-------------------------------- Ali 2019-12-3----------------

ALTER TABLE dbo.SecurityUserSection ADD
	FullOption bit NOT NULL CONSTRAINT DF_SecurityUserSection_FullOption DEFAULT 0
GO
 -------------------------------- End 2019-12-3----------------
 -------------------------------- Hammad 2019-12-3-------------
SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (146, N'Sending Notification For First Level', N'نموذج إرسال إشعارات للمستوى الاول', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (147, N'Sending Notification For Up Level', N'نموذج إرسال إشعارات للمستوى الاعلى', 0, 1)
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF


SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (146, N'Sending Notification For First Level', N'نموذج إرسال إشعارات للمستوى الاول', 146, N'إرسال إشعارات للمستوى الاول', N'<p>&nbsp;</p><p>عدد المعلق فى طلبات <span contenteditable="false">@Raw(Model.RequestName)</span>&nbsp;=<span contenteditable="false">@Raw(Model.PendingCount)</span></p><p>معلق من فتره ساعات</p><p><span contenteditable="false">@Raw(Model.PendingFromHourCount)</span></p><p>الى</p><p><span contenteditable="false">@Raw(Model.PendingToHourCount)</span></p>', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (147, N'Sending Notification For Up Level', N'نموذج إرسال إشعارات للمستوى الاعلى', 147, N'إرسال إشعارات للمستوى الاعلى', N'<p>إرسال إشعارات للمستوى الاعلى</p><p>المعلق عند المستخدم <span contenteditable="false">@Raw(Model.PendingOnEmployee)</span> يساوى&nbsp;<span contenteditable="false">@Raw(Model.PendingCount)</span></p><p>فى&nbsp;<span contenteditable="false">@Raw(Model.RequestName)</span></p><p>&nbsp;</p>', 1, NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF
GO
 -------------------------------- End 2019-12-3-------------
 -------------------------------- Hammad 2019-12-5----------
EXEC sp_rename 'WF_VacationEmployeeTrack', 'WF_OtherEmployeeTrack';  
Go
EXEC sp_rename 'WF_OtherEmployeeTrack.VacationCode', 'OtherCode', 'COLUMN';
Go

ALTER TABLE [dbo].[WF_OtherEmployeeTrack] DROP CONSTRAINT [FK_WF_VacationEmployeeTrack_VacationType]
GO


ALTER TABLE [dbo].[WF_OtherEmployeeTrack] DROP CONSTRAINT [FK_WF_VacationEmployeeTrack_VacationType]
GO

Update [dbo].[SystemMenu] set ControllerName='/WorkFlow/OtherEmployeeTrack' where SystemMenuCode=98
 Go

 -------------------------------- End 2019-12-5----------
 -------------------------------- Ali 2019-12-5----------------

 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (235, N'Appraisal Element Group', N'مجموعة عناصر التقييم', 161, N'/Appraisal/AppraisalElementGroup', N'Index', NULL, N'get', 12, 1, 1)
  Go

 SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
 INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (4512, 235, 8)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
Go

 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10050, N'مجموعة عناصر التقييم', N'Appraisal Element Group', 235, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10051, N'اضافة مجموعة عناصر التقييم ', N'Add Appraisal Element Group', 235, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10052, N'تعديل مجموعة عناصر التقييم ', N'Edit Appraisal Element Group', 235, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10053, N'حذف مجموعة عناصر التقييم ', N'Delete Appraisal Element Group', 235, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10054, N'حفظ مجموعة عناصر التقييم ', N'Save Appraisal Element Group', 235, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10055, N'عرض مجموعة عناصر التقييم ', N'ViewAppraisal Element Group', 235, 2)
Go

 -------------------------------- End 2019-12-5----------

   -------------------------------- Ali 2019-12-8----------
   ALTER TABLE dbo.WF_VacationRequest ADD
	DisclaimerSignatureDate datetime NULL,
	DisclaimerSignatureDateHijri nvarchar(10) NULL
GO

  -------------------------------- End 2019-12-8----------
   -------------------------------- Ali 2019-12-9----------
   INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFAttachmentMandatory',N'attachment request mandatory',N'مرفق الطلب الزامي',N'True',2,3,1,1,Null,Null,7)
Go
  -------------------------------- End 2019-12-9----------
  -------------------------------- Hammad 2019-12-9----------
 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WfVacMaxDaysDisclaimerDate',N'Max Days For Disclaimer Date Befor Vacation Date',N'الحد الأقصى لتاريخ إخلاء الطرف من الإجازة',N'5',2,35,2,1,Null,Null,11)
Go

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WfVacMinDaysDisclaimerDate',N'Min Days For Disclaimer Date Befor Vacation Date',N'الحد الأدنى لتاريخ إخلاء الطرف من الإجازة',N'1',2,36,2,1,Null,Null,11)
Go

-------------------------------- End 2019-12-9----------