public static Customer getCustomer(int?id)
{
CreditCardDBContext db = new CreditCardDBContext();
var customer = db.customers.Find(id);
return(customer);
}
public static void addCustomer(Customer customer)
{
CreditCardDBContext db = new CreditCardDBContext();
db.customers.Add(customer);
db.SaveChanges();
}
public static List <Customer> getAllCustomers()
{
CreditCardDBContext db = new CreditCardDBContext();
List <Customer> customer = db.customers.ToList();
return(customer);
}
public static CustomerTransactionsViewModel getCustomerAndTransactions(int?id)
{
CreditCardDBContext db = new CreditCardDBContext();
Customer customer = db.customers.Find(id);
CustomerTransactionsViewModel custTrans = new CustomerTransactionsViewModel();
custTrans.customer = db.customers.Find(id);
var transactions = db.transactions.Where(theTrans =>
theTrans.custID == custTrans.customer.custID
);
custTrans.transactions = transactions.ToList();
return(custTrans);
}
