public List <DbElectionCandidate> GetCandidates(uint cycle_id, DbCandidateState state)
{
return(Context.Connection.Query <DbElectionCandidate>("SELECT * FROM fso_election_candidates WHERE election_cycle_id = @cycle_id AND state = @state",
new { cycle_id = cycle_id, state = state.ToString() }).ToList());
}
public DbElectionCandidate GetCandidate(uint avatar_id, uint cycle_id, DbCandidateState state)
{
return(Context.Connection.Query <DbElectionCandidate>("SELECT * FROM fso_election_candidates WHERE candidate_avatar_id = @avatar_id " +
"AND election_cycle_id = @cycle_id AND state = @state",
new { avatar_id = avatar_id, cycle_id = cycle_id, state = state.ToString() }).FirstOrDefault());
}
