2023-05-03 06:53:09.8814||DEBUG|InstitutionService.Program|init main function 2023-05-03 06:53:12.8149|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 06:53:13.1809|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-03 06:53:13.1988|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-03 06:53:13.1988|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-03 06:53:13.1988|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-03 06:53:13.2178|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-05-03 06:53:13.2178|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-05-03 06:53:13.5174|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-05-03 06:53:13.5174|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2023-05-03 06:53:13.5174|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {e8e2c85d-a182-4b51-b3b6-d3f2741037d0} with creation date 2023-05-03 05:53:13Z, activation date 2023-05-03 05:53:13Z, and expiration date 2023-08-01 05:53:13Z. 2023-05-03 06:53:13.5282|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {e8e2c85d-a182-4b51-b3b6-d3f2741037d0} may be persisted to storage in unencrypted form. 2023-05-03 06:53:13.6001|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 06:53:13.9852|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 06:53:13.9852|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 06:53:14.0244|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 06:53:14.0284|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 06:53:14.2434|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 06:53:14.3149|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 287.8614ms 2023-05-03 06:53:14.3149|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 06:53:14.3149|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 718.9378ms 200 application/json; charset=utf-8 2023-05-03 06:53:33.3789|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 0 2023-05-03 06:53:33.3789|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 06:53:33.3789|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.1628ms 204 2023-05-03 06:53:33.6603|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 06:53:33.7961|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 06:53:33.7961|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 06:53:33.7961|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 06:53:33.7961|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 06:53:33.8220|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 06:53:33.8271|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 06:53:33.8271|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 29.0821ms 2023-05-03 06:53:33.8271|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 06:53:33.8271|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 168.1873ms 200 application/json; charset=utf-8 2023-05-03 07:25:13.1905|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:45820/INSTITUTION/iisintegration 0 2023-05-03 07:25:13.1905|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0769ms 202 2023-05-03 10:47:56.3221||DEBUG|InstitutionService.Program|init main function 2023-05-03 10:47:57.9020|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 10:47:58.2799|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-03 10:47:58.2981|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-03 10:47:58.2981|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-03 10:47:58.3015|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-03 10:47:58.3015|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-05-03 10:47:58.3269|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-05-03 10:47:58.6158|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-05-03 10:47:58.6158|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2023-05-03 10:47:58.6158|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {dad1e3d5-0e26-4d63-8fbb-b542f63479c6} with creation date 2023-05-03 09:47:58Z, activation date 2023-05-03 09:47:58Z, and expiration date 2023-08-01 09:47:58Z. 2023-05-03 10:47:58.6158|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {dad1e3d5-0e26-4d63-8fbb-b542f63479c6} may be persisted to storage in unencrypted form. 2023-05-03 10:47:58.7219|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 10:47:59.1093|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 10:47:59.1133|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 10:47:59.1408|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 10:47:59.1438|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 10:47:59.3572|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 10:47:59.4279|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 284.5385ms 2023-05-03 10:47:59.4279|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 10:47:59.4279|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 709.9157ms 200 application/json; charset=utf-8 2023-05-03 10:48:07.1781|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 10:48:07.1781|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 10:48:07.1781|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 10:48:07.1781|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 10:48:07.2058|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 10:48:07.2058|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 10:48:07.2058|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 30.5204ms 2023-05-03 10:48:07.2058|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 10:48:07.2058|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 35.5368ms 200 application/json; charset=utf-8 2023-05-03 10:48:08.4305|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 10:48:08.4305|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 10:48:08.4305|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 10:48:08.4305|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 10:48:08.4305|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 10:48:08.4430|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 10:48:08.4430|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 8.7942ms 2023-05-03 10:48:08.4430|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 10:48:08.4430|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 14.0599ms 200 application/json; charset=utf-8 2023-05-03 10:48:12.2354|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Countries 2023-05-03 10:48:12.2368|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 10:48:12.2368|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.Countries (InstitutionService)' 2023-05-03 10:48:12.2368|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "Countries", controller = "Institution"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult Countries(System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 10:48:12.2368|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 10:48:12.3221|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [c].[Id], [c].[Code1], [c].[Code2], [c].[CountryName] FROM [Countries] AS [c] 2023-05-03 10:48:12.3539|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Entity.Countries, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 10:48:12.3539|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.Countries (InstitutionService) in 118.1255ms 2023-05-03 10:48:12.3539|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.Countries (InstitutionService)' 2023-05-03 10:48:12.3539|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 124.2417ms 200 application/json; charset=utf-8 2023-05-03 10:48:21.4953|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 10:48:21.4953|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 10:48:21.4953|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.5648ms 204 2023-05-03 10:48:21.9144|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 10:48:22.0539|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 10:48:22.0539|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 10:48:22.0539|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 10:48:22.0539|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 10:48:22.0539|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 10:48:22.0539|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 10:48:22.0539|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 4.3462ms 2023-05-03 10:48:22.0539|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 10:48:22.0539|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 146.6278ms 200 application/json; charset=utf-8 2023-05-03 10:48:26.6563|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 10:48:26.6563|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 10:48:26.6563|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.6198ms 204 2023-05-03 10:48:26.9570|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 10:48:26.9587|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 10:48:26.9587|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 10:48:26.9587|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 10:48:26.9587|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 10:48:26.9587|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 10:48:26.9587|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 10:48:26.9587|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 5.3151ms 2023-05-03 10:48:26.9587|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 10:48:26.9587|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.3706ms 200 application/json; charset=utf-8 2023-05-03 10:48:27.9059|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 10:48:27.9059|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 10:48:27.9081|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.1295ms 204 2023-05-03 10:48:28.2061|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 10:48:28.2075|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 10:48:28.2075|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 10:48:28.2075|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 10:48:28.2075|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 10:48:28.2075|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 10:48:28.2075|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 10:48:28.2075|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 4.4393ms 2023-05-03 10:48:28.2075|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 10:48:28.2075|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.1091ms 200 application/json; charset=utf-8 2023-05-03 10:48:34.6144|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 10:48:34.6144|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 10:48:34.6144|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.9224ms 204 2023-05-03 10:48:34.9180|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 10:48:34.9180|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 10:48:34.9180|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 10:48:34.9180|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 10:48:34.9180|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 10:48:34.9180|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 10:48:34.9180|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 10:48:34.9180|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 4.3613ms 2023-05-03 10:48:34.9180|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 10:48:34.9257|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7.6982ms 200 application/json; charset=utf-8 2023-05-03 11:20:55.0500|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:38325/INSTITUTION/iisintegration 0 2023-05-03 11:20:55.0500|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.6489ms 202 2023-05-03 11:37:14.7493||DEBUG|InstitutionService.Program|init main function 2023-05-03 11:37:15.4891|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 11:37:15.6508|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-03 11:37:15.6687|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-03 11:37:15.6687|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-03 11:37:15.6687|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-03 11:37:15.6867|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-05-03 11:37:15.6982|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-05-03 11:37:15.7738|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-05-03 11:37:15.7738|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2023-05-03 11:37:15.7816|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {75de374b-e0bd-4af3-8dc5-46691d88c4d3} with creation date 2023-05-03 10:37:15Z, activation date 2023-05-03 10:37:15Z, and expiration date 2023-08-01 10:37:15Z. 2023-05-03 11:37:15.7816|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {75de374b-e0bd-4af3-8dc5-46691d88c4d3} may be persisted to storage in unencrypted form. 2023-05-03 11:37:16.0783|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 11:37:16.1152|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 11:37:16.1152|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:37:16.1462|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 11:37:16.1462|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 11:37:16.3054|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 11:37:16.3755|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 226.7912ms 2023-05-03 11:37:16.3755|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:37:16.3790|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 301.2451ms 200 application/json; charset=utf-8 2023-05-03 11:37:58.6837|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 11:37:58.6881|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 11:37:58.6881|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:37:58.6881|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 11:37:58.7186|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 11:37:58.7249|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 11:37:58.7249|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 36.4553ms 2023-05-03 11:37:58.7249|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:37:58.7249|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 42.9253ms 200 application/json; charset=utf-8 2023-05-03 11:37:59.1803|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 11:37:59.1803|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 11:37:59.1803|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:37:59.1803|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 11:37:59.1893|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 11:37:59.1893|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 11:37:59.1893|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 8.6211ms 2023-05-03 11:37:59.1893|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:37:59.1893|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 15.7279ms 200 application/json; charset=utf-8 2023-05-03 11:38:04.2992|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Countries 2023-05-03 11:38:04.2992|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 11:38:04.2992|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.Countries (InstitutionService)' 2023-05-03 11:38:04.2992|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "Countries", controller = "Institution"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult Countries(System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 11:38:04.2992|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 11:38:04.3863|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [c].[Id], [c].[Code1], [c].[Code2], [c].[CountryName] FROM [Countries] AS [c] 2023-05-03 11:38:04.4184|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Entity.Countries, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 11:38:04.4184|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.Countries (InstitutionService) in 118.9001ms 2023-05-03 11:38:04.4184|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.Countries (InstitutionService)' 2023-05-03 11:38:04.4241|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 124.9695ms 200 application/json; charset=utf-8 2023-05-03 11:43:45.4975|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 11:43:45.4975|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 11:43:45.4975|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:43:45.4975|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 11:43:45.4975|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 11:43:45.4975|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 11:43:45.4975|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 7.6608ms 2023-05-03 11:43:45.4975|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:43:45.4975|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.0512ms 200 application/json; charset=utf-8 2023-05-03 11:43:50.0883|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 11:43:50.0883|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 11:43:50.0883|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:43:50.0883|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 11:43:50.0883|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 11:43:50.0883|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 11:43:50.0883|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 5.0921ms 2023-05-03 11:43:50.0883|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:43:50.0883|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.0443ms 200 application/json; charset=utf-8 2023-05-03 11:43:51.6079|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 11:43:51.6079|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 11:43:51.6079|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:43:51.6079|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 11:43:51.6079|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 11:43:51.6079|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 11:43:51.6079|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 6.7511ms 2023-05-03 11:43:51.6079|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:43:51.6079|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 10.4283ms 200 application/json; charset=utf-8 2023-05-03 11:43:53.8676|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Countries 2023-05-03 11:43:53.8676|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 11:43:53.8676|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.Countries (InstitutionService)' 2023-05-03 11:43:53.8676|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "Countries", controller = "Institution"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult Countries(System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 11:43:53.8676|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 11:43:53.8676|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [c].[Id], [c].[Code1], [c].[Code2], [c].[CountryName] FROM [Countries] AS [c] 2023-05-03 11:43:53.8676|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Entity.Countries, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 11:43:53.8822|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.Countries (InstitutionService) in 12.1462ms 2023-05-03 11:43:53.8822|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.Countries (InstitutionService)' 2023-05-03 11:43:53.8822|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 15.0955ms 200 application/json; charset=utf-8 2023-05-03 11:55:55.0293|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 11:55:55.0293|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 11:55:55.0293|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.9488ms 204 2023-05-03 11:55:56.0515|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 11:55:56.1006|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 11:55:56.1006|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 11:55:56.1006|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:55:56.1006|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 11:55:56.1006|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 11:55:56.1006|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 11:55:56.1006|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 7.9612ms 2023-05-03 11:55:56.1006|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:55:56.1006|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 59.7855ms 200 application/json; charset=utf-8 2023-05-03 11:56:28.3580|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 11:56:28.3591|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 11:56:28.3591|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.6593ms 204 2023-05-03 11:56:28.6897|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 11:56:28.6918|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 11:56:28.6918|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 11:56:28.6918|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:56:28.6918|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 11:56:28.6918|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 11:56:28.6918|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 11:56:28.6918|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 4.9896ms 2023-05-03 11:56:28.6918|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:56:28.6918|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.3504ms 200 application/json; charset=utf-8 2023-05-03 11:56:29.0937|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 11:56:29.0947|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 11:56:29.0947|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.4899ms 204 2023-05-03 11:56:29.4700|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 11:56:29.4700|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 11:56:29.4700|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 11:56:29.4700|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:56:29.4700|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 11:56:29.4700|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 11:56:29.4700|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 11:56:29.4700|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 5.0427ms 2023-05-03 11:56:29.4700|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 11:56:29.4700|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.8364ms 200 application/json; charset=utf-8 2023-05-03 12:38:26.4667|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 12:38:26.4667|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 12:38:26.4667|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1706ms 204 2023-05-03 12:38:26.9695|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 12:38:26.9711|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 12:38:26.9711|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 12:38:26.9711|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 12:38:26.9711|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 12:38:26.9711|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 12:38:26.9711|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 12:38:26.9711|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 8.1675ms 2023-05-03 12:38:26.9711|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 12:38:26.9711|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.951ms 200 application/json; charset=utf-8 2023-05-03 12:38:39.9374|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 12:38:39.9374|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 12:38:39.9374|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1169ms 204 2023-05-03 12:38:40.3305|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 12:38:40.3305|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 12:38:40.3305|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 12:38:40.3305|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 12:38:40.3305|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 12:38:40.3305|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 12:38:40.3305|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 12:38:40.3305|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 4.2037ms 2023-05-03 12:38:40.3305|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 12:38:40.3305|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7.1029ms 200 application/json; charset=utf-8 2023-05-03 12:38:41.8379|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 12:38:41.8379|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 12:38:41.8379|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.4588ms 204 2023-05-03 12:38:42.2871|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 12:38:42.2871|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 12:38:42.2871|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 12:38:42.2871|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 12:38:42.2871|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 12:38:42.2871|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 12:38:42.2871|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 12:38:42.2871|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 4.0007ms 2023-05-03 12:38:42.2871|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 12:38:42.2871|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6.6856ms 200 application/json; charset=utf-8 2023-05-03 12:41:48.8114|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 12:41:48.8114|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 12:41:48.8114|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1646ms 204 2023-05-03 12:41:49.1279|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 12:41:49.1279|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 12:41:49.1279|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 12:41:49.1279|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 12:41:49.1279|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 12:41:49.1279|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 12:41:49.1279|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 12:41:49.1279|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 4.0022ms 2023-05-03 12:41:49.1279|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 12:41:49.1279|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6.6262ms 200 application/json; charset=utf-8 2023-05-03 12:41:50.4207|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 12:41:50.4207|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 12:41:50.4207|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0554ms 204 2023-05-03 12:41:50.7704|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 12:41:50.7704|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 12:41:50.7704|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 12:41:50.7704|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 12:41:50.7704|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 12:41:50.7704|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 12:41:50.7704|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 12:41:50.7704|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 3.5633ms 2023-05-03 12:41:50.7704|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 12:41:50.7704|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6.0855ms 200 application/json; charset=utf-8 2023-05-03 12:46:12.7376|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 12:46:12.7376|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 12:46:12.7376|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.214ms 204 2023-05-03 12:46:13.1084|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 12:46:13.1084|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 12:46:13.1084|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 12:46:13.1084|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 12:46:13.1084|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 12:46:13.1084|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 12:46:13.1084|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 12:46:13.1084|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 3.897ms 2023-05-03 12:46:13.1084|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 12:46:13.1084|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7.0266ms 200 application/json; charset=utf-8 2023-05-03 13:07:23.3634|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 0 2023-05-03 13:07:23.3634|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:07:23.3634|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.125ms 204 2023-05-03 13:07:23.6432|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 13:07:23.6432|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 13:07:23.6432|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:07:23.6432|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 13:07:23.6432|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 13:07:23.6432|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 13:07:23.6432|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 13:07:23.6432|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 7.6231ms 2023-05-03 13:07:23.6432|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 13:07:23.6432|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 10.9072ms 200 application/json; charset=utf-8 2023-05-03 13:31:48.9634|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 13:31:48.9634|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:31:48.9634|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 13:31:48.9634|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 13:31:48.9660|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 13:31:48.9660|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 13:31:48.9660|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 7.0846ms 2023-05-03 13:31:48.9660|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 13:31:48.9660|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.4945ms 200 application/json; charset=utf-8 2023-05-03 13:31:53.2432|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 13:31:53.2432|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:31:53.2432|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 13:31:53.2432|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 13:31:53.2458|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 13:31:53.2458|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 13:31:53.2458|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 4.092ms 2023-05-03 13:31:53.2458|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 13:31:53.2458|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6.5536ms 200 application/json; charset=utf-8 2023-05-03 13:31:54.6121|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 13:31:54.6121|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:31:54.6121|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 13:31:54.6121|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 13:31:54.6121|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 13:31:54.6121|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 13:31:54.6121|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 2.845ms 2023-05-03 13:31:54.6121|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 13:31:54.6121|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.4566ms 200 application/json; charset=utf-8 2023-05-03 13:31:56.7121|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Countries 2023-05-03 13:31:56.7121|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:31:56.7121|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.Countries (InstitutionService)' 2023-05-03 13:31:56.7121|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "Countries", controller = "Institution"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult Countries(System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 13:31:56.7121|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 13:31:56.7189|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [c].[Id], [c].[Code1], [c].[Code2], [c].[CountryName] FROM [Countries] AS [c] 2023-05-03 13:31:56.7189|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Entity.Countries, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 13:31:56.7189|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.Countries (InstitutionService) in 12.5195ms 2023-05-03 13:31:56.7189|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.Countries (InstitutionService)' 2023-05-03 13:31:56.7189|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 13.9178ms 200 application/json; charset=utf-8 2023-05-03 13:32:01.8195|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 13:32:01.8195|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:32:01.8195|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.5998ms 204 2023-05-03 13:32:02.1151|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 13:32:02.1151|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 13:32:02.1151|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:32:02.1151|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 13:32:02.1151|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 13:32:02.1151|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 13:32:02.1198|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 13:32:02.1198|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 3.1814ms 2023-05-03 13:32:02.1198|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 13:32:02.1198|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.6783ms 200 application/json; charset=utf-8 2023-05-03 13:32:05.9547|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 13:32:05.9547|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:32:05.9547|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.7198ms 204 2023-05-03 13:32:06.2287|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 13:32:06.2287|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 13:32:06.2287|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:32:06.2287|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 13:32:06.2287|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 13:32:06.2308|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 13:32:06.2308|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 13:32:06.2308|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 2.8851ms 2023-05-03 13:32:06.2308|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 13:32:06.2308|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.9225ms 200 application/json; charset=utf-8 2023-05-03 13:32:07.1320|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 13:32:07.1320|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:32:07.1320|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.5899ms 204 2023-05-03 13:32:07.4368|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 13:32:07.4368|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 13:32:07.4368|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:32:07.4368|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 13:32:07.4368|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 13:32:07.4368|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 13:32:07.4368|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 13:32:07.4368|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 2.7549ms 2023-05-03 13:32:07.4368|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 13:32:07.4368|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.7567ms 200 application/json; charset=utf-8 2023-05-03 13:50:03.5236|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=257&userId=10628&institutionId=93 0 2023-05-03 13:50:03.5236|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:50:03.5236|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.8882ms 204 2023-05-03 13:50:03.8174|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=257&userId=10628&institutionId=93 2023-05-03 13:50:03.8174|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 13:50:03.8174|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:50:03.8174|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2023-05-03 13:50:03.8174|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 13:50:03.8174|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 2023-05-03 13:50:03.8297|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 13:50:03.9231|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (26ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId] FROM [CertificateLogs] AS [c] WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 2023-05-03 13:50:04.0369|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [i].[Id], [i].[AccountNumber], [i].[Address], [i].[BankId], [i].[BannerUrl], [i].[CertificateLogoUrl], [i].[Code], [i].[Country], [i].[CreatedBy], [i].[DateCreated], [i].[DateModified], [i].[Email], [i].[FullName], [i].[InstitutionType], [i].[IsActive], [i].[IsDeleted], [i].[LogoUrl], [i].[ModifiedBy], [i].[Name], [i].[OverView], [i].[Phonenumber], [i].[ThumbnailUrl], [i].[Website] FROM [Institution] AS [i] WHERE [i].[Id] = @__institutionId_0 2023-05-03 13:50:04.1378|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [CertificateLogs] ([CertificateId], [CourseId], [CreatedBy], [DateCreated], [DateModified], [DownloadDate], [InstitutionCode], [IsActive], [IsDeleted], [ModifiedBy], [UserId]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10); SELECT [Id] FROM [CertificateLogs] WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 2023-05-03 13:50:04.1780||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2023-05-03 13:50:04.1900|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template] FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0 2023-05-03 13:50:11.4559|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-03 13:50:11.4866|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 7657.9587ms 2023-05-03 13:50:11.4866|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 13:50:11.4866|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7669.7898ms 200 application/json; charset=utf-8 2023-05-03 13:51:34.0098|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10628&institutionId=93 0 2023-05-03 13:51:34.0098|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:51:34.0098|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.618ms 204 2023-05-03 13:51:34.2911|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10628&institutionId=93 2023-05-03 13:51:34.2911|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 13:51:34.2911|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:51:34.2911|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2023-05-03 13:51:34.2911|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 13:51:34.2911|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 2023-05-03 13:51:34.2911|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 13:51:34.2988|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId] FROM [CertificateLogs] AS [c] WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 2023-05-03 13:51:34.4010|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [i].[Id], [i].[AccountNumber], [i].[Address], [i].[BankId], [i].[BannerUrl], [i].[CertificateLogoUrl], [i].[Code], [i].[Country], [i].[CreatedBy], [i].[DateCreated], [i].[DateModified], [i].[Email], [i].[FullName], [i].[InstitutionType], [i].[IsActive], [i].[IsDeleted], [i].[LogoUrl], [i].[ModifiedBy], [i].[Name], [i].[OverView], [i].[Phonenumber], [i].[ThumbnailUrl], [i].[Website] FROM [Institution] AS [i] WHERE [i].[Id] = @__institutionId_0 2023-05-03 13:51:34.4010|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [CertificateLogs] ([CertificateId], [CourseId], [CreatedBy], [DateCreated], [DateModified], [DownloadDate], [InstitutionCode], [IsActive], [IsDeleted], [ModifiedBy], [UserId]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10); SELECT [Id] FROM [CertificateLogs] WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 2023-05-03 13:51:34.4078||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2023-05-03 13:51:34.4078|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template] FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0 2023-05-03 13:51:37.0418|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-03 13:51:37.0645|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2770.9455ms 2023-05-03 13:51:37.0645|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 13:51:37.0645|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2773.9531ms 200 application/json; charset=utf-8 2023-05-03 13:52:46.5632|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=257&userId=10628&institutionId=93 0 2023-05-03 13:52:46.5632|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:52:46.5632|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.5806ms 204 2023-05-03 13:52:46.8462|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=257&userId=10628&institutionId=93 2023-05-03 13:52:46.8462|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 13:52:46.8462|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:52:46.8462|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2023-05-03 13:52:46.8462|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 13:52:46.8462|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 2023-05-03 13:52:46.8462|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 13:52:46.8462|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId] FROM [CertificateLogs] AS [c] WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 2023-05-03 13:52:46.8689|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10 WHERE [Id] = @p11; SELECT @@ROWCOUNT; 2023-05-03 13:52:46.8788||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2023-05-03 13:52:46.8788|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template] FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0 2023-05-03 13:52:49.5179|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-03 13:52:49.5413|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2692.7184ms 2023-05-03 13:52:49.5413|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 13:52:49.5413|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2695.6954ms 200 application/json; charset=utf-8 2023-05-03 13:53:13.1691|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=257&userId=10628&institutionId=93 0 2023-05-03 13:53:13.1691|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:53:13.1691|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.6301ms 204 2023-05-03 13:53:13.4451|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=257&userId=10628&institutionId=93 2023-05-03 13:53:13.4451|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 13:53:13.4451|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:53:13.4451|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2023-05-03 13:53:13.4451|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 13:53:13.4451|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 2023-05-03 13:53:13.4451|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 13:53:13.4451|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId] FROM [CertificateLogs] AS [c] WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 2023-05-03 13:53:13.4538|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10 WHERE [Id] = @p11; SELECT @@ROWCOUNT; 2023-05-03 13:53:13.4538||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2023-05-03 13:53:13.4538|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template] FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0 2023-05-03 13:53:16.1724|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-03 13:53:16.1968|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2749.6975ms 2023-05-03 13:53:16.1968|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 13:53:16.1968|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2752.3326ms 200 application/json; charset=utf-8 2023-05-03 13:56:14.2136|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10628&institutionId=93 0 2023-05-03 13:56:14.2136|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:56:14.2143|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.7116ms 204 2023-05-03 13:56:14.5350|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10628&institutionId=93 2023-05-03 13:56:14.5350|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 13:56:14.5350|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:56:14.5350|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2023-05-03 13:56:14.5350|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 13:56:14.5350|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 2023-05-03 13:56:14.5350|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 13:56:14.5350|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId] FROM [CertificateLogs] AS [c] WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 2023-05-03 13:56:14.5442|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10 WHERE [Id] = @p11; SELECT @@ROWCOUNT; 2023-05-03 13:56:14.5442||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2023-05-03 13:56:14.5442|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template] FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0 2023-05-03 13:56:17.1956|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-03 13:56:17.2191|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2681.6991ms 2023-05-03 13:56:17.2191|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 13:56:17.2191|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2684.6819ms 200 application/json; charset=utf-8 2023-05-03 13:56:44.8841|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10628&institutionId=93 0 2023-05-03 13:56:44.8841|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:56:44.8841|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.5821ms 204 2023-05-03 13:56:45.1690|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10628&institutionId=93 2023-05-03 13:56:45.1690|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 13:56:45.1690|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:56:45.1690|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2023-05-03 13:56:45.1690|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 13:56:45.1690|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 2023-05-03 13:56:45.1690|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 13:56:45.1690|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId] FROM [CertificateLogs] AS [c] WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 2023-05-03 13:56:45.1690|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10 WHERE [Id] = @p11; SELECT @@ROWCOUNT; 2023-05-03 13:56:45.1690||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2023-05-03 13:56:45.1690|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template] FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0 2023-05-03 13:56:47.8287|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-03 13:56:47.8512|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2680.2795ms 2023-05-03 13:56:47.8512|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 13:56:47.8512|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2682.8438ms 200 application/json; charset=utf-8 2023-05-03 13:57:14.0258|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10628&institutionId=93 0 2023-05-03 13:57:14.0258|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:57:14.0264|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.6244ms 204 2023-05-03 13:57:15.1435|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10628&institutionId=93 2023-05-03 13:57:15.1435|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 13:57:15.1435|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:57:15.1435|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2023-05-03 13:57:15.1435|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 13:57:15.1435|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 2023-05-03 13:57:15.1435|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 13:57:15.1435|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId] FROM [CertificateLogs] AS [c] WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 2023-05-03 13:57:15.1435|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10 WHERE [Id] = @p11; SELECT @@ROWCOUNT; 2023-05-03 13:57:15.1534||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2023-05-03 13:57:15.1534|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template] FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0 2023-05-03 13:57:17.7842|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-03 13:57:17.8062|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2660.8768ms 2023-05-03 13:57:17.8062|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 13:57:17.8062|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2663.1135ms 200 application/json; charset=utf-8 2023-05-03 13:58:45.3007|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 0 2023-05-03 13:58:45.3007|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:58:45.3007|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.695ms 204 2023-05-03 13:58:45.5739|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 13:58:45.5739|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 13:58:45.5739|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 13:58:45.5739|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 13:58:45.5739|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 13:58:45.5739|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 13:58:45.5739|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 13:58:45.5739|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 2.491ms 2023-05-03 13:58:45.5739|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 13:58:45.5739|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.8257ms 200 application/json; charset=utf-8 2023-05-03 15:21:27.7832|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 0 2023-05-03 15:21:27.7832|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:21:27.7832|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.6831ms 204 2023-05-03 15:21:28.1372|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 15:21:28.1372|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 15:21:28.1372|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:21:28.1372|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 15:21:28.1372|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 15:21:28.1372|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 15:21:28.1444|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 15:21:28.1444|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 6.0735ms 2023-05-03 15:21:28.1444|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 15:21:28.1444|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7.9327ms 200 application/json; charset=utf-8 2023-05-03 15:23:21.6823|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 15:23:21.6823|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:23:21.6823|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 15:23:21.6823|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 15:23:21.6823|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 15:23:21.6823|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 15:23:21.6823|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 1.878ms 2023-05-03 15:23:21.6823|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 15:23:21.6823|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3.1271ms 200 application/json; charset=utf-8 2023-05-03 15:23:49.1419|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 15:23:49.1419|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:23:49.1419|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.6242ms 204 2023-05-03 15:23:49.8411|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 15:23:49.8411|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 15:23:49.8411|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:23:49.8421|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 15:23:49.8421|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 15:23:49.8421|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 15:23:49.8421|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 15:23:49.8421|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 1.8812ms 2023-05-03 15:23:49.8421|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 15:23:49.8421|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3.5281ms 200 application/json; charset=utf-8 2023-05-03 15:24:07.1989|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10628&institutionId=93 2023-05-03 15:24:07.1989|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:24:07.1989|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.624ms 204 2023-05-03 15:24:08.0262|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10628&institutionId=93 2023-05-03 15:24:08.0262|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 15:24:08.0262|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:24:08.0262|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2023-05-03 15:24:08.0262|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 15:24:08.0262|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 2023-05-03 15:24:08.0262|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 15:24:08.0262|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId] FROM [CertificateLogs] AS [c] WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 2023-05-03 15:24:08.0262|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10 WHERE [Id] = @p11; SELECT @@ROWCOUNT; 2023-05-03 15:24:08.0262||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2023-05-03 15:24:08.0262|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template] FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0 2023-05-03 15:24:10.6705|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-03 15:24:10.6922|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2664.1544ms 2023-05-03 15:24:10.6922|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 15:24:10.6922|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2666.4332ms 200 application/json; charset=utf-8 2023-05-03 15:25:20.6169|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10628&institutionId=93 2023-05-03 15:25:20.6169|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:25:20.6169|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.5846ms 204 2023-05-03 15:25:21.1082|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10628&institutionId=93 2023-05-03 15:25:21.1082|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 15:25:21.1082|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:25:21.1082|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2023-05-03 15:25:21.1082|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 15:25:21.1082|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 2023-05-03 15:25:21.1082|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 15:25:21.1082|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId] FROM [CertificateLogs] AS [c] WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 2023-05-03 15:25:21.1082|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10 WHERE [Id] = @p11; SELECT @@ROWCOUNT; 2023-05-03 15:25:21.1082||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2023-05-03 15:25:21.1082|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template] FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0 2023-05-03 15:25:22.7836|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=257&userId=10628&institutionId=93 2023-05-03 15:25:22.7836|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:25:22.7836|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.5724ms 204 2023-05-03 15:25:23.2441|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=257&userId=10628&institutionId=93 2023-05-03 15:25:23.2441|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 15:25:23.2441|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:25:23.2441|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2023-05-03 15:25:23.2441|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 15:25:23.2441|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 2023-05-03 15:25:23.2460|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 15:25:23.2460|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId] FROM [CertificateLogs] AS [c] WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 2023-05-03 15:25:23.2460|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10 WHERE [Id] = @p11; SELECT @@ROWCOUNT; 2023-05-03 15:25:23.2460||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2023-05-03 15:25:23.2460|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template] FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0 2023-05-03 15:25:23.7840|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-03 15:25:23.8065|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2696.554ms 2023-05-03 15:25:23.8065|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 15:25:23.8065|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2698.8761ms 200 application/json; charset=utf-8 2023-05-03 15:25:25.8968|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-03 15:25:25.9188|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2672.983ms 2023-05-03 15:25:25.9188|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 15:25:25.9188|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2675.0974ms 200 application/json; charset=utf-8 2023-05-03 15:25:44.6850|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=257&userId=10628&institutionId=93 2023-05-03 15:25:44.6850|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:25:44.6850|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.6195ms 204 2023-05-03 15:25:45.1441|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=257&userId=10628&institutionId=93 2023-05-03 15:25:45.1441|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 15:25:45.1441|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:25:45.1441|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2023-05-03 15:25:45.1441|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 15:25:45.1441|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 2023-05-03 15:25:45.1441|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 15:25:45.1441|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId] FROM [CertificateLogs] AS [c] WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 2023-05-03 15:25:45.1441|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10 WHERE [Id] = @p11; SELECT @@ROWCOUNT; 2023-05-03 15:25:45.1531||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2023-05-03 15:25:45.1531|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template] FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0 2023-05-03 15:25:47.7972|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-03 15:25:47.8197|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2674.0445ms 2023-05-03 15:25:47.8200|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 15:25:47.8200|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2676.1184ms 200 application/json; charset=utf-8 2023-05-03 15:26:31.6643|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=257&userId=10628&institutionId=93 2023-05-03 15:26:31.6643|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:26:31.6643|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.6242ms 204 2023-05-03 15:26:32.2166|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=257&userId=10628&institutionId=93 2023-05-03 15:26:32.2166|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 15:26:32.2166|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:26:32.2166|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2023-05-03 15:26:32.2166|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 15:26:32.2166|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 2023-05-03 15:26:32.2166|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 15:26:32.2166|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId] FROM [CertificateLogs] AS [c] WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 2023-05-03 15:26:32.2166|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10 WHERE [Id] = @p11; SELECT @@ROWCOUNT; 2023-05-03 15:26:32.2166||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2023-05-03 15:26:32.2166|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template] FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0 2023-05-03 15:26:34.8656|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-03 15:26:34.8894|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2671.0967ms 2023-05-03 15:26:34.8894|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 15:26:34.8894|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2673.2876ms 200 application/json; charset=utf-8 2023-05-03 15:52:29.7547|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 15:52:29.7547|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:52:29.7547|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.6109ms 204 2023-05-03 15:52:30.1611|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 15:52:30.1611|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 15:52:30.1611|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 15:52:30.1611|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 15:52:30.1627|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 15:52:30.1627|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 15:52:30.1627|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 15:52:30.1627|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 7.051ms 2023-05-03 15:52:30.1627|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 15:52:30.1627|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.2775ms 200 application/json; charset=utf-8 2023-05-03 16:21:07.5310|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:24451/INSTITUTION/iisintegration 0 2023-05-03 16:21:07.5310|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.4045ms 202 2023-05-03 17:01:34.5476||DEBUG|InstitutionService.Program|init main function 2023-05-03 17:01:35.3418|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 17:01:35.5142|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-03 17:01:35.5323|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-03 17:01:35.5323|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-03 17:01:35.5323|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-03 17:01:35.5504|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-05-03 17:01:35.5650|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-05-03 17:01:35.6458|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-05-03 17:01:35.6458|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2023-05-03 17:01:35.6520|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {0a796bd7-efba-43ad-a7bd-82e17e966e49} with creation date 2023-05-03 16:01:35Z, activation date 2023-05-03 16:01:35Z, and expiration date 2023-08-01 16:01:35Z. 2023-05-03 17:01:35.6520|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {0a796bd7-efba-43ad-a7bd-82e17e966e49} may be persisted to storage in unencrypted form. 2023-05-03 17:01:35.8541|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 17:01:35.8944|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 17:01:35.8944|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 17:01:35.9251|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 17:01:35.9251|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 17:01:36.1198|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 17:01:36.2030|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 274.8074ms 2023-05-03 17:01:36.2030|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 17:01:36.2030|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 354.3069ms 200 application/json; charset=utf-8 2023-05-03 17:01:43.0939|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 17:01:43.0939|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 17:01:43.0939|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 17:01:43.0939|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 17:01:43.1221|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 17:01:43.1221|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 17:01:43.1221|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 29.9801ms 2023-05-03 17:01:43.1221|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 17:01:43.1221|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 35.1581ms 200 application/json; charset=utf-8 2023-05-03 17:22:13.8100|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:31518/INSTITUTION/iisintegration 0 2023-05-03 17:22:13.8100|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1275ms 202 2023-05-03 18:20:14.0724||DEBUG|InstitutionService.Program|init main function 2023-05-03 18:20:14.8422|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 18:20:15.0061|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-03 18:20:15.0268|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-03 18:20:15.0298|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-03 18:20:15.0298|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-03 18:20:15.0298|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-05-03 18:20:15.0567|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-05-03 18:20:15.1404|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-05-03 18:20:15.1411|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2023-05-03 18:20:15.1411|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {fade33b6-7431-4f12-ae32-9668bfe4735d} with creation date 2023-05-03 17:20:15Z, activation date 2023-05-03 17:20:15Z, and expiration date 2023-08-01 17:20:15Z. 2023-05-03 18:20:15.1411|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {fade33b6-7431-4f12-ae32-9668bfe4735d} may be persisted to storage in unencrypted form. 2023-05-03 18:20:15.3881|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 18:20:15.4287|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 18:20:15.4287|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 18:20:15.4644|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 18:20:15.4644|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 18:20:15.6450|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 18:20:15.7311|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 263.3062ms 2023-05-03 18:20:15.7324|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 18:20:15.7324|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 347.1246ms 200 application/json; charset=utf-8 2023-05-03 18:41:14.9210|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:14242/INSTITUTION/iisintegration 0 2023-05-03 18:41:14.9210|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0561ms 202 2023-05-03 22:06:13.5960||DEBUG|InstitutionService.Program|init main function 2023-05-03 22:06:14.3431|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 22:06:14.5062|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-03 22:06:14.5239|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-03 22:06:14.5239|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-03 22:06:14.5275|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-03 22:06:14.5275|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-05-03 22:06:14.5544|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-05-03 22:06:14.6336|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-05-03 22:06:14.6336|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2023-05-03 22:06:14.6400|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {94a7396b-8247-4b69-b9af-5118e04e0e31} with creation date 2023-05-03 21:06:14Z, activation date 2023-05-03 21:06:14Z, and expiration date 2023-08-01 21:06:14Z. 2023-05-03 22:06:14.6400|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {94a7396b-8247-4b69-b9af-5118e04e0e31} may be persisted to storage in unencrypted form. 2023-05-03 22:06:14.9252|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 22:06:14.9626|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 22:06:14.9670|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 42.2308ms 204 2023-05-03 22:06:15.5313|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 22:06:15.6243|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 22:06:15.6243|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 22:06:15.6243|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 22:06:15.6626|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 22:06:15.6626|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 22:06:15.8219|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 22:06:15.8515|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 186.5328ms 2023-05-03 22:06:15.8515|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 22:06:15.8515|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 322.7011ms 200 application/json; charset=utf-8 2023-05-03 22:06:23.5712|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 22:06:23.5742|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 22:06:23.5742|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3.9213ms 204 2023-05-03 22:06:23.8616|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=null&IsActive=true 2023-05-03 22:06:23.8616|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 22:06:23.8616|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 22:06:23.8616|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 22:06:23.8616|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 22:06:23.8893|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 22:06:23.8893|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 22:06:23.8893|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 30.801ms 2023-05-03 22:06:23.8893|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 22:06:23.8893|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 36.0052ms 200 application/json; charset=utf-8 2023-05-03 22:06:24.3713|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 22:06:24.3729|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 22:06:24.3729|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.3939ms 204 2023-05-03 22:06:24.7729|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=50&Id=93&IsActive=true 2023-05-03 22:06:24.7729|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 22:06:24.7729|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 22:06:24.7729|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 22:06:24.7729|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 22:06:24.7781|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 22:06:24.7781|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 22:06:24.7781|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 7.7382ms 2023-05-03 22:06:24.7781|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 22:06:24.7781|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.756ms 200 application/json; charset=utf-8 2023-05-03 22:25:58.3690|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 22:25:58.3690|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 22:25:58.3690|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.3691ms 204 2023-05-03 22:25:58.7112|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2023-05-03 22:25:58.7112|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 22:25:58.7112|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 22:25:58.7112|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 22:25:58.7112|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 2023-05-03 22:25:58.7112|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 22:25:58.7232|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2023-05-03 22:25:58.7232|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 8.9319ms 2023-05-03 22:25:58.7232|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2023-05-03 22:25:58.7232|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 13.623ms 200 application/json; charset=utf-8 2023-05-03 22:30:13.4718|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10621&institutionId=93 2023-05-03 22:30:13.4718|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 22:30:13.4718|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.0339ms 204 2023-05-03 22:30:14.4198|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10621&institutionId=93 2023-05-03 22:30:14.4198|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 22:30:14.4198|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 22:30:14.4198|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2023-05-03 22:30:14.4198|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 22:30:14.4332|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 2023-05-03 22:30:14.4332|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 22:30:14.6058|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (26ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId] FROM [CertificateLogs] AS [c] WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 2023-05-03 22:30:14.7275|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [i].[Id], [i].[AccountNumber], [i].[Address], [i].[BankId], [i].[BannerUrl], [i].[CertificateLogoUrl], [i].[Code], [i].[Country], [i].[CreatedBy], [i].[DateCreated], [i].[DateModified], [i].[Email], [i].[FullName], [i].[InstitutionType], [i].[IsActive], [i].[IsDeleted], [i].[LogoUrl], [i].[ModifiedBy], [i].[Name], [i].[OverView], [i].[Phonenumber], [i].[ThumbnailUrl], [i].[Website] FROM [Institution] AS [i] WHERE [i].[Id] = @__institutionId_0 2023-05-03 22:30:14.8476|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [CertificateLogs] ([CertificateId], [CourseId], [CreatedBy], [DateCreated], [DateModified], [DownloadDate], [InstitutionCode], [IsActive], [IsDeleted], [ModifiedBy], [UserId]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10); SELECT [Id] FROM [CertificateLogs] WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 2023-05-03 22:30:14.8891||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2023-05-03 22:30:14.8891|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template] FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0 2023-05-03 22:30:18.0271|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-03 22:30:18.0584|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 3624.9032ms 2023-05-03 22:30:18.0587|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 22:30:18.0587|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3639.4005ms 200 application/json; charset=utf-8 2023-05-03 22:31:04.2878|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10621&institutionId=93 2023-05-03 22:31:04.2878|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 22:31:04.2900|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.1578ms 204 2023-05-03 22:31:04.5997|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10621&institutionId=93 2023-05-03 22:31:04.5997|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 22:31:04.5997|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 22:31:04.5997|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2023-05-03 22:31:04.5997|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 22:31:04.5997|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 2023-05-03 22:31:04.6048|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 22:31:04.6048|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId] FROM [CertificateLogs] AS [c] WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 2023-05-03 22:31:04.6265|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10 WHERE [Id] = @p11; SELECT @@ROWCOUNT; 2023-05-03 22:31:04.6366||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2023-05-03 22:31:04.6366|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template] FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0 2023-05-03 22:31:07.3189|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-03 22:31:07.3416|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2737.9158ms 2023-05-03 22:31:07.3416|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 22:31:07.3416|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2742.5306ms 200 application/json; charset=utf-8 2023-05-03 22:35:02.6621|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10621&institutionId=93 2023-05-03 22:35:02.6621|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 22:35:02.6621|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.3394ms 204 2023-05-03 22:35:02.9329|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=260&userId=10621&institutionId=93 2023-05-03 22:35:02.9329|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2023-05-03 22:35:02.9329|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-03 22:35:02.9329|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2023-05-03 22:35:02.9329|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 22:35:02.9329|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 2023-05-03 22:35:02.9329|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2023-05-03 22:35:02.9329|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId] FROM [CertificateLogs] AS [c] WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 2023-05-03 22:35:02.9494|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10 WHERE [Id] = @p11; SELECT @@ROWCOUNT; 2023-05-03 22:35:02.9494||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2023-05-03 22:35:02.9494|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template] FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0 2023-05-03 22:35:05.6191|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-03 22:35:05.6433|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2707.3117ms 2023-05-03 22:35:05.6433|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2023-05-03 22:35:05.6433|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2711.0797ms 200 application/json; charset=utf-8 2023-05-03 22:55:26.4204|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:39529/INSTITUTION/iisintegration 0 2023-05-03 22:55:26.4204|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.5714ms 202