public int GetConfirmedCount()
        {
            var repo = new CandidatesRepository(_connectionString);

            return(repo.GetConfirmedCandidates().Count);
        }
        public List <Candidate> GetConfirmedCandidates()
        {
            var repo = new CandidatesRepository(_connectionString);

            return(repo.GetConfirmedCandidates());
        }