public CandidatesViewModel GetCandidateDetails(int userid)
        {
            var details = dashboardRepository.GetCandidateDetails(userid);
            CandidatesViewModel candidatedetails = new CandidatesViewModel();

            if (details != null && details.Rows.Count > 0)
            {
                candidatedetails.Id          = userid;
                candidatedetails.CandidateId = details.Rows[0]["Candidateid"] as string ?? "";
                candidatedetails.FirstName   = details.Rows[0]["FirstName"] as string ?? "";
                candidatedetails.LastName    = details.Rows[0]["LastName"] as string ?? "";
                candidatedetails.Email       = details.Rows[0]["Email"] as string ?? "";
                candidatedetails.Password    = details.Rows[0]["Password"] as string ?? "";
            }
            return(candidatedetails);
        }