namespace FrameworkDAL.Query.TestData
{
    public static class TestDataQB
    {
        // Criteria (ApplyCriteria) is appended directly after "WHERE 1 = 1" below,
        // so this constant must NOT close the FilteredTestData CTE.
        public const string GET_SELECTLIST_TESTDATA_BASE = @"
    WITH FilteredTestData AS (
        SELECT
            TESTDATAID   AS Id,
            TESTDATANAME AS Name
        FROM MTESTDATA
        WHERE 1 = 1";

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

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