﻿-------------------------------------Negm 26-9-2023------------------------------

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1242,N'WorkFlow',N'NewEmployeesRequest',N'Index',0,N'get',3228)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1243,N'WorkFlow',N'NewEmployeesRequest',N'NewEmployeesRequest_Read',0,N'post',3229)
Go

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

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

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

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

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

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

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1256,N'WorkFlow',N'NewEmployeesRequestSignature',N'NewEmployeesRequestSignature_Read',0,N'post',3236)
GO

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

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

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

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (827, NULL, NULL, N'NewEmplyeesRequestSignature', N'GetNewEmployeesRequestSignatures', N'Get')
GO

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

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

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (830, NULL, NULL, N'NewEmplyeesRequestSignature', N'CancelRequest', N'Post')
GO

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

 INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) 
 VALUES (1051, 826, 3237, 14)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1052, 827, 3237, 14)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1053, 828, 3236, 14)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1054, 829, 3237, 14)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1055, 830, 3234, 14)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1056, 831, 3238, 14)
Go


------------------------------------ End ----------------------------------------

--------------------------Ali 2023-09-26-----------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1019,N'Notifications',N'الاشعارات',479,N'',N'','fa fa-thumb-tack',N'',3,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1019,13)
Go



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1020,N'Employees Notifications',N'اشعارات الموظفين',1019,N'/NotificationService/EmployeeNotification',N'Index','fa fa-thumb-tack',N'get',1,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1020,13)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(16036,N'اشعارات الموظفين',N'Employees Notifications',1020,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(16037,N'عرض اشعارات الموظفين',N'View Employees Notifications',1020,2)
Go



INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1249,N'NotificationService',N'EmployeeNotification',N'Index',0,N'get',16036)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1250,N'NotificationService',N'EmployeeNotification',N'EmployeeNotification_Read',0,N'post',16037)

Go

--------------------------End 2023-09-26-----------------------------
--------------------------Hammad 2023-09-27--------------------------
delete ConfigParameter where ConfigKey='RedirectLinkText'

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'RedirectLinkText', N'Redirect link text', N'الاسم الظاهر على رابط الايميل', N'اضغط هنا', 1, 54, 4, 1, NULL, NULL, NULL, N'الاسم الظاهر على رابط الايميل')
GO
--------------------------End 2023-09-27--------------------------
--------------------------Hammad 2023-10-02-----------------------
ALTER TABLE dbo.WF_Track ADD
	TimePermissionCode tinyint NULL
GO

ALTER TABLE dbo.TimePermissionsTypes ADD
	HaveDifferentTrack bit NOT NULL CONSTRAINT DF_TimePermissionsTypes_HaveDifferentTrack DEFAULT ((0))
GO

--------------------------End 2023-10-02-----------------------
--------------------------Hammad 2023-10-03--------------------
ALTER TABLE dbo.WF_MissionPlaceLevel ADD
	BandCode int NULL
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'WF_MissionPlaceBandWithLevel', N'Mission Place Band With Level', N'البند مع المستوى الوظيفى لمكان المامورية', N'false',2, 19, 1, 1, NULL, NULL, 0, N'امكانية تحديد اكثر من بند وكل بند له قيمة معينة فى المكان الواحد')
GO
--------------------------End 2023-10-03-----------------------
--------------------------Ali 2023-10-03--------------------
update [SecurityPrivilegeEndPoints] set [ControllerName]=N'NewEmplyeesRequest' where  Id=830
GO
--------------------------End 2023-10-03-----------------------

