namespace FrameworkDAL.Query.TestSet
{
    public static class TestSetQB
    {
        // Criteria (ApplyCriteria) is appended directly after "WHERE 1 = 1" below,
        // so this constant must NOT close the FilteredTestSet CTE.
        public const string GET_SELECTLIST_TESTSET_BASE = @"
    WITH FilteredTestSet AS (
        SELECT
            TESTSETID   AS Id,
            TESTSETNAME AS Name
        FROM MTESTSET
        WHERE 1 = 1";

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

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