﻿--------------------------Ali 2021-05-11-------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(519,N'Back to work request',N'طلب مباشرة العمل',496,N'/WorkFlow/BackToWorkRequest',N'Index','fa fa-thumb-tack',N'get',17,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15149,N'طلب مباشرة العمل',N'Back to work request',519,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15150,N'عرض طلب مباشرة العمل',N'View Back to work request',519,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15151,N'إضافة طلب مباشرة العمل',N'Add Back to work request',519,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15152,N'تعديل طلب مباشرة العمل',N'Edit Back to work request',519,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15153,N'حذف طلب مباشرة العمل',N'Delete Back to work request',519,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15154,N'حفظ طلب مباشرة العمل',N'Save Back to work request',519,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15155,N'الغاء طلب مباشرة العمل',N'Cancel Back to work request',519,2)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(754,N'WorkFlow',N'BackToWorkRequest',N'Index',0,N'get',15149)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(755,N'WorkFlow',N'BackToWorkRequest',N'BackToWorkRequest_Read',0,N'post',15150)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(756,N'WorkFlow',N'BackToWorkRequest',N'Save',1,N'get',15151)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(757,N'WorkFlow',N'BackToWorkRequest',N'Save',2,N'get',15152)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(758,N'WorkFlow',N'BackToWorkRequest',N'Delete',0,N'post',15153)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(759,N'WorkFlow',N'BackToWorkRequest',N'Save',0,N'post',15154)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(746,N'WorkFlow',N'BackToWorkRequest',N'Cancel',0,N'get',15155)
Go


