﻿
------------------------Hammad 2019-07-03------------------
ALTER TABLE dbo.WF_Track ADD
	IsOverloadBudget bit NOT NULL CONSTRAINT DF_WF_Track_IsOverloadBudget DEFAULT 0
GO
------------------------End 2019-07-03------------------

----------------------Sayed 2019-07-06------------------


CREATE TABLE [dbo].[Condition](
	[ConditionCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](100) NOT NULL,
	[Arabic_Name] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_Condition] PRIMARY KEY CLUSTERED 
(
	[ConditionCode] 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].[PositionCondition](
	[PositionConditionCode] [int] IDENTITY(1,1) NOT NULL,
	[PositionCode] [nvarchar](30) NOT NULL,
	[ConditionCode] [int] NOT NULL,
	[IsMandatory] [bit] NOT NULL,
 CONSTRAINT [PK_PositionCondition] PRIMARY KEY CLUSTERED 
(
	[PositionConditionCode] 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].[PositionCondition]  WITH CHECK ADD  CONSTRAINT [FK_PositionCondition_Condition] FOREIGN KEY([ConditionCode])
REFERENCES [dbo].[Condition] ([ConditionCode])
GO

ALTER TABLE [dbo].[PositionCondition] CHECK CONSTRAINT [FK_PositionCondition_Condition]
GO

ALTER TABLE [dbo].[PositionCondition]  WITH CHECK ADD  CONSTRAINT [FK_PositionCondition_PositionCondition] FOREIGN KEY([PositionCode])
REFERENCES [dbo].[Positions] ([PositionCode])
GO

ALTER TABLE [dbo].[PositionCondition] CHECK CONSTRAINT [FK_PositionCondition_PositionCondition]
GO



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(210,N'Conditions And Qualifications',N'الشروط والمؤهلات',52,N'/BasicData/Condition',N'Index',N'fa fa-briefcase', N'get',4,1,1)


GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1140, N'الشرط', N'Condition', 210, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1141, N'عرض الشرط', N'View Condition', 210, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1142, N'اضافة الشرط', N'Add Condition', 210, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1143, N'تعديل الشرط', N'Edit Condition', 210, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1144, N'حذف الشرط', N'Delete Condition', 210, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1145, N'حفظ الشرط', N'Save Condition', 210, 2)
GO


INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(5118,N'شروط الوظيفة',N'Job Conditions',50,2)
Go
-------------------------------End 2019-07-06------------------------------------


------------------------Ali 2019-07-07---------------------

 update [SystemMenu]
  set [Arabic_Name]=N'تغيير البريد الالكترونى ',
  [Name]='Change Email'
  where [SystemMenuCode]=209
GO

 delete from [SecurityPrivilege] 
  where
  [ID]=1136
  GO
  -------------------------------End 2019-07-07------------------------------------

  -------------------------------Hammad 2019-07-07------------------------------------
   
 update SystemMenu set Name=N'Other Tracks',Arabic_Name=N'مسارات أخرى' where SystemMenuCode=98

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

 ------------------------Ali 2019-07-07---------------------

      ALTER TABLE [SecurityUser]
