public IHttpActionResult GetMaxIdHoja() { FarmacoClinica farmaco = null; using (MySqlConnection conexion = ConexionBase.GetDBConnection()) { conexion.Open(); string consulta = "Select id from hojaprofilaxis order by id desc limit 1"; MySqlCommand query = new MySqlCommand(consulta, conexion); using (var reader = query.ExecuteReader()) { reader.Read(); farmaco = new FarmacoClinica { idClinica = Convert.ToInt32(reader["id"].ToString()) }; } } if (farmaco.idClinica == 0) { return(NotFound()); } else { return(Ok(farmaco)); } }
public IHttpActionResult PutFarmaco(FarmacoClinica farmaco) { if (!ModelState.IsValid) { return(BadRequest("Modelo de datos no válido")); } using (MySqlConnection conexion = ConexionBase.GetDBConnection()) { conexion.Open(); string update = "update farmacoprofilaxis set dosis='" + farmaco.dosis + "', frecuencia='" + farmaco.frecuencia + "' , fechaAplicacion='" + farmaco.fechaAplicacion + "' where idProfilaxis='" + farmaco.idClinica + "'and idFarmaco='" + farmaco.idFarmaco + "' ;"; MySqlCommand query = new MySqlCommand(update, conexion); MySqlDataReader reader; reader = query.ExecuteReader(); conexion.Close(); return(Ok()); } }
public IHttpActionResult PostNewHojaFarmaco(FarmacoClinica farmaco) { if (!ModelState.IsValid) { return(BadRequest("Modelo de datos no válido")); } using (MySqlConnection conexion = ConexionBase.GetDBConnection()) { conexion.Open(); string insert = "insert into farmacoprofilaxis (idProfilaxis, idFarmaco, dosis, frecuencia, fechaAplicacion) values (" + farmaco.idClinica + ", " + farmaco.idFarmaco + ", '" + farmaco.dosis + "', '" + farmaco.frecuencia + "', '" + farmaco.fechaAplicacion + "' );"; MySqlCommand query = new MySqlCommand(insert, conexion); MySqlDataReader reader; reader = query.ExecuteReader(); conexion.Close(); return(Ok()); } }