﻿-------------------------Sayed 2019-02-24--------------------------------------------
alter table [dbo].[WF_PermissionRequest] 
add PartShiftNo tinyint
GO
CREATE TABLE [dbo].[WF_PartShift](
	[PartShiftCode] [tinyint] NOT NULL,
	[Name] [nvarchar](150) NULL,
	[Arabic_Name] [nvarchar](150) NULL,
 CONSTRAINT [PK_WF_PartShift] PRIMARY KEY CLUSTERED 
(
	[PartShiftCode] 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
INSERT [dbo].[WF_PartShift] ([PartShiftCode], [Name], [Arabic_Name]) VALUES (0, N'None', N'ÈÏæä ')
GO
INSERT [dbo].[WF_PartShift] ([PartShiftCode], [Name], [Arabic_Name]) VALUES (1, N'First Period Of Shift', N'ÇáÝÊÑÉ ÇáÇæáì ãä ÇáÏæÇã')
GO
INSERT [dbo].[WF_PartShift] ([PartShiftCode], [Name], [Arabic_Name]) VALUES (2, N'Second Period Of Shift', N'ÇáÝÊÑÉ ÇáËÇäíÉ ãä ÇáÏæÇã')
GO
INSERT [dbo].[WF_PartShift] ([PartShiftCode], [Name], [Arabic_Name]) VALUES (3, N'Third Period Of Shift', N'ÇáÝÊÑÉ ÇáËÇáËÉ ãä ÇáÏæÇã')
GO

-------------------------End 2019-02-24---------------------------------------------
-------------------------Hammad 2019-02-25---------------------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (182, N'Reports', N'ÇáÊÞÇÑíÑ', 163, NULL, NULL, N'fa fa-thumb-tack', NULL, 5, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (183, N'Total Salaries Of Departments', N'ÅÌãÇáí ÑæÇÊÈ ÇáÅÏÇÑÇÊ', 182, N'/ConsolidatedDashboard/TotalSalariesReport', N'Index', NULL, N'get', 1, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (184, N'Employees Contract Statistics', N'ÅÍÕÇÁÇÊ ÚÞæÏ ÇáãæÙÝíä', 182, N'/ConsolidatedDashboard/ContractEmployeeStatistics', N'Index', NULL, N'get', 2, 1, 1)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11019, N'ÇáÊÞÇÑíÑ', N'Reports', 182, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11020, N'ÅÌãÇáí ÑæÇÊÈ ÇáÅÏÇÑÇÊ', N'Total Salaries Of Departments ', 183, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11021, N'ÚÑÖ ÅÌãÇáí ÑæÇÊÈ ÇáÅÏÇÑÇÊ', N'View Total Salaries Of Departments', 183, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11022, N'ÅÍÕÇÁÇÊ ÚÞæÏ ÇáãæÙÝíä', N'Employees Contract Statistics', 184, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11023, N'ÚÑÖ ÅÍÕÇÁÇÊ ÚÞæÏ ÇáãæÙÝíä', N'View Employees Contract Statistics', 184, 2)
Go

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1280, 182, 9)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1281, 183, 9)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1282, 184, 9)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
-------------------------End 2019-02-25---------------------------------------------
-------------------------Hammad 2019-02-26---------------------------------------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (185, N'Hiring And Resignation Statistics', N'ÅÍÕÇÁÇÊ ÇáÊÚíäÇÊ æÇáÅÓÊÞÇáÇÊ', 182, N'/ConsolidatedDashboard/EmployeesStatusStatics', N'Index', NULL, N'get', 3, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11024, N'ÅÍÕÇÁÇÊ ÇáÊÚíäÇÊ æÇáÅÓÊÞÇáÇÊ', N'Hiring And Resignation Statistics', 185, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11025, N'ÚÑÖ ÅÍÕÇÁÇÊ ÇáÊÚíäÇÊ æÇáÅÓÊÞÇáÇÊ', N'View Hiring And Resignation Statistics', 185, 2)
Go

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1283, 185, 9)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (186, N'Monthly Cost Total Salaries', N'ÇáÊßáÝÉ ÇáÔåÑíÉ ááÑæÇÊÈ', 182, N'/ConsolidatedDashboard/MonthlyCostTotalSalaries', N'Index', NULL, N'get', 4, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11026, N'ÇáÊßáÝÉ ÇáÔåÑíÉ ááÑæÇÊÈ', N'Monthly Cost Total Salaries', 186, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11027, N'ÚÑÖ ÇáÊßáÝÉ ÇáÔåÑíÉ ááÑæÇÊÈ', N'View Monthly Cost Total Salaries', 186, 2)
Go

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1284, 186, 9)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF

-------------------------End 2019-02-26---------------------------------------------
-------------------------Hammad 2019-02-27---------------------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (187, N'TurnOver Statistics', N'ÅÍÕÇÆíÇÊ ÏæÑÉ ÇáÚãá', 182, N'/ConsolidatedDashboard/EmployeesTurnOverStatics', N'Index', NULL, N'get', 5, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11028, N'ÅÍÕÇÆíÇÊ ÏæÑÉ ÇáÚãá', N'TurnOver Statistics', 187, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11029, N'ÚÑÖ ÅÍÕÇÆíÇÊ ÏæÑÉ ÇáÚãá', N'View TurnOver Statistics', 187, 2)
Go

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1285, 187, 9)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF


ALTER TABLE dbo.ConfigParameter ADD
	RequestTypeId int  NULL 
GO

  INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate],RequestTypeId) 
    VALUES (N'WFHaveDisclaimer', N'View Have Disclaimer On Vacation', N'ÅÙåÇÑ ÅÎáÇÁ ØÑÝ Ýì ØáÈ ÇáÇÌÇÒÉ', N'false', 2, 33, 1, 0, NULL, NULL,NULL)
GO
-------------------------End 2019-02-27---------------------------------------------


-------------------------Hammad 2019-02-28---------------------------------------------

  ------------------------------Vacation Request-------------------------------------------------------------------
Update dbo.ConfigParameter set RequestTypeId=11 , orderNo=1 where ConfigKey='VacBalanceSource' 
Update dbo.ConfigParameter set RequestTypeId=11 , orderNo=2 where ConfigKey='WFSalaryAdvanceRequired'  
Update dbo.ConfigParameter set RequestTypeId=11 , orderNo=3 where ConfigKey='VacBalanceCalcPeriod'  
Update dbo.ConfigParameter set RequestTypeId=11 , orderNo=4 where ConfigKey='VacVacationAboveBalance' 
Update dbo.ConfigParameter set RequestTypeId=11 , orderNo=5 where ConfigKey='WFAirTicketRequired'  
Update dbo.ConfigParameter set RequestTypeId=11 , orderNo=6 where ConfigKey='VacOverlappingVacation'  
Update dbo.ConfigParameter set RequestTypeId=11 , orderNo=7 where ConfigKey='VacAboveAnnualBalanceDaysCount'  
Update dbo.ConfigParameter set RequestTypeId=11 , orderNo=8 where ConfigKey='VacAboveDayoffBalanceDaysCount'  
Update dbo.ConfigParameter set RequestTypeId=11 , orderNo=9 where ConfigKey='VacAboveHolidayBalanceDaysCount'  
Update dbo.ConfigParameter set RequestTypeId=11, orderNo=10 where ConfigKey='WFShowEstimatedBalance'  
Update dbo.ConfigParameter set RequestTypeId=11 , orderNo=11 where ConfigKey='WFWorkByVacationTracks'  
Update dbo.ConfigParameter set RequestTypeId=11 , orderNo=12 where ConfigKey='WFVacationRequestAttachment'  
Update dbo.ConfigParameter set RequestTypeId=11 , orderNo=13 where ConfigKey='WFDiscountDayOffAndHolidayFromAnuual'  
Update dbo.ConfigParameter set RequestTypeId=11 , orderNo=14 where ConfigKey='WFShowHolidayAndDayoffNow'  
Update dbo.ConfigParameter set RequestTypeId=11 , orderNo=15 where ConfigKey='WFAllowMultipleVacationRequest'  
Update dbo.ConfigParameter set RequestTypeId=11 , orderNo=16 where ConfigKey='WFVacationReplacementEmployeeRequired'  
Update dbo.ConfigParameter set RequestTypeId=11 , orderNo=17 where ConfigKey='VacEmployeeReplacement'  

-----------------------------------------------OverTime-------------------------------------------------------------
Update dbo.ConfigParameter set RequestTypeId=3 , orderNo=1 where ConfigKey='WFRequstOverTimeBeforeToday'  
Update dbo.ConfigParameter set RequestTypeId=3 , orderNo=2 where ConfigKey='WFMinOverTimeHoursCount'  
Update dbo.ConfigParameter set RequestTypeId=3 , orderNo=3 where ConfigKey='WFOverTimeCountPerDay'  
Update dbo.ConfigParameter set RequestTypeId=3 , orderNo=4 where ConfigKey='WFIsOvertimeRequestNeedSectionApproval'  

------------------------------------------------Genral------------------------------------------------------------------
Update dbo.ConfigParameter set RequestTypeId=0 , orderNo=1 where ConfigKey='WFShowTrackCode'  
Update dbo.ConfigParameter set RequestTypeId=0 , orderNo=2 where ConfigKey='SalHaveMoreCalc'  
Update dbo.ConfigParameter set RequestTypeId=0 , orderNo=3 where ConfigKey='WFAllUserMustApprove'  
Update dbo.ConfigParameter set RequestTypeId=0 , orderNo=4 where ConfigKey='WFDailyWorkingHours'  
Update dbo.ConfigParameter set RequestTypeId=0 , orderNo=5,Name='Monthely Working Days' where ConfigKey='WFMonthelyWorkingDays'  

