public IList <CandidatesViewModel> GetCandidates(int tpId)
        {
            var candidates = dashboardRepository.GetCandidates(tpId);
            IList <CandidatesViewModel> candidatesVM = null;

            if (null != candidates && candidates.Rows.Count > 0)
            {
                candidatesVM = new List <CandidatesViewModel>();
                foreach (DataRow row in candidates.Rows)
                {
                    candidatesVM.Add(new CandidatesViewModel
                    {
                        Id          = Convert.ToInt32(row["UserId"]),
                        CandidateId = Convert.ToString(row["Candidateid"]),
                        FirstName   = Convert.ToString(row["FirstName"]),
                        LastName    = Convert.ToString(row["LastName"]),
                        Email       = Convert.ToString(row["Email"]),
                        Password    = Convert.ToString(row["Password"]),
                        IsActive    = Convert.ToBoolean(row["IsActive"])
                    });
                }
            }
            return(candidatesVM);
        }