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];
}
private void GetViewModelPropertyValues()
{
PatientTabVM ptViewModel = (PatientTabVM)viewmodel;
string symptomsStr = String.Empty;
foreach (Symptom symptom in ptViewModel.Symptoms)
{
if (symptom.IsChecked)
{
symptomsStr += symptom.Description + ",";
}
}
symptomsStr = symptomsStr.TrimEnd(',');
string diagnosesStr = String.Empty;
foreach (Diagnosis disorder in ptViewModel.Diagnoses)
{
if (disorder.IsChecked)
{
diagnosesStr += disorder.Description + ",";
}
}
diagnosesStr = diagnosesStr.TrimEnd(',');
accNumberCol.Value = ptViewModel.AccNumber;
dateOfExamCol.Value = SqliteDateTimeHelper.ToSqliteDateTime(ptViewModel.DateOfExam);
firstNameCol.Value = ptViewModel.FirstName;
middleNameCol.Value = ptViewModel.MiddleName;
lastNameCol.Value = ptViewModel.LastName;
titleCol.Value = ptViewModel.Title;
phoneCol.Value = ptViewModel.Phone;
dependeeNameCol.Value = ptViewModel.DependeeName;
dependeeRelationCol.Value = ptViewModel.DependeeRelation.ToString();
addressCol.Value = ptViewModel.Address;
dateOfBirthCol.Value = SqliteDateTimeHelper.ToSqliteDateTime(ptViewModel.DateOfBirth);
sexCol.Value = ptViewModel.Sex.ToString();
professionCol.Value = ptViewModel.Profession;
hospitalIDCol.Value = ptViewModel.HospitalID;
symptomsCol.Value = symptomsStr;
symptomsRemarksCol.Value = ptViewModel.SymptomsRemarks;
diagnosesCol.Value = diagnosesStr;
diagnosisRemarksCol.Value = ptViewModel.DiagnosisRemarks;
prescriptionCol.Value = ptViewModel.Prescription;
}
public override void OpenRecordFromDatabase(string accNumber, string examDate)
{
string query = "SELECT * FROM " + patientTable + " WHERE AccNumber = '" + accNumber +
"' AND DateOfExam = '" + examDate + "'";
SQLiteCommand readCmd = new SQLiteCommand(query, DatabaseInfo.SqliteCon);
SQLiteDataReader reader = readCmd.ExecuteReader();
reader.Read();
PatientTabVM ptViewModel = (PatientTabVM)viewmodel;
ptViewModel.AccNumber = reader.GetInt32(accNumberCol.Index).ToString(CultureInfo.InvariantCulture);
ptViewModel.DateOfExam = Convert.ToDateTime(reader.GetString(dateOfExamCol.Index), CultureInfo.InvariantCulture);
ptViewModel.FirstName = reader.GetString(firstNameCol.Index);
ptViewModel.MiddleName = reader.GetString(middleNameCol.Index);
ptViewModel.LastName = reader.GetString(lastNameCol.Index);
ptViewModel.Title = reader.GetString(titleCol.Index);
ptViewModel.Phone = reader.GetString(phoneCol.Index);
ptViewModel.DependeeName = reader.GetString(dependeeNameCol.Index);
ptViewModel.DependeeRelation = (RelationType)Enum.Parse(typeof(RelationType), reader.GetString(dependeeRelationCol.Index));
ptViewModel.Address = reader.GetString(addressCol.Index);
ptViewModel.DateOfBirth = Convert.ToDateTime(reader.GetString(dateOfBirthCol.Index), CultureInfo.InvariantCulture);
ptViewModel.Sex = (SexType)Enum.Parse(typeof(SexType), reader.GetString(sexCol.Index));
ptViewModel.Profession = reader.GetString(professionCol.Index);
ptViewModel.HospitalID = reader.GetString(hospitalIDCol.Index);
IList <Symptom> symList = ptViewModel.CreateUncheckedSymptomsList();
string symStr = reader.GetString(symptomsCol.Index);
string[] symArr = symStr.Split(',').Select(sym => sym.Trim()).ToArray();
foreach (string sym in symArr)
{
Symptom found = symList.FirstOrDefault(x => x.Description.Equals(sym));
if (found != null)
{
found.IsChecked = true;
}
}
ptViewModel.Symptoms = symList;
ptViewModel.SymptomsRemarks = reader.GetString(symptomsRemarksCol.Index);
IList <Diagnosis> diagList = ptViewModel.CreateUncheckedDiagnosisList();
string diagStr = reader.GetString(diagnosesCol.Index);
string[] diagArr = diagStr.Split(',').Select(diag => diag.Trim()).ToArray();
foreach (string diag in diagArr)
{
Diagnosis found = diagList.FirstOrDefault(x => x.Description.Equals(diag));
if (found != null)
{
found.IsChecked = true;
}
}
ptViewModel.Diagnoses = diagList;
ptViewModel.DiagnosisRemarks = reader.GetString(diagnosisRemarksCol.Index);
ptViewModel.Prescription = reader.GetString(prescriptionCol.Index);
}