-------------------------------------------------AirTicket---------------------------------------------------------------
Update dbo.ConfigParameter set RequestTypeId=4 , orderNo=1 where ConfigKey='WFMinAirTicketOffersCount'  

--------------------------------------------------Penalty-----------------------------------------------------------------
Update dbo.ConfigParameter set RequestTypeId=13 , orderNo=1 where ConfigKey='WFPenaltyRepeatDuration'  
Update dbo.ConfigParameter set RequestTypeId=13 , orderNo=2 where ConfigKey='WFMaximumPenaltiesPerMonth'  

----------------------------------------------------New Employees----------------------------------------------------------
Update dbo.ConfigParameter set RequestTypeId=14 , orderNo=1 where ConfigKey='WFNewEmployeesRequestEnableRequiredNumber'  

--------------------------------------------------Resignation------------------------------------------------------------------
Update dbo.ConfigParameter set RequestTypeId=7 , orderNo=1 where ConfigKey='WFAddDisclaimerRequestAfterResignationApproval'  


  INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate],[RequestTypeId]) VALUES 
	(N'WFVacShowOtherBalance', N'Show Other Balance', N'ÚÑÖ ÇáÑÕíÏ ÇáÃÎÑ', N'true', 2, 18, 1, 1, NULL, NULL,11)
GO


-------------------------End 2019-02-28---------------------------------------------
-------------------------Hammad 2019-02-28---------------------------------------------


   Alter Table [dbo].[AC_TransactionReply] 
  Add PriorityDegreeCode int NULL
  GO

-------------------------End 2019-02-28---------------------------------------------
-------------------------Sayed 2019-03-04---------------------------------
insert into  [dbo].[ConfigCategory] ([ConfigCategoryCode],[Name],[Arabic_Name])
values(10,'Appraisal',N'ÇáÊÞííã')
Go

insert into [dbo].[ConfigCategoryModule](ConfigCategoryCode,AppModuleCode)
values(10,8)
go
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate])
 VALUES (N'ApprReminderBeforFinishAppraisalPeriodByDay', N'Reminder Befor Finish Appraisal Period By Day', N'ÇáÊäÈíå ÞÈá ÇäÊåÇÁ ÝÊÑÉ ÇáÊÞííã Èßã íæã', N'1', 10, 1, 2, 1, NULL, NULL)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate])
 VALUES (N'ApprReminderTimeDurationType', N'Reminder Time Duration Type', N'äæÚ ãÏÉ æÞÊ ÇáÊäÈíå', N'1', 10, 2, 6, 1, NULL, NULL)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate])
 VALUES (N'ApprReminderTimeDuration', N'Reminder Time Duration', N'ãÏÉ æÞÊ ÇáÊäÈíå', N'1', 10, 3, 2, 1, NULL, NULL)
GO
insert [dbo].[ConfigLookup] ([ConfigLookupCode],[Name],[Arabic_Name],[ConfigKey]) values(33,'Day',N'íæã','ApprReminderTimeDurationType')
GO
insert [dbo].[ConfigLookup] ([ConfigLookupCode],[Name],[Arabic_Name],[ConfigKey]) values(34,'Hour',N'ÓÇÚÉ','ApprReminderTimeDurationType')
Go
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (188, N'Work Settings', N'ÅÚÏÇÏÇÊ ÇáÚãá', 161, N'/Appraisal/SystemConfig', N'Index', NULL, N'get', 7, 1, 1)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES (1128, N'ÅÚÏÇÏÇÊ ÇáÚãá', N'System Security Config', 188, 1)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES (1129, N'ÚÑÖ ÅÚÏÇÏÇÊ ÇáÚãá', N'View System Security Config', 188, 2)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES (1130, N'ÍÝÙ ÅÚÏÇÏÇÊ ÇáÚãá', N'Save System Security Config', 188, 2)
Go

 
------------------------------End 2019-03-04---------------------------------
------------------------------Hammad 2019-03-04------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (189, N'Evaluation Types', N'ÃäæÇÚ ÇáÊÞíã', 161, N'/Appraisal/EvaluationType', N'Index', NULL, N'get', 7, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10022, N'ÃäæÇÚ ÇáÊÞííã', N'Evaluation Types', 189, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10023, N'ÚÑÖ ÃäæÇÚ ÇáÊÞííã', N'View Evaluation Types', 189, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10024, N'ÅÖÇÝÉ ÃäæÇÚ ÇáÊÞííã', N'Add Evaluation Types', 189, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10025, N'ÊÚÏíá ÃäæÇÚ ÇáÊÞííã', N'Edit Evaluation Types', 189, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10026, N'ÍÝÙ ÃäæÇÚ ÇáÊÞííã', N'Save Evaluation Types', 189, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10027, N'ÍÐÝ ÃäæÇÚ ÇáÊÞííã', N'Delete Evaluation Types', 189, 2)
Go

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1298, 189, 8)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF

------------------------------End 2019-03-04------------------------------
------------------------------Hammad 2019-03-06------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (190, N'Evaluation Periods', N'ÝÊÑÇÊ ÇáÊÞíã', 161, N'/Appraisal/EvaluationPeriod', N'Index', NULL, N'get', 8, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10028, N'ÝÊÑÇÊ ÇáÊÞííã', N'Evaluation Periods', 190, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10029, N'ÚÑÖ ÝÊÑÉ ÇáÊÞííã', N'View Evaluation Period', 190, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10030, N'ÅÖÇÝÉ ÝÊÑÉ ÇáÊÞííã', N'Add Evaluation Period', 190, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10031, N'ÊÚÏíá ÝÊÑÉ ÇáÊÞííã', N'Edit Evaluation Period', 190, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10032, N'ÍÝÙ ÝÊÑÉ ÇáÊÞííã', N'Save Evaluation Period', 190, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10033, N'ÍÐÝ ÝÊÑÉ ÇáÊÞííã', N'Delete Evaluation Period', 190, 2)
Go

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1299, 190, 8)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF

------------------------------End 2019-03-06------------------------------
------------------------------Hammad 2019-03-17---------------------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (191, N'Employee Evaluation', N'ÊÞíã ÇáãæÙÝ', 161, N'/Appraisal/EmployeeEvaluationItem', N'Index', NULL, N'get', 10, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10034, N'ÊÞííã ÇáãæÙÝ', N'Employee Evaluation', 191, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10035, N'ÚÑÖ ÊÞííã ÇáãæÙÝ', N'View Employee Evaluation', 191, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10036, N'ÍÝÙ ÊÞííã ÇáãæÙÝ ', N'Save Employee Evaluation', 191, 2)
GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1300, 191, 8)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (192, N'Employee Evaluation Status', N'ÍÇáÉ ÊÞíã ÇáãæÙÝ', 161, N'/Appraisal/EmployeeEvaluationStatus', N'Index', NULL, N'get', 11, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10037, N'حالة تقييم الموظف', N'Employee Evaluation Status', 192, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10038, N'عرض حالة تقييم الموظف', N'View Employee Evaluation Status', 192, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10039, N'حفظ حالة تقييم الموظف', N'Save Employee Evaluation Status', 192, 2)
GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1301, 192, 8)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
Go
------------------------------END 2019-03-17---------------------------
------------------------------Sayed 2019-03-21-------------------------

CREATE TABLE [dbo].[CentralCostType](
	[CostTypeCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](150) NULL,
	[Arabic_Name] [nvarchar](150) NULL,
 CONSTRAINT [PK_CentralCostType] PRIMARY KEY CLUSTERED 
(
	[CostTypeCode] 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
------------------------------End 2019-03-21----------------------------
  ---------------------------Sayed 2019-04-15-------------------------
  INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
  VALUES (N'SyncAttendanceYear', N'Attendance Sync Year', N'سنة المزامنة للحضور والانصراف', N'2019', 3, 11, 2, 1, 1, CAST(N'2019-05-06 15:25:55.060' AS DateTime), NULL)
  Go

  INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
  VALUES (N'SyncAttendanceMonth', N'Attendance Sync Month', N'شهر المزامنة للحضور والانصراف', N'4', 3, 10, 2, 1, 1, CAST(N'2019-05-06 15:25:55.060' AS DateTime), NULL)
  Go

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'SyncBasicDataDuration', N'Sync Duration of Basic Data', N'مدة المزامنة للبيانات الأساسية', N'5', 3, 3, 2, 1, 1, CAST(N'2019-05-06 15:25:55.060' AS DateTime), NULL)
Go

  ---------------------------End 2019-04-15-----------------------------
  
 ---------------------------Hammad 2019-04-21------------------------
Alter table WF_OvertimeType Add
FromTime time(5)  null,
ToTime time(5) null
Go

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WFMethodOFCalculateOvertime', N'Method of calculate overtime', N'طريقة احتساب الوقت الاضافي', N'52', 2, 5, 6, 1, 1, CAST(N'2019-04-21 15:32:15.460' AS DateTime), 3)
Go
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (52, N'Egyptian Law', N'القانون المصري', N'WFMethodOFCalculateOvertime')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (53, N'Other', N'اخرى', N'WFMethodOFCalculateOvertime')
Go
INSERT [dbo].[WF_OvertimeType] ([OvertimeTypeCode], [Name], [Arabic_Name], [Factor], [IsPercentage], [FromTime], [ToTime])
 VALUES (8, N'Morning', N'صباحي', 1.35, 1, CAST(N'08:00:00' AS Time), CAST(N'17:45:00' AS Time))
 Go
INSERT [dbo].[WF_OvertimeType] ([OvertimeTypeCode], [Name], [Arabic_Name], [Factor], [IsPercentage], [FromTime], [ToTime])
 VALUES (9, N'Evening', N'مسائي', 1.70, 1, CAST(N'18:00:00' AS Time), CAST(N'23:00:00' AS Time))
 Go
 ---------------------------End 2019-04-21------------------------
 ---------------------------Ali 2019-04-22------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (193, N'Cost Type', N'نوع التكلفة', 163, N'/ConsolidatedDashboard/CentralCostType', N'Index', NULL, N'get', 6, 1, 1)
 Go
 
 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11030, N'نوع التكلفة', N'Cost Type', 193, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11031, N'عرض نوع التكلفة', N'View Cost Type', 193, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11032, N'إضافة نوع التكلفة', N'Add Cost Type', 193, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11033, N'تعديل نوع التكلفة', N'Edit Cost Type', 193, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11034, N'حفظ نوع التكلفة', N'Save Cost Type', 193, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11035, N'حذف نوع التكلفة', N'Delete Cost Type', 193, 2)
