namespace FrameworkDAL.Query.EIPConversation.EIPMessageTemplate
{
    public static class EIPMessageTemplateQB
    {
        // Highest TEMPLATEVERSION wins; tenant-specific row wins over -1=global, same
        // override convention used elsewhere in this module (MEIPCAPABILITY risk config,
        // MEIPFLOWDEFINITION tenant override).
        public const string GET_TEMPLATE_CONTENT = @"
            SELECT TOP 1 TEMPLATECONTENT
            FROM   MEIPMESSAGETEMPLATE
            WHERE  MESSAGEKEY   = @MessageKey
              AND  LANGUAGECODE = @LanguageCode
              AND  CHANNELTYPE  = @ChannelType
              AND  (TENANTID = @TenantId OR TENANTID = -1)
              AND  ISACTIVE = 1
            ORDER BY CASE WHEN TENANTID = @TenantId THEN 0 ELSE 1 END, TEMPLATEVERSION DESC;";
    }
}