﻿ ---------------------Ali 2022-02-08-----

 ALTER procedure [dbo].[Emp_GetEmployeeProfile] 
(
@userCode	int
)
AS


SELECT  
e.[EmployeeCode]
,e.[Name]
,e.[Arabic_Name]
,[Sex]
,[BirthDate]
,[BirthCityCode]
,[BirthDestination]
,[BirthDestinationArabic]
          
,[LokerNumber]
,[IDTypeCode]
,[IdIssueFrom]
,[IdIssueFromArabic]
,[IdNumber]
,[IDpolice_station]
,[IdCityCode]
,[IdIssueDate]
,[IdExpireDate]
     
,[Children_Number]
     
,[HiringDate]
,[ContractDate]
,[ContractExpireDate]    
     
,[InsuranceNumber]
,e.[ReligionCode]      
    
,[ResignationCode]
,[ResignationDate]     
,[Active]
   
,[CityCode]
,[EngFullAddress]
,[ArabicFullAddress]
,[OldFullAddress]    
,[Police_Station]
,[EngArea]
,[EngPolice_Station]
     
,[MotherName]
,e.[Telephone]
,[Mobile]
,e.[EMail]
,[CurrPercent]
,[Hidden]
,[Transfer]
,[VacationCalcCode]
,[DayRate]
,[WorkHoures]     
,[RoomNumber]     
,[BasicSalary]
    
,[StopSalaryReason]
,[NotApplicableToTransportationAllowance]
,[StopSalary]
,[ResignationPostingDate]
       
,[EmployeeType]
,[BirthDateHijri]
,[ContractDateHijri]
,[ContractExpireDateHijri]
,[HiringDateHijri]
,[ProbationDate]
,[ProbationDateHijri]
,[ExperienceDateHijri]
,[LastWageHijri]
,[InsureDateHijri]
,[ResignationDateHijri]
,[ResignationPostingDateHijri]
      
,dbo.Location.[Name] LocationNameEn
,dbo.Location.[Arabic_Name] LocationNameAr	
,dbo.SocialInsurance.[BasicEmployeeShare]
,dbo.SocialInsurance.[BasicCompanyShare]
,dbo.SocialInsurance.[VariableEmployeeShare]
,dbo.SocialInsurance.[VariableCompanyShare]
,dbo.SocialInsurance.[InsuranceDate]
,dbo.SocialInsurance.[InsuranceDateHijri]
,dbo.SocialInsurance.MaxBasic

,dbo.Insurer.[Name] as InsurerNameEn
,dbo.Insurer.[Arabic_Name] as InsurerNameAr
,dbo.InsuranceTypes.[Name] as InsuranceTypesNameEn
,dbo.InsuranceTypes.[Arabic_Name] as InsuranceTypesNameAr
,dbo.Sections.Name SectionsNameEn
,dbo.Sections.Arabic_Name SectionsNameAr
,dbo.Departments.Name DepartmentsNameEn
,dbo.Departments.Arabic_Name DepartmentsNameAr
,dbo.Divisions.Name DivisionsNameEn
,dbo.Divisions.Arabic_Name DivisionsNameAr
,dbo.Org4.Name Org4NameEn
,dbo.Org4.Arabic_Name Org4NameAr
,dbo.Org5.Name Org5NameEn
,dbo.Org5.Arabic_Name Org5NameAr
,dbo.Nationality.[Name] NationalityNameEn
,dbo.Nationality.[Arabic_Name] NationalityNameAr
,dbo.Nationality.[CountryName]
,dbo.Nationality.[CountryArabic_Name]
,dbo.MaritalStatus.[Name] MaritalStatusNameEn
,dbo.MaritalStatus.[Arabic_Name] MaritalStatusNameAr
,dbo.EmployeeEducationData.[EducationDescription]
,dbo.[Contract].[Name] ContractNameEn
,dbo.[Contract].[Arabic_Name] ContractNameAr
,dbo.[Currencies].[Name] CurrenciesNameEn
,dbo.[Currencies].[Arabic_Name] CurrenciesNameAr
,dbo.Levels.Name LevelsNameEn
,dbo.Levels.Arabic_Name LevelsNameAr
,dbo.Positions.Name PositionsNameEn
,dbo.Positions.Arabic_Name PositionsNameAr
,dbo.[GeneralTypes].[Name] GeneralTypesNameEn
,dbo.[GeneralTypes].[Arabic_Name] GeneralTypesNameAr
,UserImage
,RecieveEmailNotifications
,UserName



