﻿ --------------------------------------- AK 2024-02-13 ---------
BEGIN TRANSACTION
GO
ALTER TABLE dbo.DashboardCategoriesLabels ADD IsMain bit NOT NULL CONSTRAINT DF_DashboardCategoriesLabels_IsMain DEFAULT 1
GO
ALTER TABLE dbo.DashboardCategoriesLabels SET (LOCK_ESCALATION = TABLE)
GO
COMMIT

BEGIN TRANSACTION
GO
ALTER TABLE dbo.DashboardCharts ADD BootstrapColumnsCount int NOT NULL CONSTRAINT DF_DashboardCharts_BootstrapColumnsCount DEFAULT 6
GO
ALTER TABLE dbo.DashboardCharts SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
--------------------------------------- End AK 2024-02-13 ------------

--------------------------------------- M.Negm 2024-02-13-------------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1043,N'Hire Candidate Request',N'طلب تعيين المرشحين ',495,N'/WorkFlow/HireCandidateRequest',N'Index','fa fa-thumb-tack',N'get',8,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1043,1)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15459,N'طلب تعيين المرشحين',N'Hire Candidate Request',1043,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15460,N'عرض طلب تعيين المرشحين',N'View Hire Candidate Request',1043,2)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15461,N'تعديل طلب تعيين المرشحين',N'Edit Hire Candidate Request',1043,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15462,N'حذف طلب تعيين المرشحين',N'Delete Hire Candidate Request',1043,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15463,N'حفظ طلب تعيين المرشحين',N'Save Hire Candidate Request',1043,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15464,N'الغاء طلب تعيين المرشحين',N'Cancel Hire Candidate Request',1043,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1483,N'WorkFlow',N'HireCandidateRequest',N'Index',0,N'get',15459)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1484,N'WorkFlow',N'HireCandidateRequest',N'HireCandidateRequest_Read',0,N'post',15460)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1485,N'WorkFlow',N'HireCandidateRequest',N'Save',2,N'get',15461)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1486,N'WorkFlow',N'HireCandidateRequest',N'Delete',0,N'post',15462)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1487,N'WorkFlow',N'HireCandidateRequest',N'Cancel',0,N'post',15464)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1273, 979, 15460, 53)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1274, 980, 15460, 53)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1275, 981, 15463, 53)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1276, 983, 15462, 53)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) 
VALUES (1277, 12, 15464, 53)
GO
--------------------------------------- End 2024-02-13  ---------------------
-------------------------------------- M.Negm 2024-02-14 --------------------------
ALTER TABLE dbo.SecurityUser ADD
	AttendanceByProject bit NOT NULL CONSTRAINT DF_SecurityUser_AttendanceByProject DEFAULT ((0))
GO
------------------------------------- End 2024-02-14 ------------------------------
------------------------------------- Hammad 2024-02-15 ---------------------------
ALTER TABLE dbo.Reports ADD
	ReportNameEn nvarchar(150) NULL
GO

ALTER TABLE [dbo].[Reports] DROP CONSTRAINT [DF_Reports_LanguageId_1]
GO

ALTER TABLE dbo.Reports
	DROP COLUMN LanguageId
GO

------------------------------------- End 2024-02-15 ------------------------------