public override void OpenRecordFromDatabase(string accNumber, string examDate)
{
string query = "SELECT * FROM " + dbTable + " WHERE AccNumber = '" + accNumber +
"' AND DateOfExam = '" + examDate + "'";
SQLiteCommand readCmd = new SQLiteCommand(query, DatabaseInfo.SqliteCon);
SQLiteDataReader reader = readCmd.ExecuteReader();
if (reader.Read())
{
BithermalCaloricTabVM bcViewModel = (BithermalCaloricTabVM)viewmodel;
bcViewModel.IsCaloricTestConducted = Convert.ToBoolean(reader.GetString(isTestConductedCol.Index));
bcViewModel.IsAirTest = Convert.ToBoolean(reader.GetString(isAirTestCol.Index));
bcViewModel.IsWaterTest = Convert.ToBoolean(reader.GetString(isWaterTestCol.Index));
bcViewModel.NysStartMin30RtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(nysStartMin30RtEarCol.Index));
bcViewModel.NysStartSec30RtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(nysStartSec30RtEarCol.Index));
bcViewModel.NysEndMin30RtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(nysEndMin30RtEarCol.Index));
bcViewModel.NysEndSec30RtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(nysEndSec30RtEarCol.Index));
bcViewModel.NysStartMin30LtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(nysStartMin30LtEarCol.Index));
bcViewModel.NysStartSec30LtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(nysStartSec30LtEarCol.Index));
bcViewModel.NysEndMin30LtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(nysEndMin30LtEarCol.Index));
bcViewModel.NysEndSec30LtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(nysEndSec30LtEarCol.Index));
bcViewModel.NysStartMin44RtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(nysStartMin44RtEarCol.Index));
bcViewModel.NysStartSec44RtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(nysStartSec44RtEarCol.Index));
bcViewModel.NysEndMin44RtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(nysEndMin44RtEarCol.Index));
bcViewModel.NysEndSec44RtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(nysEndSec44RtEarCol.Index));
bcViewModel.NysStartMin44LtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(nysStartMin44LtEarCol.Index));
bcViewModel.NysStartSec44LtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(nysStartSec44LtEarCol.Index));
bcViewModel.NysEndMin44LtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(nysEndMin44LtEarCol.Index));
bcViewModel.NysEndSec44LtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(nysEndSec44LtEarCol.Index));
bcViewModel.CanalParesis = NullDoubleHelper.ToNullableDouble(reader.GetString(canalParesisCol.Index));
bcViewModel.DirPrepond = NullDoubleHelper.ToNullableDouble(reader.GetString(dirPrepondCol.Index));
}
}
public override void OpenRecordFromDatabase(string accNumber, string examDate)
{
string query = "SELECT * FROM " + dbTable + " WHERE AccNumber = '" + accNumber +
"' AND DateOfExam = '" + examDate + "'";
SQLiteCommand readCmd = new SQLiteCommand(query, DatabaseInfo.SqliteCon);
SQLiteDataReader reader = readCmd.ExecuteReader();
if (reader.Read())
{
ImpedanceTabVM impViewModel = (ImpedanceTabVM)viewmodel;
impViewModel.IsImpedanceTestConducted = Convert.ToBoolean(reader.GetString(isTestConductedCol.Index));
impViewModel.RtEarComplianceNeg400daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(compNeg400RtEarCol.Index));
impViewModel.LtEarComplianceNeg400daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(compNeg400LtEarCol.Index));
impViewModel.RtEarComplianceNeg300daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(compNeg300RtEarCol.Index));
impViewModel.LtEarComplianceNeg300daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(compNeg300LtEarCol.Index));
impViewModel.RtEarComplianceNeg200daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(compNeg200RtEarCol.Index));
impViewModel.LtEarComplianceNeg200daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(compNeg200LtEarCol.Index));
impViewModel.RtEarComplianceNeg100daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(compNeg100RtEarCol.Index));
impViewModel.LtEarComplianceNeg100daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(compNeg100LtEarCol.Index));
impViewModel.RtEarCompliance0daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(comp0RtEarCol.Index));
impViewModel.LtEarCompliance0daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(comp0LtEarCol.Index));
impViewModel.RtEarCompliance100daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(comp100RtEarCol.Index));
impViewModel.LtEarCompliance100daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(comp100LtEarCol.Index));
impViewModel.RtEarCompliance200daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(comp200RtEarCol.Index));
impViewModel.LtEarCompliance200daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(comp200LtEarCol.Index));
impViewModel.RtEarCompliance300daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(comp300RtEarCol.Index));
impViewModel.LtEarCompliance300daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(comp300LtEarCol.Index));
impViewModel.RtEarCompliance400daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(comp400RtEarCol.Index));
impViewModel.LtEarCompliance400daPa = NullDoubleHelper.ToNullableDouble(reader.GetString(comp400LtEarCol.Index));
impViewModel.RtEarPeakPressure = NullDoubleHelper.ToNullableDouble(reader.GetString(peakPresRtEarCol.Index));
impViewModel.LtEarPeakPressure = NullDoubleHelper.ToNullableDouble(reader.GetString(peakPresLtEarCol.Index));
impViewModel.RtEarCanalVolume = NullDoubleHelper.ToNullableDouble(reader.GetString(earCnlVolRtEarCol.Index));
impViewModel.LtEarCanalVolume = NullDoubleHelper.ToNullableDouble(reader.GetString(earCnlVolLtEarCol.Index));
impViewModel.RtEarCurveType = (ImpedanceTabVM.TympanogramType)Enum.Parse(typeof(ImpedanceTabVM.TympanogramType), reader.GetString(curveRtEarCol.Index));
impViewModel.LtEarCurveType = (ImpedanceTabVM.TympanogramType)Enum.Parse(typeof(ImpedanceTabVM.TympanogramType), reader.GetString(curveLtEarCol.Index));
impViewModel.RtEarAcousticReflex500Hz = (ImpedanceTabVM.AcousticReflexType)Enum.Parse(typeof(ImpedanceTabVM.AcousticReflexType), reader.GetString(acRf500RtEarCol.Index));
impViewModel.LtEarAcousticReflex500Hz = (ImpedanceTabVM.AcousticReflexType)Enum.Parse(typeof(ImpedanceTabVM.AcousticReflexType), reader.GetString(acRf500LtEarCol.Index));
impViewModel.RtEarAcousticReflex1000Hz = (ImpedanceTabVM.AcousticReflexType)Enum.Parse(typeof(ImpedanceTabVM.AcousticReflexType), reader.GetString(acRf1000RtEarCol.Index));
impViewModel.LtEarAcousticReflex1000Hz = (ImpedanceTabVM.AcousticReflexType)Enum.Parse(typeof(ImpedanceTabVM.AcousticReflexType), reader.GetString(acRf1000LtEarCol.Index));
impViewModel.RtEarAcousticReflex2000Hz = (ImpedanceTabVM.AcousticReflexType)Enum.Parse(typeof(ImpedanceTabVM.AcousticReflexType), reader.GetString(acRf2000RtEarCol.Index));
impViewModel.LtEarAcousticReflex2000Hz = (ImpedanceTabVM.AcousticReflexType)Enum.Parse(typeof(ImpedanceTabVM.AcousticReflexType), reader.GetString(acRf2000LtEarCol.Index));
impViewModel.RtEarAcousticReflex4000Hz = (ImpedanceTabVM.AcousticReflexType)Enum.Parse(typeof(ImpedanceTabVM.AcousticReflexType), reader.GetString(acRf4000RtEarCol.Index));
impViewModel.LtEarAcousticReflex4000Hz = (ImpedanceTabVM.AcousticReflexType)Enum.Parse(typeof(ImpedanceTabVM.AcousticReflexType), reader.GetString(acRf4000LtEarCol.Index));
}
}
public override void OpenRecordFromDatabase(string accNumber, string examDate, out bool testConducted)
{
string query = "SELECT * FROM " + dbTable + " WHERE AccNumber = '" + accNumber +
"' AND DateOfExam = '" + examDate + "'";
SQLiteCommand readCmd = new SQLiteCommand(query, DatabaseInfo.SqliteCon);
SQLiteDataReader reader = readCmd.ExecuteReader();
testConducted = false;
if (reader.Read())
{
ToneDecayTabVM tdViewModel = (ToneDecayTabVM)viewmodel;
testConducted = Convert.ToBoolean(reader.GetString(isTestConductedCol.Index));
tdViewModel.TdRtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(tdRtEarCol.Index));
tdViewModel.TdLtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(tdLtEarCol.Index));
}
}
public override void OpenRecordFromDatabase(string accNumber, string examDate)
{
string query = "SELECT * FROM " + dbTable + " WHERE AccNumber = '" + accNumber +
"' AND DateOfExam = '" + examDate + "'";
SQLiteCommand readCmd = new SQLiteCommand(query, DatabaseInfo.SqliteCon);
SQLiteDataReader reader = readCmd.ExecuteReader();
if (reader.Read())
{
SpeechTabVM spViewModel = (SpeechTabVM)viewmodel;
spViewModel.IsSpeechTestConducted = Convert.ToBoolean(reader.GetString(isTestConductedCol.Index));
spViewModel.IsRtEarTest = Convert.ToBoolean(reader.GetString(isRtEarTestCol.Index));
spViewModel.IsLtEarTest = Convert.ToBoolean(reader.GetString(isLtEarTestCol.Index));
spViewModel.IsBilateralTest = Convert.ToBoolean(reader.GetString(isBltTestCol.Index));
spViewModel.Intensity0dB = NullDoubleHelper.ToNullableDouble(reader.GetString(int0dBCol.Index));
spViewModel.Intensity1dB = NullDoubleHelper.ToNullableDouble(reader.GetString(int1dBCol.Index));
spViewModel.Intensity2dB = NullDoubleHelper.ToNullableDouble(reader.GetString(int2dBCol.Index));
spViewModel.Intensity3dB = NullDoubleHelper.ToNullableDouble(reader.GetString(int3dBCol.Index));
spViewModel.Intensity4dB = NullDoubleHelper.ToNullableDouble(reader.GetString(int4dBCol.Index));
spViewModel.Intensity5dB = NullDoubleHelper.ToNullableDouble(reader.GetString(int5dBCol.Index));
spViewModel.Intensity6dB = NullDoubleHelper.ToNullableDouble(reader.GetString(int6dBCol.Index));
spViewModel.Intensity7dB = NullDoubleHelper.ToNullableDouble(reader.GetString(int7dBCol.Index));
spViewModel.Intensity8dB = NullDoubleHelper.ToNullableDouble(reader.GetString(int8dBCol.Index));
spViewModel.Intensity9dB = NullDoubleHelper.ToNullableDouble(reader.GetString(int9dBCol.Index));
spViewModel.Score0 = NullDoubleHelper.ToNullableDouble(reader.GetString(score0Col.Index));
spViewModel.Score1 = NullDoubleHelper.ToNullableDouble(reader.GetString(score1Col.Index));
spViewModel.Score2 = NullDoubleHelper.ToNullableDouble(reader.GetString(score2Col.Index));
spViewModel.Score3 = NullDoubleHelper.ToNullableDouble(reader.GetString(score3Col.Index));
spViewModel.Score4 = NullDoubleHelper.ToNullableDouble(reader.GetString(score4Col.Index));
spViewModel.Score5 = NullDoubleHelper.ToNullableDouble(reader.GetString(score5Col.Index));
spViewModel.Score6 = NullDoubleHelper.ToNullableDouble(reader.GetString(score6Col.Index));
spViewModel.Score7 = NullDoubleHelper.ToNullableDouble(reader.GetString(score7Col.Index));
spViewModel.Score8 = NullDoubleHelper.ToNullableDouble(reader.GetString(score8Col.Index));
spViewModel.Score9 = NullDoubleHelper.ToNullableDouble(reader.GetString(score9Col.Index));
spViewModel.SRTdB = NullDoubleHelper.ToNullableDouble(reader.GetString(srtdBCol.Index));
spViewModel.SDScore = NullDoubleHelper.ToNullableDouble(reader.GetString(sdScoreCol.Index));
spViewModel.SDIntensitydB = NullDoubleHelper.ToNullableDouble(reader.GetString(sdIntdBCol.Index));
}
}
public override void OpenRecordFromDatabase(string accNumber, string examDate, out bool testConducted)
{
base.OpenRecordFromDatabase(accNumber, examDate, out testConducted);
string query = "SELECT * FROM " + disabilityTable + " WHERE AccNumber = '" + accNumber +
"' AND DateOfExam = '" + examDate + "'";
SQLiteCommand readCmd = new SQLiteCommand(query, DatabaseInfo.SqliteCon);
SQLiteDataReader reader = readCmd.ExecuteReader();
testConducted = false;
if (reader.Read())
{
AirCondUmskData acUmskDataVM = (AirCondUmskData)viewmodel;
testConducted = Convert.ToBoolean(reader.GetString(isTestConductedCol.Index));
acUmskDataVM.AvgSpPerRtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(avgSpPerRtEarCol.Index));
acUmskDataVM.ImpairRtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(impairRtEarCol.Index));
acUmskDataVM.AvgSpPerLtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(avgSpPerLtEarCol.Index));
acUmskDataVM.ImpairLtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(impairLtEarCol.Index));
acUmskDataVM.Disability = NullDoubleHelper.ToNullableDouble(reader.GetString(disabilityCol.Index));
}
}
public override void OpenRecordFromDatabase(string accNumber, string examDate, out bool testConducted)
{
string query = "SELECT * FROM " + dbTable + " WHERE AccNumber = '" + accNumber +
"' AND DateOfExam = '" + examDate + "'";
SQLiteCommand readCmd = new SQLiteCommand(query, DatabaseInfo.SqliteCon);
SQLiteDataReader reader = readCmd.ExecuteReader();
testConducted = false;
if (reader.Read())
{
AblbTabVM ablbViewModel = (AblbTabVM)viewmodel;
testConducted = Convert.ToBoolean(reader.GetString(isTestConductedCol.Index));
ablbViewModel.RightEar0 = NullDoubleHelper.ToNullableDouble(reader.GetString(re0Col.Index));
ablbViewModel.RightEar1 = NullDoubleHelper.ToNullableDouble(reader.GetString(re1Col.Index));
ablbViewModel.RightEar2 = NullDoubleHelper.ToNullableDouble(reader.GetString(re2Col.Index));
ablbViewModel.RightEar3 = NullDoubleHelper.ToNullableDouble(reader.GetString(re3Col.Index));
ablbViewModel.RightEar4 = NullDoubleHelper.ToNullableDouble(reader.GetString(re4Col.Index));
ablbViewModel.RightEar5 = NullDoubleHelper.ToNullableDouble(reader.GetString(re5Col.Index));
ablbViewModel.RightEar6 = NullDoubleHelper.ToNullableDouble(reader.GetString(re6Col.Index));
ablbViewModel.RightEar7 = NullDoubleHelper.ToNullableDouble(reader.GetString(re7Col.Index));
ablbViewModel.RightEar8 = NullDoubleHelper.ToNullableDouble(reader.GetString(re8Col.Index));
ablbViewModel.RightEar9 = NullDoubleHelper.ToNullableDouble(reader.GetString(re9Col.Index));
ablbViewModel.LeftEar0 = NullDoubleHelper.ToNullableDouble(reader.GetString(le0Col.Index));
ablbViewModel.LeftEar1 = NullDoubleHelper.ToNullableDouble(reader.GetString(le1Col.Index));
ablbViewModel.LeftEar2 = NullDoubleHelper.ToNullableDouble(reader.GetString(le2Col.Index));
ablbViewModel.LeftEar3 = NullDoubleHelper.ToNullableDouble(reader.GetString(le3Col.Index));
ablbViewModel.LeftEar4 = NullDoubleHelper.ToNullableDouble(reader.GetString(le4Col.Index));
ablbViewModel.LeftEar5 = NullDoubleHelper.ToNullableDouble(reader.GetString(le5Col.Index));
ablbViewModel.LeftEar6 = NullDoubleHelper.ToNullableDouble(reader.GetString(le6Col.Index));
ablbViewModel.LeftEar7 = NullDoubleHelper.ToNullableDouble(reader.GetString(le7Col.Index));
ablbViewModel.LeftEar8 = NullDoubleHelper.ToNullableDouble(reader.GetString(le8Col.Index));
ablbViewModel.LeftEar9 = NullDoubleHelper.ToNullableDouble(reader.GetString(le9Col.Index));
}
}
