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