public static Model.Visita BuscarPorId(int clienteId)
{
using (MySqlConnection conn = new MySqlConnection(strConection))
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = @"SELECT * FROM visita WHERE id = ?id";
cmd.Parameters.AddWithValue("?id", clienteId);
MySqlDataReader reader = cmd.ExecuteReader();
Model.Visita retorno = new Model.Visita();
while (reader.Read())
{
retorno.Id = (int)reader["Id"];
retorno.CondominoId = (int)reader["idCondomino"];
retorno.VisitanteId = (int)reader["idVisitante"];
retorno.DataVisita = (DateTime)reader["datavisita"];
retorno.HoraEntrada = (TimeSpan)reader["horaEntrada"];
retorno.HoraSaida = (TimeSpan)reader["horaSaida"];
}
return(retorno);
}
}
}
public ActionResult Edit(int id, Model.Visita visita)
{
try
{
// TODO: Add update logic here
Control.VisitaDAO.Salvar(visita);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(Model.Visita visita)
{
try
{
// TODO: Add insert logic here
Control.VisitaDAO.Salvar(visita);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public static void Salvar(Model.Visita visita)
{
DateTime dt = DateTime.Now;
visita.DataVisita = dt;
visita.HoraEntrada = new TimeSpan(dt.Hour, dt.Minute, dt.Second);
using (MySqlConnection conn = new MySqlConnection(strConection))
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = conn;
if (visita.Id == 0)
{
cmd.CommandText = @"INSERT INTO visita (idCondomino, idVisitante, datavisita, horaEntrada, horaSaida) VALUES (?idCondomino, ?idVisitante, ?datavisita, ?horaEntrada, ?horaSaida);";
}
else
{
cmd.CommandText = @"UPDATE visita
SET idCondomino = ?idCondomino,
idVisitante = ?idVisitante,
datavisita = ?datavisita,
horaEntrada = ?horaEntrada,
horaSaida = ?horaSaida
WHERE id = ?id;";
}
cmd.Parameters.AddWithValue("?idCondomino", visita.CondominoId);
cmd.Parameters.AddWithValue("?idVisitante", visita.VisitanteId);
cmd.Parameters.AddWithValue("?datavisita", visita.DataVisita);
cmd.Parameters.AddWithValue("?horaEntrada", visita.HoraEntrada);
cmd.Parameters.AddWithValue("?horaSaida", visita.HoraSaida);
cmd.Parameters.AddWithValue("?id", visita.Id);
cmd.ExecuteNonQuery();
}
}
}
