15:42:40 - IsConnectionValid False
15:42:50 - (1-gen-005008) : Cannot open database "JIS_HRMSystem26-05-2025" requested by the login. The login failed.
Login failed for user 'sa'.
15:43:13 - IsConnectionValid False
15:43:23 - (2-gen-005001) : Cannot open database "JIS_HRMSystem26-05-2025" requested by the login. The login failed.
Login failed for user 'sa'.
15:45:41 - IsConnectionValid True
15:45:49 - IsConnectionValid True
15:45:53 - IsConnectionValid True
15:45:54 - IsConnectionValid True
15:45:57 - IsConnectionValid True
15:46:08 - IsConnectionValid True
15:46:08 - 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:46:31 - IsConnectionValid True
15:46:34 - IsConnectionValid True
15:46:34 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, 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, TotalSal AS BasicSalary 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:46:34 - IsConnectionValid True
15:46:34 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, 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, TotalSal AS BasicSalary 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:46:37 - IsConnectionValid True
15:46:37 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:46:42 - IsConnectionValid True
15:46:49 - IsConnectionValid True
15:46:59 - IsConnectionValid True
15:47:05 - IsConnectionValid True
15:47:21 - IsConnectionValid True
15:47:21 - IsConnectionValid True
15:47:21 - 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:47:21 - IsConnectionValid True
15:47:42 - IsConnectionValid True
15:47:42 - IsConnectionValid True
15:47:42 - IsConnectionValid True
15:47:42 - 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:47:45 - IsConnectionValid True
15:47:45 - IsConnectionValid True
15:47:45 - 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:48:01 - IsConnectionValid True
15:48:01 - IsConnectionValid True
15:48:01 - 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:48:01 - IsConnectionValid True