// GET: Vineyards public async Task <IActionResult> Index(int?ID, int?VineGrowerID, int?WineID) { var viewModel = new VineyardsIndexData(); viewModel.Vineyards = await _context.Vineyards.Include(v => v.VineGrower).Include(v => v.Wine).ToListAsync(); if (ID != null) { viewModel.Vineyards = viewModel.Vineyards.Where(v => v.VineyardID == ID); } if (VineGrowerID != null) { ViewData["Fullname"] = _context.VineGrowers.Where(v => v.ID == VineGrowerID).Single().FullName; viewModel.Vineyards2 = _context.Vineyards.Where(v => v.VineGrowerID == VineGrowerID); } if (WineID != null) { viewModel.Vineyards3 = await _context.Vineyards.Include(v => v.VineGrower).Include(v => v.Wine).ToListAsync(); ViewData["Type"] = _context.Wines.Where(v => v.WineID == WineID).Single().Type; viewModel.Vineyards3 = _context.Vineyards.Where(v => v.WineID == WineID); } return(View(viewModel)); }
public async Task<IActionResult> Index() { var viewModel = new VineyardsIndexData(); viewModel.Vineyards = await _context.Vineyards.Include(v => v.VineGrower).Include(v => v.Wine).ToListAsync(); viewModel.VineGrowers = _context.VineGrowers; viewModel.Wines = _context.Wines; return View(viewModel); }