2025-11-12 21:08:43.6678||DEBUG|AccountManagement.Program|init main function 2025-11-12 21:08:44.5671|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-11-12 21:08:44.5671|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-11-12 21:08:44.5786|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-11-12 21:08:44.6002|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 21:08:44.7977|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2025-11-12 21:08:44.8168|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2025-11-12 21:08:44.8168|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2025-11-12 21:08:44.8168|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2025-11-12 21:08:44.8348|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2025-11-12 21:08:44.8480|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2025-11-12 21:08:44.9581||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-11-12 21:08:45.1375|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/swagger/index.html 2025-11-12 21:08:45.2072|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 70.1527ms 200 text/html;charset=utf-8 2025-11-12 21:08:45.2332|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/swagger/swagger-ui-bundle.js 2025-11-12 21:08:45.2332|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/swagger/swagger-ui.css 2025-11-12 21:08:45.2365|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/swagger/swagger-ui-standalone-preset.js 2025-11-12 21:08:45.2365|2|INFO|Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware|Sending file. Request path: '/swagger-ui.css'. Physical path: 'N/A' 2025-11-12 21:08:45.2365|2|INFO|Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware|Sending file. Request path: '/swagger-ui-standalone-preset.js'. Physical path: 'N/A' 2025-11-12 21:08:45.2365|2|INFO|Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware|Sending file. Request path: '/swagger-ui-bundle.js'. Physical path: 'N/A' 2025-11-12 21:08:45.2365|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 16.8287ms 200 text/css 2025-11-12 21:08:45.2365|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 13.4891ms 200 application/javascript 2025-11-12 21:08:45.2365|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 16.8178ms 200 application/javascript 2025-11-12 21:08:45.3471|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/swagger/v1/swagger.json 2025-11-12 21:08:45.4214|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 74.2889ms 200 application/json;charset=utf-8 2025-11-12 21:29:42.4097|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAllInitiatePaymentSourceAccountsByUserId?userId=491 2025-11-12 21:29:42.4220|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 21:29:42.4220|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 13.8418ms 204 2025-11-12 21:29:42.4446|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAllInitiatePaymentSourceAccountsByUserId?userId=491 2025-11-12 21:29:42.4758|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-11-12 21:29:42.4758|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-11-12 21:29:42.4758|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-11-12 21:29:42.4758|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 21:29:42.4758|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 21:29:42.4758|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.3037ms 204 2025-11-12 21:29:42.4758|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6.4137ms 204 2025-11-12 21:29:42.4941|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 21:29:42.4941|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 19.1298ms 204 2025-11-12 21:29:42.5051|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-11-12 21:29:42.5051|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-11-12 21:29:42.5196|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-11-12 21:29:42.5826|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 21:29:42.5826|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 21:29:42.5826|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 21:29:42.5826|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 21:29:42.5826|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 21:29:42.5826|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 21:29:42.5826|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 21:29:42.5826|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 21:29:42.5826|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 21:29:42.5826|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 21:29:42.5826|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 21:29:42.5826|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 21:29:42.5826|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-11-12 21:29:42.5928|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-11-12 21:29:42.5928|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement)' 2025-11-12 21:29:42.5928|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-11-12 21:29:42.6155|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-11-12 21:29:42.6155|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 21:29:42.6249|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-11-12 21:29:42.6249|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-11-12 21:29:42.6249|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-11-12 21:29:42.6430||WARN|AccountManagement.Core.Services.TreasuryAccountService|CorporateId : 207 2025-11-12 21:29:42.6430|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 21:29:42.6430|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 21:29:42.7742|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-11-12 21:29:42.8258|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (37ms) [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-11-12 21:29:42.8258|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)) 2025-11-12 21:29:42.8326|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-11-12 21:29:42.8326|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-11-12 21:29:42.8481||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-11-12 21:29:42.8481||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-11-12 21:29:42.8481|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement) in 226.1173ms 2025-11-12 21:29:42.8481|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement) in 238.1286ms 2025-11-12 21:29:42.8481|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement)' 2025-11-12 21:29:42.8481||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-11-12 21:29:42.8481|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-11-12 21:29:42.8595|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 414.9702ms 200 application/json; charset=utf-8 2025-11-12 21:29:42.8595|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 355.6571ms 200 application/json; charset=utf-8 2025-11-12 21:29:42.8595||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-11-12 21:29:43.2682||WARN|AccountManagement.Core.Services.TreasuryAccountService|About to Fetch Treasury Accounts 2025-11-12 21:29:43.2682||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 21:29:43.2682||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: api/SL/CorporatePayAPI/V2/Treasury/Accounts/Balance 2025-11-12 21:29:43.2682||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=1100512 2025-11-12 21:29:44.2846||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 21:29:44.2846||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 21:29:44.2846||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 21:29:45.2971||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 21:29:45.2971||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 21:29:45.2971||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100127923 2025-11-12 21:29:46.3095||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 21:29:46.3126||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 21:29:46.3126||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 21:29:46.7819||WARN|AccountManagement.Core.Services.IntegrationService|Treasury Balance Enquiry Response [] 2025-11-12 21:29:46.7819||WARN|AccountManagement.Core.Services.TreasuryAccountService|Done Fetching Treasury Accounts 2025-11-12 21:29:46.7819|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-11-12 21:29:46.7819|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement) in 4165.3896ms 2025-11-12 21:29:46.7819|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-11-12 21:29:46.7819|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4288.1808ms 200 application/json; charset=utf-8 2025-11-12 21:29:47.3220||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 21:29:47.3220||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 21:29:47.3260||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=0111001293 2025-11-12 21:29:48.3326||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 21:29:48.3326||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 21:29:48.3326||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 21:29:49.3452||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 21:29:49.3452||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 21:29:49.3452||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=SLE116030002 2025-11-12 21:29:50.3565||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 21:29:50.3565||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 21:29:50.3565||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 21:29:51.3676||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 21:29:51.3676||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 21:29:51.3676||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100129378 2025-11-12 21:29:52.3795||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 21:29:52.3795||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 21:29:52.3795||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 21:29:53.3885||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 21:29:53.3885||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 21:29:53.3885||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100131027 2025-11-12 21:29:54.3993||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 21:29:54.3993||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 21:29:54.4049||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 21:29:55.4139||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 21:29:55.4947|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (9ms) [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-11-12 21:29:55.5184|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 2025-11-12 21:29:55.5279|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-11-12 21:29:55.5450|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-11-12 21:29:55.5450|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-11-12 21:29:55.5450|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-11-12 21:29:55.5450|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [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-11-12 21:29:55.5450|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-11-12 21:29:55.5654|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-11-12 21:29:55.5654|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [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-11-12 21:29:55.5654|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [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-11-12 21:29:55.5654|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [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-11-12 21:29:55.5654|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [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-11-12 21:29:55.5654|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [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-11-12 21:29:55.6810|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-11-12 21:29:55.6914|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement) in 13066.0824ms 2025-11-12 21:29:55.6914|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-11-12 21:29:55.6914|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 13175.7355ms 200 application/json; charset=utf-8 2025-11-12 21:49:43.1160|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:11603/ACCOUNTSERVICES/iisintegration 0 2025-11-12 21:49:43.1160|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3.95ms 202 2025-11-12 22:18:59.9581||DEBUG|AccountManagement.Program|init main function 2025-11-12 22:19:04.2152|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-11-12 22:19:04.2260|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-11-12 22:19:04.2260|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-11-12 22:19:04.2589|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:19:05.0029|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (21ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2025-11-12 22:19:05.0314|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2025-11-12 22:19:05.0365|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2025-11-12 22:19:05.0365|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2025-11-12 22:19:05.0553|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2025-11-12 22:19:05.0701|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2025-11-12 22:19:06.0467||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-11-12 22:19:06.2275|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAllInitiatePaymentSourceAccountsByUserId?userId=519 2025-11-12 22:19:06.2275|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-11-12 22:19:06.2275|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-11-12 22:19:06.2275|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-11-12 22:19:07.0364|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:07.0364|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:07.0364|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:07.0364|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:07.0364|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 821.4533ms 204 2025-11-12 22:19:07.0364|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 821.449ms 204 2025-11-12 22:19:07.0364|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 821.4504ms 204 2025-11-12 22:19:07.0364|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 821.455ms 204 2025-11-12 22:19:07.0859|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-11-12 22:19:07.1039|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-11-12 22:19:07.1039|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-11-12 22:19:07.1039|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAllInitiatePaymentSourceAccountsByUserId?userId=519 2025-11-12 22:19:07.4254|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:19:07.4254|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:19:07.4254|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:19:07.4254|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:19:07.4254|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:07.4254|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:07.4254|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:07.4254|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:07.4254|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:19:07.4254|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:19:07.4407|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:19:07.4407|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement)' 2025-11-12 22:19:07.4407|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-11-12 22:19:07.4407|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-11-12 22:19:07.4407|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:19:07.4407|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-11-12 22:19:07.4739|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-11-12 22:19:07.4739|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:19:07.4739|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-11-12 22:19:07.4739|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-11-12 22:19:07.4880|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-11-12 22:19:07.5108|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:19:07.5108|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:19:07.5108||WARN|AccountManagement.Core.Services.TreasuryAccountService|CorporateId : 207 2025-11-12 22:19:07.7643|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-11-12 22:19:07.8229|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (31ms) [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-11-12 22:19:07.8229|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (37ms) [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-11-12 22:19:07.8371|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-11-12 22:19:07.8371|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-11-12 22:19:07.8631|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement) in 374.0505ms 2025-11-12 22:19:07.8631|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement)' 2025-11-12 22:19:07.8631|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 757.5229ms 200 application/json; charset=utf-8 2025-11-12 22:19:07.8631|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement) in 393.119ms 2025-11-12 22:19:07.8631|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-11-12 22:19:07.8631|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 769.1817ms 200 application/json; charset=utf-8 2025-11-12 22:19:07.8795||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-11-12 22:19:07.8795||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-11-12 22:19:07.8795||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-11-12 22:19:07.8795||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-11-12 22:19:08.3780||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:08.3780||WARN|AccountManagement.Core.Services.TreasuryAccountService|About to Fetch Treasury Accounts 2025-11-12 22:19:08.3780||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=1100512 2025-11-12 22:19:08.3780||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: api/SL/CorporatePayAPI/V2/Treasury/Accounts/Balance 2025-11-12 22:19:09.4194||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:09.4251||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:09.4251||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:09.4251||WARN|AccountManagement.Core.Services.IntegrationService|Treasury Balance Enquiry Response [] 2025-11-12 22:19:09.4251||WARN|AccountManagement.Core.Services.TreasuryAccountService|Done Fetching Treasury Accounts 2025-11-12 22:19:09.4434|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-11-12 22:19:09.4434|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement) in 1960.6956ms 2025-11-12 22:19:09.4434|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-11-12 22:19:09.4434|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2364.9927ms 200 application/json; charset=utf-8 2025-11-12 22:19:10.4496||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:10.4496||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:10.4496||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100127923 2025-11-12 22:19:11.4811||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:11.4811||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:11.4914||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:12.5278||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:12.5278||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:12.5278||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=0111001293 2025-11-12 22:19:13.5706||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:13.5706||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:13.5834||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:14.6165||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:14.6165||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:14.6165||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=SLE116030002 2025-11-12 22:19:14.7218|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/CurrencyManagement/GetAllCurrencys 2025-11-12 22:19:14.7218|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/BankManagement/GetAllBanks 2025-11-12 22:19:14.7218|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:14.7218|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:14.7218|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 13.5764ms 204 2025-11-12 22:19:14.7380|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 13.3152ms 204 2025-11-12 22:19:15.3509|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/CurrencyManagement/GetAllCurrencys 2025-11-12 22:19:15.3509|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/BankManagement/GetAllBanks 2025-11-12 22:19:15.3509|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:19:15.3509|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:19:15.3635|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:15.3635|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:15.3635|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:19:15.3635|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:19:15.3635|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement)' 2025-11-12 22:19:15.3635|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement)' 2025-11-12 22:19:15.3635|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-11-12 22:19:15.3635|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-11-12 22:19:15.3792|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:19:15.3792|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:19:15.4120|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (16ms) [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-11-12 22:19:15.4396|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-11-12 22:19:15.4447|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement) in 66.9456ms 2025-11-12 22:19:15.4447|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement)' 2025-11-12 22:19:15.4447|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (49ms) [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-11-12 22:19:15.4447|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 97.4013ms 200 application/json; charset=utf-8 2025-11-12 22:19:15.5021|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-11-12 22:19:15.5107|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement) in 132.1282ms 2025-11-12 22:19:15.5107|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement)' 2025-11-12 22:19:15.5107|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 163.5615ms 200 application/json; charset=utf-8 2025-11-12 22:19:15.6631||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:15.6631||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:15.6631||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:16.7095||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:16.7095||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:16.7095||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100129378 2025-11-12 22:19:17.7567||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:17.7567||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:17.7567||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:18.8020||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:18.8020||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:18.8020||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100131027 2025-11-12 22:19:19.8507||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:19.8507||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:19.8507||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:20.8979||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:20.9973|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (7ms) [Parameters=[@p3='?' (DbType = Int64), @p0='?' (DbType = DateTime2), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Int64), @p7='?' (DbType = Int64), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (DbType = Int64), @p11='?' (DbType = Int64), @p8='?' (DbType = DateTime2), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Int64), @p15='?' (DbType = Int64), @p12='?' (DbType = DateTime2), @p13='?' (DbType = DateTime2), @p14='?' (DbType = Int64), @p19='?' (DbType = Int64), @p16='?' (DbType = DateTime2), @p17='?' (DbType = DateTime2), @p18='?' (DbType = Int64), @p23='?' (DbType = Int64), @p20='?' (DbType = DateTime2), @p21='?' (DbType = DateTime2), @p22='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p0, [DateModified] = @p1, [ModifiedBy] = @p2 WHERE [Id] = @p3; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p4, [DateModified] = @p5, [ModifiedBy] = @p6 WHERE [Id] = @p7; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p8, [DateModified] = @p9, [ModifiedBy] = @p10 WHERE [Id] = @p11; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p12, [DateModified] = @p13, [ModifiedBy] = @p14 WHERE [Id] = @p15; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p16, [DateModified] = @p17, [ModifiedBy] = @p18 WHERE [Id] = @p19; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p20, [DateModified] = @p21, [ModifiedBy] = @p22 WHERE [Id] = @p23; SELECT @@ROWCOUNT; 2025-11-12 22:19:21.0293|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 2025-11-12 22:19:21.0509|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-11-12 22:19:21.0805|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-11-12 22:19:21.0805|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-11-12 22:19:21.0805|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-11-12 22:19:21.0805|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-11-12 22:19:21.0805|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-11-12 22:19:21.0805|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-11-12 22:19:21.0992|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-11-12 22:19:21.0992|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-11-12 22:19:21.0992|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-11-12 22:19:21.0992|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-11-12 22:19:21.0992|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-11-12 22:19:21.3219|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-11-12 22:19:21.3343|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement) in 13845.3202ms 2025-11-12 22:19:21.3343|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-11-12 22:19:21.3343|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 14233.8551ms 200 application/json; charset=utf-8 2025-11-12 22:19:28.9496|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-11-12 22:19:28.9496|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-11-12 22:19:28.9496|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-11-12 22:19:28.9496|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:28.9568|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:28.9568|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:28.9568|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 10.2976ms 204 2025-11-12 22:19:28.9568|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 10.0532ms 204 2025-11-12 22:19:28.9568|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.927ms 204 2025-11-12 22:19:29.0053|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-11-12 22:19:29.0053|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-11-12 22:19:29.0053|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-11-12 22:19:29.0053|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:19:29.0053|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:19:29.0183|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:19:29.0183|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:29.0183|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:29.0183|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:29.0183|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:19:29.0183|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:19:29.0183|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:19:29.0346|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-11-12 22:19:29.0346|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-11-12 22:19:29.0346|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-11-12 22:19:29.0346|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-11-12 22:19:29.0346|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-11-12 22:19:29.0346|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-11-12 22:19:29.0346||WARN|AccountManagement.Core.Services.TreasuryAccountService|CorporateId : 207 2025-11-12 22:19:29.0346|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:19:29.0500|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:19:29.0500|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-11-12 22:19:29.0500||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-11-12 22:19:29.0500|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-11-12 22:19:29.0500|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)) 2025-11-12 22:19:29.0500||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-11-12 22:19:29.0500|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement) in 16.8562ms 2025-11-12 22:19:29.0670||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-11-12 22:19:29.0670|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-11-12 22:19:29.0670||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-11-12 22:19:29.0670|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 70.4558ms 200 application/json; charset=utf-8 2025-11-12 22:19:29.1050||WARN|AccountManagement.Core.Services.TreasuryAccountService|About to Fetch Treasury Accounts 2025-11-12 22:19:29.1050||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:29.1050||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: api/SL/CorporatePayAPI/V2/Treasury/Accounts/Balance 2025-11-12 22:19:29.1050||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=1100512 2025-11-12 22:19:30.1489||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:30.1489||WARN|AccountManagement.Core.Services.IntegrationService|Treasury Balance Enquiry Response [] 2025-11-12 22:19:30.1489||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:30.1587||WARN|AccountManagement.Core.Services.TreasuryAccountService|Done Fetching Treasury Accounts 2025-11-12 22:19:30.1587||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:30.1587|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-11-12 22:19:30.1587|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement) in 1122.052ms 2025-11-12 22:19:30.1587|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-11-12 22:19:30.1587|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1164.5382ms 200 application/json; charset=utf-8 2025-11-12 22:19:30.4286|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/CurrencyManagement/GetAllCurrencys 2025-11-12 22:19:30.4286|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/BankManagement/GetAllBanks 2025-11-12 22:19:30.4286|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:30.4286|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:30.4286|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.0338ms 204 2025-11-12 22:19:30.4407|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.9348ms 204 2025-11-12 22:19:30.5484|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/CurrencyManagement/GetAllCurrencys 2025-11-12 22:19:30.5484|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/BankManagement/GetAllBanks 2025-11-12 22:19:30.5511|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:19:30.5511|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:19:30.5511|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:30.5511|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:30.5511|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:19:30.5511|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:19:30.5511|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement)' 2025-11-12 22:19:30.5511|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement)' 2025-11-12 22:19:30.5511|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-11-12 22:19:30.5511|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-11-12 22:19:30.5511|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:19:30.5660|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:19:30.5660|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] 2025-11-12 22:19:30.5660|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-11-12 22:19:30.5834|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement) in 23.0164ms 2025-11-12 22:19:30.5834|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] 2025-11-12 22:19:30.5834|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement)' 2025-11-12 22:19:30.5834|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 40.041ms 200 application/json; charset=utf-8 2025-11-12 22:19:30.6001|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-11-12 22:19:30.6001|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement) in 40.8058ms 2025-11-12 22:19:30.6001|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement)' 2025-11-12 22:19:30.6001|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 57.1419ms 200 application/json; charset=utf-8 2025-11-12 22:19:31.1945||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:31.1945||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:31.1945||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100127923 2025-11-12 22:19:32.2363|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-11-12 22:19:32.2363|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-11-12 22:19:32.2385||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:32.2385|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:19:32.2385|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:19:32.2385||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:32.2385|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:32.2385|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:32.2385||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:32.2385|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:19:32.2385|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:19:32.2385|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-11-12 22:19:32.2538|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-11-12 22:19:32.2538|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-11-12 22:19:32.2538|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-11-12 22:19:32.2538||WARN|AccountManagement.Core.Services.TreasuryAccountService|CorporateId : 207 2025-11-12 22:19:32.2538|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:19:32.2538||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-11-12 22:19:32.2538|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-11-12 22:19:32.2712||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-11-12 22:19:32.2712|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-11-12 22:19:32.2712|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement) in 18.5677ms 2025-11-12 22:19:32.2712|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-11-12 22:19:32.2712|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 41.3334ms 200 application/json; charset=utf-8 2025-11-12 22:19:32.3086||WARN|AccountManagement.Core.Services.TreasuryAccountService|About to Fetch Treasury Accounts 2025-11-12 22:19:32.3086||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: api/SL/CorporatePayAPI/V2/Treasury/Accounts/Balance 2025-11-12 22:19:33.2869||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:33.2869||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:33.2869||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=0111001293 2025-11-12 22:19:33.3496||WARN|AccountManagement.Core.Services.IntegrationService|Treasury Balance Enquiry Response [] 2025-11-12 22:19:33.3496||WARN|AccountManagement.Core.Services.TreasuryAccountService|Done Fetching Treasury Accounts 2025-11-12 22:19:33.3496|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-11-12 22:19:33.3496|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement) in 1098.7898ms 2025-11-12 22:19:33.3496|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-11-12 22:19:33.3496|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1121.5623ms 200 application/json; charset=utf-8 2025-11-12 22:19:33.3956|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/CurrencyManagement/GetAllCurrencys 2025-11-12 22:19:33.3956|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:19:33.3956|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:33.3956|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:19:33.3956|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/BankManagement/GetAllBanks 2025-11-12 22:19:33.3956|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement)' 2025-11-12 22:19:33.3956|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:19:33.3956|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-11-12 22:19:33.4097|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:33.4097|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:19:33.4097|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement)' 2025-11-12 22:19:33.4097|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-11-12 22:19:33.4097|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:19:33.4097|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:19:33.4097|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-11-12 22:19:33.4097|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-11-12 22:19:33.4245|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement) in 13.2724ms 2025-11-12 22:19:33.4245|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement)' 2025-11-12 22:19:33.4245|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 31.056ms 200 application/json; charset=utf-8 2025-11-12 22:19:33.4245|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (10ms) [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-11-12 22:19:33.4434|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-11-12 22:19:33.4434|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement) in 30.0775ms 2025-11-12 22:19:33.4434|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement)' 2025-11-12 22:19:33.4434|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 43.3652ms 200 application/json; charset=utf-8 2025-11-12 22:19:34.3025||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:34.3025||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:34.3025||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:35.3335||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:35.3335||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:35.3335||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=SLE116030002 2025-11-12 22:19:36.3641||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:36.3641||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:36.3641||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:37.4120||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:37.4120||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:37.4120||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100129378 2025-11-12 22:19:38.4591||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:38.4591||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:38.4591||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:39.5058||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:39.5058||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:39.5058||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100131027 2025-11-12 22:19:40.5375||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:40.5375||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:40.5375||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:41.5842||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:41.6068|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [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-11-12 22:19:41.6165|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)) ORDER BY [s].[DateCreated] DESC 2025-11-12 22:19:41.6165|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-11-12 22:19:41.6294|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-11-12 22:19:41.6294|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-11-12 22:19:41.6294|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-11-12 22:19:41.6430|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-11-12 22:19:41.6430|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-11-12 22:19:41.6430|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-11-12 22:19:41.6586|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-11-12 22:19:41.6586|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-11-12 22:19:41.6586|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-11-12 22:19:41.6586|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-11-12 22:19:41.6586|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-11-12 22:19:41.7406|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-11-12 22:19:41.7406|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement) in 12696.7997ms 2025-11-12 22:19:41.7406|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-11-12 22:19:41.7406|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 12744.5089ms 200 application/json; charset=utf-8 2025-11-12 22:19:41.7951|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-11-12 22:19:41.7951|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:19:41.8010|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:19:41.8010|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:19:41.8010|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-11-12 22:19:41.8010|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-11-12 22:19:41.8010|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:19:41.8010|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-11-12 22:19:41.8154||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-11-12 22:19:41.8154||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-11-12 22:19:41.8525||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:41.8525||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=1100512 2025-11-12 22:19:42.8955||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:42.8955||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:42.8955||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:43.9428||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:43.9428||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:43.9428||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100127923 2025-11-12 22:19:44.9895||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:44.9895||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:44.9895||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:46.0211||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:46.0211||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:46.0211||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=0111001293 2025-11-12 22:19:47.0664||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:47.0664||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:47.0664||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:48.0870||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:48.0870||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:48.0870||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=SLE116030002 2025-11-12 22:19:49.1025||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:49.1025||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:49.1025||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:50.1329||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:50.1329||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:50.1329||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100129378 2025-11-12 22:19:51.1807||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:51.1807||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:51.1807||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:52.1985||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:52.1985||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:19:52.1985||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100131027 2025-11-12 22:19:53.2299||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:19:53.2299||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:19:53.2299||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:19:54.2758||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:19:54.2911|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [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-11-12 22:19:54.2911|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 2025-11-12 22:19:54.2911|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-11-12 22:19:54.3079|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-11-12 22:19:54.3079|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-11-12 22:19:54.3079|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-11-12 22:19:54.3079|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-11-12 22:19:54.3214|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-11-12 22:19:54.3214|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-11-12 22:19:54.3214|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-11-12 22:19:54.3214|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-11-12 22:19:54.3367|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-11-12 22:19:54.3367|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-11-12 22:19:54.3367|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-11-12 22:19:54.4052|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-11-12 22:19:54.4052|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement) in 12602.6588ms 2025-11-12 22:19:54.4052|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-11-12 22:19:54.4052|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 12615.686ms 200 application/json; charset=utf-8 2025-11-12 22:20:44.7237|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-11-12 22:20:44.7237|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-11-12 22:20:44.7237|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-11-12 22:20:44.7237|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:20:44.7237|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:20:44.7237|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:20:44.7237|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.0882ms 204 2025-11-12 22:20:44.7237|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 12.5154ms 204 2025-11-12 22:20:44.7237|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 14.0458ms 204 2025-11-12 22:20:44.8125|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-11-12 22:20:44.8125|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-11-12 22:20:44.8125|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-11-12 22:20:44.8173|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:20:44.8173|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:20:44.8173|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:20:44.8173|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:20:44.8173|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:20:44.8324|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:20:44.8324|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:20:44.8324|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:20:44.8324|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:20:44.8324|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-11-12 22:20:44.8480|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-11-12 22:20:44.8480|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-11-12 22:20:44.8480|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-11-12 22:20:44.8480|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-11-12 22:20:44.8480|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-11-12 22:20:44.8480|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:20:44.8480|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:20:44.8480||WARN|AccountManagement.Core.Services.TreasuryAccountService|CorporateId : 207 2025-11-12 22:20:44.8664|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-11-12 22:20:44.8664|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)) 2025-11-12 22:20:44.8664|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-11-12 22:20:44.8664||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-11-12 22:20:44.8664|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement) in 17.4217ms 2025-11-12 22:20:44.8664||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-11-12 22:20:44.8664||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-11-12 22:20:44.8664|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-11-12 22:20:44.8818||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-11-12 22:20:44.8818|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 71.3398ms 200 application/json; charset=utf-8 2025-11-12 22:20:44.9128||WARN|AccountManagement.Core.Services.TreasuryAccountService|About to Fetch Treasury Accounts 2025-11-12 22:20:44.9128||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: api/SL/CorporatePayAPI/V2/Treasury/Accounts/Balance 2025-11-12 22:20:44.9379||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:20:44.9416||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=1100512 2025-11-12 22:20:45.9426||WARN|AccountManagement.Core.Services.IntegrationService|Treasury Balance Enquiry Response [] 2025-11-12 22:20:45.9426||WARN|AccountManagement.Core.Services.TreasuryAccountService|Done Fetching Treasury Accounts 2025-11-12 22:20:45.9426|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-11-12 22:20:45.9426|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement) in 1090.7964ms 2025-11-12 22:20:45.9426|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-11-12 22:20:45.9426|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1141.5798ms 200 application/json; charset=utf-8 2025-11-12 22:20:45.9732||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:20:45.9732||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:20:45.9732||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:20:46.8781|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/CurrencyManagement/GetAllCurrencys 2025-11-12 22:20:46.8781|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/BankManagement/GetAllBanks 2025-11-12 22:20:46.8781|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:20:46.8781|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:20:46.8781|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.3402ms 204 2025-11-12 22:20:46.8781|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 10.5208ms 204 2025-11-12 22:20:47.0038||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:20:47.0038||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:20:47.0038||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100127923 2025-11-12 22:20:48.0362||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:20:48.0362||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:20:48.0362||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:20:48.7661|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/BankManagement/GetAllBanks 2025-11-12 22:20:48.7661|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/CurrencyManagement/GetAllCurrencys 2025-11-12 22:20:48.7702|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:20:48.7702|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:20:48.7702|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:20:48.7702|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:20:48.7702|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:20:48.7702|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:20:48.7826|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement)' 2025-11-12 22:20:48.7826|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement)' 2025-11-12 22:20:48.7826|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-11-12 22:20:48.7826|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-11-12 22:20:48.7826|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:20:48.7826|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:20:48.7826|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [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-11-12 22:20:48.7990|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (5ms) [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-11-12 22:20:48.7990|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-11-12 22:20:48.7990|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement) in 12.3262ms 2025-11-12 22:20:48.7990|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement)' 2025-11-12 22:20:48.7990|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 39.8253ms 200 application/json; charset=utf-8 2025-11-12 22:20:48.7990|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-11-12 22:20:48.7990|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement) in 20.3688ms 2025-11-12 22:20:48.7990|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement)' 2025-11-12 22:20:48.7990|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 45.5321ms 200 application/json; charset=utf-8 2025-11-12 22:20:49.0838||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:20:49.0838||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:20:49.0838||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=0111001293 2025-11-12 22:20:50.1297||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:20:50.1297||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:20:50.1297||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:20:51.1612||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:20:51.1612||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:20:51.1612||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=SLE116030002 2025-11-12 22:20:52.2082||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:20:52.2082||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:20:52.2082||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:20:53.2380||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:20:53.2380||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:20:53.2380||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100129378 2025-11-12 22:20:54.2703||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:20:54.2703||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:20:54.2703||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:20:55.3067||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:20:55.3067||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:20:55.3067||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100131027 2025-11-12 22:20:56.3372||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:20:56.3372||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:20:56.3372||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:20:57.3855||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:20:57.3977|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [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-11-12 22:20:57.3977|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [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-11-12 22:20:57.3977|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-11-12 22:20:57.4130|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-11-12 22:20:57.4130|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-11-12 22:20:57.4130|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-11-12 22:20:57.4130|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-11-12 22:20:57.4130|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-11-12 22:20:57.4313|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-11-12 22:20:57.4313|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-11-12 22:20:57.4313|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-11-12 22:20:57.4313|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-11-12 22:20:57.4446|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-11-12 22:20:57.4446|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-11-12 22:20:57.5077|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-11-12 22:20:57.5077|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement) in 12652.4348ms 2025-11-12 22:20:57.5077|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-11-12 22:20:57.5077|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 12702.8292ms 200 application/json; charset=utf-8 2025-11-12 22:24:35.3724|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-11-12 22:24:35.3724|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:24:35.3724|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3.3878ms 204 2025-11-12 22:24:35.3724|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-11-12 22:24:35.3724|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:24:35.3724|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.2812ms 204 2025-11-12 22:24:35.3904|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-11-12 22:24:35.3904|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:24:35.3959|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.4551ms 204 2025-11-12 22:24:35.7680|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-11-12 22:24:35.7706|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:24:35.7706|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:24:35.7706|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-11-12 22:24:35.7706|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:24:35.7706|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:24:35.7706|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-11-12 22:24:35.7706|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-11-12 22:24:35.7706|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:24:35.7706|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-11-12 22:24:35.7706|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:24:35.7706|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:24:35.7863|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-11-12 22:24:35.7863|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:24:35.7863|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:24:35.7863|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-11-12 22:24:35.7863|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:24:35.7863|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:24:35.7863|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-11-12 22:24:35.7863|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-11-12 22:24:35.7863|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-11-12 22:24:35.7863|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-11-12 22:24:35.7863|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-11-12 22:24:35.8033||WARN|AccountManagement.Core.Services.TreasuryAccountService|CorporateId : 207 2025-11-12 22:24:35.8033|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement) in 11.0667ms 2025-11-12 22:24:35.8033||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-11-12 22:24:35.8033|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-11-12 22:24:35.8033||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-11-12 22:24:35.8033|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 34.7942ms 200 application/json; charset=utf-8 2025-11-12 22:24:35.8033||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-11-12 22:24:35.8033||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-11-12 22:24:35.8344||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:24:35.8344||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=1100512 2025-11-12 22:24:35.8502||WARN|AccountManagement.Core.Services.TreasuryAccountService|About to Fetch Treasury Accounts 2025-11-12 22:24:35.8502||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: api/SL/CorporatePayAPI/V2/Treasury/Accounts/Balance 2025-11-12 22:24:36.8682||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:24:36.8682||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:24:36.8682||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:24:36.8832||WARN|AccountManagement.Core.Services.IntegrationService|Treasury Balance Enquiry Response [] 2025-11-12 22:24:36.8832||WARN|AccountManagement.Core.Services.TreasuryAccountService|Done Fetching Treasury Accounts 2025-11-12 22:24:36.8832|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-11-12 22:24:36.8832|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement) in 1090.6938ms 2025-11-12 22:24:36.8832|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-11-12 22:24:36.8832|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1114.8972ms 200 application/json; charset=utf-8 2025-11-12 22:24:37.8991||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:24:37.8991||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:24:37.8991||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100127923 2025-11-12 22:24:38.9300||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:24:38.9300||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:24:38.9300||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:24:39.9610||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:24:39.9610||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:24:39.9610||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=0111001293 2025-11-12 22:24:40.9914||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:24:40.9914||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:24:40.9914||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:24:42.0237||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:24:42.0237||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:24:42.0237||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=SLE116030002 2025-11-12 22:24:43.0555||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:24:43.0555||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:24:43.0555||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:24:44.0869||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:24:44.0869||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:24:44.0869||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100129378 2025-11-12 22:24:45.1173||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:24:45.1173||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:24:45.1173||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:24:46.1340||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:24:46.1340||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:24:46.1340||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100131027 2025-11-12 22:24:47.1651||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:24:47.1651||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:24:47.1651||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:24:48.2114||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:24:48.2114|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [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-11-12 22:24:48.2114|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)) ORDER BY [s].[DateCreated] DESC 2025-11-12 22:24:48.2250|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-11-12 22:24:48.2250|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [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-11-12 22:24:48.2250|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [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-11-12 22:24:48.2250|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-11-12 22:24:48.2250|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-11-12 22:24:48.2250|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-11-12 22:24:48.2405|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-11-12 22:24:48.2405|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [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-11-12 22:24:48.2405|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [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-11-12 22:24:48.2405|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-11-12 22:24:48.2405|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-11-12 22:24:48.2405|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-11-12 22:24:48.3007|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-11-12 22:24:48.3049|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement) in 12519.2999ms 2025-11-12 22:24:48.3049|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-11-12 22:24:48.3049|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 12540.7116ms 200 application/json; charset=utf-8 2025-11-12 22:25:58.5924|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/Detail/000001011100127923 2025-11-12 22:25:58.5924|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:25:58.5924|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:25:58.5924|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountDetails (AccountManagement)' 2025-11-12 22:25:58.6049|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAccountDetails", controller = "AccountManagement"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAccountDetails(System.String) on controller AccountManagement.Controllers.AccountManagementController (AccountManagement). 2025-11-12 22:25:58.6049|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:25:58.6309|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [Parameters=[@__AccountNo_0='?' (Size = 4000), @__UserTypeId_1='?' (DbType = Int64), @__UserType_2='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [s].[AccountNumber], [s].[AccountName], [b].[Name] AS [BankName], [s].[IsActive], [s].[IsDeleted], [s].[UserTypeId], [s].[UserType], [s].[ApprovalStatus] FROM [SourceAccountManagements] AS [s] INNER JOIN [Banks] AS [b] ON [s].[BankId] = [b].[Id] WHERE (((([s].[AccountNumber] = @__AccountNo_0) AND ([s].[UserTypeId] = @__UserTypeId_1)) AND ([s].[UserType] = @__UserType_2)) AND ([s].[IsActive] = CAST(1 AS bit))) AND ([s].[IsDeleted] = CAST(0 AS bit)) 2025-11-12 22:25:58.6416|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[SourceAccountManagement.Data.Models.SourceAccountManagementViewModel, AccountManagement.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2025-11-12 22:25:58.6511|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAccountDetails (AccountManagement) in 45.1188ms 2025-11-12 22:25:58.6511|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountDetails (AccountManagement)' 2025-11-12 22:25:58.6511|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 62.2377ms 200 application/json; charset=utf-8 2025-11-12 22:26:08.3469|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-11-12 22:26:08.3469|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:26:08.3469|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.0381ms 204 2025-11-12 22:26:08.3469|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-11-12 22:26:08.3469|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:26:08.3469|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.7621ms 204 2025-11-12 22:26:08.3630|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-11-12 22:26:08.3630|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:26:08.3630|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.7572ms 204 2025-11-12 22:26:09.1591|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-11-12 22:26:09.1591|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-11-12 22:26:09.1591|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-11-12 22:26:09.1591|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:26:09.1591|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:26:09.1591|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:26:09.1591|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-11-12 22:26:09.1705|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:26:09.1705|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:26:09.1705|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-11-12 22:26:09.1705|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:26:09.1705|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-11-12 22:26:09.1705|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-11-12 22:26:09.1705|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-11-12 22:26:09.1705|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-11-12 22:26:09.1705|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-11-12 22:26:09.1705|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-11-12 22:26:09.1705|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:26:09.1849|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-11-12 22:26:09.1849|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-11-12 22:26:09.1849||WARN|AccountManagement.Core.Services.TreasuryAccountService|CorporateId : 207 2025-11-12 22:26:09.1849|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-11-12 22:26:09.1849|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [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-11-12 22:26:09.1849||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-11-12 22:26:09.1849|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-11-12 22:26:09.1849||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-11-12 22:26:09.1849||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-11-12 22:26:09.1849|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement) in 11.8532ms 2025-11-12 22:26:09.1849||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-11-12 22:26:09.1849|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-11-12 22:26:09.2027|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 41.259ms 200 application/json; charset=utf-8 2025-11-12 22:26:09.2240||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:26:09.2240||WARN|AccountManagement.Core.Services.TreasuryAccountService|About to Fetch Treasury Accounts 2025-11-12 22:26:09.2240||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=1100512 2025-11-12 22:26:09.2240||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: api/SL/CorporatePayAPI/V2/Treasury/Accounts/Balance 2025-11-12 22:26:10.2680||WARN|AccountManagement.Core.Services.IntegrationService|Treasury Balance Enquiry Response [] 2025-11-12 22:26:10.2680||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:26:10.2680||WARN|AccountManagement.Core.Services.TreasuryAccountService|Done Fetching Treasury Accounts 2025-11-12 22:26:10.2680||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:26:10.2680|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-11-12 22:26:10.2680||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:26:10.2796|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement) in 1090.837ms 2025-11-12 22:26:10.2796|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-11-12 22:26:10.2796|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1124.3837ms 200 application/json; charset=utf-8 2025-11-12 22:26:11.3133||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:26:11.3133||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:26:11.3133||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100127923 2025-11-12 22:26:12.3475||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:26:12.3475||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:26:12.3475||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:26:13.3785||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:26:13.3785||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:26:13.3785||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=0111001293 2025-11-12 22:26:14.4267||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:26:14.4267||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:26:14.4267||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:26:15.4737||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:26:15.4737||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:26:15.4737||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=SLE116030002 2025-11-12 22:26:16.5051||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:26:16.5051||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:26:16.5051||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:26:17.5362||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:26:17.5362||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:26:17.5362||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100129378 2025-11-12 22:26:18.5831||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:26:18.5831||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:26:18.5831||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:26:19.6289||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:26:19.6289||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-11-12 22:26:19.6289||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100131027 2025-11-12 22:26:20.6612||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [] 2025-11-12 22:26:20.6612||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-11-12 22:26:20.6612||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-11-12 22:26:21.6768||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-11-12 22:26:21.6768|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [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-11-12 22:26:21.6905|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [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-11-12 22:26:21.6905|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-11-12 22:26:21.6905|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-11-12 22:26:21.6905|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-11-12 22:26:21.6905|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-11-12 22:26:21.7052|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-11-12 22:26:21.7052|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-11-12 22:26:21.7052|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-11-12 22:26:21.7052|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-11-12 22:26:21.7052|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-11-12 22:26:21.7206|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-11-12 22:26:21.7206|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-11-12 22:26:21.7206|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-11-12 22:26:21.7768|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-11-12 22:26:21.7768|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement) in 12595.9734ms 2025-11-12 22:26:21.7768|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-11-12 22:26:21.7768|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 12622.0774ms 200 application/json; charset=utf-8 2025-11-12 22:46:58.6074|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:40488/ACCOUNTSERVICES/iisintegration 0 2025-11-12 22:46:58.6119|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.5007ms 202