public static Dictionary <string, object> reply(int commentId, int atId, string content, int replyId)
{
MovieEntities movieEntities = new MovieEntities();
int userId = SessionService.getSession();
Feedback feedback = new Feedback();
feedback.comment_id = commentId;
feedback.user_id = userId;
feedback.at_id = atId;
feedback.reply_id = replyId;
feedback.content = content;
feedback.time = DateTime.Now;
movieEntities.Feedback.Add(feedback);
movieEntities.SaveChanges();
return(ClassToDictionary.classToDictionary(feedback));
}
public static int getRate(int movieId)
{
MovieEntities movieEntities = new MovieEntities();
int userId = SessionService.getSession();
Movie movie = movieEntities.Movie.Where(m => m.id == movieId).FirstOrDefault();
Rate rate = movieEntities.Rate.Where(r => r.movie_id == movieId && r.user_id == userId).FirstOrDefault();
if (rate == null)
{
return(ConstantValue.NoScore);
}
else
{
return(rate.score);
}
}
public static Dictionary <string, object> upload(int movieId, string title, string intro, string cover, string content)
{
int userId = SessionService.getSession();
MovieEntities movieEntities = new MovieEntities();
Comment comment = new Comment();
comment.movie_id = movieId;
comment.user_id = userId;
comment.title = title;
comment.intro = intro;
comment.cover = cover;
comment.content = content;
comment.likes = 0;
comment.comments = 0;
comment.time = DateTime.Now;
movieEntities.Comment.Add(comment);
movieEntities.SaveChanges();
return(ClassToDictionary.classToDictionary(comment));
}
public static Dictionary <string, object> rate(int movieId, int score)
{
MovieEntities movieEntities = new MovieEntities();
int userId = SessionService.getSession();
Movie movie = movieEntities.Movie.Where(m => m.id == movieId).FirstOrDefault();
Rate rate = movieEntities.Rate.Where(r => r.movie_id == movieId && r.user_id == userId).FirstOrDefault();
if (rate == null)
{
MovieService.updateMovieRate(movie, score);
movie.likes += 1;
Rate newRate = new Rate
{
movie_id = movieId,
user_id = userId,
score = score
};
movieEntities.Rate.Add(newRate);
}
else
{
MovieService.updateMovieRate(movie, rate, score);
if (score != rate.score)
{
rate.score = score;
}
}
movieEntities.SaveChanges();
Dictionary <string, object> results = new Dictionary <string, object>
{
{ ConstantValue.Rate, movie.rate },
{ ConstantValue.Likes, movie.likes }
};
return(results);
}
