2025-12-13 00:12:09.4376|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:31828/AUTHENTICATIONSERVICE/iisintegration 0 2025-12-13 00:12:09.4435|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.9131ms 202 2025-12-13 00:12:19.7477||DEBUG|Authentication.Program|init main function 2025-12-13 00:12:21.3474|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-12-13 00:12:21.5687|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2025-12-13 00:12:21.5890|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2025-12-13 00:12:21.5890|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2025-12-13 00:12:21.5890|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2025-12-13 00:12:21.6031|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2025-12-13 00:12:21.6203|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2025-12-13 00:12:21.7278||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-12-13 00:12:21.9201|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/RefreshToken?Token=gl2UevIRWIpO+y6xUfbQqyMHJmuFA3WFij/ry/lKq0k= 2025-12-13 00:12:21.9474|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 00:12:21.9474|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 33.6153ms 204 2025-12-13 00:12:22.0135|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/RefreshToken?Token=gl2UevIRWIpO+y6xUfbQqyMHJmuFA3WFij/ry/lKq0k= 0 2025-12-13 00:12:22.0135|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 00:12:22.0249|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2025-12-13 00:12:22.0530|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-12-13 00:12:22.0530|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-12-13 00:12:22.2409|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (37ms) [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-12-13 00:12:22.2409|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'Microsoft.AspNetCore.Mvc.ProblemDetails'. 2025-12-13 00:12:22.3241|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.RefreshToken (Authentication) in 267.5941ms 2025-12-13 00:12:22.3241|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2025-12-13 00:12:22.3241|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 314.0258ms 401 application/problem+json; charset=utf-8 2025-12-13 00:12:36.8076|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/SignIn 2025-12-13 00:12:36.8076|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 00:12:36.8076|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.7884ms 204 2025-12-13 00:12:36.8650|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/SignIn application/json 59 2025-12-13 00:12:36.8650|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 00:12:36.8650|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.SignIn (Authentication)' 2025-12-13 00:12:36.8833|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-12-13 00:12:36.9089|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-12-13 00:12:36.9782|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].[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-12-13 00:12:37.0478|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [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-12-13 00:12:37.0890|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [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-12-13 00:12:37.1412|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', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 2025-12-13 00:12:37.1743|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2025-12-13 00:12:37.1874|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-12-13 00:12:37.2029|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-12-13 00:12:37.2111|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2025-12-13 00:12:37.2111|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-12-13 00:12:37.3987|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) 2025-12-13 00:12:37.3987|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-12-13 00:12:37.4453|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (5ms) [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-12-13 00:12:37.5383|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-12-13 00:12:37.5688|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-12-13 00:12:37.5882|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) 2025-12-13 00:12:37.5882||INFO|Authentication.Controllers.AccountController|useramansaray@MOF role is gotten 2025-12-13 00:12:37.5882|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-12-13 00:12:37.6107|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-12-13 00:12:37.6107|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-12-13 00:12:37.6107|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-12-13 00:12:37.6161|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-12-13 00:12:37.6161|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-12-13 00:12:37.6161|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-12-13 00:12:37.6161||INFO|Authentication.Controllers.AccountController|user amansaray@MOF is signin but about to call corporate service 2025-12-13 00:12:37.7349|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'AuditTrailUtility.Utility.SaveResponse'. 2025-12-13 00:12:37.7428|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.SignIn (Authentication) in 858.2095ms 2025-12-13 00:12:37.7428|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.SignIn (Authentication)' 2025-12-13 00:12:37.7428|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 882.2723ms 200 application/json; charset=utf-8 2025-12-13 00:12:38.1532|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/Admin/GetAllUsersByCorporateId?corporateId=207 2025-12-13 00:12:38.1532|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 00:12:38.1532|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.4865ms 204 2025-12-13 00:12:38.3931|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-12-13 00:12:38.3986|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 00:12:38.3986|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.GetAllUsersByCorporateId (Authentication)' 2025-12-13 00:12:38.3986|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-12-13 00:12:38.4180|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-12-13 00:12:38.4363|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-12-13 00:12:38.4576|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-12-13 00:12:38.4659|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.GetAllUsersByCorporateId (Authentication) in 57.1961ms 2025-12-13 00:12:38.4659|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.GetAllUsersByCorporateId (Authentication)' 2025-12-13 00:12:38.4659|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 74.8877ms 200 application/json; charset=utf-8 2025-12-13 00:32:40.0763|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/RefreshToken?Token=IwJG79JTb+sW1tWafTFjFX4uBG3RA6SrzVAQRKwH0II= 2025-12-13 00:32:40.0763|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 00:32:40.0763|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7.6328ms 204 2025-12-13 00:32:41.4315|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/RefreshToken?Token=IwJG79JTb+sW1tWafTFjFX4uBG3RA6SrzVAQRKwH0II= 0 2025-12-13 00:32:41.4315|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 00:32:41.4315|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2025-12-13 00:32:41.4315|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-12-13 00:32:41.4315|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-12-13 00:32:41.4773|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (20ms) [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-12-13 00:32:41.4773|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'Microsoft.AspNetCore.Mvc.ProblemDetails'. 2025-12-13 00:32:41.4773|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.RefreshToken (Authentication) in 45.0849ms 2025-12-13 00:32:41.4773|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2025-12-13 00:32:41.4773|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 59.8228ms 401 application/problem+json; charset=utf-8 2025-12-13 00:33:01.3227|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/SignIn 2025-12-13 00:33:01.3278|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 00:33:01.3278|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.0143ms 204 2025-12-13 00:33:03.7771|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/SignIn application/json 59 2025-12-13 00:33:03.7771|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 00:33:03.7771|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.SignIn (Authentication)' 2025-12-13 00:33:03.7771|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-12-13 00:33:03.7980|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-12-13 00:33:03.8083|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-12-13 00:33:03.8083|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [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-12-13 00:33:03.8083|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-12-13 00:33:03.8322|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', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 2025-12-13 00:33:03.8322|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) 2025-12-13 00:33:03.8416|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-12-13 00:33:03.8416|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-12-13 00:33:03.8416|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2025-12-13 00:33:03.8571|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-12-13 00:33:03.8805|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2025-12-13 00:33:03.8883|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-12-13 00:33:03.9092|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (15ms) [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-12-13 00:33:03.9194|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [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-12-13 00:33:03.9194|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-12-13 00:33:03.9350|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) 2025-12-13 00:33:03.9350||INFO|Authentication.Controllers.AccountController|useramansaray@MOF role is gotten 2025-12-13 00:33:03.9481|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-12-13 00:33:03.9481|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [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-12-13 00:33:03.9481|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-12-13 00:33:03.9481|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-12-13 00:33:03.9685|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-12-13 00:33:03.9685|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-12-13 00:33:03.9685|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-12-13 00:33:03.9685||INFO|Authentication.Controllers.AccountController|user amansaray@MOF is signin but about to call corporate service 2025-12-13 00:33:04.0335|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'AuditTrailUtility.Utility.SaveResponse'. 2025-12-13 00:33:04.0335|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.SignIn (Authentication) in 243.9126ms 2025-12-13 00:33:04.0335|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.SignIn (Authentication)' 2025-12-13 00:33:04.0427|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 265.8663ms 200 application/json; charset=utf-8 2025-12-13 00:33:06.9010|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/Admin/GetAllUsersByCorporateId?corporateId=207 2025-12-13 00:33:06.9053|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 00:33:06.9053|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.5655ms 204 2025-12-13 00:33:10.2115|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-12-13 00:33:10.2168|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 00:33:10.2168|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.GetAllUsersByCorporateId (Authentication)' 2025-12-13 00:33:10.2168|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-12-13 00:33:10.2168|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-12-13 00:33:10.2342|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-12-13 00:33:10.2454|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-12-13 00:33:10.2454|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.GetAllUsersByCorporateId (Authentication) in 24.1478ms 2025-12-13 00:33:10.2454|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.GetAllUsersByCorporateId (Authentication)' 2025-12-13 00:33:10.2454|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 41.2628ms 200 application/json; charset=utf-8 2025-12-13 00:53:19.1483|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:7134/AUTHENTICATIONSERVICE/iisintegration 0 2025-12-13 00:53:19.1598|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.5087ms 202 2025-12-13 00:53:31.4922||DEBUG|Authentication.Program|init main function 2025-12-13 00:53:36.5280|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-12-13 00:53:37.0329|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (16ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2025-12-13 00:53:37.0582|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2025-12-13 00:53:37.0582|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2025-12-13 00:53:37.0582|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2025-12-13 00:53:37.0850|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2025-12-13 00:53:37.4097|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2025-12-13 00:53:38.0254||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-12-13 00:53:38.2528|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/RefreshToken?Token=B3JHZ6rzeAiW1tq0Kcubcp6xGgfxRkEGCOPtXuWGf8A= 2025-12-13 00:53:38.2827|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 00:53:38.2827|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 37.2537ms 204 2025-12-13 00:53:38.4999|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/RefreshToken?Token=B3JHZ6rzeAiW1tq0Kcubcp6xGgfxRkEGCOPtXuWGf8A= 0 2025-12-13 00:53:38.4999|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 00:53:38.5144|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2025-12-13 00:53:38.5484|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-12-13 00:53:38.5584|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-12-13 00:53:38.7768|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (40ms) [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-12-13 00:53:38.8589|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (5ms) [Parameters=[@__p_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].[Id] = @__p_0 2025-12-13 00:53:39.3630|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (15ms) [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) 2025-12-13 00:53:39.3858|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [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-12-13 00:53:39.7794|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (8ms) [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-12-13 00:53:39.8681|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [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-12-13 00:53:39.9074|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-12-13 00:53:39.9295|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'Authentication.Data.Models.TokenResponse'. 2025-12-13 00:53:39.9548|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.RefreshToken (Authentication) in 1401.4759ms 2025-12-13 00:53:39.9548|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2025-12-13 00:53:39.9548|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1461.1681ms 200 application/json; charset=utf-8 2025-12-13 01:14:29.4966|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:7432/AUTHENTICATIONSERVICE/iisintegration 0 2025-12-13 01:14:29.5015|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.3215ms 202 2025-12-13 23:09:57.3544||DEBUG|Authentication.Program|init main function 2025-12-13 23:10:03.6805|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-12-13 23:10:04.4978|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (15ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2025-12-13 23:10:04.5199|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2025-12-13 23:10:04.5260|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2025-12-13 23:10:04.5260|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2025-12-13 23:10:04.5413|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2025-12-13 23:10:04.7348|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2025-12-13 23:10:05.4018||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-12-13 23:10:05.7119|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/SignIn 2025-12-13 23:10:05.7424|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 23:10:05.7424|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 39.2715ms 204 2025-12-13 23:10:06.0140|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/SignIn application/json 59 2025-12-13 23:10:06.0140|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 23:10:06.0300|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.SignIn (Authentication)' 2025-12-13 23:10:06.0624|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-12-13 23:10:06.0712|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-12-13 23:10:06.3652|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (40ms) [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-12-13 23:10:06.4609|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [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-12-13 23:10:06.5186|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-12-13 23:10:06.6316|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', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 2025-12-13 23:10:06.6685|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2025-12-13 23:10:06.6870|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-12-13 23:10:06.7063|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-12-13 23:10:06.7160|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2025-12-13 23:10:06.7160|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-12-13 23:10:07.5307|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2025-12-13 23:10:07.5458|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-12-13 23:10:07.9384|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (7ms) [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-12-13 23:10:08.0389|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [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-12-13 23:10:08.0755|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-12-13 23:10:08.0978|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', N'UserRole') AND ([a].[UserId] = @__userId_0) 2025-12-13 23:10:08.1044||INFO|Authentication.Controllers.AccountController|useramansaray@MOF role is gotten 2025-12-13 23:10:08.1154|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-12-13 23:10:08.1307|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-12-13 23:10:08.1307|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-12-13 23:10:08.1307|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-12-13 23:10:08.1307|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-12-13 23:10:08.1307|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-12-13 23:10:08.1307|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-12-13 23:10:08.1307||INFO|Authentication.Controllers.AccountController|user amansaray@MOF is signin but about to call corporate service 2025-12-13 23:10:08.3962|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'AuditTrailUtility.Utility.SaveResponse'. 2025-12-13 23:10:08.4167|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.SignIn (Authentication) in 2349.6297ms 2025-12-13 23:10:08.4167|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.SignIn (Authentication)' 2025-12-13 23:10:08.4167|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2408.4066ms 200 application/json; charset=utf-8 2025-12-13 23:10:08.7361|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AuthenticationService/api/Account/Admin/GetAllUsersByCorporateId?corporateId=207 2025-12-13 23:10:08.7441|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 23:10:08.7441|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 12.9339ms 204 2025-12-13 23:10:09.0097|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-12-13 23:10:09.0097|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-12-13 23:10:09.0213|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.GetAllUsersByCorporateId (Authentication)' 2025-12-13 23:10:09.0213|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-12-13 23:10:09.0656|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-12-13 23:10:09.0886|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-12-13 23:10:09.1172|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-12-13 23:10:09.1172|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.GetAllUsersByCorporateId (Authentication) in 94.7306ms 2025-12-13 23:10:09.1172|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.GetAllUsersByCorporateId (Authentication)' 2025-12-13 23:10:09.1321|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 122.5347ms 200 application/json; charset=utf-8 2025-12-13 23:30:55.6521|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:23759/AUTHENTICATIONSERVICE/iisintegration 0 2025-12-13 23:30:55.6521|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.5907ms 202