﻿
----------------------------Ali 2022-04-20----------------

  INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(609,N'Financial Transaction',N'الحركات الماليه',583,N'',N'','fas fa-hand-holding-usd',N'',5,1,1)
Go

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

  update SystemMenu set Arabic_Name=N'ادارة الحركات الماليه', name =N'Managing Cash Transactions', ParentID=609,Sequence=1
  where SystemMenuCode=606
  Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(608,N'Financial Transaction Posting',N'ترحيل الحركات الماليه',608,N'/GenerlLedger/FinancialTransactionPosting',N'Index','fa fa-thumb-tack',N'get',2,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23066,N'ترحيل الحركات الماليه',N'Financial Transaction Posting',608,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23067,N'عرض ترحيل الحركات الماليه',N'View Financial Transaction Posting',608,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23068,N'حفظ ترحيل الحركات الماليه',N'Save Financial Transaction Posting',608,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1026,N'GenerlLedger',N'FinancialTransactionPosting',N'Index',0,N'get',23066)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1027,N'GenerlLedger',N'FinancialTransactionPosting',N'FinancialTransactionPosting_Read',0,N'post',23067)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1028,N'GenerlLedger',N'FinancialTransactionPosting',N'Save',0,N'post',23068)
GO

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(610,N'Cancel Financial Transaction posting',N'الغاء ترحيل الحركات الماليه',609,N'/GenerlLedger/CancelFinancialTransactionPosting',N'Index','fa fa-thumb-tack',N'get',3,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23071,N'الغاء ترحيل الحركات الماليه',N'Cancel Financial Transaction posting',610,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23072,N'عرض الغاء ترحيل الحركات الماليه',N'View Cancel Financial Transaction posting',610,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23073,N'حفظ الغاء ترحيل الحركات الماليه',N'Save Cancel Financial Transaction posting',610,2)
Go

 INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1029,N'GenerlLedger',N'CancelFinancialTransactionPosting',N'Index',0,N'get',23071)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1030,N'GenerlLedger',N'CancelFinancialTransactionPosting',N'CancelFinancialTransactionPosting_Read',0,N'post',23072)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1031,N'GenerlLedger',N'CancelFinancialTransactionPosting',N'Save',0,N'post',23073)
GO


----------------------------End 2022-04-20----------------
----------------------------Hammad 2022-04-24----------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'RecPreviousExperienceDisplay', N'Display Previous Experience ', N'    عرض الخبرات السابقة ', N'true', 14, 2, 1, 1, NULL, NULL, NULL)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'RecContactInformationDisplay', N'Display Contact Information ', N'   عرض بيانات التواصل  ', N'true', 14, 1, 1, 1, NULL, NULL, NULL)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'RecCertificatesInformationDisplay', N'Certificates Information Display', N'    عرض بيانات الشهادات  ', N'true', 14, 6, 1, 1, NULL, NULL, NULL)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'RecQualificationsInformationDisplay', N'Qualifications Information Display', N'    عرض بيانات المؤهلات الدراسية  ', N'true', 14, 3, 1, 1, NULL, NULL, NULL)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'RecReferencesInformationDisplay', N'References  Information Display', N'   عرض  بيانات المرجع ', N'true', 14, 7, 1, 1, NULL, NULL, NULL)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'RecSkillsInformationDisplay', N' Skills Information Display', N'    عرض بيانات  المهارات  ', N'true', 14, 4, 1, 1, NULL, NULL, NULL)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'RecTrainingInformationDisplay', N'Training Information Display', N'    عرض بيانات التدريب  ', N'true', 14, 5, 1, 1, NULL, NULL, NULL)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'RecSkillsInformationDisplay', N' Skills Information Display', N'    عرض بيانات  المهارات  ', N'true', 14, 4, 1, 1, NULL, NULL, NULL)
GO
----------------------------End 2022-04-24----------------
----------------------------MOstafa 2022-04-26----------------
 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFHideVacationBalance',N'Hide Vacation Balance',N'اخفاء رصيد الأجازات',N'false',2,6,1,1,Null,Null,7)
