﻿

--------------------------------------Ali 2019-10-29---------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (335, N'Transfer Request From Department ', N'طلب تحويل من قسم', 29, N'/WorkFlow/TransferRequestFromDepartment ', N'Index', N'fa fa-thumb-tack', N'get', 37, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (336, N'Transfer Request From Department Signature ', N'اعتماد طلب تحويل من قسم ', 108, N'/WorkFlow/TransferRequestFromDepartmentSignature', N'Index', N'fa fa-thumb-tack', N'get', 40, 1, 1)
Go


INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (4496, 335, 1)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (4497, 336, 1)
Go


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3438, N'طلب تحويل من قسم', N'Transfer Request From Department ', 335, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3439, N'عرض طلب تحويل من قسم', N'View Transfer Request From Department ', 335, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3440, N'اضافة طلب تحويل من قسم ', N'Add Transfer Request From Department ', 335, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3441, N'تعديل طلب تحويل من قسم', N'Edit Transfer Request From Department ', 335, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3442, N'حفظ طلب تحويل من قسم', N'Save Transfer Request From Department ', 335, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3443, N'حذف طلب تحويل من قسم', N'Delete Transfer Request From Department ', 335, 2)

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3444, N'اعتماد طلب تحويل من قسم', N'Transfer Request From Department Signature', 336, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3445, N' عرض اعتماد طلب تحويل من قسم ', N'View Transfer Request From Department Signature', 336, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3446, N' تعديل اعتماد طلب تحويل من قسم ', N'Edit Transfer Request From Department Signature', 336, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3447, N' حفظ اعتماد طلب تحويل من قسم ', N'Save Transfer Request From Department Signature', 336, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3448, N' حفظ متعدد اعتماد طلب تحويل من قسم ', N'Multiple Save Transfer Request  Signature', 336, 2)





--------------------------------------End 2019-10-29---------------------------
--------------------------------------Hammad 2019-10-30------------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WFChangeOvertimeTrack', N'Change Overtime Track Depend on Number Of hours', N'تغير مسار الوقت الإضافى بالنسبة لعدد الساعات', N'false', 2, 8, 1, 1, NULL, NULL, 3)
Go
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WFOverTimeHoursCountForChangeTrack', N'OverTime Hours Count For Change Track', N'عدد ساعات الوقت الاضافى لتغير المسار', N'3', 2, 9, 3, 1, NULL, NULL, 3)
 Go
 --------------------------------------End 2019-10-30------------------------

 ------------------------------------Sayed 2019-10-31------------------------
  INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFSyncPenaltyRequestToPenaltyRequest',N'Transfer of the penalty request directly to the penalty table in payroll',N'نقل طلب الجزاء الى جدول الجزاء في المرتبات مباشرة',N'false',2,3,1,1,Null,Null,13)
Go
---------------------------------End 2019-10-31----------------------------
 ------------------------------------Ali 2019-10-31------------------------
 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3449, N' الغاء طلب تحويل من قسم ', N'Cancel Transfer Request', 336, 2)
 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3450, N' عرض تاكيد موافقة الطلب ', N'Show Confirmed Approval Request', 336, 2)


SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WF_MasterRequests](
	[MasterRequestCode] [int] IDENTITY(1,1) NOT NULL,
	[RequestTypeCode] [int] NOT NULL,
	[TrackCode] [int] NOT NULL,
	[RequestDate] [datetime] NULL,
	[RequestDateHijri] [nvarchar](10) NULL,
	[MainType] [tinyint] NOT NULL,
	[DepartmentApproval] [tinyint] NOT NULL,
	[Notes] [nvarchar](500) NULL,
	[Canceled] [bit] NULL,
	[CancelRequestNumber] [int] 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_MasterRequests] 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_MasterRequests]  WITH CHECK ADD  CONSTRAINT [FK_WF_MasterRequests_SecurityUser] FOREIGN KEY([CreatedBy])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_MasterRequests] CHECK CONSTRAINT [FK_WF_MasterRequests_SecurityUser]
GO

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

ALTER TABLE [dbo].[WF_MasterRequests] CHECK CONSTRAINT [FK_WF_MasterRequests_SecurityUser1]
GO

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

ALTER TABLE [dbo].[WF_MasterRequests] CHECK CONSTRAINT [FK_WF_MasterRequests_WF_RequestStatus]
GO

ALTER TABLE [dbo].[WF_MasterRequests]  WITH CHECK ADD  CONSTRAINT [FK_WF_MasterRequests_WF_RequestType] FOREIGN KEY([RequestTypeCode])
REFERENCES [dbo].[WF_RequestType] ([RequestTypeId])
GO

ALTER TABLE [dbo].[WF_MasterRequests] CHECK CONSTRAINT [FK_WF_MasterRequests_WF_RequestType]
GO

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

ALTER TABLE [dbo].[WF_MasterRequests] CHECK CONSTRAINT [FK_WF_MasterRequests_WF_Track]
GO







SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WF_MasterRequestsSignature](
	[MasterRequestSignatureCode] [int] IDENTITY(1,1) NOT NULL,
	[MasterRequestCode] [int] NOT NULL,
	[UserCode] [int] NOT NULL,
	[StepNumber] [int] NOT NULL,
	[Approved] [tinyint] NOT NULL,
	[SignatureDate] [datetime] NULL,
	[SignatureDateHijri] [nvarchar](10) NULL,
	[SignatureTime] [nvarchar](10) NULL,
	[SignatureComment] [nvarchar](500) NULL,
	[SignatureCommentInverse] [nvarchar](500) NULL,
	[Turn] [int] NULL,
	[OldUserCode] [int] NULL,
	[ChangedBy] [int] NULL,
	[ChangeDate] [datetime] NULL,
	[UserTypeCode] [int] NULL,
 CONSTRAINT [PK_WF_MasterRequestsSignature] PRIMARY KEY CLUSTERED 
(
	[MasterRequestSignatureCode] 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_MasterRequestsSignature]  WITH CHECK ADD  CONSTRAINT [FK_WF_MasterRequestsSignature_SecurityUser] FOREIGN KEY([UserCode])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_MasterRequestsSignature] CHECK CONSTRAINT [FK_WF_MasterRequestsSignature_SecurityUser]
GO

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

ALTER TABLE [dbo].[WF_MasterRequestsSignature] CHECK CONSTRAINT [FK_WF_MasterRequestsSignature_WF_MasterRequests]
GO

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

ALTER TABLE [dbo].[WF_MasterRequestsSignature] CHECK CONSTRAINT [FK_WF_MasterRequestsSignature_WF_RequestStatus]
GO






SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WF_MasterRequestsCondition](
	[MasterRequestConditionCode] [int] IDENTITY(1,1) NOT NULL,
	[MasterRequestCode] [int] NOT NULL,
	[PositionConditionCode] [int] NOT NULL,
 CONSTRAINT [PK_WF_RequestCondition] PRIMARY KEY CLUSTERED 
(
	[MasterRequestConditionCode] 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_MasterRequestsCondition]  WITH CHECK ADD  CONSTRAINT [FK_WF_MasterRequestsCondition_PositionCondition] FOREIGN KEY([PositionConditionCode])
REFERENCES [dbo].[PositionCondition] ([PositionConditionCode])
GO

ALTER TABLE [dbo].[WF_MasterRequestsCondition] CHECK CONSTRAINT [FK_WF_MasterRequestsCondition_PositionCondition]
GO

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

ALTER TABLE [dbo].[WF_MasterRequestsCondition] CHECK CONSTRAINT [FK_WF_MasterRequestsCondition_WF_MasterRequests]
GO




SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WF_TransferRequest](
	[TransferRequestCode] [int] IDENTITY(1,1) NOT NULL,
	[MasterRequestCode] [int] NOT NULL,
	[EmployeeCode] [int] NOT NULL,
	[OldLocationCode] [tinyint] NOT NULL,
	[OldPositionCode] [nvarchar](30) NOT NULL,
	[OldDepartmentCode] [nvarchar](4) NOT NULL,
	[OldSectionCode] [nvarchar](6) NOT NULL,
	[NewLocationCode] [tinyint] NOT NULL,
	[NewPositionCode] [nvarchar](30) NOT NULL,
	[NewSectionCode] [nvarchar](6) NOT NULL,
	[NewDepartmentCode] [nvarchar](4) NOT NULL,
	[EffectDate] [datetime] NOT NULL,
	[EffectDateHijri] [nvarchar](10) NOT NULL,
 CONSTRAINT [PK_WF_TransferRequest] PRIMARY KEY CLUSTERED 
(
	[TransferRequestCode] 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_TransferRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_TransferRequest_Departments_New] FOREIGN KEY([NewDepartmentCode])
REFERENCES [dbo].[Departments] ([DepartmentCode])
GO

ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Departments_New]
GO

ALTER TABLE [dbo].[WF_TransferRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_TransferRequest_Departments_Old] FOREIGN KEY([OldDepartmentCode])
REFERENCES [dbo].[Departments] ([DepartmentCode])
GO

ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Departments_Old]
GO

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

ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Employees]
GO

ALTER TABLE [dbo].[WF_TransferRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_TransferRequest_Location_New] FOREIGN KEY([NewLocationCode])
REFERENCES [dbo].[Location] ([LocationCode])
GO

ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Location_New]
GO

ALTER TABLE [dbo].[WF_TransferRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_TransferRequest_Location_Old] FOREIGN KEY([OldLocationCode])
REFERENCES [dbo].[Location] ([LocationCode])
GO

ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Location_Old]
GO

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

ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_MasterRequests]
GO

ALTER TABLE [dbo].[WF_TransferRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_TransferRequest_Positions_New] FOREIGN KEY([NewPositionCode])
REFERENCES [dbo].[Positions] ([PositionCode])
GO

ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Positions_New]
GO

ALTER TABLE [dbo].[WF_TransferRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_TransferRequest_Positions_Old] FOREIGN KEY([OldPositionCode])
REFERENCES [dbo].[Positions] ([PositionCode])
GO

ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Positions_Old]
GO

ALTER TABLE [dbo].[WF_TransferRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_TransferRequest_Sections_New] FOREIGN KEY([NewSectionCode])
REFERENCES [dbo].[Sections] ([SectionCode])
GO

ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Sections_New]
GO

ALTER TABLE [dbo].[WF_TransferRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_TransferRequest_Sections_Old] FOREIGN KEY([OldSectionCode])
REFERENCES [dbo].[Sections] ([SectionCode])
GO

ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Sections_Old]
GO



--------------------------------End 2019-10-31----------------------------

--------------------------------Ali 2019-11-3----------------------------

  UPDATE [SystemMenu]
SET [ControllerName] = '/WorkFlow/TransferRequestFromDepartment'
 where SystemMenuCode=335
 --------------------------------End 2019-11-3----------------------------
