
------------------------------- Hammad 2020-04-14 -----------------------
ALTER TABLE dbo.WF_NewHireRequest ADD
	CurrentAddressAr nvarchar(250) NULL,
	CityCode int NULL,
	CubeCardNo nvarchar(50) NULL
GO
------------------------------- End 2020-04-14 -----------------------

  ------------------------------- Ali 2020-04-16 -----------------------
  ALTER TABLE dbo.WF_NewHireRequest ADD
	IdNumber nvarchar(20) NULL,
	IdIssueFrom nvarchar(30) NULL,
	IdIssueFromArabic nvarchar(30) NULL,
	IdIssueDate datetime NULL,
	IdExpireDate datetime NULL,
	BirthCityCode int NULL,
	BirthDestination nvarchar(30) NULL,
	BirthDestinationArabic nvarchar(30) NULL,
	IdIssueDateHijri nvarchar(10) NULL,
	IdExpireDateHijri nvarchar(10) NULL
GO

update [ConfigParameter] set 
  [Arabic_Name]= N'بيانات البطاقة'
  where ConfigKey= 'WFNewHireIDDataRequired'
  GO

  INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'WFNewHirePassportDataRequired', N'Passport Data Required', N'بيانات جواز السفر', N'false', 2, 8, 1, 1, NULL, NULL, 5)
  GO
  ------------------------------- End 2020-04-16 -----------------------
  ------------------------------- Ali 2020-04-19 -----------------------

  INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'WFCannotRepeatedEmpCode', N'Can''t Repeated Employee Code in request', N'عدم تكرار كود الموظف فى الطلب', N'false', 2, 9, 1, 1, NULL, NULL, 5)
  ------------------------------- End 2020-04-19 -----------------------

    ------------------------------- Hammad 2020-04-21 -----------------------
  ALTER TABLE dbo.AppModule DROP COLUMN LicenseNumber;
  Go
    ------------------------------- End 2020-04-21 -----------------------

    ------------------------------- Ali 2020-04-22 -----------------------
	
ALTER TABLE dbo.WF_PenaltyRequestSignature ADD
	SignatureCommentInverse nvarchar(255) NULL
GO

ALTER TABLE dbo.WF_PermissionRequestSignature ADD
	SignatureCommentInverse nvarchar(255) NULL
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3516, N'إرجاع طلب الجزاء', N'Inverse Penalty Request Signature', 126, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3517, N'إرجاع طلب الإذن', N'Inverse Permission Request Signature', 37, 2)
Go
 ------------------------------- End 2020-04-22 -----------------------
   ------------------------------- Ali 2020-04-23 -----------------------

 ALTER TABLE dbo.WF_OverTimeRequestSignature ADD
	SignatureCommentInverse nvarchar(255) NULL
GO
ALTER TABLE dbo.WF_PromotionRequestSignature ADD
	SignatureCommentInverse nvarchar(255) NULL
GO
ALTER TABLE dbo.WF_AirTicketRequestSignature ADD
	SignatureCommentInverse nvarchar(255) NULL
GO

ALTER TABLE dbo.WF_CasualRequestSignature ADD
	SignatureCommentInverse nvarchar(255) NULL
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3518, N'إرجاع طلب الوقت الاضافى', N'Inverse OverTime Request Signature', 65, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3519, N'إرجاع طلب الترقية', N'Inverse PromotionRequest Signature', 90, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3520, N'إرجاع طلب تذكرة طيران', N'Inverse AirTicket Request Signature', 67, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3521, N'إرجاع طلب العلاوه', N'Inverse Bonus Request Signature', 145, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3522, N'إرجاع طلب العمالة المؤقتة', N'Inverse Casual Request Signature', 83, 2)
Go

ALTER TABLE dbo.WF_ChangeDayoffRequestSignature ADD
	SignatureCommentInverse nvarchar(255) NULL
GO

ALTER TABLE dbo.WF_CompensationRequestForADayOfRestSignature ADD
	SignatureCommentInverse nvarchar(255) NULL
GO

ALTER TABLE dbo.WF_LoanRequestSignature ADD
	SignatureCommentInverse nvarchar(255) NULL
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3523, N'إرجاع طلب تغيير يوم الراحة', N'Inverse Change Day off Request Signature', 174, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3524, N'إرجاع طلب تعويض عن يوم راحه', N'Inverse Compensation Day off Request Signature', 221, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3525, N'إرجاع طلب عام', N'Inverse General Request Signature', 198, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3526, N'إرجاع طلب سلفه', N'Inverse Loan Request Signature', 85, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3527, N'إرجاع طلب الصيانه', N'Inverse Maintenance Request Signature', 114, 2)
 ------------------------------- End 2020-04-23 -----------------------

	
	