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 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(); }
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(); }
private void SetChangesToDB() { using (HealthCareEntities healthCareContext = new HealthCareEntities()) { try { GetDataFromForms(); if (dr.Id != 0) { Doctor.UpdateDoctor(dr); } else { Doctor doctor = new Doctor() { Phone = dr.Phone, Name = dr.Name, Address = dr.Address, IdClinic = dr.IdClinic }; Doctor.AddNewDoctor(doctor); } } catch (Exception exp) { MessageBox.Show("Error! " + exp.Message); } } }
private void SetChangesToDB() { using (HealthCareEntities healthCareContext = new HealthCareEntities()) { try { GetDataFromForms(); if (cl.Id != 0) { Clinic.UpdateClinic(cl); } else { Clinic clinic = new Clinic() { Phone = cl.Phone, Title = cl.Title, Address = cl.Address }; Clinic.AddNewClinic(clinic); } } catch (Exception exp) { MessageBox.Show("Error! " + exp.Message); } } }
private void SetChangesToDB() { using (HealthCareEntities healthCareContext = new HealthCareEntities()) { try { GetDataFromForms(); if (pt.Id != 0) { Patient.UpdatePatient(pt); } else { Patient patient = new Patient() { Phone = pt.Phone, Name =pt.Name, Address = pt.Address }; Patient.AddNewPatient(patient); } } catch (Exception exp) { MessageBox.Show("Error! " + exp.Message); } } }
private void SetChangesToDB() { using (HealthCareEntities healthCareContext = new HealthCareEntities()) { try { //Journal journalBeforeChanged = new Journal() //{ // IdDoctor = jr.IdDoctor, // IdPatient = jr.IdPatient, // Date = jr.Date, // SomeInfo = jr.SomeInfo //}; if (jr.IdDoctor != 0) { GetDataFromForms(); Journal.UpdateJournal(jr); } else { GetDataFromForms(); Journal journal = new Journal() { IdDoctor = jr.IdDoctor, IdPatient = jr.IdPatient, Date = jr.Date, SomeInfo = jr.SomeInfo }; Journal.AdNewJournal(journal); } } catch (Exception exp) { MessageBox.Show("Error! " + exp.Message); } } }