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 static MedicationAdminstrationRecord fromArrayList(ArrayList arrayList)
{
MedicationAdminstrationRecord mar = new MedicationAdminstrationRecord();
Medication med = null;
MedicationDose dose = new MedicationDose();
Patient pat = new Patient();
//---keys
med = Medication.fromMySqlMedication((long)arrayList[0]);
pat.ParentSimulation = Simulation.fromMySql((long)arrayList[1]);
pat.Id = (long)arrayList[2];
//---unique fields
mar.Initials = (string)arrayList[3];
//mar.AdministrationTime = null;
/*if (arrayList[4].GetType() != typeof(DBNull))*/ mar.AdministrationTime = (DateTime)arrayList[4];
mar.ReasonCode = (sbyte)arrayList[5];
mar.AdministrationNotes = (string)arrayList[6];
mar.ReasonNotes = (string)arrayList[7];
//patient pool field
pat.AdmissionDate = (DateTime)arrayList[8];
//---patient duplication
pat.Name = (string)arrayList[9];
pat.DateOfBirth = (DateTime)arrayList[10];
pat.Allergies = (string)arrayList[11];
pat.Diagnosis = (string)arrayList[12];
pat.DrName = (string)arrayList[13];
pat.Diet = (string)arrayList[14];
pat.RoomNumber = (string)arrayList[15];
pat.Weight = (short)arrayList[16];
pat.Gender = ((string)arrayList[17]) == "MALE" ? PatientGender.Male : PatientGender.Female;
pat.Notes = (string)arrayList[18];
//---medication dose duplication
dose.InjectionSite = (sbyte)arrayList[19];
dose.Schedule = (string)arrayList[20];
dose.TimePeriod = (DateTime)arrayList[21];
dose.StartTime = (DateTime)arrayList[22];
dose.Id = (long)arrayList[23];
dose.ForMedication = med;
mar.ForDose = dose;
mar.ForPatient = pat;
return mar;
} //End fromArrayList()
public static MedicationDose fromArrayList(ArrayList arrayList)
{
MedicationDose dose = new MedicationDose();
dose.Id = (long)arrayList[0];
dose.ForMedication = Medication.fromMySqlMedication((long)arrayList[1]);
dose.ForPatient = Patient.fromMySqlPatient((long)arrayList[2]);
dose.InjectionSite = (sbyte)arrayList[3];
dose.Schedule = (string)arrayList[4];
dose.TimePeriod = (DateTime)arrayList[5];
dose.StartTime = (DateTime)arrayList[6];
dose.StopTime = null;
if(arrayList[7].GetType() != typeof(DBNull)) dose.StopTime = (DateTime)arrayList[6];
return dose;
}
