﻿----------------------------------- Hammad 2024-03-28 -------------------

ALTER TABLE [dbo].[FingerAreaProjects] DROP CONSTRAINT [FK_FingerAreaProjects_FingerArea1]
GO

  ALTER TABLE dbo.FingerAreaProjects
	DROP COLUMN FingerAreaCode
  GO

CREATE TABLE [dbo].[FingerAreaProjectDetail](
	[FingerAreaProjectDetailCode] [int] IDENTITY(1,1) NOT NULL,
	[FingerAreaProjectsCode] [int] NOT NULL,
	[FingerAreaCode] [int] NOT NULL,
 CONSTRAINT [PK_FingerAreaProjectDetail] PRIMARY KEY CLUSTERED 
(
	[FingerAreaProjectDetailCode] 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].[FingerAreaProjectDetail]  WITH CHECK ADD  CONSTRAINT [FK_FingerAreaProjectDetail_FingerArea] FOREIGN KEY([FingerAreaCode])
REFERENCES [dbo].[FingerArea] ([FingerAreaCode])
GO

ALTER TABLE [dbo].[FingerAreaProjectDetail] CHECK CONSTRAINT [FK_FingerAreaProjectDetail_FingerArea]
GO

ALTER TABLE [dbo].[FingerAreaProjectDetail]  WITH CHECK ADD  CONSTRAINT [FK_FingerAreaProjectDetail_FingerAreaProjects] FOREIGN KEY([FingerAreaProjectsCode])
REFERENCES [dbo].[FingerAreaProjects] ([FingerAreaProjectsCode])
GO

ALTER TABLE [dbo].[FingerAreaProjectDetail] CHECK CONSTRAINT [FK_FingerAreaProjectDetail_FingerAreaProjects]
GO

update SystemMenu   set IsVisible=1 ,Sequence=2
 where SystemMenuCode=1036 
 GO
 update SystemMenu   set Sequence=1
 where SystemMenuCode=582 
 GO
  update SecurityPrivilege set SystemMenuCode=1036 where ID=13139
  GO
----------------------------------- End 2024-03-28 ---------------------
----------------------------------- Hammad 2024-04-01 ------------------

ALTER TABLE dbo.FingerAreaProjects ADD
	ProjectCode nvarchar(100) NULL
GO

ALTER TABLE [dbo].FingerAreaProjects ALTER COLUMN ArabicName NVARCHAR(150);
Go

ALTER TABLE [dbo].FingerAreaProjects ALTER COLUMN Name NVARCHAR(150);
Go

ALTER TABLE dbo.WF_LoanTypeDetials ADD
	IsAttachmentRequired bit NOT NULL CONSTRAINT DF_WF_LoanTypeDetials_IsAttachmentRequired DEFAULT 0
GO

----------------------------------- End 2024-04-01 ------------------
----------------------------------- Mostafa 2024-04-02 ------------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1068,N'Specializations',N'تخصصات',1063,N'/Personal/Specialization',N'Index','fa fa-thumb-tack',N'get',4,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1068,22)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4164,N'تخصصات',N'Specializations',1068,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4165,N'عرض تخصصات',N'View Specializations',1068,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4166,N'إضافة تخصصات',N'Add Specializations',1068,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4167,N'تعديل تخصصات',N'Edit Specializations',1068,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4168,N'حذف تخصصات',N'Delete Specializations',1068,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4169,N'حفظ تخصصات',N'Save Specializations',1068,2)
Go

-- SSTAuthorizationActionFilterBefore (script only not added in db Check it and run if you want) 

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1660,N'Personal',N'Specialization',N'Index',0,N'get',4164)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1661,N'Personal',N'Specialization',N'Specialization_Read',0,N'post',4165)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1662,N'Personal',N'Specialization',N'Save',1,N'get',4166)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1663,N'Personal',N'Specialization',N'Save',2,N'get',4167)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1664,N'Personal',N'Specialization',N'Delete',0,N'post',4168)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1665,N'Personal',N'Specialization',N'Save',0,N'post',4169)

-- Api security privilege End Point (script only not added in db Check it and run if you want) 

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1122,NULL, NULL,N'Specialization',N'GetSpecializationSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1123,NULL, NULL,N'Specialization',N'GetSpecialization',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1124,NULL, NULL,N'Specialization',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1125,NULL, NULL,N'Specialization',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1126,NULL, NULL,N'Specialization',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1127,NULL, NULL,N'Specialization',N'Get',N'Get')
Go
-- Api security privilege End Point Detail (script only not added in db Check it and run if you want) 

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1398,1122,4165, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1399,1123,4165, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1400,1124,4169, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1401,1125,4169, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1402,1126,4168, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1403,1127,4167, NULL)
Go

----------------------------------------------------------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1066,N'Languages',N'اللغات',1063,N'/Personal/Language',N'Index','fa fa-thumb-tack',N'get',3,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1066,22)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4152,N'اللغات',N'Languages',1066,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4153,N'عرض اللغات',N'View Languages',1066,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4154,N'إضافة اللغات',N'Add Languages',1066,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4155,N'تعديل اللغات',N'Edit Languages',1066,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4156,N'حذف اللغات',N'Delete Languages',1066,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4157,N'حفظ اللغات',N'Save Languages',1066,2)
Go

-- SSTAuthorizationActionFilterBefore (script only not added in db Check it and run if you want) 

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1648,N'Personal',N'Language',N'Index',0,N'get',4152)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1649,N'Personal',N'Language',N'Language_Read',0,N'post',4153)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1650,N'Personal',N'Language',N'Save',1,N'get',4154)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1651,N'Personal',N'Language',N'Save',2,N'get',4155)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1652,N'Personal',N'Language',N'Delete',0,N'post',4156)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1653,N'Personal',N'Language',N'Save',0,N'post',4157)

-- Api security privilege End Point (script only not added in db Check it and run if you want) 
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1110,NULL, NULL,N'Language',N'GetLanguageSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1111,NULL, NULL,N'Language',N'GetLanguage',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1112,NULL, NULL,N'Language',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1113,NULL, NULL,N'Language',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1114,NULL, NULL,N'Language',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1115,NULL, NULL,N'Language',N'Get',N'Get')
Go
-- Api security privilege End Point Detail (script only not added in db Check it and run if you want) 

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1386,1110,4153, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1387,1111,4153, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1388,1112,4157, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1389,1113,4157, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1390,1114,4156, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1391,1115,4155, NULL)
Go
Alter table Languages
 add Serial nvarchar(150)
 GO
 Update Languages set serial= LanguageCode
GO
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1069,N'Universities',N'الجامعات',1063,N'/Personal/University',N'Index','fa fa-thumb-tack',N'get',5,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1069,22)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4170,N'الجامعات',N'Universities',1069,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4171,N'عرض الجامعات',N'View Universities',1069,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4172,N'إضافة الجامعات',N'Add Universities',1069,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4173,N'تعديل الجامعات',N'Edit Universities',1069,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4174,N'حذف الجامعات',N'Delete Universities',1069,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4175,N'حفظ الجامعات',N'Save Universities',1069,2)
Go