,dbo.EmployeesExtend.[IssuePlace] as EmpExtendIssuePlace
,dbo.EmployeesExtend.[CardNumber] as  EmpExtendCardNumber
,dbo.EmployeesExtend.[IssueDate] as EmpExtendIssueDate
,dbo.EmployeesExtend.[IssueDateHijri] as EmpExtendIssueDateHijri
,dbo.EmployeesExtend.[ExpireDate] as EmpExtendExpireDate
,dbo.EmployeesExtend.[ExpireDateHijri] as EmpExtendExpireDateHijri
,dbo.EmployeesExtend.ExtensionNumber
,dbo.EmployeesExtend.EMail2 

,dbo.[HealthInsuranceTypes].[Name] as MedicalInsuranceTypeNameEn
,dbo.[HealthInsuranceTypes].[Arabic_Name] as MedicalInsuranceTypeNameAr
	

   
FROM [dbo].[SecurityUser]

left join [dbo].[Employees] e on [dbo].SecurityUser.[EmployeeCode] = e.EmployeeCode
left join [dbo].[Location] on [dbo].Location.[LocationCode] = e.LocationCode
left join [dbo].[SocialInsurance] on [dbo].SocialInsurance.[EmployeeCode] = e.EmployeeCode
left join [dbo].[Insurer] on [dbo].Insurer.[InsurerCode] = [dbo].SocialInsurance.[InsurerCode]
left join [dbo].[InsuranceTypes] on [dbo].InsuranceTypes.InsuranceCode = e.InsuranceCode
left join [dbo].[Sections] on [dbo].Sections.SectionCode = e.SectionCode
left join [dbo].[Departments] on [dbo].Departments.DepartmentCode = [dbo].Sections.DepartmentCode
left join [dbo].Divisions on [dbo].Divisions.DivisionCode = [dbo].Departments.DivisionCode
left join [dbo].Org4 on [dbo].Org4.Org4Code = [dbo].Divisions.FatherCode
left join [dbo].Org5 on [dbo].Org5.Org5Code = [dbo].Org4.FatherCode
left join [dbo].[Nationality] on [dbo].Nationality.[NationalityCode] = e.NationalityCode
left join [dbo].[MaritalStatus] on [dbo].MaritalStatus.[MaritalCode] = e.MaritalCode
left join [dbo].[EmployeeEducationData] on [dbo].EmployeeEducationData.[EmployeeCode] = e.EmployeeCode
left join [dbo].[Contract] on [dbo].[Contract].[ContractCode] = e.ContractCode
left join [dbo].[Currencies] on [dbo].[Currencies].CurrencyCode = e.CurrencyCode
left join [dbo].[Levels] on [dbo].Levels.LevelCode = e.LevelCode
left join [dbo].[GeneralTypes] on [dbo].GeneralTypes.[GeneralTypeCode] = e.GeneralTypeCode
left join [dbo].[Positions] on [dbo].Positions.PositionCode = e.PositionCode

left join [dbo].[EmployeesExtend] on [dbo].EmployeesExtend.[EmployeeExtendCode] = e.EmployeeCode
left join [dbo].[HealthInsuranceTypes] on [dbo].HealthInsuranceTypes.HealthInsuranceTypeCode = [dbo].[EmployeesExtend].HealthInsuranceTypeCode

where [dbo].[SecurityUser].[EmployeeCode] = @userCode;
GO
 ---------------------End 2022-02-08-----
 ---------------------Ali 2022-02-09-----
CREATE TABLE [dbo].[SecurityPrivilegeActionsApi](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[AreaName] [nvarchar](50) NULL,
	[ControllerName] [nvarchar](50) NOT NULL,
	[ActionName] [nvarchar](250) NOT NULL,
	[HTTPMethod] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_SecurityPrivilegeActionsApi] PRIMARY KEY CLUSTERED 
