2025-10-17 00:00:31.4518||DEBUG|InstitutionService.Program|init main function 
2025-10-17 00:00:33.5400|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 00:00:33.9975|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-10-17 00:00:34.0157|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-10-17 00:00:34.0157|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-10-17 00:00:34.0157|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-10-17 00:00:34.0377|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-10-17 00:00:34.0495|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-10-17 00:00:34.5743|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2025-10-17 00:00:34.5743|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. 
2025-10-17 00:00:34.5830|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {bedfaa1a-1ade-4373-a7f0-b7948350cfb9} with creation date 2025-10-16 23:00:34Z, activation date 2025-10-16 23:00:34Z, and expiration date 2026-01-14 23:00:34Z. 
2025-10-17 00:00:34.5830|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {bedfaa1a-1ade-4373-a7f0-b7948350cfb9} may be persisted to storage in unencrypted form. 
2025-10-17 00:00:34.7867|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   
2025-10-17 00:00:35.3759|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 00:00:35.3759|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 00:00:35.4059|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). 
2025-10-17 00:00:35.4091|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 00:00:35.6544|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]]'. 
2025-10-17 00:00:35.7271|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 318.6003ms 
2025-10-17 00:00:35.7271|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 00:00:35.7271|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 945.2288ms 200 application/json; charset=utf-8 
2025-10-17 00:00:36.4011|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   
2025-10-17 00:00:36.4056|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 00:00:36.4056|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 00:00:36.4056|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). 
2025-10-17 00:00:36.4363|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 00:00:36.4363|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]]'. 
2025-10-17 00:00:36.4363|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 35.2913ms 
2025-10-17 00:00:36.4363|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 00:00:36.4363|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 42.6936ms 200 application/json; charset=utf-8 
2025-10-17 00:21:30.8994|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:13759/INSTITUTION/iisintegration  0 
2025-10-17 00:21:30.8994|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1716ms 202  
2025-10-17 04:27:43.2372||DEBUG|InstitutionService.Program|init main function 
2025-10-17 04:27:43.9588|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 04:27:44.1269|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (16ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-10-17 04:27:44.1475|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-10-17 04:27:44.1475|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-10-17 04:27:44.1475|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-10-17 04:27:44.1651|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-10-17 04:27:44.1767|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-10-17 04:27:44.2531|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2025-10-17 04:27:44.2531|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. 
2025-10-17 04:27:44.2531|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {c0bcee62-6ebf-4140-bb2c-aa80a04cfbc3} with creation date 2025-10-17 03:27:44Z, activation date 2025-10-17 03:27:44Z, and expiration date 2026-01-15 03:27:44Z. 
2025-10-17 04:27:44.2673|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {c0bcee62-6ebf-4140-bb2c-aa80a04cfbc3} may be persisted to storage in unencrypted form. 
2025-10-17 04:27:44.5332|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=113&IsActive=true   
2025-10-17 04:27:44.5694|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 04:27:44.5694|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 04:27:44.6018|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). 
2025-10-17 04:27:44.6018|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 04:27:44.7689|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]]'. 
2025-10-17 04:27:44.8396|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 235.276ms 
2025-10-17 04:27:44.8396|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 04:27:44.8431|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 310.3899ms 200 application/json; charset=utf-8 
2025-10-17 04:48:35.8819|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:25441/INSTITUTION/iisintegration  0 
2025-10-17 04:48:35.8819|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1274ms 202  
2025-10-17 11:39:54.2019||DEBUG|InstitutionService.Program|init main function 
2025-10-17 11:39:57.8307|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 11:39:58.2747|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-10-17 11:39:58.2747|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-10-17 11:39:58.2962|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-10-17 11:39:58.2962|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-10-17 11:39:58.3116|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-10-17 11:39:58.3116|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-10-17 11:39:58.9192|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2025-10-17 11:39:58.9192|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. 
2025-10-17 11:39:58.9192|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {ce4a63a8-fa4f-46a4-9d06-e6e7decc46e7} with creation date 2025-10-17 10:39:58Z, activation date 2025-10-17 10:39:58Z, and expiration date 2026-01-15 10:39:58Z. 
2025-10-17 11:39:58.9332|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {ce4a63a8-fa4f-46a4-9d06-e6e7decc46e7} may be persisted to storage in unencrypted form. 
2025-10-17 11:39:59.2162|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000   
2025-10-17 11:39:59.7577|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 11:39:59.7618|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 546.0511ms 204  
2025-10-17 11:39:59.9250|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000   
2025-10-17 11:40:00.1519|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 11:40:00.1519|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 11:40:00.1519|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 11:40:00.1896|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). 
2025-10-17 11:40:00.1896|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 11:40:00.4388|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]]'. 
2025-10-17 11:40:00.4695|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 277.1466ms 
2025-10-17 11:40:00.4695|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 11:40:00.4695|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 547.0705ms 200 application/json; charset=utf-8 
2025-10-17 11:40:09.8495|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   
2025-10-17 11:40:09.8495|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 11:40:09.8552|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.8029ms 204  
2025-10-17 11:40:10.0146|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   
2025-10-17 11:40:10.0146|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 11:40:10.0146|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 11:40:10.0146|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 11:40:10.0146|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). 
2025-10-17 11:40:10.0420|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 11:40:10.0420|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]]'. 
2025-10-17 11:40:10.0420|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 32.1254ms 
2025-10-17 11:40:10.0420|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 11:40:10.0420|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 36.0548ms 200 application/json; charset=utf-8 
2025-10-17 11:40:10.4094|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   
2025-10-17 11:40:10.4094|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 11:40:10.4094|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.3614ms 204  
2025-10-17 11:40:10.5712|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   
2025-10-17 11:40:10.5712|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 11:40:10.5743|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 11:40:10.5743|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 11:40:10.5743|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). 
2025-10-17 11:40:10.5743|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 11:40:10.5743|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]]'. 
2025-10-17 11:40:10.5743|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 8.4104ms 
2025-10-17 11:40:10.5743|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 11:40:10.5743|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 13.5876ms 200 application/json; charset=utf-8 
2025-10-17 11:40:13.7140|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   
2025-10-17 11:40:13.7172|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 11:40:13.7172|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 11:40:13.7172|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 11:40:13.7172|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). 
2025-10-17 11:40:13.7172|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 11:40:13.7172|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]]'. 
2025-10-17 11:40:13.7172|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 4.3168ms 
2025-10-17 11:40:13.7172|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 11:40:13.7172|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 10.9917ms 200 application/json; charset=utf-8 
2025-10-17 11:41:13.8626|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 11:41:13.8626|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 11:41:13.8626|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.1304ms 204  
2025-10-17 11:41:14.0242|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 11:41:14.0257|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 11:41:14.0257|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 11:41:14.0257|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-10-17 11:41:14.0257|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 11:41:14.0257|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). 
2025-10-17 11:41:14.0403|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 11:41:14.2106|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (32ms) [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) 
2025-10-17 11:41:14.3235|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [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; 
2025-10-17 11:41:14.3629||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-10-17 11:41:14.3881|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [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 
2025-10-17 11:41:18.4906|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-10-17 11:41:18.5231|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 4484.6444ms 
2025-10-17 11:41:18.5231|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 11:41:18.5231|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4499.8034ms 200 application/json; charset=utf-8 
2025-10-17 11:41:30.0703|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 11:41:30.0703|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 11:41:30.0703|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.9002ms 204  
2025-10-17 11:41:30.2319|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 11:41:30.2319|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 11:41:30.2319|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 11:41:30.2319|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-10-17 11:41:30.2319|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 11:41:30.2319|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). 
2025-10-17 11:41:30.2319|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 11:41:30.2436|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) 
2025-10-17 11:41:30.2436|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; 
2025-10-17 11:41:30.2436||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-10-17 11:41:30.2436|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 
2025-10-17 11:41:32.9366|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-10-17 11:41:32.9614|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2725.1663ms 
2025-10-17 11:41:32.9614|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 11:41:32.9614|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2730.4667ms 200 application/json; charset=utf-8 
2025-10-17 11:47:08.7604|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 11:47:08.7604|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 11:47:08.7604|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.3371ms 204  
2025-10-17 11:47:08.9201|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 11:47:08.9201|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 11:47:08.9201|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 11:47:08.9201|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-10-17 11:47:08.9201|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 11:47:08.9201|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). 
2025-10-17 11:47:08.9256|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 11:47:08.9256|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) 
2025-10-17 11:47:08.9256|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; 
2025-10-17 11:47:08.9447||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-10-17 11:47:08.9447|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 
2025-10-17 11:47:11.6286|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-10-17 11:47:11.6540|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2730.5598ms 
2025-10-17 11:47:11.6540|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 11:47:11.6540|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2734.5181ms 200 application/json; charset=utf-8 
2025-10-17 11:47:28.6066|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 11:47:28.6066|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 11:47:28.6066|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.5848ms 204  
2025-10-17 11:47:28.7704|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 11:47:28.7704|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 11:47:28.7704|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 11:47:28.7704|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-10-17 11:47:28.7704|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 11:47:28.7704|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). 
2025-10-17 11:47:28.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  
2025-10-17 11:47:28.7704|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) 
2025-10-17 11:47:28.7704|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; 
2025-10-17 11:47:28.7920||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-10-17 11:47:28.7920|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 
2025-10-17 11:47:31.4582|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-10-17 11:47:31.4816|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2707.4686ms 
2025-10-17 11:47:31.4816|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 11:47:31.4816|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2711.9253ms 200 application/json; charset=utf-8 
2025-10-17 12:20:50.8363|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:26290/INSTITUTION/iisintegration  0 
2025-10-17 12:20:50.8363|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.5977ms 202  
2025-10-17 13:30:54.0701||DEBUG|InstitutionService.Program|init main function 
2025-10-17 13:30:54.8015|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 13:30:54.9627|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-10-17 13:30:54.9804|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-10-17 13:30:54.9804|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-10-17 13:30:54.9804|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-10-17 13:30:54.9979|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-10-17 13:30:55.0094|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-10-17 13:30:55.0842|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2025-10-17 13:30:55.0842|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. 
2025-10-17 13:30:55.0842|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {6273fece-262b-4c2c-bb00-3f8d04bdd928} with creation date 2025-10-17 12:30:55Z, activation date 2025-10-17 12:30:55Z, and expiration date 2026-01-15 12:30:55Z. 
2025-10-17 13:30:55.0991|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {6273fece-262b-4c2c-bb00-3f8d04bdd928} may be persisted to storage in unencrypted form. 
2025-10-17 13:30:55.3790|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 13:30:55.4148|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 13:30:55.4148|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 40.108ms 204  
2025-10-17 13:30:55.5950|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 13:30:55.6830|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 13:30:55.6860|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 13:30:55.6860|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-10-17 13:30:55.6860|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 13:30:55.7157|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). 
2025-10-17 13:30:55.7190|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 13:30:55.8861|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (28ms) [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) 
2025-10-17 13:30:55.9927|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [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; 
2025-10-17 13:30:56.1620||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-10-17 13:30:56.1765|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 
2025-10-17 13:30:59.4038|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-10-17 13:30:59.4551|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 3736.9964ms 
2025-10-17 13:30:59.4551|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 13:30:59.4551|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3862.6841ms 200 application/json; charset=utf-8 
2025-10-17 13:51:53.8304|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:14450/INSTITUTION/iisintegration  0 
2025-10-17 13:51:53.8304|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0571ms 202  
2025-10-17 15:21:28.2687||DEBUG|InstitutionService.Program|init main function 
2025-10-17 15:21:31.0577|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 15:21:31.5212|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-10-17 15:21:31.5392|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-10-17 15:21:31.5392|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-10-17 15:21:31.5392|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-10-17 15:21:31.5392|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-10-17 15:21:31.5689|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-10-17 15:21:32.0818|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2025-10-17 15:21:32.0818|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. 
2025-10-17 15:21:32.0890|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {3d9735d0-ed6d-4239-85d8-691178175ca2} with creation date 2025-10-17 14:21:32Z, activation date 2025-10-17 14:21:32Z, and expiration date 2026-01-15 14:21:32Z. 
2025-10-17 15:21:32.0890|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {3d9735d0-ed6d-4239-85d8-691178175ca2} may be persisted to storage in unencrypted form. 
2025-10-17 15:21:32.3335|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 15:21:32.8941|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:21:32.8941|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 565.8562ms 204  
2025-10-17 15:21:33.0606|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 15:21:33.2808|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 15:21:33.2808|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:21:33.2808|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-10-17 15:21:33.2889|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 15:21:33.3145|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). 
2025-10-17 15:21:33.3145|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 15:21:33.4894|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (28ms) [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) 
2025-10-17 15:21:33.5998|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [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; 
2025-10-17 15:21:33.8512||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-10-17 15:21:33.8658|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 
2025-10-17 15:21:37.2346|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-10-17 15:21:37.2862|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 3969.2554ms 
2025-10-17 15:21:37.2862|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 15:21:37.2862|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4228.0823ms 200 application/json; charset=utf-8 
2025-10-17 15:24:50.6527|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 15:24:50.6527|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:24:50.6527|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.2996ms 204  
2025-10-17 15:24:50.8122|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 15:24:50.8122|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 15:24:50.8122|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:24:50.8122|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-10-17 15:24:50.8122|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 15:24:50.8161|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). 
2025-10-17 15:24:50.8399|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 15:24:50.8399|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) 
2025-10-17 15:24:50.8399|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; 
2025-10-17 15:24:50.8561||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-10-17 15:24:50.8561|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 
2025-10-17 15:24:53.6124|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-10-17 15:24:53.6218|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000   
2025-10-17 15:24:53.6218|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:24:53.6218|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.5991ms 204  
2025-10-17 15:24:53.6502|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2833.9683ms 
2025-10-17 15:24:53.6502|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 15:24:53.6502|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2838.962ms 200 application/json; charset=utf-8 
2025-10-17 15:24:53.7831|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000   
2025-10-17 15:24:53.7856|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 15:24:53.7856|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:24:53.7856|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:24:53.7856|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). 
2025-10-17 15:24:53.7856|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 15:24:53.8177|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]]'. 
2025-10-17 15:24:53.8279|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 31.9912ms 
2025-10-17 15:24:53.8279|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:24:53.8279|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 45.5018ms 200 application/json; charset=utf-8 
2025-10-17 15:25:01.0105|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000   
2025-10-17 15:25:01.0105|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:25:01.0105|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.9411ms 204  
2025-10-17 15:25:01.1727|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000   
2025-10-17 15:25:01.1727|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 15:25:01.1727|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:25:01.1727|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:25:01.1727|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). 
2025-10-17 15:25:01.1727|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 15:25:01.1808|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]]'. 
2025-10-17 15:25:01.1808|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 6.0572ms 
2025-10-17 15:25:01.1808|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:25:01.1808|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.5944ms 200 application/json; charset=utf-8 
2025-10-17 15:25:10.9436|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   
2025-10-17 15:25:10.9451|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:25:10.9451|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.5501ms 204  
2025-10-17 15:25:11.1016|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   
2025-10-17 15:25:11.1016|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 15:25:11.1016|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:25:11.1016|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:25:11.1016|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). 
2025-10-17 15:25:11.1016|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 15:25:11.1156|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]]'. 
2025-10-17 15:25:11.1156|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 11.9141ms 
2025-10-17 15:25:11.1156|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:25:11.1156|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 15.4695ms 200 application/json; charset=utf-8 
2025-10-17 15:25:11.4418|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   
2025-10-17 15:25:11.4430|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:25:11.4430|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.0394ms 204  
2025-10-17 15:25:11.6011|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   
2025-10-17 15:25:11.6011|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 15:25:11.6011|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:25:11.6011|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:25:11.6011|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). 
2025-10-17 15:25:11.6011|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 15:25:11.6011|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]]'. 
2025-10-17 15:25:11.6011|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 8.8561ms 
2025-10-17 15:25:11.6011|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:25:11.6152|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 14.1229ms 200 application/json; charset=utf-8 
2025-10-17 15:25:17.9885|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   
2025-10-17 15:25:17.9885|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:25:17.9885|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.7493ms 204  
2025-10-17 15:25:18.1468|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   
2025-10-17 15:25:18.1468|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 15:25:18.1468|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:25:18.1468|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:25:18.1468|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). 
2025-10-17 15:25:18.1468|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 15:25:18.1468|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]]'. 
2025-10-17 15:25:18.1595|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 9.5616ms 
2025-10-17 15:25:18.1595|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:25:18.1595|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 13.2003ms 200 application/json; charset=utf-8 
2025-10-17 15:25:18.6487|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   
2025-10-17 15:25:18.6487|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:25:18.6487|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.5047ms 204  
2025-10-17 15:25:18.8062|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   
2025-10-17 15:25:18.8062|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 15:25:18.8062|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:25:18.8062|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:25:18.8062|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). 
2025-10-17 15:25:18.8062|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 15:25:18.8062|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]]'. 
2025-10-17 15:25:18.8062|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 7.0395ms 
2025-10-17 15:25:18.8062|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:25:18.8062|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 10.8745ms 200 application/json; charset=utf-8 
2025-10-17 15:27:08.7232|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 15:27:08.7241|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:27:08.7241|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.3017ms 204  
2025-10-17 15:27:08.8900|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 15:27:08.8900|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 15:27:08.8900|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:27:08.8900|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-10-17 15:27:08.8900|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 15:27:08.8900|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). 
2025-10-17 15:27:08.8958|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 15:27:08.8958|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) 
2025-10-17 15:27:08.8958|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; 
2025-10-17 15:27:08.8958||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-10-17 15:27:08.8958|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 
2025-10-17 15:27:11.6541|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-10-17 15:27:11.6823|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2789.026ms 
2025-10-17 15:27:11.6823|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 15:27:11.6823|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2792.9616ms 200 application/json; charset=utf-8 
2025-10-17 15:28:20.3480|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 15:28:20.3480|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:28:20.3480|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.2407ms 204  
2025-10-17 15:28:20.5052|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-10-17 15:28:20.5052|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 15:28:20.5052|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:28:20.5052|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-10-17 15:28:20.5052|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 15:28:20.5052|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). 
2025-10-17 15:28:20.5052|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 15:28:20.5052|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) 
2025-10-17 15:28:20.5194|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; 
2025-10-17 15:28:20.5194||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-10-17 15:28:20.5194|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 
2025-10-17 15:28:23.2839|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-10-17 15:28:23.3085|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2799.6644ms 
2025-10-17 15:28:23.3085|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-10-17 15:28:23.3085|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2804.055ms 200 application/json; charset=utf-8 
2025-10-17 15:28:24.5288|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000   
2025-10-17 15:28:24.5288|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:28:24.5288|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.2807ms 204  
2025-10-17 15:28:24.6895|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000   
2025-10-17 15:28:24.6910|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-17 15:28:24.6910|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:28:24.6910|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:28:24.6910|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). 
2025-10-17 15:28:24.6910|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 15:28:24.6910|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]]'. 
2025-10-17 15:28:24.6910|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 6.0826ms 
2025-10-17 15:28:24.6910|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:28:24.6910|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.8116ms 200 application/json; charset=utf-8 
2025-10-17 15:42:30.5477|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000   
2025-10-17 15:42:30.5477|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:42:30.5477|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:42:30.5477|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). 
2025-10-17 15:42:30.5477|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 15:42:30.5477|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]]'. 
2025-10-17 15:42:30.5586|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 8.8689ms 
2025-10-17 15:42:30.5586|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:42:30.5586|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.3576ms 200 application/json; charset=utf-8 
2025-10-17 15:44:16.7918|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000   
2025-10-17 15:44:16.7918|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:44:16.7918|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:44:16.7918|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). 
2025-10-17 15:44:16.7918|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 15:44:16.7918|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]]'. 
2025-10-17 15:44:16.7918|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 5.4105ms 
2025-10-17 15:44:16.7918|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:44:16.7918|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7.9836ms 200 application/json; charset=utf-8 
2025-10-17 15:44:40.3497|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   
2025-10-17 15:44:40.3504|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:44:40.3504|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:44:40.3504|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). 
2025-10-17 15:44:40.3504|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 15:44:40.3504|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]]'. 
2025-10-17 15:44:40.3504|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 5.1308ms 
2025-10-17 15:44:40.3504|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:44:40.3504|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7.4498ms 200 application/json; charset=utf-8 
2025-10-17 15:44:41.2820|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   
2025-10-17 15:44:41.2820|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 15:44:41.2820|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:44:41.2820|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). 
2025-10-17 15:44:41.2820|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 15:44:41.2820|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]]'. 
2025-10-17 15:44:41.2820|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 3.7196ms 
2025-10-17 15:44:41.2820|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 15:44:41.2820|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.8639ms 200 application/json; charset=utf-8 
2025-10-17 16:20:27.6935|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:16779/INSTITUTION/iisintegration  0 
2025-10-17 16:20:27.6935|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.5069ms 202  
2025-10-17 19:50:03.7474||DEBUG|InstitutionService.Program|init main function 
2025-10-17 19:50:06.3796|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 19:50:06.8363|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-10-17 19:50:06.8546|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-10-17 19:50:06.8577|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-10-17 19:50:06.8577|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-10-17 19:50:06.8750|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-10-17 19:50:06.8913|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-10-17 19:50:07.5115|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2025-10-17 19:50:07.5115|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. 
2025-10-17 19:50:07.5115|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {0bc047d5-9dba-4086-9264-d68ac245505c} with creation date 2025-10-17 18:50:07Z, activation date 2025-10-17 18:50:07Z, and expiration date 2026-01-15 18:50:07Z. 
2025-10-17 19:50:07.5275|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {0bc047d5-9dba-4086-9264-d68ac245505c} may be persisted to storage in unencrypted form. 
2025-10-17 19:50:07.7813|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   
2025-10-17 19:50:08.3750|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-17 19:50:08.3750|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 19:50:08.4045|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). 
2025-10-17 19:50:08.4045|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-17 19:50:08.6592|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]]'. 
2025-10-17 19:50:08.7297|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 322.5935ms 
2025-10-17 19:50:08.7297|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-10-17 19:50:08.7345|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 953.619ms 200 application/json; charset=utf-8 
2025-10-17 20:21:04.4825|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:46171/INSTITUTION/iisintegration  0 
2025-10-17 20:21:04.4825|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1663ms 202