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 bool AddNewSimilarMovie(movie_relation temp)
{
try
{
db.movie_relation.Add(temp);
db.SaveChanges();
return(true);
}
catch
{
db.movie_relation.Remove(temp);
return(false);
}
}
