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"); } } }