﻿--------------------------------------- Mostafa 2024-02-05 ------------

Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15454,N'طباعة طلب الإجازة',N'Vacation Request print',91,2)
go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15455,N'طباعه الطلب بالاعتماد',N'Print Request With Signature',91,2)
go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15456,N'طباعة إخلاء الطرف',N'Print Disclaimer Request',91,2)
go
-- Vacation Request print
INSERT INTO SecurityUserDetail (SecurityUserID, PrivilegeID, CreationDate, CreatedBy)
SELECT sec.SecurityUserID, 15454, GETDATE(), 1
FROM SecurityUserDetail sec 
WHERE sec.PrivilegeID = 3145;
GO
INSERT INTO SecurityGroupDetail (SecurityGroupID, PrivilegeID, CreationDate, CreatedBy)
SELECT gr.SecurityGroupID, 15454, GETDATE(), 1
FROM SecurityGroupDetail gr 
WHERE gr.PrivilegeID = 3145;
GO
-- Print Request With Signature
INSERT INTO SecurityUserDetail (SecurityUserID, PrivilegeID, CreationDate, CreatedBy)
SELECT sec.SecurityUserID, 15455, GETDATE(), 1
FROM SecurityUserDetail sec 
WHERE sec.PrivilegeID = 3145;
GO
INSERT INTO SecurityGroupDetail (SecurityGroupID, PrivilegeID, CreationDate, CreatedBy)
SELECT gr.SecurityGroupID, 15455, GETDATE(), 1
FROM SecurityGroupDetail gr 
WHERE gr.PrivilegeID = 3145;
GO
-- Print Disclaimer Request
INSERT INTO SecurityUserDetail (SecurityUserID, PrivilegeID, CreationDate, CreatedBy)
SELECT sec.SecurityUserID, 15456, GETDATE(), 1
FROM SecurityUserDetail sec 
WHERE sec.PrivilegeID = 3145;
GO
INSERT INTO SecurityGroupDetail (SecurityGroupID, PrivilegeID, CreationDate, CreatedBy)
SELECT gr.SecurityGroupID, 15456, GETDATE(), 1
FROM SecurityGroupDetail gr 
WHERE gr.PrivilegeID = 3145;
GO
--------------------------------------- End  2024-02-05 ------------

------------------------------------MNegm 2024-02-05 -----------------------
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1466,N'WorkFlow',N'CasualRequest',N'Index',0,N'get',3111)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1467,N'WorkFlow',N'CasualRequest',N'CasualRequest_Read',0,N'post',3112)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1468,N'WorkFlow',N'CasualRequest',N'Save',1,N'get',3113)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1469,N'WorkFlow',N'CasualRequest',N'Save',2,N'get',3114)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1470,N'WorkFlow',N'CasualRequest',N'Delete',0,N'post',3115)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1471,N'WorkFlow',N'CasualRequest',N'Save',0,N'post',3116)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1472,N'WorkFlow',N'CasualRequest',N'Cancel',0,N'post',3117)
Go


INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(967,NULL, NULL,N'CasualRequest',N'SearchCasualRequest',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(968,NULL, NULL,N'CasualRequest',N'GetDetails',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(969,NULL, NULL,N'CasualRequest',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(970,NULL, NULL,N'CasualRequest',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) 
VALUES(971,NULL, NULL,N'CasualRequest',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(972,NULL, NULL,N'CasualRequest',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(973,NULL, NULL,N'CasualRequest',N'CancelRequest',N'Post')
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1256,967,3112, 8)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) 
VALUES(1257,968,3112, 8)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1258,969,3116, 8)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) 
VALUES(1259,970,3116, 8)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1260,971,3115, 8)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) 
VALUES(1261,972,3114, 8)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) 
VALUES(1262,973,3117, 8)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1473,N'WorkFlow',N'CasualRequestSignature',N'Index',0,N'get',3118)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1474,N'WorkFlow',N'CasualRequestSignature',N'CasualRequestSignature_Read',0,N'post',3119)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1475,N'WorkFlow',N'CasualRequestSignature',N'Save',2,N'get',3120)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1476,N'WorkFlow',N'CasualRequestSignature',N'Save',0,N'post',3121)
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (974, NULL, NULL, N'CasualRequestSignature', N'GetSignatureById', N'Get')
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (975, NULL, NULL, N'CasualRequestSignature', N'GetCasualRequestSignatures', N'Get')
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (976, NULL, NULL, N'CasualRequestSignature', N'GetRequestSignaturesByUser', N'Post')
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (977, NULL, NULL, N'CasualRequestSignature', N'GetRequestHistory', N'Post')
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (978, NULL, NULL, N'CasualRequestSignature', N'SaveSignature', N'Post')
Go

 INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) 
 VALUES (1263,974, 3120, 8)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1264, 975, 3120, 8)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1265, 976, 3119, 8)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1266, 977, 3120, 8)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1267, 978, 3121, 8)
