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 });
}
}
