﻿---------------------Hammad 2021-07-13------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'ApprEvaluationCurveStartWith', N'Evaluation Curve Start With   ', N'منحنى التقيم يبدأ ب', N'79', 10, 15, 6, 1, NULL, NULL, NULL)
 GO

INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (79, N'Section', N'القسم', N'ApprEvaluationCurveStartWith')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (80, N'Department', N'الإدارة', N'ApprEvaluationCurveStartWith')
GO
---------------------End 2021-07-13------------

---------------------Mostafa 2021-07-14------------
INSERT INTO SecurityPrivilege (ID, DescriptionAR, DescriptionEN, SystemMenuCode,PrivilegeType)
VALUES (2232,N'إضافة موظفين للمجموعة',N'Add employees to the group', 548,2);
GO
CREATE TABLE [dbo].[Employee_EmployeeGroup](
	[Employee_EmployeeGroupCode] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeGroupCode] [int] NULL,
	[EmployeeCode] [int] NULL,
 CONSTRAINT [PK_Employee_EmployeeGroup] PRIMARY KEY CLUSTERED 
(
	[Employee_EmployeeGroupCode] 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
 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'IsAddEmployeeToMoreThanOneGroup',N'Is it possible to add an employee in more than one group?',N'هل يمكن اضافة موظف في اكثر من مجموعة؟',N'0',15,1,1,1,Null,Null,Null)
Go

INSERT INTO ConfigCategory (ConfigCategoryCode,Name,Arabic_Name)
VALUES (15,N'Employees',N'الموظفين')
GO
INSERT INTO SecurityPrivilege (ID, DescriptionAR, DescriptionEN, SystemMenuCode,PrivilegeType)
VALUES (1294,N'إعدادات العمل',N'Work settings Config', 549,1);
Go 
INSERT INTO SecurityPrivilege (ID, DescriptionAR, DescriptionEN, SystemMenuCode,PrivilegeType)
VALUES (1295,N'عرض إعدادات العمل',N'View Work settings Config', 549,2);
Go 
INSERT INTO SecurityPrivilege (ID, DescriptionAR, DescriptionEN, SystemMenuCode,PrivilegeType)
VALUES (1296,N'حفظ إعدادات العمل',N'Save Work settings Config', 549,2);
Go
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (549, N'Work Settings', N'إعدادات العمل', 27, N'/Personal/SystemSecurityConfig', N'Index', N'fa fa-thumb-tack', N'get', 4, 1, 1)
GO
---------------------end 2021-07-14------------
---------------------Ali 2021-07-14------------
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'NewLocation', N'New Location Name #', N'اسم الموقع الجديد #')
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'NewSection', N'New Section Name #', N'اسم القسم الجديد #')
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'OldLocation', N'Old Location Name #', N'اسم الموقع  القديم #')
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'OldSection', N'Old Section Name #', N'اسم القسم القديم #')
Go
---------------------end 2021-07-14------------
---------------------Ali 2021-07-15------------

INSERT [dbo].[Reports] ([ReportCode], [Name], [Arabic_Name], [ReportName], [AppModuleCode]) VALUES (13, N'Supplier Transaction', N'  حركات الموردين', N'SupplierTransactionReport.trdx', 12)
INSERT [dbo].[Reports] ([ReportCode], [Name], [Arabic_Name], [ReportName], [AppModuleCode]) VALUES (14, N'Item Balance', N'كارت الصنف', N'ItemBalance.trdx', 12)
SET IDENTITY_INSERT [dbo].[Reports] OFF
Go

 update [SystemMenu] set  [Name]=N'StorsReports',[Arabic_Name]=N'تقارير المخازن',ParentID=528,Sequence=2
  where [SystemMenuCode] =530
  Go
  delete  from SystemMenuModule where SystemMenuCode=529
  delete from SystemMenu where SystemMenuCode=529
  Go
    delete from [Reports] where  ReportCode=12
	Go
---------------------end 2021-07-15------------
---------------------Ali 2021-07-25------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (550, N'Calculate Employees Overtime', N'احتساب الاضافى للموظفين', 501, N'  /WorkFlow/OverTimeRequestFinalSignature', N'CalculateEmployeesOvertime', N'fa fa-thumb-tack', N'get', 23, 0, 0)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3987, N'إحتساب  الإضافي  النهائى للموظفين', N'Calculate Final Employees  Overtime', 222, 2)
Go
---------------------end 2021-07-25------------