﻿
------------------------------------ M.Negm 2024-03-17 -----------------------------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1060,N'Work Quit Types',N'أنواع ترك العمل',1023,N'/Personal/WorkQuitTypes',N'Index','fa fa-thumb-tack',N'get',15,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4126,N'أنواع ترك العمل',N'Work Quit Types',1060,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4127,N'عرض أنواع ترك العمل',N'View Work Quit Types',1060,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4128,N'إضافة أنواع ترك العمل',N'Add Work Quit Types',1060,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4129,N'تعديل أنواع ترك العمل',N'Edit Work Quit Types',1060,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4130,N'حذف أنواع ترك العمل',N'Delete Work Quit Types',1060,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4131,N'حفظ أنواع ترك العمل',N'Save Work Quit Types',1060,2)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1624,N'Personal',N'WorkQuitTypes',N'Index',0,N'get',4126)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1625,N'Personal',N'WorkQuitTypes',N'WorkQuitTypes_Read',0,N'post',4127)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1626,N'Personal',N'WorkQuitTypes',N'Save',1,N'get',4128)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1627,N'Personal',N'WorkQuitTypes',N'Save',2,N'get',4129)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1628,N'Personal',N'WorkQuitTypes',N'Delete',0,N'post',4130)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1629,N'Personal',N'WorkQuitTypes',N'Save',0,N'post',4131)


INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1085,NULL, NULL,N'WorkQuitTypes',N'GetWorkQuitTypesSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1086,NULL, NULL,N'WorkQuitTypes',N'GetWorkQuitTypes',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1087,NULL, NULL,N'WorkQuitTypes',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1088,NULL, NULL,N'WorkQuitTypes',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1089,NULL, NULL,N'WorkQuitTypes',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1090,NULL, NULL,N'WorkQuitTypes',N'Get',N'Get')
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1362,1085,4127, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1363,1086,4127, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1364,1087,4131, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1365,1088,4131, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1366,1089,4130, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1367,1090,4129, NULL)
Go
------------------------------------ End 2024-03-17 ------------------------------------------
------------------------------------ MOstafa 2024-03-17 ------------------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1059,N'Medical Type',N'انواع مصروفات الرعاية الطبية',1023,N'/Personal/MedicalType',N'Index','fa fa-thumb-tack',N'get',14,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1059,22)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4120,N'انواع مصروفات الرعاية الطبية',N'Medical Type',1059,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4121,N'عرض انواع مصروفات الرعاية الطبية',N'View Medical Type',1059,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4122,N'إضافة انواع مصروفات الرعاية الطبية',N'Add Medical Type',1059,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4123,N'تعديل انواع مصروفات الرعاية الطبية',N'Edit Medical Type',1059,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4124,N'حذف انواع مصروفات الرعاية الطبية',N'Delete Medical Type',1059,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4125,N'حفظ انواع مصروفات الرعاية الطبية',N'Save Medical Type',1059,2)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1618,N'Personal',N'MedicalType',N'Index',0,N'get',4120)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1619,N'Personal',N'MedicalType',N'MedicalType_Read',0,N'post',4121)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1620,N'Personal',N'MedicalType',N'Save',1,N'get',4122)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1621,N'Personal',N'MedicalType',N'Save',2,N'get',4123)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1622,N'Personal',N'MedicalType',N'Delete',0,N'post',4124)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1623,N'Personal',N'MedicalType',N'Save',0,N'post',4125)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1079,NULL, NULL,N'MedicalType',N'GetMedicalTypeSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1080,NULL, NULL,N'MedicalType',N'GetMedicalType',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1081,NULL, NULL,N'MedicalType',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1082,NULL, NULL,N'MedicalType',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1083,NULL, NULL,N'MedicalType',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1084,NULL, NULL,N'MedicalType',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1356,1079,4121, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1357,1080,4121, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1358,1081,4125, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1359,1082,4125, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1360,1083,4124, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1361,1084,4123, NULL)
Go
------------------------------------ End 2024-03-17 ------------------------------------------
------------------------------------ Ali 2024-03-17 ------------------------------------------


