﻿--------------------------------------- Ali 2024-07-22 ------------
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1425,NULL,NULL,N'UndeclaredPosition',N'CandidatesUndeclaredPosition',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1714,1425,5129,NULL)
GO
--------------------------------------- End 2024-07-22 ------------
--------------------------------------- mahmoud 2024-07-24 --------------------------
INSERT [dbo].[SecurityPrivilegeActions]
([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES (1995, N'WorkFlow', N'OverTimeSymphonyRequestApi', N'Index', 0, N'get', 3240)
Go

INSERT [dbo].[SecurityPrivilegeActions]
([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES (1996, N'WorkFlow', N'OverTimeSymphonyRequestApi', N'OverTimeRequest_Read', 0, N'post', 3294)
Go

INSERT [dbo].[SecurityPrivilegeActions]
([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES (1997, N'WorkFlow', N'OverTimeSymphonyRequestApi', N'Save', 1, N'get', 3295)
Go

INSERT [dbo].[SecurityPrivilegeActions]
([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES (1998, N'WorkFlow', N'OverTimeSymphonyRequestApi', N'Save', 2, N'get', 3296)
Go

INSERT [dbo].[SecurityPrivilegeActions]
([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES (1999, N'WorkFlow', N'OverTimeSymphonyRequestApi', N'Delete', 0, N'post', 3297)
Go

INSERT [dbo].[SecurityPrivilegeActions]
([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES (2000, N'WorkFlow', N'OverTimeSymphonyRequestApi', N'Save', 0, N'post', 3299)
Go
INSERT [dbo].[SecurityPrivilegeActions]
([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES (2001, N'WorkFlow', N'OverTimeSymphonyRequestApi', N'Add', 1, N'Get', 3295)
Go
INSERT [dbo].[SecurityPrivilegeActions]
([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES (2002, N'WorkFlow', N'OverTimeSymphonyRequestApi', N'Add', 0, N'post', 3299)
Go

INSERT [dbo].[SecurityPrivilegeActions]
([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES (2003, N'WorkFlow', N'OverTimeSymphonyRequestApi', N'Cancel', 0, N'post', 3298)
Go

INSERT [dbo].[SecurityPrivilegeEndPoints]
([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) 
VALUES(1426,NULL, NULL,N'OverTimeSymphonyRequest',N'SearchOverTimeSymphonyRequest',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] 
([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) 
VALUES(1427,NULL, NULL,N'OverTimeSymphonyRequest',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] 
([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1428,NULL, NULL,N'OverTimeSymphonyRequest',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints]
([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1429,NULL, NULL,N'OverTimeSymphonyRequest',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints]
([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1430,NULL, NULL,N'OverTimeSymphonyRequest',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints]
([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1431,NULL, NULL,N'OverTimeSymphonyRequest',N'GetForSave',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints]
([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1432,NULL, NULL,N'OverTimeSymphonyRequest',N'GetForAdd',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints]
([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1433,NULL, NULL,N'OverTimeSymphonyRequest',N'CancelRequest',N'Get')
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) 
VALUES(1715,1426,3294, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails]
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1716,1427,3296, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1717,1428,3299, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails]([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1718,1429,3297, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails]([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1719,1430,3294, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails]([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1720,1431,3295, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails]([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1721,1431,3296, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails]([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1722,1432,3295, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails]([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1723,1433,3298, NULL)
Go

--------------------------------------End 2024-07-24  -------------------------------
--------------------------------------Ali 2024-07-28  -------------------------------

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId],[ConfigDescription])
VALUES(N'WfCalculateOvertimeBeforeShift',N'Calculate Overtime Before Shift',N'إحتساب الوقت الإضافي  قبل الورديه',N'false',2,24,1,1,Null,Null,3,N'احتساب الوقت الاضافى للموضف قبل الورديه بناءا على بصمة الحضور مع الورديه المحدده فقط')
Go
--------------------------------------End 2024-07-28  -------------------------------
--------------------------------------M.Negm  2024-07-28  -------------------------------

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1724,499,23043, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1725,999,13136, NULL)
Go
--------------------------------------End 2024-07-28  -------------------------------
--------------------------------------Ali 2024-07-29  -------------------------------

delete From [SecurityPrivilegeEndPoints] where Id in ( 874,875,876,877,878,879,880)
  delete From [SecurityPrivilegeEndPoints] where Id in ( 985,986,865)
  INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) 
VALUES(1726,12,15464, 53)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1727, 984, 15461, 53)
GO

--------------------------------------End 2024-07-29  -------------------------------
--------------------------------------M.Negm  2024-07-30  -------------------------------
INSERT [dbo].[SecurityPrivilegeActions] 
([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(2004,N'WorkFlow',N'OverTimeSymphonyRequestSignatureApi',N'Index',0,N'get',3301)
Go
INSERT [dbo].[SecurityPrivilegeActions] 
([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(2005,N'WorkFlow',N'OverTimeSymphonyRequestSignatureApi',N'OverTimeRequest_Read',0,N'post',3301)
Go
INSERT [dbo].[SecurityPrivilegeActions] 
([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(2006,N'WorkFlow',N'OverTimeSymphonyRequestSignatureApi',N'Save',2,N'get',3302)
Go
INSERT [dbo].[SecurityPrivilegeActions] 
([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(2007,N'WorkFlow',N'OverTimeSymphonyRequestSignatureApi',N'Save',0,N'Post',3303)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints]
([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])VALUES 
(1434, NULL, NULL, N'OverTimeSymphonyRequestSignature', N'GetDetails', N'Get')
GO

INSERT [dbo].[SecurityPrivilegeEndPoints]
([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])VALUES 
(1435, NULL, NULL, N'OverTimeSymphonyRequestSignature', N'GetForSaveSignature', N'Get')
GO

INSERT [dbo].[SecurityPrivilegeEndPoints]
([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])VALUES 
(1436, NULL, NULL, N'OverTimeSymphonyRequestSignature', N'GetRequestSignaturesByUser', N'Post')
GO

INSERT [dbo].[SecurityPrivilegeEndPoints]
([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])VALUES 
(1437, NULL, NULL, N'OverTimeSymphonyRequestSignature', N'SaveSignature', N'Post')
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails]
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1728,1434, 3301, null)
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails]
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])VALUES (1729, 1435, 3301, null)
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails]
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])VALUES (1730, 1436, 3301, null)
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails]
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])VALUES (1731, 1437, 3303, null)
GO 

INSERT [dbo].[SecurityPrivilegeEndPoints]
([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1438,NULL, NULL,N'OverTimeSymphonyRequest',N'GetDetails',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails]
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1732,1438, 3294, null)
GO

update [SecurityPrivilegeEndPoints] set HTTPMethod=N'post' Where id = 1433
go 

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) 
VALUES(1733,1433,3298, NULL)
Go

--------------------------------------End 2024-07-30  -------------------------------
--------------------------------------Mostafa 2024-07-31  -------------------------------
DECLARE @ConstraintName NVARCHAR(MAX);
DECLARE @Sql NVARCHAR(MAX);

DECLARE cur_constraints CURSOR FOR
SELECT name
FROM sys.default_constraints
WHERE parent_object_id = OBJECT_ID('dbo.VacationType');

OPEN cur_constraints;
FETCH NEXT FROM cur_constraints INTO @ConstraintName;

WHILE @@FETCH_STATUS = 0
BEGIN
    BEGIN TRY
        SET @Sql = 'ALTER TABLE dbo.VacationType DROP CONSTRAINT ' + QUOTENAME(@ConstraintName);
        EXEC sp_executesql @Sql;
    END TRY
    BEGIN CATCH
    END CATCH

    FETCH NEXT FROM cur_constraints INTO @ConstraintName;
END

CLOSE cur_constraints;
DEALLOCATE cur_constraints;
GO
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
CREATE TABLE dbo.Tmp_VacationType
	(
	VacationCode tinyint NOT NULL IDENTITY (0, 1),
	Name nvarchar(150) NULL,
	Arabic_Name nvarchar(150) NULL,
	Abbreviation nvarchar(3) NULL,
	discount tinyint NULL,
	BandCode int NULL,
	AnnalLessenDue bit NULL,
	DayoffLessenDue bit NULL,
	HolidayLessenDue bit NULL,
	ByRequest tinyint NULL,
	MYColor float(53) NULL,
	Closed bit NULL,
	FinanceEffect bit NULL,
	ConnectWithBus bit NULL,
	DeductH bit NULL,
	TransportationAllowance bit NULL,
	VacationCollectCode tinyint NULL,
	HidInDiscrepancy bit NULL,
	Present bit NULL,
	RequestSystem bit NULL,
	HidinAttendanceSystem bit NULL,
	OutofHolidayPayment bit NULL,
	AutomaticPenalty float(53) NULL,
	ExceptionDaysPerYear int NULL,
	HidingInLeavesView bit NULL,
	FlexibleTimeTaken bit NULL,
	AnnalLessenInCaseMoreDays float(53) NULL,
	DayoffLessenInCaseMoreDays float(53) NULL,
	HolidayLessenInCaseMoreDays float(53) NULL,
	DeductThisDaysInEndOfServiceReward bit NULL,
	DeductThisDaysInEndOfVacationBalance bit NULL,
	VirtualWorkingHours bit NULL,
	OutOfTotalAvailableHours bit NULL,
	ForShowOnlyInAttendanceSystem bit NULL,
	DropHolidayBalance bit NULL,
	MaximumDaysConsumedPerYear float(53) NULL,
	DeductionDays float(53) NULL,
	HidInAttendanceSystemTemporary bit NULL,
	WDName nvarchar(200) NULL,
	OutOfImportAttendanceSheet bit NULL,
	AccountHours nvarchar(150) NULL,
	ConvertToPresentLetterInAttendanceSystem bit NULL,
	YealyEvaluationPoint float(53) NULL,
	YealyEvaluationExemption int NULL,
	DeductThisDaysWithPayWayByDays bit NULL,
	AttachedFileMandatory bit NULL,
	WF_IsMultiSelect bit NOT NULL,
	InsideVacationPlan bit NOT NULL,
	HaveDifferentTrack bit NOT NULL,
	EffectInAppraisal bit NOT NULL,
	ShowVacationTime bit NOT NULL,
	ShowSalaryAdvanceRequired bit NOT NULL,
	ShowAirTicketRequired bit NOT NULL,
	SubmitBeforRequestDate int NULL,
	SubmitAfterRequestDate int NULL,
	MustRequestBeforeDays int NULL,
	HiringFromMonths float(53) NULL,
	GenderTypeCode int NULL,
	RepeatVacationTypeCode int NULL,
	TheMinimumNumberOfDaysAtATime float(53) NULL,
	TheMaximumNumberOfDaysAtATime float(53) NULL,
	BonusEffect bit NULL,
	MandatoryComment bit NULL,
	RepeatVacationYearlyCount int NULL,
	CalcVacationYearlyFromTypeCode int NULL,
	CanSplitVacation bit NOT NULL,
	FixedNumberOfDays float(53) NULL,
	IncludeWorkingHour bit NOT NULL,
	MaxDaysPerMonth int NULL,
	ReplacementEmployeeRequired bit NOT NULL
	)  ON [PRIMARY]

ALTER TABLE dbo.Tmp_VacationType SET (LOCK_ESCALATION = TABLE)

SET IDENTITY_INSERT dbo.Tmp_VacationType ON

IF EXISTS(SELECT * FROM dbo.VacationType)
	 EXEC('INSERT INTO dbo.Tmp_VacationType (VacationCode, Name, Arabic_Name, Abbreviation, discount, BandCode, AnnalLessenDue, DayoffLessenDue, HolidayLessenDue, ByRequest, MYColor, Closed, FinanceEffect, ConnectWithBus, DeductH, TransportationAllowance, VacationCollectCode, HidInDiscrepancy, Present, RequestSystem, HidinAttendanceSystem, OutofHolidayPayment, AutomaticPenalty, ExceptionDaysPerYear, HidingInLeavesView, FlexibleTimeTaken, AnnalLessenInCaseMoreDays, DayoffLessenInCaseMoreDays, HolidayLessenInCaseMoreDays, DeductThisDaysInEndOfServiceReward, DeductThisDaysInEndOfVacationBalance, VirtualWorkingHours, OutOfTotalAvailableHours, ForShowOnlyInAttendanceSystem, DropHolidayBalance, MaximumDaysConsumedPerYear, DeductionDays, HidInAttendanceSystemTemporary, WDName, OutOfImportAttendanceSheet, AccountHours, ConvertToPresentLetterInAttendanceSystem, YealyEvaluationPoint, YealyEvaluationExemption, DeductThisDaysWithPayWayByDays, AttachedFileMandatory, WF_IsMultiSelect, InsideVacationPlan, HaveDifferentTrack, EffectInAppraisal, ShowVacationTime, ShowSalaryAdvanceRequired, ShowAirTicketRequired, SubmitBeforRequestDate, SubmitAfterRequestDate, MustRequestBeforeDays, HiringFromMonths, GenderTypeCode, RepeatVacationTypeCode, TheMinimumNumberOfDaysAtATime, TheMaximumNumberOfDaysAtATime, BonusEffect, MandatoryComment, RepeatVacationYearlyCount, CalcVacationYearlyFromTypeCode, CanSplitVacation, FixedNumberOfDays, IncludeWorkingHour, MaxDaysPerMonth, ReplacementEmployeeRequired)
		SELECT VacationCode, Name, Arabic_Name, Abbreviation, discount, BandCode, AnnalLessenDue, DayoffLessenDue, HolidayLessenDue, ByRequest, MYColor, Closed, FinanceEffect, ConnectWithBus, DeductH, TransportationAllowance, VacationCollectCode, HidInDiscrepancy, Present, RequestSystem, HidinAttendanceSystem, OutofHolidayPayment, AutomaticPenalty, ExceptionDaysPerYear, HidingInLeavesView, FlexibleTimeTaken, AnnalLessenInCaseMoreDays, DayoffLessenInCaseMoreDays, HolidayLessenInCaseMoreDays, DeductThisDaysInEndOfServiceReward, DeductThisDaysInEndOfVacationBalance, VirtualWorkingHours, OutOfTotalAvailableHours, ForShowOnlyInAttendanceSystem, DropHolidayBalance, MaximumDaysConsumedPerYear, DeductionDays, HidInAttendanceSystemTemporary, WDName, OutOfImportAttendanceSheet, AccountHours, ConvertToPresentLetterInAttendanceSystem, YealyEvaluationPoint, YealyEvaluationExemption, DeductThisDaysWithPayWayByDays, AttachedFileMandatory, WF_IsMultiSelect, InsideVacationPlan, HaveDifferentTrack, EffectInAppraisal, ShowVacationTime, ShowSalaryAdvanceRequired, ShowAirTicketRequired, SubmitBeforRequestDate, SubmitAfterRequestDate, MustRequestBeforeDays, HiringFromMonths, GenderTypeCode, RepeatVacationTypeCode, TheMinimumNumberOfDaysAtATime, TheMaximumNumberOfDaysAtATime, BonusEffect, MandatoryComment, RepeatVacationYearlyCount, CalcVacationYearlyFromTypeCode, CanSplitVacation, FixedNumberOfDays, IncludeWorkingHour, MaxDaysPerMonth, ReplacementEmployeeRequired FROM dbo.VacationType WITH (HOLDLOCK TABLOCKX)')

SET IDENTITY_INSERT dbo.Tmp_VacationType OFF

ALTER TABLE dbo.WF_VacationRequest DROP CONSTRAINT FK_WF_VacationRequest_VacationType

ALTER TABLE dbo.WF_VacationRequestDetail DROP CONSTRAINT FK_WF_VacationRequestDetail_VacationType

DROP TABLE dbo.VacationType

EXECUTE sp_rename N'dbo.Tmp_VacationType', N'VacationType', 'OBJECT' 

ALTER TABLE dbo.VacationType ADD CONSTRAINT
	PK_VacationType PRIMARY KEY CLUSTERED 
	(
	VacationCode
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

COMMIT
GO
BEGIN TRANSACTION
ALTER TABLE dbo.WF_VacationRequestDetail ADD CONSTRAINT
	FK_WF_VacationRequestDetail_VacationType FOREIGN KEY
	(VacationCode
	)
	REFERENCES dbo.VacationType(
	VacationCode) 
	ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 

ALTER TABLE dbo.WF_VacationRequestDetail SET (LOCK_ESCALATION = TABLE)
COMMIT
GO
BEGIN TRANSACTION
ALTER TABLE dbo.WF_VacationRequest ADD CONSTRAINT
	FK_WF_VacationRequest_VacationType FOREIGN KEY
	(VacationTypeId
	) REFERENCES
	dbo.VacationType(
	VacationCode) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 

ALTER TABLE dbo.WF_VacationRequest SET (LOCK_ESCALATION = TABLE)
COMMIT
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_discount DEFAULT ((0)) FOR discount
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_BandCode DEFAULT ((0)) FOR BandCode
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_AnnalLessenDue DEFAULT ((0)) FOR AnnalLessenDue
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_DayoffLessenDue DEFAULT ((0)) FOR DayoffLessenDue
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_HolidayLessenDue DEFAULT ((0)) FOR HolidayLessenDue
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_ByRequest DEFAULT ((0)) FOR ByRequest
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_MYColor DEFAULT ((0)) FOR MYColor
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_Closed DEFAULT ((0)) FOR Closed
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_FinanceEffect DEFAULT ((0)) FOR FinanceEffect
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_ConnectWithBus DEFAULT ((0)) FOR ConnectWithBus
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_DeductH DEFAULT ((0)) FOR DeductH
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_TransportationAllowance DEFAULT ((0)) FOR TransportationAllowance
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_HidInDiscrepancy DEFAULT ((0)) FOR HidInDiscrepancy
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_Present DEFAULT ((0)) FOR Present
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_RequestSystem DEFAULT ((0)) FOR RequestSystem
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_HidinAttendanceSystem DEFAULT ((0)) FOR HidinAttendanceSystem
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_OutofHolidayPayment DEFAULT ((0)) FOR OutofHolidayPayment
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_HidingInLeavesView DEFAULT ((0)) FOR HidingInLeavesView
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_FlexibleTimeTaken DEFAULT ((0)) FOR FlexibleTimeTaken
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_DeductThisDaysInEndOfServiceReward DEFAULT ((0)) FOR DeductThisDaysInEndOfServiceReward
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_DeductThisDaysInEndOfVacationBalance DEFAULT ((0)) FOR DeductThisDaysInEndOfVacationBalance
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_VirtualWorkingHours DEFAULT ((0)) FOR VirtualWorkingHours
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_OutOfTotalAvailableHours DEFAULT ((0)) FOR OutOfTotalAvailableHours
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_ForShowOnlyInAttendanceSystem DEFAULT ((0)) FOR ForShowOnlyInAttendanceSystem
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_DropHolidayBalance DEFAULT ((0)) FOR DropHolidayBalance
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_HidInAttendanceSystemTemporary DEFAULT ((0)) FOR HidInAttendanceSystemTemporary
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_OutOfImportAttendanceSheet DEFAULT ((0)) FOR OutOfImportAttendanceSheet
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_ConvertToPresentLetterInAttendanceSystem DEFAULT ((0)) FOR ConvertToPresentLetterInAttendanceSystem
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_DeductThisDaysWithPayWayByDays DEFAULT ((0)) FOR DeductThisDaysWithPayWayByDays
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationT_WFIsMultiSelect DEFAULT ((0)) FOR WF_IsMultiSelect
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationT_InsideVacationPlan DEFAULT ((0)) FOR InsideVacationPlan
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationT_HaveDifferentTrack DEFAULT ((0)) FOR HaveDifferentTrack
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationT_EffectInAppraisal DEFAULT ((1)) FOR EffectInAppraisal
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_ShowVacationTime DEFAULT ((0)) FOR ShowVacationTime
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_ShowSalaryAdvanceRequired DEFAULT ((0)) FOR ShowSalaryAdvanceRequired
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_ShowAirTicketRequired DEFAULT ((0)) FOR ShowAirTicketRequired
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationT_MandatoryComment DEFAULT ((0)) FOR MandatoryComment
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_CanSplitVacation DEFAULT ((0)) FOR CanSplitVacation
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_IncludeWorkingHour DEFAULT ((0)) FOR IncludeWorkingHour
GO
ALTER TABLE dbo.VacationType ADD CONSTRAINT DF_VacationType_ReplacementEmployeeRequired DEFAULT ((0)) FOR ReplacementEmployeeRequired
GO 
ALTER TABLE dbo.VacationType ADD  CreatedBy  int NOT NULL CONSTRAINT DF_VacationType_CreatedBy DEFAULT(1)
GO
ALTER TABLE dbo.VacationType ADD CreationDate  DATETIME CONSTRAINT DF_VacationType_CreationDate DEFAULT GETDATE();
GO
ALTER TABLE dbo.VacationType ADD ModifiedBy int  NULL 
GO
ALTER TABLE dbo.VacationType ADD ModificationDate datetime NULL;
GO
ALTER TABLE dbo.VacationType ADD Serial  nvarchar(150) NULL 
GO
ALTER TABLE dbo.VacationType ADD  DiffrentEffectAccrodingToPayCode bit NULL  CONSTRAINT DF_VacationType_DiffrentEffectAccrodingToPayCode DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  AnnualLessenInDaysYearFree float NULL  
GO
ALTER TABLE dbo.VacationType ADD  DayoffLessenInDaysYearFree float NULL 
GO
ALTER TABLE dbo.VacationType ADD  HolidayLessenInDaysYearFree float NULL 
GO
ALTER TABLE dbo.VacationType ADD  ReferenceToCalculateForTerminatedUntilEndOfMonth bit NULL  CONSTRAINT DF_VacationType_ReferenceToCalculateForTerminatedUntilEndOfMonth DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  DropDayoffBalance bit NULL  CONSTRAINT DF_VacationType_DropDayoffBalance DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  ForReadOnlyInAttendanceSystem bit NULL  CONSTRAINT DF_VacationType_ForReadOnlyInAttendanceSystem DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  CentralCode int NULL  
GO
ALTER TABLE dbo.VacationType ADD  VacationsPlan bit NULL  CONSTRAINT DF_VacationType_VacationsPlan DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  DeductThisDaysInAirTicket bit NULL  CONSTRAINT DF_VacationType_DeductThisDaysInAirTicket DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  AbsentPenalty bit NULL  CONSTRAINT DF_VacationType_AbsentPenalty DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  AffectSCBonus bit NULL  CONSTRAINT DF_VacationType_AffectSCBonus DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  UseProfileSpecialRate bit NULL  CONSTRAINT DF_VacationType_UseProfileSpecialRate DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  UseTimePenaltiesActions bit NULL  CONSTRAINT DF_VacationType_UseTimePenaltiesActions DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  DuplicateCalculate bit NULL  CONSTRAINT DF_VacationType_DuplicateCalculate DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  DuplicateCalculateBandCode int NULL  
GO
ALTER TABLE dbo.VacationType ADD  IgnoreVacationStatusCode bit NULL  CONSTRAINT DF_VacationType_IgnoreVacationStatusCode DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  MDT DATETIME CONSTRAINT DF_VacationType_MDT DEFAULT GETDATE() 
GO
ALTER TABLE dbo.VacationType ADD  OutOfFTE bit NULL  CONSTRAINT DF_VacationType_OutOfFTE DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  ConvertCountOfDaysTo30 bit NULL  CONSTRAINT DF_VacationType_ConvertCountOfDaysTo30 DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  UseAWarningForTheMaximumNumberDaysOfSection bit NULL  CONSTRAINT DF_VacationType_UseAWarningForTheMaximumNumberDaysOfSection DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  HideInLeavesAndVacationsScreen bit NULL  CONSTRAINT DF_VacationType_HideInLeavesAndVacationsScreen DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  KPIEffect bit NULL  CONSTRAINT DF_VacationType_KPIEffect DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  DayRateNumber tinyint NULL  CONSTRAINT DF_VacationType_DayRateNumber DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  LinkLeaveSalarySettlementDaysDetails bit NULL  CONSTRAINT DF_VacationType_LinkLeaveSalarySettlementDaysDetails DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  DeductThisDaysInEndOfServiceRewardExceptionDays float NULL  
GO
ALTER TABLE dbo.VacationType ADD  DeductThisDaysInIncentive bit NULL  CONSTRAINT DF_VacationType_DeductThisDaysInIncentive DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  HidTotalColumnInAttendanceSystem bit NULL  CONSTRAINT DF_VacationType_HidTotalColumnInAttendanceSystem DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  DropDayoff2Only bit NULL  CONSTRAINT DF_VacationType_DropDayoff2Only DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  TargetSheetNoneDay bit NULL  CONSTRAINT DF_VacationType_TargetSheetNoneDay DEFAULT(0)
GO
ALTER TABLE dbo.VacationType ADD  ZeroTarget bit NULL  CONSTRAINT DF_VacationType_ZeroTarget DEFAULT(0)
GO
update dbo.VacationType set Serial=VacationCode
GO
UPDATE dbo.VacationType SET CreatedBy = 1 WHERE CreatedBy IS NULL OR CreatedBy = 0;
Go
UPDATE dbo.VacationType SET CreationDate = GETDATE() WHERE CreationDate IS NULL;
GO
UPDATE dbo.VacationType SET MDT = GETDATE() WHERE MDT IS NULL;
GO
UPDATE  dbo.VacationType SET Name = CASE WHEN COALESCE(Name, '') = '' OR Name IS NULL THEN Arabic_Name ELSE Name END, Arabic_Name = CASE WHEN COALESCE(Arabic_Name, '') = '' OR Arabic_Name IS NULL THEN Name  ELSE Arabic_Name END;
GO

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1088,N'Vacation Type',N'أنواع الإجازات',1062,N'/Personal/VacationType',N'Index','fa fa-thumb-tack',N'get',15,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1088,22)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4194,N'أنواع الإجازات',N'Vacation Type',1088,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4195,N'عرض أنواع الإجازات',N'View Vacation Type',1088,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4196,N'إضافة أنواع الإجازات',N'Add Vacation Type',1088,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4197,N'تعديل أنواع الإجازات',N'Edit Vacation Type',1088,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4198,N'حذف أنواع الإجازات',N'Delete Vacation Type',1088,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4199,N'حفظ أنواع الإجازات',N'Save Vacation Type',1088,2)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1989,N'Personal',N'VacationType',N'Index',0,N'get',4194)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1990,N'Personal',N'VacationType',N'VacationType_Read',0,N'post',4195)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1991,N'Personal',N'VacationType',N'Save',1,N'get',4196)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1992,N'Personal',N'VacationType',N'Save',2,N'get',4197)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1993,N'Personal',N'VacationType',N'Delete',0,N'post',4198)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1994,N'Personal',N'VacationType',N'Save',0,N'post',4199)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1418,NULL, NULL,N'VacationType',N'GetVacationTypeSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1419,NULL, NULL,N'VacationType',N'GetVacationType',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1420,NULL, NULL,N'VacationType',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1421,NULL, NULL,N'VacationType',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1422,NULL, NULL,N'VacationType',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1423,NULL, NULL,N'VacationType',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1707,1418,4195, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1708,1419,4195, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1709,1420,4199, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1710,1421,4199, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1711,1422,4198, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1712,1423,4197, NULL)
Go

DECLARE @ConstraintName NVARCHAR(MAX);
DECLARE @Sql NVARCHAR(MAX);

DECLARE cur_constraints CURSOR FOR
SELECT name
FROM sys.default_constraints
WHERE parent_object_id = OBJECT_ID('dbo.CentralVacationTypes');

OPEN cur_constraints;
FETCH NEXT FROM cur_constraints INTO @ConstraintName;

WHILE @@FETCH_STATUS = 0
BEGIN
    BEGIN TRY
        SET @Sql = 'ALTER TABLE dbo.CentralVacationTypes DROP CONSTRAINT ' + QUOTENAME(@ConstraintName);
        EXEC sp_executesql @Sql;
    END TRY
    BEGIN CATCH
    END CATCH

    FETCH NEXT FROM cur_constraints INTO @ConstraintName;
END

CLOSE cur_constraints;
DEALLOCATE cur_constraints;
GO
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION

CREATE TABLE dbo.Tmp_CentralVacationTypes
	(
	VacationCode int NOT NULL IDENTITY (1, 1),
	Name nvarchar(150) NULL,
	Arabic_Name nvarchar(150) NULL,
	Closed bit NULL,
	MDT datetime NULL
	)  ON [PRIMARY]

ALTER TABLE dbo.Tmp_CentralVacationTypes SET (LOCK_ESCALATION = TABLE)



SET IDENTITY_INSERT dbo.Tmp_CentralVacationTypes ON

IF EXISTS(SELECT * FROM dbo.CentralVacationTypes)
	 EXEC('INSERT INTO dbo.Tmp_CentralVacationTypes (VacationCode, Name, Arabic_Name, Closed, MDT)
		SELECT VacationCode, Name, Arabic_Name, Closed, MDT FROM dbo.CentralVacationTypes WITH (HOLDLOCK TABLOCKX)')

SET IDENTITY_INSERT dbo.Tmp_CentralVacationTypes OFF

DROP TABLE dbo.CentralVacationTypes

EXECUTE sp_rename N'dbo.Tmp_CentralVacationTypes', N'CentralVacationTypes', 'OBJECT' 

ALTER TABLE dbo.CentralVacationTypes ADD CONSTRAINT
	PK_CentralVacationTypes_VacationCode PRIMARY KEY CLUSTERED 
	(
	VacationCode
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


COMMIT
ALTER TABLE dbo.CentralVacationTypes ADD CreatedBy int  NOT NULL  DEFAULT 1
GO
ALTER TABLE dbo.CentralVacationTypes ADD CreationDate datetime  NOT NULL DEFAULT GETDATE()
GO
ALTER TABLE dbo.CentralVacationTypes ADD ModifiedBy int NULL
GO
ALTER TABLE dbo.CentralVacationTypes ADD ModificationDate datetime NULL
GO
ALTER TABLE dbo.CentralVacationTypes ADD Serial nvarchar(150) NULL
GO
UPDATE   dbo.CentralVacationTypes SET Serial= VacationCode WHERE Serial IS NULL
GO
ALTER TABLE dbo.CentralVacationTypes ADD CONSTRAINT
DF_CentralVacationTypes_Closed DEFAULT ((0)) FOR Closed
GO
ALTER TABLE dbo.CentralVacationTypes ADD CONSTRAINT
DF_CentralVacationTypes_MDT DEFAULT (getdate()) FOR MDT
GO
UPDATE   dbo.CentralVacationTypes SET Name = CASE WHEN COALESCE(Name, '') = '' OR Name IS NULL THEN Arabic_Name ELSE Name END, Arabic_Name = CASE WHEN COALESCE(Arabic_Name, '') = '' OR Arabic_Name IS NULL THEN Name  ELSE Arabic_Name END;
GO
update VacationType set AnnalLessenDue =0 where AnnalLessenDue is null
GO
update VacationType set DayoffLessenDue =0 where DayoffLessenDue is null
GO
update VacationType set HolidayLessenDue =0 where HolidayLessenDue is null
GO
update VacationType set DropHolidayBalance =0 where DropHolidayBalance is null
GO
update VacationType set DropDayoffBalance =0 where DropDayoffBalance is null
GO
update VacationType set DropDayoff2Only =0 where DropDayoff2Only is null
GO
update VacationType set DiffrentEffectAccrodingToPayCode =0 where DiffrentEffectAccrodingToPayCode is null
GO
update VacationType set UseProfileSpecialRate =0 where UseProfileSpecialRate is null
GO
update VacationType set FinanceEffect =0 where FinanceEffect is null
GO
update VacationType set ConnectWithBus =0 where ConnectWithBus is null
GO
update VacationType set Closed =0 where Closed is null
GO
update VacationType set TransportationAllowance =0 where TransportationAllowance is null
GO
update VacationType set FlexibleTimeTaken =0 where FlexibleTimeTaken is null
GO
update VacationType set OutofHolidayPayment =0 where OutofHolidayPayment is null
GO
update VacationType set HidingInLeavesView =0 where HidingInLeavesView is null
GO
update VacationType set HidInDiscrepancy =0 where HidInDiscrepancy is null
GO
update VacationType set Present =0 where Present is null
GO
update VacationType set HidinAttendanceSystem =0 where HidinAttendanceSystem is null
GO
update VacationType set ForShowOnlyInAttendanceSystem =0 where ForShowOnlyInAttendanceSystem is null
GO
update VacationType set ForReadOnlyInAttendanceSystem =0 where ForReadOnlyInAttendanceSystem is null
GO
update VacationType set DeductThisDaysInEndOfServiceReward =0 where DeductThisDaysInEndOfServiceReward is null
GO
update VacationType set DeductThisDaysInEndOfVacationBalance =0 where DeductThisDaysInEndOfVacationBalance is null
GO
update VacationType set DeductThisDaysInAirTicket =0 where DeductThisDaysInAirTicket is null
GO
update VacationType set DeductThisDaysInIncentive =0 where DeductThisDaysInIncentive is null
GO
update VacationType set HidInAttendanceSystemTemporary =0 where HidInAttendanceSystemTemporary is null
GO
update VacationType set OutOfImportAttendanceSheet =0 where OutOfImportAttendanceSheet is null
GO
update VacationType set OutOfTotalAvailableHours =0 where OutOfTotalAvailableHours is null
GO
update VacationType set DeductThisDaysWithPayWayByDays =0 where DeductThisDaysWithPayWayByDays is null
GO
update VacationType set AttachedFileMandatory =0 where AttachedFileMandatory is null
GO
update VacationType set ReferenceToCalculateForTerminatedUntilEndOfMonth =0 where ReferenceToCalculateForTerminatedUntilEndOfMonth is null
GO
update VacationType set MandatoryComment =0 where MandatoryComment is null
GO
update VacationType set VacationsPlan =0 where VacationsPlan is null
GO
update VacationType set UseTimePenaltiesActions =0 where UseTimePenaltiesActions is null
GO
update VacationType set DuplicateCalculate =0 where DuplicateCalculate is null
GO
update VacationType set VirtualWorkingHours =0 where VirtualWorkingHours is null
GO
update VacationType set OutOfFTE =0 where OutOfFTE is null
GO
update VacationType set AffectSCBonus =0 where AffectSCBonus is null
GO
update VacationType set IgnoreVacationStatusCode =0 where IgnoreVacationStatusCode is null
GO
update VacationType set BonusEffect =0 where BonusEffect is null
GO
update VacationType set KPIEffect =0 where KPIEffect is null
GO
update VacationType set ConvertToPresentLetterInAttendanceSystem =0 where ConvertToPresentLetterInAttendanceSystem is null
GO
update VacationType set UseAWarningForTheMaximumNumberDaysOfSection =0 where UseAWarningForTheMaximumNumberDaysOfSection is null
GO
update VacationType set HidTotalColumnInAttendanceSystem =0 where HidTotalColumnInAttendanceSystem is null
GO
update VacationType set HideInLeavesAndVacationsScreen =0 where HideInLeavesAndVacationsScreen is null
GO
update VacationType set LinkLeaveSalarySettlementDaysDetails =0 where LinkLeaveSalarySettlementDaysDetails is null
GO
update VacationType set DeductH =0 where DeductH is null
GO
update VacationType set RequestSystem =0 where RequestSystem is null
GO
update VacationType set WF_IsMultiSelect =0 where WF_IsMultiSelect is null
GO
update VacationType set InsideVacationPlan =0 where InsideVacationPlan is null
GO
update VacationType set HaveDifferentTrack =0 where HaveDifferentTrack is null
GO
update VacationType set EffectInAppraisal =0 where EffectInAppraisal is null
GO
update VacationType set ShowVacationTime =0 where ShowVacationTime is null
GO
update VacationType set ShowSalaryAdvanceRequired =0 where ShowSalaryAdvanceRequired is null
GO
update VacationType set ShowAirTicketRequired =0 where ShowAirTicketRequired is null
GO
update VacationType set CanSplitVacation =0 where CanSplitVacation is null
GO
update VacationType set IncludeWorkingHour =0 where IncludeWorkingHour is null
GO
update VacationType set ReplacementEmployeeRequired =0 where ReplacementEmployeeRequired is null
GO
update VacationType set AbsentPenalty =0 where AbsentPenalty is null
GO
update VacationType set ConvertCountOfDaysTo30 =0 where ConvertCountOfDaysTo30 is null
GO
update VacationType set TargetSheetNoneDay =0 where TargetSheetNoneDay is null
GO
update VacationType set ZeroTarget =0 where ZeroTarget is null
GO
update VacationType set ByRequest =0 where ByRequest is null
GO
ALTER TABLE dbo.SecurityUser ADD
	AttendByMobile bit NOT NULL CONSTRAINT DF_SecurityUser_AttendByMobile DEFAULT ((1))
GO
--------------------------------------End 2024-07-31  -------------------------------
-------------------------------------M.Negm 2024-08-01 ------------------------------

ALTER TABLE dbo.WF_OvertimeType ADD
	IsEdit bit NOT NULL CONSTRAINT DF_WF_OvertimeType_IsEdit DEFAULT ((0))
GO

------------------------------------ End 2024-08-01 -----------------------------