using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace PayRollDAL.Query.PayTaxTypeDetailSetting
{
    public static class PayTaxTypeDetailSettingQB
    {
        // Criteria (ApplyCriteria) is appended directly after "WHERE 1 = 1" below,
        // so this constant must NOT close the FilteredPayTaxTypeDetailSetting CTE.
        public const string GET_SELECTLIST_PAYTAXTYPEDETAILSETTING_BASE = @"
    WITH FilteredPayTaxTypeDetailSetting AS (
        SELECT
            a.PAYTAXTYPEDETAILSETTINGID    AS PayTaxTypeDetailSettingId,
            a.TYPE                         AS PayTaxTypeDetailSettingType,
            a.FIELDTYPE                    AS PayTaxTypeDetailSettingFieldType,
            a.FIELDCODE                    AS PayTaxTypeDetailSettingFieldCode,
            a.POSTTYPE                     AS PayTaxTypeDetailSettingPostType,
            a.ISSAMEPERIOD                 AS PayTaxTypeDetailSettingIssamePeriod,
            a.ISREADONLY                   AS PayTaxTypeDetailSettingIsReadOnly,
            b.PAYTAXTYPEDETAILID           AS PayTaxTypeDetailId,
            b.FIELDNAME                    AS PayTaxTypeDetailFieldName,
            b.DISPLAYNAME                  AS PayTaxTypeDetailDisplayName
        FROM MPAYTAXTYPEDETAILSETTING a
        INNER JOIN MPAYTAXTYPEDETAIL b ON a.PAYTAXTYPEDETAILID = b.PAYTAXTYPEDETAILID
        WHERE 1 = 1";

        public const string GET_SELECTLIST_PAYTAXTYPEDETAILSETTING_PAGING_SUFFIX = @"
    ),
    PagedPayTaxTypeDetailSetting AS (
        SELECT *, ROW_NUMBER() OVER (ORDER BY PayTaxTypeDetailSettingId) AS RowNum
        FROM FilteredPayTaxTypeDetailSetting
    )
    SELECT
        PayTaxTypeDetailSettingId,
        PayTaxTypeDetailSettingType,
        PayTaxTypeDetailSettingFieldType,
        PayTaxTypeDetailSettingFieldCode,
        PayTaxTypeDetailSettingPostType,
        PayTaxTypeDetailSettingIssamePeriod,
        PayTaxTypeDetailSettingIsReadOnly,
        PayTaxTypeDetailId,
        PayTaxTypeDetailFieldName,
        PayTaxTypeDetailDisplayName
    FROM PagedPayTaxTypeDetailSetting
    WHERE (@firstnumber = -1 AND @maxresult = -1) OR (RowNum BETWEEN @firstnumber AND @maxresult);";
    }
}