public ActionResult Editar(CaracterisTica pCarac) { caracRepo.editarCaracteristica(pCarac); @ViewBag.idPac = TempData.Peek("idPaciente"); int idPac = ViewBag.idPac; return(RedirectToAction("IndexTerapeuta", "Terapeuta")); }
public void criarCaracteristica(CaracterisTica pCarac) { ConexaoBD conn = new ConexaoBD(); MySqlCommand cmd = new MySqlCommand(); StringBuilder sql = new StringBuilder(); sql.Append("INSERT INTO caracteristica (nomeCaracteristica) VALUES (@nomeCaracteristica)"); cmd.Parameters.AddWithValue("@nomeCaracteristica", pCarac.nomeCaracteristica); cmd.CommandText = sql.ToString(); conn.executeCommand(cmd); sql.Clear(); }
public void editarCaracteristica(CaracterisTica pCarac) { ConexaoBD conn = new ConexaoBD(); MySqlCommand cmd = new MySqlCommand(); StringBuilder sql = new StringBuilder(); sql.Append("UPDATE caracteristica "); sql.Append("SET nomeCaracteristica=@nomeCaracteristica "); sql.Append("WHERE idCaracteristica=@idCaracteristica"); cmd.Parameters.AddWithValue("@idCaracteristica", pCarac.idCarac); cmd.Parameters.AddWithValue("@nomeCaracteristica", pCarac.nomeCaracteristica); cmd.CommandText = sql.ToString(); conn.executeCommand(cmd); sql.Clear(); }
//getone public CaracterisTica getOne(int pIdCarac) { CaracterisTica caracteristica = new CaracterisTica(); StringBuilder sql = new StringBuilder(); sql.Append("select * from caracteristica where idCaracteristica=@idCarac "); MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = sql.ToString(); cmd.Parameters.AddWithValue("@idCarac", pIdCarac); MySqlDataReader dr = conn.executeSqlReader(cmd); while (dr.Read()) { caracteristica = (new CaracterisTica { idCarac = (int)dr["idCaracteristica"], nomeCaracteristica = (string)dr["nomeCaracteristica"] }); } return(caracteristica); }