11:35:02 - IsConnectionValid True 11:35:02 - IsConnectionValid True 11:35:03 - IsConnectionValid True 11:35:07 - IsConnectionValid True 11:35:08 - IsConnectionValid True 11:35:10 - IsConnectionValid True 11:35:12 - IsConnectionValid True 11:35:12 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:35:13 - IsConnectionValid True 11:35:13 - 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 11:35:14 - IsConnectionValid True 11:35:14 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:35:15 - IsConnectionValid True 11:35:15 - 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 11:35:16 - IsConnectionValid True 11:35:16 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:35:20 - IsConnectionValid True 11:35:20 - 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 11:35:22 - IsConnectionValid True 11:35:22 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:35:41 - IsConnectionValid True 11:35:45 - IsConnectionValid True 11:35:53 - IsConnectionValid True 11:35:57 - IsConnectionValid True 11:35:57 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:35:58 - IsConnectionValid True 11:35:58 - IsConnectionValid True 11:35:58 - IsConnectionValid True 11:35:58 - IsConnectionValid True 11:35:58 - IsConnectionValid True 11:35:58 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 11:35:58 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 11:35:58 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 11:35:58 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 11:35:58 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 11:35:59 - IsConnectionValid True 11:35:59 - IsConnectionValid True 11:35:59 - IsConnectionValid True 11:35:59 - IsConnectionValid True 11:35:59 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - IsConnectionValid True 11:35:59 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - IsConnectionValid True 11:35:59 - IsConnectionValid True 11:35:59 - IsConnectionValid True 11:35:59 - IsConnectionValid True 11:35:59 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 11:35:59 - IsConnectionValid True 11:35:59 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - IsConnectionValid True 11:35:59 - IsConnectionValid True 11:35:59 - IsConnectionValid True 11:35:59 - IsConnectionValid True 11:35:59 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - IsConnectionValid True 11:35:59 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 11:35:59 - IsConnectionValid True 11:35:59 - IsConnectionValid True 11:35:59 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 11:35:59 - IsConnectionValid True 11:35:59 - IsConnectionValid True 11:35:59 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - IsConnectionValid True 11:35:59 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - IsConnectionValid True 11:35:59 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:59 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 11:35:59 - IsConnectionValid True 11:35:59 - IsConnectionValid True 11:35:59 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 876 WHERE LocationDef.TenantID =1 Query 11:35:59 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 876 WHERE CustodyItemsDef.TenantID =1 Query 11:35:59 - IsConnectionValid True 11:35:59 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =876 Query 11:35:59 - IsConnectionValid True 11:35:59 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:35:59 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:35:59 - IsConnectionValid True 11:35:59 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:35:59 - IsConnectionValid True 11:35:59 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:35:59 - IsConnectionValid True 11:35:59 - IsConnectionValid True 11:35:59 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 11:35:59 - IsConnectionValid True 11:35:59 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 11:36:06 - IsConnectionValid True 11:36:06 - IsConnectionValid True 11:36:08 - IsConnectionValid True 11:36:09 - IsConnectionValid True 11:36:09 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:36:10 - IsConnectionValid True 11:36:10 - 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 11:36:12 - IsConnectionValid True 11:36:12 - 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 AND Code LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:36:13 - IsConnectionValid True 11:36: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 11:36:14 - IsConnectionValid True 11:36:14 - 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 11:36:23 - IsConnectionValid True 11:36:23 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:36:28 - IsConnectionValid True 11:36:32 - IsConnectionValid True 11:36:38 - IsConnectionValid True 11:36:48 - IsConnectionValid True 11:37:02 - IsConnectionValid True 11:37:08 - IsConnectionValid True 11:37:22 - IsConnectionValid True 11:37:22 - 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 11:37:27 - IsConnectionValid True 11:37:27 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:37:38 - IsConnectionValid True 11:37:38 - 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 11:37:40 - IsConnectionValid True 11:37:40 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:37:48 - IsConnectionValid True 11:37: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 11:37:48 - IsConnectionValid True 11:37: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 '03/11/2024' AND '03/11/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 11:37:52 - IsConnectionValid True 11:37:57 - IsConnectionValid True 11:38:03 - IsConnectionValid True 11:38:11 - IsConnectionValid True 11:38:15 - IsConnectionValid True 11:38:21 - IsConnectionValid True 11:38:24 - IsConnectionValid True 11:40:22 - IsConnectionValid True 11:40:27 - IsConnectionValid True 11:40:28 - IsConnectionValid True 11:40:28 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:40:29 - IsConnectionValid True 11:40:29 - 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 11:40:36 - IsConnectionValid True 11:40:36 - 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 AND Code LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:40:36 - IsConnectionValid True 11:40: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 11:40:37 - IsConnectionValid True 11:40:37 - 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 11:40:38 - IsConnectionValid True 11:40:38 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:40:38 - IsConnectionValid True 11:40:38 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:40:51 - IsConnectionValid True 11:40:52 - IsConnectionValid True 11:40:52 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:40:55 - IsConnectionValid True 11:40:55 - 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 11:40:56 - IsConnectionValid True 11:40:56 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:40:56 - IsConnectionValid True 11:40:56 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:40:59 - IsConnectionValid True 11:40:59 - 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 11:40:59 - IsConnectionValid True 11:40:59 - 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 '03/11/2024' AND '03/11/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 11:41:04 - IsConnectionValid True 11:41:11 - IsConnectionValid True 11:41:16 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 11:41:24 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 11:41:24 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 11:41:24 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 11:41:24 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - IsConnectionValid True 11:41:24 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 11:41:24 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - IsConnectionValid True 11:41:24 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - IsConnectionValid True 11:41:24 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - IsConnectionValid True 11:41:24 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 11:41:24 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - IsConnectionValid True 11:41:24 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 11:41:24 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 876 WHERE LocationDef.TenantID =1 Query 11:41:24 - IsConnectionValid True 11:41:24 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 876 WHERE CustodyItemsDef.TenantID =1 Query 11:41:24 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =876 Query 11:41:24 - IsConnectionValid True 11:41:24 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:41:24 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:41:24 - IsConnectionValid True 11:41:24 - IsConnectionValid True 11:41:24 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:41:24 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:41:24 - IsConnectionValid True 11:41:24 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 11:41:24 - IsConnectionValid True 11:41:24 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 11:41:28 - IsConnectionValid True 11:41:33 - IsConnectionValid True 11:41:33 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 11:41:34 - IsConnectionValid True 11:41:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:41:35 - IsConnectionValid True 11:41:35 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND Code LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:41:37 - IsConnectionValid True 11:41:39 - IsConnectionValid True 11:41:39 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM ShiftDef WHERE TenantID = @val0 AND (SectionID=0 OR SectionID=125) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:41:43 - IsConnectionValid True 11:41:50 - IsConnectionValid True 11:41:50 - 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 11:41:52 - IsConnectionValid True 11:41:52 - 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 AND Code LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:41:52 - IsConnectionValid True 11:41:52 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:41:53 - IsConnectionValid True 11:41:53 - 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 11:41:54 - IsConnectionValid True 11:41:54 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:41:54 - IsConnectionValid True 11:41:54 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:41:58 - IsConnectionValid True 11:42:02 - IsConnectionValid True 11:42:04 - IsConnectionValid True 11:42:06 - IsConnectionValid True 11:42:06 - 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 FROM LeaveType WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:42:08 - IsConnectionValid True 11:42:08 - IsConnectionValid True 11:42:08 - IsConnectionValid True 11:42:08 - IsConnectionValid True 11:42:08 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:42:10 - IsConnectionValid True 11:42:10 - 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 11:42:11 - IsConnectionValid True 11:42: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 = '1900-01-01' or (DateleftTemp<>DateLeft and DateLeft > GETDATE())) and UserID = @val1 and TenantID = @val2 AND Code LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:42:12 - IsConnectionValid True 11:42:12 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:42:13 - IsConnectionValid True 11:42:13 - 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 11:42:13 - IsConnectionValid True 11:42:13 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:42:13 - IsConnectionValid True 11:42:13 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:42:18 - IsConnectionValid True 11:42:18 - 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 11:42:18 - IsConnectionValid True 11:42:18 - 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 '03/11/2024' AND '03/11/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 11:42:25 - IsConnectionValid True 11:42:27 - IsConnectionValid True 11:42:27 - 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 FROM LeaveType WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:42:31 - IsConnectionValid True 11:42:31 - IsConnectionValid True 11:42:31 - IsConnectionValid True 11:42:31 - IsConnectionValid True 11:42:31 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:47:44 - IsConnectionValid True 11:47:45 - IsConnectionValid True 11:47:45 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:47:46 - IsConnectionValid True 11:47:46 - 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 11:47:50 - IsConnectionValid True 11:47:51 - IsConnectionValid True 11:47:51 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 11:47:53 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 11:47:53 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 11:47:53 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 11:47:53 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - IsConnectionValid True 11:47:53 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 11:47:53 - IsConnectionValid True 11:47:53 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - IsConnectionValid True 11:47:53 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 11:47:53 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 11:47:53 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - IsConnectionValid True 11:47:53 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - IsConnectionValid True 11:47:53 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:53 - IsConnectionValid True 11:47:53 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 11:47:53 - IsConnectionValid True 11:47:53 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 876 WHERE LocationDef.TenantID =1 Query 11:47:53 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 876 WHERE CustodyItemsDef.TenantID =1 Query 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - IsConnectionValid True 11:47:53 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =876 Query 11:47:53 - IsConnectionValid True 11:47:53 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:47:53 - IsConnectionValid True 11:47:53 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:47:53 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:47:53 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:47:53 - IsConnectionValid True 11:47:53 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 11:47:53 - IsConnectionValid True 11:47:53 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 11:48:00 - IsConnectionValid True 11:48:00 - 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 AND Code LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:48:01 - IsConnectionValid True 11:48:01 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:48:02 - IsConnectionValid True 11:48:02 - 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 11:48:02 - IsConnectionValid True 11:48:02 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:48:02 - IsConnectionValid True 11:48:02 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:48:07 - IsConnectionValid True 11:48:07 - 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 11:48:07 - IsConnectionValid True 11:48:07 - 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 '03/11/2024' AND '03/11/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 11:48:12 - IsConnectionValid True 11:48:15 - IsConnectionValid True 11:48:19 - IsConnectionValid True 11:48:19 - 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 FROM LeaveType WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:48:22 - IsConnectionValid True 11:48:22 - IsConnectionValid True 11:48:22 - IsConnectionValid True 11:48:22 - IsConnectionValid True 11:48: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 11:48:24 - IsConnectionValid True 11:48:24 - 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 11:48:26 - IsConnectionValid True 11:48:26 - 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 AND Code LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:48:27 - IsConnectionValid True 11:48:27 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:48:36 - IsConnectionValid True 11:48:36 - 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 11:48:37 - IsConnectionValid True 11:48:37 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:48:37 - IsConnectionValid True 11:48:37 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:48:39 - IsConnectionValid True 11:48:39 - 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 11:48:39 - IsConnectionValid True 11:48:39 - 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 '03/11/2024' AND '03/12/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 11:48:47 - IsConnectionValid True 11:48:47 - 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 11:48:47 - IsConnectionValid True 11:48:47 - 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 '03/11/2024' AND '03/11/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 11:48:52 - IsConnectionValid True 11:48:52 - IsConnectionValid True 11:48:52 - IsConnectionValid True 11:48:52 - IsConnectionValid True 11:48:52 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:49:30 - IsConnectionValid True 11:53:35 - IsConnectionValid True 11:53:36 - 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 11:53:38 - IsConnectionValid True 11:53:38 - 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 AND Code LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:53:39 - IsConnectionValid True 11:53:39 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:53:40 - IsConnectionValid True 11:53: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 11:53:41 - IsConnectionValid True 11:53:41 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:53:41 - IsConnectionValid True 11:53:41 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:53:43 - IsConnectionValid True 11:53:43 - 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 11:53:43 - IsConnectionValid True 11:53:43 - 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 '03/11/2024' AND '03/12/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 11:53:46 - IsConnectionValid True 11:53:46 - 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 11:53:46 - IsConnectionValid True 11:53:46 - 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 '03/11/2024' AND '03/11/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 11:53:48 - IsConnectionValid True 11:53:48 - IsConnectionValid True 11:53:48 - IsConnectionValid True 11:53:48 - SELECT DISTINCT FromDate AS FromDate, ToDate AS ToDate FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND ID = @val0 and TenantID = @val1 Query 11:57:50 - IsConnectionValid True 11:57:50 - 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 11:57:50 - IsConnectionValid True 11:57:50 - 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 '03/11/2024' AND '03/11/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 11:57:51 - IsConnectionValid True 11:57:55 - IsConnectionValid True 11:58:04 - IsConnectionValid True 11:58:04 - 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 FROM LeaveType WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:58:07 - IsConnectionValid True 11:58:07 - IsConnectionValid True 11:58:07 - IsConnectionValid True 11:58:07 - IsConnectionValid True 11:58:07 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:58:09 - IsConnectionValid True 11:58:09 - 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 11:58:13 - IsConnectionValid True 11:58:13 - 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 AND Code LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:58:14 - IsConnectionValid True 11:58:14 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:58:15 - IsConnectionValid True 11:58:15 - 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 11:58:16 - IsConnectionValid True 11:58:16 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:58:16 - IsConnectionValid True 11:58:16 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:58:19 - IsConnectionValid True 11:58:19 - 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 11:58:19 - IsConnectionValid True 11:58:19 - 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 '03/11/2024' AND '03/11/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 11:58:24 - IsConnectionValid True 11:58:30 - IsConnectionValid True 11:58:35 - IsConnectionValid True 11:58:38 - IsConnectionValid True 11:58:40 - IsConnectionValid True 11:58:40 - 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 FROM LeaveType WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:58:42 - IsConnectionValid True 11:58:42 - IsConnectionValid True 11:58:42 - IsConnectionValid True 11:58:42 - IsConnectionValid True 11:58: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 11:58:44 - IsConnectionValid True 11:58:44 - 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 11:58:46 - IsConnectionValid True 11:58:46 - 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 AND Code LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:58:47 - IsConnectionValid True 11:58:47 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 12:35:32 - IsConnectionValid True 12:35:32 - 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 12:35:33 - IsConnectionValid True 12:35:33 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 12:35:33 - IsConnectionValid True 12:35:33 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 12:35:34 - IsConnectionValid True 12:35:34 - 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 12:35:34 - IsConnectionValid True 12:35:34 - 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 '03/11/2024' AND '03/11/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 12:35:37 - IsConnectionValid True 12:35:39 - IsConnectionValid True 12:35:44 - IsConnectionValid True 12:35:46 - IsConnectionValid True 12:35:46 - 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 FROM LeaveType WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:35:48 - IsConnectionValid True 12:35:48 - IsConnectionValid True 12:35:48 - IsConnectionValid True 12:35:53 - IsConnectionValid True 12:35:57 - IsConnectionValid True 12:35:57 - IsConnectionValid True 12:35:57 - IsConnectionValid True 12:36:21 - IsConnectionValid True 12:36: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 12:36:23 - IsConnectionValid True 12:36:23 - 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 AND Code LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:36:24 - IsConnectionValid True 12:36:24 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 12:36:25 - IsConnectionValid True 12:36:25 - 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 12:36:26 - IsConnectionValid True 12:36:26 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 12:36:26 - IsConnectionValid True 12:36:26 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 12:36:31 - IsConnectionValid True 12:36:31 - IsConnectionValid True 12:36:31 - IsConnectionValid True 12:36:37 - IsConnectionValid True 12:36:37 - IsConnectionValid True 12:36:37 - IsConnectionValid True 12:37:54 - IsConnectionValid True 12:37:54 - IsConnectionValid True 12:37:54 - IsConnectionValid True 12:38:08 - IsConnectionValid True 12:38:08 - IsConnectionValid True 12:38:08 - IsConnectionValid True 12:39:19 - IsConnectionValid True 12:39:19 - IsConnectionValid True 12:39:19 - IsConnectionValid True 12:40:40 - IsConnectionValid True 12:40:40 - IsConnectionValid True 12:40:40 - IsConnectionValid True 12:40:40 - IsConnectionValid True 12:40: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 12:40:43 - IsConnectionValid True 12:40:43 - 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 12:40:48 - IsConnectionValid True 12:40:48 - 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 AND Code LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:40:48 - IsConnectionValid True 12:40: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 12:40:49 - IsConnectionValid True 12:40:49 - 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 12:40:50 - IsConnectionValid True 12:40:50 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 12:40:50 - IsConnectionValid True 12:40:50 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 12:41:20 - IsConnectionValid True 12:41:23 - IsConnectionValid True 12:41:30 - IsConnectionValid True 12:41:37 - IsConnectionValid True 12:41:40 - IsConnectionValid True 12:41:40 - 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 FROM LeaveType WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:41:41 - IsConnectionValid True 12:41:41 - IsConnectionValid True 12:41:41 - IsConnectionValid True 12:41:52 - IsConnectionValid True 12:41:54 - IsConnectionValid True 12:41:54 - IsConnectionValid True 12:41:54 - IsConnectionValid True 12:42:01 - IsConnectionValid True 12:42:03 - IsConnectionValid True 12:42:03 - IsConnectionValid True 12:42:03 - IsConnectionValid True 12:42:03 - IsConnectionValid True 12:42:03 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 12:42:30 - IsConnectionValid True 12:42:30 - 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 12:42:32 - IsConnectionValid True 12:42:32 - 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 AND Code LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:42:33 - IsConnectionValid True 12:42:33 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 12:42:34 - IsConnectionValid True 12:42:34 - 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 12:42:35 - IsConnectionValid True 12:42:35 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 12:42:35 - IsConnectionValid True 12:42:35 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 12:42:38 - IsConnectionValid True 12:42:43 - IsConnectionValid True 12:42:48 - IsConnectionValid True 12:42:50 - IsConnectionValid True 12:42:52 - IsConnectionValid True 12:42:52 - 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 FROM LeaveType WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:42:54 - IsConnectionValid True 12:42:54 - IsConnectionValid True 12:42:54 - IsConnectionValid True