﻿---------------------------Hammad 2022-08-11----------

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'WFCompensationCommentMandatory', N'Request Reason Mandatory', N'التعليق اجباري عند تقديم الطلب', N'false', 2, 2, 1, 1, NULL, NULL, 21)
GO

CREATE TABLE [dbo].[WF_CompensationAllowanceLevels](
	[CompensationAllowanceLevelCode] [int] IDENTITY(1,1) NOT NULL,
	[CompensationAllowanceTypeCode] [int] NOT NULL,
	[LevelCode] [tinyint] NOT NULL,
 CONSTRAINT [PK_WF_CompensationAllowanceLevels] PRIMARY KEY CLUSTERED 
(
	[CompensationAllowanceLevelCode] 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_CompensationAllowanceLevels]  WITH CHECK ADD  CONSTRAINT [FK_WF_CompensationAllowanceLevels_Levels] FOREIGN KEY([LevelCode])
REFERENCES [dbo].[Levels] ([LevelCode])
GO

ALTER TABLE [dbo].[WF_CompensationAllowanceLevels] CHECK CONSTRAINT [FK_WF_CompensationAllowanceLevels_Levels]
GO

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

ALTER TABLE [dbo].[WF_CompensationAllowanceLevels] CHECK CONSTRAINT [FK_WF_CompensationAllowanceLevels_WF_CompensationAllowanceTypes]
GO

---------------------------End 2022-08-11-----------
---------------------------Ali 2022-08-11-----------

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFMustRequestBeforeDaysforeignUser',N'Must request before days For foreign',N'التقديم قبل تاريخ الطلب بعدد ايام للاجانب',N'0',2,7,2,1,Null,Null,7)
Go
 update [ConfigParameter]
  set Arabic_Name=N' التقديم قبل تاريخ الطلب بعدد ايام للمحليين' ,Name = N'Must request before days For Local'
 where [ConfigKey]=N'WFMustRequestBeforeDays'
 Go
 UPDATE [Nationality]
SET [NationalityType]= CASE
   WHEN [NationalityCode]=1 THEN 1
   ELSE 2
END
Go

  INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WorkByFinancialPrivilegeInPaySlip',N'Work by financial privilege Only in Pay Slip',N'الاعتماد على الصلاحيات الماليه فقط فى شريط القبض',N'false',1,46,1,1,Null,Null,Null)
Go

  update [ConfigParameter]
  set ConfigValue=(select ConfigValue from [ConfigParameter] where ConfigKey= N'WFMustRequestBeforeDays')
 where  ConfigKey= N'WFMustRequestBeforeDaysforeignUser'  
 Go
---------------------------Ali 2022-08-11-----------
---------------------------Mostafa 2022-08-11-----------
ALTER TABLE dbo.Employees ADD
	AttendWorkingHours float NULL

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(644,N'Update Employee Data',N'تحديث بيانات الموظفين',27,N'/Personal/UpdateEmployeeData',N'Index','fa fa-thumb-tack',N'get',6,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(644,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(2234,N'تحديث بيانات الموظفين',N'Update Employee Data',644,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(2235,N'عرض تحديث بيانات الموظفين',N'View Update Employee Data',644,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(2236,N'حفظ تحديث بيانات الموظفين',N'Save Update Employee Data',644,2)
Go
---------------------------End 2022-08-11-----------
---------------------------Hammad 2022-08-14-----------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'WFNotAcceptOverTimeInDayOff', N'Not Accept OverTime In Day Off', N'عدم قبول الطلب فى الراحة الاسبوعية', N'false', 2, 20, 1, 1, NULL, NULL, 3)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WFNotAcceptOverTimeInHoliday', N'Not Accept OverTime In Holiday ', N'عدم قبول الطلب فى الاعياد  ', N'false', 2, 21, 1, 1, NULL, NULL, 3)
GO
---------------------------End 2022-08-14-----------
---------------------------Ali 2022-08-14-----------

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'DisplayPaySlipAfterSendNotif',N'Display Pay Slip After Send Notifications',N'اظهار شريط المرتب بعد ارسال الاشعارات',N'false',1,47,1,1,Null,Null,Null)
Go
---------------------------End 2022-08-14-----------
---------------------------Hammad 2022-08-15-----------
ALTER TABLE dbo.WF_OvertimeType ADD
	BalanceFactor float(53) NULL
GO
---------------------------End 2022-08-15-----------

---------------------------Mostafa 2022-08-14-----------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (555, N'Task Force Request', N'طلب انتداب', 496, N'/WorkFlow/TaskForceRequest', N'Index', N'fa fa-thumb-tack', N'get', 22, 1, 1)

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

GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15228, N'طلب انتداب', N'Task Force Request', 555, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15229, N'عرض طلب انتداب', N'View Task Force Request', 555, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15230, N'إضافة طلب انتداب', N'Add Task Force Request', 555, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15231, N'تعديل طلب انتداب', N'Edit Task Force Request', 555, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15232, N'حذف طلب انتداب', N'Delete Task Force Request', 555, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15233, N'حفظ طلب انتداب', N'Save Task Force Request', 555, 2)

---------------------------End 2022-08-14-----------
---------------------------Ali 2022-08-15-----------


SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] ON 
   Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (168, NULL, NULL, N'ChangeSectionDepartRequest', N'SearchChangeSectionDepartRequest', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (169, NULL, NULL, N'ChangeSectionDepartRequest', N'GetDetails', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (170, NULL, NULL, N'ChangeSectionDepartRequest', N'GetWithOutSigById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (171, NULL, NULL, N'ChangeSectionDepartRequest', N'Get', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (172, NULL, NULL, N'ChangeSectionDepartRequest', N'Delete', N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (173, NULL, NULL, N'ChangeSectionDepartRequest', N'Post', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (174, NULL, NULL, N'ChangeSectionDepartRequest', N'Put', N'Put')
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] OFF
GO

SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ON 
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (306, 168, 15075, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (307, 169, 15075, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (308, 170 ,15077, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (309, 171, 15077, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (310, 172, 15078, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (311, 173, 15079, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (312, 174, 15079, NULL)

GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (313, 9, 15082, 57)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (314, 10, 15082, 57)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (315, 8, 15083, 57)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (316, 13, 15084, 57)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (317, 11, 15085, 57)
GO
---------------------------End 2022-08-15-----------

