2024-09-18 01:32:53.0474||DEBUG|Authentication.Program|init main function 2024-09-18 01:32:53.7987|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 01:32:53.9808|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-09-18 01:32:53.9996|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-09-18 01:32:54.0026|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-09-18 01:32:54.0026|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-09-18 01:32:54.0026|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2024-09-18 01:32:54.0251|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2024-09-18 01:32:54.1020|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2024-09-18 01:32:54.1020|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-09-18 01:32:54.1081|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {fdbbc13d-63d7-446a-93cf-3d543ebb2cc3} with creation date 2024-09-18 00:32:54Z, activation date 2024-09-18 00:32:54Z, and expiration date 2024-12-17 00:32:54Z. 2024-09-18 01:32:54.1081|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {fdbbc13d-63d7-446a-93cf-3d543ebb2cc3} may be persisted to storage in unencrypted form. 2024-09-18 01:32:54.3786|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/Account/LinkedInLogin 2024-09-18 01:32:54.8289|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.LinkedInLogin (Authentication)' 2024-09-18 01:32:54.8449|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "LinkedInLogin", controller = "Account"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult LinkedInLogin() on controller Authentication.Controllers.AccountController (Authentication). 2024-09-18 01:32:54.8449|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 01:32:55.9263|1|INFO|Microsoft.AspNetCore.Mvc.ChallengeResult|Executing ChallengeResult with authentication schemes (LinkedIn). 2024-09-18 01:32:55.9263|1|DEBUG|AspNet.Security.OAuth.LinkedIn.LinkedInAuthenticationHandler|HandleChallenge with Location: https://www.linkedin.com/oauth/v2/authorization?client_id=77nzjvnk1ehwjv&scope=r_liteprofile%20r_emailaddress&response_type=code&redirect_uri=https%3A%2F%2Fapi.skilldorm.com%2FAuthentication%2Fsignin-linkedin&state=CfDJ8D3Bu_3XY2pEk889VD67LMP_kpwF7Ggaa6osazIRaRMXWUDFaaPlP8kPAZeot1ZePKyU3xOIMu2qyCI9a1TtWSGdGGuN-clpJUZhoY7BPOCV4I0qy8OwnzrIFCwpAyHvyW-iDZdWepAkfNIQEgct71Ri1o4HKc_fnP8vaoV0sfWez4jarWzhQLiYy7coMIEcNR3z6XJ0LXlLPs_9L04n79bvn_uJL5xshqwRc5HtMgPh5mvAlTXlOY_9c56kj24fhUaTxWIu3KkjDihL0o14VxB8nYirv9Lf0jdV4XIsVVbL; and Set-Cookie: .AspNetCore.Correlation.LinkedIn.XiNlFtW6YtTMyaicuVTvd8_WfxZOR5lUhrJsELtG8pg=N; expires=Wed, 18 Sep 2024 00:47:55 GMT; path=/Authentication/signin-linkedin; secure; samesite=none; httponly. 2024-09-18 01:32:55.9263|12|INFO|AspNet.Security.OAuth.LinkedIn.LinkedInAuthenticationHandler|AuthenticationScheme: LinkedIn was challenged. 2024-09-18 01:32:55.9368|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.LinkedInLogin (Authentication) in 1089.389ms 2024-09-18 01:32:55.9368|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.LinkedInLogin (Authentication)' 2024-09-18 01:32:55.9368|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1563.3308ms 302 2024-09-18 01:53:52.5406|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:24922/AUTHENTICATION/iisintegration 0 2024-09-18 01:53:52.5406|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.2494ms 202 2024-09-18 03:40:15.6903||DEBUG|Authentication.Program|init main function 2024-09-18 03:40:16.4453|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 03:40:16.6263|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-09-18 03:40:16.6449|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-09-18 03:40:16.6449|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-09-18 03:40:16.6449|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-09-18 03:40:16.6556|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2024-09-18 03:40:16.6686|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2024-09-18 03:40:16.7478|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2024-09-18 03:40:16.7478|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-09-18 03:40:16.7478|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {f7c925ac-b584-42f2-8c2a-da5616e24987} with creation date 2024-09-18 02:40:16Z, activation date 2024-09-18 02:40:16Z, and expiration date 2024-12-17 02:40:16Z. 2024-09-18 03:40:16.7478|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {f7c925ac-b584-42f2-8c2a-da5616e24987} may be persisted to storage in unencrypted form. 2024-09-18 03:40:17.0114|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-09-18 03:40:17.0504|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-09-18 03:40:17.0504|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-09-18 03:40:17.0834|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-09-18 03:40:17.0895|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 03:40:17.1227|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 03:40:17.2563|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-09-18 03:40:17.3078|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-09-18 03:40:17.3814|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 295.3669ms 2024-09-18 03:40:17.3814|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-09-18 03:40:17.3814|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 374.2458ms 200 application/json; charset=utf-8 2024-09-18 04:01:15.1018|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:16738/AUTHENTICATION/iisintegration 0 2024-09-18 04:01:15.1018|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.278ms 202 2024-09-18 11:35:06.5984||DEBUG|Authentication.Program|init main function 2024-09-18 11:35:10.7207|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 11:35:11.2884|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-09-18 11:35:11.3070|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-09-18 11:35:11.3100|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-09-18 11:35:11.3100|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-09-18 11:35:11.3100|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2024-09-18 11:35:11.4056|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2024-09-18 11:35:11.6636|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2024-09-18 11:35:11.6636|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-09-18 11:35:11.6700|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {d62c06ae-1899-4bbe-9369-4cf4ee499f27} with creation date 2024-09-18 10:35:11Z, activation date 2024-09-18 10:35:11Z, and expiration date 2024-12-17 10:35:11Z. 2024-09-18 11:35:11.6700|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {d62c06ae-1899-4bbe-9369-4cf4ee499f27} may be persisted to storage in unencrypted form. 2024-09-18 11:35:11.7631|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-09-18 11:35:11.8005|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-09-18 11:35:11.8005|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-09-18 11:35:11.8283|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-09-18 11:35:11.8283|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 11:35:11.8671|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 11:35:12.0002|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-09-18 11:35:12.0519|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-09-18 11:35:12.1276|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 296.4723ms 2024-09-18 11:35:12.1276|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-09-18 11:35:12.1276|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 369.5742ms 200 application/json; charset=utf-8 2024-09-18 11:35:27.4976|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-09-18 11:35:27.4976|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-09-18 11:35:27.4976|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-09-18 11:35:27.4976|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-09-18 11:35:27.4976|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 11:35:27.4976|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 11:35:27.4976|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2024-09-18 11:35:27.5134|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-09-18 11:35:27.5134|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 10.2375ms 2024-09-18 11:35:27.5134|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-09-18 11:35:27.5134|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 17.4404ms 200 application/json; charset=utf-8 2024-09-18 11:35:33.2643|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Admin/SignIn 2024-09-18 11:35:33.2643|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-09-18 11:35:33.2643|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.7987ms 204 2024-09-18 11:35:33.5300|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Admin/SignIn application/json 45 2024-09-18 11:35:33.5346|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-09-18 11:35:33.9427|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.AdminSignIn (Authentication)' 2024-09-18 11:35:33.9427|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "AdminSignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] AdminSignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 2024-09-18 11:35:33.9550|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 11:35:34.8518|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-09-18 11:35:34.8875|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 11:35:34.8950|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-09-18 11:35:34.9228|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-09-18 11:35:34.9460|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-09-18 11:35:34.9530|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-09-18 11:35:34.9659|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-09-18 11:35:34.9659|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2024-09-18 11:35:34.9659|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].[Biography], [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 [Staffs] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2024-09-18 11:35:35.3345|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-09-18 11:35:35.3345||WARN|Authentication.Controllers.AccountController|Role is INSTITUTION ADMIN 2024-09-18 11:35:35.3449|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-09-18 11:35:35.6235|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-09-18 11:35:35.6477|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-09-18 11:35:35.6477||INFO|Authentication.Controllers.AccountController|user: ELAN - Olabode Ogunfuye role is gotten 2024-09-18 11:35:35.6477|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 [Staffs] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2024-09-18 11:35:35.6550|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__roleName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT [r].[Id], [r].[CreatedBy], [r].[DateCreated], [r].[DateUpdated], [r].[IsActive], [r].[IsDeleted], [r].[PermissionId], [r].[RoleId], [r].[RowVersion], [r].[UpdatedBy] FROM [RolePermissions] AS [r] INNER JOIN [AspNetRoles] AS [a] ON [r].[RoleId] = [a].[Id] WHERE ([a].[Name] = @__roleName_0) AND ([r].[IsActive] = CAST(1 AS bit)) 2024-09-18 11:35:35.6550|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:35:35.6550|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:35:35.6550|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:35:35.6550|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:35:35.6550|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:35:35.6550|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:35:35.6550|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:35:35.6550|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:35:35.6550|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:35:35.6693|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:35:35.6693|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:35:35.6693|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:35:36.2654|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2024-09-18 11:35:36.2654|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.AdminSignIn (Authentication) in 2323.8898ms 2024-09-18 11:35:36.2654|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.AdminSignIn (Authentication)' 2024-09-18 11:35:36.2654|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2742.7153ms 200 application/json; charset=utf-8 2024-09-18 11:38:44.8739|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-09-18 11:38:44.8739|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-09-18 11:38:44.8739|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-09-18 11:38:44.8739|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-09-18 11:38:44.8739|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 11:38:44.8739|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 11:38:44.8739|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-09-18 11:38:44.8739|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-09-18 11:38:44.8739|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 7.759ms 2024-09-18 11:38:44.8860|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-09-18 11:38:44.8860|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 12.6392ms 200 application/json; charset=utf-8 2024-09-18 11:38:44.9118|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Admin/SignIn 2024-09-18 11:38:44.9118|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-09-18 11:38:44.9118|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.3394ms 204 2024-09-18 11:38:46.2725|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Admin/SignIn application/json 45 2024-09-18 11:38:46.2725|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-09-18 11:38:46.2725|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.AdminSignIn (Authentication)' 2024-09-18 11:38:46.2725|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "AdminSignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] AdminSignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 2024-09-18 11:38:46.2725|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 11:38:46.2858|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-09-18 11:38:46.2858|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 11:38:46.2858|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-09-18 11:38:46.2858|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-09-18 11:38:46.2933|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-09-18 11:38:46.2933|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-09-18 11:38:46.2933|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-09-18 11:38:46.2933|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2024-09-18 11:38:46.2933|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].[Biography], [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 [Staffs] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2024-09-18 11:38:46.2933|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-09-18 11:38:46.2933||WARN|Authentication.Controllers.AccountController|Role is INSTITUTION ADMIN 2024-09-18 11:38:46.2933|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-09-18 11:38:46.2933|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-09-18 11:38:46.2933|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-09-18 11:38:46.2933||INFO|Authentication.Controllers.AccountController|user: ELAN - Olabode Ogunfuye role is gotten 2024-09-18 11:38:46.3090|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 [Staffs] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2024-09-18 11:38:46.3090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__roleName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT [r].[Id], [r].[CreatedBy], [r].[DateCreated], [r].[DateUpdated], [r].[IsActive], [r].[IsDeleted], [r].[PermissionId], [r].[RoleId], [r].[RowVersion], [r].[UpdatedBy] FROM [RolePermissions] AS [r] INNER JOIN [AspNetRoles] AS [a] ON [r].[RoleId] = [a].[Id] WHERE ([a].[Name] = @__roleName_0) AND ([r].[IsActive] = CAST(1 AS bit)) 2024-09-18 11:38:46.3090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:38:46.3090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:38:46.3090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:38:46.3090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:38:46.3090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:38:46.3090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:38:46.3090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:38:46.3090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:38:46.3090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:38:46.3090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:38:46.3090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:38:46.3090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:38:46.3473|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2024-09-18 11:38:46.3473|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.AdminSignIn (Authentication) in 71.4765ms 2024-09-18 11:38:46.3473|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.AdminSignIn (Authentication)' 2024-09-18 11:38:46.3473|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 76.3369ms 200 application/json; charset=utf-8 2024-09-18 11:52:31.2082|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-09-18 11:52:31.2082|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-09-18 11:52:31.2082|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-09-18 11:52:31.2082|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-09-18 11:52:31.2082|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 11:52:31.2082|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 11:52:31.2211|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-09-18 11:52:31.2211|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-09-18 11:52:31.2211|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 13.0063ms 2024-09-18 11:52:31.2211|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-09-18 11:52:31.2211|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 16.1718ms 200 application/json; charset=utf-8 2024-09-18 11:53:20.8380|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Admin/SignIn 2024-09-18 11:53:20.8380|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-09-18 11:53:20.8380|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.9484ms 204 2024-09-18 11:53:21.4940|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Admin/SignIn application/json 45 2024-09-18 11:53:21.4940|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-09-18 11:53:21.4940|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.AdminSignIn (Authentication)' 2024-09-18 11:53:21.4940|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "AdminSignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] AdminSignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 2024-09-18 11:53:21.4940|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 11:53:21.5079|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-09-18 11:53:21.5079|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 11:53:21.5079|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-09-18 11:53:21.5079|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-09-18 11:53:21.5156|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-09-18 11:53:21.5156|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-09-18 11:53:21.5156|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-09-18 11:53:21.5156|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2024-09-18 11:53:21.5156|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].[Biography], [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 [Staffs] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2024-09-18 11:53:21.5156|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-09-18 11:53:21.5156||WARN|Authentication.Controllers.AccountController|Role is INSTITUTION ADMIN 2024-09-18 11:53:21.5156|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-09-18 11:53:21.5156|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-09-18 11:53:21.5324|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-09-18 11:53:21.5324||INFO|Authentication.Controllers.AccountController|user: ELAN - Olabode Ogunfuye role is gotten 2024-09-18 11:53:21.5324|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 [Staffs] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2024-09-18 11:53:21.5324|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__roleName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT [r].[Id], [r].[CreatedBy], [r].[DateCreated], [r].[DateUpdated], [r].[IsActive], [r].[IsDeleted], [r].[PermissionId], [r].[RoleId], [r].[RowVersion], [r].[UpdatedBy] FROM [RolePermissions] AS [r] INNER JOIN [AspNetRoles] AS [a] ON [r].[RoleId] = [a].[Id] WHERE ([a].[Name] = @__roleName_0) AND ([r].[IsActive] = CAST(1 AS bit)) 2024-09-18 11:53:21.5324|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:53:21.5324|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:53:21.5324|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:53:21.5324|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:53:21.5324|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:53:21.5324|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:53:21.5324|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:53:21.5324|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:53:21.5324|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:53:21.5324|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:53:21.5324|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:53:21.5324|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2024-09-18 11:53:21.5901|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2024-09-18 11:53:21.5901|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.AdminSignIn (Authentication) in 93.4414ms 2024-09-18 11:53:21.5901|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.AdminSignIn (Authentication)' 2024-09-18 11:53:21.5901|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 97.7043ms 200 application/json; charset=utf-8 2024-09-18 12:34:05.3609|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:23740/AUTHENTICATION/iisintegration 0 2024-09-18 12:34:05.3609|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.8976ms 202 2024-09-18 13:42:23.9958||DEBUG|Authentication.Program|init main function 2024-09-18 13:42:24.7430|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 13:42:24.9193|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-09-18 13:42:24.9380|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-09-18 13:42:24.9380|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-09-18 13:42:24.9380|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-09-18 13:42:24.9490|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2024-09-18 13:42:24.9619|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2024-09-18 13:42:25.0420|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2024-09-18 13:42:25.0420|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-09-18 13:42:25.0420|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {7f3c585a-944d-4b5a-bad8-7fd831084648} with creation date 2024-09-18 12:42:25Z, activation date 2024-09-18 12:42:25Z, and expiration date 2024-12-17 12:42:25Z. 2024-09-18 13:42:25.0542|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {7f3c585a-944d-4b5a-bad8-7fd831084648} may be persisted to storage in unencrypted form. 2024-09-18 13:42:25.3137|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-09-18 13:42:25.3516|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-09-18 13:42:25.3516|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-09-18 13:42:25.3837|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-09-18 13:42:25.3837|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 13:42:25.4232|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 13:42:25.5562|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-09-18 13:42:25.6092|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-09-18 13:42:25.6808|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 294.4819ms 2024-09-18 13:42:25.6808|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-09-18 13:42:25.6808|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 371.2115ms 200 application/json; charset=utf-8 2024-09-18 14:03:23.7642|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:39247/AUTHENTICATION/iisintegration 0 2024-09-18 14:03:23.7642|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.08ms 202 2024-09-18 23:20:29.6185||DEBUG|Authentication.Program|init main function 2024-09-18 23:20:30.3718|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 23:20:30.5509|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-09-18 23:20:30.5693|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-09-18 23:20:30.5723|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2024-09-18 23:20:30.5723|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2024-09-18 23:20:30.5723|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2024-09-18 23:20:30.5929|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2024-09-18 23:20:30.6680|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2024-09-18 23:20:30.6680|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-09-18 23:20:30.6680|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {a55a53d0-6b1c-47e9-ba87-cefc407d6298} with creation date 2024-09-18 22:20:30Z, activation date 2024-09-18 22:20:30Z, and expiration date 2024-12-17 22:20:30Z. 2024-09-18 23:20:30.6680|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {a55a53d0-6b1c-47e9-ba87-cefc407d6298} may be persisted to storage in unencrypted form. 2024-09-18 23:20:30.9408|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2024-09-18 23:20:30.9791|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2024-09-18 23:20:30.9791|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-09-18 23:20:31.0072|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-09-18 23:20:31.0131|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 23:20:31.0459|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2024-09-18 23:20:31.1791|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-09-18 23:20:31.2296|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-09-18 23:20:31.3016|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 291.8532ms 2024-09-18 23:20:31.3031|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2024-09-18 23:20:31.3031|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 366.1768ms 200 application/json; charset=utf-8 2024-09-18 23:41:28.3592|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:13775/AUTHENTICATION/iisintegration 0 2024-09-18 23:41:28.3592|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.3247ms 202