﻿---------------------Hammad 2021-11-01---------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'APPEvaluationElementWeightDependOn', N'Evaluation Element Weight Depend On', N'الوزن النسبى للعناصر معتمد على   ', N'85', 10, 16, 6, 1, NULL, NULL, NULL)
GO
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (85, N'Position ', N' الوظيفة', N'APPEvaluationElementWeightDependOn')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (86, N'Employee ', N' الموظف', N'APPEvaluationElementWeightDependOn')
GO
---------------------End 2021-11-01---------
---------------------Ali 2021-11-02---------

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WF_NewHireRequestFiles](
	[NewHireRequestFileCode] [int] IDENTITY(1,1) NOT NULL,
	[NewHireRequestCode] [int] NOT NULL,
	[FileName] [nvarchar](500) NOT NULL,
 CONSTRAINT [PK_WF_NewHireRequestFile] PRIMARY KEY CLUSTERED 
(
	[NewHireRequestFileCode] 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].[WF_NewHireRequestFiles]  WITH CHECK ADD  CONSTRAINT [FK_WF_NewHireRequestFile_WF_NewHireRequest] FOREIGN KEY([NewHireRequestCode])
REFERENCES [dbo].[WF_NewHireRequest] ([NewHireRequestCode])
GO

ALTER TABLE [dbo].[WF_NewHireRequestFiles] CHECK CONSTRAINT [FK_WF_NewHireRequestFile_WF_NewHireRequest]
GO

---------------------End 2021-11-02---------
---------------------Mostafa 2021-11-02---------
	ALTER TABLE VacationType ADD
	MandatoryComment bit  NULL DEFAULT ((0))
	GO
---------------------End 2021-11-02---------
-------------------Sayed 2021-11-03-----------
alter table WF_BackToWorkRequest 
add IsSynced bit Not Null default(0)
GO
alter table WF_VacationRequest
add IsSynced bit Not Null default(0)
GO
-------------End 2021-11-03-------------------
-------------Ali 2021-11-03-------------------

INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFNewHireDisplayWorkHeelInfoTab',N'Display Work Heel Info',N'عرض معلومات كعب العمل',N'true',2,20,1,1,Null,Null,5)
Go


 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFNewHireDisplayMilitaryInfoTab',N'Display Military Info',N'عرض بيانات التجنيد',N'true',2,21,1,1,Null,Null,5)
Go


 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFNewHireDisplayPersonalItemsTab',N'Display Personal Items',N'عرض المتعلقات الشخصية',N'true',2,22,1,1,Null,Null,5)
Go


 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFNewHireDisplayReferenceCheckTab',N'Display Reference Check',N'عرض مرجع المرجعية',N'true',2,23,1,1,Null,Null,5)
Go


 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFNewHireDisplayIDDetailsTab',N'Display ID Details',N'عرض تفاصيل البطاقة',N'true',2,24,1,1,Null,Null,5)
Go


 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFNewHireDisplayPassportDetailsTab',N'Display Passport Details',N'عرض تفاصيل جواز السفر',N'true',2,25,1,1,Null,Null,5)
Go


 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFNewHireDisplayResidenceInfoTab',N'Display Residence Info',N'عرض بيانات الاقامة',N'true',2,26,1,1,Null,Null,5)
Go


 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFNewHireDisplayHealthInsuranceTab',N'Display Health Insurance',N'عرض التامين الطبى',N'true',2,27,1,1,Null,Null,5)
Go


 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFNewHireDisplayPreviousExperienceTab',N'Display Previous Experience',N'عرض الخبرات السابقة',N'true',2,28,1,1,Null,Null,5)
Go
-------------End 2021-11-03-------------------
--------------------------Mostafa 2021-11-04-----------------------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(568,N'Letter Authority',N'نوع جهة الخطاب',28,N'/WorkFlow/LetterAuthority',N'Index','fa fa-thumb-tack',N'get',29,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15255,N'نوع جهة الخطاب',N'Letter Authority',568,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15256,N'عرض نوع جهة الخطاب',N'View Letter Authority',568,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15257,N'إضافة نوع جهة الخطاب',N'Add Letter Authority',568,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15258,N'تعديل نوع جهة الخطاب',N'Edit Letter Authority',568,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15259,N'حذف نوع جهة الخطاب',N'Delete Letter Authority',568,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15260,N'حفظ نوع جهة الخطاب',N'Save Letter Authority',568,2)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(569,N'letter Types',N'نو ع الخطاب',28,N'/WorkFlow/letterTypes',N'Index','fa fa-thumb-tack',N'get',30,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15261,N'نو ع الخطاب',N'letter Types',569,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15262,N'عرض نو ع الخطاب',N'View letter Types',569,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15263,N'إضافة نو ع الخطاب',N'Add letter Types',569,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15264,N'تعديل نو ع الخطاب',N'Edit letter Types',569,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15265,N'حذف نو ع الخطاب',N'Delete letter Types',569,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15266,N'حفظ نو ع الخطاب',N'Save letter Types',569,2)
Go

--------------------------End 2021-11-04-----------------------------
--------------------------Ali 2021-11-04-----------------------------

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ResidenceTypes](
	[ResidenceCode] [int] NOT NULL,
	[Name] [nvarchar](255) NULL,
	[Arabic_Name] [nvarchar](255) NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_ResidenceTypes] PRIMARY KEY CLUSTERED 
(
	[ResidenceCode] 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].[WF_NewHireRequest] add

	[CardNumber] [nvarchar](20) NULL,
	[IssuePlace] [nvarchar](30) NULL,
	[IssueDate] [datetime] NULL,
	[IssueDateHijri] [nvarchar](10) NULL,
	[ExpireDate] [datetime] NULL,
	[ExpireDateHijri] [nvarchar](10) NULL,
	[HealthInsuranceTypeCode] [nvarchar](3) NULL,
	[ResidenceCode] [int] NULL,
	[ResidenceNumber] [nvarchar](20) NULL,
	[ResidenceJob] [nvarchar](50) NULL,
	[ResidenceSource] [nvarchar](50) NULL,
	[ResidenceIssueDate] [datetime] NULL,
	[ResidenceIssueDateHijri] [nchar](10) NULL,
	[ResidenceExpireDate] [datetime] NULL,
	[ResidenceExpireDateHijri] [nchar](10) NULL,
	[EntryNumber] [nvarchar](20) NULL,
	[EntryPort] [nvarchar](50) NULL,
	[EntryDate] [datetime] NULL,
	[EntryDateHijri] [nchar](10) NULL
	Go
--------------------------End 2021-11-04-----------------------------
