﻿---------------------AK 2021-12-12--------
SET IDENTITY_INSERT [dbo].[AppModule] ON  
INSERT [dbo].[AppModule] ([AppModuleCode], [Name], [Arabic_Name], [IsLicensed], [LicenseNumber]) VALUES (17, N'Purchases', N'المشتريات', 1, NULL)
SET IDENTITY_INSERT [dbo].[AppModule] OFF
Go
---------------------End 2021-12-12--------


---------------------AK 2021-12-13--------
INSERT [dbo].[ConfigCategory] ([ConfigCategoryCode], [Name], [Arabic_Name]) VALUES (17, N'Purchases', N'المشتريات')
Go
 
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES (N'PurIsPurchasesOrderNeedApprove', N'Is purchases order Need Approve?', N'هل أمر الشراء يحتاج لموافقة؟', N'false', 17, 1, 1, 1, NULL, NULL, NULL)
GO

INSERT [dbo].[ConfigCategoryModule] ([ConfigCategoryCode], [AppModuleCode])
VALUES ( 17, 17)
Go
---------------------End 2021-12-13--------

---------------------Ali 2021-12-14--------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(575,N'Purchases',N'المشتريات',Null,N'Null',N'Null','fa fa-thumb-tack',N'get',Null,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(575,17)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])VALUES(22006,N'المشتريات',N'Purchases',575,1)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(576,N'Purchase quotation',N'عرض الاسعار',575,N'/Inventory/PurchaseQuotation',N'Index','fa fa-thumb-tack',N'Get',1,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(576,17)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22000,N'عرض الاسعار',N'Purchase Quotation',576,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22001,N'عرض عرض الاسعار',N'View Purchase Quotation',576,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22002,N'إضافة عرض الاسعار',N'Add Purchase Quotation',576,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22003,N'تعديل عرض الاسعار',N'Edit Purchase Quotation',576,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22004,N'حذف عرض الاسعار',N'Delete Purchase Quotation',576,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22005,N'حفظ عرض الاسعار',N'Save Purchase Quotation',576,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (921, N'Inventory', N'PurchaseQuotation', N'Index', 0, N'get', 22000)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (922, N'Inventory', N'PurchaseQuotation', N'PurchaseQuotation_Read', 0, N'post', 22001)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (923, N'Inventory', N'PurchaseQuotation', N'Save', 1, N'get', 22002)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (924, N'Inventory', N'PurchaseQuotation', N'Save', 2, N'get', 22003)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (925, N'Inventory', N'PurchaseQuotation', N'Delete', 0, N'post', 22004)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (926, N'Inventory', N'PurchaseQuotation', N'Save', 0, N'post', 22005)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(577,N'Purchase Order',N'اوامر الشراء',575,N'/Inventory/PurchaseOrder',N'Index','fa fa-thumb-tack',N'get',2,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(577,17)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22008,N'اوامر الشراء',N'Purchase Order',577,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22009,N'عرض اوامر الشراء',N'View Purchase Order',577,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22010,N'إضافة اوامر الشراء',N'Add Purchase Order',577,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22011,N'تعديل اوامر الشراء',N'Edit Purchase Order',577,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22012,N'حذف اوامر الشراء',N'Delete Purchase Order',577,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22013,N'حفظ اوامر الشراء',N'Save Purchase Order',577,2)

Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(927,N'Inventory',N'PurchaseOrder',N'Index',0,N'get',22008)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(928,N'Inventory',N'PurchaseOrder',N'PurchaseOrder_Read',0,N'post',22009)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(929,N'Inventory',N'PurchaseOrder',N'Save',1,N'get',22010)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(930,N'Inventory',N'PurchaseOrder',N'Save',2,N'get',22011)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(931,N'Inventory',N'PurchaseOrder',N'Delete',0,N'post',22012)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(932,N'Inventory',N'PurchaseOrder',N'Save',0,N'post',22013)
 
Go

---------------------End 2021-12-14--------
