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