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

namespace DevadminDAL.Query.Client
{
    public static class ClientQB
    {
        public const string GET_SELECTLIST_CLIENT_SQL = @"
                                                    WITH Client AS (
                                                        SELECT
                                                            c.CLIENTID   AS ClientId,
                                                            c.CLIENTCODE AS ClientCode,
                                                            c.CLIENTNAME AS ClientName,
                                                            ROW_NUMBER() OVER (ORDER BY c.CLIENTID) AS RowNum
                                                        FROM MCLIENT c
                                                        WHERE c.STATUS = 1
                                                          AND (@clientname IS NULL OR c.CLIENTNAME LIKE '%' + @clientname + '%')
                                                    )
                                                    SELECT
                                                        ClientId,
                                                        ClientCode,
                                                        ClientName
                                                    FROM Client
                                                    WHERE
                                                          (@firstnumber = -1 AND @maxresult = -1)
                                                       OR (RowNum BETWEEN @firstnumber AND @maxresult);
                                                    ";

        public const string GET_SELECTLIST_CLIENT_PG = @"
                                                    WITH Client AS (
                                                        SELECT
                                                            c.CLIENTID   AS ""ClientId"",
                                                            c.CLIENTCODE AS ""ClientCode"",
                                                            c.CLIENTNAME AS ""ClientName"",
                                                            ROW_NUMBER() OVER (ORDER BY c.CLIENTID) AS ""RowNum""
                                                        FROM MCLIENT c
                                                        WHERE c.STATUS = 1
                                                          AND (:clientname IS NULL OR c.CLIENTNAME ILIKE '%' || :clientname || '%')
                                                    )
                                                    SELECT
                                                        ""ClientId"",
                                                        ""ClientCode"",
                                                        ""ClientName""
                                                    FROM Client
                                                    WHERE
                                                          (:firstnumber = -1 AND :maxresult = -1)
                                                       OR (""RowNum"" BETWEEN :firstnumber AND :maxresult);
                                                    ";

        public const string GET_SELECTLIST_CLIENT_ORACLE = @";";
        public const string GET_SELECTLIST_CLIENT_MYSQL = @";";
    }
}