﻿

---------------------------------------Ali 2019-08-17-----------------------------------------

   ALTER TABLE [WF_CompensationRequestForADayOfRest]
ADD [CompensationAllowanceTypeCode] [int] NOT NULL ;
Go


ALTER TABLE [dbo].[WF_CompensationRequestForADayOfRest]  WITH CHECK ADD  CONSTRAINT [FK_WF_CompensationRequestForADayOfRest_WF_CompensationAllowanceTypes] FOREIGN KEY([CompensationAllowanceTypeCode])
REFERENCES [dbo].[WF_CompensationAllowanceTypes] ([CompensationAllowanceTypeCode])
GO



ALTER TABLE [WF_CompensationRequestForADayOfRest]
DROP COLUMN CompensationType;
---------------------------------------End 2019-08-17-----------------------------------------
---------------------------------------Hammad 2019-08-18--------------------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (222, N'Over Time Request Final Signature', N'اعتماد نهائى للوقت الإضافى', 108, N'/WorkFlow/OverTimeRequestFinalSignature', N'Index', NULL, N'get', 36, 1, 1)
 Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3386, N'اعتماد نهائى للوقت الإضافى', N'Over Time Request Final Signature ', 222, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3387, N'عرض اعتماد نهائى للوقت الإضافى', N'View Over Time Request Final Signature ', 222, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3388, N'تعديل اعتماد نهائى للوقت الإضافى', N'Edit Over Time Request Final Signature ', 222, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3389, N'حفظ اعتماد نهائى للوقت الإضافى', N'Save Over Time Request Final Signature ', 222, 2)
Go
SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (3450, 222, 1)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF

---------------------------------------End 2019-08-18--------------------------------------

---------------------------------------Ali 2019-08-19-----------------------------------------

  delete from [WF_FactorType]
  where [FactorTypeCode] in (10,13)

  ---------------------------------------End 2019-08-19-----------------------------------------
  ---------------------------------------Sayed 2019-08-21---------------------------------------
  SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
GO

INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (128, N'OverTime Request Final Sending', N'إرسال طلب الموافقة النهائية على الوقت الإضافى', 0, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (129, N'OverTime Request Final Sending Accept', N'الموافقة النهائية على الوقت الإضافى', 0, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (130, N'OverTime Request Final Sending Refuse', N'رفض الموافقة النهائية على الوقت الإضافى', 0, 1)
GO
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
GO

SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
GO

INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (128, N'OverTime Request Final Sending', N'إرسال طلب الموافقة النهائية على الوقت الإضافى', 128, N'إرسال طلب الموافقة النهائية على الوقت الإضافى', N'<p>&nbsp;</p><p>نرجو الموافقة على طلب </p>', 1, NULL)
GO
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (129, N'OverTime Request Final Sending Accept', N'الموافقة النهائية على الوقت الإضافى', 129, N'الموافقة النهائية على الوقت الإضافى', N'<p>نرجو الموافقة على طلب </p>', 1, NULL)
GO
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (130, N'OverTime Request Final Sending Refuse', N'رفض الموافقة النهائية على الوقت الإضافى', 130, N'رفض الموافقة النهائية على الوقت الإضافى', N'<p>تم رفض الطلب </p>', 1, NULL)
GO
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF
GO
---------------------------------------End 2019-08-21-----------------------------------------
---------------------------------------Hammad 2019-08-22-----------------------------------------


ALTER TABLE dbo.WF_CompensationRequestForADayOfRest ADD
	FinalApproval tinyint NOT NULL CONSTRAINT DF_WF_CompensationRequestForADayOfRest_FinalApproval DEFAULT ((0)),
	FinalApprovalTrackCode int NULL,
	FinalCompensationDayAfterFactor float(53) NULL,
	FinalApprovalDate datetime NULL,
	FinalApprovalDateHijri nvarchar(10) NULL
GO

CREATE TABLE [dbo].[WF_CompensationRequestFinalDayRestSignature](
	[CompensationRequestFinalDayRestSignatureId] [bigint] IDENTITY(1,1) NOT NULL,
	[CompensationRequestForADayOfRestId] [bigint] NOT NULL,
	[StepNumber] [int] NOT NULL,
	[UserId] [int] NOT NULL,
	[Approved] [tinyint] NOT NULL,
	[SignatureDate] [datetime] NULL,
	[SignatureTime] [nvarchar](10) NULL,
	[SignatureComment] [nvarchar](255) NULL,
	[Turn] [int] NULL,
	[SignatureDateHijri] [nvarchar](10) NULL,
	[OldUserCode] [int] NULL,
	[ChangedBy] [int] NULL,
	[ChangeDate] [datetime] NULL,
	[CompensationDayAfterFactor] [float] NULL,
 CONSTRAINT [PK_WF_CompensationRequestFinalDayRestSignature] PRIMARY KEY CLUSTERED 
(
	[CompensationRequestFinalDayRestSignatureId] 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_CompensationRequestFinalDayRestSignature]  WITH CHECK ADD  CONSTRAINT [FK_WF_CompensationRequestFinalDayRestSignature_SecurityUser] FOREIGN KEY([UserId])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_CompensationRequestFinalDayRestSignature] CHECK CONSTRAINT [FK_WF_CompensationRequestFinalDayRestSignature_SecurityUser]
GO

ALTER TABLE [dbo].[WF_CompensationRequestFinalDayRestSignature]  WITH CHECK ADD  CONSTRAINT [FK_WF_CompensationRequestFinalDayRestSignature_WF_CompensationRequestForADayOfRest] FOREIGN KEY([CompensationRequestForADayOfRestId])
REFERENCES [dbo].[WF_CompensationRequestForADayOfRest] ([CompensationRequestForADayOfRestId])
GO

ALTER TABLE [dbo].[WF_CompensationRequestFinalDayRestSignature] CHECK CONSTRAINT [FK_WF_CompensationRequestFinalDayRestSignature_WF_CompensationRequestForADayOfRest]
GO

ALTER TABLE [dbo].[WF_CompensationRequestFinalDayRestSignature]  WITH CHECK ADD  CONSTRAINT [FK_WF_CompensationRequestFinalDayRestSignature_WF_RequestStatus] FOREIGN KEY([Approved])
REFERENCES [dbo].[WF_RequestStatus] ([RequestStatusId])
GO

ALTER TABLE [dbo].[WF_CompensationRequestFinalDayRestSignature] CHECK CONSTRAINT [FK_WF_CompensationRequestFinalDayRestSignature_WF_RequestStatus]
GO


SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (130, N'OverTime Request Final Sending Refuse', N'رفض الموافقة النهائية على الوقت الإضافى', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (131, N'Compensation Request Final Sending', N'إرسال طلب الموافقة النهائية على تعويض يوم راحة', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (132, N'Compensation Request Final Accept', N'الموافقة النهائية على تعويض يوم راحة', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (133, N'Compensation Request Final Refuse', 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 (130, N'OverTime Request Final Sending Refuse', N'رفض الموافقة النهائية على الوقت الإضافى', 130, N'رفض الموافقة النهائية على الوقت الإضافى', N'<p>تم رفض الطلب </p>', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (131, N'Compensation Request Final Sending', N'إرسال طلب الموافقة النهائية على تعويض يوم راحة', 131, N'إرسال طلب الموافقة النهائية على تعويض يوم راحة', N'<p>&nbsp;</p><p>نرجو الموافقة على طلب </p>', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (132, N'Compensation Request Final Accept', N'الموافقة النهائية على تعويض يوم راحة', 132, N'الموافقة النهائية على تعويض يوم راحة', N'<p>نرجو الموافقة على طلب </p>', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (133, N'Compensation Request Final Refuse', N'رفض الموافقة النهائية على تعويض يوم راحة', 133, N'رفض الموافقة النهائية على تعويض يوم راحة', N'<p>تم رفض الطلب </p>', 1, NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (223, N'Compensation Request Final Day Rest Signature', N'اعتماد نهائى طلب تعويض عن يوم راحه', 108, N'/WorkFlow/CompensationRequestFinalDayRestSignature', N'Index', NULL, N'get', 37, 1, 1)
 Go

 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3390, N'اعتماد نهائى طلب تعويض عن يوم راحه', N'Compensation Request Final Day Rest Signature', 223, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3391, N'عرض اعتماد نهائى طلب تعويض عن يوم راحه', N'View Compensation Request Final Day Rest Signature', 223, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3392, N'تعديل اعتماد نهائى طلب تعويض عن يوم راحه', N'Edit Compensation Request Final Day Rest Signature', 223, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3393, N'حفظ اعتماد نهائى طلب تعويض عن يوم راحه', N'Save Compensation Request Final Day Rest Signature', 223, 2)
GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (3451, 223, 1)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF


INSERT [dbo].[WF_RequestType] ([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate])
 VALUES (22, N'الموافقة النهائية لطلب تعويض عن يوم راحه', N'Final Approval For Compensation Request ', 0, N'sayedmustafa1984@gmail.com', N'sayedmustafa1984@gmail.com', N'123', N'smtp.sendgrid.net', 587, N'Sayed', NULL, NULL)
 Go
---------------------------------------End 2019-08-22-----------------------------------------
---------------------------------------Hammad 2019-08-25-----------------------------------------
ALTER TABLE dbo.WF_CompensationRequestForADayOfRest ADD
	Period tinyint NULL,
	PYear smallint NULL
GO
---------------------------------------End 2019-08-25-----------------------------------------
---------------------------------------Hammad 2019-08-27--------------------------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WFMaxOverTimeHoursCount', N'Maximum count of over time hours', N'الحد الأقصى لعدد سعات الوقت الاضافى', N'6', 2, 2, 2, 1, NULL, NULL, 3)
 
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'BalanceCalcPeriod', N'Vacation Balance till', N'إظهار رصيد الأجازات حتى', N'54', 1, 8, 6, 1, 1, CAST(N'2019-08-27 17:02:13.627' AS DateTime), NULL)
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (54, N'Current Month End', N'نهاية الشهر الحالي', N'BalanceCalcPeriod')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (55, N'Year End', N'نهاية العام', N'BalanceCalcPeriod')
Go
 ---------------------------------------End 2019-08-27--------------------------------------
 ---------------------------------------Hammad 2019-09-01--------------------------------------
 ALTER TABLE dbo.WF_AirTicketRequest ADD
	FileName nvarchar(150) NULL
GO

ALTER TABLE dbo.WF_NewEmployeesRequest ADD
	FileName nvarchar(150) NULL
GO
 ---------------------------------------End 2019-09-01--------------------------------------

  ---------------------------------------Ali 2019-09-02--------------------------------------

 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3394, N'سجل طلبات التعويض', N'Compensation Request View History', 221, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3395, N'سجل طلبات الوقت الاضافى للموظف', N'Employee History For OverTime Request ', 65, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3396, N'  سجل طلبات البصمة للموظف', N' Employee History For Finger Print Request', 70, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3397, N'سجل طلبات السلفة للموظف', N'Loan Request Employee History', 85, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3398, N'سجل طلبات الجزاءات للموظف', N'Penalty Request Employee History', 126, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3399, N'سجل طلبات العلاوة للموظف', N'Bonus Request Employee History', 145, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3400, N' سجل طلبات  المركبة للموظف', N'Vehicle Request Employee History', 147, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3401, N' سجل طلبات  تغيير يوم الراحة للموظف', N'Change Day off Request Employee History', 174, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3402, N' سجل الطلبات  العامة للموظف', N'General Request Employee History', 198, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3403, N' سجل طلبات  الترقية للموظف', N'  Promotion Request Employee History', 90, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3404, N' سجل طلبات  الاذونات للموظف', N' Permission Request Employee History', 37, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3405, N' سجل طلبات  الاجازات للموظف', N'Vacations Request Employee History', 92, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3406, N'   سجل طلبات  تذكرة الطيران للموظف', N'AirTicket Request Employee History', 67, 2)


 INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'WFUseSignatureReports', N'Use Signature Reports', N'استخدام التوقيع على التقارير', N'false', 2, 6, 1, 1, NULL, NULL, 0)
 GO
 ---------------------------------------End 2019-09-02--------------------------------------

  ---------------------------------------Ali 2019-09-03--------------------------------------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3407, N'سجل الطلبات النهائيه للتعويض  للموظف', N' Compensation Request Final Employee History', 223, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3408, N' سجل الطلبات النهائيه للوقت الاضافى للموظف', N'OverTime Request Final  Employee History', 222, 2)
Go
 ---------------------------------------End 2019-09-03--------------------------------------

  ---------------------------------------Ali 2019-09-04--------------------------------------
   ALTER TABLE [WF_LoanTypeDetials]
 ADD  [CanEditLoanDate] bit NOT NULL 
 DEFAULT (1);
  GO
 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1172, N'امكانية تعديل اسم المستخدم ', N'Can Edit User Name', 6, 2)
 GO
  ---------------------------------------End 2019-09-04--------------------------------------
  ---------------------------------------Sayed 2019-09-04---------------------------
  Update dbo.ConfigParameter set IsVisible=1,RequestTypeId=11 where ConfigKey='WFHaveDisclaimer' 
  Go
  --------------------------------------End 2019-09-04------------------------------
  --------------------------------------Hammad 2019-09-04------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (224, N'Reports', N'التقارير', 161, NULL, NULL, N'fa fa-thumb-tack', NULL, 13, 1, 1)

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (225, N'Employee Evaluation Status', N'حالة تقييم الموظف ', 224, N'/Appraisal/EmployeeEvaluationStatusReport', N'Index', NULL, N'get', 1, 1, 1)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (228, N' Follow Managers Evaluation', N'متابعة تقيم المدراء   ', 224, N'/Appraisal/EvaluationPresidentsReport', N'Index', NULL, N'get', 1, 1, 1)
 Go

 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10041, N'التقارير', N'Reports', 224, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10042, N'حالة تقييم الموظف ', N'Employee Evaluation Status ', 225, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10043, N'عرض حالة تقييم الموظف ', N'View Employee Evaluation Status', 225, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10044, N'متابعة تقيم المدراء ', N'Follow Managers Evaluation ', 228, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10045, N'عرض متابعة تقيم المدراء  ', N'View Follow Managers Evaluation', 228, 2)
Go


INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 224, 8)
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 225, 8)
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 228, 8)

