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