/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
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 FK_Nationality_MappingNationality

ALTER TABLE dbo.MappingResources SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Nationality
	DROP CONSTRAINT DF_Nationality_NationalityCode

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

ALTER TABLE dbo.Tmp_Nationality SET (LOCK_ESCALATION = TABLE)

SET IDENTITY_INSERT dbo.Tmp_Nationality ON


BEGIN TRY
  IF EXISTS (SELECT * FROM dbo.Nationality)
   EXEC('INSERT INTO dbo.Tmp_Nationality (NationalityCode, Name, Arabic_Name, CountryName, CountryArabic_Name, NationalityType, MappingCode)
		SELECT NationalityCode, Name, Arabic_Name, CountryName, CountryArabic_Name, NationalityType, MappingCode FROM dbo.Nationality WITH (HOLDLOCK TABLOCKX)')
END TRY
BEGIN CATCH
  -- Handle potential errors during data insertion (e.g., log the error and rollback)
  DECLARE @errorMessage nvarchar(max);
  SELECT @errorMessage = ERROR_MESSAGE();
  PRINT 'Error occurred during data insertion: ' + @errorMessage;
  ROLLBACK TRANSACTION;
END CATCH;


SET IDENTITY_INSERT dbo.Tmp_Nationality OFF

ALTER TABLE dbo.Rec_RecruitEmployee
	DROP CONSTRAINT FK_Rec_RecruitEmployee_Nationality

ALTER TABLE dbo.Rec_RecruitJobNationalities
	DROP CONSTRAINT FK_Rec_RecruitJobNationalities_Nationality

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]

ALTER TABLE dbo.Nationality ADD CONSTRAINT
	FK_Nationality_MappingNationality FOREIGN KEY
	(
	MappingCode
	) REFERENCES dbo.MappingResources
	(
	MappingResourceCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Rec_RecruitJobNationalities ADD CONSTRAINT
	FK_Rec_RecruitJobNationalities_Nationality FOREIGN KEY
	(
	NationalityCode
	) REFERENCES dbo.Nationality
	(
	NationalityCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Rec_RecruitJobNationalities SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Rec_RecruitEmployee ADD CONSTRAINT
	FK_Rec_RecruitEmployee_Nationality FOREIGN KEY
	(
	NationalityCode
	) REFERENCES dbo.Nationality
	(
	NationalityCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Rec_RecruitEmployee SET (LOCK_ESCALATION = TABLE)

COMMIT

ALTER TABLE dbo.Nationality ADD
	CreatedBy int NOT NULL CONSTRAINT DF_Nationality_CreatedBy DEFAULT ((1)),
	CreationDate datetime NOT NULL CONSTRAINT DF_Nationality_CreationDate DEFAULT (getdate()),
	ModifiedBy int NULL,
	ModificationDate datetime NULL
GO

Alter Table Nationality
Add  Serial nvarchar(150)  ;


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1057,N'Nationality',N'الجنسية',1023,N'/Personal/Nationality',N'Index','fa fa-thumb-tack',N'get',14,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4108,N'الجنسية',N'Nationality',1057,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4109,N'عرض الجنسية',N'View Nationality',1057,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4110,N'إضافة الجنسية',N'Add Nationality',1057,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4111,N'تعديل الجنسية',N'Edit Nationality',1057,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4112,N'حذف الجنسية',N'Delete Nationality',1057,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4113,N'حفظ الجنسية',N'Save Nationality',1057,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(1591,N'Personal',N'Nationality',N'Index',0,N'get',4108)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1592,N'Personal',N'Nationality',N'Nationality_Read',0,N'post',4109)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1593,N'Personal',N'Nationality',N'Save',1,N'get',4110)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1594,N'Personal',N'Nationality',N'Save',2,N'get',4111)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1595,N'Personal',N'Nationality',N'Delete',0,N'post',4112)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1596,N'Personal',N'Nationality',N'Save',0,N'post',4113)

