Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- namespace db
- {
- public class DatabaseSeed
- {
- public static async void AddStuff()
- {
- DbService db = new DbService();
- User iomc = db.GetUserByUsername("iomc");
- User hasc = db.GetUserByUsername("hasc");
- User inru = db.GetUserByUsername("inru");
- User rakr = db.GetUserByUsername("rakr");
- User doje = db.GetUserByUsername("doje");
- User gaga = db.GetUserByUsername("gaga");
- User qutr = db.GetUserByUsername("qutr");
- User jada = db.GetUserByUsername("jada");
- iomc.SeenEpisodes = new List<Episode>();
- iomc.RatedMovies = new List<RatedMovie>();
- iomc.FollowedSeries = new List<Series>();
- hasc.SeenEpisodes = new List<Episode>();
- hasc.RatedMovies = new List<RatedMovie>();
- hasc.FollowedSeries = new List<Series>();
- inru.SeenEpisodes = new List<Episode>();
- inru.RatedMovies = new List<RatedMovie>();
- inru.SeenEpisodes = new List<Episode>();
- rakr.SeenEpisodes = new List<Episode>();
- rakr.RatedMovies = new List<RatedMovie>();
- rakr.FollowedSeries = new List<Series>();
- doje.SeenEpisodes = new List<Episode>();
- doje.RatedMovies = new List<RatedMovie>();
- doje.FollowedSeries = new List<Series>();
- gaga.SeenEpisodes = new List<Episode>();
- gaga.RatedMovies = new List<RatedMovie>();
- gaga.FollowedSeries = new List<Series>();
- qutr.SeenEpisodes = new List<Episode>();
- qutr.RatedMovies = new List<RatedMovie>();
- qutr.FollowedSeries = new List<Series>();
- jada.SeenEpisodes = new List<Episode>();
- jada.RatedMovies = new List<RatedMovie>();
- jada.FollowedSeries = new List<Series>();
- Genre romance = db.GetGenreByName("Romance");
- Genre comedy = db.GetGenreByName("Comedy");
- Genre horror = db.GetGenreByName("Horror");
- Genre thriller = db.GetGenreByName("Thriller");
- Genre action = db.GetGenreByName("Action");
- Genre adventure = db.GetGenreByName("Adventure");
- Genre drama = db.GetGenreByName("Drama");
- Genre scifi = db.GetGenreByName("Sci-Fi");
- Genre animation = db.GetGenreByName("Animation");
- Genre crime = db.GetGenreByName("crime");
- Genre fantasy = db.GetGenreByName("fantasy");
- romance.Movies = new List<Movie>();
- romance.Series = new List<Series>();
- comedy.Movies = new List<Movie>();
- comedy.Series = new List<Series>();
- horror.Movies = new List<Movie>();
- horror.Series = new List<Series>();
- thriller.Movies = new List<Movie>();
- thriller.Series = new List<Series>();
- action.Movies = new List<Movie>();
- action.Series = new List<Series>();
- adventure.Movies = new List<Movie>();
- adventure.Series = new List<Series>();
- drama.Movies = new List<Movie>();
- drama.Series = new List<Series>();
- scifi.Movies = new List<Movie>();
- scifi.Series = new List<Series>();
- animation.Movies = new List<Movie>();
- animation.Series = new List<Series>();
- crime.Movies = new List<Movie>();
- crime.Series = new List<Series>();
- fantasy.Movies = new List<Movie>();
- fantasy.Series = new List<Series>();
- StreamingService netflix = db.GetStreamingServiceByName("Netflix");
- StreamingService hbo = db.GetStreamingServiceByName("HBO");
- StreamingService amazonVideo = db.GetStreamingServiceByName("Amazon Video");
- StreamingService hulu = db.GetStreamingServiceByName("Hulu");
- StreamingService googlePlay = db.GetStreamingServiceByName("Google Play");
- netflix.Movies = new List<Movie>();
- netflix.Series = new List<Series>();
- hbo.Movies = new List<Movie>();
- hbo.Series = new List<Series>();
- amazonVideo.Movies = new List<Movie>();
- amazonVideo.Series = new List<Series>();
- hulu.Movies = new List<Movie>();
- hulu.Series = new List<Series>();
- googlePlay.Movies = new List<Movie>();
- googlePlay.Series = new List<Series>();
- Movie americanPie = db.GetMovieByName("American Pie");
- Movie roadTrip = db.GetMovieByName("Road Trip");
- Movie up = db.GetMovieByName("Up");
- Movie theDayAfterTomorrow = db.GetMovieByName("The Day After Tomorrow");
- Movie theMartian = db.GetMovieByName("The Martian");
- Movie gravity = db.GetMovieByName("Gravity");
- Movie napoleonDynamite = db.GetMovieByName("Napoleon Dynamite");
- Movie dawnOfTheDead = db.GetMovieByName("Dawn of the Dead");
- americanPie.Genres = new List<Genre>();
- americanPie.StreamingServices = new List<StreamingService>();
- americanPie.Ratings = new List<RatedMovie>();
- roadTrip.Genres = new List<Genre>();
- roadTrip.StreamingServices = new List<StreamingService>();
- roadTrip.Ratings = new List<RatedMovie>();
- up.Genres = new List<Genre>();
- up.StreamingServices = new List<StreamingService>();
- up.Ratings = new List<RatedMovie>();
- theDayAfterTomorrow.Genres = new List<Genre>();
- theDayAfterTomorrow.StreamingServices = new List<StreamingService>();
- theDayAfterTomorrow.Ratings = new List<RatedMovie>();
- theMartian.Genres = new List<Genre>();
- theMartian.StreamingServices = new List<StreamingService>();
- theMartian.Ratings = new List<RatedMovie>();
- gravity.Genres = new List<Genre>();
- gravity.StreamingServices = new List<StreamingService>();
- gravity.Ratings = new List<RatedMovie>();
- napoleonDynamite.Genres = new List<Genre>();
- napoleonDynamite.StreamingServices = new List<StreamingService>();
- napoleonDynamite.Ratings = new List<RatedMovie>();
- dawnOfTheDead.Genres = new List<Genre>();
- dawnOfTheDead.StreamingServices = new List<StreamingService>();
- dawnOfTheDead.Ratings = new List<RatedMovie>();
- Series theWalkingDead = db.GetSeriesByName("The Walking Dead");
- Series breakingBad = db.GetSeriesByName("Breaking Bad");
- Series prisonBreak = db.GetSeriesByName("Prison Break");
- Series theOC = db.GetSeriesByName("The O.C.");
- Series supernatural = db.GetSeriesByName("Supernatural");
- theWalkingDead.StreamingServices = new List<StreamingService>();
- theWalkingDead.Seasons = new List<Season>();
- theWalkingDead.Ratings = new List<int>();
- theWalkingDead.Genres = new List<Genre>();
- breakingBad.StreamingServices = new List<StreamingService>();
- breakingBad.Seasons = new List<Season>();
- breakingBad.Ratings = new List<int>();
- breakingBad.Genres = new List<Genre>();
- prisonBreak.StreamingServices = new List<StreamingService>();
- prisonBreak.Seasons = new List<Season>();
- prisonBreak.Ratings = new List<int>();
- prisonBreak.Genres = new List<Genre>();
- theOC.StreamingServices = new List<StreamingService>();
- theOC.Seasons = new List<Season>();
- theOC.Ratings = new List<int>();
- theOC.Genres = new List<Genre>();
- supernatural.StreamingServices = new List<StreamingService>();
- supernatural.Seasons = new List<Season>();
- supernatural.Ratings = new List<int>();
- supernatural.Genres = new List<Genre>();
- Season twk1 = db.GetSeasonByName("The Walking Dead Season 1");
- Season twk2 = db.GetSeasonByName("The Walking Dead Season 2");
- Season bb1 = db.GetSeasonByName("Breaking Bad Season 1");
- Season bb2 = db.GetSeasonByName("Breaking Bad Season 2");
- Season pb1 = db.GetSeasonByName("Prison Break Season 1");
- Season pb2 = db.GetSeasonByName("Prison Break Season 2");
- Season pb3 = db.GetSeasonByName("Prison Break Season 3");
- Season to1 = db.GetSeasonByName("The O.C. Season 1");
- Season to2 = db.GetSeasonByName("The O.C. Season 2");
- Season sn1 = db.GetSeasonByName("Supernatural Season 1");
- Season sn2 = db.GetSeasonByName("Supernatural Season 2");
- twk1.Episodes = new List<Episode>();
- twk2.Episodes = new List<Episode>();
- bb1.Episodes = new List<Episode>();
- bb2.Episodes = new List<Episode>();
- pb1.Episodes = new List<Episode>();
- pb2.Episodes = new List<Episode>();
- pb3.Episodes = new List<Episode>();
- to1.Episodes = new List<Episode>();
- to2.Episodes = new List<Episode>();
- sn1.Episodes = new List<Episode>();
- sn2.Episodes = new List<Episode>();
- Episode twk11 = db.GetEpisodeByName("twk11");
- Episode twk12 = db.GetEpisodeByName("twk12");
- Episode twk13 = db.GetEpisodeByName("twk13");
- Episode twk21 = db.GetEpisodeByName("twk21");
- Episode twk22 = db.GetEpisodeByName("twk22");
- Episode bb11 = db.GetEpisodeByName("bb11");
- Episode bb12 = db.GetEpisodeByName("bb12");
- Episode bb21 = db.GetEpisodeByName("bb21");
- Episode bb22 = db.GetEpisodeByName("bb22");
- Episode pb11 = db.GetEpisodeByName("pb11");
- Episode pb12 = db.GetEpisodeByName("pb12");
- Episode pb21 = db.GetEpisodeByName("pb21");
- Episode pb22 = db.GetEpisodeByName("pb22");
- Episode pb31 = db.GetEpisodeByName("pb31");
- Episode pb32 = db.GetEpisodeByName("pb32");
- Episode to11 = db.GetEpisodeByName("to11");
- Episode to12 = db.GetEpisodeByName("to12");
- Episode to21 = db.GetEpisodeByName("to21");
- Episode to22 = db.GetEpisodeByName("to22");
- Episode sn11 = db.GetEpisodeByName("sn11");
- Episode sn12 = db.GetEpisodeByName("sn12");
- Episode sn21 = db.GetEpisodeByName("sn21");
- Episode sn22 = db.GetEpisodeByName("sn22");
- Episode sn23 = db.GetEpisodeByName("sn23");
- americanPie.Genres.Add(comedy);
- roadTrip.Genres.Add(adventure);
- roadTrip.Genres.Add(comedy);
- up.Genres.Add(animation);
- up.Genres.Add(comedy);
- up.Genres.Add(adventure);
- theDayAfterTomorrow.Genres.Add(action);
- theDayAfterTomorrow.Genres.Add(adventure);
- theDayAfterTomorrow.Genres.Add(scifi);
- theMartian.Genres.Add(adventure);
- theMartian.Genres.Add(drama);
- theMartian.Genres.Add(scifi);
- gravity.Genres.Add(drama);
- gravity.Genres.Add(scifi);
- gravity.Genres.Add(thriller);
- napoleonDynamite.Genres.Add(comedy);
- dawnOfTheDead.Genres.Add(action);
- dawnOfTheDead.Genres.Add(horror);
- dawnOfTheDead.Genres.Add(thriller);
- // ADD GENRES TO SERIES
- theWalkingDead.Genres.Add(drama);
- theWalkingDead.Genres.Add(horror);
- theWalkingDead.Genres.Add(thriller);
- breakingBad.Genres.Add(crime);
- breakingBad.Genres.Add(drama);
- breakingBad.Genres.Add(thriller);
- prisonBreak.Genres.Add(action);
- prisonBreak.Genres.Add(crime);
- prisonBreak.Genres.Add(drama);
- theOC.Genres.Add(comedy);
- theOC.Genres.Add(drama);
- theOC.Genres.Add(romance);
- supernatural.Genres.Add(drama);
- supernatural.Genres.Add(fantasy);
- supernatural.Genres.Add(horror);
- // ADD EPISODES TO SEASONS
- twk1.Episodes.Add(twk11);
- twk1.Episodes.Add(twk11);
- twk1.Episodes.Add(twk13);
- twk2.Episodes.Add(twk21);
- twk2.Episodes.Add(twk22);
- bb1.Episodes.Add(bb11);
- bb1.Episodes.Add(bb12);
- bb2.Episodes.Add(bb21);
- bb2.Episodes.Add(bb22);
- pb1.Episodes.Add(pb11);
- pb1.Episodes.Add(pb12);
- pb2.Episodes.Add(pb21);
- pb2.Episodes.Add(pb22);
- pb3.Episodes.Add(pb31);
- pb3.Episodes.Add(pb32);
- to1.Episodes.Add(to11);
- to1.Episodes.Add(to12);
- to2.Episodes.Add(to21);
- to2.Episodes.Add(to22);
- sn1.Episodes.Add(sn11);
- sn1.Episodes.Add(sn12);
- sn2.Episodes.Add(sn21);
- sn2.Episodes.Add(sn22);
- sn2.Episodes.Add(sn23);
- // ADD SEASONS TO SERIES
- theWalkingDead.Seasons.Add(twk1);
- theWalkingDead.Seasons.Add(twk2);
- breakingBad.Seasons.Add(bb1);
- breakingBad.Seasons.Add(bb2);
- prisonBreak.Seasons.Add(pb1);
- prisonBreak.Seasons.Add(pb2);
- prisonBreak.Seasons.Add(pb3);
- theOC.Seasons.Add(to1);
- theOC.Seasons.Add(to2);
- supernatural.Seasons.Add(sn1);
- supernatural.Seasons.Add(sn2);
- // ADD STREAMINGSERVICES TO MOVIES
- americanPie.StreamingServices.Add(netflix);
- americanPie.StreamingServices.Add(hbo);
- americanPie.StreamingServices.Add(amazonVideo);
- americanPie.StreamingServices.Add(hulu);
- americanPie.StreamingServices.Add(googlePlay);
- roadTrip.StreamingServices.Add(netflix);
- roadTrip.StreamingServices.Add(hbo);
- roadTrip.StreamingServices.Add(amazonVideo);
- roadTrip.StreamingServices.Add(hulu);
- roadTrip.StreamingServices.Add(googlePlay);
- up.StreamingServices.Add(amazonVideo);
- theDayAfterTomorrow.StreamingServices.Add(netflix);
- theMartian.StreamingServices.Add(netflix);
- theMartian.StreamingServices.Add(hbo);
- theMartian.StreamingServices.Add(amazonVideo);
- gravity.StreamingServices.Add(netflix);
- gravity.StreamingServices.Add(hbo);
- napoleonDynamite.StreamingServices.Add(netflix);
- napoleonDynamite.StreamingServices.Add(hbo);
- dawnOfTheDead.StreamingServices.Add(netflix);
- // ADD STREAMINGSERVICES TO SERIES
- theWalkingDead.StreamingServices.Add(hbo);
- breakingBad.StreamingServices.Add(netflix);
- breakingBad.StreamingServices.Add(hulu);
- prisonBreak.StreamingServices.Add(netflix);
- prisonBreak.StreamingServices.Add(googlePlay);
- theOC.StreamingServices.Add(netflix);
- theOC.StreamingServices.Add(amazonVideo);
- supernatural.StreamingServices.Add(googlePlay);
- supernatural.StreamingServices.Add(hulu);
- db.SaveChanges();
- /*// SEED USERS
- User iomc = await db.AddUser(new User("iomc", "Iolanthe", "McIlharga"));
- User hasc = await db.AddUser(new User("hasc", "Hatti", "Scarman"));
- User inru = await db.AddUser(new User("inru", "Inge", "Rudyard"));
- User rakr = await db.AddUser(new User("rakr", "Ranice", "Krimmer"));
- User doje = await db.AddUser(new User("doje", "Doralyn", "Jeal"));
- User gaga = await db.AddUser(new User("gaga", "Gaven", "Garnar"));
- User qutr = await db.AddUser(new User("qutr", "Quentin", "Tregunnah"));
- User jada = await db.AddUser(new User("jada", "Jacqueline", "Dannehl"));
- // SEED GENRES
- Genre romance = await db.AddGenre(new Genre("Romance"));
- Genre comedy = await db.AddGenre(new Genre("Comedy"));
- Genre horror = await db.AddGenre(new Genre("Horror"));
- Genre thriller = await db.AddGenre(new Genre("Thriller"));
- Genre action = await db.AddGenre(new Genre("Action"));
- Genre adventure = await db.AddGenre(new Genre("Adventure"));
- Genre drama = await db.AddGenre(new Genre("Drama"));
- Genre scifi = await db.AddGenre(new Genre("Sci-Fi"));
- Genre animation = await db.AddGenre(new Genre("Animation"));
- Genre crime = await db.AddGenre(new Genre("crime"));
- Genre fantasy = await db.AddGenre(new Genre("fantasy"));
- // SEED STREAMINGSERVICES
- StreamingService netflix = await db.AddStreamingService(new StreamingService("Netflix"));
- StreamingService hbo = await db.AddStreamingService(new StreamingService("HBO"));
- StreamingService amazonVideo = await db.AddStreamingService(new StreamingService("Amazon Video"));
- StreamingService hulu = await db.AddStreamingService(new StreamingService("Hulu"));
- StreamingService googlePlay = await db.AddStreamingService(new StreamingService("Google Play"));
- // SEED MOVIES
- Movie americanPie = await db.AddMovie(new Movie("American Pie", "Chris Weitz", DateTime.Now, DateTime.Now.AddDays(30)));
- Movie roadTrip = await db.AddMovie(new Movie("Road Trip", "Todd Philips", DateTime.Now, DateTime.Now.AddDays(30)));
- Movie up = await db.AddMovie(new Movie("Up", "Pete Doctor", DateTime.Now, DateTime.Now.AddDays(30)));
- Movie theDayAfterTomorrow = await db.AddMovie(new Movie("The Day After Tomorrow", "Roland Emmerich", DateTime.Now, DateTime.Now.AddDays(30)));
- Movie theMartian = await db.AddMovie(new Movie("The Martian", "Ridley Scott", DateTime.Now, DateTime.Now.AddDays(30)));
- Movie gravity = await db.AddMovie(new Movie("Gravity", "Alfonso Cuarón", DateTime.Now, DateTime.Now.AddDays(30)));
- Movie napoleonDynamite = await db.AddMovie(new Movie("Napoleon Dynamite", "Jared Hess", DateTime.Now, DateTime.Now.AddDays(30)));
- Movie dawnOfTheDead = await db.AddMovie(new Movie("Dawn of the Dead", "Zack Snyder", DateTime.Now, DateTime.Now.AddDays(30)));
- // SEED SERIES
- Series theWalkingDead = await db.AddSeries(new Series("The Walking Dead", "Frank Darabont", DateTime.Now, DateTime.Now.AddDays(30)));
- Series breakingBad = await db.AddSeries(new Series("Breaking Bad", "Vince Gilligan", DateTime.Now, DateTime.Now.AddDays(30)));
- Series prisonBreak = await db.AddSeries(new Series("Prison Break", "Paul Scheuring", DateTime.Now, DateTime.Now.AddDays(30)));
- Series theOC = await db.AddSeries(new Series("The O.C.", "Josh Schwartz", DateTime.Now, DateTime.Now.AddDays(30)));
- Series supernatural = await db.AddSeries(new Series("Supernatural", "Eric Kripke", DateTime.Now, DateTime.Now.AddDays(30)));
- // SEED SEASONS
- Season twk1 = await db.AddSeason(new Season());
- Season twk2 = await db.AddSeason(new Season());
- Season bb1 = await db.AddSeason(new Season());
- Season bb2 = await db.AddSeason(new Season());
- Season pb1 = await db.AddSeason(new Season());
- Season pb2 = await db.AddSeason(new Season());
- Season pb3 = await db.AddSeason(new Season());
- Season to1 = await db.AddSeason(new Season());
- Season to2 = await db.AddSeason(new Season());
- Season sn1 = await db.AddSeason(new Season());
- Season sn2 = await db.AddSeason(new Season());
- // SEED EPISODES;
- Episode twk11 = await db.AddEpisode(new Episode(1, "First"));
- Episode twk12 = await db.AddEpisode(new Episode(2, "Second"));
- Episode twk13 = await db.AddEpisode(new Episode(3, "Third"));
- Episode twk21 = await db.AddEpisode(new Episode(1, "First"));
- Episode twk22 = await db.AddEpisode(new Episode(2, "Second"));
- Episode bb11 = await db.AddEpisode(new Episode(1, "First"));
- Episode bb12 = await db.AddEpisode(new Episode(2, "Second"));
- Episode bb21 = await db.AddEpisode(new Episode(1, "First"));
- Episode bb22 = await db.AddEpisode(new Episode(2, "Second"));
- Episode pb11 = await db.AddEpisode(new Episode(1, "First"));
- Episode pb12 = await db.AddEpisode(new Episode(2, "Second"));
- Episode pb21 = await db.AddEpisode(new Episode(1, "First"));
- Episode pb22 = await db.AddEpisode(new Episode(2, "Second"));
- Episode pb31 = await db.AddEpisode(new Episode(1, "First"));
- Episode pb32 = await db.AddEpisode(new Episode(2, "Second"));
- Episode to11 = await db.AddEpisode(new Episode(1, "First"));
- Episode to12 = await db.AddEpisode(new Episode(2, "Second"));
- Episode to21 = await db.AddEpisode(new Episode(1, "First"));
- Episode to22 = await db.AddEpisode(new Episode(2, "Second"));
- Episode sn11 = await db.AddEpisode(new Episode(1, "First"));
- Episode sn12 = await db.AddEpisode(new Episode(2, "Second"));
- Episode sn21 = await db.AddEpisode(new Episode(1, "First"));
- Episode sn22 = await db.AddEpisode(new Episode(2, "Second"));
- Episode sn23 = await db.AddEpisode(new Episode(3, "Third"));
- */
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement