﻿----------------------------MOstafa 2022-05-08----------------
EXEC sp_RENAME 'AC_TransactionAuthorityImage.ReceivingData' , 'ReceivingDate', 'COLUMN'
GO
----------------------------End 2022-05-08----------------
-------------------------------Hammad 2022-03-17---
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'WFNewEmployeeAttachement', N'Attachment mandatory  ', N'  المرفق إجبارى', N'false', 2, 3, 1, 1, NULL, NULL, 14)
GO
-------------------------------End 2022-03-17---
-------------------------------Mostafa 2022-03-17---
 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFNumberMonthsAppointment',N'Number Of Months From The Date of Appointment',N'عدد الشهور من تاريخ التعيين لتقديم طلب',N'0',2,3,2,1,Null,Null,50)
Go
-------------------------------End 2022-03-17---

-------------------------------Ali 2022-05-08---

  ALTER TABLE dbo.WF_RequestType ADD
	WorkedByAssignmentContract bit NOT NULL CONSTRAINT DF_WF_RequestType_WorkedByAssignmentContract DEFAULT ((1))
GO

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'ReadAttendanceFromNextMonth',N'Read Attendance  from the next month',N'قراءة الحضور والانصراف من الشهر التالى',N'false',1,42,1,1,Null,Null,null)
Go

-------------------------------End 2022-05-08---
----------------------------AK 2022-05-08----------------
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.Rec_QuestionTemplate ADD
	IsActive bit NOT NULL CONSTRAINT DF_Rec_QuestionTemplate_IsActive DEFAULT 1
GO
ALTER TABLE dbo.Rec_QuestionTemplate SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
----------------------------End 2022-05-08----------------
----------------------------Hammad 2022-05-09----------------

ALTER TABLE dbo.SecurityUserAuthority ADD
	NotificationSent bit NOT NULL CONSTRAINT DF_SecurityUserAuthority_NotificationSent DEFAULT 0
GO
----------------------------End 2022-05-09----------------
----------------------------Ali 2022-05-09----------------

 delete  from
[ConfigParameter]
 where [ConfigKey]= N'AcademicScholarshipReqIsApplyDuplicate'
 Go
----------------------------End 2022-05-09----------------
----------------------------Hammad 2022-05-09----------------
SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) 
VALUES (326, N'Notification Expiry User Authority Period', N'اشعار بانتهاء مدة تكليف المستخدم لجهة ', 0, 2, NULL, 1)
GO
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
GO

INSERT [dbo].[EmailTemplate] ([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode], [MessageTemplate]) 
VALUES (N'Notification Expiry User Authority Period', N'اشعار بانتهاء مدة تكليف المستخدم لجهة', 326, N'اشعار بانتهاء مدة تكليف المستخدم لجهة ', N'اشعار بانتهاء مدة تكليف المستخدم لجهة ', 1, NULL, NULL, NULL, NULL)
GO
----------------------------End 2022-05-09----------------
---------------------AK 2022-05-09----
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'RecIgnoreTheKillerQuestionInTheEvaluationStage', N'Ignore the killer question in the evaluation stage?', N'تجاهل السؤال القاتل في مرحلة التقييم', N'false', 4, 1, 1, 1, NULL, NULL, NULL)
GO
---------------------End2022-05-09---------
---------------------Mostafa 2022-05-09---------
SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) 
VALUES (327, N'Send Salary Notification', N'إرسال إشعار بالراتب', 0, 6)
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
Go
INSERT [dbo].[EmailTemplate] ([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode]) 
VALUES ( N'Send Salary Notification', N'إرسال إشعار بالراتب', 327, N'إرسال إشعار بالراتب ', N'إرسال إشعار بالراتب', 1, NULL, NULL, NULL)
GO
---------------------End2022-05-09---------
---------------------Mostafa 2022-05-10---------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1314, N'إرسال الإشعار بالراتب', N'Send salary notification', 3, 2)
GO
---------------------End2022-05-10---------
---------------------Ali 2022-05-10---------

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

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

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

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

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


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


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

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

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

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

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

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

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

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

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

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

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

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

GO


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

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

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

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

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

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

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

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

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

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

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

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

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

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


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(590,N'Journals',N'القيود',584,N'/GenerlLedger/Journal',N'Index','fa fa-thumb-tack',N'get',3,1,1)
Go

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


INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23014,N'القيود',N'Journals',590,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23015,N'عرض  القيود',N'View Journals',590,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23016,N'إضافة  القيود',N'Add Journals',590,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23017,N'تعديل  القيود',N'Edit Journals',590,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23018,N'حذف  القيود',N'Delete Journals',590,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23019,N'حفظ  القيود',N'Save Journals',590,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(964,N'GenerlLedger',N'Journal',N'Index',0,N'get',23014)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(965,N'GenerlLedger',N'Journal',N'Journal_Read',0,N'post',23015)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(966,N'GenerlLedger',N'Journal',N'Save',1,N'get',23016)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(967,N'GenerlLedger',N'Journal',N'Save',2,N'get',23017)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(968,N'GenerlLedger',N'Journal',N'Delete',0,N'post',23018)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(969,N'GenerlLedger',N'Journal',N'Save',0,N'post',23019)
Go


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(591,N'Taxes types',N'انواع الضرائب',584,N'/GenerlLedger/Taxestype',N'Index','fa fa-thumb-tack',N'get',4,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23020,N'انواع الضرائب',N'Taxes types',591,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23021,N'عرض انواع الضرائب',N'View Taxes types',591,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23022,N'إضافة انواع الضرائب',N'Add Taxes types',591,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23023,N'تعديل انواع الضرائب',N'Edit Taxes types',591,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23024,N'حذف انواع الضرائب',N'Delete Taxes types',591,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23025,N'حفظ انواع الضرائب',N'Save Taxes types',591,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(970,N'GenerlLedger',N'Taxestype',N'Index',0,N'get',23020)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(971,N'GenerlLedger',N'Taxestype',N'Taxestype_Read',0,N'post',23021)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(972,N'GenerlLedger',N'Taxestype',N'Save',1,N'get',23022)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(973,N'GenerlLedger',N'Taxestype',N'Save',2,N'get',23023)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(974,N'GenerlLedger',N'Taxestype',N'Delete',0,N'post',23024)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(975,N'GenerlLedger',N'Taxestype',N'Save',0,N'post',23025)
Go


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(592,N'Currency',N'العملة',584,N'/GenerlLedger/Currency',N'Index','fa fa-thumb-tack',N'get',5,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23026,N'العملة',N'Currency',592,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23027,N'عرض العملة',N'View Currency',592,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23028,N'إضافة العملة',N'Add Currency',592,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23029,N'تعديل العملة',N'Edit Currency',592,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23030,N'حذف العملة',N'Delete Currency',592,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23031,N'حفظ العملة',N'Save Currency',592,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(976,N'GenerlLedger',N'Currency',N'Index',0,N'get',23020)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(977,N'GenerlLedger',N'Currency',N'Currency_Read',0,N'post',23021)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(978,N'GenerlLedger',N'Currency',N'Save',1,N'get',23022)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(979,N'GenerlLedger',N'Currency',N'Save',2,N'get',23023)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(980,N'GenerlLedger',N'Currency',N'Delete',0,N'post',23024)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(981,N'GenerlLedger',N'Currency',N'Save',0,N'post',23025)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(593,N'Exchange Rate',N'سعر الصرف',584,N'/GenerlLedger/ExchangeRate',N'index','fa fa-money',N'get',6,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23032,N'سعر الصرف',N'Exchange Rate',593,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23033,N'عرض سعر الصرف',N'View Exchange Rate',593,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23034,N'إضافة سعر الصرف',N'Add Exchange Rate',593,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23035,N'تعديل سعر الصرف',N'Edit Exchange Rate',593,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23036,N'حذف سعر الصرف',N'Delete Exchange Rate',593,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23037,N'حفظ سعر الصرف',N'Save Exchange Rate',593,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(982,N'GenerlLedger',N'ExchangeRate',N'Index',0,N'get',23032)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(983,N'GenerlLedger',N'ExchangeRate',N'ExchangeRate_Read',0,N'post',23033)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(984,N'GenerlLedger',N'ExchangeRate',N'Save',1,N'get',23034)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(985,N'GenerlLedger',N'ExchangeRate',N'Save',2,N'get',23035)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(986,N'GenerlLedger',N'ExchangeRate',N'Delete',0,N'post',23036)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(987,N'GenerlLedger',N'ExchangeRate',N'Save',0,N'post',23037)


update SystemMenu set Name=N'Journal Type',Arabic_Name=N'أنواع اليومية',ControllerName=N'/GenerlLedger/JournalType' where SystemMenuCode=590
Go
update SecurityPrivilege set DescriptionEN=N'Journal Type',DescriptionAR=N'أنواع اليومية' where ID=23014
update SecurityPrivilege set DescriptionEN=N'View Journal Type',DescriptionAR=N'عرض أنواع اليومية' where ID=23015
update SecurityPrivilege set DescriptionEN=N'Add Journal Type',DescriptionAR=N'إضافة أنواع اليومية' where ID=23016
update SecurityPrivilege set DescriptionEN=N'Edit Journal Type',DescriptionAR=N'تعديل أنواع اليومية' where ID=23017
update SecurityPrivilege set DescriptionEN=N'Delete Journal Type',DescriptionAR=N'حذف أنواع اليومية' where ID=23018
update SecurityPrivilege set DescriptionEN=N'Save Journal Type',DescriptionAR=N'حفظ أنواع اليومية' where ID=23019
Go
update SecurityPrivilegeActions set ControllerName=N'JournalType' where ControllerName=N'Journal'
update SecurityPrivilegeActions set ActionName=N'JournalType_Read' where ID=965
Go


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(594,N'Safes',N'الخزن',584,N'/GenerlLedger/Safe',N'Index','fa fa-thumb-tack',N'get',7,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23038,N'الخزن',N'Safes',594,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23039,N'عرض الخزن',N'View Safes',594,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23040,N'إضافة الخزن',N'Add Safes',594,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23041,N'تعديل الخزن',N'Edit Safes',594,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23042,N'حذف الخزن',N'Delete Safes',594,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23043,N'حفظ الخزن',N'Save Safes',594,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(988,N'GenerlLedger',N'Safe',N'Index',0,N'get',23038)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(989,N'GenerlLedger',N'Safe',N'Safe_Read',0,N'post',23039)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(990,N'GenerlLedger',N'Safe',N'Save',1,N'get',23040)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(991,N'GenerlLedger',N'Safe',N'Save',2,N'get',23041)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(992,N'GenerlLedger',N'Safe',N'Delete',0,N'post',23042)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(993,N'GenerlLedger',N'Safe',N'Save',0,N'post',23043)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(595,N'Banks',N'البنوك',584,N'/GenerlLedger/Bank',N'Index','fa fa-thumb-tack',N'get',8,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23044,N'البنوك',N'Banks',595,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23045,N'عرض البنوك',N'View Banks',595,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23046,N'إضافة البنوك',N'Add Banks',595,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23047,N'تعديل البنوك',N'Edit Banks',595,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23048,N'حذف البنوك',N'Delete Banks',595,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23049,N'حفظ البنوك',N'Save Banks',595,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(994,N'GenerlLedger',N'Bank',N'Index',0,N'get',23044)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(995,N'GenerlLedger',N'Bank',N'Bank_Read',0,N'post',23045)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(996,N'GenerlLedger',N'Bank',N'Save',1,N'get',23046)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(997,N'GenerlLedger',N'Bank',N'Save',2,N'get',23047)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(998,N'GenerlLedger',N'Bank',N'Delete',0,N'post',23048)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(999,N'GenerlLedger',N'Bank',N'Save',0,N'post',23049)
Go

INSERT [dbo].[ConfigCategory] ([ConfigCategoryCode], [Name], [Arabic_Name]) VALUES (18, N'Generl Ledger', N'الحسابات العامه')
Go

 INSERT [dbo].[ConfigCategoryModule] ([ConfigCategoryCode], [AppModuleCode])
VALUES ( 18, 18)
Go

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WorkByMultiCurrencies',N'Work by Multi Currencies',N'العمل بعملات متعدده',N'true',18,1,1,1,Null,Null,null)
Go


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(596,N'General Preparation',N'تهيئه عامه',583,N'/GenerlLedger/GeneralPreparation',N'Index','fa fa-thumb-tack',N'get',2,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(596,18)
Go
  INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (23050, N'التهيئه عامه', N'General Preparation', 596, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (23051, N'حفظ التهيئه عامه', N'Save General Preparation', 596, 2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1000,N'GenerlLedger',N'GeneralPreparation',N'Index',0,N'get',23050)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1001,N'GenerlLedger',N'GeneralPreparation',N'Save',0,N'post',23051)
Go


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(604,N'Journal Entries',N'قيود اليوميه',584,N'/GenerlLedger/JournalHeader',N'Index','fa fa-thumb-tack',N'get',9,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23052,N'قيود اليوميه',N'Journal Entries',604,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23053,N'عرض قيود اليوميه',N'View Journal Entries',604,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23054,N'إضافة قيود اليوميه',N'Add Journal Entries',604,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23055,N'تعديل قيود اليوميه',N'Edit Journal Entries',604,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23056,N'حذف قيود اليوميه',N'Delete Journal Entries',604,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23057,N'حفظ قيود اليوميه',N'Save Journal Entries',604,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1014,N'GenerlLedger',N'JournalHeader',N'Index',0,N'get',23052)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1015,N'GenerlLedger',N'JournalHeader',N'JournalHeader_Read',0,N'post',23053)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1016,N'GenerlLedger',N'JournalHeader',N'Save',1,N'get',23054)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1017,N'GenerlLedger',N'JournalHeader',N'Save',2,N'get',23055)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1018,N'GenerlLedger',N'JournalHeader',N'Delete',0,N'post',23056)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1019,N'GenerlLedger',N'JournalHeader',N'Save',0,N'post',23057)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(607,N'Entries',N'القيود',583,N'',N'','fa fa-thumb-tack',N'',5,1,1)
Go

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

 
  update [SystemMenu] set ParentID= 607 , Sequence=1
  where SystemMenuCode=604 
  Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(606,N'Cash Transactions',N'الحركات الماليه',583,N'/GenerlLedger/CashTransaction',N'Index','fa fa-money',N'get',4,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23058,N'الحركات الماليه',N'Cash Transactions',606,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23059,N'عرض الحركات الماليه',N'View Cash Transactions',606,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23060,N'إضافة الحركات الماليه',N'Add Cash Transactions',606,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23061,N'تعديل الحركات الماليه',N'Edit Cash Transactions',606,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23062,N'حذف الحركات الماليه',N'Delete Cash Transactions',606,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23063,N'حفظ الحركات الماليه',N'Save Cash Transactions',606,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1020,N'GenerlLedger',N'CashTransaction',N'Index',0,N'get',23058)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1021,N'GenerlLedger',N'CashTransaction',N'CashTransaction_Read',0,N'post',23059)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1022,N'GenerlLedger',N'CashTransaction',N'Save',1,N'get',23060)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1023,N'GenerlLedger',N'CashTransaction',N'Save',2,N'get',23061)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1024,N'GenerlLedger',N'CashTransaction',N'Delete',0,N'post',23062)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1025,N'GenerlLedger',N'CashTransaction',N'Save',0,N'post',23063)
