
------------------------------- Ali 2020-09-16 --------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(374,N'Stores Transactions',N'حركات المخازن',357,N'/Inventory/StoreTransaction',N'Index','fa fa-thumb-tack',N'get',1,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(374,12)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14180,N'حركات المخازن',N'Stores Transactions',374,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14181,N'عرض حركات المخازن',N'View Stores Transactions',374,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14182,N'إضافة حركات المخازن',N'Add Stores Transactions',374,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14183,N'تعديل حركات المخازن',N'Edit Stores Transactions',374,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14184,N'حذف حركات المخازن',N'Delete Stores Transactions',374,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14185,N'حفظ حركات المخازن',N'Save Stores Transactions',374,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (281, N'Inventory', N'StoreTransaction', N'Index', 0, N'get', 14180)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (282, N'Inventory', N'StoreTransaction', N'StoreTransaction_Read', 0, N'post', 14181)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (283, N'Inventory', N'StoreTransaction', N'Save', 1, N'get', 14182)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (284, N'Inventory', N'StoreTransaction', N'Save', 2, N'get', 14183)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (285, N'Inventory', N'StoreTransaction', N'Delete', 0, N'post', 14184)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (286, N'Inventory', N'StoreTransaction', N'Save', 0, N'post', 14185)
Go
------------------------------- End 2020-09-16 --------------------------
------------------------------- Ali 2020-09-22 --------------------------
  update [SecurityPrivilegeActions] 
  set  [ActionName]=N'SaveEvaluationStatus'
  where ID=89;
  Go

 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(374,N'Save Store Transaction',N'حفظ حركات المخازن',357,N'/Inventory/StoreTransaction',N'Save','fa fa-thumb-tack',N'get',2,0,0)
Go

  update [SystemMenu] 
  set [IsVisible]=0
  where SystemMenuCode=60
  Go

------------------------------- End 2020-09-22 --------------------------
------------------------------- Ali 2020-09-23 --------------------------
  update [Inv].[TransactionType]
  set [ShownPrice]=3
  where [IndicatorType] =1 
  Go
  update [Inv].[TransactionType]
  set ShownPrice = 2
  where [IndicatorType] in(2,3,4) 
  Go
  
SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (113, N'Receive a job application', N'إستلام طلب تقديمة للوظيفة', 113, N'تم إستلام طلب تقديمة للوظيفة', N'A job application has been received', 1, NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF
Go
------------------------------- End 2020-09-23 --------------------------
-------------------------------Sayed 2020-09-27------------------------
INSERT [dbo].[WF_FactorType] ([FactorTypeCode], [Name], [Arabic_Name]) VALUES (10, N'Mony', N'مبلغ')
GO
INSERT [dbo].[WF_FactorType] ([FactorTypeCode], [Name], [Arabic_Name]) VALUES (11, N'Days', N'أيام')
GO
INSERT [dbo].[WF_FactorType] ([FactorTypeCode], [Name], [Arabic_Name]) VALUES (12, N'Hours', N'ساعات')
GO
INSERT [dbo].[WF_FactorType] ([FactorTypeCode], [Name], [Arabic_Name]) VALUES (13, N'Minutes', N'دقائق')
Go
-------------------------------End 2020-09-27------------------------

-------------------------------Ali 2020-09-27------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (376, N'Question Answer', N'إجابات الأسئلة', 47, N'/Recruitment/CandidatesStatus', N'QuestionAnswer', N'fa fa-thumb-tack', N'get', 9, 0, 0)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (377, N'Save Evaluation Type', N'حفظ انواع التقييم', 161, N'/Appraisal/EvaluationType', N'Save', N'fa fa-thumb-tack', N'get', 19, 0, 0)
Go

update  [dbo].[SystemMenu] 
set ActionName= N'Index' 
where  SystemMenuCode=215
Go
-------------------------------End 2020-09-27------------------------
