public ActionResult SearchResultDetails(string careerId, string searchText) { var model = new CareerSearchResultDetailsModel(); model.SearchText = searchText; using (var ctx = new CareersEntities()) { var description = ctx.spGetCareerInfoBasic(careerId); var tasks = ctx.spGetCareerInfoCareerTasks(careerId); var knowledge = ctx.spGetCareerInfoKnowledge(careerId); var skills = ctx.spGetCareerInfoSkills(careerId); var abilities = ctx.spGetCareerInfoAbilities(careerId); var activities = ctx.spGetCareerInfoWorkActivities(careerId); var interestes = ctx.spGetCareerInfoInterests(careerId); var styles = ctx.spGetCareerInfoWorkStyles(careerId); model.DescriptionDetails = description.FirstOrDefault(); model.Tasks = tasks.ToList(); model.KnowledgeItems = knowledge.ToList(); model.Skills = skills.ToList(); model.Abilities = abilities.ToList(); model.Activities = activities.ToList(); model.Interests = interestes.ToList(); model.Styles = styles.ToList(); } if (model.DescriptionDetails == null) { return View("Search"); } model.CareerName = model.DescriptionDetails.title; return View(model); }