public List<JobIndustryAreaModel> GetJobIndustryAreaWithJobPost()
{
DataTable jobIndustryArea = _jobPostProcessor.GetJobIndustryAreaWithJobPost();
List<JobIndustryAreaModel> lstJobIndustryArea = new List<JobIndustryAreaModel>();
if (jobIndustryArea.Rows.Count > 0)
{
lstJobIndustryArea = ConvertDatatableToModelList.ConvertDataTable<JobIndustryAreaModel>(jobIndustryArea);
}
return lstJobIndustryArea;
}
public List<CountryViewModel> GetCountryDetails()
{
DataTable country = masterDataRepository.GetCountries();
List<CountryViewModel> lstCountry = new List<CountryViewModel>();
if (country.Rows.Count > 0)
{
lstCountry = ConvertDatatableToModelList.ConvertDataTable<CountryViewModel>(country);
}
return lstCountry;
}
public List<EmploymentStatusModel> GetJobJobEmploymentStatusDetails()
{
DataTable JobEmploymentStatus = _jobPostProcessor.GetJobJobEmploymentStatusDetail();
List<EmploymentStatusModel> lstJobEmploymentStatus = new List<EmploymentStatusModel>();
if (JobEmploymentStatus.Rows.Count > 0)
{
lstJobEmploymentStatus = ConvertDatatableToModelList.ConvertDataTable<EmploymentStatusModel>(JobEmploymentStatus);
}
return lstJobEmploymentStatus;
}
public List<EmploymentTypeModel> GetJobJobEmploTypeDetails()
{
DataTable JobEmploymentType = _jobPostProcessor.GetJobJobEmploTypeDetail();
List<EmploymentTypeModel> lstJobEmploymentType = new List<EmploymentTypeModel>();
if (JobEmploymentType.Rows.Count > 0)
{
lstJobEmploymentType = ConvertDatatableToModelList.ConvertDataTable<EmploymentTypeModel>(JobEmploymentType);
}
return lstJobEmploymentType;
}
public List <CityViewModel> GetCityHasJobPostId()
{
DataTable city = _homeRepositories.GetCityHasJobPostId();
List <CityViewModel> lstCity = new List <CityViewModel>();
if (city.Rows.Count > 0)
{
lstCity = ConvertDatatableToModelList.ConvertDataTable <CityViewModel>(city);
}
return(lstCity);
}
public List <GenderViewModel> GetGenders()
{
DataTable genderdata = masterRepo.GetAllGender(true);
List <GenderViewModel> lstGender = new List <GenderViewModel>();
if (genderdata.Rows.Count > 0)
{
lstGender = ConvertDatatableToModelList.ConvertDataTable <GenderViewModel>(genderdata);
}
return(lstGender);
}
public List<StateViewModel> GetStateList(string CountryCode)
{
DataTable state = _jobPostProcessor.GetStateListDetail(CountryCode);
if (state.Rows.Count > 0)
{
List<StateViewModel> lstState = new List<StateViewModel>();
lstState = ConvertDatatableToModelList.ConvertDataTable<StateViewModel>(state);
return lstState;
}
throw new UserNotFoundException("User not found");
}
public List <MaritalStatusViewModel> GetMaritalStatusMaster()
{
DataTable maritalStatuses = masterRepository.GetMaritalStatusMaster();
List <MaritalStatusViewModel> lstMaritalStatus = new List <MaritalStatusViewModel>();
if (maritalStatuses.Rows.Count > 0)
{
lstMaritalStatus = ConvertDatatableToModelList.ConvertDataTable <MaritalStatusViewModel>(maritalStatuses);
}
return(lstMaritalStatus);
}
public List<GenderViewModel> GetGenderListDetail()
{
DataTable gender = _jobPostProcessor.GetGenderListDetail();
if (gender.Rows.Count > 0)
{
List<GenderViewModel> genderList = new List<GenderViewModel>();
genderList = ConvertDatatableToModelList.ConvertDataTable<GenderViewModel>(gender);
return genderList;
}
throw new UserNotFoundException("Data not found");
}
public List<JobTitleViewModel> GetJobTitleDetails()
{
DataTable jobTitle = masterDataRepository.GetJobRoles();
List<JobTitleViewModel> lstJobTitle = new List<JobTitleViewModel>();
if (jobTitle.Rows.Count > 0)
{
lstJobTitle = ConvertDatatableToModelList.ConvertDataTable<JobTitleViewModel>(jobTitle);
return lstJobTitle;
}
return lstJobTitle;
}
public List <StateViewModel> GetStates(string country)
{
DataTable state = masterRepo.GetStates(country);
List <StateViewModel> lstState = new List <StateViewModel>();
if (state.Rows.Count > 0)
{
lstState = ConvertDatatableToModelList.ConvertDataTable <StateViewModel>(state);
}
return(lstState);
}
public List<JobIndustryAreaModel> GetJobIndustryAreaWithStudentData()
{
DataTable jobIndustryArea = _jobPostProcessor.GetJobIndustryAreaWithStudentData();
if (jobIndustryArea.Rows.Count > 0)
{
List<JobIndustryAreaModel> lstJobIndustryArea = new List<JobIndustryAreaModel>();
lstJobIndustryArea = ConvertDatatableToModelList.ConvertDataTable<JobIndustryAreaModel>(jobIndustryArea);
return lstJobIndustryArea;
}
throw new DataNotFound("Data not found");
}
public List<CityViewModel> GetCityList(string StateCode)
{
DataTable city = _jobPostProcessor.GetCityListDetail(StateCode);
if (city.Rows.Count > 0)
{
List<CityViewModel> lstCity = new List<CityViewModel>();
lstCity = ConvertDatatableToModelList.ConvertDataTable<CityViewModel>(city);
return lstCity;
}
throw new UserNotFoundException("User not found");
}
public List <CityViewModel> GetCityList(string StateCode)
{
DataTable city = masterRepository.GetCities(StateCode);
if (city.Rows.Count > 0)
{
List <CityViewModel> lstCity = new List <CityViewModel>();
lstCity = ConvertDatatableToModelList.ConvertDataTable <CityViewModel>(city);
return(lstCity);
}
throw new DataNotFound("Cities not found, please contact your tech deck.");
}
public List <CityViewModel> GetCityListByChar(string cityFirstChar)
{
DataTable city = _homeRepositories.GetCityListByChar(cityFirstChar);
if (city.Rows.Count > 0)
{
List <CityViewModel> lstCity = new List <CityViewModel>();
lstCity = ConvertDatatableToModelList.ConvertDataTable <CityViewModel>(city);
return(lstCity);
}
throw new DataNotFound("City data not found");
}
public List <CityViewModel> GetCityList()
{
DataTable city = _masterRepository.GetAllCitiesWithoutState();
if (city.Rows.Count > 0)
{
List <CityViewModel> lstCity = new List <CityViewModel>();
lstCity = ConvertDatatableToModelList.ConvertDataTable <CityViewModel>(city);
return(lstCity);
}
throw new UserNotFoundException("User not found");
}
public List <JobTitleViewModel> GetJobTitleById(int JobIndustrialArea)
{
DataTable jobTitle = masterDataRepository.GetJobTitlesById(JobIndustrialArea);
List <JobTitleViewModel> lstJobTitle = new List <JobTitleViewModel>();
if (jobTitle.Rows.Count > 0)
{
lstJobTitle = ConvertDatatableToModelList.ConvertDataTable <JobTitleViewModel>(jobTitle);
return(lstJobTitle);
}
return(lstJobTitle);
}
public List <CityViewModel> GetCitiesWithJobSeekerInfo()
{
DataTable city = _homeRepositories.GetCitiesWithJobSeekerInfo();
if (city.Rows.Count > 0)
{
List <CityViewModel> lstCity = new List <CityViewModel>();
lstCity = ConvertDatatableToModelList.ConvertDataTable <CityViewModel>(city);
return(lstCity);
}
throw new UserNotFoundException("User not found");
}
public List <StateViewModel> GetStateList(string CountryCode)
{
DataTable state = _masterDataRepository.GetStates(CountryCode);
List <StateViewModel> lstState = new List <StateViewModel>();
if (state.Rows.Count > 0)
{
lstState = ConvertDatatableToModelList.ConvertDataTable <StateViewModel>(state);
}
return(lstState);
//throw new Exception("State not found");
}
public List <JobTitleViewModel> GetJobListByChar(string jobFirstChar)
{
List <JobTitleViewModel> jobslist = new List <JobTitleViewModel>();
try
{
DataTable jobs = _homeRepositories.GetJobListByChar(jobFirstChar);
if (jobs.Rows.Count > 0)
{
jobslist = ConvertDatatableToModelList.ConvertDataTable <JobTitleViewModel>(jobs);
}
return(jobslist);
}
catch (DataNotFound ex)
{
throw new DataNotFound(ex.Message);
}
}
public List <SearchJobListViewModel> SearchJobList(SearchJobViewModel searches, int UserId)
{
var sModel = new JobSearchModel
{
Skills = searches.Skills,
JobRole = searches.JobTitle,
City = string.Join(Constants.CommaSeparator, searches.City),
Experiance = searches.Experiance,
JobCategory = string.Join(Constants.CommaSeparator, searches.JobCategory),
CompanyUserId = string.Join(Constants.CommaSeparator, searches.CompanyUserId)
};
int quarterStartMonth = Convert.ToInt32(ConfigurationHelper.Config.GetSection(Constants.JobPostingQuarterStartingMonthKey).Value);
DataTable jobList = _searchJobRepository.GetSearchJobList(sModel, UserId, quarterStartMonth);
List <SearchJobListViewModel> lstJobList = new List <SearchJobListViewModel>();
if (jobList.Rows.Count > 0)
{
lstJobList = ConvertDatatableToModelList.ConvertDataTable <SearchJobListViewModel>(jobList);
var appliedJobs = homeHandler.GetAplliedJobs(UserId);
for (int i = 0; i < lstJobList.Count; i++)
{
//getting the all the jobs applied by user only if the user logged in
if (UserId != 0 && appliedJobs.Count > 0)
{
lstJobList[i].IsApplied = appliedJobs.Any(aj => aj == lstJobList[i].JobPostId);
}
//Handled if image url exist in db but not available physically
string picpath = System.IO.Path.GetFullPath(_hostingEnviroment.WebRootPath + lstJobList[i].CompanyLogo);
if (!System.IO.File.Exists(picpath))
{
string fName = $@"\ProfilePic\" + "Avatar_company.jpg";
lstJobList[i].CompanyLogo = fName;
}
}
}
return(lstJobList);
}
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);
}
