15:16:05 - IsConnectionValid True
15:16:08 - IsConnectionValid True
15:16:09 - IsConnectionValid True
15:16:16 - IsConnectionValid True
15:16:16 - IsConnectionValid True
15:16:19 - IsConnectionValid True
15:16:19 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1
15:16:19 - Select COUNT(ID) AS TotalNum FROM Employees WHERE ( DATEDIFF(DAY,GETDATE(),EndContractDate)<=30 AND DATEDIFF(DAY,GETDATE(),EndContractDate)>0)  COUNT Query 0
15:16:19 - SELECT COUNT(ID) AS TotalNum 
									FROM VwEmpDocAlerts
									WHERE DocTypeID=1 AND  
									( DATEDIFF(DAY,GETDATE(),ToDate)<=21 AND 
									DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 0
15:16:20 - Select COUNT(E.ID) AS TotalNum from Employees E INNER JOIN EmploymentTypes ET ON E.EmploymentType=ET.ID WHERE ((( DATEDIFF(DAY,DateBegin ,GETDATE()))-6)/30 )>=6 and et.IsShowInAlert=1 and ISNULL(IsthirdOrFour,0)=0 COUNT Query 0
15:16:20 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(BirthDate)=MONTH(GETDATE())  COUNT Query 16
15:16:20 - 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 0
15:16:20 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(EndContractDate)=MONTH(GETDATE()) AND YEAR(EndContractDate)=YEAR(GETDATE())  COUNT Query 0
15:16:20 - 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(DAY, (COMPAREDATE), GETDATE()) / 365)) > CASE WHEN Gender =1 THEN (SELECT FemaleSocStopY FROM SysParam) ELSE (SELECT MaleSocStopY FROM SysParam) END COUNT Query 0
15:16:21 - IsConnectionValid True
15:48:14 - IsConnectionValid True
15:48:14 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1
15:48:14 - Select COUNT(ID) AS TotalNum FROM Employees WHERE ( DATEDIFF(DAY,GETDATE(),EndContractDate)<=30 AND DATEDIFF(DAY,GETDATE(),EndContractDate)>0)  COUNT Query 0
15:48:14 - SELECT COUNT(ID) AS TotalNum 
									FROM VwEmpDocAlerts
									WHERE DocTypeID=1 AND  
									( DATEDIFF(DAY,GETDATE(),ToDate)<=21 AND 
									DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 0
15:48:14 - Select COUNT(E.ID) AS TotalNum from Employees E INNER JOIN EmploymentTypes ET ON E.EmploymentType=ET.ID WHERE ((( DATEDIFF(DAY,DateBegin ,GETDATE()))-6)/30 )>=6 and et.IsShowInAlert=1 and ISNULL(IsthirdOrFour,0)=0 COUNT Query 0
15:48:14 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(BirthDate)=MONTH(GETDATE())  COUNT Query 16
15:48:14 - 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 0
15:48:14 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(EndContractDate)=MONTH(GETDATE()) AND YEAR(EndContractDate)=YEAR(GETDATE())  COUNT Query 0
15:48:14 - 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(DAY, (COMPAREDATE), GETDATE()) / 365)) > CASE WHEN Gender =1 THEN (SELECT FemaleSocStopY FROM SysParam) ELSE (SELECT MaleSocStopY FROM SysParam) END COUNT Query 0
15:48:17 - IsConnectionValid True
15:48:24 - IsConnectionValid True
15:48:24 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
15:48:29 - IsConnectionValid True
15:48:30 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees  WHERE   (DateLeft = '1900-01-01' or (DateleftTemp<>DateLeft and DateLeft > GETDATE()))  and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:48:35 - IsConnectionValid True
15:48:35 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
15:48:37 - IsConnectionValid True
15:48:37 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:48:40 - IsConnectionValid True
15:48:40 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
15:48:42 - IsConnectionValid True
15:48:42 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:48:46 - IsConnectionValid True
15:48:46 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
15:48:46 - IsConnectionValid True
15:48:46 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
22:32:33 - IsConnectionValid False