namespace TMSDAL.Query.Reports
{
    // Shared SQL for the TMS Reports-family access-control check -- mirrors
    // AccountsDAL.Query.AccountReports.AccountReportsQB.GET_REPORT_ACCESS_LIMITS exactly (MROLEVSMENU
    // is a generic framework table, not owned by any one module).
    public static class TmsReportsQB
    {
        public const string GET_REPORT_ACCESS_LIMITS = @"
            SELECT
                MAXDAYSNORMAL   AS MaxDaysNormal,
                DAYSLIMIT       AS DaysLimit,
                MAXRECORDSNORMAL AS MaxRecordsNormal,
                RECORDSLIMIT    AS RecordsLimit
            FROM MROLEVSMENU
            WHERE ROLEID = @RoleId AND MENUID = @MenuId;";
    }
}