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