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();
};
}
