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); }