public ActionResult Manage() { try { ManagerViewModel viewModel = new ManagerViewModel(); DatabaseQuery dbq = new DatabaseQuery(); viewModel.Orders = dbq.GetOrders(); viewModel.Orderlines = dbq.GetOrderlines(); viewModel.OrderlinesAsc = dbq.GetOrderlines(); List<Product> products = dbq.GetProducts(); foreach (Product p in products) { if (viewModel.Orderlines.Any(ol => ol.Product.Id == p.Id)) { continue; } OrderLine o = new OrderLine { Product = p, Amount = 0 }; viewModel.OrderlinesAsc.Add(o); } viewModel.OrderlinesAsc.Reverse(); //take first 10 items from list viewModel.OrderlinesAsc.Take(10); viewModel.Orderlines.Take(10); return View(viewModel); } catch (Exception e) { ViewBag.Error = "Er is iets fout gegaan met het ophalen van de producten: " + e; return View(); } //return RedirectToAction("View", "Home"); //Return naar de Homepage }