public void submitAnnualVote(annualVoteModel vote) { using (SqlCommand cmd = new SqlCommand("SubmitVote")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@whoVoted", vote.voterID); cmd.Parameters.AddWithValue("@dateVoted", vote.voteDate); cmd.Parameters.AddWithValue("@votePref1", vote.votePref_1); cmd.Parameters.AddWithValue("@votePref2", vote.votePref_2); cmd.Parameters.AddWithValue("@votePref3", vote.votePref_3); cmd.Parameters.AddWithValue("@votePref4", vote.votePref_4); cmd.Parameters.AddWithValue("@votePref5", vote.votePref_5); cmd.Parameters.AddWithValue("@votePref6", vote.votePref_6); cmd.Parameters.AddWithValue("@votePref7", vote.votePref_7); cmd.Connection = conn; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } }
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 } }