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

namespace PayRollDAL.Query.ManPower
{
    public static class ManPowerQB
    {
        // ── Picklist (paged, dual-dialect) ──────────────────────────────────
        // Indexes recommended:
        //   MMANPOWER: IX_MMANPOWER_OUID (OUID)

        public const string GET_SELECTLIST_MANPOWER_SQL = @"
WITH Paged AS (
    SELECT A.MANPOWERID AS Id,
           A.VERSIONNO   AS VersionNo,
           ROW_NUMBER() OVER (ORDER BY A.MANPOWERID DESC) AS RowNum
    FROM   MMANPOWER A
    WHERE  1 = 1 /*FILTER*/
)
SELECT Id, VersionNo
FROM   Paged
WHERE  (@firstnumber = -1 AND @maxresult = -1)
   OR  (RowNum BETWEEN @firstnumber AND @maxresult);";

        public const string GET_SELECTLIST_MANPOWER_PG = @"
WITH Paged AS (
    SELECT A.MANPOWERID AS ""Id"",
           A.VERSIONNO   AS ""VersionNo"",
           ROW_NUMBER() OVER (ORDER BY A.MANPOWERID DESC) AS ""RowNum""
    FROM   MMANPOWER A
    WHERE  1 = 1 /*FILTER*/
)
SELECT ""Id"", ""VersionNo""
FROM   Paged
WHERE  (:firstnumber = -1 AND :maxresult = -1)
   OR  (""RowNum"" BETWEEN :firstnumber AND :maxresult);";

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

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