private static void SetDefaultDbContent(PatientModelContainer dbContext)
{
using (var context = new PatientModelContainer())
{
Database.SetInitializer(new DbSeeder());
//without below database/table is created but data is not populated;
var data = from d in context.DbPatients select d;
}
}
private DbPatient GetDbPatient(PatientModelContainer context, string lastName)
{
DbPatient dbPatientFound = null;
dbPatientFound = (from p in context.DbPatients
where p.LastName == lastName
select p).FirstOrDefault();
return(dbPatientFound);
}
public Patient GetPatient(string lastName)
{
Patient p = null;
using (var context = new PatientModelContainer())
{
var patientFound = GetDbPatient(context, lastName);
if (patientFound != null)
{
p = GetPatientFromDbPatient(patientFound);
}
}
return(p);
}
public void DeletePatient(string lastName)
{
using (var context = new PatientModelContainer())
{
var foundPerson = GetDbPatient(context, lastName);
if (foundPerson == null)
{
return;
}
context.DbPatients.Remove(foundPerson);
context.SaveChanges();
}
}
public IEnumerable <Patient> GetPatients()
{
using (var ctx = new PatientModelContainer())
{
IEnumerable <Patient> patients = from p in ctx.DbPatients
select new Patient
{
FirstName = p.FirstName,
LastName = p.LastName,
PhoneNumber = p.PhoneNumber,
MobileNumber = p.MobileNumber,
Address = p.Address
};
return(patients.ToList());
}
}
public void UpdatePatient(string lastName, Patient updatedPatient)
{
using (var context = new PatientModelContainer())
{
var patientFound = GetDbPatient(context, lastName);
if (patientFound == null)
{
return;
}
patientFound.FirstName = updatedPatient.FirstName;
patientFound.LastName = updatedPatient.LastName;
patientFound.PhoneNumber = updatedPatient.PhoneNumber;
patientFound.MobileNumber = updatedPatient.MobileNumber;
patientFound.Address = updatedPatient.Address;
context.SaveChanges();
}
}
public void AddPatient(Patient newPatient)
{
using (var context = new PatientModelContainer())
{
if (GetDbPatient(context, newPatient.LastName) != null)
{
return;
}
var addPatient = new DbPatient()
{
FirstName = newPatient.FirstName,
LastName = newPatient.LastName,
PhoneNumber = newPatient.PhoneNumber,
MobileNumber = newPatient.MobileNumber,
Address = newPatient.Address
};
context.DbPatients.Add(addPatient);
context.SaveChanges();
}
}
/// <summary>
/// This method will call into DbSeeder class (below) that contains
/// overridden Seed method to populate dbo.Patients table;
/// </summary>
private static void DbSetup()
{
var ctx = new PatientModelContainer();
SetDefaultDbContent(ctx);
}
