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

namespace FrameworkDAL.Query.Mail
{
    public class MailQB
    {
        public const string GET_SELECTLIST_MAIL = @"WITH PagedMail AS 
                                                    (
                                                        SELECT
                                                            M.MAILID        AS Id,
                                                            M.SMTPPORT  AS SmtpPort,
                                                            M.POP3PORT  AS Pop3Port,
                                                            M.PARENTMAILID   AS MailId,
                                                            M.MAILDESCRIPTION AS Description,
                                                            ROW_NUMBER() OVER (ORDER BY M.MAILID) AS RowNum
                                                        FROM MMAIL M
                                                        WHERE M.STATUS = 1
                                                    )
                                                    SELECT
                                                        Id,
                                                        SmtpPort,
                                                        Pop3Port,
                                                        MailId,
                                                        Description
                                                    FROM PagedMail
                                                    WHERE RowNum BETWEEN (@firstnumber + 1) AND (@firstnumber + @maxresult)
                                                    ORDER BY RowNum;";

        public const string DELETE_MAIL = @"DELETE FROM MMAIL
                                            WHERE MAILID = @mailid";
    }
}