public List <SearchJobListViewModel> RecommendedJobs(int roleid) { DataTable dt = _jobPostProcessor.RecommendedJobs(roleid); if (dt.Rows.Count > 0) { List <SearchJobListViewModel> lstRecommendedJobs = new List <SearchJobListViewModel>(); for (int i = 0; i < dt.Rows.Count; i++) { SearchJobListViewModel RecommendedJob = new SearchJobListViewModel { JobPostId = Convert.ToInt32(dt.Rows[i]["JobPostId"]), CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]), JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]), EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]), City = Convert.ToString(dt.Rows[i]["City"]), HiringCriteria = Convert.ToString(dt.Rows[i]["HiringCriteria"]), CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]), JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]), }; lstRecommendedJobs.Add(RecommendedJob); } return(lstRecommendedJobs); } throw new DataNotFound("Data not found"); }
public List <SearchJobListViewModel> ViewAllFeaturedJobs() { DataTable dt = _homeRepositories.ViewAllFeaturedJobs(); if (dt.Rows.Count > 0) { List <SearchJobListViewModel> lstfeautredJobs = new List <SearchJobListViewModel>(); for (int i = 0; i < dt.Rows.Count; i++) { SearchJobListViewModel feautredJob = new SearchJobListViewModel { JobPostId = Convert.ToInt32(dt.Rows[i]["JobPostId"]), CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]), JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]), EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]), City = Convert.ToString(dt.Rows[i]["City"]), HiringCriteria = Convert.ToString(dt.Rows[i]["HiringCriteria"]), CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]), JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]), FeaturedJobDisplayOrder = (dt.Rows[i]["FeaturedJobDisplayOrder"] as int?) ?? 0, }; lstfeautredJobs.Add(feautredJob); } return(lstfeautredJobs); } throw new DataNotFound("Data not found"); }
public List <SearchJobListViewModel> FreelancerJobs() { DataTable dt = _homeRepositories.FreelancerJobs(); if (dt.Rows.Count > 0) { List <SearchJobListViewModel> lstFreelancerJobs = new List <SearchJobListViewModel>(); for (int i = 0; i < dt.Rows.Count; i++) { string picpath = System.IO.Path.GetFullPath(hostingEnviroment.WebRootPath + dt.Rows[i]["CompanyLogo"]); if (!System.IO.File.Exists(picpath)) { string fName = $@"\ProfilePic\" + "Avatar_company.jpg"; dt.Rows[i]["CompanyLogo"] = fName; } SearchJobListViewModel freelancerJobs = new SearchJobListViewModel { JobPostId = Convert.ToInt32(dt.Rows[i]["JobPostId"]), CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]), JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]), EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]), City = Convert.ToString(dt.Rows[i]["City"]), HiringCriteria = Convert.ToString(dt.Rows[i]["HiringCriteria"]), CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]), CTC = Convert.ToString(dt.Rows[i]["CTC"]), NumberOfDays = Convert.ToString(dt.Rows[i]["NumberOfDays"]), }; lstFreelancerJobs.Add(freelancerJobs); } return(lstFreelancerJobs); } throw new DataNotFound("Data not found"); }
public List <SearchJobListViewModel> GetFeaturedJobs() { DataTable dt = _homeRepositories.GetFeaturedJobs(); List <SearchJobListViewModel> lstfeautredJobs = new List <SearchJobListViewModel>(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { SearchJobListViewModel feautredJob = new SearchJobListViewModel { CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]) ?? "", JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]) ?? "", EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]) ?? "", City = Convert.ToString(dt.Rows[i]["City"]) ?? "", HiringCriteria = Convert.ToString(dt.Rows[i]["HiringCriteria"]) ?? "", CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]) ?? "", JobPostId = (dt.Rows[i]["JobPostId"] as int?) ?? 0, JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]) ?? "", FeaturedJobDisplayOrder = (dt.Rows[i]["FeaturedJobDisplayOrder"] as int?) ?? 0, JobDetails = Convert.ToString(dt.Rows[i]["JobDetails"]) ?? "", CTC = Convert.ToString(dt.Rows[i]["CTC"]) ?? "", NumberOfDays = Convert.ToString(dt.Rows[i]["NumberOfDays"]) ?? "" }; lstfeautredJobs.Add(feautredJob); } } return(lstfeautredJobs); }
public List <SearchJobListViewModel> GetWalkInsJobs() { DataTable dt = _homeRepositories.GetWalkInJobs(); List <SearchJobListViewModel> lstWalkinJobs = new List <SearchJobListViewModel>(); try { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { SearchJobListViewModel WalkinJobs = new SearchJobListViewModel { CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]) ?? "", JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]) ?? "", EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]) ?? "", City = Convert.ToString(dt.Rows[i]["City"]) ?? "", HiringCriteria = Convert.ToString(dt.Rows[i]["HiringCriteria"]) ?? "", CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]) ?? "", JobPostId = (dt.Rows[i]["JobPostId"] as int?) ?? 0, JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]) ?? "", CTC = Convert.ToString(dt.Rows[i]["CTC"]) ?? "", NumberOfDays = Convert.ToString(dt.Rows[i]["NumberOfDays"]) ?? "" }; lstWalkinJobs.Add(WalkinJobs); } } } catch { throw new DataNotFound("data not found!"); } return(lstWalkinJobs); }
public List <SearchJobListViewModel> GetJobseekerAppliedJobs(int userId) { DataTable dt = _userProfileRepository.GetJobseekerAppliedJobs(userId); List <SearchJobListViewModel> lstAppliedJobs = new List <SearchJobListViewModel>(); try { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { SearchJobListViewModel AppliedJobs = new SearchJobListViewModel { CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]) ?? "", JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]) ?? "", EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]) ?? "", City = Convert.ToString(dt.Rows[i]["City"]) ?? "", HiringCriteria = Convert.ToString(dt.Rows[i]["HiringCriteria"]) ?? "", CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]) ?? "", JobPostId = (dt.Rows[i]["JobPostId"] as int?) ?? 0, JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]) ?? "", CTC = Convert.ToString(dt.Rows[i]["CTC"]) ?? "", NumberOfDays = Convert.ToString(dt.Rows[i]["NumberOfDays"]) ?? "", CreatedDate = Convert.ToDateTime(dt.Rows[i]["CreatedDate"]) }; lstAppliedJobs.Add(AppliedJobs); } } } catch { throw new DataNotFound("data not found!"); } return(lstAppliedJobs); }
public List <SearchJobListViewModel> GetAllCompanyList() { DataTable dt = _homeRepositories.GetAllCompanyList(); List <SearchJobListViewModel> list = new List <SearchJobListViewModel>(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { SearchJobListViewModel model = new SearchJobListViewModel { CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]), CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]), }; list.Add(model); } } return(list); }
public List <SearchJobListViewModel> GetWalkInsJobs() { DataTable dt = _homeRepositories.GetWalkInJobs(); List <SearchJobListViewModel> lstWalkinJobs = new List <SearchJobListViewModel>(); try { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { string picpath = System.IO.Path.GetFullPath(hostingEnviroment.WebRootPath + dt.Rows[i]["CompanyLogo"]); if (!System.IO.File.Exists(picpath)) { string fName = $@"\ProfilePic\" + "Avatar_company.jpg"; dt.Rows[i]["CompanyLogo"] = fName; } SearchJobListViewModel WalkinJobs = new SearchJobListViewModel { CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]) ?? "", JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]) ?? "", EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]) ?? "", City = Convert.ToString(dt.Rows[i]["City"]) ?? "", HiringCriteria = Convert.ToString(dt.Rows[i]["HiringCriteria"]) ?? "", CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]) ?? "", JobPostId = (dt.Rows[i]["JobPostId"] as int?) ?? 0, JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]) ?? "", CTC = Convert.ToString(dt.Rows[i]["CTC"]) ?? "", NumberOfDays = Convert.ToString(dt.Rows[i]["NumberOfDays"]) ?? "" }; lstWalkinJobs.Add(WalkinJobs); } } } catch { throw new DataNotFound("data not found!"); } return(lstWalkinJobs); }
public List <SearchJobListViewModel> JobSeekerJobsOnSkills(string skills, int UserId) { DataTable dt = _userProfileRepository.JobSeekerJobsOnSkills(skills, UserId); List <SearchJobListViewModel> lstJobs = new List <SearchJobListViewModel>(); try { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { string picpath = System.IO.Path.GetFullPath(_hostingEnviroment.WebRootPath + dt.Rows[i]["CompanyLogo"]); if (!System.IO.File.Exists(picpath)) { string fName = $@"\ProfilePic\" + "Avatar_company.jpg"; dt.Rows[i]["CompanyLogo"] = fName; } SearchJobListViewModel Jobs = new SearchJobListViewModel { CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]) ?? "", JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]) ?? "", EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]) ?? "", City = Convert.ToString(dt.Rows[i]["City"]) ?? "", HiringCriteria = Convert.ToString(dt.Rows[i]["HiringCriteria"]) ?? "", CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]) ?? "", JobPostId = (dt.Rows[i]["JobPostId"] as int?) ?? 0, JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]) ?? "", Skills = Convert.ToString(dt.Rows[i]["Skills"]) ?? "", CTC = Convert.ToString(dt.Rows[i]["CTC"]) ?? "", }; lstJobs.Add(Jobs); } } } catch { throw new DataNotFound("data not found!"); } return(lstJobs); }
public List <SearchJobListViewModel> NasscomJobs() { DataTable dt = _homeRepositories.NasscomJobsList(); List <SearchJobListViewModel> list = new List <SearchJobListViewModel>(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { SearchJobListViewModel model = new SearchJobListViewModel { CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]), CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]), JobPostId = Convert.ToInt32(dt.Rows[i]["JobPostId"]), JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]), City = Convert.ToString(dt.Rows[i]["City"]), EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]), }; list.Add(model); } } return(list); }