Go

  --------------------------------------End 2019-09-04------------------------------
  --------------------------------------Hammad 2019-09-08---------------------------
  INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (229, N' Evaluation Category Notes Report', N'تقرير ملاحظات فئة التقييم  ', 224, N'/Appraisal/EvaluationCategoryNotesReport', N'Index', NULL, N'get', 3, 1, 1)
 Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10046, N'تقرير ملاحظات فئة التقييم  ', N'Evaluation Category Notes Report ', 229, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10047, N'عرض تقرير ملاحظات فئة التقييم  ', N'View Evaluation Category Notes Report', 229, 2)
Go
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 229, 8)
Go

ALTER TABLE dbo.WF_OverTimeRequest ADD
	RequestDateTo datetime NULL,
	RequestDateToHijri nvarchar(10) NULL
GO


CREATE TABLE [dbo].[WF_OverTimeRequestDetails](
	[OverTimeRequestDetailCode] [int] IDENTITY(1,1) NOT NULL,
	[OverTimeRequestId] [bigint] NOT NULL,
	[RequestDetailDate] [datetime] NOT NULL,
 CONSTRAINT [PK_OverTimeRequestDetails] PRIMARY KEY CLUSTERED 
(
	[OverTimeRequestDetailCode] 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_OverTimeRequestDetails]  WITH CHECK ADD  CONSTRAINT [FK_WF_OverTimeRequestDetails_WF_OverTimeRequest] FOREIGN KEY([OverTimeRequestId])
REFERENCES [dbo].[WF_OverTimeRequest] ([OverTimeRequestId])
GO

ALTER TABLE [dbo].[WF_OverTimeRequestDetails] CHECK CONSTRAINT [FK_WF_OverTimeRequestDetails_WF_OverTimeRequest]
GO

  --------------------------------------End 2019-09-08---------------------------
  --------------------------------------A.Khaled 2019-09-10---------------------------
CREATE TABLE [dbo].[INV_ItemCategories](
	[CategoryCode] [int] IDENTITY(1,1) NOT NULL,
	[CategoryNumber] [nvarchar](30) NULL,
	[Name] [nvarchar](50) NULL,
	[Arabic_Name] [nvarchar](50) NULL,
	[GLSalesAccount] [nvarchar](15) NULL,
	[GLInventoryAccount] [nvarchar](15) NULL,
	[GLCostOfGoodsAccount] [nvarchar](15) NULL,
	[GLReturnedSalesAccount] [nvarchar](15) NULL,
	[GLReturnedPurchasesAccount] [nvarchar](15) NULL,
	[GLPurchasesAccount] [nvarchar](15) NULL,
	[Closed] [smallint] NULL,
 CONSTRAINT [PK__ScnItemC__371BA95462EC5D29] PRIMARY KEY CLUSTERED 
(
	[CategoryCode] 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

CREATE TABLE [dbo].[INV_ItemTypes](
	[ItemTypeCode] [int] IDENTITY(1,1) NOT NULL,
	[ItemTypeNumber] [smallint] NULL,
	[Name] [nvarchar](200) NULL,
	[Arabic_Name] [nvarchar](200) NULL,
 CONSTRAINT [PK__ScnItemT__6C3E5231B3FC769E] PRIMARY KEY CLUSTERED 
(
	[ItemTypeCode] 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

CREATE TABLE [dbo].[INV_ItemUnits](
	[UnitCode] [int] IDENTITY(1,1) NOT NULL,
	[UnitNumber] [nvarchar](4) NULL,
	[Name] [nvarchar](20) NULL,
	[Arabic_Name] [nvarchar](20) NULL,
	[LinkedGaugeCode] [nvarchar](4) NULL,
	[LinkFactor] [float] NULL,
	[Closed] [tinyint] NULL,
 CONSTRAINT [PK__ScnItemG__18FB719279050CEF] PRIMARY KEY CLUSTERED 
(
	[UnitCode] 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

CREATE TABLE [dbo].[INV_Stores](
	[StoreCode] [int] IDENTITY(1,1) NOT NULL,
	[StoreNumber] [nvarchar](10) NULL,
	[Name] [nvarchar](50) NULL,
	[Arabic_Name] [nvarchar](50) NULL,
	[GLAccount] [nvarchar](15) NULL,
	[Closed] [bit] NULL,
 CONSTRAINT [PK__ScnStore__02A384F9AC6DEA6D] PRIMARY KEY CLUSTERED 
(
	[StoreCode] 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

CREATE TABLE [dbo].[INV_Items](
	[ItemCode] [int] IDENTITY(1,1) NOT NULL,
	[ItemNumber] [nvarchar](100) NULL,
	[Name] [nvarchar](70) NULL,
	[Arabic_Name] [nvarchar](70) NULL,
	[ItemTypeCode] [int] NULL,
	[Alternative_Code] [nvarchar](25) NULL,
	[CategoryCode] [int] NULL,
	[UnitCode] [int] NULL,
	[DescriptionEnglish] [nvarchar](255) NULL,
	[DescriptionArabic] [nvarchar](255) NULL,
	[Group1] [nvarchar](50) NULL,
	[Group2] [nvarchar](50) NULL,
	[Group3] [nvarchar](50) NULL,
	[Group4] [nvarchar](50) NULL,
	[Group5] [nvarchar](50) NULL,
	[Group6] [nvarchar](50) NULL,
	[Length] [float] NULL,
	[Width] [float] NULL,
	[Height] [float] NULL,
	[Weight] [float] NULL,
	[CustomsDuty] [float] NULL,
	[Vendor] [nvarchar](5) NULL,
	[CostingMethod] [smallint] NULL,
	[InactiveFlag] [smallint] NULL,
	[TaxCode] [nvarchar](10) NULL,
	[SalesComission] [float] NULL,
	[IsCopied] [smallint] NULL,
	[UserParam1] [float] NULL,
	[UserParam2] [float] NULL,
	[AdjPrice] [smallint] NULL,
	[ForSale] [tinyint] NULL,
	[ForPuy] [tinyint] NULL,
	[ExpireRequired] [tinyint] NULL,
 CONSTRAINT [PK__ScnItems__7A8729A3] PRIMARY KEY CLUSTERED 
(
	[ItemCode] 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].[INV_Items]  WITH CHECK ADD  CONSTRAINT [FK_INV_Items_INV_ItemCategories] FOREIGN KEY([CategoryCode])
REFERENCES [dbo].[INV_ItemCategories] ([CategoryCode])
GO

ALTER TABLE [dbo].[INV_Items] CHECK CONSTRAINT [FK_INV_Items_INV_ItemCategories]
GO

ALTER TABLE [dbo].[INV_Items]  WITH CHECK ADD  CONSTRAINT [FK_INV_Items_INV_ItemTypes] FOREIGN KEY([ItemTypeCode])
REFERENCES [dbo].[INV_ItemTypes] ([ItemTypeCode])
GO

ALTER TABLE [dbo].[INV_Items] CHECK CONSTRAINT [FK_INV_Items_INV_ItemTypes]
GO

ALTER TABLE [dbo].[INV_Items]  WITH CHECK ADD  CONSTRAINT [FK_INV_Items_INV_ItemUnits] FOREIGN KEY([UnitCode])
REFERENCES [dbo].[INV_ItemUnits] ([UnitCode])
GO

ALTER TABLE [dbo].[INV_Items] CHECK CONSTRAINT [FK_INV_Items_INV_ItemUnits]
GO

CREATE TABLE [dbo].[INV_StoreItemsData](
	[StoreItemCode] [int] IDENTITY(1,1) NOT NULL,
	[StoreCode] [int] NULL,
	[ItemCode] [int] NULL,
	[ShelfLocation] [nvarchar](255) NULL,
	[ActualBalance] [float] NULL,
	[BeginningBlaance] [float] NULL,
	[BeginningCost] [float] NULL,
	[AverageCost] [float] NULL,
	[Reorder] [float] NULL,
	[Minimum] [float] NULL,
	[Maximum] [float] NULL,
	[SaleCommission] [float] NULL,
	[SalesPrice1] [float] NULL,
	[SalesPrice2] [float] NULL,
	[SalesPrice3] [float] NULL,
	[SalesPrice4] [float] NULL,
	[Stopped] [bit] NULL,
	[UseBackOrder] [bit] NULL,
	[NegativeBalances] [bit] NULL,
	[TaxExemption] [bit] NULL,
	[Closed] [bit] NULL,
	[LastCost] [float] NULL,
	[Reserved] [float] NULL,
	[PriceCode] [nvarchar](2) NULL,
	[Expire_Date] [datetime] NULL,
 CONSTRAINT [PK__ScnStore__A14F4407B518A0C5] PRIMARY KEY CLUSTERED 
(
	[StoreItemCode] 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].[INV_StoreItemsData]  WITH CHECK ADD  CONSTRAINT [FK_INV_StoreItemsData_INV_Items] FOREIGN KEY([ItemCode])
REFERENCES [dbo].[INV_Items] ([ItemCode])
GO

ALTER TABLE [dbo].[INV_StoreItemsData] CHECK CONSTRAINT [FK_INV_StoreItemsData_INV_Items]
GO

ALTER TABLE [dbo].[INV_StoreItemsData]  WITH CHECK ADD  CONSTRAINT [FK_INV_StoreItemsData_INV_Stores] FOREIGN KEY([StoreCode])
REFERENCES [dbo].[INV_Stores] ([StoreCode])
GO

ALTER TABLE [dbo].[INV_StoreItemsData] CHECK CONSTRAINT [FK_INV_StoreItemsData_INV_Stores]
GO

CREATE TABLE [dbo].[WF_Vendor](
	[VendorCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
 CONSTRAINT [PK_WF_Vendor] PRIMARY KEY CLUSTERED 
(
	[VendorCode] 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

CREATE TABLE [dbo].[WF_Customer](
	[CustomerCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
 CONSTRAINT [PK_WF_Customer] PRIMARY KEY CLUSTERED 
(
	[CustomerCode] 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

CREATE TABLE [dbo].[WF_PurchasesRequest](
	[PurchasesRequestCode] [int] IDENTITY(1,1) NOT NULL,
	[RequestDate] [datetime] NOT NULL,
	[RequestDateHijri] [nvarchar](10) NOT NULL,
	[RequestContent] [nvarchar](250) NULL,
	[TrackCode] [int] NOT NULL,
	[DepartmentApproval] [tinyint] NOT NULL,
	[CancelRequestNumber] [int] NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[CreationDateHijri] [nvarchar](10) NOT NULL,
	[Canceled] [bit] NOT NULL,
	[MainType] [tinyint] NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
	[ModificationDateHijri] [nvarchar](10) NULL,
	[StoreCode] [int] NOT NULL,
	[VendorCode] [int] NULL,
 CONSTRAINT [PK_WF_PurchasesRequest] PRIMARY KEY CLUSTERED 
(
	[PurchasesRequestCode] 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_PurchasesRequest] ADD  CONSTRAINT [DF_WF_PurchasesRequest_Canceled]  DEFAULT ((0)) FOR [Canceled]
GO

ALTER TABLE [dbo].[WF_PurchasesRequest] ADD  CONSTRAINT [DF_WF_PurchasesRequest_MainType]  DEFAULT ((0)) FOR [MainType]
GO

ALTER TABLE [dbo].[WF_PurchasesRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_PurchasesRequest_INV_Stores] FOREIGN KEY([StoreCode])
REFERENCES [dbo].[INV_Stores] ([StoreCode])
GO

ALTER TABLE [dbo].[WF_PurchasesRequest] CHECK CONSTRAINT [FK_WF_PurchasesRequest_INV_Stores]
GO

ALTER TABLE [dbo].[WF_PurchasesRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_PurchasesRequest_SecurityUser] FOREIGN KEY([ModifiedBy])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_PurchasesRequest] CHECK CONSTRAINT [FK_WF_PurchasesRequest_SecurityUser]
GO

ALTER TABLE [dbo].[WF_PurchasesRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_PurchasesRequest_SecurityUser1] FOREIGN KEY([CreatedBy])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_PurchasesRequest] CHECK CONSTRAINT [FK_WF_PurchasesRequest_SecurityUser1]
GO

ALTER TABLE [dbo].[WF_PurchasesRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_PurchasesRequest_WF_RequestStatus] FOREIGN KEY([DepartmentApproval])
REFERENCES [dbo].[WF_RequestStatus] ([RequestStatusId])
GO

ALTER TABLE [dbo].[WF_PurchasesRequest] CHECK CONSTRAINT [FK_WF_PurchasesRequest_WF_RequestStatus]
GO

ALTER TABLE [dbo].[WF_PurchasesRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_PurchasesRequest_WF_Track] FOREIGN KEY([TrackCode])
REFERENCES [dbo].[WF_Track] ([TrackId])
GO

ALTER TABLE [dbo].[WF_PurchasesRequest] CHECK CONSTRAINT [FK_WF_PurchasesRequest_WF_Track]
GO

ALTER TABLE [dbo].[WF_PurchasesRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_PurchasesRequest_WF_Vendor] FOREIGN KEY([VendorCode])
REFERENCES [dbo].[WF_Vendor] ([VendorCode])
GO

ALTER TABLE [dbo].[WF_PurchasesRequest] CHECK CONSTRAINT [FK_WF_PurchasesRequest_WF_Vendor]
GO

CREATE TABLE [dbo].[WF_PurchasesRequestDetails](
	[PurchasesRequestDetailsCode] [int] IDENTITY(1,1) NOT NULL,
	[PurchasesRequestCode] [int] NOT NULL,
	[ItemCode] [int] NOT NULL,
	[Quantity] [float] NOT NULL,
	[AverageCost] [float] NOT NULL,
 CONSTRAINT [PK_WF_PurchasesRequestDetails] PRIMARY KEY CLUSTERED 
(
	[PurchasesRequestDetailsCode] 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_PurchasesRequestDetails]  WITH CHECK ADD  CONSTRAINT [FK_WF_PurchasesRequestDetails_INV_Items] FOREIGN KEY([ItemCode])
REFERENCES [dbo].[INV_Items] ([ItemCode])
GO

ALTER TABLE [dbo].[WF_PurchasesRequestDetails] CHECK CONSTRAINT [FK_WF_PurchasesRequestDetails_INV_Items]
GO

ALTER TABLE [dbo].[WF_PurchasesRequestDetails]  WITH CHECK ADD  CONSTRAINT [FK_WF_PurchasesRequestDetails_WF_PurchasesRequest] FOREIGN KEY([PurchasesRequestCode])
REFERENCES [dbo].[WF_PurchasesRequest] ([PurchasesRequestCode])
GO

ALTER TABLE [dbo].[WF_PurchasesRequestDetails] CHECK CONSTRAINT [FK_WF_PurchasesRequestDetails_WF_PurchasesRequest]
GO

CREATE TABLE [dbo].[WF_PurchasesRequestSignature](
	[PurchasesRequestSignatureCode] [int] IDENTITY(1,1) NOT NULL,
	[PurchasesRequestCode] [int] NULL,
	[UserCode] [int] NOT NULL,
	[StepNumber] [int] NOT NULL,
	[Approved] [tinyint] NOT NULL,
	[SignatureDate] [datetime] NULL,
	[SignatureTime] [nvarchar](10) NULL,
	[SignatureComment] [nvarchar](255) NULL,
	[Turn] [int] NULL,
	[SignatureDateHijri] [nvarchar](10) NULL,
	[OldUserCode] [int] NULL,
	[ChangedBy] [int] NULL,
	[ChangeDate] [datetime] NULL,
 CONSTRAINT [PK_WF_PurchasesRequestSignature] PRIMARY KEY CLUSTERED 
(
	[PurchasesRequestSignatureCode] 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_PurchasesRequestSignature]  WITH CHECK ADD  CONSTRAINT [FK_WF_PurchasesRequestSignature_SecurityUser] FOREIGN KEY([UserCode])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_PurchasesRequestSignature] CHECK CONSTRAINT [FK_WF_PurchasesRequestSignature_SecurityUser]
GO

ALTER TABLE [dbo].[WF_PurchasesRequestSignature]  WITH CHECK ADD  CONSTRAINT [FK_WF_PurchasesRequestSignature_WF_PurchasesRequest] FOREIGN KEY([PurchasesRequestCode])
REFERENCES [dbo].[WF_PurchasesRequest] ([PurchasesRequestCode])
GO

ALTER TABLE [dbo].[WF_PurchasesRequestSignature] CHECK CONSTRAINT [FK_WF_PurchasesRequestSignature_WF_PurchasesRequest]
GO

ALTER TABLE [dbo].[WF_PurchasesRequestSignature]  WITH CHECK ADD  CONSTRAINT [FK_WF_PurchasesRequestSignature_WF_RequestStatus] FOREIGN KEY([Approved])
REFERENCES [dbo].[WF_RequestStatus] ([RequestStatusId])
GO

ALTER TABLE [dbo].[WF_PurchasesRequestSignature] CHECK CONSTRAINT [FK_WF_PurchasesRequestSignature_WF_RequestStatus]
GO

CREATE TABLE [dbo].[WF_RequisitionFormRequest](
	[RequisitionFormRequestCode] [int] IDENTITY(1,1) NOT NULL,
	[RequestDate] [datetime] NOT NULL,
	[RequestDateHijri] [nvarchar](10) NOT NULL,
	[RequestContent] [nvarchar](250) NULL,
	[TrackCode] [int] NOT NULL,
	[DepartmentApproval] [tinyint] NOT NULL,
	[CancelRequestNumber] [int] NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[CreationDateHijri] [nvarchar](10) NOT NULL,
	[Canceled] [bit] NOT NULL,
	[MainType] [tinyint] NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
	[ModificationDateHijri] [nvarchar](10) NULL,
	[StoreCode] [int] NOT NULL,
	[CustomerCode] [int] NULL,
 CONSTRAINT [PK_WF_RequisitionFormRequest] PRIMARY KEY CLUSTERED 
(
	[RequisitionFormRequestCode] 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_RequisitionFormRequest] ADD  CONSTRAINT [DF_WF_RequisitionFormRequest_Canceled]  DEFAULT ((0)) FOR [Canceled]
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequest] ADD  CONSTRAINT [DF_WF_RequisitionFormRequest_MainType]  DEFAULT ((0)) FOR [MainType]
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_RequisitionFormRequest_INV_Stores] FOREIGN KEY([StoreCode])
REFERENCES [dbo].[INV_Stores] ([StoreCode])
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequest] CHECK CONSTRAINT [FK_WF_RequisitionFormRequest_INV_Stores]
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_RequisitionFormRequest_SecurityUser] FOREIGN KEY([ModifiedBy])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequest] CHECK CONSTRAINT [FK_WF_RequisitionFormRequest_SecurityUser]
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_RequisitionFormRequest_SecurityUser1] FOREIGN KEY([CreatedBy])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequest] CHECK CONSTRAINT [FK_WF_RequisitionFormRequest_SecurityUser1]
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_RequisitionFormRequest_WF_Customer] FOREIGN KEY([CustomerCode])
REFERENCES [dbo].[WF_Customer] ([CustomerCode])
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequest] CHECK CONSTRAINT [FK_WF_RequisitionFormRequest_WF_Customer]
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_RequisitionFormRequest_WF_RequestStatus] FOREIGN KEY([DepartmentApproval])
REFERENCES [dbo].[WF_RequestStatus] ([RequestStatusId])
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequest] CHECK CONSTRAINT [FK_WF_RequisitionFormRequest_WF_RequestStatus]
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_RequisitionFormRequest_WF_Track] FOREIGN KEY([TrackCode])
REFERENCES [dbo].[WF_Track] ([TrackId])
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequest] CHECK CONSTRAINT [FK_WF_RequisitionFormRequest_WF_Track]
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequest] CHECK CONSTRAINT [FK_WF_RequisitionFormRequest_WF_Vendor]
GO

CREATE TABLE [dbo].[WF_RequisitionFormRequestDetails](
	[RequisitionFormRequestDetailsCode] [int] IDENTITY(1,1) NOT NULL,
	[RequisitionFormRequestCode] [int] NOT NULL,
	[ItemCode] [int] NOT NULL,
	[Quantity] [float] NOT NULL,
	[AverageCost] [float] NOT NULL,
 CONSTRAINT [PK_WF_RequisitionFormRequestDetails] PRIMARY KEY CLUSTERED 
(
	[RequisitionFormRequestDetailsCode] 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_RequisitionFormRequestDetails]  WITH CHECK ADD  CONSTRAINT [FK_WF_RequisitionFormRequestDetails_INV_Items] FOREIGN KEY([ItemCode])
REFERENCES [dbo].[INV_Items] ([ItemCode])
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequestDetails] CHECK CONSTRAINT [FK_WF_RequisitionFormRequestDetails_INV_Items]
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequestDetails]  WITH CHECK ADD  CONSTRAINT [FK_WF_RequisitionFormRequestDetails_WF_RequisitionFormRequest] FOREIGN KEY([RequisitionFormRequestCode])
REFERENCES [dbo].[WF_RequisitionFormRequest] ([RequisitionFormRequestCode])
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequestDetails] CHECK CONSTRAINT [FK_WF_RequisitionFormRequestDetails_WF_RequisitionFormRequest]
GO

CREATE TABLE [dbo].[WF_RequisitionFormRequestSignature](
	[RequisitionFormRequestSignatureCode] [int] IDENTITY(1,1) NOT NULL,
	[RequisitionFormRequestCode] [int] NULL,
	[UserCode] [int] NOT NULL,
	[StepNumber] [int] NOT NULL,
	[Approved] [tinyint] NOT NULL,
	[SignatureDate] [datetime] NULL,
	[SignatureTime] [nvarchar](10) NULL,
	[SignatureComment] [nvarchar](255) NULL,
	[Turn] [int] NULL,
	[SignatureDateHijri] [nvarchar](10) NULL,
	[OldUserCode] [int] NULL,
	[ChangedBy] [int] NULL,
	[ChangeDate] [datetime] NULL,
 CONSTRAINT [PK_WF_RequisitionFormRequestSignature] PRIMARY KEY CLUSTERED 
(
	[RequisitionFormRequestSignatureCode] 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_RequisitionFormRequestSignature]  WITH CHECK ADD  CONSTRAINT [FK_WF_RequisitionFormRequestSignature_SecurityUser] FOREIGN KEY([UserCode])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequestSignature] CHECK CONSTRAINT [FK_WF_RequisitionFormRequestSignature_SecurityUser]
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequestSignature]  WITH CHECK ADD  CONSTRAINT [FK_WF_RequisitionFormRequestSignature_WF_RequisitionFormRequest] FOREIGN KEY([RequisitionFormRequestCode])
REFERENCES [dbo].[WF_RequisitionFormRequest] ([RequisitionFormRequestCode])
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequestSignature] CHECK CONSTRAINT [FK_WF_RequisitionFormRequestSignature_WF_RequisitionFormRequest]
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequestSignature]  WITH CHECK ADD  CONSTRAINT [FK_WF_RequisitionFormRequestSignature_WF_RequestStatus] FOREIGN KEY([Approved])
REFERENCES [dbo].[WF_RequestStatus] ([RequestStatusId])
GO

