public ViewResult showorder()
{
var context = new LntDatabaseEntitiesEntities();
var model = context.orders.ToList();
return(View(model));
}
public ActionResult Neworders(order ord)
{
var context = new LntDatabaseEntitiesEntities();
context.orders.Add(ord);
context.SaveChanges();
return(RedirectToAction("showorder"));
}
public ViewResult Find(string id)
{
int custid = int.Parse(id);
var context = new LntDatabaseEntitiesEntities();
var model = context.orders.FirstOrDefault((e) => e.cust_id == custid);
return(View(model));
}
public ActionResult Delete(string id)
{
//convert string to int
int custid = int.Parse(id);
var context = new LntDatabaseEntitiesEntities();
var model = context.orders.FirstOrDefault((e) => e.cust_id == custid);
context.orders.Remove(model);
context.SaveChanges();
return(RedirectToAction("showorder"));
}
public ActionResult Find(order ord)
{
var context = new LntDatabaseEntitiesEntities();
var model = context.orders.FirstOrDefault((e) => e.cust_id == ord.cust_id);
model.cust_name = ord.cust_name;
model.item_name = ord.item_name;
model.price = ord.price;
context.SaveChanges();//Commits the changes made to the records...
return(RedirectToAction("showorder"));
}