public void UpdateValues(HighSchoolEmergencyContactClass hsec) { _parentNameOne = hsec.parentNameOne; _parentNameTwo = hsec.parentNameTwo; _parentOneRelationship = hsec.parentOneRelationship; _parentTwoRelationship = hsec.parentTwoRelationship; _parentOnePrimaryNum = hsec.parentOnePrimaryNum; _parentTwoPrimaryNum = hsec.parentTwoPrimaryNum; _parentOneCellNum = hsec.parentOneCellNum; _parentTwoCellNum = hsec.parentTwoCellNum; _parentOneAddress = hsec.parentOneAddress; _parentTwoAddress = hsec.parentTwoAddress; _parentOneCity = hsec.parentOneCity; _parentTwoCity = hsec.parentTwoCity; _parentOneState = hsec.parentOneState; _parentTwoState = hsec.parentTwoState; _parentOneZip = hsec.parentOneZip; _parentTwoZip = hsec.parentTwoZip; _parentOneEmail = hsec.parentOneEmail; _parentTwoEmail = hsec.parentTwoEmail; _residesWithP1 = bool.Parse(hsec.residesWithP1); _residesWithP2 = bool.Parse(hsec.residesWithP2); _eContactName = hsec.EContactName; _eContactRelationship = hsec.EContactRelationship; _eContactPrimaryNum = hsec.EContactPrimaryNum; _eContactCellNum = hsec.EContactCellNum; }
public HighSchoolECUC() { InitializeComponent(); // DataAccess variable to retrieve and autofill previously stored data for the user DataAccess db = new DataAccess(); hsec = db.GetHSEC(LoginPage.highschoolCheck.Id); // set the datacontext of the text fields to be the AdultEmergencyContact variable textFields.DataContext = hsec; }
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 SaveHSEC(HighSchoolEmergencyContactClass hsec, HighSchoolECUCTextValidation hsecCheck) { string query = $"Update HighSchoolEmergencyContact Set "; List <string> listToSave = new List <string>(new string[] { "parentNameOne = @ParentNameOne", "parentOneRelationship = @ParentOneRelationship", "parentOneAddress = @ParentOneAddress", "parentOneCity = @ParentOneCity", "parentOneState = @ParentOneState", "parentOneZip = @ParentOneZip", "parentOnePrimaryNum = @ParentOnePrimaryNum", "parentOneWorkNum = @ParentOneWorkNum", "parentOneCellNum = @ParentOneCellNum", "parentOneEmail = @ParentOneEmail", "residesWithP1 = @ResidesWithP1", "parentNameTwo = @ParentNameTwo", "parentTwoRelationship = @ParentTwoRelationship", "parentTwoAddress = @ParentTwoAddress", "parentTwoCity = @ParentTwoCity", "parentTwoState = @ParentTwoState", "parentTwoZip = @ParentTwoZip", "parentTwoPrimaryNum = @ParentTwoPrimaryNum", "parentTwoWorkNum = @ParentTwoWorkNum", "parentTwoCellNum = @ParentTwoCellNum", "parentTwoEmail = @ParentTwoEmail", "residesWithP2 = @ResidesWithP2", "EContactName = @eContactName", "EContactRelationship = @eContactRelationship", "EContactPrimaryNum = @eContactPrimaryNum", "EContactWorkNum = @eContactWorkNum", "EContactCellNum = @eContactCellNum" }); List <string> toRemove = hsecCheck.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 { ParentNameOne = hsec.parentNameOne, ParentOneRelationship = hsec.parentOneRelationship, ParentOneAddress = hsec.parentOneAddress, ParentOneCity = hsec.parentOneCity, ParentOneState = hsec.parentOneState, ParentOneZip = hsec.parentOneZip, ParentOnePrimaryNum = hsec.parentOnePrimaryNum, ParentOneWorkNum = hsec.parentOneWorkNum, ParentOneCellNum = hsec.parentOneCellNum, ParentOneEmail = hsec.parentOneEmail, ResidesWithP1 = hsec.residesWithP1, ParentNameTwo = hsec.parentNameTwo, ParentTwoRelationship = hsec.parentTwoRelationship, ParentTwoAddress = hsec.parentTwoAddress, ParentTwoCity = hsec.parentTwoCity, ParentTwoState = hsec.parentTwoState, ParentTwoZip = hsec.parentTwoZip, ParentTwoPrimaryNum = hsec.parentTwoPrimaryNum, ParentTwoWorkNum = hsec.parentTwoWorkNum, ParentTwoCellNum = hsec.parentTwoCellNum, ParentTwoEmail = hsec.parentTwoEmail, ResidesWithP2 = hsec.residesWithP2, eContactName = hsec.EContactName, eContactRelationship = hsec.EContactRelationship, eContactPrimaryNum = hsec.EContactPrimaryNum, eContactWorkNum = hsec.EContactWorkNum, eContactCellNum = hsec.EContactCellNum, id = hsec.Id }); } }