﻿------------------------------------------Mostafa  2024-05-07 ------------------------
ALTER TABLE dbo.WF_OverTimeRequest ADD
	PermissionRequestId bigint NULL
------------------------------------------End  2024-05-07 ------------------------
--------------------------------------- AK 2024-05-07 ---------
UPDATE [dbo].[DashboardCategoriesLabels] SET [LabelEn]=N'HR & Admin Team', [LabelAr]=N'عدد الموارد البشرية', [ActionName]='GetHrCount'  WHERE [DashboardCategoryLabelCode]=104
UPDATE [dbo].[DashboardCategoriesLabels] SET [LabelEn]=N'HR Team vs HC %', [LabelAr]=N'نسبة الموارد البشرية', [ActionName]='GetHrPrecentage'  WHERE [DashboardCategoryLabelCode]=105
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1418, N'الذكور والاناث - شكل فرعي دائري', N'Male - Female - SubChart Pie', 1032, 2)
INSERT [dbo].[DashboardCharts] ([DashboardChartCode], [PackageName], [ChartType], [DashboardCategoryCode], [ChartTitleEn], [ChartTitleAr], [Sequence], [IsMain], [AreaName], [ControllerName], [ActionName], [Options], [ResourceKeys], [SecurityPrivilegeID], [IsVisable], [BootstrapColumnsCount]) VALUES (106, N'corechart', 1, 1, N'Male - Female %', N'الذكور والاناث', 7, 0, NULL, N'GeneralDashboard', N'GetMaleFemaleCount', N'{{title:''{0}'',pieSliceText:''percentage'',chartArea:{{left:''2%'',right:''2%'',top:''10%'',bottom:''2%'',height:''100%'',width:''100%''}},is3D:true,}}', N'GoogleDashboardRes.MaleFemale', 1418, 1, 6)
UPDATE [dbo].[DashboardCharts] SET [BootstrapColumnsCount]=4 WHERE [DashboardChartCode] IN (100,101,106)
GO
--------------------------------------- End AK 2024-05-07 ------------
--------------------------------------- Ali  2024-05-07 ------------

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1803, N'WorkFlow', N'OverTimeRequestFinalSignatureApi', N'Index', 0, N'get', 3386)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1804, N'WorkFlow', N'OverTimeRequestFinalSignatureApi', N'OverTimeRequestFinal_Read', 0, N'post', 3387)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1805, N'WorkFlow', N'OverTimeRequestFinalSignatureApi', N'Save', 2, N'get', 3388)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1806, N'WorkFlow', N'OverTimeRequestFinalSignatureApi', N'Save', 0, N'post', 3389)
Go
--------------------------------------- End  2024-05-07 ------------
--------------------------------------- Hammad  2024-05-08 ---------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'WF_TransferContractAfterDocumented', N'Transfer Contract After Documented', N'نقل العقود بعد التوثيق ', N'true', 2, 2, 1, 1, NULL, NULL, 60, NULL)
GO
--------------------------------------- End  2024-05-08 ------------