public IActionResult CategoryProfile(int categoryId) { List <Products> AllProducts = dbContext.Products .ToList(); @ViewBag.AllProducts = AllProducts; DateTime CurrentTime = DateTime.Now; ViewBag.Now = CurrentTime; Categories retrievedCategory = dbContext.Categories.SingleOrDefault(u => u.CategoriesId == categoryId); @ViewBag.retrievedCategory = retrievedCategory; AddProductToCategoryView newCategoryToProduct = new AddProductToCategoryView(); newCategoryToProduct.Products = dbContext.Products .Include(c => c.Associated) .ThenInclude(a => a.Categories) .ToList(); newCategoryToProduct.Categories = dbContext.Categories .Where(p => p.CategoriesId == categoryId) .FirstOrDefault(); // AddProductToCategoryView newProductToCategory = new AddProductToCategoryView(); // // Categories thisCategory = dbContext.Categories // // .Where(c => c.CategoriesId == categoryId) // // .Include(c => c.Associations) // // .ThenInclude(assoc => assoc.Products) // // .FirstOrDefault(); // // newProductToCategory.Products = dbContext.Products // // .Include(p => p.Associated).ToList(); // // @ViewBag.AddProdToCategoryView = newProductToCategory; var categoryWithProducts = dbContext.Categories .Include(category => category.Associations) .ThenInclude(sub => sub.Products) .FirstOrDefault(category => category.CategoriesId == categoryId); @ViewBag.categoryWithProducts = categoryWithProducts; return(View()); }
public IActionResult Show(int CategoryID) { AddProductToCategoryView AddProdToCategoryView = new AddProductToCategoryView(); Category thisCategory = dbContext.Categories .Where(c => c.CategoryID == CategoryID) .Include(c => c.AssociatedProducts) .ThenInclude(assoc => assoc.Product) .FirstOrDefault(); AddProdToCategoryView.Category = thisCategory; AddProdToCategoryView.Products = dbContext.Products .Include(p => p.AssociatedCategories).ToList(); return(View(AddProdToCategoryView)); //AddProductToCategory }