static void Main(string[] args)
{
using (var dbContext = new HospitalISDbContext())
{
System.Console.WriteLine(dbContext.Users.First().Name);
System.Console.WriteLine(dbContext.Users.First().Id);
System.Console.WriteLine(dbContext.Users.First(p => p.Name == "Rick").Surname);
System.Console.WriteLine(dbContext.Users.First(p => p.Name == "Rick").Id);
}
}
private DbContext InitializeDatabase()
{
var context = new HospitalISDbContext(Effort.DbConnectionFactory.CreatePersistent(TestDbConnectionString));
//context.Users.RemoveRange(context.Users);
//context.SaveChanges();
var doctorJohnDoe = new Doctor
{
Id = Guid.Parse("00000000-0000-0000-0000-000000000001"),
Username = "******",
PasswordHash = "123",
PasswordSalt = "12",
Name = "John",
Surname = "Doe",
Specialization = HospitalISDBContext.Enums.Specialization.AllergistImmunologist
};
var doctorMacKane = new Doctor
{
Id = Guid.Parse("00000000-0000-0000-0000-000000000002"),
Username = "******",
PasswordHash = "123",
PasswordSalt = "12",
Name = "Mac",
Surname = "Kane",
Specialization = HospitalISDBContext.Enums.Specialization.Ophthalmologist
};
var patientHarryMaybourne = new Patient
{
Id = Guid.Parse("00000000-0000-0000-0000-000000000003"),
Username = "******",
PasswordHash = "123",
PasswordSalt = "12",
Name = "Harry",
Surname = "Maybourne",
DateOfBirth = new DateTime(1967, 1, 5),
IdentificationNumber = "670105"
};
var patientRickUnseen = new Patient
{
Id = Guid.Parse("00000000-0000-0000-0000-000000000004"),
Username = "******",
PasswordHash = "123",
PasswordSalt = "12",
Name = "Rick",
Surname = "Unseen",
DateOfBirth = new DateTime(1985, 8, 9),
IdentificationNumber = "850809"
};
var death = new Disease
{
Id = Guid.Parse("00000000-0000-0000-0000-000000000001"),
Name = "Death"
};
var deathSympthom1 = new Sympthom
{
Id = Guid.Parse("00000000-0000-0000-0000-000000000001"),
Name = "Immobilized"
};
var deathSympthom2 = new Sympthom
{
Id = Guid.Parse("00000000-0000-0000-0000-000000000002"),
Name = "Asleep"
};
var deathSympthom3 = new Sympthom
{
Id = Guid.Parse("00000000-0000-0000-0000-000000000003"),
Name = "Dead"
};
//death.Sympthoms.Add(deathSympthom1);
//death.Sympthoms.Add(deathSympthom2);
//death.Sympthoms.Add(deathSympthom3);
doctorJohnDoe.Patients.Add(patientHarryMaybourne);
doctorJohnDoe.Patients.Add(patientRickUnseen);
doctorMacKane.Patients.Add(patientHarryMaybourne);
patientHarryMaybourne.Doctors.Add(doctorJohnDoe);
patientHarryMaybourne.Doctors.Add(doctorMacKane);
patientRickUnseen.Doctors.Add(doctorJohnDoe);
context.Users.AddOrUpdate(doctorJohnDoe);
context.Users.AddOrUpdate(doctorMacKane);
context.Users.AddOrUpdate(patientHarryMaybourne);
context.Users.AddOrUpdate(patientRickUnseen);
context.Diseases.AddOrUpdate(death);
context.Sympthoms.AddOrUpdate(deathSympthom1);
context.Sympthoms.AddOrUpdate(deathSympthom2);
context.Sympthoms.AddOrUpdate(deathSympthom2);
context.SaveChanges();
return(context);
}
