public List <Candidate> Confirm(CandidateViewModel vm)
        {
            var repo = new CandidateRepository(_connectionString);

            repo.ConfirmCandidate(vm.CandidateId);
            return(repo.GetAll());
        }