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