// GET: CustomerOrderDetail public ActionResult Index() { OrderModelContainer DB = new OrderModelContainer(); List <CustomerViewModel> CustomerVMList = new List <CustomerViewModel>(); var customerList = (from cust in DB.CustomerSet join ord in DB.OrderSet on cust.CustomerId equals ord.Customer.CustomerId select new { cust.CustomerId, cust.CustomerName, cust.CustomerAddress, cust.CustomerMail, ord.OrderDate, ord.OrderPrice }).ToList(); foreach (var item in customerList) { CustomerViewModel cvm = new CustomerViewModel(); cvm.CustomerId = item.CustomerId; cvm.CustomerName = item.CustomerName; cvm.CustomerAddress = item.CustomerAddress; cvm.CustomerMail = item.CustomerMail; cvm.OrderDate = item.OrderDate; cvm.OrderPrice = item.OrderPrice; CustomerVMList.Add(cvm); } return(View(CustomerVMList)); }
public void populateCustomer(object selectCustomer = null) { OrderModelContainer DB = new OrderModelContainer(); var customerQuery = from d in DB.CustomerSet orderby d.CustomerName select d; ViewBag.CustomerId = new SelectList(customerQuery, "CustomerId", "CustomerName", selectCustomer); }
public ActionResult Create(Order order) { OrderModelContainer DB = new OrderModelContainer(); int currentCustomer = Convert.ToInt32(Request.Form["CustomerId"]); var customer = (from q in DB.CustomerSet where q.CustomerId == currentCustomer select q).FirstOrDefault(); order.Customer = customer; DB.OrderSet.Add(order); DB.SaveChanges(); return(RedirectToAction("Index")); }
// GET: Customer public ActionResult Index() { OrderModelContainer DB = new OrderModelContainer(); return(View(DB.CustomerSet)); }