-------------------------------Hammad 2020-03-19------------
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) 
VALUES (59, N'Egyptian Law Open ', N'القانون المصرى المفتوح ', N'WFMethodOFCalculateOvertime')
Go

INSERT [dbo].[WF_OvertimeType] ([OvertimeTypeCode], [Name], [Arabic_Name], [Factor], [IsPercentage], [FromTime], [ToTime], [TypeOfLaw])
 VALUES (11, N'Morning And Evening', N'مسائى وصباحي   ', 0, 1, NULL, NULL, 1)
Go
-------------------------------End 2020-03-19------------

-------------------------------- Ali 2020-02-05 --------------------------
CREATE TABLE [dbo].[News](
	[NewsCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](max) NOT NULL,
	[Arabic_Name] [nvarchar](max) NOT NULL,
	[IsActive] [bit] 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_News] PRIMARY KEY CLUSTERED 
(
	[NewsCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[News] ADD  CONSTRAINT [DF_News_IsActive]  DEFAULT ((0)) FOR [IsActive]
GO


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(338,N'News',N'الاخبار',115,N'/News',N'Index','fa fa-thumb-tack',N'get',6,1,1)
Go

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


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1187, N'الاخبار', N'News', 338, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1188, N'عرض الاخبار', N'View News', 338, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1189, N'اضافة الاخبار', N'Add News', 338, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1190, N'تعديل الاخبار', N'Edit News', 338, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1191, N'حذف الاخبار', N'Delete News', 338, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1192, N'حفظ الاخبار', N'Save News', 338, 2)
Go
-------------------------------- End 2020-02-05 --------------------------
-------------------------------- Hammad 2020-02-09 -----------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (242, N'Branch License Setup', N'إعداد ترخيص عمل الفرع', 4, N'/BranchLicenseSetup', N'Index', NULL, N'get', 13, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1193, N'إعداد ترخيص الفرع', N'Branch License Setup', 242, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1194, N'عرض إعداد ترخيص الفرع', N'View Branch License Setup', 242, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1195, N'حفظ إعداد ترخيص الفرع', N'Save Branch License Setup', 242, 2)
Go

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

-------------------------------- End 2020-02-09 -----------------------
-------------------------------Hammad 2020-01-20-------------------------
 
ALTER TABLE dbo.WF_MasterRequests ADD
	FileName nvarchar(150) NULL
GO

CREATE TABLE [dbo].[WF_BonusType](
	[BonusTypeCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](500) NOT NULL,
	[Arabic_Name] [nvarchar](500) NOT NULL,
	[Type] [int] NOT NULL,
	[Amount] [float] NOT NULL,
	[MaxRequestCount] [int] NOT NULL,
	[MaxRequestCountType] [int] NOT NULL,
	[DaysCountAfterHiring] [int] NOT NULL,
	[AttachmentRequired] [bit] NOT NULL CONSTRAINT [DF_WF_BonusType_AttachementRequired]  DEFAULT ((0)),
	[BandCode] [int] NOT NULL,
 CONSTRAINT [PK_WF_BonusType] PRIMARY KEY CLUSTERED 
(
	[BonusTypeCode] 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_BonusType]  WITH CHECK ADD  CONSTRAINT [FK_WF_BonusType_Basis] FOREIGN KEY([BandCode])
REFERENCES [dbo].[Basis] ([BandCode])
GO

ALTER TABLE [dbo].[WF_BonusType] CHECK CONSTRAINT [FK_WF_BonusType_Basis]
GO


CREATE TABLE [dbo].[WF_BonusTypePenalty](
	[BonusTypePenaltyCode] [int] IDENTITY(1,1) NOT NULL,
	[BonusTypeCode] [int] NOT NULL,
	[PenaltyCategoryCode] [int] NOT NULL,
	[PreventFromBonus] [bit] NOT NULL,
	[BonusAfterMonthsCount] [int] NULL,
 CONSTRAINT [PK_WF_BonusTypePenalty] PRIMARY KEY CLUSTERED 
(
	[BonusTypePenaltyCode] 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_BonusTypePenalty] ADD  CONSTRAINT [DF_WF_BonusTypePenalty_PreventFromCandidature]  DEFAULT ((0)) FOR [PreventFromBonus]
GO

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

ALTER TABLE [dbo].[WF_BonusTypePenalty] CHECK CONSTRAINT [FK_WF_BonusTypePenalty_PenaltyCategories]
GO

ALTER TABLE [dbo].[WF_BonusTypePenalty]  WITH CHECK ADD  CONSTRAINT [FK_WF_BonusTypePenalty_WF_BonusType] FOREIGN KEY([BonusTypeCode])
REFERENCES [dbo].[WF_BonusType] ([BonusTypeCode])
GO

ALTER TABLE [dbo].[WF_BonusTypePenalty] CHECK CONSTRAINT [FK_WF_BonusTypePenalty_WF_BonusType]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Candidature After Months Count from Penalty' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WF_BonusTypePenalty', @level2type=N'COLUMN',@level2name=N'BonusAfterMonthsCount'
GO



CREATE TABLE [dbo].[WF_BonusesRequest](
	[MasterRequestCode] [int] NOT NULL,
	[BonusAmount] [float] NOT NULL,
	[BonusYear] [smallint] NOT NULL,
	[BonusMonth] [tinyint] NOT NULL,
	[BonusTypeCode] [int] NOT NULL,
 CONSTRAINT [PK_WF__BonusRequest] PRIMARY KEY CLUSTERED 
(
	[MasterRequestCode] 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_BonusesRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF__BonusRequest_WF_BonusType] FOREIGN KEY([BonusTypeCode])
REFERENCES [dbo].[WF_BonusType] ([BonusTypeCode])
GO

ALTER TABLE [dbo].[WF_BonusesRequest] CHECK CONSTRAINT [FK_WF__BonusRequest_WF_BonusType]
GO

ALTER TABLE [dbo].[WF_BonusesRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF__BonusRequest_WF_MasterRequests] FOREIGN KEY([MasterRequestCode])
REFERENCES [dbo].[WF_MasterRequests] ([MasterRequestCode])
GO

ALTER TABLE [dbo].[WF_BonusesRequest] CHECK CONSTRAINT [FK_WF__BonusRequest_WF_MasterRequests]
GO


 -------------------------------End 2020-01-20-------------------------

 -------------------------------Hammad 2020-01-27----------------------
 
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (241, N'Bonus Type', N'نوع العلاوة', 28, N'/WorkFlow/BonusType', N'Index', NULL, N'get', 19, 1, 1)
 Go

 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3485, N'نوع العلاوة', N' Bonus Type', 241, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3486, N'عرض  نوع العلاوة', N'View Bonus Type', 241, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3487, N'اضافة نوع العلاوة', N'Add Bonus Type', 241, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3488, N'تعديل نوع العلاوة', N'Edit Bonus Type', 241, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3489, N'حذف نوع العلاوة', N'Delete Bonus Type', 241, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3490, N'حفظ نوع العلاوة', N'Save Bonus Type', 241, 2)
Go
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 241, 1)
GO
 -------------------------------End 2020-01-27----------------------

  -------------------------------Ali 2020-01-28----------------------
 ALTER TABLE dbo.WF_LoanRequest ADD
	GuarantorCode int NULL
GO

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'WFGuarantor', N'View Guarantor By', N'عرض الضامن بواسطة', N'56', 2, 6, 6, 1, NULL, NULL, 9)
Go

INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (56, N'Division', N'القطاع', N'WFGuarantor')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (57, N'Department', N'الادارة', N'WFGuarantor')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (58, N'Section', N'القسم', N'WFGuarantor')
Go
 -------------------------------End 2020-01-28----------------------
 -------------------------------- A.Khaled 2020-02-02 --------------------------
 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (337, N'Online Recruitment Link', N'رابط التوظيف عبر الإنترنت', 47, N'/Recruitment/OnlineRecruitmentLink', N'Index', 'fa fa-external-link-square', N'get', 0, 1, 1)
 GO

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (8529, 337, 4)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (5119, N'رابط التوظيف عبر الإنترنت', N'Online Recruitment Link', 337, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (5120, N'عرض رابط التوظيف عبر الإنترنت', N'View Online Recruitment Link', 337, 2)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (159, N'Recruitment', N'OnlineRecruitmentLink', N'Index', 0, N'get', 5120)
GO
-------------------------------- End 2020-02-02 --------------------------
-------------------------------- Hammad 2020-02-04 --------------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'WFLoanRequestDisplaySalary', N'Display Total Salary', N'عرض إجمالى المرتب', N'false', 2, 7, 1, 1, NULL, NULL, 9)
GO
-------------------------------- End 2020-02-04 --------------------------

-------------------------------- Ali 2020-02-05 --------------------------
CREATE TABLE [dbo].[News](
	[NewsCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](max) NOT NULL,
	[Arabic_Name] [nvarchar](max) NOT NULL,
	[IsActive] [bit] 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_News] PRIMARY KEY CLUSTERED 
(
	[NewsCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[News] ADD  CONSTRAINT [DF_News_IsActive]  DEFAULT ((0)) FOR [IsActive]
GO


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(338,N'News',N'الاخبار',115,N'/News',N'Index','fa fa-thumb-tack',N'get',6,1,1)
Go

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


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1187, N'الاخبار', N'News', 338, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1188, N'عرض الاخبار', N'View News', 338, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1189, N'اضافة الاخبار', N'Add News', 338, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1190, N'تعديل الاخبار', N'Edit News', 338, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1191, N'حذف الاخبار', N'Delete News', 338, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1192, N'حفظ الاخبار', N'Save News', 338, 2)
Go
-------------------------------- End 2020-02-05 --------------------------
-------------------------------- Hammad 2020-02-09 -----------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (242, N'Branch License Setup', N'إعداد ترخيص عمل الفرع', 4, N'/BranchLicenseSetup', N'Index', NULL, N'get', 13, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1193, N'إعداد ترخيص الفرع', N'Branch License Setup', 242, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1194, N'عرض إعداد ترخيص الفرع', N'View Branch License Setup', 242, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1195, N'حفظ إعداد ترخيص الفرع', N'Save Branch License Setup', 242, 2)
Go

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

-------------------------------- End 2020-02-09 -----------------------