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

namespace PayRollDAL.Query.KRA
{
    public static class KRAQB
    {
        // ── Picklist (paged, dual-dialect) ──────────────────────────────────
        // Indexes recommended:
        //   MKRA: IX_MKRA_NAME (KRANAME)

        public const string GET_SELECTLIST_KRA_SQL = @"
WITH Paged AS (
    SELECT A.KRAID        AS Id,
           A.KRANAME       AS Name,
           A.DESCRIPTION   AS Description,
           ROW_NUMBER() OVER (ORDER BY A.KRANAME) AS RowNum
    FROM   MKRA A
    WHERE  1 = 1 /*FILTER*/
)
SELECT Id, Name, Description
FROM   Paged
WHERE  (@firstnumber = -1 AND @maxresult = -1)
   OR  (RowNum BETWEEN @firstnumber AND @maxresult);";

        public const string GET_SELECTLIST_KRA_PG = @"
WITH Paged AS (
    SELECT A.KRAID        AS ""Id"",
           A.KRANAME       AS ""Name"",
           A.DESCRIPTION   AS ""Description"",
           ROW_NUMBER() OVER (ORDER BY A.KRANAME) AS ""RowNum""
    FROM   MKRA A
    WHERE  1 = 1 /*FILTER*/
)
SELECT ""Id"", ""Name"", ""Description""
FROM   Paged
WHERE  (:firstnumber = -1 AND :maxresult = -1)
   OR  (""RowNum"" BETWEEN :firstnumber AND :maxresult);";

        public const string GET_SELECTLIST_KRA_COUNT_SQL = @"
SELECT COUNT(*)
FROM   MKRA A
WHERE  1 = 1 /*FILTER*/;";

        public const string GET_SELECTLIST_KRA_COUNT_PG = @"
SELECT COUNT(*)
FROM   MKRA A
WHERE  1 = 1 /*FILTER*/;";
    }
}