Advertisement
ToxicTroelsen

Untitled

May 24th, 2018
9,053
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.68 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading.Tasks;
  6.  
  7. namespace db
  8. {
  9. public class DatabaseSeed
  10. {
  11. public static async void AddStuff()
  12. {
  13. DbService db = new DbService();
  14.  
  15. User iomc = db.GetUserByUsername("iomc");
  16. User hasc = db.GetUserByUsername("hasc");
  17. User inru = db.GetUserByUsername("inru");
  18. User rakr = db.GetUserByUsername("rakr");
  19. User doje = db.GetUserByUsername("doje");
  20. User gaga = db.GetUserByUsername("gaga");
  21. User qutr = db.GetUserByUsername("qutr");
  22. User jada = db.GetUserByUsername("jada");
  23.  
  24. iomc.SeenEpisodes = new List<Episode>();
  25. iomc.RatedMovies = new List<RatedMovie>();
  26. iomc.FollowedSeries = new List<Series>();
  27. hasc.SeenEpisodes = new List<Episode>();
  28. hasc.RatedMovies = new List<RatedMovie>();
  29. hasc.FollowedSeries = new List<Series>();
  30. inru.SeenEpisodes = new List<Episode>();
  31. inru.RatedMovies = new List<RatedMovie>();
  32. inru.SeenEpisodes = new List<Episode>();
  33. rakr.SeenEpisodes = new List<Episode>();
  34. rakr.RatedMovies = new List<RatedMovie>();
  35. rakr.FollowedSeries = new List<Series>();
  36. doje.SeenEpisodes = new List<Episode>();
  37. doje.RatedMovies = new List<RatedMovie>();
  38. doje.FollowedSeries = new List<Series>();
  39. gaga.SeenEpisodes = new List<Episode>();
  40. gaga.RatedMovies = new List<RatedMovie>();
  41. gaga.FollowedSeries = new List<Series>();
  42. qutr.SeenEpisodes = new List<Episode>();
  43. qutr.RatedMovies = new List<RatedMovie>();
  44. qutr.FollowedSeries = new List<Series>();
  45. jada.SeenEpisodes = new List<Episode>();
  46. jada.RatedMovies = new List<RatedMovie>();
  47. jada.FollowedSeries = new List<Series>();
  48.  
  49. Genre romance = db.GetGenreByName("Romance");
  50. Genre comedy = db.GetGenreByName("Comedy");
  51. Genre horror = db.GetGenreByName("Horror");
  52. Genre thriller = db.GetGenreByName("Thriller");
  53. Genre action = db.GetGenreByName("Action");
  54. Genre adventure = db.GetGenreByName("Adventure");
  55. Genre drama = db.GetGenreByName("Drama");
  56. Genre scifi = db.GetGenreByName("Sci-Fi");
  57. Genre animation = db.GetGenreByName("Animation");
  58. Genre crime = db.GetGenreByName("crime");
  59. Genre fantasy = db.GetGenreByName("fantasy");
  60.  
  61. romance.Movies = new List<Movie>();
  62. romance.Series = new List<Series>();
  63. comedy.Movies = new List<Movie>();
  64. comedy.Series = new List<Series>();
  65. horror.Movies = new List<Movie>();
  66. horror.Series = new List<Series>();
  67. thriller.Movies = new List<Movie>();
  68. thriller.Series = new List<Series>();
  69. action.Movies = new List<Movie>();
  70. action.Series = new List<Series>();
  71. adventure.Movies = new List<Movie>();
  72. adventure.Series = new List<Series>();
  73. drama.Movies = new List<Movie>();
  74. drama.Series = new List<Series>();
  75. scifi.Movies = new List<Movie>();
  76. scifi.Series = new List<Series>();
  77. animation.Movies = new List<Movie>();
  78. animation.Series = new List<Series>();
  79. crime.Movies = new List<Movie>();
  80. crime.Series = new List<Series>();
  81. fantasy.Movies = new List<Movie>();
  82. fantasy.Series = new List<Series>();
  83.  
  84. StreamingService netflix = db.GetStreamingServiceByName("Netflix");
  85. StreamingService hbo = db.GetStreamingServiceByName("HBO");
  86. StreamingService amazonVideo = db.GetStreamingServiceByName("Amazon Video");
  87. StreamingService hulu = db.GetStreamingServiceByName("Hulu");
  88. StreamingService googlePlay = db.GetStreamingServiceByName("Google Play");
  89.  
  90. netflix.Movies = new List<Movie>();
  91. netflix.Series = new List<Series>();
  92. hbo.Movies = new List<Movie>();
  93. hbo.Series = new List<Series>();
  94. amazonVideo.Movies = new List<Movie>();
  95. amazonVideo.Series = new List<Series>();
  96. hulu.Movies = new List<Movie>();
  97. hulu.Series = new List<Series>();
  98. googlePlay.Movies = new List<Movie>();
  99. googlePlay.Series = new List<Series>();
  100.  
  101. Movie americanPie = db.GetMovieByName("American Pie");
  102. Movie roadTrip = db.GetMovieByName("Road Trip");
  103. Movie up = db.GetMovieByName("Up");
  104. Movie theDayAfterTomorrow = db.GetMovieByName("The Day After Tomorrow");
  105. Movie theMartian = db.GetMovieByName("The Martian");
  106. Movie gravity = db.GetMovieByName("Gravity");
  107. Movie napoleonDynamite = db.GetMovieByName("Napoleon Dynamite");
  108. Movie dawnOfTheDead = db.GetMovieByName("Dawn of the Dead");
  109.  
  110. americanPie.Genres = new List<Genre>();
  111. americanPie.StreamingServices = new List<StreamingService>();
  112. americanPie.Ratings = new List<RatedMovie>();
  113. roadTrip.Genres = new List<Genre>();
  114. roadTrip.StreamingServices = new List<StreamingService>();
  115. roadTrip.Ratings = new List<RatedMovie>();
  116. up.Genres = new List<Genre>();
  117. up.StreamingServices = new List<StreamingService>();
  118. up.Ratings = new List<RatedMovie>();
  119. theDayAfterTomorrow.Genres = new List<Genre>();
  120. theDayAfterTomorrow.StreamingServices = new List<StreamingService>();
  121. theDayAfterTomorrow.Ratings = new List<RatedMovie>();
  122. theMartian.Genres = new List<Genre>();
  123. theMartian.StreamingServices = new List<StreamingService>();
  124. theMartian.Ratings = new List<RatedMovie>();
  125. gravity.Genres = new List<Genre>();
  126. gravity.StreamingServices = new List<StreamingService>();
  127. gravity.Ratings = new List<RatedMovie>();
  128. napoleonDynamite.Genres = new List<Genre>();
  129. napoleonDynamite.StreamingServices = new List<StreamingService>();
  130. napoleonDynamite.Ratings = new List<RatedMovie>();
  131. dawnOfTheDead.Genres = new List<Genre>();
  132. dawnOfTheDead.StreamingServices = new List<StreamingService>();
  133. dawnOfTheDead.Ratings = new List<RatedMovie>();
  134.  
  135. Series theWalkingDead = db.GetSeriesByName("The Walking Dead");
  136. Series breakingBad = db.GetSeriesByName("Breaking Bad");
  137. Series prisonBreak = db.GetSeriesByName("Prison Break");
  138. Series theOC = db.GetSeriesByName("The O.C.");
  139. Series supernatural = db.GetSeriesByName("Supernatural");
  140.  
  141. theWalkingDead.StreamingServices = new List<StreamingService>();
  142. theWalkingDead.Seasons = new List<Season>();
  143. theWalkingDead.Ratings = new List<int>();
  144. theWalkingDead.Genres = new List<Genre>();
  145. breakingBad.StreamingServices = new List<StreamingService>();
  146. breakingBad.Seasons = new List<Season>();
  147. breakingBad.Ratings = new List<int>();
  148. breakingBad.Genres = new List<Genre>();
  149. prisonBreak.StreamingServices = new List<StreamingService>();
  150. prisonBreak.Seasons = new List<Season>();
  151. prisonBreak.Ratings = new List<int>();
  152. prisonBreak.Genres = new List<Genre>();
  153. theOC.StreamingServices = new List<StreamingService>();
  154. theOC.Seasons = new List<Season>();
  155. theOC.Ratings = new List<int>();
  156. theOC.Genres = new List<Genre>();
  157. supernatural.StreamingServices = new List<StreamingService>();
  158. supernatural.Seasons = new List<Season>();
  159. supernatural.Ratings = new List<int>();
  160. supernatural.Genres = new List<Genre>();
  161.  
  162. Season twk1 = db.GetSeasonByName("The Walking Dead Season 1");
  163. Season twk2 = db.GetSeasonByName("The Walking Dead Season 2");
  164. Season bb1 = db.GetSeasonByName("Breaking Bad Season 1");
  165. Season bb2 = db.GetSeasonByName("Breaking Bad Season 2");
  166. Season pb1 = db.GetSeasonByName("Prison Break Season 1");
  167. Season pb2 = db.GetSeasonByName("Prison Break Season 2");
  168. Season pb3 = db.GetSeasonByName("Prison Break Season 3");
  169. Season to1 = db.GetSeasonByName("The O.C. Season 1");
  170. Season to2 = db.GetSeasonByName("The O.C. Season 2");
  171. Season sn1 = db.GetSeasonByName("Supernatural Season 1");
  172. Season sn2 = db.GetSeasonByName("Supernatural Season 2");
  173.  
  174. twk1.Episodes = new List<Episode>();
  175. twk2.Episodes = new List<Episode>();
  176. bb1.Episodes = new List<Episode>();
  177. bb2.Episodes = new List<Episode>();
  178. pb1.Episodes = new List<Episode>();
  179. pb2.Episodes = new List<Episode>();
  180. pb3.Episodes = new List<Episode>();
  181. to1.Episodes = new List<Episode>();
  182. to2.Episodes = new List<Episode>();
  183. sn1.Episodes = new List<Episode>();
  184. sn2.Episodes = new List<Episode>();
  185.  
  186. Episode twk11 = db.GetEpisodeByName("twk11");
  187. Episode twk12 = db.GetEpisodeByName("twk12");
  188. Episode twk13 = db.GetEpisodeByName("twk13");
  189. Episode twk21 = db.GetEpisodeByName("twk21");
  190. Episode twk22 = db.GetEpisodeByName("twk22");
  191. Episode bb11 = db.GetEpisodeByName("bb11");
  192. Episode bb12 = db.GetEpisodeByName("bb12");
  193. Episode bb21 = db.GetEpisodeByName("bb21");
  194. Episode bb22 = db.GetEpisodeByName("bb22");
  195. Episode pb11 = db.GetEpisodeByName("pb11");
  196. Episode pb12 = db.GetEpisodeByName("pb12");
  197. Episode pb21 = db.GetEpisodeByName("pb21");
  198. Episode pb22 = db.GetEpisodeByName("pb22");
  199. Episode pb31 = db.GetEpisodeByName("pb31");
  200. Episode pb32 = db.GetEpisodeByName("pb32");
  201. Episode to11 = db.GetEpisodeByName("to11");
  202. Episode to12 = db.GetEpisodeByName("to12");
  203. Episode to21 = db.GetEpisodeByName("to21");
  204. Episode to22 = db.GetEpisodeByName("to22");
  205. Episode sn11 = db.GetEpisodeByName("sn11");
  206. Episode sn12 = db.GetEpisodeByName("sn12");
  207. Episode sn21 = db.GetEpisodeByName("sn21");
  208. Episode sn22 = db.GetEpisodeByName("sn22");
  209. Episode sn23 = db.GetEpisodeByName("sn23");
  210.  
  211. americanPie.Genres.Add(comedy);
  212.  
  213. roadTrip.Genres.Add(adventure);
  214. roadTrip.Genres.Add(comedy);
  215.  
  216. up.Genres.Add(animation);
  217. up.Genres.Add(comedy);
  218. up.Genres.Add(adventure);
  219.  
  220. theDayAfterTomorrow.Genres.Add(action);
  221. theDayAfterTomorrow.Genres.Add(adventure);
  222. theDayAfterTomorrow.Genres.Add(scifi);
  223.  
  224. theMartian.Genres.Add(adventure);
  225. theMartian.Genres.Add(drama);
  226. theMartian.Genres.Add(scifi);
  227.  
  228. gravity.Genres.Add(drama);
  229. gravity.Genres.Add(scifi);
  230. gravity.Genres.Add(thriller);
  231.  
  232. napoleonDynamite.Genres.Add(comedy);
  233.  
  234. dawnOfTheDead.Genres.Add(action);
  235. dawnOfTheDead.Genres.Add(horror);
  236. dawnOfTheDead.Genres.Add(thriller);
  237.  
  238. // ADD GENRES TO SERIES
  239. theWalkingDead.Genres.Add(drama);
  240. theWalkingDead.Genres.Add(horror);
  241. theWalkingDead.Genres.Add(thriller);
  242.  
  243. breakingBad.Genres.Add(crime);
  244. breakingBad.Genres.Add(drama);
  245. breakingBad.Genres.Add(thriller);
  246.  
  247. prisonBreak.Genres.Add(action);
  248. prisonBreak.Genres.Add(crime);
  249. prisonBreak.Genres.Add(drama);
  250.  
  251. theOC.Genres.Add(comedy);
  252. theOC.Genres.Add(drama);
  253. theOC.Genres.Add(romance);
  254.  
  255. supernatural.Genres.Add(drama);
  256. supernatural.Genres.Add(fantasy);
  257. supernatural.Genres.Add(horror);
  258.  
  259. // ADD EPISODES TO SEASONS
  260. twk1.Episodes.Add(twk11);
  261. twk1.Episodes.Add(twk11);
  262. twk1.Episodes.Add(twk13);
  263. twk2.Episodes.Add(twk21);
  264. twk2.Episodes.Add(twk22);
  265. bb1.Episodes.Add(bb11);
  266. bb1.Episodes.Add(bb12);
  267. bb2.Episodes.Add(bb21);
  268. bb2.Episodes.Add(bb22);
  269. pb1.Episodes.Add(pb11);
  270. pb1.Episodes.Add(pb12);
  271. pb2.Episodes.Add(pb21);
  272. pb2.Episodes.Add(pb22);
  273. pb3.Episodes.Add(pb31);
  274. pb3.Episodes.Add(pb32);
  275. to1.Episodes.Add(to11);
  276. to1.Episodes.Add(to12);
  277. to2.Episodes.Add(to21);
  278. to2.Episodes.Add(to22);
  279. sn1.Episodes.Add(sn11);
  280. sn1.Episodes.Add(sn12);
  281. sn2.Episodes.Add(sn21);
  282. sn2.Episodes.Add(sn22);
  283. sn2.Episodes.Add(sn23);
  284.  
  285. // ADD SEASONS TO SERIES
  286. theWalkingDead.Seasons.Add(twk1);
  287. theWalkingDead.Seasons.Add(twk2);
  288. breakingBad.Seasons.Add(bb1);
  289. breakingBad.Seasons.Add(bb2);
  290. prisonBreak.Seasons.Add(pb1);
  291. prisonBreak.Seasons.Add(pb2);
  292. prisonBreak.Seasons.Add(pb3);
  293. theOC.Seasons.Add(to1);
  294. theOC.Seasons.Add(to2);
  295. supernatural.Seasons.Add(sn1);
  296. supernatural.Seasons.Add(sn2);
  297.  
  298. // ADD STREAMINGSERVICES TO MOVIES
  299. americanPie.StreamingServices.Add(netflix);
  300. americanPie.StreamingServices.Add(hbo);
  301. americanPie.StreamingServices.Add(amazonVideo);
  302. americanPie.StreamingServices.Add(hulu);
  303. americanPie.StreamingServices.Add(googlePlay);
  304.  
  305. roadTrip.StreamingServices.Add(netflix);
  306. roadTrip.StreamingServices.Add(hbo);
  307. roadTrip.StreamingServices.Add(amazonVideo);
  308. roadTrip.StreamingServices.Add(hulu);
  309. roadTrip.StreamingServices.Add(googlePlay);
  310.  
  311.  
  312. up.StreamingServices.Add(amazonVideo);
  313.  
  314. theDayAfterTomorrow.StreamingServices.Add(netflix);
  315.  
  316. theMartian.StreamingServices.Add(netflix);
  317. theMartian.StreamingServices.Add(hbo);
  318. theMartian.StreamingServices.Add(amazonVideo);
  319.  
  320.  
  321. gravity.StreamingServices.Add(netflix);
  322. gravity.StreamingServices.Add(hbo);
  323.  
  324. napoleonDynamite.StreamingServices.Add(netflix);
  325. napoleonDynamite.StreamingServices.Add(hbo);
  326.  
  327. dawnOfTheDead.StreamingServices.Add(netflix);
  328.  
  329. // ADD STREAMINGSERVICES TO SERIES
  330. theWalkingDead.StreamingServices.Add(hbo);
  331.  
  332. breakingBad.StreamingServices.Add(netflix);
  333. breakingBad.StreamingServices.Add(hulu);
  334.  
  335.  
  336. prisonBreak.StreamingServices.Add(netflix);
  337. prisonBreak.StreamingServices.Add(googlePlay);
  338.  
  339. theOC.StreamingServices.Add(netflix);
  340. theOC.StreamingServices.Add(amazonVideo);
  341.  
  342. supernatural.StreamingServices.Add(googlePlay);
  343. supernatural.StreamingServices.Add(hulu);
  344.  
  345. db.SaveChanges();
  346.  
  347.  
  348. /*// SEED USERS
  349. User iomc = await db.AddUser(new User("iomc", "Iolanthe", "McIlharga"));
  350. User hasc = await db.AddUser(new User("hasc", "Hatti", "Scarman"));
  351. User inru = await db.AddUser(new User("inru", "Inge", "Rudyard"));
  352. User rakr = await db.AddUser(new User("rakr", "Ranice", "Krimmer"));
  353. User doje = await db.AddUser(new User("doje", "Doralyn", "Jeal"));
  354. User gaga = await db.AddUser(new User("gaga", "Gaven", "Garnar"));
  355. User qutr = await db.AddUser(new User("qutr", "Quentin", "Tregunnah"));
  356. User jada = await db.AddUser(new User("jada", "Jacqueline", "Dannehl"));
  357.  
  358. // SEED GENRES
  359. Genre romance = await db.AddGenre(new Genre("Romance"));
  360. Genre comedy = await db.AddGenre(new Genre("Comedy"));
  361. Genre horror = await db.AddGenre(new Genre("Horror"));
  362. Genre thriller = await db.AddGenre(new Genre("Thriller"));
  363. Genre action = await db.AddGenre(new Genre("Action"));
  364. Genre adventure = await db.AddGenre(new Genre("Adventure"));
  365. Genre drama = await db.AddGenre(new Genre("Drama"));
  366. Genre scifi = await db.AddGenre(new Genre("Sci-Fi"));
  367. Genre animation = await db.AddGenre(new Genre("Animation"));
  368. Genre crime = await db.AddGenre(new Genre("crime"));
  369. Genre fantasy = await db.AddGenre(new Genre("fantasy"));
  370.  
  371. // SEED STREAMINGSERVICES
  372. StreamingService netflix = await db.AddStreamingService(new StreamingService("Netflix"));
  373. StreamingService hbo = await db.AddStreamingService(new StreamingService("HBO"));
  374. StreamingService amazonVideo = await db.AddStreamingService(new StreamingService("Amazon Video"));
  375. StreamingService hulu = await db.AddStreamingService(new StreamingService("Hulu"));
  376. StreamingService googlePlay = await db.AddStreamingService(new StreamingService("Google Play"));
  377.  
  378. // SEED MOVIES
  379. Movie americanPie = await db.AddMovie(new Movie("American Pie", "Chris Weitz", DateTime.Now, DateTime.Now.AddDays(30)));
  380. Movie roadTrip = await db.AddMovie(new Movie("Road Trip", "Todd Philips", DateTime.Now, DateTime.Now.AddDays(30)));
  381. Movie up = await db.AddMovie(new Movie("Up", "Pete Doctor", DateTime.Now, DateTime.Now.AddDays(30)));
  382. Movie theDayAfterTomorrow = await db.AddMovie(new Movie("The Day After Tomorrow", "Roland Emmerich", DateTime.Now, DateTime.Now.AddDays(30)));
  383. Movie theMartian = await db.AddMovie(new Movie("The Martian", "Ridley Scott", DateTime.Now, DateTime.Now.AddDays(30)));
  384. Movie gravity = await db.AddMovie(new Movie("Gravity", "Alfonso Cuarón", DateTime.Now, DateTime.Now.AddDays(30)));
  385. Movie napoleonDynamite = await db.AddMovie(new Movie("Napoleon Dynamite", "Jared Hess", DateTime.Now, DateTime.Now.AddDays(30)));
  386. Movie dawnOfTheDead = await db.AddMovie(new Movie("Dawn of the Dead", "Zack Snyder", DateTime.Now, DateTime.Now.AddDays(30)));
  387.  
  388. // SEED SERIES
  389. Series theWalkingDead = await db.AddSeries(new Series("The Walking Dead", "Frank Darabont", DateTime.Now, DateTime.Now.AddDays(30)));
  390. Series breakingBad = await db.AddSeries(new Series("Breaking Bad", "Vince Gilligan", DateTime.Now, DateTime.Now.AddDays(30)));
  391. Series prisonBreak = await db.AddSeries(new Series("Prison Break", "Paul Scheuring", DateTime.Now, DateTime.Now.AddDays(30)));
  392. Series theOC = await db.AddSeries(new Series("The O.C.", "Josh Schwartz", DateTime.Now, DateTime.Now.AddDays(30)));
  393. Series supernatural = await db.AddSeries(new Series("Supernatural", "Eric Kripke", DateTime.Now, DateTime.Now.AddDays(30)));
  394.  
  395. // SEED SEASONS
  396. Season twk1 = await db.AddSeason(new Season());
  397. Season twk2 = await db.AddSeason(new Season());
  398. Season bb1 = await db.AddSeason(new Season());
  399. Season bb2 = await db.AddSeason(new Season());
  400. Season pb1 = await db.AddSeason(new Season());
  401. Season pb2 = await db.AddSeason(new Season());
  402. Season pb3 = await db.AddSeason(new Season());
  403. Season to1 = await db.AddSeason(new Season());
  404. Season to2 = await db.AddSeason(new Season());
  405. Season sn1 = await db.AddSeason(new Season());
  406. Season sn2 = await db.AddSeason(new Season());
  407.  
  408. // SEED EPISODES;
  409. Episode twk11 = await db.AddEpisode(new Episode(1, "First"));
  410. Episode twk12 = await db.AddEpisode(new Episode(2, "Second"));
  411. Episode twk13 = await db.AddEpisode(new Episode(3, "Third"));
  412. Episode twk21 = await db.AddEpisode(new Episode(1, "First"));
  413. Episode twk22 = await db.AddEpisode(new Episode(2, "Second"));
  414. Episode bb11 = await db.AddEpisode(new Episode(1, "First"));
  415. Episode bb12 = await db.AddEpisode(new Episode(2, "Second"));
  416. Episode bb21 = await db.AddEpisode(new Episode(1, "First"));
  417. Episode bb22 = await db.AddEpisode(new Episode(2, "Second"));
  418. Episode pb11 = await db.AddEpisode(new Episode(1, "First"));
  419. Episode pb12 = await db.AddEpisode(new Episode(2, "Second"));
  420. Episode pb21 = await db.AddEpisode(new Episode(1, "First"));
  421. Episode pb22 = await db.AddEpisode(new Episode(2, "Second"));
  422. Episode pb31 = await db.AddEpisode(new Episode(1, "First"));
  423. Episode pb32 = await db.AddEpisode(new Episode(2, "Second"));
  424. Episode to11 = await db.AddEpisode(new Episode(1, "First"));
  425. Episode to12 = await db.AddEpisode(new Episode(2, "Second"));
  426. Episode to21 = await db.AddEpisode(new Episode(1, "First"));
  427. Episode to22 = await db.AddEpisode(new Episode(2, "Second"));
  428. Episode sn11 = await db.AddEpisode(new Episode(1, "First"));
  429. Episode sn12 = await db.AddEpisode(new Episode(2, "Second"));
  430. Episode sn21 = await db.AddEpisode(new Episode(1, "First"));
  431. Episode sn22 = await db.AddEpisode(new Episode(2, "Second"));
  432. Episode sn23 = await db.AddEpisode(new Episode(3, "Third"));
  433. */
  434. }
  435. }
  436. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement