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