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