public List <CategoryJobsViewModel> getTechsByCategory(string category) { List <CategoryJobsViewModel> _techs = new List <CategoryJobsViewModel>(); var techs = from Technician in db.Technicians where Technician.JobType == category select Technician; foreach (var item in techs) { var profile = (from TechnicianProfile in db.TechnicianProfiles where TechnicianProfile.techId == item.Id select TechnicianProfile).FirstOrDefault(); CategoryJobsViewModel _model = new CategoryJobsViewModel() { Id = profile.Id, techid = item.Id, techAspnetId = item.ApplicationUser_Id, CompanyName = item.CompanyName, Rating = profile.Rating }; _techs.Add(_model); } return(_techs); }
public ActionResult GetCategories(int id) { var jobs = _context.Jobs.Where(m => m.CategoryId == id).ToList(); var category = _context.Categories.Find(id); var viewModel = new CategoryJobsViewModel { Jobs = jobs, Category = category }; return(View(viewModel)); }