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

namespace FrameworkDAL.Query.EventSource
{
    public class EventSourceQB
    {
        public const string GET_EVENTSOURCE = @"SELECT 
                                                    ES.EVENTSOURCEID       AS EventSourceId,
                                                    ES.EVENTSOURCECODE     AS EventSourceCode,
                                                    ES.EVENTSOURCENAME     AS EventSourceName,
                                                    ES.SORTORDER           AS EventSourceSortOrder,
                                                    ES.STATUS              AS EventSourceStatus,
                                                    ES.VERSION             AS EventSourceVersion,
                                                    ES.SOURCETYPE          AS EventSourceSourceType,
                                                    ES.CREATEDBYID         AS EventSourceCreatedById,
                                                    ES.CREATEDON           AS EventSourceCreatedOn,
                                                    ES.MODIFIEDBYID        AS EventSourceModifiedById,
                                                    ES.MODIFIEDON          AS EventSourceModifiedOn
                                                FROM MEVENTSOURCE ES
                                                    WHERE ES.EVENTSOURCEID = @eventsourceid;";

        public const string SAVE_EVENTSOURCE = @"INSERT INTO MEVENTSOURCE 
                                                (   
                                                    EVENTSOURCEID,
                                                    EVENTSOURCECODE,
                                                    EVENTSOURCENAME,
                                                    SORTORDER,
                                                    STATUS,
                                                    VERSION,
                                                    SOURCETYPE,
                                                    CREATEDBYID,
                                                    CREATEDON,
                                                    MODIFIEDBYID,
                                                    MODIFIEDON
                                                )
                                                VALUES 
                                                (
                                                    @EventSourceId,
                                                    @EventSourceCode,
                                                    @EventSourceName,
                                                    @EventSourceSortOrder,
                                                    @EventSourceStatus,
                                                    @EventSourceVersion,
                                                    @EventSourceSourceType,
                                                    @EventSourceCreatedById,
                                                    @EventSourceCreatedOn,
                                                    @EventSourceModifiedById,
                                                    @EventSourceModifiedOn
                                                );";

        public const string UPDATE_EVENTSOURCE = @"UPDATE MEVENTSOURCE
                                                SET
                                                    EVENTSOURCECODE     = @EventSourceCode,
                                                    EVENTSOURCENAME     = @EventSourceName,
                                                    SORTORDER           = @EventSourceSortOrder,
                                                    STATUS              = @EventSourceStatus,
                                                    VERSION             = @EventSourceVersion,
                                                    SOURCETYPE          = @EventSourceSourceType,
                                                    MODIFIEDBYID        = @EventSourceModifiedById,
                                                    MODIFIEDON          = @EventSourceModifiedOn
                                                WHERE 
                                                    EVENTSOURCEID       = @EventSourceId;";

        public const string DELETE_EVENTSOURCE = @"DELETE FROM MEVENTSOURCE
                                                   WHERE EVENTSOURCEID = @eventsourceid;";

        public const string GET_SELECTLIST_EVENTSOURCE = @"
                            WITH PagedEventSource AS (
                            SELECT 
                            ES.EVENTSOURCEID AS Id,
                            ES.EVENTSOURCECODE AS Code,
                            ES.EVENTSOURCENAME AS Name,
                            ROW_NUMBER() OVER (ORDER BY ES.EVENTSOURCEID) AS RowNum
                            FROM MEVENTSOURCE ES
                            )
                            SELECT
                            Id,
                            Code,
                            Name
                            FROM PagedEventSource
                            WHERE 
                            (@firstnumber = -1 AND @maxresult = -1)
                            OR
                            (RowNum BETWEEN @firstnumber AND @maxresult);
                            ";
    }
}