2023-12-27 00:51:16.0641||DEBUG|Authentication.Program|init main function 
2023-12-27 00:51:16.8139|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 00:51:16.9951|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-12-27 00:51:17.0142|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-12-27 00:51:17.0142|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-12-27 00:51:17.0142|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-12-27 00:51:17.0271|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2023-12-27 00:51:17.0271|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2023-12-27 00:51:17.1178|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2023-12-27 00:51:17.1178|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 
2023-12-27 00:51:17.1239|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {bf8ed4ad-6f7a-491c-a898-29e99e651a43} with creation date 2023-12-26 23:51:17Z, activation date 2023-12-26 23:51:17Z, and expiration date 2024-03-25 23:51:17Z. 
2023-12-27 00:51:17.1239|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {bf8ed4ad-6f7a-491c-a898-29e99e651a43} may be persisted to storage in unencrypted form. 
2023-12-27 00:51:17.3826|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/Account/LinkedInLogin   
2023-12-27 00:51:17.7735|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.LinkedInLogin (Authentication)' 
2023-12-27 00:51:17.7892|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "LinkedInLogin", controller = "Account"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult LinkedInLogin() on controller Authentication.Controllers.AccountController (Authentication). 
2023-12-27 00:51:17.7892|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 00:51:18.5687|1|INFO|Microsoft.AspNetCore.Mvc.ChallengeResult|Executing ChallengeResult with authentication schemes (LinkedIn). 
2023-12-27 00:51:18.5752|1|DEBUG|AspNet.Security.OAuth.LinkedIn.LinkedInAuthenticationHandler|HandleChallenge with Location: https://www.linkedin.com/oauth/v2/authorization?client_id=77nzjvnk1ehwjv&scope=r_liteprofile%20r_emailaddress&response_type=code&redirect_uri=https%3A%2F%2Fapi.skilldorm.com%2FAuthentication%2Fsignin-linkedin&state=CfDJ8K3Ujr96bxxJqJgp6Z5lGkNWN3GBQDJEcDfPxjkSWTlaH2s8DRysJ37XHK89nXhoKMQWMj5C7Q70ig_p2wrMQ56gY89AUuo-rXkqHv59XJLGK1yQhFFETmWhmGIhJ4MnClEjQXaKMqL_fd6krC11EFoxZb-c1YsQysySWv1JPw55Faw8SBVVGuq3tl1b96OmmhqNLzJGu10enSB1RWCczkKu8i00FbuM0v0FSpymA5nVAgsXezk48uyfHaMAW6fXGkrYzpsH07NgFza70L5QwMgTSkC5Y7CnXNa__ag54dcG; and Set-Cookie: .AspNetCore.Correlation.LinkedIn.8IfO_EflwpkkGinCrHZ_Wlztu5eeFmxivDorR-0K9e4=N; expires=Wed, 27 Dec 2023 00:06:18 GMT; path=/Authentication/signin-linkedin; secure; samesite=none; httponly. 
2023-12-27 00:51:18.5752|12|INFO|AspNet.Security.OAuth.LinkedIn.LinkedInAuthenticationHandler|AuthenticationScheme: LinkedIn was challenged. 
2023-12-27 00:51:18.5752|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.LinkedInLogin (Authentication) in 787.4344ms 
2023-12-27 00:51:18.5752|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.LinkedInLogin (Authentication)' 
2023-12-27 00:51:18.5752|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1202.2107ms 302  
2023-12-27 01:12:15.6058|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:38158/AUTHENTICATION/iisintegration  0 
2023-12-27 01:12:15.6058|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1267ms 202  
2023-12-27 04:50:44.4042||DEBUG|Authentication.Program|init main function 
2023-12-27 04:50:47.8401|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 04:50:48.3586|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-12-27 04:50:48.3774|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-12-27 04:50:48.3774|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-12-27 04:50:48.3774|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-12-27 04:50:48.3774|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2023-12-27 04:50:48.4654|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2023-12-27 04:50:48.6928|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2023-12-27 04:50:48.6928|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 
2023-12-27 04:50:48.6928|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {33d83767-0c02-420b-8961-9bde842e9efa} with creation date 2023-12-27 03:50:48Z, activation date 2023-12-27 03:50:48Z, and expiration date 2024-03-26 03:50:48Z. 
2023-12-27 04:50:48.7067|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {33d83767-0c02-420b-8961-9bde842e9efa} may be persisted to storage in unencrypted form. 
2023-12-27 04:50:48.8210|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-12-27 04:50:48.8580|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-12-27 04:50:48.8580|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-12-27 04:50:48.8865|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 
2023-12-27 04:50:48.8865|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 04:50:48.9258|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 04:50:49.0586|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 
2023-12-27 04:50:49.1101|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 
2023-12-27 04:50:49.1837|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 294.5348ms 
2023-12-27 04:50:49.1837|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-12-27 04:50:49.1837|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 366.9635ms 200 application/json; charset=utf-8 
2023-12-27 05:11:43.2274|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:27541/AUTHENTICATION/iisintegration  0 
2023-12-27 05:11:43.2274|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1018ms 202  
2023-12-27 06:39:17.1552||DEBUG|Authentication.Program|init main function 
2023-12-27 06:39:17.8997|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 06:39:18.0743|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-12-27 06:39:18.0929|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-12-27 06:39:18.0929|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-12-27 06:39:18.0929|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-12-27 06:39:18.1033|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2023-12-27 06:39:18.1163|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2023-12-27 06:39:18.1955|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2023-12-27 06:39:18.1955|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 
2023-12-27 06:39:18.1955|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {a4df2fd2-4eb6-4149-b1cf-f1fbe80c1480} with creation date 2023-12-27 05:39:18Z, activation date 2023-12-27 05:39:18Z, and expiration date 2024-03-26 05:39:18Z. 
2023-12-27 06:39:18.1955|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {a4df2fd2-4eb6-4149-b1cf-f1fbe80c1480} may be persisted to storage in unencrypted form. 
2023-12-27 06:39:18.4584|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-12-27 06:39:18.4959|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-12-27 06:39:18.4959|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-12-27 06:39:18.5247|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 
2023-12-27 06:39:18.5247|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 06:39:18.5638|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 06:39:18.6965|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 
2023-12-27 06:39:18.7475|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 
2023-12-27 06:39:18.8198|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 292.6174ms 
2023-12-27 06:39:18.8198|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-12-27 06:39:18.8198|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 365.5507ms 200 application/json; charset=utf-8 
2023-12-27 06:40:07.3188|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-12-27 06:40:07.3188|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-12-27 06:40:07.3188|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-12-27 06:40:07.3188|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 
2023-12-27 06:40:07.3188|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 06:40:07.3188|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 06:40:07.3307|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 
2023-12-27 06:40:07.3307|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 
2023-12-27 06:40:07.3307|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 9.5538ms 
2023-12-27 06:40:07.3307|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-12-27 06:40:07.3307|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 14.9202ms 200 application/json; charset=utf-8 
2023-12-27 06:40:24.4312|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-12-27 06:40:24.4312|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-12-27 06:40:24.4312|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-12-27 06:40:24.4312|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 
2023-12-27 06:40:24.4446|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 06:40:24.4446|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 06:40:24.4446|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 
2023-12-27 06:40:24.4446|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 
2023-12-27 06:40:24.4446|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 17.1243ms 
2023-12-27 06:40:24.4446|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-12-27 06:40:24.4446|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 22.8208ms 200 application/json; charset=utf-8 
2023-12-27 06:40:37.0159|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-12-27 06:40:37.0159|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-12-27 06:40:37.0159|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-12-27 06:40:37.0191|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 
2023-12-27 06:40:37.0191|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 06:40:37.0191|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 06:40:37.0191|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 
2023-12-27 06:40:37.0191|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 
2023-12-27 06:40:37.0191|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 6.4285ms 
2023-12-27 06:40:37.0191|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-12-27 06:40:37.0191|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 10.7114ms 200 application/json; charset=utf-8 
2023-12-27 06:40:46.7813|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/Account/GoogleLogin   
2023-12-27 06:40:47.1227|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.GoogleLogin (Authentication)' 
2023-12-27 06:40:47.1260|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GoogleLogin", controller = "Account"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult GoogleLogin() on controller Authentication.Controllers.AccountController (Authentication). 
2023-12-27 06:40:47.1260|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 06:40:47.4075|1|INFO|Microsoft.AspNetCore.Mvc.ChallengeResult|Executing ChallengeResult with authentication schemes (Google). 
2023-12-27 06:40:47.4075|12|INFO|Microsoft.AspNetCore.Authentication.Google.GoogleHandler|AuthenticationScheme: Google was challenged. 
2023-12-27 06:40:47.4075|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.GoogleLogin (Authentication) in 286.3278ms 
2023-12-27 06:40:47.4075|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.GoogleLogin (Authentication)' 
2023-12-27 06:40:47.4075|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 632.046ms 302  
2023-12-27 06:41:48.8980|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/signin-google?state=CfDJ8NIv36S2TklBsc_x--gMFIBLCXMFY7X-efU-dtgWkHiao5ijntBM1-CPNs_RvcfeigIkZfXfAKjLkXjfSgAojQTRY2Me0Mte7GhPH4Q3F7cDH0yFuLkkZahKrvJHS22nA8VtL_HX7KTg8-EJulFmt1Dn35vQH-EoQGnxCvUjZndTAe2IE5E8haEn3Ot6aWYpGxet9WUsF2-vnn9evyudqpyLTiosFsIRkf_c4DQlW9bRLmjWm8U09EBcPe2LTYIlVwM42j01DCWsO8d9h8DgzLzU6U6HxGFEV9JOugx-GzF4&code=4%2F0AfJohXmpuzXG_xpAwRuSCsy33sVT0FvqZCtJPs_vDUNW6LxC-yKAdGeEY-V4O1md17d3Bg&scope=email+profile+openid+https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.profile+https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.email&authuser=1&prompt=consent   
2023-12-27 06:41:49.2862|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.External signed in. 
2023-12-27 06:41:49.2862|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 389.1926ms 302  
2023-12-27 06:41:49.6062|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/Account/GoogleResponse   
2023-12-27 06:41:49.6096|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.GoogleResponse (Authentication)' 
2023-12-27 06:41:49.6096|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GoogleResponse", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GoogleResponse() on controller Authentication.Controllers.AccountController (Authentication). 
2023-12-27 06:41:49.6096|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 06:41:49.6301||WARN|Authentication.Controllers.AccountController|external login info from googleresponse 
2023-12-27 06:41:49.6301|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 06:41:49.6688|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (21ms) [Parameters=[@__loginProvider_0='?' (Size = 450), @__providerKey_1='?' (Size = 450)], CommandType='Text', CommandTimeout='30']
SELECT TOP(2) [a].[LoginProvider], [a].[ProviderKey], [a].[Discriminator], [a].[ProviderDisplayName], [a].[UserId]
FROM [AspNetUserLogins] AS [a]
WHERE [a].[Discriminator] IN (N'IdentityUserLogin<long>', N'UserLogin') AND (([a].[LoginProvider] = @__loginProvider_0) AND ([a].[ProviderKey] = @__providerKey_1)) 
2023-12-27 06:41:49.6688||WARN|Authentication.Controllers.AccountController|external login result from googleresponse --> {"Succeeded":false,"IsLockedOut":false,"IsNotAllowed":false,"RequiresTwoFactor":false} 
2023-12-27 06:41:49.6688||WARN|Authentication.Controllers.AccountController|elsesucceeded from googleresponse 
2023-12-27 06:41:49.6946|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__ToLower_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType]
FROM [AspNetUsers] AS [a]
WHERE LOWER([a].[UserName]) = @__ToLower_0 
2023-12-27 06:41:49.6946||WARN|Authentication.Controllers.AccountController|Registering a new user 
2023-12-27 06:41:49.6946|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedUserName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType]
FROM [AspNetUsers] AS [a]
WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 
2023-12-27 06:41:49.8157|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Int32), @p1='?' (Size = 4000), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = Int64), @p6='?' (Size = 256), @p7='?' (DbType = Boolean), @p8='?' (Size = 4000), @p9='?' (DbType = Int64), @p10='?' (DbType = Boolean), @p11='?' (DbType = Boolean), @p12='?' (DbType = Boolean), @p13='?' (Size = 4000), @p14='?' (DbType = DateTime2), @p15='?' (DbType = Boolean), @p16='?' (DbType = DateTimeOffset), @p17='?' (Size = 4000), @p18='?' (Size = 256), @p19='?' (Size = 256), @p20='?' (Size = 4000), @p21='?' (Size = 4000), @p22='?' (DbType = Boolean), @p23='?' (Size = 4000), @p24='?' (DbType = Boolean), @p25='?' (DbType = Int64), @p26='?' (Size = 256), @p27='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [AspNetUsers] ([AccessFailedCount], [ConcurrencyStamp], [CreatedBy], [DateCreated], [DateUpdated], [DeletedBy], [Email], [EmailConfirmed], [FirstName], [InstitutionId], [IsActive], [IsDeleted], [IsFirstLogin], [LastName], [LastPasswordChangeDate], [LockoutEnabled], [LockoutEnd], [MiddleName], [NormalizedEmail], [NormalizedUserName], [PasswordHash], [PhoneNumber], [PhoneNumberConfirmed], [SecurityStamp], [TwoFactorEnabled], [UpdatedBy], [UserName], [UserType])
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26, @p27);
SELECT [Id], [RowVersion]
FROM [AspNetUsers]
WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 
2023-12-27 06:41:49.8531|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__roleId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[IsActive], [a].[Name], [a].[NormalizedName], [a].[RoleType], [a].[UpdatedBy]
FROM [AspNetRoles] AS [a]
WHERE [a].[Id] = @__roleId_0 
2023-12-27 06:41:49.8668|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedRoleName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[IsActive], [a].[Name], [a].[NormalizedName], [a].[RoleType], [a].[UpdatedBy]
FROM [AspNetRoles] AS [a]
WHERE [a].[NormalizedName] = @__normalizedRoleName_0 
2023-12-27 06:41:49.8668|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__p_0='?' (DbType = Int64), @__p_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[UserId], [a].[RoleId], [a].[Discriminator]
FROM [AspNetUserRoles] AS [a]
WHERE [a].[Discriminator] IN (N'IdentityUserRole<long>', N'UserRole') AND (([a].[UserId] = @__p_0) AND ([a].[RoleId] = @__p_1)) 
2023-12-27 06:41:49.8781|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__normalizedRoleName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[IsActive], [a].[Name], [a].[NormalizedName], [a].[RoleType], [a].[UpdatedBy]
FROM [AspNetRoles] AS [a]
WHERE [a].[NormalizedName] = @__normalizedRoleName_0 
2023-12-27 06:41:49.8781|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__normalizedUserName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType]
FROM [AspNetUsers] AS [a]
WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 
2023-12-27 06:41:49.9047|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@p0='?' (DbType = Int64), @p1='?' (DbType = Int64), @p2='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [AspNetUserRoles] ([UserId], [RoleId], [Discriminator])
VALUES (@p0, @p1, @p2); 
2023-12-27 06:41:49.9047|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p28='?' (DbType = Int64), @p0='?' (DbType = Int32), @p1='?' (Size = 4000), @p29='?' (Size = 4000), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = Int64), @p6='?' (Size = 256), @p7='?' (DbType = Boolean), @p8='?' (Size = 4000), @p9='?' (DbType = Int64), @p10='?' (DbType = Boolean), @p11='?' (DbType = Boolean), @p12='?' (DbType = Boolean), @p13='?' (Size = 4000), @p14='?' (DbType = DateTime2), @p15='?' (DbType = Boolean), @p16='?' (DbType = DateTimeOffset), @p17='?' (Size = 4000), @p18='?' (Size = 256), @p19='?' (Size = 256), @p20='?' (Size = 4000), @p21='?' (Size = 4000), @p22='?' (DbType = Boolean), @p30='?' (Size = 8) (DbType = Binary), @p23='?' (Size = 4000), @p24='?' (DbType = Boolean), @p25='?' (DbType = Int64), @p26='?' (Size = 256), @p27='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [AspNetUsers] SET [AccessFailedCount] = @p0, [ConcurrencyStamp] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateUpdated] = @p4, [DeletedBy] = @p5, [Email] = @p6, [EmailConfirmed] = @p7, [FirstName] = @p8, [InstitutionId] = @p9, [IsActive] = @p10, [IsDeleted] = @p11, [IsFirstLogin] = @p12, [LastName] = @p13, [LastPasswordChangeDate] = @p14, [LockoutEnabled] = @p15, [LockoutEnd] = @p16, [MiddleName] = @p17, [NormalizedEmail] = @p18, [NormalizedUserName] = @p19, [PasswordHash] = @p20, [PhoneNumber] = @p21, [PhoneNumberConfirmed] = @p22, [SecurityStamp] = @p23, [TwoFactorEnabled] = @p24, [UpdatedBy] = @p25, [UserName] = @p26, [UserType] = @p27
WHERE [Id] = @p28 AND [ConcurrencyStamp] = @p29 AND [RowVersion] = @p30;
SELECT [RowVersion]
FROM [AspNetUsers]
WHERE @@ROWCOUNT = 1 AND [Id] = @p28; 
2023-12-27 06:41:49.9311|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p0='?' (Size = 4000), @p1='?' (Size = 4000), @p2='?' (Size = 4000), @p3='?' (Size = 4000), @p4='?' (Size = 4000), @p5='?' (DbType = Int64), @p6='?' (DbType = DateTime2), @p7='?' (DbType = DateTime2), @p8='?' (Size = 4000), @p9='?' (Size = 4000), @p10='?' (DbType = Boolean), @p11='?' (DbType = Boolean), @p12='?' (Size = 4000), @p13='?' (Size = 4000), @p14='?' (DbType = Int64), @p15='?' (Size = 4000), @p16='?' (Size = 4000), @p17='?' (Size = 4000), @p18='?' (DbType = Int64), @p19='?' (Size = 4000), @p20='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [Students] ([Address1], [Address2], [Age], [Biography], [Country], [CreatedBy], [DateCreated], [DateModified], [FaceBook], [Headline], [IsActive], [IsDeleted], [JobTitle], [LinkedIn], [ModifiedBy], [Organization], [ProfilePixUrl], [Twitter], [UserId], [Website], [YouTube])
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20);
SELECT [Id]
FROM [Students]
WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 
2023-12-27 06:41:49.9423||WARN|Authentication.Core.Services.GoogleService|appendRequest=  {"majorDimension":null,"range":null,"values":[["dealogroupincorporated@gmail.com","dealogroup","incorporated"]],"ETag":null}, sheetID ="1oTZ1hfTRq_kX45J0_zA2vxVqddGZ166HHuYeO31LaPA", range ="newlyRegisteredUsers!A1:C" 
2023-12-27 06:41:49.9423||WARN|Authentication.Core.Services.GoogleService|valueInputeOption=  USERENTERED 
2023-12-27 06:41:50.7537||WARN|Authentication.Core.Services.GoogleService|Googlesheet response=  {"spreadsheetId":"1oTZ1hfTRq_kX45J0_zA2vxVqddGZ166HHuYeO31LaPA","tableRange":"newlyRegisteredUsers!A1:C343","updates":{"spreadsheetId":"1oTZ1hfTRq_kX45J0_zA2vxVqddGZ166HHuYeO31LaPA","updatedCells":3,"updatedColumns":3,"updatedData":null,"updatedRange":"newlyRegisteredUsers!A344:C344","updatedRows":1,"ETag":null},"ETag":null} 
2023-12-27 06:41:50.7537|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__loginProvider_0='?' (Size = 450), @__providerKey_1='?' (Size = 450)], CommandType='Text', CommandTimeout='30']
SELECT TOP(2) [a].[LoginProvider], [a].[ProviderKey], [a].[Discriminator], [a].[ProviderDisplayName], [a].[UserId]
FROM [AspNetUserLogins] AS [a]
WHERE [a].[Discriminator] IN (N'IdentityUserLogin<long>', N'UserLogin') AND (([a].[LoginProvider] = @__loginProvider_0) AND ([a].[ProviderKey] = @__providerKey_1)) 
2023-12-27 06:41:50.7537|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedUserName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType]
FROM [AspNetUsers] AS [a]
WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 
2023-12-27 06:41:50.7720|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (5ms) [Parameters=[@p0='?' (Size = 450), @p1='?' (Size = 450), @p2='?' (Size = 4000), @p3='?' (Size = 4000), @p4='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [AspNetUserLogins] ([LoginProvider], [ProviderKey], [Discriminator], [ProviderDisplayName], [UserId])
VALUES (@p0, @p1, @p2, @p3, @p4); 
2023-12-27 06:41:50.7720|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p28='?' (DbType = Int64), @p0='?' (DbType = Int32), @p1='?' (Size = 4000), @p29='?' (Size = 4000), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = Int64), @p6='?' (Size = 256), @p7='?' (DbType = Boolean), @p8='?' (Size = 4000), @p9='?' (DbType = Int64), @p10='?' (DbType = Boolean), @p11='?' (DbType = Boolean), @p12='?' (DbType = Boolean), @p13='?' (Size = 4000), @p14='?' (DbType = DateTime2), @p15='?' (DbType = Boolean), @p16='?' (DbType = DateTimeOffset), @p17='?' (Size = 4000), @p18='?' (Size = 256), @p19='?' (Size = 256), @p20='?' (Size = 4000), @p21='?' (Size = 4000), @p22='?' (DbType = Boolean), @p30='?' (Size = 8) (DbType = Binary), @p23='?' (Size = 4000), @p24='?' (DbType = Boolean), @p25='?' (DbType = Int64), @p26='?' (Size = 256), @p27='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [AspNetUsers] SET [AccessFailedCount] = @p0, [ConcurrencyStamp] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateUpdated] = @p4, [DeletedBy] = @p5, [Email] = @p6, [EmailConfirmed] = @p7, [FirstName] = @p8, [InstitutionId] = @p9, [IsActive] = @p10, [IsDeleted] = @p11, [IsFirstLogin] = @p12, [LastName] = @p13, [LastPasswordChangeDate] = @p14, [LockoutEnabled] = @p15, [LockoutEnd] = @p16, [MiddleName] = @p17, [NormalizedEmail] = @p18, [NormalizedUserName] = @p19, [PasswordHash] = @p20, [PhoneNumber] = @p21, [PhoneNumberConfirmed] = @p22, [SecurityStamp] = @p23, [TwoFactorEnabled] = @p24, [UpdatedBy] = @p25, [UserName] = @p26, [UserType] = @p27
WHERE [Id] = @p28 AND [ConcurrencyStamp] = @p29 AND [RowVersion] = @p30;
SELECT [RowVersion]
FROM [AspNetUsers]
WHERE @@ROWCOUNT = 1 AND [Id] = @p28; 
2023-12-27 06:41:50.7900|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__user_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[ClaimType], [a].[ClaimValue], [a].[Discriminator], [a].[UserId]
FROM [AspNetUserClaims] AS [a]
WHERE [a].[Discriminator] IN (N'IdentityUserClaim<long>', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 
2023-12-27 06:41:50.8118|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[Discriminator] IN (N'IdentityUserRole<long>', N'UserRole') AND ([a].[UserId] = @__userId_0) 
2023-12-27 06:41:50.8166|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[IsActive], [a].[Name], [a].[NormalizedName], [a].[RoleType], [a].[UpdatedBy]
FROM [AspNetRoles] AS [a]
WHERE [a].[NormalizedName] = @__normalizedName_0 
2023-12-27 06:41:50.8166|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__role_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[ClaimType], [a].[ClaimValue]
FROM [AspNetRoleClaims] AS [a]
WHERE [a].[RoleId] = @__role_Id_0 
2023-12-27 06:41:50.8166|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 
2023-12-27 06:41:50.8166||WARN|Authentication.Controllers.AccountController|About to send Email. 
2023-12-27 06:41:50.8166||WARN|Authentication.Data.Utility.Email.EmailUtilityService|Url Token : {url} 
2023-12-27 06:41:50.8343||WARN|Authentication.Data.Utility.Email.EmailUtilityService|Url: https://api.skilldorm.com/Notification/ 
2023-12-27 06:41:50.8343||WARN|Authentication.Data.Utility.Email.EmailUtilityService|EndPoint: api/Email/Send 
2023-12-27 06:41:52.3065||WARN|Authentication.Data.Utility.Email.EmailUtilityService|Response from Notification Service: {"data":null,"code":"00","success":true,"description":"Success"} 
2023-12-27 06:41:52.3065||WARN|Authentication.Data.Utility.Email.EmailUtilityService|Response from Notification Service: OK--OK--(null) 
2023-12-27 06:41:52.3137||WARN|Authentication.Controllers.AccountController|Done sending Email. 
2023-12-27 06:41:52.9250||ERROR|Authentication.Controllers.AccountController|Error Sending Email. Details System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
 ---> System.PlatformNotSupportedException: This instance contains state that cannot be serialized and deserialized on this platform.
   at System.Security.Claims.ClaimsPrincipal.OnSerializingMethod(StreamingContext context)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor, Boolean wrapExceptions)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
   at Newtonsoft.Json.Serialization.JsonContract.<>c__DisplayClass57_0.<CreateSerializationCallback>b__0(Object o, StreamingContext context)
   at Newtonsoft.Json.Serialization.JsonContract.InvokeOnSerializing(Object o, StreamingContext context)
   at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.OnSerializing(JsonWriter writer, JsonContract contract, Object value)
   at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeObject(JsonWriter writer, Object value, JsonObjectContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
   at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeValue(JsonWriter writer, Object value, JsonContract valueContract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerProperty)
   at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeObject(JsonWriter writer, Object value, JsonObjectContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
   at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeValue(JsonWriter writer, Object value, JsonContract valueContract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerProperty)
   at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.Serialize(JsonWriter jsonWriter, Object value, Type objectType)
   at Newtonsoft.Json.JsonSerializer.SerializeInternal(JsonWriter jsonWriter, Object value, Type objectType)
   at Newtonsoft.Json.JsonSerializer.Serialize(JsonWriter jsonWriter, Object value, Type objectType)
   at Newtonsoft.Json.JsonConvert.SerializeObjectInternal(Object value, Type type, JsonSerializer jsonSerializer)
   at Newtonsoft.Json.JsonConvert.SerializeObject(Object value, Type type, JsonSerializerSettings settings)
   at Newtonsoft.Json.JsonConvert.SerializeObject(Object value)
   at AuditTrailUtility.AuditTrails.CreateActivityLog(String description, String moduleName, String moduleAction, Int64 userid, Int64 institutionId, Object record, String agent, LogType logType) in C:\Program Files (x86)\Jenkins\workspace\SkillDorm-BE-V1\AuditTrailUtility\AuditTrail.cs:line 73
   at Authentication.Controllers.AccountController.GoogleResponse() in C:\Program Files (x86)\Jenkins\workspace\SkillDorm-BE-V1\Authentication\Controllers\AccountController.cs:line 1562 
2023-12-27 06:41:52.9250||WARN|Authentication.Controllers.AccountController|userUsername is dealogroupincorporated@gmail.com 
2023-12-27 06:41:52.9250|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__ToLower_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType]
FROM [AspNetUsers] AS [a]
WHERE LOWER([a].[UserName]) = @__ToLower_0 
2023-12-27 06:41:52.9250|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__checkUser_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[Address1], [s].[Address2], [s].[Age], [s].[Biography], [s].[Country], [s].[CreatedBy], [s].[DateCreated], [s].[DateModified], [s].[FaceBook], [s].[Headline], [s].[IsActive], [s].[IsDeleted], [s].[JobTitle], [s].[LinkedIn], [s].[ModifiedBy], [s].[Organization], [s].[ProfilePixUrl], [s].[Twitter], [s].[UserId], [s].[Website], [s].[YouTube]
FROM [Students] AS [s]
WHERE [s].[UserId] = @__checkUser_Id_0 
2023-12-27 06:41:52.9509||WARN|Authentication.Controllers.AccountController|Newresult is {"FirstName":"dealogroup","MiddleName":null,"LastName":"incorporated","IsFirstLogin":true,"FullName":"dealogroup incorporated","RowVersion":"AAAAAAAFR5U=","DateCreated":"2023-12-27T06:41:49.6745809","DateUpdated":null,"CreatedBy":0,"UpdatedBy":null,"DeletedBy":0,"IsDeleted":false,"IsActive":true,"InstitutionId":0,"UserType":1,"LastPasswordChangeDate":null,"Id":10637,"UserName":"dealogroupincorporated@gmail.com","NormalizedUserName":"DEALOGROUPINCORPORATED@GMAIL.COM","Email":"dealogroupincorporated@gmail.com","NormalizedEmail":"DEALOGROUPINCORPORATED@GMAIL.COM","EmailConfirmed":false,"PasswordHash":null,"SecurityStamp":"DVYWUB4GZPNY7VFWGMGGSNQ5LHO4N7UY","ConcurrencyStamp":"8d0afbd4-12a0-4154-9689-76d5a9ecebc9","PhoneNumber":null,"PhoneNumberConfirmed":false,"TwoFactorEnabled":false,"LockoutEnd":null,"LockoutEnabled":true,"AccessFailedCount":0} 
2023-12-27 06:41:52.9509|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[Discriminator] IN (N'IdentityUserRole<long>', N'UserRole') AND ([a].[UserId] = @__userId_0) 
2023-12-27 06:41:52.9509||WARN|Authentication.Controllers.AccountController|Role is STUDENT 
2023-12-27 06:41:52.9619|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__get_Item_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT [p].[Code]
FROM [RolePermissions] AS [r]
INNER JOIN [AspNetRoles] AS [a] ON [r].[RoleId] = [a].[Id]
INNER JOIN [Permissions] AS [p] ON [r].[PermissionId] = [p].[Id]
WHERE [a].[Name] = @__get_Item_0 
2023-12-27 06:41:53.1285|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p0='?' (DbType = DateTime2), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Size = 4000), @p4='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [UserToken] ([DateCreated], [ExpiryDate], [IsActive], [Token], [UserId])
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT [Id]
FROM [UserToken]
WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 
2023-12-27 06:41:53.1285|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[Discriminator] IN (N'IdentityUserRole<long>', N'UserRole') AND ([a].[UserId] = @__userId_0) 
2023-12-27 06:41:53.1285||WARN|Authentication.Controllers.AccountController|user: dealogroupincorporated@gmail.com - dealogroup incorporated role is gotten 
2023-12-27 06:41:53.4769||WARN|Authentication.Controllers.AccountController|serializedata = {"access_token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1lIjoiZGVhbG9ncm91cCIsImh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vd3MvMjAwOC8wNi9pZGVudGl0eS9jbGFpbXMvcHJpbWFyeXNpZCI6IjEwNjM3IiwiaHR0cDovL3NjaGVtYXMueG1sc29hcC5vcmcvd3MvMjAwNS8wNS9pZGVudGl0eS9jbGFpbXMvZ2l2ZW5uYW1lIjoiZGVhbG9ncm91cGluY29ycG9yYXRlZEBnbWFpbC5jb20iLCJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9lbWFpbGFkZHJlc3MiOiJkZWFsb2dyb3VwaW5jb3Jwb3JhdGVkQGdtYWlsLmNvbSIsImh0dHA6Ly9zY2hlbWFzLnhtbHNvYXAub3JnL3dzLzIwMDUvMDUvaWRlbnRpdHkvY2xhaW1zL2xvY2FsaXR5IjoiMCIsImh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vd3MvMjAwOC8wNi9pZGVudGl0eS9jbGFpbXMvcm9sZSI6IlNUVURFTlQiLCJleHAiOjE3MDM3NDIxMTIsImlzcyI6InNraWxsYmV0YV9yaXZldF9zdHVkaW8iLCJhdWQiOiJTa2lsbEJldGFSaXZldFN0dWRpbyJ9.DqMqMNGe1FpZua2QsZCnmbaWTkP1Y2kHWQFsm9c4-9M","refreshToken":"PHuxE6FylgSkb/cSlZoklzH9dWDl5bdqLThCZj/4jsw=","accesstoken_Expires":"2023-12-28T05:41:52Z","refreshToken_Expires":"2023-12-27T07:41:53.1174714+01:00","isFirstLogin":true,"role":"STUDENT","UserId":10637,"StudentProfile":10438,"UserName":"dealogroupincorporated@gmail.com","InstitutionId":0,"FirstName":"dealogroup","LastName":"incorporated"} 
2023-12-27 06:41:53.4769|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.RedirectResultExecutor|Executing RedirectResult, redirecting to https://www.skilldorm.com/course/discovery?data={"access_token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1lIjoiZGVhbG9ncm91cCIsImh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vd3MvMjAwOC8wNi9pZGVudGl0eS9jbGFpbXMvcHJpbWFyeXNpZCI6IjEwNjM3IiwiaHR0cDovL3NjaGVtYXMueG1sc29hcC5vcmcvd3MvMjAwNS8wNS9pZGVudGl0eS9jbGFpbXMvZ2l2ZW5uYW1lIjoiZGVhbG9ncm91cGluY29ycG9yYXRlZEBnbWFpbC5jb20iLCJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9lbWFpbGFkZHJlc3MiOiJkZWFsb2dyb3VwaW5jb3Jwb3JhdGVkQGdtYWlsLmNvbSIsImh0dHA6Ly9zY2hlbWFzLnhtbHNvYXAub3JnL3dzLzIwMDUvMDUvaWRlbnRpdHkvY2xhaW1zL2xvY2FsaXR5IjoiMCIsImh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vd3MvMjAwOC8wNi9pZGVudGl0eS9jbGFpbXMvcm9sZSI6IlNUVURFTlQiLCJleHAiOjE3MDM3NDIxMTIsImlzcyI6InNraWxsYmV0YV9yaXZldF9zdHVkaW8iLCJhdWQiOiJTa2lsbEJldGFSaXZldFN0dWRpbyJ9.DqMqMNGe1FpZua2QsZCnmbaWTkP1Y2kHWQFsm9c4-9M","refreshToken":"PHuxE6FylgSkb/cSlZoklzH9dWDl5bdqLThCZj/4jsw=","accesstoken_Expires":"2023-12-28T05:41:52Z","refreshToken_Expires":"2023-12-27T07:41:53.1174714+01:00","isFirstLogin":true,"role":"STUDENT","UserId":10637,"StudentProfile":10438,"UserName":"dealogroupincorporated@gmail.com","InstitutionId":0,"FirstName":"dealogroup","LastName":"incorporated"}. 
2023-12-27 06:41:53.4769|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.GoogleResponse (Authentication) in 3861.876ms 
2023-12-27 06:41:53.4769|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.GoogleResponse (Authentication)' 
2023-12-27 06:41:53.4769|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3873.4903ms 302  
2023-12-27 06:44:23.3477|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-12-27 06:44:23.3477|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-12-27 06:44:23.3477|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.1543ms 204  
2023-12-27 06:44:23.6964|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-12-27 06:44:23.6964|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-12-27 06:44:23.6964|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-12-27 06:44:23.6964|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 
2023-12-27 06:44:23.6964|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 06:44:23.6964|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 06:44:23.7066|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 
2023-12-27 06:44:23.7066|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 
2023-12-27 06:44:23.7066|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 15.0019ms 
2023-12-27 06:44:23.7066|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-12-27 06:44:23.7066|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 19.6465ms 200 application/json; charset=utf-8 
2023-12-27 07:21:16.8663|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:34126/AUTHENTICATION/iisintegration  0 
2023-12-27 07:21:16.8663|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.684ms 202  
2023-12-27 12:29:19.7465||DEBUG|Authentication.Program|init main function 
2023-12-27 12:29:20.4910|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 12:29:20.6701|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-12-27 12:29:20.6891|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-12-27 12:29:20.6891|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-12-27 12:29:20.6891|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-12-27 12:29:20.7000|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2023-12-27 12:29:20.7164|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2023-12-27 12:29:20.7930|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2023-12-27 12:29:20.7930|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 
2023-12-27 12:29:20.7930|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {b87c7207-d4dc-4028-b5c5-108088ee1d5b} with creation date 2023-12-27 11:29:20Z, activation date 2023-12-27 11:29:20Z, and expiration date 2024-03-26 11:29:20Z. 
2023-12-27 12:29:20.8076|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {b87c7207-d4dc-4028-b5c5-108088ee1d5b} may be persisted to storage in unencrypted form. 
2023-12-27 12:29:21.0696|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-12-27 12:29:21.1073|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-12-27 12:29:21.1073|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-12-27 12:29:21.1375|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 
2023-12-27 12:29:21.1375|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 12:29:21.1770|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 12:29:21.3099|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 
2023-12-27 12:29:21.3607|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 
2023-12-27 12:29:21.4351|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 294.9346ms 
2023-12-27 12:29:21.4351|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-12-27 12:29:21.4351|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 369.7997ms 200 application/json; charset=utf-8 
2023-12-27 12:50:19.5174|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:32766/AUTHENTICATION/iisintegration  0 
2023-12-27 12:50:19.5174|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0553ms 202  
2023-12-27 19:05:37.5247||DEBUG|Authentication.Program|init main function 
2023-12-27 19:05:42.1829|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 19:05:42.6996|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-12-27 19:05:42.7186|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-12-27 19:05:42.7186|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-12-27 19:05:42.7186|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-12-27 19:05:42.7186|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2023-12-27 19:05:42.8065|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2023-12-27 19:05:43.0333|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2023-12-27 19:05:43.0333|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 
2023-12-27 19:05:43.0333|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {5a28fa8f-e78a-4dce-8d8a-970d36e050da} with creation date 2023-12-27 18:05:43Z, activation date 2023-12-27 18:05:43Z, and expiration date 2024-03-26 18:05:43Z. 
2023-12-27 19:05:43.0443|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {5a28fa8f-e78a-4dce-8d8a-970d36e050da} may be persisted to storage in unencrypted form. 
2023-12-27 19:05:43.2021|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-12-27 19:05:43.2394|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-12-27 19:05:43.2394|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-12-27 19:05:43.2670|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 
2023-12-27 19:05:43.2670|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 19:05:43.3052|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-12-27 19:05:43.4356|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 
2023-12-27 19:05:43.4860|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 
2023-12-27 19:05:43.5583|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 288.7364ms 
2023-12-27 19:05:43.5596|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-12-27 19:05:43.5596|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 360.4287ms 200 application/json; charset=utf-8 
2023-12-27 19:26:36.0128|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:15025/AUTHENTICATION/iisintegration  0 
2023-12-27 19:26:36.0128|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0698ms 202