﻿--------------------------------------- Ali  2024-01-24 -------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1041,N'Translat Labels',N'ترجمة عناصر الشاشات',208,N'/LabelsName',N'Index','fa fa-thumb-tack',N'get',12,1,0)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1397,N'ترجمة عناصر الشاشات',N'Translat Labels',1041,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1398,N'عرض ترجمة عناصر الشاشات',N'View Translat Labels',1041,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1399,N'تعديل ترجمة عناصر الشاشات',N'Edit Translat Labels',1041,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1400,N'حفظ ترجمة عناصر الشاشات',N'Save Translat Labels',1041,2)
Go

--------------------------------------- End  2024-01-24 -------------
  --------------------------------------- AK 2024-01-24 ---------
  DROP TABLE DashboardCategoriesLabels
GO
DROP TABLE DashboardCharts
GO
DROP TABLE DashboardCategories
GO

DELETE [dbo].[SecurityUserDetail] WHERE PrivilegeID IN (1380,1388,1389,1390,1391,1392,1393,1394,1395,1396)
GO
DELETE [dbo].SecurityGroupDetail WHERE PrivilegeID IN (1380,1388,1389,1390,1391,1392,1393,1394,1395,1396)
GO
DELETE [dbo].[SecurityPrivilege] WHERE SystemMenuCode=1032
GO
DELETE [dbo].[SystemMenuModule] WHERE SystemMenuCode=1032
GO
DELETE [dbo].[SystemMenu] WHERE SystemMenuCode=1032
GO

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES (1032, N'General dashboard', N'لوحة القياس العامة', 115, '/GeneralDashboard', 'Index', N'fa fa-thumb-tack', 'get', 12, 1, 1)
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (1032, 6)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1380, N'لوحة القياس العامة', N'General dashboard', 1032, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1388, N'عدد العاملين بالشركة', N'Headcount Per Company', 1032, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1389, N'عدد العاملين بالقطاع', N'Headcount Per Division', 1032, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1390, N'المرتبات بالشركة', N'Salaries Per Company', 1032, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1391, N'عدد العاملين', N'Headcount', 1032, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1392, N'معدل دوران العاملين', N'Turnover', 1032, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1393, N'تعيين جديد', N'New Hire', 1032, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1394, N'استقالة', N'Resignation', 1032, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1395, N'اجمالي المرتبات', N'Total Gross Salary', 1032, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1396, N'صافي المرتبات', N'Total Net Salary', 1032, 2)
GO