-- SSTAuthorizationActionFilterBefore (script only not added in db Check it and run if you want) 

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1666,N'Personal',N'University',N'Index',0,N'get',4170)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1667,N'Personal',N'University',N'University_Read',0,N'post',4171)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1668,N'Personal',N'University',N'Save',1,N'get',4172)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1669,N'Personal',N'University',N'Save',2,N'get',4173)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1670,N'Personal',N'University',N'Delete',0,N'post',4174)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1671,N'Personal',N'University',N'Save',0,N'post',4175)
Go
-- Api security privilege End Point (script only not added in db Check it and run if you want) 

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1128,NULL, NULL,N'University',N'GetUniversitySearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1129,NULL, NULL,N'University',N'GetUniversity',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1130,NULL, NULL,N'University',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1131,NULL, NULL,N'University',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1132,NULL, NULL,N'University',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1133,NULL, NULL,N'University',N'Get',N'Get')
Go
-- Api security privilege End Point Detail (script only not added in db Check it and run if you want) 

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1404,1128,4171, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1405,1129,4171, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1406,1130,4175, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1407,1131,4175, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1408,1132,4174, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1409,1133,4173, NULL)
Go


---------------------------------------------لGrade ---------------------------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1070,N'Grades',N'التقديرات',1063,N'/Personal/Grade',N'Index','fa fa-thumb-tack',N'get',6,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1070,22)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4176,N'التقديرات',N'Grades',1070,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4177,N'عرض التقديرات',N'View Grades',1070,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4178,N'إضافة التقديرات',N'Add Grades',1070,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4179,N'تعديل التقديرات',N'Edit Grades',1070,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4180,N'حذف التقديرات',N'Delete Grades',1070,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4181,N'حفظ التقديرات',N'Save Grades',1070,2)
Go

-- SSTAuthorizationActionFilterBefore (script only not added in db Check it and run if you want) 

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1672,N'Personal',N'Grade',N'Index',0,N'get',4176)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1673,N'Personal',N'Grade',N'Grade_Read',0,N'post',4177)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1674,N'Personal',N'Grade',N'Save',1,N'get',4178)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1675,N'Personal',N'Grade',N'Save',2,N'get',4179)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1676,N'Personal',N'Grade',N'Delete',0,N'post',4180)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1677,N'Personal',N'Grade',N'Save',0,N'post',4181)
Go
-- Api security privilege End Point (script only not added in db Check it and run if you want) 

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1134,NULL, NULL,N'Grade',N'GetGradeSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1135,NULL, NULL,N'Grade',N'GetGrade',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1136,NULL, NULL,N'Grade',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1137,NULL, NULL,N'Grade',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1138,NULL, NULL,N'Grade',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1139,NULL, NULL,N'Grade',N'Get',N'Get')
Go
-- Api security privilege End Point Detail (script only not added in db Check it and run if you want) 

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1410,1134,4177, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1411,1135,4177, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1412,1136,4181, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1413,1137,4181, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1414,1138,4180, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1415,1139,4179, NULL)
Go

Alter Table Grade 
add Serial Nvarchar(100)
Go

ALTER TABLE dbo.Grade ADD
	CreatedBy int NOT NULL CONSTRAINT DF_Grade_CreatedBy DEFAULT ((1)),
	CreationDate datetime NOT NULL CONSTRAINT DF_Grade_CreationDate DEFAULT (getdate()),
	ModifiedBy int NULL,
	ModificationDate datetime NULL
GO


UPDATE Grade set Serial = GradeCode
 Go 

