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