public void btnSubmit_Click(object sender, EventArgs e) { string currentUser = HttpContext.Current.User.Identity.Name; if (validateSubmission()) { SQLFunctions conn = new SQLFunctions(); int userId = conn.getUserID(currentUser); annualVoteModel voting = new annualVoteModel(); voting.voterID = userId; voting.voteDate = DateTime.Now; List <bookVote> choiceList = new List <bookVote>(); bookVote choices; foreach (HtmlTableRow row in tableContent.Rows) { choices = new bookVote(); foreach (Control ctl in row.Cells[0].Controls.OfType <TextBox>()) { string S = ((TextBox)ctl).Text; choices.votePref = Convert.ToInt32(S); } if (row.Cells[2].InnerText != "Title") { choices.bookTitle = row.Cells[2].InnerText; choiceList.Add(choices); } else { // Do nothing } } for (int X = 0; X <= choiceList.Count - 1; X++) { switch (choiceList[X].votePref) { case 1: voting.votePref_1 = conn.getBookID(choiceList[X].bookTitle); break; case 2: voting.votePref_2 = conn.getBookID(choiceList[X].bookTitle); break; case 3: voting.votePref_3 = conn.getBookID(choiceList[X].bookTitle); break; case 4: voting.votePref_4 = conn.getBookID(choiceList[X].bookTitle); break; case 5: voting.votePref_5 = conn.getBookID(choiceList[X].bookTitle); break; case 6: voting.votePref_6 = conn.getBookID(choiceList[X].bookTitle); break; case 7: voting.votePref_7 = conn.getBookID(choiceList[X].bookTitle); break; default: break; } } // Submit answers conn.submitAnnualVote(voting); tableContent.Visible = false; btnSubmit.Visible = false; ThankYouForVoting.Visible = true; } else { // Testing } }