2023-06-11 00:48:53.0083|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:20392/AUTHENTICATION/iisintegration  0 
2023-06-11 00:48:53.0097|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.3541ms 202  
2023-06-11 10:35:35.4456||DEBUG|Authentication.Program|init main function 
2023-06-11 10:35:39.6167|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 10:35:40.1308|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-06-11 10:35:40.1511|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-06-11 10:35:40.1511|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-06-11 10:35:40.1511|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-06-11 10:35:40.1511|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2023-06-11 10:35:40.2371|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2023-06-11 10:35:40.4722|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2023-06-11 10:35:40.4722|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-06-11 10:35:40.4801|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {8daac529-79b0-47fd-b5e1-cfa4bb40e5fb} with creation date 2023-06-11 09:35:40Z, activation date 2023-06-11 09:35:40Z, and expiration date 2023-09-09 09:35:40Z. 
2023-06-11 10:35:40.4801|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {8daac529-79b0-47fd-b5e1-cfa4bb40e5fb} may be persisted to storage in unencrypted form. 
2023-06-11 10:35:40.7647|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-06-11 10:35:40.8052|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 10:35:40.8080|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 10:35:40.8336|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-06-11 10:35:40.8394|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 10:35:40.8724|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 10:35:41.0051|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-06-11 10:35:41.0559|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-06-11 10:35:41.1286|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 292.4502ms 
2023-06-11 10:35:41.1286|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 10:35:41.1286|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 369.5552ms 200 application/json; charset=utf-8 
2023-06-11 10:56:34.4264|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:25708/AUTHENTICATION/iisintegration  0 
2023-06-11 10:56:34.4264|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0938ms 202  
2023-06-11 11:55:56.6707||DEBUG|Authentication.Program|init main function 
2023-06-11 11:55:57.4236|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 11:55:57.6002|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-06-11 11:55:57.6187|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-06-11 11:55:57.6187|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-06-11 11:55:57.6187|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-06-11 11:55:57.6290|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2023-06-11 11:55:57.6418|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2023-06-11 11:55:57.7167|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2023-06-11 11:55:57.7167|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-06-11 11:55:57.7228|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {b9f7c0ce-da55-4c63-ad37-3e4359658a10} with creation date 2023-06-11 10:55:57Z, activation date 2023-06-11 10:55:57Z, and expiration date 2023-09-09 10:55:57Z. 
2023-06-11 11:55:57.7228|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {b9f7c0ce-da55-4c63-ad37-3e4359658a10} may be persisted to storage in unencrypted form. 
2023-06-11 11:55:57.9789|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-06-11 11:55:58.0163|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 11:55:58.0163|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 11:55:58.0462|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-06-11 11:55:58.0521|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 11:55:58.0855|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 11:55:58.2174|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-06-11 11:55:58.2676|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-06-11 11:55:58.3394|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 290.7162ms 
2023-06-11 11:55:58.3394|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 11:55:58.3394|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 364.8032ms 200 application/json; charset=utf-8 
2023-06-11 12:16:56.4044|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:5637/AUTHENTICATION/iisintegration  0 
2023-06-11 12:16:56.4044|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0714ms 202  
2023-06-11 20:38:55.1354||DEBUG|Authentication.Program|init main function 
2023-06-11 20:38:58.6599|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 20:38:59.1677|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-06-11 20:38:59.1860|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-06-11 20:38:59.1860|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-06-11 20:38:59.1860|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-06-11 20:38:59.1860|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2023-06-11 20:38:59.2773|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2023-06-11 20:38:59.5100|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2023-06-11 20:38:59.5100|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-06-11 20:38:59.5165|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {616f8494-c64d-49ac-8f0b-d56ba7ce1b68} with creation date 2023-06-11 19:38:59Z, activation date 2023-06-11 19:38:59Z, and expiration date 2023-09-09 19:38:59Z. 
2023-06-11 20:38:59.5165|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {616f8494-c64d-49ac-8f0b-d56ba7ce1b68} may be persisted to storage in unencrypted form. 
2023-06-11 20:38:59.7654|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-06-11 20:38:59.8022|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 20:38:59.8022|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 20:38:59.8296|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-06-11 20:38:59.8296|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 20:38:59.8683|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 20:38:59.9987|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-06-11 20:39:00.0505|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-06-11 20:39:00.1221|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 289.8454ms 
2023-06-11 20:39:00.1232|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 20:39:00.1232|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 360.6709ms 200 application/json; charset=utf-8 
2023-06-11 20:39:00.8595|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/SignIn   
2023-06-11 20:39:00.8595|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 20:39:00.8595|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3.2781ms 204  
2023-06-11 20:39:04.4762|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Student/SignIn application/json 65 
2023-06-11 20:39:04.4816|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 20:39:04.8271|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 
2023-06-11 20:39:04.8271|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "StudentSignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] StudentSignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 
2023-06-11 20:39:04.8271|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 20:39:05.6710|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [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-06-11 20:39:05.6710|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2023-06-11 20:39:05.6710|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.StudentSignIn (Authentication) in 842.2997ms 
2023-06-11 20:39:05.6710|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 
2023-06-11 20:39:05.6710|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1199.6607ms 200 application/json; charset=utf-8 
2023-06-11 20:39:14.6380|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/SignIn   
2023-06-11 20:39:14.6398|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 20:39:14.6398|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.7699ms 204  
2023-06-11 20:39:14.9396|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Student/SignIn application/json 65 
2023-06-11 20:39:14.9396|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 20:39:14.9396|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 
2023-06-11 20:39:14.9396|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "StudentSignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] StudentSignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 
2023-06-11 20:39:14.9511|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 20:39:14.9511|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-06-11 20:39:14.9511|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2023-06-11 20:39:14.9511|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.StudentSignIn (Authentication) in 21.2965ms 
2023-06-11 20:39:14.9511|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 
2023-06-11 20:39:14.9511|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 25.937ms 200 application/json; charset=utf-8 
2023-06-11 20:39:48.3184|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-06-11 20:39:48.3184|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 20:39:48.3184|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 20:39:48.3184|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-06-11 20:39:48.3184|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 20:39:48.3184|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 20:39:48.3268|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-06-11 20:39:48.3268|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-06-11 20:39:48.3268|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 6.9271ms 
2023-06-11 20:39:48.3268|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 20:39:48.3268|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.6134ms 200 application/json; charset=utf-8 
2023-06-11 20:44:31.4130|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-06-11 20:44:31.4130|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 20:44:31.4130|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 20:44:31.4154|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-06-11 20:44:31.4154|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 20:44:31.4154|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 20:44:31.4154|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-06-11 20:44:31.4154|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-06-11 20:44:31.4154|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 7.2579ms 
2023-06-11 20:44:31.4154|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 20:44:31.4154|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 10.6357ms 200 application/json; charset=utf-8 
2023-06-11 20:54:05.5489|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-06-11 20:54:05.5501|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 20:54:05.5501|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 20:54:05.5501|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-06-11 20:54:05.5501|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 20:54:05.5501|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 20:54:05.5501|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-06-11 20:54:05.5501|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-06-11 20:54:05.5501|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 11.671ms 
2023-06-11 20:54:05.5501|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 20:54:05.5501|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 14.5955ms 200 application/json; charset=utf-8 
2023-06-11 21:14:53.5778|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:42148/AUTHENTICATION/iisintegration  0 
2023-06-11 21:14:53.5778|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.9351ms 202  
2023-06-11 21:25:33.9388||DEBUG|Authentication.Program|init main function 
2023-06-11 21:25:34.7127|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 21:25:34.8960|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-06-11 21:25:34.9151|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-06-11 21:25:34.9182|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2023-06-11 21:25:34.9182|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2023-06-11 21:25:34.9182|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2023-06-11 21:25:34.9396|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2023-06-11 21:25:35.0219|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2023-06-11 21:25:35.0219|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-06-11 21:25:35.0314|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {195974e7-379c-4fab-8fe0-068c69002184} with creation date 2023-06-11 20:25:35Z, activation date 2023-06-11 20:25:35Z, and expiration date 2023-09-09 20:25:35Z. 
2023-06-11 21:25:35.0314|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {195974e7-379c-4fab-8fe0-068c69002184} may be persisted to storage in unencrypted form. 
2023-06-11 21:25:35.2298|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-06-11 21:25:35.2683|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 21:25:35.2683|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 21:25:35.3002|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-06-11 21:25:35.3002|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 21:25:35.3397|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 21:25:35.4759|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-06-11 21:25:35.5284|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-06-11 21:25:35.6025|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 299.6594ms 
2023-06-11 21:25:35.6025|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 21:25:35.6065|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 377.185ms 200 application/json; charset=utf-8 
2023-06-11 21:25:38.6338|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/SignIn   
2023-06-11 21:25:38.6338|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 21:25:38.6371|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3.4437ms 204  
2023-06-11 21:25:38.9176|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Student/SignIn application/json 57 
2023-06-11 21:25:38.9229|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 21:25:38.9358|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 
2023-06-11 21:25:38.9358|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "StudentSignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] StudentSignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 
2023-06-11 21:25:38.9358|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 21:25:39.0448|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [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-06-11 21:25:39.0751|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 21:25:39.0751|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-06-11 21:25:39.1085|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-06-11 21:25:39.1307|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-06-11 21:25:39.1307|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-06-11 21:25:39.1489|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-06-11 21:25:39.1538|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 
2023-06-11 21:25:39.1538|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userInfo_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] = @__userInfo_Id_0 
2023-06-11 21:25:39.1744|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-06-11 21:25:39.1744||WARN|Authentication.Controllers.AccountController|Role is STUDENT 
2023-06-11 21:25:39.1744|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-06-11 21:25:39.4353|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-06-11 21:25:39.4576|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-06-11 21:25:39.4576||INFO|Authentication.Controllers.AccountController|user: tamiloreog@gmail.com - Tamilore Oyegun role is gotten 
2023-06-11 21:25:39.4576|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userInfo_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [s].[ProfilePixUrl]
FROM [Students] AS [s]
WHERE [s].[UserId] = @__userInfo_Id_0 
2023-06-11 21:25:40.1703|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2023-06-11 21:25:40.1703|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.StudentSignIn (Authentication) in 1239.1544ms 
2023-06-11 21:25:40.1703|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 
2023-06-11 21:25:40.1703|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1263.3883ms 200 application/json; charset=utf-8 
2023-06-11 21:41:08.9401|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/RefreshToken   
2023-06-11 21:41:08.9401|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 21:41:08.9401|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.6068ms 204  
2023-06-11 21:41:09.2203|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/RefreshToken application/json 2 
2023-06-11 21:41:09.2203|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 21:41:09.2203|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 
2023-06-11 21:41:09.2203|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "RefreshToken", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] RefreshToken(System.String) on controller Authentication.Controllers.AccountController (Authentication). 
2023-06-11 21:41:09.2387|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 21:41:09.2585|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[Token], [u].[UserId]
FROM [UserToken] AS [u]
WHERE [u].[Token] IS NULL 
2023-06-11 21:41:09.2585|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.String'. 
2023-06-11 21:41:09.2585|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.RefreshToken (Authentication) in 28.6084ms 
2023-06-11 21:41:09.2585|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 
2023-06-11 21:41:09.2585|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 40.2186ms 401 text/plain; charset=utf-8 
2023-06-11 21:41:11.5807|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-06-11 21:41:11.5807|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 21:41:11.5807|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 21:41:11.5807|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-06-11 21:41:11.5807|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 21:41:11.5807|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 21:41:11.5807|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-06-11 21:41:11.5807|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-06-11 21:41:11.5807|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 6.7512ms 
2023-06-11 21:41:11.5807|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 21:41:11.5807|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.4287ms 200 application/json; charset=utf-8 
2023-06-11 21:41:19.3872|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-06-11 21:41:19.3872|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 21:41:19.3872|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 21:41:19.3872|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-06-11 21:41:19.3872|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 21:41:19.3918|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 21:41:19.3918|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-06-11 21:41:19.3918|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-06-11 21:41:19.3918|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 6.0439ms 
2023-06-11 21:41:19.3918|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 21:41:19.3918|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.6516ms 200 application/json; charset=utf-8 
2023-06-11 21:41:20.4492|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions   
2023-06-11 21:41:20.4492|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 21:41:20.4543|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 21:41:20.4543|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-06-11 21:41:20.4543|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 21:41:20.4543|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 21:41:20.4543|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-06-11 21:41:20.4543|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-06-11 21:41:20.4543|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 6.7784ms 
2023-06-11 21:41:20.4543|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 
2023-06-11 21:41:20.4543|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 13.4597ms 200 application/json; charset=utf-8 
2023-06-11 21:41:20.6194|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/SignIn   
2023-06-11 21:41:20.6194|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 21:41:20.6194|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.3818ms 204  
2023-06-11 21:41:20.9086|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Student/SignIn application/json 57 
2023-06-11 21:41:20.9086|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2023-06-11 21:41:20.9086|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 
2023-06-11 21:41:20.9086|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "StudentSignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] StudentSignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 
2023-06-11 21:41:20.9086|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 21:41:20.9086|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-06-11 21:41:20.9086|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2023-06-11 21:41:20.9239|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-06-11 21:41:20.9239|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [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-06-11 21:41:20.9239|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-06-11 21:41:20.9239|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [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-06-11 21:41:20.9239|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [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-06-11 21:41:20.9239|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 
2023-06-11 21:41:20.9239|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__userInfo_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] = @__userInfo_Id_0 
2023-06-11 21:41:20.9239|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-06-11 21:41:20.9239||WARN|Authentication.Controllers.AccountController|Role is STUDENT 
2023-06-11 21:41:20.9239|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [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-06-11 21:41:20.9383|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [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-06-11 21:41:20.9383|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-06-11 21:41:20.9383||INFO|Authentication.Controllers.AccountController|user: tamiloreog@gmail.com - Tamilore Oyegun role is gotten 
2023-06-11 21:41:20.9383|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__userInfo_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [s].[ProfilePixUrl]
FROM [Students] AS [s]
WHERE [s].[UserId] = @__userInfo_Id_0 
2023-06-11 21:41:20.9755|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2023-06-11 21:41:20.9755|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.StudentSignIn (Authentication) in 64.63ms 
2023-06-11 21:41:20.9755|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 
2023-06-11 21:41:20.9755|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 68.4444ms 200 application/json; charset=utf-8 
2023-06-11 22:20:33.6303|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:4211/AUTHENTICATION/iisintegration  0 
2023-06-11 22:20:33.6303|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.916ms 202