private void btnSave_Click(object sender, EventArgs e) { var note = tbNote.Text; var medication = tbMedication.Text; var entry = tbEntry.Text; if (entry != String.Empty) { if (Treatment != null) // edit handover Treatment { Treatment.Note = tbNote.Text; Treatment.Medication = tbMedication.Text; Treatment.Entry = tbEntry.Text; Treatment.Update(); this.DialogResult = DialogResult.OK; } else // save new Treatment { var treatment = new Model.Treatment(SelectedPatient.Id, DateTime.Now, entry, medication, note); SelectedPatient.Treatments.Add(treatment); this.DialogResult = DialogResult.OK; } this.Close(); } else { MessageBox.Show("Um die Behandlung zu speichern, muss ein Eintrag getätigt werden."); } }
public FrmTreatment(List <Model.Patient> patientList, Model.Treatment treatment) // edit handover treatment { InitializeComponent(); Patients = patientList; Treatment = treatment; foreach (var patient in patientList) { if (patient.Id == treatment.PatientId) { SelectedPatient = patient; break; } } cbPatient.Items.Add(SelectedPatient.Name); cbPatient.SelectedIndex = 0; cbPatient.Enabled = false; tbEntry.Text = treatment.Entry; tbMedication.Text = treatment.Medication; lblDate.Text = treatment.Date.ToString("dd.MM.yyyy"); tbNote.Text = treatment.Note; tbEntry.Enabled = true; tbMedication.Enabled = true; tbNote.Enabled = true; btnSave.Enabled = true; }
public static Patient CreateTestPatient() { var birthday = new DateTime(1999, 6, 18); var patientAddress = new Address("Heinz Peter", 86732, "deutschland", "bobostraße", "1", "elefanthausen", "01768743793", "banana"); var docAddress = new Address("Dr. Olaf Günter", 72722, "deutschland", "tiefstraße", "5", "tiefendorf", "0908287483", "no banana"); var cassAddress = new Address("Aok Hb", 72572, "deutschland", "blubstraße", "52", "blubdorf", "065422483", "maybe banana"); var insuranceAgency = new InsuranceAgency(cassAddress, "definitly banana"); var doctor = new Doctor(docAddress, "Psychologie", "psychisch krank"); var patient = new Patient(birthday, "male", insuranceAgency, 00001, doctor, patientAddress, "master Banana"); var treatment = new Treatment(patient.Id, DateTime.Now, "testentry", "phenylpiracetam", "testnotiz"); patient.Treatments.Add(treatment); return(patient); }
public static int SaveTreatment(Treatment treatment) { var sql = $"INSERT INTO {Fieldnames.Treatments.Tablename}({Fieldnames.Treatments.PatientId}, {Fieldnames.Treatments.Date}, {Fieldnames.Treatments.Entry}, {Fieldnames.Treatments.Medication}, {Fieldnames.Treatments.Note})"; sql += $"VALUES(@{Fieldnames.Treatments.PatientId}, @{Fieldnames.Treatments.Date}, @{Fieldnames.Treatments.Entry}, @{Fieldnames.Treatments.Medication}, @{Fieldnames.Treatments.Note})"; using (var c = new SQLiteConnection(@"Data Source = ..\..\..\..\DB\MYDb.db; Version = 3;")) { c.Open(); using (var command = new SQLiteCommand(sql, c)) { command.Parameters.Add($"@{Fieldnames.Treatments.PatientId}", DbType.Int32).Value = treatment.PatientId; command.Parameters.Add($"@{Fieldnames.Treatments.Date}", DbType.String).Value = Convert.ToString(treatment.Date); command.Parameters.Add($"@{Fieldnames.Treatments.Entry}", DbType.String).Value = treatment.Entry; command.Parameters.Add($"@{Fieldnames.Treatments.Medication}", DbType.String).Value = treatment.Medication; command.Parameters.Add($"@{Fieldnames.Treatments.Note}", DbType.String).Value = treatment.Note; command.ExecuteNonQuery(); command.Parameters.Clear(); command.CommandText = $"SELECT max(Id) FROM {Fieldnames.Treatments.Tablename}"; using (var reader = command.ExecuteReader()) { reader.Read(); var maxId = reader.GetInt32(0); treatment.SetId(maxId); return(maxId); } } } }