Go

 SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
 INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1303, 193, 9)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
 ---------------------------End 2019-04-22------------------------
 ---------------------------Hammad 2019-04-22------------------------

   Alter table [dbo].[WF_VacationRequest] Add
  MissionPlace nvarchar(50) null
  Go
 ---------------------------End 2019-04-22------------------------
   ---------------------------Hammad 2019-04-24------------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WFGetNextEmployeeCodeFromEmployee', N'Get Next Employee Code From Employee', N'كود الموظف القادم من الموظفين', N'false', 2, 1, 1, 1, NULL, NULL, 5)
  GO
   ---------------------------End 2019-04-24-----------------------
      ---------------------------Hammad 2019-04-30------------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'CheckYearOfBirthWhenChangeDefualtPassword', N'Check Year Of Birth When Change Defualt Password', N'التحقق من سنة الميلاد عند تغير كلمة المرور الافتراضية', N'false', 7, 8, 1, 1, NULL, NULL, NULL)
  GO
   ---------------------------End 2019-04-30-----------------------
   ---------------------------Sayed 2019-04-30---------------------
  
CREATE TABLE [dbo].[TimeAttendanceEvaluationMonthly](
	[SerialAuto] [int] IDENTITY(1,1) NOT NULL,
	[PYear] [smallint] NOT NULL,
	[Period] [tinyint] NOT NULL,
	[EmployeeCode] [int] NOT NULL,
	[Points] [float] NULL,
	[ReasonCode] [int] NOT NULL,
	[ActionDate] [datetime] NULL,
	[ActionDateHijri] [nvarchar](10) NULL,
	[NotesNumber] [int] NULL,
	[NotesText] [nvarchar](255) NULL,
	[Exemption] [tinyint] NOT NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_TimeAttendanceEvaluationMonthly] PRIMARY KEY CLUSTERED 
