private static async Task <int> EnsureCoach(CoachContext context, string userID, string firstName, string surname)
{
var coach = new Coach {
};
coach = (Coach)context.Coaches.FirstOrDefault(c => c.OwnerID == userID);
if (coach == null)
{
coach = new Coach
{
OwnerID = userID,
FirstName = firstName,
Surname = surname,
HireDate = DateTime.Now,
RecordStatus = (int)RecordStatus.Active
};
await context.Coaches.AddAsync(coach);
context.SaveChanges();
}
return(coach.ID);
}
private static async Task <int> EnsureAthlete(CoachContext context, string userID, string firstName, string surname)
{
var athlete = new Athlete {
};
athlete = (Athlete)context.Athletes.FirstOrDefault(a => a.OwnerID == userID);
if (athlete == null)
{
athlete = new Athlete
{
OwnerID = userID,
FirstName = firstName,
Surname = surname,
EnrollmentDate = DateTime.Now,
RecordStatus = (int)RecordStatus.Active
};
await context.Athletes.AddAsync(athlete);
context.SaveChanges();
}
return(athlete.ID);
}
private static void SeedDb(CoachContext context)
{
// Look for any students.
//if (context.Athletes.Any())
//{
// return; // DB has been seeded
//}
//var athletes = new Athlete[]
//{
// new Athlete{FirstName="Rebecca",Surname="Jenner",EnrollmentDate=DateTime.Parse("2005-09-01")},
// new Athlete{FirstName="Kody",Surname="Barrett",EnrollmentDate=DateTime.Parse("2002-09-01")},
// new Athlete{FirstName="Ian",Surname="Hurley",EnrollmentDate=DateTime.Parse("2003-09-01")},
// new Athlete{FirstName="Sherry",Surname="Ey",EnrollmentDate=DateTime.Parse("2002-09-01")},
// new Athlete{FirstName="Kephren",Surname="Izzard",EnrollmentDate=DateTime.Parse("2002-09-01")},
// new Athlete{FirstName="Grant",Surname="Little",EnrollmentDate=DateTime.Parse("2001-09-01")},
// new Athlete{FirstName="Leslie",Surname="Sproule",EnrollmentDate=DateTime.Parse("2003-09-01")},
// new Athlete{FirstName="Troy",Surname="Austin",EnrollmentDate=DateTime.Parse("2005-09-01")}
//};
//foreach (Athlete a in athletes)
//{
// context.Athletes.Add(a);
//}
//context.SaveChanges();
//var trainingPrograms = new TrainingProgram[]
//{
// new TrainingProgram{Title="5 km running"},
// new TrainingProgram{Title="Marathon"},
// new TrainingProgram{Title="Ultra-marathon"},
// new TrainingProgram{Title="Ironman triathlon"},
// new TrainingProgram{Title="70.3 Ironman triathlon"},
// new TrainingProgram{Title="Open water swimming"}
//};
//foreach (TrainingProgram tp in trainingPrograms)
//{
// context.TrainingPrograms.Add(tp);
//}
//context.SaveChanges();
//var programEnrollments = new ProgramEnrollment[]
//{
// new ProgramEnrollment{AthleteID=1,TrainingProgramID=2},
// new ProgramEnrollment{AthleteID=1,TrainingProgramID=1},
// new ProgramEnrollment{AthleteID=1,TrainingProgramID=4},
// new ProgramEnrollment{AthleteID=2,TrainingProgramID=5},
// new ProgramEnrollment{AthleteID=2,TrainingProgramID=3},
// new ProgramEnrollment{AthleteID=2,TrainingProgramID=1},
// new ProgramEnrollment{AthleteID=3,TrainingProgramID=2},
// new ProgramEnrollment{AthleteID=4,TrainingProgramID=1},
// new ProgramEnrollment{AthleteID=4,TrainingProgramID=6},
// new ProgramEnrollment{AthleteID=5,TrainingProgramID=1},
// new ProgramEnrollment{AthleteID=6,TrainingProgramID=2},
// new ProgramEnrollment{AthleteID=7,TrainingProgramID=4},
//};
//foreach (ProgramEnrollment pe in programEnrollments)
//{
// context.ProgramEnrollments.Add(pe);
//}
//context.SaveChanges();
}
