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