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