public PartialViewResult EditOrderId(EditOrderId model) { ViewBag.Title = "Modifica Codice Commessa"; if (!ModelState.IsValid) { return(PartialView("_EditOrderId", model)); } try { using (var conn = new MySql.Data.MySqlClient.MySqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["GestionaleDB"].ToString())) { conn.Open(); using (var comm = new MySql.Data.MySqlClient.MySqlCommand("UPDATE orders SET OrderId = @NewOrderId WHERE OrderId = @OldOrderId", conn)) { comm.CommandType = System.Data.CommandType.Text; comm.CommandTimeout = 3000; comm.Parameters.AddWithValue("@NewOrderId", model.NewOrderId); comm.Parameters.AddWithValue("@OldOrderId", model.OldOrderId); comm.ExecuteNonQuery(); } conn.Close(); } ViewBag.Message = "Modificato con Successo!"; ViewBag.ReturnUrl = "/Orders/Index"; return(PartialView("../Shared/_Success")); } catch (Exception ex) { ModelState.AddModelError("", ex.MySqlExMessage()); return(PartialView("_EditOrderId", model)); } }
public PartialViewResult GetEditOrderId(string OrderId) { ViewBag.Title = "Modifica Codice Commessa"; var ord = db.Orders.Find(OrderId); var model = new EditOrderId { OldOrderId = ord.OrderId }; return(PartialView("_EditOrderId", model)); }