2025-11-15 13:03:37.6103||DEBUG|Authentication.Program|init main function 
2025-11-15 13:03:42.8230|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-15 13:03:43.3804|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (15ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-11-15 13:03:43.4016|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-11-15 13:03:43.4016|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-11-15 13:03:43.4016|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-11-15 13:03:43.4352|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-11-15 13:03:43.6305|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-11-15 13:03:44.3229||INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|User profile not available. Using 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\4.0.30319.0\AutoGenKeys\S-1-5-82-2404559740-2321761809-584227669-3522060946-2110276425\DataProtection' as key repository and Windows DPAPI to encrypt keys at rest. 
2025-11-15 13:03:44.7375|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/SignIn  0 
2025-11-15 13:03:44.7677|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 13:03:44.7746|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 37.7125ms 204  
2025-11-15 13:03:45.0647|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/SignIn application/json 65 
2025-11-15 13:03:45.0695|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 13:03:45.0695|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.SignIn (Authentication)' 
2025-11-15 13:03:45.1136|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 
2025-11-15 13:03:45.1221|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-15 13:03:45.4131|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (26ms) [Parameters=[@__ToLower_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[Address], [a].[BranchId], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DOB], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[MobileNumber], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType], [a].[UserTypeId]
FROM [AspNetUsers] AS [a]
WHERE LOWER([a].[UserName]) = @__ToLower_0 
2025-11-15 13:03:45.5176|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (10ms) [Parameters=[@__checkUser_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[SessionExpiryDate], [u].[Token], [u].[UserId]
FROM [UserToken] AS [u]
WHERE ([u].[UserId] = @__checkUser_Id_0) AND ([u].[IsActive] = CAST(1 AS bit))
ORDER BY [u].[Id] DESC 
2025-11-15 13:03:45.5565|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (15ms) [Parameters=[@__normalizedUserName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[Address], [a].[BranchId], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DOB], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[MobileNumber], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType], [a].[UserTypeId]
FROM [AspNetUsers] AS [a]
WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 
2025-11-15 13:03:45.6165||WARN|Microsoft.AspNetCore.Identity.UserManager|Invalid password for user 491. 
2025-11-15 13:03:45.6165|2|WARN|Microsoft.AspNetCore.Identity.SignInManager|User 491 failed to provide the correct password. 
2025-11-15 13:03:45.6344|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[@__normalizedUserName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[Address], [a].[BranchId], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DOB], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[MobileNumber], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType], [a].[UserTypeId]
FROM [AspNetUsers] AS [a]
WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 
2025-11-15 13:03:45.7369|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (4ms) [Parameters=[@p32='?' (DbType = Int64), @p0='?' (DbType = Int32), @p1='?' (Size = 4000), @p2='?' (DbType = Int64), @p3='?' (Size = 4000), @p33='?' (Size = 4000), @p4='?' (DbType = Int64), @p5='?' (DbType = DateTime2), @p6='?' (DbType = DateTime2), @p7='?' (DbType = DateTime2), @p8='?' (DbType = Int64), @p9='?' (Size = 256), @p10='?' (DbType = Boolean), @p11='?' (Size = 4000), @p12='?' (DbType = Boolean), @p13='?' (DbType = Boolean), @p14='?' (DbType = Boolean), @p15='?' (Size = 4000), @p16='?' (DbType = DateTime2), @p17='?' (DbType = Boolean), @p18='?' (DbType = DateTimeOffset), @p19='?' (Size = 4000), @p20='?' (Size = 4000), @p21='?' (Size = 256), @p22='?' (Size = 256), @p23='?' (Size = 4000), @p24='?' (Size = 4000), @p25='?' (DbType = Boolean), @p34='?' (Size = 8) (DbType = Binary), @p26='?' (Size = 4000), @p27='?' (DbType = Boolean), @p28='?' (DbType = Int64), @p29='?' (Size = 256), @p30='?' (DbType = Int32), @p31='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [AspNetUsers] SET [AccessFailedCount] = @p0, [Address] = @p1, [BranchId] = @p2, [ConcurrencyStamp] = @p3, [CreatedBy] = @p4, [DOB] = @p5, [DateCreated] = @p6, [DateUpdated] = @p7, [DeletedBy] = @p8, [Email] = @p9, [EmailConfirmed] = @p10, [FirstName] = @p11, [IsActive] = @p12, [IsDeleted] = @p13, [IsFirstLogin] = @p14, [LastName] = @p15, [LastPasswordChangeDate] = @p16, [LockoutEnabled] = @p17, [LockoutEnd] = @p18, [MiddleName] = @p19, [MobileNumber] = @p20, [NormalizedEmail] = @p21, [NormalizedUserName] = @p22, [PasswordHash] = @p23, [PhoneNumber] = @p24, [PhoneNumberConfirmed] = @p25, [SecurityStamp] = @p26, [TwoFactorEnabled] = @p27, [UpdatedBy] = @p28, [UserName] = @p29, [UserType] = @p30, [UserTypeId] = @p31
WHERE [Id] = @p32 AND [ConcurrencyStamp] = @p33 AND [RowVersion] = @p34;
SELECT [RowVersion]
FROM [AspNetUsers]
WHERE @@ROWCOUNT = 1 AND [Id] = @p32; 
2025-11-15 13:03:45.7726|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.String'. 
2025-11-15 13:03:45.7726|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.SignIn (Authentication) in 661.9139ms 
2025-11-15 13:03:45.7726|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.SignIn (Authentication)' 
2025-11-15 13:03:45.7726|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 721.1748ms 400 text/plain; charset=utf-8 
2025-11-15 13:04:59.6294|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/SignIn  0 
2025-11-15 13:04:59.6294|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 13:04:59.6294|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.3733ms 204  
2025-11-15 13:04:59.6579|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/SignIn application/json 65 
2025-11-15 13:04:59.6579|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 13:04:59.6579|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.SignIn (Authentication)' 
2025-11-15 13:04:59.6579|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 
2025-11-15 13:04:59.7078|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-15 13:04:59.7245|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[@__ToLower_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[Address], [a].[BranchId], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DOB], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[MobileNumber], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType], [a].[UserTypeId]
FROM [AspNetUsers] AS [a]
WHERE LOWER([a].[UserName]) = @__ToLower_0 
2025-11-15 13:04:59.7245|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (5ms) [Parameters=[@__checkUser_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[SessionExpiryDate], [u].[Token], [u].[UserId]
FROM [UserToken] AS [u]
WHERE ([u].[UserId] = @__checkUser_Id_0) AND ([u].[IsActive] = CAST(1 AS bit))
ORDER BY [u].[Id] DESC 
2025-11-15 13:04:59.7385|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].[Address], [a].[BranchId], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DOB], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[MobileNumber], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType], [a].[UserTypeId]
FROM [AspNetUsers] AS [a]
WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 
2025-11-15 13:04:59.7577|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].[Address], [a].[BranchId], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DOB], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[MobileNumber], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType], [a].[UserTypeId]
FROM [AspNetUsers] AS [a]
WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 
2025-11-15 13:04:59.7701|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@p32='?' (DbType = Int64), @p0='?' (DbType = Int32), @p1='?' (Size = 4000), @p2='?' (DbType = Int64), @p3='?' (Size = 4000), @p33='?' (Size = 4000), @p4='?' (DbType = Int64), @p5='?' (DbType = DateTime2), @p6='?' (DbType = DateTime2), @p7='?' (DbType = DateTime2), @p8='?' (DbType = Int64), @p9='?' (Size = 256), @p10='?' (DbType = Boolean), @p11='?' (Size = 4000), @p12='?' (DbType = Boolean), @p13='?' (DbType = Boolean), @p14='?' (DbType = Boolean), @p15='?' (Size = 4000), @p16='?' (DbType = DateTime2), @p17='?' (DbType = Boolean), @p18='?' (DbType = DateTimeOffset), @p19='?' (Size = 4000), @p20='?' (Size = 4000), @p21='?' (Size = 256), @p22='?' (Size = 256), @p23='?' (Size = 4000), @p24='?' (Size = 4000), @p25='?' (DbType = Boolean), @p34='?' (Size = 8) (DbType = Binary), @p26='?' (Size = 4000), @p27='?' (DbType = Boolean), @p28='?' (DbType = Int64), @p29='?' (Size = 256), @p30='?' (DbType = Int32), @p31='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [AspNetUsers] SET [AccessFailedCount] = @p0, [Address] = @p1, [BranchId] = @p2, [ConcurrencyStamp] = @p3, [CreatedBy] = @p4, [DOB] = @p5, [DateCreated] = @p6, [DateUpdated] = @p7, [DeletedBy] = @p8, [Email] = @p9, [EmailConfirmed] = @p10, [FirstName] = @p11, [IsActive] = @p12, [IsDeleted] = @p13, [IsFirstLogin] = @p14, [LastName] = @p15, [LastPasswordChangeDate] = @p16, [LockoutEnabled] = @p17, [LockoutEnd] = @p18, [MiddleName] = @p19, [MobileNumber] = @p20, [NormalizedEmail] = @p21, [NormalizedUserName] = @p22, [PasswordHash] = @p23, [PhoneNumber] = @p24, [PhoneNumberConfirmed] = @p25, [SecurityStamp] = @p26, [TwoFactorEnabled] = @p27, [UpdatedBy] = @p28, [UserName] = @p29, [UserType] = @p30, [UserTypeId] = @p31
WHERE [Id] = @p32 AND [ConcurrencyStamp] = @p33 AND [RowVersion] = @p34;
SELECT [RowVersion]
FROM [AspNetUsers]
WHERE @@ROWCOUNT = 1 AND [Id] = @p32; 
2025-11-15 13:04:59.8147|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__user_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[ClaimType], [a].[ClaimValue], [a].[Discriminator], [a].[UserId]
FROM [AspNetUserClaims] AS [a]
WHERE [a].[Discriminator] IN (N'IdentityUserClaim<long>', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 
2025-11-15 13:04:59.8497|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[Discriminator] IN (N'IdentityUserRole<long>', N'UserRole') AND ([a].[UserId] = @__userId_0) 
2025-11-15 13:04:59.8683|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [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].[InstitutionId], [a].[IsActive], [a].[Name], [a].[NormalizedName], [a].[UpdatedBy], [a].[UserType]
FROM [AspNetRoles] AS [a]
WHERE [a].[NormalizedName] = @__normalizedName_0 
2025-11-15 13:04:59.8894|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [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 
2025-11-15 13:04:59.8995|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 
2025-11-15 13:04:59.9058|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].[Address], [a].[BranchId], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DOB], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[MobileNumber], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType], [a].[UserTypeId]
FROM [AspNetUsers] AS [a]
WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 
2025-11-15 13:05:00.6200|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[Discriminator] IN (N'IdentityUserRole<long>', N'UserRole') AND ([a].[UserId] = @__userId_0) 
2025-11-15 13:05:00.6327|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__user_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [p].[Code]
FROM [UserPermissions] AS [u]
INNER JOIN [Permissions] AS [p] ON [u].[PermissionId] = [p].[Id]
WHERE ([u].[UserId] = @__user_Id_0) AND ([u].[IsActive] = CAST(1 AS bit)) 
2025-11-15 13:05:00.9964|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (9ms) [Parameters=[@__user_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[SessionExpiryDate], [u].[Token], [u].[UserId]
FROM [UserToken] AS [u]
WHERE ([u].[UserId] = @__user_Id_0) AND ([u].[IsActive] = CAST(1 AS bit)) 
2025-11-15 13:05:01.0500|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = DateTime2), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (DbType = DateTime2), @p4='?' (Size = 4000), @p5='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [UserToken] ([DateCreated], [ExpiryDate], [IsActive], [SessionExpiryDate], [Token], [UserId])
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT [Id]
FROM [UserToken]
WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 
2025-11-15 13:05:01.0658|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[Discriminator] IN (N'IdentityUserRole<long>', N'UserRole') AND ([a].[UserId] = @__userId_0) 
2025-11-15 13:05:01.0658||INFO|Authentication.Controllers.AccountController|usermmohai@MOF role is gotten 
2025-11-15 13:05:01.0792|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__user_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [u].[Id], [u].[CreatedBy], [u].[DateCreated], [u].[DateUpdated], [u].[IsActive], [u].[IsDeleted], [u].[PermissionId], [u].[RowVersion], [u].[UpdatedBy], [u].[UserId]
FROM [UserPermissions] AS [u]
WHERE ([u].[UserId] = @__user_Id_0) AND ([u].[IsActive] = CAST(1 AS bit)) 
2025-11-15 13:05:01.0957|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:05:01.0957|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:05:01.0957|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:05:01.0957|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:05:01.0957|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:05:01.0957|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:05:01.1090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:05:01.1090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:05:01.1090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:05:01.1090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:05:01.1090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:05:01.1090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:05:01.1090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:05:01.1090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:05:01.1090|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:05:01.1255|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:05:01.1255||INFO|Authentication.Controllers.AccountController|user mmohai@MOF is signin but about to call corporate service 
2025-11-15 13:05:01.3973|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'AuditTrailUtility.Utility.SaveResponse'. 
2025-11-15 13:05:01.4194|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.SignIn (Authentication) in 1747.8126ms 
2025-11-15 13:05:01.4215|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.SignIn (Authentication)' 
2025-11-15 13:05:01.4215|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1765.8582ms 200 application/json; charset=utf-8 
2025-11-15 13:05:01.5832|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/Admin/GetAllUsersByCorporateId?corporateId=207  0 
2025-11-15 13:05:01.5832|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 13:05:01.5832|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7.0407ms 204  
2025-11-15 13:05:01.6126|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/Admin/GetAllUsersByCorporateId?corporateId=207   
2025-11-15 13:05:01.6126|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 13:05:01.6272|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.GetAllUsersByCorporateId (Authentication)' 
2025-11-15 13:05:01.6272|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllUsersByCorporateId", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllUsersByCorporateId(Int64) on controller Authentication.Controllers.AccountController (Authentication). 
2025-11-15 13:05:01.6468|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-15 13:05:01.6709|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__corporateId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccessFailedCount], [a].[Address], [a].[BranchId], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DOB], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[MobileNumber], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType], [a].[UserTypeId]
FROM [AspNetUsers] AS [a]
WHERE [a].[UserTypeId] = @__corporateId_0 
2025-11-15 13:05:01.7047|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.UserBindingModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-15 13:05:01.7047|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.GetAllUsersByCorporateId (Authentication) in 76.684ms 
2025-11-15 13:05:01.7047|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.GetAllUsersByCorporateId (Authentication)' 
2025-11-15 13:05:01.7047|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 103.8996ms 200 application/json; charset=utf-8 
2025-11-15 13:06:51.1586|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/SignOut/491  0 
2025-11-15 13:06:51.1586|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 13:06:51.1650|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6.7759ms 204  
2025-11-15 13:06:51.1985|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/SignOut/491   
2025-11-15 13:06:51.1985|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 13:06:51.1985|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.SignOut (Authentication)' 
2025-11-15 13:06:51.2151|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SignOut", controller = "Account"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult SignOut(Int64) on controller Authentication.Controllers.AccountController (Authentication). 
2025-11-15 13:06:51.2151|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-15 13:06:51.2552|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[@__UserId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[SessionExpiryDate], [u].[Token], [u].[UserId]
FROM [UserToken] AS [u]
WHERE ([u].[UserId] = @__UserId_0) AND ([u].[IsActive] = CAST(1 AS bit)) 
2025-11-15 13:06:51.2750|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@p6='?' (DbType = Int64), @p0='?' (DbType = DateTime2), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (DbType = DateTime2), @p4='?' (Size = 4000), @p5='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [UserToken] SET [DateCreated] = @p0, [ExpiryDate] = @p1, [IsActive] = @p2, [SessionExpiryDate] = @p3, [Token] = @p4, [UserId] = @p5
WHERE [Id] = @p6;
SELECT @@ROWCOUNT; 
2025-11-15 13:06:51.2750|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'AuditTrailUtility.Utility.SaveResponse'. 
2025-11-15 13:06:51.2750|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.SignOut (Authentication) in 68.4461ms 
2025-11-15 13:06:51.2903|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.SignOut (Authentication)' 
2025-11-15 13:06:51.2903|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 94.7677ms 200 application/json; charset=utf-8 
2025-11-15 13:13:48.3783|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/SignIn  0 
2025-11-15 13:13:48.3783|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 13:13:48.3783|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.8618ms 204  
2025-11-15 13:13:48.8404|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/SignIn application/json 65 
2025-11-15 13:13:48.8458|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 13:13:48.8458|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.SignIn (Authentication)' 
2025-11-15 13:13:48.8458|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 
2025-11-15 13:13:48.8458|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-15 13:13:48.8752|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].[Address], [a].[BranchId], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DOB], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[MobileNumber], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType], [a].[UserTypeId]
FROM [AspNetUsers] AS [a]
WHERE LOWER([a].[UserName]) = @__ToLower_0 
2025-11-15 13:13:48.8752|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (9ms) [Parameters=[@__checkUser_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[SessionExpiryDate], [u].[Token], [u].[UserId]
FROM [UserToken] AS [u]
WHERE ([u].[UserId] = @__checkUser_Id_0) AND ([u].[IsActive] = CAST(1 AS bit))
ORDER BY [u].[Id] DESC 
2025-11-15 13:13:48.8946|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].[Address], [a].[BranchId], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DOB], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[MobileNumber], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType], [a].[UserTypeId]
FROM [AspNetUsers] AS [a]
WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 
2025-11-15 13:13:48.8946||WARN|Microsoft.AspNetCore.Identity.UserManager|Invalid password for user 493. 
2025-11-15 13:13:48.8946|2|WARN|Microsoft.AspNetCore.Identity.SignInManager|User 493 failed to provide the correct password. 
2025-11-15 13:13:48.9081|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].[Address], [a].[BranchId], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DOB], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[MobileNumber], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType], [a].[UserTypeId]
FROM [AspNetUsers] AS [a]
WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 
2025-11-15 13:13:48.9081|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@p32='?' (DbType = Int64), @p0='?' (DbType = Int32), @p1='?' (Size = 4000), @p2='?' (DbType = Int64), @p3='?' (Size = 4000), @p33='?' (Size = 4000), @p4='?' (DbType = Int64), @p5='?' (DbType = DateTime2), @p6='?' (DbType = DateTime2), @p7='?' (DbType = DateTime2), @p8='?' (DbType = Int64), @p9='?' (Size = 256), @p10='?' (DbType = Boolean), @p11='?' (Size = 4000), @p12='?' (DbType = Boolean), @p13='?' (DbType = Boolean), @p14='?' (DbType = Boolean), @p15='?' (Size = 4000), @p16='?' (DbType = DateTime2), @p17='?' (DbType = Boolean), @p18='?' (DbType = DateTimeOffset), @p19='?' (Size = 4000), @p20='?' (Size = 4000), @p21='?' (Size = 256), @p22='?' (Size = 256), @p23='?' (Size = 4000), @p24='?' (Size = 4000), @p25='?' (DbType = Boolean), @p34='?' (Size = 8) (DbType = Binary), @p26='?' (Size = 4000), @p27='?' (DbType = Boolean), @p28='?' (DbType = Int64), @p29='?' (Size = 256), @p30='?' (DbType = Int32), @p31='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [AspNetUsers] SET [AccessFailedCount] = @p0, [Address] = @p1, [BranchId] = @p2, [ConcurrencyStamp] = @p3, [CreatedBy] = @p4, [DOB] = @p5, [DateCreated] = @p6, [DateUpdated] = @p7, [DeletedBy] = @p8, [Email] = @p9, [EmailConfirmed] = @p10, [FirstName] = @p11, [IsActive] = @p12, [IsDeleted] = @p13, [IsFirstLogin] = @p14, [LastName] = @p15, [LastPasswordChangeDate] = @p16, [LockoutEnabled] = @p17, [LockoutEnd] = @p18, [MiddleName] = @p19, [MobileNumber] = @p20, [NormalizedEmail] = @p21, [NormalizedUserName] = @p22, [PasswordHash] = @p23, [PhoneNumber] = @p24, [PhoneNumberConfirmed] = @p25, [SecurityStamp] = @p26, [TwoFactorEnabled] = @p27, [UpdatedBy] = @p28, [UserName] = @p29, [UserType] = @p30, [UserTypeId] = @p31
WHERE [Id] = @p32 AND [ConcurrencyStamp] = @p33 AND [RowVersion] = @p34;
SELECT [RowVersion]
FROM [AspNetUsers]
WHERE @@ROWCOUNT = 1 AND [Id] = @p32; 
2025-11-15 13:13:48.9266|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.String'. 
2025-11-15 13:13:48.9266|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.SignIn (Authentication) in 75.4357ms 
2025-11-15 13:13:48.9266|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.SignIn (Authentication)' 
2025-11-15 13:13:48.9266|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 94.6351ms 400 text/plain; charset=utf-8 
2025-11-15 13:14:04.8542|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/SignIn  0 
2025-11-15 13:14:04.8542|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 13:14:04.8628|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.4716ms 204  
2025-11-15 13:14:05.3160|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/SignIn application/json 65 
2025-11-15 13:14:05.3160|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 13:14:05.3160|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.SignIn (Authentication)' 
2025-11-15 13:14:05.3160|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 
2025-11-15 13:14:05.3340|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-15 13:14:05.3340|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].[Address], [a].[BranchId], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DOB], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[MobileNumber], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType], [a].[UserTypeId]
FROM [AspNetUsers] AS [a]
WHERE LOWER([a].[UserName]) = @__ToLower_0 
2025-11-15 13:14:05.3502|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (5ms) [Parameters=[@__checkUser_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[SessionExpiryDate], [u].[Token], [u].[UserId]
FROM [UserToken] AS [u]
WHERE ([u].[UserId] = @__checkUser_Id_0) AND ([u].[IsActive] = CAST(1 AS bit))
ORDER BY [u].[Id] DESC 
2025-11-15 13:14:05.3502|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].[Address], [a].[BranchId], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DOB], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[MobileNumber], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType], [a].[UserTypeId]
FROM [AspNetUsers] AS [a]
WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 
2025-11-15 13:14:05.3670|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[@__normalizedUserName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[Address], [a].[BranchId], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DOB], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[MobileNumber], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType], [a].[UserTypeId]
FROM [AspNetUsers] AS [a]
WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 
2025-11-15 13:14:05.3779|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@p32='?' (DbType = Int64), @p0='?' (DbType = Int32), @p1='?' (Size = 4000), @p2='?' (DbType = Int64), @p3='?' (Size = 4000), @p33='?' (Size = 4000), @p4='?' (DbType = Int64), @p5='?' (DbType = DateTime2), @p6='?' (DbType = DateTime2), @p7='?' (DbType = DateTime2), @p8='?' (DbType = Int64), @p9='?' (Size = 256), @p10='?' (DbType = Boolean), @p11='?' (Size = 4000), @p12='?' (DbType = Boolean), @p13='?' (DbType = Boolean), @p14='?' (DbType = Boolean), @p15='?' (Size = 4000), @p16='?' (DbType = DateTime2), @p17='?' (DbType = Boolean), @p18='?' (DbType = DateTimeOffset), @p19='?' (Size = 4000), @p20='?' (Size = 4000), @p21='?' (Size = 256), @p22='?' (Size = 256), @p23='?' (Size = 4000), @p24='?' (Size = 4000), @p25='?' (DbType = Boolean), @p34='?' (Size = 8) (DbType = Binary), @p26='?' (Size = 4000), @p27='?' (DbType = Boolean), @p28='?' (DbType = Int64), @p29='?' (Size = 256), @p30='?' (DbType = Int32), @p31='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [AspNetUsers] SET [AccessFailedCount] = @p0, [Address] = @p1, [BranchId] = @p2, [ConcurrencyStamp] = @p3, [CreatedBy] = @p4, [DOB] = @p5, [DateCreated] = @p6, [DateUpdated] = @p7, [DeletedBy] = @p8, [Email] = @p9, [EmailConfirmed] = @p10, [FirstName] = @p11, [IsActive] = @p12, [IsDeleted] = @p13, [IsFirstLogin] = @p14, [LastName] = @p15, [LastPasswordChangeDate] = @p16, [LockoutEnabled] = @p17, [LockoutEnd] = @p18, [MiddleName] = @p19, [MobileNumber] = @p20, [NormalizedEmail] = @p21, [NormalizedUserName] = @p22, [PasswordHash] = @p23, [PhoneNumber] = @p24, [PhoneNumberConfirmed] = @p25, [SecurityStamp] = @p26, [TwoFactorEnabled] = @p27, [UpdatedBy] = @p28, [UserName] = @p29, [UserType] = @p30, [UserTypeId] = @p31
WHERE [Id] = @p32 AND [ConcurrencyStamp] = @p33 AND [RowVersion] = @p34;
SELECT [RowVersion]
FROM [AspNetUsers]
WHERE @@ROWCOUNT = 1 AND [Id] = @p32; 
2025-11-15 13:14:05.3856|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__user_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[ClaimType], [a].[ClaimValue], [a].[Discriminator], [a].[UserId]
FROM [AspNetUserClaims] AS [a]
WHERE [a].[Discriminator] IN (N'IdentityUserClaim<long>', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 
2025-11-15 13:14:05.3856|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[Discriminator] IN (N'IdentityUserRole<long>', N'UserRole') AND ([a].[UserId] = @__userId_0) 
2025-11-15 13:14:05.3856|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].[InstitutionId], [a].[IsActive], [a].[Name], [a].[NormalizedName], [a].[UpdatedBy], [a].[UserType]
FROM [AspNetRoles] AS [a]
WHERE [a].[NormalizedName] = @__normalizedName_0 
2025-11-15 13:14:05.3856|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 
2025-11-15 13:14:05.3856|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 
2025-11-15 13:14:05.3856|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].[Address], [a].[BranchId], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DOB], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[MobileNumber], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType], [a].[UserTypeId]
FROM [AspNetUsers] AS [a]
WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 
2025-11-15 13:14:05.4237|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[Discriminator] IN (N'IdentityUserRole<long>', N'UserRole') AND ([a].[UserId] = @__userId_0) 
2025-11-15 13:14:05.4237|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__user_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [p].[Code]
FROM [UserPermissions] AS [u]
INNER JOIN [Permissions] AS [p] ON [u].[PermissionId] = [p].[Id]
WHERE ([u].[UserId] = @__user_Id_0) AND ([u].[IsActive] = CAST(1 AS bit)) 
2025-11-15 13:14:05.4442|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (10ms) [Parameters=[@__user_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[SessionExpiryDate], [u].[Token], [u].[UserId]
FROM [UserToken] AS [u]
WHERE ([u].[UserId] = @__user_Id_0) AND ([u].[IsActive] = CAST(1 AS bit)) 
2025-11-15 13:14:05.4442|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p0='?' (DbType = DateTime2), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (DbType = DateTime2), @p4='?' (Size = 4000), @p5='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [UserToken] ([DateCreated], [ExpiryDate], [IsActive], [SessionExpiryDate], [Token], [UserId])
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT [Id]
FROM [UserToken]
WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 
2025-11-15 13:14:05.4573|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[Discriminator] IN (N'IdentityUserRole<long>', N'UserRole') AND ([a].[UserId] = @__userId_0) 
2025-11-15 13:14:05.4573||INFO|Authentication.Controllers.AccountController|userrwilliams@MOF role is gotten 
2025-11-15 13:14:05.4573|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__user_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [u].[Id], [u].[CreatedBy], [u].[DateCreated], [u].[DateUpdated], [u].[IsActive], [u].[IsDeleted], [u].[PermissionId], [u].[RowVersion], [u].[UpdatedBy], [u].[UserId]
FROM [UserPermissions] AS [u]
WHERE ([u].[UserId] = @__user_Id_0) AND ([u].[IsActive] = CAST(1 AS bit)) 
2025-11-15 13:14:05.4573|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:14:05.4573|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:14:05.4573|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:14:05.4712|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:14:05.4712|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:14:05.4712|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:14:05.4712|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:14:05.4712|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:14:05.4712|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:14:05.4712|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:14:05.4712|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:14:05.4871|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__item_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Code]
FROM [Permissions] AS [p]
WHERE [p].[Id] = @__item_PermissionId_0 
2025-11-15 13:14:05.4871||INFO|Authentication.Controllers.AccountController|user rwilliams@MOF is signin but about to call corporate service 
2025-11-15 13:14:05.5527|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'AuditTrailUtility.Utility.SaveResponse'. 
2025-11-15 13:14:05.5527|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.SignIn (Authentication) in 225.5059ms 
2025-11-15 13:14:05.5527|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.SignIn (Authentication)' 
2025-11-15 13:14:05.5527|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 242.8455ms 200 application/json; charset=utf-8 
2025-11-15 13:14:06.0972|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/Admin/GetAllUsersByCorporateId?corporateId=207  0 
2025-11-15 13:14:06.0972|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 13:14:06.0972|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7.5315ms 204  
2025-11-15 13:14:06.5633|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/Admin/GetAllUsersByCorporateId?corporateId=207   
2025-11-15 13:14:06.5670|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 13:14:06.5670|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.GetAllUsersByCorporateId (Authentication)' 
2025-11-15 13:14:06.5670|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllUsersByCorporateId", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllUsersByCorporateId(Int64) on controller Authentication.Controllers.AccountController (Authentication). 
2025-11-15 13:14:06.5670|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-15 13:14:06.5825|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[@__corporateId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccessFailedCount], [a].[Address], [a].[BranchId], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DOB], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[MobileNumber], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType], [a].[UserTypeId]
FROM [AspNetUsers] AS [a]
WHERE [a].[UserTypeId] = @__corporateId_0 
2025-11-15 13:14:06.5825|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.UserBindingModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-15 13:14:06.5825|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.GetAllUsersByCorporateId (Authentication) in 21.2771ms 
2025-11-15 13:14:06.5970|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.GetAllUsersByCorporateId (Authentication)' 
2025-11-15 13:14:06.5970|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 35.2941ms 200 application/json; charset=utf-8 
2025-11-15 13:34:35.9671|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:1037/AUTHENTICATIONSERVICE/iisintegration  0 
2025-11-15 13:34:35.9671|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3.7439ms 202  
2025-11-15 22:44:09.2305||DEBUG|Authentication.Program|init main function 
2025-11-15 22:44:13.2498|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-15 22:44:13.8622|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (16ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-11-15 22:44:13.8848|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-11-15 22:44:13.8848|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-11-15 22:44:13.8932|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-11-15 22:44:13.9100|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-11-15 22:44:14.0417|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-11-15 22:44:14.5890||INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|User profile not available. Using 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\4.0.30319.0\AutoGenKeys\S-1-5-82-2404559740-2321761809-584227669-3522060946-2110276425\DataProtection' as key repository and Windows DPAPI to encrypt keys at rest. 
2025-11-15 22:44:14.8402|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/RefreshToken?Token=jEmUmQVfrYLbgXm7KyoQI9NbB1bHeIXJ9dWUh5W5Y34=   
2025-11-15 22:44:14.8402|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/RefreshToken?Token=jEmUmQVfrYLbgXm7KyoQI9NbB1bHeIXJ9dWUh5W5Y34=   
2025-11-15 22:44:14.8714|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 22:44:14.8714|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 22:44:14.8836|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 44.1366ms 204  
2025-11-15 22:44:14.8836|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 44.1618ms 204  
2025-11-15 22:44:15.0374|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/RefreshToken?Token=jEmUmQVfrYLbgXm7KyoQI9NbB1bHeIXJ9dWUh5W5Y34=  0 
2025-11-15 22:44:15.0374|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/RefreshToken?Token=jEmUmQVfrYLbgXm7KyoQI9NbB1bHeIXJ9dWUh5W5Y34=  0 
2025-11-15 22:44:15.0374|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 22:44:15.0374|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 22:44:15.0555|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 
2025-11-15 22:44:15.0555|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 
2025-11-15 22:44:15.0901|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). 
2025-11-15 22:44:15.0901|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). 
2025-11-15 22:44:15.0993|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-15 22:44:15.0993|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-15 22:44:15.3057|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (44ms) [Parameters=[@__Token_0='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[SessionExpiryDate], [u].[Token], [u].[UserId]
FROM [UserToken] AS [u]
WHERE [u].[Token] = @__Token_0 
2025-11-15 22:44:15.3057|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (41ms) [Parameters=[@__Token_0='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[SessionExpiryDate], [u].[Token], [u].[UserId]
FROM [UserToken] AS [u]
WHERE [u].[Token] = @__Token_0 
2025-11-15 22:44:15.3639|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'Microsoft.AspNetCore.Mvc.ProblemDetails'. 
2025-11-15 22:44:15.3639|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'Microsoft.AspNetCore.Mvc.ProblemDetails'. 
2025-11-15 22:44:15.4648|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.RefreshToken (Authentication) in 370.0582ms 
2025-11-15 22:44:15.4648|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.RefreshToken (Authentication) in 366.971ms 
2025-11-15 22:44:15.4648|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 
2025-11-15 22:44:15.4648|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 
2025-11-15 22:44:15.4704|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 432.9993ms 401 application/problem+json; charset=utf-8 
2025-11-15 22:44:15.4704|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 433.0613ms 401 application/problem+json; charset=utf-8 
2025-11-15 22:44:16.0480|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/RefreshToken?Token=  0 
2025-11-15 22:44:16.0480|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/RefreshToken?Token=  0 
2025-11-15 22:44:16.0555|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 22:44:16.0555|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/RefreshToken?Token=  0 
2025-11-15 22:44:16.0555|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 22:44:16.0555|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 
2025-11-15 22:44:16.0645|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-15 22:44:16.0645|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 
2025-11-15 22:44:16.0645|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). 
2025-11-15 22:44:16.0645|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 
2025-11-15 22:44:16.0645|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). 
2025-11-15 22:44:16.0645|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). 
2025-11-15 22:44:16.1206|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-15 22:44:16.1206|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-15 22:44:16.1206|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-15 22:44:16.1457|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[SessionExpiryDate], [u].[Token], [u].[UserId]
FROM [UserToken] AS [u]
WHERE [u].[Token] IS NULL 
2025-11-15 22:44:16.1457|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'Microsoft.AspNetCore.Mvc.ProblemDetails'. 
2025-11-15 22:44:16.1457|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.RefreshToken (Authentication) in 73.7693ms 
2025-11-15 22:44:16.1457|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 
2025-11-15 22:44:16.1457|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 96.4104ms 401 application/problem+json; charset=utf-8 
2025-11-15 22:44:16.1457|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (21ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[SessionExpiryDate], [u].[Token], [u].[UserId]
FROM [UserToken] AS [u]
WHERE [u].[Token] IS NULL 
2025-11-15 22:44:16.1457|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'Microsoft.AspNetCore.Mvc.ProblemDetails'. 
2025-11-15 22:44:16.1457|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[SessionExpiryDate], [u].[Token], [u].[UserId]
FROM [UserToken] AS [u]
WHERE [u].[Token] IS NULL 
2025-11-15 22:44:16.1457|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.RefreshToken (Authentication) in 82.8098ms 
2025-11-15 22:44:16.1587|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'Microsoft.AspNetCore.Mvc.ProblemDetails'. 
2025-11-15 22:44:16.1587|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 
2025-11-15 22:44:16.1587|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.RefreshToken (Authentication) in 85.6682ms 
2025-11-15 22:44:16.1587|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 114.6532ms 401 application/problem+json; charset=utf-8 
2025-11-15 22:44:16.1587|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 
2025-11-15 22:44:16.1587|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 118.9807ms 401 application/problem+json; charset=utf-8 
2025-11-15 23:05:07.7798|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:17738/AUTHENTICATIONSERVICE/iisintegration  0 
2025-11-15 23:05:07.7842|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.3033ms 202