﻿ --------------------------------------Ali 2024-04-23 -----------------------------------

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1731, N'WorkFlow', N'LoanRequestSignatureApi', N'Index', 0, N'get', 3129)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1732, N'WorkFlow', N'LoanRequestSignatureApi', N'LoanRequest_Read', 0, N'post', 3130)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1733, N'WorkFlow', N'LoanRequestSignatureApi', N'Save', 2, N'get', 3131)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1734, N'WorkFlow', N'LoanRequestSignatureApi', N'Save', 0, N'post', 3132)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1739, N'WorkFlow', N'LoanRequestApi', N'Index', 0, N'get', 3122)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1740, N'WorkFlow', N'LoanRequestApi', N'LoanRequest_Read', 0, N'post', 3123)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1741, N'WorkFlow', N'LoanRequestApi', N'Save', 1, N'get', 3124)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1742, N'WorkFlow', N'LoanRequestApi', N'Save', 2, N'get', 3125)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1743, N'WorkFlow', N'LoanRequestApi', N'Delete', 0, N'post', 3126)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1744, N'WorkFlow', N'LoanRequestApi', N'Save', 0, N'post', 3132)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1745, N'WorkFlow', N'LoanRequestApi', N'Cancel', 0, N'post', 3128)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1779, N'WorkFlow', N'OverTimeRequestApi', N'Index', 0, N'get',3052 )
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1780, N'WorkFlow', N'OverTimeRequestApi', N'OverTimeRequest_Read', 0, N'post', 3053)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1781, N'WorkFlow', N'OverTimeRequestApi', N'Save', 1, N'get', 3054)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1782, N'WorkFlow', N'OverTimeRequestApi', N'Save', 2, N'get', 3055)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1783, N'WorkFlow', N'OverTimeRequestApi', N'Delete', 0, N'post', 3056)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1784, N'WorkFlow', N'OverTimeRequestApi', N'Save', 0, N'post', 3058)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1785, N'WorkFlow', N'OverTimeRequestApi', N'Cancel', 0, N'post', 3057)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1786, N'WorkFlow', N'OverTimeRequestSignatureApi', N'Index', 0, N'get', 3059)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1787, N'WorkFlow', N'OverTimeRequestSignatureApi', N'OverTimeRequest_Read', 0, N'post', 3060)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1788, N'WorkFlow', N'OverTimeRequestSignatureApi', N'Save', 2, N'get', 3061)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1789, N'WorkFlow', N'OverTimeRequestSignatureApi', N'Save', 0, N'post', 3062)
Go

  --------------------------------------End 2024-04-23 -----------------------------------
  --------------------------------------Hammad 2024-04-24 --------------------------------

ALTER TABLE dbo.WF_FingerPrintType ADD
	RequestMaxNumberPeDay int NULL
GO

delete ConfigParameter where ConfigKey='Wf_FingerprintMaximumRequestPeDay'
GO

ALTER TABLE dbo.WF_NewHireRequest ADD
	BankCode tinyint NULL,
	DirectManagerCode int NULL,
	AccountNo nvarchar(50) NULL,
	BuildingNo nvarchar(100) NULL,
	RoomNo nvarchar(50) NULL,
	ExtensionNumber nvarchar(50) NULL
GO

  --------------------------------------End 2024-04-23 --------------------------------
--------------------------------------- AK 2024-04-24 ---------
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1208,NULL, NULL,N'RecruitJob',N'GetRecruitJobSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1209,NULL, NULL,N'RecruitJob',N'GetRecruitJob',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1210,NULL, NULL,N'RecruitJob',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1211,NULL, NULL,N'RecruitJob',N'Post',N'Post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1212,NULL, NULL,N'RecruitJob',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1213,NULL, NULL,N'RecruitJob',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1483,1208,5042, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1488,1209,5042, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1489,1210,5046, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1490,1211,5046, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1491,1212,5045, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1492,1213,5044, NULL)
Go
--------------------------------------- End AK 2024-04-24 ------------