private static void SeedCountries(string jsonCountries, MoviesModel context) { var countries = JArray.Parse(jsonCountries); foreach (JToken country in countries) { Country dbCountry = new Country() { Name = country["name"].ToString() }; context.Countries.Add(dbCountry); } context.SaveChanges(); }
private static void SeedFavouriteMovies(string jsonFavouriteMovies, MoviesModel context) { var userMovies = JArray.Parse(jsonFavouriteMovies); foreach (JToken userMovie in userMovies) { string user = userMovie["username"].ToString(); var dbUser = context.Users.FirstOrDefault(u => u.Username == user); foreach (var favourite in userMovie["favouriteMovies"]) { string fv = favourite.ToString(); var dbMovie = context.Movies.FirstOrDefault(m => m.Isbn == fv); dbUser.Movies.Add(dbMovie); } } context.SaveChanges(); }
private static void SeedMovies(string jsonMovies, MoviesModel context) { var movies = JArray.Parse(jsonMovies); foreach (JToken movie in movies) { AgeRestriction movieRestriction; if (movie["ageRestriction"].ToString() == "0") { movieRestriction = AgeRestriction.Child; } else if (movie["ageRestriction"].ToString() == "1") { movieRestriction = AgeRestriction.Teen; } else { movieRestriction = AgeRestriction.Adult; } Movie dbMovie = new Movie() { Title = movie["title"].ToString(), Isbn = movie["isbn"].ToString(), AgeRestriction = movieRestriction, }; context.Movies.Add(dbMovie); } context.SaveChanges(); }
private static void SeedUsers(string jsonUsers, MoviesModel context) { var users = JArray.Parse(jsonUsers); foreach (JToken user in users) { string age = null; if (user["age"] != null) { age = user["age"].ToString(); } User dbUser = new User() { Username = user["username"].ToString(), Age = age, Email = user["email"].ToString() }; context.Users.Add(dbUser); } context.SaveChanges(); }
private static void SeedRatings(string jsonRatings, MoviesModel context) { var ratings = JArray.Parse(jsonRatings); foreach (JToken rating in ratings) { string isbn = rating["movie"].ToString(); string user = rating["user"].ToString(); int movieId = context.Movies.FirstOrDefault(m => m.Isbn == isbn).Id; int userId = context.Users.FirstOrDefault(u => u.Username == user).Id; Rating dbRating = new Rating() { MovieId = movieId, UserId = userId, Stars = int.Parse(rating["rating"].ToString()) }; context.Ratings.Add(dbRating); } context.SaveChanges(); }