public async Task <IActionResult> Index() { ListKlantViewModel viewModel = new ListKlantViewModel(); viewModel.Klanten = await _context.Klanten.ToListAsync(); return(View(viewModel)); }
public async Task <IActionResult> Search(ListKlantViewModel viewModel) { IQueryable <Klant> queryableKlanten = _context.Klanten.AsQueryable(); if (!string.IsNullOrEmpty(viewModel.NaamSearch)) { queryableKlanten = queryableKlanten.Where(k => k.Naam.StartsWith(viewModel.NaamSearch)); } if (!string.IsNullOrEmpty(viewModel.VoornaamSearch)) { queryableKlanten = queryableKlanten.Where(k => k.Voornaam.StartsWith(viewModel.VoornaamSearch)); } viewModel.Klanten = await queryableKlanten.ToListAsync(); return(View("Index", viewModel)); }