﻿------------------------------------------- Hammad  2024-09-18 ---------------
INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode], [IsVisible]) 
VALUES (42, N'Direct Manager 2', N'المدير المباشر 2', 1, NULL, 1)
GO
------------------------------------------- End  2024-09-18 ---------------
-------------------------------------------M.Negm 2024-09-19 --------------
 ALTER TABLE dbo.VacationType ADD
	CantAddRequestForEmpHaveFingerPrint bit NOT NULL CONSTRAINT DF_VacationType_CantAddRequestForEmpHaveFingerPrint DEFAULT ((0))
GO

Update SecurityPrivilegeEndPointsDetails set SecurityPrivilegeId=3360 where id=1587
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15495, N'حفظ إعدادات الاجازات', N'Save Vacation Configuration', 215, 2)
GO
Update SecurityPrivilegeActions set SecurityPrivilegeID = 15495 where id = 2032
Go 
Update SecurityPrivilegeEndPointsDetails set SecurityPrivilegeId=15495 where id=1759
Go

------------------------------------------- End 2024-09-19 -----------------
----------------------------------------- AK 2024-09-19 --------------------
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1459,'PMS',NULL,N'AppraisalCategory',N'GetAppraisalCategoriesSearch',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1460,'PMS',NULL,N'AppraisalCategory',N'Post',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1461,'PMS',NULL,N'AppraisalCategory',N'Put',N'Put')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1462,'PMS',NULL,N'AppraisalCategory',N'Delete',N'Delete')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1760,1459,10002,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1761,1460,10005,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1762,1461,10005,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1763,1462,10006,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1463,'PMS',NULL,N'AppraisalElementGroup',N'GetAppraisalElementGroupsSearch',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1464,'PMS',NULL,N'AppraisalElementGroup',N'Post',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1465,'PMS',NULL,N'AppraisalElementGroup',N'Put',N'Put')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1466,'PMS',NULL,N'AppraisalElementGroup',N'Delete',N'Delete')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1765,1463,10055,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1766,1464,10054,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1767,1465,10054,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1768,1466,10053,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1467,'PMS',NULL,N'AppraisalElement',N'GetAppraisalElementesSearch',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1468,'PMS',NULL,N'AppraisalElement',N'Post',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1469,'PMS',NULL,N'AppraisalElement',N'Put',N'Put')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1470,'PMS',NULL,N'AppraisalElement',N'Delete',N'Delete')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1785,1467,10011,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1786,1468,10014,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1787,1469,10014,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1788,1470,10015,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1471,'PMS',NULL,N'DepartmentRelationship',N'GetByDepartment',N'Get')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1472,'PMS',NULL,N'DepartmentRelationship',N'Post',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1821,1471,10020,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1822,1472,10021,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1473,'PMS',NULL,N'AttendancePointSetup',N'GetAttendancePointSetupSearch',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1474,'PMS',NULL,N'AttendancePointSetup',N'Post',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1475,'PMS',NULL,N'AttendancePointSetup',N'Put',N'Put')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1476,'PMS',NULL,N'AttendancePointSetup',N'Delete',N'Delete')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1823,1473,10066,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1824,1474,10070,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1825,1475,10070,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1826,1476,10069,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1477,'PMS',NULL,N'PromotionStatus',N'GetPromotionStatusesSearch',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1478,'PMS',NULL,N'PromotionStatus',N'Post',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1479,'PMS',NULL,N'PromotionStatus',N'Put',N'Put')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1480,'PMS',NULL,N'PromotionStatus',N'Delete',N'Delete')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1827,1477,10152,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1828,1478,10156,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1829,1479,10156,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1830,1480,10155,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1481,'PMS',NULL,N'Curve',N'GetCurvesSearch',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1482,'PMS',NULL,N'Curve',N'Post',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1483,'PMS',NULL,N'Curve',N'Put',N'Put')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1484,'PMS',NULL,N'Curve',N'Delete',N'Delete')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1831,1481,10085,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1832,1482,10089,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1833,1483,10089,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1834,1484,10088,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1485,'PMS',NULL,N'CurveLevel',N'GetCurveLevelesSearch',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1486,'PMS',NULL,N'CurveLevel',N'Post',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1487,'PMS',NULL,N'CurveLevel',N'Put',N'Put')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1488,'PMS',NULL,N'CurveLevel',N'Delete',N'Delete')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1835,1485,10079,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1836,1486,10083,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1837,1487,10083,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1838,1488,10082,NULL)
GO
--------------------------------------- End AK 2024-09-19 ------------------
--------------------------------------- Hammad 2024-09-19 ------------------
	update SystemMenu set ControllerName =N'/WorkFlow/PermissionRequestApi' where SystemMenuCode=36
 Go
 --------------------------------------- End 2024-09-19 ------------------