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

namespace MarketingDAL.Query.LeadCycle
{
    public static class LeadCycleQB
    {
        public const string GET_SELECTLIST_LEADCYCLE_SQL = @"
                                                    WITH LeadCycle AS (
                                                        SELECT
                                                            lc.LEADCYCLEID   AS Id,
                                                            lc.LEADCYCLECODE AS Code,
                                                            lc.LEADCYCLENAME AS Name,
                                                            ROW_NUMBER() OVER (ORDER BY lc.LEADCYCLEID) AS RowNum
                                                        FROM MLEADCYCLE lc
                                                        WHERE 1 = 1
                                                    )
                                                    SELECT
                                                        Id,
                                                        Code,
                                                        Name
                                                    FROM LeadCycle
                                                    WHERE
                                                          (@firstnumber = -1 AND @maxresult = -1)
                                                       OR (RowNum BETWEEN @firstnumber AND @maxresult);
                                                    ";

        public const string GET_SELECTLIST_LEADCYCLE_PG = @"
                                                    WITH LeadCycle AS (
                                                        SELECT
                                                            lc.LEADCYCLEID   AS ""Id"",
                                                            lc.LEADCYCLECODE AS ""Code"",
                                                            lc.LEADCYCLENAME AS ""Name"",
                                                            ROW_NUMBER() OVER (ORDER BY lc.LEADCYCLEID) AS ""RowNum""
                                                        FROM MLEADCYCLE lc
                                                        WHERE 1 = 1
                                                    )
                                                    SELECT
                                                        ""Id"",
                                                        ""Code"",
                                                        ""Name""
                                                    FROM LeadCycle
                                                    WHERE
                                                          (:firstnumber = -1 AND :maxresult = -1)
                                                       OR (""RowNum"" BETWEEN :firstnumber AND :maxresult);
                                                    ";

        public const string GET_SELECTLIST_LEADCYCLE_ORACLE = @";";
        public const string GET_SELECTLIST_LEADCYCLE_MYSQL = @";";

        public const string GET_SELECTLIST_LEADCYCLEDETAIL_SQL = @"
                                                    SELECT
                                                        LEADCYCLEDETAILID AS Id,
                                                        STAGECODE         AS StageCode,
                                                        STAGENAME         AS StageName,
                                                        ISOPEN            AS IsOpen,
                                                        PRESTAGESLNO      AS PreStageSlNo
                                                    FROM MLEADCYCLEDETAIL
                                                    WHERE 1 = 1
                                                    ORDER BY LEADCYCLEDETAILID;
                                                    ";

        public const string GET_SELECTLIST_LEADCYCLEDETAIL_PG = @"
                                                    SELECT
                                                        LEADCYCLEDETAILID AS ""Id"",
                                                        STAGECODE         AS ""StageCode"",
                                                        STAGENAME         AS ""StageName"",
                                                        ISOPEN            AS ""IsOpen"",
                                                        PRESTAGESLNO      AS ""PreStageSlNo""
                                                    FROM MLEADCYCLEDETAIL
                                                    WHERE 1 = 1
                                                    ORDER BY LEADCYCLEDETAILID;
                                                    ";

        public const string GET_SELECTLIST_LEADCYCLEDETAIL_ORACLE = @";";
        public const string GET_SELECTLIST_LEADCYCLEDETAIL_MYSQL = @";";
    }
}