01:07:35 - IsConnectionValid True 01:07:42 - IsConnectionValid True 01:07:42 - IsConnectionValid True 01:07:44 - IsConnectionValid True 01:08:05 - IsConnectionValid True 01:08:05 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwVacationDays WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 01:08:07 - IsConnectionValid True 12:27:46 - IsConnectionValid True 12:27:46 - IsConnectionValid True 13:40:48 - IsConnectionValid True 13:40:53 - IsConnectionValid True 13:40:57 - IsConnectionValid True 13:41:01 - IsConnectionValid True 13:42:08 - IsConnectionValid True 13:42:12 - IsConnectionValid True 13:42:17 - IsConnectionValid True 13:42:20 - IsConnectionValid True 13:42:20 - IsConnectionValid True 13:42:23 - IsConnectionValid True 13:42:24 - IsConnectionValid True 13:43:50 - IsConnectionValid False 13:43:50 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:44:27 - IsConnectionValid False 13:44:27 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:44:28 - IsConnectionValid False 13:44:28 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:45:44 - IsConnectionValid False 13:45:44 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:45:47 - IsConnectionValid True 13:45:51 - IsConnectionValid False 13:45:51 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:45:58 - IsConnectionValid False 13:45:58 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:46:02 - IsConnectionValid False 13:46:02 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:46:35 - IsConnectionValid False 13:46:35 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:49:43 - IsConnectionValid False 13:49:43 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:50:13 - IsConnectionValid False 13:50:13 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:51:13 - IsConnectionValid False 13:51:37 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:51:41 - IsConnectionValid True 13:51:48 - IsConnectionValid True 13:51:52 - IsConnectionValid True 13:51:52 - IsConnectionValid True 13:51:54 - IsConnectionValid True 13:51:57 - IsConnectionValid True 13:52:04 - IsConnectionValid False 13:53:44 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:53:44 - IsConnectionValid False 13:53:46 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:53:49 - IsConnectionValid False 13:53:50 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:53:53 - IsConnectionValid False 13:54:37 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:54:40 - IsConnectionValid False 13:55:31 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:55:33 - IsConnectionValid False 13:56:48 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:57:39 - IsConnectionValid False 13:59:40 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:59:41 - IsConnectionValid False 13:59:41 - IsConnectionValid False 13:59:41 - IsConnectionValid False 13:59:58 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:59:59 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 13:59:59 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 14:00:03 - IsConnectionValid False 14:00:13 - (1-att-000001) : The entry 'MainConnection' has already been added. (D:\Web Projects\Human Resources Management System\Web Services\API\Attendance\WCF\WCF.Web\web.config line 8) 14:07:38 - IsConnectionValid True 14:10:10 - IsConnectionValid True 14:10:14 - IsConnectionValid True 14:10:18 - IsConnectionValid True 14:10:22 - IsConnectionValid True 14:10:22 - IsConnectionValid True 14:10:48 - IsConnectionValid True 14:10:48 - SELECT ID AS ID, FromHour AS FromHour, ToHour AS ToHour FROM VacationEntry WHERE TenantID = 1 AND EmployeeID = @val0 and CAST(FromDate AS Date) = @val1 and IsHours = @val2 and Minus > @val3 and IsFromAttendance = @val4 and TenantID = @val5 ORDER BY ID asc Query 14:11:02 - IsConnectionValid True 14:11:02 - SELECT * FROM AttendanceEmpTimeDetails WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 and CAST(Date AS Date) = @val2 Query 14:11:27 - IsConnectionValid True 14:11:27 - (1-att-000006) : Could not find stored procedure 'web_attendance_autoProcessDetection'. 14:11:30 - IsConnectionValid True 14:11:30 - (1-att-000006) : Could not find stored procedure 'web_attendance_autoProcessDetection'. 14:12:27 - IsConnectionValid True 14:12:27 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('10/31/2024', isnull(VacAbbrID,0) , 116, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 14:12:31 - IsConnectionValid True 14:12:31 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) Query 14:12:49 - IsConnectionValid True 14:12:49 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('10/31/2024', isnull(VacAbbrID,0) , 116, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 14:12:53 - IsConnectionValid True 14:12:53 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) Query 14:22:09 - IsConnectionValid True 14:22:10 - (1-att-000006) : Could not find stored procedure 'web_attendance_autoProcessDetection'. 14:23:20 - IsConnectionValid True 14:23:43 - IsConnectionValid True 14:23:50 - IsConnectionValid True 14:24:18 - IsConnectionValid True 14:24:29 - IsConnectionValid True 14:24:29 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('10/31/2024', isnull(VacAbbrID,0) , 67, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 14:24:29 - IsConnectionValid True 14:24:29 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) Query 14:24:52 - IsConnectionValid True 14:24:52 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('10/31/2024', isnull(VacAbbrID,0) , 55, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 14:24:52 - IsConnectionValid True 14:24:52 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) Query 14:25:13 - IsConnectionValid True 14:25:13 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('10/31/2024', isnull(VacAbbrID,0) , 67, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 14:25:13 - IsConnectionValid True 14:25:13 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) Query 14:28:01 - IsConnectionValid True 14:28:12 - IsConnectionValid True 14:28:26 - IsConnectionValid True 14:28:54 - IsConnectionValid True 14:32:13 - IsConnectionValid True 14:32:23 - IsConnectionValid True 14:33:16 - IsConnectionValid True 14:33:23 - IsConnectionValid True 14:34:02 - IsConnectionValid True 14:34:12 - IsConnectionValid True 14:34:28 - IsConnectionValid True 14:34:28 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('10/31/2024', isnull(VacAbbrID,0) , 51, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 14:34:28 - IsConnectionValid True 14:34:28 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) Query 14:40:44 - IsConnectionValid True 14:40:44 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 and IsOverTime = @val1 Query 14:41:31 - IsConnectionValid True 14:41:31 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('10/31/2024', isnull(VacAbbrID,0) , 51, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 14:41:31 - IsConnectionValid True 14:41:31 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) Query 14:41:55 - IsConnectionValid True 14:42:00 - IsConnectionValid True 14:42:00 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('10/31/2024', isnull(VacAbbrID,0) , 76, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 14:42:00 - IsConnectionValid True 14:42:00 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) Query 14:42:00 - IsConnectionValid True 14:42:00 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) Query 14:42:09 - IsConnectionValid True 14:42:09 - IsConnectionValid True 14:42:19 - IsConnectionValid True 14:42:25 - IsConnectionValid True 15:31:57 - IsConnectionValid True 15:32:19 - IsConnectionValid True 15:32:20 - (1-att-000007) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 15:36:50 - IsConnectionValid True 15:37:55 - IsConnectionValid True 15:38:03 - IsConnectionValid True 15:38:03 - SELECT DISTINCT * FROM VwEmpTransactionsWithSecurity WHERE TenantID = @val0 AND UserID = @val1 AND EmployeeCode >= @val2 AND EmployeeCode <= @val3 AND TransactionUserID = @val4 AND IsNotManualEntry = @val5 AND IsReserve = @val6 AND Loans = @val7 AND IsInsurance = @val8 AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND month(TransactionDate) = @val13 AND year(TransactionDate) = @val14 ORDER BY Code Query 15:38:08 - IsConnectionValid True 15:38:08 - SELECT DISTINCT * FROM CloseMonth WHERE TenantID = 1 AND TenantID = @val0 and month(CloseDate) = @val1 and year(CloseDate) = @val2 Query 15:38:11 - IsConnectionValid True 15:38:11 - IsConnectionValid True 15:38:11 - SELECT DISTINCT * FROM VwEmpTransactionsWithSecurity WHERE TenantID = @val0 AND UserID = @val1 AND EmployeeCode >= @val2 AND EmployeeCode <= @val3 AND TransactionUserID = @val4 AND IsNotManualEntry = @val5 AND IsReserve = @val6 AND Loans = @val7 AND IsInsurance = @val8 AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) ORDER BY Code Query 15:38:17 - IsConnectionValid True 15:38:22 - IsConnectionValid True 15:38:35 - IsConnectionValid True 15:58:17 - IsConnectionValid True 15:58:34 - IsConnectionValid True 15:58:34 - IsConnectionValid True 15:58:34 - SELECT DISTINCT * FROM VwTransactionToUpdate WHERE TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND (Amount =0 OR 0=0) ORDER BY Code Query 15:58:34 - IsConnectionValid True 15:58:57 - IsConnectionValid True 15:58:57 - IsConnectionValid True 15:58:57 - SELECT DISTINCT * FROM VwTransactionToUpdate WHERE TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND (Amount =0 OR 0=0) ORDER BY Code Query 15:58:57 - IsConnectionValid True 16:00:39 - IsConnectionValid True 16:00:54 - IsConnectionValid True 16:00:54 - IsConnectionValid True 16:00:54 - SELECT DISTINCT * FROM VwTransactionToUpdate WHERE TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND (Amount =0 OR 0=0) ORDER BY Code Query 16:00:54 - IsConnectionValid True 16:01:02 - IsConnectionValid True 16:01:03 - IsConnectionValid True 16:01:04 - IsConnectionValid True 16:01:06 - IsConnectionValid True 16:01:08 - IsConnectionValid True 16:01:09 - IsConnectionValid True 16:01:11 - IsConnectionValid True 16:01:11 - IsConnectionValid True 16:01:11 - IsConnectionValid True 16:01:11 - SELECT DISTINCT * FROM VwTransactionToUpdate WHERE TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND (Amount =0 OR 0=0) ORDER BY Code Query 16:01:11 - IsConnectionValid True 16:01:40 - IsConnectionValid True 16:01:40 - IsConnectionValid True 16:01:40 - SELECT DISTINCT * FROM VwTransactionToUpdate WHERE TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND (Amount =0 OR 0=0) ORDER BY Code Query 16:01:40 - IsConnectionValid True 16:01:52 - IsConnectionValid True 16:01:52 - IsConnectionValid True 16:01:52 - SELECT DISTINCT * FROM VwTransactionToUpdate WHERE TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND (Amount =0 OR 0=0) ORDER BY Code Query 16:01:52 - IsConnectionValid True 16:03:13 - IsConnectionValid True 16:03:15 - IsConnectionValid True 16:03:16 - IsConnectionValid True 16:03:16 - IsConnectionValid True 16:03:16 - IsConnectionValid True 16:03:16 - SELECT DISTINCT * FROM VwTransactionToUpdate WHERE TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND (Amount =0 OR 0=0) ORDER BY Code Query 16:03:16 - IsConnectionValid True 16:03:42 - IsConnectionValid True 16:03:47 - IsConnectionValid True 16:05:16 - IsConnectionValid True 16:05:37 - IsConnectionValid True 16:10:50 - IsConnectionValid True 16:11:04 - IsConnectionValid True 16:11:35 - IsConnectionValid True 16:11:41 - IsConnectionValid True 16:13:06 - IsConnectionValid True 16:13:11 - IsConnectionValid True 16:13:42 - IsConnectionValid True 16:13:44 - IsConnectionValid True 16:13:49 - IsConnectionValid True 16:15:31 - IsConnectionValid True 16:17:26 - IsConnectionValid True 16:26:14 - IsConnectionValid True 16:26:18 - IsConnectionValid True 16:26:25 - IsConnectionValid True 16:26:42 - IsConnectionValid True 16:26:42 - SELECT * FROM AttendanceEmpTimeDetails WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 and CAST(Date AS Date) = @val2 Query 16:27:08 - IsConnectionValid True 16:27:08 - SELECT * FROM AttendanceEmpTimeDetails WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 and CAST(Date AS Date) = @val2 Query 16:27:27 - IsConnectionValid True 16:27:27 - SELECT * FROM AttendanceEmpTimeDetails WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 and CAST(Date AS Date) = @val2 Query 16:27:32 - IsConnectionValid True 16:27:32 - SELECT * FROM AttendanceEmpTimeDetails WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 and CAST(Date AS Date) = @val2 Query 16:28:36 - IsConnectionValid True 16:28:42 - IsConnectionValid True 16:28:51 - IsConnectionValid True 16:28:51 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('10/31/2024', isnull(VacAbbrID,0) , 35, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 16:28:51 - IsConnectionValid True 16:28:51 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) Query 16:30:42 - IsConnectionValid True 16:30:47 - IsConnectionValid True 16:30:55 - IsConnectionValid True 16:30:55 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('10/31/2024', isnull(VacAbbrID,0) , 35, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 16:30:55 - IsConnectionValid True 16:30:55 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) Query 16:31:06 - IsConnectionValid True 16:31:06 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('10/31/2024', isnull(VacAbbrID,0) , 35, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 16:31:06 - IsConnectionValid True 16:31:06 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) Query 16:31:11 - IsConnectionValid True 16:31:11 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('10/31/2024', isnull(VacAbbrID,0) , 35, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 16:31:11 - IsConnectionValid True 16:31:11 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) Query 16:31:38 - IsConnectionValid True 16:31:38 - SELECT ID AS ID, FromHour AS FromHour, ToHour AS ToHour FROM VacationEntry WHERE TenantID = 1 AND EmployeeID = @val0 and CAST(FromDate AS Date) = @val1 and IsHours = @val2 and Minus > @val3 and IsFromAttendance = @val4 and TenantID = @val5 ORDER BY ID asc Query 16:32:12 - IsConnectionValid True 16:32:27 - IsConnectionValid True 16:32:27 - SELECT ID AS ID, FromHour AS FromHour, ToHour AS ToHour FROM VacationEntry WHERE TenantID = 1 AND EmployeeID = @val0 and CAST(FromDate AS Date) = @val1 and IsHours = @val2 and Minus > @val3 and IsFromAttendance = @val4 and TenantID = @val5 ORDER BY ID asc Query 17:01:10 - IsConnectionValid True 17:01:17 - IsConnectionValid True 17:01:24 - IsConnectionValid True 17:01:24 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('10/31/2024', isnull(VacAbbrID,0) , 124, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 17:01:31 - IsConnectionValid True 17:01:31 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('10/31/2024', isnull(VacAbbrID,0) , 125, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 17:01:41 - IsConnectionValid True 17:01:41 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('10/31/2024', isnull(VacAbbrID,0) , 118, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 17:01:51 - IsConnectionValid True 17:01:51 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 and IsOverTime = @val1 Query 17:01:54 - IsConnectionValid True 17:01:54 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) Query 17:04:45 - IsConnectionValid True 17:04:54 - IsConnectionValid True 17:05:00 - IsConnectionValid True 17:05:00 - SELECT * FROM AttendanceEmpTimeDetails WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 and CAST(Date AS Date) = @val2 Query 17:05:07 - IsConnectionValid True 17:05:09 - IsConnectionValid True 17:08:15 - IsConnectionValid True 17:08:21 - IsConnectionValid True 17:08:50 - IsConnectionValid True 17:08:53 - IsConnectionValid True 17:08:56 - IsConnectionValid True 17:08:56 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('11/13/2024', isnull(VacAbbrID,0) , 118, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 17:08:59 - IsConnectionValid True 17:08:59 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) Query 17:09:32 - IsConnectionValid True 17:09:35 - IsConnectionValid True 17:09:39 - IsConnectionValid True 17:09:39 - SELECT DISTINCT isnull(VacAbbrID,0) AS VacAbbrID, [dbo].[web_get_vacation_Credit_WithouDate]('11/13/2024', isnull(VacAbbrID,0) , 116, 1) AS VacBalance FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) and isnull(VacAbbrID,0) > @val2 Query 17:09:41 - IsConnectionValid True 17:09:41 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type, isnull(TransTypeID,0) AS TransTypeID, isnull(VacAbbrID,0) AS VacAbbrID FROM vwVacTransType WHERE TenantID = @val0 and IsOverTime in (2,1) Query