public List <PrescriptionMedicine> GetMedicinesList()
{
using (var ctx = new PatientDATA())
{
return(ctx.PrescriptionMedicine.ToList());
}
}
public List <Patient> GetList()
{
using (var ctx = new PatientDATA())
{
return(ctx.Patient.ToList());
}
}
public Patient GetPatientByTZ(long tz)
{
using (var ctx = new PatientDATA())
{
var Patient = ctx.Patient.Where(s => s.TZ == tz).FirstOrDefault();
return(Patient);
}
}
public Patient GetPatientByID(int id)
{
using (var ctx = new PatientDATA())
{
var Patient = ctx.Patient.Where(s => s.ID == id).FirstOrDefault();
return(Patient);
}
}
public void Add(Patient Patient)
{
using (var ctx = new PatientDATA())
{
ctx.Patient.Add(Patient);
ctx.SaveChanges();
}
}
public void Delete(int id)
{
using (var ctx = new PatientDATA())
{
var patient = ctx.Patient.Where(s => s.ID == id).FirstOrDefault();
ctx.Patient.Remove(patient); // פונקציות של הדאטה בייס
ctx.SaveChanges(); // שמירת שינויים
}
}
public List <PrescriptionMedicine> GetPatientMedicines(Patient patient)
{
using (PatientDATA ctx = new PatientDATA())
{
List <PrescriptionMedicine> medicines = new List <PrescriptionMedicine>(
ctx.PrescriptionMedicine.Where(medicine => medicine.PatientTZ == patient.TZ));
return(medicines);
}
}
public void Edit(Patient patient)
{
using (var ctx = new PatientDATA())
{
var p = ctx.Patient.FirstOrDefault(x => x.ID == patient.ID);
ctx.Patient.Remove(p);
ctx.Patient.Add(patient);
ctx.SaveChanges();
}
}
public void AddMedicines(List <MedicineTimes> medicines, Prescription prescription)
{
using (var ctx = new PatientDATA())
{
foreach (var item in medicines)
{
PrescriptionMedicine medicine = new PrescriptionMedicine(prescription.PatientTZ, item.MyMedicine.ProprietaryName, item.StartTime, item.EndTime);
ctx.PrescriptionMedicine.Add(medicine);
ctx.SaveChanges();
}
}
}
public List <string> GetTZ()
{
using (var ctx = new PatientDATA())
{
List <string> TZ = new List <string>();
foreach (var item in ctx.Patient)
{
TZ.Add(item.TZ.ToString());
}
return(TZ);
}
}