public List <PatientQue> addVisit(PatientQue patientQue)
{
using (IDbConnection cnn = new SQLiteConnection(AppSettings.connectionString)) {
var output = cnn.Query <PatientQue>(
$"INSERT INTO visits (patient_id,doctor_id,date,disease) " +
$"VALUES (@patient_id,@doctor_id,@date,@disease)", patientQue);
return(output.ToList());
}
}
private void MedicalVisitButton_Click(object sender, RoutedEventArgs e)
{
Logger.debug(QueGrid.Items.Count.ToString());
if (DoctorsComboBox.SelectedItem == null)
{
Error.show("Błąd", "Proszę wskazać lekarza");
return;
}
if (DiseaseTextBox.Text == "")
{
Error.show("Błąd", "Proszę wskazać chorobę");
return;
}
Logger.debug(VisitDate.SelectedDate.ToString());
// Sprawdź datę
if (!VisitDate.SelectedDate.HasValue)
{
Error.show("Błąd", "Proszę wskazać datę");
return;
}
else
{
if (VisitDate.SelectedDate < DateTime.Now)
{
Error.show("Błąd", "Data nie może być wcześniejsza niż jutro");
return;
}
}
var docName = DoctorsComboBox.SelectedValue.ToString().Split('-')[0].Trim();
var docSpec = DoctorsComboBox.SelectedValue.ToString().Split('-')[1].Trim();
var doctor = vm.getDoctorByNameAndSpec(docName, docSpec);
// Aktualizuj Baze danych
var visit = new PatientQue()
{
date = VisitDate.SelectedDate.ToString(),
disease = DiseaseTextBox.Text,
doctor_id = doctor.doctor_id,
patient_id = UserCache.currentPatient.patient_id
};
vm.addVisit(visit);
// Aktualizuj UI
QueGrid.Items.Add(visit);
}
