public ActionResult Result(String OccupationQuery)
{
ViewBag.Message = "Results Page";
AutomationEntities_ j = new AutomationEntities_();
var jobs = j.sp_jobstable().ToList();
ViewBag.jobsInTable = jobs;
var jobsRelated = j.sp_Related(OccupationQuery).ToList();
ViewBag.jobsRelatedTable = jobsRelated;
var descrip = j.occDescription(OccupationQuery).FirstOrDefault();
var prob = j.occProbability(OccupationQuery).FirstOrDefault();
Occupation occ = new Occupation()
{
occName = OccupationQuery,
occDescription = descrip,
occProbability = prob
};
ViewData["OccupationData"] = occ;
return(View(occ));
}
public ActionResult Sorry()
{
ViewBag.Message = "Sorry";
AutomationEntities_ j = new AutomationEntities_();
var jobs = j.sp_jobstable().ToList();
ViewBag.jobsInTable = jobs;
return(View());
}
public ActionResult Search(string JobQuery)
{
AutomationEntities_ j = new AutomationEntities_();
var jobs = j.sp_jobstable().ToList();
if (JobQuery == "" || !jobs.Contains(JobQuery))
{
return(RedirectToAction("Sorry"));
}
return(RedirectToAction("Result", "Home", new { OccupationQuery = JobQuery }));
}