﻿--------------------------------------- AK 2024-06-06 ---------
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1356,NULL,NULL,N'RecruitJobStages',N'GetForeignerJobStagesSearch',N'Get')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1360,NULL,NULL,N'RecruitJobStages',N'UpdateForeignerJobStages',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1639,1356,5144,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1643,1360,5145,NULL)
GO
--------------------------------------- End AK 2024-06-06 ------------

---------------------------------------  Mostafa 2024-06-06 ------------
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1950,N'WorkFlow',N'BandSalaryConfiguration',N'Index',0,N'get',1381)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1952,N'WorkFlow',N'BandSalaryConfiguration',N'BandSalaryConfiguration_Read',0,N'post',1382)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1953,N'WorkFlow',N'BandSalaryConfiguration',N'Save',0,N'post',1383)
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1368,NULL, NULL,N'BasisConfiguration',N'GetBandSalaryConfigurationSearch',N'post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1369,NULL, NULL,N'BasisConfiguration',N'EditListBandSalaryConfiguration',N'post')
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1651,1368,1382, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1652,1369,1383, NULL)
GO

--------------------------------------- End Mostafa 2024-06-06 ------------
---------------------------------------  M.Negm 2024-06-06 ------------
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1954,N'WorkFlow',N'EmployeeTrackApi',N'Index',0,N'get',3012)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1955,N'WorkFlow',N'EmployeeTrackApi',N'EmployeeTrack_Read',0,N'post',3013)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1956,N'WorkFlow',N'EmployeeTrackApi',N'Save',1,N'get',3014)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1957,N'WorkFlow',N'EmployeeTrackApi',N'Save',2,N'get',3015)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1958,N'WorkFlow',N'EmployeeTrackApi',N'Delete',0,N'post',3016)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1959,N'WorkFlow',N'EmployeeTrackApi',N'Save',0,N'post',3017)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1960,N'WorkFlow',N'EmployeeTrackApi',N'SaveBySection',1,N'get',3187)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1961,N'WorkFlow',N'EmployeeTrackApi',N'SaveBySection',0,N'post',3187)
Go

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1370,NULL, NULL,N'WfEmployeeTrack',N'GetWfEmployeeTrackSearch',N'post')
Go																									
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1371,NULL, NULL,N'WfEmployeeTrack',N'post',N'post')
Go																													
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1372,NULL, NULL,N'WfEmployeeTrack',N'Delete',N'Delete')
Go																													
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1373,NULL, NULL,N'WfEmployeeTrack',N'SaveBySection',N'Post')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1653,1370,3013, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1654,1371,3017, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1655,1372,3016, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1656,1373,3187, NULL)
Go
--------------------------------------- End  M.Negm 2024-06-06 ------------
--------------------------------------- mostafa 2024-06-09 ------------

update [SecurityPrivilegeActions] set  [SecurityPrivilegeID]=3595 where  [ID]=1825
--------------------------------------- end 2024-06-09 ------------
--------------------------------------- Hammad 2024-06-10 ------------
ALTER TABLE [dbo].[FingerAreaProjects] DROP CONSTRAINT [FK_FingerAreaProjects_FingerArea]
GO

  ALTER TABLE dbo.FingerAreaProjects
	DROP COLUMN FingerAreaCode
  GO
  --------------------------------------- end 2024-06-10 ------------

  --------------------------------------- M.Negm 2024-06-10 ------------
 INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1380,NULL, NULL,N'WfEmployeeTrack',N'GetForSave',N'get')
Go		
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1663,1380,3014, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1664,1380,3015, NULL)
Go

 INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1381,NULL, NULL,N'WfTrack',N'GetForSave',N'get')
Go		
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1665,1381,3008, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1666,1381,3009, NULL)
Go
  --------------------------------------- end M.Negm 2024-06-10 ------------

