private sbyte mySqlUpdateMedication()
{
DBConnection dbCon = MySqlHelper.dbCon;
ArrayList response = dbCon.selectQuery(
string.Format("SELECT update_medication('{0}', '{1}', '{2}', '{3}')",
MedicationPoolWindow.SelectedMedication.Id,
MySqlFunctions.EscapeString(medicationNameTextBox.Text),
MySqlFunctions.EscapeString(strengthTextBox.Text),
routeComboBox.SelectedIndex.ToString()));
MySqlHelper.disconnect();
if ((sbyte)(response[0] as ArrayList)[0] == 0)
MessageBox.Show("Medication not updated.", "Update Error", MessageBoxButton.OK, MessageBoxImage.Error);
//update selected medication and refresh med pool
else
{
MedicationPoolWindow.SelectedMedication.Name = medicationNameTextBox.Text;
MedicationPoolWindow.SelectedMedication.Strength = strengthTextBox.Text;
MedicationPoolWindow.SelectedMedication.Route = routeComboBox.SelectedIndex;
Medication.refreshMedicationPool();
}
return (sbyte)(response[0] as ArrayList)[0];
}
private long mySqlAddNewMedication()
{
DBConnection dbCon = MySqlHelper.dbCon;
ArrayList response = dbCon.selectQuery(
string.Format("SELECT add_medication('{0}', '{1}', '{2}', '{3}')",
"NULL",
MySqlFunctions.EscapeString(medicationNameTextBox.Text),
MySqlFunctions.EscapeString(strengthTextBox.Text),
routeComboBox.SelectedIndex.ToString()));
MySqlHelper.disconnect();
long newId = (long)(response[0] as ArrayList)[0];
if (newId == 0)
MessageBox.Show("Medication not saved.", "Save Error", MessageBoxButton.OK, MessageBoxImage.Error);
//set selected medication and refresh med pool
else
{
MedicationPoolWindow.SelectedMedication = Medication.fromMySqlMedication(newId);
Medication.refreshMedicationPool();
}
return (long)(response[0] as ArrayList)[0];
}
public MedicationPoolWindow()
{
this.InitializeComponent();
Owner = MainWindow.Instance;
medicationPoolListView.DataContext = Medication.MedicationPool;
Medication.refreshMedicationPool();
this.Closing += MedicationPoolWindow_Closing;
}
private void deleteButton_Click(object sender, RoutedEventArgs e)
{
if (MessageBoxResult.No == MessageBox.Show("Are you sure you want to delete this medication?",
"Confirmation", MessageBoxButton.YesNo,
MessageBoxImage.Warning)) return;
if (MySqlHelper.connect() == false) return;
if (MySqlHelper.dbCon.deleteQuery("DELETE FROM tblMedication WHERE id=" +
(medicationPoolListView.SelectedItem as Medication).Id) == false)
MessageBox.Show("Delete is not possible.\nMedication is referenced by other records in the database.",
"Delete Error", MessageBoxButton.OK, MessageBoxImage.Error);
else Medication.refreshMedicationPool();
MySqlHelper.disconnect();
}
private void newButton_Click(object sender, RoutedEventArgs e)
{
Medication.refreshMedicationPool();
//implicitly sets new mode
MedicationEditorWindow.EmptyInstance.ShowDialog();
}
private void addButton_Click(object sender, RoutedEventArgs e)
{
SelectedDose = null;
Medication.refreshMedicationPool();
MedicationPoolWindow.Instance.ShowDialog();
}
