/// <summary>
/// selects all completed votes by id
/// </summary>
/// <param name="completedVoteID"></param>
/// <returns></returns>
public CompletedVoteVM SelectCompletedVoteByCompletedVoteID(int completedVoteID)
{
CompletedVoteVM completedVote = new CompletedVoteVM();
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_select_completed_vote_by_completed_vote_id", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CompletedVoteID", completedVote);
try
{
var reader = cmd.ExecuteReader();
if (reader.Read())
{
completedVote.CompletedVoteID = reader.GetInt32(0);
completedVote.PersonID = reader.GetInt32(1);
completedVote.ElectionID = reader.GetInt32(2);
completedVote.HasVoted = reader.GetBoolean(3);
completedVote.FirstName = reader.GetString(4);
completedVote.LastName = reader.GetString(5);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(completedVote);
}
/// <summary>
/// selects all completed votes
/// </summary>
/// <returns></returns>
public List <CompletedVoteVM> SelectAllCompletedVotes()
{
List <CompletedVoteVM> completedVotes = new List <CompletedVoteVM>();
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_select_all_completed_votes", conn);
cmd.CommandType = CommandType.StoredProcedure;
try
{
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var completedVote = new CompletedVoteVM();
completedVote.CompletedVoteID = reader.GetInt32(0);
completedVote.PersonID = reader.GetInt32(1);
completedVote.ElectionID = reader.GetInt32(2);
completedVote.HasVoted = reader.GetBoolean(3);
completedVote.FirstName = reader.GetString(4);
completedVote.LastName = reader.GetString(5);
completedVotes.Add(completedVote);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(completedVotes);
}
