
   ------------------------------Ali 2020-05-14--------------------

   INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (250, N'Organization Structure', N'الهيكل الإدارى', 52, NULL, NULL, NULL, NULL, 9, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (251, N'Organization Group', N'مجموعة الهيكل الإدارى', 250, N'/BasicData/OrganizationGroup', N'Index', NULL, N'get', 3, 1, 1)
 Go

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

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1210, N'مجموعة الهيكل الإدارى', N'Organization Group', 251, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1211, N'عرض مجموعة الهيكل الإدارى', N'View Organization Group', 251, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1212, N'إضافة مجموعة الهيكل الإدارى', N'Add Organization Group', 251, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1213, N'تعديل مجموعة الهيكل الإدارى', N'Edit Organization Group', 251, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1214, N'حفظ مجموعة الهيكل الإدارى', N'Save Organization Group', 251, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1215, N'حذف مجموعة الهيكل الإدارى', N'Delete Organization Group', 251, 2)
 Go
 
 update [SystemMenu] 
  set ParentID=250 ,Sequence=1
  where SystemMenuCode=248
   Go

  update [SystemMenu] 
  set ParentID=250 ,Sequence=2
  where SystemMenuCode=249
   Go
      ------------------------------End 2020-05-14--------------------
      ------------------------------Hammad 2020-05-14--------------------

CREATE TABLE [dbo].[FieldsDataSource](
	[FieldDataSourceCode] [int] NOT NULL,
	[FieldName] [nvarchar](50) NULL,
	[DescriptionAr] [nvarchar](50) NULL,
	[DescriptionEn] [nvarchar](50) NULL,
	[FieldDataType] [int] NOT NULL,
	[Area] [nvarchar](100) NULL,
	[Controller] [nvarchar](100) NULL,
	[Action] [nvarchar](100) NULL,
 CONSTRAINT [PK_FieldsDataSource] PRIMARY KEY CLUSTERED 
(
	[FieldDataSourceCode] 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].[FieldsDataSource] ([FieldDataSourceCode], [FieldName], [DescriptionAr], [DescriptionEn], [FieldDataType], [Area], [Controller], [Action]) VALUES (1, N'BirthDate', N'تاريخ الميلاد', N'Birth date', 2, NULL, NULL, NULL)
INSERT [dbo].[FieldsDataSource] ([FieldDataSourceCode], [FieldName], [DescriptionAr], [DescriptionEn], [FieldDataType], [Area], [Controller], [Action]) VALUES (2, N'DepartmentCode', N'الادارة', N'Department', 4, N'BasicData', N'Department', N'GetDepartmentsWithCodes')
INSERT [dbo].[FieldsDataSource] ([FieldDataSourceCode], [FieldName], [DescriptionAr], [DescriptionEn], [FieldDataType], [Area], [Controller], [Action]) VALUES (3, N'DivisionCode', N'القطاع', N'Division', 4, N'BasicData', N'Division', N'GetDivisionsWithCodes')
INSERT [dbo].[FieldsDataSource] ([FieldDataSourceCode], [FieldName], [DescriptionAr], [DescriptionEn], [FieldDataType], [Area], [Controller], [Action]) VALUES (4, N'HiringDate', N'تاريخ التعيين', N'Hiring date', 2, NULL, NULL, NULL)
INSERT [dbo].[FieldsDataSource] ([FieldDataSourceCode], [FieldName], [DescriptionAr], [DescriptionEn], [FieldDataType], [Area], [Controller], [Action]) VALUES (5, N'InsuranceCode', N'التأمين', N'Insurance', 3, NULL, N'Common', N'GetInsuranceWithCodes')
INSERT [dbo].[FieldsDataSource] ([FieldDataSourceCode], [FieldName], [DescriptionAr], [DescriptionEn], [FieldDataType], [Area], [Controller], [Action]) VALUES (6, N'LevelCode', N'المستوى', N'Level', 3, NULL, N'Common', N'GetLevelsWithCodes')
INSERT [dbo].[FieldsDataSource] ([FieldDataSourceCode], [FieldName], [DescriptionAr], [DescriptionEn], [FieldDataType], [Area], [Controller], [Action]) VALUES (7, N'LocationCode', N'المنطقة', N'Location', 3, N'BasicData', N'Location', N'GetLocationsWithCodes')
INSERT [dbo].[FieldsDataSource] ([FieldDataSourceCode], [FieldName], [DescriptionAr], [DescriptionEn], [FieldDataType], [Area], [Controller], [Action]) VALUES (8, N'NationalityCode', N'الجنسية', N'Nationality', 3, NULL, N'Common', N'GetNationalityWithCodes')
INSERT [dbo].[FieldsDataSource] ([FieldDataSourceCode], [FieldName], [DescriptionAr], [DescriptionEn], [FieldDataType], [Area], [Controller], [Action]) VALUES (9, N'PositionCode', N'الوظيفة', N'Position', 4, N'Personal', N'Position', N'GetAllPositionsWithCodes')
INSERT [dbo].[FieldsDataSource] ([FieldDataSourceCode], [FieldName], [DescriptionAr], [DescriptionEn], [FieldDataType], [Area], [Controller], [Action]) VALUES (10, N'SectionCode', N'القسم', N'Section', 4, N'BasicData', N'Section', N'GetSectionsWithCodes')
INSERT [dbo].[FieldsDataSource] ([FieldDataSourceCode], [FieldName], [DescriptionAr], [DescriptionEn], [FieldDataType], [Area], [Controller], [Action]) VALUES (11, N'Gender', N'النوع', N'Gender', 1, NULL, N'Common', N'GetGender')
Go
      ------------------------------End 2020-05-14--------------------   
	  ------------------------------Hammad 2020-05-17-----------------	  
	  ALTER TABLE dbo.VacationType ADD
	  ShowVacationTime bit NOT NULL CONSTRAINT DF_VacationType_ShowVacationTime DEFAULT 0
       GO
	   ALTER TABLE dbo.WF_VacationRequest ADD
	TimeFrom time(5) NULL,
	TimeTo time(5) NULL
         GO
 ALTER TABLE dbo.WF_VacationRequest ADD
	ShowVacationTime bit NOT NULL CONSTRAINT DF_WF_VacationRequest_ShowVacationTime DEFAULT 0
 GO
 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
 VALUES (3534, N'   طلب اجازة مجمعة بالوقت', N'  Combined Vacations Request Time', 91, 2)
 Go
	  ------------------------------End 2020-05-17-----------------
	  ------------------------------Ali 2020-05-19-----------------	  

	  INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (252, N'Organisation Charts', N'مخطط الهيكل الإدارى', 250, N'/BasicData/OrganisationChart', N'Index', NULL, N'get', 4, 1, 1)
Go

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

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1216, N'مخطط الهيكل الإدارى', N'Organisation Charts', 252, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1217, N'عرض مخطط الهيكل الإدارى', N'View Organisation Charts', 252, 2)
Go
 ------------------------------End 2020-05-19-----------------
 ------------------------------Hammad 2020-06-01--------------
  ALTER TABLE dbo.WF_OverTimeRequestFinalSignature ADD
	ActualMinutesMorning float(53) NULL,
	ActualMinutesEvening float(53) NULL
GO
 ------------------------------End 2020-06-01-----------------


