﻿--------------------------Hammad 2023-10-30--------------------
insert into ConfigCategoryModule(ConfigCategoryCode	,AppModuleCode)values(15,1)
Go
--------------------------End 2023-10-30-----------------------
-----------------------------Negm 30-10-2023-------------------


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1277,N'WorkFlow',N'ChangeDayoffRequest',N'Index',0,N'get',3314)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1278,N'WorkFlow',N'ChangeDayoffRequest',N'ChangeDayoffRequest_Read',0,N'post',3315)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1279,N'WorkFlow',N'ChangeDayoffRequest',N'Save',1,N'get',3316)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1280,N'WorkFlow',N'ChangeDayoffRequest',N'Save',2,N'get',3317)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1281,N'WorkFlow',N'ChangeDayoffRequest',N'Delete',0,N'post',3318)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1282,N'WorkFlow',N'ChangeDayoffRequest',N'Save',0,N'post',3319)
Go

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




insert into SecurityPrivilegeActions (id , AreaName , ControllerName , ActionName , ActionType , HTTPMethod , SecurityPrivilegeID )
values (1288, N'WorkFlow' , N'ChangeDayoffRequestSignature', N'Index', 0, N'get' ,3321  )

insert into SecurityPrivilegeActions (id , AreaName , ControllerName , ActionName , ActionType , HTTPMethod , SecurityPrivilegeID )
values (1289, N'WorkFlow' , N'ChangeDayoffRequestSignature', N'ChangeDayoffRequest_Read', 0, N'post' ,3322  )

insert into SecurityPrivilegeActions (id , AreaName , ControllerName , ActionName , ActionType , HTTPMethod , SecurityPrivilegeID )
values (1290, N'WorkFlow' , N'ChangeDayoffRequestSignature', N'Save', 2, N'get' ,3323  )

insert into SecurityPrivilegeActions (id , AreaName , ControllerName , ActionName , ActionType , HTTPMethod , SecurityPrivilegeID )
values (1291, N'WorkFlow' , N'ChangeDayoffRequestSignature', N'Save', 0, N'post' ,3324  )


INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) 
VALUES (854, NULL, NULL, N'ChangeDayOffRequest', N'SearchChangeDayOffRequest', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (855, NULL, NULL, N'ChangeDayOffRequest', N'GetDetails', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) 
VALUES (856, NULL, NULL, N'ChangeDayOffRequest', N'GetWithOutSigById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (857, NULL, NULL, N'ChangeDayOffRequest', N'Put', N'Put')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) 
VALUES (858, NULL, NULL, N'ChangeDayOffRequest', N'Post', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) 
VALUES (859, NULL, NULL, N'ChangeDayOffRequest', N'Delete', N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (860, NULL, NULL, N'ChangeDayOffRequest', N'Get', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (861, NULL, NULL, N'ChangeDayOffRequest', N'CancelRequest', N'Get')
GO


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1083, 854, 3315, 18)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1084, 855, 3317, 18)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1085, 856, 3317, 18)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1086, 857, 3319, 18)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1087, 858, 3319, 18)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1088, 859, 3318, 18)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1089, 860, 3317, 18)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1090, 861, 3320, 18)
GO


INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (862, NULL, NULL, N'ChangeDayOffRequestSignature', N'GetSignatureById', N'Get')
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (863, NULL, NULL, N'ChangeDayOffRequestSignature', N'GetChangeDayOffRequestSignature', N'Get')
GO

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

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (865, NULL, NULL, N'ChangeDayOffRequestSignature', N'GetRequestHistory', N'Post')
GO

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


 INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) 
 VALUES (1091, 862, 3323, 18)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1092, 863, 3323, 18)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1093, 864, 3322, 18)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1094, 866, 3324, 18)
GO

----------------------------End 30-10-2023---------------------
----------------------------Hammad 30-10-2023------------------
ALTER TABLE dbo.WF_TrackDetail ADD
	IsRecommandOnly bit NOT NULL CONSTRAINT DF_WF_TrackDetail_IsRecommandOnly DEFAULT (0)
GO
----------------------------End 30-10-2023---------------------
----------------------------Ali 1-11-2023---------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) VALUES (N'CanAddEmployeesForFingerArea', N'? Can Add employees for Finger Area', N'امكانية اضافة موظفين لمساحة البصمه ؟', N'false', 12, 15, 1, 1, NULL, NULL, NULL, N'يمكن تسكين الموظفين لمساحة البصمه مع تفعيل الاعداد')
Go
----------------------------End 1-11-2023---------------------
----------------------------Hammad 02-11-2023------------------
 ALTER TABLE dbo.WF_MasterRequestsSignature ADD
	RecommendationTypeCode int  NULL 
Go

ALTER TABLE dbo.WF_MasterRequestsSignature ADD
	IsRecommandOnly bit NOT NULL CONSTRAINT DF_WF_MasterRequestsSignature_IsRecommandOnly DEFAULT (0)
GO
----------------------------End 02-11-2023------------------
