2024-06-06 13:29:55.3109|TRACE|DashboardControllerLogger|DashboardController constructor
2024-06-06 13:29:55.4009|TRACE|RestAuthorizationLogger|Into IsAuthorized DddsUtils.Web
2024-06-06 13:29:55.4009|TRACE|RestAuthorizationLogger|token
2024-06-06 13:29:55.4009|TRACE|RestAuthorizationLogger|BAqwPFmj7es0aUbuv1r+zfCqP1RaOBTd8G0pM9MBsgGrIvE0J0VtFd3/PGRkiuqP/a6k5Kf7yO/SHrrgoJ3MkoF9L/7wc4yexsw0F9yD3gjUhzfEPtxDPNu5/pf/WJ+f
2024-06-06 13:29:55.4109|TRACE|RestAuthorizationLogger|User info: System.Security.Principal.GenericPrincipal
2024-06-06 13:29:55.4109|TRACE|RestAuthorizationLogger|Completed IsAuthorized DddsUtils.Web: True
2024-06-06 13:29:55.4859|TRACE|DashboardControllerLogger|Into getDiseaseProfile
2024-06-06 13:29:55.4909|TRACE|DashoboardManagerLogger|Into getDiseaseProfile
2024-06-06 13:29:55.4909|TRACE|DashboardRepositoryLogger|Into getDiseaseProfile
2024-06-06 13:29:57.1850|ERROR|DapperContextLogger|Method: getDiseaseProfile ms: 1680 Message: Conversion failed when converting the varchar value 'R08' to data type int.
2024-06-06 13:29:57.1850|ERROR|DapperContextLogger|

DECLARE 
   @Level1 varchar( 50 ) = '0' 
,  @Level2 varchar( 50 ) = '0' 
,  @Level3 varchar( 50 ) = '0' 
,  @Level4 varchar( 50 ) = '0' 
,  @Level5 varchar( 50 ) = '0' 
,  @SessionLevel1 varchar( 50 ) = '1,2' 
,  @SessionLevel2 varchar( 50 ) = '0' 
,  @SessionLevel3 varchar( 50 ) = '0' 
,  @SessionLevel4 varchar( 50 ) = '0' 
,  @SessionLevel5 varchar( 50 ) = '0' 
,  @Projects varchar( 50 ) = '0' 
,  @Plans varchar( 50 ) = 'null' 
,  @Year varchar( 50 ) = ',' 
,  @Month varchar( 50 ) = ',' 
,  @iGraphID int = 6 

 EXEC dbo.DashboardSP @Level1,@Level2,@Level3,@Level4,@Level5,@SessionLevel1,@SessionLevel2,@SessionLevel3,@SessionLevel4,@SessionLevel5,@Projects,@Plans,@Year,@Month,@iGraphID 

2024-06-06 13:29:57.1850|TRACE|DashboardRepositoryLogger|Completed getDiseaseProfile
2024-06-06 13:29:57.1850|TRACE|DashoboardManagerLogger|Completed getDiseaseProfile
2024-06-06 13:29:57.1850|TRACE|DashboardControllerLogger|Completed getDiseaseProfile