ALTER TABLE [dbo].[WF_RequisitionFormRequestSignature] CHECK CONSTRAINT [FK_WF_RequisitionFormRequestSignature_WF_RequestStatus]
GO

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (226, N'Purchases Request', N'طلب شراء',29, N'/WorkFlow/PurchasesRequest', N'Index', NULL, N'get',35,1,1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (227, N'Purchases Request Signature', N'اعتماد طلب شراء',108, N'/WorkFlow/PurchasesRequestSignature', N'Index', NULL, N'get',38,1,1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (330, N'Requisition Form Request', N'طلب صرف',29, N'/WorkFlow/RequisitionFormRequest', N'Index', NULL, N'get',36,1,1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (331, N'Requisition Form Request Signature', N'اعتماد طلب صرف',108, N'/WorkFlow/RequisitionFormRequestSignature', N'Index', NULL, N'get',39,1,1)
GO
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES (226, 1)
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES (227, 1)
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES (330, 1)
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES (331, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3409, N'طلب شراء', N'Purchases Request',226, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3410, N'عرض طلب شراء', N'View Purchases Request',226, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3411, N'إضافة طلب شراء', N'Add Purchases Request',226, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3412, N'تعديل طلب شراء', N'Edit Purchases Request',226, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3413, N'حذف طلب شراء', N'Delete Purchases Request',226, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3414, N'حفظ طلب شراء', N'Save Purchases Request',226, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3415, N'إلغاء طلب  شراء', N'Cancel Purchases Request',226, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3416, N'اعتماد طلب شراء', N'Purchases Request Signature',227, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3417, N'عرض اعتماد طلب شراء', N'View Purchases Request Signature',227, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3418, N'تعديل اعتماد طلب شراء', N'Edit Purchases Request Signature',227, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3419, N'حفظ اعتماد طلب شراء', N'Save Purchases Request Signature',227, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3420, N'حفظ متعدد طلب شراء', N'Save Multiple Purchases Request Signature',227, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3421, N'طلب صرف', N'Requisition Form Request',330, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3422, N'عرض طلب صرف', N'View Requisition Form Request',330, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3423, N'إضافة طلب صرف', N'Add Requisition Form Request',330, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3424, N'تعديل طلب صرف', N'Edit Requisition Form Request',330, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3425, N'حذف طلب صرف', N'Delete Requisition Form Request',330, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3426, N'حفظ طلب صرف', N'Save Requisition Form Request',330, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3427, N'إلغاء طلب  صرف', N'Cancel Requisition Form Request',330, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3428, N'اعتماد طلب صرف', N'Requisition Form Request Signature',331, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3429, N'عرض اعتماد طلب صرف', N'View Requisition Form Request Signature',331, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3430, N'تعديل اعتماد طلب صرف', N'Edit Requisition Form Request Signature',331, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3431, N'حفظ اعتماد طلب صرف', N'Save Requisition Form Request Signature',331, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3432, N'حفظ متعدد طلب صرف', N'Save Multiple Requisition Form Request Signature',331, 2)
GO
INSERT [dbo].[WF_RequestType] ([RequestTypeId],[RequestTypeName],[RequestTypeNameEn],[IsEditable],[SenderUserName],[SenderFrom],[SenderPassword],[SenderHostName],[SenderPort],[SenderName],[SubmitBeforRequestDate],[SubmitAfterRequestDate]) VALUES (23, N'طلب شراء', N'Purchases Request',0, N'sayedmustafa1984@gmail.com', N'sayedmustafa1984@gmail.com', N'123', N'smtp.sendgrid.net',587, N'Sayed',2,3)
INSERT [dbo].[WF_RequestType] ([RequestTypeId],[RequestTypeName],[RequestTypeNameEn],[IsEditable],[SenderUserName],[SenderFrom],[SenderPassword],[SenderHostName],[SenderPort],[SenderName],[SubmitBeforRequestDate],[SubmitAfterRequestDate]) VALUES (24, N'طلب صرف', N'Requisition Form Request',0, N'sayedmustafa1984@gmail.com', N'sayedmustafa1984@gmail.com', N'123', N'smtp.sendgrid.net',587, N'Sayed',2,3)
GO
SET IDENTITY_INSERT dbo.[EmailTemplateType] ON; 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (134, N'Purchases Request Sending', N'إرسال طلب شراء ',0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (135, N'Purchases Request Accept', N'الموافقة على طلب شراء ',0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (136, N'Purchases Request Refuse', N'رفض طلب شراء ',0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (137, N'Purchases Request Cancellation', N'إلغاء طلب شراء',0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (138, N'Requisition Form Request Sending', N'إرسال طلب صرف ',0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (139, N'Requisition Form Request Accept', N'الموافقة على طلب صرف ',0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (140, N'Requisition Form Request Refuse', N'رفض طلب صرف ',0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (141, N'Requisition Form Request Cancellation', N'إلغاء طلب صرف',0, 1)
SET IDENTITY_INSERT dbo.[EmailTemplateType] OFF; 
SET IDENTITY_INSERT dbo.[EmailTemplate] ON; 
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [Subject], [Body],[EmailTemplateTypeCode],[IsDefault],[SubjectAppendCode]) VALUES (134, N'Purchases Request Sending', N'إرسال طلب شراء', N'طلب شراء', N'<p>نرجو الموافقة على طلب الشراء</p>',134, 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [Subject], [Body],[EmailTemplateTypeCode],[IsDefault],[SubjectAppendCode]) VALUES (135, N'Purchases Request Accept', N'الموافقة على طلب شراء', N'اعتماد طلب شراء', N'<p>تمت الموافقة</p>',135, 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [Subject], [Body],[EmailTemplateTypeCode],[IsDefault],[SubjectAppendCode]) VALUES (136, N'Purchases Request Refuse', N'رفض طلب شراء', N'رفض طلب شراء', N'تم رفض الطلب',136, 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [Subject], [Body],[EmailTemplateTypeCode],[IsDefault],[SubjectAppendCode]) VALUES (137, N'Purchases Request Cancellation', N'إلغاء طلب شراء', N'إلغاء طلب شراء', N'<p>تم إلغاء طلب الشراء</p>',137, 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [Subject], [Body],[EmailTemplateTypeCode],[IsDefault],[SubjectAppendCode]) VALUES (138, N'Requisition Form Request Sending', N'إرسال طلب صرف', N'طلب صرف', N'<p>نرجو الموافقة على طلب الصرف</p>',138, 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [Subject], [Body],[EmailTemplateTypeCode],[IsDefault],[SubjectAppendCode]) VALUES (139, N'Requisition Form Request Accept', N'الموافقة على طلب صرف', N'اعتماد طلب صرف', N'<p>تمت الموافقة</p>',139, 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [Subject], [Body],[EmailTemplateTypeCode],[IsDefault],[SubjectAppendCode]) VALUES (140, N'Requisition Form Request Refuse', N'رفض طلب صرف', N'رفض طلب صرف', N'تم رفض الطلب',140, 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [Subject], [Body],[EmailTemplateTypeCode],[IsDefault],[SubjectAppendCode]) VALUES (141, N'Requisition Form Request Cancellation', N'إلغاء طلب صرف', N'إلغاء طلب صرف', N'<p>تم إلغاء طلب الصرف</p>',141, 1, NULL)
SET IDENTITY_INSERT dbo.[EmailTemplate] OFF; 
GO
  --------------------------------------End 2019-09-10---------------------------
  --------------------------------------Hammad 2019-09-10---------------------------

  INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
 VALUES (10048, N'إظهار كل الموظفين للاحتساب', N'View All Employee For Calculate', 192, 2)
 Go
 INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WFNewHireShowAllTrack', N'NewHire Show All Track', N'عرض كل المسارات', N'false', 2, 7, 1, 1, NULL, NULL, 5)
 Go
 update [dbo].[SecurityPrivilege] set  [DescriptionAR]=N'إظهار كل الموظفين للاحتساب', [DescriptionEN]=N'View All Employee For Calculate' where ID=10048
   --------------------------------------End 2019-09-10---------------------------

     --------------------------------------Ali 2019-09-12---------------------------

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'WFLoanRequestDay', N'Loan Request Day', N'يوم طلب السلفة', N'15', 2, 5, 2, 1, NULL, NULL, 9)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'WFSelectLoanRequestDay', N'Select Loan Request Day', N'تحديد يوم طلب السلفة', N'false', 2, 4, 1, 1, NULL, NULL, 9)
Go
   --------------------------------------End 2019-09-12---------------------------

--------------------------------------Ali 2019-09-15---------------------------
   INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'WFVacationMissionNumber', N'Vacation Mission Number', N'رقم اجازة المامورية', N'20', 2, 34, 2, 1, NULL, NULL, 11)
    Go 
	 --------------------------------------End 2019-09-15---------------------------
 --------------------------------------A.Khaled 2019-09-15---------------------------
 INSERT INTO [dbo].[WF_RequestStatus] (RequestStatusId,RequestStatusName,RequestStatusNameEn) VALUES (3,N'ارجاع',N'Inverse')
 Go
 ALTER TABLE [dbo].[WF_PurchasesRequestSignature] ADD [SignatureCommentInverse] [nvarchar](255) NULL
 Go
 --------------------------------------End 2019-09-15--------------------------- 
 --------------------------------------A.Khaled 2019-09-16---------------------------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3433, N'ارجاع طلب  شراء', N'Inverse Purchases Request',227, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3434, N'ارجاع طلب  صرف', N'Inverse Requisition Form Request',331, 2)
Go
ALTER TABLE [dbo].[WF_RequisitionFormRequestSignature] ADD [SignatureCommentInverse] [nvarchar](255) NULL
GO
 --------------------------------------End 2019-09-16--------------------------- 
 --------------------------------------Ali 2019-09-16---------------------------
   UPDATE [ConfigParameter]
SET [Name] = 'Loan request starting day', [Arabic_Name]= N'يوم ابتداء طلب السلفة'
WHERE [ConfigKey] = 'WFSelectLoanRequestDay';
Go
 --------------------------------------End 2019-09-16--------------------------- 
 --------------------------------------Hammad 2019-09-17------------------------ 
 ALTER TABLE dbo.WF_VacationRequestSignature ADD
	UserTypeCode int NULL
GO

ALTER TABLE dbo.WF_ResignationRequestSignature ADD
	UserTypeCode int NULL
GO

ALTER TABLE dbo.WF_LoanRequestSignature ADD
	UserTypeCode int NULL
GO

ALTER TABLE dbo.WF_PromotionRequestSignature ADD
	UserTypeCode int NULL
GO

ALTER TABLE dbo.WF_OverTimeRequestSignature ADD
	UserTypeCode int NULL
GO


ALTER TABLE dbo.WF_OverTimeSymphonyRequestSignature ADD
	UserTypeCode int NULL
GO


ALTER TABLE dbo.WF_PermissionRequestSignature ADD
	UserTypeCode int NULL
GO

ALTER TABLE dbo.WF_PenaltyRequestSignature ADD
	UserTypeCode int NULL
GO

delete ConfigParameter where ConfigKey='WFVacationMissionNo'
GO

 --------------------------------------End 2019-09-17------------------------ 
 --------------------------------------Ali 2019-09-17------------------------ 
 
 ALTER TABLE dbo.WF_FingerPrintRequestSignature ADD
	UserTypeCode int NULL
GO

 ALTER TABLE dbo.WF_GeneralRequestSignature ADD
	UserTypeCode int NULL
GO

ALTER TABLE dbo.WF_MaintenanceRequestSignature ADD
	UserTypeCode int NULL
GO

ALTER TABLE dbo.WF_AirTicketRequestSignature ADD
	UserTypeCode int NULL
GO


ALTER TABLE dbo.WF_BonusRequestSignature ADD
	UserTypeCode int NULL
GO

ALTER TABLE dbo.WF_CasualRequestSignature ADD
	UserTypeCode int NULL
GO
ALTER TABLE dbo.WF_NewEmployeesRequestSignature ADD
	UserTypeCode int NULL
GO

ALTER TABLE dbo.WF_NewHireRequestSignature ADD
	UserTypeCode int NULL
GO

ALTER TABLE dbo.WF_ChangeDayoffRequestSignature ADD
	UserTypeCode int NULL
GO

ALTER TABLE dbo.WF_PurchasesRequestSignature ADD
	UserTypeCode int NULL
GO

ALTER TABLE dbo.WF_RequisitionFormRequestSignature ADD
	UserTypeCode int NULL
GO



ALTER TABLE dbo.WF_VehicleRequestSignature ADD
	UserTypeCode int NULL
GO

ALTER TABLE dbo.WF_CompensationRequestForADayOfRestSignature ADD
	UserTypeCode int NULL
GO

 --------------------------------------End 2019-09-17------------------------ 
 --------------------------------------Hammad 2019-09-19------------------------ 
 ALTER TABLE dbo.SecurityUserAuthority ADD
	IsDefault bit NOT NULL CONSTRAINT DF_SecurityUserAuthority_isDefault DEFAULT 1
GO
 --------------------------------------End 2019-09-19------------------------ 
 --------------------------------------Ali 2019-09-19------------------------ 

   Update dbo.ConfigParameter set ConfigType=3 where ConfigKey in('WFMaxOverTimeHoursCount','WFMinOverTimeHoursCount') 
  Go

    ALTER TABLE dbo.WF_OvertimeType ADD
	TypeOfLaw tinyint NULL
GO

    UPDATE [SystemMenu]
SET [ShowInPrivilegePage] = 0
  where SystemMenuCode=99
  Go

    delete from [SecurityGroupDetail] where [PrivilegeID] in (3170,3171,3172,3173,3174,3175)
	Go

	delete from [SecurityUserDetail] where [ID]in(18158,18159,18160,18161,18162,18163)
	Go

	SET IDENTITY_INSERT [dbo].[SecurityGroupDetail] ON 
	INSERT [dbo].[SecurityGroupDetail] ([ID], [SecurityGroupID], [PrivilegeID]) VALUES (25905, 1, 3170)
INSERT [dbo].[SecurityGroupDetail] ([ID], [SecurityGroupID], [PrivilegeID]) VALUES (25906, 1, 3171)
INSERT [dbo].[SecurityGroupDetail] ([ID], [SecurityGroupID], [PrivilegeID]) VALUES (25907, 1, 3172)
INSERT [dbo].[SecurityGroupDetail] ([ID], [SecurityGroupID], [PrivilegeID]) VALUES (25908, 1, 3173)
INSERT [dbo].[SecurityGroupDetail] ([ID], [SecurityGroupID], [PrivilegeID]) VALUES (25909, 1, 3174)
INSERT [dbo].[SecurityGroupDetail] ([ID], [SecurityGroupID], [PrivilegeID]) VALUES (25910, 1, 3175)

SET IDENTITY_INSERT [dbo].[SecurityGroupDetail] OFF
Go

SET IDENTITY_INSERT [dbo].[SecurityUserDetail] ON 

	INSERT [dbo].[SecurityUserDetail] ([ID], [SecurityUserID], [PrivilegeID]) VALUES (21346, 1, 3170)
INSERT [dbo].[SecurityUserDetail] ([ID], [SecurityUserID], [PrivilegeID]) VALUES (21347, 1, 3171)
INSERT [dbo].[SecurityUserDetail] ([ID], [SecurityUserID], [PrivilegeID]) VALUES (21571, 1, 3172)
INSERT [dbo].[SecurityUserDetail] ([ID], [SecurityUserID], [PrivilegeID]) VALUES (21348, 1, 3173)
INSERT [dbo].[SecurityUserDetail] ([ID], [SecurityUserID], [PrivilegeID]) VALUES (21349, 1, 3174)
INSERT [dbo].[SecurityUserDetail] ([ID], [SecurityUserID], [PrivilegeID]) VALUES (21350, 1, 3175)
SET IDENTITY_INSERT [dbo].[SecurityUserDetail] OFF
Go
 --------------------------------------End 2019-09-19------------------------ 
 --------------------------------------Hammad 2019-09-19---------------------
 ALTER TABLE dbo.WF_VacationRequestSignature ADD
	SignatureCommentInverse nvarchar(255) NULL
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
 VALUES (3435, N'  ارجاع لطلب الاجازات المجمعة', N' Inverse Combined Vacations Request Signature', 92, 2)
GO
 --------------------------------------End 2019-09-19---------------------
 --------------------------------------Ali 2019-09-24---------------------
 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (332, N'Lastest Sql Updates', N'تحديثات قاعدة البيانات', 208, N'LastestSqlUpdate', N'Index', NULL, N'get', 4, 1, 0)
 GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (4470, 332, 6)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1173, N'تحديثات قاعدة البيانات', N'Lastest Sql Updates', 332, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1174, N' عرض تحديثات قاعدة البيانات', N'View Lastest Sql Updates', 332, 2)
GO

INSERT [dbo].[SecurityUserDetail] ( [SecurityUserID], [PrivilegeID]) VALUES ( 1, 1173)
INSERT [dbo].[SecurityUserDetail] ( [SecurityUserID], [PrivilegeID]) VALUES ( 1, 1174)
GO
 --------------------------------------End 2019-09-24---------------------
 --------------------------------------Hammadf 2019-09-25-----------------
 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES (7037, N'عرض إجمالى راتب تكلفة الموظفين', N'View Employees Cost Distribution Total Salary', 107, 2)
 --------------------------------------Hammadf 2019-09-25-----------------
  --------------------------------------A.Khaled 2019-09-28---------------------------
UPDATE [Budget].[BudgetItems] SET [SaveStatus]=20 WHERE [SaveStatus]=1
UPDATE [Budget].[BudgetItems] SET [SaveStatus]=30 WHERE [SaveStatus]=2
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12040, N'نسخ الموازنة', N'Copy Budget', 204, 2)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (145, N'Budget', N'BudgetHead', N'CopyBudgetHead', 0, N'post', 12040)
Go
 --------------------------------------End 2019-09-28--------------------------- 
   --------------------------------------A.Khaled 2019-09-30---------------------------
UPDATE [dbo].[SecurityPrivilege] SET DescriptionAR=N'اعداد عناصر الموازنة', DescriptionEN='Configure Budget Items' WHERE ID=12022
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12041, N'احتساب عناصر الموازنة', N'Calculate Budget Items', 205, 2)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (146, N'Budget', N'BudgetItem', N'CalculateBudgetItem', 0, N'post', 12041)
Go
 --------------------------------------End 2019-09-30--------------------------- 
    --------------------------------------Ali 2019-10-1---------------------------
 INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'WFCanEditTravelDirection', N'Can Edit Travel Direction ', N'امكانية تعديل اتجاه رحلة الذهاب', N'true', 2, 2, 1, 1, NULL, NULL, 4)
 Go
  --------------------------------------End 2019-10-1--------------------------- 
  --------------------------------------Hammad 2019-10-03--------------------------- 

  INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES (230, N'Budget Item Category', N'فئة بند الموازنة   ', 203, N'/Budget/BudgetItemCategory', N'Index', NULL, N'get', 4, 1, 1)
 Go
 
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12042, N'فئة بند الموازنة', N'Budget Item Category', 230, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12043, N'عرض فئة بند الموازنة', N'View Budget Item Category', 230, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12044, N'اضافة فئة بند الموازنة', N'Add Budget Item Category', 230, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12045, N'تعديل فئة بند الموازنة', N'Edit Budget Item Category', 230, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12046, N'حفظ فئة بند الموازنة', N'Save Budget Item Category', 230, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12047, N'حذف فئة بند الموازنة', N'Delete Budget Item Category', 230, 2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (146, N'Budget', N'BudgetItem', N'CalculateBudgetItem', 0, N'post', 12041)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (147, N'Budget', N'BudgetItemCategory', N'Index', 0, N'get', 12042)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (148, N'Budget', N'BudgetItemCategory', N'BudgetItemCategory_Read', 0, N'post', 12043)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (149, N'Budget', N'BudgetItemCategory', N'Save', 1, N'get', 12044)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (150, N'Budget', N'BudgetItemCategory', N'Save', 2, N'get', 12045)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (151, N'Budget', N'BudgetItemCategory', N'Save', 0, N'post', 12046)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (152, N'Budget', N'BudgetItemCategory', N'Delete', 0, N'post', 12047)
Go

INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES (230, 6)
Go

  --------------------------------------End 2019-10-03--------------------------- 
--------------------------------------A.Khaled 2019-10-07---------------------------
DROP VIEW [Budget].[PreDashboardActual]
Go
CREATE VIEW [Budget].[PreDashboardActualCost]
AS
SELECT BI.BudgetHeadCode, BAC.BudgetItemCode, BI.Arabic_Name, BI.Name, BAC.BudgetActualCostCode, BAC.CostYear, BAC.CostMonth, BAC.Amount, BI.SaveStatus FROM [Budget].[BudgetHeads] BH 
  INNER JOIN [Budget].[BudgetItems] BI ON BI.BudgetHeadCode=BH.BudgetHeadCode AND BI.CompareType=1 -- CompareTypeActualCost
  LEFT JOIN [Budget].[BudgetActualCosts] BAC ON BI.BudgetItemCode=BAC.BudgetItemCode
GO
--------------------------------------End 2019-10-07--------------------------- 
--------------------------------------A.Khaled 2019-10-15---------------------------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12048, N'المقارنة بالراتب الفعلي', N'Compare with Actual Salary', 216, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12049, N'المقارنة بالراتب المعياري', N'Compare with Standard Salary', 216, 2)
GO
--------------------------------------End 2019-10-15--------------------------- 
--------------------------------------Sayed 2019-10-15-------------------------
DELETE FROM [dbo].[SecurityPrivilegeActions]
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1, N'Recruitment', N'CompanySize', N'Index', 0, N'get', 5023)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2, N'Recruitment', N'CompanySize', N'CompanySize_Read', 0, N'post', 5024)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (3, N'Recruitment', N'CompanySize', N'Save', 1, N'get', 5025)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (4, N'Recruitment', N'CompanySize', N'Save', 2, N'get', 5026)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (5, N'Recruitment', N'CompanySize', N'Delete', 0, N'post', 5027)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (6, N'Recruitment', N'CompanySize', N'Save', 0, N'post', 5028)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (7, N'Recruitment', N'JobCategory', N'Index', 0, N'get', 5002)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (8, N'Recruitment', N'JobCategory', N'JobCategory_Read', 0, N'post', 5003)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (9, N'Recruitment', N'JobCategory', N'Save', 1, N'get', 5004)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (10, N'Recruitment', N'JobCategory', N'Save', 2, N'get', 5005)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (11, N'Recruitment', N'JobCategory', N'Delete', 0, N'post', 5006)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (12, N'Recruitment', N'JobCategory', N'Save', 0, N'post', 5007)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (13, N'Recruitment', N'VisaStatus', N'Index', 0, N'get', 5011)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (14, N'Recruitment', N'VisaStatus', N'VisaStatus_Read', 0, N'post', 5012)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (15, N'Recruitment', N'VisaStatus', N'Save', 1, N'get', 5013)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (16, N'Recruitment', N'VisaStatus', N'Save', 2, N'get', 5014)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (17, N'Recruitment', N'VisaStatus', N'Delete', 0, N'post', 5015)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (18, N'Recruitment', N'VisaStatus', N'Save', 0, N'post', 5016)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (19, N'Recruitment', N'CompanyDomain', N'Index', 0, N'get', 5017)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (20, N'Recruitment', N'CompanyDomain', N'CompanyDomain_Read', 0, N'post', 5018)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (21, N'Recruitment', N'CompanyDomain', N'Save', 1, N'get', 5019)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (22, N'Recruitment', N'CompanyDomain', N'Save', 2, N'get', 5020)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (23, N'Recruitment', N'CompanyDomain', N'Delete', 0, N'post', 5021)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (24, N'Recruitment', N'CompanyDomain', N'Save', 0, N'post', 5022)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (25, N'Recruitment', N'WorkSite', N'Index', 0, N'get', 5029)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (26, N'Recruitment', N'WorkSite', N'WorkSite_Read', 0, N'post', 5030)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (27, N'Recruitment', N'WorkSite', N'Save', 1, N'get', 5031)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (28, N'Recruitment', N'WorkSite', N'Save', 2, N'get', 5032)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (29, N'Recruitment', N'WorkSite', N'Delete', 0, N'post', 5033)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (30, N'Recruitment', N'WorkSite', N'Save', 0, N'post', 5034)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (31, N'Recruitment', N'QuestionTemplate', N'Index', 0, N'get', 5035)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (32, N'Recruitment', N'QuestionTemplate', N'QuestionTemplate_Read', 0, N'post', 5036)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (33, N'Recruitment', N'QuestionTemplate', N'SaveQuestion', 1, N'get', 5037)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (34, N'Recruitment', N'QuestionTemplate', N'SaveQuestion', 2, N'get', 5038)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (35, N'Recruitment', N'QuestionTemplate', N'Delete', 0, N'post', 5039)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (36, N'Recruitment', N'QuestionTemplate', N'SaveOpenQuestion', 0, N'post', 5040)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (37, N'Recruitment', N'QuestionTemplate', N'SaveClosedQuestion', 0, N'post', 5040)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (38, N'Recruitment', N'QuestionTemplate', N'SaveNumRangeQuestion', 0, N'post', 5040)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (39, N'Recruitment', N'QuestionTemplate', N'SaveDateRangeQuestion', 0, N'post', 5040)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (40, N'Recruitment', N'QuestionTemplate', N'SaveMultiChoiceQuestion', 0, N'post', 5040)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (41, N'Recruitment', N'JobApplySteps', N'Index', 0, N'get', 5057)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (42, N'Recruitment', N'JobApplySteps', N'InterviewStages_Read', 0, N'post', 5058)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (43, N'Recruitment', N'JobApplySteps', N'Save', 0, N'post', 5059)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (44, N'Recruitment', N'JobApplySteps', N'Save', 1, N'get', 5060)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (45, N'Recruitment', N'JobApplySteps', N'Save', 2, N'get', 5061)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (46, N'Recruitment', N'JobApplySteps', N'Delete', 0, N'post', 5062)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (47, N'Recruitment', N'JobOfferParameter', N'Index', 0, N'get', 5080)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (48, N'Recruitment', N'JobOfferParameter', N'JobOfferParameter_Read', 0, N'post', 5081)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (49, N'Recruitment', N'JobOfferParameter', N'Save', 1, N'get', 5082)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (50, N'Recruitment', N'JobOfferParameter', N'Save', 2, N'get', 5083)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (51, N'Recruitment', N'JobOfferParameter', N'Save', 0, N'post', 5084)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (52, N'Recruitment', N'JobOfferParameter', N'Delete', 0, N'post', 5085)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (53, N'Recruitment', N'JobRole', N'Index', 0, N'get', 5087)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (54, N'Recruitment', N'JobRole', N'JobRole_Read', 0, N'post', 5088)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (55, N'Recruitment', N'JobRole', N'Save', 1, N'get', 5089)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (56, N'Recruitment', N'JobRole', N'Save', 2, N'get', 5090)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (57, N'Recruitment', N'JobRole', N'Save', 0, N'post', 5091)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (58, N'Recruitment', N'JobRole', N'Delete', 0, N'post', 5092)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (59, N'Recruitment', N'JobType', N'Index', 0, N'get', 5093)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (60, N'Recruitment', N'JobType', N'JobType_Read', 0, N'post', 5094)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (61, N'Recruitment', N'JobType', N'Save', 1, N'get', 5095)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (62, N'Recruitment', N'JobType', N'Save', 2, N'get', 5096)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (63, N'Recruitment', N'JobType', N'Save', 0, N'post', 5097)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (64, N'Recruitment', N'JobType', N'Delete', 0, N'post', 5098)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (65, N'Recruitment', N'RejectHiring', N'Index', 0, N'get', 5101)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (66, N'Recruitment', N'RejectHiring', N'RejectHiring_Read', 0, N'post', 5102)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (67, N'Recruitment', N'RejectHiring', N'Save', 1, N'get', 5103)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (68, N'Recruitment', N'RejectHiring', N'Save', 2, N'get', 5104)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (69, N'Recruitment', N'RejectHiring', N'Delete', 0, N'post', 5105)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (70, N'Recruitment', N'RejectHiring', N'Save', 0, N'post', 5106)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (71, N'Recruitment', N'EvaluationParameter', N'Index', 0, N'get', 5107)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (72, N'Recruitment', N'EvaluationParameter', N'EvaluationParameter_Read', 0, N'post', 5108)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (73, N'Recruitment', N'EvaluationParameter', N'Save', 1, N'get', 5109)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (74, N'Recruitment', N'EvaluationParameter', N'Save', 2, N'get', 5110)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (75, N'Recruitment', N'EvaluationParameter', N'Save', 0, N'post', 5111)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (76, N'Recruitment', N'EvaluationParameter', N'Delete', 0, N'post', 5112)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (77, N'Recruitment', N'Job', N'Index', 0, N'get', 5008)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (78, N'Recruitment', N'Job', N'Job_Read', 0, N'post', 5009)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (79, N'Recruitment', N'Job', N'Edit', 0, N'get', 5010)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (80, N'Recruitment', N'Job', N'Edit', 0, N'post', 5117)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (81, N'Recruitment', N'RecruitJob', N'Index', 0, N'get', 5041)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (82, N'Recruitment', N'RecruitJob', N'RecruitJob_Read', 0, N'post', 5042)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (83, N'Recruitment', N'RecruitJob', N'Save', 1, N'get', 5043)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (84, N'Recruitment', N'RecruitJob', N'Save', 2, N'get', 5044)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (85, N'Recruitment', N'RecruitJob', N'Delete', 0, N'post', 5045)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (86, N'Recruitment', N'RecruitJob', N'Save', 0, N'post', 5046)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (87, N'Recruitment', N'RecruitJobCandidates', N'Index', 0, N'get', 5053)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (88, N'Recruitment', N'RecruitJobCandidates', N'Candidates_Read', 0, N'post', 5054)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (89, N'Recruitment', N'RecruitJobCandidates', N'Save', 0, N'post', 5056)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (90, N'Recruitment', N'RecruitJobCandidates', N'CandidateQuestionAnswer', 0, N'get', 5086)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (91, N'Recruitment', N'CandidateInvitation', N'Index', 0, N'get', 5063)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (92, N'Recruitment', N'CandidateInvitation', N'CandidateInvitation_Read', 0, N'post', 5064)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (93, N'Recruitment', N'CandidateInvitation', N'SendInvitation', 0, N'get', 5066)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (94, N'Recruitment', N'CandidateInvitation', N'SendInvitation', 0, N'post', 5066)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (95, N'Recruitment', N'CandidateInvitation', N'EmailInvitation', 0, N'get', 5066)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (96, N'Recruitment', N'InterviewResult', N'Index', 0, N'get', 5067)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (97, N'Recruitment', N'InterviewResult', N'InterviewResult_Read', 0, N'post', 5068)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (98, N'Recruitment', N'InterviewResult', N'InvitationResult', 0, N'get', 5070)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (99, N'Recruitment', N'InterviewResult', N'InvitationResult', 0, N'post', 5070)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (100, N'Recruitment', N'InterviewResult', N'InterviewDetails', 0, N'get', 5070)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (101, N'Recruitment', N'JobOffer', N'Index', 0, N'get', 5071)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (102, N'Recruitment', N'JobOffer', N'JobOffer_Read', 0, N'post', 5072)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (103, N'Recruitment', N'JobOffer', N'Save', 0, N'get', 5074)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (104, N'Recruitment', N'JobOffer', N'Save', 0, N'post', 5074)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (105, N'Recruitment', N'JobOffer', N'EmailInvitation', 0, N'get', 5074)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (106, N'Recruitment', N'HireCandidates', N'Index', 0, N'get', 5075)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (107, N'Recruitment', N'HireCandidates', N'HireCandidates_Read', 0, N'post', 5076)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (108, N'Recruitment', N'HireCandidates', N'OfferDetails', 0, N'get', 5078)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (109, N'Recruitment', N'HireCandidates', N'HireResult', 1, N'get', 5079)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (110, N'Recruitment', N'HireCandidates', N'HireResult', 0, N'post', 5044)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (111, N'Recruitment', N'RecruitEmployeeProfile', N'Index', 0, N'get', 5067)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (112, N'Recruitment', N'RecruitEmployeeProfile', N' RecruitEmployeeContact_Read', 0, N'post', 5068)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (113, N'Recruitment', N'RecruitEmployeeProfile', N'CandidateDetails', 0, N'get', 5069)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (114, N'Recruitment', N'CandidatesStatus', N'Index', 0, N'get', 5099)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (115, N'Recruitment', N'CandidatesStatus', N'CandidatesAppliedJobs_Read', 0, N'post', 5100)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (116, N'Recruitment', N'CandidatesStatus', N'QuestionAnswer', 0, N'get', 5086)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (117, N'Recruitment', N'CandidatesStatus', N'CandidateProfileDetails', 0, N'get', 5100)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (118, N'Budget', N'BudgetHead', N'Index', 0, N'get', 12011)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (119, N'Budget', N'BudgetHead', N'BudgetHead_Read', 0, N'post', 12012)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (120, N'Budget', N'BudgetHead', N'Save', 1, N'get', 12013)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (121, N'Budget', N'BudgetHead', N'Save', 2, N'get', 12014)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (122, N'Budget', N'BudgetHead', N'Save', 0, N'post', 12015)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (123, N'Budget', N'BudgetHead', N'Delete', 0, N'post', 12016)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (124, N'Budget', N'BudgetHead', N'OpenCloseBudget', 0, N'post', 12017)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (125, N'Budget', N'BudgetHead', N'CancelUnCancelBudget', 0, N'post', 12018)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (126, N'Budget', N'BudgetHead', N'AddBudgetSalaryDetails', 0, N'post', 12019)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (127, N'Budget', N'BudgetItem', N'Index', 0, N'get', 12020)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (128, N'Budget', N'BudgetItem', N'BudgetItem_Read', 0, N'post', 12021)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (129, N'Budget', N'BudgetItem', N'Save', 2, N'get', 12022)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (130, N'Budget', N'BudgetItem', N'Save', 0, N'post', 12023)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (131, N'Budget', N'BudgetItem', N'ManualEditBudgetItems', 0, N'get', 12024)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (132, N'Budget', N'BudgetItem', N'CloseBudgetItem', 0, N'post', 12025)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (133, N'Budget', N'BudgetItem', N'CancelBudgetItemCalculation', 0, N'post', 12026)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (134, N'Budget', N'BudgetItem', N'Index', 0, N'post', 12020)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (135, N'Budget', N'BudgetActualCost', N'Index', 0, N'get', 12027)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (136, N'Budget', N'BudgetActualCost', N'BudgetActualCost_Read', 0, N'post', 12028)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (137, N'Budget', N'BudgetActualCost', N'Save', 1, N'get', 12029)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (138, N'Budget', N'BudgetActualCost', N'Save', 2, N'get', 12030)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (139, N'Budget', N'BudgetActualCost', N'Save', 0, N'post', 12031)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (140, N'Budget', N'BudgetActualCost', N'Delete', 0, N'post', 12032)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (141, N'Budget', N'BudgetItem', N'OpenBudgetItem', 0, N'post', 12033)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (142, N'Budget', N'BudgetItem', N'Details', 0, N'get', 12037)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (143, N'Budget', N'DashBoard', N'GetBudgetCompareByItem', 0, N'post', 12035)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (144, N'Budget', N'DashBoard', N'GetBudgetCompareByMonth', 0, N'post', 12036)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (145, N'Budget', N'BudgetHead', N'CopyBudgetHead', 0, N'post', 12040)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (146, N'Budget', N'BudgetItem', N'CalculateBudgetItem', 0, N'post', 12041)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (147, N'Budget', N'BudgetItemCategory', N'Index', 0, N'get', 12042)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (148, N'Budget', N'BudgetItemCategory', N'BudgetItemCategory_Read', 0, N'post', 12043)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (149, N'Budget', N'BudgetItemCategory', N'Save', 1, N'get', 12044)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (150, N'Budget', N'BudgetItemCategory', N'Save', 2, N'get', 12045)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (151, N'Budget', N'BudgetItemCategory', N'Save', 0, N'post', 12046)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (152, N'Budget', N'BudgetItemCategory', N'Delete', 0, N'post', 12047)
GO

--------------------------------------End 2019-10-15---------------------------