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