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

namespace FrameworkDAL.Query.Scheduler
{
    public static class SchedulerQB
    {
        public const string GET_SCHEDULER = @"SELECT 
    SCHEDULERID                  AS SchedulerId,
    CRONEXPRESSION               AS SchedulerCronExpression,
    SCHEDULERNAME                AS SchedulerName,
    REMARKS                      AS SchedulerRemarks,
    RIGHT(REPLICATE('0', 12) + ISNULL(SELECTEDMONTH, ''), 12) AS SchedulerSelectedMonth,
    RIGHT(REPLICATE('0', 7) + ISNULL(SELECTEDDAYS, ''), 7) AS SchedulerSelectedDays,
    DATETYPE                     AS SchedulerDateType,
    SELECTEDDATES                AS SchedulerSelectedDates,
    OCCURENCENO                  AS SchedulerOccurenceOn,
    OCCURENCEDAY                 AS SchedulerOccurenceDay,
    EVERYNOOFMONTHS              AS SchedulerEveryNoOfMonths,
    EVERYNOOFDAYS                AS SchedulerEveryNoOfDays,
    TIMERANGETYPE                AS SchedulerTimeRangeType,
    EVERYNOOFHOURS               AS SchedulerEveryNoOfHours,
    EVERYNOOFMINUTES             AS SchedulerEveryNoOfMinutes,
    OCCURSATTIME                 AS SchedulerOccursAtTime,
    OCCURSATMULTIPLETIME         AS SchedulerOccursAtMultipleTime,
    STATUS                       AS SchedulerStatus,
    VERSION                      AS SchedulerVersion,
    CREATEDBYID                  AS SchedulerCreatedById,
    CREATEDON                    AS SchedulerCreatedOn,
    MODIFIEDBYID                 AS SchedulerModifiedById,
    MODIFIEDON                   AS SchedulerModifiedOn,
    SOURCETYPE                   AS SourceType
FROM TSCHEDULER
WHERE
SCHEDULERID=@schedulerid;
";

        public const string SAVE_SCHEDULER = @"INSERT INTO TSCHEDULER
                                                (
                                                    SCHEDULERID,
                                                    CRONEXPRESSION,
                                                    SCHEDULERNAME,
                                                    REMARKS,
                                                    SELECTEDMONTH,
                                                    SELECTEDDAYS,
                                                    DATETYPE,
                                                    SELECTEDDATES,
                                                    OCCURENCENO,
                                                    OCCURENCEDAY,
                                                    EVERYNOOFMONTHS,
                                                    EVERYNOOFDAYS,
                                                    TIMERANGETYPE,
                                                    EVERYNOOFHOURS,
                                                    EVERYNOOFMINUTES,
                                                    OCCURSATTIME,
                                                    OCCURSATMULTIPLETIME,
                                                    STATUS,
                                                    VERSION,
                                                    CREATEDBYID,
                                                    CREATEDON,
                                                    MODIFIEDBYID,
                                                    MODIFIEDON,
                                                    SOURCETYPE
                                                )
                                                VALUES
                                                (
                                                    @SchedulerId,
                                                    @SchedulerCronExpression,
                                                    @SchedulerName,
                                                    @SchedulerRemarks,
                                                    @SchedulerSelectedMonth,
                                                    @SchedulerSelectedDays,
                                                    @SchedulerDateType,
                                                    @SchedulerSelectedDates,
                                                    @SchedulerOccurenceOn,
                                                    @SchedulerOccurenceDay,
                                                    @SchedulerEveryNoOfMonths,
                                                    @SchedulerEveryNoOfDays,
                                                    @SchedulerTimeRangeType,
                                                    @SchedulerEveryNoOfHours,
                                                    @SchedulerEveryNoOfMinutes,
                                                    @SchedulerOccursAtTime,
                                                    @SchedulerOccursAtMultipleTime,
                                                    @SchedulerStatus,
                                                    @SchedulerVersion,
                                                    @SchedulerCreatedById,
                                                    @SchedulerCreatedOn,
                                                    @SchedulerModifiedById,
                                                    @SchedulerModifiedOn,
                                                    @SourceType
                                                );";

        public const string UPDATE_SCHEDULER = @"UPDATE TSCHEDULER
SET
    CRONEXPRESSION = @SchedulerCronExpression,
    SCHEDULERNAME = @SchedulerName,
    REMARKS = @SchedulerRemarks,
    SELECTEDMONTH = @SchedulerSelectedMonth,
    SELECTEDDAYS = @SchedulerSelectedDays,
    DATETYPE = @SchedulerDateType,
    SELECTEDDATES = @SchedulerSelectedDates,
    OCCURENCENO = @SchedulerOccurenceOn,
    OCCURENCEDAY = @SchedulerOccurenceDay,
    EVERYNOOFMONTHS = @SchedulerEveryNoOfMonths,
    EVERYNOOFDAYS = @SchedulerEveryNoOfDays,
    TIMERANGETYPE = @SchedulerTimeRangeType,
    EVERYNOOFHOURS = @SchedulerEveryNoOfHours,
    EVERYNOOFMINUTES = @SchedulerEveryNoOfMinutes,
    OCCURSATTIME = @SchedulerOccursAtTime,
    OCCURSATMULTIPLETIME = @SchedulerOccursAtMultipleTime,
    STATUS = @SchedulerStatus,
    VERSION = @SchedulerVersion,
    MODIFIEDBYID = @SchedulerModifiedById,
    MODIFIEDON = @SchedulerModifiedOn,
    SOURCETYPE = @SourceType
WHERE SCHEDULERID = @SchedulerId;
";

        public const string DELETE_SCHEDULER = @"DELETE FROM TSCHEDULER
WHERE SCHEDULERID = @SchedulerId;
";

        public const string GET_SELECTLIST_SCHEDULER = @"SELECT 
         S.SCHEDULERID AS Id,
         S.SCHEDULERNAME AS Name
         FROM
         TSCHEDULER S;";
    }
}