INSERT[dbo].[WF_RequestType]([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment]) VALUES(49,N'طلب مباشرة العمل',N'Back to work request',0,N'sayedmustafa84@yahoo.com',N'sayedmustafa84@yahoo.com',N'1',N'smtp.sendgrid.net',587,N'SST',NULL,NULL,1,1,0,0)
Go
SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(244,N'Back to work request Sending',N'ارسال طلب مباشرة العمل',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(245,N'Back to work request Accept',N'الموافقة على طلب مباشرة العمل',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(246,N'Back to work request Refuse',N'رفض طلب مباشرة العمل',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(247,N'Back to work request Cancel',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(244,N'Back to work request Sending',N'ارسال طلب مباشرة العمل',244,N'ارسال',N'ارسال',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(245,N'Back to work request Accept',N'الموافقة على طلب مباشرة العمل',245,N'الموافقة على',N'الموافقة على',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(246,N'Back to work request Refuse',N'رفض طلب مباشرة العمل',246,N'رفض',N'رفض',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(247,N'Back to work request Cancel',N'الغاء طلب مباشرة العمل',247,N'الغاء',N'الغاء',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(520,N'Back to work Request Signature',N'اعتماد طلب مباشرة العمل',501,N'/WorkFlow/BackToWorkRequestSignature',N'Index','fa fa-thumb-tack',N'get',19,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15156,N'اعتماد طلب مباشرة العمل',N'Back to work Request Signature',520,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15157,N'عرض اعتماد طلب مباشرة العمل',N'View Back to work Request Signature',520,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15158,N'تعديل اعتماد طلب مباشرة العمل',N'Edit Back to work Request Signature',520,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15159,N'حفظ اعتماد طلب مباشرة العمل',N'Save Back to work Request Signature',520,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15160,N'حفظ متعدد العمل',N'Multiple Save',520,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15161,N'عرض سجل الموظف',N'View Employee History',520,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15162,N'ارجاع الطلب',N'Inverse Request',520,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15163,N'اختيار كل الطلبات',N'Choose All Requests',520,2)

Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(760,N'WorkFlow',N'BackToWorkRequestSignature',N'Index',0,N'get',15156)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(761,N'WorkFlow',N'BackToWorkRequestSignature',N'BackToWorkRequestSignature_Read',0,N'post',15157)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(762,N'WorkFlow',N'BackToWorkRequestSignature',N'Save',2,N'get',15158)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(763,N'WorkFlow',N'BackToWorkRequestSignature',N'Save',0,N'post',15159)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(764,N'WorkFlow',N'BackToWorkRequestSignature',N'SaveRequestSignatureLst',0,N'post',15160)
Go
--------------------------End 2021-05-11-------------
--------------------------Hammad 2021-05-18----------
CREATE TABLE [dbo].[EmployeeGrades](
	[EmployeeGradeCode] [int] NOT NULL,
	[Name] [nvarchar](255) NULL,
	[Arabic_Name] [nvarchar](255) NULL,
	[Closed] [bit] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_EmployeeGrades_EmployeeGradeCode] PRIMARY KEY CLUSTERED 
(
	[EmployeeGradeCode] 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_NewJobRequest] DROP CONSTRAINT [FK_WF_NewJobRequest_Grade]
GO

ALTER TABLE WF_NewJobRequest
DROP COLUMN GradeCode
Go

ALTER TABLE WF_NewJobRequest Add
  EmployeeGradeCode int null,
  GeneralTypeCode tinyint  null
Go

ALTER TABLE [dbo].[WF_NewJobRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_NewJobRequest_EmployeeGrades] FOREIGN KEY([EmployeeGradeCode])
REFERENCES [dbo].[EmployeeGrades] ([EmployeeGradeCode])
GO

ALTER TABLE [dbo].[WF_NewJobRequest] CHECK CONSTRAINT [FK_WF_NewJobRequest_EmployeeGrades]
GO

ALTER TABLE [dbo].[WF_NewJobRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_NewJobRequest_GeneralTypes] FOREIGN KEY([GeneralTypeCode])
REFERENCES [dbo].[GeneralTypes] ([GeneralTypeCode])
GO

ALTER TABLE [dbo].[WF_NewJobRequest] CHECK CONSTRAINT [FK_WF_NewJobRequest_GeneralTypes]
GO

CREATE TABLE [dbo].[WF_NewJobRequestCondition](
	[NewJobRequestConditionCode] [int] IDENTITY(1,1) NOT NULL,
	[MasterRequestCode] [int] NOT NULL,
	[ConditionCode] [int] NOT NULL,
 CONSTRAINT [PK_WF_NewJobRequestCondition] PRIMARY KEY CLUSTERED 
(
	[NewJobRequestConditionCode] 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_NewJobRequestCondition]  WITH CHECK ADD  CONSTRAINT [FK_WF_NewJobRequestCondition_Condition] FOREIGN KEY([ConditionCode])
REFERENCES [dbo].[Condition] ([ConditionCode])
GO

ALTER TABLE [dbo].[WF_NewJobRequestCondition] CHECK CONSTRAINT [FK_WF_NewJobRequestCondition_Condition]
GO

ALTER TABLE [dbo].[WF_NewJobRequestCondition]  WITH CHECK ADD  CONSTRAINT [FK_WF_NewJobRequestCondition_WF_NewJobRequest] FOREIGN KEY([MasterRequestCode])
REFERENCES [dbo].[WF_NewJobRequest] ([MasterRequestCode])
GO

ALTER TABLE [dbo].[WF_NewJobRequestCondition] CHECK CONSTRAINT [FK_WF_NewJobRequestCondition_WF_NewJobRequest]
GO


--------------------------End 2021-05-18----------
--------------------------Hammad 2021-05-19-------
Delete ConfigParameter where ConfigKey='WfShiftInDayOfRest'
Go
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WFOverTimeNumberShiftHours', N'Number Of Additional Shift Hours', N'عدد ساعات الوردية الإضافية', N'8', 2, 15, 3, 1, NULL, NULL, 3)
 Go
 ALTER TABLE dbo.WF_OverTimeRequest ADD
	OvertimeEffectCode int NULL
GO
--------------------------End 2021-05-19--------
--------------------------Ali 2021-05-19--------

 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(522,N'Introduction Letter Request',N'طلب خطاب تعريف',496,N'/WorkFlow/IntroductionLetterRequest',N'Index','fa fa-thumb-tack',N'get',18,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15164,N'طلب خطاب تعريف',N'Introduction Letter Request',522,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15165,N'عرض طلب خطاب تعريف',N'View Introduction Letter Request',522,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15166,N'إضافة طلب خطاب تعريف',N'Add Introduction Letter Request',522,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15167,N'تعديل طلب خطاب تعريف',N'Edit Introduction Letter Request',522,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15168,N'حذف طلب خطاب تعريف',N'Delete Introduction Letter Request',522,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15169,N'حفظ طلب خطاب تعريف',N'Save Introduction Letter Request',522,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15170,N'الغاء طلب خطاب تعريف',N'Cancel Introduction Letter Request',522,2)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(765,N'WorkFlow',N'IntroductionLetterRequest',N'Index',0,N'get',15164)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(766,N'WorkFlow',N'IntroductionLetterRequest',N'IntroductionLetterRequest_Read',0,N'post',15165)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(767,N'WorkFlow',N'IntroductionLetterRequest',N'Save',1,N'get',15166)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(768,N'WorkFlow',N'IntroductionLetterRequest',N'Save',2,N'get',15167)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(769,N'WorkFlow',N'IntroductionLetterRequest',N'Delete',0,N'post',15168)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(770,N'WorkFlow',N'IntroductionLetterRequest',N'Save',0,N'post',15169)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(771,N'WorkFlow',N'IntroductionLetterRequest',N'Cancel',0,N'get',15170)
Go

INSERT[dbo].[WF_RequestType]([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment]) VALUES(50,N'طلب خطاب تعريف',N'Introduction Letter Request',0,N'sayedmustafa84@yahoo.com',N'sayedmustafa84@yahoo.com',N'1',N'smtp.sendgrid.net',587,N'SST',NULL,NULL,1,1,0,0)
Go
SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(248,N'Introduction Letter Request Sending',N'ارسال طلب خطاب تعريف',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(249,N'Introduction Letter Request Accept',N'الموافقة على طلب خطاب تعريف',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(250,N'Introduction Letter Request Refuse',N'رفض طلب خطاب تعريف',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(251,N'Introduction Letter Request Cancel',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(248,N'Introduction Letter Request Sending',N'ارسال طلب خطاب تعريف',248,N'ارسال',N'ارسال',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(249,N'Introduction Letter Request Accept',N'الموافقة على طلب خطاب تعريف',249,N'الموافقة على',N'الموافقة على',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(250,N'Introduction Letter Request Refuse',N'رفض طلب خطاب تعريف',250,N'رفض',N'رفض',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(251,N'Introduction Letter Request Cancel',N'الغاء طلب خطاب تعريف',251,N'الغاء',N'الغاء',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(523,N'Introduction Letter Request Signature',N'اعتماد طلب خطاب تعريف',501,N'/WorkFlow/IntroductionLetterRequestSignature',N'Index','fa fa-thumb-tack',N'get',20,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15171,N'اعتماد طلب خطاب تعريف',N'Introduction Letter Request Signature',523,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15172,N'عرض اعتماد طلب خطاب تعريف',N'View Introduction Letter Request Signature',523,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15173,N'تعديل اعتماد طلب خطاب تعريف',N'Edit Introduction Letter Request Signature',523,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15174,N'حفظ اعتماد طلب خطاب تعريف',N'Save Introduction Letter Request Signature',523,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15175,N'حفظ متعدد للاعتماد',N'Multiple Save',523,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15176,N'عرض سجل الموظف',N'View Employee History',523,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15177,N'ارجاع الطلب',N'Inverse Request',523,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15178,N'اختيار كل الطلبات',N'Choose All Requests',523,2)

Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(772,N'WorkFlow',N'IntroductionLetterRequestSignature',N'Index',0,N'get',15171)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(773,N'WorkFlow',N'IntroductionLetterRequestSignature',N'IntroductionLetterRequestSignature_Read',0,N'post',15172)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(774,N'WorkFlow',N'IntroductionLetterRequestSignature',N'Save',2,N'get',15173)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(775,N'WorkFlow',N'IntroductionLetterRequestSignature',N'Save',0,N'post',15174)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(776,N'WorkFlow',N'IntroductionLetterRequestSignature',N'SaveRequestSignatureLst',0,N'post',15175)
Go
--------------------------End 2021-05-19--------
--------------------------Hammad 2021-05-20-----

ALTER TABLE dbo.WF_CompensationAllowanceTypes ADD
	BalanceFactor float(53) NULL,
	BalanceFactorTypeCode int NULL,
	ForcingBreak bit NOT NULL CONSTRAINT DF_WF_CompensationAllowanceTypes_ForcingBreak DEFAULT ((0))
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'WFCompensationReducedBalance', N'Adding a day of compensation reduced from balance Weekend or holiday', N'عند إضافة يوم التعويض  تخفيض يوم من رصيد الراحة  الاسبوعبية او الاجازات الرسمية ', N'false', 2, 1, 1, 1, NULL, NULL, 21)
Go
ALTER TABLE dbo.WF_CompensationRequestForADayOfRest ADD
	BalanceFactor float(53) NULL,
	BalanceFactorTypeCode tinyint NULL
GO
--------------------------End 2021-05-20-----
--------------------------Ali 2021-05-20-----
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(524,N'Medical Inquiry Request',N'طلب استفسار طبى',496,N'/WorkFlow/MedicalInquiryRequest',N'Index','fa fa-thumb-tack',N'get',19,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15179,N'طلب استفسار طبى',N'Medical Inquiry Request',524,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15180,N'عرض طلب استفسار طبى',N'View Medical Inquiry Request',524,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15181,N'إضافة طلب استفسار طبى',N'Add Medical Inquiry Request',524,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15182,N'تعديل طلب استفسار طبى',N'Edit Medical Inquiry Request',524,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15183,N'حذف طلب استفسار طبى',N'Delete Medical Inquiry Request',524,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15184,N'حفظ طلب استفسار طبى',N'Save Medical Inquiry Request',524,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15185,N'الغاء طلب استفسار طبى',N'Cancel Medical Inquiry Request',524,2)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(777,N'WorkFlow',N'MedicalInquiryRequest',N'Index',0,N'get',15179)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(778,N'WorkFlow',N'MedicalInquiryRequest',N'MedicalInquiryRequest_Read',0,N'post',15180)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(779,N'WorkFlow',N'MedicalInquiryRequest',N'Save',1,N'get',15181)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(780,N'WorkFlow',N'MedicalInquiryRequest',N'Save',2,N'get',15182)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(781,N'WorkFlow',N'MedicalInquiryRequest',N'Delete',0,N'post',15183)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(782,N'WorkFlow',N'MedicalInquiryRequest',N'Save',0,N'post',15184)
Go

INSERT[dbo].[WF_RequestType]([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment]) VALUES(51,N'طلب استفسار طبى',N'Medical Inquiry Request',0,N'sayedmustafa84@yahoo.com',N'sayedmustafa84@yahoo.com',N'1',N'smtp.sendgrid.net',587,N'SST',NULL,NULL,1,1,0,0)
Go
SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(252,N'Medical Inquiry Request Sending',N'ارسال طلب استفسار طبى',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(253,N'Medical Inquiry Request Accept',N'الموافقة على طلب استفسار طبى',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(254,N'Medical Inquiry Request Refuse',N'رفض طلب استفسار طبى',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(255,N'Medical Inquiry Request Cancel',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(252,N'Medical Inquiry Request Sending',N'ارسال طلب استفسار طبى',252,N'ارسال',N'ارسال',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(253,N'Medical Inquiry Request Accept',N'الموافقة على طلب استفسار طبى',253,N'الموافقة على',N'الموافقة على',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(254,N'Medical Inquiry Request Refuse',N'رفض طلب استفسار طبى',254,N'رفض',N'رفض',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(255,N'Medical Inquiry Request Cancel',N'الغاء طلب استفسار طبى',255,N'الغاء',N'الغاء',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF

---



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(525,N'Medical Inquiry Request Signature',N'اعتماد طلب استفسار طبى',501,N'/WorkFlow/MedicalInquiryRequestSignature',N'Index','fa fa-thumb-tack',N'get',21,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15186,N'اعتماد طلب استفسار طبى',N'Medical Inquiry Request Signature',525,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15187,N'عرض اعتماد طلب استفسار طبى',N'View Medical Inquiry Request Signature',525,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15188,N'تعديل اعتماد طلب استفسار طبى',N'Edit Medical Inquiry Request Signature',525,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15189,N'حفظ اعتماد طلب استفسار طبى',N'Save Medical Inquiry Request Signature',525,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15190,N'حفظ متعدد للاعتماد',N'Multiple Save',525,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15191,N'عرض سجل الموظف',N'View Employee History',525,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15192,N'ارجاع الطلب',N'Inverse Request',525,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15193,N'اختيار كل الطلبات',N'Choose All Requests',525,2)

Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(784,N'WorkFlow',N'MedicalInquiryRequestSignature',N'Index',0,N'get',15186)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(785,N'WorkFlow',N'MedicalInquiryRequestSignature',N'MedicalInquiryRequestSignature_Read',0,N'post',15187)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(786,N'WorkFlow',N'MedicalInquiryRequestSignature',N'Save',2,N'get',15188)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(787,N'WorkFlow',N'MedicalInquiryRequestSignature',N'Save',0,N'post',15189)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(788,N'WorkFlow',N'MedicalInquiryRequestSignature',N'SaveRequestSignatureLst',0,N'post',15190)
Go





 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WfRequestDateDependentOnFinancialEffectsMonth',N'? Request date dependent on financial effects month',N'تاريخ الطلب يخضع لشهر المؤثرات المالية ؟',N'False',2,1,1,1,Null,Null,51)
Go


 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFNumberOfRequestedPerMonth',N'Number of requested per month',N'عدد المرات للطلب فى الشهر',N'3',2,2,2,1,Null,Null,51)
Go
--------------------------End 2021-05-20-----
