public ActionResult OrderDetails(OrderAndTable model) { var order = model.order; using (var dc = new MySQLEntities()) { var orderInDb = dc.orders.Find(order.idOrders); if (orderInDb == null) { order.idOrders = Guid.NewGuid(); dc.orders.Add(order); dc.SaveChanges(); } else { //dc.Set<order>().AddOrUpdate(order); dc.Entry(orderInDb).CurrentValues.SetValues(order); dc.Entry(orderInDb).State = EntityState.Modified; dc.SaveChanges(); } } Thread.Sleep(1000); return(RedirectToAction("../Home/Index")); }
public ActionResult OrderDetails(string idOrdersAsString) { try { using (var dc = new MySQLEntities()) { SelectList districts = new SelectList(dc.districts.ToList(), "iddistricts", "name"); ViewBag.Districts = districts; SelectList statuses = new SelectList(dc.status.ToList(), "idstatus", "name"); ViewBag.Statuses = statuses; SelectList customers = new SelectList(dc.customers.ToList(), "idcustomers", "name"); ViewBag.Customers = customers; SelectList worktypes = new SelectList(dc.worktypes.ToList(), "idWorkTypes", "name"); ViewBag.Worktypes = worktypes; SelectList masters = new SelectList(dc.masters.ToList(), "idMasters", "name"); ViewBag.Masters = masters; SelectList works = new SelectList(dc.works.ToList(), "idWorks", "name"); ViewBag.Works = works; var order = new orders(); if (idOrdersAsString == "") { order.idOrders = Guid.NewGuid(); } else { Guid idOrders = new Guid(idOrdersAsString); order = dc.orders.Find(idOrders); } var model = new OrderAndTable(order) { order = order, }; return(PartialView(model)); }; } catch (Exception ex) { return(HttpNotFound()); } }
public ActionResult RemoveWorkOrder(OrderAndTable model, int index) { model.RemoveWorkOrder(index); return(Json(model)); }
public ActionResult AddWorkOrder(OrderAndTable model) { model.AddWorkOrder(); return(Json(model)); }
public ActionResult SaveOrder(OrderAndTable model) { model.SaveTable(); return(Json(model)); }