2022-05-11 04:02:49.1300||DEBUG|InstitutionService.Program|init main function 2022-05-11 04:02:49.8426|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 04:02:50.0051|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2022-05-11 04:02:50.0229|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2022-05-11 04:02:50.0229|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2022-05-11 04:02:50.0229|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2022-05-11 04:02:50.0421|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2022-05-11 04:02:50.0535|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2022-05-11 04:02:50.1297|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2022-05-11 04:02:50.1297|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. 2022-05-11 04:02:50.1365|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {52a3a592-6c95-4968-92a6-8262da153286} with creation date 2022-05-11 03:02:50Z, activation date 2022-05-11 03:02:50Z, and expiration date 2022-08-09 03:02:50Z. 2022-05-11 04:02:50.1365|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {52a3a592-6c95-4968-92a6-8262da153286} may be persisted to storage in unencrypted form. 2022-05-11 04:02:50.4498|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Countries 2022-05-11 04:02:50.4846|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:02:50.4846|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.Countries (InstitutionService)' 2022-05-11 04:02:50.5065|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). 2022-05-11 04:02:50.5092|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 04:02:50.6013|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (5ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [c].[Id], [c].[Code1], [c].[Code2], [c].[CountryName] FROM [Countries] AS [c] 2022-05-11 04:02:50.6349|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]]'. 2022-05-11 04:02:50.7015|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.Countries (InstitutionService) in 192.645ms 2022-05-11 04:02:50.7015|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.Countries (InstitutionService)' 2022-05-11 04:02:50.7015|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 254.6042ms 200 application/json; charset=utf-8 2022-05-11 04:04:52.1983|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2022-05-11 04:04:52.1983|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:04:52.1983|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.2488ms 204 2022-05-11 04:04:52.4895|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2022-05-11 04:04:52.5383|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 04:04:52.5383|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:04:52.5383|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 04:04:52.5383|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). 2022-05-11 04:04:52.5675|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 04:04:52.7336|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]]'. 2022-05-11 04:04:52.7408|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 195.9092ms 2022-05-11 04:04:52.7408|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 04:04:52.7408|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 252.951ms 200 application/json; charset=utf-8 2022-05-11 04:05:37.6676|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 2022-05-11 04:05:37.6676|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:05:37.6676|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.4536ms 204 2022-05-11 04:05:37.9679|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 2022-05-11 04:05:37.9679|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 04:05:37.9679|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:05:37.9679|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 04:05:37.9679|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). 2022-05-11 04:05:37.9735|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 04:05:37.9735|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]]'. 2022-05-11 04:05:37.9735|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 10.5606ms 2022-05-11 04:05:37.9735|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 04:05:37.9735|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 15.0395ms 200 application/json; charset=utf-8 2022-05-11 04:05:38.0469|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 2022-05-11 04:05:38.0469|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:05:38.0469|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1847ms 204 2022-05-11 04:05:38.3474|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 2022-05-11 04:05:38.3490|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 04:05:38.3490|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:05:38.3490|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 04:05:38.3490|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). 2022-05-11 04:05:38.3490|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 04:05:38.3490|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]]'. 2022-05-11 04:05:38.3490|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 4.5615ms 2022-05-11 04:05:38.3490|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 04:05:38.3490|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.4339ms 200 application/json; charset=utf-8 2022-05-11 04:07:28.0382|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:07:28.0382|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:07:28.0382|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.1815ms 204 2022-05-11 04:07:28.3372|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:07:28.3372|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 04:07:28.3372|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:07:28.3372|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2022-05-11 04:07:28.3372|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:07:28.3479|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). 2022-05-11 04:07:28.3479|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 04:07:28.4309|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (29ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT CASE WHEN EXISTS ( SELECT 1 FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0) THEN CAST(1 AS bit) ELSE CAST(0 AS bit) END 2022-05-11 04:07:28.4590|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (8ms) [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) 2022-05-11 04:07:28.5713|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [i].[Id], [i].[AccountNumber], [i].[Address], [i].[BankId], [i].[BannerUrl], [i].[CertificateLogoUrl], [i].[Code], [i].[Country], [i].[CreatedBy], [i].[DateCreated], [i].[DateModified], [i].[Email], [i].[FullName], [i].[InstitutionType], [i].[IsActive], [i].[IsDeleted], [i].[LogoUrl], [i].[ModifiedBy], [i].[Name], [i].[OverView], [i].[Phonenumber], [i].[ThumbnailUrl], [i].[Website] FROM [Institution] AS [i] WHERE [i].[Id] = @__institutionId_0 2022-05-11 04:07:28.6727|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[@p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [CertificateLogs] ([CertificateId], [CourseId], [CreatedBy], [DateCreated], [DateModified], [DownloadDate], [InstitutionCode], [IsActive], [IsDeleted], [ModifiedBy], [UserId]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10); SELECT [Id] FROM [CertificateLogs] WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 2022-05-11 04:07:28.7184||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2022-05-11 04:07:28.7337|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (4ms) [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 2022-05-11 04:07:37.3365|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2022-05-11 04:07:37.3709|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 9022.7771ms 2022-05-11 04:07:37.3709|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:07:37.3709|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9034.4185ms 200 application/json; charset=utf-8 2022-05-11 04:08:00.1873|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:08:00.1873|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:08:00.1873|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.7161ms 204 2022-05-11 04:08:00.5371|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:08:00.5371|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 04:08:00.5371|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:08:00.5371|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2022-05-11 04:08:00.5371|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:08:00.5371|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). 2022-05-11 04:08:00.5371|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 04:08:00.5371|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT CASE WHEN EXISTS ( SELECT 1 FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0) THEN CAST(1 AS bit) ELSE CAST(0 AS bit) END 2022-05-11 04:08:00.5371|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) 2022-05-11 04:08:00.5645|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; 2022-05-11 04:08:00.5745||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2022-05-11 04:08:00.5745|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 2022-05-11 04:08:03.7692|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2022-05-11 04:08:03.7983|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 3257.5358ms 2022-05-11 04:08:03.7983|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:08:03.7983|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3262.406ms 200 application/json; charset=utf-8 2022-05-11 04:08:06.6219|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:08:06.6219|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:08:06.6219|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.4591ms 204 2022-05-11 04:08:06.9373|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:08:06.9373|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 04:08:06.9373|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:08:06.9403|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2022-05-11 04:08:06.9403|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:08:06.9403|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). 2022-05-11 04:08:06.9403|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 04:08:06.9403|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT CASE WHEN EXISTS ( SELECT 1 FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0) THEN CAST(1 AS bit) ELSE CAST(0 AS bit) END 2022-05-11 04:08:06.9403|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) 2022-05-11 04:08:06.9403|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; 2022-05-11 04:08:06.9403||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2022-05-11 04:08:06.9573|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 2022-05-11 04:08:10.1583|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2022-05-11 04:08:10.1832|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 3241.9694ms 2022-05-11 04:08:10.1832|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:08:10.1832|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3246.9291ms 200 application/json; charset=utf-8 2022-05-11 04:09:25.8181|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:09:25.8181|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:09:25.8181|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.4224ms 204 2022-05-11 04:09:26.1175|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:09:26.1175|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 04:09:26.1175|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:09:26.1175|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2022-05-11 04:09:26.1175|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:09:26.1175|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). 2022-05-11 04:09:26.1175|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 04:09:26.1175|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT CASE WHEN EXISTS ( SELECT 1 FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0) THEN CAST(1 AS bit) ELSE CAST(0 AS bit) END 2022-05-11 04:09:26.1271|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) 2022-05-11 04:09:26.1271|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; 2022-05-11 04:09:26.1271||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2022-05-11 04:09:26.1271|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 2022-05-11 04:09:29.3435|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2022-05-11 04:09:30.2274|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 4106.8136ms 2022-05-11 04:09:30.2274|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:09:30.2274|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4110.5885ms 200 application/json; charset=utf-8 2022-05-11 04:13:53.7682|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:13:53.7682|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:13:53.7682|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0846ms 204 2022-05-11 04:13:54.0469|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:13:54.0469|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 04:13:54.0469|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:13:54.0469|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2022-05-11 04:13:54.0469|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:13:54.0469|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). 2022-05-11 04:13:54.0469|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 04:13:54.0469|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT CASE WHEN EXISTS ( SELECT 1 FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0) THEN CAST(1 AS bit) ELSE CAST(0 AS bit) END 2022-05-11 04:13:54.0469|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) 2022-05-11 04:13:54.0469|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; 2022-05-11 04:13:54.0640||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2022-05-11 04:13:54.0640|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 2022-05-11 04:13:57.2713|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2022-05-11 04:13:58.1570|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 4107.0921ms 2022-05-11 04:13:58.1570|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:13:58.1570|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4110.7268ms 200 application/json; charset=utf-8 2022-05-11 04:14:22.7169|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:14:22.7169|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:14:22.7169|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0713ms 204 2022-05-11 04:14:23.0069|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:14:23.0069|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 04:14:23.0069|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:14:23.0069|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2022-05-11 04:14:23.0069|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:14:23.0069|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). 2022-05-11 04:14:23.0069|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 04:14:23.0069|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT CASE WHEN EXISTS ( SELECT 1 FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0) THEN CAST(1 AS bit) ELSE CAST(0 AS bit) END 2022-05-11 04:14:23.0147|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) 2022-05-11 04:14:23.0147|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; 2022-05-11 04:14:23.0147||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2022-05-11 04:14:23.0147|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 2022-05-11 04:14:26.2293|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2022-05-11 04:14:26.2542|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 3244.5001ms 2022-05-11 04:14:26.2542|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:14:26.2542|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3247.992ms 200 application/json; charset=utf-8 2022-05-11 04:14:34.1667|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:14:34.1667|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:14:34.1667|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0611ms 204 2022-05-11 04:14:34.4367|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:14:34.4367|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 04:14:34.4367|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:14:34.4367|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2022-05-11 04:14:34.4367|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:14:34.4367|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). 2022-05-11 04:14:34.4367|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 04:14:34.4367|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT CASE WHEN EXISTS ( SELECT 1 FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0) THEN CAST(1 AS bit) ELSE CAST(0 AS bit) END 2022-05-11 04:14:34.4367|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) 2022-05-11 04:14:34.4367|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; 2022-05-11 04:14:34.4367||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2022-05-11 04:14:34.4520|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 2022-05-11 04:14:37.6357|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2022-05-11 04:14:37.6605|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 3221.109ms 2022-05-11 04:14:37.6605|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:14:37.6605|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3224.4595ms 200 application/json; charset=utf-8 2022-05-11 04:38:37.6178|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:38:37.6178|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:38:37.6178|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.989ms 204 2022-05-11 04:38:37.8974|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:38:37.8974|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 04:38:37.8974|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:38:37.8974|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2022-05-11 04:38:37.8974|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:38:37.8974|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). 2022-05-11 04:38:37.8974|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 04:38:37.9059|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT CASE WHEN EXISTS ( SELECT 1 FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0) THEN CAST(1 AS bit) ELSE CAST(0 AS bit) END 2022-05-11 04:38:37.9059|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) 2022-05-11 04:38:37.9059|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; 2022-05-11 04:38:37.9059||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2022-05-11 04:38:37.9186|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 2022-05-11 04:38:41.1320|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2022-05-11 04:38:42.1365|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 4236.6432ms 2022-05-11 04:38:42.1365|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:38:42.1365|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4239.8ms 200 application/json; charset=utf-8 2022-05-11 04:38:47.2567|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:38:47.2567|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:38:47.2567|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.9579ms 204 2022-05-11 04:38:47.5368|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 04:38:47.5368|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 04:38:47.5368|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 04:38:47.5368|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2022-05-11 04:38:47.5368|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:38:47.5368|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). 2022-05-11 04:38:47.5368|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 04:38:47.5368|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT CASE WHEN EXISTS ( SELECT 1 FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0) THEN CAST(1 AS bit) ELSE CAST(0 AS bit) END 2022-05-11 04:38:47.5430|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) 2022-05-11 04:38:47.5430|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; 2022-05-11 04:38:47.5430||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2022-05-11 04:38:47.5430|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 2022-05-11 04:38:50.7631|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2022-05-11 04:38:50.7873|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 3248.0618ms 2022-05-11 04:38:50.7873|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 04:38:50.7873|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3251.0212ms 200 application/json; charset=utf-8 2022-05-11 05:03:47.6082|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 05:03:47.6082|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 05:03:47.6082|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.8959ms 204 2022-05-11 05:03:47.8871|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 05:03:47.8871|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 05:03:47.8871|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 05:03:47.8871|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2022-05-11 05:03:47.8871|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 05:03:47.8871|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). 2022-05-11 05:03:47.8871|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 05:03:47.8871|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT CASE WHEN EXISTS ( SELECT 1 FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0) THEN CAST(1 AS bit) ELSE CAST(0 AS bit) END 2022-05-11 05:03:47.8871|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) 2022-05-11 05:03:47.8993|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; 2022-05-11 05:03:47.8993||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2022-05-11 05:03:47.8993|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 2022-05-11 05:03:51.0904|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2022-05-11 05:03:51.9669|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 4077.4606ms 2022-05-11 05:03:51.9669|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 05:03:51.9669|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4080.3652ms 200 application/json; charset=utf-8 2022-05-11 05:26:42.5445|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 05:26:42.5445|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 05:26:42.5445|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.8783ms 204 2022-05-11 05:26:45.0071|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=256&userId=438&institutionId=93 2022-05-11 05:26:45.0071|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 05:26:45.0071|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 05:26:45.0071|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2022-05-11 05:26:45.0071|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 05:26:45.0071|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). 2022-05-11 05:26:45.0071|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 05:26:45.0071|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT CASE WHEN EXISTS ( SELECT 1 FROM [CertificateTemplates] AS [c] WHERE [c].[InstitutionId] = @__institutionId_0) THEN CAST(1 AS bit) ELSE CAST(0 AS bit) END 2022-05-11 05:26:45.0071|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) 2022-05-11 05:26:45.0071|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; 2022-05-11 05:26:45.0287||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 2022-05-11 05:26:45.0287|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 2022-05-11 05:26:48.2095|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2022-05-11 05:26:49.2270|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 4217.662ms 2022-05-11 05:26:49.2270|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 2022-05-11 05:26:49.2270|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4220.554ms 200 application/json; charset=utf-8 2022-05-11 05:27:24.5677|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2022-05-11 05:27:24.5685|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 05:27:24.5685|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1252ms 204 2022-05-11 05:27:27.5716|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2022-05-11 05:27:27.5716|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 05:27:27.5716|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 05:27:27.5716|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 05:27:27.5716|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). 2022-05-11 05:27:27.5716|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 05:27:27.5716|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]]'. 2022-05-11 05:27:27.5716|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 3.455ms 2022-05-11 05:27:27.5716|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 05:27:27.5716|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.9284ms 200 application/json; charset=utf-8 2022-05-11 05:28:13.1619|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 2022-05-11 05:28:13.1623|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 05:28:13.1623|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.6604ms 204 2022-05-11 05:28:16.2665|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 2022-05-11 05:28:16.2665|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 05:28:16.2665|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 05:28:16.2665|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 05:28:16.2665|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). 2022-05-11 05:28:16.2665|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 05:28:16.2665|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]]'. 2022-05-11 05:28:16.2718|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 3.5645ms 2022-05-11 05:28:16.2718|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 05:28:16.2718|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.6164ms 200 application/json; charset=utf-8 2022-05-11 05:28:16.4065|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 2022-05-11 05:28:16.4065|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 05:28:16.4065|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.5372ms 204 2022-05-11 05:28:28.6319|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 2022-05-11 05:28:28.6319|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 05:28:28.6319|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 05:28:28.6319|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 05:28:28.6319|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). 2022-05-11 05:28:28.6319|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 05:28:28.6319|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]]'. 2022-05-11 05:28:28.6319|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 2.7552ms 2022-05-11 05:28:28.6319|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 05:28:28.6319|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.2864ms 200 application/json; charset=utf-8 2022-05-11 05:37:41.2026|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2022-05-11 05:37:41.2026|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 05:37:41.2026|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.5408ms 204 2022-05-11 05:37:47.7971|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2022-05-11 05:37:47.7971|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 05:37:47.7971|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 05:37:47.7971|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 05:37:47.7971|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). 2022-05-11 05:37:47.7971|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 05:37:47.7971|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]]'. 2022-05-11 05:37:47.7971|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 6.7731ms 2022-05-11 05:37:47.7971|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 05:37:47.7971|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.4225ms 200 application/json; charset=utf-8 2022-05-11 05:38:20.8372|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 2022-05-11 05:38:20.8372|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 05:38:20.8372|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.6406ms 204 2022-05-11 05:38:24.4767|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 2022-05-11 05:38:24.4767|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 05:38:24.4767|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 05:38:24.4767|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 05:38:24.4767|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). 2022-05-11 05:38:24.4767|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 05:38:24.4767|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]]'. 2022-05-11 05:38:24.4767|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 3.1001ms 2022-05-11 05:38:24.4767|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 05:38:24.4767|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.24ms 200 application/json; charset=utf-8 2022-05-11 05:38:26.4022|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 2022-05-11 05:38:26.4022|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 05:38:26.4022|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.6372ms 204 2022-05-11 05:38:30.5021|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 2022-05-11 05:38:30.5021|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 05:38:30.5021|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 05:38:30.5021|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 05:38:30.5021|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). 2022-05-11 05:38:30.5021|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 05:38:30.5021|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]]'. 2022-05-11 05:38:30.5021|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 2.9506ms 2022-05-11 05:38:30.5021|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 05:38:30.5021|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.1841ms 200 application/json; charset=utf-8 2022-05-11 06:16:28.4707|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 2022-05-11 06:16:28.4707|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 06:16:28.4707|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.6575ms 204 2022-05-11 06:16:28.7568|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 2022-05-11 06:16:28.7568|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 06:16:28.7568|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 06:16:28.7568|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 06:16:28.7568|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). 2022-05-11 06:16:28.7568|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 06:16:28.7568|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]]'. 2022-05-11 06:16:28.7568|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 6.4801ms 2022-05-11 06:16:28.7568|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 06:16:28.7568|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.4239ms 200 application/json; charset=utf-8 2022-05-11 10:35:18.3758|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Countries 2022-05-11 10:35:18.3758|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 10:35:18.3758|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.Countries (InstitutionService)' 2022-05-11 10:35:18.3758|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). 2022-05-11 10:35:18.3758|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 10:35:18.3758|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [c].[Id], [c].[Code1], [c].[Code2], [c].[CountryName] FROM [Countries] AS [c] 2022-05-11 10:35:18.3862|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]]'. 2022-05-11 10:35:18.3862|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.Countries (InstitutionService) in 9.6287ms 2022-05-11 10:35:18.3862|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.Countries (InstitutionService)' 2022-05-11 10:35:18.3862|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.7024ms 200 application/json; charset=utf-8 2022-05-11 10:35:55.9787|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Countries 2022-05-11 10:35:55.9787|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 10:35:55.9787|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.Countries (InstitutionService)' 2022-05-11 10:35:55.9787|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). 2022-05-11 10:35:55.9787|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 10:35:55.9787|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [c].[Id], [c].[Code1], [c].[Code2], [c].[CountryName] FROM [Countries] AS [c] 2022-05-11 10:35:55.9787|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]]'. 2022-05-11 10:35:55.9787|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.Countries (InstitutionService) in 4.7845ms 2022-05-11 10:35:55.9787|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.Countries (InstitutionService)' 2022-05-11 10:35:55.9787|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6.3666ms 200 application/json; charset=utf-8 2022-05-11 10:37:58.4432|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000 2022-05-11 10:37:58.4432|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 10:37:58.4432|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 10:37:58.4432|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). 2022-05-11 10:37:58.4432|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 10:37:58.4503|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]]'. 2022-05-11 10:37:58.4503|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 6.4906ms 2022-05-11 10:37:58.4503|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 10:37:58.4503|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.1003ms 200 application/json; charset=utf-8 2022-05-11 10:39:21.6992|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=undefined&IsActive=true 2022-05-11 10:39:21.6992|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 10:39:21.6992|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.6611ms 204 2022-05-11 10:39:23.0682|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=undefined&IsActive=true 2022-05-11 10:39:23.0738|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 10:39:23.0738|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 10:39:23.0738|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 10:39:23.0738|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). 2022-05-11 10:39:23.0738|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 10:39:23.0738|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]]'. 2022-05-11 10:39:23.0738|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 3.2542ms 2022-05-11 10:39:23.0738|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 2022-05-11 10:39:23.0738|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 10.5381ms 200 application/json; charset=utf-8 2022-05-11 10:39:29.7334|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Partner/Search?search=&id=0&page=1&pageSize=10000 2022-05-11 10:39:29.7334|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 10:39:29.7334|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.7801ms 204 2022-05-11 10:39:31.9552|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Partner/Search?search=&id=0&page=1&pageSize=10000 2022-05-11 10:39:31.9552|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 10:39:31.9552|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 10:39:31.9552|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2022-05-11 10:39:31.9552|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.PartnerController.Search (InstitutionService)' 2022-05-11 10:39:31.9630|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "Search", controller = "Partner"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] Search(System.String, System.Nullable`1[System.Int64], System.Nullable`1[System.Int32], System.Nullable`1[System.Int32]) on controller InstitutionService.Controllers.PartnerController (InstitutionService). 2022-05-11 10:39:31.9630|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 10:39:31.9630||INFO|InstitutionService.Core.Services.PartnerService|about to call SP_GetPartner 2022-05-11 10:39:32.4833|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2022-05-11 10:39:32.4833|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.PartnerController.Search (InstitutionService) in 524.9866ms 2022-05-11 10:39:32.4833|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.PartnerController.Search (InstitutionService)' 2022-05-11 10:39:32.4833|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 533.6728ms 200 application/json; charset=utf-8 2022-05-11 10:39:44.2483|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Partner/Search?search=&id=0&page=1&pageSize=10000 2022-05-11 10:39:44.2483|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 10:39:44.2483|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.684ms 204 2022-05-11 10:39:45.0087|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Partner/Search?search=&id=0&page=1&pageSize=10000 2022-05-11 10:39:45.0087|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2022-05-11 10:39:45.0087|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2022-05-11 10:39:45.0087|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2022-05-11 10:39:45.0087|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.PartnerController.Search (InstitutionService)' 2022-05-11 10:39:45.0087|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "Search", controller = "Partner"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] Search(System.String, System.Nullable`1[System.Int64], System.Nullable`1[System.Int32], System.Nullable`1[System.Int32]) on controller InstitutionService.Controllers.PartnerController (InstitutionService). 2022-05-11 10:39:45.0087|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies 2022-05-11 10:39:45.0087||INFO|InstitutionService.Core.Services.PartnerService|about to call SP_GetPartner 2022-05-11 10:39:45.0408|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2022-05-11 10:39:45.0408|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.PartnerController.Search (InstitutionService) in 30.4436ms 2022-05-11 10:39:45.0408|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.PartnerController.Search (InstitutionService)' 2022-05-11 10:39:45.0408|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 33.2889ms 200 application/json; charset=utf-8 2022-05-11 17:33:57.9181|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:45178/INSTITUTION/iisintegration 0 2022-05-11 17:33:57.9181|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.7445ms 202