public List <Candidate> GetConfirmed()
        {
            var repo = new CandidatesRepository(_connectionString);

            return(repo.GetCandidateByStatus(Status.confirmed));
        }
        public List <Candidate> GetPending()
        {
            var repo = new CandidatesRepository(_connectionString);

            return(repo.GetCandidateByStatus(Status.pending));
        }