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