ADD SignaturePhoto varchar(max) NULL;
GO
 -------------------------------End 2019-07-07------------------------------------
  ------------------------Ali 2019-07-08---------------------

 CREATE TABLE [dbo].[QualityStandard](
	[QualityStandardCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](200) NOT NULL,
	[Arabic_Name] [nvarchar](200) NOT NULL,
 CONSTRAINT [PK_QualityStandard] PRIMARY KEY CLUSTERED 
(
	[QualityStandardCode] 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].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (211, N'Quality Standards', N'معايير الجودة', 116, N'QualityStandard', N'Index', N'fa fa-thumb-tack', N'get', 5, 1, 1)
GO

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


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1146, N'معايير الجودة', N'Quality  Standards', 211, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1147, N'عرض  معايير الجودة', N'View Quality  Standards', 211, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1148, N'اضافة معايير الجودة', N'Add Quality  Standards', 211, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1149, N'تعديل معايير الجودة', N'Edit Quality  Standards', 211, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1150, N'حفظ معايير الجودة', N'Save Quality  Standards', 211, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1151, N'حذف معايير الجودة', N'Delete Quality  Standards', 211, 2)
GO

 -------------------------------End 2019-07-08------------------------------------

 -------------------------------Hammad 2019-07-09------------------------------------

 CREATE TABLE [dbo].[WF_NewHireRequestCondition](
	[NewHireRequestConditionCode] [int] IDENTITY(1,1) NOT NULL,
	[PositionConditionCode] [int] NOT NULL,
	[NewHireRequestCode] [int] NOT NULL,
 CONSTRAINT [PK_WF_NewHireRequestCondition] PRIMARY KEY CLUSTERED 
(
	[NewHireRequestConditionCode] 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_NewHireRequestCondition]  WITH CHECK ADD  CONSTRAINT [FK_WF_NewHireRequestCondition_PositionCondition] FOREIGN KEY([PositionConditionCode])
REFERENCES [dbo].[PositionCondition] ([PositionConditionCode])
GO

ALTER TABLE [dbo].[WF_NewHireRequestCondition] CHECK CONSTRAINT [FK_WF_NewHireRequestCondition_PositionCondition]
GO

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

ALTER TABLE [dbo].[WF_NewHireRequestCondition] CHECK CONSTRAINT [FK_WF_NewHireRequestCondition_WF_NewHireRequest]
GO


 CREATE TABLE [dbo].[WF_PromotionRequestCondition](
	[PromotionRequestConditionCode] [int] IDENTITY(1,1) NOT NULL,
	[PositionConditionCode] [int] NOT NULL,
	[PromotionRequestCode] [int] NOT NULL,
 CONSTRAINT [PK_WF_PromotionRequestCondition] PRIMARY KEY CLUSTERED 
(
	[PromotionRequestConditionCode] 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_PromotionRequestCondition]  WITH CHECK ADD  CONSTRAINT [FK_WF_PromotionRequestCondition_PositionCondition] FOREIGN KEY([PositionConditionCode])
REFERENCES [dbo].[PositionCondition] ([PositionConditionCode])
GO

ALTER TABLE [dbo].[WF_PromotionRequestCondition] CHECK CONSTRAINT [FK_WF_PromotionRequestCondition_PositionCondition]
GO

ALTER TABLE [dbo].[WF_PromotionRequestCondition]  WITH CHECK ADD  CONSTRAINT [FK_WF_PromotionRequestCondition_WF_PromotionRequest] FOREIGN KEY([PromotionRequestCode])
REFERENCES [dbo].[WF_PromotionRequest] ([PromotionRequestCode])
GO

ALTER TABLE [dbo].[WF_PromotionRequestCondition] CHECK CONSTRAINT [FK_WF_PromotionRequestCondition_WF_PromotionRequest]
GO


CREATE TABLE [dbo].[EmployeeCandidacyQuality](
	[EmployeeCandidacyQualityCode] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeCandidacyID] [int] NOT NULL,
	[QualityStandardCode] [int] NOT NULL,
	[QualityDegreeCode] [int] NOT NULL,
 CONSTRAINT [PK_EmployeeCandidacyQuality] PRIMARY KEY CLUSTERED 
(
	[EmployeeCandidacyQualityCode] 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].[EmployeeCandidacyQuality]  WITH CHECK ADD  CONSTRAINT [FK_EmployeeCandidacyQuality_EmployeeCandidacy] FOREIGN KEY([EmployeeCandidacyID])
REFERENCES [dbo].[EmployeeCandidacy] ([EmployeeCandidacyID])
GO

ALTER TABLE [dbo].[EmployeeCandidacyQuality] CHECK CONSTRAINT [FK_EmployeeCandidacyQuality_EmployeeCandidacy]
GO

ALTER TABLE [dbo].[EmployeeCandidacyQuality]  WITH CHECK ADD  CONSTRAINT [FK_EmployeeCandidacyQuality_QualityStandard] FOREIGN KEY([QualityStandardCode])
REFERENCES [dbo].[QualityStandard] ([QualityStandardCode])
GO

ALTER TABLE [dbo].[EmployeeCandidacyQuality] CHECK CONSTRAINT [FK_EmployeeCandidacyQuality_QualityStandard]
GO


 -------------------------------End 2019-07-09------------------------------------
 -------------------------------Ahmed 2019-07-10------------------------------------
 
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (212, N'Vacation Plan', N'خطة الاجازات', 60, N'/WorkFlow/Attendance', N'VacationPlan', N'fa fa-calendar', N'get', 1, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3362, N'خطة الاجازات', N'Vacation Plan', 212, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3363, N'عرض خطة الاجازات', N'View Vacation Plan', 212, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3364, N'حفظ خطة الاجازات', N'Save Vacation Plan', 212, 2)
Go

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (3432, 212, 1)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO
 -------------------------------End 2019-07-10------------------------------------
 ------------------------------Sayed 2019-07-10-----------------------------------
 alter table [dbo].[VacationType]
Add InsideVacationPlan bit not null default(0)
Go
CREATE TABLE [dbo].[WF_VacationPlan](
	[VacationPlanCode] [int] IDENTITY(1,1) NOT NULL,
	[Year] [int] NOT NULL,
	[Month] [int] NOT NULL,
	[EmployeeCode] [int] NOT NULL,
	[Day1] [int] NULL,
	[Day2] [int] NULL,
	[Day3] [int] NULL,
	[Day4] [int] NULL,
	[Day5] [int] NULL,
	[Day6] [int] NULL,
	[Day7] [int] NULL,
	[Day8] [int] NULL,
	[Day9] [int] NULL,
	[Day10] [int] NULL,
	[Day11] [int] NULL,
	[Day12] [int] NULL,
	[Day13] [int] NULL,
	[Day14] [int] NULL,
	[Day15] [int] NULL,
	[Day16] [int] NULL,
	[Day17] [int] NULL,
	[Day18] [int] NULL,
	[Day19] [int] NULL,
	[Day20] [int] NULL,
	[Day21] [int] NULL,
	[Day22] [int] NULL,
	[Day23] [int] NULL,
	[Day24] [int] NULL,
	[Day25] [int] NULL,
	[Day26] [int] NULL,
	[Day27] [int] NULL,
	[Day28] [int] NULL,
	[Day29] [int] NULL,
	[Day30] [int] NULL,
	[Day31] [int] NULL,
	
 CONSTRAINT [PK_WF_VacationPlans] PRIMARY KEY CLUSTERED 
(
	[VacationPlanCode] 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-07-10--------------------------------------

-------------------------------Hammad 2019-07-11--------------------------------------


CREATE TABLE [dbo].[PenaltyCategories](
	[PenaltyCategoryCode] [int] NOT NULL,
	[Name] [nvarchar](150) NULL,
	[Arabic_Name] [nvarchar](150) NULL,
	[Closed] [bit] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_PenaltyCategories_PenaltyCategoryCode] PRIMARY KEY CLUSTERED 
(
	[PenaltyCategoryCode] 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].[CandidacyTypes](
	[CandidacyTypeCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](200) NOT NULL,
	[Arabic_Name] [nvarchar](200) NOT NULL,
	[FinishedTestPeriod] [bit] NOT NULL CONSTRAINT [DF_CandidacyTypes_FinishedTestPeriod]  DEFAULT ((0)),
	[MonthsCountAfterHiringDate] [int] NOT NULL,
 CONSTRAINT [PK_CandidacyTypes] PRIMARY KEY CLUSTERED 
(
	[CandidacyTypeCode] 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].[CandidatesTypes](
	[CandidatesTypeCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](200) NOT NULL,
	[Arabic_Name] [nvarchar](200) NOT NULL,
 CONSTRAINT [PK_CandidatesTypes_1] PRIMARY KEY CLUSTERED 
(
	[CandidatesTypeCode] 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].[CandidacyTypeDetails](
	[CandidacyTypeDetailCode] [int] IDENTITY(1,1) NOT NULL,
	[CandidacyTypeCode] [int] NOT NULL,
	[CandidatesTypeCode] [int] NOT NULL,
 CONSTRAINT [PK_CandidacyTypeDetails] PRIMARY KEY CLUSTERED 
(
	[CandidacyTypeDetailCode] 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].[CandidacyTypeDetails]  WITH CHECK ADD  CONSTRAINT [FK_CandidacyTypeDetails_CandidacyTypes] FOREIGN KEY([CandidacyTypeCode])
REFERENCES [dbo].[CandidacyTypes] ([CandidacyTypeCode])
GO

ALTER TABLE [dbo].[CandidacyTypeDetails] CHECK CONSTRAINT [FK_CandidacyTypeDetails_CandidacyTypes]
GO

ALTER TABLE [dbo].[CandidacyTypeDetails]  WITH CHECK ADD  CONSTRAINT [FK_CandidacyTypeDetails_CandidatesTypes] FOREIGN KEY([CandidatesTypeCode])
REFERENCES [dbo].[CandidatesTypes] ([CandidatesTypeCode])
GO

ALTER TABLE [dbo].[CandidacyTypeDetails] CHECK CONSTRAINT [FK_CandidacyTypeDetails_CandidatesTypes]
GO




CREATE TABLE [dbo].[CandidacyTypePenalty](
	[CandidacyTypePenaltyCode] [int] IDENTITY(1,1) NOT NULL,
	[CandidacyTypeCode] [int] NOT NULL,
	[PenaltyCategoryCode] [int] NOT NULL,
	[PreventFromCandidature] [bit] NOT NULL CONSTRAINT [DF_CandidacyTypePenalty_PreventFromCandidature]  DEFAULT ((0)),
	[CandidatureAfterMonthsCount] [int] NULL,
 CONSTRAINT [PK_CandidacyTypePenalty] PRIMARY KEY CLUSTERED 
(
	[CandidacyTypePenaltyCode] 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].[CandidacyTypePenalty]  WITH CHECK ADD  CONSTRAINT [FK_CandidacyTypePenalty_CandidacyTypes] FOREIGN KEY([CandidacyTypeCode])
REFERENCES [dbo].[CandidacyTypes] ([CandidacyTypeCode])
GO

ALTER TABLE [dbo].[CandidacyTypePenalty] CHECK CONSTRAINT [FK_CandidacyTypePenalty_CandidacyTypes]
GO

ALTER TABLE [dbo].[CandidacyTypePenalty]  WITH CHECK ADD  CONSTRAINT [FK_CandidacyTypePenalty_PenaltyCategories] FOREIGN KEY([PenaltyCategoryCode])
REFERENCES [dbo].[PenaltyCategories] ([PenaltyCategoryCode])
GO

ALTER TABLE [dbo].[CandidacyTypePenalty] CHECK CONSTRAINT [FK_CandidacyTypePenalty_PenaltyCategories]
GO


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (213, N'Candidacy Type', N'أنواع الترشيح', 116, N'/CandidacyType', N'Index', NULL, N'get', 6, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1152, N'أنواع الترشيح', N'Candidacy Type', 213, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1153, N'عرض  أنواع الترشيح', N'View Candidacy Type', 213, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1154, N'اضافة أنواع الترشيح', N'Add Candidacy Type', 213, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1155, N'تعديل أنواع الترشيح', N'Edit Candidacy Type', 213, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1156, N'حفظ أنواع الترشيح', N'Save Candidacy Type', 213, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1157, N'حذف أنواع الترشيح', N'Delete Candidacy Type', 213, 2)
GO

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


-------------------------------End 2019-07-11--------------------------------------
-------------------------------Hammad 2019-07-14--------------------------------------


CREATE TABLE [dbo].[CandidacySetup](
	[CandidacySetupCode] [int] IDENTITY(1,1) NOT NULL,
	[CandidacyTypeCode] [int] NOT NULL,
	[FromDate] [datetime] NOT NULL,
	[ToDate] [datetime] NOT NULL,
	[FromDateHijri] [nvarchar](10) NOT NULL,
	[ToDateHijri] [nvarchar](10) NOT NULL,
	[DependOnPreviousCandidacies] [bit] NOT NULL,
	[MaxCountCandidatesForSection] [int] NOT NULL,
	[AnnualMonthly] [int] NOT NULL,
	[Year] [int] NULL,
 CONSTRAINT [PK_CandidacySetup] PRIMARY KEY CLUSTERED 
(
	[CandidacySetupCode] 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].[CandidacySetup] ADD  CONSTRAINT [DF_Table2_PeriodFromDateHijri]  DEFAULT ('') FOR [FromDateHijri]
GO

ALTER TABLE [dbo].[CandidacySetup] ADD  CONSTRAINT [DF_Table2_PeriodToDateHijri]  DEFAULT ('') FOR [ToDateHijri]
GO

ALTER TABLE [dbo].[CandidacySetup] ADD  CONSTRAINT [DF_CandidacySetup_DependOnPreviousCandidacies]  DEFAULT ((0)) FOR [DependOnPreviousCandidacies]
GO

ALTER TABLE [dbo].[CandidacySetup]  WITH CHECK ADD  CONSTRAINT [FK_CandidacySetup_CandidacyTypes] FOREIGN KEY([CandidacyTypeCode])
REFERENCES [dbo].[CandidacyTypes] ([CandidacyTypeCode])
GO

ALTER TABLE [dbo].[CandidacySetup] CHECK CONSTRAINT [FK_CandidacySetup_CandidacyTypes]
GO




CREATE TABLE [dbo].[CandidacySetupMonth](
	[CandidacySetupMonthCode] [int] IDENTITY(1,1) NOT NULL,
	[CandidacySetupCode] [int] NOT NULL,
	[Month] [int] NOT NULL,
 CONSTRAINT [PK_CandidacySetupMonth] PRIMARY KEY CLUSTERED 
(
	[CandidacySetupMonthCode] 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].[CandidacySetupMonth]  WITH CHECK ADD  CONSTRAINT [FK_CandidacySetupMonth_CandidacySetup] FOREIGN KEY([CandidacySetupCode])
REFERENCES [dbo].[CandidacySetup] ([CandidacySetupCode])
GO

ALTER TABLE [dbo].[CandidacySetupMonth] CHECK CONSTRAINT [FK_CandidacySetupMonth_CandidacySetup]
GO



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (214, N'Candidacy Setup', N'إعدادات الترشيح', 116, N'/CandidacySetup', N'Index', NULL, N'get', 7, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1158, N'إعدادت الترشيح', N'Candidacy Setup', 214, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1159, N'عرض  إعدادت الترشيح', N'View Candidacy Setup', 214, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1160, N'اضافة إعدادت الترشيح', N'Add Candidacy Setup', 214, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1161, N'تعديل إعدادت الترشيح', N'Edit Candidacy Setup', 214, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1162, N'حفظ إعدادت الترشيح', N'Save Candidacy Setup', 214, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1163, N'حذف إعدادت الترشيح', N'Delete Candidacy Setup', 214, 2)
Go

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





-------------------------------End 2019-07-14--------------------------------------
-------------------------------Hammad 2019-07-15----------------------------------

  ALTER TABLE dbo.EmployeeCandidacy ADD
	CandidacySetupCode int NOT NULL default(0)
GO

  ALTER TABLE dbo.EmployeeCandidacy 
  DROP COLUMN [Month]

  GO

 ALTER TABLE dbo.EmployeeCandidacy 
  DROP COLUMN [Year]

  GO

  -------------------------------End 2019-07-15----------------------------------

  -------------------------------Ali 2019-07-15----------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (215, N'Vacation Type', N'انواع الاجازات', 28, N'/WorkFlow/VacationType', NULL, NULL, NULL, 17, 1, 0)
 GO
  
  SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
  INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (3437, 215, 1)
  SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
   GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3365, N'انواع الاجازات', N'Vacation Type', 215, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3366, N'عرض انواع الاجازات', N'View Vacation Type', 215, 1)
 GO


SET IDENTITY_INSERT [dbo].[SecurityUserDetail] ON 
  INSERT [dbo].[SecurityUserDetail] ([ID], [SecurityUserID], [PrivilegeID]) VALUES (13489, 1, 3365)
INSERT [dbo].[SecurityUserDetail] ([ID], [SecurityUserID], [PrivilegeID]) VALUES (13490, 1, 3366)
SET IDENTITY_INSERT [dbo].[SecurityUserDetail] OFF
 GO
  -------------------------------End 2019-07-15----------------------------------

  -------------------------------Hammad 2019-07-16-------------------------------
     
ALTER TABLE dbo.CandidacySetup ADD
	Name nvarchar(200) NOT NULL ,
	Arabic_Name nvarchar(200) NOT NULL 
GO

ALTER TABLE [dbo].[CandidacySetup]  WITH CHECK ADD  CONSTRAINT [FK_CandidacySetup_CandidacyTypes] FOREIGN KEY([CandidacyTypeCode])
REFERENCES [dbo].[CandidacyTypes] ([CandidacyTypeCode])
GO

ALTER TABLE [dbo].[CandidacySetup] CHECK CONSTRAINT [FK_CandidacySetup_CandidacyTypes]
GO


ALTER TABLE [dbo].[EmployeeCandidacy]  WITH CHECK ADD  CONSTRAINT [FK_EmployeeCandidacy_CandidacySetup] FOREIGN KEY([CandidacySetupCode])
REFERENCES [dbo].[CandidacySetup] ([CandidacySetupCode])
GO

ALTER TABLE [dbo].[EmployeeCandidacy] CHECK CONSTRAINT [FK_EmployeeCandidacy_CandidacySetup]
GO

  -------------------------------End 2019-07-16-------------------------------

  -------------------------------A.Khaled 2019-07-16-------------------------------
     
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES (216, N'Budget compare with actual', N'مقارنة الموازنات بالتكلفة الفعلية', 203, N'/Budget/DashBoard', N'Index', NULL, N'get', 3, 1, 1)
GO

INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES (216, 6)
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12034, N'مقارنة الموازنات بالتكلفة الفعلية', N'Budget compare with actual', 216, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12035, N'مقارنة الموازنة بالعنصر', N'Budget Compare By Item', 216, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12036, N'مقارنة الموازنة بالشهر', N'Budget Compare By Month', 216, 2)
GO

  -------------------------------End 2019-07-16-------------------------------


  -------------------------------Ali 2019-07-16-------------------------------
   ALTER TABLE [VacationType]
ADD [HaveDifferentTrack] [bit] NOT NULL DEFAULT(0);



SET IDENTITY_INSERT [dbo].[SecurityUserDetail] ON 
INSERT [dbo].[SecurityUserDetail] ([ID], [SecurityUserID], [PrivilegeID]) VALUES (13193, 1, 1137)
INSERT [dbo].[SecurityUserDetail] ([ID], [SecurityUserID], [PrivilegeID]) VALUES (13194, 1, 1138)
INSERT [dbo].[SecurityUserDetail] ([ID], [SecurityUserID], [PrivilegeID]) VALUES (13195, 1, 1139)



INSERT [dbo].[SecurityUserDetail] ([ID], [SecurityUserID], [PrivilegeID]) VALUES (13192, 1, 1134)
INSERT [dbo].[SecurityUserDetail] ([ID], [SecurityUserID], [PrivilegeID]) VALUES (13546, 1, 1133)

SET IDENTITY_INSERT [dbo].[SecurityUserDetail] OFF


  -------------------------------End 2019-07-16-------------------------------
  -------------------------------Hammad 2019-07-16----------------------------
  ALTER TABLE dbo.PenaltiesList ADD
	PenaltyCategoryCode int NULL
GO

  SET IDENTITY_INSERT [dbo].[CandidatesTypes] ON 
INSERT [dbo].[CandidatesTypes] ([CandidatesTypeCode], [Name], [Arabic_Name]) VALUES (1, N'Department Manager', N'مدير الإدارة')
INSERT [dbo].[CandidatesTypes] ([CandidatesTypeCode], [Name], [Arabic_Name]) VALUES (2, N'Section Manager', N'مدير القسم')
INSERT [dbo].[CandidatesTypes] ([CandidatesTypeCode], [Name], [Arabic_Name]) VALUES (3, N'Direct Manager', N'المدير المباشر')
INSERT [dbo].[CandidatesTypes] ([CandidatesTypeCode], [Name], [Arabic_Name]) VALUES (4, N'Employee', N'موظف')
SET IDENTITY_INSERT [dbo].[CandidatesTypes] OFF
  -------------------------------End 2019-07-16----------------------------

 -------------------------------Ali 2019-07-17-------------------------------



 SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ConditionCategory](
	[ConditioncategoryCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](250) NOT NULL,
	[Arabic_Name] [nvarchar](250) NOT NULL,
 CONSTRAINT [PK_Conditioncategory] PRIMARY KEY CLUSTERED 
(
	[ConditioncategoryCode] 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].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (217, N'Conditions And Qualifications categories', N'فئات الشروط والمؤهلات', 52, N'/BasicData/ConditionCategorie', N'Index', N'fa fa-briefcase', N'get', 5, 1, 1)


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


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1164, N'فئات الشروط والمؤهلات', N'Conditions And Qualifications categories', 217, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1165, N'عرض فئات الشروط والمؤهلات', N'View Conditions And Qualifications categories', 217, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1166, N'اضافة فئات الشروط والمؤهلات', N'Add Conditions And Qualifications categories', 217, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1167, N'تعديل فئات الشروط والمؤهلات', N'Edit Conditions And Qualifications categories', 217, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1168, N'حذف فئات الشروط والمؤهلات', N'Delete Conditions And Qualifications categories', 217, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1169, N'حفظ فئات الشروط والمؤهلات', N'Save Conditions And Qualifications categories', 217, 2)


   ALTER TABLE [Condition]
ADD [ConditioncategoryCode] [int] NOT NULL DEFAULT(3); ;
Go


ALTER TABLE [dbo].[Condition]  WITH CHECK ADD  CONSTRAINT [FK_Condition_ConditionCategory] FOREIGN KEY([ConditioncategoryCode])
REFERENCES [dbo].[ConditionCategory] ([ConditioncategoryCode])
GO

-------------------------------End 2019-07-17-------------------------------
-------------------------------Hammad 2019-07-17------------------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WFCalculatePenalitesCountForCategory', N'Calculate Penalites Count For Category(Month)', N'إحتساب عدد الجزاءات للفئة قبل (شهر)', N'5', 2, 1, 2, 1, NULL, NULL, 10)
 -------------------------------End 2019-07-17-------------------------------

 -------------------------------Ali 2019-07-22------------------------------
 	update [SystemMenuModule]
   set [SystemMenuCode]=50,[AppModuleCode]=1
    where [SystemMenuModuleCode]=3426


	update [SystemMenuModule]
   set [SystemMenuCode]=50,[AppModuleCode]=1
    where [SystemMenuModuleCode]=3426


	 -------------------------------End 2019-07-22-------------------------------
	 
	 -------------------------------A.Khaled 2019-07-24-------------------------------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12037, N'تفاصيل الموظفين للعنصر', N'Employees details for item', 205, 2)
GO
INSERT INTO [dbo].[SecurityPrivilegeActions]([ID],[AreaName],[ControllerName],[ActionName],[ActionType],[HTTPMethod],[SecurityPrivilegeID]) VALUES (142,N'Budget',N'BudgetItem',N'Details',0,N'get',12037)
GO

UPDATE SecurityPrivilegeActions SET HTTPMethod=N'get' WHERE ID=131 
GO

INSERT INTO [dbo].[SecurityPrivilegeActions]([ID],[AreaName],[ControllerName],[ActionName],[ActionType],[HTTPMethod],[SecurityPrivilegeID]) VALUES (143,N'Budget',N'DashBoard',N'GetBudgetCompareByItem',0,N'post',12035)
INSERT INTO [dbo].[SecurityPrivilegeActions]([ID],[AreaName],[ControllerName],[ActionName],[ActionType],[HTTPMethod],[SecurityPrivilegeID]) VALUES (144,N'Budget',N'DashBoard',N'GetBudgetCompareByMonth',0,N'post',12036)
GO

CREATE FUNCTION [dbo].[NumbersToRows] (@fromNumber int,@toNumber int)
RETURNS TABLE 
AS
RETURN 
(
	WITH theNumbers AS
     (SELECT @fromNumber as theNumber
      UNION ALL
      SELECT theNumber+1 FROM theNumbers WHERE theNumber+1 <= @toNumber)
SELECT theNumber FROM theNumbers
--OPTION (MAXRECURSION 0);
)
GO

CREATE FUNCTION [dbo].[MonthsToRows] (@fromMonth int,@fromYear int,@toMonth int,@toYear int)
RETURNS @result table (month int NULL, year int NULL)
AS
BEGIN
IF(@toYear>@fromYear)
	BEGIN
	INSERT INTO @result (month,year)
	SELECT Months.theNumber AS Month, Years.theNumber Year 
	FROM (SELECT * FROM dbo.NumbersToRows(@fromMonth,12)) Months
	CROSS JOIN (SELECT * FROM dbo.NumbersToRows(@fromYear,@fromYear)) AS Years
	SET @fromYear=@fromYear+1;
	WHILE(@toYear>@fromYear)
	BEGIN
	INSERT INTO @result (month,year)
	SELECT Months.theNumber AS Month, Years.theNumber Year 
	FROM (SELECT * FROM dbo.NumbersToRows(1,12)) Months
	CROSS JOIN (SELECT * FROM dbo.NumbersToRows(@fromYear,@fromYear)) AS Years
	SET @fromYear=@fromYear+1;
	END
	INSERT INTO @result (month,year)
	SELECT Months.theNumber AS Month, Years.theNumber Year 
	FROM (SELECT * FROM dbo.NumbersToRows(1,@toMonth)) Months
	CROSS JOIN (SELECT * FROM dbo.NumbersToRows(@fromYear,@fromYear)) AS Years
	END
	ELSE
	BEGIN
	INSERT INTO @result (month,year)
	SELECT Months.theNumber AS Month, Years.theNumber Year 
	FROM (SELECT * FROM dbo.NumbersToRows(@fromMonth,@toMonth)) Months
	CROSS JOIN (SELECT * FROM dbo.NumbersToRows(@fromYear,@toYear)) AS Years
	END 	
RETURN 
END
GO

CREATE VIEW [Budget].[PreDashboardBudget]
AS
WITH BEDDates AS 
(
  SELECT BED.BudgetItemCode, BED.EmployeeCode, BED.NewAmount, BED.EndEffectYear, BED.EndEffectMonth,  BH.FromMonth,BH.FromYear,BH.[ToMonth],BH.[ToYear],BED.BudgetEmployeeDetailCode
  FROM [Budget].[BudgetEmployeeDetails] BED
  INNER JOIN [Budget].[BudgetItems] BI ON BED.BudgetItemCode=BI.BudgetItemCode
  INNER JOIN [Budget].[BudgetHeads] BH ON BI.BudgetHeadCode=BH.BudgetHeadCode  
  WHERE (datefromparts(BED.EndEffectYear, BED.EndEffectMonth, 1) BETWEEN datefromparts(BH.FromYear, BH.FromMonth, 1) AND datefromparts(BH.[ToYear], BH.[ToMonth], 1))
)
, BED AS 
(
  SELECT BI.BudgetHeadCode, BI.BudgetItemCode, BI.Name, BI.Arabic_Name, BudEmpDtls.EmployeeCode, BudEmpDtls.NewAmount, BI.SaveStatus  FROM [Budget].[BudgetEmployeeDetails] BudEmpDtls
  INNER JOIN [Budget].[BudgetItems] BI ON BudEmpDtls.BudgetItemCode=BI.BudgetItemCode
  INNER JOIN [Budget].[BudgetHeads] BH ON BI.BudgetHeadCode=BH.BudgetHeadCode
)
SELECT BED.BudgetHeadCode,BED.BudgetItemCode, BED.Arabic_Name, BED.Name, BEDDates.BudgetEmployeeDetailCode,  b.Year, b.Month,BEDDates.EmployeeCode,BED.NewAmount, BED.SaveStatus FROM BED
INNER JOIN BEDDates ON BED.EmployeeCode=BEDDates.EmployeeCode AND BED.BudgetItemCode=BEDDates.BudgetItemCode
CROSS APPLY dbo.MonthsToRows(BEDDates.FromMonth,BEDDates.FromYear,BEDDates.EndEffectMonth,BEDDates.EndEffectYear) AS b
GO

CREATE VIEW [Budget].[PreDashboardActual]
AS
SELECT BI.BudgetHeadCode, BAC.BudgetItemCode, BI.Arabic_Name, BI.Name, BAC.BudgetActualCostCode, BAC.CostYear, BAC.CostMonth, BAC.Amount, BI.SaveStatus FROM [Budget].[BudgetHeads] BH 
  INNER JOIN [Budget].[BudgetItems] BI ON BI.BudgetHeadCode=BH.BudgetHeadCode
  LEFT JOIN [Budget].[BudgetActualCosts] BAC ON BI.BudgetItemCode=BAC.BudgetItemCode
GO
  -------------------------------End 2019-07-24-------------------------------
  -------------------------------Hammad 2019-07-25----------------------------
  ALTER TABLE WF_NewHireRequest ALTER COLUMN HRStatusCode int NULL
  Go
  ALTER TABLE dbo.WF_LoanTypeDetials ADD
	LoanDependOnCode int NULL
GO
    -------------------------------End 2019-07-25---------------------------- 
	-------------------------------A.Khaled 2019-07-25----------------------------
INSERT INTO [dbo].[ConfigParameter] ([ConfigKey],[Name],[Arabic_Name],[ConfigValue],[ConfigCategoryCode],[OrderNo],[ConfigType],[IsVisible],[ModifiedBy],[ModificationDate],[RequestTypeId])
     VALUES (N'DefaultDate',N'Default Date',N'التاريخ الافتراضي',N'g',1,9,4,0,NULL,NULL,NULL)
	 INSERT INTO [dbo].[ConfigParameter] ([ConfigKey],[Name],[Arabic_Name],[ConfigValue],[ConfigCategoryCode],[OrderNo],[ConfigType],[IsVisible],[ModifiedBy],[ModificationDate],[RequestTypeId])
     VALUES (N'CountryCode',N'Country Code',N'كود الدولة',N'EG',1,10,4,0,NULL,NULL,NULL)
GO
    -------------------------------End 2019-07-25----------------------------
    -------------------------------Hammad 2019-07-25----------------------------

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'WFPromotionShowConfirmedApproval', N'Show Confirmed Approval Request', N'عرض تاكيد موافقة الطلب', N'false', 2, 1, 1, 1, NULL, NULL, 10)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3367, N'عرض تاكيد موافقة الطلب', N'Show Confirmed Approval Request', 89, 2)
Go
 ALTER TABLE WF_NewHireRequest ALTER COLUMN SecurityLevel tinyint NULL
  Go
---------------------------------End 2019-07-31----------------------------
----------------------------------Sayed 2019-07-31--------------------------
CREATE TABLE [dbo].[Religion](
	[ReligionCode] [tinyint] NOT NULL,
	[Name] [nvarchar](30) NULL,
	[Arabic_Name] [nvarchar](30) NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_Religion] PRIMARY KEY CLUSTERED 
(
	[ReligionCode] 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-07-31------------------------------
------------------------Hammad 2019-07-31------------------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'WFNewHireArmyDataRequired', N'Army Data Required', N'بيانات التجنيد إجبارية', N'false', 2, 4, 1, 1, NULL, NULL, 5)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'WFNewHireInsuranceDataRequired', N'Insurance Data Required', N'بيانات التامين إجبارية', N'false', 2, 2, 1, 1, NULL, NULL, 5)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'WFNewHireWorkHeelDataRequired', N'WorkHeel Data Required', N'بيانات كعب العمل إجبارية', N'false', 2, 3, 1, 1, NULL, NULL, 5)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'WFNewHireIDDataRequired', N'ID Data Required', N'بيانات جواز السفر/  البطاقة إجبارية', N'false', 2, 3, 1, 1, NULL, NULL, 5)
Go
------------------------End 2019-07-31------------------------------
------------------------Hammad 2019-08-01---------------------------

ALTER TABLE dbo.WF_NewHireRequest ADD
	ReligionCode int NULL,
	CurrentAddress nvarchar(50) NULL,
	IDAddress nvarchar(50) NULL,
	WorkHeelIssueDate datetime NULL,
	WorkHeelIssuePlace nvarchar(50) NULL,
	WorkHeelResendDate datetime NULL,
	CityCode int NULL,
	MilitaryDate datetime NULL,
	MilitaryExpireDate datetime NULL,
	District nvarchar(50) NULL,
	CertificationNumber nvarchar(50) NULL,
	StandbyExpireDate datetime NULL,
	MilitaryCode tinyint NULL
GO

------------------------End 2019-08-01---------------------------

------------------------Ali 2019-08-01---------------------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (218, N'Sql Interface', N'واجهة قاعدة البيانات ', 208, N'SqlInterface', N'Index', NULL, N'get', 3, 1, 0)
Go

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (3446, 218, 6)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1170, N'واجهة قاعدة البيانات ', N'Sql Interface', 218, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1171, N' عرض واجهة قاعدة البيانات  ', N'View Sql Interface', 218, 2)
Go

