public Account GetAccountByIban(string iban)
{
using (var context = new Persondb2Context())
{
try
{
var account = context.Account.FirstOrDefault(a => a.Iban == iban);
return(account);
}
catch (Exception ex)
{
throw new NotImplementedException($"{ex.Message}\n{ex.InnerException.Message} \nXXX");
}
}
}
public Transaction GetTransactionsOfAccount(string iban)
{
using (var context = new Persondb2Context())
{
try
{
var transaction = context.Transaction.Last(t => t.Iban == iban);
return(transaction);
}
catch (Exception ex)
{
throw new NotImplementedException($"{ex.Message}\n{ex.InnerException.Message} \nXXX");
}
}
}
public void Create(Bank bank)
{
using (var context = new Persondb2Context())
{
try
{
context.Add(bank);
context.SaveChanges();
}
catch (Exception ex)
{
throw new NotImplementedException($"{ex.Message}\n{ex.InnerException.Message} \nXXX");
}
}
}
public Bank GetBankById(long id)
{
using (var context = new Persondb2Context())
{
try
{
var bank = context.Bank.FirstOrDefault(b => b.Id == id);
return(bank);
}
catch (Exception ex)
{
throw new NotImplementedException($"{ex.Message}\n{ex.InnerException.Message} \nXXX");
}
}
}
public List <Bank> GetBanks()
{
using (var context = new Persondb2Context())
{
try
{
List <Bank> banks = context.Bank.ToListAsync().Result;
return(banks);
}
catch (Exception ex)
{
throw new NotImplementedException($"{ex.Message}\n{ex.InnerException.Message} \n");
}
}
}
public void AddTransaction(Transaction transaction)
{
using (var context = new Persondb2Context())
{
try
{
context.Add(transaction);
var account = GetAccountByIban(transaction.Iban);
account.Balance += transaction.Amount;
context.Account.Update(account);
context.SaveChanges();
}
catch (Exception ex)
{
throw new NotImplementedException($"{ex.Message}\n{ex.InnerException.Message} \n");
}
}
}
public void Delete(int id)
{
using (var context = new Persondb2Context())
{
try
{
var delBank = context.Bank.FirstOrDefault(b => b.Id == id);
if (delBank != null)
{
context.Bank.Remove(delBank);
}
context.SaveChanges();
}
catch (Exception ex)
{
throw new NotImplementedException($"{ex.Message}\n{ex.InnerException.Message} \nXXX");
}
}
}
public List <Bank> GetTransactionsFromBankCustomersAccounts()
{
using (var context = new Persondb2Context())
{
try
{
List <Bank> banks = context.Bank
.Include(b => b.Customer)
.Include(b => b.Account)
.Include(b => b.Account).ThenInclude(a => a.Transaction)
.Where(b => b.Id == 13)
.ToListAsync().Result;
return(banks);
}
catch (Exception ex)
{
throw new NotImplementedException($"{ex.Message}\n{ex.InnerException.Message} \n");
}
}
}
public void Update(Bank bank)
{
using (var context = new Persondb2Context())
{
try
{
var updateBank = GetBankById(bank.Id);
if (updateBank != null)
{
updateBank.Name = bank.Name;
updateBank.Bic = bank.Bic;
context.Bank.Update(updateBank);
}
context.SaveChanges();
}
catch (Exception ex)
{
throw new NotImplementedException($"{ex.Message}\n{ex.InnerException.Message} \nXXX");
}
}
}
