private IndexModel fillIndexModel()
 {
     IndexModel model = new IndexModel();
     DatabaseQuery db = new DatabaseQuery();
     model.Categories = db.GetCategories();
     model.Products = db.GetProducts();
     return model;
 }
 private ProductViewModel FillProductViewModel()
 {
     ProductViewModel model = new ProductViewModel();
     DatabaseQuery dbq = new DatabaseQuery();
     List<Category> categories = dbq.GetCategories();
     model.Categories = new SelectList(categories, "id", "name");
     return model;
 }
 public ActionResult CategoryOverview()
 {
     if (TempData["ErrorMessage"] != null)
     {
         ViewBag.Error = TempData["ErrorMessage"].ToString();
     }
     using (DatabaseQuery query = new DatabaseQuery())
     {
         return View(query.GetCategories());
     }
 }