SET IDENTITY_INSERT [dbo].[SecurityUserDetail] ON 
INSERT [dbo].[SecurityUserDetail] ([ID], [SecurityUserID], [PrivilegeID]) VALUES (1170, 1062, 2016)
INSERT [dbo].[SecurityUserDetail] ([ID], [SecurityUserID], [PrivilegeID]) VALUES (1171, 1062, 2017)
SET IDENTITY_INSERT [dbo].[SecurityUserDetail] OFF
Go


SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SqlInterfaceTabelName](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[TabelName] [nvarchar](200) NOT NULL,
	
 CONSTRAINT [PK_ID] 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


SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SqlInterfaceColumnsName](
	[ColumnsNameID] [int] IDENTITY(1,1) NOT NULL,
	[ColumnsName] [nvarchar](200) NOT NULL,
	
 CONSTRAINT [PK_ColumnsNameID] PRIMARY KEY CLUSTERED 
(
	[ColumnsNameID] 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-08-01---------------------------

------------------------Ali 2019-08-01---------------------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (219, N'Compensation Allowance Types', N'أنواع بدل التعويض', 28, N'/WorkFlow/CompensationAllowanceType', N'Index', NULL, N'get', 18, 1, 1)
Go

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (3447, 219, 1)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3368, N'أنواع بدل التعويض', N'Compensation Allowance Types', 219, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3369, N' عرض أنواع بدل التعويض ', N'View Compensation Allowance Types', 219, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3370, N' إضافة نوع بدل التعويض ', N'Add Compensation Allowance Type', 219, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3371, N' تعديل نوع بدل التعويض ', N'Edit Compensation Allowance Type', 219, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3372, N' حذف نوع بدل التعويض ', N'Delete Compensation Allowance Type', 219, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3373, N' حفظ نوع بدل التعويض ', N'Save Compensation Allowance Type', 219, 2)
Go



SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WF_CompensationAllowanceTypes](
	[CompensationAllowanceTypeCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
	[AllowanceType][nvarchar](100) NOT NULL,
	[Factor][float] NOT NULL,
	[CalculationNumber][float] NOT NULL,
	[AllowanceFactor] int NOT NULL

 CONSTRAINT [PK_CompensationAllowanceTypes] PRIMARY KEY CLUSTERED 
(
	[CompensationAllowanceTypeCode] 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_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WF_FactorType](
	[FactorTypeCode] [int] NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
	

 CONSTRAINT [PK_FactorType] PRIMARY KEY CLUSTERED 
(
	[FactorTypeCode] 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_FactorType] ([FactorTypeCode], [Name], [Arabic_Name]) VALUES (10, N'Mony', N'نقود')
INSERT [dbo].[WF_FactorType] ([FactorTypeCode], [Name], [Arabic_Name]) VALUES (11, N'Days', N'أيام')
INSERT [dbo].[WF_FactorType] ([FactorTypeCode], [Name], [Arabic_Name]) VALUES (12, N'Hours', N'ساعات')
INSERT [dbo].[WF_FactorType] ([FactorTypeCode], [Name], [Arabic_Name]) VALUES (13, N'Minutes', N'دقائق')
Go

------------------------End 2019-08-01---------------------------
------------------------Sayed 2019-08-01-----------------------
CREATE TABLE [dbo].[Penalties](
	[Serial] [float] NOT NULL,
	[EmployeeCode] [int] NULL,
	[PenaltyCode] [smallint] NULL,
	[Once] [tinyint] NULL,
	[Date] [datetime] NULL,
	[Amount] [float] NULL,
	[Period] [tinyint] NULL,
	[PYear] [smallint] NULL,
	[EventDescription] [varchar](1000) NULL,
	[Colsed] [bit] NULL,
	[Abate] [bit] NULL,
	[AddBy] [nvarchar](20) NULL,
	[AddDate] [datetime] NULL,
	[LastChangeBy] [nvarchar](20) NULL,
	[ChangeDate] [datetime] NULL,
	[MainType] [tinyint] NULL,
	[OriginalPYear] [int] NULL,
	[OriginalPeriod] [tinyint] NULL,
	[LinkSerial] [int] NULL,
	[Closed] [bit] NULL,
	[AmountValue] [float] NULL,
	[AccApproved] [int] NULL,
	[DateHijri] [nvarchar](10) NULL,
	[ExpirationDate] [datetime] NULL,
	[ExpirationDateHijri] [nvarchar](10) NULL,
	[EventPlace] [nvarchar](255) NULL,
	[EventTime] [nvarchar](5) NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_Penalties] 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

ALTER TABLE [dbo].[Penalties] ADD  CONSTRAINT [DF_Penalties_Serial]  DEFAULT (0) FOR [Serial]
GO

ALTER TABLE [dbo].[Penalties] ADD  CONSTRAINT [DF_Penalties_EmployeeCode]  DEFAULT (0) FOR [EmployeeCode]
GO

ALTER TABLE [dbo].[Penalties] ADD  CONSTRAINT [DF_Penalties_PenaltyCode]  DEFAULT (0) FOR [PenaltyCode]
GO

ALTER TABLE [dbo].[Penalties] ADD  CONSTRAINT [DF_Penalties_Once]  DEFAULT (0) FOR [Once]
GO

ALTER TABLE [dbo].[Penalties] ADD  CONSTRAINT [DF_Penalties_Amount]  DEFAULT (0) FOR [Amount]
GO

ALTER TABLE [dbo].[Penalties] ADD  CONSTRAINT [DF_Penalties_Period]  DEFAULT (0) FOR [Period]
GO

ALTER TABLE [dbo].[Penalties] ADD  CONSTRAINT [DF_Penalties_PYear]  DEFAULT (0) FOR [PYear]
GO

ALTER TABLE [dbo].[Penalties] ADD  CONSTRAINT [DF_Penalties_Colsed]  DEFAULT (0) FOR [Colsed]
GO

ALTER TABLE [dbo].[Penalties] ADD  CONSTRAINT [DF_Penalties_Abate]  DEFAULT (0) FOR [Abate]
GO

ALTER TABLE [dbo].[Penalties] ADD  CONSTRAINT [DF_Penalties_Closed]  DEFAULT (0) FOR [Closed]
GO
-------------------------------End 2019-08-01-----------------------------------------
-------------------------------Sayed 2019-08-03---------------------------------------

  ALTER TABLE dbo.WF_OverTimeRequest ADD
	FinalApproval tinyint not null default(0),
	FinalApprovalTrackCode int NULL,
	FinalMnutes float NULL,
	FinalMinutesAfterFactor float NULL,
	FinalCost float NULL,
	FinalApprovalDate datetime NULL,
	FinalApprovalDateHijri nvarchar(10) NULL
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'WFOverTimeFinalRequired', N'Final Overtime Approve Required', N'الموافقة النهائية على العمل الإضافي ', N'false', 2, 4, 1, 1, NULL, NULL, 3)
GO
INSERT [dbo].[WF_RequestType] ([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName]) VALUES (20, N'الموافقة النهائية لطلب الوقت الاضافي', N'Final Approval For Overtime Request', 0, N'sayedmustafa1984@gmail.com', N'sayedmustafa1984@gmail.com', N'123', N'smtp.sendgrid.net', 587, N'Sayed')
Go
CREATE TABLE [dbo].[WF_OverTimeRequestFinalSignature](
	[OverTimeRequestFinalSignatureId] [bigint] IDENTITY(1,1) NOT NULL,
	[OverTimeRequestId] [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_OverTimeRequestFinalSignature] PRIMARY KEY CLUSTERED 
(
	[OverTimeRequestFinalSignatureId] 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_OverTimeRequestFinalSignature]  WITH CHECK ADD  CONSTRAINT [FK_WF_OverTimeRequestFinalSignature_SecurityUser] FOREIGN KEY([UserId])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_OverTimeRequestFinalSignature] CHECK CONSTRAINT [FK_WF_OverTimeRequestFinalSignature_SecurityUser]
GO

ALTER TABLE [dbo].[WF_OverTimeRequestFinalSignature]  WITH CHECK ADD  CONSTRAINT [FK_WF_OverTimeRequestFinalSignature_WF_OverTimeRequest] FOREIGN KEY([OverTimeRequestId])
REFERENCES [dbo].[WF_OverTimeRequest] ([OverTimeRequestId])
GO

ALTER TABLE [dbo].[WF_OverTimeRequestFinalSignature] CHECK CONSTRAINT [FK_WF_OverTimeRequestFinalSignature_WF_OverTimeRequest]
GO

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

ALTER TABLE [dbo].[WF_OverTimeRequestFinalSignature] CHECK CONSTRAINT [FK_WF_OverTimeRequestFinalSignature_WF_RequestStatus]
GO
---------------------------------------End 2019-08-03--------------------------------------------

---------------------------------------Ali 2019-08-04--------------------------------------------


ALTER TABLE WF_CompensationAllowanceTypes
ADD FactorTypeCode [int] NOT NULL ;
Go


ALTER TABLE [dbo].[WF_CompensationAllowanceTypes]  WITH CHECK ADD  CONSTRAINT [FK_WF_CompensationAllowanceTypes_WF_FactorType] FOREIGN KEY([FactorTypeCode])
REFERENCES [dbo].[WF_FactorType] ([FactorTypeCode])
GO

ALTER TABLE WF_CompensationAllowanceTypes
DROP COLUMN AllowanceFactor;

  ALTER TABLE [WF_CompensationAllowanceTypes]
    ALTER COLUMN AllowanceType int not null;

---------------------------------------End 2019-08-04--------------------------------------------
---------------------------------------Ali 2019-08-05--------------------------------------------

alter table WF_CompensationAllowanceTypes
	ADD ItemNumber [int] null
	Go

	alter table WF_CompensationAllowanceTypes
	ADD VacationType [tinyint] not null
	Go
	   	  
---------------------------------------End 2019-08-05--------------------------------------------
---------------------------------------Sayed 2019-08-05-----------------------------------------
INSERT [dbo].[Religion] ([ReligionCode], [Name], [Arabic_Name], [MDT]) VALUES (1, N'Moslem', N'مسلم', NULL)
GO
INSERT [dbo].[Religion] ([ReligionCode], [Name], [Arabic_Name], [MDT]) VALUES (2, N'Christian', N'مسيحى', NULL)
GO
INSERT [dbo].[Religion] ([ReligionCode], [Name], [Arabic_Name], [MDT]) VALUES (3, N'Juish', N'يهودى', NULL)
GO
INSERT [dbo].[Religion] ([ReligionCode], [Name], [Arabic_Name], [MDT]) VALUES (4, N'Others', N'أُخرى', NULL)
GO
---------------------------------------End 2019-08-05--------------------------------------------
---------------------------------------Hammad 2019-08-07-----------------------------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'WFNewHireCheckIsOverBudget', N'Check Salary Between Max and Mini', N'التحقق ان الراتب بين الحد الاقصى والادنى', N'true', 2, 6, 1, 1, NULL, NULL, 5)

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'WFPromotionCheckIsOverBudget', N'Check Salary Between Max and Mini', N'التحقق ان الراتب بين الحد الاقصى والادنى', N'true', 2, 3, 1, 1, NULL, NULL, 10)

  EXEC sp_RENAME 'WF_NewHireRequest.WorkHeelIssueDate' , 'CubeIssueDate', 'COLUMN'
  EXEC sp_RENAME 'WF_NewHireRequest.WorkHeelIssuePlace' , 'CubeIssuePlace', 'COLUMN'
  EXEC sp_RENAME 'WF_NewHireRequest.WorkHeelResendDate' , 'CubeSavedDate', 'COLUMN'
  ALTER TABLE dbo.WF_OverTimeRequestFinalSignature ADD
	ActualMinutes float(53) NULL
   GO
    EXEC sp_RENAME 'WF_OverTimeRequest.FinalMnutes' , 'FinalMinutes', 'COLUMN'
