namespace FrameworkDAL.Query.Taxonomy
{
    /// <summary>
    /// Required indexes:
    ///   IX_TTOPICLINK_ENTITYTYPE_ENTITYID on (ENTITYTYPE, ENTITYID)
    ///   IX_TTOPICLINK_TOPICID on (TOPICID)
    /// See FrameworkDAL.DTO.Taxonomy.TaxonomyEntityTypeConstant for EntityType values.
    /// </summary>
    public static class TopicLinkQB
    {
        public const string GET_TOPICLINKS_BY_ENTITY = @"
SELECT  l.TOPICLINKID           AS TopicLinkId,
        l.TOPICID                AS TopicId,
        l.ENTITYTYPE              AS EntityType,
        l.ENTITYID                AS EntityId,
        l.ISPRIMARY                AS IsPrimary,
        l.RELEVANCEPCT              AS RelevancePct,
        l.TENANTID                  AS TenantId,
        l.CREATEDBYID                AS CreatedById,
        l.CREATEDON                  AS CreatedOn
FROM    DBO.TTOPICLINK l
WHERE   l.ENTITYTYPE = @EntityType
AND     l.ENTITYID   = @EntityId
AND    (l.TENANTID = @TenantId OR l.TENANTID = -1)";


        public const string GET_TOPICLINKS_BY_TOPIC = @"
SELECT  l.TOPICLINKID           AS TopicLinkId,
        l.TOPICID                AS TopicId,
        l.ENTITYTYPE              AS EntityType,
        l.ENTITYID                AS EntityId,
        l.ISPRIMARY                AS IsPrimary,
        l.RELEVANCEPCT              AS RelevancePct,
        l.TENANTID                  AS TenantId,
        l.CREATEDBYID                AS CreatedById,
        l.CREATEDON                  AS CreatedOn
FROM    DBO.TTOPICLINK l
WHERE   l.TOPICID = @TopicId
AND    (l.TENANTID = @TenantId OR l.TENANTID = -1)";


        public const string SAVE_TOPICLINK = @"
INSERT INTO DBO.TTOPICLINK
(
    TOPICLINKID, TOPICID, ENTITYTYPE, ENTITYID, ISPRIMARY, RELEVANCEPCT, TENANTID,
    CREATEDBYID, CREATEDON
)
VALUES
(
    @TopicLinkId, @TopicId, @EntityType, @EntityId, @IsPrimary, @RelevancePct, @TenantId,
    @CreatedById, @CreatedOn
)";


        public const string DELETE_TOPICLINK = @"
DELETE FROM DBO.TTOPICLINK
WHERE   TOPICLINKID = @TopicLinkId
AND     TENANTID    = @TenantId";
    }
}