2025-11-12 21:29:43.4195||DEBUG|PaymentSystem.Program|init main function 
2025-11-12 21:29:44.5911||INFO|Hangfire.SqlServer.SqlServerObjectsInstaller|Start installing Hangfire SQL objects... 
2025-11-12 21:29:44.8345||INFO|Hangfire.SqlServer.SqlServerObjectsInstaller|Hangfire SQL objects installed. 
2025-11-12 21:29:44.8496||INFO|Hangfire.BackgroundJobServer|Starting Hangfire Server using job storage: 'SQL Server: VLIV-EFTDB01@RCPaySL-Live' 
2025-11-12 21:29:44.8496||INFO|Hangfire.BackgroundJobServer|Using the following options for SQL Server job storage: Queue poll interval: 00:00:00. 
2025-11-12 21:29:44.8496||INFO|Hangfire.BackgroundJobServer|Using the following options for Hangfire Server:
    Worker count: 20
    Listening queues: 'default'
    Shutdown timeout: 00:00:15
    Schedule polling interval: 00:00:15 
2025-11-12 21:29:44.9716||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:16876:45c21d00 successfully announced in 96.6193 ms 
2025-11-12 21:29:44.9716||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:16876:45c21d00 is starting the registered dispatchers: ServerWatchdog, ServerJobCancellationWatcher, ExpirationManager, CountersAggregator, Worker, DelayedJobScheduler, RecurringJobScheduler... 
2025-11-12 21:29:44.9850||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:16876:45c21d00 all the dispatchers started 
2025-11-12 21:29:45.7855|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'BlackList'. 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:29:45.7855|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'FeeReversal'. 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:29:45.7952|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'FeeAmount' on entity type 'FeeTransactionLog'. 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:29:45.7952|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'FeeTransactionLogStaging'. 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:29:45.7952|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'FeeAmount' on entity type 'PaymentBatch'. 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:29:45.7952|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'TotalAmount' on entity type 'PaymentBatch'. 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:29:45.7952|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'PaymentItem'. 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:29:45.7952|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CorporateFeeAmount' on entity type 'PaymentItem'. 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:29:45.7952|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CreditAmount' on entity type 'PaymentItem'. 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:29:45.7952|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CustomerFeeAmount' on entity type 'PaymentItem'. 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:29:45.7952|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CorporateFeeAmount' on entity type 'PaymentItemStaging'. 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:29:45.7952|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CreditedAmount' on entity type 'PaymentItemStaging'. 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:29:45.7952|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CustomerFeeAmount' on entity type 'PaymentItemStaging'. 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:29:45.7952|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'PaymentReversal'. 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:29:45.7952|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'PaymentSummaryByBank'. 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:29:45.8110|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Credit' on entity type 'Statement'. 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:29:45.8110|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Debit' on entity type 'Statement'. 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:29:45.8110|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'TotalAmount' on entity type 'UploadStaging'. 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:29:45.8383|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 21:29:45.8383|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 21:29:45.8383|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 21:29:46.1363|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-11-12 21:29:46.1554|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-11-12 21:29:46.1554|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-11-12 21:29:46.1554|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-11-12 21:29:46.1785|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-11-12 21:29:46.1918|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-11-12 21:29:46.2606||WARN|PaymentService.Core.Service.PaymentService|4 payment batch(es) locked inprogress 
2025-11-12 21:29:46.3477||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-405065765-51968188-4129435083-1865239232-3978796933\DataProtection' as key repository and Windows DPAPI to encrypt keys at rest. 
2025-11-12 21:29:46.5292|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-11-12 21:29:46.5292|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/PaymentType/List?isActive=true&institutionId=79   
2025-11-12 21:29:46.6782|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 21:29:46.6782|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 21:29:46.6782|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 155.5668ms 204  
2025-11-12 21:29:46.6782|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 155.5687ms 204  
2025-11-12 21:29:46.7981|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-11-12 21:29:46.7981|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/PaymentType/List?isActive=true&institutionId=79   
2025-11-12 21:29:46.8594|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-12 21:29:46.8594|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-12 21:29:46.8594|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 21:29:46.8594|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 21:29:46.8594|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-12 21:29:46.8594|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-12 21:29:46.8594|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentTypeController.List (PaymentService)' 
2025-11-12 21:29:46.8594|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-11-12 21:29:46.8934|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetPaymentStatistics", controller = "Payment"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetPaymentStatistics(Int64, System.String, System.String, Int32) on controller PaymentService.Controllers.PaymentController (PaymentService). 
2025-11-12 21:29:46.8934|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "List", controller = "PaymentType"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult List(Boolean, Int64, Int64) on controller PaymentService.Controllers.PaymentTypeController (PaymentService). 
2025-11-12 21:29:46.9200|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 21:29:46.9200|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 21:29:46.9905|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (44ms) [Parameters=[@__CorporateId_1='?' (DbType = Int64), @__InstitutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [p].[Name], [p].[Code], [p].[Id], [p].[IsActive], [p].[AllowPartialPayment], [p].[Default], [p].[InstitutionId], @__CorporateId_1 AS [CorporateId]
FROM [PaymentTypes] AS [p]
WHERE (([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit))) AND (([p].[InstitutionId] = @__InstitutionId_0) OR ([p].[InstitutionId] = CAST(0 AS bigint))) 
2025-11-12 21:29:47.0940|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[System.Collections.Generic.List`1[[PaymentService.Data.Model.PaymentTypeModel, PaymentService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 
2025-11-12 21:29:47.0940|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[PaymentService.Data.Model.PaymentStatisticsViewModel, PaymentService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-12 21:29:47.1084|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService) in 212.3217ms 
2025-11-12 21:29:47.1084|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentTypeController.List (PaymentService) in 211.259ms 
2025-11-12 21:29:47.1084|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-11-12 21:29:47.1084|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentTypeController.List (PaymentService)' 
2025-11-12 21:29:47.1084|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 313.3775ms 200 application/json; charset=utf-8 
2025-11-12 21:29:47.1084|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 314.05ms 200 application/json; charset=utf-8 
2025-11-12 21:30:00.1941|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 21:30:00.1941|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 21:35:00.3538|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 21:35:00.4001|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 21:40:00.5720|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 21:40:00.5804|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 21:45:00.6389|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 21:45:00.6389|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 21:50:00.7644|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 21:50:00.7644|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 21:50:42.7669|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:46571/PAYMENTSERVICE/iisintegration  0 
2025-11-12 21:50:42.7669|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.2127ms 202  
2025-11-12 21:50:42.7669||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:16876:45c21d00 caught stopping signal... 
2025-11-12 21:50:42.7669||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:16876:45c21d00 caught stopped signal... 
2025-11-12 21:50:43.8386||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:16876:45c21d00 All dispatchers stopped 
2025-11-12 21:50:43.8511||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:16876:45c21d00 successfully reported itself as stopped in 6.0615 ms 
2025-11-12 21:50:43.8511||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:16876:45c21d00 has been stopped in total 1077.7062 ms 
2025-11-12 22:19:00.1428||DEBUG|PaymentSystem.Program|init main function 
2025-11-12 22:19:03.3950||INFO|Hangfire.SqlServer.SqlServerObjectsInstaller|Start installing Hangfire SQL objects... 
2025-11-12 22:19:03.8271||INFO|Hangfire.SqlServer.SqlServerObjectsInstaller|Hangfire SQL objects installed. 
2025-11-12 22:19:03.8474||INFO|Hangfire.BackgroundJobServer|Starting Hangfire Server using job storage: 'SQL Server: VLIV-EFTDB01@RCPaySL-Live' 
2025-11-12 22:19:03.8474||INFO|Hangfire.BackgroundJobServer|Using the following options for SQL Server job storage: Queue poll interval: 00:00:00. 
2025-11-12 22:19:03.8474||INFO|Hangfire.BackgroundJobServer|Using the following options for Hangfire Server:
    Worker count: 20
    Listening queues: 'default'
    Shutdown timeout: 00:00:15
    Schedule polling interval: 00:00:15 
2025-11-12 22:19:03.9888||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:3512:318f1734 successfully announced in 102.025 ms 
2025-11-12 22:19:03.9888||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:3512:318f1734 is starting the registered dispatchers: ServerWatchdog, ServerJobCancellationWatcher, ExpirationManager, CountersAggregator, Worker, DelayedJobScheduler, RecurringJobScheduler... 
2025-11-12 22:19:04.0084||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:3512:318f1734 all the dispatchers started 
2025-11-12 22:19:05.5003|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'BlackList'. 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:05.5116|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'FeeReversal'. 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:05.5116|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'FeeAmount' on entity type 'FeeTransactionLog'. 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:05.5189|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'FeeTransactionLogStaging'. 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:05.5189|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'FeeAmount' on entity type 'PaymentBatch'. 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:05.5189|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'TotalAmount' on entity type 'PaymentBatch'. 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:05.5189|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'PaymentItem'. 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:05.5189|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CorporateFeeAmount' on entity type 'PaymentItem'. 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:05.5353|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CreditAmount' on entity type 'PaymentItem'. 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:05.5353|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CustomerFeeAmount' on entity type 'PaymentItem'. 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:05.5353|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CorporateFeeAmount' on entity type 'PaymentItemStaging'. 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:05.5353|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CreditedAmount' on entity type 'PaymentItemStaging'. 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:05.5353|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CustomerFeeAmount' on entity type 'PaymentItemStaging'. 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:05.5353|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'PaymentReversal'. 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:05.5353|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'PaymentSummaryByBank'. 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:05.5521|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Credit' on entity type 'Statement'. 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:05.5521|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Debit' on entity type 'Statement'. 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:05.5521|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'TotalAmount' on entity type 'UploadStaging'. 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:05.5851|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:19:05.5851|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:19:05.5851|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:19:06.4935|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-11-12 22:19:06.5127|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (10ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-11-12 22:19:06.5235|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (8ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-11-12 22:19:06.5235|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-11-12 22:19:06.5630|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (15ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-11-12 22:19:06.5833|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-11-12 22:19:07.0351||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-405065765-51968188-4129435083-1865239232-3978796933\DataProtection' as key repository and Windows DPAPI to encrypt keys at rest. 
2025-11-12 22:19:07.3279|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/PaymentType/List?isActive=true&institutionId=79   
2025-11-12 22:19:07.3279|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-11-12 22:19:08.1203|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:19:08.1203|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:19:08.1307|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 803.2822ms 204  
2025-11-12 22:19:08.1307|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 803.282ms 204  
2025-11-12 22:19:08.6025|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/PaymentType/List?isActive=true&institutionId=79   
2025-11-12 22:19:08.8402|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-11-12 22:19:08.8552|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-12 22:19:08.8552|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-12 22:19:08.8552|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:19:08.8552|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:19:08.8687|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-12 22:19:08.8687|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-12 22:19:08.8687|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentTypeController.List (PaymentService)' 
2025-11-12 22:19:08.8687|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-11-12 22:19:08.9117|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetPaymentStatistics", controller = "Payment"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetPaymentStatistics(Int64, System.String, System.String, Int32) on controller PaymentService.Controllers.PaymentController (PaymentService). 
2025-11-12 22:19:08.9117|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "List", controller = "PaymentType"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult List(Boolean, Int64, Int64) on controller PaymentService.Controllers.PaymentTypeController (PaymentService). 
2025-11-12 22:19:08.9471|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:19:08.9471|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:19:08.9870|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[@__CorporateId_1='?' (DbType = Int64), @__InstitutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [p].[Name], [p].[Code], [p].[Id], [p].[IsActive], [p].[AllowPartialPayment], [p].[Default], [p].[InstitutionId], @__CorporateId_1 AS [CorporateId]
FROM [PaymentTypes] AS [p]
WHERE (([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit))) AND (([p].[InstitutionId] = @__InstitutionId_0) OR ([p].[InstitutionId] = CAST(0 AS bigint))) 
2025-11-12 22:19:09.1701|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[PaymentService.Data.Model.PaymentStatisticsViewModel, PaymentService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-12 22:19:09.1701|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[System.Collections.Generic.List`1[[PaymentService.Data.Model.PaymentTypeModel, PaymentService.Data, 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:09.1900|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentTypeController.List (PaymentService) in 271.4762ms 
2025-11-12 22:19:09.1900|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService) in 274.8291ms 
2025-11-12 22:19:09.1921|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentTypeController.List (PaymentService)' 
2025-11-12 22:19:09.1921|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-11-12 22:19:09.1921|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 594.2166ms 200 application/json; charset=utf-8 
2025-11-12 22:19:09.1921|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 358.3323ms 200 application/json; charset=utf-8 
2025-11-12 22:19:28.9498|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-11-12 22:19:28.9498|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:19:28.9574|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7.9774ms 204  
2025-11-12 22:19:28.9971|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-11-12 22:19:28.9971|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-12 22:19:29.0043|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:19:29.0043|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-12 22:19:29.0043|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-11-12 22:19:29.0215|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetPaymentStatistics", controller = "Payment"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetPaymentStatistics(Int64, System.String, System.String, Int32) on controller PaymentService.Controllers.PaymentController (PaymentService). 
2025-11-12 22:19:29.0215|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:19:29.1602|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[PaymentService.Data.Model.PaymentStatisticsViewModel, PaymentService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-12 22:19:29.1602|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService) in 140.2675ms 
2025-11-12 22:19:29.1602|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-11-12 22:19:29.1602|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 172.3409ms 200 application/json; charset=utf-8 
2025-11-12 22:19:32.2365|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-11-12 22:19:32.2365|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-12 22:19:32.2365|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:19:32.2365|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-12 22:19:32.2365|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-11-12 22:19:32.2365|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetPaymentStatistics", controller = "Payment"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetPaymentStatistics(Int64, System.String, System.String, Int32) on controller PaymentService.Controllers.PaymentController (PaymentService). 
2025-11-12 22:19:32.2365|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:19:32.3856|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[PaymentService.Data.Model.PaymentStatisticsViewModel, PaymentService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-12 22:19:32.3856|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService) in 140.6918ms 
2025-11-12 22:19:32.3856|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-11-12 22:19:32.3939|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 157.5541ms 200 application/json; charset=utf-8 
2025-11-12 22:20:04.6559|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:20:04.7223|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:20:44.7212|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-11-12 22:20:44.7262|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:20:44.7262|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7.4556ms 204  
2025-11-12 22:20:44.8120|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-11-12 22:20:44.8172|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-12 22:20:44.8172|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:20:44.8172|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-12 22:20:44.8341|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-11-12 22:20:44.8341|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetPaymentStatistics", controller = "Payment"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetPaymentStatistics(Int64, System.String, System.String, Int32) on controller PaymentService.Controllers.PaymentController (PaymentService). 
2025-11-12 22:20:44.8341|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:20:44.9731|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[PaymentService.Data.Model.PaymentStatisticsViewModel, PaymentService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-12 22:20:44.9731|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService) in 132.0557ms 
2025-11-12 22:20:44.9731|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-11-12 22:20:44.9731|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 165.5184ms 200 application/json; charset=utf-8 
2025-11-12 22:24:35.3349|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-11-12 22:24:35.3349|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:24:35.3349|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.0147ms 204  
2025-11-12 22:24:35.7353|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-11-12 22:24:35.7420|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-12 22:24:35.7420|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:24:35.7420|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-12 22:24:35.7420|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-11-12 22:24:35.7420|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetPaymentStatistics", controller = "Payment"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetPaymentStatistics(Int64, System.String, System.String, Int32) on controller PaymentService.Controllers.PaymentController (PaymentService). 
2025-11-12 22:24:35.7420|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:24:35.8701|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[PaymentService.Data.Model.PaymentStatisticsViewModel, PaymentService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-12 22:24:35.8701|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService) in 124.6994ms 
2025-11-12 22:24:35.8701|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-11-12 22:24:35.8701|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 141.3023ms 200 application/json; charset=utf-8 
2025-11-12 22:24:38.8668|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/PendingQueue/207?StartDate=2025-11-12&EndDate=2025-11-12&UploadStatus=2&Page=1&PageSize=100   
2025-11-12 22:24:38.8668|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:24:38.8668|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7.0943ms 204  
2025-11-12 22:24:38.9508|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/PendingQueue/207?StartDate=2025-11-12&EndDate=2025-11-12&UploadStatus=2&Page=1&PageSize=100   
2025-11-12 22:24:38.9508|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-12 22:24:38.9508|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:24:38.9607|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-12 22:24:38.9607|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentController.GetPendingPaymentQueue (PaymentService)' 
2025-11-12 22:24:38.9607|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetPendingPaymentQueue", controller = "Payment"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetPendingPaymentQueue(Int64, System.String, System.String, System.String, Int32, Int32, Int32) on controller PaymentService.Controllers.PaymentController (PaymentService). 
2025-11-12 22:24:38.9754|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:24:41.9162|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[CorporatePay.Common.Model.PagedModel`1[[PaymentService.Data.Model.PaymentDetailModel, PaymentService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], CorporatePay.Common, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-12 22:24:41.9355|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentController.GetPendingPaymentQueue (PaymentService) in 2961.0994ms 
2025-11-12 22:24:41.9355|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentController.GetPendingPaymentQueue (PaymentService)' 
2025-11-12 22:24:41.9355|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2987.5086ms 200 application/json; charset=utf-8 
2025-11-12 22:25:04.8476|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:25:04.8476|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:25:33.4384|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Detail/b706dcf4-c5f5-4790-9736-491efdded855   
2025-11-12 22:25:33.4384|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:25:33.4384|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.9266ms 204  
2025-11-12 22:25:55.0983|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Detail/b706dcf4-c5f5-4790-9736-491efdded855   
2025-11-12 22:25:55.0983|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:25:55.1041|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.8261ms 204  
2025-11-12 22:25:56.9980|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Detail/b706dcf4-c5f5-4790-9736-491efdded855   
2025-11-12 22:25:56.9980|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-12 22:25:57.0052|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:25:57.0052|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-12 22:25:57.0052|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentController.GetPaymentDetais (PaymentService)' 
2025-11-12 22:25:57.0052|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetPaymentDetais", controller = "Payment"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetPaymentDetais(System.String) on controller PaymentService.Controllers.PaymentController (PaymentService). 
2025-11-12 22:25:57.0221|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:25:58.3036|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (9ms) [Parameters=[@__SessionId_0='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [u].[Id], [u].[BatchDesc], [u].[CorporateId], [u].[CreatedBy], [u].[CurrencyId], [u].[DateCreated], [u].[DateModified], [u].[Error], [u].[FeeId], [u].[FilePath], [u].[IsActive], [u].[IsDeleted], [u].[Message], [u].[ModifiedBy], [u].[PaymentBatchIds], [u].[PaymentMode], [u].[PaymentType], [u].[ProcessingStage], [u].[ReferenceNo], [u].[SendToBank], [u].[SessionId], [u].[SourceAccount], [u].[SplitBatch], [u].[SplitByBank], [u].[SuspenseAccount], [u].[TotalAmount], [u].[TotalItems], [u].[UploadMethod], [u].[UploadStatus], [u].[UserType], [u].[UserTypeId]
FROM [UploadStaging] AS [u]
WHERE [u].[SessionId] = @__SessionId_0 
2025-11-12 22:25:58.3799|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (5ms) [Parameters=[@__8__locals1_upload_PaymentType_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [PaymentTypes] AS [p]
        WHERE [p].[Id] = @__8__locals1_upload_PaymentType_0) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END 
2025-11-12 22:25:58.4298|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [Parameters=[@__8__locals1_upload_ReferenceNo_0='?' (Size = 4000), @__8__locals1_upload_CorporateId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [UploadStaging] AS [u]
WHERE (([u].[ReferenceNo] = @__8__locals1_upload_ReferenceNo_0) AND ([u].[CorporateId] = @__8__locals1_upload_CorporateId_1)) AND [u].[UploadStatus] NOT IN (3, 6) 
2025-11-12 22:25:58.6764||WARN|PaymentService.Core.Service.IntegrationService|Response from Account: {"data":{"id":0,"userTypeId":207,"userType":1,"accountName":"AGDEXPENDITUREACCOUNTS-GENERA","accountNumber":"000001011100127923","currentBalance":0.0,"formattedAmount":"0.00","overdraftLimit":0.0,"formattedOverdraftLimit":"0.00","bankId":0,"banks":null,"bankName":"Bank of Sierra Leone","approvalStatus":1,"approvalStatusDate":"0001-01-01T00:00:00","rejectionComment":null,"code":null,"isActive":true,"isDeleted":false,"whoCanViewSourceAccount":null,"whoCanInitaitePaymentOnSourceAccount":null,"currency":null},"code":"00","success":true,"description":"Success"} 
2025-11-12 22:25:58.7652|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[PaymentService.Data.Model.PaymentDetailModel, PaymentService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-12 22:25:58.7652|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentController.GetPaymentDetais (PaymentService) in 1751.5623ms 
2025-11-12 22:25:58.7652|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentController.GetPaymentDetais (PaymentService)' 
2025-11-12 22:25:58.7732|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1775.316ms 200 application/json; charset=utf-8 
2025-11-12 22:26:08.3387|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-11-12 22:26:08.3387|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:26:08.3414|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.6539ms 204  
2025-11-12 22:26:09.1559|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-11-12 22:26:09.1559|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-12 22:26:09.1559|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-12 22:26:09.1559|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-12 22:26:09.1696|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-11-12 22:26:09.1696|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetPaymentStatistics", controller = "Payment"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetPaymentStatistics(Int64, System.String, System.String, Int32) on controller PaymentService.Controllers.PaymentController (PaymentService). 
2025-11-12 22:26:09.1696|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:26:09.3053|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[PaymentService.Data.Model.PaymentStatisticsViewModel, PaymentService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-12 22:26:09.3053|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService) in 135.1332ms 
2025-11-12 22:26:09.3053|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-11-12 22:26:09.3108|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 154.8743ms 200 application/json; charset=utf-8 
2025-11-12 22:30:04.9904|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:30:04.9987|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:35:05.1792|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:35:05.2247|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:40:05.3447|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:40:05.3447|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:45:05.5142|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:45:05.5142|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-11-12 22:46:58.6394|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:42653/PAYMENTSERVICE/iisintegration  0 
2025-11-12 22:46:58.6433||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:3512:318f1734 caught stopping signal... 
2025-11-12 22:46:58.6433|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.0542ms 202  
2025-11-12 22:46:58.6433||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:3512:318f1734 caught stopped signal... 
2025-11-12 22:46:59.7180||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:3512:318f1734 All dispatchers stopped 
2025-11-12 22:46:59.7353||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:3512:318f1734 successfully reported itself as stopped in 6.196 ms 
2025-11-12 22:46:59.7353||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:3512:318f1734 has been stopped in total 1086.3219 ms