public List <SearchJobListViewModel> GetRecentJobs() { DataTable dt = _homeRepositories.GetRecentJobs(); List <SearchJobListViewModel> lstRecentJobs = new List <SearchJobListViewModel>(); try { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { SearchJobListViewModel RecentJobs = 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"]) ?? "" }; lstRecentJobs.Add(RecentJobs); } } } catch { throw new DataNotFound("data not found!"); } return(lstRecentJobs); }
public List <SearchJobListViewModel> GetRecentJobs() { DataTable dt = _homeRepositories.GetRecentJobs(); List <SearchJobListViewModel> lstRecentJobs = 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 RecentJobs = 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"]) ?? "" }; lstRecentJobs.Add(RecentJobs); } } } catch { throw new DataNotFound("data not found!"); } return(lstRecentJobs); }