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