Go

  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

update SystemMenu set ParentID=609 where SystemMenuCode=608
Go
---------------------End 2022-05-10---------
---------------------Mostafa 2022-05-10---------
SET IDENTITY_INSERT [dbo].[AppModule] ON  
INSERT [dbo].[AppModule] ([AppModuleCode], [Name], [Arabic_Name],IsLicensed) VALUES (21, N'Send PaySlip', N' ارسال شيت المرتب',1)
SET IDENTITY_INSERT [dbo].[AppModule] OFF
GO
INSERT [dbo].[ConfigCategory] ([ConfigCategoryCode], [Name], [Arabic_Name]) VALUES (21, N'Send PaySlip', N' ارسال شيت المرتب')
GO
INSERT [dbo].[ConfigCategoryModule] ([ConfigCategoryCode], [AppModuleCode])
VALUES ( 21, 21)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'PaySlipMailHost', N'Host Name', N'اسم المضيف', N'smtp.sendgrid.net', 21, 2, 4, 1, NULL, NULL, NULL)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'PaySlipMailIsEnableSSL', N'Is enable SSL', N'تفعيل التشفير SSL', N'true', 21, 6, 1, 1, NULL, NULL, NULL)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'PaySlipMailPassword', N'Password', N'كلمة المرور', N'sst123456', 21, 4, 7, 1, NULL, NULL, NULL)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'PaySlipMailPort', N'Port No', N'رقم البوابة', N'587', 21, 5, 2, 1, NULL, NULL, NULL)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'PaySlipMailSenderName', N'Sender Name', N'اسم المرسل', N'SST', 21, 1, 4, 1, NULL, NULL, NULL)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'PaySlipMailUserName', N'User Name', N'اسم المستخدم', N'employees.sst@gmail.com', 21, 3, 4, 1, NULL, NULL, NULL)
GO
---------------------End 2022-05-10---------
