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 });
