private void GetViewModelPropertyValues(string accNumber, string examDate)
{
SpeechTabVM spViewModel = (SpeechTabVM)viewmodel;
accNumberCol.Value = accNumber;
dateOfExamCol.Value = examDate;
isTestConductedCol.Value = spViewModel.IsSpeechTestConducted.ToString(CultureInfo.InvariantCulture);
isRtEarTestCol.Value = spViewModel.IsRtEarTest.ToString();
isLtEarTestCol.Value = spViewModel.IsLtEarTest.ToString();
isBltTestCol.Value = spViewModel.IsBilateralTest.ToString();
int0dBCol.Value = spViewModel.Intensity0dB.ToString();
int1dBCol.Value = spViewModel.Intensity1dB.ToString();
int2dBCol.Value = spViewModel.Intensity2dB.ToString();
int3dBCol.Value = spViewModel.Intensity3dB.ToString();
int4dBCol.Value = spViewModel.Intensity4dB.ToString();
int5dBCol.Value = spViewModel.Intensity5dB.ToString();
int6dBCol.Value = spViewModel.Intensity6dB.ToString();
int7dBCol.Value = spViewModel.Intensity7dB.ToString();
int8dBCol.Value = spViewModel.Intensity8dB.ToString();
int9dBCol.Value = spViewModel.Intensity9dB.ToString();
score0Col.Value = spViewModel.Score0.ToString();
score1Col.Value = spViewModel.Score1.ToString();
score2Col.Value = spViewModel.Score2.ToString();
score3Col.Value = spViewModel.Score3.ToString();
score4Col.Value = spViewModel.Score4.ToString();
score5Col.Value = spViewModel.Score5.ToString();
score6Col.Value = spViewModel.Score6.ToString();
score7Col.Value = spViewModel.Score7.ToString();
score8Col.Value = spViewModel.Score8.ToString();
score9Col.Value = spViewModel.Score9.ToString();
srtdBCol.Value = spViewModel.SRTdB.ToString();
sdScoreCol.Value = spViewModel.SDScore.ToString();
sdIntdBCol.Value = spViewModel.SDIntensitydB.ToString();
}
public MainViewModel()
{
tabVMDict = new SortedDictionary <int, TabVM>();
tabVMDict[PatientTabIndex] = new PatientTabVM();
tabVMDict[PureToneTabIndex] = new PureToneTabVM();
tabVMDict[SpeechTabIndex] = new SpeechTabVM();
tabVMDict[ImpedanceTabIndex] = new ImpedanceTabVM();
tabVMDict[BithermalCaloricTabIndex] = new BithermalCaloricTabVM();
TabVMs = new ObservableCollection <TabVM>(tabVMDict.Values);
Patient = (PatientTabVM)tabVMDict[PatientTabIndex];
}
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));
}
}
