2025-12-25 13:44:09.4272||DEBUG|AccountManagement.Program|init main function 
2025-12-25 13:44:14.8708|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'WaysMeans'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-12-25 13:44:14.8845|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CurrentBalance' on entity type 'SourceAccountManagements'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-12-25 13:44:14.8893|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'OverdraftLimit' on entity type 'SourceAccountManagements'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-12-25 13:44:14.9164|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-12-25 13:44:15.5754|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (15ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-12-25 13:44:15.5979|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-12-25 13:44:15.5979|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-12-25 13:44:15.6071|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-12-25 13:44:15.6241|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-12-25 13:44:15.6406|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-12-25 13:44:16.4597||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-636400548-2315632189-4083574877-3698939047-2307078153\DataProtection' as key repository and Windows DPAPI to encrypt keys at rest. 
2025-12-25 13:44:16.7383|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207   
2025-12-25 13:44:16.7383|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance   
2025-12-25 13:44:16.7383|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current   
2025-12-25 13:44:17.3802|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 13:44:17.3802|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 13:44:17.3802|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 13:44:17.3950|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 656.861ms 204  
2025-12-25 13:44:17.3950|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 656.863ms 204  
2025-12-25 13:44:17.3950|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 656.895ms 204  
2025-12-25 13:44:17.5976|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current   
2025-12-25 13:44:17.5976|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207   
2025-12-25 13:44:17.5976|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance   
2025-12-25 13:44:17.8808|1|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Failed to validate the token. Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'.
   at Microsoft.IdentityModel.Tokens.Validators.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, SecurityToken securityToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, JwtSecurityToken jwtToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateTokenPayload(JwtSecurityToken jwtToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateToken(String token, TokenValidationParameters validationParameters, SecurityToken& validatedToken)
   at Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler.HandleAuthenticateAsync()
2025-12-25 13:44:17.8808|1|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Failed to validate the token. Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'.
   at Microsoft.IdentityModel.Tokens.Validators.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, SecurityToken securityToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, JwtSecurityToken jwtToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateTokenPayload(JwtSecurityToken jwtToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateToken(String token, TokenValidationParameters validationParameters, SecurityToken& validatedToken)
   at Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler.HandleAuthenticateAsync()
2025-12-25 13:44:17.8808|1|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Failed to validate the token. Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'.
   at Microsoft.IdentityModel.Tokens.Validators.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, SecurityToken securityToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, JwtSecurityToken jwtToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateTokenPayload(JwtSecurityToken jwtToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateToken(String token, TokenValidationParameters validationParameters, SecurityToken& validatedToken)
   at Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler.HandleAuthenticateAsync()
2025-12-25 13:44:17.9002|7|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Bearer was not authenticated. Failure message: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'. 
2025-12-25 13:44:17.9034|7|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Bearer was not authenticated. Failure message: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'. 
2025-12-25 13:44:17.9034|7|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Bearer was not authenticated. Failure message: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'. 
2025-12-25 13:44:17.9034|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 13:44:17.9034|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 13:44:17.9034|2|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization failed. 
2025-12-25 13:44:17.9034|2|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization failed. 
2025-12-25 13:44:17.9034|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 13:44:17.9216|2|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization failed. 
2025-12-25 13:44:17.9216|12|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|AuthenticationScheme: Bearer was challenged. 
2025-12-25 13:44:17.9216|12|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|AuthenticationScheme: Bearer was challenged. 
2025-12-25 13:44:17.9216|12|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|AuthenticationScheme: Bearer was challenged. 
2025-12-25 13:44:17.9216|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 321.3038ms 401  
2025-12-25 13:44:17.9216|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 327.7706ms 401  
2025-12-25 13:44:17.9216|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 326.5314ms 401  
2025-12-25 14:00:41.7902|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAllInitiatePaymentSourceAccountsByUserId?userId=493   
2025-12-25 14:00:41.7970|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:00:41.7970|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.5589ms 204  
2025-12-25 14:00:41.8227|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current   
2025-12-25 14:00:41.8263|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207   
2025-12-25 14:00:41.8263|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance   
2025-12-25 14:00:41.8263|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:00:41.8263|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:00:41.8263|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:00:41.8263|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 13.9519ms 204  
2025-12-25 14:00:41.8263|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 12.399ms 204  
2025-12-25 14:00:41.8263|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 14.0402ms 204  
2025-12-25 14:00:42.0313|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAllInitiatePaymentSourceAccountsByUserId?userId=493   
2025-12-25 14:00:42.0551|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current   
2025-12-25 14:00:42.0551|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207   
2025-12-25 14:00:42.0551|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-12-25 14:00:42.0551|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-12-25 14:00:42.0622|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-12-25 14:00:42.0622|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:00:42.0622|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:00:42.0622|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:00:42.0622|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-12-25 14:00:42.0622|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance   
2025-12-25 14:00:42.0622|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-12-25 14:00:42.0622|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-12-25 14:00:42.0622|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement)' 
2025-12-25 14:00:42.0757|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-12-25 14:00:42.0757|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 
2025-12-25 14:00:42.0757|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 
2025-12-25 14:00:42.0757|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:00:42.0757|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-12-25 14:00:42.0757|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 
2025-12-25 14:00:42.1104|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "FetchCurrentWaysMeans", controller = "WaysMeans"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult FetchCurrentWaysMeans() on controller AccountManagement.Controllers.WaysMeansController (AccountManagement). 
2025-12-25 14:00:42.1104|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-12-25 14:00:42.1262|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllInitiatePaymentSourceAccountsByUserId", controller = "AccountManagement"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllInitiatePaymentSourceAccountsByUserIdAsync(Int64) on controller AccountManagement.Controllers.AccountManagementController (AccountManagement). 
2025-12-25 14:00:42.1262|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAccountByCorporateId", controller = "AccountManagement"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAccountByCorporateIdAsync(Int64) on controller AccountManagement.Controllers.AccountManagementController (AccountManagement). 
2025-12-25 14:00:42.1262|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "FetchBalance", controller = "TreasuryAccount"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] FetchBalance(System.Nullable`1[CorporatePay.Common.GovernmentAccountType]) on controller AccountManagement.Controllers.TreasuryAccountController (AccountManagement). 
2025-12-25 14:00:42.1540||WARN|AccountManagement.Core.Services.TreasuryAccountService|CorporateId : 207 
2025-12-25 14:00:42.1540|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-12-25 14:00:42.1540|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-12-25 14:00:42.3880|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [w].[Id], [w].[Amount], [w].[Comment], [w].[CreatedBy], [w].[DateCreated], [w].[DateModified], [w].[IsActive], [w].[IsDeleted], [w].[ModifiedBy], [w].[Year]
FROM [WaysMeans] AS [w]
WHERE ([w].[IsDeleted] = CAST(0 AS bit)) AND ([w].[IsActive] = CAST(1 AS bit))
ORDER BY [w].[Id] DESC 
2025-12-25 14:00:42.4573|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (46ms) [Parameters=[@__Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [s].[Id], [s].[AccountName], [s].[AccountNumber], [s].[ApprovalStatus], [s].[ApprovalStatusDate], [s].[ApprovedBy], [s].[BankId], [s].[BankName], [s].[Code], [s].[CreatedBy], [s].[Currency], [s].[CurrentBalance], [s].[CurrentBalanceLastUpdatedTime], [s].[DateCreated], [s].[DateModified], [s].[IsActive], [s].[IsDeleted], [s].[ModifiedBy], [s].[OverdraftLimit], [s].[RejectionComment], [s].[UserType], [s].[UserTypeId]
FROM [SourceAccountManagements] AS [s]
WHERE (([s].[UserTypeId] = @__Id_0) AND ([s].[IsDeleted] = CAST(0 AS bit))) AND ([s].[IsActive] = CAST(1 AS bit)) 
2025-12-25 14:00:42.4573|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (48ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName], [s].[Id], [s].[AccountName], [s].[AccountNumber], [s].[ApprovalStatus], [s].[ApprovalStatusDate], [s].[ApprovedBy], [s].[BankId], [s].[BankName], [s].[Code], [s].[CreatedBy], [s].[Currency], [s].[CurrentBalance], [s].[CurrentBalanceLastUpdatedTime], [s].[DateCreated], [s].[DateModified], [s].[IsActive], [s].[IsDeleted], [s].[ModifiedBy], [s].[OverdraftLimit], [s].[RejectionComment], [s].[UserType], [s].[UserTypeId], [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType]
FROM [AccountPermissions] AS [a]
LEFT JOIN [SourceAccountManagements] AS [s] ON [a].[AccountsId] = [s].[Id]
INNER JOIN [Permissions] AS [p] ON [a].[PermissionId] = [p].[Id]
WHERE ((((([a].[UserId] = @__userId_0) AND ([a].[PermissionName] = N'Can Initiate Payment On Source Account')) AND ([a].[IsActive] = CAST(1 AS bit))) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([s].[IsActive] = CAST(1 AS bit))) AND ([s].[IsDeleted] = CAST(0 AS bit)) 
2025-12-25 14:00:42.4573|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[AccountManagement.Data.Models.WaysMeansModel, AccountManagement.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-12-25 14:00:42.4751|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[AccountManagement.Data.Entity.AccountPermission, AccountManagement.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-12-25 14:00:42.4851||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 
2025-12-25 14:00:42.4851|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement) in 358.9625ms 
2025-12-25 14:00:42.4851||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 
2025-12-25 14:00:42.4851|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement) in 378.248ms 
2025-12-25 14:00:42.4851|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement)' 
2025-12-25 14:00:42.4851||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 
2025-12-25 14:00:42.4851|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 
2025-12-25 14:00:42.4851|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 464.9727ms 200 application/json; charset=utf-8 
2025-12-25 14:00:42.4980|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 442.9923ms 200 application/json; charset=utf-8 
2025-12-25 14:00:42.4980||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 
2025-12-25 14:00:42.7210||WARN|AccountManagement.Core.Services.IntegrationService|Response: {
  "data": [
    {
      "id": 41,
      "name": "T24",
      "transactionType": 1,
      "integrationType": 1,
      "institutionId": 79,
      "routeServices": [
        {
          "routeId": 41,
          "serviceType": 4,
          "endPoint": "/api/SL/CorporatePayApi/V2/FundsTransfer"
        },
        {
          "routeId": 41,
          "serviceType": 5,
          "endPoint": "/api/SL/CorporatePayApi/V2/CheckOverDrawnAccount?accountNumber="
        },
        {
          "routeId": 41,
          "serviceType": 6,
          "endPoint": "/api/SL/CorporatePayApi/V2/TransactionStatusQuery?refNo={Ref}"
        },
        {
          "routeId": 41,
          "serviceType": 1,
          "endPoint": "/api/SL/CorporatePayApi/V2/NameEnquiry?accountNumber="
        },
        {
          "routeId": 41,
          "serviceType": 2,
          "endPoint": "/api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber="
        }
      ],
      "routeParameters": [
        {
          "routeId": 41,
          "name": "Url",
          "value": "https://rcpayapi.mof.gov.sl/CorporatePayApi/"
        },
        {
          "routeId": 41,
          "name": "WebServiceUrl",
          "value": "http://10.117.0.150:9090/TWS/services?wsdl"
        },
        {
          "routeId": 41,
          "name": "UserName",
          "value": "EFTUSER"
        },
        {
          "routeId": 41,
          "name": "Password",
          "value": "FINANCE123456"
        }
      ]
    },
    {
      "id": 42,
      "name": "NotonUs",
      "transactionType": 2,
      "integrationType": 1,
      "institutionId": 79,
      "routeServices": [
        {
          "routeId": 42,
          "serviceType": 1,
          "endPoint": "/api/SL/CorporatePayAPI/V2/NameEnquiry/OtherBank?accountNumber="
        },
        {
          "routeId": 42,
          "serviceType": 4,
          "endPoint": "/api/SL/CorporatePayAPI/V2/FundsTransfer/OtherBank"
        },
        {
          "routeId": 42,
          "serviceType": 6,
          "endPoint": "/api/SL/CorporatePayApi/V2/TransactionStatusQuery?refNo={Ref}"
        }
      ],
      "routeParameters": [
        {
          "routeId": 42,
          "name": "Url",
          "value": "https://rcpayapi.mof.gov.sl/CorporatePayApi/"
        },
        {
          "routeId": 42,
          "name": "WebServiceUrl",
          "value": "http://10.117.0.150:9090/TWS/services?wsdl"
        },
        {
          "routeId": 42,
          "name": "UserName",
          "value": "EFTUSER"
        },
        {
          "routeId": 42,
          "name": "Password",
          "value": "FINANCE123456"
        }
      ]
    },
    {
      "id": 43,
      "name": "ForeignPayment",
      "transactionType": 3,
      "integrationType": 1,
      "institutionId": 79,
      "routeServices": [
        {
          "routeId": 43,
          "serviceType": 4,
          "endPoint": "/api/SL/CorporatePayAPI/V2/FundsTransfer/Foreign"
        },
        {
          "routeId": 43,
          "serviceType": 6,
          "endPoint": "/api/SL/CorporatePayAPI/V2/TransactionStatusQuery/OtherBank?refNo={Ref}"
        }
      ],
      "routeParameters": [
        {
          "routeId": 43,
          "name": "Url",
          "value": "https://rcpayapi.mof.gov.sl/CorporatePayApi/"
        },
        {
          "routeId": 43,
          "name": "WebServiceUrl",
          "value": "http://10.117.0.150:9090/TWS/services?wsdl"
        },
        {
          "routeId": 43,
          "name": "UserName",
          "value": "EFTUSER"
        },
        {
          "routeId": 43,
          "name": "Password",
          "value": "FINANCE123456"
        }
      ]
    }
  ],
  "code": "00",
  "success": true,
  "description": "Success"
}::: OK::: OK 
2025-12-25 14:00:42.7210||WARN|AccountManagement.Core.Services.IntegrationService|Response: {
  "data": [
    {
      "id": 41,
      "name": "T24",
      "transactionType": 1,
      "integrationType": 1,
      "institutionId": 79,
      "routeServices": [
        {
          "routeId": 41,
          "serviceType": 4,
          "endPoint": "/api/SL/CorporatePayApi/V2/FundsTransfer"
        },
        {
          "routeId": 41,
          "serviceType": 5,
          "endPoint": "/api/SL/CorporatePayApi/V2/CheckOverDrawnAccount?accountNumber="
        },
        {
          "routeId": 41,
          "serviceType": 6,
          "endPoint": "/api/SL/CorporatePayApi/V2/TransactionStatusQuery?refNo={Ref}"
        },
        {
          "routeId": 41,
          "serviceType": 1,
          "endPoint": "/api/SL/CorporatePayApi/V2/NameEnquiry?accountNumber="
        },
        {
          "routeId": 41,
          "serviceType": 2,
          "endPoint": "/api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber="
        }
      ],
      "routeParameters": [
        {
          "routeId": 41,
          "name": "Url",
          "value": "https://rcpayapi.mof.gov.sl/CorporatePayApi/"
        },
        {
          "routeId": 41,
          "name": "WebServiceUrl",
          "value": "http://10.117.0.150:9090/TWS/services?wsdl"
        },
        {
          "routeId": 41,
          "name": "UserName",
          "value": "EFTUSER"
        },
        {
          "routeId": 41,
          "name": "Password",
          "value": "FINANCE123456"
        }
      ]
    },
    {
      "id": 42,
      "name": "NotonUs",
      "transactionType": 2,
      "integrationType": 1,
      "institutionId": 79,
      "routeServices": [
        {
          "routeId": 42,
          "serviceType": 1,
          "endPoint": "/api/SL/CorporatePayAPI/V2/NameEnquiry/OtherBank?accountNumber="
        },
        {
          "routeId": 42,
          "serviceType": 4,
          "endPoint": "/api/SL/CorporatePayAPI/V2/FundsTransfer/OtherBank"
        },
        {
          "routeId": 42,
          "serviceType": 6,
          "endPoint": "/api/SL/CorporatePayApi/V2/TransactionStatusQuery?refNo={Ref}"
        }
      ],
      "routeParameters": [
        {
          "routeId": 42,
          "name": "Url",
          "value": "https://rcpayapi.mof.gov.sl/CorporatePayApi/"
        },
        {
          "routeId": 42,
          "name": "WebServiceUrl",
          "value": "http://10.117.0.150:9090/TWS/services?wsdl"
        },
        {
          "routeId": 42,
          "name": "UserName",
          "value": "EFTUSER"
        },
        {
          "routeId": 42,
          "name": "Password",
          "value": "FINANCE123456"
        }
      ]
    },
    {
      "id": 43,
      "name": "ForeignPayment",
      "transactionType": 3,
      "integrationType": 1,
      "institutionId": 79,
      "routeServices": [
        {
          "routeId": 43,
          "serviceType": 4,
          "endPoint": "/api/SL/CorporatePayAPI/V2/FundsTransfer/Foreign"
        },
        {
          "routeId": 43,
          "serviceType": 6,
          "endPoint": "/api/SL/CorporatePayAPI/V2/TransactionStatusQuery/OtherBank?refNo={Ref}"
        }
      ],
      "routeParameters": [
        {
          "routeId": 43,
          "name": "Url",
          "value": "https://rcpayapi.mof.gov.sl/CorporatePayApi/"
        },
        {
          "routeId": 43,
          "name": "WebServiceUrl",
          "value": "http://10.117.0.150:9090/TWS/services?wsdl"
        },
        {
          "routeId": 43,
          "name": "UserName",
          "value": "EFTUSER"
        },
        {
          "routeId": 43,
          "name": "Password",
          "value": "FINANCE123456"
        }
      ]
    }
  ],
  "code": "00",
  "success": true,
  "description": "Success"
}::: OK::: OK 
2025-12-25 14:00:42.7499||WARN|AccountManagement.Core.Services.TreasuryAccountService|About to Fetch Treasury Accounts 
2025-12-25 14:00:42.7499||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-25 14:00:42.7499||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: api/SL/CorporatePayAPI/V2/Treasury/Accounts/Balance 
2025-12-25 14:00:42.7499||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=1100512 
2025-12-25 14:00:43.8672||WARN|AccountManagement.Core.Services.IntegrationService|Treasury Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-25 14:00:43.8672||WARN|AccountManagement.Core.Services.TreasuryAccountService|Done Fetching Treasury Accounts 
2025-12-25 14:00:43.8766|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[System.Object, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 
2025-12-25 14:00:43.8766|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement) in 1751.3859ms 
2025-12-25 14:00:43.8766|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 
2025-12-25 14:00:43.8766|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1817.5365ms 200 application/json; charset=utf-8 
2025-12-25 14:00:43.8929||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-25 14:00:43.8929||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-25 14:00:43.8929||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-25 14:00:43.9325||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-25 14:00:43.9370||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-25 14:00:43.9370||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100127923 
2025-12-25 14:00:45.0342||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-25 14:00:45.0342||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-25 14:00:45.0342||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-25 14:00:45.0676||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-25 14:00:45.0676|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/BankManagement/GetAllBanks   
2025-12-25 14:00:45.0676|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/CurrencyManagement/GetAllCurrencys   
2025-12-25 14:00:45.0676||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-25 14:00:45.0676|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:00:45.0764|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:00:45.0764|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.5119ms 204  
2025-12-25 14:00:45.0764||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=0111001293 
2025-12-25 14:00:45.0764|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 10.6017ms 204  
2025-12-25 14:00:45.3133|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/BankManagement/GetAllBanks   
2025-12-25 14:00:45.3133|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/CurrencyManagement/GetAllCurrencys   
2025-12-25 14:00:45.3133|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-12-25 14:00:45.3133|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-12-25 14:00:45.3266|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:00:45.3266|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-12-25 14:00:45.3266|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:00:45.3266|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement)' 
2025-12-25 14:00:45.3266|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-12-25 14:00:45.3266|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement)' 
2025-12-25 14:00:45.3547|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllCurrencys", controller = "CurrencyManagement"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllCurrencysAsync(AccountManagement.Data.Utility.PaginationHelpers.CurrencyParameters) on controller AccountManagement.Controllers.CurrencyManagementController (AccountManagement). 
2025-12-25 14:00:45.3547|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllBanks", controller = "BankManagement"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllBanksAsync(AccountManagement.Data.Utility.PaginationHelpers.BankParameters) on controller AccountManagement.Controllers.BankManagementController (AccountManagement). 
2025-12-25 14:00:45.3578|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-12-25 14:00:45.3578|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-12-25 14:00:45.3773|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name]
FROM [Currencies] AS [c]
ORDER BY [c].[Name] 
2025-12-25 14:00:45.3773|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [b].[Id], [b].[Account], [b].[BBAN], [b].[BICCode], [b].[BankType], [b].[Code], [b].[CountryId], [b].[CreatedBy], [b].[DateCreated], [b].[DateModified], [b].[IsActive], [b].[IsDeleted], [b].[ModifiedBy], [b].[Name], [b].[SettlementBankId], [b].[SettlementBankName], [b].[SettlementBankOfficerEmail], [b].[ShortName], [c].[Id], [c].[Code1], [c].[Code2], [c].[Name]
FROM [Banks] AS [b]
INNER JOIN [Countries] AS [c] ON [b].[CountryId] = [c].[Id]
ORDER BY [b].[Name] 
2025-12-25 14:00:45.4068|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'AccountManagement.Data.Utility.PaginationHelpers.PagedList`1[[CorporatePay.Common.Models.CurrencyViewModel, CorporatePay.Common, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-12-25 14:00:45.4068|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement) in 59.8172ms 
2025-12-25 14:00:45.4068|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement)' 
2025-12-25 14:00:45.4203|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 106.73ms 200 application/json; charset=utf-8 
2025-12-25 14:00:45.4203|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.ResponsePageList`1[[System.Collections.Generic.List`1[[CorporatePay.Common.Models.BankViewModel, CorporatePay.Common, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 
2025-12-25 14:00:45.4442|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement) in 86.8206ms 
2025-12-25 14:00:45.4442|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement)' 
2025-12-25 14:00:45.4442|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 135.5964ms 200 application/json; charset=utf-8 
2025-12-25 14:00:46.1576||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-25 14:00:46.1576||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-25 14:00:46.1576||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-25 14:00:46.1844||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-25 14:00:46.1879||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-25 14:00:46.1879||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=SLE116030002 
2025-12-25 14:00:47.2844||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-25 14:00:47.2844||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-25 14:00:47.2844||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-25 14:00:47.3163||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-25 14:00:47.3163||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-25 14:00:47.3260||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100129378 
2025-12-25 14:00:48.4017||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-25 14:00:48.4041||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-25 14:00:48.4041||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-25 14:00:48.4248||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-25 14:00:48.4248||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-25 14:00:48.4371||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100131027 
2025-12-25 14:00:49.5348||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-25 14:00:49.5348||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-25 14:00:49.5348||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-25 14:00:49.5625||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-25 14:00:49.6703|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[@p4='?' (DbType = Int64), @p0='?' (DbType = Decimal), @p1='?' (DbType = DateTime2), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Int64), @p9='?' (DbType = Int64), @p5='?' (DbType = Decimal), @p6='?' (DbType = DateTime2), @p7='?' (DbType = DateTime2), @p8='?' (DbType = Int64), @p14='?' (DbType = Int64), @p10='?' (DbType = Decimal), @p11='?' (DbType = DateTime2), @p12='?' (DbType = DateTime2), @p13='?' (DbType = Int64), @p19='?' (DbType = Int64), @p15='?' (DbType = Decimal), @p16='?' (DbType = DateTime2), @p17='?' (DbType = DateTime2), @p18='?' (DbType = Int64), @p24='?' (DbType = Int64), @p20='?' (DbType = Decimal), @p21='?' (DbType = DateTime2), @p22='?' (DbType = DateTime2), @p23='?' (DbType = Int64), @p29='?' (DbType = Int64), @p25='?' (DbType = Decimal), @p26='?' (DbType = DateTime2), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [SourceAccountManagements] SET [CurrentBalance] = @p0, [CurrentBalanceLastUpdatedTime] = @p1, [DateModified] = @p2, [ModifiedBy] = @p3
WHERE [Id] = @p4;
SELECT @@ROWCOUNT;

UPDATE [SourceAccountManagements] SET [CurrentBalance] = @p5, [CurrentBalanceLastUpdatedTime] = @p6, [DateModified] = @p7, [ModifiedBy] = @p8
WHERE [Id] = @p9;
SELECT @@ROWCOUNT;

UPDATE [SourceAccountManagements] SET [CurrentBalance] = @p10, [CurrentBalanceLastUpdatedTime] = @p11, [DateModified] = @p12, [ModifiedBy] = @p13
WHERE [Id] = @p14;
SELECT @@ROWCOUNT;

UPDATE [SourceAccountManagements] SET [CurrentBalance] = @p15, [CurrentBalanceLastUpdatedTime] = @p16, [DateModified] = @p17, [ModifiedBy] = @p18
WHERE [Id] = @p19;
SELECT @@ROWCOUNT;

UPDATE [SourceAccountManagements] SET [CurrentBalance] = @p20, [CurrentBalanceLastUpdatedTime] = @p21, [DateModified] = @p22, [ModifiedBy] = @p23
WHERE [Id] = @p24;
SELECT @@ROWCOUNT;

UPDATE [SourceAccountManagements] SET [CurrentBalance] = @p25, [CurrentBalanceLastUpdatedTime] = @p26, [DateModified] = @p27, [ModifiedBy] = @p28
WHERE [Id] = @p29;
SELECT @@ROWCOUNT; 
2025-12-25 14:00:49.7183|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (23ms) [Parameters=[@__Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [s].[Id], [s].[AccountName], [s].[AccountNumber], [s].[ApprovalStatus], [s].[ApprovalStatusDate], [s].[ApprovedBy], [s].[BankId], [s].[BankName], [s].[Code], [s].[CreatedBy], [s].[Currency], [s].[CurrentBalance], [s].[CurrentBalanceLastUpdatedTime], [s].[DateCreated], [s].[DateModified], [s].[IsActive], [s].[IsDeleted], [s].[ModifiedBy], [s].[OverdraftLimit], [s].[RejectionComment], [s].[UserType], [s].[UserTypeId]
FROM [SourceAccountManagements] AS [s]
WHERE (([s].[UserTypeId] = @__Id_0) AND ([s].[IsDeleted] = CAST(0 AS bit))) AND ([s].[IsActive] = CAST(1 AS bit))
ORDER BY [s].[DateCreated] DESC 
2025-12-25 14:00:49.7351|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE [p].[Code] = N'CVAB' 
2025-12-25 14:00:49.7547|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName]
FROM [AccountPermissions] AS [a]
WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 
2025-12-25 14:00:49.7669|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE [p].[Code] = N'CVAB' 
2025-12-25 14:00:49.7669|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName]
FROM [AccountPermissions] AS [a]
WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 
2025-12-25 14:00:49.7840|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE [p].[Code] = N'CVAB' 
2025-12-25 14:00:49.7840|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName]
FROM [AccountPermissions] AS [a]
WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 
2025-12-25 14:00:49.7840|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE [p].[Code] = N'CVAB' 
2025-12-25 14:00:49.7950|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName]
FROM [AccountPermissions] AS [a]
WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 
2025-12-25 14:00:49.7950|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE [p].[Code] = N'CVAB' 
2025-12-25 14:00:49.7950|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName]
FROM [AccountPermissions] AS [a]
WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 
2025-12-25 14:00:49.7950|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE [p].[Code] = N'CVAB' 
2025-12-25 14:00:49.8114|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName]
FROM [AccountPermissions] AS [a]
WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 
2025-12-25 14:00:49.9392|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[SourceAccountManagement.Data.Models.SourceAccountManagementViewModel, AccountManagement.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-12-25 14:00:49.9511|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement) in 7821.9694ms 
2025-12-25 14:00:49.9511|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 
2025-12-25 14:00:49.9511|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7896.1638ms 200 application/json; charset=utf-8 
2025-12-25 14:01:02.3141|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current   
2025-12-25 14:01:02.3141|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance   
2025-12-25 14:01:02.3141|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207   
2025-12-25 14:01:02.3141|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:01:02.3141|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:01:02.3141|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:01:02.3141|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.6849ms 204  
2025-12-25 14:01:02.3141|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.3078ms 204  
2025-12-25 14:01:02.3141|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 10.1568ms 204  
2025-12-25 14:01:02.5887|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207   
2025-12-25 14:01:02.5887|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance   
2025-12-25 14:01:02.5887|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current   
2025-12-25 14:01:02.5943|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-12-25 14:01:02.5943|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-12-25 14:01:02.5943|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-12-25 14:01:02.5943|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:01:02.5943|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:01:02.5943|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-25 14:01:02.5943|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-12-25 14:01:02.5943|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-12-25 14:01:02.5943|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-12-25 14:01:02.5943|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 
2025-12-25 14:01:02.5943|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 
2025-12-25 14:01:02.6072|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 
2025-12-25 14:01:02.6072|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAccountByCorporateId", controller = "AccountManagement"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAccountByCorporateIdAsync(Int64) on controller AccountManagement.Controllers.AccountManagementController (AccountManagement). 
2025-12-25 14:01:02.6072|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "FetchCurrentWaysMeans", controller = "WaysMeans"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult FetchCurrentWaysMeans() on controller AccountManagement.Controllers.WaysMeansController (AccountManagement). 
2025-12-25 14:01:02.6072|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-12-25 14:01:02.6072|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "FetchBalance", controller = "TreasuryAccount"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] FetchBalance(System.Nullable`1[CorporatePay.Common.GovernmentAccountType]) on controller AccountManagement.Controllers.TreasuryAccountController (AccountManagement). 
2025-12-25 14:01:02.6072|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-12-25 14:01:02.6072||WARN|AccountManagement.Core.Services.TreasuryAccountService|CorporateId : 207 
2025-12-25 14:01:02.6072|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [w].[Id], [w].[Amount], [w].[Comment], [w].[CreatedBy], [w].[DateCreated], [w].[DateModified], [w].[IsActive], [w].[IsDeleted], [w].[ModifiedBy], [w].[Year]
FROM [WaysMeans] AS [w]
WHERE ([w].[IsDeleted] = CAST(0 AS bit)) AND ([w].[IsActive] = CAST(1 AS bit))
ORDER BY [w].[Id] DESC 
2025-12-25 14:01:02.6250|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[AccountManagement.Data.Models.WaysMeansModel, AccountManagement.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-12-25 14:01:02.6250|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [s].[Id], [s].[AccountName], [s].[AccountNumber], [s].[ApprovalStatus], [s].[ApprovalStatusDate], [s].[ApprovedBy], [s].[BankId], [s].[BankName], [s].[Code], [s].[CreatedBy], [s].[Currency], [s].[CurrentBalance], [s].[CurrentBalanceLastUpdatedTime], [s].[DateCreated], [s].[DateModified], [s].[IsActive], [s].[IsDeleted], [s].[ModifiedBy], [s].[OverdraftLimit], [s].[RejectionComment], [s].[UserType], [s].[UserTypeId]
FROM [SourceAccountManagements] AS [s]
WHERE (([s].[UserTypeId] = @__Id_0) AND ([s].[IsDeleted] = CAST(0 AS bit))) AND ([s].[IsActive] = CAST(1 AS bit)) 
2025-12-25 14:01:02.6250||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 
2025-12-25 14:01:02.6250|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement) in 13.2156ms 
2025-12-25 14:01:02.6250||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 
2025-12-25 14:01:02.6250|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 
2025-12-25 14:01:02.6250||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 
2025-12-25 14:01:02.6250||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 
2025-12-25 14:01:02.6250|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 44.1984ms 200 application/json; charset=utf-8 
2025-12-25 14:01:02.6536||WARN|AccountManagement.Core.Services.IntegrationService|Response: {
  "data": [
    {
      "id": 41,
      "name": "T24",
      "transactionType": 1,
      "integrationType": 1,
      "institutionId": 79,
      "routeServices": [
        {
          "routeId": 41,
          "serviceType": 4,
          "endPoint": "/api/SL/CorporatePayApi/V2/FundsTransfer"
        },
        {
          "routeId": 41,
          "serviceType": 5,
          "endPoint": "/api/SL/CorporatePayApi/V2/CheckOverDrawnAccount?accountNumber="
        },
        {
          "routeId": 41,
          "serviceType": 6,
          "endPoint": "/api/SL/CorporatePayApi/V2/TransactionStatusQuery?refNo={Ref}"
        },
        {
          "routeId": 41,
          "serviceType": 1,
          "endPoint": "/api/SL/CorporatePayApi/V2/NameEnquiry?accountNumber="
        },
        {
          "routeId": 41,
          "serviceType": 2,
          "endPoint": "/api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber="
        }
      ],
      "routeParameters": [
        {
          "routeId": 41,
          "name": "Url",
          "value": "https://rcpayapi.mof.gov.sl/CorporatePayApi/"
        },
        {
          "routeId": 41,
          "name": "WebServiceUrl",
          "value": "http://10.117.0.150:9090/TWS/services?wsdl"
        },
        {
          "routeId": 41,
          "name": "UserName",
          "value": "EFTUSER"
        },
        {
          "routeId": 41,
          "name": "Password",
          "value": "FINANCE123456"
        }
      ]
    },
    {
      "id": 42,
      "name": "NotonUs",
      "transactionType": 2,
      "integrationType": 1,
      "institutionId": 79,
      "routeServices": [
        {
          "routeId": 42,
          "serviceType": 1,
          "endPoint": "/api/SL/CorporatePayAPI/V2/NameEnquiry/OtherBank?accountNumber="
        },
        {
          "routeId": 42,
          "serviceType": 4,
          "endPoint": "/api/SL/CorporatePayAPI/V2/FundsTransfer/OtherBank"
        },
        {
          "routeId": 42,
          "serviceType": 6,
          "endPoint": "/api/SL/CorporatePayApi/V2/TransactionStatusQuery?refNo={Ref}"
        }
      ],
      "routeParameters": [
        {
          "routeId": 42,
          "name": "Url",
          "value": "https://rcpayapi.mof.gov.sl/CorporatePayApi/"
        },
        {
          "routeId": 42,
          "name": "WebServiceUrl",
          "value": "http://10.117.0.150:9090/TWS/services?wsdl"
        },
        {
          "routeId": 42,
          "name": "UserName",
          "value": "EFTUSER"
        },
        {
          "routeId": 42,
          "name": "Password",
          "value": "FINANCE123456"
        }
      ]
    },
    {
      "id": 43,
      "name": "ForeignPayment",
      "transactionType": 3,
      "integrationType": 1,
      "institutionId": 79,
      "routeServices": [
        {
          "routeId": 43,
          "serviceType": 4,
          "endPoint": "/api/SL/CorporatePayAPI/V2/FundsTransfer/Foreign"
        },
        {
          "routeId": 43,
          "serviceType": 6,
          "endPoint": "/api/SL/CorporatePayAPI/V2/TransactionStatusQuery/OtherBank?refNo={Ref}"
        }
      ],
      "routeParameters": [
        {
          "routeId": 43,
          "name": "Url",
          "value": "https://rcpayapi.mof.gov.sl/CorporatePayApi/"
        },
        {
          "routeId": 43,
          "name": "WebServiceUrl",
          "value": "http://10.117.0.150:9090/TWS/services?wsdl"
        },
        {
          "routeId": 43,
          "name": "UserName",
          "value": "EFTUSER"
        },
        {
          "routeId": 43,
          "name": "Password",
          "value": "FINANCE123456"
        }
      ]
    }
  ],
  "code": "00",
  "success": true,
  "description": "Success"
}::: OK::: OK 
2025-12-25 14:01:02.6536||WARN|AccountManagement.Core.Services.IntegrationService|Response: {
  "data": [
    {
      "id": 41,
      "name": "T24",
      "transactionType": 1,
      "integrationType": 1,
      "institutionId": 79,
      "routeServices": [
        {
          "routeId": 41,
          "serviceType": 4,
          "endPoint": "/api/SL/CorporatePayApi/V2/FundsTransfer"
        },
        {
          "routeId": 41,
          "serviceType": 5,
          "endPoint": "/api/SL/CorporatePayApi/V2/CheckOverDrawnAccount?accountNumber="
        },
        {
          "routeId": 41,
          "serviceType": 6,
          "endPoint": "/api/SL/CorporatePayApi/V2/TransactionStatusQuery?refNo={Ref}"
        },
        {
          "routeId": 41,
          "serviceType": 1,
          "endPoint": "/api/SL/CorporatePayApi/V2/NameEnquiry?accountNumber="
        },
        {
          "routeId": 41,
          "serviceType": 2,
          "endPoint": "/api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber="
        }
      ],
      "routeParameters": [
        {
          "routeId": 41,
          "name": "Url",
          "value": "https://rcpayapi.mof.gov.sl/CorporatePayApi/"
        },
        {
          "routeId": 41,
          "name": "WebServiceUrl",
          "value": "http://10.117.0.150:9090/TWS/services?wsdl"
        },
        {
          "routeId": 41,
          "name": "UserName",
          "value": "EFTUSER"
        },
        {
          "routeId": 41,
          "name": "Password",
          "value": "FINANCE123456"
        }
      ]
    },
    {
      "id": 42,
      "name": "NotonUs",
      "transactionType": 2,
      "integrationType": 1,
      "institutionId": 79,
      "routeServices": [
        {
          "routeId": 42,
          "serviceType": 1,
          "endPoint": "/api/SL/CorporatePayAPI/V2/NameEnquiry/OtherBank?accountNumber="
        },
        {
          "routeId": 42,
          "serviceType": 4,
          "endPoint": "/api/SL/CorporatePayAPI/V2/FundsTransfer/OtherBank"
        },
        {
          "routeId": 42,
          "serviceType": 6,
          "endPoint": "/api/SL/CorporatePayApi/V2/TransactionStatusQuery?refNo={Ref}"
        }
      ],
      "routeParameters": [
        {
          "routeId": 42,
          "name": "Url",
          "value": "https://rcpayapi.mof.gov.sl/CorporatePayApi/"
        },
        {
          "routeId": 42,
          "name": "WebServiceUrl",
          "value": "http://10.117.0.150:9090/TWS/services?wsdl"
        },
        {
          "routeId": 42,
          "name": "UserName",
          "value": "EFTUSER"
        },
        {
          "routeId": 42,
          "name": "Password",
          "value": "FINANCE123456"
        }
      ]
    },
    {
      "id": 43,
      "name": "ForeignPayment",
      "transactionType": 3,
      "integrationType": 1,
      "institutionId": 79,
      "routeServices": [
        {
          "routeId": 43,
          "serviceType": 4,
          "endPoint": "/api/SL/CorporatePayAPI/V2/FundsTransfer/Foreign"
        },
        {
          "routeId": 43,
          "serviceType": 6,
          "endPoint": "/api/SL/CorporatePayAPI/V2/TransactionStatusQuery/OtherBank?refNo={Ref}"
        }
      ],
      "routeParameters": [
        {
          "routeId": 43,
          "name": "Url",
          "value": "https://rcpayapi.mof.gov.sl/CorporatePayApi/"
        },
        {
          "routeId": 43,
          "name": "WebServiceUrl",
          "value": "http://10.117.0.150:9090/TWS/services?wsdl"
        },
        {
          "routeId": 43,
          "name": "UserName",
          "value": "EFTUSER"
        },
        {
          "routeId": 43,
          "name": "Password",
          "value": "FINANCE123456"
        }
      ]
    }
  ],
  "code": "00",
  "success": true,
  "description": "Success"
}::: OK::: OK 
2025-12-25 14:01:02.6573||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-25 14:01:02.6573||WARN|AccountManagement.Core.Services.TreasuryAccountService|About to Fetch Treasury Accounts 
2025-12-25 14:01:02.6573||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=1100512 
2025-12-25 14:01:02.6573||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: api/SL/CorporatePayAPI/V2/Treasury/Accounts/Balance 
2025-12-25 14:01:03.7523||WARN|AccountManagement.Core.Services.IntegrationService|Treasury Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-25 14:01:03.7523||WARN|AccountManagement.Core.Services.TreasuryAccountService|Done Fetching Treasury Accounts 
2025-12-25 14:01:03.7523||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-25 14:01:03.7523|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[System.Object, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 
2025-12-25 14:01:03.7523|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement) in 1146.8434ms 
2025-12-25 14:01:03.7523|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 
2025-12-25 14:01:03.7523||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-25 14:01:03.7523|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1178.1828ms 200 application/json; charset=utf-8 
2025-12-25 14:01:03.7688||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-25 14:01:03.7850||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-25 14:01:03.7850||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-25 14:01:03.7850||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100127923 
2025-12-25 14:01:04.8810||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-25 14:01:04.8810||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-25 14:01:04.8810||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-25 14:01:04.9118||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-25 14:01:04.9118||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-25 14:01:04.9118||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=0111001293 
2025-12-25 14:01:06.0036||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-25 14:01:06.0036||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-25 14:01:06.0036||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-25 14:01:06.0266||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-25 14:01:06.0266||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-25 14:01:06.0330||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=SLE116030002 
2025-12-25 14:01:07.1256||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-25 14:01:07.1296||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-25 14:01:07.1296||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-25 14:01:07.1506||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-25 14:01:07.1506||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-25 14:01:07.1506||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100129378 
2025-12-25 14:01:08.2410||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-25 14:01:08.2410||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-25 14:01:08.2410||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-25 14:01:08.2675||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-25 14:01:08.2675||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-25 14:01:08.2675||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100131027 
2025-12-25 14:01:09.3636||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-25 14:01:09.3636||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-25 14:01:09.3636||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-25 14:01:09.3872||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-25 14:01:09.4015|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[@p2='?' (DbType = Int64), @p0='?' (DbType = DateTime2), @p1='?' (DbType = DateTime2), @p5='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p8='?' (DbType = Int64), @p6='?' (DbType = DateTime2), @p7='?' (DbType = DateTime2), @p11='?' (DbType = Int64), @p9='?' (DbType = DateTime2), @p10='?' (DbType = DateTime2), @p14='?' (DbType = Int64), @p12='?' (DbType = DateTime2), @p13='?' (DbType = DateTime2), @p17='?' (DbType = Int64), @p15='?' (DbType = DateTime2), @p16='?' (DbType = DateTime2)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p0, [DateModified] = @p1
WHERE [Id] = @p2;
SELECT @@ROWCOUNT;

UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p3, [DateModified] = @p4
WHERE [Id] = @p5;
SELECT @@ROWCOUNT;

UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p6, [DateModified] = @p7
WHERE [Id] = @p8;
SELECT @@ROWCOUNT;

UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p9, [DateModified] = @p10
WHERE [Id] = @p11;
SELECT @@ROWCOUNT;

UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p12, [DateModified] = @p13
WHERE [Id] = @p14;
SELECT @@ROWCOUNT;

UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p15, [DateModified] = @p16
WHERE [Id] = @p17;
SELECT @@ROWCOUNT; 
2025-12-25 14:01:09.4159|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [Parameters=[@__Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [s].[Id], [s].[AccountName], [s].[AccountNumber], [s].[ApprovalStatus], [s].[ApprovalStatusDate], [s].[ApprovedBy], [s].[BankId], [s].[BankName], [s].[Code], [s].[CreatedBy], [s].[Currency], [s].[CurrentBalance], [s].[CurrentBalanceLastUpdatedTime], [s].[DateCreated], [s].[DateModified], [s].[IsActive], [s].[IsDeleted], [s].[ModifiedBy], [s].[OverdraftLimit], [s].[RejectionComment], [s].[UserType], [s].[UserTypeId]
FROM [SourceAccountManagements] AS [s]
WHERE (([s].[UserTypeId] = @__Id_0) AND ([s].[IsDeleted] = CAST(0 AS bit))) AND ([s].[IsActive] = CAST(1 AS bit))
ORDER BY [s].[DateCreated] DESC 
2025-12-25 14:01:09.4238|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE [p].[Code] = N'CVAB' 
2025-12-25 14:01:09.4238|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName]
FROM [AccountPermissions] AS [a]
WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 
2025-12-25 14:01:09.4238|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE [p].[Code] = N'CVAB' 
2025-12-25 14:01:09.4238|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName]
FROM [AccountPermissions] AS [a]
WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 
2025-12-25 14:01:09.4394|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE [p].[Code] = N'CVAB' 
2025-12-25 14:01:09.4394|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName]
FROM [AccountPermissions] AS [a]
WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 
2025-12-25 14:01:09.4394|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE [p].[Code] = N'CVAB' 
2025-12-25 14:01:09.4394|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName]
FROM [AccountPermissions] AS [a]
WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 
2025-12-25 14:01:09.4571|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE [p].[Code] = N'CVAB' 
2025-12-25 14:01:09.4571|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName]
FROM [AccountPermissions] AS [a]
WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 
2025-12-25 14:01:09.4571|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE [p].[Code] = N'CVAB' 
2025-12-25 14:01:09.4709|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName]
FROM [AccountPermissions] AS [a]
WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 
2025-12-25 14:01:09.5235|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[SourceAccountManagement.Data.Models.SourceAccountManagementViewModel, AccountManagement.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-12-25 14:01:09.5235|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement) in 6916.0952ms 
2025-12-25 14:01:09.5235|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 
2025-12-25 14:01:09.5330|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6944.3441ms 200 application/json; charset=utf-8 
2025-12-25 14:21:08.0677|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:34649/ACCOUNTSERVICES/iisintegration  0 
2025-12-25 14:21:08.0677|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.429ms 202