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