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