public JobPostViewModel GetJobDetails(int jobid) { var dt = _jobPostProcessor.GetJobDetails(jobid); if (dt != null) { string picpath = System.IO.Path.GetFullPath(hostingEnviroment.WebRootPath + dt.Rows[0]["CompanyLogo"]); if (!System.IO.File.Exists(picpath)) { string fName = $@"\ProfilePic\" + "Avatar_company.jpg"; dt.Rows[0]["CompanyLogo"] = fName; } JobPostViewModel jobdetails = new JobPostViewModel { JobPostId = Convert.ToInt32(dt.Rows[0]["JobPostId"]), JobIndustryAreaId = Convert.ToInt32(dt.Rows[0]["JobIndustryAreaId"]), CountryCode = Convert.ToString(dt.Rows[0]["Country"]), StateCode = Convert.ToString(dt.Rows[0]["StateName"]), CityCode = Convert.ToString(dt.Rows[0]["City"]), MonthlySalary = Convert.ToString(dt.Rows[0]["MonthlySalary"]), //NoPosition = Convert.ToInt32(dt.Rows[0]["NoPosition"]), EmploymentStatusName = Convert.ToString(dt.Rows[0]["EmploymentStatusName"]), EmploymentTypeName = Convert.ToString(dt.Rows[0]["EmploymentTypeName"]), Skills = Convert.ToString(dt.Rows[0]["Skills"]), JobTitle = Convert.ToString(dt.Rows[0]["JobTitleName"]), Nationality = Convert.ToString(dt.Rows[0]["Nationality"]), PositionStartDate = Convert.ToString(dt.Rows[0]["PositionStartDate"]), PositionEndDate = Convert.ToString(dt.Rows[0]["PositionEndDate"]), HiringCriteria = Convert.ToString(dt.Rows[0]["HiringCriteria"]), Gender = Convert.ToString(dt.Rows[0]["Gender"]), CTC = (dt.Rows[0]["CTC"]) as string ?? "", JobDetails = Convert.ToString(dt.Rows[0]["JobDetails"]), CompanyLogo = Convert.ToString(dt.Rows[0]["CompanyLogo"]), CompanyName = Convert.ToString(dt.Rows[0]["CompanyName"]), JobTitleByEmployer = Convert.ToString(dt.Rows[0]["JobTitleByEmployer"]), JobTypeSummary = Convert.ToString(dt.Rows[0]["JobTypeSummary"]), }; //jobdetails.HiringCriteria = jobdetails.HiringCriteria.Substring(jobdetails.HiringCriteria.IndexOf(':') + 2); //int openings = DateTime.Now.Month; //if (openings <= 3) //{ // jobdetails.NoPosition = dt.Rows[0]["Quarter4"] as int? ?? 0; //} //else if (openings > 3 && openings <= 4) //{ // jobdetails.NoPosition = dt.Rows[0]["Quarter1"] as int? ?? 0; //} //else if (openings > 4 && openings <= 7) //{ // jobdetails.NoPosition = dt.Rows[0]["Quarter2"] as int? ?? 0; //} //else if (openings > 7 && openings <= 12) //{ // jobdetails.NoPosition = dt.Rows[0]["Quarter3"] as int? ?? 0; //} return(jobdetails); } throw new DataNotFound("Job details not found"); }