GO
------------------------------------- End 2024-02-05 ----------------------------
------------------------------------- Ali 2024-02-06 ----------------------------

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15457,N'عرض ملفات اخلاء الطرف',N'View Disclaimer Signature Fils',80,2)
Go
------------------------------------- End 2024-02-06 ----------------------------
------------------------------------- Hammad 2024-02-06 ----------------------------
delete [dbo].[SecurityGroupDetail]  where PrivilegeID=(select top 1 ID from [dbo].[SecurityPrivilege] where Id=13136 and SystemMenuCode=481 )
Go
delete [dbo].[SecurityUserDetail]  where PrivilegeID=(select top 1 ID from [dbo].[SecurityPrivilege] where Id=13136 and SystemMenuCode=481 ) 
Go
update [dbo].[SecurityPrivilege]  set ID=16038 where Id=13136 and SystemMenuCode=481
Go

delete [dbo].[SecurityGroupDetail]  where PrivilegeID=(select top 1 ID from [dbo].[SecurityPrivilege] where Id=13135 and SystemMenuCode=96 )
Go
delete [dbo].[SecurityUserDetail]  where PrivilegeID=(select top 1 ID from [dbo].[SecurityPrivilege] where Id=13135 and SystemMenuCode=96 ) 
Go
update [dbo].[SecurityPrivilege]  set ID=15458 where Id=13135 and SystemMenuCode=96
Go
update [dbo].[SecurityPrivilege] set DescriptionAR=N' ترشيحات الموظفين ' ,[DescriptionEN]=N'Employee Filtering ' Where ID in (13134,15458,16038) 
Go
ALTER TABLE [dbo].[NotificationRecieverDetail] DROP CONSTRAINT [FK_EmailRecieverDetail_EmailTemplateType]
GO
------------------------------------- End 2024-02-06 ----------------------------
------------------------------------- Hammad 2024-02-07 -------------------------
	
 CREATE TABLE [dbo].[HealthInsuranceCard](
	[EmployeeCode] [int] NOT NULL,
	[CardNumber] [nvarchar](255) NULL,
	[IssuePlace] [nvarchar](255) NULL,
	[IssueDate] [datetime] NULL,
	[IssueDateHijri] [nvarchar](10) NULL,
	[ExpireDate] [datetime] NULL,
	[ExpireDateHijri] [nvarchar](10) NULL,
	[HealthInsuranceTypeCode] [nvarchar](3) NULL,
	[SigningPrimaryMedicalExaminationDate] [datetime] NULL,
	[SigningPrimaryMedicalExaminationDateHijri] [nvarchar](10) NULL,
	[PrimaryMedicalExaminationNumber] [nvarchar](100) NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_HealthInsuranceCard_EmployeeCode] PRIMARY KEY CLUSTERED 
(
	[EmployeeCode] 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

update NotificationTemplateType set IsNotificationTimingEnabled=1,IsDurationEnabled=1 where NotificationTemplateTypeCode  IN(3,4,5)
Go


------------------------------------- End 2024-02-07 -------------------------

-------------------------------------M.Negm 2024-02-08 ----------------------------

	INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
	VALUES(1042,N'Employee Filtering ',N'ترشيحات الموظفين ',N'',N'/EmployeeFiltering',N'Index','fa fa-thumb-tack',N'get',NULL,0,0)
	Go
------------------------------------- End 2024-02-08 ----------------------------
------------------------------------- MOstafa 2024-02-08 ----------------------------
update SystemMenu set IsVisible=0 where SystemMenuCode=487
Go
update ConfigParameter set ConfigCategoryCode=21 where ConfigCategoryCode=13
Go
update ConfigParameter set OrderNo=7 where ConfigKey='NotifMaxNumberOfEmployeeInGroup' 
Go
------------------------------------- End 2024-02-08 ----------------------------
