2026-01-10 12:52:13.7603||DEBUG|AccountManagement.Program|init main function 
2026-01-10 12:52:19.9221|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()'. 
2026-01-10 12:52:19.9370|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()'. 
2026-01-10 12:52:19.9370|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()'. 
2026-01-10 12:52:19.9709|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2026-01-10 12:52:20.5525|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (15ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2026-01-10 12:52:20.5753|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2026-01-10 12:52:20.5753|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2026-01-10 12:52:20.5753|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2026-01-10 12:52:20.6009|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2026-01-10 12:52:20.6175|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2026-01-10 12:52:21.6748||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. 
2026-01-10 12:52:22.0481|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAllInitiatePaymentSourceAccountsByUserId?userId=493   
2026-01-10 12:52:22.0481|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance   
2026-01-10 12:52:22.0481|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207   
2026-01-10 12:52:22.0481|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current   
2026-01-10 12:52:22.8600|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-10 12:52:22.8600|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-10 12:52:22.8600|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-10 12:52:22.8600|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-10 12:52:22.8715|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 824.0177ms 204  
2026-01-10 12:52:22.8715|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 824.0332ms 204  
2026-01-10 12:52:22.8716|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 824.0159ms 204  
2026-01-10 12:52:22.8716|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 824.9867ms 204  
2026-01-10 12:52:23.1008|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance   
2026-01-10 12:52:23.1008|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAllInitiatePaymentSourceAccountsByUserId?userId=493   
2026-01-10 12:52:23.1008|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current   
2026-01-10 12:52:23.1067|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207   
2026-01-10 12:52:23.5348|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2026-01-10 12:52:23.5348|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2026-01-10 12:52:23.5348|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2026-01-10 12:52:23.5348|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2026-01-10 12:52:23.5415|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-10 12:52:23.5415|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-10 12:52:23.5415|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-10 12:52:23.5415|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-10 12:52:23.5415|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2026-01-10 12:52:23.5415|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2026-01-10 12:52:23.5415|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2026-01-10 12:52:23.5415|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2026-01-10 12:52:23.5557|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 
2026-01-10 12:52:23.5557|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 
2026-01-10 12:52:23.5557|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 
2026-01-10 12:52:23.5557|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement)' 
2026-01-10 12:52:23.5920|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). 
2026-01-10 12:52:23.5920|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2026-01-10 12:52:23.6023|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). 
2026-01-10 12:52:23.6023|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). 
2026-01-10 12:52:23.6023|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). 
2026-01-10 12:52:23.6338|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2026-01-10 12:52:23.6338|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2026-01-10 12:52:23.6338||WARN|AccountManagement.Core.Services.TreasuryAccountService|CorporateId : 207 
2026-01-10 12:52:23.8054|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 
2026-01-10 12:52:23.8747|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]]'. 
2026-01-10 12:52:23.8747|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (39ms) [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)) 
2026-01-10 12:52:23.8747|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (40ms) [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)) 
2026-01-10 12:52:23.8986|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]]'. 
2026-01-10 12:52:23.9076|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement) in 311.0422ms 
2026-01-10 12:52:23.9076|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement) in 302.0346ms 
2026-01-10 12:52:23.9076|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 
2026-01-10 12:52:23.9076|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement)' 
2026-01-10 12:52:23.9076|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 811.4632ms 200 application/json; charset=utf-8 
2026-01-10 12:52:23.9076|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 812.1443ms 200 application/json; charset=utf-8 
2026-01-10 12:52:23.9287||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 
2026-01-10 12:52:23.9287||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 
2026-01-10 12:52:23.9314||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 
2026-01-10 12:52:23.9314||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 
2026-01-10 12:52:24.2830||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 
2026-01-10 12:52:24.2830||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 
2026-01-10 12:52:24.3124||WARN|AccountManagement.Core.Services.TreasuryAccountService|About to Fetch Treasury Accounts 
2026-01-10 12:52:24.3124||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2026-01-10 12:52:24.3124||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: api/SL/CorporatePayAPI/V2/Treasury/Accounts/Balance 
2026-01-10 12:52:24.3124||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=1100512 
2026-01-10 12:52:25.4894||WARN|AccountManagement.Core.Services.IntegrationService|Treasury Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2026-01-10 12:52:25.4950||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2026-01-10 12:52:25.4950||WARN|AccountManagement.Core.Services.TreasuryAccountService|Done Fetching Treasury Accounts 
2026-01-10 12:52:25.4950||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2026-01-10 12:52:25.4950|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]]'. 
2026-01-10 12:52:25.4950||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2026-01-10 12:52:25.5068|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement) in 1897.8421ms 
2026-01-10 12:52:25.5068|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 
2026-01-10 12:52:25.5068|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2409.9336ms 200 application/json; charset=utf-8 
2026-01-10 12:52:25.5446||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2026-01-10 12:52:25.5446||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2026-01-10 12:52:25.5446||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100127923 
2026-01-10 12:52:26.5597|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/CurrencyManagement/GetAllCurrencys   
2026-01-10 12:52:26.5597|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/BankManagement/GetAllBanks   
2026-01-10 12:52:26.5597|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-10 12:52:26.5755|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-10 12:52:26.5755|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 18.7448ms 204  
2026-01-10 12:52:26.5755|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 18.2127ms 204  
2026-01-10 12:52:26.6332||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2026-01-10 12:52:26.6332||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2026-01-10 12:52:26.6332||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2026-01-10 12:52:26.6630||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2026-01-10 12:52:26.6630||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2026-01-10 12:52:26.6630||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=0111001293 
2026-01-10 12:52:26.8001|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/CurrencyManagement/GetAllCurrencys   
2026-01-10 12:52:26.8049|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2026-01-10 12:52:26.8049|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/BankManagement/GetAllBanks   
2026-01-10 12:52:26.8049|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2026-01-10 12:52:26.8049|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-10 12:52:26.8049|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-10 12:52:26.8049|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2026-01-10 12:52:26.8049|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2026-01-10 12:52:26.8189|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement)' 
2026-01-10 12:52:26.8189|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement)' 
2026-01-10 12:52:26.8189|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). 
2026-01-10 12:52:26.8189|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2026-01-10 12:52:26.8189|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). 
2026-01-10 12:52:26.8365|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2026-01-10 12:52:26.8526|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (4ms) [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] 
2026-01-10 12:52:26.8526|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [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] 
2026-01-10 12:52:26.8848|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]]'. 
2026-01-10 12:52:26.8848|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement) in 58.3984ms 
2026-01-10 12:52:26.8848|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement)' 
2026-01-10 12:52:26.8848|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 93.7028ms 200 application/json; charset=utf-8 
2026-01-10 12:52:26.9137|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]]'. 
2026-01-10 12:52:26.9137|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement) in 91.6719ms 
2026-01-10 12:52:26.9294|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement)' 
2026-01-10 12:52:26.9294|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 124.5757ms 200 application/json; charset=utf-8 
2026-01-10 12:52:27.7605||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2026-01-10 12:52:27.7605||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2026-01-10 12:52:27.7605||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2026-01-10 12:52:27.7910||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2026-01-10 12:52:27.7910||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2026-01-10 12:52:27.7910||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=SLE116030002 
2026-01-10 12:52:28.8843||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2026-01-10 12:52:28.8843||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2026-01-10 12:52:28.8843||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2026-01-10 12:52:28.9131||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2026-01-10 12:52:28.9131||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2026-01-10 12:52:28.9131||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100129378 
2026-01-10 12:52:29.9975||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2026-01-10 12:52:29.9975||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2026-01-10 12:52:29.9975||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2026-01-10 12:52:30.0255||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2026-01-10 12:52:30.0255||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2026-01-10 12:52:30.0255||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100131027 
2026-01-10 12:52:31.1370||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2026-01-10 12:52:31.1370||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2026-01-10 12:52:31.1370||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2026-01-10 12:52:31.1669||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2026-01-10 12:52:31.2587|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [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), @p28='?' (DbType = Int64), @p25='?' (DbType = DateTime2), @p26='?' (DbType = DateTime2), @p27='?' (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 [CurrentBalanceLastUpdatedTime] = @p25, [DateModified] = @p26, [ModifiedBy] = @p27
WHERE [Id] = @p28;
SELECT @@ROWCOUNT; 
2026-01-10 12:52:31.2869|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [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 
2026-01-10 12:52:31.3022|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' 
2026-01-10 12:52:31.3234|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)) 
2026-01-10 12:52:31.3346|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' 
2026-01-10 12:52:31.3346|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)) 
2026-01-10 12:52:31.3538|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' 
2026-01-10 12:52:31.3538|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)) 
2026-01-10 12:52:31.3538|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' 
2026-01-10 12:52:31.3684|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)) 
2026-01-10 12:52:31.3684|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' 
2026-01-10 12:52:31.3684|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)) 
2026-01-10 12:52:31.3684|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' 
2026-01-10 12:52:31.3684|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)) 
2026-01-10 12:52:31.5380|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]]'. 
2026-01-10 12:52:31.5380|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement) in 7943.5633ms 
2026-01-10 12:52:31.5380|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 
2026-01-10 12:52:31.5542|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8447.3854ms 200 application/json; charset=utf-8 
2026-01-10 13:13:11.9665|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:27848/ACCOUNTSERVICES/iisintegration  0 
2026-01-10 13:13:11.9665|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3.2128ms 202  
2026-01-10 20:51:35.1892||DEBUG|AccountManagement.Program|init main function 
2026-01-10 20:51:40.1836|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()'. 
2026-01-10 20:51:40.1991|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()'. 
2026-01-10 20:51:40.1991|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()'. 
2026-01-10 20:51:40.2303|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2026-01-10 20:51:40.8599|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2026-01-10 20:51:40.8814|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2026-01-10 20:51:40.8814|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2026-01-10 20:51:40.8814|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2026-01-10 20:51:40.9047|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2026-01-10 20:51:40.9197|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2026-01-10 20:51:41.6984||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. 
2026-01-10 20:51:41.9950|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/swagger/index.html   
2026-01-10 20:51:42.6299|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 635.236ms 200 text/html;charset=utf-8 
2026-01-10 21:12:33.5537|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:37125/ACCOUNTSERVICES/iisintegration  0 
2026-01-10 21:12:33.5537|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.2349ms 202