public static void SaveCustomer(BankDTO.CustomerDTO createdCustomer) { var db = new dbBankEntities(); var newCustomer = setCustomerInfo(createdCustomer); db.tbCustomers.Add(newCustomer); db.SaveChanges(); }
public static void DeleteRow(int index, Guid customerId) { var db = new dbBankEntities(); var deleteSelectedRow = (from account in db.tbSavings where account.Customer_Id == customerId && account.SavingId == index select account).FirstOrDefault(); db.tbSavings.Remove(deleteSelectedRow); db.SaveChanges(); }
public static void CreateAccount(Guid customerId, decimal amount) { var db = new dbBankEntities(); Random random = new Random(); var newAccount = new tbSaving(); newAccount.Customer_Id = customerId; newAccount.RoutingNumber = CreateNewRoutingNumber(random, db); newAccount.AccountNumber = CreateNewAccountNumber(random); newAccount.Amount = amount; db.tbSavings.Add(newAccount); db.SaveChanges(); }
public static void StoreChange(AccountDTO _changedAccount) { var db = new dbBankEntities(); var queryDbAmount = (from account in db.tbSavings where account.SavingId == _changedAccount.SavingId select account).FirstOrDefault(); queryDbAmount.Amount = _changedAccount.Amount; /*var changedAccount = new tbSaving(); * changedAccount.AccountNumber = _changedAccount.AccountNumber; * changedAccount.Amount = _changedAccount.Amount; * changedAccount.Customer_Id = _changedAccount.Customer_Id; * changedAccount.RoutingNumber = _changedAccount.RoutingNumber; * changedAccount.SavingId = _changedAccount.SavingId; * * db.tbSavings.Remove(queryDbAmount); * db.tbSavings.Add(changedAccount);*/ db.SaveChanges(); }