public HttpResponseMessage updatePedido(recetasModel receta) { try { using (SqlConnection conn = new SqlConnection(DatabaseConnectionString)) { SqlCommand cmd = new SqlCommand("UPDATE RECETAS SET Imagen=@imagen, idDoctor=@doctor WHERE idReceta=@id", conn); cmd.Parameters.AddWithValue("@id", receta.idReceta); cmd.Parameters.AddWithValue("@imagen", receta.Imagen); cmd.Parameters.AddWithValue("@doctor", receta.idDoctor); cmd.Connection = conn; conn.Open(); cmd.ExecuteReader(); var message = Request.CreateResponse(HttpStatusCode.Created, receta); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage regReceta([FromBody] recetasModel receta) { try { using (SqlConnection conn = new SqlConnection(DatabaseConnectionString)) { SqlCommand cmd = new SqlCommand("INSERT INTO RECETAS(idCliente,Imagen,Estado, idDoctor) OUTPUT INSERTED.idReceta VALUES (@cliente,@imagen,@estado,@doctor)", conn); cmd.Parameters.AddWithValue("@cliente", receta.idCliente); cmd.Parameters.AddWithValue("@imagen", receta.Imagen); cmd.Parameters.AddWithValue("@estado", 1); cmd.Parameters.AddWithValue("@doctor", receta.idDoctor); cmd.Connection = conn; conn.Open(); var message = Request.CreateResponse(HttpStatusCode.Created, serial.singleserialize(cmd.ExecuteReader())); conn.Close(); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }