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

namespace FrameworkDAL.Query.EventClass
{
    public static class EventClassQB
    {
        public const string GET_EVENTCLASS = @"SELECT
                            EVENTCLASSID AS EventClassId,
                            EVENTCLASSCODE AS EventClassCode,
                            EVENTCLASSNAME AS EventClassName,
                            COLOR AS EventClassColor,
                            WEIGHT AS EventClassWeight,
                            EVENTTEXT AS EventClassText,
                            TAG AS EventClassTag,
                            SOURCE AS EventClassSource,
                            LINK AS EventClassLink,
                            SORTORDER AS EventClassSortOrder,
                            STATUS AS EventClassStatus,
                            VERSION AS EventClassVersion,
                            SOURCETYPE AS EventClassSourceType,
                            CREATEDBYID AS EventClassCreatedById,
                            CREATEDON AS EventClassCreatedOn,
                            MODIFIEDBYID AS EventClassModifiedById,
                            MODIFIEDON AS EventClassModifiedOn
                            FROM MEVENTCLASS EC
                            WHERE EC.EVENTCLASSID = @eventclassid;
                            ";

        public const string SAVE_EVENTCLASS = @"INSERT 
                            INTO MEVENTCLASS (
                                 EVENTCLASSID,
                                 EVENTCLASSCODE,
                                 EVENTCLASSNAME,
                                 COLOR,
                                 WEIGHT,
                                 EVENTTEXT,
                                 TAG,
                                 SOURCE,
                                 LINK,
                                 SORTORDER,
                                 STATUS,
                                 VERSION,
                                 CREATEDBYID,
                                 CREATEDON,
                                 MODIFIEDBYID,
                                 MODIFIEDON
                            ) VALUES (
                                 @EventClassId,
                                 @EventClassCode,
                                 @EventClassName,
                                 @EventClassColor,
                                 @EventClassWeight,
                                 @EventClassText,
                                 @EventClassTag,
                                 @EventClassSource,
                                 @EventClassLink,
                                 @EventClassSortOrder,
                                 @EventClassStatus,
                                 @EventClassVersion,
                                 @EventClassCreatedById,
                                 @EventClassCreatedOn,
                                 @EventClassModifiedById,
                                 @EventClassModifiedOn  
                            );
                            ";

        public const string UPDATE_EVENTCLASS = @"UPDATE 
                            MEVENTCLASS SET
                            EVENTCLASSCODE = @EventClassCode,
                            EVENTCLASSNAME = @EventClassName,
                            COLOR = @EventClassColor,
                            WEIGHT = @EventClassWeight,
                            EVENTTEXT = @EventClassText,
                            TAG = @EventClassTag,
                            SOURCE = @EventClassSource,
                            LINK = @EventClassLink,
                            SORTORDER = @EventClassSortOrder,
                            STATUS = @EventClassStatus,
                            VERSION = @EventClassVersion,
                            MODIFIEDBYID = @EventClassModifiedById,
                            MODIFIEDON = @EventClassModifiedOn
                            WHERE EVENTCLASSID = @EventClassId;
                            ";

        public const string DELETE_EVENTCLASS = @"DELETE 
                            FROM MEVENTCLASS
                            WHERE EVENTCLASSID = @eventclassid;
                            ";

        public const string GET_SELECTLIST_EVENTCLASS = @"
                            WITH PagedEventClass AS (
                            SELECT 
                            EC.EVENTCLASSID AS Id,
                            EC.EVENTCLASSCODE AS Code,
                            EC.EVENTCLASSNAME AS Name,
                            ROW_NUMBER() OVER (ORDER BY EC.EVENTCLASSID) AS RowNum
                            FROM MEVENTCLASS EC
                            )
                            SELECT
                            Id,
                            Code,
                            Name
                            FROM PagedEventClass
                            WHERE  
                            (@firstnumber = -1 AND @maxresult = -1)
                            OR
                            (RowNum BETWEEN @firstnumber AND @maxresult);
                            ";
    }
}