public static Model.Patrimonio BuscarPorId(int clienteId) { using (MySqlConnection conn = new MySqlConnection(strConection)) { conn.Open(); using (MySqlCommand cmd = new MySqlCommand()) { cmd.Connection = conn; cmd.CommandText = @"SELECT * FROM patrimonio WHERE id = ?id"; cmd.Parameters.AddWithValue("?id", clienteId); MySqlDataReader reader = cmd.ExecuteReader(); Model.Patrimonio retorno = new Model.Patrimonio(); while (reader.Read()) { retorno.Id = (int)reader["Id"]; retorno.Descricao = (string)reader["descricao"]; retorno.Tipo = (string)reader["tipo"]; retorno.EmManutecao = (bool)reader["emManutencao"]; retorno.TorreId = (int)reader["idTorre"]; retorno.Local = (string)reader["local"]; } return(retorno); } } }
public ActionResult Create(Model.Patrimonio patrimonio) { try { Control.PatrimonioDAO.Salvar(patrimonio); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Edit(int id, Model.Patrimonio patrimonio) { try { // TODO: Add update logic here Control.PatrimonioDAO.Salvar(patrimonio); return(RedirectToAction("Index")); } catch { return(View()); } }
public static void Salvar(Model.Patrimonio patrimonio) { using (MySqlConnection conn = new MySqlConnection(strConection)) { conn.Open(); using (MySqlCommand cmd = new MySqlCommand()) { cmd.Connection = conn; if (patrimonio.Id == 0) { cmd.CommandText = @"INSERT INTO patrimonio (descricao, emManutencao, local, tipo, idTorre) VALUES (?descricao, ?emManutencao, ?local, ?tipo, ?idTorre);"; } else { cmd.CommandText = @"UPDATE patrimonio SET descricao = ?descricao, emManutencao = ?emManutencao, local = ?local, tipo = ?tipo, idTorre = ?idTorre, status = ?status, idCondominio = ?idCondominio WHERE id = ?id;"; } cmd.Parameters.AddWithValue("?descricao", patrimonio.Descricao); cmd.Parameters.AddWithValue("?emManutencao", patrimonio.EmManutecao); cmd.Parameters.AddWithValue("?local", patrimonio.Local); cmd.Parameters.AddWithValue("?tipo", patrimonio.Tipo); cmd.Parameters.AddWithValue("?idTorre", patrimonio.TorreId); cmd.Parameters.AddWithValue("?id", patrimonio.Id); cmd.ExecuteNonQuery(); } } }