public static void AddNewDoctor(Doctor doctor) { HealthCareEntities hlthCareContext = new HealthCareEntities(); hlthCareContext.Doctors.Add(doctor); hlthCareContext.SaveChanges(); }
public static void AdNewJournal(Journal journal) { HealthCareEntities hlthCareContext = new HealthCareEntities(); hlthCareContext.Journals.Add(journal); hlthCareContext.SaveChanges(); }
public static void AddNewPatient(Patient patient) { HealthCareEntities hlthCareContext = new HealthCareEntities(); hlthCareContext.Patients.Add(patient); hlthCareContext.SaveChanges(); }
public static void AddNewClinic(Clinic clinic) { HealthCareEntities hlthCareContext = new HealthCareEntities(); hlthCareContext.Clinics.Add(clinic); hlthCareContext.SaveChanges(); }
public static void UpdatePatient(Patient patient) { HealthCareEntities hlthCareContext = new HealthCareEntities(); var pt = hlthCareContext.Patients.Where(p => p.Id == patient.Id).First(); pt.Name = patient.Name; pt.Phone = patient.Phone; pt.Address = patient.Address; hlthCareContext.SaveChanges(); }
public static void UpdateDoctor(Doctor doctor) { HealthCareEntities hlthCareContext = new HealthCareEntities(); var dr = hlthCareContext.Doctors.Where(d => d.Id == doctor.Id).First(); dr.Name = doctor.Name; dr.Phone = doctor.Phone; dr.IdClinic = doctor.IdClinic; dr.Address = doctor.Address; hlthCareContext.SaveChanges(); }
public static void DeleteDoctor(int id) { HealthCareEntities hlthCareContext = new HealthCareEntities(); Doctor doctor = new Doctor() { Id = id }; hlthCareContext.Doctors.Attach(doctor); hlthCareContext.Doctors.Remove(doctor); hlthCareContext.SaveChanges(); }
public static void DeletePatient(int id) { HealthCareEntities hlthCareContext = new HealthCareEntities(); Patient patient = new Patient { Id = id }; hlthCareContext.Patients.Attach(patient); hlthCareContext.Patients.Remove(patient); hlthCareContext.SaveChanges(); }
public static void DeleteClinic(int id) { HealthCareEntities hlthCareContext = new HealthCareEntities(); Clinic clinic = new Clinic() { Id = id }; hlthCareContext.Clinics.Attach(clinic); hlthCareContext.Clinics.Remove(clinic); hlthCareContext.SaveChanges(); }
//Journal journalPast, Journal journalNew ) public static void UpdateJournal(Journal journal) { HealthCareEntities hlthCareContext = new HealthCareEntities(); var jr = hlthCareContext.Journals.Where(j => (j.IdDoctor == journal.IdDoctor && j.IdPatient == journal.IdPatient && j.Date == journal.Date)).First(); //jr.IdDoctor = journalNew.IdDoctor; //jr.IdPatient = journalNew.IdPatient; //jr.SomeInfo = journalNew.SomeInfo; //jr.Date = journalNew.Date; jr.SomeInfo = journal.SomeInfo; hlthCareContext.SaveChanges(); }
public static void DeleteJournal(int idDoctor, int idPatient, DateTime date) { HealthCareEntities hlthCareContext = new HealthCareEntities(); Journal journal = new Journal { IdDoctor = idDoctor, IdPatient = idPatient, Date = date }; hlthCareContext.Journals.Attach(journal); hlthCareContext.Journals.Remove(journal); hlthCareContext.SaveChanges(); }
public static void UpdateClinic(Clinic clinic) { HealthCareEntities hlthCareContext = new HealthCareEntities(); var cl = hlthCareContext.Clinics.Where(c => c.Id == clinic.Id).First(); cl.Title = clinic.Title; cl.Phone = clinic.Phone; cl.Address = clinic.Address; hlthCareContext.SaveChanges(); }