﻿---------------------------Hammad 2022-09-01--------

CREATE TABLE [SST.ERP_Client].[dbo].[ExceptionLog](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[BranchId] [int] NOT NULL,
	[Category] [nvarchar](50) NOT NULL,
	[Title] [nvarchar](250) NOT NULL,
	[ErrorMessage] [nvarchar](max) NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[UserCode] [int] NOT NULL,
	[MachineName] [nvarchar](250) NOT NULL,
 CONSTRAINT [PK_ExceptionLogg] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

-------------------------End 2022-09-01---------
-------------------------Mostafa 2022-09-01---------
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] ON 
   Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (270, NULL, NULL, N'NewEmployeesRequest', N'SearchNewEmployeesRequest', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (271, NULL, NULL, N'NewEmployeesRequest', N'GetDetails', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (272, NULL, NULL, N'NewEmployeesRequest', N'GetWithOutSigById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (273, NULL, NULL, N'NewEmployeesRequest', N'Get', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (274, NULL, NULL, N'NewEmployeesRequest', N'Delete', N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (275, NULL, NULL, N'NewEmployeesRequest', N'Post', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (276, NULL, NULL, N'NewEmployeesRequest', N'Put', N'Put')
GO
-- Cancel
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (277, NULL, NULL, N'NewEmployeesRequest', N'CancelRequest', N'Post') -- Cancel
GO
--sig
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (278, NULL, NULL, N'NewEmployeesRequestSignature', N'GetSignatureById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (279, NULL, NULL, N'NewEmployeesRequestSignature', N'GetNewEmployeesRequestSignatures', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (280, NULL, NULL, N'NewEmployeesRequestSignature', N'GetRequestSignaturesByUser', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (281, NULL, NULL, N'NewEmployeesRequestSignature', N'GetRequestHistory', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (282, NULL, NULL, N'NewEmployeesRequestSignature', N'SaveSignature', N'Post')
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] OFF
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ON 
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (458, 270, 3229, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (459, 271, 3229, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (460, 272 ,3231, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (461, 273, 3231, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (462, 274, 3232, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (463, 275, 3233, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (464, 276, 3233, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (465, 277, 3234, NULL)  --Cancel
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (466, 278, 3236, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (467, 279, 3236, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (468, 280, 3237, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (469, 281, 3237, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (470, 282, 3238, NULL)
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] OFF
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] ON 
   Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (296, NULL, NULL, N'PromotionRequest', N'SearchPromotionRequest', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (297, NULL, NULL, N'PromotionRequest', N'GetDetails', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (298, NULL, NULL, N'PromotionRequest', N'GetWithOutSigById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (299, NULL, NULL, N'PromotionRequest', N'Get', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (300, NULL, NULL, N'PromotionRequest', N'Delete', N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (301, NULL, NULL, N'PromotionRequest', N'Post', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (302, NULL, NULL, N'PromotionRequest', N'Put', N'Put')
GO
-- Cancel
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (303, NULL, NULL, N'PromotionRequest', N'CancelRequest', N'Post') -- Cancel
GO
--sig
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (304, NULL, NULL, N'PromotionRequestSignature', N'GetSignatureById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (305, NULL, NULL, N'PromotionRequestSignature', N'GetPromotionRequestSignatures', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (306, NULL, NULL, N'PromotionRequestSignature', N'GetRequestSignaturesByUser', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (307, NULL, NULL, N'PromotionRequestSignature', N'GetRequestHistory', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (308, NULL, NULL, N'PromotionRequestSignature', N'SaveSignature', N'Post')
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] OFF
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ON 
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (484, 296, 3134, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (485, 297, 3134, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (486, 298 ,3136, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (487, 299, 3136, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (488, 300, 3138, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (489, 301, 3137, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (490, 302, 3137, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (491, 303, 3199, NULL)  --Cancel
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (492, 304, 3141, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (493, 305, 3141, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (494, 306, 3142, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (495, 307, 3142, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (496, 308, 3143, NULL)
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] OFF
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] ON 
   Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (322, NULL, NULL, N'PenaltyRequest', N'SearchPenaltyRequest', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (323, NULL, NULL, N'PenaltyRequest', N'GetDetails', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (324, NULL, NULL, N'PenaltyRequest', N'GetWithOutSigById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (325, NULL, NULL, N'PenaltyRequest', N'Get', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (326, NULL, NULL, N'PenaltyRequest', N'Delete', N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (327, NULL, NULL, N'PenaltyRequest', N'Post', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (328, NULL, NULL, N'PenaltyRequest', N'Put', N'Put')
GO
-- Cancel
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (329, NULL, NULL, N'PenaltyRequest', N'CancelRequest', N'Post') -- Cancel
GO
--sig
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (330, NULL, NULL, N'PenaltyRequestSignature', N'GetSignatureById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (331, NULL, NULL, N'PenaltyRequestSignature', N'GetPenaltyRequestSignature', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (332, NULL, NULL, N'PenaltyRequestSignature', N'GetRequestSignaturesByUser', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (333, NULL, NULL, N'PenaltyRequestSignature', N'GetRequestHistory', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (334, NULL, NULL, N'PenaltyRequestSignature', N'SaveSignature', N'Post')
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] OFF
GO

SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ON 
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (510, 322, 3207, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (511, 323, 3207, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (512, 324 ,3209, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (513, 325, 3209, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (514, 326, 3210, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (515, 327, 3211, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (516, 328, 3211, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (517, 329, 3212, NULL)  --Cancel
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (518, 330, 3214, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (519, 331, 3214, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (520, 332, 3215, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (521, 333, 3215, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (522, 334, 3217, NULL)
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] OFF
GO
	
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] ON 
   Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (335, NULL, NULL, N'AirTicketRequest', N'SearchAirTicketRequest', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (336, NULL, NULL, N'AirTicketRequest', N'GetDetails', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (337, NULL, NULL, N'AirTicketRequest', N'GetWithOutSigById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (338, NULL, NULL, N'AirTicketRequest', N'Get', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (339, NULL, NULL, N'AirTicketRequest', N'Delete', N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (340, NULL, NULL, N'AirTicketRequest', N'Post', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (341, NULL, NULL, N'AirTicketRequest', N'Put', N'Put')
GO
-- Cancel
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (342, NULL, NULL, N'AirTicketRequest', N'CancelRequest', N'Post') -- Cancel
GO
--sig
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (343, NULL, NULL, N'AirTicketRequestSignature', N'GetSignatureById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (344, NULL, NULL, N'AirTicketRequestSignature', N'GetAirTicketRequestSignature', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (345, NULL, NULL, N'AirTicketRequestSignature', N'GetRequestSignaturesByUser', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (346, NULL, NULL, N'AirTicketRequestSignature', N'GetRequestHistory', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (347, NULL, NULL, N'AirTicketRequestSignature', N'SaveSignature', N'Post')
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] OFF
GO

SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ON 
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (523, 335, 3064, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (524, 336, 3064, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (525, 337 ,3066, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (526, 338, 3066, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (527, 339, 3067, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (528, 340, 3069, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (529, 341, 3069, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (530, 342, 3068, NULL)  --Cancel
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (531, 343, 3071, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (532, 344, 3071, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (533, 345, 3072, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (534, 346, 3072, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (535, 347, 3073, NULL)
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] OFF
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] ON 
   Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (366, NULL, NULL, N'AirTicketRequestSignature', N'AirTicketOfferRecommend', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (367, NULL, NULL, N'AirTicketRequestSignature', N'AirTicketOfferSelect', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (368, NULL, NULL, N'AirTicketRequestSignature', N'SaveAirTicketOffer', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (369, NULL, NULL, N'AirTicketRequestSignature', N'DeleteAirTicketOffer', N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (370, NULL, NULL, N'AirTicketRequestSignature', N'AirTicketOfferGetDetails', N'Get')
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] OFF
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ON 
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (554, 366, 3074, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (555, 367, 3075, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (556, 368 ,3076, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (557, 369, 3076, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (558, 370, 3160, NULL)
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] OFF
GO
-------------------------End 2022-09-01---------
-------------------------Hammad 2022-09-01------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (646, N'Error Log Viewer', N'عرض سجل الأخطاء', 208, N'/ErrorLogViewer', N'Index', NULL, N'get', 10, 1, 0)
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (646, 1)
GO


INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'DisplayPaySlipAfterClosingMonth', N'Display Pay Slip After Closing Month', N'اظهار شريط المرتب بعد إقفال الشهر', N'false', 1, 49, 1, 1, 1, NULL, NULL)
GO

-------------------------End 2022-09-01------
-------------------------Ali 2022-09-01------

SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] ON 
   Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (283, NULL, NULL, N'ResignationRequest', N'SearchResignationRequest', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (284, NULL, NULL, N'ResignationRequest', N'GetDetails', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (285, NULL, NULL, N'ResignationRequest', N'GetWithOutSigById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (286, NULL, NULL, N'ResignationRequest', N'Get', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (287, NULL, NULL, N'ResignationRequest', N'Delete', N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (288, NULL, NULL, N'ResignationRequest', N'Post', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (289, NULL, NULL, N'ResignationRequest', N'Put', N'Put')
GO


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




INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (291, NULL, NULL, N'ResignationRequestSignature', N'GetSignatureById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (292, NULL, NULL, N'ResignationRequestSignature', N'GetResignationRequestsSignatures', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (293, NULL, NULL, N'ResignationRequestSignature', N'GetRequestSignaturesByUser', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (294, NULL, NULL, N'ResignationRequestSignature', N'GetRequestHistory', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (295, NULL, NULL, N'ResignationRequestSignature', N'SaveSignature', N'Post')
GO

SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] OFF
GO




SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ON 
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (471, 283, 3101, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (472, 284, 3101, NULL)

GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (473, 285, 3103, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (474, 286, 3103, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (475, 287, 3104, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (476, 288, 3105, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (477, 289, 3105, NULL)
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (478, 290, 3106, NULL)  --Cancel
GO


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (479, 291, 3108, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (480, 292, 3108, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (481, 293, 3109, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (482, 294, 3109, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (483, 295, 3110, NULL)
GO

SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] OFF
GO


SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] ON 
   Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (309, NULL, NULL, N'LoanRequest', N'SearchLoanRequest', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (310, NULL, NULL, N'LoanRequest', N'GetDetails', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (311, NULL, NULL, N'LoanRequest', N'GetWithOutSigById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (312, NULL, NULL, N'LoanRequest', N'Get', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (313, NULL, NULL, N'LoanRequest', N'Delete', N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (314, NULL, NULL, N'LoanRequest', N'Post', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (315, NULL, NULL, N'LoanRequest', N'Put', N'Put')
GO


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




INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (317, NULL, NULL, N'LoanRequestSignature', N'GetSignatureById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (318, NULL, NULL, N'LoanRequestSignature', N'GetLoanRequestsSignatures', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (319, NULL, NULL, N'LoanRequestSignature', N'GetRequestSignaturesByUser', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (320, NULL, NULL, N'LoanRequestSignature', N'GetRequestHistory', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (321, NULL, NULL, N'LoanRequestSignature', N'SaveSignature', N'Post')
GO

SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] OFF
GO




SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ON 
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (497, 309, 3123, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (498, 310, 3123, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (499, 311, 3125, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (500, 312, 3125, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (501, 313, 3126, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (502, 314, 3127, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (503, 315, 3127, NULL)
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (504, 316, 3128, NULL)  --Cancel
GO


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (505, 317, 3130, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (506, 318, 3130, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (507, 319, 3131, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (508, 320, 3131, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (509, 321, 3132, NULL)
GO

SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] OFF
GO

-------------------------End 2022-09-01------
-------------------------Ali 2022-09-04------



SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] ON 
   Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (348, NULL, NULL, N'OverTimeRequest', N'SearchOverTimeRequest', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (349, NULL, NULL, N'OverTimeRequest', N'GetDetails', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (350, NULL, NULL, N'OverTimeRequest', N'GetWithOutSigById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (351, NULL, NULL, N'OverTimeRequest', N'Get', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (352, NULL, NULL, N'OverTimeRequest', N'Delete', N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (353, NULL, NULL, N'OverTimeRequest', N'Post', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (354, NULL, NULL, N'OverTimeRequest', N'Put', N'Put')
GO


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




INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (356, NULL, NULL, N'OverTimeRequestSignature', N'GetSignatureById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (357, NULL, NULL, N'OverTimeRequestSignature', N'GetOverTimeRequestsSignatures', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (358, NULL, NULL, N'OverTimeRequestSignature', N'GetRequestSignaturesByUser', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (359, NULL, NULL, N'OverTimeRequestSignature', N'GetRequestHistory', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (360, NULL, NULL, N'OverTimeRequestSignature', N'SaveSignature', N'Post')
GO


--Final
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (361, NULL, NULL, N'OverTimeRequestFinalSignature', N'GetFinalSignaturesByRequest', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (362, NULL, NULL, N'OverTimeRequestFinalSignature', N'GetFinalSignatureById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (363, NULL, NULL, N'OverTimeRequestFinalSignature', N'GetOverTimeRequestFinalSigWithDetails', N'Get')
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (364, NULL, NULL, N'OverTimeRequestFinalSignature', N'GetOverTimeRequestFinalSignaturesByUser', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (365, NULL, NULL, N'OverTimeRequestFinalSignature', N'SaveOverTimeFinalSignature', N'Post')
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] OFF
GO




SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ON 
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (536, 348, 3053, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (537, 349, 3053, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (538, 350, 3055, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (539, 351, 3055, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (540, 352, 3056, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (541, 353, 3058, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (542, 354, 3058, NULL)
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (543, 355, 3057, NULL)  --Cancel
GO


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (544, 356, 3060, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (545, 357, 3060, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (546, 358, 3061, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (547, 359, 3061, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (548, 360, 3062, NULL)
GO




--Final Sig
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (549, 361, 3387, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (550, 362, 3387, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (551, 363, 3387, NULL)

GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (552, 364, 3388, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (553, 365, 3389, NULL)
GO


SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] OFF
GO


SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] ON 
   Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (390, NULL, NULL, N'DisclaimerRequestSignature', N'GetDisclaimerSignatureById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (391, NULL, NULL, N'DisclaimerRequestSignature', N'GetDisclaimerRequestsSignatures', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (392, NULL, NULL, N'DisclaimerRequestSignature', N'GetDisclaimerRequestSignaturesByUser', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (393, NULL, NULL, N'DisclaimerRequestSignature', N'SaveDisclaimerSignature', N'Post')
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] OFF
GO

SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ON 
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (578, 390, 3289, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (579, 391, 3289, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (580, 392, 3290, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (581, 393, 3291, NULL)
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] OFF
GO


-------------------------End 2022-09-04------


-------------------------Mostafa 2022-09-04------
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] ON 
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (371, NULL, NULL, N'CompensationRequestForADayOfRest', N'SearchCompensationRequestForADayOfRest', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (372, NULL, NULL, N'CompensationRequestForADayOfRest', N'GetDetails', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (373, NULL, NULL, N'CompensationRequestForADayOfRest', N'GetWithOutSigById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (374, NULL, NULL, N'CompensationRequestForADayOfRest', N'Get', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (375, NULL, NULL, N'CompensationRequestForADayOfRest', N'Delete', N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (376, NULL, NULL, N'CompensationRequestForADayOfRest', N'Post', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (377, NULL, NULL, N'CompensationRequestForADayOfRest', N'Put', N'Put')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (378, NULL, NULL, N'CompensationRequestForADayOfRest', N'CancelRequest', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (379, NULL, NULL, N'CompensationDayOfRestRequestSignature', N'GetSignatureById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (380, NULL, NULL, N'CompensationDayOfRestRequestSignature', N'GetCompensationRequestsSignatures', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (381, NULL, NULL, N'CompensationDayOfRestRequestSignature', N'GetRequestSignaturesByUser', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (382, NULL, NULL, N'CompensationDayOfRestRequestSignature', N'GetRequestHistory', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (383, NULL, NULL, N'CompensationDayOfRestRequestSignature', N'SaveSignature', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (384, NULL, NULL, N'CompensationRequestFinalDayRestSignature', N'GetFinalSignaturesByRequest', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (385, NULL, NULL, N'CompensationRequestFinalDayRestSignature', N'GetFinalSignatureById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (386, NULL, NULL, N'CompensationRequestFinalDayRestSignature', N'GetCompensationRequestsFinalSignatures', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (387, NULL, NULL, N'CompensationRequestFinalDayRestSignature', N'GetCompensationRequestFinalSigWithDetails', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (388, NULL, NULL, N'CompensationRequestFinalDayRestSignature', N'GetRequestFinalSignaturesByUser', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (389, NULL, NULL, N'CompensationRequestFinalDayRestSignature', N'SaveFinalSignature', N'Post')
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPoints] OFF

SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ON 
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (559, 371, 3375, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (560, 372, 3375, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (561, 373, 3377, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (562, 374, 3377, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (563, 375, 3378, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (564, 376, 3380, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (565, 377, 3380, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (566, 378, 3379, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (567, 379, 3382, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (568, 380, 3382, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (569, 381, 3383, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (570, 382, 3383, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (571, 383, 3385, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (572, 384, 3392, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (573, 385, 3392, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (574, 386, 3392, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (575, 387, 3392, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (576, 388, 3392, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (577, 389, 3393, NULL)
GO
SET IDENTITY_INSERT [dbo].[SecurityPrivilegeEndPointsDetails] OFF
GO
-------------------------End 2022-09-04------
-------------------------Mostafa 2022-09-05------
update [dbo].[SecurityPrivilegeEndPointsDetails] set SecurityPrivilegeId=3072 where id=531
GO
update [dbo].[SecurityPrivilegeEndPointsDetails] set SecurityPrivilegeId=3071 where id=533
GO
update [dbo].[SecurityPrivilegeEndPointsDetails] set SecurityPrivilegeId=3406 where id=534
GO
update [dbo].[SecurityPrivilegeEndPointsDetails] set SecurityPrivilegeId=3215 where id=518
GO
update [dbo].[SecurityPrivilegeEndPointsDetails] set SecurityPrivilegeId=3214 where id=520
GO
update [dbo].[SecurityPrivilegeEndPointsDetails] set SecurityPrivilegeId=3398 where id=521
GO
update [dbo].[SecurityPrivilegeEndPointsDetails] set SecurityPrivilegeId=3216 where id=522
GO
update [dbo].[SecurityPrivilegeEndPointsDetails] set SecurityPrivilegeId=3142 where id=492
GO
update [dbo].[SecurityPrivilegeEndPointsDetails] set SecurityPrivilegeId=3141 where id=494
GO
update [dbo].[SecurityPrivilegeEndPointsDetails] set SecurityPrivilegeId=3403 where id=495
GO
update [dbo].[SecurityPrivilegeEndPointsDetails] set SecurityPrivilegeId=3237 where id=466
GO
update [dbo].[SecurityPrivilegeEndPointsDetails] set SecurityPrivilegeId=3236 where id=468
GO
-------------------------End 2022-09-05------
-------------------------Ali 2022-09-05------


update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]=3061 where Id=544
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]=3060 where Id=546
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]=3388 where Id=550
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]=3387 where Id=551
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3387 where Id=552   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3152 where Id=429   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3405 where Id=430   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3153 where Id=427   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3085 where Id=442   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3396 where Id=443   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3086 where Id=440   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3040 where Id=455   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3404 where Id=456   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3041 where Id=453   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3108 where Id=481   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3109 where Id=479   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3383 where Id=567   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3382 where Id=569   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3394 where Id=570   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3391 where Id=574   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3391 where Id=575   
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3391 where Id=572   
Go


update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]=3289  where Id=580
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]=3290  where Id=578
Go
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]= 3395 where Id=547
Go
-------------------------End 2022-09-05------
-------------------------Hammad 2022-09-05------
ALTER TABLE [SST.ERP_Client].[dbo].[Clients] ADD
	TokenExpireMinutes int NOT NULL CONSTRAINT DF_Clients_TokenExpireMinutes DEFAULT 45
GO

ALTER TABLE [dbo].[WF_FinancialPaymentHrRequest]
 DROP CONSTRAINT [FK_WF_FinancialPaymentHrRequest_Divisions]
GO
-------------------------End 2022-09-05--------
-------------------------Mostafa 2022-09-05--------
EXEC sp_RENAME 'WF_FinancialPaymentHrRequest.DivisionCode' , 'HirarchyCode', 'COLUMN'
GO
-------------------------End 2022-09-05--------
