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