public Candidate GetCandidate(int id)
        {
            var repo = new CandidatesRepository(_connectionString);

            return(repo.GetPendingCandidate(id));
        }