public object Create([FromBody] MovieWatch movieWatchEntry) { Database.Query("INSERT INTO MovieWatch (userID, movieID, rating) VALUES (@userID, @movieID, @rating)", new object[] { movieWatchEntry.userID, movieWatchEntry.movieID, movieWatchEntry.rating }); return(Database.Query("SELECT * FROM MovieWatch WHERE id = LAST_INSERT_ID()")); }
public object Delete([FromBody] MovieWatch movieWatchEntry) => Database.Query("DELETE FROM MovieWatch WHERE userID = @userID AND movieID = @movieID", new object[] { movieWatchEntry.userID, movieWatchEntry.movieID });
public object Update(int id, [FromBody] MovieWatch movieWatchEntry) => Database.Query("UPDATE MovieWatch SET rating = @rating WHERE id = @id", new object[] { movieWatchEntry.rating, id });