2025-11-29 00:50:41.9730||DEBUG|ReportService.Program|init main function 
2025-11-29 00:50:43.4772|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'ForeignAmount' 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-29 00:50:43.4772|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'ForeignAmount' on entity type 'TransactionItem'. 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-29 00:50:43.5204|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-11-29 00:50:44.0269|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (17ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-11-29 00:50:44.0505|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-11-29 00:50:44.0567|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-11-29 00:50:44.0567|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-11-29 00:50:44.0821|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-11-29 00:50:44.0984|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-11-29 00:50:44.3328||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-1110769482-1405036209-1633820378-260903415-1084590633\DataProtection' as key repository and Windows DPAPI to encrypt keys at rest. 
2025-11-29 00:50:44.5274|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/ReportService/api/Dashboard/Transactions/Current?CorporateId=207&Page=1&PageLenght=3   
2025-11-29 00:50:44.8071|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 00:50:44.8200|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 292.8648ms 204  
2025-11-29 00:50:44.9437|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/ReportService/api/Dashboard/Transactions/Current?CorporateId=207&Page=1&PageLenght=3   
2025-11-29 00:50:45.0935|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-29 00:50:45.0935|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 00:50:45.1050|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-29 00:50:45.1050|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'ReportService.Controllers.DashboardController.FetchCurrentTransactions (ReportService)' 
2025-11-29 00:50:45.1438|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "FetchCurrentTransactions", controller = "Dashboard"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] FetchCurrentTransactions(Int64, Int32, Int32) on controller ReportService.Controllers.DashboardController (ReportService). 
2025-11-29 00:50:45.4790|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[ReportService.Data.Models.DashboardTransactions, ReportService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-29 00:50:45.5394|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action ReportService.Controllers.DashboardController.FetchCurrentTransactions (ReportService) in 390.9458ms 
2025-11-29 00:50:45.5394|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'ReportService.Controllers.DashboardController.FetchCurrentTransactions (ReportService)' 
2025-11-29 00:50:45.5394|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 601.1886ms 200 application/json; charset=utf-8 
2025-11-29 00:52:41.3809|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/ReportService/api/report/PaymentReport   
2025-11-29 00:52:41.3809|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 00:52:41.3918|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 10.9666ms 204  
2025-11-29 00:52:56.5898|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/ReportService/api/report/PaymentReport   
2025-11-29 00:52:56.5898|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 00:52:56.6006|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.1195ms 204  
2025-11-29 00:52:56.9235|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/ReportService/api/report/PaymentReport application/json 236 
2025-11-29 00:52:56.9276|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-29 00:52:56.9276|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 00:52:56.9276|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-29 00:52:56.9276|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'ReportService.Controllers.ReportController.PaymentReport (ReportService)' 
2025-11-29 00:52:56.9429|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "PaymentReport", controller = "Report"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] PaymentReport(AuditTrailUtility.Utility.SearchCall`1[ReportService.Data.Models.PaymentBatchSearch]) on controller ReportService.Controllers.ReportController (ReportService). 
2025-11-29 00:52:57.1375|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-11-29 00:52:57.3597|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (66ms) [Parameters=[@CorporateId='?' (DbType = Int64), @Export='?' (DbType = Boolean), @UserType='?' (DbType = Int32), @UserTypeId='?' (DbType = Int64), @Search='?', @AccountName='?', @Id='?' (DbType = Int64), @StartDate='?' (DbType = DateTime), @EndDate='?' (DbType = DateTime), @PaymentTypeId='?' (DbType = Int64), @Page='?' (DbType = Int32), @PageSize='?' (DbType = Int32), @CurrencyId='?' (DbType = Int64), @DateOption='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SP_GetPaymentReport @CorporateId,@UserType,@UserTypeId,@Id,@Search,@AccountName,@Startdate,@Enddate,@PaymentTypeId,@Export,@Page,@PageSize,@CurrencyId,@DateOption 
2025-11-29 00:52:57.6460|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[ReportService.Data.Models.PaymentBatchModel, ReportService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-29 00:52:57.6690|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action ReportService.Controllers.ReportController.PaymentReport (ReportService) in 724.7958ms 
2025-11-29 00:52:57.6690|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'ReportService.Controllers.ReportController.PaymentReport (ReportService)' 
2025-11-29 00:52:57.6690|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 750.0765ms 200 application/json; charset=utf-8 
2025-11-29 00:53:00.9767|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/ReportService/api/report/PaymentReport application/json 236 
2025-11-29 00:53:00.9767|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-29 00:53:00.9767|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 00:53:00.9767|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-29 00:53:00.9908|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'ReportService.Controllers.ReportController.PaymentReport (ReportService)' 
2025-11-29 00:53:00.9908|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "PaymentReport", controller = "Report"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] PaymentReport(AuditTrailUtility.Utility.SearchCall`1[ReportService.Data.Models.PaymentBatchSearch]) on controller ReportService.Controllers.ReportController (ReportService). 
2025-11-29 00:53:01.0229|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-11-29 00:53:01.0645|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (36ms) [Parameters=[@CorporateId='?' (DbType = Int64), @Export='?' (DbType = Boolean), @UserType='?' (DbType = Int32), @UserTypeId='?' (DbType = Int64), @Search='?', @AccountName='?', @Id='?' (DbType = Int64), @StartDate='?' (DbType = DateTime), @EndDate='?' (DbType = DateTime), @PaymentTypeId='?' (DbType = Int64), @Page='?' (DbType = Int32), @PageSize='?' (DbType = Int32), @CurrencyId='?' (DbType = Int64), @DateOption='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SP_GetPaymentReport @CorporateId,@UserType,@UserTypeId,@Id,@Search,@AccountName,@Startdate,@Enddate,@PaymentTypeId,@Export,@Page,@PageSize,@CurrencyId,@DateOption 
2025-11-29 00:53:01.1309|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[ReportService.Data.Models.PaymentBatchModel, ReportService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-29 00:53:01.1309|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action ReportService.Controllers.ReportController.PaymentReport (ReportService) in 141.41ms 
2025-11-29 00:53:01.1309|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'ReportService.Controllers.ReportController.PaymentReport (ReportService)' 
2025-11-29 00:53:01.1309|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 162.7896ms 200 application/json; charset=utf-8 
2025-11-29 00:53:17.5493|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/ReportService/api/report/PaymentReport   
2025-11-29 00:53:17.5493|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 00:53:17.5493|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.9212ms 204  
2025-11-29 00:53:17.6180|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/ReportService/api/report/PaymentReport application/json 236 
2025-11-29 00:53:17.6241|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-29 00:53:17.6241|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 00:53:17.6241|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-29 00:53:17.6241|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'ReportService.Controllers.ReportController.PaymentReport (ReportService)' 
2025-11-29 00:53:17.6241|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "PaymentReport", controller = "Report"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] PaymentReport(AuditTrailUtility.Utility.SearchCall`1[ReportService.Data.Models.PaymentBatchSearch]) on controller ReportService.Controllers.ReportController (ReportService). 
2025-11-29 00:53:17.6365|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-11-29 00:53:17.6890|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (48ms) [Parameters=[@CorporateId='?' (DbType = Int64), @Export='?' (DbType = Boolean), @UserType='?' (DbType = Int32), @UserTypeId='?' (DbType = Int64), @Search='?', @AccountName='?', @Id='?' (DbType = Int64), @StartDate='?' (DbType = DateTime), @EndDate='?' (DbType = DateTime), @PaymentTypeId='?' (DbType = Int64), @Page='?' (DbType = Int32), @PageSize='?' (DbType = Int32), @CurrencyId='?' (DbType = Int64), @DateOption='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SP_GetPaymentReport @CorporateId,@UserType,@UserTypeId,@Id,@Search,@AccountName,@Startdate,@Enddate,@PaymentTypeId,@Export,@Page,@PageSize,@CurrencyId,@DateOption 
2025-11-29 00:53:17.7510|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[ReportService.Data.Models.PaymentBatchModel, ReportService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-29 00:53:17.7510|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action ReportService.Controllers.ReportController.PaymentReport (ReportService) in 122.6743ms 
2025-11-29 00:53:17.7510|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'ReportService.Controllers.ReportController.PaymentReport (ReportService)' 
2025-11-29 00:53:17.7510|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 141.4367ms 200 application/json; charset=utf-8 
2025-11-29 00:53:21.6579|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/ReportService/api/report/PaymentReport application/json 236 
2025-11-29 00:53:21.6579|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-29 00:53:21.6579|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 00:53:21.6683|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-29 00:53:21.6683|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'ReportService.Controllers.ReportController.PaymentReport (ReportService)' 
2025-11-29 00:53:21.6683|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "PaymentReport", controller = "Report"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] PaymentReport(AuditTrailUtility.Utility.SearchCall`1[ReportService.Data.Models.PaymentBatchSearch]) on controller ReportService.Controllers.ReportController (ReportService). 
2025-11-29 00:53:21.6683|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-11-29 00:53:21.7245|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (43ms) [Parameters=[@CorporateId='?' (DbType = Int64), @Export='?' (DbType = Boolean), @UserType='?' (DbType = Int32), @UserTypeId='?' (DbType = Int64), @Search='?', @AccountName='?', @Id='?' (DbType = Int64), @StartDate='?' (DbType = DateTime), @EndDate='?' (DbType = DateTime), @PaymentTypeId='?' (DbType = Int64), @Page='?' (DbType = Int32), @PageSize='?' (DbType = Int32), @CurrencyId='?' (DbType = Int64), @DateOption='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SP_GetPaymentReport @CorporateId,@UserType,@UserTypeId,@Id,@Search,@AccountName,@Startdate,@Enddate,@PaymentTypeId,@Export,@Page,@PageSize,@CurrencyId,@DateOption 
2025-11-29 00:53:21.7921|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[ReportService.Data.Models.PaymentBatchModel, ReportService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-29 00:53:21.7921|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action ReportService.Controllers.ReportController.PaymentReport (ReportService) in 121.6996ms 
2025-11-29 00:53:21.7921|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'ReportService.Controllers.ReportController.PaymentReport (ReportService)' 
2025-11-29 00:53:21.7921|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 141.1395ms 200 application/json; charset=utf-8 
2025-11-29 00:53:29.4984|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/ReportService/api/report/PaymentReport   
2025-11-29 00:53:29.4984|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 00:53:29.4984|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.6445ms 204  
2025-11-29 00:53:29.5476|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/ReportService/api/report/PaymentReport application/json 236 
2025-11-29 00:53:29.5476|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-29 00:53:29.5618|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 00:53:29.5618|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-29 00:53:29.5618|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'ReportService.Controllers.ReportController.PaymentReport (ReportService)' 
2025-11-29 00:53:29.5618|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "PaymentReport", controller = "Report"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] PaymentReport(AuditTrailUtility.Utility.SearchCall`1[ReportService.Data.Models.PaymentBatchSearch]) on controller ReportService.Controllers.ReportController (ReportService). 
2025-11-29 00:53:29.5618|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-11-29 00:53:29.6089|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (33ms) [Parameters=[@CorporateId='?' (DbType = Int64), @Export='?' (DbType = Boolean), @UserType='?' (DbType = Int32), @UserTypeId='?' (DbType = Int64), @Search='?', @AccountName='?', @Id='?' (DbType = Int64), @StartDate='?' (DbType = DateTime), @EndDate='?' (DbType = DateTime), @PaymentTypeId='?' (DbType = Int64), @Page='?' (DbType = Int32), @PageSize='?' (DbType = Int32), @CurrencyId='?' (DbType = Int64), @DateOption='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SP_GetPaymentReport @CorporateId,@UserType,@UserTypeId,@Id,@Search,@AccountName,@Startdate,@Enddate,@PaymentTypeId,@Export,@Page,@PageSize,@CurrencyId,@DateOption 
2025-11-29 00:53:29.6824|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[ReportService.Data.Models.PaymentBatchModel, ReportService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-29 00:53:29.6899|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action ReportService.Controllers.ReportController.PaymentReport (ReportService) in 121.5348ms 
2025-11-29 00:53:29.6899|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'ReportService.Controllers.ReportController.PaymentReport (ReportService)' 
2025-11-29 00:53:29.6899|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 147.6208ms 200 application/json; charset=utf-8 
2025-11-29 00:54:04.8991|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/ReportService/api/report/PaymentReport   
2025-11-29 00:54:04.9035|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 00:54:04.9035|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6.7386ms 204  
2025-11-29 00:54:04.9785|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://rcpayapi.mof.gov.sl/ReportService/api/report/PaymentReport application/json 237 
2025-11-29 00:54:04.9785|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-29 00:54:04.9785|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 00:54:04.9785|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-29 00:54:04.9785|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'ReportService.Controllers.ReportController.PaymentReport (ReportService)' 
2025-11-29 00:54:04.9785|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "PaymentReport", controller = "Report"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] PaymentReport(AuditTrailUtility.Utility.SearchCall`1[ReportService.Data.Models.PaymentBatchSearch]) on controller ReportService.Controllers.ReportController (ReportService). 
2025-11-29 00:54:04.9995|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-11-29 00:54:05.0422|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (36ms) [Parameters=[@CorporateId='?' (DbType = Int64), @Export='?' (DbType = Boolean), @UserType='?' (DbType = Int32), @UserTypeId='?' (DbType = Int64), @Search='?', @AccountName='?', @Id='?' (DbType = Int64), @StartDate='?' (DbType = DateTime), @EndDate='?' (DbType = DateTime), @PaymentTypeId='?' (DbType = Int64), @Page='?' (DbType = Int32), @PageSize='?' (DbType = Int32), @CurrencyId='?' (DbType = Int64), @DateOption='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SP_GetPaymentReport @CorporateId,@UserType,@UserTypeId,@Id,@Search,@AccountName,@Startdate,@Enddate,@PaymentTypeId,@Export,@Page,@PageSize,@CurrencyId,@DateOption 
2025-11-29 00:54:05.1071|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[ReportService.Data.Models.PaymentBatchModel, ReportService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-29 00:54:05.1071|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action ReportService.Controllers.ReportController.PaymentReport (ReportService) in 116.5513ms 
2025-11-29 00:54:05.1071|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'ReportService.Controllers.ReportController.PaymentReport (ReportService)' 
2025-11-29 00:54:05.1071|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 135.0597ms 200 application/json; charset=utf-8 
2025-11-29 00:56:30.2200|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/ReportService/api/Dashboard/Transactions/Current?CorporateId=207&Page=1&PageLenght=3   
2025-11-29 00:56:30.2200|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 00:56:30.2200|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6.8558ms 204  
2025-11-29 00:56:30.2960|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/ReportService/api/Dashboard/Transactions/Current?CorporateId=207&Page=1&PageLenght=3   
2025-11-29 00:56:30.3018|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-29 00:56:30.3018|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 00:56:30.3018|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-29 00:56:30.3018|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'ReportService.Controllers.DashboardController.FetchCurrentTransactions (ReportService)' 
2025-11-29 00:56:30.3018|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "FetchCurrentTransactions", controller = "Dashboard"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] FetchCurrentTransactions(Int64, Int32, Int32) on controller ReportService.Controllers.DashboardController (ReportService). 
2025-11-29 00:56:30.3410|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[ReportService.Data.Models.DashboardTransactions, ReportService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-29 00:56:30.3438|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action ReportService.Controllers.DashboardController.FetchCurrentTransactions (ReportService) in 29.8433ms 
2025-11-29 00:56:30.3438|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'ReportService.Controllers.DashboardController.FetchCurrentTransactions (ReportService)' 
2025-11-29 00:56:30.3438|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 53.9002ms 200 application/json; charset=utf-8 
2025-11-29 01:16:41.1527|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:34770/REPORTSERVICE/iisintegration  0 
2025-11-29 01:16:41.1527|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3.7146ms 202  
2025-11-29 08:08:28.4587||DEBUG|ReportService.Program|init main function 
2025-11-29 08:08:29.4914|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'ForeignAmount' 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-29 08:08:29.5029|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'ForeignAmount' on entity type 'TransactionItem'. 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-29 08:08:29.5326|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-11-29 08:08:30.0115|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (16ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-11-29 08:08:30.0334|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-11-29 08:08:30.0334|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-11-29 08:08:30.0420|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-11-29 08:08:30.0630|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-11-29 08:08:30.0836|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-11-29 08:08:30.2446||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-1110769482-1405036209-1633820378-260903415-1084590633\DataProtection' as key repository and Windows DPAPI to encrypt keys at rest. 
2025-11-29 08:08:30.5356|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/ReportService/api/Dashboard/Transactions/Current?CorporateId=207&Page=1&PageLenght=3   
2025-11-29 08:08:30.6659|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 08:08:30.6659|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 137.3985ms 204  
2025-11-29 08:08:30.9988|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/ReportService/api/Dashboard/Transactions/Current?CorporateId=207&Page=1&PageLenght=3   
2025-11-29 08:08:31.1288|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-29 08:08:31.1347|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 08:08:31.1347|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-29 08:08:31.1347|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'ReportService.Controllers.DashboardController.FetchCurrentTransactions (ReportService)' 
2025-11-29 08:08:31.1777|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "FetchCurrentTransactions", controller = "Dashboard"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] FetchCurrentTransactions(Int64, Int32, Int32) on controller ReportService.Controllers.DashboardController (ReportService). 
2025-11-29 08:08:31.5223|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[ReportService.Data.Models.DashboardTransactions, ReportService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-29 08:08:31.5812|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action ReportService.Controllers.DashboardController.FetchCurrentTransactions (ReportService) in 399.356ms 
2025-11-29 08:08:31.5812|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'ReportService.Controllers.DashboardController.FetchCurrentTransactions (ReportService)' 
2025-11-29 08:08:31.5812|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 586.5992ms 200 application/json; charset=utf-8 
2025-11-29 08:29:27.7170|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:5546/REPORTSERVICE/iisintegration  0 
2025-11-29 08:29:27.7170|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.7852ms 202  
2025-11-29 08:49:08.4093||DEBUG|ReportService.Program|init main function 
2025-11-29 08:49:09.2305|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'ForeignAmount' 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-29 08:49:09.2436|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'ForeignAmount' on entity type 'TransactionItem'. 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-29 08:49:09.2736|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2025-11-29 08:49:09.5581|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (15ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-11-29 08:49:09.5798|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-11-29 08:49:09.5798|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-11-29 08:49:09.5798|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-11-29 08:49:09.6085|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-11-29 08:49:09.6236|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-11-29 08:49:09.7548||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-1110769482-1405036209-1633820378-260903415-1084590633\DataProtection' as key repository and Windows DPAPI to encrypt keys at rest. 
2025-11-29 08:49:10.1400|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/ReportService/api/Dashboard/Transactions/Current?CorporateId=207&Page=1&PageLenght=3   
2025-11-29 08:49:10.2079|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 08:49:10.2166|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 77.0303ms 204  
2025-11-29 08:49:10.3067|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/ReportService/api/Dashboard/Transactions/Current?CorporateId=207&Page=1&PageLenght=3   
2025-11-29 08:49:10.4282|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-11-29 08:49:10.4282|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-11-29 08:49:10.4398|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-11-29 08:49:10.4398|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'ReportService.Controllers.DashboardController.FetchCurrentTransactions (ReportService)' 
2025-11-29 08:49:10.4744|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "FetchCurrentTransactions", controller = "Dashboard"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] FetchCurrentTransactions(Int64, Int32, Int32) on controller ReportService.Controllers.DashboardController (ReportService). 
2025-11-29 08:49:10.7301|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[ReportService.Data.Models.DashboardTransactions, ReportService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-11-29 08:49:10.7878|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action ReportService.Controllers.DashboardController.FetchCurrentTransactions (ReportService) in 308.7214ms 
2025-11-29 08:49:10.7878|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'ReportService.Controllers.DashboardController.FetchCurrentTransactions (ReportService)' 
2025-11-29 08:49:10.7878|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 486.3454ms 200 application/json; charset=utf-8 
2025-11-29 09:10:07.8053|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:17562/REPORTSERVICE/iisintegration  0 
2025-11-29 09:10:07.8053|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3.2402ms 202