﻿--------------------------Hammad 2021-06-09-----------------------------

 INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'RecHireCandidateRequest', N'Add Hire Candidate Request', N'اضافة طلب لتعين المرشح', N'false', 4, 3, 1, 1, NULL, NULL, NULL)
 Go

 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (541, N'Consolidated Report', N'  تقارير مجمعة', 182, N'/ConsolidatedDashboard/ConsolidatedReport', N'Index', N'fa fa-thumb-tack', N'get', 6, 1, 1)
 Go
 INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES (541, 9)
 Go

 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11040, N'  تقارير مجمعة ', N'Consolidated Report', 541, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11041, N'عرض   تقارير مجمعة ', N'View Consolidated Report', 541, 2)
Go
 --------------------------End 2021-06-09-----------------------------
 --------------------------Ali 2021-06-13-----------------------------
 update [WF_RequestType]
set  [CategoryCode]=1,[RequestTypeGroupCode]=4
	 where  [RequestTypeId]=53
	 Go
	 update [SystemMenu]
set
 [Name]=N'Hire Candidates Request Signature', [Arabic_Name]=N'اعتماد  طلب تعيين المرشحين'
	 where  [SystemMenuCode]=540
	 Go

	 update [SecurityPrivilege] set  [DescriptionAR]=N'اعتماد طلب تعيين المرشحين' ,[DescriptionEN]=N'Hire Candidates Request Signature' where [ID]=15209
update [SecurityPrivilege] set  [DescriptionAR]=N'عرض اعتماد طلب تعيين المرشحين'   ,[DescriptionEN]=N'View Hire Candidates Request Signature' where [ID]=15210 
update [SecurityPrivilege] set  [DescriptionAR]=N'تعديل اعتماد طلب تعيين المرشحين' ,[DescriptionEN]=N'Edit Hire Candidates Request Signature' where [ID]=15211
update [SecurityPrivilege] set  [DescriptionAR]=N'حفظ اعتماد طلب تعيين المرشحين'   ,[DescriptionEN]=N'Save Hire Candidates Request Signature' where [ID]=15212
Go
 --------------------------End 2021-06-13-----------------------------

 --------------------------Hammad 2021-06-14--------------------------

  CREATE TABLE [dbo].[ConsolidatedReport](
	[ConsolidatedReportCode] [int] NOT NULL,
	[ReportName] [nvarchar](250) NOT NULL,
	[ReportNameAr] [nvarchar](250) NOT NULL,
	[Name] [nvarchar](250) NOT NULL,
	[Arabic_Name] [nvarchar](250) NOT NULL,
 CONSTRAINT [PK_ConsolidatedReport] PRIMARY KEY CLUSTERED 
(
	[ConsolidatedReportCode] 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].[ConsolidatedReport] ([ConsolidatedReportCode], [ReportName], [ReportNameAr], [Name], [Arabic_Name]) VALUES (1, N'023 E .trdx', N'023 A.trdx', N'Handicapped working in the facility', N'المعوقين العاملين بالمنشأة')
INSERT [dbo].[ConsolidatedReport] ([ConsolidatedReportCode], [ReportName], [ReportNameAr], [Name], [Arabic_Name]) VALUES (2, N'101 E .trdx', N'101 A.trdx', N'Retirement', N'الإحالة علي المعاش')
INSERT [dbo].[ConsolidatedReport] ([ConsolidatedReportCode], [ReportName], [ReportNameAr], [Name], [Arabic_Name]) VALUES (3, N'102 E .trdx', N'102 A.trdx', N'Resignations', N'الإستقالات')
INSERT [dbo].[ConsolidatedReport] ([ConsolidatedReportCode], [ReportName], [ReportNameAr], [Name], [Arabic_Name]) VALUES (4, N'103 E .trdx', N'103 A.trdx', N'New Hire', N'المعينين الجدد')
INSERT [dbo].[ConsolidatedReport] ([ConsolidatedReportCode], [ReportName], [ReportNameAr], [Name], [Arabic_Name]) VALUES (5, N'106 E .trdx', N'106 A.trdx', N'Basic Data - ( All Employees )', N'البيانات الأساسة - كل الموظفين')
INSERT [dbo].[ConsolidatedReport] ([ConsolidatedReportCode], [ReportName], [ReportNameAr], [Name], [Arabic_Name]) VALUES (6, N'110 E .trdx', N'110 A.trdx', N'Social Insurance', N'التأمينات الإجتماعية')
INSERT [dbo].[ConsolidatedReport] ([ConsolidatedReportCode], [ReportName], [ReportNameAr], [Name], [Arabic_Name]) VALUES (7, N'117 E.trdx', N'117 A.trdx', N'Name List', N'قائمة الأسماء')
INSERT [dbo].[ConsolidatedReport] ([ConsolidatedReportCode], [ReportName], [ReportNameAr], [Name], [Arabic_Name]) VALUES (8, N'119 E .trdx', N'119 A.trdx', N'Name List With Total Salary', N'قائمة بالأسماء والرواتب')
INSERT [dbo].[ConsolidatedReport] ([ConsolidatedReportCode], [ReportName], [ReportNameAr], [Name], [Arabic_Name]) VALUES (9, N'148 E.trdx', N'148 A.trdx', N'Expired Contract', N'انتهاء العقود')
INSERT [dbo].[ConsolidatedReport] ([ConsolidatedReportCode], [ReportName], [ReportNameAr], [Name], [Arabic_Name]) VALUES (10, N'150 E .trdx', N'150 A.trdx', N'Military Certificates Expired', N'الشهادات العسكرية منتهية الصلاحية')
GO
 --------------------------End 2021-06-14--------------------------
 --------------------------Ali 2021-06-15--------------------------

 ALTER TABLE EmployeOrientation
ALTER COLUMN ClosedDate datetime NULL;
Go
 --------------------------End 2021-06-15--------------------------
 --------------------------Ali 2021-06-16--------------------------

ALTER TABLE dbo.Orientations ADD
	DisplayOrientationFromDate datetime NULL,
	DisplayOrientationToDate datetime NULL
GO
 --------------------------End 2021-06-16--------------------------
