public bool AddNewSimilarMovie(movie_relation temp)
        {
            try
            {
                db.movie_relation.Add(temp);
                db.SaveChanges();

                return true;
            }
            catch
            {
                db.movie_relation.Remove(temp);

                return false;
            }
        }
        public movie_relation getMovieRelationByMoviesIds(int firstMovieId, int secondMovieId)
        {
            IQueryable<movie_relation> temp = from a in db.movie_relation
                                              where
                                                (a.movie_1_id == firstMovieId && a.movie_2_id == secondMovieId)
                                                    ||
                                                (a.movie_1_id == secondMovieId && a.movie_2_id == firstMovieId)
                                              select a;

            movie_relation movieRelation = new movie_relation();
            movieRelation = temp.FirstOrDefault();

            return movieRelation;
        }
        public ActionResult addSimilarMovie(AddSimilarMovieModel newSimilar)
        {
            movie_relation temp = new movie_relation();

            int secondMovieId = dbMovie.getMovieByTitle(newSimilar.secondMovieTitle.ToLower().Trim()).id;

            temp.movie_1_id = newSimilar.firstMovieId;
            temp.movie_2_id = secondMovieId;
            temp.auto_created = false;

            dbMovie.AddNewSimilarMovie(temp);

            users_vote tempVote = new users_vote();

            tempVote.vote = true;
            tempVote.user_id = newSimilar.userId;
            tempVote.movie_relation = dbMovie.getMovieRelationByMoviesIds(newSimilar.firstMovieId, secondMovieId);

            dbUser.addVote(tempVote);

            return RedirectToAction("Show", "Movie", new{ id = newSimilar.firstMovieId});
        }