public IActionResult Submit(Candidate c)
        {
            var repository = new CTRepository(_conn);

            repository.AddCandidate(c);
            return(Redirect("/home/index"));
        }
        public IActionResult GetDeclined()
        {
            var repository = new CTRepository(_conn);

            return(Json(repository.GetDeclinedAmount()));
        }
        public IActionResult GetPending()
        {
            var repository = new CTRepository(_conn);

            return(Json(repository.GetPendingAmount()));
        }
        public void Decline(int id)
        {
            var repository = new CTRepository(_conn);

            repository.DeclineCandidate(id);
        }
        public void Confirm(int id)
        {
            var repository = new CTRepository(_conn);

            repository.ConfirmCandidate(id);
        }
        public IActionResult ViewDeclined()
        {
            var repository = new CTRepository(_conn);

            return(View(repository.GetDeclinedCandidates()));
        }
        public IActionResult ViewDetails(int id)
        {
            var repository = new CTRepository(_conn);

            return(View(repository.GetCandidateById(id)));
        }
        public IActionResult ViewPending()
        {
            var repository = new CTRepository(_conn);

            return(View(repository.GetPendingCandidates()));
        }