public HealthInfoUC()
{
InitializeComponent();
// DataAccess variable to be used to retrieve and autofill information stored in the database for the user
DataAccess db = new DataAccess();
// initialize previously declared values to null for later checking
hshi = null;
ahi = null;
// check what type of student logged in
// then query database and pull student info, assigning values to the proper HealthInfo object
// then assign the datacontext for the text fields in the UC to the newly reassigned variable
if (LoginPage.highschoolCheck != null)
{
hshi = db.GetHSHI(LoginPage.highschoolCheck.Id);
if (hshi.healthSignature != null)
{
using (MemoryStream ms = new MemoryStream(hshi.healthSignature))
{
signatureCanvas.Strokes = new System.Windows.Ink.StrokeCollection(ms);
ms.Close();
}
}
textFields.DataContext = hshi;
siglabel.Text = "Parent/Guardian Signature: ";
}
else
{
ahi = db.GetAHI(LoginPage.adultCheck.Id);
if (ahi.healthSignature != null)
{
using (MemoryStream ms = new MemoryStream(ahi.healthSignature))
{
signatureCanvas.Strokes = new System.Windows.Ink.StrokeCollection(ms);
ms.Close();
}
}
textFields.DataContext = ahi;
siglabel.Text = "Student Signature: ";
}
// set signature border to base color
sigCanBorder.BorderBrush = new SolidColorBrush(Color.FromRgb(33, 148, 243));
}
private void Load()
{
DataAccess db = new DataAccess();
hsbi = db.GetHSBI(Id);
hsec = db.GetHSEC(Id);
hshi = db.GetHSHI(Id);
hsp = db.GetHSP(Id);
hsci = db.GetHSCI(Id);
BasicInfoField.DataContext = hsbi;
EmergencyContactField.DataContext = hsec;
HealthInformationField.DataContext = hshi;
StudentPolicyField.DataContext = hsp;
ConfidentialInfoField.DataContext = hsci;
if (hshi.healthSignature != null)
{
using (MemoryStream ms = new MemoryStream(hshi.healthSignature))
{
HISignatureCanvas.Strokes = new System.Windows.Ink.StrokeCollection(ms);
ms.Close();
}
}
if (hsp.parentSignature != null)
{
using (MemoryStream ms = new MemoryStream(hsp.parentSignature))
{
parentSigPolicyCanvas.Strokes = new System.Windows.Ink.StrokeCollection(ms);
ms.Close();
}
}
if (hsp.studentSignature != null)
{
using (MemoryStream ms = new MemoryStream(hsp.studentSignature))
{
policySignatureCanvas.Strokes = new System.Windows.Ink.StrokeCollection(ms);
ms.Close();
}
}
if (hsci.parentSignature != null)
{
using (MemoryStream ms = new MemoryStream(hsci.parentSignature))
{
parentSigCanvas.Strokes = new System.Windows.Ink.StrokeCollection(ms);
ms.Close();
}
}
}
public void UpdateValues(HighSchoolHealthInfoClass hshi)
{
_primaryPhysician = hshi.primaryPhysician;
_otherPhysician = hshi.otherPhysician;
_pPhysicianPhoneNum = hshi.pPhysicianPhoneNum;
_oPhysicianPhoneNum = hshi.oPhysicianPhoneNum;
_diabeticType = hshi.diabeticType;
_allergies = hshi.allergies;
_heartIssues = hshi.heartIssues;
_metabolic = bool.Parse(hshi.metabolic);
_jointMuscle = bool.Parse(hshi.jointMuscle);
_chronicIllness = bool.Parse(hshi.chronicIllness);
_migraines = bool.Parse(hshi.migraines);
_neurological = bool.Parse(hshi.neurological);
_pulmonary = bool.Parse(hshi.pulmonary);
_asthma = bool.Parse(hshi.asthma);
_other = bool.Parse(hshi.other);
_otherMeds = hshi.otherMeds;
_specificFirstAidNeeds = hshi.specificFirstAidNeeds;
_repPermissionForTreatment = hshi.repPermissionForTreatment;
}
public void SaveHSHI(HighSchoolHealthInfoClass hshi, HealthInfoTextValidation hiCheck)
{
string query = $"Update HighSchoolHealthInfo Set ";
List <string> listToSave = new List <string>(new string[] { "primaryPhysician = @PrimaryPhysician", "otherPhysician = @OtherPhysician", "pPhysicianPhoneNum = @PphysicianPhoneNum", "oPhysicianPhoneNum = @OphysicianPhoneNum", "diabeticType = @DiabeticType", "allergies = @Allergies", "heartIssues = @HeartIssues", "metabolic = @Metabolic", "jointMuscle = @JointMuscle", "chronicIllness = @ChronicIllness", "migraines = @Migraines", "neurological = @Neurological", "pulmonary = @Pulmonary", "asthma = @Asthma", "other = @Other", "otherMeds = @OtherMeds", "specificFirstAidNeeds = @SpecificFirstAidNeeds", "repPermissionForTreatment = @RepPermissionForTreatment", "healthSignature = @signature" });
List <string> toRemove = hiCheck.IsValid;
foreach (var v in toRemove)
{
for (int i = 0; i < listToSave.Count; i++)
{
if (listToSave[i].Contains(v))
{
listToSave.RemoveAt(i);
i--;
}
}
}
foreach (var s in listToSave)
{
if (listToSave.IndexOf(s) != listToSave.Count - 1)
{
query += s + ",";
}
else
{
query += s;
}
}
query += " Where Id = @id";
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Helper.CnnVal("EnrollmentDB")))
{
connection.Execute(query,
new { signature = hshi.healthSignature, PrimaryPhysician = hshi.primaryPhysician, OtherPhysician = hshi.otherPhysician, PphysicianPhoneNum = hshi.pPhysicianPhoneNum, OphysicianPhoneNum = hshi.oPhysicianPhoneNum, DiabeticType = hshi.diabeticType, Allergies = hshi.allergies, HeartIssues = hshi.heartIssues, Metabolic = hshi.metabolic, JointMuscle = hshi.jointMuscle, ChronicIllness = hshi.chronicIllness, Migraines = hshi.migraines, Neurological = hshi.neurological, Pulmonary = hshi.pulmonary, Asthma = hshi.asthma, Other = hshi.other, OtherMeds = hshi.otherMeds, SpecificFirstAidNeeds = hshi.specificFirstAidNeeds, RepPermissionForTreatment = hshi.repPermissionForTreatment, id = hshi.Id });
}
}
