13:42:52 - IsConnectionValid True
13:42:52 - IsConnectionValid True
13:42:52 - IsConnectionValid True
13:42:57 - IsConnectionValid True
13:42:57 - IsConnectionValid True
13:43:00 - IsConnectionValid True
13:43:02 - IsConnectionValid True
13:43:09 - IsConnectionValid True
13:43:09 - SELECT  DISTINCT ProjectName AS ProjectName, ProjectID AS ProjectID FROM VwOccasions WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1  Query
13:43:23 - IsConnectionValid True
13:43:23 - IsConnectionValid True
13:44:07 - IsConnectionValid True
13:44:08 - IsConnectionValid True
13:44:10 - IsConnectionValid True
13:44:10 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
13:44:11 - IsConnectionValid True
13:44:11 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees  WHERE   (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >09/13/2023)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:44:13 - IsConnectionValid True
13:44:13 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
13:44:14 - IsConnectionValid True
13:44:14 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:44:15 - IsConnectionValid True
13:44:15 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
13:45:32 - IsConnectionValid True
13:45:34 - IsConnectionValid True
13:45:34 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
13:45:39 - IsConnectionValid True
13:45:39 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees  WHERE   (DateLeft = '1900-01-01' or (DateleftTemp<>DateLeft and DateLeft > GETDATE()))  and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:45:40 - IsConnectionValid True
13:45:40 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
13:45:49 - IsConnectionValid True
13:45:49 - SELECT  DISTINCT COUNT(*) AS OccCount FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
13:45:49 - IsConnectionValid True
13:45:49 - IsConnectionValid True
13:45:49 - SELECT  DISTINCT OccasionDate AS OccasionDate FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
13:45:49 - SELECT  DISTINCT OccasionDate AS OccasionDate FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
13:45:53 - IsConnectionValid True
13:45:53 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM VwVacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:45:54 - IsConnectionValid True
13:45:54 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
13:45:54 - IsConnectionValid True
13:45:54 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
13:45:57 - IsConnectionValid True
13:45:57 - SELECT  DISTINCT COUNT(*) AS OccCount FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
13:45:57 - IsConnectionValid True
13:45:57 - SELECT  DISTINCT OccasionDate AS OccasionDate FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
13:45:57 - IsConnectionValid True
13:45:57 - SELECT  DISTINCT OccasionDate AS OccasionDate FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
13:46:50 - IsConnectionValid True
13:46:50 - IsConnectionValid True
13:46:50 - SELECT  DISTINCT * FROM StaffCategory WHERE  TenantID =1 ORDER BY ID  Query
13:46:50 - IsConnectionValid True
13:46:50 - SELECT * FROM web_HRMS_Experience WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY StaffCatID ASC, ExperienceNo2 ASC  Query
13:46:51 - IsConnectionValid True
13:46:54 - IsConnectionValid True
13:46:59 - IsConnectionValid True
13:47:03 - IsConnectionValid True
13:47:03 - SELECT  DISTINCT ProjectName AS ProjectName, ProjectID AS ProjectID FROM VwOccasions WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1  Query
13:47:18 - IsConnectionValid True
13:47:19 - IsConnectionValid True
13:47:19 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
13:47:21 - IsConnectionValid True
13:47:21 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees  WHERE   (DateLeft = '1900-01-01' or (DateleftTemp<>DateLeft and DateLeft > GETDATE()))  and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:47:22 - IsConnectionValid True
13:47:22 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
13:47:23 - IsConnectionValid True
13:47:23 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM VwVacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:47:23 - IsConnectionValid True
13:47:23 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
13:47:23 - IsConnectionValid True
13:47:23 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
13:47:26 - IsConnectionValid True
13:47:26 - SELECT  DISTINCT COUNT(*) AS OccCount FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
13:47:26 - IsConnectionValid True
13:47:26 - SELECT  DISTINCT OccasionDate AS OccasionDate FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
13:47:26 - IsConnectionValid True
13:47:26 - SELECT  DISTINCT OccasionDate AS OccasionDate FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
13:47:30 - IsConnectionValid True
13:47:30 - SELECT  DISTINCT COUNT(*) AS OccCount FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
13:47:30 - IsConnectionValid True
13:47:30 - SELECT  DISTINCT OccasionDate AS OccasionDate FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
13:47:30 - SELECT  DISTINCT OccasionDate AS OccasionDate FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
13:47:42 - IsConnectionValid True
13:47:42 - SELECT  DISTINCT COUNT(*) AS OccCount FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
13:47:42 - IsConnectionValid True
13:47:42 - IsConnectionValid True
13:47:42 - SELECT  DISTINCT OccasionDate AS OccasionDate FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
13:47:42 - SELECT  DISTINCT OccasionDate AS OccasionDate FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
14:00:09 - IsConnectionValid True
14:00:11 - IsConnectionValid True
14:00:16 - IsConnectionValid True
14:00:16 - SELECT ISNULL(SchoolID,0) AS SchoolID, ISNULL(Name,'') AS Name, ISNULL(branch,'') AS Branch FROM User_Rights INNER JOIN Schools On User_Rights.SchoolID = Schools.ID WHERE TenantID = 1 AND   UserID = @val0 and DefaultSchool = @val1  Query
14:00:16 - (1-gen-1002) : Invalid object name 'Schools'.
14:00:19 - IsConnectionValid True
14:00:21 - IsConnectionValid True
14:00:21 - SELECT ISNULL(SchoolID,0) AS SchoolID, ISNULL(Name,'') AS Name, ISNULL(branch,'') AS Branch FROM User_Rights INNER JOIN Schools On User_Rights.SchoolID = Schools.ID WHERE TenantID = 1 AND   UserID = @val0 and DefaultSchool = @val1  Query
14:00:21 - (1-gen-1002) : Invalid object name 'Schools'.
14:00:23 - IsConnectionValid True
14:00:36 - IsConnectionValid True