namespace CMSDAL.Query.SiteTemplate;
public static class SiteTemplateQB
{
    public const string GET_LIST = @"
        SELECT
            st.SITETEMPLATEID          AS SiteTemplateId,
            st.SITETEMPLATECODE        AS SiteTemplateCode,
            st.SITETEMPLATENAME        AS SiteTemplateName,
            st.SITETEMPLATEDESCRIPTION AS SiteTemplateDescription,
            st.DEFAULTDESIGNSYSTEMID   AS DefaultDesignSystemId,
            st.STATUS                  AS Status,
            st.TENANTID                AS TenantId
        FROM DBO.MCMSSITETEMPLATE st
        WHERE st.STATUS = 1 AND (st.TENANTID = @TenantId OR st.TENANTID = -1)
        ORDER BY st.SITETEMPLATENAME";

    // Own tenant OR system-wide (-1) — same resolution convention as DesignSystemQB.GET_BY_ID /
    // DataSourceQB.GET_BY_CODE.
    public const string GET_BY_CODE = @"
        SELECT
            st.SITETEMPLATEID          AS SiteTemplateId,
            st.SITETEMPLATECODE        AS SiteTemplateCode,
            st.SITETEMPLATENAME        AS SiteTemplateName,
            st.SITETEMPLATEDESCRIPTION AS SiteTemplateDescription,
            st.DEFAULTDESIGNSYSTEMID   AS DefaultDesignSystemId,
            st.STATUS                  AS Status,
            st.TENANTID                AS TenantId
        FROM DBO.MCMSSITETEMPLATE st
        WHERE st.SITETEMPLATECODE = @SiteTemplateCode AND (st.TENANTID = @TenantId OR st.TENANTID = -1)
          AND st.STATUS = 1";
}