﻿
-----------------------------------  M.Negm 2024-02-12 ---------------------------
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
VALUES(5152,N'حفظ طلب تعيين مرشحين ',N'Save Hire Candidate Request',125,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1477,N'WorkFlow',N'HireCandidateRequest',N'Save',1,N'get',5135)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1478,N'WorkFlow',N'HireCandidateRequest',N'Save',0,N'post',5152)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(979,NULL, NULL,N'HireCandidateRequest',N'SearchHireCandidateRequest',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(980,NULL, NULL,N'HireCandidateRequest',N'GetDetails',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(981,NULL, NULL,N'HireCandidateRequest',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(982,NULL, NULL,N'HireCandidateRequest',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) 
VALUES(983,NULL, NULL,N'HireCandidateRequest',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(984,NULL, NULL,N'HireCandidateRequest',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(985,NULL, NULL,N'HireCandidateRequest',N'GetWithOutSigById',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(986,NULL, NULL,N'HireCandidateRequest',N'CancelRequest',N'Post')
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1268,982,5152, 53)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1479,N'WorkFlow',N'HireCandidateRequestSignature',N'Index',0,N'get',15209)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1480,N'WorkFlow',N'HireCandidateRequestSignature',N'HireCandidateRequest_Read',0,N'post',15210)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1481,N'WorkFlow',N'HireCandidateRequestSignature',N'Save',2,N'get',15211)
Go

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

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1269, 9, 15210, 53)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1270, 10, 15210, 53)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1271, 8, 15211, 53)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) 
VALUES (1272, 13, 15212, 53)
GO
INSERT INTO SecurityUserDetail ( SecurityUserID,PrivilegeID, CreationDate, CreatedBy)
	  SELECT sec.SecurityUserID,5152, GETDATE(), 1
	  FROM SecurityUserDetail sec 
	WHERE  sec.PrivilegeID in
	(5135);
	Go
INSERT INTO SecurityGroupDetail( SecurityGroupID,PrivilegeID, CreationDate, CreatedBy)
    SELECT gr.SecurityGroupID,5152, GETDATE(), 1
    FROM SecurityGroupDetail gr 
	WHERE  gr.PrivilegeID in
	(5135);
Go


------------------------------------ End 2024-02-12 ------------------------------
------------------------------------ Ali 2024-02-12 ------------------------------

  INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode],[IsVisible])
  VALUES (41, N'Section Manager 2', N'مدير قسم 2', 1, NULL,1)
Go

ALTER TABLE dbo.Sections ADD
	ManagerCode2 int NULL
GO
------------------------------------ End 2024-02-12 ------------------------------

