public async Task <IActionResult> Catalogue(string CourseDMString, string searchString) { IQueryable <string> deliveryMethodQuery = from m in _context.Course orderby m.DeliveryMethod select m.DeliveryMethod; var courses = from m in _context.Course select m; if (!String.IsNullOrEmpty(searchString)) { courses = courses.Where(s => s.Title.Contains(searchString)); } if (!string.IsNullOrEmpty(CourseDMString)) { courses = courses.Where(s => s.DeliveryMethod == CourseDMString); } var coursedeliveryVM = new CourseDeliveryViewModel { DeliveryMethod = new SelectList(await deliveryMethodQuery.Distinct().ToListAsync()), Courses = await courses.ToListAsync() }; return(View(coursedeliveryVM)); }
public async Task <IActionResult> Index() { IQueryable <string> deliveryMethodQuery = from m in _context.Course orderby m.DeliveryMethod select m.DeliveryMethod; var courseDeliveryVM = new CourseDeliveryViewModel { DeliveryMethod = new SelectList(await deliveryMethodQuery.Distinct().ToListAsync()), Courses = await _context.Course.Take(4).ToListAsync() }; return(View(courseDeliveryVM)); }