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