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