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;
}
private void GetViewModelPropertyValues(string accNumber, string examDate, bool testConducted)
{
ToneDecayTabVM tdViewModel = (ToneDecayTabVM)viewmodel;
accNumberCol.Value = accNumber;
dateOfExamCol.Value = examDate;
isTestConductedCol.Value = testConducted.ToString(CultureInfo.InvariantCulture);
tdRtEarCol.Value = tdViewModel.TdRtEar.ToString();
tdLtEarCol.Value = tdViewModel.TdLtEar.ToString();
}
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 InitializeProperties()
{
ACMskTabVM.InitializeProperties();
ACUmskTabVM.InitializeProperties();
BCMskTabVM.InitializeProperties();
BCUmskTabVM.InitializeProperties();
ACAidedTabVM.InitializeProperties();
LoudnessTabVM.InitializeProperties();
SoundFieldTabVM.InitializeProperties();
IsPureToneTestConducted = false;
AblbTabVM.InitializeProperties();
SisiTabVM.InitializeProperties();
ToneDecayTabVM.InitializeProperties();
StengerTabVM.InitializeProperties();
TuningForkVM.InitializeProperties();
IsSpecialTestConducted = false;
}
public override bool DeleteRecordFromDatabase(string accNumber, string examDate)
{
bool acmskDel = ACMskTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool acumskDel = ACUmskTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool bcmskDel = BCMskTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool bcumskDel = BCUmskTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool acaidDel = ACAidedTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool loudDel = LoudnessTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool soundDel = SoundFieldTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool ablbDel = AblbTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool sisiDel = SisiTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool tonedecayDel = ToneDecayTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool stengerDel = StengerTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool tuningforkDel = TuningForkVM.DeleteRecordFromDatabase(accNumber, examDate);
return(acmskDel || acumskDel || bcmskDel || bcumskDel || acaidDel || loudDel || soundDel ||
ablbDel || sisiDel || tonedecayDel || stengerDel || tuningforkDel);
}
public override void OpenRecordFromDatabase(string accNumber, string examDate)
{
bool ptTestConducted;
bool stTestConducted;
ACMskTabVM.OpenRecordFromDatabase(accNumber, examDate, out ptTestConducted);
ACUmskTabVM.OpenRecordFromDatabase(accNumber, examDate, out ptTestConducted);
BCMskTabVM.OpenRecordFromDatabase(accNumber, examDate, out ptTestConducted);
BCUmskTabVM.OpenRecordFromDatabase(accNumber, examDate, out ptTestConducted);
ACAidedTabVM.OpenRecordFromDatabase(accNumber, examDate, out ptTestConducted);
LoudnessTabVM.OpenRecordFromDatabase(accNumber, examDate, out ptTestConducted);
SoundFieldTabVM.OpenRecordFromDatabase(accNumber, examDate, out ptTestConducted);
IsPureToneTestConducted = ptTestConducted;
AblbTabVM.OpenRecordFromDatabase(accNumber, examDate, out stTestConducted);
SisiTabVM.OpenRecordFromDatabase(accNumber, examDate, out stTestConducted);
ToneDecayTabVM.OpenRecordFromDatabase(accNumber, examDate, out stTestConducted);
StengerTabVM.OpenRecordFromDatabase(accNumber, examDate, out stTestConducted);
TuningForkVM.OpenRecordFromDatabase(accNumber, examDate);
IsSpecialTestConducted = stTestConducted;
}
public override bool UpdateRecordInDatabase(string accNumber, string examDate, out string msg)
{
string error;
bool success = ACMskTabVM.UpdateRecordInDatabase(accNumber, examDate, isPureToneTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = ACUmskTabVM.UpdateRecordInDatabase(accNumber, examDate, isPureToneTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = BCMskTabVM.UpdateRecordInDatabase(accNumber, examDate, isPureToneTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = BCUmskTabVM.UpdateRecordInDatabase(accNumber, examDate, isPureToneTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = ACAidedTabVM.UpdateRecordInDatabase(accNumber, examDate, isPureToneTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = LoudnessTabVM.UpdateRecordInDatabase(accNumber, examDate, isPureToneTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = SoundFieldTabVM.UpdateRecordInDatabase(accNumber, examDate, isPureToneTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = AblbTabVM.UpdateRecordInDatabase(accNumber, examDate, isSpecialTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = SisiTabVM.UpdateRecordInDatabase(accNumber, examDate, isSpecialTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = ToneDecayTabVM.UpdateRecordInDatabase(accNumber, examDate, isSpecialTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = StengerTabVM.UpdateRecordInDatabase(accNumber, examDate, isSpecialTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = TuningForkVM.UpdateRecordInDatabase(accNumber, examDate, out error);
if (!success)
{
msg = error;
return(false);
}
msg = string.Empty;
return(true);
}
