00:56:48 - IsConnectionValid True
00:56:52 - IsConnectionValid True
00:56:55 - IsConnectionValid True
00:56:55 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
00:56:57 - IsConnectionValid True
00:56:57 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 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 ID ASC  Query
00:56:57 - IsConnectionValid True
00:56:57 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees  WHERE  TenantID = 1 AND   UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then  1 else 0 END  END LIKE @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
00:56:59 - IsConnectionValid True
00:56:59 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query