namespace MarketingDAL.Query.Lead
{
    public static class ContactPicklistQB
    {
        public const string GET_CONTACTPICKLISTREPORT_SQL = @"
            WITH ContactPicklistReport AS (
                SELECT
                    a.CONTACTID   AS Id,
                    a.NAME        AS Name,
                    a.FIRSTNAME   AS FirstName,
                    a.MOBILENO    AS MobileNumber,
                    a.MAILID      AS Mail,
                    ROW_NUMBER() OVER (ORDER BY a.CONTACTID) AS RowNum
                FROM MCONTACT a
                WHERE 1 = 1
            )
            SELECT
                Id,
                Name,
                FirstName,
                MobileNumber,
                Mail
            FROM ContactPicklistReport
            WHERE
                  (@firstnumber = -1 AND @maxresult = -1)
               OR (RowNum BETWEEN @firstnumber AND @maxresult);
            ";

        public const string GET_CONTACTPICKLISTREPORT_PG = @"
            WITH ""ContactPicklistReport"" AS (
                SELECT
                    a.CONTACTID   AS ""Id"",
                    a.NAME        AS ""Name"",
                    a.FIRSTNAME   AS ""FirstName"",
                    a.MOBILENO    AS ""MobileNumber"",
                    a.MAILID      AS ""Mail"",
                    ROW_NUMBER() OVER (ORDER BY a.CONTACTID) AS ""RowNum""
                FROM MCONTACT a
                WHERE 1 = 1
            )
            SELECT
                ""Id"",
                ""Name"",
                ""FirstName"",
                ""MobileNumber"",
                ""Mail""
            FROM ""ContactPicklistReport""
            WHERE
                  (:firstnumber = -1 AND :maxresult = -1)
               OR (""RowNum"" BETWEEN :firstnumber AND :maxresult);
            ";

        public const string GET_CONTACTPICKLISTREPORT_ORACLE = @";";
        public const string GET_CONTACTPICKLISTREPORT_MYSQL = @";";
    }
}