---------------------------------------End 2019-08-07-----------------------------------------

---------------------------------------Ali 2019-08-07-----------------------------------------


SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WF_CompensationRequestForADayOfRest](
	[CompensationRequestForADayOfRestId] [bigint] IDENTITY(1,1) NOT NULL,
	[EmployeeCode] [int] NOT NULL,
	[DepartmentApproval] [tinyint] NOT NULL,
	[HRApproval] [tinyint] NOT NULL,
	[HRApprovalUserId] [int] NULL,
	[HRApprovalDate] [datetime] NULL,
	[HRApprovalComment] [nvarchar](255) NULL,
	[RequesStatus] [tinyint] NULL,
	[CancelRequestNumber] [bigint] NULL,
	[AddDateHijri] [nvarchar](10) NOT NULL,
	[HRApprovalDateHijri] [nvarchar](10) NULL,
	[TrackCode] [int] NOT NULL,
	[RequestDate] [datetime] NOT NULL,
	[RequestDateHijri] [nvarchar](10) NOT NULL,
	[RequestReason] [nvarchar](200) NULL,
	[CompensationType] [nvarchar](150) NOT NULL,
	[AllowanceType] [int] NOT NULL,
	[Factor] [float] NOT NULL,
	[FactorTypeCode] [tinyint] NOT NULL,
	[RecordAddBy] [int] NOT NULL,
	[RecordAddDate] [datetime] NOT NULL,
	[RecordLastChangeBy] [int] NULL,
	[RecordChangeDate] [datetime] NULL,
	[Closed] [bit] NULL,
	[MainType] [tinyint] NOT NULL,
	[ItemNumber] [int] NULL,
 CONSTRAINT [PK_WF_CompensationRequestForADayOfRest] PRIMARY KEY CLUSTERED 
(
	[CompensationRequestForADayOfRestId] 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_CompensationRequestForADayOfRest] ADD  CONSTRAINT [DF_WF_CompensationRequestForADayOfRest_Closed]  DEFAULT ((0)) FOR [Closed]
GO

ALTER TABLE [dbo].[WF_CompensationRequestForADayOfRest] ADD  CONSTRAINT [DF_WF_CompensationRequestForADayOfRest_MainType]  DEFAULT ((0)) FOR [MainType]
GO

ALTER TABLE [dbo].[WF_CompensationRequestForADayOfRest]  WITH CHECK ADD  CONSTRAINT [FK_WF_CompensationRequestForADayOfRest_Employees] FOREIGN KEY([EmployeeCode])
REFERENCES [dbo].[Employees] ([EmployeeCode])
GO

ALTER TABLE [dbo].[WF_CompensationRequestForADayOfRest] CHECK CONSTRAINT [FK_WF_CompensationRequestForADayOfRest_Employees]
GO

ALTER TABLE [dbo].[WF_CompensationRequestForADayOfRest]  WITH CHECK ADD  CONSTRAINT [FK_WF_CompensationRequestForADayOfRest_SecurityUser] FOREIGN KEY([RecordAddBy])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_CompensationRequestForADayOfRest] CHECK CONSTRAINT [FK_WF_CompensationRequestForADayOfRest_SecurityUser]
GO

