public object Create([FromBody] Movie movie) { int tmdbID = movie.tmdbID; var tmdbData = JsonValue.Parse((string)Api.GetMovie(tmdbID)) as JsonObject; var title = (string)tmdbData["title"]; Database.Query("INSERT INTO Movie (title, tmdbID, tmdbData) VALUES (@title, @tmdbID, @tmdbData)", new object[] { title, tmdbID, tmdbData }); return(Database.Query("SELECT * FROM Movie WHERE id = LAST_INSERT_ID()")); }
public object Get(int id) => Api.GetMovie(id);