﻿----------------------------------------- AK 2024-11-05 --------------------
UPDATE ConfigParameter SET IsVisible=0 where ConfigKey in ('ACC_CustomersMainAccountsChartCode','ACC_VendorsMainAccountsChartCode')
GO
--------------------------------------- AK  2024-11-05 ------------------


 ----------------------------------------- M.Negm 2024-11-05 --------------------
 
  INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1115,N'Expenses Category',N' تصنيف المصروفات ',584,N'/GenerlLedger/ExpensesCategory',N'Index','fa fa-thumb-tack',N'get',9,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23139,N'  تصنيف المصروفات ',N'Expenses Category',1115,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23140,N'عرض   تصنيف المصروفات ',N'View Expenses Category',1115,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23141,N'إضافة   تصنيف المصروفات ',N'Add Expenses Category',1115,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23142,N'تعديل   تصنيف المصروفات ',N'Edit Expenses Category',1115,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23143,N'حذف   تصنيف المصروفات ',N'Delete Expenses Category',1115,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23144,N'حفظ   تصنيف المصروفات ',N'Save Expenses Category',1115,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2141,N'GenerlLedger',N'ExpensesCategory',N'Index',0,N'get',23139)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2142,N'GenerlLedger',N'ExpensesCategory',N'ExpensesCategory_Read',0,N'post',23140)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2143,N'GenerlLedger',N'ExpensesCategory',N'Save',1,N'get',23141)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2144,N'GenerlLedger',N'ExpensesCategory',N'Save',2,N'get',23142)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2145,N'GenerlLedger',N'ExpensesCategory',N'Delete',0,N'post',23143)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2146,N'GenerlLedger',N'ExpensesCategory',N'Save',0,N'post',23144)


INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1580,N'GenerlLedger', NULL,N'ExpensesCategory',N'GetExpensesCategorySearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1581,N'GenerlLedger', NULL,N'ExpensesCategory',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1582,N'GenerlLedger', NULL,N'ExpensesCategory',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1583,N'GenerlLedger', NULL,N'ExpensesCategory',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1584,N'GenerlLedger', NULL,N'ExpensesCategory',N'Get',N'Get')
Go


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1934,1580,23140, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1935,1581,23142, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1936,1582,23144, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1937,1583,23143, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1938,1584,23140, NULL)
Go
--------------------------------------- Negm  2024-11-05 ------------------
--------------------------------------- Hammad  2024-11-05 -------------
ALTER TABLE [SST.ERP_Client].dbo.ClientSecurityUser ADD
	DefaultBranchId int NULL
GO
--------------------------------------- End  2024-11-05 ----------------

--------------------------------------- Negm  2024-11-05 -------------

  INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1116,N'Expense',N'  المصروفات ',584,N'/GenerlLedger/Expense',N'Index','fa fa-thumb-tack',N'get',10,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23145,N' المصروفات ',N'Expenses ',1116,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23146,N'عرض  المصروفات ',N'View Expenses ',1116,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23147,N'إضافة  المصروفات ',N'Add Expenses ',1116,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23148,N'تعديل  المصروفات ',N'Edit Expenses ',1116,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23149,N'حذف  المصروفات ',N'Delete Expenses ',1116,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23150,N'حفظ  المصروفات ',N'Save Expenses ',1116,2)
Go



INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2147,N'GenerlLedger',N'Expense',N'Index',0,N'get',23145)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2148,N'GenerlLedger',N'Expense',N'Expense_Read',0,N'post',23146)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2149,N'GenerlLedger',N'Expense',N'Save',1,N'get',23147)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2150,N'GenerlLedger',N'Expense',N'Save',2,N'get',23148)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2151,N'GenerlLedger',N'Expense',N'Delete',0,N'post',23149)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2152,N'GenerlLedger',N'Expense',N'Save',0,N'post',23150)


INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1586,N'GenerlLedger', NULL,N'Expense',N'GetExpenseSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1587,N'GenerlLedger', NULL,N'Expense',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1588,N'GenerlLedger', NULL,N'Expense',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1589,N'GenerlLedger', NULL,N'Expense',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1590,N'GenerlLedger', NULL,N'Expense',N'Get',N'Get')
Go


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1940,1586,23146, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1941,1587,23148, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1942,1588,23147, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1943,1589,23149, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1944,1590,23146, NULL)
Go

--------------------------------------- End Negm  2024-11-05 ----------------
--------------------------------------- Hammad  2024-11-06 ----------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES (710, N'Branches Vacation Request Signature', N'اعتماد طلب اجازة الفروع  ', 503, N'/WorkFlow/ClientVacationsRequestSignature', N'Index', N'fa fa-thumb-tack', N'get', 9, 1, 1)
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15505, N'اعتماد طلب أجازات الفروع', N'Branches Vacation Request Signature', 710, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15506, N'عرض اعتماد طلب أجازات الفروع', N'View Branches Vacation Request Signature', 710, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15507, N'تعديل اعتماد طلب أجازات الفروع', N'Edit Branches Vacation Request Signature', 710, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15508, N'حفظ اعتماد طلب أجازات الفروع', N'Save Branches Vacation Request Signature', 710, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15509, N' حفظ متعدد  طلب أجازات الفروع', N'Save Multiple Branches Vacation Request Signature', 710, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15510, N' سجل طلبات  الاجازات للموظف', N'Vacations Request Employee History', 710, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15511, N'  ارجاع طلب أجازات الفروع  ', N' Inverse Branches Vacation Request Signature', 710, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15512, N'اختيار كل الطلبات', N'Choose All Requests', 710, 2)
GO

INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (710, 1)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2119, N'WorkFlow', N'ClientVacationsRequestSignature', N'Index', 0, N'get', 15505)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2120, N'WorkFlow', N'ClientVacationsRequestSignature', N'ClientVacationsRequest_Read', 0, N'post', 15506)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2121, N'WorkFlow', N'ClientVacationsRequestSignature', N'Save', 2, N'get', 15507)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2122, N'WorkFlow', N'ClientVacationsRequestSignature', N'Save', 0, N'post', 15508)
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (1591, NULL, NULL, N'ClientVacationsRequestSignature', N'GetSignatureById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (1592, NULL, NULL, N'ClientVacationsRequestSignature', N'GetCombinedVacationsRequestSignature', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (1593, NULL, NULL, N'ClientVacationsRequestSignature', N'GetRequestSignatureByClientUser', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (1594, NULL, NULL, N'ClientVacationsRequestSignature', N'GetRequestHistory', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (1595, NULL, NULL, N'ClientVacationsRequestSignature', N'SaveSignature', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1945, 1591, 15507, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1946, 1592, 15506, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1947, 1593, 15506, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1948, 1594, 15510, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1949, 1595, 15509, NULL)
GO

--------------------------------------- End  2024-11-06 ----------------