protected override async Task HandleCore(RefreshAccountTransfersCommand message)
{
var validationResult = _validator.Validate(message);
if (!validationResult.IsValid())
{
throw new InvalidRequestException(validationResult.ValidationDictionary);
}
try
{
var paymentTransfers = await _paymentService.GetAccountTransfers(message.PeriodEnd, message.ReceiverAccountId);
//Handle multiple transfers for the same account, period end and commitment ID by grouping them together
//This can happen if delivery months are different by collection months are not for payments
var transfers = paymentTransfers.GroupBy(t => new { t.SenderAccountId, t.ReceiverAccountId, CommitmentId = t.ApprenticeshipId, t.PeriodEnd })
.Select(g =>
{
var firstGroupItem = g.First();
return(new AccountTransfer
{
PeriodEnd = firstGroupItem.PeriodEnd,
Amount = g.Sum(x => x.Amount),
ApprenticeshipId = firstGroupItem.ApprenticeshipId,
ReceiverAccountId = firstGroupItem.ReceiverAccountId,
ReceiverAccountName = firstGroupItem.ReceiverAccountName,
SenderAccountId = firstGroupItem.SenderAccountId,
SenderAccountName = firstGroupItem.SenderAccountName,
Type = firstGroupItem.Type
});
}).ToArray();
var transferSenderIds = transfers.Select(t => t.SenderAccountId).Distinct();
var transferSenderAccountNames = await _accountRepository.GetAccountNames(transferSenderIds);
var transferReceiverAccountName = await _accountRepository.GetAccountName(message.ReceiverAccountId);
foreach (var transfer in transfers)
{
transfer.PeriodEnd = message.PeriodEnd;
var paymentDetails = await _transferRepository.GetTransferPaymentDetails(transfer);
transfer.CourseName = paymentDetails.CourseName ?? "Unknown Course";
transfer.CourseLevel = paymentDetails.CourseLevel;
transfer.ApprenticeCount = paymentDetails.ApprenticeCount;
transfer.SenderAccountName = transferSenderAccountNames[transfer.SenderAccountId];
transfer.ReceiverAccountName = transferReceiverAccountName;
if (transfer.Amount != paymentDetails.PaymentTotal)
{
_logger.Warn("Transfer total does not match transfer payments total");
}
}
await _transferRepository.CreateAccountTransfers(transfers);
}
catch (Exception ex)
{
_logger.Error(ex, $"Could not process transfers for Account Id {message.ReceiverAccountId} and Period End {message.PeriodEnd}");
throw;
}
}