Go
----------------------------End 2022-04-26----------------
----------------------------Mostafa 2022-04-27----------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(611,N'Monthly Effects Request Report',N'تقرير طلب مؤثرات شهري',94,N'/WorkFlow/MonthlyEffectsRequestReport',N'Index','fa fa-thumb-tack',N'get',2,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(611,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15297,N'تقرير طلب مؤثرات شهري',N'Monthly Effects Request Report',611,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15298,N'عرض تقرير طلب مؤثرات شهري',N'View Monthly Effects Request Report',611,2)
Go
----------------------------End 2022-04-27----------------
----------------------------MOstafa 2022-04-27----------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(612,N'Update Evaluation Data',N'تحديث بيانات التقييم',161,N'/Appraisal/UpdateEvaluationData',N'Index','fa fa-pencil-square-o',N'get',22,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(612,8)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10102,N'تحديث بيانات التقييم',N'Update Evaluation Data',612,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10103,N'عرض تحديث بيانات التقييم',N'View Update Evaluation Data',612,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10104,N'إضافة تحديث بيانات التقييم',N'Add Update Evaluation Data',612,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10105,N'تعديل تحديث بيانات التقييم',N'Edit Update Evaluation Data',612,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10106,N'حذف تحديث بيانات التقييم',N'Delete Update Evaluation Data',612,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10107,N'حفظ تحديث بيانات التقييم',N'Save Update Evaluation Data',612,2)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1032,N'Appraisal',N'UpdateEvaluationData',N'Index',0,N'get',10102)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1033,N'Appraisal',N'UpdateEvaluationData',N'UpdateEvaluationData_Read',0,N'post',10103)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1034,N'Appraisal',N'UpdateEvaluationData',N'Save',1,N'get',10104)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1035,N'Appraisal',N'UpdateEvaluationData',N'Save',2,N'get',10105)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1036,N'Appraisal',N'UpdateEvaluationData',N'Delete',0,N'post',10106)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1037,N'Appraisal',N'UpdateEvaluationData',N'Save',0,N'post',10107)
go
----------------------------End 2022-04-27----------------
----------------------------MOstafa 2022-04-28----------------


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
GO
ALTER TABLE dbo.AC_TransactionAuthorityImage ADD
	ReceivingData datetime NULL,
	ReceivingBy int NULL
GO
ALTER TABLE dbo.AC_TransactionAuthorityImage SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
Go
----------------------------End 2022-04-28----------------
----------------------------Ali 2022-04-28----------------

INSERT [dbo].[ConfigCategory] ([ConfigCategoryCode], [Name], [Arabic_Name]) VALUES (20, N'Academic Requests', N'الطلبات الاكاديمى')
Go
INSERT [dbo].[ConfigCategoryModule] ([ConfigCategoryCode], [AppModuleCode]) VALUES ( 20, 16)
Go

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'AcademicResearchProfileReqIsApplyDuplicate',N'? Can Add more than Request on the same day',N'امكانية اضافة اكثر من طلب فى نفس اليوم ؟',N'False',20,1,1,1,Null,Null,32)
Go

   INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'AcademicPublicationReqIsApplyDuplicate',N'? Can Add more than Request on the same day',N'امكانية اضافة اكثر من طلب فى نفس اليوم ؟',N'False',20,1,1,1,Null,Null,33)
Go

   INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'AcademicScientificReqIsApplyDuplicate',N'? Can Add more than Request on the same day',N'امكانية اضافة اكثر من طلب فى نفس اليوم ؟',N'False',20,1,1,1,Null,Null,34)
Go

INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'AcademicCommitteeReqIsApplyDuplicate',N'? Can Add more than Request on the same day',N'امكانية اضافة اكثر من طلب فى نفس اليوم ؟',N'False',20,1,1,1,Null,Null,35)
Go

INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'AcademicProfDevCommunityServiceReqIsApplyDuplicate',N'? Can Add more than Request on the same day',N'امكانية اضافة اكثر من طلب فى نفس اليوم ؟',N'False',20,1,1,1,Null,Null,36)
Go

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'AcademicAwardReqIsApplyDuplicate',N'? Can Add more than Request on the same day',N'امكانية اضافة اكثر من طلب فى نفس اليوم ؟',N'False',20,1,1,1,Null,Null,37)
Go

INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'AcademicSponserReqIsApplyDuplicate',N'? Can Add more than Request on the same day',N'امكانية اضافة اكثر من طلب فى نفس اليوم ؟',N'False',20,1,1,1,Null,Null,38)
Go

  INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'AcademicCo-ExtraReqIsApplyDuplicate',N'? Can Add more than Request on the same day',N'امكانية اضافة اكثر من طلب فى نفس اليوم ؟',N'False',20,1,1,1,Null,Null,39)
Go

  INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'AcademicPGSupervisioReqIsApplyDuplicate',N'? Can Add more than Request on the same day',N'امكانية اضافة اكثر من طلب فى نفس اليوم ؟',N'False',20,1,1,1,Null,Null,40)
Go

  INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'AcademicStructuralInstCapBReqIsApplyDuplicate',N'? Can Add more than Request on the same day',N'امكانية اضافة اكثر من طلب فى نفس اليوم ؟',N'False',20,1,1,1,Null,Null,41)
Go

   INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'AcademicScholarshipReqIsApplyDuplicate',N'? Can Add more than Request on the same day',N'امكانية اضافة اكثر من طلب فى نفس اليوم ؟',N'False',20,1,1,1,Null,Null,46)
Go


----------------------------End 2022-04-28----------------