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

namespace MarketingDAL.Query.LeadCategory
{
    public static class LeadCategoryQB
    {
        public const string GET_SELECTLIST_LEADCATEGORY_SQL = @"
                                                    WITH LeadCategory AS (
                                                        SELECT
                                                            a.LEADCATEGORYID   AS Id,
                                                            a.LEADCATEGORYCODE AS Code,
                                                            a.LEADCATEGORYNAME AS Name,
                                                            a.LEADCYCLEID      AS LeadCycleId,
                                                            a.APPLICABLETYPE   AS ApplicableType,
                                                            ROW_NUMBER() OVER (ORDER BY a.LEADCATEGORYID) AS RowNum
                                                        FROM MLEADCATEGORY a
                                                        WHERE a.LEADCATEGORYID <> -1
                                                    )
                                                    SELECT
                                                        Id,
                                                        Code,
                                                        Name,
                                                        LeadCycleId,
                                                        ApplicableType
                                                    FROM LeadCategory
                                                    WHERE
                                                          (@firstnumber = -1 AND @maxresult = -1)
                                                       OR (RowNum BETWEEN @firstnumber AND @maxresult);
                                                    ";

        public const string GET_SELECTLIST_LEADCATEGORY_PG = @"
                                                    WITH LeadCategory AS (
                                                        SELECT
                                                            a.LEADCATEGORYID   AS ""Id"",
                                                            a.LEADCATEGORYCODE AS ""Code"",
                                                            a.LEADCATEGORYNAME AS ""Name"",
                                                            a.LEADCYCLEID      AS ""LeadCycleId"",
                                                            a.APPLICABLETYPE   AS ""ApplicableType"",
                                                            ROW_NUMBER() OVER (ORDER BY a.LEADCATEGORYID) AS ""RowNum""
                                                        FROM MLEADCATEGORY a
                                                        WHERE a.LEADCATEGORYID <> -1
                                                    )
                                                    SELECT
                                                        ""Id"",
                                                        ""Code"",
                                                        ""Name"",
                                                        ""LeadCycleId"",
                                                        ""ApplicableType""
                                                    FROM LeadCategory
                                                    WHERE
                                                          (:firstnumber = -1 AND :maxresult = -1)
                                                       OR (""RowNum"" BETWEEN :firstnumber AND :maxresult);
                                                    ";

        public const string GET_SELECTLIST_LEADCATEGORY_ORACLE = @";";
        public const string GET_SELECTLIST_LEADCATEGORY_MYSQL = @";";
    }
}