02:58:09 - IsConnectionValid True 13:38:37 - IsConnectionValid True 13:38:47 - IsConnectionValid True 13:38:48 - IsConnectionValid True 13:38:48 - IsConnectionValid True 13:38:53 - IsConnectionValid True 13:38:53 - IsConnectionValid True 13:38:56 - IsConnectionValid True 13:39:05 - IsConnectionValid True 13:39:05 - 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 13:39:05 - (1-gen-1002) : Invalid object name 'Schools'. 13:39:31 - IsConnectionValid True 13:39:37 - IsConnectionValid True 13:39:37 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 13:39:52 - IsConnectionValid True 13:40:02 - IsConnectionValid True 13:40:02 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 13:40:07 - IsConnectionValid True 13:40:07 - IsConnectionValid True 13:40:12 - IsConnectionValid True 13:40:12 - 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 13:40:12 - (1-gen-1002) : Invalid object name 'Schools'. 13:40:15 - IsConnectionValid True 13:40:15 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 13:40:15 - IsConnectionValid True 13:40:15 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 13:40:17 - IsConnectionValid True 13:40:17 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 13:40:17 - IsConnectionValid True 13:40:17 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 13:40:20 - IsConnectionValid True 13:40:34 - IsConnectionValid True 13:40:40 - IsConnectionValid True 13:40:40 - 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 13:40:40 - (1-gen-1002) : Invalid object name 'Schools'. 13:42:23 - IsConnectionValid True 13:42:26 - IsConnectionValid True 13:42:26 - 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:42:29 - IsConnectionValid True 13:42: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 13:42:30 - IsConnectionValid True 13:42:30 - 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:42:34 - IsConnectionValid True 13:42:34 - 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:42:35 - IsConnectionValid True 13:42:35 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 13:42:35 - IsConnectionValid True 13:42:35 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 13:42:46 - IsConnectionValid True 13:42:46 - IsConnectionValid True 13:42:46 - IsConnectionValid True 13:42:46 - (3-hr-0010025) : Procedure or function 'HRMS_Save_MinusVacationEntry' expects parameter '@EmpWorkHour', which was not supplied. 13:42:55 - IsConnectionValid True 13:42:55 - IsConnectionValid True 13:42:55 - IsConnectionValid True 13:42:55 - (3-hr-0010025) : Procedure or function 'HRMS_Save_MinusVacationEntry' expects parameter '@EmpWorkHour', which was not supplied. 13:43:36 - IsConnectionValid True 13:43:36 - IsConnectionValid True 13:43:36 - IsConnectionValid True 13:43:36 - (3-hr-0010025) : Procedure or function 'HRMS_Save_MinusVacationEntry' expects parameter '@EmpWorkHour', which was not supplied. 13:43:50 - IsConnectionValid True 13:43:50 - IsConnectionValid True 13:43:50 - IsConnectionValid True 13:43:50 - (3-hr-0010025) : Procedure or function 'HRMS_Save_MinusVacationEntry' expects parameter '@EmpWorkHour', which was not supplied. 13:45:41 - IsConnectionValid True 13:45:41 - IsConnectionValid True 13:45:41 - IsConnectionValid True 13:45:41 - (3-hr-0010025) : Procedure or function 'HRMS_Save_MinusVacationEntry' expects parameter '@EmpWorkHour', which was not supplied. 13:46:04 - IsConnectionValid True 13:46:04 - IsConnectionValid True 13:46:04 - IsConnectionValid True 13:46:04 - (3-hr-0010025) : Procedure or function 'HRMS_Save_MinusVacationEntry' expects parameter '@EmpWorkHour', which was not supplied. 13:51:21 - IsConnectionValid True 13:51:21 - IsConnectionValid True 13:51:21 - IsConnectionValid True 13:51:22 - IsConnectionValid True 13:51: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:51:24 - IsConnectionValid True 13:51: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 13:51:33 - IsConnectionValid True 13:51:33 - 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:51:37 - IsConnectionValid True 13:51:38 - IsConnectionValid True 13:51: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 13:51:48 - IsConnectionValid True 13:51: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 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:52:01 - IsConnectionValid True 13:52:03 - IsConnectionValid True 13:52: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 13:52:15 - IsConnectionValid True 13:52:15 - IsConnectionValid True 13:52:20 - IsConnectionValid True 13:52:22 - IsConnectionValid True 13:52:22 - 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 13:52:22 - (1-gen-1002) : Invalid object name 'Schools'. 13:52:25 - IsConnectionValid True 13:52:25 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 13:52:25 - IsConnectionValid True 13:52:25 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 13:52:32 - IsConnectionValid True 13:52:32 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 13:52:32 - IsConnectionValid True 13:52:32 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 13:52:36 - IsConnectionValid True 13:53:11 - IsConnectionValid True 13:53:14 - IsConnectionValid True 13:53:14 - 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 13:53:14 - (1-gen-1002) : Invalid object name 'Schools'. 14:14:31 - IsConnectionValid True 14:14:33 - IsConnectionValid True 14:14: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 14:15:05 - IsConnectionValid True 14:18:01 - IsConnectionValid True 14:18: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 14:45:59 - IsConnectionValid True 14:46: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 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:46:14 - IsConnectionValid True 14:46: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 14:46:21 - IsConnectionValid True 14:46:22 - IsConnectionValid True 14:46: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 14:46:25 - IsConnectionValid True 14:46:25 - 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 14:46:30 - IsConnectionValid True 14:46: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 14:46:40 - IsConnectionValid True 14:46: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 14:46:57 - IsConnectionValid True 14:46:58 - IsConnectionValid True 14:46:58 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 14:47:00 - IsConnectionValid True 14:47: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 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:47:02 - IsConnectionValid True 14:47:02 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 14:47:04 - IsConnectionValid True 14:47:04 - 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 14:47:05 - IsConnectionValid True 14:47:05 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 14:47:15 - IsConnectionValid True 14:47:15 - IsConnectionValid True 14:47:16 - IsConnectionValid True 14:47:16 - SELECT DISTINCT FromDate AS FromDate, ToDate AS ToDate FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND ID = @val0 and TenantID = @val1 Query 14:47:23 - IsConnectionValid True 14:47:23 - IsConnectionValid True 14:47:23 - IsConnectionValid True 14:47:23 - SELECT DISTINCT FromDate AS FromDate, ToDate AS ToDate FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND ID = @val0 and TenantID = @val1 Query 14:47:34 - IsConnectionValid True 14:47:34 - IsConnectionValid True 14:47:34 - IsConnectionValid True 14:47:34 - SELECT DISTINCT FromDate AS FromDate, ToDate AS ToDate FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND ID = @val0 and TenantID = @val1 Query 14:48:14 - IsConnectionValid True 14:48:14 - IsConnectionValid True 14:48:14 - IsConnectionValid True 14:48:14 - SELECT DISTINCT FromDate AS FromDate, ToDate AS ToDate FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND ID = @val0 and TenantID = @val1 Query 14:48:22 - IsConnectionValid True 14:48:22 - IsConnectionValid True 14:48:22 - IsConnectionValid True 14:48:23 - IsConnectionValid True 14:48:23 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 14:48:25 - IsConnectionValid True 14:48:25 - 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 14:48:27 - IsConnectionValid True 14: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 14:48:38 - IsConnectionValid True 14:48:38 - 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 14:48:39 - IsConnectionValid True 14:48:39 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 14:48:39 - IsConnectionValid True 14:48:39 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 14:48:46 - IsConnectionValid True 14:48:46 - IsConnectionValid True 14:48:46 - IsConnectionValid True 14:48:46 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 14:48: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 14:48:46 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 14:48:56 - IsConnectionValid True 14:48:56 - IsConnectionValid True 14:48:57 - IsConnectionValid True 14:48:57 - IsConnectionValid True 14:48:57 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 14:48:58 - IsConnectionValid True 14:48:58 - 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 14:49:00 - IsConnectionValid True 14:49:00 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 14:49:03 - IsConnectionValid True 14:49:07 - IsConnectionValid True 14:49:07 - 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:49:07 - (1-gen-1002) : Invalid object name 'Schools'. 14:49:08 - IsConnectionValid True 14:49:08 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:49:08 - IsConnectionValid True 14:49:08 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:49:23 - IsConnectionValid True 14:49:25 - IsConnectionValid True 14:49:26 - IsConnectionValid True 14:49:26 - 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:49:26 - (1-gen-1002) : Invalid object name 'Schools'. 14:49:28 - IsConnectionValid True 14:49:28 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:49:28 - IsConnectionValid True 14:49:28 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:49:37 - IsConnectionValid True 14:49:37 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:49:37 - IsConnectionValid True 14:49:37 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:49:42 - IsConnectionValid True 14:49:47 - IsConnectionValid True 14:49:48 - IsConnectionValid True 14:49:48 - 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:49:48 - (1-gen-1002) : Invalid object name 'Schools'. 14:50:06 - IsConnectionValid True 14:50:10 - IsConnectionValid True 14:50:10 - 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:50:10 - (1-gen-1002) : Invalid object name 'Schools'. 14:50:11 - IsConnectionValid True 14:50:11 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:50:12 - IsConnectionValid True 14:50:12 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:50:14 - IsConnectionValid True 14:50:14 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:50:14 - IsConnectionValid True 14:50:14 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:50:18 - IsConnectionValid True 14:50:18 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:50:18 - IsConnectionValid True 14:50:18 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:50:23 - IsConnectionValid True 14:50:23 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:50:23 - IsConnectionValid True 14:50:23 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:50:25 - IsConnectionValid True 14:50:25 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:50:25 - IsConnectionValid True 14:50:25 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:50:27 - IsConnectionValid True 14:50:48 - IsConnectionValid True 14:51:20 - IsConnectionValid True 14:51:21 - IsConnectionValid True 14:51: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:51:21 - (1-gen-1002) : Invalid object name 'Schools'. 14:51:23 - IsConnectionValid True 14:51:23 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:51:23 - IsConnectionValid True 14:51:23 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:51:25 - IsConnectionValid True 14:51:25 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:51:25 - IsConnectionValid True 14:51:25 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:51:33 - IsConnectionValid True 14:51:44 - IsConnectionValid True 14:51:46 - IsConnectionValid True 14:51:46 - 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:51:46 - (1-gen-1002) : Invalid object name 'Schools'. 14:51:48 - IsConnectionValid True 14:51:48 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:51:48 - IsConnectionValid True 14:51:48 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:51:52 - IsConnectionValid True 14:51:52 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:51:52 - IsConnectionValid True 14:51:52 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:52:02 - IsConnectionValid True 14:52:10 - IsConnectionValid True 14:52:13 - IsConnectionValid True 14:52:13 - 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:52:13 - (1-gen-1002) : Invalid object name 'Schools'. 14:52:15 - IsConnectionValid True 14:52:15 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:52:15 - IsConnectionValid True 14:52:15 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:52:17 - IsConnectionValid True 14:52:17 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:52:17 - IsConnectionValid True 14:52:17 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:52:20 - IsConnectionValid True 14:52:36 - IsConnectionValid True 14:53:06 - IsConnectionValid True 14:53:20 - IsConnectionValid True 14:53:20 - 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:53:20 - (1-gen-1002) : Invalid object name 'Schools'. 14:53:22 - IsConnectionValid True 14:53:22 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:53:28 - IsConnectionValid True 14:55:13 - IsConnectionValid True 14:55:24 - IsConnectionValid True 14:55:30 - IsConnectionValid True 14:55:32 - IsConnectionValid True 14:55:35 - IsConnectionValid True 14:55:37 - IsConnectionValid True 14:55:39 - IsConnectionValid True 14:55:42 - IsConnectionValid True 14:56:11 - IsConnectionValid True 15:08:11 - IsConnectionValid True 15:08:11 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:08:36 - IsConnectionValid True 15:08:36 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:09:17 - IsConnectionValid True 15:09:19 - IsConnectionValid True 15:09:19 - 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 15:09:19 - (1-gen-1002) : Invalid object name 'Schools'. 15:09:20 - IsConnectionValid True 15:09:23 - IsConnectionValid True 15:09:28 - IsConnectionValid True 15:09:32 - IsConnectionValid True 15:09:35 - IsConnectionValid True 15:09:35 - 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 15:10:12 - IsConnectionValid True 15:10:40 - IsConnectionValid True 15:10:40 - IsConnectionValid True 15:10:47 - IsConnectionValid True 15:10:47 - 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 15:10:51 - IsConnectionValid True 15:10:54 - IsConnectionValid True 15:10:54 - IsConnectionValid True 15:11:07 - IsConnectionValid True 15:11:07 - IsConnectionValid True 15:11:09 - IsConnectionValid True 15:11:12 - IsConnectionValid True 15:11:21 - (1-gen-005001120) : Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 15:11:24 - (1-gen-005001120) : Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 15:11:44 - IsConnectionValid True 15:11:44 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 15:11:46 - IsConnectionValid True 15:11:46 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:11:49 - IsConnectionValid True 15:12:02 - IsConnectionValid True 15:12:02 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:12:40 - IsConnectionValid True 15:12:40 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:12:46 - IsConnectionValid True 15:12:54 - IsConnectionValid True 15:12:54 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwEmployeeChildren WHERE TenantID = 1 AND TenantID = @val0 AND UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:12:59 - IsConnectionValid True 15:13:05 - IsConnectionValid True 15:13:19 - IsConnectionValid True 15:13:29 - IsConnectionValid True 15:13:34 - IsConnectionValid True 15:13: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 15:13:35 - IsConnectionValid True 15:13:35 - 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 15:13:39 - IsConnectionValid True 15:13:42 - IsConnectionValid True 15:13: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 15:14:06 - IsConnectionValid True 15:14:08 - IsConnectionValid True 15:14:14 - IsConnectionValid True 15:14: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >08/07/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:14:17 - IsConnectionValid True 15:14:17 - 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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >08/07/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:14:18 - IsConnectionValid True 15:14:18 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 15:14:19 - IsConnectionValid True 15:14:21 - IsConnectionValid True 15:14:21 - 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 15:14:26 - IsConnectionValid True 15:14:26 - 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 15:14:28 - IsConnectionValid True 15:14:28 - IsConnectionValid True 15:14:28 - IsConnectionValid True 15:14:28 - IsConnectionValid True 15:14:28 - IsConnectionValid True 15:14:28 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 15:14:28 - 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 15:14:28 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 15:14:28 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 15:14:28 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 15:14:29 - IsConnectionValid True 15:14:29 - IsConnectionValid True 15:14:29 - IsConnectionValid True 15:14:29 - IsConnectionValid True 15:14:29 - IsConnectionValid True 15:14:29 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:29 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:29 - IsConnectionValid True 15:14:29 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:29 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:29 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 15:14:29 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:29 - IsConnectionValid True 15:14:29 - IsConnectionValid True 15:14:29 - IsConnectionValid True 15:14:29 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:29 - IsConnectionValid True 15:14:29 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:29 - IsConnectionValid True 15:14:29 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:29 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:29 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:29 - IsConnectionValid True 15:14:29 - IsConnectionValid True 15:14:29 - IsConnectionValid True 15:14:29 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:29 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:29 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 15:14:29 - IsConnectionValid True 15:14:29 - IsConnectionValid True 15:14:29 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:29 - IsConnectionValid True 15:14:29 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:29 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 15:14:29 - IsConnectionValid True 15:14:29 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 15:14:29 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 15:14:29 - IsConnectionValid True 15:14:29 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:29 - IsConnectionValid True 15:14:29 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:29 - IsConnectionValid True 15:14:29 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 15:14:29 - IsConnectionValid True 15:14:29 - IsConnectionValid True 15:14:29 - 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 = 845 WHERE LocationDef.TenantID =1 Query 15:14:29 - 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 = 845 WHERE CustodyItemsDef.TenantID =1 Query 15:14:29 - IsConnectionValid True 15:14:29 - 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 =845 Query 15:14:29 - IsConnectionValid True 15:14:29 - IsConnectionValid True 15:14:29 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:14:29 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:14:29 - IsConnectionValid True 15:14:29 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:14:29 - IsConnectionValid True 15:14:29 - IsConnectionValid True 15:14:29 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:14:29 - IsConnectionValid True 15:14:29 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 15:14:29 - IsConnectionValid True 15:14:29 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 15:14:57 - IsConnectionValid True 15:14:57 - IsConnectionValid True 15:14:57 - IsConnectionValid True 15:14:57 - IsConnectionValid True 15:14:57 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:14:57 - SELECT DISTINCT * FROM vwEmployeesResignation WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 15:14:57 - (1-gen-1002) : The given key was not present in the dictionary. 15:14:57 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 15:15:06 - IsConnectionValid True 15:15:11 - IsConnectionValid True 15:15:12 - IsConnectionValid True 15:15:16 - IsConnectionValid True 15:15:16 - SELECT * FROM HRMS_VwVacationEntry_Cancel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 ORDER BY FromDate ASC Query 15:15:17 - IsConnectionValid True 15:15:17 - 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 >08/07/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:15:26 - IsConnectionValid True 15:15: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 =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >08/07/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:15:34 - IsConnectionValid True 15:15:38 - IsConnectionValid True 15:15:38 - 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 15:15:53 - IsConnectionValid True 15:15:53 - 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 15:15:58 - IsConnectionValid True 15:15:58 - IsConnectionValid True 15:15:58 - IsConnectionValid True 15:15:58 - IsConnectionValid True 15:15:58 - IsConnectionValid True 15:15:58 - IsConnectionValid True 15:15: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 15:15:58 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 15:15:58 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 15:15:58 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 15:15:58 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 15:15:59 - IsConnectionValid True 15:15:59 - IsConnectionValid True 15:15:59 - IsConnectionValid True 15:15:59 - IsConnectionValid True 15:15:59 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:15:59 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:15:59 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:15:59 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:15:59 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 15:15:59 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:15:59 - IsConnectionValid True 15:15:59 - IsConnectionValid True 15:15:59 - IsConnectionValid True 15:15:59 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:15:59 - IsConnectionValid True 15:15:59 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:15:59 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:15:59 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:15:59 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:15:59 - IsConnectionValid True 15:15:59 - IsConnectionValid True 15:15:59 - IsConnectionValid True 15:15:59 - IsConnectionValid True 15:15:59 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 15:15:59 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:15:59 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:15:59 - IsConnectionValid True 15:15:59 - IsConnectionValid True 15:15:59 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 15:15:59 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:15:59 - IsConnectionValid True 15:15:59 - IsConnectionValid True 15:15:59 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 15:15:59 - IsConnectionValid True 15:15:59 - IsConnectionValid True 15:15:59 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 15:15:59 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:15:59 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:15:59 - IsConnectionValid True 15:15:59 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 15:15:59 - IsConnectionValid True 15:15:59 - IsConnectionValid True 15:15: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 = 845 WHERE LocationDef.TenantID =1 Query 15:15: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 = 845 WHERE CustodyItemsDef.TenantID =1 Query 15:15:59 - IsConnectionValid True 15:15:59 - IsConnectionValid True 15:15:59 - IsConnectionValid True 15:15:59 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:15: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 =845 Query 15:15:59 - IsConnectionValid True 15:15:59 - IsConnectionValid True 15:15:59 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:15:59 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:15:59 - IsConnectionValid True 15:15:59 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:15:59 - IsConnectionValid True 15:15:59 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 15:15:59 - IsConnectionValid True 15:15:59 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 15:16:05 - IsConnectionValid True 15:16:14 - IsConnectionValid True 15:16:14 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 15:16:21 - IsConnectionValid True 15:16:25 - IsConnectionValid True 15:16:25 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 15:16:28 - IsConnectionValid True 15:16:28 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 ORDER BY Code ASC Query 15:16:31 - IsConnectionValid True 15:16:33 - IsConnectionValid True 15:16:33 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 ORDER BY Code ASC Query 15:17:12 - IsConnectionValid True 15:17:22 - IsConnectionValid True 15:17:22 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwEmployeeChildren WHERE TenantID = 1 AND TenantID = @val0 AND UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:17:25 - IsConnectionValid True 15:17:31 - IsConnectionValid True 15:17:31 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:17:34 - IsConnectionValid True 15:17:44 - IsConnectionValid True 15:17:45 - IsConnectionValid True 15:17:47 - IsConnectionValid True 15:17:48 - IsConnectionValid True 15:18:09 - IsConnectionValid True 15:20:43 - IsConnectionValid True 15:20:46 - IsConnectionValid True 15:20:46 - 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 15:20:46 - (1-gen-1002) : Invalid object name 'Schools'. 15:20:47 - IsConnectionValid True 15:20:47 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:21:12 - IsConnectionValid True 15:21:12 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:22:09 - IsConnectionValid True 15:22:11 - IsConnectionValid True 15:22:11 - 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 15:22:15 - IsConnectionValid True 15:22:45 - (1-gen-005001120) : Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 15:23:20 - IsConnectionValid True 15:23:27 - IsConnectionValid True 15:23: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >08/07/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:23:39 - IsConnectionValid True 15:23:39 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 15:23:42 - IsConnectionValid True 15:23:43 - IsConnectionValid True 15:24:09 - IsConnectionValid True 15:24:10 - IsConnectionValid True 15:24:39 - IsConnectionValid True 15:24:39 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:24:42 - IsConnectionValid True 15:24:45 - IsConnectionValid True 15:24:46 - IsConnectionValid True 15:25:23 - IsConnectionValid True 15:25:23 - IsConnectionValid True 15:25:23 - IsConnectionValid True 15:25:23 - SELECT DISTINCT * FROM StaffCategory WHERE TenantID =1 ORDER BY ID Query 15:25:23 - SELECT * FROM web_HRMS_Experience WHERE TenantID = 1 AND TenantID = @val0 ORDER BY StaffCatID ASC, ExperienceNo2 ASC Query 15:25:32 - IsConnectionValid True 15:25:38 - IsConnectionValid True 15:25:38 - SELECT ID AS ID, Code AS Code, Name AS Name, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, 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 15:25:42 - IsConnectionValid True 15:25:42 - SELECT ID AS ID, Code AS Code, Name AS Name, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, 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 15:25:45 - IsConnectionValid True 15:25:45 - SELECT ID AS ID, Code AS Code, Name AS Name, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, 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 15:25:45 - IsConnectionValid True 15:25:45 - SELECT ID AS ID, Code AS Code, Name AS Name, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, 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 15:26:03 - IsConnectionValid True 15:26:03 - 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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, 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 15:26:03 - IsConnectionValid True 15:26:03 - 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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, 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 15:26:03 - IsConnectionValid True 15:26: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, 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 15:26:04 - IsConnectionValid True 15:26: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, 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 15:30:17 - IsConnectionValid True 15:30:20 - IsConnectionValid True 15:30:20 - 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 15:30:20 - (1-gen-1002) : Invalid object name 'Schools'. 15:30:21 - IsConnectionValid True 15:30:21 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:30:24 - IsConnectionValid True 15:30:24 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:30:44 - IsConnectionValid True 15:30:46 - IsConnectionValid True 15:30:46 - 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 15:30:46 - (1-gen-1002) : Invalid object name 'Schools'. 15:30:54 - IsConnectionValid True 15:30:54 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:31:19 - IsConnectionValid True 15:31:19 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:31:57 - IsConnectionValid True 15:32:00 - IsConnectionValid True 15:32:00 - 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 15:32:00 - (1-gen-1002) : Invalid object name 'Schools'. 15:32:02 - IsConnectionValid True 15:32:02 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 OR Code LIKE @val6 OR Name LIKE @val7 OR CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val8 ORDER BY Code ASC Query 15:32:03 - IsConnectionValid True 15:32:03 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:33:33 - IsConnectionValid True 15:33:36 - IsConnectionValid True 15:33:36 - 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 15:33:36 - (1-gen-1002) : Invalid object name 'Schools'. 15:33:50 - IsConnectionValid True 15:33:50 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 OR Code LIKE @val5 OR Name LIKE @val6 OR CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val7 ORDER BY Code ASC Query 15:33:52 - IsConnectionValid True 15:33:52 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 ORDER BY Code ASC Query 15:34:26 - IsConnectionValid True 15:34:28 - IsConnectionValid True 15:34:28 - 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 15:34:28 - (1-gen-1002) : Invalid object name 'Schools'. 15:34:47 - IsConnectionValid True 15:34:48 - IsConnectionValid True 15:34:48 - 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 15:34:48 - (1-gen-1002) : Invalid object name 'Schools'. 15:34:50 - IsConnectionValid True 15:34:50 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:35:01 - IsConnectionValid True 15:35:01 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:35:05 - IsConnectionValid True 15:35:05 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:35:07 - IsConnectionValid True 15:35:07 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:35:08 - IsConnectionValid True 15:35:08 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:35:08 - IsConnectionValid True 15:35:08 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:35:15 - IsConnectionValid True 15:35:16 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:35:16 - IsConnectionValid True 15:35:16 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:35:16 - IsConnectionValid True 15:35:16 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:35:16 - IsConnectionValid True 15:35:16 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:35:16 - IsConnectionValid True 15:35:16 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:35:16 - IsConnectionValid True 15:35:16 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:35:16 - IsConnectionValid True 15:35:16 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:35:16 - IsConnectionValid True 15:35:16 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:37:41 - IsConnectionValid True 15:37:41 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:38:15 - IsConnectionValid True 15:38:16 - IsConnectionValid True 15:38: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 15:38:16 - (1-gen-1002) : Invalid object name 'Schools'. 15:38:21 - IsConnectionValid True 15:38:21 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:38:40 - IsConnectionValid True 15:38:40 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:38:47 - IsConnectionValid True 15:38:47 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:38:47 - IsConnectionValid True 15:38:47 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:39:36 - IsConnectionValid True 15:39:36 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:39:45 - IsConnectionValid True 15:39:45 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:40:10 - IsConnectionValid True 15:40:12 - IsConnectionValid True 15:40:12 - 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 15:40:12 - (1-gen-1002) : Invalid object name 'Schools'. 15:40:15 - IsConnectionValid True 15:40:15 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:40:25 - IsConnectionValid True 15:40:26 - IsConnectionValid True 15:40:26 - 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 15:40:26 - (1-gen-1002) : Invalid object name 'Schools'. 15:40:30 - IsConnectionValid True 15:40:30 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:40:41 - IsConnectionValid True 15:40:41 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:41:14 - IsConnectionValid True 15:41:14 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:41:51 - IsConnectionValid True 15:41:52 - IsConnectionValid True 15:41:54 - IsConnectionValid True 15:41:56 - IsConnectionValid True 15:41:59 - IsConnectionValid True 15:41:59 - 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 15:41:59 - (1-gen-1002) : Invalid object name 'Schools'. 15:42:00 - IsConnectionValid True 15:42:00 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:42:00 - IsConnectionValid True 15:42:00 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:42:04 - IsConnectionValid True 15:42:05 - IsConnectionValid True 15:42:05 - 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 15:42:05 - (1-gen-1002) : Invalid object name 'Schools'. 15:42:06 - IsConnectionValid True 15:42:06 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:42:07 - IsConnectionValid True 15:42:07 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:42:15 - IsConnectionValid True 15:42:15 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:44:04 - IsConnectionValid True 15:44:05 - IsConnectionValid True 15:44:05 - 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 15:44:05 - (1-gen-1002) : Invalid object name 'Schools'. 15:44:07 - IsConnectionValid True 15:44:07 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:44:11 - IsConnectionValid True 15:44:11 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:44:11 - IsConnectionValid True 15:44:11 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:44:11 - IsConnectionValid True 15:44:11 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:44:11 - IsConnectionValid True 15:44:11 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:44:25 - IsConnectionValid True 15:44:26 - IsConnectionValid True 15:44:28 - IsConnectionValid True 15:44:30 - IsConnectionValid True 15:44:30 - 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 15:44:30 - (1-gen-1002) : Invalid object name 'Schools'. 15:44:31 - IsConnectionValid True 15:44:31 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:44:32 - IsConnectionValid True 15:44: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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:44:35 - IsConnectionValid True 15:44:35 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:44:38 - IsConnectionValid True 15:44:38 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:45:41 - IsConnectionValid True 15:45:42 - IsConnectionValid True 15:45:42 - 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 15:45:42 - (1-gen-1002) : Invalid object name 'Schools'. 15:45:59 - IsConnectionValid True 15:45:59 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:46:16 - IsConnectionValid True 15:46:16 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:46:36 - IsConnectionValid True 15:46:37 - IsConnectionValid True 15:46:39 - IsConnectionValid True 15:46:42 - IsConnectionValid True 15:46:42 - 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 15:46:42 - (1-gen-1002) : Invalid object name 'Schools'. 15:46:43 - IsConnectionValid True 15:46:43 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:46:46 - IsConnectionValid True 15:46: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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:46:59 - IsConnectionValid True 15:46:59 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:47:12 - IsConnectionValid True 15:47:12 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:47:12 - IsConnectionValid True 15:47:12 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:47:20 - IsConnectionValid True 15:47:20 - 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, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 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 15:47:49 - IsConnectionValid True 15:47:58 - IsConnectionValid True 15:59:03 - IsConnectionValid True 15:59:06 - IsConnectionValid True 15:59:06 - 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 15:59:06 - (1-gen-1002) : Invalid object name 'Schools'. 15:59:55 - IsConnectionValid True 15:59:57 - IsConnectionValid True 15:59:57 - 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 15:59:57 - (1-gen-1002) : Invalid object name 'Schools'. 16:00:27 - IsConnectionValid True 16:00:29 - IsConnectionValid True 16:00:29 - 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 16:00:29 - (1-gen-1002) : Invalid object name 'Schools'. 16:00:45 - IsConnectionValid True 16:00:47 - IsConnectionValid True 16:00:47 - 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 16:00:47 - (1-gen-1002) : Invalid object name 'Schools'. 16:01:33 - IsConnectionValid True 16:01:35 - IsConnectionValid True 16:01:35 - 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 16:01:35 - (1-gen-1002) : Invalid object name 'Schools'. 16:01:40 - IsConnectionValid True 16:01:40 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 16:02:05 - IsConnectionValid True 16:02:05 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 16:06:18 - IsConnectionValid True 16:06:20 - IsConnectionValid True 16:06:20 - 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 16:06:20 - (1-gen-1002) : Invalid object name 'Schools'. 16:06:24 - IsConnectionValid True 16:06:24 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ([object Object]=0 and DateLeft='01/01/1900') or ([object Object]=1 and DateLeft<>'01/01/1900') or [object Object]=2 and CAST(DateLeft AS Date) = @val6 ORDER BY Code ASC Query 16:06:24 - (1-gen-1002) : Invalid column name 'object Object'. Invalid column name 'object Object'. Invalid column name 'object Object'. 16:06:24 - IsConnectionValid True 16:06:24 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ([object Object]=0 and DateLeft='01/01/1900') or ([object Object]=1 and DateLeft<>'01/01/1900') or [object Object]=2 and CAST(DateLeft AS Date) = @val6 ORDER BY Code ASC Query 16:06:24 - (1-gen-1002) : Invalid column name 'object Object'. Invalid column name 'object Object'. Invalid column name 'object Object'. 16:06:54 - IsConnectionValid True 16:06:56 - IsConnectionValid True 16:06:56 - 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 16:06:56 - (1-gen-1002) : Invalid object name 'Schools'. 16:06:57 - IsConnectionValid True 16:06:57 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ([object Object]=0 and DateLeft='01/01/1900') or ([object Object]=1 and DateLeft<>'01/01/1900') or [object Object]=2 ORDER BY Code ASC Query 16:06:58 - (1-gen-1002) : Invalid column name 'object Object'. Invalid column name 'object Object'. Invalid column name 'object Object'. 16:06:58 - IsConnectionValid True 16:06:58 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ([object Object]=0 and DateLeft='01/01/1900') or ([object Object]=1 and DateLeft<>'01/01/1900') or [object Object]=2 ORDER BY Code ASC Query 16:06:58 - (1-gen-1002) : Invalid column name 'object Object'. Invalid column name 'object Object'. Invalid column name 'object Object'. 16:07:27 - IsConnectionValid True 16:07:29 - IsConnectionValid True 16:07:29 - 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 16:07:29 - (1-gen-1002) : Invalid object name 'Schools'. 16:07:31 - IsConnectionValid True 16:07:31 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and (([object Object]=0 and DateLeft='01/01/1900') or ([object Object]=1 and DateLeft<>'01/01/1900') or [object Object]=2 ) ORDER BY Code ASC Query 16:07:31 - (1-gen-1002) : Invalid column name 'object Object'. Invalid column name 'object Object'. Invalid column name 'object Object'. 16:07:31 - IsConnectionValid True 16:07:31 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and (([object Object]=0 and DateLeft='01/01/1900') or ([object Object]=1 and DateLeft<>'01/01/1900') or [object Object]=2 ) ORDER BY Code ASC Query 16:07:31 - (1-gen-1002) : Invalid column name 'object Object'. Invalid column name 'object Object'. Invalid column name 'object Object'. 16:09:17 - IsConnectionValid True 16:09:19 - IsConnectionValid True 16:09:19 - 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 16:09:19 - (1-gen-1002) : Invalid object name 'Schools'. 16:09:21 - IsConnectionValid True 16:09:21 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((undefined=0 and DateLeft='01/01/1900') or (undefined=1 and DateLeft<>'01/01/1900' ) or undefined=2 ) ORDER BY Code ASC Query 16:09:21 - (1-gen-1002) : Invalid column name 'undefined'. Invalid column name 'undefined'. Invalid column name 'undefined'. 16:09:21 - IsConnectionValid True 16:09:21 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((undefined=0 and DateLeft='01/01/1900') or (undefined=1 and DateLeft<>'01/01/1900' ) or undefined=2 ) ORDER BY Code ASC Query 16:09:21 - (1-gen-1002) : Invalid column name 'undefined'. Invalid column name 'undefined'. Invalid column name 'undefined'. 16:09:48 - IsConnectionValid True 16:09:50 - IsConnectionValid True 16:09:50 - 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 16:09:50 - (1-gen-1002) : Invalid object name 'Schools'. 16:09:52 - IsConnectionValid True 16:09:52 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((undefined=0 and DateLeft='01/01/1900') or (undefined=1 and DateLeft<>'01/01/1900' ) or undefined=2 ) ORDER BY Code ASC Query 16:09:52 - (1-gen-1002) : Invalid column name 'undefined'. Invalid column name 'undefined'. Invalid column name 'undefined'. 16:09:52 - IsConnectionValid True 16:09:52 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((undefined=0 and DateLeft='01/01/1900') or (undefined=1 and DateLeft<>'01/01/1900' ) or undefined=2 ) ORDER BY Code ASC Query 16:09:52 - (1-gen-1002) : Invalid column name 'undefined'. Invalid column name 'undefined'. Invalid column name 'undefined'. 16:10:30 - IsConnectionValid True 16:10:33 - IsConnectionValid True 16:10:33 - 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 16:10:33 - (1-gen-1002) : Invalid object name 'Schools'. 16:10:35 - IsConnectionValid True 16:10:35 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((0=0 and DateLeft='01/01/1900') or (0=1 and DateLeft<>'01/01/1900' ) or 0=2 ) ORDER BY Code ASC Query 16:11:00 - IsConnectionValid True 16:11:00 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((0=0 and DateLeft='01/01/1900') or (0=1 and DateLeft<>'01/01/1900' ) or 0=2 ) ORDER BY Code ASC Query 16:14:56 - IsConnectionValid True 16:14:56 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((0=0 and DateLeft='01/01/1900') or (0=1 and DateLeft<>'01/01/1900' ) or 0=2 ) ORDER BY Code ASC Query 16:15:09 - IsConnectionValid True 16:15:11 - IsConnectionValid True 16:15:11 - 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 16:15:11 - (1-gen-1002) : Invalid object name 'Schools'. 16:15:16 - IsConnectionValid True 16:15:16 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:15:21 - IsConnectionValid True 16:15:21 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:15:25 - IsConnectionValid True 16:15:25 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:15:50 - IsConnectionValid True 16:15:50 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:16:05 - IsConnectionValid True 16:17:24 - IsConnectionValid True 16:17:24 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:17:29 - IsConnectionValid True 16:17:29 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:17:37 - IsConnectionValid True 16:17:37 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:17:39 - IsConnectionValid True 16:17:39 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:17:43 - IsConnectionValid True 16:22:52 - IsConnectionValid True 16:22:52 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:22:53 - IsConnectionValid True 16:22:53 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:22:59 - IsConnectionValid True 16:22:59 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:23:24 - IsConnectionValid True 16:23:24 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:23:26 - IsConnectionValid True 16:23:28 - IsConnectionValid True 16:23:28 - 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 16:23:28 - (1-gen-1002) : Invalid object name 'Schools'. 16:29:46 - IsConnectionValid True 16:29:48 - IsConnectionValid True 16:29:48 - 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 16:29:48 - (1-gen-1002) : Invalid object name 'Schools'. 16:29:53 - IsConnectionValid True 16:29:53 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 16:30:19 - IsConnectionValid True 16:30:19 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 16:31:23 - IsConnectionValid True 16:31:32 - IsConnectionValid True 16:31:35 - IsConnectionValid True 16:31:35 - 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 16:31:35 - (1-gen-1002) : Invalid object name 'Schools'. 16:32:07 - IsConnectionValid True 16:32:27 - IsConnectionValid True 16:32:27 - 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 16:32:27 - (1-gen-1002) : Invalid object name 'Schools'. 16:33:53 - IsConnectionValid True 16:33:55 - IsConnectionValid True 16:33:55 - 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 16:33:55 - (1-gen-1002) : Invalid object name 'Schools'. 16:34:00 - IsConnectionValid True 16:38:03 - IsConnectionValid True 16:38:06 - IsConnectionValid True 16:38:06 - 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 16:38:06 - (1-gen-1002) : Invalid object name 'Schools'. 16:38:38 - IsConnectionValid True 16:38:40 - IsConnectionValid True 16:38:40 - 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 16:38:40 - (1-gen-1002) : Invalid object name 'Schools'. 16:39:41 - IsConnectionValid True 16:39:41 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:40:06 - IsConnectionValid True 16:40:06 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:40:09 - IsConnectionValid True 16:40:09 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:40:34 - IsConnectionValid True 16:40:34 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:40:37 - IsConnectionValid True 16:41:00 - IsConnectionValid True 16:41:33 - IsConnectionValid True 16:41:35 - IsConnectionValid True 16:41:35 - 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 16:41:35 - (1-gen-1002) : Invalid object name 'Schools'. 16:41:36 - IsConnectionValid True 16:41:36 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((0=0 and DateLeft='01/01/1900') or (0=1 and DateLeft<>'01/01/1900' ) or 0=2 ) ORDER BY Code ASC Query 16:42:02 - IsConnectionValid True 16:42:02 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((0=0 and DateLeft='01/01/1900') or (0=1 and DateLeft<>'01/01/1900' ) or 0=2 ) ORDER BY Code ASC Query 16:42:32 - IsConnectionValid True 16:42:32 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((0=0 and DateLeft='01/01/1900') or (0=1 and DateLeft<>'01/01/1900' ) or 0=2 ) ORDER BY Code ASC Query 16:42:58 - IsConnectionValid True 16:42:58 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((0=0 and DateLeft='01/01/1900') or (0=1 and DateLeft<>'01/01/1900' ) or 0=2 ) ORDER BY Code ASC Query 16:43:13 - IsConnectionValid True 16:43:13 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:43:38 - IsConnectionValid True 16:43:39 - IsConnectionValid True 16:43:40 - IsConnectionValid True 16:43:43 - IsConnectionValid True 16:43:43 - 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 16:43:43 - (1-gen-1002) : Invalid object name 'Schools'. 16:43:45 - IsConnectionValid True 16:43:45 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((0=0 and DateLeft='01/01/1900') or (0=1 and DateLeft<>'01/01/1900' ) or 0=2 ) ORDER BY Code ASC Query 16:43:50 - IsConnectionValid True 16:43:50 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:44:11 - IsConnectionValid True 16:44:11 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((0=0 and DateLeft='01/01/1900') or (0=1 and DateLeft<>'01/01/1900' ) or 0=2 ) ORDER BY Code ASC Query 16:44:11 - IsConnectionValid True 16:44:11 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:44:13 - IsConnectionValid True 16:44:13 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:44:13 - IsConnectionValid True 16:44:13 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:44:22 - IsConnectionValid True 16:44:50 - IsConnectionValid True 16:46:56 - IsConnectionValid True 16:47:31 - IsConnectionValid True 16:47:36 - IsConnectionValid True 16:48:14 - IsConnectionValid True 16:48:43 - IsConnectionValid True 16:50:00 - IsConnectionValid True 16:50:02 - IsConnectionValid True 16:50:02 - 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 16:50:02 - (1-gen-1002) : Invalid object name 'Schools'. 16:50:07 - IsConnectionValid True 16:50:07 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:50:32 - IsConnectionValid True 16:50:32 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:50:34 - IsConnectionValid True 16:50:34 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:50:42 - IsConnectionValid True 16:50:42 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:50:47 - IsConnectionValid True 16:51:53 - IsConnectionValid True 16:52:48 - IsConnectionValid True 16:53:18 - IsConnectionValid True 16:54:09 - IsConnectionValid True 16:54:51 - IsConnectionValid True 16:54:59 - IsConnectionValid True 16:54:59 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((2=0 and DateLeft='01/01/1900') or (2=1 and DateLeft<>'01/01/1900' ) or 2=2 ) ORDER BY Code ASC Query 16:54:59 - IsConnectionValid True 16:54:59 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((2=0 and DateLeft='01/01/1900') or (2=1 and DateLeft<>'01/01/1900' ) or 2=2 ) ORDER BY Code ASC Query 16:55:11 - IsConnectionValid True 16:55:16 - IsConnectionValid True 16:56:10 - IsConnectionValid True 16:56:12 - IsConnectionValid True 16:56:13 - 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 16:56:13 - (1-gen-1002) : Invalid object name 'Schools'. 16:56:16 - IsConnectionValid True 16:56:16 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((0=0 and DateLeft='01/01/1900') or (0=1 and DateLeft<>'01/01/1900' ) or 0=2 ) ORDER BY Code ASC Query 16:56:24 - IsConnectionValid True 16:56:24 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:56:42 - IsConnectionValid True 16:56:42 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((0=0 and DateLeft='01/01/1900') or (0=1 and DateLeft<>'01/01/1900' ) or 0=2 ) ORDER BY Code ASC Query 16:56:42 - IsConnectionValid True 16:56:42 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:56:44 - IsConnectionValid True 16:56:44 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:57:09 - IsConnectionValid True 16:57:09 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((1=0 and DateLeft='01/01/1900') or (1=1 and DateLeft<>'01/01/1900' ) or 1=2 ) ORDER BY Code ASC Query 16:57:39 - IsConnectionValid True 16:57:47 - IsConnectionValid True 16:58:02 - IsConnectionValid True 17:00:28 - IsConnectionValid True 17:01:07 - IsConnectionValid True 17:01:31 - IsConnectionValid True 17:02:09 - IsConnectionValid True 17:02:17 - IsConnectionValid True 17:02:50 - IsConnectionValid True