11:17:05 - IsConnectionValid True
11:17:05 - IsConnectionValid True
11:17:06 - IsConnectionValid True
11:17:13 - IsConnectionValid True
11:17:16 - IsConnectionValid True
11:17:16 - IsConnectionValid True
11:17:19 - IsConnectionValid True
11:17:57 - IsConnectionValid True
11:18:02 - IsConnectionValid True
11:18:02 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%'  OR EnglishName LIKE '%1%' ) ORDER BY ID ASC  Query
11:18:02 - IsConnectionValid True
11:18:02 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, 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  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:18:10 - IsConnectionValid True
11:18:10 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASC  Query
11:18:10 - IsConnectionValid True
11:18:10 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, 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  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:30:36 - IsConnectionValid True
11:30:36 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASC  Query
11:30:36 - IsConnectionValid True
11:30:36 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, 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  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:30:38 - IsConnectionValid True
11:30:38 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASC  Query
11:30:39 - IsConnectionValid True
11:30:39 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, 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  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:37:55 - IsConnectionValid True
11:37:58 - IsConnectionValid True
11:37:58 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1  DateLeftTemp = @val2 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASC  Query
11:37:58 - (1-gen-1002) : Incorrect syntax near 'DateLeftTemp'.
11:37:58 - IsConnectionValid True
11:37:58 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, 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  DateLeftTemp = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:37:58 - (1-gen-1004) : Incorrect syntax near 'DateLeftTemp'.
11:40:38 - IsConnectionValid True
11:40:41 - IsConnectionValid True
11:40:41 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 and DateLeftTemp = @val2 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASC  Query
11:40:41 - (1-gen-1002) : Conversion failed when converting date and/or time from character string.
11:40:41 - IsConnectionValid True
11:40:41 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, 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 DateLeftTemp = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:40:41 - (1-gen-1004) : Conversion failed when converting date and/or time from character string.
11:40:44 - IsConnectionValid True
11:40:44 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 and DateLeftTemp = @val2 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASC  Query
11:40:44 - (1-gen-1002) : Conversion failed when converting date and/or time from character string.
11:40:44 - IsConnectionValid True
11:40:44 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, 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 DateLeftTemp = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:40:44 - (1-gen-1004) : Conversion failed when converting date and/or time from character string.
11:41:28 - IsConnectionValid True
11:41:32 - IsConnectionValid True
11:41:32 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 and CAST(DateLeftTemp AS Date) = @val2 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASC  Query
11:41:32 - IsConnectionValid True
11:41:32 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, 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 CAST(DateLeftTemp AS Date) = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:41:34 - IsConnectionValid True
11:41:34 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 and CAST(DateLeftTemp AS Date) = @val2 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASC  Query
11:41:34 - IsConnectionValid True
11:41:34 - 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, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, 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 CAST(DateLeftTemp AS Date) = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow