public SyllabusController(MvcDanceContext context) { _context = context; }
public DanceVideoController(MvcDanceContext context) { _context = context; }
public DanceMoveController(MvcDanceContext context) { _context = context; }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new MvcDanceContext(serviceProvider.GetRequiredService <DbContextOptions <MvcDanceContext> >())) { if (context.Dance.Any()) { return; } var dances = new List <Dance>() { new Dance() { Name = "Waltz", Speed = "Smooth" }, new Dance { Name = "Rumba", Speed = "Rhythm" }, new Dance() { Name = "Tango", Speed = "Smooth" }, new Dance() { Name = "Foxtrot", Speed = "Smooth" }, new Dance() { Name = "Cha-Cha", Speed = "Rhythm" } }; //Create the dances dances.ForEach(d => context.Dance.Add(d)); context.SaveChanges(); //Create the syllabus var syllabi = new List <Syllabus>(); foreach (Dance dance in dances) { for (int i = 1; i <= 3; i++) { syllabi.Add( new Syllabus { Level = i, DanceId = dance.DanceId } ); } } syllabi.ForEach(s => context.Syllabus.Add(s)); context.SaveChanges(); var dummyDanceVideo = new DanceVideo { Title = "Box Step", VideoUrl = "https://www.youtube.com/watch?v=n8PIcO4_S5Q", Description = "The box step" }; context.DanceVideo.Add(dummyDanceVideo); context.SaveChanges(); //TODO dance moves var dummyDanceMove = new DanceMove { DanceVideoId = dummyDanceVideo.DanceVideoId, SyllabusId = syllabi.Single(s => s.Level == 1 && s.DanceId == (dances.Single(d => d.Name == "Waltz").DanceId)).SyllabusId }; context.DanceMove.Add(dummyDanceMove); context.SaveChanges(); }; }