--------------------------Hammad 2020-12-30--------------------------


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (301, N'Inventory', N'Stocktaking', N'Index', 0, N'get', 14195)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (302, N'Inventory', N'Stocktaking', N'Stocktaking_Read', 0, N'post', 14196)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (303, N'Inventory', N'Stocktaking', N'Save', 1, N'get', 14197)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (304, N'Inventory', N'Stocktaking', N'Delete', 0, N'post', 14198)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (305, N'Inventory', N'Stocktaking', N'Save', 0, N'post', 14199)
Go
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (408, N'Stocktaking', N'جرد المخزون', 357, N'/Inventory/Stocktaking', N'Save', N'fa fa-thumb-tack', N'get', 6, 0, 1)
Go

------------------------------End 2020-12-30-------------------------
---------------------------Sayed Mustafa 2021-01-02-----------------------------
  update [SystemMenu] set [Name]='Vacant Jobs' where [SystemMenuCode]=59
  go
  update [SecurityPrivilege] set [DescriptionEN]='Vacant Jobs' where ID=5041
  update [SecurityPrivilege] set [DescriptionEN]='View Vacant Jobs' where ID=5042
  update [SecurityPrivilege] set [DescriptionEN]='Add Vacant Jobs' where ID=5043
  update [SecurityPrivilege] set [DescriptionEN]='Edit Vacant Jobs' where ID=5044
  update [SecurityPrivilege] set [DescriptionEN]='Delete Vacant Jobs' where ID=5045
  update [SecurityPrivilege] set [DescriptionEN]='Save Vacant Jobs' where ID=5046
  GO
   update [SystemMenu] set [Name]='Evaluation Stage' where [SystemMenuCode]=68
  go

  update [SecurityPrivilege] set [DescriptionEN]='Save Evaluation Stage' where ID=5056
  GO
   update [SystemMenu] set [Name]='Employee Evaluation Stage' where [SystemMenuCode]=192
  go

  update [SecurityPrivilege] set [DescriptionEN]='Employee Evaluation Stage' where ID=10037
  update [SecurityPrivilege] set [DescriptionEN]='View Employee Evaluation Stage' where ID=10038
  update [SecurityPrivilege] set [DescriptionEN]='Save Employee Evaluation Stage' where ID=10039
  update [SecurityPrivilege] set [DescriptionEN]='Calculate Employee Evaluation Stage' where ID=10040
  Go
    update [SystemMenu] set [Name]='Employee Evaluation Stage' where [SystemMenuCode]=225
  go

  update [SecurityPrivilege] set [DescriptionEN]='Employee Evaluation Stage' where ID=10042
  update [SecurityPrivilege] set [DescriptionEN]='View Employee Evaluation Stage' where ID=10043
  GO

  ----------------------------End 2021-01-02-----------------------------------  
  ----------------------------Hammad 2021-01-02-----------------------------------  
  SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (174, N'Accepted in Evaluation Status ', N'مقبول في تقييم ', 0, 4)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (175, N'Rejected in Evaluation Status', N'مرفوض في تقييم ', 0, 4)
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 (174, N'Success in  evaluation Status', N'النجاح في مرحلة تقييم', 174, N'النجاح في مرحلة تقييم', N'<p>Test</p><p>you are success in this stage</p>', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (175, N'Failed in evaluation Status ', N'فشل في مرحلة تقييم', 175, N'فشل في مرحلة تقييم', N'<p>you are Failed&nbsp;in this stage</p><p>&nbsp;</p><p>&nbsp;</p>', 1, NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF



CREATE TABLE [dbo].[AC_TransactionCategory](
	[TransactionCategoryCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
 CONSTRAINT [PK_AC_TransactionCategory] PRIMARY KEY CLUSTERED 
(
	[TransactionCategoryCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE dbo.AC_Transaction ADD
	TransactionCategoryCode int NULL
GO



ALTER TABLE [dbo].[AC_Transaction]  WITH CHECK ADD  CONSTRAINT [FK_AC_Transaction_AC_TransactionCategory] FOREIGN KEY([TransactionCategoryCode])
REFERENCES [dbo].[AC_TransactionCategory] ([TransactionCategoryCode])
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'ACTransactionCategory', N'work By Transaction Category', N'العمل بفئات المعاملة', N'false', 6, 15, 1, 1, NULL, NULL, NULL)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(409,N'Transaction Category',N'فئة المعاملة',10,N'/AdminComm/TransactionCategory',N'Index','fa fa-thumb-tack',N'get',14,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(409,2)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(2220,N'فئة المعاملة',N'Transaction Category',409,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(2221,N'عرض فئة المعاملة',N'View Transaction Category',409,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(2222,N'إضافة فئة المعاملة',N'Add Transaction Category',409,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(2223,N'تعديل فئة المعاملة',N'Edit Transaction Category',409,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(2224,N'حذف فئة المعاملة',N'Delete Transaction Category',409,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(2225,N'حفظ فئة المعاملة',N'Save Transaction Category',409,2)

Go

  ----------------------------End 2021-01-02-----------------------------------


   ----------------------------Ali 2021-01-03-----------------------------------

  INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'DisplayUserAuthorityAfterAddAuthority', N'Display Add User Authority After Add Authority', N'اظهار  اضافة جهات المستحدم بعد اضافة الجهات', N'false', 6, 16, 1, 1, NULL, NULL, NULL)
    Go
  INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'DisplayAuthorityUsers', N'Display Authority Users', N'اظهار مستخدمين الجهة', N'false', 6, 17, 1, 1, NULL, NULL, NULL)
  Go
  ----------------------------End 2021-01-03-----------------------------------


