private void FinishVisitButton_Click(object sender, RoutedEventArgs e)
{
using (var context = new DataBaseContext())
{
PrescriptionList.ForEach(x => context.PrescribedMedications.AddOrUpdate(i => i.Id, x));
context.SaveChanges();
var treatment = new DbTreatment()
{
IllnessName = DiagnosedSicknessTextBox.Text,
SymptomsDescription = SymptomsDescriptionTextBox.Text,
Prescription = PrescriptionList,
Visit = context.Visits.Single(x => x.Id == DataHolderForMainWindow.ChosenVisitId)
};
context.Treatments.AddOrUpdate(x => x.Id, treatment);
context.SaveChanges();
context.TreatmentHistories.Single(x => x.Id == CurrentVisit.TreatmentHistoryId).Treatments.Add(treatment);
context.SaveChanges();
}
}
public static void AddSingleRelationship(DataBaseContext context, DbTreatmentHistory treatmentHistory, DbTreatment treatment)
{
context.TreatmentHistories.SingleOrDefault(th => th.Id == treatmentHistory.Id).Treatments.Add(context.Treatments.SingleOrDefault(t => t.Id == treatment.Id));
}
public static void AddSingleRelationship(DataBaseContext context, DbVisit visit, DbTreatment treatment)
{
context.Treatments.SingleOrDefault(t => t.Id == treatment.Id).Visit = context.Visits.SingleOrDefault(v => v.Id == visit.Id);
}
public static void AddSingleRelationship(DataBaseContext context, DbTreatment treatment, DbPrescribedMedications prescribedMedications)
{
context.Treatments.SingleOrDefault(t => t.Id == treatment.Id).Prescription.Add(context.PrescribedMedications.SingleOrDefault(t => t.Id == treatment.Id));
}
