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