﻿--------------------------------------- M.Negm  2024-06-26 ----------------
 ALTER TABLE dbo.VacationType ADD
	ReplacementEmployeeRequired bit NOT NULL CONSTRAINT DF_VacationType_ReplacementEmployeeRequired DEFAULT ((0))
GO
DECLARE @ConfigValue NVARCHAR(MAX)
SELECT @ConfigValue = ConfigValue 
FROM ConfigParameter 
WHERE ConfigKey LIKE N'WFVacationReplacementEmployeeRequired'

IF @ConfigValue = 'true'
BEGIN
    UPDATE VacationType 
    SET ReplacementEmployeeRequired = 1
END
Go

delete from ConfigParameter where ConfigKey Like N'WFVacationReplacementEmployeeRequired'
 Go

--------------------------------------- End M.Negm  2024-06-26 ------------
--------------------------------------- Ali  2024-07-07 ------------

update [SecurityPrivilegeActions] set [ActionName]='SaveRequest' where ID=1982
Go
--------------------------------------- End  2024-07-07 ------------
--------------------------------------- M.Negm  2024-07-07 ------------
INSERT [dbo].[SecurityPrivilegeEndPointsDetails]
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) 
VALUES(1701,1353,3009, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails]
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) 
VALUES(1702,1323,3222, NULL)
Go
--------------------------------------- End  2024-07-07 ------------
  --------------------------------------- AK 2024-07-07 ---------
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1399,NULL,NULL,N'JobOffer',N'GetCandidatesForJobOffer',N'Post')
Go
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1686,1399,5072,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1400,NULL,NULL,N'CandidateInvitation',N'GetJobOffer',N'Get')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1687,1400,5074,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1413,NULL,NULL,N'CandidateInvitation',N'SaveJobOffer',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1700,1413,5074,NULL)
GO
--------------------------------------- End AK 2024-07-07 ------------