﻿--------------------------Ali 2021-06-08--------------------------------


CREATE TABLE [dbo].[WF_RequestTypeGroup](
	[RequestTypeGroupCode] [int] IDENTITY(1,1) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[IsVisible] [bit] NOT NULL,
 CONSTRAINT [PK_WF_RequestTypeGroup] PRIMARY KEY CLUSTERED 
(
	[RequestTypeGroupCode] 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_RequestTypeGroup] ADD  CONSTRAINT [DF_WF_RequestTypeGroup_IsVisible]  DEFAULT ((1)) FOR [IsVisible]
GO


 ALTER TABLE dbo.WF_RequestType ADD
	RequestTypeGroupCode int NULL
GO
ALTER TABLE dbo.WF_RequestType ADD CONSTRAINT
	FK_WF_RequestType_WF_RequestTypeGroup FOREIGN KEY
	(
	RequestTypeGroupCode
	) REFERENCES dbo.WF_RequestTypeGroup
	(
	RequestTypeGroupCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO

SET IDENTITY_INSERT [dbo].[WF_RequestTypeGroup] ON 

INSERT [dbo].[WF_RequestTypeGroup] ([RequestTypeGroupCode], [Arabic_Name], [Name],[IsVisible]) VALUES (1, N'الطلبات الادارية', N'Administrative requests',1)
INSERT [dbo].[WF_RequestTypeGroup] ([RequestTypeGroupCode], [Arabic_Name], [Name],[IsVisible]) VALUES (2, N'الطلبات المالية', N'Financial requests',1)
INSERT [dbo].[WF_RequestTypeGroup] ([RequestTypeGroupCode], [Arabic_Name], [Name],[IsVisible]) VALUES (3, N'طلبات الحضور والإنصراف', N'Attendance requests',1)
INSERT [dbo].[WF_RequestTypeGroup] ([RequestTypeGroupCode], [Arabic_Name], [Name],[IsVisible]) VALUES (4, N'طلبات التوظيف', N'Recruit Requests',1)
INSERT [dbo].[WF_RequestTypeGroup] ([RequestTypeGroupCode], [Arabic_Name], [Name],[IsVisible]) VALUES (5, N'طلبات المخازن', N'Inventory Requests',1)
INSERT [dbo].[WF_RequestTypeGroup] ([RequestTypeGroupCode], [Arabic_Name], [Name],[IsVisible]) VALUES (6, N'الطلبات الاكاديمى', N'Academic Requests',0)
SET IDENTITY_INSERT [dbo].[WF_RequestTypeGroup] OFF
Go																							     
																							     
																							     
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=3 where [RequestTypeId]=2       
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=3       
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=4       
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=4 where [RequestTypeId]=5       
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=3 where [RequestTypeId]=6       
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=7       
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=4 where [RequestTypeId]=8       
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=2 where [RequestTypeId]=9       
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=2 where [RequestTypeId]=10      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=3 where [RequestTypeId]=11      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=12      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=13      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=4 where [RequestTypeId]=14      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=2 where [RequestTypeId]=15      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=16      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=17      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=3 where [RequestTypeId]=18      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=19      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=20      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=3 where [RequestTypeId]=21      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=3 where [RequestTypeId]=22      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=5 where [RequestTypeId]=23      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=5 where [RequestTypeId]=24      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=4 where [RequestTypeId]=25      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=4 where [RequestTypeId]=26      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=2 where [RequestTypeId]=27      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=5 where [RequestTypeId]=28      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=29      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=2 where [RequestTypeId]=30      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=2 where [RequestTypeId]=31      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=6 where [RequestTypeId]=32      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=6 where [RequestTypeId]=33      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=6 where [RequestTypeId]=34      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=6 where [RequestTypeId]=35      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=6 where [RequestTypeId]=36      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=6 where [RequestTypeId]=37      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=6 where [RequestTypeId]=38      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=6 where [RequestTypeId]=39      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=6 where [RequestTypeId]=40      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=6 where [RequestTypeId]=41      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=42      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=43      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=44      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=45      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=46      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=47      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=48      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=49      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=50      

update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=51      
update [dbo].[WF_RequestType] set  RequestTypeGroupCode=1 where [RequestTypeId]=52      
Go




update SystemMenu set ParentID=496 ,Sequence= 21
where SystemMenuCode=492
Go


     ALTER TABLE [TimeSheet]ALTER COLUMN [01] nvarchar(3)
     ALTER TABLE [TimeSheet]ALTER COLUMN [02] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [03] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [04] nvarchar(3)
     ALTER TABLE [TimeSheet]ALTER COLUMN [05] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [06] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [07] nvarchar(3)
     ALTER TABLE [TimeSheet]ALTER COLUMN [08] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [09] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [10] nvarchar(3)
     ALTER TABLE [TimeSheet]ALTER COLUMN [11] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [12] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [13] nvarchar(3)
     ALTER TABLE [TimeSheet]ALTER COLUMN [14] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [15] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [16] nvarchar(3)
     ALTER TABLE [TimeSheet]ALTER COLUMN [17] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [18] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [19] nvarchar(3)
     ALTER TABLE [TimeSheet]ALTER COLUMN [20] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [21] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [22] nvarchar(3)
     ALTER TABLE [TimeSheet]ALTER COLUMN [23] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [24] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [25] nvarchar(3)
     ALTER TABLE [TimeSheet]ALTER COLUMN [26] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [27] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [28] nvarchar(3)
     ALTER TABLE [TimeSheet]ALTER COLUMN [29] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [30] nvarchar(3)
	 ALTER TABLE [TimeSheet]ALTER COLUMN [31] nvarchar(3)
	 Go

 --------------------------End 2021-06-08--------------------------------
 --------------------------Ali 2021-06-09--------------------------------

CREATE TABLE [dbo].[Orientations](
	[OrientationCode] [int] IDENTITY(1,1) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[DisplayFromHiringDate] [datetime] NOT NULL,
	[FileName] [nvarchar](500) NULL,
	[SendNotifications] [bit] NOT NULL,
	[SendNotificationsAfterHour] [int] NULL,
	[Note] [nvarchar](250) NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
 CONSTRAINT [PK_Orientation] PRIMARY KEY CLUSTERED 
(
	[OrientationCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO


CREATE TABLE [dbo].[EmployeOrientation](
	[EmployeOrientationCode] [int] IDENTITY(1,1) NOT NULL,
	[OrientationCode] [int] NOT NULL,
	[EmployeCode] [int] NOT NULL,
	[Closed] [bit] NOT NULL,
	[ClosedDate] [datetime] NOT NULL,
	[EmployeNote] [nvarchar](250) NULL,
 CONSTRAINT [PK_EmployeOrientation] PRIMARY KEY CLUSTERED 
(
	[EmployeOrientationCode] 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].[EmployeOrientation]  WITH CHECK ADD  CONSTRAINT [FK_EmployeOrientation_Orientation] FOREIGN KEY([OrientationCode])
REFERENCES [dbo].[Orientations] ([OrientationCode])
GO

ALTER TABLE [dbo].[EmployeOrientation] CHECK CONSTRAINT [FK_EmployeOrientation_Orientation]
GO

	
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(538,N'Orientation',N'التوجيهات',402,N'/Orientation',N'Index','fa fa-thumb-tack',N'get',3,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1278,N'التوجيهات',N'Orientation',538,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1279,N'عرض التوجيهات',N'View Orientation',538,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1280,N'إضافة التوجيهات',N'Add Orientation',538,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1281,N'تعديل التوجيهات',N'Edit Orientation',538,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1282,N'حذف التوجيهات',N'Delete Orientation',538,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1283,N'حفظ التوجيهات',N'Save Orientation',538,2)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(539,N'Employe Orientation',N'توجيهات الموظف',402,N'/EmployeOrientation',N'Index','fa fa-thumb-tack',N'get',4,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1284,N'توجيهات الموظف',N'Employe Orientation',539,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1285,N'عرض توجيهات الموظف',N'View Employe Orientation',539,2)
Go

 --------------------------End 2021-06-09--------------------------------
 --------------------------Hammad 2021-06-09-----------------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'ShowEmployeesSubContracts', N'Show Employees Sub Contracts', N'  عرض العقود الفرعية للموظف', N'true', 7, 11, 1, 1, NULL, NULL, NULL)
 --------------------------End 2021-06-09-----------------------------