﻿--------------------------------------- Mostafa 2024-08-22 ------------
ALTER TABLE dbo.FingerArea ADD
	ShortName nvarchar(20) NULL
GO
--------------------------------------- End 2024-08-22 ------------
--------------------------------------- Ali 2024-08-25 ------------


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2008, N'WorkFlow', N'CombinedVacationsRequestApi', N'Index', 0, N'get',3144 )
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2009, N'WorkFlow', N'CombinedVacationsRequestApi', N'CombinedVacationsRequest_Read', 0, N'post', 3145)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2010, N'WorkFlow', N'CombinedVacationsRequestApi', N'Save', 1, N'get', 3146)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2011, N'WorkFlow', N'CombinedVacationsRequestApi', N'Save', 2, N'get', 3147)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2012, N'WorkFlow', N'CombinedVacationsRequestApi', N'Delete', 0, N'post', 3149)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2013, N'WorkFlow', N'CombinedVacationsRequestApi', N'SaveRequest', 0, N'post', 3148)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2014, N'WorkFlow', N'CombinedVacationsRequestApi', N'Cancel', 0, N'post', 3150)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2015, N'WorkFlow', N'CombinedVacationsRequestSignatureApi', N'Index', 0, N'get', 3151)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2016, N'WorkFlow', N'CombinedVacationsRequestSignatureApi', N'CombinedVacationsRequest_Read', 0, N'post', 3152)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2017, N'WorkFlow', N'CombinedVacationsRequestSignatureApi', N'Save', 2, N'get', 3153)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2018, N'WorkFlow', N'CombinedVacationsRequestSignatureApi', N'Save', 0, N'post', 3154)
Go

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])VALUES(1439,NULL, NULL,N'CombinedVacationsRequest',N'SearchCombinedVacationRequest',N'post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])VALUES(1440,NULL, NULL,N'CombinedVacationsRequest',N'GetDetails',N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])VALUES(1441,NULL, NULL,N'CombinedVacationsRequest',N'Put',N'Put')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])VALUES(1442,NULL, NULL,N'CombinedVacationsRequest',N'post',N'post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])VALUES(1443,NULL, NULL,N'CombinedVacationsRequest',N'Delete',N'Delete')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])VALUES(1444,NULL, NULL,N'CombinedVacationsRequest',N'Get',N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])VALUES(1445,NULL, NULL,N'CombinedVacationsRequest',N'CancelRequest',N'Post')

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])VALUES(1734,1439,3145,11)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])VALUES(1735,1440,3145,11)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])VALUES(1736,1441,3148,11)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])VALUES(1737,1442,3148,11)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])VALUES(1738,1443,3149,11)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])VALUES(1739,1444,3147,11)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])VALUES(1740,1445,3150,11)
Go

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])VALUES (1446, NULL, NULL, N' CombinedVacationsRequestSignature', N'GetSignatureById', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])VALUES (1447, NULL, NULL, N' CombinedVacationsRequestSignature', N'GetCombinedVacationsRequestSignature', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])VALUES (1448, NULL, NULL, N' CombinedVacationsRequestSignature', N'GetRequestSignaturesByUser', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])VALUES (1449, NULL, NULL, N' CombinedVacationsRequestSignature', N'SaveSignature', N'Post')
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1741,1446, 3153,11)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])VALUES (1742,1447, 3153,11)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])VALUES (1743,1448, 3152,11)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])VALUES (1744,1449, 3154,11)
GO 

--------------------------------------- End 2024-08-25 ------------

-------------------------------------------M.Negm 2024-08-25 ------------------------

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(2031,N'WorkFlow',N'VacationTypeApi',N'Index',0,N'get',3545)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(2032,N'WorkFlow',N'VacationTypeApi',N'EditSingle',0,N'Post',3545)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] 
([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1457,N'Workflow', NULL,N'VacationType',N'GetVacationTypeInfo',N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails]
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1758,1457,3545, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] 
([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1458,N'Workflow', NULL,N'VacationType',N'EditSingle',N'Put')
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails]
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1759,1458,3545, NULL)
GO
------------------------------------------- End M.Negm 2024-08-25 ------------------------
-------------------------------------------M.Negm 2024-08-26 ------------------------

  INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
   VALUES(13142,N' تسكين الموظفين على مساحة البصمة ',N' Finger Area Employee',705,1)
   go
     INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
   VALUES(13143,N' عرض تسكين الموظفين على مساحة البصمة  ',N'View Finger Area Employee',705,2)  
   go
   INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
   VALUES(13144,N'حفظ تسكين الموظفين على مساحة البصمة ',N'Save Finger Area Employee',705,2)
   go
   update SystemMenu set ShowInPrivilegePage=1 where SystemMenuCode = 705
   go
------------------------------------------- End M.Negm 2024-08-26 -------------------
-------------------------------------------Hammad 2024-08-27 ------------------------
ALTER TABLE dbo.NotificationFlag ADD
	IsSent bit NOT NULL CONSTRAINT DF_NotificationFlag_IsSent DEFAULT 0,
	ErrorReason nvarchar(500) NULL
GO

update dbo.NotificationFlag set IsSent=1
GO
------------------------------------------- End Hammad 2024-08-27 -------------------
