///////////////////This are the methods used to update the display immideately after updating
private async Task <bool> UpdateDiseaseData(BasicDiseases tempDisease)
{
docKitName.Text = tempDisease.Name;
docKitDescription.Text = "\n" + tempDisease.Description;
docKitImage.Source = await ImageMethods.Base64StringToBitmap(tempDisease.Image);
docKitSymptomsPanel.Children.Clear();
foreach (var i in tempDisease.Symptoms.Split(','))
{
if (i.Equals(""))
{
continue;
}
StackPanel docKitSymptomsStackPanels = new StackPanel();
docKitSymptomsStackPanels.Margin = new Thickness(0, 15, 0, 0);
docKitSymptomsStackPanels.Orientation = Orientation.Horizontal;
TextBlock dot = new TextBlock();
dot.Width = 15;
dot.FontSize = 20;
dot.Text = "•";
docKitSymptomsStackPanels.Children.Add(dot);
TextBlock Symptom = new TextBlock();
Symptom.Width = 650;
Symptom.Text = ExtraModules.RemoveStringSpace(i).Replace(",", "");
Symptom.TextWrapping = TextWrapping.Wrap;
Symptom.FontSize = 20;
docKitSymptomsStackPanels.Children.Add(Symptom);
docKitSymptomsPanel.Children.Add(docKitSymptomsStackPanels);
}
return(true);
}
private async void UpdateEditedDetails()
{
if (VisitListBox.SelectedItem != null)
{
try
{
string query = "SELECT * FROM MedicalDetails WHERE PID = @pid AND DateVisited = @dv";
Statement statement = await this.database.PrepareStatementAsync(query);
statement.BindTextParameterWithName("@pid", this.PID);
statement.BindTextParameterWithName("@dv", VisitListBox.Items[VisitListBox.SelectedIndex].ToString());
statement.EnableColumnsProperty();
if (await statement.StepAsync())
{
VisitSymptomsPanel.Children.Clear();
foreach (string str in statement.Columns["Symptoms"].Split(','))
{
StackPanel VisitSymptomsStackPanels = new StackPanel();
VisitSymptomsStackPanels.Margin = new Thickness(0, 15, 0, 0);
VisitSymptomsStackPanels.Orientation = Orientation.Horizontal;
TextBlock dot = new TextBlock();
dot.Width = 10;
dot.FontSize = 15;
dot.Text = "•";
VisitSymptomsStackPanels.Children.Add(dot);
TextBlock vaccineName = new TextBlock();
vaccineName.Width = 280;
vaccineName.Text = ExtraModules.RemoveExtraCommas(ExtraModules.RemoveStringSpace(str));
vaccineName.TextWrapping = TextWrapping.Wrap;
vaccineName.FontSize = 15;
VisitSymptomsStackPanels.Children.Add(vaccineName);
VisitSymptomsPanel.Children.Add(VisitSymptomsStackPanels);
}
VisitTextDisease.Text = "\n" + statement.Columns["DiseaseFound"];
VisitTextBG.Text = statement.Columns["BloodGlucose"];
VisitTextBP.Text = statement.Columns["SystolicBP"] + "/" + statement.Columns["DiastolicBP"];
double BMIDouble = Convert.ToDouble(statement.Columns["BMI"]);
Double BMIRounded3 = Math.Round(BMIDouble, 3);
VisitTextBMI.Text = BMIRounded3.ToString();
VisitTextWeight.Text = statement.Columns["Weight"];
VisitTextHeight.Text = statement.Columns["Height"];
}
}
catch (Exception ex)
{
var result = SQLiteWinRT.Database.GetSqliteErrorCode(ex.HResult);
Debug.WriteLine("CREATE_NEW_VISIT---UPDATE_EDITED_DETAILS" + "\n" + ex.Message + "\n" + result.ToString());
}
try
{
string query = "SELECT * FROM MedicalDetailsMedicine WHERE PID = @pid AND DateVisited = @dv";
Statement statement = await this.database.PrepareStatementAsync(query);
statement.BindTextParameterWithName("@pid", this.PID);
statement.BindTextParameterWithName("@dv", VisitListBox.Items[VisitListBox.SelectedIndex].ToString());
statement.EnableColumnsProperty();
VisitTextMedicines.Children.Clear();
while (await statement.StepAsync())
{
StackPanel VisitMedicineStackPanels = new StackPanel();
VisitMedicineStackPanels.Margin = new Thickness(0, 15, 0, 0);
VisitMedicineStackPanels.Orientation = Orientation.Horizontal;
TextBlock dot = new TextBlock();
dot.Width = 10;
dot.FontSize = 15;
dot.Text = "•";
VisitMedicineStackPanels.Children.Add(dot);
TextBlock medicineName = new TextBlock();
medicineName.Width = 280;
medicineName.Text = ExtraModules.RemoveExtraCommas(ExtraModules.RemoveStringSpace(statement.Columns["Medicine"]));
medicineName.TextWrapping = TextWrapping.Wrap;
medicineName.FontSize = 15;
VisitMedicineStackPanels.Children.Add(medicineName);
VisitTextMedicines.Children.Add(VisitMedicineStackPanels);
}
}
catch (Exception ex)
{
var result = SQLiteWinRT.Database.GetSqliteErrorCode(ex.HResult);
Debug.WriteLine("CREATE_NEW_VISIT---UPDATE_EDITED_DETAILS---MEDICINE" + "\n" + ex.Message + "\n" + result.ToString());
}
try
{
string query = "SELECT * FROM MedicalDetailsVaccine WHERE PID = @pid AND DateVisited = @dv";
Statement statement = await this.database.PrepareStatementAsync(query);
statement.BindTextParameterWithName("@pid", this.PID);
statement.BindTextParameterWithName("@dv", VisitListBox.Items[VisitListBox.SelectedIndex].ToString());
statement.EnableColumnsProperty();
VisitTextVaccine.Children.Clear();
while (await statement.StepAsync())
{
if (statement.Columns["Vaccine"].Equals(""))
{
break;
}
StackPanel VisitVaccineStackPanels = new StackPanel();
VisitVaccineStackPanels.Margin = new Thickness(0, 15, 0, 0);
VisitVaccineStackPanels.Orientation = Orientation.Horizontal;
TextBlock dot = new TextBlock();
dot.Width = 10;
dot.FontSize = 15;
dot.Text = "•";
VisitVaccineStackPanels.Children.Add(dot);
TextBlock VaccineName = new TextBlock();
VaccineName.Width = 280;
VaccineName.Text = ExtraModules.RemoveExtraCommas(ExtraModules.RemoveStringSpace(statement.Columns["Vaccine"]));
VaccineName.TextWrapping = TextWrapping.Wrap;
VaccineName.FontSize = 15;
VisitVaccineStackPanels.Children.Add(VaccineName);
VisitTextVaccine.Children.Add(VisitVaccineStackPanels);
}
}
catch (Exception ex)
{
var result = SQLiteWinRT.Database.GetSqliteErrorCode(ex.HResult);
Debug.WriteLine("CREATE_NEW_VISIT---UPDATE_EDITED_DETAILS---VACCINE" + "\n" + ex.Message + "\n" + result.ToString());
}
this.visibleStackPanels();
}
}
