﻿ ---------------------------Hammad 2020-12-23--------------------------
 INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'IntegrateWFWithRecruitment', N'Integrate WF With Recruitment', N'تكامل سير العمل مع التوظيف', N'false', 1, 13, 1, 1, NULL, NULL, NULL)
 GO

 ALTER TABLE dbo.WF_NewHireRequest ADD
	ForeignerUserCode int NULL
GO
  ---------------------------End 2020-12-23-----------------------------
--------------------------Ali 2021-10-27-------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(566,N'Calculation Annual Work Incentive',N'احتساب حافز العمل السنوي',161,N'/Appraisal/CalculationAnnualWorkIncentive',N'Index','fa fa-thumb-tack',N'get',20,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(566,8)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10093,N'احتساب حافز العمل السنوي',N'Calculation Annual Work Incentive',566,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10094,N'عرض احتساب حافز العمل السنوي',N'View Calculation Annual Work Incentive',566,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10095,N'إضافة طلب علاوة لحافز العمل السنوي',N'Add Bonus Request For Annual Work Incentive',566,2)
	INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10099,N'حفظ حافز العمل السنوي',N'Save Calculation Annual Work Incentive',566,2)
Go

--------------------------End 2021-10-27-------------------
--------------------------Hammad 2021-10-27----------------
ALTER TABLE dbo.WF_Track ADD
	SendEmailAfterTrackToUserTypes nvarchar(100) NULL
GO
--------------------------End 2021-10-27----------------
--------------------------Ali 2021-10-28-------------------

  ALTER TABLE dbo.WF_BonusesRequest ADD
	IsFromAppraisal bit NOT NULL CONSTRAINT DF_WF_BonusesRequest_IsFromAppraisal DEFAULT ((0))
GO
--------------------------End 2021-10-28----------------
---------------------AK 2021-10-31------------
INSERT INTO SecurityPrivilege (ID, DescriptionAR, DescriptionEN, SystemMenuCode,PrivilegeType) VALUES (3990,N'عرض المؤهلات',N'View Qualifications', 3,2);
INSERT INTO SecurityPrivilege (ID, DescriptionAR, DescriptionEN, SystemMenuCode,PrivilegeType) VALUES (3991,N'عرض الترقيات',N'View Employee Promotion', 3,2);
Update ConfigParameter SET Arabic_Name=N'قراءة البيانات من قاعدة البيانات الاساسية', Name='Read data from source data' WHERE ConfigKey='ReadTimeAttandancePayRoll'
Go
---------------------end 2021-10-31------------

---------------------Ali 2021-10-31------------

  ALTER TABLE dbo.WF_BonusType ADD
	RelatedToAppraisal bit NOT NULL CONSTRAINT DF_WF_BonusType_RelatedToAppraisal DEFAULT ((0))
  GO

  INSERT [dbo].[WF_BonusType] ( [Name], [Arabic_Name], [Type], [Amount], [MaxRequestCount], [MaxRequestCountType], [DaysCountAfterHiring], [AttachmentRequired], [BandCode], [RelatedToAppraisal])
  VALUES ( N'Bonus Type Calculation Incentive From Appraisal', N' نوع علاوة احتساب الحافز من التقييم', 0, 0, 0, 0, 0, 0, 1, 1)
  GO
---------------------end 2021-10-31------------
---------------------AK 2021-10-31------------
   ALTER TABLE dbo.WF_SendEmailSetup ADD
	[FLevelFromHourCount] [float] NOT NULL,
	[FLevelToHourCount] [float] NOT NULL,
	[FLevelHoursRepeatReminder] [nvarchar](50) NULL,
	[FLevelBcc] [nvarchar](50) NULL,
	[FLevelCC] [nvarchar](50) NULL,	
	[UpLevelBcc] [nvarchar](50) NULL,
	[UpLevelCC] [nvarchar](50) NULL
	GO

ALTER TABLE dbo.WF_SendEmailSetup Drop COLUMN  ToUserAfterHourCount
GO
---------------------end 2021-10-31------------

---------------------Mostafa 2021-11-01------------
ALTER TABLE dbo.WF_PromotionRequest ADD
IsFromAppraisal bit NOT NULL  DEFAULT ((0))
GO
ALTER TABLE dbo.PromotionReasons ADD
IsPromotionReasons bit NOT NULL  DEFAULT ((0))
GO
insert into dbo.PromotionReasons(PromotionReasonCode,Name,Arabic_Name,SocialIncrease,IsPromotionReasons)
VALUES((select max(PromotionReasonCode)+1 from PromotionReasons)  ,N'upgrade from evaluation',N'ترقية من التقييم',0,1)

GO
---------------------end 2021-11-01------------
