namespace FrameworkDAL.Query.TestUnit
{
    public static class TestUnitQB
    {
        // Criteria (ApplyCriteria) is appended directly after "WHERE 1 = 1" below,
        // so this constant must NOT close the FilteredTestUnit CTE.
        public const string GET_SELECTLIST_TESTUNIT_BASE = @"
    WITH FilteredTestUnit AS (
        SELECT
            TESTUNITID   AS Id,
            TESTUNITCODE AS Code,
            TESTUNITNAME AS Name
        FROM MTESTUNIT
        WHERE 1 = 1";

        public const string GET_SELECTLIST_TESTUNIT_PAGING_SUFFIX = @"
    ),
    PagedTestUnit AS (
        SELECT *, ROW_NUMBER() OVER (ORDER BY Id) AS RowNum
        FROM FilteredTestUnit
    )
    SELECT
        Id,
        Code,
        Name
    FROM PagedTestUnit
    WHERE (@firstnumber = -1 AND @maxresult = -1) OR (RowNum BETWEEN @firstnumber AND @maxresult);";

        public const string GET_SELECTLIST_TESTUNIT_COUNT_BASE = @"
    SELECT COUNT(*)
    FROM MTESTUNIT
    WHERE 1 = 1";
    }
}