private string GetCourseById(string cId) { var dTable = masterDataRepository.GetCoursesById(Convert.ToInt32(cId)); if (null != dTable && dTable.Rows.Count > 0) { return(Convert.ToString(dTable.Rows[0]["CourseName"])); } return(string.Empty); }
public SearchResumeListViewModel ShowCandidateDetails(int employerId, int jobSeekerId) { //var a = JsonConvert.DeserializeObject(skill).ToString(); SearchResumeListViewModel model = new SearchResumeListViewModel(); DataTable searchedResume = _serarchresumeProcess.ShowCandidateDetails(employerId, jobSeekerId); if (searchedResume.Rows.Count > 0) { EducationalDetails[] objEducationDetail = JsonConvert.DeserializeObject <EducationalDetails[]>(searchedResume.Rows[0]["EducationalDetails"].ToString()); ExperienceDetails[] objExperience = JsonConvert.DeserializeObject <ExperienceDetails[]>(searchedResume.Rows[0]["ExperienceDetails"].ToString()); model.Skills = new Skills(); var skills = JsonConvert.DeserializeObject <Skills>(searchedResume.Rows[0]["Skills"].ToString()); if (null != skills) { model.Skills = skills; } string resumePath = Convert.ToString(searchedResume.Rows[0]["Resume"]); if (!string.IsNullOrWhiteSpace(resumePath)) { if (!File.Exists($"{_hostingEnviroment.WebRootPath}{resumePath}")) { resumePath = string.Empty; } } model.ExperienceDetails = objExperience; model.EducationalDetails = objEducationDetail; if (model.EducationalDetails != null) { foreach (EducationalDetails edu in model.EducationalDetails) { DataTable coursename = _masterRepository.GetCoursesById(Convert.ToInt32(edu.Course)); if (coursename != null && coursename.Rows.Count > 0) { edu.CourseName = coursename.Rows[0]["CourseName"] as string ?? ""; } } } model.FirstName = Convert.ToString(searchedResume.Rows[0]["FirstName"]); model.LastName = Convert.ToString(searchedResume.Rows[0]["LastName"]); model.Email = Convert.ToString(searchedResume.Rows[0]["Email"]); model.Resume = resumePath; model.UserId = Convert.ToInt32(searchedResume.Rows[0]["UserId"]); model.CityCode = Convert.ToString(searchedResume.Rows[0]["CityCode"]); model.CityName = Convert.ToString(searchedResume.Rows[0]["CityName"]); model.JobIndustryAreaName = Convert.ToString(searchedResume.Rows[0]["JobIndustryAreaName"]); model.CreatedOn = Convert.ToDateTime(searchedResume.Rows[0]["CreatedOn"]); model.Address = Convert.ToString(searchedResume.Rows[0]["Address1"]); model.State = Convert.ToString(searchedResume.Rows[0]["State"]); model.StateName = Convert.ToString(searchedResume.Rows[0]["StateName"]); model.Country = Convert.ToString(searchedResume.Rows[0]["Country"]); model.MobileNo = Convert.ToString(searchedResume.Rows[0]["MobileNo"]); model.ProfilePic = Convert.ToString(searchedResume.Rows[0]["ProfilePic"]); model.AboutMe = searchedResume.Rows[0]["AboutMe"].ToString(); model.LinkedinProfile = searchedResume.Rows[0]["LinkedinProfile"].ToString(); model.JobTitle = searchedResume.Rows[0]["JobTitleName"].ToString(); model.CountryName = searchedResume.Rows[0]["CountryName"].ToString(); //model.TotalExperience = Convert.ToDouble(searchedResume.Rows[0]["TotalExperience"]); if (!Convert.IsDBNull(searchedResume.Rows[0]["TotalExperience"])) { model.TotalExperience = Convert.ToDouble(searchedResume.Rows[0]["TotalExperience"]); } string dob = Convert.ToString(searchedResume.Rows[0]["DateOfBirth"] as string) ?? ""; if (dob != null && dob != "") { DateTime date = Convert.ToDateTime(dob); model.DateOfBirth = Convert.ToString(DateTime.Now.Year - date.Year); } model.CurrentSalary = searchedResume.Rows[0]["CurrentSalary"].ToString(); model.ExpectedSalary = searchedResume.Rows[0]["ExpectedSalary"].ToString(); return(model); } throw new UserNotFoundException("Data Not found"); }
public UserDetail GetJobseekerDetail(int UserId) { DataTable jobSeekerDetail = _userProfileRepository.GetJobseekerData(UserId); DataTable allcities = _userProfileRepository.GetAllCities(); DataTable preferredlocation = _userProfileRepository.GetUserPreferredlocation(UserId); DataTable ITSkills = _userProfileRepository.GetUserITSkills(UserId); DataTable ProfileScore = _userProfileRepository.ProfileScore(UserId); UserDetail model = new UserDetail(); if (jobSeekerDetail.Rows.Count > 0) { model.PersonalDetails = new UserViewModel(); ExperienceDetails[] objExperience = JsonConvert.DeserializeObject <ExperienceDetails[]>(jobSeekerDetail.Rows[0]["ExperienceDetails"].ToString()); EducationalDetails[] objEducational = JsonConvert.DeserializeObject <EducationalDetails[]>(jobSeekerDetail.Rows[0]["EducationalDetails"].ToString()); model.Cities = ConvertDatatableToModelList.ConvertDataTable <CityViewModel>(allcities); model.ITSkills = ConvertDatatableToModelList.ConvertDataTable <ITSkills>(ITSkills); //Adding preferred location if (preferredlocation != null && preferredlocation.Rows.Count > 0) { //checking if locationid is null then assign otherlocation model.PersonalDetails.PreferredLocation1 = (preferredlocation.Rows[0]["LocationId"] as string) ?? preferredlocation.Rows[0]["OtherLocation"] as string; model.PersonalDetails.PreferredLocation2 = (preferredlocation.Rows[1]["LocationId"] as string) ?? (preferredlocation.Rows[1]["OtherLocation"]) as string; model.PersonalDetails.PreferredLocation3 = (preferredlocation.Rows[2]["LocationId"] as string) ?? (preferredlocation.Rows[2]["OtherLocation"]) as string; } //model.PersonalDetails.Preferredlocation = ConvertDatatableToModelList.ConvertDataTable<string>(preferredlocation); model.ExperienceDetails = objExperience; model.EducationalDetails = objEducational; if (model.EducationalDetails != null) { foreach (EducationalDetails edu in model.EducationalDetails) { if (edu.Course != null) { DataTable coursename = _masterRepository.GetCoursesById(Convert.ToInt32(edu.Course)); if (coursename != null) { edu.CourseName = Convert.ToString(coursename.Rows[0]["CourseName"]); } } } } model.Skills = new Skills(); if (!Convert.IsDBNull(jobSeekerDetail.Rows[0]["Skills"])) { model.Skills = JsonConvert.DeserializeObject <Skills>(jobSeekerDetail.Rows[0]["Skills"].ToString()); } model.PersonalDetails.DOB = Convert.ToString(jobSeekerDetail.Rows[0]["DateOfBirth"]); model.PersonalDetails.ProfileSummary = Convert.ToString(jobSeekerDetail.Rows[0]["ProfileSummary"]); model.PersonalDetails.ProfilePic = Convert.ToString(jobSeekerDetail.Rows[0]["ProfilePic"]); model.PersonalDetails.CandidateId = Convert.ToString(jobSeekerDetail.Rows[0]["CandidateId"]); model.PersonalDetails.JobTitleName = Convert.ToString(jobSeekerDetail.Rows[0]["JobTitleName"]); model.PersonalDetails.FirstName = Convert.ToString(jobSeekerDetail.Rows[0]["FirstName"]); model.PersonalDetails.LastName = Convert.ToString(jobSeekerDetail.Rows[0]["LastName"]); model.PersonalDetails.MobileNo = Convert.ToString(jobSeekerDetail.Rows[0]["MobileNo"]); model.PersonalDetails.Email = Convert.ToString(jobSeekerDetail.Rows[0]["Email"]); model.PersonalDetails.MaritalStatus = Convert.ToString(jobSeekerDetail.Rows[0]["MaritalStatus"]); model.PersonalDetails.MaritalStatusName = Convert.ToString(jobSeekerDetail.Rows[0]["MaritalStatusName"]); model.PersonalDetails.Address1 = Convert.ToString(jobSeekerDetail.Rows[0]["Address1"]); model.PersonalDetails.City = Convert.ToString(jobSeekerDetail.Rows[0]["City"]); model.PersonalDetails.JobTitleId = jobSeekerDetail.Rows[0]["JobTitleId"] as int? ?? 0; model.PersonalDetails.UserId = UserId; model.PersonalDetails.Gender = Convert.ToString(jobSeekerDetail.Rows[0]["Gender"]); model.PersonalDetails.Country = Convert.ToString(jobSeekerDetail.Rows[0]["Country"]); model.PersonalDetails.State = Convert.ToString(jobSeekerDetail.Rows[0]["State"]); model.PersonalDetails.Resume = Convert.ToString(jobSeekerDetail.Rows[0]["Resume"]); model.PersonalDetails.LinkedinProfile = Convert.ToString(jobSeekerDetail.Rows[0]["LinkedinProfile"] as string) ?? ""; model.PersonalDetails.IsJobAlert = Convert.ToBoolean(jobSeekerDetail.Rows[0]["IsJobAlert"]); //model.PersonalDetails.ProfileScore = ProfileScore; if (!Convert.IsDBNull(jobSeekerDetail.Rows[0]["TotalExperience"])) { model.PersonalDetails.TotalExperience = Convert.ToDouble(jobSeekerDetail.Rows[0]["TotalExperience"]); } //Check if resume file exist on server string resumepath = Path.GetFullPath(_hostingEnviroment.WebRootPath + model.PersonalDetails.Resume); if (!File.Exists(resumepath)) { string fName = ""; model.PersonalDetails.Resume = fName; } if (ProfileScore != null && ProfileScore.Rows.Count > 0) { model.PersonalDetails.ProfileScore = Convert.ToInt16(ProfileScore.Rows[0]["Total"]); } model.PersonalDetails.CTC = Convert.ToString(jobSeekerDetail.Rows[0]["CurrentSalary"]); model.PersonalDetails.ECTC = Convert.ToString(jobSeekerDetail.Rows[0]["ExpectedSalary"]); model.PersonalDetails.AboutMe = Convert.ToString(jobSeekerDetail.Rows[0]["AboutMe"]); model.PersonalDetails.JobIndustryArea = Convert.ToString(jobSeekerDetail.Rows[0]["JobIndustryAreaId"]); model.PersonalDetails.EmploymentStatus = Convert.ToString(jobSeekerDetail.Rows[0]["EmploymentStatusId"]); model.PersonalDetails.EmploymentStatusName = Convert.ToString(jobSeekerDetail.Rows[0]["EmploymentStatusName"]); } return(model); }