public IEnumerable <BankWithClients> RetrieveAllBanksWithClients()
{
var results = _repo.DebtsForPeopleAndBanks().Result.Where(d => d.Amount > 0);
var banks = _repo.AllBanks().Result;
var bankClients = new List <BankWithClients>();
foreach (var bank in banks)
{
var theBank = new BankWithClients()
{
BankId = bank.IDBank,
BankName = bank.Name,
Clients = new List <Person>()
};
bankClients.Add(theBank);
}
foreach (var item in bankClients)
{
foreach (var debt in results)
{
if (item.BankId == debt.bank.IDBank)
{
item.Clients.Add(debt.person);
}
}
}
return(bankClients);
}
public IEnumerable <Person> RetrieveListOfPersonsWithMultipleDebts()
{
var results = _repo.DebtsForPeopleAndBanks().Result.Where(d => d.Amount > 0);
var personsWithTwoBanks = new List <Person>();
foreach (var debt in results)
{
var persWithDebt = results.Where(d => d.person.IDPerson == debt.person.IDPerson);
if (persWithDebt.Count() > 1 && !personsWithTwoBanks.Contains(debt.person))
{
personsWithTwoBanks.Add(debt.person);
}
}
return(personsWithTwoBanks);
}
static void Main(string[] args)
{
var d = new DebtRepository();
Console.WriteLine(System.Text.Json.JsonSerializer.Serialize(d.AllBanks()));
Console.WriteLine(System.Text.Json.JsonSerializer.Serialize(d.AllPersons()));
Console.WriteLine(System.Text.Json.JsonSerializer.Serialize(d.DebtsForPeopleAndBanks()));
}
