// GET: Job/Details/5 /// Reference:Varsity Project by Christine Bittle - Team Data Controllers public ActionResult Details(int id) { //ShowJob, model view used ShowJob ModelView = new ShowJob(); string url = "JobData/FindJob/" + id; HttpResponseMessage response = client.GetAsync(url).Result; //Response 200 code if it is ok if (response.IsSuccessStatusCode) { JobDto SelectedJob = response.Content.ReadAsAsync <JobDto>().Result; ModelView.Job = SelectedJob; // Get Applications by Job Id url = "JobData/GetApplicationsForJob/" + id; response = client.GetAsync(url).Result; IEnumerable <ApplicationDto> SelectedApplications = response.Content.ReadAsAsync <IEnumerable <ApplicationDto> >().Result; ModelView.Applications = SelectedApplications; return(View(ModelView)); } else { return(RedirectToAction("Error")); } }
//Display individual job details public ActionResult Show(int?id) { Job job = db.Jobs.SqlQuery("Select * from Jobs Where JobID=@JobID", new SqlParameter("@JobID", id)).FirstOrDefault(); string query = "select * from Applications where JobID = @id"; SqlParameter parameter = new SqlParameter("@id", id); List <Application> applications = db.Applications.SqlQuery(query, parameter).ToList(); ShowJob ViewModel = new ShowJob(); ViewModel.Job = job; ViewModel.Applications = applications; return(View(ViewModel)); }