public static void AddNewDoctor(Doctor doctor) { HealthCareEntities hlthCareContext = new HealthCareEntities(); hlthCareContext.Doctors.Add(doctor); hlthCareContext.SaveChanges(); }
public DoctorForm() { InitializeComponent(); dr = new Doctor(); flagEdit = false; cbClinic.Items.AddRange(Clinic.AllClinics().ToArray()); }
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 DoctorForm(int cmd, Doctor dr) { InitializeComponent(); this.dr = dr; flagEdit = false; cbClinic.Items.AddRange(Clinic.AllClinics().ToArray()); switch (cmd) { case 0: FormForEdit(); break; case 1: FormForAdd(); break; default: throw new Exception("Not correct parametr to constructor for DoctorForm!"); } }
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(); }
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); } } }