CREATE TABLE [dbo].[DashboardCategories](
	[DashboardCategoryCode] [int] NOT NULL,
	[Name] [nvarchar](100) NOT NULL,
	[Arabic_Name] [nvarchar](100) NOT NULL,
	[IsVisable] [bit] NOT NULL,
 CONSTRAINT [PK_DashboardCategories] PRIMARY KEY CLUSTERED 
(
	[DashboardCategoryCode] 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].[DashboardCategoriesLabels](
	[DashboardCategoryLabelCode] [int] NOT NULL,
	[DashboardCategoryCode] [int] NOT NULL,
	[LabelEn] [nvarchar](100) NOT NULL,
	[LabelAr] [nvarchar](100) NOT NULL,
	[Sequence] [int] NOT NULL,
	[AreaName] [nvarchar](100) NULL,
	[ControllerName] [nvarchar](100) NOT NULL,
	[ActionName] [nvarchar](100) NOT NULL,
	[SecurityPrivilegeID] [int] NOT NULL,
	[IsVisable] [bit] NOT NULL,
 CONSTRAINT [PK_DashboardCategoriesLabels] PRIMARY KEY CLUSTERED 
(
	[DashboardCategoryLabelCode] 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].[DashboardCharts](
	[DashboardChartCode] [int] NOT NULL,
	[PackageName] [varchar](50) NOT NULL,
	[ChartType] [int] NOT NULL,
	[DashboardCategoryCode] [int] NOT NULL,
	[ChartTitleEn] [nvarchar](100) NOT NULL,
	[ChartTitleAr] [nvarchar](100) NOT NULL,
	[Sequence] [int] NOT NULL,
	[IsMain] [bit] NOT NULL,
	[AreaName] [nvarchar](100) NULL,
	[ControllerName] [nvarchar](100) NOT NULL,
	[ActionName] [nvarchar](100) NOT NULL,
	[Options] [nvarchar](2000) NOT NULL,
	[ResourceKeys] [varchar](200) NOT NULL,
	[SecurityPrivilegeID] [int] NOT NULL,
	[IsVisable] [bit] NOT NULL,
 CONSTRAINT [PK_DashboardCharts] PRIMARY KEY CLUSTERED 
(
	[DashboardChartCode] 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].[DashboardCategories] ([DashboardCategoryCode], [Name], [Arabic_Name], [IsVisable]) VALUES (1, N'Operations', N'التشغيل', 1)
GO
INSERT [dbo].[DashboardCategories] ([DashboardCategoryCode], [Name], [Arabic_Name], [IsVisable]) VALUES (2, N'Payroll', N'المرتبات', 1)
GO
INSERT [dbo].[DashboardCategoriesLabels] ([DashboardCategoryLabelCode], [DashboardCategoryCode], [LabelEn], [LabelAr], [Sequence], [AreaName], [ControllerName], [ActionName], [SecurityPrivilegeID], [IsVisable]) VALUES (1, 1, N'Headcount', N'عدد العاملين', 1, NULL, N'GeneralDashboard', N'GetHeadcount', 1391, 1)
GO
INSERT [dbo].[DashboardCategoriesLabels] ([DashboardCategoryLabelCode], [DashboardCategoryCode], [LabelEn], [LabelAr], [Sequence], [AreaName], [ControllerName], [ActionName], [SecurityPrivilegeID], [IsVisable]) VALUES (2, 1, N'Turnover', N'معدل دوران العاملين', 2, NULL, N'GeneralDashboard', N'GetTurnover', 1392, 1)
GO
INSERT [dbo].[DashboardCategoriesLabels] ([DashboardCategoryLabelCode], [DashboardCategoryCode], [LabelEn], [LabelAr], [Sequence], [AreaName], [ControllerName], [ActionName], [SecurityPrivilegeID], [IsVisable]) VALUES (3, 1, N'New Hire', N'تعيين جديد', 3, NULL, N'GeneralDashboard', N'GetNewHire', 1393, 1)
GO
INSERT [dbo].[DashboardCategoriesLabels] ([DashboardCategoryLabelCode], [DashboardCategoryCode], [LabelEn], [LabelAr], [Sequence], [AreaName], [ControllerName], [ActionName], [SecurityPrivilegeID], [IsVisable]) VALUES (4, 1, N'Resignation', N'استقالة', 4, NULL, N'GeneralDashboard', N'GetResignation', 1394, 1)
GO
INSERT [dbo].[DashboardCategoriesLabels] ([DashboardCategoryLabelCode], [DashboardCategoryCode], [LabelEn], [LabelAr], [Sequence], [AreaName], [ControllerName], [ActionName], [SecurityPrivilegeID], [IsVisable]) VALUES (5, 2, N'Total Gross Salary', N'اجمالي المرتبات', 2, NULL, N'GeneralDashboard', N'GetGrossSalaries', 1395, 1)
GO
INSERT [dbo].[DashboardCategoriesLabels] ([DashboardCategoryLabelCode], [DashboardCategoryCode], [LabelEn], [LabelAr], [Sequence], [AreaName], [ControllerName], [ActionName], [SecurityPrivilegeID], [IsVisable]) VALUES (6, 2, N'Total Net Salary', N'صافي المرتبات', 2, NULL, N'GeneralDashboard', N'GetNetSalaries', 1396, 1)
GO
INSERT [dbo].[DashboardCharts] ([DashboardChartCode], [PackageName], [ChartType], [DashboardCategoryCode], [ChartTitleEn], [ChartTitleAr], [Sequence], [IsMain], [AreaName], [ControllerName], [ActionName], [Options], [ResourceKeys], [SecurityPrivilegeID], [IsVisable]) VALUES (1, N'corechart', 1, 1, N'Headcount Per Company', N'عدد العاملين بالشركة', 1, 1, NULL, N'GeneralDashboard', N'GetEmployeesCountByLocation', N'{{title:''{0}'',pieSliceText:''percentage'',chartArea:{{left:''2%'',right:''2%'',top:''10%'',bottom:''2%'',}},is3D:true,}}', N'GoogleDashboardRes.HeadcountPerCompany', 1388, 1)
GO
INSERT [dbo].[DashboardCharts] ([DashboardChartCode], [PackageName], [ChartType], [DashboardCategoryCode], [ChartTitleEn], [ChartTitleAr], [Sequence], [IsMain], [AreaName], [ControllerName], [ActionName], [Options], [ResourceKeys], [SecurityPrivilegeID], [IsVisable]) VALUES (2, N'corechart', 1, 1, N'Headcount Per Division', N'عدد العاملين بالقطاع', 2, 1, NULL, N'GeneralDashboard', N'GetEmployeesCountByDivision', N'{{title:''{0}'',pieSliceText:''percentage'',chartArea:{{left:''2%'',right:''2%'',top:''10%'',bottom:''2%'',height:''100%'',width:''100%''}},is3D:true,}}', N'GoogleDashboardRes.HeadcountPerDivision', 1389, 1)
GO
INSERT [dbo].[DashboardCharts] ([DashboardChartCode], [PackageName], [ChartType], [DashboardCategoryCode], [ChartTitleEn], [ChartTitleAr], [Sequence], [IsMain], [AreaName], [ControllerName], [ActionName], [Options], [ResourceKeys], [SecurityPrivilegeID], [IsVisable]) VALUES (3, N'bar', 2, 2, N'Salaries Per Company', N'المرتبات بالشركة', 1, 1, NULL, N'GeneralDashboard', N'GetLocationsSalaries', N'{{title:''{0}'',bars:''horizontal'',titleTextStyle: {{color: ''545454'',fontSize: ''15'',fontWidth: ''normal'',alignment: ''center''}},hAxis: {{viewWindow: {{min: 0}}}},bar: {{ groupWidth: ''50%'' }} }}', N'GoogleDashboardRes.SalariesPerCompany', 1390, 1)
GO
INSERT [dbo].[DashboardCharts] ([DashboardChartCode], [PackageName], [ChartType], [DashboardCategoryCode], [ChartTitleEn], [ChartTitleAr], [Sequence], [IsMain], [AreaName], [ControllerName], [ActionName], [Options], [ResourceKeys], [SecurityPrivilegeID], [IsVisable]) VALUES (4, N'bar', 3, 2, N'Salaries Per Company', N'المرتبات بالشركة', 1, 1, NULL, N'GeneralDashboard', N'GetLocationsSalaries', N'{{title:''{0}'',bars:''horizontal'',titleTextStyle: {{color: ''545454'',fontSize: ''15'',fontWidth: ''normal'',alignment: ''center''}},hAxis: {{viewWindow: {{min: 0}}}},bar: {{ groupWidth: ''50%'' }} }}', N'GoogleDashboardRes.SalariesPerCompany', 1390, 1)
GO
ALTER TABLE [dbo].[DashboardCategories] ADD  CONSTRAINT [DF_DashboardCategories_IsVisable]  DEFAULT ((1)) FOR [IsVisable]
GO
ALTER TABLE [dbo].[DashboardCharts] ADD  CONSTRAINT [DF_DashboardCharts_ChartType]  DEFAULT ((1)) FOR [ChartType]
GO
ALTER TABLE [dbo].[DashboardCharts] ADD  CONSTRAINT [DF_DashboardCharts_IsMain]  DEFAULT ((0)) FOR [IsMain]
GO
ALTER TABLE [dbo].[DashboardCharts] ADD  CONSTRAINT [DF_DashboardCharts_IsVisable]  DEFAULT ((1)) FOR [IsVisable]
GO
ALTER TABLE [dbo].[DashboardCategoriesLabels]  WITH CHECK ADD  CONSTRAINT [FK_DashboardCategoriesLabels_DashboardCategories] FOREIGN KEY([DashboardCategoryCode])
REFERENCES [dbo].[DashboardCategories] ([DashboardCategoryCode])
GO
ALTER TABLE [dbo].[DashboardCategoriesLabels] CHECK CONSTRAINT [FK_DashboardCategoriesLabels_DashboardCategories]
GO
ALTER TABLE [dbo].[DashboardCategoriesLabels]  WITH CHECK ADD  CONSTRAINT [FK_DashboardCategoriesLabels_SecurityPrivilege] FOREIGN KEY([SecurityPrivilegeID])
REFERENCES [dbo].[SecurityPrivilege] ([ID])
GO
ALTER TABLE [dbo].[DashboardCategoriesLabels] CHECK CONSTRAINT [FK_DashboardCategoriesLabels_SecurityPrivilege]
GO
ALTER TABLE [dbo].[DashboardCharts]  WITH CHECK ADD  CONSTRAINT [FK_DashboardCharts_SecurityPrivilege] FOREIGN KEY([SecurityPrivilegeID])
REFERENCES [dbo].[SecurityPrivilege] ([ID])
GO
ALTER TABLE [dbo].[DashboardCharts] CHECK CONSTRAINT [FK_DashboardCharts_SecurityPrivilege]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Pie 1
Columns 2
Bars 3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DashboardCharts', @level2type=N'COLUMN',@level2name=N'ChartType'
GO
--------------------------------------- End AK 2024-01-24 ------------
--------------------------------------- mostafa 2024-01-24 ------------


INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (960, NULL, NULL, N'MonthlyEffectsRequest', N'SearchMonthlyEffectsRequest', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (961, NULL, NULL, N'MonthlyEffectsRequest', N'GetDetails', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (962, NULL, NULL, N'MonthlyEffectsRequest', N'GetWithOutSigById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (963, NULL, NULL, N'MonthlyEffectsRequest', N'Get', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (964, NULL, NULL, N'MonthlyEffectsRequest', N'Delete', N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (965, NULL, NULL, N'MonthlyEffectsRequest', N'Post', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (966, NULL, NULL, N'MonthlyEffectsRequest', N'Put', N'Put')


GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1243, 960, 3472, 27)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1244, 961, 3472, 27)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1245, 962 ,3474, 27)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1246, 963, 3474, 27)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1247, 964, 3476, 27)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1248, 965, 3475, 27)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1249, 966, 3474, 27)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1455,N'WorkFlow',N'MonthlyEffectsRequest',N'Index',0,N'get',3471)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1456,N'WorkFlow',N'MonthlyEffectsRequest',N'MonthlyEffectsRequest_Read',0,N'post',3472)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1457,N'WorkFlow',N'MonthlyEffectsRequest',N'Save',1,N'get',3473)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1458,N'WorkFlow',N'MonthlyEffectsRequest',N'Save',2,N'get',3474)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1459,N'WorkFlow',N'MonthlyEffectsRequest',N'Delete',0,N'post',3476)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1460,N'WorkFlow',N'MonthlyEffectsRequest',N'Save',0,N'post',3475)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1461,N'WorkFlow',N'MonthlyEffectsRequest',N'Cancel',0,N'post',3475)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1462,N'WorkFlow',N'MonthlyEffectsRequestSignature',N'Index',0,N'get',3478)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1463,N'WorkFlow',N'MonthlyEffectsRequestSignature',N'MonthlyEffectsRequestSignature_Read',0,N'post',3479)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1464,N'WorkFlow',N'MonthlyEffectsRequestSignature',N'Save',2,N'get',3480)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1465,N'WorkFlow',N'MonthlyEffectsRequestSignature',N'Save',0,N'post',3481)
GO
 INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1250, 12,3477, 27)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1251, 9,3479, 27)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1252, 10,3479, 27)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1253, 8,3480, 27)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1254, 13,3481, 27)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1255, 11,3483, 27)