(
	[SerialAuto] 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
/****** Object:  Table [dbo].[TimeAttendanceEvaluationYealy]    Script Date: 30/04/2019 13:16:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TimeAttendanceEvaluationYealy](
	[SerialAuto] [int] IDENTITY(1,1) NOT NULL,
	[PYear] [smallint] NOT NULL,
	[Period] [tinyint] NULL,
	[EmployeeCode] [int] NOT NULL,
	[Points] [float] NULL,
	[ReasonCode] [int] NOT NULL,
	[ActionDate] [datetime] NULL,
	[ActionDateHijri] [nvarchar](10) NULL,
	[NotesNumber] [int] NULL,
	[NotesText] [nvarchar](255) NULL,
	[Exemption] [tinyint] NOT NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_TimeAttendanceEvaluationYealy] PRIMARY KEY CLUSTERED 
(
	[SerialAuto] 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
------------------------End 2019-04-30------------------------------
------------------------Hammad 2019-05-06------------------------------
CREATE TABLE [dbo].[SecurityUserEmailNotification](
	[SecurityUserEmailNotificationCode] [int] IDENTITY(1,1) NOT NULL,
	[SecurityUserCode] [int] NOT NULL,
	[EmailTemplateTypeCode] [int] NOT NULL,
 CONSTRAINT [PK_SecurityUserEmailNotification] PRIMARY KEY CLUSTERED 
(
	[SecurityUserEmailNotificationCode] 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].[SecurityUserEmailNotification]  WITH CHECK ADD  CONSTRAINT [FK_SecurityUserEmailNotification_EmailTemplateType] FOREIGN KEY([EmailTemplateTypeCode])
REFERENCES [dbo].[EmailTemplateType] ([EmailTemplateTypeCode])
GO

ALTER TABLE [dbo].[SecurityUserEmailNotification] CHECK CONSTRAINT [FK_SecurityUserEmailNotification_EmailTemplateType]
GO

ALTER TABLE [dbo].[SecurityUserEmailNotification]  WITH CHECK ADD  CONSTRAINT [FK_SecurityUserEmailNotification_SecurityUser] FOREIGN KEY([SecurityUserCode])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[SecurityUserEmailNotification] CHECK CONSTRAINT [FK_SecurityUserEmailNotification_SecurityUser]
GO
------------------------End 2019-05-06------------------------------
------------------------Hammad 2019-05-08---------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (194, N' Template Privilege', N'صلاحيات النماذج', 10, N'/AdminComm/UserAdminTemplatePrivilege', N'Index', NULL, N'get', 13, 1, 1)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (2122, N'صلاحيات النماذج', N'Users  Template Privilege', 194, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (2123, N' حفظ صلاحيات النماذج', N'Save Users  Template Privilege', 194, 2)
Go

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (2365, 194, 2)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF

------------------------End 2019-05-08---------------------------
------------------------Hammad 2019-05-13------------------------

CREATE TABLE [dbo].[AC_TransactionAuthorityImage](
	[TransactionAuthorityImageCode] [int] IDENTITY(1,1) NOT NULL,
	[TransactionCode] [int] NOT NULL,
	[AuthorityCode] [int] NOT NULL,
	[ActionTypeCode] [int] NULL,
 CONSTRAINT [PK_AC_TransactionAuthorityImage] PRIMARY KEY CLUSTERED 
(
	[TransactionAuthorityImageCode] 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].[AC_TransactionAuthorityImage]  WITH CHECK ADD  CONSTRAINT [FK_AC_TransactionAuthorityImage_AC_ActionType] FOREIGN KEY([ActionTypeCode])
REFERENCES [dbo].[AC_ActionType] ([ActionTypeCode])
GO

ALTER TABLE [dbo].[AC_TransactionAuthorityImage] CHECK CONSTRAINT [FK_AC_TransactionAuthorityImage_AC_ActionType]
GO

ALTER TABLE [dbo].[AC_TransactionAuthorityImage]  WITH CHECK ADD  CONSTRAINT [FK_AC_TransactionAuthorityImage_AC_Authority] FOREIGN KEY([AuthorityCode])
REFERENCES [dbo].[AC_Authority] ([AuthorityCode])
GO

ALTER TABLE [dbo].[AC_TransactionAuthorityImage] CHECK CONSTRAINT [FK_AC_TransactionAuthorityImage_AC_Authority]
GO

ALTER TABLE [dbo].[AC_TransactionAuthorityImage]  WITH CHECK ADD  CONSTRAINT [FK_AC_TransactionAuthorityImage_AC_Transaction] FOREIGN KEY([TransactionCode])
REFERENCES [dbo].[AC_Transaction] ([TransactionCode])
GO

ALTER TABLE [dbo].[AC_TransactionAuthorityImage] CHECK CONSTRAINT [FK_AC_TransactionAuthorityImage_AC_Transaction]
GO

------------------------End 2019-05-13------------------------
------------------------Hammad 2019-05-16------------------------

CREATE TABLE [dbo].[WF_GeneralRequestType](
	[GeneralRequestTypeCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](30) NULL,
	[Arabic_Name] [nvarchar](30) NULL,
 CONSTRAINT [PK_GeneralRequestTypes] PRIMARY KEY CLUSTERED 
(
	[GeneralRequestTypeCode] 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_GeneralRequest](
	[GeneralRequestId] [bigint] IDENTITY(1,1) NOT NULL,
	[EmployeeCode] [int] NOT NULL,
	[GeneralRequestTypeCode] [int] NOT NULL,
	[RequestDate] [datetime] NOT NULL,
	[RequestDateHijri] [nvarchar](10) NOT NULL,
	[RequestContent] [nvarchar](250) NOT NULL,
	[TrackCode] [int] NOT NULL,
	[DepartmentApproval] [tinyint] NOT NULL,
	[CancelRequestNumber] [int] NULL,
	[HRApproval] [tinyint] NOT NULL,
	[HRApprovalUserCode] [int] NULL,
	[HRApprovalDate] [datetime] NULL,
	[HRApprovalComment] [nvarchar](255) NULL,
	[HRApprovalDateHijri] [nvarchar](10) NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[CreationDateHijri] [nvarchar](10) NOT NULL,
	[Canceled] [bit] NOT NULL DEFAULT ((0)),
	[MainType] [tinyint] NOT NULL DEFAULT ((0)),
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
	[ModificationDateHijri] [nvarchar](10) NULL,
 CONSTRAINT [PK_WF_GeneralRequest] PRIMARY KEY CLUSTERED 
(
	[GeneralRequestId] 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_GeneralRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_GeneralRequest_Employees] FOREIGN KEY([EmployeeCode])
REFERENCES [dbo].[Employees] ([EmployeeCode])
GO


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

ALTER TABLE [dbo].[WF_GeneralRequest] CHECK CONSTRAINT [FK_WF_GeneralRequest_CreatedByUserCode]
GO

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

ALTER TABLE [dbo].[WF_GeneralRequest] CHECK CONSTRAINT [FK_WF_GeneralRequest_ModofiedByUser]
GO

ALTER TABLE [dbo].[WF_GeneralRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_GeneralRequest_SecurityUser] FOREIGN KEY([HRApprovalUserCode])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_GeneralRequest] CHECK CONSTRAINT [FK_WF_GeneralRequest_SecurityUser]
GO

ALTER TABLE [dbo].[WF_GeneralRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_GeneralRequest_WF_GeneralRequestType] FOREIGN KEY([GeneralRequestTypeCode])
REFERENCES [dbo].[WF_GeneralRequestType] ([GeneralRequestTypeCode])
GO

ALTER TABLE [dbo].[WF_GeneralRequest] CHECK CONSTRAINT [FK_WF_GeneralRequest_WF_GeneralRequestType]
GO

ALTER TABLE [dbo].[WF_GeneralRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_GeneralRequest_WF_RequestStatus] FOREIGN KEY([HRApproval])
REFERENCES [dbo].[WF_RequestStatus] ([RequestStatusId])
GO

ALTER TABLE [dbo].[WF_GeneralRequest] CHECK CONSTRAINT [FK_WF_GeneralRequest_WF_RequestStatus]
GO

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

ALTER TABLE [dbo].[WF_GeneralRequest] CHECK CONSTRAINT [FK_WF_GeneralRequest_WF_RequestStatus1]
GO

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

ALTER TABLE [dbo].[WF_GeneralRequest] CHECK CONSTRAINT [FK_WF_GeneralRequest_WF_Track]
GO



CREATE TABLE [dbo].[WF_GeneralRequestSignature](
	[GeneralRequestSignatureId] [bigint] IDENTITY(1,1) NOT NULL,
	[GeneralRequestId] [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,
 CONSTRAINT [PK_WF_GeneralRequestSignature] PRIMARY KEY CLUSTERED 
(
	[GeneralRequestSignatureId] 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_GeneralRequestSignature]  WITH CHECK ADD  CONSTRAINT [FK_WF_GeneralRequestSignature_SecurityUser] FOREIGN KEY([UserId])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_GeneralRequestSignature] CHECK CONSTRAINT [FK_WF_GeneralRequestSignature_SecurityUser]
GO

ALTER TABLE [dbo].[WF_GeneralRequestSignature]  WITH CHECK ADD  CONSTRAINT [FK_WF_GeneralRequestSignature_WF_GeneralRequest] FOREIGN KEY([GeneralRequestId])
REFERENCES [dbo].[WF_GeneralRequest] ([GeneralRequestId])
GO

ALTER TABLE [dbo].[WF_GeneralRequestSignature] CHECK CONSTRAINT [FK_WF_GeneralRequestSignature_WF_GeneralRequest]
GO

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

ALTER TABLE [dbo].[WF_GeneralRequestSignature] CHECK CONSTRAINT [FK_WF_GeneralRequestSignature_WF_RequestStatus]
GO






SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (120, N'General Request Sending', N'إرسال طلب عام', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (121, N'General Request Accept', N'الموافقة على طلب عام ', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (122, N'General Request Refuse', N'رفض طلب عام ', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (123, N'General Request Cancellation', 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 (120, N'General Request Sending', N'إرسال طلب عام', 120, N'إرسال طلب عام', N'<p>&nbsp;</p><p>نرجو الموافقة على طلب </p>', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (121, N'General Request Accept', N'الموافقة على طلب عام', 121, N'الموافقة على طلب عام', N'<p>نرجو الموافقة على طلب </p>', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (122, N'General Request Refuse', N'رفض طلب عام', 122, N'رفض طلب عام', N'<p>تم رفض الطلب </p>', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (123, N'General Request Cancellation', N'إالغاء طلب عام', 123, 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 (196, N'General Request Type', N'نوع طلب عام', 28, N'/WorkFlow/GeneralRequestType', N'Index', NULL, N'get', 15, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (197, N'General Request', N'طلب عام', 29, N'/WorkFlow/GeneralRequest', N'Index', NULL, N'get', 33, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (198, N'General Request Signature', N'اعتماد طلب عام', 108, N'/WorkFlow/GeneralRequestSignature', N'Index', NULL, N'get', 34, 1, 1)
Go

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (2368, 196, 1)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (2369, 197, 1)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (2370, 198, 1)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF



INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3335, N'انواع طلب عام', N'General Request Type ', 196, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3336, N'عرض انواع طلب عام', N'View General Reques Type', 196, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3337, N'إضافة انواع طلب عام', N'Add General Reques Type', 196, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3338, N'تعديل انواع طلب عام', N'Edit General Reques Type', 196, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3339, N'حذف انواع طلب عام', N'Delete General Reques Type', 196, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3340, N'حفظ انواع طلب عام', N'Save General Reques Type', 196, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3341, N'طلب عام', N'General Request', 197, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3342, N'عرض طلب عام', N'View General Request', 197, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3343, N'اضافة طلب عام', N'Add General Request', 197, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3344, N'تعديل طلب عام', N'Edit General Request', 197, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3345, N'حذف طلب عام', N'Delete General Request', 197, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3346, N'الغاء طلب عام', N'Cancel General Request', 197, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3347, N'حفظ طلب عام', N'Save General Request', 197, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3348, N' اعتماد طلب عام', N'General Request Signature', 198, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3349, N'عرض  اعتماد طلب عام', N'View General Request Signature', 198, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3350, N'تعديل اعتماد طلب عام', N'Edit General Request Signature', 198, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3351, N'حفظ اعتماد طلب عام', N'Save General Request Signature', 198, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3352, N'حفظ متعدد طلب عام', N'Save Multiple General Request Signature', 198, 2)
Go


INSERT [dbo].[WF_RequestType] ([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName]) VALUES (19, N'طلب عام', N'General Request', 0, N'sayedmustafa1984@gmail.com', N'sayedmustafa1984@gmail.com', N'123', N'smtp.sendgrid.net', 587, N'Sayed')
Go

------------------------End 2019-05-16------------------------
------------------------Sayed 2019-05-19----------------------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10040, N'احتساب تقييم الموظف', N'Calculate Employee Evaluation ', 192, 2)
GO
alter table [dbo].[WF_PermissionRequest]
add [IsNextDay] bit not null default(0)
GO
------------------------End 2019-05-19------------------------
------------------------Hammad 2019-05-20------------------------
CREATE TABLE [dbo].[AC_TransactionTemplate](
	[TransactionTemplateCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
	[EmailTemplateTypeCode] [int] NOT NULL,
	[Body] [nvarchar](max) NOT NULL,
 CONSTRAINT [PK_AC_TransactionTemplet] PRIMARY KEY CLUSTERED 
(
	[TransactionTemplateCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[AC_TransactionTemplate]  WITH CHECK ADD  CONSTRAINT [FK_AC_TransactionTemplet_EmailTemplateType] FOREIGN KEY([EmailTemplateTypeCode])
REFERENCES [dbo].[EmailTemplateType] ([EmailTemplateTypeCode])
GO

ALTER TABLE [dbo].[AC_TransactionTemplate] CHECK CONSTRAINT [FK_AC_TransactionTemplet_EmailTemplateType]
GO

CREATE TABLE [dbo].[AC_SecurityUserTemplate](
	[SecurityUserTemplateCode] [int] IDENTITY(1,1) NOT NULL,
	[SecurityUserCode] [int] NOT NULL,
	[TransactionTemplateCode] [int] NOT NULL,
	[EmailTemplateTypeCode] [int] NOT NULL,
 CONSTRAINT [PK_AC_SecurityUserTemplate] PRIMARY KEY CLUSTERED 
(
	[SecurityUserTemplateCode] 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].[AC_SecurityUserTemplate]  WITH CHECK ADD  CONSTRAINT [FK_AC_SecurityUserTemplate_AC_TransactionTemplate] FOREIGN KEY([TransactionTemplateCode])
REFERENCES [dbo].[AC_TransactionTemplate] ([TransactionTemplateCode])
GO

ALTER TABLE [dbo].[AC_SecurityUserTemplate] CHECK CONSTRAINT [FK_AC_SecurityUserTemplate_AC_TransactionTemplate]
GO

ALTER TABLE [dbo].[AC_SecurityUserTemplate]  WITH CHECK ADD  CONSTRAINT [FK_AC_SecurityUserTemplate_EmailTemplateType] FOREIGN KEY([EmailTemplateTypeCode])
REFERENCES [dbo].[EmailTemplateType] ([EmailTemplateTypeCode])
GO

ALTER TABLE [dbo].[AC_SecurityUserTemplate] CHECK CONSTRAINT [FK_AC_SecurityUserTemplate_EmailTemplateType]
GO

ALTER TABLE [dbo].[AC_SecurityUserTemplate]  WITH CHECK ADD  CONSTRAINT [FK_AC_SecurityUserTemplate_SecurityUser] FOREIGN KEY([SecurityUserCode])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[AC_SecurityUserTemplate] CHECK CONSTRAINT [FK_AC_SecurityUserTemplate_SecurityUser]
GO




------------------------End 2019-05-20------------------------

------------------------Ali 2019-05-20------------------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (195, N'TransactionTemplate', N'قالب المعاملات', 10, N'/AdminComm/TransactionTemplate', N'Index', NULL, N'get', 13, 1, 1)
GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (195, 120, 6)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (2124, N'عرض قالب المعاملات', N'Transaction Template View', 195, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (2125, N'اضافة قالب المعاملات', N' Transaction Template Add', 195, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (2126, N'تعديل قالب المعاملات', N'Transaction Template Edit', 195, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (2127, N'حذف  قالب المعاملات', N'Transaction Template Delete', 195, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (2128, N'حفظ قالب المعاملات', N'  Transaction Template Save', 195, 2)
GO
------------------------End 2019-05-20------------------------
------------------------Hammad 2019-05-22------------------------
ALTER TABLE dbo.WF_NewHireRequest ADD
	ReferenceStatusCode int NULL,
	DoneBy nvarchar(50) NULL,
	ReferenceCheck bit NOT NULL CONSTRAINT DF_WF_NewHireRequest_ReferenceCheck DEFAULT 0
GO
------------------------End 2019-05-22------------------------

------------------------Hammad 2019-05-23---------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (199, N'Provide workflow ', N'سير العمل', 7, N'/ProvideWorkflow', N'Index', N'fa fa-key', N'get', 3, 0, 1)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1131, N'تقديم سير', N'Provide workflow', 199, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1132, N'تقديم سير العمل فى اى وقت', N'Provide workflow at any time', 199, 2)
Go

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (2371, 199, 1)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (2372, 199, 2)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF

ALTER TABLE dbo.WF_RequestType ADD
	SubmitBeforRequestDate int NULL,
	SubmitAfterRequestDate int NULL
GO
------------------------End 2019-05-23---------------------

------------------------Hammad 2019-05-23---------------------

CREATE TABLE [dbo].[WF_KeepingTypes](
	[KeepingTypeCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](200) NOT NULL,
	[Arabic_Name] [nvarchar](200) NOT NULL,
 CONSTRAINT [PK_KeepingTypes] PRIMARY KEY CLUSTERED 
(
	[KeepingTypeCode] 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_Keeping](
	[Serial] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeCode] [int] NOT NULL,
	[KeepingTypeCode] [int] NOT NULL,
	[FromDate] [datetime] NOT NULL,
	[KeepingCount] [int] NOT NULL,
	[KeepingValue] [float] NULL,
	[NewHireRequestCode] [int] NOT NULL,
	[KeepingDeception] [varchar](1000) NULL,
 CONSTRAINT [PK_Keeping] PRIMARY KEY CLUSTERED 
(
	[Serial] 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

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[WF_Keeping]  WITH CHECK ADD  CONSTRAINT [FK_WF_Keeping_WF_KeepingTypes] FOREIGN KEY([KeepingTypeCode])
REFERENCES [dbo].[WF_KeepingTypes] ([KeepingCode])
GO

ALTER TABLE [dbo].[WF_Keeping] CHECK CONSTRAINT [FK_WF_Keeping_WF_KeepingTypes]
GO

ALTER TABLE [dbo].[WF_Keeping]  WITH CHECK ADD  CONSTRAINT [FK_WF_Keeping_WF_NewHireRequest] FOREIGN KEY([NewHireRequestCode])
REFERENCES [dbo].[WF_NewHireRequest] ([NewHireRequestCode])
GO

ALTER TABLE [dbo].[WF_Keeping] CHECK CONSTRAINT [FK_WF_Keeping_WF_NewHireRequest]
GO




------------------------End 2019-05-23---------------------

------------------------Ali 2019-05-27---------------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (200, N'Keeping Types', N'أنواع العهد', 28, N'/WorkFlow/KeepingType', N'Index', NULL, N'get', 16, 1, 1)
GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (200, 125, 4)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3353, N'أنواع العهد', N'Keeping Types ', 200, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3354, N'عرض أنواع العهد', N'ViewKeeping Types', 200, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3355, N'اضافة أنواع العهد', N'AddKeeping Types', 200, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3356, N'تعديل أنواع العهد', N'EditKeeping Types', 200, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3357, N' حذف أنواع العهد', N'Delete Keeping Types', 200, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3358, N'حفظ أنواع العهد', N'SaveViewKeeping Types', 200, 2)

GO

------------------------End 2019-05-27---------------------

------------------------Hammad 2019-05-27---------------------
ALTER TABLE dbo.TimePermissionsTypes ADD
	ReasonRequired bit  NOT NULL CONSTRAINT DF_TimePermissionsTypes_ReasonRequired DEFAULT 0
GO

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (201, N'Permissions Type Config', N'إعداد انوع الإذونات', 28, N'/WorkFlow/PermissionsTypeConfig', N'Index', NULL, N'get', 17, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3359, N' إعداد انوع الإذونات', N'Permissions Type Config', 201, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3360, N'عرض  إعداد انوع الإذونات', N'View Permissions Type Config', 201, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3361, N'حفظ  إعداد انوع الإذونات', N'Save Permissions Type Config', 201, 2)
GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (2374, 201, 1)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
------------------------End 2019-05-27---------------------

------------------------Hammad 2019-05-29---------------------

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (5117, N'حفظ الوظيفة', N'Save Job', 50, 2)
GO

ALTER TABLE dbo.Company ADD
	PermissionUsersCountLicense nvarchar(1000) NULL
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES (N'MailUserNameForPermissionUsersCount', N'User Name', N'اسم المستخدم', N'm.ragab@ssteg.net', 1, 8, 4, 0, NULL, NULL, NULL)

------------------------End 2019-05-29---------------------

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'APPColleaguesOfOtherDepartmentPercentage', N'incentives to evaluate Colleagues of other Department', N'نسبة الحافز على تقيم زملاء من إدارة أخرى', N'50', 10, 6, 2, 1, 1, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'APPColleaguesOfSameDepartmentPercentage', N'incentives to evaluate Colleagues Of Same DepartmentPercentage', N'نسبة الحافز على تقيم زملاء من نفس الإدارة', N'30', 10, 5, 2, 1, 1, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'APPrMinStaffEvalByOtherDepartment', N'Minimum staff to be evaluated by other departments', N'الحد الادنى للموظفين التى سيتم تقيمهم من إدارات أخرى', N'10', 10, 7, 2, 1, 1, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'APPrMinStaffEvalBySameDepartment', N'Minimum staff to be evaluated by Same departments', N'الحد الادنى للموظفين التى سيتم تقيمهم من نفس الإدارة ', N'10', 10, 9, 2, 1, 1, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'APPrNotAllowedEvaluateSameEmployeesPreviouslyEvaluated', N'Not allowed to evaluate the same employees that were previously evaluated', N'لا يسمح بتقييم نفس الموظفين الذين تم تقييمه في السابق', N'true', 10, 11, 1, 1, 1, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'APPrNotAllowedEvaluateSameEmployeeWhoEvaluatedYou', N'Not allowed to evaluate the same employee who evaluated you in current Evaluation', N'لايسمح بتقييم الموظف الذي قام بتقييمك في التقييم الحالي', N'true', 10, 12, 1, 1, 1, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'APPrPlacementGradesMinStaffEvalByOtherDepartment', N'Placement of grades in the case of evaluation below the minimum (evaluated from other departments)', N' تنسيب الدرجات فى حالة تقييم اقل من الحد الادنى تقيم من إدارات أخرى', N'true', 10, 8, 1, 1, 1, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'APPrPlacementGradesMinStaffEvalInSameDepartment', N'Placement of grades in the case of evaluation below the minimum (evaluate in same departments)', N' تنسيب الدرجات فى حالة تقييم اقل من الحد الادنى  تقيم فى نفس الإدارة', N'true', 10, 10, 1, 1, 1, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'ApprReminderBeforFinishAppraisalPeriodByDay', N'Reminder Befor Finish Appraisal Period By Day', N'التنبيه قبل انتهاء فترة التقييم بكم يوم', N'1', 10, 1, 2, 1, 1, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'ApprReminderTimeDuration', N'Reminder Time Duration', N'مدة وقت التنبيه', N'4', 10, 3, 2, 1, 1, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'ApprReminderTimeDurationType', N'Reminder Time Duration Type', N'نوع مدة وقت التنبيه', N'33', 10, 2, 6, 1, 1, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'APPrSubordinatesPercentage', N'incentives to evaluate subordinates Percentage', N'نسبة الحافز على تقيم المرؤسين', N'20', 10, 4, 2, 1, 1, NULL, NULL)


------------------------Ali 2019-05-30---------------------
 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (202, N'General Privileges', N'صلاحيات عامة', 47, NULL, NULL, NULL, N'get', 1, 0, 1)
 GO

 Update [dbo].[SecurityPrivilege] Set [SystemMenuCode]=202
 Where  ID= 5069
 GO

 DELETE FROM [dbo].[SecurityPrivilege] 
 WHERE ID IN (5055, 5065,5073,5077)
 GO


 ------------------------End 2019-05-29---------------------
 ------------------------Hammad 2019-05-30---------------------

 delete [dbo].[ConfigLookup]  where ConfigLookupCode in (50,51,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49)

delete [dbo].[ConfigParameter] 
where ConfigKey in ('SyncAttendanceMonth','SyncAttendanceYear','WFLoanTemplate','SyncBasicDataDuration','VacHolidayBalanceCalcPeriod'
,'VacDayoffBalanceCalcPeriod','VacOtherBalanceCalcPeriod')

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'SyncAttendanceYear', N'Attendance Sync Year', N'سنة المزامنة للحضور والانصراف', N'2019', 3, 11, 2, 1, 1, CAST(N'2019-05-06 15:25:55.060' AS DateTime), NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'SyncAttendanceMonth', N'Attendance Sync Month', N'شهر المزامنة للحضور والانصراف', N'4', 3, 10, 2, 1, 1, CAST(N'2019-05-06 15:25:55.060' AS DateTime), NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'SyncBasicDataDuration', N'Sync Duration of Basic Data', N'مدة المزامنة للبيانات الأساسية', N'5', 3, 3, 2, 1, 1, CAST(N'2019-05-06 15:25:55.060' AS DateTime), NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'WFLoanTemplate', N'Loan  Template Type', N'نوع نموذج السلف', N'51', 2, 3, 6, 1, NULL, CAST(N'2019-04-24 14:20:53.587' AS DateTime), 9)
INSERT into [ConfigLookup] ([ConfigLookupCode],[Name],[Arabic_Name],[ConfigKey]) values(50,'Makady Template',N'نموذج مكادي','WFLoanTemplate')
INSERT into [ConfigLookup] ([ConfigLookupCode],[Name],[Arabic_Name],[ConfigKey]) values(51,'Other Template',N'نماذج اخرى','WFLoanTemplate')
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'VacHolidayBalanceCalcPeriod', N'Display Holiday Vacation Balance till', N'إظهار رصيد الأجازات الرسمية حتى', N'36', 2, 3, 6, 1, NULL, CAST(N'2019-04-24 14:20:53.587' AS DateTime), 11)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'VacDayoffBalanceCalcPeriod', N'Display Day Off Vacation Balance till', N'إظهار رصيد اجازات الراحة الاسيوعية حتى', N'42', 2, 3, 6, 1, NULL, CAST(N'2019-04-24 14:20:53.587' AS DateTime), 11)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'VacOtherBalanceCalcPeriod', N'Display Other Vacation Balance till', N'إظهار رصيد الأجازات الاخرى حتى', N'46', 2, 3, 6, 1, NULL, CAST(N'2019-04-24 14:20:53.587' AS DateTime), 11)
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (35, N'Current Month End', N'نهاية الشهر الحالي', N'VacHolidayBalanceCalcPeriod')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (36, N'Month End of Vacation Request', N'نهاية شهر طلب الأجازة', N'VacHolidayBalanceCalcPeriod')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (37, N'Year End', N'نهاية العام', N'VacHolidayBalanceCalcPeriod')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (38, N'Start Vacation Date ', N'تاريخ بداية الاجازة', N'VacHolidayBalanceCalcPeriod')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (39, N'End Vacation Date ', N'تاريخ نهاية الاجازة', N'VacHolidayBalanceCalcPeriod')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (40, N'Current Month End', N'نهاية الشهر الحالي', N'VacDayoffBalanceCalcPeriod')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (41, N'Month End of Vacation Request', N'نهاية شهر طلب الأجازة', N'VacDayoffBalanceCalcPeriod')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (42, N'Year End', N'نهاية العام', N'VacDayoffBalanceCalcPeriod')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (43, N'Start Vacation Date ', N'تاريخ بداية الاجازة', N'VacDayoffBalanceCalcPeriod')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (44, N'End Vacation Date ', N'تاريخ نهاية الاجازة', N'VacDayoffBalanceCalcPeriod')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (45, N'Current Month End', N'نهاية الشهر الحالي', N'VacOtherBalanceCalcPeriod')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (46, N'Month End of Vacation Request', N'نهاية شهر طلب الأجازة', N'VacOtherBalanceCalcPeriod')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (47, N'Year End', N'نهاية العام', N'VacOtherBalanceCalcPeriod')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (48, N'Start Vacation Date ', N'تاريخ بداية الاجازة', N'VacOtherBalanceCalcPeriod')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (49, N'End Vacation Date ', N'تاريخ نهاية الاجازة', N'VacOtherBalanceCalcPeriod')

 Go

  ------------------------End 2019-05-30---------------------

  ------------------------Ali 2019-06-2---------------------

  CREATE TABLE [dbo].[SecurityPrivilegeActions](
	[ID] [int] NOT NULL,
	[AreaName] [nvarchar](50) NULL,
	[ControllerName] [nvarchar](50) NOT NULL,
	[ActionName] [nvarchar](250) NOT NULL,
	[ActionType] [int] NOT NULL,
	[HTTPMethod] [nvarchar](50) NOT NULL,
	[SecurityPrivilegeID] [int] NOT NULL,
 CONSTRAINT [PK_SecurityPrivilegeActions] PRIMARY KEY CLUSTERED 
(
	[ID] 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].[SecurityPrivilegeActions]  WITH CHECK ADD  CONSTRAINT [FK_SecurityPrivilegeActions_SecurityPrivilege] FOREIGN KEY([SecurityPrivilegeID])
REFERENCES [dbo].[SecurityPrivilege] ([ID])
GO

ALTER TABLE [dbo].[SecurityPrivilegeActions] CHECK CONSTRAINT [FK_SecurityPrivilegeActions_SecurityPrivilege]
GO



  INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1, N'Recruitment', N'CompanySize', N'Index', 0, N'get', 5023)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (2, N'Recruitment', N'CompanySize', N'CompanySize_Read', 0, N'post', 5024)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (3, N'Recruitment', N'CompanySize', N'Save', 1, N'get', 5025)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (4, N'Recruitment', N'CompanySize', N'Save', 2, N'get', 5026)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (5, N'Recruitment', N'CompanySize', N'Delete', 0, N'post', 5027)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (6, N'Recruitment', N'CompanySize', N'Save', 0, N'post', 5028)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (7, N'Recruitment', N'JobCategory', N'Index', 0, N'get', 5002)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (8, N'Recruitment', N'JobCategory', N'JobCategory_Read', 0, N'post', 5003)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (9, N'Recruitment', N'JobCategory', N'Save', 1, N'get', 5004)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (10, N'Recruitment', N'JobCategory', N'Save', 2, N'get', 5005)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (11, N'Recruitment', N'JobCategory', N'Delete', 0, N'post', 5006)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (12, N'Recruitment', N'JobCategory', N'Save', 0, N'post', 5007)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (13, N'Recruitment', N'VisaStatus', N'Index', 0, N'get', 5011)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (14, N'Recruitment', N'VisaStatus', N'VisaStatus_Read', 0, N'post', 5012)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (15, N'Recruitment', N'VisaStatus', N'Save', 1, N'get', 5013)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (16, N'Recruitment', N'VisaStatus', N'Save', 2, N'get', 5014)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (17, N'Recruitment', N'VisaStatus', N'Delete', 0, N'post', 5015)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (18, N'Recruitment', N'VisaStatus', N'Save', 0, N'post', 5016)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (19, N'Recruitment', N'CompanyDomain', N'Index', 0, N'get', 5017)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (20, N'Recruitment', N'CompanyDomain', N'CompanySize_Read', 0, N'post', 5018)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (21, N'Recruitment', N'CompanyDomain', N'Save', 1, N'get', 5019)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (22, N'Recruitment', N'CompanyDomain', N'Save', 2, N'get', 5020)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (23, N'Recruitment', N'CompanyDomain', N'Delete', 0, N'post', 5021)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (24, N'Recruitment', N'CompanyDomain', N'Save', 0, N'post', 5022)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (25, N'Recruitment', N'WorkSite', N'Index', 0, N'get', 5029)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (26, N'Recruitment', N'WorkSite', N'WorkSite_Read', 0, N'post', 5030)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (27, N'Recruitment', N'WorkSite', N'Save', 1, N'get', 5031)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (28, N'Recruitment', N'WorkSite', N'Save', 2, N'get', 5032)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (29, N'Recruitment', N'WorkSite', N'Delete', 0, N'post', 5033)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (30, N'Recruitment', N'WorkSite', N'Save', 0, N'post', 5034)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (31, N'Recruitment', N'QuestionTemplate', N'Index', 0, N'get', 5035)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (32, N'Recruitment', N'QuestionTemplate', N'QuestionTemplate_Read', 0, N'post', 5036)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (33, N'Recruitment', N'QuestionTemplate', N'SaveQuestion', 1, N'get', 5037)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (34, N'Recruitment', N'QuestionTemplate', N'SaveQuestion', 2, N'get', 5038)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (35, N'Recruitment', N'QuestionTemplate', N'Delete', 0, N'post', 5039)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (36, N'Recruitment', N'QuestionTemplate', N'SaveOpenQuestion', 0, N'post', 5040)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (37, N'Recruitment', N'QuestionTemplate', N'SaveClosedQuestion', 0, N'post', 5040)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (38, N'Recruitment', N'QuestionTemplate', N'SaveNumRangeQuestion', 0, N'post', 5040)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (39, N'Recruitment', N'QuestionTemplate', N'SaveDateRangeQuestion', 0, N'post', 5040)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (40, N'Recruitment', N'QuestionTemplate', N'SaveMultiChoiceQuestion', 0, N'post', 5040)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (41, N'Recruitment', N'JobApplySteps', N'Index', 0, N'get', 5057)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (42, N'Recruitment', N'JobApplySteps', N'InterviewStages_Read', 0, N'post', 5058)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (43, N'Recruitment', N'JobApplySteps', N'Save', 0, N'post', 5059)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (44, N'Recruitment', N'JobApplySteps', N'Save', 1, N'get', 5060)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (45, N'Recruitment', N'JobApplySteps', N'Save', 2, N'get', 5061)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (46, N'Recruitment', N'JobApplySteps', N'Delete', 0, N'post', 5062)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (47, N'Recruitment', N'JobOfferParameter', N'Index', 0, N'get', 5080)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (48, N'Recruitment', N'JobOfferParameter', N'JobOfferParameter_Read', 0, N'post', 5081)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (49, N'Recruitment', N'JobOfferParameter', N'Save', 1, N'get', 5082)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (50, N'Recruitment', N'JobOfferParameter', N'Save', 2, N'get', 5083)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (51, N'Recruitment', N'JobOfferParameter', N'Save', 0, N'post', 5084)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (52, N'Recruitment', N'JobOfferParameter', N'Delete', 0, N'post', 5085)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (53, N'Recruitment', N'JobRole', N'Index', 0, N'get', 5087)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (54, N'Recruitment', N'JobRole', N'JobRole_Read', 0, N'post', 5088)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (55, N'Recruitment', N'JobRole', N'Save', 1, N'get', 5089)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (56, N'Recruitment', N'JobRole', N'Save', 2, N'get', 5090)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (57, N'Recruitment', N'JobRole', N'Save', 0, N'post', 5091)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (58, N'Recruitment', N'JobRole', N'Delete', 0, N'post', 5092)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (59, N'Recruitment', N'JobType', N'Index', 0, N'get', 5093)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (60, N'Recruitment', N'JobType', N'JobType_Read', 0, N'post', 5094)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (61, N'Recruitment', N'JobType', N'Save', 1, N'get', 5095)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (62, N'Recruitment', N'JobType', N'Save', 2, N'get', 5096)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (63, N'Recruitment', N'JobType', N'Save', 0, N'post', 5097)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (64, N'Recruitment', N'JobType', N'Delete', 0, N'post', 5098)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (65, N'Recruitment', N'RejectHiring', N'Index', 0, N'get', 5101)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (66, N'Recruitment', N'RejectHiring', N'RejectHiring_Read', 0, N'post', 5102)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (67, N'Recruitment', N'RejectHiring', N'Save', 1, N'get', 5103)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (68, N'Recruitment', N'RejectHiring', N'Save', 2, N'get', 5104)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (69, N'Recruitment', N'RejectHiring', N'Delete', 0, N'post', 5105)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (70, N'Recruitment', N'RejectHiring', N'Save', 0, N'post', 5106)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (71, N'Recruitment', N'EvaluationParameter', N'Index', 0, N'get', 5107)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (72, N'Recruitment', N'EvaluationParameter', N'EvaluationParameter_Read', 0, N'post', 5108)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (73, N'Recruitment', N'EvaluationParameter', N'Save', 1, N'get', 5109)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (74, N'Recruitment', N'EvaluationParameter', N'Save', 2, N'get', 5110)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (75, N'Recruitment', N'EvaluationParameter', N'Save', 0, N'post', 5111)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (76, N'Recruitment', N'EvaluationParameter', N'Delete', 0, N'post', 5112)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (77, N'Recruitment', N'Job', N'Index', 0, N'get', 5008)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (78, N'Recruitment', N'Job', N'Job_Read', 0, N'post', 5009)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (79, N'Recruitment', N'Job', N'Edit', 0, N'get', 5010)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (80, N'Recruitment', N'Job', N'Edit', 0, N'post', 5117)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (81, N'Recruitment', N'RecruitJob', N'Index', 0, N'get', 5041)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (82, N'Recruitment', N'RecruitJob', N'RecruitJob_Read', 0, N'post', 5042)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (83, N'Recruitment', N'RecruitJob', N'Save', 1, N'get', 5043)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (84, N'Recruitment', N'RecruitJob', N'Save', 2, N'get', 5044)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (85, N'Recruitment', N'RecruitJob', N'Delete', 0, N'post', 5045)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (86, N'Recruitment', N'RecruitJob', N'Save', 0, N'post', 5046)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (87, N'Recruitment', N'RecruitJobCandidates', N'Index', 0, N'get', 5053)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (88, N'Recruitment', N'RecruitJobCandidates', N'Candidates_Read', 0, N'post', 5054)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (89, N'Recruitment', N'RecruitJobCandidates', N'Save', 0, N'post', 5056)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (90, N'Recruitment', N'RecruitJobCandidates', N'CandidateQuestionAnswer', 0, N'get', 5086)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (91, N'Recruitment', N'CandidateInvitation', N'Index', 0, N'get', 5063)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (92, N'Recruitment', N'CandidateInvitation', N'CandidateInvitation_Read', 0, N'post', 5064)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (93, N'Recruitment', N'CandidateInvitation', N'SendInvitation', 0, N'get', 5066)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (94, N'Recruitment', N'CandidateInvitation', N'SendInvitation', 0, N'post', 5066)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (95, N'Recruitment', N'CandidateInvitation', N'EmailInvitation', 0, N'get', 5066)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (96, N'Recruitment', N'InterviewResult', N'Index', 0, N'get', 5067)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (97, N'Recruitment', N'InterviewResult', N'InterviewResult_Read', 0, N'post', 5068)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (98, N'Recruitment', N'InterviewResult', N'InvitationResult', 0, N'get', 5070)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (99, N'Recruitment', N'InterviewResult', N'InvitationResult', 0, N'post', 5070)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (100, N'Recruitment', N'InterviewResult', N'InterviewDetails', 0, N'get', 5070)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (101, N'Recruitment', N'JobOffer', N'Index', 0, N'get', 5071)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (102, N'Recruitment', N'JobOffer', N'JobOffer_Read', 0, N'post', 5072)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (103, N'Recruitment', N'JobOffer', N'Save', 0, N'get', 5074)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (104, N'Recruitment', N'JobOffer', N'Save', 0, N'post', 5074)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (105, N'Recruitment', N'JobOffer', N'EmailInvitation', 0, N'get', 5074)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (106, N'Recruitment', N'HireCandidates', N'Index', 0, N'get', 5075)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (107, N'Recruitment', N'HireCandidates', N'HireCandidates_Read', 0, N'post', 5076)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (108, N'Recruitment', N'HireCandidates', N'OfferDetails', 0, N'get', 5078)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (109, N'Recruitment', N'HireCandidates', N'HireResult', 1, N'get', 5079)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (110, N'Recruitment', N'HireCandidates', N'HireResult', 0, N'post', 5044)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (111, N'Recruitment', N'RecruitEmployeeProfile', N'Index', 0, N'get', 5067)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (112, N'Recruitment', N'RecruitEmployeeProfile', N' RecruitEmployeeContact_Read', 0, N'post', 5068)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (113, N'Recruitment', N'RecruitEmployeeProfile', N'CandidateDetails', 0, N'get', 5069)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (114, N'Recruitment', N'CandidatesStatus', N'Index', 0, N'get', 5099)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (115, N'Recruitment', N'CandidatesStatus', N'CandidatesAppliedJobs_Read', 0, N'post', 5100)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (116, N'Recruitment', N'CandidatesStatus', N'QuestionAnswer', 0, N'get', 5086)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (117, N'Recruitment', N'CandidatesStatus', N'CandidateProfileDetails', 0, N'get', 5100)

 GO

 ------------------------End 2019-06-2---------------------

   ------------------------Ali 2019-06-9---------------------

 UPDATE [SecurityPrivilegeActions]
SET [ActionName] = 'CompanyDomain_Read'
WHERE ID = 20 ;
 GO


  DELETE FROM [dbo].[SecurityPrivilege] 
 WHERE ID IN (5047, 5050)
 GO

    UPDATE [SystemMenu]
SET [ShowInPrivilegePage] = 0
WHERE [SystemMenuCode] = 97 


 ------------------------End 2019-06-9---------------------
 ------------------------Hammad 2019-06-10---------------------
 update TimePermissionsKinds set Name='Half Day' where ComeLateOrOutEarly=4
  ------------------------End 2019-06-10---------------------

  ------------------------Hammad 2019-06-10---------------------

EXEC sp_rename '[dbo].[WF_CasualRequest].EventDate', 'EventDateFrom', 'COLUMN'; 
Go

EXEC sp_rename '[dbo].[WF_CasualRequest].EventDateHijri', 'EventDateFromHijri', 'COLUMN'; 
Go

Alter table [dbo].[WF_CasualRequest] Add
EventDateTo datetime null
Go

Alter table [dbo].[WF_CasualRequest] Add
EventDateToHijri nvarchar(10) null
Go
  ------------------------End 2019-06-10---------------------

 ------------------------Ali 2019-06-11---------------------
 

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (203, N'Budgets', N'الموازنات', 115, NULL, NULL, NULL, N'get', 6, 1, 1)

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES (204, N'Budget', N'الموازنة', 203, N'/Budget/BudgetHead', N'Index', NULL, N'get', 1, 1, 1)
GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (3407, 203, 6)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (3408, 204, 6)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12000, N'الموازنات', N'Budgets', 203, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12011, N'الموازنة', N'Budget', 204, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12012, N'عرض الموازنة', N'View Budget', 204, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12013, N'اضافة الموازنة', N'Add Budget', 204, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12014, N'تعديل الموازنة', N'Edit Budget', 204, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12015, N'حفظ الموازنة', N'Save Budget', 204, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12016, N'حذف الموازنة', N'Delete Budget', 204, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12017, N'فتح واغلاق الموازنة', N'Open Close Budget', 204, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12018, N'الغاء و التراجع عن الغاء الموازنة', N'Cancel And UnCancel Budget', 204, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12019, N'لقطة من بيانات الموظفين', N'Add Budget Salary Details', 204, 2)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (118, N'Budget', N'BudgetHead', N'Index', 0, N'get', 12011)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (119, N'Budget', N'BudgetHead', N'BudgetHead_Read', 0, N'post', 12012)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (120, N'Budget', N'BudgetHead', N'Save', 1, N'get', 12013)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (121, N'Budget', N'BudgetHead', N'Save', 2, N'get', 12014)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (122, N'Budget', N'BudgetHead', N'Save', 0, N'post', 12015)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (123, N'Budget', N'BudgetHead', N'Delete', 0, N'post', 12016)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (124, N'Budget', N'BudgetHead', N'OpenCloseBudget', 0, N'post', 12017)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (125, N'Budget', N'BudgetHead', N'CancelUnCancelBudget', 0, N'post', 12018)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (126, N'Budget', N'BudgetHead', N'AddBudgetSalaryDetails', 0, N'post', 12019)

Go

 ------------------------End 2019-06-11---------------------

 ------------------------Hammad 2019-06-12---------------------
 update [dbo].[WF_OvertimeType] set ToTime=CAST(N'23:59:59' AS Time) where OvertimeTypeCode=9
 Go

INSERT [dbo].[WF_OvertimeType] ([OvertimeTypeCode], [Name], [Arabic_Name], [Factor], [IsPercentage], [FromTime], [ToTime]) VALUES (10, N'Evening', N'مسائى', 1.7, 1, CAST(N'00:00:00' AS Time), CAST(N'06:00:00' AS Time))
Go
 ------------------------End 2019-06-12---------------------
 ------------------------sayed 2019-06-19-------------------
ALTER procedure [dbo].[Emp_GetEmployeeSalaryDetails] 
(
	@EmpCode	int=0
)
AS


SELECT 
	  [EmployeeCode]
      ,[dbo].Salary_Details.[BandCode]
      ,[Amount]
      ,[CurrencyCode]
      ,[CurrencyAmount]
      ,[AmountAcc]
      ,[CurrencyAmountAcc]
      ,[TempChangeValue]
      ,[ArabicAmount]
      ,[CalculateNumber]
      ,[EnglishAmount]
      ,[SerialAuto]
      ,[SpecialCostCenter]
	  ,[dbo].Basis.[Name] BasisNameEn
	  ,[dbo].Basis.[Arabic_Name] BasisNameAr

FROM [dbo].[Salary_Details]
inner join [dbo].[Basis] on [dbo].[Basis].[BandCode] = [dbo].Salary_Details.BandCode

where 
	( [dbo].Salary_Details.[EmployeeCode] = @EmpCode);



	------------------------End 2019-06-19---------------------
	------------------------Hammad 2019-06-20---------------------

 

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (205, N'Budget Items', N'عناصر الموازنة', 203, N'/Budget/BudgetItem', N'Index', NULL, N'get', 2, 0, 1)
Go

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (3409, 205, 6)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12020, N'عناصر الموازنة', N' Budget Items', 205, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12021, N'عرض عناصر الموازنة', N'View Budget Items', 205, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12022, N'تعديل عناصر الموازنة', N'Edit Budget Items', 205, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12023, N'حفظ عناصر الموازنة', N'Save Budget Items', 205, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12024, N'التعديل اليدوى لعناصر الموازنة', N'Manual Edit Budget Items', 205, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12025, N'حفظ بعد الاحتساب', N'Save After Calc Budget Items', 205, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12026, N'الغاء عناصر الموازنة', N'Cancel Budget Items', 205, 2)
Go

  INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES
   (127, N'Budget', N'BudgetItem', N'Index', 0, N'get', 12020)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (128, N'Budget', N'BudgetItem', N'BudgetItem_Read', 0, N'post', 12021)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (129, N'Budget', N'BudgetItem', N'Save', 2, N'get', 12022)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (130, N'Budget', N'BudgetItem', N'Save', 0, N'post', 12023)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (131, N'Budget', N'BudgetItem', N'ManualEditBudgetItems', 0, N'post', 12024)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (132, N'Budget', N'BudgetItem', N'CalculateBudgetItem', 0, N'post', 12025)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (133, N'Budget', N'BudgetItem', N'CancelBudgetItemCalculation', 0, N'post', 12026)
Go

	------------------------End 2019-06-20---------------------

	------------------------Ali 2019-06-23---------------------
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ConfigurationUpdates](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[UpdateNumber] [int] NOT NULL,
	[UpdateDate] [datetime] NOT NULL,
 CONSTRAINT [PK_ConfigurationUpdates] PRIMARY KEY CLUSTERED 
(
	[ID] 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

------------------------End 2019-06-23---------------------
------------------------Hammad 2019-06-24---------------------
ALTER TABLE [dbo].[Salary_Details] DROP CONSTRAINT [DF_Salary_Details_CurrencyCode]
GO

Alter table Salary_Details
Alter column CurrencyCode smallint NULL
GO

------------------------End 2019-06-24---------------------

------------------------Ali 2019-06-25---------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (206, N'Back Up ', N'نسخة احتياطيه', 4, N'BackUp ', N'Index', NULL, N'get', 10, 1, 0)
GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (3410, 206, 6)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1133, N'نسخة احتياطيه', N'Back Up ', 206, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1134, N'عرض', N'View', 206, 2)
GO
------------------------End 2019-06-25---------------------
------------------------Hammad 2019-06-27---------------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (207, N'Budget Actual Cost', N'التكلفة الفعلية للموازنة', 203, N'/Budget/BudgetActualCost', N'Index', NULL, N'get', 3, 1, 1)
 Go

 
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12027, N'التكلفة الفعلية للموازنة', N'Budget Actual Cost ', 207, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12028, N'عرض التكلفة الفعلية للموازنة', N'View Budget Actual Cost', 207, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12029, N'اضافة التكلفة الفعلية للموازنة', N'Add Budget Actual Cost', 207, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12030, N'تعديل التكلفة الفعلية للموازنة', N'Edit Budget Actual Cost', 207, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12031, N'حفظ التكلفة الفعلية للموازنة', N'Save Budget Actual Cost', 207, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12032, N'حذف التكلفة الفعلية للموازنة', N'Delete Budget Actual Cost', 207, 2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (135, N'Budget', N'BudgetActualCost', N'Index', 0, N'get', 12027)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (136, N'Budget', N'BudgetActualCost', N'BudgetActualCost_Read', 0, N'post', 12028)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (137, N'Budget', N'BudgetActualCost', N'Save', 1, N'get', 12029)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (138, N'Budget', N'BudgetActualCost', N'Save', 2, N'get', 12030)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (139, N'Budget', N'BudgetActualCost', N'Save', 0, N'post', 12031)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (140, N'Budget', N'BudgetActualCost', N'Delete', 0, N'post', 12032)
Go



SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (3415, 207, 6)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO
------------------------End 2019-06-27---------------------
------------------------Hammad 2019-07-01---------------------

  Update [dbo].[SecurityPrivilege] set DescriptionAR=N'إغلاق عنصر الموازنة'  , DescriptionEN=N'Close Budget Item'  where iD=12025
  Update [dbo].[SecurityPrivilegeActions] set  ActionName='CloseBudgetItem'  where iD=132
  GO
  INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
   VALUES (12033, N'فتح عنصر الموازنة', N'Open Budget Items', 205, 2)
   GO
   INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
   VALUES (141, N'Budget', N'BudgetItem', N'OpenBudgetItem', 0, N'post', 12033)
Go
------------------------End 2019-07-01---------------------

------------------------Ali 2019-07-02---------------------
  UPDATE [SecurityPrivilege]
SET [DescriptionAR] =N'فئات التقييم للادارات'
WHERE ID=10007 
GO
  UPDATE [SecurityPrivilege]
SET [DescriptionAR] =N'عرض فئات التقييم للادارات'
WHERE ID=10008 
GO
  UPDATE [SecurityPrivilege]
SET [DescriptionAR] =N'حفظ فئات التقييم للادارات'
WHERE ID=10009 
GO


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (208, N'Other settings', N'إعدادات اخرى', 4, NULL, NULL, NULL, N'get', 10, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (209, N'Email', N' البريد الالكترونى ', 208, N'Email', N'Index', NULL, N'get', 1, 1, 1)
GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (3419, 208, 6)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (3420, 209, 6)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1135, N'إعدادات اخرى', N'Other settings', 208, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1136, N'عرض إعدادات اخرى', N'view Other settings', 208, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1137, N' البريد الالكترونى ', N'Email', 209, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1138, N'عرض  البريد الالكترونى ', N'View Email', 209, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1139, N'تعديل  البريد الالكترونى ', N'Edit Email', 209, 2)

GO

 update [SystemMenu]
  set [ParentID]=208,
  [Sequence]=2
  where [SystemMenuCode]= 206

------------------------End 2019-07-02---------------------
