public override void OpenRecordFromDatabase(string accNumber, string examDate)
{
TuningForkTestsVM tfViewModel = (TuningForkTestsVM)viewmodel;
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())
{
tfViewModel.IsTestConducted = Convert.ToBoolean(reader.GetString(isTestConductedCol.Index));
tfViewModel.Wbr512RtEar = (TuningForkTypes.Weber)Enum.Parse(typeof(TuningForkTypes.Weber), reader.GetString(wbr512RtEarCol.Index));
tfViewModel.Wbr512LtEar = (TuningForkTypes.Weber)Enum.Parse(typeof(TuningForkTypes.Weber), reader.GetString(wbr512LtEarCol.Index));
tfViewModel.Rn256RtEar = (TuningForkTypes.Rinne)Enum.Parse(typeof(TuningForkTypes.Rinne), reader.GetString(rn256RtEarCol.Index));
tfViewModel.Rn256LtEar = (TuningForkTypes.Rinne)Enum.Parse(typeof(TuningForkTypes.Rinne), reader.GetString(rn256LtEarCol.Index));
tfViewModel.Rn512RtEar = (TuningForkTypes.Rinne)Enum.Parse(typeof(TuningForkTypes.Rinne), reader.GetString(rn512RtEarCol.Index));
tfViewModel.Rn512LtEar = (TuningForkTypes.Rinne)Enum.Parse(typeof(TuningForkTypes.Rinne), reader.GetString(rn512LtEarCol.Index));
tfViewModel.Rn1024RtEar = (TuningForkTypes.Rinne)Enum.Parse(typeof(TuningForkTypes.Rinne), reader.GetString(rn1024RtEarCol.Index));
tfViewModel.Rn1024LtEar = (TuningForkTypes.Rinne)Enum.Parse(typeof(TuningForkTypes.Rinne), reader.GetString(rn1024LtEarCol.Index));
tfViewModel.SwbRtEar = (TuningForkTypes.Schwabach)Enum.Parse(typeof(TuningForkTypes.Schwabach), reader.GetString(swbRtEarCol.Index));
tfViewModel.SwbLtEar = (TuningForkTypes.Schwabach)Enum.Parse(typeof(TuningForkTypes.Schwabach), reader.GetString(swbLtEarCol.Index));
tfViewModel.AbcRtEar = (TuningForkTypes.AbsBoneCond)Enum.Parse(typeof(TuningForkTypes.AbsBoneCond), reader.GetString(abcRtEarCol.Index));
tfViewModel.AbcLtEar = (TuningForkTypes.AbsBoneCond)Enum.Parse(typeof(TuningForkTypes.AbsBoneCond), reader.GetString(abcLtEarCol.Index));
tfViewModel.StgRtEar = (TuningForkTypes.Stenger)Enum.Parse(typeof(TuningForkTypes.Stenger), reader.GetString(stgRtEarCol.Index));
tfViewModel.StgLtEar = (TuningForkTypes.Stenger)Enum.Parse(typeof(TuningForkTypes.Stenger), reader.GetString(stgLtEarCol.Index));
tfViewModel.TlRtEar = (TuningForkTypes.Teal)Enum.Parse(typeof(TuningForkTypes.Teal), reader.GetString(tlRtEarCol.Index));
tfViewModel.TlLtEar = (TuningForkTypes.Teal)Enum.Parse(typeof(TuningForkTypes.Teal), reader.GetString(tlLtEarCol.Index));
tfViewModel.GlRtEar = (TuningForkTypes.Gelle)Enum.Parse(typeof(TuningForkTypes.Gelle), reader.GetString(glRtEarCol.Index));
tfViewModel.GlLtEar = (TuningForkTypes.Gelle)Enum.Parse(typeof(TuningForkTypes.Gelle), reader.GetString(glLtEarCol.Index));
}
}
private void GetViewModelPropertyValues(string accNumber, string examDate)
{
TuningForkTestsVM tfViewModel = (TuningForkTestsVM)viewmodel;
accNumberCol.Value = accNumber;
dateOfExamCol.Value = examDate;
isTestConductedCol.Value = tfViewModel.IsTestConducted.ToString(CultureInfo.InvariantCulture);
wbr512RtEarCol.Value = tfViewModel.Wbr512RtEar.ToString();
wbr512LtEarCol.Value = tfViewModel.Wbr512LtEar.ToString();
rn256RtEarCol.Value = tfViewModel.Rn256RtEar.ToString();
rn256LtEarCol.Value = tfViewModel.Rn256LtEar.ToString();
rn512RtEarCol.Value = tfViewModel.Rn512RtEar.ToString();
rn512LtEarCol.Value = tfViewModel.Rn512LtEar.ToString();
rn1024RtEarCol.Value = tfViewModel.Rn1024RtEar.ToString();
rn1024LtEarCol.Value = tfViewModel.Rn1024LtEar.ToString();
swbRtEarCol.Value = tfViewModel.SwbRtEar.ToString();
swbLtEarCol.Value = tfViewModel.SwbLtEar.ToString();
abcRtEarCol.Value = tfViewModel.AbcRtEar.ToString();
abcLtEarCol.Value = tfViewModel.AbcLtEar.ToString();
stgRtEarCol.Value = tfViewModel.StgRtEar.ToString();
stgLtEarCol.Value = tfViewModel.StgLtEar.ToString();
tlRtEarCol.Value = tfViewModel.TlRtEar.ToString();
tlLtEarCol.Value = tfViewModel.TlLtEar.ToString();
glRtEarCol.Value = tfViewModel.GlRtEar.ToString();
glLtEarCol.Value = tfViewModel.GlLtEar.ToString();
}
public PureToneTabVM()
{
ACMskTabVM = new AirCondMskVM();
ACUmskTabVM = new AirCondUmskVM();
BCMskTabVM = new BoneCondMskVM();
BCUmskTabVM = new BoneCondUmskVM();
ACAidedTabVM = new AirCondAidVM();
LoudnessTabVM = new LoudDiscomLvlVM();
SoundFieldTabVM = new SoundFieldVM();
ptamTabDict = new SortedDictionary <int, PureToneAMTabVM>();
ptamTabDict[ACMskTabIndex] = ACMskTabVM;
ptamTabDict[ACUmskTabIndex] = ACUmskTabVM;
ptamTabDict[BCMskTabIndex] = BCMskTabVM;
ptamTabDict[BCUmskTabIndex] = BCUmskTabVM;
ptamTabDict[ACAidedTabIndex] = ACAidedTabVM;
ptamTabDict[LoudnessTabIndex] = LoudnessTabVM;
ptamTabDict[SoundFieldTabIndex] = SoundFieldTabVM;
PureToneAMTabs = new ObservableCollection <PureToneAMTabVM>(ptamTabDict.Values);
AblbTabVM = new AblbTabVM();
SisiTabVM = new SisiTabVM();
ToneDecayTabVM = new ToneDecayTabVM();
StengerTabVM = new StengerTabVM();
TuningForkVM = new TuningForkTestsVM();
DateOfExam = DateTime.Now;
IsPureToneTestConducted = false;
IsSpecialTestConducted = false;
}