namespace FrameworkDAL.Query.TestCase
{
    public static class TestCaseQB
    {
        // Criteria (ApplyCriteria) is appended directly after "WHERE 1 = 1" below,
        // so this constant must NOT close the FilteredTestCase CTE.
        public const string GET_SELECTLIST_TESTCASE_BASE = @"
    WITH FilteredTestCase AS (
        SELECT
            TESTCASEID   AS Id,
            TESTCASENAME AS Name
        FROM MTESTCASE
        WHERE 1 = 1";

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

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