private static MoviePersonalNote GetNote(MovieDbEntities db, User loggedInUser, Movie rowMovie)
{
try
{
var user = db.Users.Where(o => o.Username == loggedInUser.Username).FirstOrDefault();
var movie = db.Movies.Where(o => o.ImdbId == rowMovie.ImdbId).FirstOrDefault();
if (movie == null)
{
rowMovie.IsUpdated = false;
db.AddToMovies(rowMovie);
movie = rowMovie;
}
var personalNote =
db.MoviePersonalNotes.Where(o => o.User.Id == loggedInUser.Id && o.Movie.Id == movie.Id).
FirstOrDefault();
if (personalNote == null)
{
personalNote = new MoviePersonalNote {
Comment = "", Movie = movie, User = user
};
db.AddToMoviePersonalNotes(personalNote);
}
return(personalNote);
}
catch (Exception exp)
{
Logger.Exception(exp, 550);
return(null);
}
}
