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