﻿
--------------------------------------- M.NEGM  2024-11-12 ----------------
DELETE FROM  [dbo].[ConfigParameter]  WHERE [ConfigKey]='WorkByMultiCurrencies'
GO
--------------------------------------- End  2024-11-12 ----------------
--------------------------------------- Hammad  2024-11-13 -------------
SET IDENTITY_INSERT [dbo].[SecurityGroup] ON 
GO
INSERT [dbo].[SecurityGroup] ([SecurityGroupCode], [Name], [Arabic_Name], [IsEditable], [IsDefault], [PasswordPolicyCode]) 
VALUES (100, N'General Users', N'المستخدم العام ', 1, 0, NULL)
GO
SET IDENTITY_INSERT [dbo].[SecurityGroup] OFF
GO

Insert into  SecurityGroupDetail
select 100,ID as PrivilegeID,GETDATE(),1 from SecurityPrivilege
where  SystemMenuCode in ( select SystemMenuCode from SystemMenuModule where AppModuleCode=1)
Go
--------------------------------------- End  2024-11-13 -------------
----------------------------------------- AK 2024-11-13 --------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (1119, N'General Ledger', N'الحسابات العامة', 7, '', '', '', '', 6, 0, 1)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (23151, N'تغيير سعر الصرف', N'Change exchange rate', 1119, 2)
GO
SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (66678, 1119, 18)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO
--------------------------------------- AK  2024-11-13 ------------------