private static void SeedDatabase(ClinicsDB db)
{
var proc1 = new Procedure() { Name = "Blood test", Price = 50.00m };
var proc2 = new Procedure() { Name = "MRI", Price = 1000.00m };
var specialty = new Specialty() { Name = "Internist" };
var specialist = new Specialist()
{
FirstName = "Gregory",
LastName = "House",
SpecialtyId = specialty.Id
};
var manip = new Manipulation()
{
Date = DateTime.Now,
SpecialistId = specialist.Id
};
manip.Procedures.Add(proc1);
manip.Procedures.Add(proc2);
db.Procedures.Add(proc1);
db.Procedures.Add(proc2);
db.Specialties.Add(specialty);
db.Specialists.Add(specialist);
db.Manipulations.Add(manip);
SaveChanges(db);
}
private static void ClearDatabase(ClinicsDB db)
{
// In this order
db.Database.ExecuteSqlCommand("DELETE FROM Procedures");
db.Database.ExecuteSqlCommand("DELETE FROM Manipulations");
db.Database.ExecuteSqlCommand("DELETE FROM Specialists");
db.Database.ExecuteSqlCommand("DELETE FROM Specialties");
}
private static void ClearDatabase(ClinicsDB db)
{
// In this order
db.Manipulations.ToList().ForEach(x => db.Manipulations.Remove(x));
db.Specialists.ToList().ForEach(x => db.Specialists.Remove(x));
db.Specialties.ToList().ForEach(x => db.Specialties.Remove(x));
db.Procedures.ToList().ForEach(x => db.Procedures.Remove(x));
SaveChanges(db);
}
static void Main()
{
Console.WriteLine("Connecting to server...");
using (var db = new ClinicsDB())
{
ClearDatabase(db);
SeedDatabase(db);
// Print all manipulations in the database
Console.WriteLine(string.Join(Environment.NewLine, db.Manipulations.ToList()));
}
}
private static void SaveChanges(ClinicsDB db)
{
int rowsAffected = db.SaveChanges();
Console.WriteLine("({0} row(s) affected)", rowsAffected);
}
