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