public ActionResult StaffList()
{
List<Staff> Staffs;
using (var db = new LINQExercisesEntities())
{
Staffs = db.Staff.ToList();
}
return View(Staffs);
}
public ActionResult CustomerList()
{
List<Customer> Customers;
using (var db = new LINQExercisesEntities())
{
Customers = db.Customer.ToList();
}
return View(Customers);
}
public ActionResult CreateStore(Store store)
{
using (var db = new LINQExercisesEntities())
{
db.Store.Add(store);
db.SaveChanges();
}
return(RedirectToAction("StoreList"));
}
public ActionResult StoreList()
{
List <Store> stores;
using (var db = new LINQExercisesEntities())
{
stores = db.Store.ToList();
}
return(View(stores));
}
public ActionResult TransactionDetail(int id=1)
{
List<TransactionHead> header;
using (var db = new LINQExercisesEntities())
{
header = db.TransactionHead.Include("TransactionLine.Product")
.Include("Customer")
.Include("Staff")
.Include("Store")
.ToList();
}
return View(header);
}
public ActionResult CreateCustomer(Customer c)
{
/*
* var new_cus = new Customer
* {
* Name = c.Name,
* Address = c.Address,
* Phone = c.Phone,
* TransactionHead = c.TransactionHead
*
* };
*/
using (var db = new LINQExercisesEntities())
{
db.Customer.Add(c);
db.SaveChanges();
}
return(RedirectToAction("CustomerList"));
}
