2025-08-26 10:07:17.9037||DEBUG|InstitutionService.Program|init main function 
2025-08-26 10:07:21.2732|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-08-26 10:07:21.7225|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-08-26 10:07:21.7406|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-08-26 10:07:21.7406|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-08-26 10:07:21.7406|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-08-26 10:07:21.7608|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-08-26 10:07:21.7727|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-08-26 10:07:22.2450|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2025-08-26 10:07:22.2450|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-08-26 10:07:22.2450|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {18437d62-cd62-4612-a321-cec077c250a1} with creation date 2025-08-26 09:07:22Z, activation date 2025-08-26 09:07:22Z, and expiration date 2025-11-24 09:07:22Z. 
2025-08-26 10:07:22.2575|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {18437d62-cd62-4612-a321-cec077c250a1} may be persisted to storage in unencrypted form. 
2025-08-26 10:07:22.5284|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-08-26 10:07:23.0371|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 10:07:23.0402|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 10:07:23.0667|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-08-26 10:07:23.0697|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-08-26 10:07:23.3031|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-08-26 10:07:23.3755|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 306.2372ms 
2025-08-26 10:07:23.3755|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 10:07:23.3792|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 851.3378ms 200 application/json; charset=utf-8 
2025-08-26 10:34:07.2123|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:26385/INSTITUTION/iisintegration  0 
2025-08-26 10:34:07.2123|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1072ms 202  
2025-08-26 13:45:54.1140||DEBUG|InstitutionService.Program|init main function 
2025-08-26 13:45:54.8654|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-08-26 13:45:55.0280|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-08-26 13:45:55.0458|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-08-26 13:45:55.0486|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-08-26 13:45:55.0486|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-08-26 13:45:55.0640|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-08-26 13:45:55.0640|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-08-26 13:45:55.1536|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2025-08-26 13:45:55.1536|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-08-26 13:45:55.1607|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {61fc4eea-3fb6-4d53-950f-cab68ba15dd7} with creation date 2025-08-26 12:45:55Z, activation date 2025-08-26 12:45:55Z, and expiration date 2025-11-24 12:45:55Z. 
2025-08-26 13:45:55.1607|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {61fc4eea-3fb6-4d53-950f-cab68ba15dd7} may be persisted to storage in unencrypted form. 
2025-08-26 13:45:55.4161|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-08-26 13:45:55.4599|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 13:45:55.4599|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 13:45:55.4928|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-08-26 13:45:55.4928|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-08-26 13:45:55.6718|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-08-26 13:45:55.7854|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 289.4646ms 
2025-08-26 13:45:55.7854|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 13:45:55.7854|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 374.0093ms 200 application/json; charset=utf-8 
2025-08-26 14:20:40.1795|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:22432/INSTITUTION/iisintegration  0 
2025-08-26 14:20:40.1795|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1066ms 202  
2025-08-26 20:24:13.7335||DEBUG|InstitutionService.Program|init main function 
2025-08-26 20:24:15.7615|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-08-26 20:24:16.1942|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-08-26 20:24:16.2124|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-08-26 20:24:16.2124|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-08-26 20:24:16.2124|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-08-26 20:24:16.2308|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-08-26 20:24:16.2427|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-08-26 20:24:16.7138|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2025-08-26 20:24:16.7138|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-08-26 20:24:16.7241|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {e266cba5-4ca0-4707-b6bf-22940f0b878a} with creation date 2025-08-26 19:24:16Z, activation date 2025-08-26 19:24:16Z, and expiration date 2025-11-24 19:24:16Z. 
2025-08-26 20:24:16.7241|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {e266cba5-4ca0-4707-b6bf-22940f0b878a} may be persisted to storage in unencrypted form. 
2025-08-26 20:24:16.8104|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-08-26 20:24:17.3138|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 20:24:17.3138|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 508.1547ms 204  
2025-08-26 20:56:19.8089|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-08-26 20:56:19.8089|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 20:56:19.8089|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 20:56:19.8440|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-08-26 20:56:19.8440|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-08-26 20:56:20.0912|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-08-26 20:56:20.1625|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 315.815ms 
2025-08-26 20:56:20.1632|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 20:56:20.1632|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 356.3123ms 200 application/json; charset=utf-8 
2025-08-26 20:56:37.5193|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-08-26 20:56:37.5193|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 20:56:37.5193|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 20:56:37.5193|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-08-26 20:56:37.5493|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-08-26 20:56:37.5493|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-08-26 20:56:37.5579|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 33.6911ms 
2025-08-26 20:56:37.5579|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 20:56:37.5579|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 39.4962ms 200 application/json; charset=utf-8 
2025-08-26 20:56:37.8362|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-08-26 20:56:37.8362|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 20:56:37.8362|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 20:56:37.8390|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-08-26 20:56:37.8390|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-08-26 20:56:37.8390|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-08-26 20:56:37.8390|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 14.2623ms 
2025-08-26 20:56:37.8390|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 20:56:37.8390|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 18.5483ms 200 application/json; charset=utf-8 
2025-08-26 20:57:03.0366|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-08-26 20:57:03.0366|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 20:57:03.0366|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 20:57:03.0366|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-08-26 20:57:03.0366|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-08-26 20:57:03.0436|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-08-26 20:57:03.0436|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 5.3272ms 
2025-08-26 20:57:03.0436|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 20:57:03.0436|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.806ms 200 application/json; charset=utf-8 
2025-08-26 20:57:44.1049|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-08-26 20:57:44.1049|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 20:57:44.1049|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 20:57:44.1049|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-08-26 20:57:44.1049|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-08-26 20:57:44.1049|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-08-26 20:57:44.1049|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 6.7752ms 
2025-08-26 20:57:44.1156|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 20:57:44.1156|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.074ms 200 application/json; charset=utf-8 
2025-08-26 20:57:44.4993|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-08-26 20:57:44.4993|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 20:57:44.4993|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 20:57:44.4993|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-08-26 20:57:44.4993|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-08-26 20:57:44.4993|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-08-26 20:57:44.5075|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 5.4546ms 
2025-08-26 20:57:44.5075|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 20:57:44.5075|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.035ms 200 application/json; charset=utf-8 
2025-08-26 20:57:45.0080|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-08-26 20:57:45.0080|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 20:57:45.0080|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 20:57:45.0080|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-08-26 20:57:45.0080|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-08-26 20:57:45.0080|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-08-26 20:57:45.0080|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 7.9817ms 
2025-08-26 20:57:45.0080|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 20:57:45.0080|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 10.6809ms 200 application/json; charset=utf-8 
2025-08-26 21:09:52.9901|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-08-26 21:09:52.9901|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:09:52.9901|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 21:09:52.9901|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-08-26 21:09:52.9901|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-08-26 21:09:52.9993|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-08-26 21:09:52.9993|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 7.9142ms 
2025-08-26 21:09:52.9993|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 21:09:52.9993|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 10.5657ms 200 application/json; charset=utf-8 
2025-08-26 21:09:56.7682|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-08-26 21:09:56.7682|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:09:56.7682|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 21:09:56.7682|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-08-26 21:09:56.7682|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-08-26 21:09:56.7682|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-08-26 21:09:56.7682|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 9.6867ms 
2025-08-26 21:09:56.7682|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 21:09:56.7682|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 12.8985ms 200 application/json; charset=utf-8 
2025-08-26 21:09:57.3335|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=114&IsActive=true   
2025-08-26 21:09:57.3335|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:09:57.3335|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 21:09:57.3335|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-08-26 21:09:57.3335|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-08-26 21:09:57.3335|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-08-26 21:09:57.3335|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 4.2629ms 
2025-08-26 21:09:57.3335|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 21:09:57.3335|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6.7597ms 200 application/json; charset=utf-8 
2025-08-26 21:09:58.5655|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Countries   
2025-08-26 21:09:58.5655|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:09:58.5655|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.Countries (InstitutionService)' 
2025-08-26 21:09:58.5655|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "Countries", controller = "Institution"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult Countries(System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 
2025-08-26 21:09:58.5655|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-08-26 21:09:58.6630|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (7ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [c].[Id], [c].[Code1], [c].[Code2], [c].[CountryName]
FROM [Countries] AS [c] 
2025-08-26 21:09:58.6975|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Entity.Countries, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-08-26 21:09:58.7021|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.Countries (InstitutionService) in 132.0219ms 
2025-08-26 21:09:58.7021|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.Countries (InstitutionService)' 
2025-08-26 21:09:58.7021|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 137.2754ms 200 application/json; charset=utf-8 
2025-08-26 21:12:56.5150|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-08-26 21:12:56.5159|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:12:56.5159|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.4217ms 204  
2025-08-26 21:12:56.8022|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-08-26 21:12:56.9690|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-08-26 21:12:56.9690|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:12:56.9690|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 21:12:56.9690|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-08-26 21:12:56.9690|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-08-26 21:12:56.9690|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-08-26 21:12:56.9690|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 4.552ms 
2025-08-26 21:12:56.9690|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-26 21:12:56.9690|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 173.6956ms 200 application/json; charset=utf-8 
2025-08-26 21:13:30.2367|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-08-26 21:13:30.2367|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:13:30.2367|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.5501ms 204  
2025-08-26 21:13:30.5143|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-08-26 21:13:30.5143|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-08-26 21:13:30.5143|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:13:30.5143|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-08-26 21:13:30.5143|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-26 21:13:30.5143|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-08-26 21:13:30.5143|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-08-26 21:13:30.6235|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (34ms) [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-08-26 21:13:30.7192|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-08-26 21:13:30.7588||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-08-26 21:13:30.7815|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-08-26 21:13:57.7104|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-08-26 21:13:57.7426|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 27218.1343ms 
2025-08-26 21:13:57.7426|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-26 21:13:57.7426|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 27229.0539ms 200 application/json; charset=utf-8 
2025-08-26 21:14:02.0694|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-08-26 21:14:02.0694|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:14:02.0694|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.2444ms 204  
2025-08-26 21:14:02.3674|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-08-26 21:14:02.3674|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-08-26 21:14:02.3674|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:14:02.3674|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-08-26 21:14:02.3674|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-26 21:14:02.3674|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-08-26 21:14:02.3674|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-08-26 21:14:02.3773|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-08-26 21:14:02.3773|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-08-26 21:14:02.3773||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-08-26 21:14:02.3773|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-08-26 21:14:05.0622|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-08-26 21:14:05.0861|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2715.4723ms 
2025-08-26 21:14:05.0861|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-26 21:14:05.0861|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2719.291ms 200 application/json; charset=utf-8 
2025-08-26 21:14:15.6729|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-08-26 21:14:15.6729|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:14:15.6729|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1742ms 204  
2025-08-26 21:14:15.9659|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-08-26 21:14:15.9659|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-08-26 21:14:15.9659|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:14:15.9659|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-08-26 21:14:15.9659|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-26 21:14:15.9659|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-08-26 21:14:15.9659|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-08-26 21:14:15.9659|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-08-26 21:14:15.9659|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-08-26 21:14:15.9854||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-08-26 21:14:15.9854|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-08-26 21:14:18.6751|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-08-26 21:14:18.7052|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2735.7099ms 
2025-08-26 21:14:18.7052|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-26 21:14:18.7052|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2739.8901ms 200 application/json; charset=utf-8 
2025-08-26 21:14:49.3528|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-08-26 21:14:49.3528|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:14:49.3528|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.2303ms 204  
2025-08-26 21:14:49.6417|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-08-26 21:14:49.6417|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-08-26 21:14:49.6417|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:14:49.6417|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-08-26 21:14:49.6417|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-26 21:14:49.6417|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-08-26 21:14:49.6417|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-08-26 21:14:49.6417|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-08-26 21:14:49.6417|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-08-26 21:14:49.6559||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-08-26 21:14:49.6559|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-08-26 21:14:52.3297|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-08-26 21:14:52.3530|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2708.4647ms 
2025-08-26 21:14:52.3530|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-26 21:14:52.3530|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2711.9057ms 200 application/json; charset=utf-8 
2025-08-26 21:17:51.9230|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-08-26 21:17:51.9230|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:17:51.9230|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1712ms 204  
2025-08-26 21:17:52.2162|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-08-26 21:17:52.2162|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-08-26 21:17:52.2162|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:17:52.2162|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-08-26 21:17:52.2162|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-26 21:17:52.2162|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-08-26 21:17:52.2162|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-08-26 21:17:52.2162|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-08-26 21:17:52.2162|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-08-26 21:17:52.2162||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-08-26 21:17:52.2162|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-08-26 21:17:54.9044|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-08-26 21:17:54.9277|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2708.3365ms 
2025-08-26 21:17:54.9277|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-26 21:17:54.9277|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2712.1826ms 200 application/json; charset=utf-8 
2025-08-26 21:38:44.8906|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:20306/INSTITUTION/iisintegration  0 
2025-08-26 21:38:44.8906|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.4951ms 202  
2025-08-26 21:48:05.3060||DEBUG|InstitutionService.Program|init main function 
2025-08-26 21:48:06.0716|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-08-26 21:48:06.2338|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-08-26 21:48:06.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-08-26 21:48:06.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-08-26 21:48:06.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-08-26 21:48:06.2694|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-08-26 21:48:06.2849|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-08-26 21:48:06.3654|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2025-08-26 21:48:06.3654|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-08-26 21:48:06.3737|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {29913e95-4e89-402f-bfbd-ba440831a4ef} with creation date 2025-08-26 20:48:06Z, activation date 2025-08-26 20:48:06Z, and expiration date 2025-11-24 20:48:06Z. 
2025-08-26 21:48:06.3737|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {29913e95-4e89-402f-bfbd-ba440831a4ef} may be persisted to storage in unencrypted form. 
2025-08-26 21:48:06.5961|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-08-26 21:48:06.6322|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:48:06.6322|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 40.8932ms 204  
2025-08-26 21:48:06.9202|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-08-26 21:48:07.0118|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-08-26 21:48:07.0118|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:48:07.0118|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-08-26 21:48:07.0118|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-26 21:48:07.0466|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-08-26 21:48:07.0466|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-08-26 21:48:07.2222|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-08-26 21:48:07.3307|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-08-26 21:48:07.4956||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-08-26 21:48:07.5102|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-08-26 21:48:10.7085|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-08-26 21:48:10.7675|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 3718.3648ms 
2025-08-26 21:48:10.7675|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-26 21:48:10.7675|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3849.9306ms 200 application/json; charset=utf-8 
2025-08-26 21:49:51.5181|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-08-26 21:49:51.5211|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:49:51.5211|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3.6621ms 204  
2025-08-26 21:49:51.8040|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-08-26 21:49:51.8040|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-08-26 21:49:51.8040|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-26 21:49:51.8040|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-08-26 21:49:51.8040|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-26 21:49:51.8040|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-08-26 21:49:51.8331|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-08-26 21:49:51.8380|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-08-26 21:49:51.8380|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-08-26 21:49:51.8380||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-08-26 21:49:51.8380|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-08-26 21:49:54.5416|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-08-26 21:49:54.5661|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2756.4795ms 
2025-08-26 21:49:54.5661|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-26 21:49:54.5661|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2762.9546ms 200 application/json; charset=utf-8 
2025-08-26 22:10:05.0870|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:13732/INSTITUTION/iisintegration  0 
2025-08-26 22:10:05.0870|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0039ms 202