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 CustomerDetails(customers customer) { using (var dc = new MySQLEntities()) { if (customer.idcustomers == Guid.Empty) { customer.idcustomers = Guid.NewGuid(); dc.customers.Add(customer); dc.SaveChanges(); } else { dc.Entry(customer).State = EntityState.Modified; dc.SaveChanges(); } } return(RedirectToAction("Customers")); }
public ActionResult DistrictDetails(districts district) { using (var dc = new MySQLEntities()) { if (district.iddistricts == Guid.Empty) { district.iddistricts = Guid.NewGuid(); dc.districts.Add(district); dc.SaveChanges(); } else { dc.Entry(district).State = EntityState.Modified; dc.SaveChanges(); } } return(RedirectToAction("Districts")); }
public ActionResult WorktypeDetails(worktypes worktype) { using (var dc = new MySQLEntities()) { if (worktype.idWorkTypes == Guid.Empty) { worktype.idWorkTypes = Guid.NewGuid(); dc.worktypes.Add(worktype); dc.SaveChanges(); } else { dc.Entry(worktype).State = EntityState.Modified; dc.SaveChanges(); } } return(RedirectToAction("Worktypes")); }
public ActionResult WorkDetails(works work) { using (var dc = new MySQLEntities()) { if (work.idWorks == Guid.Empty) { work.idWorks = Guid.NewGuid(); dc.works.Add(work); dc.SaveChanges(); } else { dc.Entry(work).State = EntityState.Modified; dc.SaveChanges(); } } return(RedirectToAction("Works")); //if (idWorksAsString == null) //{ // return HttpNotFound(); //} //try //{ // using (var dc = new MySQLEntities()) // { // Guid idWorks = new Guid(idWorksAsString); // var elementMySQL = dc.works.Find(idWorks); // return PartialView(elementMySQL); // }; //} //catch (Exception ex) //{ //return HttpNotFound(); //} }