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