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