01:52:09 - IsConnectionValid True
01:52:25 - IsConnectionValid True
01:52:25 - IsConnectionValid True
01:52:37 - IsConnectionValid True
01:52:37 - IsConnectionValid True
01:52:46 - IsConnectionValid True
01:52:59 - IsConnectionValid True
01:52:59 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END  AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 and TenantID = @val1 and IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
01:53:05 - IsConnectionValid True
01:53:05 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END  AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 and TenantID = @val1 and IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
01:53:15 - IsConnectionValid True
01:53:15 - SELECT * FROM HRMS_vwTransactionEntryPerMonth WHERE  TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 and Year = @val8 and Month = @val9 and TransactionID = @val10 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
01:53:47 - IsConnectionValid True
01:53:47 - SELECT * FROM HRMS_vwEmployees WHERE  TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
01:54:01 - IsConnectionValid True
01:54:02 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END  AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 and TenantID = @val1 and IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
01:54:06 - IsConnectionValid True
01:54:06 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END  AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 and TenantID = @val1 and IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
01:54:20 - IsConnectionValid True
01:54:20 - SELECT * FROM HRMS_vwTransactionEntryPerMonth WHERE  TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 and Year = @val8 and Month = @val9 and TransactionID = @val10 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query