void LoadPersonalNote(MoviePersonalNote note)
        {
            if (note == null)
            {
                rsUserRating.Rating = 0;

                pbDislike.Image = Properties.Resources.hate_it_dis;
                pbHaveIt.Image = Properties.Resources.have_it_dis;
                pbLike.Image = Properties.Resources.like_it_dis;
                pbSeenIt.Image = Properties.Resources.seen_it_dis;
                pbWanted.Image = Properties.Resources.check_list_dis;
            }
            else
            {
                _controller_OnDebugTextFired(this, new TextEventArgs("note=" + note.Movie.Title + "\r\n"));

                rsUserRating.Rating = note.Rating;

                pbDislike.Image = note.Favourite < 0 ? Properties.Resources.hate_it : Properties.Resources.hate_it_dis;
                pbLike.Image = note.Favourite > 0 ? Properties.Resources.like_it : Properties.Resources.like_it_dis;
                pbHaveIt.Image = note.Have ? Properties.Resources.have_it : Properties.Resources.have_it_dis;
                pbSeenIt.Image = note.Seen ? Properties.Resources.seen_it : Properties.Resources.seen_it_dis;
                pbWanted.Image = note.Wishlist ? Properties.Resources.check_list : Properties.Resources.check_list_dis;
            }
        }
        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;
            }
        }