public static Model.Condomino BuscarPorId(int condominoId)
{
using (MySqlConnection conn = new MySqlConnection(strConection))
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = @"SELECT * FROM condomino WHERE id = ?id";
cmd.Parameters.AddWithValue("?id", condominoId);
MySqlDataReader reader = cmd.ExecuteReader();
Model.Condomino retorno = new Model.Condomino();
while (reader.Read())
{
retorno.Id = (int)reader["Id"];
retorno.Nome = (string)reader["nome"];
retorno.CPF = (string)reader["cpf"];
retorno.RG = (string)reader["rg"];
retorno.Telefone = (string)reader["telefone"];
retorno.Email = (string)reader["email"];
retorno.IdApartamento = (int)reader["idApartamento"];
}
return(retorno);
}
}
}
public ActionResult Create(Model.Condomino condomino)
{
try
{
Control.CondominoDAO.Salvar(condomino);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Edit(int id, Model.Condomino condominio)
{
try
{
// TODO: Add update logic here
Control.CondominoDAO.Salvar(condominio);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public static void Salvar(Model.Condomino condomino)
{
using (MySqlConnection conn = new MySqlConnection(strConection))
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = conn;
if (condomino.Id == 0)
{
cmd.CommandText = @"INSERT INTO condomino
(nome, cpf, rg, telefone, email, idApartamento)
VALUES
(?nome, ?cpf, ?rg, ?telefone, ?email, ?idApartamento);";
}
else
{
cmd.CommandText = @"UPDATE condomino
SET nome = ?nome,
cpf = ?cpf,
rg = ?rg,
telefone = ?telefone,
email = ?email,
idApartamento = ?idApartamento
WHERE id = ?id;";
}
cmd.Parameters.AddWithValue("?nome", condomino.Nome);
cmd.Parameters.AddWithValue("?cpf", condomino.CPF);
cmd.Parameters.AddWithValue("?rg", condomino.RG);
cmd.Parameters.AddWithValue("?telefone", condomino.Telefone);
cmd.Parameters.AddWithValue("?email", condomino.Email);
cmd.Parameters.AddWithValue("?idApartamento", condomino.IdApartamento);
cmd.Parameters.AddWithValue("?id", condomino.Id);
cmd.ExecuteNonQuery();
}
}
}
