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