(
	[ID] 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

CREATE TABLE [dbo].[SecurityPrivilegeActionDetail](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[SecurityPrivilegeActionId] [int] NOT NULL,
	[SecurityPrivilegeID] [int] NOT NULL,
	[RequestTypeId] [int] NULL,
 CONSTRAINT [PK_SecurityPrivilegeActionDetail] PRIMARY KEY CLUSTERED 
(
	[ID] 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].[SecurityPrivilegeActionDetail]  WITH CHECK ADD  CONSTRAINT [FK_SecurityPrivilegeActionDetail_SecurityPrivilege] FOREIGN KEY([SecurityPrivilegeID])
REFERENCES [dbo].[SecurityPrivilege] ([ID])
GO

ALTER TABLE [dbo].[SecurityPrivilegeActionDetail] CHECK CONSTRAINT [FK_SecurityPrivilegeActionDetail_SecurityPrivilege]
GO

ALTER TABLE [dbo].[SecurityPrivilegeActionDetail]  WITH CHECK ADD  CONSTRAINT [FK_SecurityPrivilegeActionDetail_SecurityPrivilegeActionsApi] FOREIGN KEY([SecurityPrivilegeActionId])
REFERENCES [dbo].[SecurityPrivilegeActionsApi] ([ID])
GO

ALTER TABLE [dbo].[SecurityPrivilegeActionDetail] CHECK CONSTRAINT [FK_SecurityPrivilegeActionDetail_SecurityPrivilegeActionsApi]
GO
 ---------------------End 2022-02-09-----
---------------------AK 2022-02-13----- 
ALTER TABLE [dbo].[FingerAreaCheckPointLogs] ADD Latitude float NOT NULL
GO
ALTER TABLE [dbo].[FingerAreaCheckPointLogs] ADD Longitude float NOT NULL
GO
 ---------------------End 2022-02-13-----

 
  ---------------------Mostafa 2022-02-13-----

SET IDENTITY_INSERT [dbo].[AppModule] ON  
INSERT [dbo].[AppModule] ([AppModuleCode], [Name], [Arabic_Name], [IsLicensed], [LicenseNumber]) VALUES (18, N'Generl Ledger', N'الحسابات العامة', 1, NULL)
SET IDENTITY_INSERT [dbo].[AppModule] OFF
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(583,N'Generl Ledger',N'الحسابات العامة',null,N'',N'','fa fa-thumb-tack',N'get',18,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(583,18)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(584,N'Basic Data',N'البيانات الاساسية',583,N'',N'','fa fa-thumb-tack',N'',1,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(584,18)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(585,N'Cost Centers Chart',N' مراكز التكلفة',584,N'/GenerlLedger/CostCenterChart',N'index','fa fa-thumb-tack',N'get',1,1,1)
Go


INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(585,18)
Go


INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23000,N' مركز التكلفة',N'Cost Center Chart',585,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23001,N'عرض  مركز التكلفة',N'View Cost Center Chart',585,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23002,N'إضافة  مركز التكلفة',N'Add Cost Center Chart',585,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23003,N'تعديل  مركز التكلفة',N'Edit Cost Center Chart',585,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23004,N'حذف  مركز التكلفة',N'Delete Cost Center Chart',585,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23005,N'حفظ  مركز التكلفة',N'Save Cost Center Chart',585,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(952,N'GenerlLedger',N'CostCenterChart',N'Index',0,N'get',23000)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(953,N'GenerlLedger',N'CostCenterChart',N'CostCenterChart_Read',0,N'post',23001)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(954,N'GenerlLedger',N'CostCenterChart',N'Save',1,N'get',23002)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(955,N'GenerlLedger',N'CostCenterChart',N'Save',2,N'get',23003)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(956,N'GenerlLedger',N'CostCenterChart',N'Delete',0,N'post',23004)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(957,N'GenerlLedger',N'CostCenterChart',N'Save',0,N'post',23005)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23006,N'الحسابات العامة',N'Generl Ledger ',583,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23007,N' البيانات الاساسية',N' Basic Data Generl Ledger ',584,1)

GO

   ---------------------End 2022-02-13-----
   ---------------------Hammad 2022-02-14--
   
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(586,N'Accounts Chart',N'دليل الحسابات',584,N'/GenerlLedger/AccountsChart',N'Index','fa fa-thumb-tack',N'get',2,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(586,18)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23008,N' دليل الحسابات',N'Accounts Chart',586,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23009,N'عرض  دليل الحسابات',N'View Accounts Chart',586,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23010,N'إضافة  دليل الحسابات',N'Add Accounts Chart',586,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23011,N'تعديل  دليل الحسابات',N'Edit Accounts Chart',586,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23012,N'حذف  دليل الحسابات',N'Delete Accounts Chart',586,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23013,N'حفظ  دليل الحسابات',N'Save Accounts Chart',586,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(958,N'GenerlLedger',N'AccountsChart',N'Index',0,N'get',23008)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(959,N'GenerlLedger',N'AccountsChart',N'AccountsChart_Read',0,N'post',23009)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(960,N'GenerlLedger',N'AccountsChart',N'Save',1,N'get',23010)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(961,N'GenerlLedger',N'AccountsChart',N'Save',2,N'get',23011)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(962,N'GenerlLedger',N'AccountsChart',N'Delete',0,N'post',23012)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(963,N'GenerlLedger',N'AccountsChart',N'Save',0,N'post',23013)
Go
   ---------------------End 2022-02-14--
   ---------------------Ali 2022-02-14--

    update [SecurityPrivilegeActions] set HTTPMethod= N'post' where ID=878
	Go

	SET IDENTITY_INSERT [dbo].[SecurityPrivilegeActionsApi] ON 

INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (1, NULL, N'BackToWorkRequest', N'SearchBackToWorkRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (2, NULL, N'BackToWorkRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (3, NULL, N'BackToWorkRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (4, NULL, N'BackToWorkRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (5, NULL, N'BackToWorkRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (6, NULL, N'BackToWorkRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (7, NULL, N'BackToWorkRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (8, NULL, N'MasterRequestsSignatures', N'GetSignatureById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (9, NULL, N'MasterRequestsSignatures', N'GetMasterRequestsSignatures', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (10, NULL, N'MasterRequestsSignatures', N'GetRequestSignaturesByUser', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (11, NULL, N'MasterRequestsSignatures', N'GetRequestHistory', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (12, NULL, N'MasterRequestsSignatures', N'CancelRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (13, NULL, N'MasterRequestsSignatures', N'SaveSignature', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (14, NULL, N'IntroductionLetterRequest', N'SearchIntroductionletterRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (15, NULL, N'IntroductionLetterRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (16, NULL, N'IntroductionLetterRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (17, NULL, N'IntroductionLetterRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (18, NULL, N'IntroductionLetterRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (19, NULL, N'IntroductionLetterRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (20, NULL, N'IntroductionLetterRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (21, NULL, N'MedicalInquiryRequest', N'SearchMedicalInquiryRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (22, NULL, N'MedicalInquiryRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (23, NULL, N'MedicalInquiryRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (24, NULL, N'MedicalInquiryRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (25, NULL, N'MedicalInquiryRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (26, NULL, N'MedicalInquiryRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (27, NULL, N'MedicalInquiryRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (28, NULL, N'PrintBusinessCardRequest', N'SearchPrintBusinessCardRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (29, NULL, N'PrintBusinessCardRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (30, NULL, N'PrintBusinessCardRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (31, NULL, N'PrintBusinessCardRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (32, NULL, N'PrintBusinessCardRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (33, NULL, N'PrintBusinessCardRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (34, NULL, N'PrintBusinessCardRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (35, NULL, N'ReimbursementRequest', N'SearchReimbursementRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (36, NULL, N'ReimbursementRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (37, NULL, N'ReimbursementRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (38, NULL, N'ReimbursementRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (39, NULL, N'ReimbursementRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (40, NULL, N'ReimbursementRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (41, NULL, N'ReimbursementRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (42, NULL, N'NewSectionDepartRequest', N'SearchNewSectionDepartRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (43, NULL, N'NewSectionDepartRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (44, NULL, N'NewSectionDepartRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (45, NULL, N'NewSectionDepartRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (46, NULL, N'NewSectionDepartRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (47, NULL, N'NewSectionDepartRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (48, NULL, N'NewSectionDepartRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (49, NULL, N'ScholarshipRequest', N'SearchScholarshipRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (50, NULL, N'ScholarshipRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (51, NULL, N'ScholarshipRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (52, NULL, N'ScholarshipRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (53, NULL, N'ScholarshipRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (54, NULL, N'ScholarshipRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (55, NULL, N'ScholarshipRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (56, NULL, N'TimeSheetRequest', N'SearchTimeSheetRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (57, NULL, N'TimeSheetRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (58, NULL, N'TimeSheetRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (59, NULL, N'TimeSheetRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (60, NULL, N'TimeSheetRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (61, NULL, N'TimeSheetRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (62, NULL, N'TimeSheetRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (63, NULL, N'MedicalInsuranceRequest', N'SearchMedicalInsuranceRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (64, NULL, N'MedicalInsuranceRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (65, NULL, N'MedicalInsuranceRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (66, NULL, N'MedicalInsuranceRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (67, NULL, N'MedicalInsuranceRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (68, NULL, N'MedicalInsuranceRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (69, NULL, N'MedicalInsuranceRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (70, NULL, N'MedicalInsuranceRequest', N'SearchMedicalInsuranceRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (71, NULL, N'MedicalInsuranceRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (72, NULL, N'MedicalInsuranceRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (73, NULL, N'MedicalInsuranceRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (74, NULL, N'MedicalInsuranceRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (75, NULL, N'MedicalInsuranceRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (76, NULL, N'MedicalInsuranceRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (77, NULL, N'AcademicResearchProfileRequest', N'SearchAcademicResearchProfileRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (78, NULL, N'AcademicResearchProfileRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (79, NULL, N'AcademicResearchProfileRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (80, NULL, N'AcademicResearchProfileRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (81, NULL, N'AcademicResearchProfileRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (82, NULL, N'AcademicResearchProfileRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (83, NULL, N'AcademicResearchProfileRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (84, NULL, N'AcademicAwardRequest', N'SearchAcademicAwardRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (85, NULL, N'AcademicAwardRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (86, NULL, N'AcademicAwardRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (87, NULL, N'AcademicAwardRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (88, NULL, N'AcademicAwardRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (89, NULL, N'AcademicAwardRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (90, NULL, N'AcademicAwardRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (91, NULL, N'AcademicCoExtraCurricularActivityRequest', N'SearchAcademicCoExtraCurricularActivityRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (92, NULL, N'AcademicCoExtraCurricularActivityRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (93, NULL, N'AcademicCoExtraCurricularActivityRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (94, NULL, N'AcademicCoExtraCurricularActivityRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (95, NULL, N'AcademicCoExtraCurricularActivityRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (96, NULL, N'AcademicCoExtraCurricularActivityRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (97, NULL, N'AcademicCoExtraCurricularActivityRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (98, NULL, N'AcademicCommitteeRequest', N'SearchAcademicCommitteeRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (99, NULL, N'AcademicCommitteeRequest', N'GetDetails', N'Get')
GO

INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (100, NULL, N'AcademicCommitteeRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (101, NULL, N'AcademicCommitteeRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (102, NULL, N'AcademicCommitteeRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (103, NULL, N'AcademicCommitteeRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (104, NULL, N'AcademicCommitteeRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (105, NULL, N'AcademicPGSupervisionRequest', N'SearchAcademicPGSupervisionRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (106, NULL, N'AcademicPGSupervisionRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (107, NULL, N'AcademicPGSupervisionRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (108, NULL, N'AcademicPGSupervisionRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (109, NULL, N'AcademicPGSupervisionRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (110, NULL, N'AcademicPGSupervisionRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (111, NULL, N'AcademicPGSupervisionRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (112, NULL, N'AcademicProfDevCommunityServiceRequest', N'SearchAcademicProfDevCommunityServiceRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (113, NULL, N'AcademicProfDevCommunityServiceRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (114, NULL, N'AcademicProfDevCommunityServiceRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (115, NULL, N'AcademicProfDevCommunityServiceRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (116, NULL, N'AcademicProfDevCommunityServiceRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (117, NULL, N'AcademicProfDevCommunityServiceRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (118, NULL, N'AcademicProfDevCommunityServiceRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (119, NULL, N'AcademicPublicationRequest', N'SearchAcademicPublicationRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (120, NULL, N'AcademicPublicationRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (121, NULL, N'AcademicPublicationRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (122, NULL, N'AcademicPublicationRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (123, NULL, N'AcademicPublicationRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (124, NULL, N'AcademicPublicationRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (125, NULL, N'AcademicPublicationRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (126, NULL, N'AcademicScientificActivityRequest', N'SearchAcademicScientificActivityRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (127, NULL, N'AcademicScientificActivityRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (128, NULL, N'AcademicScientificActivityRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (129, NULL, N'AcademicScientificActivityRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (130, NULL, N'AcademicScientificActivityRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (131, NULL, N'AcademicScientificActivityRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (132, NULL, N'AcademicScientificActivityRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (141, NULL, N'AcademicSponserRequest', N'SearchAcademicSponserRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (142, NULL, N'AcademicSponserRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (143, NULL, N'AcademicSponserRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (144, NULL, N'AcademicSponserRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (145, NULL, N'AcademicSponserRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (146, NULL, N'AcademicSponserRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (147, NULL, N'AcademicSponserRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (148, NULL, N'AcademicStructInstCapBuildExpansionRequest', N'SearchAcademicStructInstCapBuildExpansionRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (149, NULL, N'AcademicStructInstCapBuildExpansionRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (150, NULL, N'AcademicStructInstCapBuildExpansionRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (151, NULL, N'AcademicStructInstCapBuildExpansionRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (152, NULL, N'AcademicStructInstCapBuildExpansionRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (153, NULL, N'AcademicStructInstCapBuildExpansionRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (154, NULL, N'AcademicStructInstCapBuildExpansionRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (155, NULL, N'PurchasesRequest', N'SearchPurchasesRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (156, NULL, N'PurchasesRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (157, NULL, N'PurchasesRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (158, NULL, N'PurchasesRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (159, NULL, N'PurchasesRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (160, NULL, N'PurchasesRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (161, NULL, N'PurchasesRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (162, NULL, N'ConslidatedPurchasesRequest', N'SearchConslidatedPurchasesRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (163, NULL, N'ConslidatedPurchasesRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (164, NULL, N'ConslidatedPurchasesRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (165, NULL, N'ConslidatedPurchasesRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (166, NULL, N'ConslidatedPurchasesRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (167, NULL, N'ConslidatedPurchasesRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeActionsApi] ([ID], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (168, NULL, N'ConslidatedPurchasesRequest', N'Put', N'Put')
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeActionsApi] OFF
Go

GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeActionDetail] ON 

INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (1, 1, 15150, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (2, 2, 15150, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (3, 3, 15152, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (4, 4, 15152, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (5, 5, 15154, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (6, 6, 15154, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (7, 7, 15153, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (8, 8, 15158, 49)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (9, 9, 15158, 49)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (10, 10, 15157, 49)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (11, 11, 15161, 49)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (12, 12, 15155, 49)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (13, 13, 15159, 49)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (14, 14, 15165, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (15, 15, 15165, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (16, 16, 15167, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (17, 17, 15169, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (18, 18, 15169, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (19, 19, 15168, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (20, 20, 15167, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (21, 21, 15180, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (22, 22, 15180, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (23, 23, 15182, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (24, 24, 15182, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (25, 25, 15183, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (26, 26, 15184, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (27, 27, 15184, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (28, 28, 15135, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (29, 29, 15135, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (30, 30, 15137, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (31, 31, 15137, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (32, 32, 15138, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (33, 33, 15139, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (34, 34, 15139, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (35, 35, 15195, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (36, 36, 15195, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (37, 37, 15197, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (38, 38, 15197, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (39, 39, 15198, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (40, 40, 15199, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (41, 41, 15199, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (42, 42, 15060, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (43, 43, 15060, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (44, 44, 15062, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (45, 45, 15062, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (46, 46, 15063, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (47, 47, 15064, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (48, 48, 15064, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (49, 49, 15105, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (50, 50, 15105, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (51, 51, 15107, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (52, 52, 15107, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (53, 53, 15108, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (54, 54, 15109, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (55, 55, 15109, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (56, 56, 15268, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (57, 57, 15268, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (58, 58, 15270, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (59, 59, 15270, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (60, 60, 15271, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (61, 61, 15273, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (62, 62, 15273, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (63, 63, 15090, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (64, 64, 15090, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (65, 65, 15092, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (66, 66, 15092, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (67, 67, 15093, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (68, 68, 15094, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (69, 69, 15094, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (70, 70, 15120, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (71, 71, 15120, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (72, 72, 15122, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (73, 73, 15122, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (74, 74, 15123, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (75, 75, 15124, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (76, 76, 15124, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (77, 77, 3823, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (78, 78, 3823, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (79, 79, 3825, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (80, 80, 3825, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (81, 81, 3826, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (82, 82, 3827, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (83, 83, 3827, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (84, 84, 3905, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (85, 85, 3905, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (86, 86, 3907, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (87, 87, 3907, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (88, 88, 3908, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (89, 89, 3909, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (90, 90, 3909, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (91, 91, 3935, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (92, 92, 3935, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (93, 93, 3937, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (94, 94, 3937, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (95, 95, 3938, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (96, 96, 3939, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (97, 97, 3939, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (98, 98, 3868, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (99, 99, 3868, NULL)
GO
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (100, 100, 3870, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (101, 101, 3870, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (102, 102, 3871, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (103, 103, 3872, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (104, 104, 3872, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (105, 105, 3950, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (106, 106, 3950, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (107, 107, 3952, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (108, 108, 3952, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (109, 109, 3953, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (110, 110, 3954, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (111, 111, 3954, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (112, 112, 3890, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (113, 113, 3890, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (114, 114, 3892, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (115, 115, 3892, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (116, 116, 3893, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (117, 117, 3894, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (118, 118, 3894, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (119, 119, 3838, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (120, 120, 3838, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (121, 121, 3840, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (122, 122, 3840, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (123, 123, 3841, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (124, 124, 3842, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (125, 125, 3842, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (126, 126, 3853, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (127, 127, 3853, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (128, 128, 3855, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (129, 129, 3855, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (130, 130, 3856, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (131, 131, 3857, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (132, 132, 3857, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (141, 141, 3920, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (142, 142, 3920, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (143, 143, 3922, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (144, 144, 3922, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (145, 145, 3923, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (146, 146, 3924, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (147, 147, 3924, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (148, 148, 15007, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (149, 149, 15007, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (150, 150, 15009, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (151, 151, 15009, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (152, 152, 15010, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (153, 153, 15011, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (154, 154, 15011, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (155, 155, 3410, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (156, 156, 3410, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (157, 157, 3412, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (158, 158, 3412, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (159, 159, 3413, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (160, 160, 3414, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (161, 161, 3414, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (162, 162, 15283, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (163, 163, 15283, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (164, 164, 15285, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (165, 165, 15285, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (166, 166, 15286, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (167, 167, 15287, NULL)
INSERT [dbo].[SecurityPrivilegeActionDetail] ([ID], [SecurityPrivilegeActionId], [SecurityPrivilegeID], [RequestTypeId]) VALUES (168, 168, 15287, NULL)
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeActionDetail] OFF
Go
   ---------------------End 2022-02-14--
 
 ---------------------Ali 2022-02-15--

    update [SecurityPrivilegeActions] set [HTTPMethod] =N'post' , [ActionType]=0
  where ID=908
  Go

  INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (587, N'Sync Service', N'خدمة المزامنة', 17, N'/SyncServiceConfigParameter', N'Index', N'fa fa-thumb-tack', N'get', 6, 1, 1)
  Go

 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1303, N'خدمة المزامنة', N'Sync Service', 587, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1304, N'عرض خدمة المزامنة ', N'View Sync Service', 587, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1305, N'حفظ خدمة المزامنة ', N'Save Sync Service', 587, 2)
Go

 ---------------------End 2022-02-15--
 ---------------------Hammad 2022-02-15--
update SecurityPrivilegeActions set HTTPMethod='get' where ID=953
update SecurityPrivilegeActions set HTTPMethod='get' where ID=959
GO
 ---------------------End 2022-02-15------------------------------------
  ---------------------Ali 2022-02-17-----------------------------------

 ALTER TABLE [SST.ERP_Client].dbo.Clients ADD
	TransferToNewHost bit NOT NULL CONSTRAINT DF_Clients_TransferToNewHost DEFAULT ((0)),
	NewUrl nvarchar(150) NULL,
	ExpirationDate datetime NULL
GO
 ---------------------End 2022-02-17------------------------------------
