private static void ImportCountries(JToken countryObj) { var context = new MoviesContext(); var country = new Country(); country.Name = countryObj["name"].Value<string>(); context.Countries.Add(country); context.SaveChanges(); }
private static void ImportMovies(JToken movieObj) { var context = new MoviesContext(); var movie = new Movie(); movie.Isbn = movieObj["isbn"].Value<string>(); movie.Title = movieObj["title"].Value<string>(); movie.AgeRestriction = (AgeRestriction)Enum.Parse(typeof(AgeRestriction), movieObj["ageRestriction"].ToString()); context.Movies.Add(movie); context.SaveChanges(); }
private static void ImportMovieRatings(JToken elementObj) { var context = new MoviesContext(); string userName = elementObj["user"].Value<string>(); string movie = elementObj["movie"].Value<string>(); int stars = int.Parse(elementObj["rating"].ToString()); context.Ratings.Add(new Rating() { Stars = stars, MovieId = context.Movies.FirstOrDefault(m => m.Isbn == movie).Id, UserId = context.Users.FirstOrDefault(u => u.UserName == userName).Id }); context.SaveChanges(); }
private static void ImportFavouriteMovies(JToken favouriteMovieObj) { var context = new MoviesContext(); string userName = favouriteMovieObj["username"].Value<string>(); var dbUser = context.Users.FirstOrDefault(u => u.UserName == userName); Console.WriteLine("User {0} movies imported: ", favouriteMovieObj["username"].Value<string>()); var moviesIsbn = JArray.Parse(favouriteMovieObj["favouriteMovies"].ToString()); foreach (var movie in moviesIsbn) { string currMovie = movie.ToString(); Movie newMovie = context.Movies.FirstOrDefault(m => m.Isbn == currMovie); dbUser.Movies.Add(newMovie); Console.WriteLine(newMovie.Title); } context.SaveChanges(); }
private static void ImportUsers(JToken userObj) { var context = new MoviesContext(); var user = new User(); user.UserName = userObj["username"].Value<string>(); if (userObj["age"].Type != JTokenType.Null) { user.Age = userObj["age"].Value<int>(); } if (userObj["email"].Type != JTokenType.Null) { user.Email = userObj["email"].Value<string>(); } if (userObj["country"].Type != JTokenType.Null) { var countryName = userObj["country"].Value<string>(); user.Country = context.Countries.FirstOrDefault(c => c.Name == countryName); } context.Users.Add(user); context.SaveChanges(); }