public async Task <int> AddTrivia(Trivia trivia) { var movieFromDB = ( from m in _context.Movies where m.Title == trivia.MovieTitle select m ).FirstOrDefault(); var triviasFromDB = ( from t in _context.Trivias where t.Content == trivia.Content && t.MovieTitle == trivia.MovieTitle select t ).FirstOrDefault(); if (triviasFromDB != null) { return(0); } if (movieFromDB == null) { await AddMovie(trivia.MovieTitle); return(await AddTrivia(trivia)); } else { _context.Trivias.Add(trivia); return(await _context.SaveChangesAsync()); } }
public async Task <int> RemoveTrivia(Trivia trivia) { _context.Trivias.Remove( _context.Trivias.SingleOrDefault(t => t.ID == trivia.ID) ); return(await _context.SaveChangesAsync()); }