ALTER TABLE [dbo].[WF_CompensationRequestForADayOfRest]  WITH CHECK ADD  CONSTRAINT [FK_WF_CompensationRequestForADayOfRest_SecurityUser1] FOREIGN KEY([HRApprovalUserId])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_CompensationRequestForADayOfRest] CHECK CONSTRAINT [FK_WF_CompensationRequestForADayOfRest_SecurityUser1]
GO

ALTER TABLE [dbo].[WF_CompensationRequestForADayOfRest]  WITH CHECK ADD  CONSTRAINT [FK_WF_CompensationRequestForADayOfRest_SecurityUser2] FOREIGN KEY([RecordLastChangeBy])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_CompensationRequestForADayOfRest] CHECK CONSTRAINT [FK_WF_CompensationRequestForADayOfRest_SecurityUser2]
GO

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

ALTER TABLE [dbo].[WF_CompensationRequestForADayOfRest] CHECK CONSTRAINT [FK_WF_CompensationRequestForADayOfRest_WF_RequestStatus]
GO

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

ALTER TABLE [dbo].[WF_CompensationRequestForADayOfRest] CHECK CONSTRAINT [FK_WF_CompensationRequestForADayOfRest_WF_RequestStatus1]
GO

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

ALTER TABLE [dbo].[WF_CompensationRequestForADayOfRest] CHECK CONSTRAINT [FK_WF_CompensationRequestForADayOfRest_WF_Track]
GO








SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

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

ALTER TABLE [dbo].[WF_CompensationRequestForADayOfRestSignature] CHECK CONSTRAINT [FK_WF_CompensationRequestForADayOfRestSignature_SecurityUser]
GO

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

ALTER TABLE [dbo].[WF_CompensationRequestForADayOfRestSignature] CHECK CONSTRAINT [FK_WF_CompensationRequestForADayOfRestSignature_WF_CompensationRequestForADayOfRest]
GO

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

ALTER TABLE [dbo].[WF_CompensationRequestForADayOfRestSignature] CHECK CONSTRAINT [FK_WF_CompensationRequestForADayOfRestSignature_WF_RequestStatus]
GO




INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (220, N'Compensation Request For A Day Of Rest', N'طلب تعويض عن يوم راحه', 29, N'/WorkFlow/CompensationRequestForADayOfRest', N'Index', NULL, N'get', 34, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (221, N'Compensation Request For A Day Of Rest Signature', N'اعتماد طلب تعويض عن يوم راحه', 108, N'/WorkFlow/CompensationDayOfRestRequestSignature', N'Index', NULL, N'get', 35, 1, 1)
Go

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (3448, 220, 1)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (3449, 221, 1)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF



INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3374, N'طلب تعويض عن يوم راحة', N'Compensation Request For A Day Of Rest', 220, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3375, N'عرض طلب تعويض عن يوم راحة', N'View Compensation Request For A Day Of Rest', 220, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3376, N'إضافة طلب تعويض عن يوم راحة', N'Add Compensation Request For A Day Of Rest', 220, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3377, N'تعديل طلب تعويض عن يوم راحة', N'Edit Compensation Request For A Day Of Rest', 220, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3378, N'حذف طلب تعويض عن يوم راحة', N'Delete Compensation Request For A Day Of Rest', 220, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3379, N'إلغاء طلب تعويض عن يوم راحة', N'Cancel Compensation Request For A Day Of Rest', 220, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3380, N'حفظ طلب تعويض عن يوم راحة', N'Save Compensation Request For A Day Of Rest', 220, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3381, N'اعتماد طلب تعويض عن يوم راحه', N'Compensation Day Of Rest Request Signature', 221, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3382, N'عرض اعتماد طلب تعويض عن يوم راحه', N'View Compensation Day Of Rest Request Signature', 221, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3383, N'تعديل اعتماد طلب تعويض عن يوم راحه', N'Edit Compensation Day Of Rest Request Signature', 221, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3384, N'حفظ اعتماد طلب تعويض عن يوم راحه', N'Save Compensation Day Of Rest Request Signature', 221, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3385, N'حفظ متعدد طلب تعويض يوم راحه', N'Save Multiple Compensation Day Of Rest Request ', 221, 2)
Go




SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (124, N'Compensation Request For A Day Of Rest Sending', N'إرسال طلب تعويض عن يوم راحة', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (125, N'Compensation Request For A Day Of Rest Accept', N'الموافقة على طلب تعويض عن يوم راحة', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (126, N'Compensation Request For A Day Of Rest Refuse', N'رفض طلب تعويض عن يوم راحة', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (127, N'Compensation Request For A Day Of 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 (124, N'Compensation Request For A Day Of Rest Sending', N'إرسال طلب تعويض عن يوم راحة', 124, N'إرسال طلب تعويض عن يوم راحة', N'<p>&nbsp;</p><p>نرجو الموافقة على طلب </p>', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (125, N'Compensation Request For A Day Of Rest Accept', N'الموافقة على طلب تعويض عن يوم راحة', 125, N'الموافقة على طلب تعويض عن يوم راحة', N'<p>نرجو الموافقة على طلب </p>', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (126, N'Compensation Request For A Day Of Rest Refuse', N'رفض طلب تعويض عن يوم راحة', 126, N'رفض طلب تعويض عن يوم راحة', N'<p>تم رفض الطلب </p>', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (127, N'Compensation Request For A Day Of Cancellation', N'إلغاء طلب تعويض عن يوم راحة', 127, N'إلغاء طلب تعويض عن يوم راحة', N'<p>تم الغاء الطلب </p>', 1, NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF
Go


Go


INSERT [dbo].[WF_RequestType] ([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate]) VALUES (21, N'طلب تعويض عن يوم راحه', N'Compensation Request For A Day Of Rest', 0, N'sayedmustafa1984@gmail.com', N'sayedmustafa1984@gmail.com', N'123', N'smtp.sendgrid.net', 587, N'Sayed', 2, 2)
Go

---------------------------------------End 2019-08-07-----------------------------------------


