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());
}
}
