﻿-------------------------------Hammad 2022-03-08------
ALTER TABLE dbo.WF_TrackMaxDays ADD
	CreatedBy int NULL,
	CreationDate datetime NULL,
	ModifiedBy int NULL,
	ModificationDate datetime NULL
GO


update [dbo].[SystemMenu] set Arabic_Name=N'المسارات الإضافية' where SystemMenuCode=589

GO
-------------------------------End 2022-03-08------

-------------------------------Mostafa 2022-03-09------
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


-------------------------------End 2022-03-09------

-------------------------------Ali 2022-03-10---


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
-------------------------------End 2022-03-10---
-------------------------------Hammad 2022-03-10---


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

-------------------------------Mostafa  2022-03-13---
GO
CREATE TABLE [dbo].[ExchangeRate](
	[ExchangeRateId] [int] IDENTITY(1,1) NOT NULL,
	[CurrencyCode] [tinyint] NOT NULL,
	[Rate] [float] NOT NULL,
	[RateDate] [datetime] NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
 CONSTRAINT [PK_ExchangeRate] PRIMARY KEY CLUSTERED 
(
	[ExchangeRateId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ExchangeRate]  WITH CHECK ADD  CONSTRAINT [FK_ExchangeRate_Currencies] FOREIGN KEY([CurrencyCode])
REFERENCES [dbo].[Currencies] ([CurrencyCode])
GO
ALTER TABLE [dbo].[ExchangeRate] CHECK CONSTRAINT [FK_ExchangeRate_Currencies]
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)

-------------------------------End 2022-03-13---
-------------------------------Hammad 2022-03-13---
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
-------------------------------End 2022-03-13---
-------------------------------Ali 2022-03-13---

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
-------------------------------End 2022-03-13---
-------------------------------Ali 2022-03-14---
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
-------------------------------End 2022-03-14---
-------------------------------Hammad 2022-03-14---
ALTER TABLE dbo.NotificationTemplateType ADD
	HaveUserAccount bit NOT NULL CONSTRAINT DF_NotificationTemplateType_HaveUserAccount DEFAULT ((1))
GO
ALTER TABLE dbo.NotificationTemplateType SET (LOCK_ESCALATION = TABLE)
GO
-------------------------------End 2022-03-14---