public static CCTrans getTransaction(int id)
{
CreditCardDbContext db = new CreditCardDbContext();
CCTrans transaction = db.transactions.Find(id);
return(transaction);
}
public static List <Customer> getCustomers()
{
CreditCardDbContext db = new CreditCardDbContext();
List <Customer> customers = db.customers.ToList();
return(customers);
}
public static List <CCTrans> getTransactions()
{
CreditCardDbContext db = new CreditCardDbContext();
List <CCTrans> transactions = db.transactions.ToList();
return(transactions);
}
public static Customer getCustomer(int id)
{
CreditCardDbContext db = new CreditCardDbContext();
Customer customer = db.customers.Find(id);
return(customer);
}
public static void updateTransDesc(int transId, string transDesc)
{
CreditCardDbContext db = new CreditCardDbContext();
CCTrans transaction = getTransaction(transId);
transaction.transDesc = transDesc;
db.Entry(transaction).State = EntityState.Modified;
db.SaveChanges();
}