// [EnableCors(origins: "http://localhost:64155/", headers: "*", methods: "*")]
public IHttpActionResult GetFarmacoById(int id)
{
FarmacoViewModel farmaco = null;
using (MySqlConnection conexion = ConexionBase.GetDBConnection())
{
conexion.Open();
MySqlCommand query = new MySqlCommand(" select id, nombre, via from farmacos where id=" + id.ToString(), conexion);
using (var reader = query.ExecuteReader())
{
reader.Read();
farmaco = new FarmacoViewModel()
{
id = Convert.ToInt32(reader["id"].ToString()),
nombre = reader["nombre"].ToString(),
via = reader["via"].ToString()
};
}
if (farmaco == null)
{
return(NotFound());
}
else
{
return(Ok(farmaco));
}
}
}
// [EnableCors(origins: "http://localhost:64155/", headers: "*", methods: "*")]
public IHttpActionResult PutFarmaco(FarmacoViewModel farmaco)
{
if (!ModelState.IsValid)
{
return(BadRequest("Modelo de datos invalido"));
}
using (MySqlConnection conexion = ConexionBase.GetDBConnection())
{
conexion.Open();
string update = "update farmacos set nombre='" + farmaco.nombre + "', via='" + farmaco.via + "' where id='" + farmaco.id + "'; ";
MySqlCommand query = new MySqlCommand(update, conexion);
MySqlDataReader reader;
reader = query.ExecuteReader();
return(Ok());
}
}
// [EnableCors(origins: "http://localhost:64155/", headers:"*", methods:"*")]
public IHttpActionResult PostNewFarmaco(FarmacoViewModel farmaco)
{
if (!ModelState.IsValid)
{
return(BadRequest("Datos invalidos"));
}
using (MySqlConnection conexion = ConexionBase.GetDBConnection())
{
conexion.Open();
string insert = "insert into farmacos (id, nombre,via ) values ('" + farmaco.id + "', '" + farmaco.nombre + "', '" + farmaco.via + "' );";
MySqlCommand query = new MySqlCommand(insert, conexion);
MySqlDataReader myReader;
myReader = query.ExecuteReader();
conexion.Close();
return(Ok());
}
}
