private void AddSportIfNotExists(AppDBContext db, DB.Models.Sport sport)
{
if (db.Sports.Where(s => s.Name == sport.Name).SingleOrDefault() != null)
{
return;
}
db.Sports.Add(sport);
db.SaveChanges();
}
private void ConnectAthleteToSportIfNotExists(AppDBContext db, DB.Models.Athlete athlete, DB.Models.Sport sport)
{
if (db.AthleteSports.Where(s => s.Athlete.FullName == athlete.FullName && s.Sport.Name == sport.Name).SingleOrDefault() != null)
{
return;
}
db.AthleteSports.Add(new DB.Models.AthleteSport()
{
Athlete = athlete,
Sport = sport
});
db.SaveChanges();
}
public void GenerateBasicData()
{
var db = new AppDBContext();
db.Database.EnsureCreated();
var running = new DB.Models.Sport()
{
Name = "Running"
};
AddSportIfNotExists(db, running);
var jumping = new DB.Models.Sport()
{
Name = "Jumping"
};
AddSportIfNotExists(db, jumping);
var swimming = new DB.Models.Sport()
{
Name = "Swimming"
};
AddSportIfNotExists(db, swimming);
var box = new DB.Models.Sport()
{
Name = "Boxing"
};
AddSportIfNotExists(db, box);
var gymnastic = new DB.Models.Sport()
{
Name = "Gymnastic"
};
AddSportIfNotExists(db, gymnastic);
var usainBolt = new DB.Models.Athlete()
{
FullName = "Usain Bolt",
Birth = DateTime.Parse("1986.08.21."),
BirthPlace = "Kingston",
Country = "Jamaica",
};
AddAthleteIfNotExists(db, usainBolt);
ConnectAthleteToSportIfNotExists(db, usainBolt, running);
var mPhelps = new DB.Models.Athlete()
{
FullName = "Michael Phelps",
Birth = DateTime.Parse("1985.06.30."),
BirthPlace = "USA",
Country = "United States",
};
AddAthleteIfNotExists(db, mPhelps);
ConnectAthleteToSportIfNotExists(db, mPhelps, swimming);
var mAli = new DB.Models.Athlete()
{
FullName = "Muhammad Ali",
Birth = DateTime.Parse("1942.01.17."),
BirthPlace = "Chicago",
Country = "United States",
};
AddAthleteIfNotExists(db, mAli);
ConnectAthleteToSportIfNotExists(db, mAli, box);
var pMorales = new DB.Models.Athlete()
{
FullName = "Pablo Morales",
Birth = DateTime.Parse("1964.12.05."),
BirthPlace = "New York",
Country = "United States",
};
AddAthleteIfNotExists(db, pMorales);
ConnectAthleteToSportIfNotExists(db, pMorales, swimming);
var lLatynina = new DB.Models.Athlete()
{
FullName = "Larisa Latynina",
Birth = DateTime.Parse("1934.12.27."),
BirthPlace = "Moscow",
Country = "Russian Federation",
};
AddAthleteIfNotExists(db, lLatynina);
ConnectAthleteToSportIfNotExists(db, lLatynina, swimming);
}