update SecurityPrivilege set PrivilegeType=1 where ID=4151
GO
INSERT INTO [SST.ERP_Client]. [dbo].[APIs] ([ApiId], [ApiName]) VALUES (13, N'Payroll')
Go	
SET IDENTITY_INSERT [dbo].[AppModule] ON  
INSERT [dbo].[AppModule] ([AppModuleCode], [Name], [Arabic_Name], [IsLicensed], [LicenseNumber]) VALUES (23, N'Payroll', 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(1071,N'Payroll',N'الرواتب',NULL,NULL,NULL,'fa fa-money',NULL,23,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1071,23)
Go
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1072,N'Basic Data',N'بيانات أساسية',1071,NULL,NULL,'fa fa-thumb-tack',NULL,1,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1072,23)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25000,N'الرواتب',N'Payroll',1071,1)
GO
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25001,N'بيانات أساسية',N'Basic Data ',1072,1)
GO
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1073,N'Bank Account Type',N' انواع حسابات البنوك ',1072,N'/Payroll/BankAccountType',N'Index','fa fa-thumb-tack',N'get',1,1,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25002,N' انواع حسابات البنوك',N'Bank Account Type',1073,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25003,N'عرض انواع حسابات البنوك ',N'View Bank Account Type',1073,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25004,N'إضافة انواع حسابات البنوك ',N'Add Bank Account Type',1073,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25005,N'تعديل انواع حسابات البنوك ',N'Edit Bank Account Type',1073,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25006,N'حذف انواع حسابات البنوك ',N'Delete Bank Account Type',1073,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25007,N'حفظ انواع حسابات البنوك ',N'Save Bank Account Type',1073,2)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1678,N'Payroll',N'BankAccountType',N'Index',0,N'get',25002)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1679,N'Payroll',N'BankAccountType',N'BankAccountType_Read',0,N'post',25003)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1680,N'Payroll',N'BankAccountType',N'Save',1,N'get',25004)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1681,N'Payroll',N'BankAccountType',N'Save',2,N'get',25005)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1682,N'Payroll',N'BankAccountType',N'Delete',0,N'post',25006)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1683,N'Payroll',N'BankAccountType',N'Save',0,N'post',25007)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1140,NULL, NULL,N'BankAccountType',N'GetBankAccountTypeSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1141,NULL, NULL,N'BankAccountType',N'GetBankAccountType',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1142,NULL, NULL,N'BankAccountType',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1143,NULL, NULL,N'BankAccountType',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1144,NULL, NULL,N'BankAccountType',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1145,NULL, NULL,N'BankAccountType',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1416,1140,25003, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1417,1141,25003, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1418,1142,25007, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1419,1143,25007, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1420,1144,25006, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1421,1145,25005, NULL)
Go
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1074,N'Bonus Type',N' أنواع المكافآت ',1072,N'/Payroll/BonusType',N'Index','fa fa-thumb-tack',N'get',2,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1074,23)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25008,N' أنواع المكافآت',N'Bonus Type',1074,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25009,N'عرض أنواع المكافآت ',N'View Bonus Type',1074,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25010,N'إضافة أنواع المكافآت ',N'Add Bonus Type',1074,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25011,N'تعديل أنواع المكافآت ',N'Edit Bonus Type',1074,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25012,N'حذف أنواع المكافآت ',N'Delete Bonus Type',1074,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25013,N'حفظ أنواع المكافآت ',N'Save Bonus Type',1074,2)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1684,N'Payroll',N'BonusType',N'Index',0,N'get',25008)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1685,N'Payroll',N'BonusType',N'BonusType_Read',0,N'post',25009)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1686,N'Payroll',N'BonusType',N'Save',1,N'get',25010)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1687,N'Payroll',N'BonusType',N'Save',2,N'get',25011)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1688,N'Payroll',N'BonusType',N'Delete',0,N'post',25012)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1689,N'Payroll',N'BonusType',N'Save',0,N'post',25013)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1146,NULL, NULL,N'BonusType',N'GetBonusTypeSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1147,NULL, NULL,N'BonusType',N'GetBonusType',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1148,NULL, NULL,N'BonusType',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1149,NULL, NULL,N'BonusType',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1150,NULL, NULL,N'BonusType',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1151,NULL, NULL,N'BonusType',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1422,1146,25009, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1423,1147,25009, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1424,1148,25013, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1425,1149,25013, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1426,1150,25012, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1427,1151,25011, NULL)
Go
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1075,N'Bonus Gift',N'المنح و الهبة',1072,N'/Payroll/BonusGift',N'Index','fa fa-gift',N'get',3,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1075,23)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25014,N' المنح و الهبة',N'Bonus Gift',1075,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25015,N'عرض المنح و الهبة ',N'View Bonus Gift',1075,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25016,N'إضافة المنح و الهبة ',N'Add Bonus Gift',1075,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25017,N'تعديل المنح و الهبة ',N'Edit Bonus Gift',1075,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25018,N'حذف المنح و الهبة ',N'Delete Bonus Gift',1075,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25019,N'حفظ المنح و الهبة ',N'Save Bonus Gift',1075,2)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1690,N'Payroll',N'BonusGift',N'Index',0,N'get',25014)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1691,N'Payroll',N'BonusGift',N'BonusGift_Read',0,N'post',25015)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1692,N'Payroll',N'BonusGift',N'Save',1,N'get',25016)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1693,N'Payroll',N'BonusGift',N'Save',2,N'get',25017)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1694,N'Payroll',N'BonusGift',N'Delete',0,N'post',25018)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1695,N'Payroll',N'BonusGift',N'Save',0,N'post',25019)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1152,NULL, NULL,N'BonusGift',N'GetBonusGiftSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1153,NULL, NULL,N'BonusGift',N'GetBonusGift',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1154,NULL, NULL,N'BonusGift',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1155,NULL, NULL,N'BonusGift',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1156,NULL, NULL,N'BonusGift',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1157,NULL, NULL,N'BonusGift',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1428,1152,25015, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1429,1153,25015, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1430,1154,25019, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1431,1155,25019, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1432,1156,25018, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1433,1157,25017, NULL)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1076,N' Installment Type',N'انواع الاقساط',1072,N'/Payroll/InstallmentType',N'Index','fa fa-random',N'get',4,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1076,23)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25020,N' انواع الاقساط',N' Installment Type',1076,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25021,N'عرض انواع الاقساط ',N'View  Installment Type',1076,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25022,N'إضافة انواع الاقساط ',N'Add  Installment Type',1076,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25023,N'تعديل انواع الاقساط ',N'Edit  Installment Type',1076,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25024,N'حذف انواع الاقساط ',N'Delete  Installment Type',1076,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25025,N'حفظ انواع الاقساط ',N'Save  Installment Type',1076,2)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1696,N'Payroll',N'InstallmentType',N'Index',0,N'get',25020)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1697,N'Payroll',N'InstallmentType',N'InstallmentType_Read',0,N'post',25021)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1698,N'Payroll',N'InstallmentType',N'Save',1,N'get',25022)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1699,N'Payroll',N'InstallmentType',N'Save',2,N'get',25023)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1700,N'Payroll',N'InstallmentType',N'Delete',0,N'post',25024)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1701,N'Payroll',N'InstallmentType',N'Save',0,N'post',25025)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1159,NULL, NULL,N'InstallmentType',N'GetInstallmentTypeSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1160,NULL, NULL,N'InstallmentType',N'GetInstallmentType',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1161,NULL, NULL,N'InstallmentType',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1162,NULL, NULL,N'InstallmentType',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1163,NULL, NULL,N'InstallmentType',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1164,NULL, NULL,N'InstallmentType',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1434,1159,25021, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1435,1160,25021, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1436,1161,25025, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1437,1162,25025, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1438,1163,25024, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1439,1164,25023, NULL)
Go
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1077,N' Marital Status',N'الحالة الاجتماعية',1072,N'/Payroll/MaritalStatus',N'Index','fa fa-random',N'get',5,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1077,23)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25026,N' الحالة الاجتماعية',N' Marital Status',1077,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25027,N'عرض الحالة الاجتماعية ',N'View  Marital Status',1077,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25028,N'إضافة الحالة الاجتماعية ',N'Add  Marital Status',1077,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25029,N'تعديل الحالة الاجتماعية ',N'Edit  Marital Status',1077,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25030,N'حذف الحالة الاجتماعية ',N'Delete  Marital Status',1077,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25031,N'حفظ الحالة الاجتماعية ',N'Save  Marital Status',1077,2)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1702,N'Payroll',N'MaritalStatus',N'Index',0,N'get',25026)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1703,N'Payroll',N'MaritalStatus',N'MaritalStatus_Read',0,N'post',25027)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1704,N'Payroll',N'MaritalStatus',N'Save',1,N'get',25028)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1705,N'Payroll',N'MaritalStatus',N'Save',2,N'get',25029)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1706,N'Payroll',N'MaritalStatus',N'Delete',0,N'post',25030)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1707,N'Payroll',N'MaritalStatus',N'Save',0,N'post',25031)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1165,NULL, NULL,N'MaritalStatus',N'GetMaritalStatusSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1166,NULL, NULL,N'MaritalStatus',N'GetMaritalStatus',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1167,NULL, NULL,N'MaritalStatus',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1168,NULL, NULL,N'MaritalStatus',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1169,NULL, NULL,N'MaritalStatus',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1170,NULL, NULL,N'MaritalStatus',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1440,1165,25027, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1441,1166,25027, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1442,1167,25031, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1443,1168,25031, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1444,1169,25030, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1445,1170,25029, NULL)
Go
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1078,N'Payroll Group',N'مجموعات الحسابات',1072,N'/Payroll/PayrollGroup',N'Index','fa fa-random',N'get',6,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1078,23)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25032,N' مجموعات الحسابات',N' Payroll Group',1078,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25033,N'عرض مجموعات الحسابات ',N'View  Payroll Group',1078,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25034,N'إضافة مجموعات الحسابات ',N'Add  Payroll Group',1078,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25035,N'تعديل مجموعات الحسابات ',N'Edit  Payroll Group',1078,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25036,N'حذف مجموعات الحسابات ',N'Delete  Payroll Group',1078,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25037,N'حفظ مجموعات الحسابات ',N'Save  Payroll Group',1078,2)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1708,N'Payroll',N'PayrollGroup',N'Index',0,N'get',25032)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1709,N'Payroll',N'PayrollGroup',N'PayrollGroup_Read',0,N'post',25033)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1710,N'Payroll',N'PayrollGroup',N'Save',1,N'get',25034)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1711,N'Payroll',N'PayrollGroup',N'Save',2,N'get',25035)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1712,N'Payroll',N'PayrollGroup',N'Delete',0,N'post',25036)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1713,N'Payroll',N'PayrollGroup',N'Save',0,N'post',25037)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1171,NULL, NULL,N'PayrollGroup',N'GetPayrollGroupSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1172,NULL, NULL,N'PayrollGroup',N'GetPayrollGroup',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1173,NULL, NULL,N'PayrollGroup',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1174,NULL, NULL,N'PayrollGroup',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1175,NULL, NULL,N'PayrollGroup',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1176,NULL, NULL,N'PayrollGroup',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1446,1171,25033, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1447,1172,25033, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1448,1173,25037, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1449,1174,25037, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1450,1175,25036, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1451,1176,25035, NULL)
Go
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1079,N'Currency',N'العملات',1072,N'/Payroll/Currency',N'Index','fa fa-random',N'get',7,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1079,23)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25038,N' العملات',N' Currency',1079,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25039,N'عرض العملات ',N'View  Currency',1079,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25040,N'إضافة العملات ',N'Add  Currency',1079,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25041,N'تعديل العملات ',N'Edit  Currency',1079,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25042,N'حذف العملات ',N'Delete  Currency',1079,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25043,N'حفظ العملات ',N'Save  Currency',1079,2)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1725,N'Payroll',N'Currency',N'Index',0,N'get',25038)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1726,N'Payroll',N'Currency',N'Currency_Read',0,N'post',25039)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1727,N'Payroll',N'Currency',N'Save',1,N'get',25040)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1728,N'Payroll',N'Currency',N'Save',2,N'get',25041)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1729,N'Payroll',N'Currency',N'Delete',0,N'post',25042)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1730,N'Payroll',N'Currency',N'Save',0,N'post',25043)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1177,NULL, NULL,N'Currency',N'GetCurrencySearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1178,NULL, NULL,N'Currency',N'GetCurrency',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1179,NULL, NULL,N'Currency',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1180,NULL, NULL,N'Currency',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1181,NULL, NULL,N'Currency',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1182,NULL, NULL,N'Currency',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1452,1177,25039, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1453,1178,25039, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1454,1179,25043, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1455,1180,25043, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1456,1181,25042, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1457,1182,25041, NULL)
Go
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1080,N'Pension',N' انواع المنح',1072,N'/Payroll/Pension',N'Index','fa fa-random',N'get',8,1,1)
GO
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1080,23)
GO
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25044,N'انواع المنح',N' Pension',1080,1)
GO
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25045,N'عرض  انواع المنح ',N'View  Pension',1080,2)
GO
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25046,N'إضافة  انواع المنح ',N'Add  Pension',1080,2)
GO
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25047,N'تعديل  انواع المنح ',N'Edit  Pension',1080,2)
GO
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25048,N'حذف  انواع المنح ',N'Delete  Pension',1080,2)
GO
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25049,N'حفظ  انواع المنح ',N'Save  Pension',1080,2)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1746,N'Payroll',N'Pension',N'Index',0,N'get',25044)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1747,N'Payroll',N'Pension',N'Pension_Read',0,N'post',25045)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1748,N'Payroll',N'Pension',N'Save',1,N'get',25046)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1749,N'Payroll',N'Pension',N'Save',2,N'get',25047)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1750,N'Payroll',N'Pension',N'Delete',0,N'post',25048)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1751,N'Payroll',N'Pension',N'Save',0,N'post',25049)
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1184,NULL, NULL,N'Pension',N'GetPensionSearch',N'post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1185,NULL, NULL,N'Pension',N'GetPension',N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1186,NULL, NULL,N'Pension',N'Put',N'Put')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1187,NULL, NULL,N'Pension',N'post',N'post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1188,NULL, NULL,N'Pension',N'Delete',N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1189,NULL, NULL,N'Pension',N'Get',N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1459,1184,25045, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1460,1185,25045, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1461,1186,25049, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1462,1187,25049, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1463,1188,25048, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1464,1189,25047, NULL)
GO
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1081,N'Tax Sheet',N'سجل الضرائب',1072,N'/Payroll/TaxSheet',N'Index','fa fa-random',N'get',9,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1081,23)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25050,N' سجل الضرائب',N' Tax Sheet',1081,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25051,N'عرض سجل الضرائب ',N'View  Tax Sheet',1081,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25052,N'إضافة سجل الضرائب ',N'Add  Tax Sheet',1081,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25053,N'تعديل سجل الضرائب ',N'Edit  Tax Sheet',1081,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25054,N'حذف سجل الضرائب ',N'Delete  Tax Sheet',1081,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25055,N'حفظ سجل الضرائب ',N'Save  Tax Sheet',1081,2)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1752,N'Payroll',N'TaxSheet',N'Index',0,N'get',25050)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1753,N'Payroll',N'TaxSheet',N'TaxSheet_Read',0,N'post',25051)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1754,N'Payroll',N'TaxSheet',N'Save',1,N'get',25052)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1755,N'Payroll',N'TaxSheet',N'Save',2,N'get',25053)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1756,N'Payroll',N'TaxSheet',N'Delete',0,N'post',25054)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1757,N'Payroll',N'TaxSheet',N'Save',0,N'post',25055)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1190,NULL, NULL,N'TaxSheet',N'GetTaxSheetSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1191,NULL, NULL,N'TaxSheet',N'GetTaxSheet',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1192,NULL, NULL,N'TaxSheet',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1193,NULL, NULL,N'TaxSheet',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1194,NULL, NULL,N'TaxSheet',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1195,NULL, NULL,N'TaxSheet',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1465,1190,25051, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1466,1191,25051, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1467,1192,25055, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1468,1193,25055, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1469,1194,25054, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1470,1195,25053, NULL)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1082,N'Bank',N'البنوك',1072,N'/Payroll/Bank',N'Index','fa fa-university',N'get',10,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1082,23)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25056,N' البنوك',N' Bank',1082,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25057,N'عرض البنوك ',N'View Bank',1082,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25058,N'إضافة البنوك ',N'Add Bank',1082,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25059,N'تعديل البنوك ',N'Edit Bank',1082,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25060,N'حذف البنوك ',N'Delete Bank',1082,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(25061,N'حفظ البنوك ',N'Save Bank',1082,2)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1758,N'Payroll',N'Bank',N'Index',0,N'get',25056)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1759,N'Payroll',N'Bank',N'Bank_Read',0,N'post',25057)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1760,N'Payroll',N'Bank',N'Save',1,N'get',25058)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1761,N'Payroll',N'Bank',N'Save',2,N'get',25059)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1762,N'Payroll',N'Bank',N'Delete',0,N'post',25060)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1763,N'Payroll',N'Bank',N'Save',0,N'post',25061)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1196,NULL, NULL,N'Bank',N'GetBankSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1197,NULL, NULL,N'Bank',N'GetBank',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1198,NULL, NULL,N'Bank',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1199,NULL, NULL,N'Bank',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1200,NULL, NULL,N'Bank',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1201,NULL, NULL,N'Bank',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1471,1196,25057, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1472,1197,25057, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1473,1198,25061, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1474,1199,25061, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1475,1200,25060, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1476,1201,25059, NULL)
Go


BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Faculties
	DROP CONSTRAINT DF_Faculties_FacultyCode

CREATE TABLE dbo.Tmp_Faculties
	(
	FacultyCode smallint NOT NULL IDENTITY (0, 1),
	Name nvarchar(250) NULL,
	Arabic_Name nvarchar(250) NULL,
	MDT datetime NULL
	)  ON [PRIMARY]

ALTER TABLE dbo.Tmp_Faculties SET (LOCK_ESCALATION = TABLE)

SET IDENTITY_INSERT dbo.Tmp_Faculties ON

IF EXISTS(SELECT * FROM dbo.Faculties)
	 EXEC('INSERT INTO dbo.Tmp_Faculties (FacultyCode, Name, Arabic_Name, MDT)
		SELECT FacultyCode, Name, Arabic_Name, MDT FROM dbo.Faculties WITH (HOLDLOCK TABLOCKX)')

SET IDENTITY_INSERT dbo.Tmp_Faculties OFF

DROP TABLE dbo.Faculties

EXECUTE sp_rename N'dbo.Tmp_Faculties', N'Faculties', 'OBJECT' 
ALTER TABLE dbo.Faculties ADD CONSTRAINT
	PK_Faculties PRIMARY KEY CLUSTERED 
	(
	FacultyCode
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

COMMIT
GO

ALTER TABLE dbo.Faculties ADD
	CreatedBy int NULL,
	CreationDate datetime NULL,
	ModifiedBy int NULL,
	ModificationDate datetime NULL


GO
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.MaritalStatus
	DROP CONSTRAINT DF_MaritalStatus_MaritalCode

CREATE TABLE dbo.Tmp_MaritalStatus
	(
	MaritalCode tinyint NOT NULL IDENTITY (0, 1),
	Name nvarchar(150) NULL,
	Arabic_Name nvarchar(150) NULL
	)  ON [PRIMARY]

ALTER TABLE dbo.Tmp_MaritalStatus SET (LOCK_ESCALATION = TABLE)

SET IDENTITY_INSERT dbo.Tmp_MaritalStatus ON

IF EXISTS(SELECT * FROM dbo.MaritalStatus)
	 EXEC('INSERT INTO dbo.Tmp_MaritalStatus (MaritalCode, Name, Arabic_Name)
		SELECT MaritalCode, Name, Arabic_Name FROM dbo.MaritalStatus WITH (HOLDLOCK TABLOCKX)')

SET IDENTITY_INSERT dbo.Tmp_MaritalStatus OFF

ALTER TABLE dbo.Rec_RecruitEmployee
	DROP CONSTRAINT FK_Rec_RecruitEmployee_MaritalStatus

DROP TABLE dbo.MaritalStatus

EXECUTE sp_rename N'dbo.Tmp_MaritalStatus', N'MaritalStatus', 'OBJECT' 

ALTER TABLE dbo.MaritalStatus ADD CONSTRAINT
	PK_MaritalStatus PRIMARY KEY CLUSTERED 
	(
	MaritalCode
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Rec_RecruitEmployee ADD CONSTRAINT
	FK_Rec_RecruitEmployee_MaritalStatus FOREIGN KEY
	(
	MaritalCode
	) REFERENCES dbo.MaritalStatus
	(
	MaritalCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Rec_RecruitEmployee SET (LOCK_ESCALATION = TABLE)

COMMIT
GO
ALTER TABLE dbo.MaritalStatus ADD
	CreatedBy int NULL,
	CreationDate datetime NULL,
	ModifiedBy int NULL,
	ModificationDate datetime NULL,
	Serial nvarchar(150) NULL,
	Closed BIT DEFAULT 0
	GO
update MaritalStatus set Serial=MaritalCode,CreatedBy=1 ,CreationDate=GETDATE(),Closed=0
GO

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION

ALTER TABLE Acc.AccountsChart SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Currencies
	DROP CONSTRAINT DF_Currencies_CurrencyCode

ALTER TABLE dbo.Currencies
	DROP CONSTRAINT DF_Currencies_Rate

CREATE TABLE dbo.Tmp_Currencies
	(
	CurrencyCode tinyint NOT NULL IDENTITY (1, 1),
	Name nvarchar(150) NULL,
	Arabic_Name nvarchar(150) NULL,
	Rate float(53) NULL,
	ArabicPiaster nvarchar(150) NULL,
	EnglishAPiaster nvarchar(150) NULL,
	NetSalariesAccount int NULL
	)  ON [PRIMARY]

ALTER TABLE dbo.Tmp_Currencies SET (LOCK_ESCALATION = TABLE)

ALTER TABLE dbo.Tmp_Currencies ADD CONSTRAINT
	DF_Currencies_Rate DEFAULT ((0)) FOR Rate

SET IDENTITY_INSERT dbo.Tmp_Currencies ON

IF EXISTS(SELECT * FROM dbo.Currencies)
	 EXEC('INSERT INTO dbo.Tmp_Currencies (CurrencyCode, Name, Arabic_Name, Rate, ArabicPiaster, EnglishAPiaster, NetSalariesAccount)
		SELECT CurrencyCode, Name, Arabic_Name, Rate, ArabicPiaster, EnglishAPiaster, CONVERT(int, NetSalariesAccount) FROM dbo.Currencies WITH (HOLDLOCK TABLOCKX)')

SET IDENTITY_INSERT dbo.Tmp_Currencies OFF

ALTER TABLE dbo.WF_CasualRequest
	DROP CONSTRAINT FK_WF_CasualRequest_Currencies

ALTER TABLE dbo.ExchangeRate
	DROP CONSTRAINT FK_ExchangeRate_Currencies

ALTER TABLE dbo.Academic_Awards
	DROP CONSTRAINT FK_Academic_Awards_Currencies_CurrencyCode

ALTER TABLE dbo.Academic_StructInstCapBuildExpansions
	DROP CONSTRAINT FK_Academic_StructInstCapBuildExpansion_CurrencyCode

ALTER TABLE dbo.Academic_Sponsers
	DROP CONSTRAINT FK_Academic_Sponsers_Currencies_CurrencyCode

ALTER TABLE dbo.Academic_ScientificActivities
	DROP CONSTRAINT FK_Academic_ScientificActivities_Currencies_FinancialCompensationCurrencyCode

ALTER TABLE dbo.Academic_ScientificActivities
	DROP CONSTRAINT FK_Academic_ScientificActivities_Currencies_InstitutionalRevenueCurrencyCode

ALTER TABLE dbo.WF_AssignmentRequests
	DROP CONSTRAINT FK_AssignmentRequest_Currency

ALTER TABLE dbo.Academic_ProfDevCommunityServices
	DROP CONSTRAINT FK_Academic_ProfDevCommunityServices_Currencies_CurrencyCode

ALTER TABLE dbo.WF_SalaryDetail
	DROP CONSTRAINT FK_WF_SalaryDetail_Currencies

DROP TABLE dbo.Currencies

EXECUTE sp_rename N'dbo.Tmp_Currencies', N'Currencies', 'OBJECT' 

ALTER TABLE dbo.Currencies ADD CONSTRAINT
	PK_Currencies PRIMARY KEY CLUSTERED 
	(
	CurrencyCode
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


ALTER TABLE dbo.Currencies ADD CONSTRAINT
	FK_Currencies_AccountsChart FOREIGN KEY
	(
	NetSalariesAccount
	) REFERENCES Acc.AccountsChart
	(
	AccountsChartCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.WF_SalaryDetail ADD CONSTRAINT
	FK_WF_SalaryDetail_Currencies FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.WF_SalaryDetail SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Academic_ProfDevCommunityServices ADD CONSTRAINT
	FK_Academic_ProfDevCommunityServices_Currencies_CurrencyCode FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Academic_ProfDevCommunityServices SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.WF_AssignmentRequests ADD CONSTRAINT
	FK_AssignmentRequest_Currency FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  CASCADE 
	

ALTER TABLE dbo.WF_AssignmentRequests SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Academic_ScientificActivities ADD CONSTRAINT
	FK_Academic_ScientificActivities_Currencies_FinancialCompensationCurrencyCode FOREIGN KEY
	(
	FinancialCompensationCurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Academic_ScientificActivities ADD CONSTRAINT
	FK_Academic_ScientificActivities_Currencies_InstitutionalRevenueCurrencyCode FOREIGN KEY
	(
	InstitutionalRevenueCurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Academic_ScientificActivities SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Academic_Sponsers ADD CONSTRAINT
	FK_Academic_Sponsers_Currencies_CurrencyCode FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Academic_Sponsers SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Academic_StructInstCapBuildExpansions ADD CONSTRAINT
	FK_Academic_StructInstCapBuildExpansion_CurrencyCode FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Academic_StructInstCapBuildExpansions SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Academic_Awards ADD CONSTRAINT
	FK_Academic_Awards_Currencies_CurrencyCode FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Academic_Awards SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.ExchangeRate ADD CONSTRAINT
	FK_ExchangeRate_Currencies FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.ExchangeRate SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.WF_CasualRequest ADD CONSTRAINT
	FK_WF_CasualRequest_Currencies FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.WF_CasualRequest SET (LOCK_ESCALATION = TABLE)

COMMIT

GO
ALTER TABLE dbo.Currencies ADD
	CreatedBy int NULL,
	CreationDate datetime NULL,
	ModifiedBy int NULL,
	ModificationDate datetime NULL,
	Serial nvarchar(150) NULL,
	Closed BIT DEFAULT 0
	GO
	update Currencies set Serial=CurrencyCode,CreatedBy=1 ,CreationDate=GETDATE(),Closed=0
	GO

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION

ALTER TABLE Acc.AccountsChart SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Currencies
	DROP CONSTRAINT DF_Currencies_CurrencyCode

ALTER TABLE dbo.Currencies
	DROP CONSTRAINT DF_Currencies_Rate

CREATE TABLE dbo.Tmp_Currencies
	(
	CurrencyCode tinyint NOT NULL IDENTITY (0, 1),
	Name nvarchar(150) NULL,
	Arabic_Name nvarchar(150) NULL,
	Rate float(53) NULL,
	ArabicPiaster nvarchar(150) NULL,
	EnglishAPiaster nvarchar(150) NULL,
	NetSalariesAccount nvarchar(30) NULL
	)  ON [PRIMARY]

ALTER TABLE dbo.Tmp_Currencies SET (LOCK_ESCALATION = TABLE)

ALTER TABLE dbo.Tmp_Currencies ADD CONSTRAINT
	DF_Currencies_Rate DEFAULT ((0)) FOR Rate

SET IDENTITY_INSERT dbo.Tmp_Currencies ON

IF EXISTS(SELECT * FROM dbo.Currencies)
	 EXEC('INSERT INTO dbo.Tmp_Currencies (CurrencyCode, Name, Arabic_Name, Rate, ArabicPiaster, EnglishAPiaster, NetSalariesAccount)
		SELECT CurrencyCode, Name, Arabic_Name, Rate, ArabicPiaster, EnglishAPiaster, NetSalariesAccount FROM dbo.Currencies WITH (HOLDLOCK TABLOCKX)')

SET IDENTITY_INSERT dbo.Tmp_Currencies OFF

ALTER TABLE dbo.WF_SalaryDetail
	DROP CONSTRAINT FK_WF_SalaryDetail_Currencies

ALTER TABLE dbo.Academic_ProfDevCommunityServices
	DROP CONSTRAINT FK_Academic_ProfDevCommunityServices_Currencies_CurrencyCode

ALTER TABLE dbo.WF_AssignmentRequests
	DROP CONSTRAINT FK_AssignmentRequest_Currency

ALTER TABLE dbo.Academic_ScientificActivities
	DROP CONSTRAINT FK_Academic_ScientificActivities_Currencies_FinancialCompensationCurrencyCode

ALTER TABLE dbo.Academic_ScientificActivities
	DROP CONSTRAINT FK_Academic_ScientificActivities_Currencies_InstitutionalRevenueCurrencyCode

ALTER TABLE dbo.Academic_Sponsers
	DROP CONSTRAINT FK_Academic_Sponsers_Currencies_CurrencyCode

ALTER TABLE dbo.Academic_StructInstCapBuildExpansions
	DROP CONSTRAINT FK_Academic_StructInstCapBuildExpansion_CurrencyCode

ALTER TABLE dbo.Academic_Awards
	DROP CONSTRAINT FK_Academic_Awards_Currencies_CurrencyCode

ALTER TABLE dbo.ExchangeRate
	DROP CONSTRAINT FK_ExchangeRate_Currencies

ALTER TABLE dbo.WF_CasualRequest
	DROP CONSTRAINT FK_WF_CasualRequest_Currencies

DROP TABLE dbo.Currencies

EXECUTE sp_rename N'dbo.Tmp_Currencies', N'Currencies', 'OBJECT' 

ALTER TABLE dbo.Currencies ADD CONSTRAINT
	PK_Currencies PRIMARY KEY CLUSTERED 
	(
	CurrencyCode
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


ALTER TABLE dbo.Currencies ADD CONSTRAINT
	FK_Currencies_AccountsChart FOREIGN KEY
	(
	NetSalariesAccount
	) REFERENCES Acc.AccountsChart
	(
	AccountsChartCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.WF_CasualRequest ADD CONSTRAINT
	FK_WF_CasualRequest_Currencies FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.WF_CasualRequest SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.ExchangeRate ADD CONSTRAINT
	FK_ExchangeRate_Currencies FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.ExchangeRate SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Academic_Awards ADD CONSTRAINT
	FK_Academic_Awards_Currencies_CurrencyCode FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Academic_Awards SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Academic_StructInstCapBuildExpansions ADD CONSTRAINT
	FK_Academic_StructInstCapBuildExpansion_CurrencyCode FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Academic_StructInstCapBuildExpansions SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Academic_Sponsers ADD CONSTRAINT
	FK_Academic_Sponsers_Currencies_CurrencyCode FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Academic_Sponsers SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Academic_ScientificActivities ADD CONSTRAINT
	FK_Academic_ScientificActivities_Currencies_FinancialCompensationCurrencyCode FOREIGN KEY
	(
	FinancialCompensationCurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Academic_ScientificActivities ADD CONSTRAINT
	FK_Academic_ScientificActivities_Currencies_InstitutionalRevenueCurrencyCode FOREIGN KEY
	(
	InstitutionalRevenueCurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Academic_ScientificActivities SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.WF_AssignmentRequests ADD CONSTRAINT
	FK_AssignmentRequest_Currency FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  CASCADE 
	

ALTER TABLE dbo.WF_AssignmentRequests SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Academic_ProfDevCommunityServices ADD CONSTRAINT
	FK_Academic_ProfDevCommunityServices_Currencies_CurrencyCode FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Academic_ProfDevCommunityServices SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.WF_SalaryDetail ADD CONSTRAINT
	FK_WF_SalaryDetail_Currencies FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.WF_SalaryDetail SET (LOCK_ESCALATION = TABLE)

COMMIT
GO
ALTER TABLE dbo.Currencies 
ADD CreatedBy INT NOT NULL DEFAULT 1,
    CreationDate DATETIME NOT NULL DEFAULT GETDATE(),
    ModifiedBy INT NULL,
    ModificationDate DATETIME NULL,
    Serial NVARCHAR(150) NULL,
    Closed BIT DEFAULT 0;
	
	update Currencies set Serial=CurrencyCode,CreatedBy=1 ,CreationDate=GETDATE(),Closed=0

	GO
UPDATE Cities
SET CreatedBy = COALESCE(CreatedBy, 1),
    CreationDate = CASE
                       WHEN CreatedBy IS NULL THEN GETDATE()
                       ELSE CreationDate
                   END
WHERE CreatedBy IS NULL;
GO
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.SubContractGroups
	DROP CONSTRAINT DF_SubContractGroups_Closed

CREATE TABLE dbo.Tmp_SubContractGroups
	(
	SubContractGroupCode int NOT NULL IDENTITY (1, 1),
	Name nvarchar(150) NULL,
	Arabic_Name nvarchar(150) NULL,
	Closed bit NULL,
	MDT datetime NULL,
	CreatedBy int NULL,
	CreationDate datetime NULL,
	ModifiedBy int NULL,
	ModificationDate datetime NULL
	)  ON [PRIMARY]

ALTER TABLE dbo.Tmp_SubContractGroups SET (LOCK_ESCALATION = TABLE)

ALTER TABLE dbo.Tmp_SubContractGroups ADD CONSTRAINT
	DF_SubContractGroups_Closed DEFAULT ((0)) FOR Closed

SET IDENTITY_INSERT dbo.Tmp_SubContractGroups ON

IF EXISTS(SELECT * FROM dbo.SubContractGroups)
	 EXEC('INSERT INTO dbo.Tmp_SubContractGroups (SubContractGroupCode, Name, Arabic_Name, Closed, MDT, CreatedBy, CreationDate, ModifiedBy, ModificationDate)
		SELECT SubContractGroupCode, Name, Arabic_Name, Closed, MDT, CreatedBy, CreationDate, ModifiedBy, CONVERT(datetime, ModificationDate) FROM dbo.SubContractGroups WITH (HOLDLOCK TABLOCKX)')

SET IDENTITY_INSERT dbo.Tmp_SubContractGroups OFF

ALTER TABLE dbo.WF_RequestTypeSubContractGroups
	DROP CONSTRAINT FK_WF_RequestTypeSubContractGroups_SubContractGroups

DROP TABLE dbo.SubContractGroups

EXECUTE sp_rename N'dbo.Tmp_SubContractGroups', N'SubContractGroups', 'OBJECT' 

ALTER TABLE dbo.SubContractGroups ADD CONSTRAINT
	PK_SubContractGroups_SubContractGroupCode PRIMARY KEY CLUSTERED 
	(
	SubContractGroupCode
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.WF_RequestTypeSubContractGroups ADD CONSTRAINT
	FK_WF_RequestTypeSubContractGroups_SubContractGroups FOREIGN KEY
	(
	SubContractGroupCode
	) REFERENCES dbo.SubContractGroups
	(
	SubContractGroupCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.WF_RequestTypeSubContractGroups SET (LOCK_ESCALATION = TABLE)

COMMIT

GO
UPDATE SubContractGroups
SET CreatedBy = COALESCE(CreatedBy, 1),
    CreationDate = CASE
                       WHEN CreatedBy IS NULL THEN GETDATE()
                       ELSE CreationDate
                   END
WHERE CreatedBy IS NULL;
GO
ALTER TABLE dbo.HealthInsuranceTypes ADD CONSTRAINT
	DF_HealthInsuranceTypes_Closed DEFAULT ((0)) FOR Closed
	GO
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.DocumentsTypes
	DROP CONSTRAINT DF_DocumentsTypes_CreatedBy

ALTER TABLE dbo.DocumentsTypes
	DROP CONSTRAINT DF_DocumentsTypes_CreationDate

CREATE TABLE dbo.Tmp_DocumentsTypes
	(
	DocumentTypeCode int NOT NULL IDENTITY (1, 1),
	Name nvarchar(150) NULL,
	Arabic_Name nvarchar(150) NULL,
	MDT datetime NULL,
	CreatedBy int NOT NULL,
	CreationDate datetime NOT NULL,
	ModifiedBy int NULL,
	ModificationDate datetime NULL,
	Serial nvarchar(150) NULL,
	CentralCode int NULL
	)  ON [PRIMARY]

ALTER TABLE dbo.Tmp_DocumentsTypes SET (LOCK_ESCALATION = TABLE)

ALTER TABLE dbo.Tmp_DocumentsTypes ADD CONSTRAINT
	DF_DocumentsTypes_CreatedBy DEFAULT ((1)) FOR CreatedBy

ALTER TABLE dbo.Tmp_DocumentsTypes ADD CONSTRAINT
	DF_DocumentsTypes_CreationDate DEFAULT (getdate()) FOR CreationDate

SET IDENTITY_INSERT dbo.Tmp_DocumentsTypes ON

IF EXISTS(SELECT * FROM dbo.DocumentsTypes)
	 EXEC('INSERT INTO dbo.Tmp_DocumentsTypes (DocumentTypeCode, Name, Arabic_Name, MDT, CreatedBy, CreationDate, ModifiedBy, ModificationDate, Serial, CentralCode)
		SELECT DocumentTypeCode, Name, Arabic_Name, MDT, CreatedBy, CreationDate, ModifiedBy, ModificationDate, Serial, CentralCode FROM dbo.DocumentsTypes WITH (HOLDLOCK TABLOCKX)')

SET IDENTITY_INSERT dbo.Tmp_DocumentsTypes OFF

DROP TABLE dbo.DocumentsTypes

EXECUTE sp_rename N'dbo.Tmp_DocumentsTypes', N'DocumentsTypes', 'OBJECT' 

ALTER TABLE dbo.DocumentsTypes ADD CONSTRAINT
	PK_DocumentsTypes PRIMARY KEY CLUSTERED 
	(
	DocumentTypeCode
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
COMMIT

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Nationality
	DROP CONSTRAINT DF_Nationality_CreatedBy

ALTER TABLE dbo.Nationality
	DROP CONSTRAINT DF_Nationality_CreationDate

CREATE TABLE dbo.Tmp_Nationality
	(
	NationalityCode tinyint NOT NULL IDENTITY (0, 1),
	Name nvarchar(150) NULL,
	Arabic_Name nvarchar(150) NULL,
	CountryName nvarchar(150) NULL,
	CountryArabic_Name nvarchar(150) NULL,
	NationalityType int NULL,
	MappingCode int NULL,
	Serial nvarchar(150) NULL,
	CreatedBy int NOT NULL,
	CreationDate datetime NOT NULL,
	ModifiedBy int NULL,
	ModificationDate datetime NULL
	)  ON [PRIMARY]

ALTER TABLE dbo.Tmp_Nationality SET (LOCK_ESCALATION = TABLE)

ALTER TABLE dbo.Tmp_Nationality ADD CONSTRAINT
	DF_Nationality_CreatedBy DEFAULT ((1)) FOR CreatedBy

ALTER TABLE dbo.Tmp_Nationality ADD CONSTRAINT
	DF_Nationality_CreationDate DEFAULT (getdate()) FOR CreationDate

SET IDENTITY_INSERT dbo.Tmp_Nationality ON

IF EXISTS(SELECT * FROM dbo.Nationality)
	 EXEC('INSERT INTO dbo.Tmp_Nationality (NationalityCode, Name, Arabic_Name, CountryName, CountryArabic_Name, NationalityType, MappingCode, Serial, CreatedBy, CreationDate, ModifiedBy, ModificationDate)
		SELECT NationalityCode, Name, Arabic_Name, CountryName, CountryArabic_Name, NationalityType, MappingCode, Serial, CreatedBy, CreationDate, ModifiedBy, ModificationDate FROM dbo.Nationality WITH (HOLDLOCK TABLOCKX)')

SET IDENTITY_INSERT dbo.Tmp_Nationality OFF

DROP TABLE dbo.Nationality

EXECUTE sp_rename N'dbo.Tmp_Nationality', N'Nationality', 'OBJECT' 

ALTER TABLE dbo.Nationality ADD CONSTRAINT
	PK_Nationality PRIMARY KEY CLUSTERED 
	(
	NationalityCode
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


COMMIT
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Contract ADD CONSTRAINT
	DF_Contract_FixedTerm DEFAULT ((0)) FOR FixedTerm

ALTER TABLE dbo.Contract ADD CONSTRAINT
	DF_Contract_Closed DEFAULT ((0)) FOR Closed

ALTER TABLE dbo.Contract ADD CONSTRAINT
	DF_Contract_ManualExpireDate DEFAULT ((0)) FOR ManualExpireDate

ALTER TABLE dbo.Contract ADD CONSTRAINT
	DF_Contract_DropDayoffAndHolidays DEFAULT ((0)) FOR DropDayoffAndHolidays

ALTER TABLE dbo.Contract ADD CONSTRAINT
	DF_Contract_DropDayoff DEFAULT ((0)) FOR DropDayoff

ALTER TABLE dbo.Contract SET (LOCK_ESCALATION = TABLE)

COMMIT


GO
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Grade
	DROP CONSTRAINT DF_Grade_CreatedBy

ALTER TABLE dbo.Grade
	DROP CONSTRAINT DF_Grade_CreationDate

CREATE TABLE dbo.Tmp_Grade
	(
	GradeCode int NOT NULL IDENTITY (1, 1),
	Name nvarchar(150) NOT NULL,
	Arabic_Name nvarchar(150) NOT NULL,
	Serial nvarchar(150) NULL,
	CreatedBy int NOT NULL,
	CreationDate datetime NOT NULL,
	ModifiedBy int NULL,
	ModificationDate datetime NULL
	)  ON [PRIMARY]

ALTER TABLE dbo.Tmp_Grade SET (LOCK_ESCALATION = TABLE)

ALTER TABLE dbo.Tmp_Grade ADD CONSTRAINT
	DF_Grade_CreatedBy DEFAULT ((1)) FOR CreatedBy

ALTER TABLE dbo.Tmp_Grade ADD CONSTRAINT
	DF_Grade_CreationDate DEFAULT (getdate()) FOR CreationDate

SET IDENTITY_INSERT dbo.Tmp_Grade ON

IF EXISTS(SELECT * FROM dbo.Grade)
	 EXEC('INSERT INTO dbo.Tmp_Grade (GradeCode, Name, Arabic_Name, Serial, CreatedBy, CreationDate, ModifiedBy, ModificationDate)
		SELECT GradeCode, Name, Arabic_Name, Serial, CreatedBy, CreationDate, ModifiedBy, ModificationDate FROM dbo.Grade WITH (HOLDLOCK TABLOCKX)')

SET IDENTITY_INSERT dbo.Tmp_Grade OFF

ALTER TABLE dbo.Rec_RecruitEmployeeEducation
	DROP CONSTRAINT FK_Rec_RecruitEmployeeEducation_Grade

DROP TABLE dbo.Grade

EXECUTE sp_rename N'dbo.Tmp_Grade', N'Grade', 'OBJECT' 

ALTER TABLE dbo.Grade ADD CONSTRAINT
	PK_Grade PRIMARY KEY CLUSTERED 
	(
	GradeCode
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Rec_RecruitEmployeeEducation ADD CONSTRAINT
	FK_Rec_RecruitEmployeeEducation_Grade FOREIGN KEY
	(
	GradeCode
	) REFERENCES dbo.Grade
	(
	GradeCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Rec_RecruitEmployeeEducation SET (LOCK_ESCALATION = TABLE)

COMMIT

GO

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Guest
	DROP CONSTRAINT DF_Guest_CreatedBy

ALTER TABLE dbo.Guest
	DROP CONSTRAINT DF_Guest_CreationDate

CREATE TABLE dbo.Tmp_Guest
	(
	GuestCode tinyint NOT NULL IDENTITY (0, 1),
	Name nvarchar(150) NULL,
	Arabic_Name nvarchar(150) NULL,
	Categ nvarchar(150) NULL,
	CreatedBy int NOT NULL,
	CreationDate datetime NOT NULL,
	ModifiedBy int NULL,
	ModificationDate datetime NULL
	)  ON [PRIMARY]

ALTER TABLE dbo.Tmp_Guest SET (LOCK_ESCALATION = TABLE)

ALTER TABLE dbo.Tmp_Guest ADD CONSTRAINT
	DF_Guest_CreatedBy DEFAULT ((1)) FOR CreatedBy

ALTER TABLE dbo.Tmp_Guest ADD CONSTRAINT
	DF_Guest_CreationDate DEFAULT (getdate()) FOR CreationDate

SET IDENTITY_INSERT dbo.Tmp_Guest ON

IF EXISTS(SELECT * FROM dbo.Guest)
	 EXEC('INSERT INTO dbo.Tmp_Guest (GuestCode, Name, Arabic_Name, Categ, CreatedBy, CreationDate, ModifiedBy, ModificationDate)
		SELECT GuestCode, Name, Arabic_Name, Categ, CreatedBy, CreationDate, ModifiedBy, ModificationDate FROM dbo.Guest WITH (HOLDLOCK TABLOCKX)')

SET IDENTITY_INSERT dbo.Tmp_Guest OFF

DROP TABLE dbo.Guest

EXECUTE sp_rename N'dbo.Tmp_Guest', N'Guest', 'OBJECT' 
GO
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES(13140,N'رفع وحدات المشاريع ',N'Upload Upload project units',1036,2)
GO

----------------------------------- End 2024-04-02 ------------------