GO

--------------------------------------- End 2024-01-24 ------------
--------------------------------------MNegm 2024-01-28 ------------------------------------


CREATE TABLE [dbo].[EmployeeFiltering](
	[EmployeeFiltersId] [int] IDENTITY(1,1) NOT NULL,
	[FromLocationCode] tinyint  NULL,
	[ToLocationCode] tinyint  NULL,
	[FromDivisionCode] NvarChar(50)  NULL,
	[ToDivisionCode] NvarChar(50)  NULL,
	[FromDepartmentCode] NvarChar(50)  NULL,
	[ToDepartmentCode] nvarchar(50)  NULL,
	[FromSectionCode] nvarchar(50)  NULL,
	[ToSectionCode] nvarchar(50)  NULL,
	[FromPositionCode] nvarchar(50)  NULL,
	[ToPositionCode] nvarchar(50)  NULL,
	[FromLevelCode] tinyint  NULL,
	[ToLevelCode] tinyint  NULL,
	[LocationCodes] nvarchar(Max)  NULL,
	[DivisionCodes] nvarchar(Max)  NULL,
	[DepartmentCodes] nvarchar(Max)  NULL,
	[SectionCodes] nvarchar(Max)  NULL,
	[PositionCodes] nvarchar(Max)  NULL,
	[LevelCodes] nvarchar(Max)  NULL,
	[TypeCode] tinyint NOT NULL, 
	[ReferenceId] int  NOT Null

PRIMARY KEY CLUSTERED 
(
	[EmployeeFiltersId] 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.NotificationTemplateType ADD
	NotificationTypeCondition nvarchar(Max) NULL 
GO 



INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
VALUES(13134,N'تعديل ترشيحات الموظفين ',N'Choose Employee Filtering ',582,2)
GO

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
VALUES(13135,N'تعديل ترشيحات الموظفين ',N'Choose Employee Filtering ',96,2)
GO
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
VALUES(13136,N'تعديل ترشيحات الموظفين ',N'Choose Employee Filtering ',481,2)
GO

------------------------------End  2024-01-28 -------------------------------------------------------------
------------------------------Mostafa  2024-01-30 -------------------------------------------------------------
CREATE TABLE [dbo].[WF_RequestSignaturesFile](
	[SignaturesFileCode] [int] IDENTITY(1,1) NOT NULL,
	[SignatureId] [bigint] NOT NULL,
	[RequestTypeCode] [int] NOT NULL,
	[FileName] [nvarchar](500) NOT NULL,
	[RequestId] [bigint] NOT NULL,
 CONSTRAINT [PK_WF_RequestSignaturesFile] PRIMARY KEY CLUSTERED 
(
	[SignaturesFileCode] 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
------------------------------End  2024-01-30 -------------------------------------------------------------
------------------------------Mostafa  2024-01-30 -------------------------------------------------------------


INSERT INTO ConfigLookup (ConfigLookupCode,Name, Arabic_Name, ConfigKey)
VALUES 
(92,N'Location', N'الموقع','VacEmployeeReplacement'),
(93,N'Org4', N'Org4','VacEmployeeReplacement'),
(94,N'Org5', N'Org5','VacEmployeeReplacement'),
(95,N'Org6', N'Org6','VacEmployeeReplacement'),
(96,N'Org7', N'Org7','VacEmployeeReplacement'),
(97,N'Org8', N'Org8','VacEmployeeReplacement'),
(98,N'Org9', N'Org9','VacEmployeeReplacement')
Go
------------------------------End  2024-01-30 -------------------------------------------------------------
--------------------------------MNegm 2024-01-31 --------------------------------------------------------------
INSERT INTO [dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES(15453,N' إمكانية تعديل نوع الجزاء ',N'Can Update penalty Code  ',126,2)
GO 
---------------------------------------- End 2024-01-31 ----------------------------------------------------
  --------------------------------------- AK 2024-01-31 ---------
BEGIN TRANSACTION
GO
ALTER TABLE dbo.FingerAreaCheckPointLogs ADD
	IsCheckPointInPolygon bit NOT NULL CONSTRAINT DF_FingerAreaCheckPointLogs_IsCheckPointInPolygon DEFAULT 0
GO
ALTER TABLE dbo.FingerAreaCheckPointLogs SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
--------------------------------------- End AK 2024-01-31 ------------