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