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

namespace AdminDAL.Query.Calendar
{
    public static class CalendarQB
    {
        public const string GET_CALENDAR = @"SELECT
                            C.CALENDARID AS CalendarId,
                            C.CALENDARCODE AS CalendarCode,
                            C.CALENDARNAME AS CalendarName,
                            C.SORTORDER AS CalendarSortOrder,
                            C.STATUS AS CalendarStatus,
                            C.VERSION AS CalendarVersion,
                            C.CREATEDBYID AS CalendarCreatedById,
                            C.CREATEDON AS CalendarCreatedOn,
                            C.MODIFIEDBYID AS CalendarModifiedById,
                            C.MODIFIEDON AS CalendarModifiedOn,
                            C.SOURCETYPE AS CalendarSourceType,
                            C.TENANTID AS CalendarTenantId,

                            CD.CALENDARDETAILID AS CalendarDetailId,
                            C.CALENDARCODE AS CalendarCode,
                            C.CALENDARNAME AS CalendarName,
                            CD.CALENDARID AS CalendarId,
                            CD.SLNO AS CalendarDetailSlNo,
                            CD.DETAILDATE AS CalendarDetailDate,
                            CD.DETAILDAY AS CalendarDetailDay,
                            CD.DETAILTYPE AS CalendarDetailType,
                            CD.PARTICULARS AS CalendarDetailParticulars
                            FROM MCALENDAR C
                            LEFT JOIN MCALENDARDETAIL CD ON C.CALENDARID = CD.CALENDARID
                            WHERE C.CALENDARID = @calendarid;
                            ";

        public const string SAVE_CALENDAR = @"INSERT 
                            INTO MCALENDAR (
                                 CALENDARID,
                                 CALENDARCODE,
                                 CALENDARNAME,
                                 SORTORDER,
                                 STATUS,
                                 VERSION,
                                 CREATEDBYID,
                                 CREATEDON,
                                 MODIFIEDBYID,
                                 MODIFIEDON,
                                 SOURCETYPE,
                                 TENANTID
                            ) OUTPUT INSERTED.CalendarId VALUES (
                                 @CalendarId,
                                 @CalendarCode,
                                 @CalendarName,
                                 @CalendarSortOrder,
                                 @CalendarStatus,
                                 @CalendarVersion,
                                 @CalendarCreatedById,
                                 @CalendarCreatedOn,
                                 @CalendarModifiedById,
                                 @CalendarModifiedOn,
                                 @CalendarSourceType,
                                 @CalendarTenantId
                            );
                            ";

        public const string SAVE_CALENDARDETAIL = @"INSERT 
                            INTO MCALENDARDETAIL (
                                 CALENDARDETAILID,
                                 CALENDARID,
                                 SLNO,
                                 DETAILDATE,
                                 DETAILDAY,
                                 DETAILTYPE,
                                 PARTICULARS
                            ) OUTPUT INSERTED.CalendarDetailId VALUES (
                                 @CalendarDetailId,
                                 @CalendarId,
                                 @CalendarDetailSlNo,
                                 @CalendarDetailDate,
                                 @CalendarDetailDay,
                                 @CalendarDetailType,
                                 @CalendarDetailParticulars 
                            );
                            ";

        public const string UPDATE_CALENDAR = @"UPDATE 
                            MCALENDAR SET
                            CALENDARCODE = @CalendarCode,
                            CALENDARNAME = @CalendarName,
                            SORTORDER = @CalendarSortOrder,
                            STATUS = @CalendarStatus,
                            VERSION = @CalendarVersion,
                            MODIFIEDBYID = @CalendarModifiedById,
                            MODIFIEDON = @CalendarModifiedOn,
                            SOURCETYPE = @CalendarSourceType,
                            TENANTID = @CalendarTenantId
                            WHERE CalendarId = @CalendarId;
                            ";

        public const string UPDATE_CALENDARDETAIL = @"UPDATE 
                            MCALENDARDETAIL SET
                            CALENDARID = @CalendarId,
                            SLNO = @CalendarDetailSlNo,
                            DETAILDATE = @CalendarDetailDate,
                            DETAILDAY = @CalendarDetailDay,
                            DETAILTYPE = @CalendarDetailType,
                            PARTICULARS = @CalendarDetailParticulars
                            WHERE CalendarDetailId = @CalendarDetailId AND CalendarId = @CalendarId;
                            ";

        public const string DELETE_CALENDAR = @"DELETE 
                            FROM MCALENDAR
                            WHERE CALENDARID = @calendarid;";

        public const string DELETE_CALENDARDETAIL = @"DELETE 
                            FROM MCALENDARDETAIL
                            WHERE CALENDARID = @calendarid;";

        public const string GET_MAX_CALENDARDETAILID = @"SELECT
                            ISNULL(MIN(CALENDARDETAILID), 0)
                            FROM MCALENDARDETAIL
                            WHERE CALENDARID = @calendarid;";

        public const string GET_SELECTLIST_CALENDAR = @"SELECT
                            CALENDARID AS Id,
                            CALENDARCODE AS Code,
                            CALENDARNAME AS Name
                            FROM MCALENDAR
                            ";
    }
}