2025-12-06 23:03:17.1249||DEBUG|AccountManagement.Program|init main function 
2025-12-06 23:03:23.0514|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-06 23:03:23.0641|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-06 23:03:23.0641|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-06 23:03:23.1028|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-12-06 23:03:23.8980|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (16ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-12-06 23:03:23.9210|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-12-06 23:03:23.9210|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-12-06 23:03:23.9210|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-12-06 23:03:23.9457|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-12-06 23:03:23.9601|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-12-06 23:03:24.9142||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-06 23:03:25.2273|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-06 23:03:25.2273|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance   
2025-12-06 23:03:25.2273|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current   
2025-12-06 23:03:25.2273|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAllInitiatePaymentSourceAccountsByUserId?userId=519   
2025-12-06 23:03:25.9697|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-06 23:03:25.9697|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-06 23:03:25.9697|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-06 23:03:25.9697|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-06 23:03:25.9815|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 754.3832ms 204  
2025-12-06 23:03:25.9815|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 754.3832ms 204  
2025-12-06 23:03:25.9815|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 754.3569ms 204  
2025-12-06 23:03:25.9815|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 754.4036ms 204  
2025-12-06 23:03:26.0568|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-06 23:03:26.0568|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current   
2025-12-06 23:03:26.0568|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance   
2025-12-06 23:03:26.0568|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAllInitiatePaymentSourceAccountsByUserId?userId=519   
2025-12-06 23:03:26.4467|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-12-06 23:03:26.4467|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-12-06 23:03:26.4467|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-12-06 23:03:26.4467|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-06 23:03:26.4467|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-12-06 23:03:26.4467|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-12-06 23:03:26.4467|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-06 23:03:26.4467|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-06 23:03:26.4467|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-12-06 23:03:26.4467|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 
2025-12-06 23:03:26.4467|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-12-06 23:03:26.4626|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement)' 
2025-12-06 23:03:26.4626|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-12-06 23:03:26.4626|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-12-06 23:03:26.4626|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 
2025-12-06 23:03:26.4626|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 
2025-12-06 23:03:26.4949|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-06 23:03:26.4949|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-12-06 23:03:26.4949|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-06 23:03:26.4949|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-06 23:03:26.5103|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-06 23:03:26.5323|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-12-06 23:03:26.5323|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-12-06 23:03:26.5323||WARN|AccountManagement.Core.Services.TreasuryAccountService|CorporateId : 207 
2025-12-06 23:03:26.8022|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-06 23:03:26.8593|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (34ms) [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-06 23:03:26.8593|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (38ms) [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-06 23:03:26.8720|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-06 23:03:26.8720|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-06 23:03:26.8956|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement) in 388.7351ms 
2025-12-06 23:03:26.8956|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement)' 
2025-12-06 23:03:26.8956|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement) in 402.6602ms 
2025-12-06 23:03:26.9001|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 842.6634ms 200 application/json; charset=utf-8 
2025-12-06 23:03:26.9001|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 
2025-12-06 23:03:26.9001|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 846.0017ms 200 application/json; charset=utf-8 
2025-12-06 23:03:26.9001||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 
2025-12-06 23:03:26.9001||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 
2025-12-06 23:03:26.9001||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 
2025-12-06 23:03:26.9001||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 
2025-12-06 23:03:27.4492||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-06 23:03:27.4492||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-06 23:03:27.4842||WARN|AccountManagement.Core.Services.TreasuryAccountService|About to Fetch Treasury Accounts 
2025-12-06 23:03:27.4842||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-06 23:03:27.4842||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: api/SL/CorporatePayAPI/V2/Treasury/Accounts/Balance 
2025-12-06 23:03:27.4842||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=1100512 
2025-12-06 23:03:28.8019||WARN|AccountManagement.Core.Services.IntegrationService|Treasury Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-06 23:03:28.8019||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-06 23:03:28.8019||WARN|AccountManagement.Core.Services.TreasuryAccountService|Done Fetching Treasury Accounts 
2025-12-06 23:03:28.8089||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-06 23:03:28.8089|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-06 23:03:28.8089||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-06 23:03:28.8089|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement) in 2306.1445ms 
2025-12-06 23:03:28.8089|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 
2025-12-06 23:03:28.8216|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2764.185ms 200 application/json; charset=utf-8 
2025-12-06 23:03:28.8563||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-06 23:03:28.8563||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-06 23:03:28.8563||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100127923 
2025-12-06 23:03:29.9621||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-06 23:03:29.9665||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-06 23:03:29.9665||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-06 23:03:29.9958||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-06 23:03:29.9958||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-06 23:03:29.9958||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=0111001293 
2025-12-06 23:03:31.0779||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-06 23:03:31.0779||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-06 23:03:31.0779||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-06 23:03:31.1028||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-06 23:03:31.1028||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-06 23:03:31.1028||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=SLE116030002 
2025-12-06 23:03:32.1974||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-06 23:03:32.1974||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-06 23:03:32.1974||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-06 23:03:32.2218||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-06 23:03:32.2218||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-06 23:03:32.2218||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100129378 
2025-12-06 23:03:33.3110||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-06 23:03:33.3110||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-06 23:03:33.3110||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-06 23:03:33.3423||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-06 23:03:33.3423||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2025-12-06 23:03:33.3423||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100131027 
2025-12-06 23:03:34.4321||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2025-12-06 23:03:34.4321||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2025-12-06 23:03:34.4321||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2025-12-06 23:03:34.4565||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2025-12-06 23:03:34.6100|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (62ms) [Parameters=[@p3='?' (DbType = Int64), @p0='?' (DbType = Decimal), @p1='?' (DbType = DateTime2), @p2='?' (DbType = DateTime2), @p7='?' (DbType = Int64), @p4='?' (DbType = Decimal), @p5='?' (DbType = DateTime2), @p6='?' (DbType = DateTime2), @p11='?' (DbType = Int64), @p8='?' (DbType = Decimal), @p9='?' (DbType = DateTime2), @p10='?' (DbType = DateTime2), @p15='?' (DbType = Int64), @p12='?' (DbType = Decimal), @p13='?' (DbType = DateTime2), @p14='?' (DbType = DateTime2), @p19='?' (DbType = Int64), @p16='?' (DbType = Decimal), @p17='?' (DbType = DateTime2), @p18='?' (DbType = DateTime2), @p23='?' (DbType = Int64), @p20='?' (DbType = Decimal), @p21='?' (DbType = DateTime2), @p22='?' (DbType = DateTime2)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [SourceAccountManagements] SET [CurrentBalance] = @p0, [CurrentBalanceLastUpdatedTime] = @p1, [DateModified] = @p2
WHERE [Id] = @p3;
SELECT @@ROWCOUNT;

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

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

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

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

UPDATE [SourceAccountManagements] SET [CurrentBalance] = @p20, [CurrentBalanceLastUpdatedTime] = @p21, [DateModified] = @p22
WHERE [Id] = @p23;
SELECT @@ROWCOUNT; 
2025-12-06 23:03:34.6985|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (53ms) [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-06 23:03:34.7192|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-06 23:03:34.7426|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-06 23:03:34.7534|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-06 23:03:34.7534|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-06 23:03:34.7597|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-06 23:03:34.7597|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-06 23:03:34.7597|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-06 23:03:34.7597|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-06 23:03:34.7752|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-06 23:03:34.7752|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-06 23:03:34.7752|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-06 23:03:34.7752|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-06 23:03:35.0004|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-06 23:03:35.0146|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement) in 8508.772ms 
2025-12-06 23:03:35.0146|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 
2025-12-06 23:03:35.0146|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8962.667ms 200 application/json; charset=utf-8 
2025-12-06 23:24:15.4408|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:47765/ACCOUNTSERVICES/iisintegration  0 
2025-12-06 23:24:15.4408|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.5131ms 202