-- 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(1066,NULL, NULL,N'Nationality',N'GetNationalitySearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1067,NULL, NULL,N'Nationality',N'GetNationality',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1068,NULL, NULL,N'Nationality',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1069,NULL, NULL,N'Nationality',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1070,NULL, NULL,N'Nationality',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1071,NULL, NULL,N'Nationality',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(1344,1066,4109, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1345,1067,4109, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1346,1068,4113, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1347,1069,4113, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1348,1070,4112, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1349,1071,4111, NULL)
Go

update nationality set serial = nationalitycode

------------------------------------ End 2024-03-17 ------------------------------------------
------------------------------------ Ali 2024-03-17 ------------------------------------------

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1597, N'WorkFlow', N'CompensationRequestForADayOfRestApi', N'Cancel', 0, N'post', 3379)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1598, N'WorkFlow', N'CompensationDayOfRestRequestSignatureApi', N'Index', 0, N'get', 3381)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1599, N'WorkFlow', N'CompensationDayOfRestRequestSignatureApi', N'CompensationRequestForADayOfRest_Read', 0, N'post', 3382)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1600, N'WorkFlow', N'CompensationDayOfRestRequestSignatureApi', N'Save', 2, N'get', 3383)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1601, N'WorkFlow', N'CompensationDayOfRestRequestSignatureApi', N'Save', 0, N'post', 3384)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1602, N'WorkFlow', N'CompensationReqFinalDayRestSignatureApi', N'Index', 0, N'get', 3390)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1603, N'WorkFlow', N'CompensationReqFinalDayRestSignatureApi', N'CompensationRequestFinal_Read', 0, N'post', 3391)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1604, N'WorkFlow', N'CompensationReqFinalDayRestSignatureApi', N'Save', 2, N'get', 3392)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1605, N'WorkFlow', N'CompensationReqFinalDayRestSignatureApi', N'Save', 0, N'post', 3393)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1606, N'WorkFlow', N'CompensationRequestForADayOfRestApi', N'Index', 0, N'get', 3374)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1607, N'WorkFlow', N'CompensationRequestForADayOfRestApi', N'CompensationRequestForADayOfRest_Read', 0, N'post', 3375)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1608, N'WorkFlow', N'CompensationRequestForADayOfRestApi', N'Save', 1, N'get', 3376)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1609, N'WorkFlow', N'CompensationRequestForADayOfRestApi', N'Save', 2, N'get', 3377)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1610, N'WorkFlow', N'CompensationRequestForADayOfRestApi', N'Delete', 0, N'post', 3378)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1611, N'WorkFlow', N'CompensationRequestForADayOfRestApi', N'Save', 0, N'post', 3380)
Go

------------------------------------ End 2024-03-17 ------------------------------------------
--------------------------------------M.Negm 2024-03-17 ----------------------------


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

CREATE TABLE dbo.Tmp_RelativeTypes
	(
	RelativeTypeCode int NOT NULL IDENTITY (1, 1),
	Name nvarchar(255) NULL,
	Arabic_Name nvarchar(255) NULL,
	MDT datetime NULL
	)  ON [PRIMARY]

ALTER TABLE dbo.Tmp_RelativeTypes SET (LOCK_ESCALATION = TABLE)

SET IDENTITY_INSERT dbo.Tmp_RelativeTypes ON


