2024-12-18 04:19:07.3806||DEBUG|Authentication.Program|init main function 2024-12-18 04:19:10.2826|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 04:19:10.8767|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 04:19:10.8958|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 04:19:10.8958|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 04:19:10.8958|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 04:19:10.9098|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2024-12-18 04:19:11.0010|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2024-12-18 04:19:11.2692|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2024-12-18 04:19:11.2692|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. 2024-12-18 04:19:11.2692|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {ff286a8d-ba2f-41a7-b7f8-8f6a8cc3af25} with creation date 2024-12-18 03:19:11Z, activation date 2024-12-18 03:19:11Z, and expiration date 2025-03-18 03:19:11Z. 2024-12-18 04:19:11.2818|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {ff286a8d-ba2f-41a7-b7f8-8f6a8cc3af25} may be persisted to storage in unencrypted form. 2024-12-18 04:19:11.4138|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 04:19:11.4514|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 04:19:11.4514|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 04:19:11.4792|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). 2024-12-18 04:19:11.4852|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 04:19:11.5179|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 04:19:11.6499|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (7ms) [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)) 2024-12-18 04:19:11.7013|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]]'. 2024-12-18 04:19:11.7738|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 291.9127ms 2024-12-18 04:19:11.7738|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 04:19:11.7783|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 364.9604ms 200 application/json; charset=utf-8 2024-12-18 04:40:06.0462|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:35208/AUTHENTICATION/iisintegration 0 2024-12-18 04:40:06.0475|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.4037ms 202 2024-12-18 06:15:29.1970||DEBUG|Authentication.Program|init main function 2024-12-18 06:15:29.9321|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 06:15:30.1134|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 06:15:30.1334|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 06:15:30.1365|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 06:15:30.1365|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 06:15:30.1365|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2024-12-18 06:15:30.1574|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2024-12-18 06:15:30.2344|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2024-12-18 06:15:30.2344|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. 2024-12-18 06:15:30.2344|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {7c4da510-43f8-4033-a619-4b107cd6a3ca} with creation date 2024-12-18 05:15:30Z, activation date 2024-12-18 05:15:30Z, and expiration date 2025-03-18 05:15:30Z. 2024-12-18 06:15:30.2344|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {7c4da510-43f8-4033-a619-4b107cd6a3ca} may be persisted to storage in unencrypted form. 2024-12-18 06:15:30.5198|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 06:15:30.5582|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 06:15:30.5582|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 06:15:30.5862|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). 2024-12-18 06:15:30.5921|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 06:15:30.6248|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 06:15:30.7582|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (7ms) [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)) 2024-12-18 06:15:30.8094|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]]'. 2024-12-18 06:15:30.8818|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 293.0406ms 2024-12-18 06:15:30.8818|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 06:15:30.8818|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 366.2081ms 200 application/json; charset=utf-8 2024-12-18 06:36:28.9420|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:5335/AUTHENTICATION/iisintegration 0 2024-12-18 06:36:28.9420|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1411ms 202 2024-12-18 09:26:49.2191||DEBUG|Authentication.Program|init main function 2024-12-18 09:26:49.9572|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 09:26:50.1348|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 09:26:50.1533|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 09:26:50.1533|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 09:26:50.1533|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 09:26:50.1533|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2024-12-18 09:26:50.1765|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2024-12-18 09:26:50.2531|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2024-12-18 09:26:50.2531|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2024-12-18 09:26:50.2605|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {608e26fc-1074-4028-a35e-0ae11af00070} with creation date 2024-12-18 08:26:50Z, activation date 2024-12-18 08:26:50Z, and expiration date 2025-03-18 08:26:50Z. 2024-12-18 09:26:50.2605|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {608e26fc-1074-4028-a35e-0ae11af00070} may be persisted to storage in unencrypted form. 2024-12-18 09:26:50.5473|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 09:26:50.5849|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 09:26:50.5875|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 09:26:50.6128|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). 2024-12-18 09:26:50.6186|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 09:26:50.6507|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 09:26:50.7828|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (7ms) [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)) 2024-12-18 09:26:50.8356|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]]'. 2024-12-18 09:26:50.9090|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 293.6621ms 2024-12-18 09:26:50.9090|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 09:26:50.9090|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 365.7452ms 200 application/json; charset=utf-8 2024-12-18 09:47:48.9704|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:6815/AUTHENTICATION/iisintegration 0 2024-12-18 09:47:48.9704|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.2536ms 202 2024-12-18 12:19:04.9691||DEBUG|Authentication.Program|init main function 2024-12-18 12:19:07.1764|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 12:19:07.7540|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 12:19:07.7726|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 12:19:07.7726|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 12:19:07.7726|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 12:19:07.7726|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2024-12-18 12:19:07.8755|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2024-12-18 12:19:08.1382|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2024-12-18 12:19:08.1382|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. 2024-12-18 12:19:08.1382|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {fbd429c5-caf1-4aa1-a492-a8255a43a45d} with creation date 2024-12-18 11:19:08Z, activation date 2024-12-18 11:19:08Z, and expiration date 2025-03-18 11:19:08Z. 2024-12-18 12:19:08.1491|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {fbd429c5-caf1-4aa1-a492-a8255a43a45d} may be persisted to storage in unencrypted form. 2024-12-18 12:19:08.3192|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 12:19:08.3581|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 12:19:08.3581|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 12:19:08.3864|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). 2024-12-18 12:19:08.3864|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 12:19:08.4251|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 12:19:08.5575|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)) 2024-12-18 12:19:08.6090|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]]'. 2024-12-18 12:19:08.6813|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 292.3032ms 2024-12-18 12:19:08.6813|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 12:19:08.6813|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 366.3383ms 200 application/json; charset=utf-8 2024-12-18 12:39:53.8707|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:28728/AUTHENTICATION/iisintegration 0 2024-12-18 12:39:53.8707|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0684ms 202 2024-12-18 14:14:40.9584||DEBUG|Authentication.Program|init main function 2024-12-18 14:14:41.7013|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:14:41.8771|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 14:14:41.8956|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 14:14:41.8986|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 14:14:41.8986|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 14:14:41.8986|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2024-12-18 14:14:41.9192|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2024-12-18 14:14:41.9961|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2024-12-18 14:14:41.9961|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. 2024-12-18 14:14:41.9961|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {6d5f482d-e55e-4af3-9840-a35bb6ea8b0d} with creation date 2024-12-18 13:14:42Z, activation date 2024-12-18 13:14:41Z, and expiration date 2025-03-18 13:14:41Z. 2024-12-18 14:14:42.0084|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {6d5f482d-e55e-4af3-9840-a35bb6ea8b0d} may be persisted to storage in unencrypted form. 2024-12-18 14:14:42.2792|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/SignIn 2024-12-18 14:14:42.2792|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 14:14:42.3186|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 14:14:42.3186|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 14:14:42.3186|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 14:14:42.3186|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 46.6697ms 204 2024-12-18 14:14:42.3488|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). 2024-12-18 14:14:42.3488|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:14:42.3867|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:14:42.5183|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (7ms) [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)) 2024-12-18 14:14:42.5725|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]]'. 2024-12-18 14:14:42.6100|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Student/SignIn application/json 66 2024-12-18 14:14:42.6154|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 14:14:42.6424|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 291.1614ms 2024-12-18 14:14:42.6424|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 14:14:42.6445|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 366.1376ms 200 application/json; charset=utf-8 2024-12-18 14:14:43.0267|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2024-12-18 14:14:43.0267|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). 2024-12-18 14:14:43.0267|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:14:43.3998|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [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 2024-12-18 14:14:43.4302|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:14:43.4302|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [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 2024-12-18 14:14:43.4655|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', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 2024-12-18 14:14:43.4879|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 14:14:43.4932|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 2024-12-18 14:14:43.5056|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 2024-12-18 14:14:43.5056|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2024-12-18 14:14:43.5056|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 2024-12-18 14:14:43.5296|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 14:14:43.5296||WARN|Authentication.Controllers.AccountController|Role is STUDENT 2024-12-18 14:14:43.5412|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 2024-12-18 14:14:43.8134|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [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(); 2024-12-18 14:14:43.8362|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 14:14:43.8362||INFO|Authentication.Controllers.AccountController|user: aienghe@hotmail.com - Aienghe Alawani role is gotten 2024-12-18 14:14:43.8362|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 2024-12-18 14:14:44.3890|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2024-12-18 14:14:44.3890|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.StudentSignIn (Authentication) in 1362.1986ms 2024-12-18 14:14:44.3890|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2024-12-18 14:14:44.3890|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1785.4163ms 200 application/json; charset=utf-8 2024-12-18 14:38:23.8920|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 14:38:23.8957|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 14:38:23.8957|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 14:38:23.8957|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). 2024-12-18 14:38:23.8957|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:38:23.8957|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:38:23.9255|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)) 2024-12-18 14:38:23.9255|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]]'. 2024-12-18 14:38:23.9255|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 30.3303ms 2024-12-18 14:38:23.9255|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 14:38:23.9255|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 37.0001ms 200 application/json; charset=utf-8 2024-12-18 14:38:24.9179|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 14:38:24.9179|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 14:38:24.9179|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 14:38:24.9179|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). 2024-12-18 14:38:24.9179|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:38:24.9179|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:38:24.9284|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)) 2024-12-18 14:38:24.9284|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]]'. 2024-12-18 14:38:24.9284|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 8.5068ms 2024-12-18 14:38:24.9284|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 14:38:24.9284|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 14.1625ms 200 application/json; charset=utf-8 2024-12-18 14:38:25.7882|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/SignIn 2024-12-18 14:38:25.7882|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 14:38:25.7882|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.1152ms 204 2024-12-18 14:38:26.0765|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Student/SignIn application/json 66 2024-12-18 14:38:26.0765|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 14:38:26.0765|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2024-12-18 14:38:26.0765|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). 2024-12-18 14:38:26.0765|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:38:26.0900|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 2024-12-18 14:38:26.0900|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:38:26.0900|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 2024-12-18 14:38:26.0900|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', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 2024-12-18 14:38:26.0900|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 14:38:26.0900|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 2024-12-18 14:38:26.0900|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 2024-12-18 14:38:26.1003|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2024-12-18 14:38:26.1003|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 2024-12-18 14:38:26.1003|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 14:38:26.1003||WARN|Authentication.Controllers.AccountController|Role is STUDENT 2024-12-18 14:38:26.1003|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 2024-12-18 14:38:26.1003|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(); 2024-12-18 14:38:26.1003|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 14:38:26.1149||INFO|Authentication.Controllers.AccountController|user: aienghe@hotmail.com - Aienghe Alawani role is gotten 2024-12-18 14:38:26.1149|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 2024-12-18 14:38:26.1496|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2024-12-18 14:38:26.1496|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.StudentSignIn (Authentication) in 70.2168ms 2024-12-18 14:38:26.1496|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2024-12-18 14:38:26.1496|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 74.7853ms 200 application/json; charset=utf-8 2024-12-18 14:41:01.4935|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/RefreshToken 2024-12-18 14:41:01.4935|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 14:41:01.4935|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.8761ms 204 2024-12-18 14:41:02.0059|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/RefreshToken 2024-12-18 14:41:02.0059|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/RefreshToken application/json 2 2024-12-18 14:41:02.0059|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 14:41:02.0059|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 14:41:02.0059|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.0638ms 204 2024-12-18 14:41:02.0444|1|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Failed to validate the token. Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'. at Microsoft.IdentityModel.Tokens.Validators.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, SecurityToken securityToken, TokenValidationParameters validationParameters) at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, JwtSecurityToken jwtToken, TokenValidationParameters validationParameters) at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateTokenPayload(JwtSecurityToken jwtToken, TokenValidationParameters validationParameters) at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateToken(String token, TokenValidationParameters validationParameters, SecurityToken& validatedToken) at Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler.HandleAuthenticateAsync() 2024-12-18 14:41:02.0559|7|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Bearer was not authenticated. Failure message: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'. 2024-12-18 14:41:02.0559|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2024-12-18 14:41:02.0559|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). 2024-12-18 14:41:02.0559|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:41:02.0759|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [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 2024-12-18 14:41:02.0759|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.String'. 2024-12-18 14:41:02.0759|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.RefreshToken (Authentication) in 16.0147ms 2024-12-18 14:41:02.0759|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2024-12-18 14:41:02.0759|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 71.195ms 401 text/plain; charset=utf-8 2024-12-18 14:41:02.3129|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/RefreshToken application/json 2 2024-12-18 14:41:02.3129|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 14:41:02.3129|1|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Failed to validate the token. Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'. at Microsoft.IdentityModel.Tokens.Validators.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, SecurityToken securityToken, TokenValidationParameters validationParameters) at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, JwtSecurityToken jwtToken, TokenValidationParameters validationParameters) at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateTokenPayload(JwtSecurityToken jwtToken, TokenValidationParameters validationParameters) at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateToken(String token, TokenValidationParameters validationParameters, SecurityToken& validatedToken) at Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler.HandleAuthenticateAsync() 2024-12-18 14:41:02.3129|7|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Bearer was not authenticated. Failure message: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'. 2024-12-18 14:41:02.3129|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2024-12-18 14:41:02.3129|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). 2024-12-18 14:41:02.3129|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:41:02.3250|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [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 2024-12-18 14:41:02.3250|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.String'. 2024-12-18 14:41:02.3250|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.RefreshToken (Authentication) in 8.974ms 2024-12-18 14:41:02.3250|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2024-12-18 14:41:02.3250|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 13.8933ms 401 text/plain; charset=utf-8 2024-12-18 14:41:02.7262|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 14:41:02.7262|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 14:41:02.7262|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 14:41:02.7262|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). 2024-12-18 14:41:02.7262|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:41:02.7262|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:41:02.7262|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)) 2024-12-18 14:41:02.7262|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]]'. 2024-12-18 14:41:02.7262|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 6.9096ms 2024-12-18 14:41:02.7262|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 14:41:02.7262|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.5234ms 200 application/json; charset=utf-8 2024-12-18 14:41:08.5556|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/SignIn 2024-12-18 14:41:08.5556|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 14:41:08.5556|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.3091ms 204 2024-12-18 14:41:09.3746|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Student/SignIn application/json 66 2024-12-18 14:41:09.3746|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 14:41:09.3746|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2024-12-18 14:41:09.3746|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). 2024-12-18 14:41:09.3746|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:41:09.3844|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 2024-12-18 14:41:09.3844|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 14:41:09.3844|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 2024-12-18 14:41:09.3844|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', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 2024-12-18 14:41:09.3953|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 14:41:09.3953|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 2024-12-18 14:41:09.3953|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 2024-12-18 14:41:09.3953|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2024-12-18 14:41:09.3953|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 2024-12-18 14:41:09.3953|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 14:41:09.3953||WARN|Authentication.Controllers.AccountController|Role is STUDENT 2024-12-18 14:41:09.3953|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 2024-12-18 14:41:09.3953|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(); 2024-12-18 14:41:09.3953|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 14:41:09.3953||INFO|Authentication.Controllers.AccountController|user: aienghe@hotmail.com - Aienghe Alawani role is gotten 2024-12-18 14:41:09.3953|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 2024-12-18 14:41:09.4425|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2024-12-18 14:41:09.4425|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.StudentSignIn (Authentication) in 67.0047ms 2024-12-18 14:41:09.4425|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2024-12-18 14:41:09.4425|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 69.7105ms 200 application/json; charset=utf-8 2024-12-18 15:08:21.5649|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 15:08:21.5649|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 15:08:21.5649|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1028ms 204 2024-12-18 15:08:21.8422|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 15:08:21.8422|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 15:08:21.8422|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 15:08:21.8436|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). 2024-12-18 15:08:21.8436|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 15:08:21.8436|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 15:08:21.8436|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (4ms) [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)) 2024-12-18 15:08:21.8603|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]]'. 2024-12-18 15:08:21.8603|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 18.8205ms 2024-12-18 15:08:21.8603|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 15:08:21.8603|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 21.3393ms 200 application/json; charset=utf-8 2024-12-18 15:49:41.8062|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:18333/AUTHENTICATION/iisintegration 0 2024-12-18 15:49:41.8062|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.5087ms 202 2024-12-18 18:04:40.6789||DEBUG|Authentication.Program|init main function 2024-12-18 18:04:43.5887|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 18:04:44.1450|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 18:04:44.1634|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 18:04:44.1634|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 18:04:44.1634|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 18:04:44.1738|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2024-12-18 18:04:44.2649|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2024-12-18 18:04:44.5250|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2024-12-18 18:04:44.5256|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. 2024-12-18 18:04:44.5256|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {8025ab54-491a-42ad-a0bc-dc4caa4ea157} with creation date 2024-12-18 17:04:44Z, activation date 2024-12-18 17:04:44Z, and expiration date 2025-03-18 17:04:44Z. 2024-12-18 18:04:44.5256|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {8025ab54-491a-42ad-a0bc-dc4caa4ea157} may be persisted to storage in unencrypted form. 2024-12-18 18:04:44.7510|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 18:04:44.7878|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 18:04:44.7920|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 41.4082ms 204 2024-12-18 18:04:45.0879|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 18:04:45.0923|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 18:04:45.0923|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 18:04:45.1274|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). 2024-12-18 18:04:45.1274|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 18:04:45.1748|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 18:04:45.3298|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)) 2024-12-18 18:04:45.4090|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]]'. 2024-12-18 18:04:45.4849|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 354.6489ms 2024-12-18 18:04:45.4849|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 18:04:45.4849|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 399.9999ms 200 application/json; charset=utf-8 2024-12-18 18:27:02.1778|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:26144/AUTHENTICATION/iisintegration 0 2024-12-18 18:27:02.1778|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0744ms 202 2024-12-18 21:39:40.9717||DEBUG|Authentication.Program|init main function 2024-12-18 21:39:41.7517|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 21:39:41.9287|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 21:39:41.9476|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 21:39:41.9476|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 21:39:41.9476|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 21:39:41.9587|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2024-12-18 21:39:41.9587|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2024-12-18 21:39:42.0535|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2024-12-18 21:39:42.0535|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. 2024-12-18 21:39:42.0535|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {66811e5e-865b-4d3e-8ce4-d75db0f52cc8} with creation date 2024-12-18 20:39:42Z, activation date 2024-12-18 20:39:42Z, and expiration date 2025-03-18 20:39:42Z. 2024-12-18 21:39:42.0535|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {66811e5e-865b-4d3e-8ce4-d75db0f52cc8} may be persisted to storage in unencrypted form. 2024-12-18 21:39:42.2959|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 21:39:42.2959|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/SignIn 2024-12-18 21:39:42.3355|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 21:39:42.3355|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 21:39:42.3355|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 21:39:42.3355|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 46.8992ms 204 2024-12-18 21:39:42.3681|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). 2024-12-18 21:39:42.3681|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 21:39:42.4063|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 21:39:42.5394|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (7ms) [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)) 2024-12-18 21:39:42.5898|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]]'. 2024-12-18 21:39:42.6597|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 289.0618ms 2024-12-18 21:39:42.6597|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 21:39:42.6597|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 366.6217ms 200 application/json; charset=utf-8 2024-12-18 21:39:42.8323|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Student/SignIn application/json 66 2024-12-18 21:39:42.8382|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 21:39:43.2517|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2024-12-18 21:39:43.2517|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). 2024-12-18 21:39:43.2588|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 21:39:43.6253|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 2024-12-18 21:39:43.6557|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 21:39:43.6557|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 2024-12-18 21:39:43.6893|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', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 2024-12-18 21:39:43.7119|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 21:39:43.7119|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 2024-12-18 21:39:43.7300|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 2024-12-18 21:39:43.7300|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2024-12-18 21:39:43.7300|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 2024-12-18 21:39:43.7544|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 21:39:43.7544||WARN|Authentication.Controllers.AccountController|Role is STUDENT 2024-12-18 21:39:43.7626|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 2024-12-18 21:39:44.0372|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(); 2024-12-18 21:39:44.0600|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 21:39:44.0600||INFO|Authentication.Controllers.AccountController|user: aienghe@hotmail.com - Aienghe Alawani role is gotten 2024-12-18 21:39:44.0600|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 2024-12-18 21:39:44.4317|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2024-12-18 21:39:44.4317|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.StudentSignIn (Authentication) in 1180.9292ms 2024-12-18 21:39:44.4317|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2024-12-18 21:39:44.4317|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1606.912ms 200 application/json; charset=utf-8 2024-12-18 22:20:41.8552|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:26847/AUTHENTICATION/iisintegration 0 2024-12-18 22:20:41.8552|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0538ms 202 2024-12-18 22:43:02.9565||DEBUG|Authentication.Program|init main function 2024-12-18 22:43:03.6943|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:43:03.8749|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 22:43:03.8935|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 22:43:03.8935|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 22:43:03.8935|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 22:43:03.9039|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2024-12-18 22:43:03.9039|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2024-12-18 22:43:03.9918|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2024-12-18 22:43:03.9918|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. 2024-12-18 22:43:03.9977|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {44f834a5-bfa2-416f-8e15-b8b5f0262f89} with creation date 2024-12-18 21:43:03Z, activation date 2024-12-18 21:43:03Z, and expiration date 2025-03-18 21:43:03Z. 2024-12-18 22:43:03.9977|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {44f834a5-bfa2-416f-8e15-b8b5f0262f89} may be persisted to storage in unencrypted form. 2024-12-18 22:43:04.2762|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 22:43:04.2762|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/SignIn 0 2024-12-18 22:43:04.3160|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 22:43:04.3160|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 22:43:04.3160|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 22:43:04.3160|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 45.7688ms 204 2024-12-18 22:43:04.3456|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). 2024-12-18 22:43:04.3456|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:43:04.3837|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:43:04.5172|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (7ms) [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)) 2024-12-18 22:43:04.5676|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]]'. 2024-12-18 22:43:04.6369|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 288.8162ms 2024-12-18 22:43:04.6369|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 22:43:04.6369|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 363.5342ms 200 application/json; charset=utf-8 2024-12-18 22:43:04.7008|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Student/SignIn application/json 66 2024-12-18 22:43:04.7008|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 22:43:04.7191|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2024-12-18 22:43:04.7191|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). 2024-12-18 22:43:04.7191|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:43:04.9511|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 2024-12-18 22:43:04.9804|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:43:04.9804|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 2024-12-18 22:43:05.0144|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', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 2024-12-18 22:43:05.0368|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 22:43:05.0421|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 2024-12-18 22:43:05.0421|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 2024-12-18 22:43:05.0615|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2024-12-18 22:43:05.0615|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 2024-12-18 22:43:05.0820|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 22:43:05.0820||WARN|Authentication.Controllers.AccountController|Role is STUDENT 2024-12-18 22:43:05.0820|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 2024-12-18 22:43:05.2327|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(); 2024-12-18 22:43:05.2650|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 22:43:05.2650||INFO|Authentication.Controllers.AccountController|user: aienghe@hotmail.com - Aienghe Alawani role is gotten 2024-12-18 22:43:05.2650|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 2024-12-18 22:43:05.4313|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2024-12-18 22:43:05.4369|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.StudentSignIn (Authentication) in 713.3763ms 2024-12-18 22:43:05.4369|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2024-12-18 22:43:05.4369|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 736.7154ms 200 application/json; charset=utf-8 2024-12-18 22:48:16.3674|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 22:48:16.3711|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 22:48:16.3711|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 22:48:16.3711|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). 2024-12-18 22:48:16.3711|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:48:16.3858|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:48:16.3858|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)) 2024-12-18 22:48:16.3858|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]]'. 2024-12-18 22:48:16.3858|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 17.1863ms 2024-12-18 22:48:16.3858|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 22:48:16.3858|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 23.6523ms 200 application/json; charset=utf-8 2024-12-18 22:48:18.5267|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/SignIn 0 2024-12-18 22:48:18.5267|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 22:48:18.5267|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.4581ms 204 2024-12-18 22:48:18.7866|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Student/SignIn application/json 66 2024-12-18 22:48:18.7882|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 22:48:18.7882|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2024-12-18 22:48:18.7882|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). 2024-12-18 22:48:18.7882|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:48:19.2409|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 2024-12-18 22:48:19.2428|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:48:19.2428|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 2024-12-18 22:48:19.2428|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', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 2024-12-18 22:48:19.2428|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 22:48:19.2428|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 2024-12-18 22:48:19.2428|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 2024-12-18 22:48:19.2428|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2024-12-18 22:48:19.2428|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 2024-12-18 22:48:19.2428|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 22:48:19.2428||WARN|Authentication.Controllers.AccountController|Role is STUDENT 2024-12-18 22:48:19.2428|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 2024-12-18 22:48:19.2589|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(); 2024-12-18 22:48:19.2589|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 22:48:19.2589||INFO|Authentication.Controllers.AccountController|user: aienghe@hotmail.com - Aienghe Alawani role is gotten 2024-12-18 22:48:19.2589|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 2024-12-18 22:48:19.2942|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2024-12-18 22:48:19.2942|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.StudentSignIn (Authentication) in 505.449ms 2024-12-18 22:48:19.2942|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2024-12-18 22:48:19.2942|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 509.1224ms 200 application/json; charset=utf-8 2024-12-18 22:51:16.9540|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 0 2024-12-18 22:51:16.9540|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 22:51:16.9540|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.0882ms 204 2024-12-18 22:51:17.3405|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 22:51:17.3405|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 22:51:17.3405|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 22:51:17.3405|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). 2024-12-18 22:51:17.3405|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:51:17.3405|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:51:17.3405|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)) 2024-12-18 22:51:17.3405|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]]'. 2024-12-18 22:51:17.3405|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 6.0173ms 2024-12-18 22:51:17.3405|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 22:51:17.3405|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.9438ms 200 application/json; charset=utf-8 2024-12-18 22:55:35.1118|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 22:55:35.1118|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 22:55:35.1118|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 22:55:35.1118|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). 2024-12-18 22:55:35.1151|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:55:35.1151|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:55:35.1151|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)) 2024-12-18 22:55:35.1151|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]]'. 2024-12-18 22:55:35.1151|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 6.2429ms 2024-12-18 22:55:35.1151|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 22:55:35.1151|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.127ms 200 application/json; charset=utf-8 2024-12-18 22:55:38.5425|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/SignIn 0 2024-12-18 22:55:38.5425|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 22:55:38.5425|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.8056ms 204 2024-12-18 22:55:38.8275|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Student/SignIn application/json 66 2024-12-18 22:55:38.8275|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 22:55:38.8275|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2024-12-18 22:55:38.8275|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). 2024-12-18 22:55:38.8334|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:55:39.4079|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [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 2024-12-18 22:55:39.4079|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:55:39.4079|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 2024-12-18 22:55:39.4156|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', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 2024-12-18 22:55:39.4156|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 22:55:39.4156|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 2024-12-18 22:55:39.4156|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 2024-12-18 22:55:39.4156|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2024-12-18 22:55:39.4156|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 2024-12-18 22:55:39.4156|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 22:55:39.4156||WARN|Authentication.Controllers.AccountController|Role is STUDENT 2024-12-18 22:55:39.4156|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 2024-12-18 22:55:39.4156|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(); 2024-12-18 22:55:39.4293|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2024-12-18 22:55:39.4293||INFO|Authentication.Controllers.AccountController|user: aienghe@hotmail.com - Aienghe Alawani role is gotten 2024-12-18 22:55:39.4293|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 2024-12-18 22:55:39.4669|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2024-12-18 22:55:39.4669|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.StudentSignIn (Authentication) in 636.8113ms 2024-12-18 22:55:39.4669|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2024-12-18 22:55:39.4669|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 640.8041ms 200 application/json; charset=utf-8 2024-12-18 22:57:45.4720|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 0 2024-12-18 22:57:45.4720|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 22:57:45.4720|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.5424ms 204 2024-12-18 22:57:45.7796|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 22:57:45.7796|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 22:57:45.7796|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 22:57:45.7796|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). 2024-12-18 22:57:45.7830|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:57:45.7830|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 22:57:45.7830|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)) 2024-12-18 22:57:45.7830|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]]'. 2024-12-18 22:57:45.7830|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 10.7124ms 2024-12-18 22:57:45.7830|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 22:57:45.7830|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 13.8007ms 200 application/json; charset=utf-8 2024-12-18 23:37:46.7174|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:13335/AUTHENTICATION/iisintegration 0 2024-12-18 23:37:46.7174|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.5272ms 202 2024-12-18 23:38:49.7344||DEBUG|Authentication.Program|init main function 2024-12-18 23:38:50.4752|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 23:38:50.6552|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 23:38:50.6736|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 23:38:50.6765|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-12-18 23:38:50.6765|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-12-18 23:38:50.6765|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2024-12-18 23:38:50.6970|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2024-12-18 23:38:50.7734|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2024-12-18 23:38:50.7734|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. 2024-12-18 23:38:50.7734|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {f987bd21-a41e-4e93-94ba-795a8ef13d36} with creation date 2024-12-18 22:38:50Z, activation date 2024-12-18 22:38:50Z, and expiration date 2025-03-18 22:38:50Z. 2024-12-18 23:38:50.7734|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {f987bd21-a41e-4e93-94ba-795a8ef13d36} may be persisted to storage in unencrypted form. 2024-12-18 23:38:51.0614|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-12-18 23:38:51.0997|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-12-18 23:38:51.1023|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 23:38:51.1274|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). 2024-12-18 23:38:51.1331|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 23:38:51.1657|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-12-18 23:38:51.2973|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (7ms) [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)) 2024-12-18 23:38:51.3482|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]]'. 2024-12-18 23:38:51.4200|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 290.0067ms 2024-12-18 23:38:51.4200|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-12-18 23:38:51.4200|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 362.7108ms 200 application/json; charset=utf-8