public List <Movy> GetCatalog() { MovieEntities db = new MovieEntities(); List <Movy> Movies = db.Movies.ToList(); return(Movies); }
public List <Movy> GetMovie() { MovieEntities db = new MovieEntities(); List <Movy> movies = db.Movies.ToList(); return(movies); }
public static Genre GetByID(int id) { using (MovieEntities context = new MovieEntities()) { return(context.Genres.Where(x => x.ID == id).First()); } }
public static Dictionary <string, object> getUserInfo(int id) { MovieEntities movieEntities = new MovieEntities(); User user = movieEntities.User.Where(u => u.id == id).FirstOrDefault(); return(ClassToDictionary.classToDictionary(user)); }
public static Dictionary <string, object> Login(string email, string pwd) { MovieEntities movieEntities = new MovieEntities(); Dictionary <string, object> result = new Dictionary <string, object>(); User user = movieEntities.User.Where(u => u.email.Equals(email)).FirstOrDefault(); if (user == null) { result.Add("type", ConstantValue.UserNotExist); return(result); } else { if (user.password.Equals(pwd)) { result.Add("type", ConstantValue.LoginSucceed); result.Add("id", user.id); HttpContext.Current.Session["user"] = user.id; return(result); } else { result.Add("type", ConstantValue.WrongPwd); return(result); } } }
public static List <Genre> GetForMovie(int id) { using (MovieEntities context = new MovieEntities()) { return(context.Movies.Where(x => x.ID == id).First().Genres.ToList()); } }
public int createUser(RegisterRequestJSON req) { int userId = 0; using (MovieEntities db = new MovieEntities()) { string email_input = !string.IsNullOrWhiteSpace(req.email) ? req.email : null; string hashedpassword_input = !string.IsNullOrWhiteSpace(req.hashedpassword) ? req.hashedpassword : null; string salt_input = !string.IsNullOrWhiteSpace(req.salt) ? req.salt : null; string accesstoken_input = !string.IsNullOrWhiteSpace(req.socialMediaAccessToken) ? req.socialMediaAccessToken : null; string socialmediauserid_input = !string.IsNullOrWhiteSpace(req.socialMediaUserId) ? req.socialMediaUserId : null; string firstname_input = !string.IsNullOrWhiteSpace(req.firstName) ? req.firstName : null; string network_input = !string.IsNullOrWhiteSpace(req.network) ? req.network : null; ObjectParameter output_userId = new ObjectParameter("userId", typeof(Int32)); int userid = db.pr_RegisterUser(email_input, salt_input, hashedpassword_input, network_input, accesstoken_input, socialmediauserid_input, firstname_input, output_userId); if (output_userId.Value != null) { int ouserId = (int)output_userId.Value; if (ouserId != 0) { userId = ouserId; } } } return(userId); }
public static Dictionary <string, object> Register(string email, string pwd, string name) { MovieEntities movieEntities = new MovieEntities(); Dictionary <string, object> result = new Dictionary <string, object>(); User user = movieEntities.User.Where(u => u.email.Equals(email)).FirstOrDefault(); if (user == null) { user = new User { email = email, password = pwd, name = name }; movieEntities.User.Add(user); movieEntities.SaveChanges(); HttpContext.Current.Session["user"] = user.id; result.Add("type", ConstantValue.RegisterSucceed); result.Add("id", movieEntities.User.Where(u => u.email.Equals(email)).FirstOrDefault().id); return(result); } else { result.Add("type", ConstantValue.UserExist); return(result); } }
public static List <Dictionary <string, object> > list(int commentId) { MovieEntities movieEntities = new MovieEntities(); LinkedList <Dictionary <string, object> > result = new LinkedList <Dictionary <string, object> >(); var feedbacks = movieEntities.Feedback.Where(f => f.comment_id == commentId).Where(f => f.reply_id == 0); foreach (var fb in feedbacks) { User user = new MovieEntities().User.Where(u => u.id == fb.user_id).FirstOrDefault(); User at = fb.at_id == 0 ? null : new MovieEntities().User.Where(u => u.id == fb.at_id).FirstOrDefault(); var f = ClassToDictionary.classToDictionary(fb); f.Add("username", user.name); f.Add("at_username", at == null ? null : at.name); LinkedList <Dictionary <string, object> > replies = new LinkedList <Dictionary <string, object> >(); foreach (var subfb in new MovieEntities().Feedback.Where(sf => sf.reply_id == fb.id)) { var subf = ClassToDictionary.classToDictionary(subfb); subf.Add("username", new MovieEntities().User.Where(u => u.id == subfb.user_id).FirstOrDefault().name); subf.Add("at_username", new MovieEntities().User.Where(u => u.id == subfb.at_id).FirstOrDefault().name); replies.AddLast(subf); } f.Add("replies", replies); result.AddLast(f); } return(result.Reverse().ToList()); }
public static List <Genre> GetAll() { using (MovieEntities context = new MovieEntities()) { return(context.Genres.OrderBy(x => x.Name).ToList()); } }
public void InsertOrUpdateComment(int userId, int movieId, decimal score) { DateTime now = DateTime.UtcNow; using (var db = new MovieEntities()) { var target = db.UserCommentMovies.FirstOrDefault(m => m.UserId == userId && m.MovieId == movieId); if (target == null) { db.UserCommentMovies.Add(new UserCommentMovie { UserId = userId, MovieId = movieId, Score = score, AddTime = now, UpdateTime = now }); } else { target.Score = score; target.UpdateTime = now; } db.SaveChanges(); } }
public DataAccess.Movie GetMovie(int movieID) //取得指定的電影 { MovieEntities dbMovie = new MovieEntities(); DataAccess.Movie movie = dbMovie.Movie.FirstOrDefault(x => x.ID == movieID); return(movie); }
public List <MovieList> GetMovieList() { MovieEntities db = new MovieEntities(); List <MovieList> Movies = db.MovieLists.ToList(); return(Movies); }
public bool isAdmin(int userId) { bool isValid = false; using (MovieEntities db = new MovieEntities()) { var userrole = (from u in db.Users join ur in db.UserRoles on u.Users_ID equals ur.Users_ID join r in db.Roles on ur.Roles_ID equals r.Roles_ID where ur.Users_ID == userId select new { role = r.RoleName }).ToList(); foreach (var item in userrole) { if (item.role.ToLower() == "admin") { isValid = true; } } } return(isValid); }
public string updateAccessToken(int userId, string accessToken) { string status = ""; try { using (MovieEntities db = new MovieEntities()) { var query = db.UsersSessions.Where(x => x.Users_ID == userId).FirstOrDefault(); if (query != null) { query.token = accessToken; query.createdDate = DateTime.UtcNow; db.SaveChanges(); } else { var usersession = new UsersSession(); usersession.Users_ID = userId; usersession.token = accessToken; usersession.createdDate = DateTime.UtcNow; db.UsersSessions.Add(usersession); db.SaveChanges(); } } } catch { status = "There seems to be an issue with updating access token. Please try again."; } return(status); }
public static Dictionary <string, object> like(int commentId) { MovieEntities movieEntities = new MovieEntities(); int userId = SessionService.getSession(); Like like = movieEntities.Like.Where(m => m.user_id == userId && m.comment_id == commentId).FirstOrDefault(); Comment comment = movieEntities.Comment.Where(c => c.id == commentId).FirstOrDefault(); Dictionary <string, object> result = new Dictionary <string, object>(); if (like == null) { Like newLike = new Like(); newLike.user_id = userId; newLike.comment_id = commentId; movieEntities.Like.Add(newLike); comment.likes += 1; movieEntities.SaveChanges(); result.Add("like", true); result.Add("likes", comment.likes); } else { movieEntities.Like.Remove(like); comment.likes -= 1; movieEntities.SaveChanges(); result.Add("like", false); result.Add("likes", comment.likes); } return(result); }
/// <summary> /// 删除token /// </summary> /// <param name="UserId"></param> private static void DeleteToken(int UserId) { MovieEntities dc = new MovieEntities(); var list = dc.Tokens.Where(c => c.UserID == UserId).FirstOrDefault(); dc.Tokens.Remove(list); dc.SaveChanges(); }
public static List <Movie> GetAll() { using (MovieEntities context = new MovieEntities()) { var movies = context.Movies.Include(x => x.Genres).OrderBy(x => x.Title).ToList(); return(movies); } }
public static Movie GetByID(int id) { using (MovieEntities context = new MovieEntities()) { var movie = context.Movies.Include(x => x.Genres).Where(x => x.ID == id).First(); return(movie); } }
public bool CreateMovie(DataAccess.Movie movie) //新增電影 { MovieEntities dbMovie = new MovieEntities(); dbMovie.Movie.Add(movie); dbMovie.SaveChanges(); return(true); }
private static void LoadDataIntoDb(dynamic obj, int path) { try { MovieEntities db = new MovieEntities(); string imdbId = obj[0]["imdb_id"]; //if(!db.Movies.Select(m => m.ImdbID == imdbId).First()) if (db.Movies.Count() == 0 || !db.Movies.Select(m => m.ImdbID == imdbId).First()) { Int64 existingMovieId = 0; if (db.Movies.Count() > 0) { existingMovieId = db.Movies.Count(); } Movie movie = new Movie(); movie.ID = existingMovieId + 1; movie.PlotDetailed = obj[0]["plot"]; movie.ImdbID = obj[0]["imdb_id"]; movie.PlotSimple = obj[0]["plot_simple"]; var tempruntime = obj[0]["runtime"]; movie.Runtime = ConvertRuntime(tempruntime.ToString()); movie.Rated = obj[0]["rated"]; movie.ImdbUrl = obj[0]["imdb_url"]; movie.AKA = obj[0]["also_known_as"][0]; movie.IMDBRating = obj[0]["rating"]; Int64 releaseDate = obj[0]["release_date"]; DateTime dtTime = new DateTime(Int32.Parse(releaseDate.ToString().Substring(0, 4)), Int32.Parse(releaseDate.ToString().Substring(4, 2)), Int32.Parse(releaseDate.ToString().Substring(6, 2))); movie.ReleaseDate = dtTime; movie.Title = obj[0]["title"]; Genres(obj, db); db.Movies.Add(movie); db.SaveChanges(); var savedMovie = db.Movies.Where(m => m.ImdbID == movie.ImdbID).Distinct(); MoviePersonRole(obj, db); var ListOfGenre = obj[0]["genres"]; Poster poster = new Poster(); poster.imdb = obj[0]["poster"]["imdb"]; poster.cover = obj[0]["poster"]["cover"]; PosterInfo posterInfo = new PosterInfo(); posterInfo.Imdb = poster.imdb; posterInfo.Cover = poster.cover; posterInfo.MovieId = savedMovie.First().ID; db.PosterInfoes.Add(posterInfo); db.SaveChanges(); } } catch (Exception ex) { string inputfolder = "C:\\Users\\PrashMaya\\My Documents\\Exceptions\\Movie{0}.txt"; string inputfile = String.Format(inputfolder, path); System.IO.File.WriteAllText(inputfile, ex.ToString()); Console.WriteLine(ex.Message); } }
[HttpGet] //Ques. #3 public Movie GetRandomMovie() { MovieEntities ORM = new MovieEntities(); Random r = new Random(); List <Movie> MovieList = ORM.Movies.ToList(); return(MovieList[r.Next(0, MovieList.Count)]); }
public Movie ListRandomMovie() { MovieEntities ORM = new MovieEntities(); Random rand = new Random(); return(ORM.Movies.ToList()[rand.Next(ORM.Movies.Count())]); }
public List <MovieList> GetMovieByGenre(string genre) { MovieEntities db = new MovieEntities(); List <MovieList> MovieGenre = (from m in db.MovieLists where m.Genre.Contains(genre) select m).ToList(); return(MovieGenre); }
public List <MovieList> GetMovieByLeadActor(string actor) { MovieEntities db = new MovieEntities(); List <MovieList> LeadActor = (from m in db.MovieLists where m.LeadActor.Contains(actor) select m).ToList(); return(LeadActor); }
public static void Delete(int id) { using (MovieEntities context = new MovieEntities()) { var movie = context.Movies.Where(x => x.ID == id).First(); context.Movies.Remove(movie); context.SaveChanges(); } }
public List <Movy> GetMovieByCategory(string id) { MovieEntities db = new MovieEntities(); List <Movy> Category = (from m in db.Movies where m.Category.Contains(id) select m).ToList(); return(Category); }
public bool isValidUserId(int userId) { using (MovieEntities db = new MovieEntities()) { var count = (from u in db.Users where u.Users_ID == userId select u).Count(); return(count > 0 ? true: false); } }
private static void AddSampleRoleData() { Role role = new Role(); role.Description = "Director"; MovieEntities db = new MovieEntities(); db.Roles.Add(role); db.SaveChanges(); }
public static LinkedList <Dictionary <string, object> > fuzzySearch(string param) { LinkedList <Dictionary <string, object> > result = new LinkedList <Dictionary <string, object> >(); var movies = new MovieEntities().Movie.Where(m => m.name.Contains(param) || m.genres.Contains(param) || m.regions.Contains(param) || m.directors.Contains(param) || m.stars.Contains(param)); foreach (var movie in movies) { result.AddLast(ClassToDictionary.movieToDictionary(movie)); } return(result); }