public bool UpdateOrderInMySQL(OrderInJSON order) { try { using (var dc = new MySQLEntities()) { Guid idOrders = new Guid(order.idOrders); var elementMySQL = dc.orders.Find(idOrders); if (elementMySQL == null) { elementMySQL = dc.orders.Add(new orders()); } elementMySQL.idOrders = new Guid(order.idOrders); elementMySQL.formationDate = DateTime.Parse(order.formationDate); elementMySQL.Customer = new Guid(order.customer); elementMySQL.workType = new Guid(order.workType); elementMySQL.CustomerComment = order.customerComment; elementMySQL.District = new Guid(order.district); elementMySQL.InitialAmount = order.initialAmount; elementMySQL.status = order.status; elementMySQL.orderNumber = order.orderNumber; if (order.master.IsEmpty()) { elementMySQL.Master = null; } else { masters masterInMySQL = dc.masters.SingleOrDefault(item => item.IdFirebase == order.master); elementMySQL.Master = masterInMySQL.idMasters; } elementMySQL.MasterComment = order.masterComment; elementMySQL.TotalAmount = order.totalAmount; //elementMySQL.Work = new Guid(order.work); // var newValue = DateTime.ParseExact(value[0], "yyyy-mm-dd", null); dc.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }
public ActionResult MasterDetails(string idMastersAsString) { try { using (var dc = new MySQLEntities()) { //SelectList districts = new SelectList(dc.districts.ToList(), "iddistricts", "name"); //ViewBag.Districts = districts; //SelectList worktypes = new SelectList(dc.worktypes.ToList(), "idWorkTypes", "name"); //ViewBag.Worktypes = worktypes; var master = new masters(); if (idMastersAsString == "") { master.idMasters = Guid.NewGuid(); } else { Guid idMasters = new Guid(idMastersAsString); master = dc.masters.Find(idMasters); } var model = new MasterAndTable(master) { master = master, }; ViewBag.districtsmaster = model.districtsmaster; return(PartialView(model)); }; } catch (Exception ex) { return(HttpNotFound()); } }