﻿--------------------------------------- Ali  2023-05-29 ---------



ALTER TABLE dbo.Rec_RecruitJob ADD CONSTRAINT
	FK_Rec_RecruitJob_Positions FOREIGN KEY
	(
	PositionCode
	) REFERENCES dbo.Positions
	(
	PositionCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.Rec_RecruitJob ADD CONSTRAINT
	FK_Rec_RecruitJob_Rec_JobCategory FOREIGN KEY
	(
	JobCategoryCode
	) REFERENCES dbo.Rec_JobCategory
	(
	JobCategoryCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.Rec_RecruitJob ADD CONSTRAINT
	FK_Rec_RecruitJob_Rec_WorkSite FOREIGN KEY
	(
	WorkSiteCode
	) REFERENCES dbo.Rec_WorkSite
	(
	WorkSiteCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO


ALTER TABLE dbo.Rec_RecruitJob ADD CONSTRAINT
	FK_Rec_RecruitJob_Contract FOREIGN KEY
	(
	ContractCode
	) REFERENCES dbo.Contract
	(
	ContractCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO

--------------------------------------- End  2023-05-29 ---------
--------------------------------------- Hammad  2023-05-31---------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription])
VALUES (N'AppCalculationAttendancePoints', N'Calculation Attendance Points one time not a number', N'إحتساب نقاط الحضور والانصراف بالمرة الواحدة', N'false', 10, 25, 1, 1, NULL, NULL, NULL, N'إحتساب نقاط الحضور والانصراف بالمرة الواحدة')
GO

--------------------------------------- End  2023-05-31 ---------
--------------------------------------- Hammad  2023-06-06 ------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES (661, N' Vaction Due', N' أرصدة الإجازات', 485, N'/NotificationService/EmailVactionDue', N'Index', N'fa fa-thumb-tack', N'get', 2, 1, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (16031, N' أرصدة الإجازات', N'Vaction Due', 661, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (16032, N'عرض  أرصدة الإجازات', N'View Vaction Due', 661, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (16033, N'إضافة  أرصدة الإجازات', N'Add Vaction Due  ', 661, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (16034, N'تعديل  أرصدة الإجازات', N'Edit Vaction Due', 661, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (16035, N'حفظ  أرصدة الإجازات', N'Save Vaction Due', 661, 2)


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1082, N'NotificationService', N'EmailVactionDue', N'Index', 0, N'get', 16031)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1083, N'NotificationService', N'EmailVactionDue', N'EmailVactionDue_Read', 0, N'post', 16032)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1084, N'NotificationService', N'EmailVactionDue', N'Save', 2, N'get', 16033)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1085, N'NotificationService', N'EmailVactionDue', N'Save', 0, N'post', 16034)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1086, N'NotificationService', N'EmailVactionDue', N'Delete', 0, N'post', 16035)
GO


INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (661, 13)



CREATE TABLE [dbo].[NotifVactionDue](
	[NotifVactionDueCode] [int] IDENTITY(1,1) NOT NULL,
	[PYear] [smallint] NOT NULL,
	[Period] [tinyint] NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
	[SectionCode] [nvarchar](max) NULL,
	[MDT] [datetime] NULL,
	[Status] [tinyint] NULL,
	[ConPeriod] [tinyint] NOT NULL,
 CONSTRAINT [PK_NotifVactionDue] PRIMARY KEY CLUSTERED 
(
	[NotifVactionDueCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[NotifVactionDue]  WITH CHECK ADD  CONSTRAINT [FK_NotifVactionDue_ConPeriod] FOREIGN KEY([ConPeriod])
REFERENCES [dbo].[Periods] ([Period])
GO

ALTER TABLE [dbo].[NotifVactionDue] CHECK CONSTRAINT [FK_NotifVactionDue_ConPeriod]
GO

ALTER TABLE [dbo].[NotifVactionDue]  WITH CHECK ADD  CONSTRAINT [FK_NotifVactionDue_CreatedBy] FOREIGN KEY([CreatedBy])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[NotifVactionDue] CHECK CONSTRAINT [FK_NotifVactionDue_CreatedBy]
GO

ALTER TABLE [dbo].[NotifVactionDue]  WITH CHECK ADD  CONSTRAINT [FK_NotifVactionDue_ModifiedBy] FOREIGN KEY([ModifiedBy])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[NotifVactionDue] CHECK CONSTRAINT [FK_NotifVactionDue_ModifiedBy]
GO

ALTER TABLE [dbo].[NotifVactionDue]  WITH CHECK ADD  CONSTRAINT [FK_NotifVactionDue_Periods] FOREIGN KEY([Period])
REFERENCES [dbo].[Periods] ([Period])
GO

ALTER TABLE [dbo].[NotifVactionDue] CHECK CONSTRAINT [FK_NotifVactionDue_Periods]
GO




CREATE TABLE [dbo].[NotifVactionDueDetail](
	[NotifVactionDueDetailCode] [int] IDENTITY(1,1) NOT NULL,
	[NotifVactionDueCode] [int] NOT NULL,
	[EmployeeCode] [int] NOT NULL,
	[EMail] [varchar](250) NULL,
	[IsSent] [bit] NOT NULL,
	[SentDate] [datetime] NULL,
	[Reason] [nvarchar](max) NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_NotifVactionDueDetail] PRIMARY KEY CLUSTERED 
(
	[NotifVactionDueDetailCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[NotifVactionDueDetail]  WITH CHECK ADD  CONSTRAINT [FK_NotifVactionDueDetail_Employees] FOREIGN KEY([EmployeeCode])
REFERENCES [dbo].[Employees] ([EmployeeCode])
GO

ALTER TABLE [dbo].[NotifVactionDueDetail] CHECK CONSTRAINT [FK_NotifVactionDueDetail_Employees]
GO

ALTER TABLE [dbo].[NotifVactionDueDetail]  WITH CHECK ADD  CONSTRAINT [FK_NotifVactionDueDetail_NotifVactionDue] FOREIGN KEY([NotifVactionDueCode])
REFERENCES [dbo].[NotifVactionDue] ([NotifVactionDueCode])
GO

ALTER TABLE [dbo].[NotifVactionDueDetail] CHECK CONSTRAINT [FK_NotifVactionDueDetail_NotifVactionDue]
GO




CREATE TABLE [dbo].[EmployeesFlags](
	[EmployeeCode] [int] NOT NULL,
	[IgnoreCostCenterdifferent] [bit] NULL,
	[StopPrivateTimePermissions] [bit] NULL,
	[NotApplicableToConvertToAbsentOption] [bit] NULL,
	[MDT] [datetime] NULL,
	[StopUpdateOtherSystem] [bit] NULL,
	[OutofSymbioticContribution] [bit] NULL,
	[NotApplicableToConvertToAbsentOptionOneTime] [bit] NULL,
	[CovertTimeOutToTimeIn] [bit] NULL,
	[HeHasNoRightToReceiveVacationsBalancesReport] [bit] NULL,
 CONSTRAINT [PK_EmployeesFlags] PRIMARY KEY CLUSTERED 
(
	[EmployeeCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[EmployeesFlags] ADD  CONSTRAINT [DF_EmployeesFlags_IgnoreCostCenterdifferent]  DEFAULT ((0)) FOR [IgnoreCostCenterdifferent]
GO

ALTER TABLE [dbo].[EmployeesFlags] ADD  CONSTRAINT [DF_EmployeesFlags_StopPrivateTimePermissions]  DEFAULT ((0)) FOR [StopPrivateTimePermissions]
GO

ALTER TABLE [dbo].[EmployeesFlags] ADD  CONSTRAINT [DF_EmployeesFlags_NotApplicableToConvertToAbsentOption]  DEFAULT ((0)) FOR [NotApplicableToConvertToAbsentOption]
GO

ALTER TABLE [dbo].[EmployeesFlags] ADD  CONSTRAINT [DF_EmployeesFlags_StopUpdateOtherSystem]  DEFAULT ((0)) FOR [StopUpdateOtherSystem]
GO

ALTER TABLE [dbo].[EmployeesFlags] ADD  CONSTRAINT [DF_EmployeesFlags_OutofSymbioticContribution]  DEFAULT ((0)) FOR [OutofSymbioticContribution]
GO

ALTER TABLE [dbo].[EmployeesFlags] ADD  CONSTRAINT [DF_EmployeesFlags_NotApplicableToConvertToAbsentOptionOneTime]  DEFAULT ((0)) FOR [NotApplicableToConvertToAbsentOptionOneTime]
GO

ALTER TABLE [dbo].[EmployeesFlags] ADD  CONSTRAINT [DF_EmployeesFlags_CovertTimeOutToTimeIn]  DEFAULT ((0)) FOR [CovertTimeOutToTimeIn]
GO




--------------------------------------- End  2023-06-06 ------
--------------------------------------- MahmoudNegm   2023-06-07 ------
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (663, NULL, NULL, N'JobOfferParameter', N'SortingJobGroupParameter_Read', N'post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (664, NULL, NULL, N'JobOfferParameter', N'UpdateSorting', N'post')
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (861, 663, 5081, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (862, 664, 5084, NULL)
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (5035, N'نماذج الأسئلة', N'Questions Templates', 58, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (5036, N'عرض نماذج الأسئلة', N'View Questions Templates', 58, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (5037, N'إضافة نماذج الأسئلة', N'Add Questions Templates', 58, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (5038, N'تعديل نماذج الأسئلة', N'Edit Questions Templates', 58, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (5039, N'حذف نماذج الأسئلة', N'Delete Questions Templates', 58, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (5040, N'حفظ نماذج الأسئلة', N'Save Questions Templates', 58, 2)
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (665, NULL, NULL, N'QuestionTemplate', N'GetQuestionTemplates', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (666, NULL, NULL, N'QuestionTemplate', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (667, NULL, NULL, N'QuestionTemplate', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (668, NULL, NULL, N'QuestionTemplate', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (669, NULL, NULL, N'QuestionTemplate', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (670, NULL, NULL, N'QuestionTemplate', N'GetQuestionTemplatesSearch', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (671, NULL, NULL, N'QuestionTemplate', N'CanRemoveQuestionTemplate', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (672, NULL, NULL, N'QuestionTemplate', N'GetDefaultQuestionsForJob', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (673, NULL, NULL, N'QuestionTemplate', N'GetClosedQuestion', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (674, NULL, NULL, N'QuestionTemplate', N'AddClosedQuestion', N'post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (675, NULL, NULL, N'QuestionTemplate', N'EditClosedQuestion', N'post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (676, NULL, NULL, N'QuestionTemplate', N'GetNumRangeQuestion', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (677, NULL, NULL, N'QuestionTemplate', N'AddNumRangeQuestion', N'post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (678, NULL, NULL, N'QuestionTemplate', N'EditNumRangeQuestion', N'post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (679, NULL, NULL, N'QuestionTemplate', N'GetDateRangeQuestion', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (680, NULL, NULL, N'QuestionTemplate', N'AddDateRangeQuestion', N'post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (681, NULL, NULL, N'QuestionTemplate', N'EditDateRangeQuestion', N'post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (682, NULL, NULL, N'QuestionTemplate', N'GetMultiChoiceQuestion', N'get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (683, NULL, NULL, N'QuestionTemplate', N'AddMultiChoiceQuestion', N'post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (684, NULL, NULL, N'QuestionTemplate', N'EditMultiChoiceQuestion', N'post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (685, NULL, NULL, N'QuestionTemplate', N'GetOpenQuestion', N'get')
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (863, 665, 5036, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (864, 666, 5038, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (865, 667, 5040, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (866, 668, 5040, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (867, 669, 5039, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (868, 670, 5036, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (869, 671, 5036, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (870, 672, 5036, NULL)


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (871, 673, 5038, NULL)
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (872, 674, 5040, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (873, 675, 5040, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (874, 676, 5038, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (875, 677, 5040, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (876, 678, 5040, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (877, 679, 5038, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (878, 680, 5040, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (879, 681, 5040, NULL)
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (880, 682, 5038, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (881, 683, 5040, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (882, 684, 5040, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (883, 685, 5038, NULL)
GO


INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (686, NULL, NULL, N'JobCategory', N'GetJobCategory', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (687, NULL, NULL, N'JobCategory', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (689, NULL, NULL, N'JobCategory', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (690, NULL, NULL, N'JobCategory', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (691, NULL, NULL, N'JobCategory', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (692, NULL, NULL, N'JobCategory', N'GetJobCategorySearch', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (884, 686, 5003, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (885, 687, 5005, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (886, 689, 5007, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (887, 690, 5007, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (888, 691, 5006, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (889, 692, 5003, NULL)
GO




INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (693, NULL, NULL, N'VisaStatus', N'GetVisaStatus', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (694, NULL, NULL, N'VisaStatus', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (695, NULL, NULL, N'VisaStatus', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (696, NULL, NULL, N'VisaStatus', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (697, NULL, NULL, N'VisaStatus', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (698, NULL, NULL, N'VisaStatus', N'GetVisaStatusSearch', N'Post')

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (890, 693, 5012, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (891, 694, 5014, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (892, 695, 5016, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (893, 696, 5016, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (894, 697, 5015, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (895, 698, 5012, NULL)
GO



INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (699, NULL, NULL, N'CompanyDomain', N'GetCompanyDomains', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (700, NULL, NULL, N'CompanyDomain', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (701, NULL, NULL, N'CompanyDomain', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (702, NULL, NULL, N'CompanyDomain', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (703, NULL, NULL, N'CompanyDomain', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (704, NULL, NULL, N'CompanyDomain', N'GetCompanyDomainSearch', N'Post')
GO


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (895, 699, 5018, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (896, 700, 5020, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (897, 701, 5022, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (898, 702, 5022, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (899, 703, 5021, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (900, 704, 5018, NULL)
GO



INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (706, NULL, NULL, N'CompanySize', N'GetCompanySizes', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (707, NULL, NULL, N'CompanySize', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (708, NULL, NULL, N'CompanySize', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (709, NULL, NULL, N'CompanySize', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (710, NULL, NULL, N'CompanySize', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (711, NULL, NULL, N'CompanySize', N'GetCompanySizeSearch', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (901, 706, 5024, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (902, 707, 5026, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (903, 708, 5028, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (904, 709, 5028, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (905, 710, 5027, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (906, 711, 5024, NULL)
GO







INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (712, NULL, NULL, N'WorkSite', N'GetWorkSite', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (713, NULL, NULL, N'WorkSite', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (714, NULL, NULL, N'WorkSite', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (715, NULL, NULL, N'WorkSite', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (716, NULL, NULL, N'WorkSite', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (717, NULL, NULL, N'WorkSite', N'GetWorkSiteSearch', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (718, NULL, NULL, N'WorkSite', N'GetWorkSiteList', N'Get')
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (907, 712, 5030, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (908, 713, 5032, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (909, 714, 5034, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (910, 715, 5034, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (911, 716, 5033, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (912, 717, 5030, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (913, 718, 5030, NULL)
GO





INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (719, NULL, NULL, N'JobApplySteps', N'GetPersonalInterviewStagess', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (720, NULL, NULL, N'JobApplySteps', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (721, NULL, NULL, N'JobApplySteps', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (722, NULL, NULL, N'JobApplySteps', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (723, NULL, NULL, N'JobApplySteps', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (724, NULL, NULL, N'JobApplySteps', N'GetPersonalInterviewStagessSearch', N'Post')
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (914, 719, 5057, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (915, 720, 5061, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (916, 721, 5059, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (917, 722, 5059, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (918, 723, 5062, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (919, 724, 5058, NULL)
GO



INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (725, NULL, NULL, N'JobRole', N'GetJobRole', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (726, NULL, NULL, N'JobRole', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (727, NULL, NULL, N'JobRole', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (728, NULL, NULL, N'JobRole', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (729, NULL, NULL, N'JobRole', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (730, NULL, NULL, N'JobRole', N'GetJobRoleSearch', N'Post')
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (920, 725, 5088, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (921, 726, 5090, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (922, 727, 5091, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (923, 728, 5091, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (924, 729, 5092, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (925, 730, 5088, NULL)
GO






INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (731, NULL, NULL, N'JobType', N'GetJobType', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (732, NULL, NULL, N'JobType', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (733, NULL, NULL, N'JobType', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (734, NULL, NULL, N'JobType', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (735, NULL, NULL, N'JobType', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (736, NULL, NULL, N'JobType', N'GetJobTypeSearch', N'Post')
GO


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (926, 731, 5094, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (927, 732, 5096, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (928, 733, 5097, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (929, 734, 5097, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (930, 735, 5098, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (931, 736, 5094, NULL)
GO




INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (737, NULL, NULL, N'RejectHiring', N'GetReasonsRejectHirings', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (738, NULL, NULL, N'RejectHiring', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (739, NULL, NULL, N'RejectHiring', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (740, NULL, NULL, N'RejectHiring', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (741, NULL, NULL, N'RejectHiring', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (742, NULL, NULL, N'RejectHiring', N'GetReasonsRejectHiringsSearch', N'Post')
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (932, 737, 5102, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (933, 738, 5104, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (934, 739, 5106, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (935, 740, 5106, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (936, 741, 5105, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (937, 742, 5102, NULL)

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (743, NULL, NULL, N'EvaluationParameter', N'GetEvaluationParameters', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (744, NULL, NULL, N'EvaluationParameter', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (745, NULL, NULL, N'EvaluationParameter', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (746, NULL, NULL, N'EvaluationParameter', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (747, NULL, NULL, N'EvaluationParameter', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (748, NULL, NULL, N'EvaluationParameter', N'GetEvaluationParameterSearch', N'Post')
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (938, 743, 5108, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (939, 744, 5110, NULL)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (940, 745, 5111, NULL)
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (941, 746, 5111, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (942, 747, 5112, NULL)
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (943, 748, 5108, NULL)

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (749, NULL, NULL, N'Endorsement', N'GetFirstEndorsement', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (750, NULL, NULL, N'Endorsement', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (751, NULL, NULL, N'Endorsement', N'Post', N'post')
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (944, 749, 5131, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (945, 750, 5132, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (946, 751, 5132, NULL)
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (752, NULL, NULL, N'RecruitRequiredFile', N'GetRecruitRequiredFiless', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (753, NULL, NULL, N'RecruitRequiredFile', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (754, NULL, NULL, N'RecruitRequiredFile', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (755, NULL, NULL, N'RecruitRequiredFile', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (756, NULL, NULL, N'RecruitRequiredFile', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (757, NULL, NULL, N'RecruitRequiredFile', N'GetRecruitRequiredFilesSearch', N'Post')
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (947, 752, 5137, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (948, 753, 5139, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (949, 754, 5141, NULL)
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (950, 755, 5141, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (951, 756, 5140, NULL)
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] 
([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (952, 757, 5137, NULL)
--------------------------------------- End  2023-06-07 ------
--------------------------------------- Hammad  2023-06-07 ------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription])
VALUES (N'RecOnlineRecruitmentLink', N'Online Recruitment Link', N'   رابط التوظيف عبر الإنترنت', N'', 14, 26, 4, 1, NULL, NULL, NULL, N' رابط التوظيف عبر الإنترنت')
GO
--------------------------------------- End  2023-06-07 ------
--------------------------------------- Hammad  2023-06-08 ------
INSERT INTO [SST.ERP_Client]. [dbo].[APIs] ([ApiId], [ApiName]) VALUES (10, N'Recruitment')
Go
--------------------------------------- End  2023-06-08 ------
