11:12:35 - IsConnectionValid True 11:12:35 - IsConnectionValid True 11:12:35 - IsConnectionValid True 11:12:44 - IsConnectionValid True 11:12:51 - IsConnectionValid True 11:12:51 - IsConnectionValid True 11:12:53 - IsConnectionValid True 11:13:07 - IsConnectionValid True 11:13:07 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:13:08 - IsConnectionValid True 11:13:08 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=0 AND TypeID=0 ) AND TenantID = @val1 ORDER BY ID asc Query 11:13:10 - IsConnectionValid True 11:13:16 - IsConnectionValid True 11:13:16 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceDefinitions WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:13:18 - IsConnectionValid True 11:13:18 - SELECT * FROM InsuranceDefinitionsDetails WHERE TenantID = 1 AND InsuranceDefinitionID = @val0 AND TenantID = @val1 ORDER BY ID asc Query 11:13:23 - IsConnectionValid True 11:13:23 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 11:13:23 - IsConnectionValid True 11:13:23 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 11:13:25 - IsConnectionValid True 11:13:25 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceDefinitions WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:13:28 - IsConnectionValid True 11:13:32 - IsConnectionValid True 11:13:32 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:13:34 - IsConnectionValid True 11:13:35 - IsConnectionValid True 11:13:35 - SELECT ID AS ID, Code AS Code, Name AS Name FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and Sign = @val1 and IsInsurance = @val2 ORDER BY ID DESC Query 11:13:35 - IsConnectionValid True 11:13:35 - SELECT ID AS ID, Code AS Code, Name AS Name FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and Sign = @val1 and IsInsurance = @val2 ORDER BY ID DESC Query 11:26:16 - IsConnectionValid True 11:26:16 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:26:18 - IsConnectionValid True 11:26:20 - IsConnectionValid True 11:54:04 - IsConnectionValid True 12:23:03 - IsConnectionValid True 12:23:10 - IsConnectionValid True 12:23:18 - IsConnectionValid True 14:35:43 - IsConnectionValid True 14:36:36 - IsConnectionValid True 14:36:38 - IsConnectionValid True 14:37:25 - IsConnectionValid True 14:37:25 - IsConnectionValid True 14:37:28 - IsConnectionValid True 14:37:29 - IsConnectionValid True 14:37:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM Projects WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:37:32 - IsConnectionValid True 14:37:34 - IsConnectionValid True 14:37:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:37:36 - IsConnectionValid True 14:37:38 - IsConnectionValid True 14:37:38 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:37:39 - IsConnectionValid True 14:37:40 - IsConnectionValid True 14:37:40 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM InsuranceCompanies WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:37:42 - IsConnectionValid True 14:37:43 - IsConnectionValid True 14:37:43 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceDefinitions WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:37:45 - IsConnectionValid True 14:44:11 - IsConnectionValid True 14:44:17 - IsConnectionValid True 14:44:17 - IsConnectionValid True 14:44:19 - IsConnectionValid True 14:44:22 - IsConnectionValid True 14:44:22 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM Projects WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:44:42 - IsConnectionValid True 14:44:42 - IsConnectionValid True 14:44:43 - IsConnectionValid True 14:44:48 - IsConnectionValid True 14:44:49 - IsConnectionValid True 14:44:51 - IsConnectionValid True 14:44:52 - IsConnectionValid True 14:44:52 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM Projects WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:44:55 - IsConnectionValid True 14:44:57 - IsConnectionValid True 14:44:57 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:45:00 - IsConnectionValid True 14:45:00 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:45:05 - IsConnectionValid True 14:45:19 - IsConnectionValid True 14:45:19 - SELECT ID AS ID, Code AS Code, Name AS Name FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and Sign = @val1 and IsInsurance = @val2 ORDER BY ID DESC Query 14:45:19 - IsConnectionValid True 14:45:19 - SELECT ID AS ID, Code AS Code, Name AS Name FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and Sign = @val1 and IsInsurance = @val2 ORDER BY ID DESC Query 14:45:22 - IsConnectionValid True 14:45:22 - SELECT ID AS ID, Code AS Code, Name AS Name FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and Sign = @val1 and IsInsurance = @val2 ORDER BY ID DESC Query 14:45:22 - IsConnectionValid True 14:45:22 - SELECT ID AS ID, Code AS Code, Name AS Name FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and Sign = @val1 and IsInsurance = @val2 ORDER BY ID DESC Query 14:45:25 - IsConnectionValid True 14:45:25 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:45:27 - IsConnectionValid True 14:45:27 - SELECT ID AS ID, Code AS Code, Name AS Name FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and Sign = @val1 and IsInsurance = @val2 ORDER BY ID DESC Query 14:45:27 - IsConnectionValid True 14:45:27 - SELECT ID AS ID, Code AS Code, Name AS Name FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and Sign = @val1 and IsInsurance = @val2 ORDER BY ID DESC Query 14:45:29 - IsConnectionValid True 14:45:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:59:08 - IsConnectionValid True 14:59:08 - SELECT ID AS ID, Code AS Code, Name AS Name FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and Sign = @val1 and IsInsurance = @val2 ORDER BY ID DESC Query 14:59:08 - IsConnectionValid True 14:59:08 - SELECT ID AS ID, Code AS Code, Name AS Name FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and Sign = @val1 and IsInsurance = @val2 ORDER BY ID DESC Query 14:59:15 - IsConnectionValid True 14:59:15 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:59:16 - IsConnectionValid True 14:59:30 - IsConnectionValid True 14:59:30 - SELECT ID AS ID, Code AS Code, Name AS Name FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and Sign = @val1 and IsInsurance = @val2 ORDER BY ID DESC Query 14:59:30 - IsConnectionValid True 14:59:30 - SELECT ID AS ID, Code AS Code, Name AS Name FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and Sign = @val1 and IsInsurance = @val2 ORDER BY ID DESC Query 14:59:33 - IsConnectionValid True 14:59:33 - IsConnectionValid True 14:59:33 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:59:36 - IsConnectionValid True 14:59:40 - IsConnectionValid True 14:59:40 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM InsuranceCompanies WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:59:45 - IsConnectionValid True 14:59:47 - IsConnectionValid True 14:59:47 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceDefinitions WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:59:49 - IsConnectionValid True 14:59:49 - IsConnectionValid True 14:59:49 - SELECT * FROM InsuranceDefinitionsDetails WHERE TenantID = 1 AND InsuranceDefinitionID = @val0 AND TenantID = @val1 ORDER BY ID asc Query 15:00:02 - IsConnectionValid True 15:00:02 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName FROM InsuranceCompanies WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:00:02 - IsConnectionValid True 15:00:02 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName FROM InsuranceCompanies WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:00:04 - IsConnectionValid True 15:00:04 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:00:04 - IsConnectionValid True 15:00:04 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:00:47 - IsConnectionValid True 15:00:47 - IsConnectionValid True 15:00:47 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceDefinitions WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:00:52 - IsConnectionValid True 15:00:54 - IsConnectionValid True 15:00:54 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:00:58 - IsConnectionValid True 15:00:58 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=509 AND TypeID=1 ) AND TenantID = @val1 ORDER BY ID asc Query 15:00:58 - IsConnectionValid True 15:00:58 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 15:00:58 - IsConnectionValid True 15:00:58 - IsConnectionValid True 15:00:58 - IsConnectionValid True 15:00:58 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:00:58 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:00:58 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:00:58 - IsConnectionValid True 15:00:58 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:00:58 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:00:58 - IsConnectionValid True 15:00:58 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 7 AND d.MaxAge > 7)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'03/10/2018',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'03/10/2018',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:00:58 - IsConnectionValid True 15:00:58 - IsConnectionValid True 15:00:58 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:00:58 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 1 AND d.MaxAge > 1)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/04/2024',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/04/2024',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:23 - IsConnectionValid True 15:01:23 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=509 AND TypeID=1 ) AND TenantID = @val1 ORDER BY ID asc Query 15:01:23 - IsConnectionValid True 15:01:23 - IsConnectionValid True 15:01:23 - IsConnectionValid True 15:01:23 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 15:01:23 - IsConnectionValid True 15:01:23 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:23 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:01:23 - IsConnectionValid True 15:01:23 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:23 - IsConnectionValid True 15:01:23 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:24 - IsConnectionValid True 15:01:24 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:24 - IsConnectionValid True 15:01:24 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 7 AND d.MaxAge > 7)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'03/10/2018',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'03/10/2018',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:24 - IsConnectionValid True 15:01:24 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 1 AND d.MaxAge > 1)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/04/2024',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/04/2024',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:25 - IsConnectionValid True 15:01:27 - IsConnectionValid True 15:01:27 - 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:01:31 - IsConnectionValid True 15:01:31 - 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' and Name LIKE '%اسامه سامي عبد الله المعشر%' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 15:01:33 - IsConnectionValid True 15:01:33 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 15:01:33 - IsConnectionValid True 15:01:33 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 15:01:33 - 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:01:33 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - IsConnectionValid True 15:01:33 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 15:01:33 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 15:01:33 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - IsConnectionValid True 15:01:33 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - 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:01:33 - IsConnectionValid True 15:01:33 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - IsConnectionValid True 15:01:33 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=3) OR ExtensionsID=0) ORDER BY ID Query 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 15:01:33 - IsConnectionValid True 15:01:33 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:01:33 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 15:01:33 - IsConnectionValid True 15:01:33 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=6) OR ExtensionsID=0) ORDER BY ID Query 15:01:33 - IsConnectionValid True 15:01:33 - 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 = 509 WHERE LocationDef.TenantID =1 Query 15:01:33 - 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 = 509 WHERE CustodyItemsDef.TenantID =1 Query 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - 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 =509 AND Emp.MasterID =0 Query 15:01:33 - SELECT * FROM HRMS_vwEmp_Contracts WHERE TenantID =1 and EmployeeID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=16) OR ExtensionsID=0) ORDER BY ContractDate Desc Query 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:01:33 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:01:33 - IsConnectionValid True 15:01:33 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - IsConnectionValid True 15:01:33 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:01:33 - IsConnectionValid True 15:01:33 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 15:01:34 - IsConnectionValid True 15:01:34 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 15:01:37 - IsConnectionValid True 15:01:38 - IsConnectionValid True 15:01:38 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:01:40 - IsConnectionValid True 15:01:40 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=0 AND TypeID=0 ) AND TenantID = @val1 ORDER BY ID asc Query 15:01:42 - IsConnectionValid True 15:01:42 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EName, MARSTAT AS MARSTAT FROM Employees WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:01:42 - IsConnectionValid True 15:01:42 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EName, MARSTAT AS MARSTAT FROM Employees WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:01:47 - IsConnectionValid True 15:01:47 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=509 AND TypeID=0 ) AND TenantID = @val1 ORDER BY ID asc Query 15:01:49 - IsConnectionValid True 15:01:49 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:01:49 - IsConnectionValid True 15:01:49 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:01:50 - IsConnectionValid True 15:01:50 - SELECT * FROM InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 and TypeID = @val2 ORDER BY ID Query 15:01:50 - IsConnectionValid True 15:01:50 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=509 AND TypeID=1 ) AND TenantID = @val1 ORDER BY ID asc Query 15:01:50 - IsConnectionValid True 15:01:50 - IsConnectionValid True 15:01:50 - IsConnectionValid True 15:01:50 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 15:01:50 - IsConnectionValid True 15:01:50 - IsConnectionValid True 15:01:50 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:01:50 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:50 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:50 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:01:50 - IsConnectionValid True 15:01:50 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:50 - IsConnectionValid True 15:01:50 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 7 AND d.MaxAge > 7)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'03/10/2018',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'03/10/2018',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:50 - IsConnectionValid True 15:01:50 - IsConnectionValid True 15:01:50 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:50 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 1 AND d.MaxAge > 1)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/04/2024',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/04/2024',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:51 - IsConnectionValid True 15:01:51 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:01:51 - IsConnectionValid True 15:01:51 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:01:52 - IsConnectionValid True 15:01:52 - SELECT * FROM InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 and TypeID = @val2 ORDER BY ID Query 15:01:52 - IsConnectionValid True 15:01:52 - IsConnectionValid True 15:01:52 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 15:01:52 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:52 - IsConnectionValid True 15:01:52 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 7 AND d.MaxAge > 7)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'03/10/2018',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'03/10/2018',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:52 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:01:52 - IsConnectionValid True 15:01:52 - IsConnectionValid True 15:01:52 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:01:52 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 1 AND d.MaxAge > 1)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/04/2024',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/04/2024',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:52 - IsConnectionValid True 15:01:52 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:52 - IsConnectionValid True 15:01:52 - IsConnectionValid True 15:01:52 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 7 AND d.MaxAge > 7)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'03/10/2018',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'03/10/2018',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:52 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 1 AND d.MaxAge > 1)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/04/2024',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/04/2024',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:55 - IsConnectionValid True 15:01:55 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:01:55 - IsConnectionValid True 15:01:55 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:01:56 - IsConnectionValid True 15:01:56 - SELECT * FROM InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 and TypeID = @val2 ORDER BY ID Query 15:01:56 - IsConnectionValid True 15:01:56 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=509 AND TypeID=1 ) AND TenantID = @val1 ORDER BY ID asc Query 15:01:56 - IsConnectionValid True 15:01:56 - IsConnectionValid True 15:01:56 - IsConnectionValid True 15:01:56 - IsConnectionValid True 15:01:56 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 15:01:56 - IsConnectionValid True 15:01:56 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:01:56 - IsConnectionValid True 15:01:56 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:56 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:01:56 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:56 - IsConnectionValid True 15:01:56 - IsConnectionValid True 15:01:56 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 7 AND d.MaxAge > 7)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'03/10/2018',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'03/10/2018',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:56 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 1 AND d.MaxAge > 1)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/04/2024',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/04/2024',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:56 - IsConnectionValid True 15:01:56 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:58 - IsConnectionValid True 15:01:58 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:01:58 - IsConnectionValid True 15:01:58 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:01:59 - IsConnectionValid True 15:01:59 - SELECT * FROM InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 and TypeID = @val2 ORDER BY ID Query 15:01:59 - IsConnectionValid True 15:01:59 - IsConnectionValid True 15:01:59 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 15:01:59 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:59 - IsConnectionValid True 15:01:59 - IsConnectionValid True 15:01:59 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:01:59 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 7 AND d.MaxAge > 7)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'03/10/2018',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'03/10/2018',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:59 - IsConnectionValid True 15:01:59 - IsConnectionValid True 15:01:59 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:01:59 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 1 AND d.MaxAge > 1)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/04/2024',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/04/2024',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:59 - IsConnectionValid True 15:01:59 - IsConnectionValid True 15:01:59 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:59 - IsConnectionValid True 15:01:59 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 7 AND d.MaxAge > 7)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'03/10/2018',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'03/10/2018',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:01:59 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 1 AND d.MaxAge > 1)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/04/2024',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/04/2024',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:04 - IsConnectionValid True 15:02:04 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:02:06 - IsConnectionValid True 15:02:06 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=0 AND TypeID=0 ) AND TenantID = @val1 ORDER BY ID asc Query 15:02:07 - IsConnectionValid True 15:02:07 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EName, MARSTAT AS MARSTAT FROM Employees WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:02:07 - IsConnectionValid True 15:02:07 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EName, MARSTAT AS MARSTAT FROM Employees WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:02:09 - IsConnectionValid True 15:02:09 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=509 AND TypeID=0 ) AND TenantID = @val1 ORDER BY ID asc Query 15:02:10 - IsConnectionValid True 15:02:10 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:02:10 - IsConnectionValid True 15:02:10 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 15:02:12 - IsConnectionValid True 15:02:12 - SELECT * FROM InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 and TypeID = @val2 ORDER BY ID Query 15:02:13 - IsConnectionValid True 15:02:13 - IsConnectionValid True 15:02:13 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:13 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:13 - IsConnectionValid True 15:02:13 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:14 - IsConnectionValid True 15:02:14 - IsConnectionValid True 15:02:14 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:14 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 15:02:14 - IsConnectionValid True 15:02:14 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:15 - IsConnectionValid True 15:02:15 - IsConnectionValid True 15:02:15 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 15:02:15 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:15 - IsConnectionValid True 15:02:15 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:16 - IsConnectionValid True 15:02:16 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:16 - IsConnectionValid True 15:02:16 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:19 - IsConnectionValid True 15:02:19 - IsConnectionValid True 15:02:19 - IsConnectionValid True 15:02:19 - IsConnectionValid True 15:02:19 - IsConnectionValid True 15:02:19 - IsConnectionValid True 15:02:19 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 15:02:19 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:19 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:19 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:19 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:19 - IsConnectionValid True 15:02:19 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:19 - IsConnectionValid True 15:02:19 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:21 - IsConnectionValid True 15:02:21 - IsConnectionValid True 15:02:21 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:21 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 15:02:21 - IsConnectionValid True 15:02:21 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:21 - IsConnectionValid True 15:02:21 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 15:02:21 - IsConnectionValid True 15:02:21 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:21 - IsConnectionValid True 15:02:21 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:22 - IsConnectionValid True 15:02:22 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 125 AND d.MaxAge > 125)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:23 - IsConnectionValid True 15:02:23 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 125 AND d.MaxAge > 125)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:26 - IsConnectionValid True 15:02:26 - IsConnectionValid True 15:02:26 - IsConnectionValid True 15:02:26 - IsConnectionValid True 15:02:26 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 15:02:26 - IsConnectionValid True 15:02:26 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:26 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 15:02:26 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 125 AND d.MaxAge > 125)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:26 - IsConnectionValid True 15:02:26 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:26 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 15:02:26 - IsConnectionValid True 15:02:26 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:26 - IsConnectionValid True 15:02:26 - IsConnectionValid True 15:02:26 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 15:02:26 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 125 AND d.MaxAge > 125)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:26 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:26 - IsConnectionValid True 15:02:26 - IsConnectionValid True 15:02:26 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:26 - IsConnectionValid True 15:02:26 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 125 AND d.MaxAge > 125)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:26 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:28 - IsConnectionValid True 15:02:28 - IsConnectionValid True 15:02:28 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:28 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:02:28 - IsConnectionValid True 15:02:28 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:29 - IsConnectionValid True 15:02:29 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:02:29 - IsConnectionValid True 15:02:29 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:29 - IsConnectionValid True 15:02:29 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:29 - IsConnectionValid True 15:02:29 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 1 AND d.MaxAge > 1)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/04/2024',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/04/2024',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:30 - IsConnectionValid True 15:02:30 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 1 AND d.MaxAge > 1)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/04/2024',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/04/2024',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:33 - IsConnectionValid True 15:02:33 - IsConnectionValid True 15:02:33 - IsConnectionValid True 15:02:33 - IsConnectionValid True 15:02:33 - IsConnectionValid True 15:02:33 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 15:02:33 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 15:02:33 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:33 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 1 AND d.MaxAge > 1)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/04/2024',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/04/2024',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:33 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:02:33 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 125 AND d.MaxAge > 125)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:33 - IsConnectionValid True 15:02:33 - IsConnectionValid True 15:02:33 - IsConnectionValid True 15:02:33 - IsConnectionValid True 15:02:33 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 15:02:33 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:33 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 125 AND d.MaxAge > 125)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:33 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:02:33 - IsConnectionValid True 15:02:33 - IsConnectionValid True 15:02:33 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 15:02:33 - IsConnectionValid True 15:02:33 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 1 AND d.MaxAge > 1)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/04/2024',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/04/2024',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:33 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:33 - IsConnectionValid True 15:02:33 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:33 - IsConnectionValid True 15:02:33 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:33 - IsConnectionValid True 15:02:33 - IsConnectionValid True 15:02:33 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 35 AND d.MaxAge > 35)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/27/1990',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/27/1990',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:33 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 1 AND d.MaxAge > 1)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/04/2024',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/04/2024',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:33 - IsConnectionValid True 15:02:33 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 125 AND d.MaxAge > 125)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:35 - IsConnectionValid True 15:02:35 - IsConnectionValid True 15:02:35 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:02:35 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:35 - IsConnectionValid True 15:02:35 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:36 - IsConnectionValid True 15:02:36 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 15:02:36 - IsConnectionValid True 15:02:36 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:36 - IsConnectionValid True 15:02:36 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 0 AND d.MaxAge > 0)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'01/01/1900',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'01/01/1900',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:37 - IsConnectionValid True 15:02:37 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 7 AND d.MaxAge > 7)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'03/10/2018',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'03/10/2018',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:38 - IsConnectionValid True 15:02:38 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge, C.Name AS CompanyAName, C.EName AS CompanyEName, C.InsuranceCalcMethod AS InsuranceCalcMethod, C.FromDate AS FromDate, C.ToDate AS ToDate FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID inner join InsuranceCompanies C ON m.InsuranceCompanyID=C.ID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR ( ISNULL(C.InsuranceCalcMethod,0)=0 AND d.MinAge <= 7 AND d.MaxAge > 7)OR ( ISNULL(C.InsuranceCalcMethod,0)=1 AND d.MinAge <= DATEDIFF(yyyy,'03/10/2018',C.FromDate) AND d.MaxAge > DATEDIFF(yyyy,'03/10/2018',C.FromDate))) and m.TypeID = @val3 ORDER BY m.ID Query 15:02:52 - IsConnectionValid True 15:02:52 - IsConnectionValid True 15:02:52 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:03:04 - IsConnectionValid True 15:04:20 - IsConnectionValid True 15:04:20 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:04:32 - IsConnectionValid True 15:04:35 - IsConnectionValid True 15:04:41 - IsConnectionValid True 15:04:41 - (2-payroll-0010017) : Could not find stored procedure 'HRMS_EndWorkCalculation'. 15:04:41 - IsConnectionValid True 15:04:41 - (2-payroll-0010017) : Could not find stored procedure 'HRMS_EndWorkCalculation'. 15:06:51 - IsConnectionValid True 15:07:01 - IsConnectionValid True 15:07:01 - (2-payroll-0010017) : Could not find stored procedure 'HRMS_EndWorkCalculation'. 15:11:13 - IsConnectionValid True 15:11:20 - IsConnectionValid True 15:11:20 - (2-payroll-0010017) : Could not find stored procedure 'HRMS_EndWorkCalculation'. 15:13:36 - IsConnectionValid True 15:13:44 - IsConnectionValid True 15:13:44 - (2-payroll-0010017) : Could not find stored procedure 'HRMS_EndWorkCalculation'. 15:26:37 - IsConnectionValid True 15:26:41 - IsConnectionValid True 15:26:41 - SELECT DISTINCT ID AS ID, Code AS Code, EnglishName AS EName, Name AS Name FROM vwemployees WHERE TenantID = @val0 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 15:26:41 - IsConnectionValid True 15:26:41 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, EnglishName AS EName, Name AS Name FROM vwemployees WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:26:44 - IsConnectionValid True 15:26:44 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, EnglishName AS EName, Name AS Name FROM vwemployees WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:26:46 - IsConnectionValid True 15:26:46 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTransactions WHERE TenantID = 1 AND EmployeeID = @val0 AND TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:26:48 - IsConnectionValid True 15:26:51 - IsConnectionValid True 15:27:07 - IsConnectionValid True 15:27:58 - IsConnectionValid True 15:28:03 - IsConnectionValid True 15:28:03 - IsConnectionValid True 15:28:06 - IsConnectionValid True 15:28:15 - IsConnectionValid True 15:28:15 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:28:41 - IsConnectionValid True 15:28:45 - IsConnectionValid True 15:28:45 - SELECT DISTINCT ID AS ID, Code AS Code, EnglishName AS EName, Name AS Name FROM vwemployees WHERE TenantID = @val0 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 15:28:45 - IsConnectionValid True 15:28:45 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, EnglishName AS EName, Name AS Name FROM vwemployees WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:28:52 - IsConnectionValid True 15:28:52 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, EnglishName AS EName, Name AS Name FROM vwemployees WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:28:54 - IsConnectionValid True 15:28:54 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTransactions WHERE TenantID = 1 AND EmployeeID = @val0 AND TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:28:57 - IsConnectionValid True 15:29:10 - IsConnectionValid True 15:29:14 - IsConnectionValid True 15:29:14 - IsConnectionValid True 15:29:16 - IsConnectionValid True 15:29:16 - SELECT DISTINCT ID AS ID, Code AS Code, EnglishName AS EName, Name AS Name FROM vwemployees WHERE TenantID = @val0 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 15:29:16 - IsConnectionValid True 15:29:16 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, EnglishName AS EName, Name AS Name FROM vwemployees WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:29:18 - IsConnectionValid True 15:29:18 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, EnglishName AS EName, Name AS Name FROM vwemployees WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:29:20 - IsConnectionValid True 15:29:20 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTransactions WHERE TenantID = 1 AND EmployeeID = @val0 AND TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:29:21 - IsConnectionValid True 15:29:26 - IsConnectionValid True 15:29:26 - IsConnectionValid True 15:48:22 - IsConnectionValid True 15:48:26 - IsConnectionValid True 15:48:26 - SELECT DISTINCT * FROM VwEmployeeStopSocSec WHERE TenantID = @val0 and IsSocialsec = @val1 and NOTSTOP = @val2 and Date IN (SELECT MAX([DATE]) From EmployeeStopSocSec WHERE EmployeeID=VwEmployeeStopSocSec.EmployeeID and TenantID=1) ORDER BY ID Query 15:48:26 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'IsSocialsec'. 15:48:32 - IsConnectionValid True 15:48:35 - IsConnectionValid True 15:48:35 - IsConnectionValid True 15:48:35 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and IsSocialsec = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 15:48:35 - SELECT DISTINCT * FROM StopSocSecReason WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:22 - IsConnectionValid True 16:04:31 - IsConnectionValid True 16:04:31 - 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 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 16:04:32 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 16:04:32 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - IsConnectionValid True 16:04:32 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 16:04:32 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 16:04:32 - IsConnectionValid True 16:04:32 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - IsConnectionValid True 16:04:32 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - IsConnectionValid True 16:04:32 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - IsConnectionValid True 16:04:32 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 16:04:32 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - IsConnectionValid True 16:04:32 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=3) OR ExtensionsID=0) ORDER BY ID Query 16:04:32 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 16:04:32 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - IsConnectionValid True 16:04:32 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:04:32 - IsConnectionValid True 16:04:32 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - 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 = 0 WHERE LocationDef.TenantID =1 Query 16:04:32 - IsConnectionValid True 16:04:32 - 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 = 0 WHERE CustodyItemsDef.TenantID =1 Query 16:04:32 - IsConnectionValid True 16:04:32 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=6) OR ExtensionsID=0) ORDER BY ID Query 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - 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 =0 AND Emp.MasterID =0 Query 16:04:32 - SELECT * FROM HRMS_vwEmp_Contracts WHERE TenantID =1 and EmployeeID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=16) OR ExtensionsID=0) ORDER BY ContractDate Desc Query 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 16:04:32 - IsConnectionValid True 16:04:32 - IsConnectionValid True 16:04:32 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 16:04:32 - IsConnectionValid True 16:04:32 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 16:04:32 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 16:04:41 - IsConnectionValid True 16:04:41 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:04:41 - IsConnectionValid True 16:04:41 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:04:42 - IsConnectionValid True 16:04:42 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 1 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:04:43 - IsConnectionValid True 16:04:43 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 10 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:04:43 - IsConnectionValid True 16:04:43 - IsConnectionValid True 16:04:43 - SELECT DISTINCT * FROM Pro_Dep_SecHierarchy WHERE TenantID =1 AND HLevel >= @val1 AND Father = @val2 ORDER BY HLevel Query 16:04:43 - IsConnectionValid True 16:04:43 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 16:04:43 - IsConnectionValid True 16:04:43 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 16:04:43 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 16:08:24 - IsConnectionValid True 16:08:24 - 0 :COuntDATA: System.Collections.ArrayList 16:08:24 - : DocumentAttachDetails 16:08:25 - IsConnectionValid True 16:08:25 - 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 16:34:48 - IsConnectionValid True 16:34:52 - IsConnectionValid True 16:34:53 - IsConnectionValid True 16:34:59 - IsConnectionValid True 16:34:59 - IsConnectionValid True 16:35:02 - IsConnectionValid True 16:35:05 - IsConnectionValid True 16:35:05 - 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 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 16:35:08 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 16:35:08 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 16:35:08 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:35:08 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:35:08 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:35:08 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:35:08 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 16:35:08 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:35:08 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:35:08 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:35:08 - IsConnectionValid True 16:35:08 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - IsConnectionValid True 16:35:08 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:35:08 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=3) OR ExtensionsID=0) ORDER BY ID Query 16:35:08 - IsConnectionValid True 16:35:08 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 16:35:09 - IsConnectionValid True 16:35:09 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 16:35:09 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:35:09 - IsConnectionValid True 16:35:09 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:35:09 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:35:09 - IsConnectionValid True 16:35:09 - IsConnectionValid True 16:35:09 - IsConnectionValid True 16:35:09 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:35:09 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 16:35:09 - IsConnectionValid True 16:35:09 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:35:09 - IsConnectionValid True 16:35:09 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 16:35:09 - IsConnectionValid True 16:35:09 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=6) OR ExtensionsID=0) ORDER BY ID Query 16:35:09 - IsConnectionValid True 16:35:09 - 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 = 0 WHERE LocationDef.TenantID =1 Query 16:35:09 - 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 = 0 WHERE CustodyItemsDef.TenantID =1 Query 16:35:09 - IsConnectionValid True 16:35:09 - IsConnectionValid True 16:35:09 - 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 =0 AND Emp.MasterID =0 Query 16:35:09 - SELECT * FROM HRMS_vwEmp_Contracts WHERE TenantID =1 and EmployeeID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=16) OR ExtensionsID=0) ORDER BY ContractDate Desc Query 16:35:09 - IsConnectionValid True 16:35:09 - IsConnectionValid True 16:35:09 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 16:35:09 - IsConnectionValid True 16:35:09 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 16:35:09 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 16:35:09 - IsConnectionValid True 16:35:09 - IsConnectionValid True 16:35:09 - IsConnectionValid True 16:35:09 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 16:35:16 - IsConnectionValid True 16:35:16 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:35:16 - IsConnectionValid True 16:35:16 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:35:17 - IsConnectionValid True 16:35:17 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 1 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:35:19 - IsConnectionValid True 16:35:19 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 11 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:35:21 - IsConnectionValid True 16:35:21 - IsConnectionValid True 16:35:21 - SELECT DISTINCT * FROM Pro_Dep_SecHierarchy WHERE TenantID =1 AND HLevel >= @val1 AND Father = @val2 ORDER BY HLevel Query 16:35:21 - IsConnectionValid True 16:35:21 - IsConnectionValid True 16:35:21 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 16:35:21 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 16:35:21 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 16:36:38 - IsConnectionValid True 16:36:38 - 0 :COuntDATA: System.Collections.ArrayList 16:36:38 - : DocumentAttachDetails 16:36:40 - (1-def-0010001) : This SqlTransaction has completed; it is no longer usable. 16:42:18 - IsConnectionValid True 16:42:18 - 0 :COuntDATA: System.Collections.ArrayList 16:42:18 - : DocumentAttachDetails 16:42:18 - (1-def-0010001) : This SqlTransaction has completed; it is no longer usable. 16:42:41 - IsConnectionValid True 16:42:41 - 0 :COuntDATA: System.Collections.ArrayList 16:42:41 - : DocumentAttachDetails 16:42:41 - (1-def-0010001) : This SqlTransaction has completed; it is no longer usable. 16:43:39 - IsConnectionValid True 16:43:39 - 0 :COuntDATA: System.Collections.ArrayList 16:43:39 - : DocumentAttachDetails 16:43:39 - 5000 :dddddddddddddddddddddd2 16:43:39 - (1-def-0010001) : This SqlTransaction has completed; it is no longer usable. 16:44:45 - IsConnectionValid True 16:44:45 - 0 :COuntDATA: System.Collections.ArrayList 16:44:45 - : DocumentAttachDetails 16:44:45 - 5000 :dddddddddddddddddddddd2 16:44:45 - 5000 :dddddddddddddddddddddd3 16:44:45 - (1-def-0010001) : This SqlTransaction has completed; it is no longer usable. 16:46:00 - IsConnectionValid True 16:46:05 - IsConnectionValid True 16:46:05 - IsConnectionValid True 16:46:05 - IsConnectionValid True 16:46:05 - IsConnectionValid True 16:46:05 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:06 - IsConnectionValid True 16:46:07 - IsConnectionValid True 16:46:07 - IsConnectionValid True 16:46:09 - IsConnectionValid True 16:46:18 - IsConnectionValid True 16:46:18 - IsConnectionValid True 16:46:21 - IsConnectionValid True 16:46:26 - IsConnectionValid True 16:46: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 16:46:29 - IsConnectionValid True 16:46:29 - IsConnectionValid True 16:46:29 - IsConnectionValid True 16:46:29 - IsConnectionValid True 16:46:29 - IsConnectionValid True 16:46:29 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 16:46:29 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 16:46:29 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 16:46:29 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 16:46:30 - IsConnectionValid True 16:46:30 - IsConnectionValid True 16:46:30 - IsConnectionValid True 16:46:30 - IsConnectionValid True 16:46:30 - IsConnectionValid True 16:46:30 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 16:46:30 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - IsConnectionValid True 16:46:30 - IsConnectionValid True 16:46:30 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 16:46:30 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - IsConnectionValid True 16:46:30 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - IsConnectionValid True 16:46:30 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - IsConnectionValid True 16:46:30 - IsConnectionValid True 16:46:30 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - IsConnectionValid True 16:46:30 - IsConnectionValid True 16:46:30 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - IsConnectionValid True 16:46:30 - IsConnectionValid True 16:46:30 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - IsConnectionValid True 16:46:30 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 16:46:30 - IsConnectionValid True 16:46:30 - IsConnectionValid True 16:46:30 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - IsConnectionValid True 16:46:30 - IsConnectionValid True 16:46:30 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=3) OR ExtensionsID=0) ORDER BY ID Query 16:46:30 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 16:46:30 - IsConnectionValid True 16:46:30 - IsConnectionValid True 16:46:30 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 16:46:30 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - IsConnectionValid True 16:46:30 - IsConnectionValid True 16:46:30 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - IsConnectionValid True 16:46:30 - IsConnectionValid True 16:46:30 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:46:30 - IsConnectionValid True 16:46:30 - IsConnectionValid True 16:46:30 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 16:46:30 - IsConnectionValid True 16:46:30 - 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 = 0 WHERE LocationDef.TenantID =1 Query 16:46:30 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 16:46:30 - IsConnectionValid True 16:46:30 - IsConnectionValid True 16:46:30 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=6) OR ExtensionsID=0) ORDER BY ID Query 16:46:30 - 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 =0 AND Emp.MasterID =0 Query 16:46:30 - 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 = 0 WHERE CustodyItemsDef.TenantID =1 Query 16:46:30 - IsConnectionValid True 16:46:30 - SELECT * FROM HRMS_vwEmp_Contracts WHERE TenantID =1 and EmployeeID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=16) OR ExtensionsID=0) ORDER BY ContractDate Desc Query 16:46:30 - IsConnectionValid True 16:46:30 - IsConnectionValid True 16:46:30 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 16:46:30 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 16:46:30 - IsConnectionValid True 16:46:30 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 16:46:30 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 16:46:41 - IsConnectionValid True 16:46:41 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:46:41 - IsConnectionValid True 16:46:41 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:46:42 - IsConnectionValid True 16:46:42 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 1 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:46:42 - IsConnectionValid True 16:46:42 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 10 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:46:43 - IsConnectionValid True 16:46:43 - IsConnectionValid True 16:46:43 - SELECT DISTINCT * FROM Pro_Dep_SecHierarchy WHERE TenantID =1 AND HLevel >= @val1 AND Father = @val2 ORDER BY HLevel Query 16:46:43 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 16:46:43 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 16:46:43 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 16:47:45 - IsConnectionValid True 16:47:45 - 0 :COuntDATA: System.Collections.ArrayList 16:47:45 - : DocumentAttachDetails 16:47:45 - 547 :dddddddddddddddddddddd2 16:47:45 - 547 :dddddddddddddddddddddd3 16:47:46 - IsConnectionValid True 16:47:46 - 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 16:58:28 - IsConnectionValid True 16:58:28 - IsConnectionValid True 16:58:28 - IsConnectionValid True 16:58:28 - IsConnectionValid True 16:58:28 - IsConnectionValid True 16:58:28 - IsConnectionValid True 16:58:28 - IsConnectionValid True 16:58:28 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:29 - IsConnectionValid True 16:58:30 - IsConnectionValid True 16:58:36 - IsConnectionValid True 16:58:36 - IsConnectionValid True 16:58:38 - IsConnectionValid True 17:07:29 - IsConnectionValid True 17:07:40 - IsConnectionValid True 17:07:40 - IsConnectionValid True 17:07:42 - IsConnectionValid True 17:07:45 - IsConnectionValid True 17:07:45 - 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 17:07:47 - IsConnectionValid True 17:07:47 - IsConnectionValid True 17:07:47 - IsConnectionValid True 17:07:47 - IsConnectionValid True 17:07:47 - IsConnectionValid True 17:07:47 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 17:07:47 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 17:07:47 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 17:07:47 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 17:07:48 - IsConnectionValid True 17:07:48 - IsConnectionValid True 17:07:48 - IsConnectionValid True 17:07:48 - IsConnectionValid True 17:07:48 - IsConnectionValid True 17:07:48 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - IsConnectionValid True 17:07:48 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 17:07:48 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - IsConnectionValid True 17:07:48 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 17:07:48 - IsConnectionValid True 17:07:48 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - IsConnectionValid True 17:07:48 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - IsConnectionValid True 17:07:48 - IsConnectionValid True 17:07:48 - IsConnectionValid True 17:07:48 - IsConnectionValid True 17:07:48 - IsConnectionValid True 17:07:48 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 17:07:48 - IsConnectionValid True 17:07:48 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - IsConnectionValid True 17:07:48 - IsConnectionValid True 17:07:48 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - IsConnectionValid True 17:07:48 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=3) OR ExtensionsID=0) ORDER BY ID Query 17:07:48 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 17:07:48 - IsConnectionValid True 17:07:48 - IsConnectionValid True 17:07:48 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - IsConnectionValid True 17:07:48 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 17:07:48 - IsConnectionValid True 17:07:48 - IsConnectionValid True 17:07:48 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - IsConnectionValid True 17:07:48 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - IsConnectionValid True 17:07:48 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - IsConnectionValid True 17:07:48 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 17:07:48 - IsConnectionValid True 17:07:48 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:07:48 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 17:07:48 - IsConnectionValid True 17:07:48 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=6) OR ExtensionsID=0) ORDER BY ID Query 17:07:48 - 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 = 0 WHERE LocationDef.TenantID =1 Query 17:07:48 - IsConnectionValid True 17:07:48 - 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 = 0 WHERE CustodyItemsDef.TenantID =1 Query 17:07:48 - IsConnectionValid True 17:07:48 - IsConnectionValid True 17:07:48 - IsConnectionValid True 17:07:48 - 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 =0 AND Emp.MasterID =0 Query 17:07:48 - IsConnectionValid True 17:07:48 - IsConnectionValid True 17:07:48 - IsConnectionValid True 17:07:48 - SELECT * FROM HRMS_vwEmp_Contracts WHERE TenantID =1 and EmployeeID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=16) OR ExtensionsID=0) ORDER BY ContractDate Desc Query 17:07:48 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 17:07:48 - IsConnectionValid True 17:07:48 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 17:07:48 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 17:07:48 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 17:07:58 - IsConnectionValid True 17:07:58 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:07:58 - IsConnectionValid True 17:07:58 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:07:59 - IsConnectionValid True 17:07:59 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 1 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:08:00 - IsConnectionValid True 17:08:00 - IsConnectionValid True 17:08:00 - IsConnectionValid True 17:08:00 - IsConnectionValid True 17:08:00 - SELECT DISTINCT * FROM Pro_Dep_SecHierarchy WHERE TenantID =1 AND HLevel >= @val1 AND Father = @val2 ORDER BY HLevel Query 17:08:00 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 17:08:00 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 17:08:00 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 17:08:02 - IsConnectionValid True 17:08:02 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:08:02 - IsConnectionValid True 17:08:02 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:08:03 - IsConnectionValid True 17:08:03 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 1 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:08:04 - IsConnectionValid True 17:08:04 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 11 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:08:06 - IsConnectionValid True 17:08:06 - IsConnectionValid True 17:08:06 - IsConnectionValid True 17:08:06 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 17:08:06 - SELECT DISTINCT * FROM Pro_Dep_SecHierarchy WHERE TenantID =1 AND HLevel >= @val1 AND Father = @val2 ORDER BY HLevel Query 17:08:06 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 17:08:06 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 17:09:18 - IsConnectionValid True 17:09:18 - 0 :COuntDATA: System.Collections.ArrayList 17:09:18 - : DocumentAttachDetails 17:09:19 - 1154 :dddddddddddddddddddddd2 17:09:19 - 1154 :dddddddddddddddddddddd3 17:09:19 - IsConnectionValid True 17:09:19 - 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 17:36:48 - IsConnectionValid True 17:37:12 - IsConnectionValid True 17:37:12 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1 17:37:12 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(BirthDate)=MONTH(GETDATE()) COUNT Query 29 17:37:12 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND (DATEDIFF(day,DateBegin,GETDATE()) +1)<=90 AND (90 - (DATEDIFF(day,DateBegin,GETDATE()) +1))<=(SELECT RemainBeforeFinishTrainingPeriod FROM SysParam) COUNT Query 26 17:37:12 - SELECT COUNT(ID) AS TotalNum FROM VwEmpDocAlerts WHERE DocTypeID=1 AND ( DATEDIFF(DAY,GETDATE(),ToDate)<=30 AND DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 11 17:37:13 - SELECT COUNT(ID) AS TotalNum FROM VwEmpDocAlerts WHERE DocTypeID=2 AND ( DATEDIFF(DAY,GETDATE(),ToDate)<=14 AND DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 0 17:37:13 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND ((MONTH(EndContractDate)=MONTH(GETDATE()) AND YEAR(EndContractDate)=YEAR(GETDATE()) ) OR EndContractDate BETWEEN GETDATE() AND EOMONTH(GETDATE(),1)) COUNT Query 14 17:37:13 - SELECT COUNT(*)FROM (SELECT Gender,CODE,ID,Name,cASE when ISNULL(NewSocSecDate,'01/01/1900')<>'01/01/1900' AND ISNULL(NewSocSecDate,'')<>'' then DATEADD(DAY, (DATEDIFF(DAY, GETDATE(),NewSocSecDate)), BirthDate)ELSE BirthDate END COMPAREDATE FROM Employees where IsSocialSec = 1 AND DateLeft='01/01/1900') D WHERE Abs((DateDiff(MONTH, (COMPAREDATE), GETDATE()) /12)) >= CASE WHEN Gender =1 THEN (SELECT FemaleSocStopY FROM SysParam) ELSE (SELECT MaleSocStopY FROM SysParam) END COUNT Query 3 17:37:13 - select COUNT(*) from EmployeeChild C INNER JOIN EMPLOYEES E ON C.FatherID=E.ID WHERE E.DateLeft='01/01/1900' AND convert(date,C.BirthDate )>= convert(date,DATEADD(YEAR,-18,GETDATE())) AND MONTH(C.BirthDate)=MONTH(GETDATE()) AND YEAR(C.BirthDate)=YEAR(DATEADD(YEAR,-18,GETDATE())) COUNT Query 1 17:37:13 - SELECT COUNT(ID) AS count FROM dbo.Employees WHERE (DateLeft = '01/01/1900') AND (YEAR(DateBegin) = 2005) COUNT Query 4 17:37:13 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(BirthDate)=MONTH(EOMONTH(GETDATE(),1)) COUNT Query 22 17:37:13 - SELECT COUNT(*) FROM Employees e WHERE employmenttype=1 and DateBegin<>'01/01/1900' and (DATEDIFF(MM,DateBegin,GETDATE()))>=3 and not exists(SELECT * from EmployeeTransactionsCondition C inner join DailyTransactionEntry d on c.EmployeeID=d.EmployeeId and c.TransactionID=d.TransactionID WHERE E.ID=C.Employeeid) and (DateLeft='01/01/1900' or ((MONTH(DateLeft)>=MONTH(GETDATE()) AND YEAR(DateLeft)=YEAR(GETDATE())) OR YEAR(DateLeft)>YEAR(GETDATE()))) COUNT Query 1 17:37:13 - SELECT COUNT(*) FROM Employees e WHERE employmenttype=3 and ContractDate<>'01/01/1900' and (DATEDIFF(MM,ContractDate,GETDATE()))>=3 and not exists(SELECT * from EmployeeTransactionsCondition C inner join DailyTransactionEntry d on c.EmployeeID=d.EmployeeId and c.TransactionID=d.TransactionID WHERE E.ID=C.Employeeid) and (DateLeft='01/01/1900' or ((MONTH(DateLeft)>=MONTH(GETDATE()) AND YEAR(DateLeft)=YEAR(GETDATE())) OR YEAR(DateLeft)>YEAR(GETDATE()))) COUNT Query 0 17:37:13 - SELECT COUNT(ID) AS TotalNum FROM VwEmpDocAlerts WHERE DocTypeID=6 AND ( DATEDIFF(DAY,GETDATE(),ToDate)<=30 AND DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 0 17:37:13 - SELECT COUNT(ID) AS TotalNum FROM VwEmpDocAlerts WHERE DocTypeID=5 AND ( DATEDIFF(DAY,GETDATE(),ToDate)<=30 AND DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 0 17:37:13 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND YEAR(EndContractDate)=(SELECT currentYear from SysParam) COUNT Query 115 17:37:13 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' COUNT Query 287 17:37:13 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' COUNT Query 287 17:37:13 - SELECT COUNT(*)FROM (SELECT Gender,CODE,ID,Name,cASE when ISNULL(NewSocSecDate,'01/01/1900')<>'01/01/1900' AND ISNULL(NewSocSecDate,'')<>'' then DATEADD(DAY, (DATEDIFF(DAY, GETDATE(),NewSocSecDate)), BirthDate)ELSE BirthDate END COMPAREDATE FROM Employees where IsSocialSec = 1 AND DateLeft='01/01/1900') D WHERE Abs((DateDiff(YEAR,(COMPAREDATE), GETDATE()) )) >= CASE WHEN Gender =1 THEN (SELECT FemaleSocStopY FROM SysParam) ELSE (SELECT MaleSocStopY FROM SysParam) END COUNT Query 3 17:37:13 - IsConnectionValid True 17:37:15 - IsConnectionValid True 17:37:15 - SELECT DISTINCT * FROM VwEmployeeStopSocSec WHERE TenantID = @val0 and IsSocialsec = @val1 and NOTSTOP = @val2 and Date IN (SELECT MAX([DATE]) From EmployeeStopSocSec WHERE EmployeeID=VwEmployeeStopSocSec.EmployeeID and TenantID=1) ORDER BY ID Query 17:37:15 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'IsSocialsec'. 17:37:20 - IsConnectionValid True 17:37:23 - IsConnectionValid True 17:37:23 - IsConnectionValid True 17:37:23 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and IsSocialsec = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 17:37:23 - SELECT DISTINCT * FROM StopSocSecReason WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:37:24 - IsConnectionValid True 17:38:00 - IsConnectionValid True 17:38:01 - IsConnectionValid True 17:38:05 - IsConnectionValid True 17:38:05 - SELECT DISTINCT * FROM VwEmployeeStopSocSec WHERE TenantID = @val0 and IsSocialsec = @val1 and NOTSTOP = @val2 and Date IN (SELECT MAX([DATE]) From EmployeeStopSocSec WHERE EmployeeID=VwEmployeeStopSocSec.EmployeeID and TenantID=1) ORDER BY ID Query 17:38:05 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'IsSocialsec'. 17:38:09 - IsConnectionValid True 17:38:10 - IsConnectionValid True 17:38:10 - IsConnectionValid True 17:38:10 - SELECT DISTINCT * FROM StopSocSecReason WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:38:10 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and IsSocialsec = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 17:38:33 - IsConnectionValid True 17:38:37 - IsConnectionValid True 17:38:40 - IsConnectionValid True 17:38:40 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and IsSocialsec = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 17:39:03 - IsConnectionValid True 17:39:06 - IsConnectionValid True 17:39:06 - IsConnectionValid True 17:39:06 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and IsSocialsec = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 17:39:06 - SELECT DISTINCT * FROM StopSocSecReason WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:39:37 - IsConnectionValid True 17:39:43 - IsConnectionValid True 17:39:46 - IsConnectionValid True 17:39:46 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and IsSocialsec = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 17:41:09 - IsConnectionValid True 17:41:12 - IsConnectionValid True 17:41:12 - SELECT DISTINCT * FROM VwEmployeeStopSocSec WHERE TenantID = @val0 and IsSocialsec = @val1 and NOTSTOP = @val2 and Date IN (SELECT MAX([DATE]) From EmployeeStopSocSec WHERE EmployeeID=VwEmployeeStopSocSec.EmployeeID and TenantID=1) ORDER BY ID Query 17:41:12 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'IsSocialsec'. 17:41:32 - IsConnectionValid True 17:41:35 - IsConnectionValid True 17:41:35 - SELECT DISTINCT * FROM VwEmployeeStopSocSec WHERE TenantID = @val0 and IsSocialsec = @val1 and NOTSTOP = @val2 and Date IN (SELECT MAX([DATE]) From EmployeeStopSocSec WHERE EmployeeID=VwEmployeeStopSocSec.EmployeeID and TenantID=1) ORDER BY ID Query 17:41:35 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'IsSocialsec'. 17:42:41 - IsConnectionValid True 17:42:44 - IsConnectionValid True 17:42:44 - SELECT DISTINCT * FROM VwEmployeeStopSocSec WHERE TenantID = @val0 and IsSocialsec = @val1 and NOTSTOP = @val2 and Date IN (SELECT MAX([DATE]) From EmployeeStopSocSec WHERE EmployeeID=VwEmployeeStopSocSec.EmployeeID and TenantID=1) ORDER BY ID Query 17:42:44 - (1-gen-1002) : Invalid column name 'IsSocialsec'. 17:43:13 - IsConnectionValid True 17:43:16 - IsConnectionValid True 17:43:16 - SELECT DISTINCT * FROM VwEmployeeStopSocSec WHERE TenantID = @val0 and IsSocialsec = @val1 and NOTSTOP = @val2 and Date IN (SELECT MAX([DATE]) From EmployeeStopSocSec WHERE EmployeeID=VwEmployeeStopSocSec.EmployeeID and TenantID=1) ORDER BY ID Query 17:45:55 - IsConnectionValid True 17:45:59 - IsConnectionValid True 17:45:59 - SELECT DISTINCT * FROM VwEmployeeStopSocSec WHERE TenantID = @val0 and IsSocialsec = @val1 and NOTSTOP = @val2 and Date IN (SELECT MAX([DATE]) From EmployeeStopSocSec WHERE EmployeeID=VwEmployeeStopSocSec.EmployeeID and TenantID=1) ORDER BY ID Query 17:46:47 - IsConnectionValid True 17:46:50 - IsConnectionValid True 17:46:50 - SELECT DISTINCT * FROM VwEmployeeStopSocSec WHERE TenantID = @val0 and IsSocialsec = @val1 and NOTSTOP = @val2 and Date IN (SELECT MAX([DATE]) From EmployeeStopSocSec WHERE EmployeeID=VwEmployeeStopSocSec.EmployeeID and TenantID=1) ORDER BY ID Query 17:47:25 - IsConnectionValid True 17:47:28 - IsConnectionValid True 17:47:28 - SELECT DISTINCT * FROM VwEmployeeStopSocSec WHERE TenantID = @val0 and IsSocialsec = @val1 and NOTSTOP = @val2 and Date IN (SELECT MAX([DATE]) From EmployeeStopSocSec WHERE EmployeeID=VwEmployeeStopSocSec.EmployeeID and TenantID=1) ORDER BY ID Query 17:48:43 - IsConnectionValid True 17:48:45 - IsConnectionValid True 17:48:45 - SELECT DISTINCT * FROM VwEmployeeStopSocSec WHERE TenantID = @val0 and IsSocialsec = @val1 and NOTSTOP = @val2 and Date IN (SELECT MAX([DATE]) From EmployeeStopSocSec WHERE EmployeeID=VwEmployeeStopSocSec.EmployeeID and TenantID=1) ORDER BY ID Query 17:51:12 - IsConnectionValid True 17:51:16 - IsConnectionValid True 17:51:16 - SELECT DISTINCT * FROM VwEmployeeStopSocSec WHERE TenantID = @val0 and IsSocialsec = @val1 and NOTSTOP = @val2 and Date IN (SELECT MAX([DATE]) From EmployeeStopSocSec WHERE EmployeeID=VwEmployeeStopSocSec.EmployeeID and TenantID=1) ORDER BY ID Query 17:53:03 - IsConnectionValid True 17:53:06 - IsConnectionValid True 17:53:06 - SELECT DISTINCT * FROM VwEmployeeStopSocSec WHERE TenantID = @val0 and IsSocialsec = @val1 and NOTSTOP = @val2 and Date IN (SELECT MAX([DATE]) From EmployeeStopSocSec WHERE EmployeeID=VwEmployeeStopSocSec.EmployeeID and TenantID=1) ORDER BY ID Query 17:53:27 - IsConnectionValid True 17:54:16 - IsConnectionValid True 17:54:19 - IsConnectionValid True 17:54:19 - IsConnectionValid True 17:54:19 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and IsSocialsec = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 17:54:19 - SELECT DISTINCT * FROM StopSocSecReason WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:54:22 - IsConnectionValid True 17:54:26 - IsConnectionValid True 17:54:28 - IsConnectionValid True 17:54:28 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and IsSocialsec = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 17:54:29 - IsConnectionValid True 17:54:32 - IsConnectionValid True 17:54:32 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 17:54:33 - IsConnectionValid True 17:54:36 - IsConnectionValid True 17:54:38 - IsConnectionValid True 17:54:38 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:54:39 - IsConnectionValid True 17:54:41 - IsConnectionValid True 17:54:41 - IsConnectionValid True 17:54:41 - SELECT Name_E AS Name_E, LAST_NO AS LAST_NO FROM VOU001 WHERE vTypeAlias = @val0 ORDER BY ID Query