public ActionResult EditRecord(int id) { OrderUnit ou = OrdersRepository.GetOrder(id); if (ou == null) { return(HttpNotFound()); } return(View(ou)); }
public bool UpdateOrder(OrderUnit item) { using (context = new DBEntities()) { var searchitem = context.Orders.Find(item.OrderID); if (searchitem != null) { searchitem.ManagerName = item.ManagerName; searchitem.CustomerName = item.CustomerName; searchitem.Amount = item.Amount; searchitem.ProductName = item.ProductName; searchitem.Date = item.Date; context.Entry(searchitem).State = EntityState.Modified; context.SaveChanges(); return(true); } return(false); } }
public IEnumerable <OrderUnit> GetAllOrders() { using (context = new DBEntities()) { foreach (OrdersRecord or in context.Orders) { if (or != null) { OrderUnit ou = new OrderUnit(); ou.OrderID = or.OrderID; ou.ManagerName = or.ManagerName; ou.CustomerName = or.CustomerName; ou.Amount = or.Amount; ou.ProductName = or.ProductName; ou.Date = or.Date; yield return(ou); } } } }
public Exception AddOrder(OrderUnit item) { using (context = new DBEntities()) { try { context.Orders.Add(new OrdersRecord() { ManagerName = item.ManagerName, CustomerName = item.CustomerName, Amount = item.Amount, ProductName = item.ProductName, Date = item.Date }); context.SaveChanges(); } catch (Exception e) { return(e); } return(null); } }
public OrderUnit GetOrder(int id) { using (context = new DBEntities()) { var searchitem = context.Orders.Find(id); if (searchitem != null) { OrderUnit ou = new OrderUnit() { OrderID = searchitem.OrderID, ManagerName = searchitem.ManagerName, CustomerName = searchitem.CustomerName, Amount = searchitem.Amount, ProductName = searchitem.ProductName, Date = searchitem.Date }; return(ou); } else { return(null); } } }
public ActionResult EditRecord(OrderUnit ou) { OrdersRepository.UpdateOrder(ou); return(RedirectToAction("Index")); }