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

namespace DevadminDAL.Query.Client
{
    public static class ClientSiteQB
    {
        public const string GET_SELECTLIST_CLIENTSITE_SQL = @"
                                                    WITH ClientSite AS (
                                                        SELECT
                                                            cs.CLIENTSITEID        AS ClientSiteId,
                                                            cs.CLIENTSITECODE      AS ClientSiteCode,
                                                            cs.CLIENTSITENAME      AS ClientSiteName,
                                                            cs.CLIENTSITESHORTNAME AS ClientSiteShortName,
                                                            ROW_NUMBER() OVER (ORDER BY cs.CLIENTSITEID) AS RowNum
                                                        FROM MCLIENTSITE cs
                                                        WHERE cs.STATUS = 1
                                                          AND (@clientid IS NULL OR cs.CLIENTID = @clientid)
                                                          AND (@clientsitename IS NULL OR cs.CLIENTSITENAME LIKE '%' + @clientsitename + '%')
                                                    )
                                                    SELECT
                                                        ClientSiteId,
                                                        ClientSiteCode,
                                                        ClientSiteName,
                                                        ClientSiteShortName
                                                    FROM ClientSite
                                                    WHERE
                                                          (@firstnumber = -1 AND @maxresult = -1)
                                                       OR (RowNum BETWEEN @firstnumber AND @maxresult);
                                                    ";

        public const string GET_SELECTLIST_CLIENTSITE_PG = @"
                                                    WITH ClientSite AS (
                                                        SELECT
                                                            cs.CLIENTSITEID        AS ""ClientSiteId"",
                                                            cs.CLIENTSITECODE      AS ""ClientSiteCode"",
                                                            cs.CLIENTSITENAME      AS ""ClientSiteName"",
                                                            cs.CLIENTSITESHORTNAME AS ""ClientSiteShortName"",
                                                            ROW_NUMBER() OVER (ORDER BY cs.CLIENTSITEID) AS ""RowNum""
                                                        FROM MCLIENTSITE cs
                                                        WHERE cs.STATUS = 1
                                                          AND (:clientid IS NULL OR cs.CLIENTID = :clientid)
                                                          AND (:clientsitename IS NULL OR cs.CLIENTSITENAME ILIKE '%' || :clientsitename || '%')
                                                    )
                                                    SELECT
                                                        ""ClientSiteId"",
                                                        ""ClientSiteCode"",
                                                        ""ClientSiteName"",
                                                        ""ClientSiteShortName""
                                                    FROM ClientSite
                                                    WHERE
                                                          (:firstnumber = -1 AND :maxresult = -1)
                                                       OR (""RowNum"" BETWEEN :firstnumber AND :maxresult);
                                                    ";

        public const string GET_SELECTLIST_CLIENTSITE_ORACLE = @";";
        public const string GET_SELECTLIST_CLIENTSITE_MYSQL = @";";
    }
}