﻿
	-----------------------------Hammad 2019-01-01-----------------------------------------

CREATE TABLE [dbo].[Rec_EvaluationInterviewStage](
	[EvaluationInterviewStageCode] [int] IDENTITY(1,1) NOT NULL,
	[PersonalInterviewStageCode] [int] NOT NULL,
	[EvaluationParameterCode] [int] NOT NULL,
 CONSTRAINT [PK_Rec_EvaluationInterviewStage] PRIMARY KEY CLUSTERED 
(
	[EvaluationInterviewStageCode] 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].[Rec_EvaluationInterviewStage]  WITH CHECK ADD  CONSTRAINT [FK_Rec_EvaluationInterviewStage_Rec_EvaluationParameter] FOREIGN KEY([EvaluationParameterCode])
REFERENCES [dbo].[Rec_EvaluationParameter] ([EvaluationParameterCode])
GO

ALTER TABLE [dbo].[Rec_EvaluationInterviewStage] CHECK CONST   RAINT [FK_Rec_EvaluationInterviewStage_Rec_EvaluationParameter]
GO

ALTER TABLE [dbo].[Rec_EvaluationInterviewStage]  WITH CHECK ADD  CONSTRAINT [FK_Rec_EvaluationInterviewStage_Rec_PersonalInterviewStages] FOREIGN KEY([PersonalInterviewStageCode])
REFERENCES [dbo].[Rec_PersonalInterviewStages] ([PersonalInterviewStageCode])
GO

ALTER TABLE [dbo].[Rec_EvaluationInterviewStage] CHECK CONSTRAINT [FK_Rec_EvaluationInterviewStage_Rec_PersonalInterviewStages]
GO

  
CREATE TABLE [dbo].[Rec_JobApplyingStageEvaluation](
	[JobApplyingStageEvaluationCode] [int] IDENTITY(1,1) NOT NULL,
	[JobApplyingStageDetailCode] [int] NOT NULL,
	[EvaluationInterviewStageCode] [int] NOT NULL,
	[ParameterValue] [nvarchar](100) NULL,
 CONSTRAINT [PK_Rec_JobApplyingStageEvaluation] PRIMARY KEY CLUSTERED 
(
	[JobApplyingStageEvaluationCode] 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].[Rec_JobApplyingStageEvaluation]  WITH CHECK ADD  CONSTRAINT [FK_Rec_JobApplyingStageEvaluation_Rec_EvaluationInterviewStage] FOREIGN KEY([EvaluationInterviewStageCode])
REFERENCES [dbo].[Rec_EvaluationInterviewStage] ([EvaluationInterviewStageCode])
GO

ALTER TABLE [dbo].[Rec_JobApplyingStageEvaluation] CHECK CONSTRAINT [FK_Rec_JobApplyingStageEvaluation_Rec_EvaluationInterviewStage]
GO

ALTER TABLE [dbo].[Rec_JobApplyingStageEvaluation]  WITH CHECK ADD  CONSTRAINT [FK_Rec_JobApplyingStageEvaluation_Rec_JobApplyingStageDetail] FOREIGN KEY([JobApplyingStageDetailCode])
REFERENCES [dbo].[Rec_JobApplyingStageDetail] ([JobApplyingStageDetailCode])
GO

ALTER TABLE [dbo].[Rec_JobApplyingStageEvaluation] CHECK CONSTRAINT [FK_Rec_JobApplyingStageEvaluation_Rec_JobApplyingStageDetail]
GO



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (159, N'Recruitment Dashboard', N'áæÍÉ ÇáÊæÙíÝ', 103, N'/Recruitment/RecruitmentDashboard', N'Index', N'fa fa-thumb-tack', N'get', 5, 1, 1)
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (7031, N'áæÍÉ ÇáÊæÙíÝ', N'Recruitment Dashboard', 159, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (7032, N'ÚÑÖ áæÍÉ ÇáÊæÙíÝ', N'View Recruitment Dashboard', 159, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (7033, N'ÚÑÖ ÚÏÏ ÇáãÞÈæáíä æÇáãÑÝæÖíä Ýí ÇáæÙÇÆÝ', N' View Number of accepted and rejected in jobs', 159, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (7034, N'ÚÑÖ ÚÏÏ ÇáãÞÈæáíä æÇáãÑÝæÖ Ýí ãÑÇÍá ÇáÊæÙíÝ', N'View Number of accepted and rejected in stage', 159, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (7035, N'ÚÑÖ ÚÏÏ ÇáãÑÓá áåã ÇáÚÑÖ ÇáæÙíÝí', N' View Number of Candidates have job offer', 159, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (7036, N'ÚÑÖ ÚÏÏ ÇáãÑÔÍíä  ÇáÐíä Êã ÊÚííäåã', N'View Number of candidates recruited', 159, 2)
GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1251, 159, 5)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF

	-----------------------------END 2019-01-01------------------------------------------
	-----------------------------skeshta 2019-01-02--------------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (160, N'Change Requests Signatures', N'ÊÛííÑ ÇáÇÚÊãÇÏÇÊ ááØáÈÇÊ', 108, N'/WorkFlow/ChangeRequestsSignatures', N'Index', N'fa fa-thumb-tack', N'get', 33, 1, 1)
GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (226, 160, 1)
GO
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3311, N'ÊÛííÑ ÇáÇÚÊãÇÏÇÊ ááØáÈÇÊ', N'Change Requests Signatures', 160, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3312, N'ÚÑÖ ÊÛííÑ ÇáÇÚÊãÇÏÇÊ ááØáÈÇÊ', N'View Change Requests Signatures', 160, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3313, N'ÍÝÙ ÊÛííÑ ÇáÇÚÊãÇÏÇÊ ááØáÈÇÊ', N'Save Change Requests Signatures', 160, 2)
GO

	-----------------------------END 2019-01-02------------------------------------------
	-----------------------------skeshta 2019-01-03--------------------------------------
	
alter table [dbo].[WF_PermissionRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

alter table [dbo].[WF_OverTimeRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

alter table [dbo].[WF_OverTimeSymphonyRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

alter table [dbo].[WF_AirTicketRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

alter table [dbo].[WF_NewHireRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

alter table [dbo].[WF_FingerPrintRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

alter table [dbo].[WF_ResignationRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

alter table [dbo].[WF_CasualRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

alter table [dbo].[WF_LoanRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

alter table [dbo].[WF_PromotionRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

alter table [dbo].[WF_VacationRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

alter table [dbo].[WF_MaintenanceRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

alter table [dbo].[WF_PenaltyRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

alter table [dbo].[WF_NewEmployeesRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

alter table [dbo].[WF_BonusRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

alter table [dbo].[WF_VehicleRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

alter table [dbo].[WF_DisclaimerRequestSignature] add
	[OldUserCode] int null,
	[ChangedBy] int null,
	[ChangeDate] datetime null
GO

	-----------------------------END 2019-01-03------------------------------------------
	-----------------------------Hammad 2019-01-03---------------------------------------

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate]) VALUES (N'WFVacationReplacementEmployeeRequired', N'Replacement Employee Required On Vacation', N'ÇáãæÙÝ ÇáÈÏíá ÇáÒÇãì Ýì ØáÈ ÇáÇÌÇÒÉ', N'false', 2, 32, 1, 1, NULL, NULL)
GO

	-----------------------------End 2019-01-03------------------------------------------
	-----------------------------Hammad 2019-01-06---------------------------------------

ALTER TABLE dbo.Rec_ApplyForJob ADD
	HaveQuestion bit NULL,
	killerQuestion tinyint NULL
GO

	-----------------------------End 2019-01-06------------------------------------------
	-----------------------------skeshta 2019-01-07--------------------------------------
	
SET IDENTITY_INSERT [dbo].[AppModule] ON 
GO
INSERT [dbo].[AppModule] ([AppModuleCode], [Name], [Arabic_Name], [IsLicensed], [LicenseNumber]) VALUES (8, N'Appraisal', N'ÇáÊÞííã', 1, NULL)
GO
SET IDENTITY_INSERT [dbo].[AppModule] OFF
GO

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (161, N'Appraisal', N'ÇáÊÞííã', NULL, NULL, NULL, N'fa fa-puzzle-piece', N'get', 14, 1, 1)
GO
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (162, N'Appraisal Categories', N'ÝÆÇÊ ÇáÊÞííã', 161, N'/Appraisal/AppraisalCategory', N'Index', N'fa fa-thumb-tack', N'get', 1, 1, 1)
GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (227, 161, 8)
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (228, 162, 8)
GO
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10000, N'ÇáÊÞííã', N'Appraisal', 161, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10001, N'ÝÆÇÊ ÇáÊÞííã', N'Appraisal Categories', 162, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10002, N'ÚÑÖ ÝÆÇÊ ÇáÊÞííã', N'View Appraisal Categories', 162, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10003, N'ÅÖÇÝÉ ÝÆÇÊ ÇáÊÞííã', N'Add Appraisal Categories', 162, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10004, N'ÊÚÏíá ÝÆÇÊ ÇáÊÞííã', N'Edit Appraisal Categories', 162, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10005, N'ÍÝÙ ÝÆÇÊ ÇáÊÞííã', N'Save Appraisal Categories', 162, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10006, N'ÍÐÝ ÝÆÇÊ ÇáÊÞííã', N'Delete Appraisal Categories', 162, 2)
GO


/****** Object:  Table [dbo].[Appraisal_CalculationMethod]    Script Date: 07/01/2019 12:46:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Appraisal_CalculationMethod](
	[CalculationMethodCode] [smallint] IDENTITY(1,1) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
 CONSTRAINT [PK_Appraisal_CalculationMethod] PRIMARY KEY CLUSTERED 
(
	[CalculationMethodCode] 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].[Appraisal_AppraisalCategory]    Script Date: 07/01/2019 12:47:05 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Appraisal_AppraisalCategory](
	[AppraisalCategoryCode] [int] IDENTITY(1,1) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[IsCalculated] [bit] NOT NULL,
	[CalculationMethodCode] [smallint] NOT NULL,
	[CategoryTypeCode] [smallint] NOT NULL,
	[AppraisalGrade] [int] NOT NULL,
	[MinPerformanceIndicatorElements] [smallint] NOT NULL,
	[MinCompetencyElements] [smallint] NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[CreationDateHijri] [nvarchar](10) NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
	[ModificationDateHijri] [nvarchar](10) NULL,
 CONSTRAINT [PK_Appraisal_AppraisalCategory] PRIMARY KEY CLUSTERED 
(
	[AppraisalCategoryCode] 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].[Appraisal_AppraisalCategory]  WITH CHECK ADD  CONSTRAINT [FK_Appraisal_AppraisalCategory_Appraisal_CalculationMethod] FOREIGN KEY([CalculationMethodCode])
REFERENCES [dbo].[Appraisal_CalculationMethod] ([CalculationMethodCode])
GO

ALTER TABLE [dbo].[Appraisal_AppraisalCategory] CHECK CONSTRAINT [FK_Appraisal_AppraisalCategory_Appraisal_CalculationMethod]
GO

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

ALTER TABLE [dbo].[Appraisal_AppraisalCategory] CHECK CONSTRAINT [FK_Appraisal_AppraisalCategory_CreatorUser]
GO

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

ALTER TABLE [dbo].[Appraisal_AppraisalCategory] CHECK CONSTRAINT [FK_Appraisal_AppraisalCategory_ModifierUser]
GO

	-----------------------------End 2019-01-07------------------------------------------
------------------------------Hammad 2019-01-07---------------------------------------
  ALTER TABLE dbo.Rec_RecruitJob ADD
	CreationDate datetime NULL,
	CreationDateHijri nvarchar(10) NULL,
	CreatedBy int NULL,
	ModifiedBy int NULL,
	ModificationDate datetime NULL,
	ModificationDateHijri nvarchar(10) NULL
GO
-----------------------------End 2019-01-07------------------------------------------
------------------------------Hammad 2019-01-09---------------------------------------

CREATE TABLE [dbo].[Branch](
	[BranchCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](100) NOT NULL,
	[Arabic_Name] [nvarchar](100) NOT NULL,
	[DataBaseName] [nvarchar](50) NOT NULL,
	[ServerName] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Branch] PRIMARY KEY CLUSTERED 
(
	[BranchCode] 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 IDENTITY_INSERT [dbo].[AppModule] ON 
INSERT [dbo].[AppModule] ([AppModuleCode], [Name], [Arabic_Name], [IsLicensed], [LicenseNumber]) VALUES (9, N'Consolidated Dashboard', N'áæÍÉ ÇáÈíÇäÇÊ ÇáãæÍÏÉ', 1, NULL)
SET IDENTITY_INSERT [dbo].[AppModule] OFF

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (163, N'Consolidated Dashboard', N'áæÍÉ ÇáÈíÇäÇÊ ÇáãæÍÏÉ', NULL, NULL, NULL, N'fa fa-tachometer', N'get', 13, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (164, N'Branches', N'ÇáÝÑæÚ', 163, N'/ConsolidatedDashboard/Branch', N'Index', N'fa fa-thumb-tack', N'get', 1, 1, 1)

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 

INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1252, 163, 9)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1253, 164, 9)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11000, N'áæÍÉ ÇáÈíÇäÇÊ ÇáãæÍÏÉ', N'Consolidated Dashboard', 163, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11001, N'ÇáÝÑæÚ', N'Branches', 164, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11002, N'ÚÑÖ ÇáÝÑÚ', N'View Branch', 164, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11003, N'ÊÚÏíá ÇáÝÑÚ', N'Edit Branch', 164, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11004, N'ÍÝÙ ÇáÝÑÚ', N'Save  Branch', 164, 2)
GO


CREATE TABLE [dbo].[SecurityUserBranch](
	[SecurityUserBranchCode] [int] IDENTITY(1,1) NOT NULL,
	[SecurityUserCode] [int] NOT NULL,
	[BranchCode] [int] NOT NULL,
 CONSTRAINT [PK_SecurityUserBranches] PRIMARY KEY CLUSTERED 
(
	[SecurityUserBranchCode] 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].[SecurityUserBranch]  WITH CHECK ADD  CONSTRAINT [FK_SecurityUserBranch_Branch] FOREIGN KEY([BranchCode])
REFERENCES [dbo].[Branch] ([BranchCode])
GO

ALTER TABLE [dbo].[SecurityUserBranch] CHECK CONSTRAINT [FK_SecurityUserBranch_Branch]
GO

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

ALTER TABLE [dbo].[SecurityUserBranch] CHECK CONSTRAINT [FK_SecurityUserBranch_SecurityUser]
GO


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (165, N'Branches Privileges', N'ÕáÇÍíÇÊ ÇáÝÑæÚ', 163, N'/ConsolidatedDashboard/BranchPrivileges', N'Index', N'fa fa-thumb-tack', N'get', 2, 1, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11005, N'ÕáÇÍíÇÊ ÇáÝÑæÚ', N'Branches Privileges', 165, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11006, N'ÚÑÖ ÕáÇÍíÇÊ ÇáÝÑæÚ', N'View Branches Privileges', 165, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11007, N'ÍÝÙ ÕáÇÍíÇÊ ÇáÝÑæÚ', N'Save Branches Privileges', 165, 2)
GO

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

------------------------------End 2019-01-09---------------------------------------------
------------------------------skeshta 2019-01-09-----------------------------------------

DROP TABLE [dbo].[Appraisal_AppraisalCategory]
GO

DROP TABLE [dbo].[Appraisal_CalculationMethod]
GO

------------------------------End 2019-01-10---------------------------------------------
------------------------------Hammad 2019-01-14---------------------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (166, N'Appraisal Category For Department', N'ÝÆÉ ÇáÊÞííã ááÅÏÇÑÉ', 161, N'/Appraisal/AppraisalCategoryDepartment', N'Index', N'fa fa-thumb-tack', N'get', 2, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10007, N'ÝÆÉ ÇáÊÞííã ááÅÏÇÑÉ', N'Appraisal Category Department', 166, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10008, N'ÚÑÖ ÝÆÉ ÇáÊÞííã ááÅÏÇÑÉ', N'View Appraisal Category Department', 166, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10009, N'ÍÝÙ ÝÆÉ ÇáÊÞííã ááÅÏÇÑÉ', N' Save Appraisal Category Department', 166, 2)
Go

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

------------------------------End 2019-01-14---------------------------------------------
------------------------------skeshta 2019-01-15-----------------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (167, N'Appraisal Elements', N'ÚäÇÕÑ ÇáÊÞííã', 161, N'/Appraisal/AppraisalElement', N'Index', N'fa fa-thumb-tack', N'get', 3, 1, 1)
GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (229, 167, 8)
GO
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10010, N'ÚäÇÕÑ ÇáÊÞííã', N'Appraisal Elements', 167, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10011, N'ÚÑÖ ÚäÇÕÑ ÇáÊÞííã', N'View Appraisal Elements', 167, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10012, N'ÅÖÇÝÉ ÚäÇÕÑ ÇáÊÞííã', N'Add Appraisal Elements', 167, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10013, N'ÊÚÏíá ÚäÇÕÑ ÇáÊÞííã', N'Edit Appraisal Elements', 167, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10014, N'ÍÝÙ ÚäÇÕÑ ÇáÊÞííã', N'Save Appraisal Elements', 167, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10015, N'ÍÐÝ ÚäÇÕÑ ÇáÊÞííã', N'Delete Appraisal Elements', 167, 2)
GO

------------------------------End 2019-01-15---------------------------------------------
------------------------------Hammad 2019-01-16---------------------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (168, N'Personnel Dashboard', N'áæÍÉ ÔÆæä ÇáãæÙÝíä', 163, N'/ConsolidatedDashboard/Personnel', N'Index', N'fa fa-thumb-tack', N'get', 3, 1, 1)
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11008, N'ÚÑÖ áæÍÉ ÔÆæä ÇáãæÙÝíä  ÇáãÌãÚÉ', N'View Consolidated Personnel Dashboard', 168, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11009, N'ÊæÒíÚ ÇáãæÙÝíä', N'View Employee Distribution ', 168, 2)
Go

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

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (169, N'Payroll Dashboard', N'áæÍÉÇáÃÌæÑ', 163, N'/ConsolidatedDashboard/Payroll', N'Index', N'fa fa-thumb-tack', N'get', 4, 1, 1)
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11010, N'ÚÑÖ áæÍÉÇáÃÌæÑ ÇáãÌãÚÉ', N'View Consolidated Payroll Dashboard', 169, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11011, N' ÚÑÖ ÃÌæÑ ÇáãæÙÝíä', N'View Employee Cost Distribution ', 169, 2)
Go

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1257, 169, 9)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
go

------------------------------End 2019-01-16---------------------------------------------
------------------------------Sayed 2019-01-16-------------------------------------------

  insert into ConfigParameter([ConfigKey],[Name],[Arabic_Name],[ConfigValue],[ConfigCategoryCode],[OrderNo],[ConfigType],[IsVisible])
  values('VacEmployeeReplacement','Show Employee Replacement By',N'ÚÑÖ ÇáãæÙÝ ÇáÈÏíá ÈæÇÓØÉ',30,2,34,6,1)
  go
  insert into [ConfigLookup] ([ConfigLookupCode],[Name],[Arabic_Name],[ConfigKey]) values(30,'Division',N'ÇáÞØÇÚ','VacEmployeeReplacement')
  go
   insert into [ConfigLookup] ([ConfigLookupCode],[Name],[Arabic_Name],[ConfigKey]) values(31,'Department',N'ÇáÇÏÇÑÉ','VacEmployeeReplacement')
  go
   insert into [ConfigLookup] ([ConfigLookupCode],[Name],[Arabic_Name],[ConfigKey]) values(32,'Section',N'ÇáÞÓã','VacEmployeeReplacement')
  go
  
-------------------------End 2019-01-16--------------------------------------------
------------------------------skeshta 2019-01-17-----------------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (170, N'Departments Appraisal Elements', N'ÚäÇÕÑ ÇáÊÞííã ááÅÏÇÑÇÊ', 161, N'/Appraisal/DepartmentAppraisalElement', N'Index', N'fa fa-thumb-tack', N'get', 4, 1, 1)
GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (230, 170, 8)
GO
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10016, N'ÚäÇÕÑ ÇáÊÞííã ááÅÏÇÑÇÊ', N'Departments Appraisal Elements', 170, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10017, N'ÚÑÖ ÚäÇÕÑ ÇáÊÞííã ááÅÏÇÑÇÊ', N'View Departments Appraisal Elements', 170, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10018, N'ÍÝÙ ÚäÇÕÑ ÇáÊÞííã ááÅÏÇÑÇÊ', N'Save Departments Appraisal Elements', 170, 2)
GO

Update [dbo].[SystemMenu]
Set Name = N'Departments Appraisal Categories', Arabic_Name = N'فئات التقييم للادارات'
Where SystemMenuCode = 166
GO

Update [dbo].[SecurityPrivilege]
Set DescriptionEN = N'Departments Appraisal Categories', DescriptionAR = N'فئات التقييم للادارات'
Where ID = 10007
GO

Update [dbo].[SecurityPrivilege]
Set DescriptionEN = N'View Departments Appraisal Categories', DescriptionAR = N'عرض فئات التقييم للادارات'
Where ID = 10008
GO

Update [dbo].[SecurityPrivilege]
Set DescriptionEN = N'Save Departments Appraisal Categories', DescriptionAR = N'حفظ فئات التقييم للادارات'
Where ID = 10009
GO

------------------------------End 2019-01-17---------------------------------------------
------------------------------Hammad 2019-01-17---------------------------------------------		


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11012, N'ÇáÍÖæÑ Çáíæãì', N'View Daily Attandance ', 168, 2)
Go

------------------------------End 2019-01-17---------------------------------------------
------------------------------Hammad 2019-01-20---------------------------------------------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11013, N'ÚÑÖ ÅÍÕÇÁÇÊ ÇáãæÙÝíä', N'View Employees Statistics ', 168, 2)
Go
ALTER TABLE dbo.Branch ADD
	BranchColor nvarchar(30) NULL
GO
------------------------------End 2019-01-20---------------------------------------------
------------------------------skeshta 2019-01-20-----------------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (171, N'Departments Relationships', N'ÇáÚáÇÞÇÊ Èíä ÇáÅÏÇÑÇÊ', 161, N'/Appraisal/DepartmentRelationship', N'Index', N'fa fa-thumb-tack', N'get', 5, 1, 1)
GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (231, 171, 8)
GO
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10019, N'ÇáÚáÇÞÇÊ Èíä ÇáÅÏÇÑÇÊ', N'Departments Relationships', 171, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10020, N'ÚÑÖ ÇáÚáÇÞÇÊ Èíä ÇáÅÏÇÑÇÊ', N'View Departments Relationships', 171, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10021, N'ÍÝÙ ÇáÚáÇÞÇÊ Èíä ÇáÅÏÇÑÇÊ', N'Save Departments Relationships', 171, 2)
GO

-------------------------End 2019-01-20--------------------------------------------------
------------------------------skeshta 2019-01-21-----------------------------------------

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11014, N'ãÚÏáÇÊ ÑÓæã ÇáÎÏãÉ', N'Service Charge Rates', 169, 2)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11015, N'ÅÍÕÇÁÇÊ ÇáÑæÇÊÈ ááãæÙÝíä', N'Employees Salary Statistics', 169, 2)
Go

------------------------------End 2019-01-21---------------------------------------------
------------------------------Hammad 2019-01-22---------------------------------------------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES 
(11016, N'ÚÑÖ ÅÔÚÇÑÇÊ ÅäÊåÇÁ ÇáÕáÇÍíÉ', N'Expiry Notification View', 168, 2)
Go

------------------------------End 2019-01-22---------------------------------------------
------------------------------skeshta 2019-01-22-----------------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (172, N'Customer Licenses', N'ÊÑÇÎíÕ ÇáÚãíá', 4, N'/CompanyLicense', N'Index', N'fa fa-thumb-tack', N'get', 7, 1, 0)
GO

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

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1111, N'ÊÑÇÎíÕ ÇáÚãíá', N'Customer Licenses', 172, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1112, N'ÚÑÖ ÊÑÇÎíÕ ÇáÚãíá', N'View Customer Licenses', 172, 2)
GO

------------------------------End 2019-01-22---------------------------------------------

------------------------------Hammad 2019-01-23---------------------------------------------


CREATE TABLE [dbo].[WF_ChangeDayoffRequest](
	[ChangeDayoffRequestId] [bigint] IDENTITY(1,1) NOT NULL,
	[EmployeeId] [int] NOT NULL,
	[RecordAddBy] [int] NOT NULL,
	[RecordAddDate] [datetime] NOT NULL,
	[AddDateHijri] [nvarchar](10) NOT NULL,
	[DepartmentApproval] [tinyint] NOT NULL,
	[RequesStatus] [tinyint] NULL,
	[CancelRequestNumber] [bigint] NULL,
	[TrackCode] [int] NOT NULL,
	[RequestDate] [datetime] NOT NULL,
	[RequestDateHijri] [nvarchar](10) NOT NULL,
	[RecordLastChangeBy] [int] NULL,
	[RecordChangeDate] [datetime] NULL,
	[Closed] [bit] NULL CONSTRAINT [DF_WF_ChangeDayoffRequest_Closed]  DEFAULT ((0)),
	[MainType] [tinyint] NOT NULL CONSTRAINT [DF_WF_ChangeDayoffRequest_MainType]  DEFAULT ((0)),
	[Notes] [nvarchar](500) NULL,
 CONSTRAINT [PK_WF_ChangeDayoffRequest] PRIMARY KEY CLUSTERED 
(
	[ChangeDayoffRequestId] 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_ChangeDayoffRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_ChangeDayoffRequest_Employees] FOREIGN KEY([EmployeeId])
REFERENCES [dbo].[Employees] ([EmployeeCode])
GO

ALTER TABLE [dbo].[WF_ChangeDayoffRequest] CHECK CONSTRAINT [FK_WF_ChangeDayoffRequest_Employees]
GO

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

ALTER TABLE [dbo].[WF_ChangeDayoffRequest] CHECK CONSTRAINT [FK_WF_ChangeDayoffRequest_SecurityUser]
GO

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

ALTER TABLE [dbo].[WF_ChangeDayoffRequest] CHECK CONSTRAINT [FK_WF_ChangeDayoffRequest_SecurityUser2]
GO

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

ALTER TABLE [dbo].[WF_ChangeDayoffRequest] CHECK CONSTRAINT [FK_WF_ChangeDayoffRequest_WF_RequestStatus]
GO

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

ALTER TABLE [dbo].[WF_ChangeDayoffRequest] CHECK CONSTRAINT [FK_WF_ChangeDayoffRequest_WF_Track]
GO




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

ALTER TABLE [dbo].[WF_ChangeDayoffRequestSignature] CHECK CONSTRAINT [FK_WF_ChangeDayoffRequestSignature_SecurityUser]
GO

ALTER TABLE [dbo].[WF_ChangeDayoffRequestSignature]  WITH CHECK ADD  CONSTRAINT [FK_WF_ChangeDayoffRequestSignature_WF_ChangeDayoffRequest] FOREIGN KEY([ChangeDayoffRequestId])
REFERENCES [dbo].[WF_ChangeDayoffRequest] ([ChangeDayoffRequestId])
GO

ALTER TABLE [dbo].[WF_ChangeDayoffRequestSignature] CHECK CONSTRAINT [FK_WF_ChangeDayoffRequestSignature_WF_ChangeDayoffRequest]
GO

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

ALTER TABLE [dbo].[WF_ChangeDayoffRequestSignature] CHECK CONSTRAINT [FK_WF_ChangeDayoffRequestSignature_WF_RequestStatus]
GO



SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (114, N' Change Dayoff Request Sending', N'ÅÑÓÇá ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (115, N' Change Dayoff Request Accept', N'ÇáãæÇÝÞÉ Úáì ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (116, N' Change Dayoff Request Refuse', N'ÑÝÖ ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (117, N' Change Dayoff 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 (114, N' Change Dayoff Request Sending', N'ÅÑÓÇá ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', 114, N' ØáÈ  ÊÛíÑ íæã ÇáÑÇÍÉ', N'ÅÑÓÇá ØáÈ  ÊÛíÑ íæã ÇáÑÇÍÉ', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (115, N' Change Dayoff Request Accept', N'ÇáãæÇÝÞÉ Úáì ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', 115, N'ÇÚÊãÇÏ ØáÈ  ÊÛíÑ íæã ÇáÑÇÍÉ', N'ÊãÊ ÇáãæÇÝÞÉ', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (116, N' Change Dayoff Request Refuse', N'ÑÝÖ ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', 116, N'ÑÝÖ ØáÈ  ÊÛíÑ íæã ÇáÑÇÍÉ', N'Êã ÑÝÖ ØáÈ  ÊÛíÑ íæã ÇáÑÇÍÉ', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (117, N' Change Dayoff Request Cancellation', N'ÅÇáÛÇÁ ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', 117, N'ÅÇáÛÇÁ ØáÈ  ÊÛíÑ íæã ÇáÑÇÍÉ', N'Êã ÅÇáÛÇÁ ØáÈ  ÊÛíÑ íæã ÇáÑÇÍÉ', 1, NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (173, N'Change Dayoff Request', N'ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', 29, N'/WorkFlow/ChangeDayoffRequest', N'Index', N'fa fa-thumb-tack', N'get', 32, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (174, N'Change Dayoff Request Signature', N'ÇÚÊãÇÏ ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', 108, N'/WorkFlow/ChangeDayoffRequestSignature', N'Index', N'fa fa-thumb-tack', N'get', 33, 1, 1)
Go


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3314, N'ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', N'Change Dayoff Request', 173, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3315, N'ÚÑÖ ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', N'View Change Dayoff Request', 173, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3316, N'ÅÖÇÝÉ ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', N'Add Change Dayoff Request', 173, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3317, N'ÊÚÏíá ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', N'Edit Change Dayoff Request', 173, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3318, N'ÍÐÝ ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', N'Delete Change Dayoff Request', 173, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3319, N'ÍÝÙ ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', N'Save Change Dayoff Request', 173, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3320, N'ÅáÛÇÁ ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', N'Cancel Change Dayoff Request', 173, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3321, N'ÇÚÊãÇÏ ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', N'Change Dayoff Request Signature', 174, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3322, N'ÚÑÖ ÇÚÊãÇÏ ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', N'View Change Dayoff Request Signature', 174, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3323, N'ÊÚÏíá ÇÚÊãÇÏ ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', N'Edit Change Dayoff Request Signature', 174, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3324, N'ÍÝÙ ÇÚÊãÇÏ ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', N'Save Change Dayoff Request Signature', 174, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3325, N'ÍÝÙ ÇÚÊãÇÏÇÊ ØáÈÇÊ ÊÛíÑ íæã ÇáÑÇÍÉ', N'Save Change Dayoff Requests Signatures', 174, 2)
GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1262, 173, 1)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1263, 174, 1)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF

INSERT [dbo].[WF_RequestType] ([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName]) VALUES (18, N'ØáÈ ÊÛíÑ íæã ÇáÑÇÍÉ', N'Change Dayoff Request', 0, N'sayedmustafa84@yahoo.com', N'sayedmustafa84@yahoo.com', N'1', N'smtp.sendgrid.net', 587, N'SST')
GO

------------------------------End 2019-01-23---------------------------------------------
------------------------------Hammad 2019-01-28---------------------------------------------

CREATE TABLE [dbo].[ReplacementEmployee](
	[ReplacementId] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeCode] [int] NOT NULL,
	[ReplacementEmployeeCode] [int] NOT NULL,
	[ReplacementSectionCode] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_ReplacementEmployee] PRIMARY KEY CLUSTERED 
(
	[ReplacementId] 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 (175, N'Replacement Employee', N'ÇáãæÙÝ ÇáÈÏíá', 28, N'/WorkFlow/ReplacementEmployee', N'Index', N'', N'get', 13, 1, 1)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3326, N'ÇáãæÙÝ ÇáÈÏíá', N'Replacement Employee', 175, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3327, N'ÚÑÖ ÇáãæÙÝ ÇáÈÏíá', N'View Replacement Employee', 175, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3328, N'ÍÝÙ ÇáãæÙÝ ÇáÈÏíá', N'Save Replacement Employee', 175, 2)
Go


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

------------------------------End 2019-01-28--------------------------------------------------
------------------------------skeshta 2019-02-06----------------------------------------------

SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (118, N'Transaction Content Template', N'äãæÐÌ ãÍÊæì ÇáãÚÇãáÉ', 0, 2)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (119, N'Transaction Reply Content Template', N'äãæÐÌ ãÍÊæì ÇáÑÏ Úáì ÇáãÚÇãáÉ', 0, 2)
GO
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
GO

SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
GO
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (118, N'Transaction Content Template', N'äãæÐÌ ãÍÊæì ÇáãÚÇãáÉ', 118, N'äãæÐÌ ãÍÊæì ÇáãÚÇãáÉ', N'', 1, NULL)
GO
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (119, N'Transaction Reply Content Template', N'äãæÐÌ ãÍÊæì ÇáÑÏ Úáì ÇáãÚÇãáÉ', 119, N'äãæÐÌ ãÍÊæì ÇáÑÏ Úáì ÇáãÚÇãáÉ', N'', 1, NULL)
GO
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF
GO

------------------------------End 2019-02-06--------------------------------------------------
------------------------------skeshta 2019-02-11----------------------------------------------

Alter table [dbo].[AC_Decision]
Add [IsDraft] bit not null default(0)
GO

Alter table [dbo].[AC_Decision]
Alter column [DecisionSerial] nvarchar(10) null
GO

/****** Object:  Table [dbo].[AC_DecisionLocation]    Script Date: 11/02/2019 14:46:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AC_DecisionLocation](
	[DecisionLocationCode] [int] IDENTITY(1,1) NOT NULL,
	[LocationCode] [tinyint] NOT NULL,
	[DecisionCode] [int] NOT NULL,
 CONSTRAINT [PK_AC_DecisionLocation] PRIMARY KEY CLUSTERED 
(
	[DecisionLocationCode] 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_DecisionLocation]  WITH CHECK ADD  CONSTRAINT [FK_AC_DecisionLocation_AC_Decision] FOREIGN KEY([DecisionCode])
REFERENCES [dbo].[AC_Decision] ([DecisionCode])
GO

ALTER TABLE [dbo].[AC_DecisionLocation] CHECK CONSTRAINT [FK_AC_DecisionLocation_AC_Decision]
GO

ALTER TABLE [dbo].[AC_DecisionLocation]  WITH CHECK ADD  CONSTRAINT [FK_AC_DecisionLocation_Location] FOREIGN KEY([LocationCode])
REFERENCES [dbo].[Location] ([LocationCode])
GO

ALTER TABLE [dbo].[AC_DecisionLocation] CHECK CONSTRAINT [FK_AC_DecisionLocation_Location]
GO

------------------------------End 2019-02-11--------------------------------------------------
------------------------------Sayed 2019-02-11------------------------------------------------
alter table [dbo].[WF_VacationRequest]
add IsHaveDisclaimer bit not null default(0)
GO
-----------------------------End 2019-02-11--------------------------------------------------

------------------------------Sayed 2019-02-12------------------------------------------------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (2034, N' ãÚÇíäÉ ÇáãÚÇãáÉ ÈÑÏæÏ', N'Preview Transaction Replies', 19, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (2035, N' ØÈÇÚÉ ÇáãÚÇãáÉ ÈÑÏæÏ', N'Print Transaction Replies', 19, 2)

GO
GO
-----------------------------End 2019-02-12--------------------------------------------------
-----------------------------Hammad 2019-02-12--------------------------------------------------


EXEC sp_rename 'WF_DisclaimerRequestSignature.ResignationRequestCode', 'RequestCode', 'COLUMN';  
GO 

ALTER TABLE [dbo].[WF_DisclaimerRequestSignature] DROP CONSTRAINT [FK_WF_DisclaimerRequestSignature_WF_ResignationRequest]
GO

ALTER TABLE dbo.WF_DisclaimerRequestSignature ADD
	RequestTypeId int NOT NULL CONSTRAINT DF_WF_DisclaimerRequestSignature_RequestTypeId DEFAULT 7
GO

ALTER TABLE [dbo].[WF_DisclaimerRequestSignature]  WITH CHECK ADD  CONSTRAINT [FK_WF_DisclaimerRequestSignature_WF_RequestType] FOREIGN KEY([RequestTypeId])
REFERENCES [dbo].[WF_RequestType] ([RequestTypeId])
GO

ALTER TABLE [dbo].[WF_DisclaimerRequestSignature] CHECK CONSTRAINT [FK_WF_DisclaimerRequestSignature_WF_RequestType]
GO

ALTER TABLE dbo.WF_VacationRequest ADD
	DisclaimerDepartmentApproval tinyint NULL,
	DisclaimerTrackCode int NULL
GO

ALTER TABLE [dbo].[WF_VacationRequest]  WITH CHECK ADD  CONSTRAINT [DisclaimerDepartmentApprovalStatus] FOREIGN KEY([DisclaimerDepartmentApproval])
REFERENCES [dbo].[WF_RequestStatus] ([RequestStatusId])
GO

ALTER TABLE [dbo].[WF_VacationRequest] CHECK CONSTRAINT [DisclaimerDepartmentApprovalStatus]
GO

-----------------------------End 2019-02-12--------------------------------------------------
-----------------------------Hammad 2019-02-13--------------------------------------------------



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (176, N'User Type', N'äæÚ ÇáãÓÊÎÏã', 4, N'/WorkFlow/UserType', N'Index', N'fa fa-thumb-tack', N'get', 8, 1, 0)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3329, N'ÇáãÓÊÎÏã äæÚ', N'User Type', 176, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3330, N'ÚÑÖ ÇáãÓÊÎÏã äæÚ', N'View User Type', 176, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3331, N'ÅÖÇÝÉ ÇáãÓÊÎÏã äæÚ', N'Add User Type', 176, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3332, N'ÊÚÏíá ÇáãÓÊÎÏã äæÚ ', N'Edit User Type', 176, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3333, N'ÍÐÝ ÇáãÓÊÎÏã äæÚ', N'Delete User Type', 176, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3334, N'ÍÝÙ ÇáãÓÊÎÏã äæÚ', N'Save User Type', 176, 2)
GO


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

INSERT [dbo].[SecurityUserDetail] ( [SecurityUserID], [PrivilegeID]) VALUES ( 1, 3329)
INSERT [dbo].[SecurityUserDetail] ( [SecurityUserID], [PrivilegeID]) VALUES (1, 3330)
INSERT [dbo].[SecurityUserDetail] ( [SecurityUserID], [PrivilegeID]) VALUES ( 1, 3331)
INSERT [dbo].[SecurityUserDetail] ( [SecurityUserID], [PrivilegeID]) VALUES ( 1, 3332)
INSERT [dbo].[SecurityUserDetail] ( [SecurityUserID], [PrivilegeID]) VALUES ( 1, 3333)
INSERT [dbo].[SecurityUserDetail] ( [SecurityUserID], [PrivilegeID]) VALUES ( 1, 3334)

-----------------------------End 2019-02-13---------------------------------------------------
------------------------------skeshta 2019-02-13----------------------------------------------

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate]) VALUES (N'WFIsOvertimeRequestNeedSectionApproval', N'Is Overtime request need Section Approval?', N'åá ØáÈ ÇáæÞÊ ÇáÇÖÇÝí íÍÊÇÌ Çáí ãæÇÝÞÉ ÇáÞÓã¿', N'false', 2, 40, 1, 1, NULL, NULL)
GO

------------------------------End 2019-02-13--------------------------------------------------
------------------------------Hammad 2019-02-14--------------------------------------------------


CREATE proc [dbo].[WF_GetOverTimeRequestByEmployee] 
(
	@UserId int =null ,
	@MainType tinyint =null ,
	@FromDate datetime =null ,
	@ToDate datetime =null,
	@EmployeeId int =null,
	@SectionCode nvarchar(50),
	@DepartmentApproval tinyint=null ,
	@DeptAccepted tinyint=null ,
	@DeptRefused tinyint=null ,
	@DeptPending tinyint=null 
)
AS

              

SELECT  [EmployeeId]
    
      ,round((sum([MinutesCount])/60),2) as HoursCount
    
	  ,Employees.Name  as EmployeeNameEN
	  ,Employees.Arabic_Name  as EmployeeNameAR
	,Sections.Name  as SectionEnName
	  ,Sections.Arabic_Name  as SectionArName
	  	 	
    	,round(sum(Cost),2) as Cost
	
		,round((sum(MinutesCountAfterFactor)/60),2) as   HoursAfterFactor
		
  FROM WF_OverTimeRequest 
  inner join Employees on WF_OverTimeRequest.EmployeeId=Employees.EmployeeCode
  LEFT OUTER JOIN  WF_OvertimeType on WF_OverTimeRequest.OvertimeTypeCode=WF_OvertimeType.OvertimeTypeCode
  inner join Sections on Sections.SectionCode=Employees.SectionCode
  inner join WF_RequestStatus on WF_OverTimeRequest.DepartmentApproval=WF_RequestStatus.RequestStatusId



 where 

      EmployeeId = COALESCE(@EmployeeId, EmployeeId)
       And  MainType = COALESCE(@MainType, MainType)
	 AND (@FromDate IS NULL OR RecordAddDate >= @FromDate)
      AND (@ToDate IS NULL OR RecordAddDate <= @ToDate )
     and   Employees.SectionCode = COALESCE(@SectionCode, Employees.SectionCode)
	 
       And( DepartmentApproval=  @DeptPending
	   or DepartmentApproval= @DeptAccepted
       or  DepartmentApproval= @DeptRefused)

	      group by EmployeeId,Employees.Name,Employees.Arabic_Name ,Sections.Name ,Sections.Arabic_Name 

GO



/****** Object:  StoredProcedure [dbo].[WF_GetOverTimeRequest]    Script Date: 13/02/2019 10:35:08 ******/
DROP PROCEDURE [dbo].[WF_GetOverTimeRequest]
GO

/****** Object:  StoredProcedure [dbo].[WF_GetOverTimeRequest]    Script Date: 13/02/2019 10:35:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE proc [dbo].[WF_GetOverTimeRequest] 
(
	@UserId int =null ,
	@MainType tinyint =null ,
	@FromDate datetime =null ,
	@ToDate datetime =null,
	@EmployeeId int =null,
	@SectionCode nvarchar(50),
	@DepartmentApproval tinyint=null ,
	@DeptAccepted tinyint=null ,
	@DeptRefused tinyint=null ,
	@DeptPending tinyint=null 
)
AS

              

SELECT  WF_OverTimeRequest.OverTimeRequestId     ,[EmployeeId]
      ,[DepartmentApproval]
      ,[RequestDate]
      ,[HRApproval]
      ,[RecordAddDate]
      ,[RequestReason]
      ,[MainType]
      ,round((MinutesCount/60),2)  as   MinutesCount
      ,WF_OverTimeRequest.[Closed]
      ,[MainType]
      ,dbo.MinutesToDuration(MinutesCount) as HoursMinutes
	  ,Employees.Name  as EmployeeNameEN
	  ,Employees.Arabic_Name  as EmployeeNameAR
      ,WF_RequestStatus.RequestStatusName  as DepartmentApprovalNameAR
	  ,WF_RequestStatus.RequestStatusNameEn  as DepartmentApprovalNameEN
	  ,Sections.Name  as SectionEnName
	  ,Sections.Arabic_Name  as SectionArName
	  ,WF_OverTimeRequestSignature.UserId
	  ,SecurityUser.EmployeeCode
	  ,empDeptPending.Arabic_Name as UserPendingNameAr
	  ,empDeptPending.Name as UserPendingNameEN,
	  TimeFrom,	TimeTo,
	  	WF_OvertimeType.Name as OvertimeTypeNameEN ,
	  	WF_OvertimeType.Arabic_Name as OvertimeTypeNameAr ,
    	dbo.MinutesToDuration(MinutesCountAfterFactor) as   MinutesCountAfterFactor
		 ,round(Cost,2) as Cost
	  ,empDeptRefused.Arabic_Name as UserRefusedNameAr
	  ,empDeptRefused.Name as UserRefusedNameEN
		,round((MinutesCountAfterFactor/60),2)  as   TotalMinutesAfterFactor
		
  FROM WF_OverTimeRequest 
  inner join Employees on WF_OverTimeRequest.EmployeeId=Employees.EmployeeCode
  LEFT OUTER JOIN  WF_OvertimeType on WF_OverTimeRequest.OvertimeTypeCode=WF_OvertimeType.OvertimeTypeCode
  inner join Sections on Sections.SectionCode=Employees.SectionCode
  inner join WF_RequestStatus on WF_OverTimeRequest.DepartmentApproval=WF_RequestStatus.RequestStatusId
  LEFT OUTER JOIN WF_OverTimeRequestSignature on WF_OverTimeRequest.OverTimeRequestId=WF_OverTimeRequestSignature.OverTimeRequestId and WF_OverTimeRequestSignature.Turn=0 and WF_OverTimeRequestSignature.Approved=0
  LEFT OUTER JOIN SecurityUser on SecurityUser.SecurityUserCode=WF_OverTimeRequestSignature.UserId
  LEFT OUTER JOIN Employees as empDeptPending on empDeptPending.EmployeeCode =SecurityUser.EmployeeCode

  LEFT OUTER JOIN WF_OverTimeRequestSignature as SignatureRefuse on WF_OverTimeRequest.OverTimeRequestId=SignatureRefuse.OverTimeRequestId and SignatureRefuse.Turn=1 and SignatureRefuse.Approved=2
  LEFT OUTER JOIN SecurityUser  as UserRefused on UserRefused.SecurityUserCode=SignatureRefuse.UserId
  LEFT OUTER JOIN Employees as empDeptRefused on empDeptRefused.EmployeeCode =UserRefused.EmployeeCode
 
 where 

      EmployeeId = COALESCE(@EmployeeId, EmployeeId)
       And  MainType = COALESCE(@MainType, MainType)
	 AND (@FromDate IS NULL OR RecordAddDate >= @FromDate)
      AND (@ToDate IS NULL OR RecordAddDate <= @ToDate )
     and   Employees.SectionCode = COALESCE(@SectionCode, Employees.SectionCode)
	 
       And( DepartmentApproval=  @DeptPending
	   or DepartmentApproval= @DeptAccepted
       or  DepartmentApproval= @DeptRefused)

	 
GO




------------------------------End 2019-02-14--------------------------------------------------
------------------------------Sayed 2019-02-14-----------------------------------------------



ALTER proc [dbo].[WF_GetOverTimeRequest] 
(
	@UserId int =null ,
	@MainType tinyint =null ,
	@FromDate datetime =null ,
	@ToDate datetime =null,
	@EmployeeId int =null,
	@SectionCode nvarchar(50),
	@DepartmentApproval tinyint=null ,
	@DeptAccepted tinyint=null ,
	@DeptRefused tinyint=null ,
	@DeptPending tinyint=null 
)
AS

              

SELECT  WF_OverTimeRequest.OverTimeRequestId     ,[EmployeeId]
      ,[DepartmentApproval]
      ,[RequestDate]
      ,[HRApproval]
      ,[RecordAddDate]
      ,[RequestReason]
      ,[MainType]
      ,round((MinutesCount/60),2)  as   MinutesCount
      ,WF_OverTimeRequest.[Closed]
      ,[MainType]
      ,dbo.MinutesToDuration(MinutesCount) as HoursMinutes
	  ,Employees.Name  as EmployeeNameEN
	  ,Employees.Arabic_Name  as EmployeeNameAR
      ,WF_RequestStatus.RequestStatusName  as DepartmentApprovalNameAR
	  ,WF_RequestStatus.RequestStatusNameEn  as DepartmentApprovalNameEN
	  ,Sections.Name  as SectionEnName
	  ,Sections.Arabic_Name  as SectionArName
	  ,WF_OverTimeRequestSignature.UserId
	  ,SecurityUser.EmployeeCode
	  ,(case when [DepartmentApproval]=0 then  empDeptPending.Arabic_Name else '' end) as UserPendingNameAr
	  ,(case when [DepartmentApproval]=0 then empDeptPending.Name else '' end) as UserPendingNameEN,
	  TimeFrom,	TimeTo,
	  	WF_OvertimeType.Name as OvertimeTypeNameEN ,
	  	WF_OvertimeType.Arabic_Name as OvertimeTypeNameAr ,
    	dbo.MinutesToDuration(MinutesCountAfterFactor) as   MinutesCountAfterFactor
		 ,round(Cost,2) as Cost
	  ,empDeptRefused.Arabic_Name as UserRefusedNameAr
	  ,empDeptRefused.Name as UserRefusedNameEN
		,round((MinutesCountAfterFactor/60),2)  as   TotalMinutesAfterFactor
		
  FROM WF_OverTimeRequest 
  inner join Employees on WF_OverTimeRequest.EmployeeId=Employees.EmployeeCode
  LEFT OUTER JOIN  WF_OvertimeType on WF_OverTimeRequest.OvertimeTypeCode=WF_OvertimeType.OvertimeTypeCode
  inner join Sections on Sections.SectionCode=Employees.SectionCode
  inner join WF_RequestStatus on WF_OverTimeRequest.DepartmentApproval=WF_RequestStatus.RequestStatusId
  LEFT OUTER JOIN WF_OverTimeRequestSignature on WF_OverTimeRequest.OverTimeRequestId=WF_OverTimeRequestSignature.OverTimeRequestId and WF_OverTimeRequestSignature.Turn=0 and WF_OverTimeRequestSignature.Approved=0
  LEFT OUTER JOIN SecurityUser on SecurityUser.SecurityUserCode=WF_OverTimeRequestSignature.UserId
  LEFT OUTER JOIN Employees as empDeptPending on empDeptPending.EmployeeCode =SecurityUser.EmployeeCode

  LEFT OUTER JOIN WF_OverTimeRequestSignature as SignatureRefuse on WF_OverTimeRequest.OverTimeRequestId=SignatureRefuse.OverTimeRequestId and SignatureRefuse.Turn=1 and SignatureRefuse.Approved=2
  LEFT OUTER JOIN SecurityUser  as UserRefused on UserRefused.SecurityUserCode=SignatureRefuse.UserId
  LEFT OUTER JOIN Employees as empDeptRefused on empDeptRefused.EmployeeCode =UserRefused.EmployeeCode
 
 where 

      EmployeeId = COALESCE(@EmployeeId, EmployeeId)
       And  MainType = COALESCE(@MainType, MainType)
	 AND (@FromDate IS NULL OR RecordAddDate >= @FromDate)
      AND (@ToDate IS NULL OR RecordAddDate <= @ToDate )
     and   Employees.SectionCode = COALESCE(@SectionCode, Employees.SectionCode)
	 
       And( DepartmentApproval=  @DeptPending
	   or DepartmentApproval= @DeptAccepted
       or  DepartmentApproval= @DeptRefused)

	 
GO

  update [SST.ERPRamadaHotelJeddah].[dbo].[WF_OverTimeRequestSignature]   set Turn=1 
  where OverTimeRequestId in (select OverTimeRequestId from WF_OverTimeRequest where DepartmentApproval=1)

--------------------------End 2019-02-14------------------------------------------
--------------------------Hammad 2019-02-17------------------------------------------

/****** Object:  StoredProcedure [dbo].[WF_GetOverTimeRequest]    Script Date: 17/02/2019 11:23:16 ******/
DROP PROCEDURE [dbo].[WF_GetOverTimeRequest]
GO

/****** Object:  StoredProcedure [dbo].[WF_GetOverTimeRequest]    Script Date: 17/02/2019 11:23:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE proc [dbo].[WF_GetOverTimeRequest] 
(
	@UserId int =null ,
	@MainType tinyint =null ,
	@FromDate datetime =null ,
	@ToDate datetime =null,
	@EmployeeId int =null,
	@SectionCode nvarchar(50),
	@DepartmentApproval tinyint=null ,
	@DeptAccepted tinyint=null ,
	@DeptRefused tinyint=null ,
	@DeptPending tinyint=null ,
	@OverTimeFromDate datetime =null ,
	@OverTimeToDate datetime =null
)
AS

              

SELECT  WF_OverTimeRequest.OverTimeRequestId     ,[EmployeeId]
      ,[DepartmentApproval]
      ,[RequestDate]
      ,[HRApproval]
      ,[RecordAddDate]
      ,[RequestReason]
      ,[MainType]
      ,round((MinutesCount/60),2)  as   MinutesCount
      ,WF_OverTimeRequest.[Closed]
      ,[MainType]
      ,dbo.MinutesToDuration(MinutesCount) as HoursMinutes
	  ,Employees.Name  as EmployeeNameEN
	  ,Employees.Arabic_Name  as EmployeeNameAR
      ,WF_RequestStatus.RequestStatusName  as DepartmentApprovalNameAR
	  ,WF_RequestStatus.RequestStatusNameEn  as DepartmentApprovalNameEN
	  ,Sections.Name  as SectionEnName
	  ,Sections.Arabic_Name  as SectionArName
	  ,WF_OverTimeRequestSignature.UserId
	  ,SecurityUser.EmployeeCode
	  ,(case when [DepartmentApproval]=0 then  empDeptPending.Arabic_Name else '' end) as UserPendingNameAr
	  ,(case when [DepartmentApproval]=0 then empDeptPending.Name else '' end) as UserPendingNameEN,
	  TimeFrom,	TimeTo,
	  	WF_OvertimeType.Name as OvertimeTypeNameEN ,
	  	WF_OvertimeType.Arabic_Name as OvertimeTypeNameAr ,
    	dbo.MinutesToDuration(MinutesCountAfterFactor) as   MinutesCountAfterFactor
		 ,round(Cost,2) as Cost
	  ,empDeptRefused.Arabic_Name as UserRefusedNameAr
	  ,empDeptRefused.Name as UserRefusedNameEN
		,round((MinutesCountAfterFactor/60),2)  as   TotalMinutesAfterFactor
		
  FROM WF_OverTimeRequest 
  inner join Employees on WF_OverTimeRequest.EmployeeId=Employees.EmployeeCode
  LEFT OUTER JOIN  WF_OvertimeType on WF_OverTimeRequest.OvertimeTypeCode=WF_OvertimeType.OvertimeTypeCode
  inner join Sections on Sections.SectionCode=Employees.SectionCode
  inner join WF_RequestStatus on WF_OverTimeRequest.DepartmentApproval=WF_RequestStatus.RequestStatusId
  LEFT OUTER JOIN WF_OverTimeRequestSignature on WF_OverTimeRequest.OverTimeRequestId=WF_OverTimeRequestSignature.OverTimeRequestId and WF_OverTimeRequestSignature.Turn=0 and WF_OverTimeRequestSignature.Approved=0
  LEFT OUTER JOIN SecurityUser on SecurityUser.SecurityUserCode=WF_OverTimeRequestSignature.UserId
  LEFT OUTER JOIN Employees as empDeptPending on empDeptPending.EmployeeCode =SecurityUser.EmployeeCode

  LEFT OUTER JOIN WF_OverTimeRequestSignature as SignatureRefuse on WF_OverTimeRequest.OverTimeRequestId=SignatureRefuse.OverTimeRequestId and SignatureRefuse.Turn=1 and SignatureRefuse.Approved=2
  LEFT OUTER JOIN SecurityUser  as UserRefused on UserRefused.SecurityUserCode=SignatureRefuse.UserId
  LEFT OUTER JOIN Employees as empDeptRefused on empDeptRefused.EmployeeCode =UserRefused.EmployeeCode
 
 where 

      EmployeeId = COALESCE(@EmployeeId, EmployeeId)
       And  MainType = COALESCE(@MainType, MainType)
	 AND (@FromDate IS NULL OR RecordAddDate >= @FromDate)
      AND (@ToDate IS NULL OR RecordAddDate <= @ToDate )
	   AND (@OverTimeFromDate IS NULL OR RequestDate >= @OverTimeFromDate)
      AND (@OverTimeToDate IS NULL OR RequestDate <= @OverTimeToDate )

     and   Employees.SectionCode = COALESCE(@SectionCode, Employees.SectionCode)
       And( DepartmentApproval=  @DeptPending
	   or DepartmentApproval= @DeptAccepted
       or  DepartmentApproval= @DeptRefused)

	 

GO



/****** Object:  StoredProcedure [dbo].[WF_GetOverTimeRequestByEmployee]    Script Date: 17/02/2019 11:37:06 ******/
DROP PROCEDURE [dbo].[WF_GetOverTimeRequestByEmployee]
GO

/****** Object:  StoredProcedure [dbo].[WF_GetOverTimeRequestByEmployee]    Script Date: 17/02/2019 11:37:06 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE proc [dbo].[WF_GetOverTimeRequestByEmployee] 
(
	@UserId int =null ,
	@MainType tinyint =null ,
	@FromDate datetime =null ,
	@ToDate datetime =null,
	@EmployeeId int =null,
	@SectionCode nvarchar(50),
	@DepartmentApproval tinyint=null ,
	@DeptAccepted tinyint=null ,
	@DeptRefused tinyint=null ,
	@DeptPending tinyint=null ,
   @OverTimeFromDate datetime =null ,
	@OverTimeToDate datetime =null
)
AS
             

SELECT  [EmployeeId]
    
      ,round((sum([MinutesCount])/60),2) as HoursCount
    
	  ,Employees.Name  as EmployeeNameEN
	  ,Employees.Arabic_Name  as EmployeeNameAR
	,Sections.Name  as SectionEnName
	  ,Sections.Arabic_Name  as SectionArName
	  	 	
    	,round(sum(Cost),2) as Cost
	
		,round((sum(MinutesCountAfterFactor)/60),2) as   HoursAfterFactor
		
  FROM WF_OverTimeRequest 
  inner join Employees on WF_OverTimeRequest.EmployeeId=Employees.EmployeeCode
  LEFT OUTER JOIN  WF_OvertimeType on WF_OverTimeRequest.OvertimeTypeCode=WF_OvertimeType.OvertimeTypeCode
  inner join Sections on Sections.SectionCode=Employees.SectionCode
  inner join WF_RequestStatus on WF_OverTimeRequest.DepartmentApproval=WF_RequestStatus.RequestStatusId



 where 

      EmployeeId = COALESCE(@EmployeeId, EmployeeId)
	 AND (@FromDate IS NULL OR RecordAddDate >= @FromDate)
      AND (@ToDate IS NULL OR RecordAddDate <= @ToDate )
	     AND (@OverTimeFromDate IS NULL OR RequestDate >= @OverTimeFromDate)
      AND (@OverTimeToDate IS NULL OR RequestDate <= @OverTimeToDate )
     and   Employees.SectionCode = COALESCE(@SectionCode, Employees.SectionCode)
	 
       And( DepartmentApproval=  @DeptPending
	   or DepartmentApproval= @DeptAccepted
       or  DepartmentApproval= @DeptRefused)

	      group by EmployeeId,Employees.Name,Employees.Arabic_Name ,Sections.Name ,Sections.Arabic_Name 

GO



--------------------------End 2019-02-17------------------------------------------
--------------------------Hammad 2019-02-20---------------------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (177, N' Work Settings', N'ÅÚÏÇÏÇÊ ÇáÚãá', 4, N'/SystemSecurityConfig', N'Index', NULL, N'get', 9, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (178, N' Work Settings', N'ÅÚÏÇÏÇÊ ÇáÚãá', 28, N'/WorkFlow/SystemConfig', N'Index', NULL, N'get', 14, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (179, N' Work Settings', N'ÅÚÏÇÏÇÊ ÇáÚãá', 10, N'/AdminComm/ACSystemConfig', N'Index', NULL, N'get', 12, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (180, N' Work Settings', N'ÅÚÏÇÏÇÊ ÇáÚãá', 103, N'/DashboardConfig', N'Index', NULL, N'get', 6, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (181, N' Work Settings', N'ÅÚÏÇÏÇÊ ÇáÚãá', 133, N'/Archive/ArcSystemConfig', N'Index', NULL, N'get', 3, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1113, N'ÅÚÏÇÏÇÊ ÇáÚãá', N'System Security Config', 177, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1114, N'ÚÑÖ ÅÚÏÇÏÇÊ ÇáÚãá', N'View System Security Config', 177, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1115, N'ÍÝÙ ÅÚÏÇÏÇÊ ÇáÚãá', N'Save System Security Config', 177, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1116, N'ÅÚÏÇÏÇÊ ÇáÚãá', N'WorkFlow Config', 178, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1117, N'ÚÑÖ ÅÚÏÇÏÇÊ ÇáÚãá', N'View WorkFlow Config', 178, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1118, N'ÍÝÙ ÅÚÏÇÏÇÊ ÇáÚãá', N'Save WorkFlow  Config', 178, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1119, N'ÅÚÏÇÏÇÊ ÇáÚãá', N'AC Config', 179, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1120, N'ÚÑÖ ÅÚÏÇÏÇÊ ÇáÚãá', N'View AC Config', 179, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1121, N'ÍÝÙ ÅÚÏÇÏÇÊ ÇáÚãá', N'Save AC Config', 179, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1122, N'ÅÚÏÇÏÇÊ ÇáÚãá', N'Dashboard Config', 180, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1123, N'ÚÑÖ ÅÚÏÇÏÇÊ ÇáÚãá', N'View Dashboard Config', 180, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1124, N'ÍÝÙ ÅÚÏÇÏÇÊ ÇáÚãá', N'Save Dashboard Config', 180, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1125, N'ÅÚÏÇÏÇÊ ÇáÚãá', N'Arc Config', 181, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1126, N'ÚÑÖ ÅÚÏÇÏÇÊ ÇáÚãá', N'View Arc Config', 181, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1127, N'ÍÝÙ ÅÚÏÇÏÇÊ ÇáÚãá', N'Save Arc Config', 181, 2)
Go


SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 

INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1270, 177, 1)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1271, 177, 2)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1272, 177, 3)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1273, 178, 1)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1277, 179, 2)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1278, 180, 5)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (1279, 181, 3)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO
--------------------------End 2019-02-20---------------------------------------
--------------------------Sayed 2019-02-21-------------------------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate]) VALUES (N'DelegationOfAdministrativeCommunications', N'Delegation of Administrative Communications ?', N'ÇáÊÝæíÖ ááÇÊÕÇáÇÊ ÇáÇÏÇÑíÉ ¿', N'true', 6, 13, 1, 1, NULL, NULL)
GO
-------------------------End 2019-02-21-----------------------------------------