BEGIN TRY
IF EXISTS(SELECT * FROM dbo.RelativeTypes)
	 EXEC('INSERT INTO dbo.Tmp_RelativeTypes (RelativeTypeCode, Name, Arabic_Name, MDT)
		SELECT RelativeTypeCode, Name, Arabic_Name, MDT FROM dbo.RelativeTypes WITH (HOLDLOCK TABLOCKX)')
		
END TRY
BEGIN CATCH
  -- Handle potential errors during data insertion (e.g., log the error and rollback)
  DECLARE @errorMessage nvarchar(max);
  SELECT @errorMessage = ERROR_MESSAGE();
  PRINT 'Error occurred during data insertion: ' + @errorMessage;
  ROLLBACK TRANSACTION;
END CATCH;



SET IDENTITY_INSERT dbo.Tmp_RelativeTypes OFF

DROP TABLE dbo.RelativeTypes

EXECUTE sp_rename N'dbo.Tmp_RelativeTypes', N'RelativeTypes', 'OBJECT' 

ALTER TABLE dbo.RelativeTypes ADD CONSTRAINT
	PK_RelativeTypes PRIMARY KEY CLUSTERED 
	(
	RelativeTypeCode
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


COMMIT


ALTER TABLE dbo.RelativeTypes ADD
	CreatedBy int NOT NULL CONSTRAINT DF_RelativeTypes_CreatedBy DEFAULT ((1)),
	CreationDate datetime NOT NULL CONSTRAINT DF_RelativeTypes_CreationDate DEFAULT (getdate()),
	ModifiedBy int NULL,
	ModificationDate datetime NULL



Alter Table RelativeTypes
Add  Serial nvarchar(150)  ;


   ALTER TABLE RelativeTypes
    ADD Closed BIT
    DEFAULT 0 NOT NULL;

update RelativeTypes set Serial = RelativeTypeCode;


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1061,N'Relative Types',N'نوع القرابة',1023,N'/Personal/RelativeTypes',N'Index','fa fa-thumb-tack',N'get',16,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4132,N'نوع القرابة',N'Relative Types',1061,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4133,N'عرض نوع القرابة',N'View Relative Types',1061,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4134,N'إضافة نوع القرابة',N'Add Relative Types',1061,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4135,N'تعديل نوع القرابة',N'Edit Relative Types',1061,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4136,N'حذف نوع القرابة',N'Delete Relative Types',1061,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4137,N'حفظ نوع القرابة',N'Save Relative Types',1061,2)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1630,N'Personal',N'RelativeTypes',N'Index',0,N'get',4132)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1631,N'Personal',N'RelativeTypes',N'RelativeTypes_Read',0,N'post',4133)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1632,N'Personal',N'RelativeTypes',N'Save',1,N'get',4134)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1633,N'Personal',N'RelativeTypes',N'Save',2,N'get',4135)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1634,N'Personal',N'RelativeTypes',N'Delete',0,N'post',4136)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1635,N'Personal',N'RelativeTypes',N'Save',0,N'post',4137)


INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1091,NULL, NULL,N'RelativeTypes',N'GetRelativeTypesSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1092,NULL, NULL,N'RelativeTypes',N'GetRelativeTypes',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1093,NULL, NULL,N'RelativeTypes',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1094,NULL, NULL,N'RelativeTypes',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1095,NULL, NULL,N'RelativeTypes',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1096,NULL, NULL,N'RelativeTypes',N'Get',N'Get')
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1368,1091,4133, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1369,1092,4133, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1370,1093,4137, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1371,1094,4137, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1372,1095,4136, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1373,1096,4135, NULL)
Go
----------------------------------End 2024-03-17 ------------------------------------------
----------------------------------Mostafa 2024-03-17 ------------------------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1062,N'Human Resource',N'شئون العاملين',1023,null,null,'fa fa fa-users',null,1,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1062,22)
Go
update  [SystemMenu] set [ParentID]=1062 where [ParentID]=1023
GO
update  [SystemMenu] set [ParentID]=1023 where [SystemMenuCode]=1062
GO
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1063,N'Educational data',N'البيانات التعليمية',1023,null,null,'fa fa-graduation-cap',null,1,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1063,22)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4150,N'البيانات التعليمية',N'Educational',1062,2)
Go
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1064,N'Faculties',N'الكليات',1063,N'/Personal/Faculty',N'Index','fa fa-thumb-tack',N'get',1,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1064,22)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4138,N'الكلية',N'Faculty',1064,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4139,N'عرض الكلية',N'View Faculty',1064,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4140,N'إضافة الكلية',N'Add Faculty',1064,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4141,N'تعديل الكلية',N'Edit Faculty',1064,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4142,N'حذف الكلية',N'Delete Faculty',1064,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4143,N'حفظ الكلية',N'Save Faculty',1064,2)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1636,N'Personal',N'Faculty',N'Index',0,N'get',4138)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1637,N'Personal',N'Faculty',N'Faculty_Read',0,N'post',4139)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1638,N'Personal',N'Faculty',N'Save',1,N'get',4140)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1639,N'Personal',N'Faculty',N'Save',2,N'get',4141)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1640,N'Personal',N'Faculty',N'Delete',0,N'post',4142)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1641,N'Personal',N'Faculty',N'Save',0,N'post',4143)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1097,NULL, NULL,N'Faculty',N'GetFacultySearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1099,NULL, NULL,N'Faculty',N'GetFaculty',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1100,NULL, NULL,N'Faculty',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1101,NULL, NULL,N'Faculty',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1102,NULL, NULL,N'Faculty',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1103,NULL, NULL,N'Faculty',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1374,1097,4139, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1375,1099,4139, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1376,1100,4143, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1377,1101,4143, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1378,1102,4142, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1379,1103,4141, NULL)
Go

----------------------------------End 2024-03-17 ------------------------------------------
----------------------------------End 2024-03-19 ------------------------------------------
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4151,N'شئون العاملين',N'Human Resource',1062,2)
GO
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4150,N'البيانات التعليمية',N'Educational data',1063,2)
GO
----------------------------------End 2024-03-19 ------------------------------------------
----------------------------------’Mostafa 2024-03-19 ------------------------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1067,N'Qualification',N'الموهلات',1063,N'/Personal/Qualification',N'Index','fa fa-thumb-tack',N'get',1,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1067,22)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4158,N'الموهلات',N'Qualification',1067,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4159,N'عرض الموهلات',N'View Qualification',1067,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4160,N'إضافة الموهلات',N'Add Qualification',1067,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4161,N'تعديل الموهلات',N'Edit Qualification',1067,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4162,N'حذف الموهلات',N'Delete Qualification',1067,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(4163,N'حفظ الموهلات',N'Save Qualification',1067,2)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1654,N'Personal',N'Qualification',N'Index',0,N'get',4158)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1655,N'Personal',N'Qualification',N'Qualification_Read',0,N'post',4159)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1656,N'Personal',N'Qualification',N'Save',1,N'get',4160)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1657,N'Personal',N'Qualification',N'Save',2,N'get',4161)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1658,N'Personal',N'Qualification',N'Delete',0,N'post',4162)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1659,N'Personal',N'Qualification',N'Save',0,N'post',4163)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1116,NULL, NULL,N'Qualification',N'GetQualificationSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1117,NULL, NULL,N'Qualification',N'GetQualification',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1118,NULL, NULL,N'Qualification',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1119,NULL, NULL,N'Qualification',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1120,NULL, NULL,N'Qualification',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1121,NULL, NULL,N'Qualification',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1392,1116,4159, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1393,1117,4159, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1394,1118,4163, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1395,1119,4163, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1396,1120,4162, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1397,1121,4161, NULL)
Go
----------------------------------End 2024-03-19 ------------------------------------------
----------------------------------Ali 2024-03-19 ------------------------------------------

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
VALUES(15466,N'تعديل مكان المامورية',N'Edit Mission Place',37,2)
Go

----------------------------------End 2024-03-19 ------------------------------------------
