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 Manipulation CreateNewManipulation(IClinicsData data, string currentReportDate, DataRow row, Patient currentPatient)
{
var procedureName = row["Procedure"].ToString();
var specialistUin = row["SpecialistUIN"].ToString();
var information = row["Information"].ToString();
var specialist = data
.Specialists.All()
.Where(s => s.Uin == specialistUin)
.FirstOrDefault();
var procedure = data
.Procedures.All()
.Where(pr => pr.Name == procedureName)
.FirstOrDefault();
Manipulation currentManipulation = new Manipulation()
{
Id = Guid.NewGuid(),
PatientId = currentPatient.Id,
SpecialistId = specialist.Id,
ProcedureId = procedure.Id,
Information = information,
Date = DateTime.ParseExact(currentReportDate, "dd-MM-yyyy", CultureInfo.InvariantCulture)
};
return currentManipulation;
}
