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