﻿-------------------------------M.Negm 2024-05-26 ------------------------------
 
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1905,N'WorkFlow',N'OvertimeEventType',N'Index',0,N'get',3219)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1906,N'WorkFlow',N'OvertimeEventType',N'OvertimeEventType_Read',0,N'post',3220)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1907,N'WorkFlow',N'OvertimeEventType',N'Save',1,N'get',3221)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1908,N'WorkFlow',N'OvertimeEventType',N'Save',2,N'get',3222)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1909,N'WorkFlow',N'OvertimeEventType',N'Delete',0,N'post',3223)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1910,N'WorkFlow',N'OvertimeEventType',N'Save',0,N'post',3224)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1319,NULL, NULL,N'OvertimeEventType',N'GetOverTimeEventTypeSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1320,NULL, NULL,N'OverTimeEventType',N'Put',N'Put')
Go																													
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1321,NULL, NULL,N'OverTimeEventType',N'post',N'post')
Go																													
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1322,NULL, NULL,N'OverTimeEventType',N'Delete',N'Delete')
Go																													
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1323,NULL, NULL,N'OverTimeEventType',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1593,1319,3220, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1594,1320,3224, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1595,1321,3224, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1596,1322,3223, NULL)
Go
-------------------------------- End 2024-05-26 -------------------------------
--------------------------------------- AK 2024-05-27 ---------
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1314,NULL,NULL,N'RecruitJobQuestion',N'GetRecruitJobQuestionSearch',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1315,NULL,NULL,N'RecruitJobQuestion',N'Get',N'Get')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1324,NULL,NULL,N'RecruitJobQuestion',N'Post',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1325,NULL,NULL,N'RecruitJobQuestion',N'Delete',N'Delete')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1326,NULL,NULL,N'RecruitJobQuestion',N'Put',N'Put')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1589,1314,5048,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1597,673,5049,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1598,673,5050,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1599,676,5049,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1600,676,5050,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1601,679,5049,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1602,679,5050,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1603,682,5049,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1604,682,5050,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1605,685,5049,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1606,685,5050,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1607,1315,5142,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1608,1324,5049,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1609,1325,5051,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1610,1326,5050,NULL)
GO
--------------------------------------- End AK 2024-05-27 ------------
--------------------------------------- M.Negm 2024-05-27 ----------------
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1911,N'WorkFlow',N'OvertimeType',N'Index',0,N'get',3170)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1912,N'WorkFlow',N'OvertimeType',N'OvertimeType_Read',0,N'post',3171)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1913,N'WorkFlow',N'OvertimeType',N'Save',1,N'get',3172)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1914,N'WorkFlow',N'OvertimeType',N'Save',2,N'get',3173)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1915,N'WorkFlow',N'OvertimeType',N'Delete',0,N'post',3174)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1916,N'WorkFlow',N'OvertimeType',N'Save',0,N'post',3175)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1327,NULL, NULL,N'OverTimeType',N'GetOverTimeTypeSearch',N'post')
Go																								
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1328,NULL, NULL,N'OverTimeType',N'Put',N'Put')
Go																													
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1329,NULL, NULL,N'OverTimeType',N'post',N'post')
Go																													
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1330,NULL, NULL,N'OverTimeType',N'Delete',N'Delete')
Go																													
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1331,NULL, NULL,N'OverTimeType',N'Get',N'Get')
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1611,1327,3171, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1612,1328,3175, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1613,1329,3175, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1614,1330,3174, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1615,1331,3173, NULL)
Go
----------------------------------- End 2024-05-27 -------------------------------------------
----------------------------------- Hammad 2024-05-27 ----------------------------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription])
VALUES (N'WorkByOfflineFingerPrint', N'Work By Offline FingerPrint', N'إمكانيةالبصمة اوفلاين', N'false', 12, 16, 1, 1, NULL, NULL, NULL, N'إمكانيةالبصمة اوفلاين ')
GO
----------------------------------- End 2024-05-27 ----------------------------------------
--------------------------------M.Negm 2024-05-22 ---------------
CREATE TABLE [dbo].[EmployeeMobileAppData](
	[EmployeeCode] [int] NOT NULL,
	[WhatsappNumber] [nvarchar](20) NULL,
	[MDT] [datetime] NULL,
	[WhatsappNumberKey] [nvarchar](10) NULL,
 CONSTRAINT [PK_EmployeeMobileAppData] 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
------------------------------ End 2024-05-22 --------------------------------