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