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); }