10:46:53 - IsConnectionValid True
10:46:56 - IsConnectionValid True
10:46:57 - IsConnectionValid True
10:47:12 - IsConnectionValid True
10:47:12 - IsConnectionValid True
10:47:31 - IsConnectionValid True
10:47:35 - IsConnectionValid True
10:47:35 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
10:47:37 - IsConnectionValid True
10:47:37 - 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
10:47:38 - IsConnectionValid True
10:47:38 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
10:47:40 - IsConnectionValid True
10:47:40 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:47:41 - IsConnectionValid True
10:47:41 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
10:47:45 - IsConnectionValid True
10:47:45 - 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
10:47:45 - IsConnectionValid True
10:47:45 - SELECT  DISTINCT COUNT(*) AS DayCount FROM EmployeeShiftDetails_PerDate WHERE  TenantID = @val0 AND EmployeeID = @val1 AND IsDayOff = @val2 AND CAST(Date AS Date) >= @val3 AND CAST(Date AS Date) <= @val4   AND Not Exists(SELECT ID FROM Occasions WHERE OccasionDate BETWEEN '04/23/2024' AND '04/23/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1))    Query
10:49:31 - IsConnectionValid True
10:49:31 - 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
10:49:31 - IsConnectionValid True
10:49:31 - SELECT  DISTINCT COUNT(*) AS DayCount FROM EmployeeShiftDetails_PerDate WHERE  TenantID = @val0 AND EmployeeID = @val1 AND IsDayOff = @val2 AND CAST(Date AS Date) >= @val3 AND CAST(Date AS Date) <= @val4   AND Not Exists(SELECT ID FROM Occasions WHERE OccasionDate BETWEEN '06/23/2023' AND '06/23/2023' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1))    Query
10:49:40 - IsConnectionValid True
10:49:41 - IsConnectionValid True
10:49:41 - IsConnectionValid True
10:49:42 - IsConnectionValid True
10:49:42 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
10:53:04 - IsConnectionValid True
10:53:04 - 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
10:53:05 - IsConnectionValid True
10:53:05 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
10:53:07 - IsConnectionValid True
10:53:07 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:53:09 - IsConnectionValid True
10:53:09 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
10:53:11 - IsConnectionValid True
10:53:11 - 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
10:53:11 - IsConnectionValid True
10:53:11 - SELECT  DISTINCT COUNT(*) AS DayCount FROM EmployeeShiftDetails_PerDate WHERE  TenantID = @val0 AND EmployeeID = @val1 AND IsDayOff = @val2 AND CAST(Date AS Date) >= @val3 AND CAST(Date AS Date) <= @val4   AND Not Exists(SELECT ID FROM Occasions WHERE OccasionDate BETWEEN '04/23/2024' AND '04/23/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1))    Query
10:53:21 - IsConnectionValid True
10:53:21 - 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
10:53:21 - IsConnectionValid True
10:53:21 - SELECT  DISTINCT COUNT(*) AS DayCount FROM EmployeeShiftDetails_PerDate WHERE  TenantID = @val0 AND EmployeeID = @val1 AND IsDayOff = @val2 AND CAST(Date AS Date) >= @val3 AND CAST(Date AS Date) <= @val4   AND Not Exists(SELECT ID FROM Occasions WHERE OccasionDate BETWEEN '06/22/2023' AND '06/22/2023' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1))    Query
10:53:25 - IsConnectionValid True
10:53:25 - IsConnectionValid True
10:53:25 - IsConnectionValid True
10:54:08 - IsConnectionValid True
10:54:08 - IsConnectionValid True
10:54:08 - IsConnectionValid True
10:54:48 - IsConnectionValid True
10:54:48 - IsConnectionValid True
10:54:48 - IsConnectionValid True
10:54:48 - IsConnectionValid True
10:54:48 - 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:11:42 - IsConnectionValid True
13:11:42 - 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:11:43 - IsConnectionValid True
13:11:43 - 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:11:54 - IsConnectionValid True
13:11:54 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:11:56 - IsConnectionValid True
13:11:56 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
13:11:58 - IsConnectionValid True
13:11:58 - 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:11:58 - IsConnectionValid True
13:11:58 - SELECT  DISTINCT COUNT(*) AS DayCount FROM EmployeeShiftDetails_PerDate WHERE  TenantID = @val0 AND EmployeeID = @val1 AND IsDayOff = @val2 AND CAST(Date AS Date) >= @val3 AND CAST(Date AS Date) <= @val4   AND Not Exists(SELECT ID FROM Occasions WHERE OccasionDate BETWEEN '04/23/2024' AND '04/23/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1))    Query
13:12:00 - IsConnectionValid True
13:12:00 - 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:12:00 - IsConnectionValid True
13:12:00 - SELECT  DISTINCT COUNT(*) AS DayCount FROM EmployeeShiftDetails_PerDate WHERE  TenantID = @val0 AND EmployeeID = @val1 AND IsDayOff = @val2 AND CAST(Date AS Date) >= @val3 AND CAST(Date AS Date) <= @val4   AND Not Exists(SELECT ID FROM Occasions WHERE OccasionDate BETWEEN '04/23/2024' AND '05/02/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1))    Query
13:12:21 - IsConnectionValid True
13:12:21 - 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:12:21 - IsConnectionValid True
13:12:21 - SELECT  DISTINCT COUNT(*) AS DayCount FROM EmployeeShiftDetails_PerDate WHERE  TenantID = @val0 AND EmployeeID = @val1 AND IsDayOff = @val2 AND CAST(Date AS Date) >= @val3 AND CAST(Date AS Date) <= @val4   AND Not Exists(SELECT ID FROM Occasions WHERE OccasionDate BETWEEN '04/23/2023' AND '05/02/2023' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1))    Query
13:12:48 - IsConnectionValid True
13:12:48 - 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:12:48 - IsConnectionValid True
13:12:48 - SELECT  DISTINCT COUNT(*) AS DayCount FROM EmployeeShiftDetails_PerDate WHERE  TenantID = @val0 AND EmployeeID = @val1 AND IsDayOff = @val2 AND CAST(Date AS Date) >= @val3 AND CAST(Date AS Date) <= @val4   AND Not Exists(SELECT ID FROM Occasions WHERE OccasionDate BETWEEN '06/25/2023' AND '07/04/2023' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1))    Query
13:13:42 - IsConnectionValid True
13:13:42 - IsConnectionValid True
13:13:42 - IsConnectionValid True
13:16:06 - IsConnectionValid True
13:16:06 - IsConnectionValid True
13:16:06 - IsConnectionValid True
13:18:38 - IsConnectionValid True
13:18:38 - IsConnectionValid True
13:18:38 - IsConnectionValid True
13:22:36 - IsConnectionValid True
13:22:36 - IsConnectionValid True
13:22:36 - IsConnectionValid True
13:22:36 - IsConnectionValid True
13:22:36 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query