

------------------------------- A.Khaled 2020-10-26 -------------------------- 
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (385, N'Save Budget Item', N'حفظ عنصر موازنة', 203, N'/Budget/BudgetItem', N'Save', N'fa fa-thumb-tack', N'get', 1, 0, 0)
------------------------------- End 2020-10-26 --------------------------
------------------------------- Hammad 2020-10-27 --------------------------

ALTER TABLE dbo.WF_StoreTransactionRequests ADD
	FromStoreCode int NULL
GO

ALTER TABLE dbo.WF_StoreTransactionRequestsDetails ADD
	QuantitySupplied float(53) NULL
GO


SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (156, N'Store Request Sending', N'ارسال طلب مخزن	', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (157, N'Store Request Accept', N'الموافقة على طلب مخزن', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (158, N'Store Request Refuse', N'رفض طلب مخزن', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (159, N'Store Request Cancellation', N'الغاء طلب مخزن', 0, 1)
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF

SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (156, N'Store Request Sending', N'إرسال طلب مخزن', 156, N'طلب مخزن', N'<p>نرجو الموافقة على طلب مخزن</p>', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (157, N'Store Request Accept', N'الموافقة على طلب مخزن', 157, N'اعتماد طلب مخزن', N'<p>تمت الموافقة</p>', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (158, N'Store Request Refuse', N'رفض طلب مخزن', 158, N'رفض طلب مخزن', N'تم رفض الطلب', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (159, N'Store Request Cancellation', N'إلغاء طلب مخزن', 159, N'إلغاء طلب مخزن', N'<p>تم إلغاء طلب مخزن</p>', 1, NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (381, N'Store Request', N'طلب مخزن', 29, N'/WorkFlow/StoreRequest', N'Index', N'fa fa-thumb-tack', N'get', 39, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (382, N'Store Request Signature', N'اعتماد طلب مخزن ', 108, N'/WorkFlow/StoreRequestSignature', N'Index', N'fa fa-thumb-tack', N'get', 42, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (383, N'Save Store Request Signature', N'حفظ اعتماد طلب مخزن  ', 108, N'/WorkFlow/StoreRequestSignature', N'StoreTransaction', N'fa fa-thumb-tack', N'get', 43, 0, 0)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (384, N'Receive Store Transaction', N'إستلام الحركة المخزنية', 29, N'/WorkFlow/StoreRequest', N'ReceiveStoreTransaction', N'fa fa-thumb-tack', N'get', 40, 0, 0)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3546, N'طلب مخزن', N'Store Request', 381, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3547, N'عرض طلب مخزن', N'View Store Request', 381, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3548, N'إضافة طلب مخزن', N' Add Store Request', 381, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3549, N'تعديل طلب مخزن ', N'Edit Store Request', 381, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3550, N'حذف طلب مخزن', N'Delete Store Request', 381, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3551, N'حفظ طلب مخزن', N'Save Store Request', 381, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3552, N'إلغاء طلب  مخزن', N'Cancel Store Request', 381, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3553, N'اعتماد طلب مخزن', N'Store Request Signature', 382, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3554, N'عرض اعتماد طلب مخزن', N'View Store Request Signature', 382, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3555, N'تعديل اعتماد طلب مخزن', N'Edit Store Request Signature', 382, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3556, N'حفظ اعتماد طلب مخزن', N'Save Store Request Signature', 382, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3557, N'حفظ متعدد طلب مخزن', N'Save Multiple Store Request Signature', 382, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3558, N'ارجاع طلب  مخزن', N'Inverse Store Request', 382, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3559, N'اختيار كل الطلبات', N'Choose All Requests', 382, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3560, N'تحويل الطلب الى حركة مخزنية', N'Convert Request To Stores Transactions', 382, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3561, N'إمكانية زيادة الكمية المطلوبة', N'Can Increas Request Quantity ', 382, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3562, N'إمكانية تقليل الكمية المطلوبة', N'Can Reduce Request Quantity ', 382, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3563, N'إستلام الحركات المخزنية   ', N'Receive Store Transaction', 381, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3564, N'إغلاق طلب المخزن     ', N'Close Store Request', 381, 2)
Go

INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (381, 1)
INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (382, 1)
Go


INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode]) VALUES (22, N'Store Keeper', N'أمين مخزن', 1, 0)
Go

INSERT [dbo].[WF_RequestType] ([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed]) VALUES (28, N'طلب مخزن', N'Store Request', 0, N'sayedmustafa84@yahoo.com', N'sayedmustafa84@yahoo.com', N'1', N'smtp.sendgrid.net', 587, N'SST', NULL, NULL, 1)
Go
------------------------------- End 2020-10-27 --------------------------
------------------------------- Ali 2020-10-28 --------------------------

INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (62, N'Contract End', N'نهاية العقد', N'BalanceCalcPeriod')
------------------------------- End 2020-10-28 --------------------------