private sbyte mySqlUpdatePatient()
{
DBConnection dbCon = MySqlHelper.dbCon;
Patient pat = PatientPoolControl.SelectedPatient;
if (pat == null) return 0;
ArrayList response = dbCon.selectQuery(
string.Format("SELECT update_patient({10}, '{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', {7}, '{8}', '{9}')",
MySqlFunctions.EscapeString(patientNameTextBox.Text),
pat.DateOfBirth.ToString("yyyy-MM-dd HH:mm:ss"),
MySqlFunctions.EscapeString(allergiesTextBox.Text),
MySqlFunctions.EscapeString(diagnosisTextBox.Text),
MySqlFunctions.EscapeString(drNameTextBox.Text),
MySqlFunctions.EscapeString(dietTextBox.Text),
MySqlFunctions.EscapeString(roomNumberTextBox.Text),
MySqlFunctions.EscapeString(weightTextBox.Text),
optMale.IsChecked == true ? "MALE" : "FEMALE",
MySqlFunctions.EscapeString(notesTextBox.Text),
pat.Id)
);
MySqlHelper.disconnect();
sbyte result = (sbyte)(response[0] as ArrayList)[0];
if (result == 0)
MessageBox.Show("Patient not updated.", "Update Error", MessageBoxButton.OK, MessageBoxImage.Error);
else Patient.refreshPatients();
return result;
}
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 mySqlAddNewPatient()
{
DBConnection dbCon = MySqlHelper.dbCon;
ArrayList response = dbCon.selectQuery(
string.Format("SELECT add_patient({10}, '{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', {7}, '{8}', '{9}')",
MySqlFunctions.EscapeString(patientNameTextBox.Text),
MySqlFunctions.EscapeString(((DateTime)dobDatePicker.SelectedDate).ToString("yyyy-MM-dd HH:mm:ss")),
MySqlFunctions.EscapeString(allergiesTextBox.Text),
MySqlFunctions.EscapeString(diagnosisTextBox.Text),
MySqlFunctions.EscapeString(drNameTextBox.Text),
MySqlFunctions.EscapeString(dietTextBox.Text),
MySqlFunctions.EscapeString(roomNumberTextBox.Text),
MySqlFunctions.EscapeString(weightTextBox.Text),
optMale.IsChecked == true ? "MALE" : "FEMALE",
MySqlFunctions.EscapeString(notesTextBox.Text),
autoIdCheckBox.IsChecked == true ? "NULL" : mrIdTextBox.Text.Substring(2)));
MySqlHelper.disconnect();
if ((long)(response[0] as ArrayList)[0] == -1)
MessageBox.Show(string.Format("The Medical Record Number {0} is not unique.\nPlease use a unique number.\nPatient not saved.",
mrIdTextBox.Text),
"Save Error", MessageBoxButton.OK, MessageBoxImage.Error);
if ((long)(response[0] as ArrayList)[0] == 0)
MessageBox.Show("Patient not saved.", "Save Error", MessageBoxButton.OK, MessageBoxImage.Error);
else Patient.refreshPatients();
return (long)(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];
}
protected void CheckErrorMessage(TestPriceItem priceItem, string etalonMessage)
{
var query = String.Format(@"select ShortErrorMessage from `logs`.downlogs where PriceItemId = {0}", priceItem.Id);
var message = String.Empty;
With.Connection(connection => { message = MySqlHelper.ExecuteScalar(connection, query).ToString(); });
Assert.That(message.Contains(etalonMessage), Is.True);
}
protected void CheckDownloadedFile()
{
var querySelectDownlogId = String.Format(@"select count(RowId) from `logs`.downlogs where PriceItemId = {0}", priceItem.Id);
var countDownlogId = 0;
With.Connection(connection => { countDownlogId = Convert.ToInt32(MySqlHelper.ExecuteScalar(connection, querySelectDownlogId)); });
Assert.That(countDownlogId, Is.EqualTo(1));
}
private void mySqlAddNewSimulation()
{
DBConnection dbCon = MySqlHelper.dbCon;
ArrayList response = dbCon.selectQuery(string.Format("SELECT add_simulation(NULL, '{0}', '{1}', NULL, 0, '{2}')",
MySqlFunctions.EscapeString(simulationNameTextBox.Text),
MySqlFunctions.EscapeString(simulationDescriptionTextBox.Text),
MySqlFunctions.EscapeString(MainWindow.CurrentUser.Username)));
MySqlHelper.disconnect();
if ((long)(response[0] as ArrayList)[0] == 0)
MessageBox.Show("Simulation not saved.", "Save Error", MessageBoxButton.OK, MessageBoxImage.Error);
else Simulation.refreshSimulations();
}
private void mySqlAddNewUserAccount()
{
DBConnection dbCon = MySqlHelper.dbCon;
ArrayList response = dbCon.selectQuery(string.Format("SELECT add_user_account(NULL, '{0}', '{1}', {2}, '{3}', '{4}', {5}, NULL, '{6}')",
MySqlFunctions.EscapeString(usernameTextBox.Text),
MySqlFunctions.EscapeString(passwordBox.SecurePassword.convertToUnsecureString()),
optAdministrator.IsChecked == true ? 0 : 1,
MySqlFunctions.EscapeString(fullnameTextBox.Text),
MySqlFunctions.EscapeString(notesTextBox.Text),
0,
MainWindow.CurrentUser.Username));
MySqlHelper.disconnect();
if ((long)(response[0] as ArrayList)[0] == 0)
MessageBox.Show("UserAccount not saved.", "Save Error", MessageBoxButton.OK, MessageBoxImage.Error);
else Simulation.refreshSimulations();
}
public void FtpChangePassiveModeTest()
{
source.PricePath = "217.173.73.200";
source.PriceMask = "price.rar";
source.ExtrMask = "price*.dbf";
source.FtpLogin = "******";
source.FtpPassword = "******";
source.FtpDir = "price";
source.Save();
Process();
var sql = String.Format(@"select count(*) from `logs`.downlogs where PriceItemId = {0}", priceItem);
var count = 0;
With.Connection(connection => count = Convert.ToInt32(MySqlHelper.ExecuteScalar(connection, sql)));
var files = Directory.GetFiles(Settings.Default.InboundPath);
Assert.That(count, Is.EqualTo(1));
}
private void mySqlAddNewMar()
{
DBConnection dbCon = MySqlHelper.dbCon;
ArrayList response = dbCon.selectQuery(
string.Format("SELECT add_mar({0}, {1}, {2}, '{3}', '{4}', {5}, '{6}', '{7}', {8})",
Mar.ForDose.Id,
Mar.ForPatient.ParentSimulation.Id,
Mar.ForPatient.Id,
MySqlFunctions.EscapeString(Mar.Initials),
Mar.AdministrationTime.ToString("yyyy-MM-dd HH:mm:ss"),
Mar.ReasonCode,
MySqlFunctions.EscapeString(Mar.AdministrationNotes),
MySqlFunctions.EscapeString(Mar.ReasonNotes),
Mar.ForDose.InjectionSite));
MySqlHelper.disconnect();
MedicationAdminstrationRecord.refreshRecords(Mar.ForPatient.Id, DateTime.Today);
}
private void mySqlUpdateSimulation()
{
DBConnection dbCon = MySqlHelper.dbCon;
Simulation sim = SimulationPoolControl.SelectedSimulation;
if (sim == null) return;
ArrayList response = dbCon.selectQuery(string.Format("SELECT update_simulation({0}, '{1}', '{2}', '{3}', {4}, '{5}')",
sim.Id,
MySqlFunctions.EscapeString(simulationNameTextBox.Text),
MySqlFunctions.EscapeString(simulationDescriptionTextBox.Text),
sim.CreationDate.ToString("yyyy-MM-dd HH:mm:ss"),
sim.IsDeleted ? 1 : 0,
MySqlFunctions.EscapeString(sim.Creator)));
MySqlHelper.disconnect();
if ((sbyte)(response[0] as ArrayList)[0] == 0)
MessageBox.Show("Simulation not Update.", "Update Error", MessageBoxButton.OK, MessageBoxImage.Error);
else Simulation.refreshSimulations();
}
private void mySqlUpdateUserAccount()
{
DBConnection dbCon = MySqlHelper.dbCon;
UserAccount ua = AccountPoolControl.SelectedUserAccount;
if (ua == null) return;
ArrayList response = dbCon.selectQuery(string.Format("SELECT add_user_account(NULL, '{0}', '{1}', {2}, '{3}', '{4}', {5}, '{6}', '{7}')",
MySqlFunctions.EscapeString(usernameTextBox.Text),
MySqlFunctions.EscapeString(passwordBox.SecurePassword.convertToUnsecureString()),
optAdministrator.IsChecked == true ? 0 : 1,
MySqlFunctions.EscapeString(fullnameTextBox.Text),
MySqlFunctions.EscapeString(notesTextBox.Text),
0,
string.Empty,
MainWindow.CurrentUser.Username));
MySqlHelper.disconnect();
if ((sbyte)(response[0] as ArrayList)[0] == 0)
MessageBox.Show("UserAccount not Update.", "Update Error", MessageBoxButton.OK, MessageBoxImage.Error);
else Simulation.refreshSimulations();
}
