public ActionResult Details(int id) { var cmd = new MySqlCommand { CommandText = "SELECT * FROM tomasenergia WHERE id = @id" }; cmd.Parameters.Add("@id", id); var items = SqlConnector.Instance.GetTable(cmd, out var r); List <TomaEnergia> tomas = new List <TomaEnergia>(); foreach (DataRow i in items.Rows) { var hogar = new TomaEnergia() { Id = int.Parse(i[0].ToString()), IdHabitacion = int.Parse(i[1].ToString()) }; tomas.Add(hogar); } var item = tomas.First(x => x.Id == id); return(View(item)); }
public ActionResult Edit(TomaEnergia item) { try { if (ModelState.IsValid) { var cmd = new MySqlCommand { CommandText = "Update tomasenergia set id = @id, id_habitacion = @IdHabitacion," + " where id = @id" }; cmd.Parameters.Add("@id", item.Id); cmd.Parameters.Add("@IdHabitacion", item.IdHabitacion); SqlConnector.Instance.ExecuteQuery(cmd, out var r); return(RedirectToAction("Index")); } return(RedirectToAction("Index")); } catch { return(View(item)); } }
public void GenerateToma(int idHabitacion) { var h = new TomaEnergia() { IdHabitacion = idHabitacion }; new TomaEnergiaController().Create(h); }
public ActionResult Create(TomaEnergia collection) { if (ModelState.IsValid) { var cmd = new MySqlCommand { CommandText = "INSERT INTO `tomasenergia` (`id`, `id_habitacion`) VALUES (NULL, @IdHabitacion)" }; cmd.Parameters.Add("@IdHabitacion", collection.IdHabitacion); SqlConnector.Instance.ExecuteQuery(cmd, out var r); return(RedirectToAction("Index")); } return(View()); }
// GET: TomaEnergia public ActionResult Index() { var cmd = new MySqlCommand { CommandText = "SELECT * FROM tomasenergia" }; var items = SqlConnector.Instance.GetTable(cmd, out var r); List <TomaEnergia> tomas = new List <TomaEnergia>(); foreach (DataRow i in items.Rows) { var hogar = new TomaEnergia() { Id = int.Parse(i[0].ToString()), IdHabitacion = int.Parse(i[1].ToString()) }; tomas.Add(hogar); } return(View(tomas)); }
public ActionResult Delete(int id, TomaEnergia model) { try { if (ModelState.IsValid) { var cmd = new MySqlCommand { CommandText = "DELETE FROM tomasenergia WHERE id = @id" }; cmd.Parameters.Add("@id", model.Id); SqlConnector.Instance.ExecuteQuery(cmd, out var r); return(RedirectToAction("Index")); } return(View(model)); } catch { return(View()); } }