public IActionResult Index() { var product = dataContext.Products.Select(p => p).ToList(); var laptop = dataContext.Laptops.Select(p => p).ToList(); var pc = dataContext.PCs.Select(p => p).ToList(); var account = dataContext.Users.Select(p => p).ToList(); List <Product> productLaptop = new List <Product>(); List <Product> productPC = new List <Product>(); List <LaptopCategory> laptopCategories = new List <LaptopCategory>(); List <PCCategory> pcCategories = new List <PCCategory>(); foreach (var item in laptop) { Product newLaptop = dataContext.Products.FirstOrDefault(p => p.ProductId == item.ProductId); productLaptop.Add(newLaptop); LaptopCategory laptopCategory = dataContext.LaptopCategories.FirstOrDefault(p => p.LaptopCategoryId == item.LaptopCategoryId); laptopCategories.Add(laptopCategory); } foreach (var item in pc) { Product newpc = dataContext.Products.FirstOrDefault(p => p.ProductId == item.ProductId); productPC.Add(newpc); PCCategory pcCategory = dataContext.PCCategories.FirstOrDefault(p => p.PCCategoryId == item.PCCategoryId); pcCategories.Add(pcCategory); } ViewBag.Product = product.Count(); ViewBag.Laptop = laptop.Count(); ViewBag.PC = pc.Count(); ViewBag.Account = account.Count(); ViewBag.ListLaptop = laptop; ViewBag.ListPC = pc; return(View()); }
public IActionResult Index(int id) { Product product = dataContext.Products.FirstOrDefault(p => p.ProductId == id); Brand brand = dataContext.Brands.FirstOrDefault(p => p.BrandId == product.BrandId); if (product.CategoryId == 1) { Laptop laptop = dataContext.Laptops.FirstOrDefault(p => p.ProductId == product.ProductId); if (laptop == null) { ViewBag.Status = 1; } else { ViewBag.Laptop = laptop; LaptopCategory laptopCategory = dataContext.LaptopCategories.FirstOrDefault(p => p.LaptopCategoryId == laptop.LaptopCategoryId); ViewBag.Category = laptopCategory.LaptopCategoryName; } } else { PC pc = dataContext.PCs.FirstOrDefault(p => p.ProductId == product.ProductId); if (pc == null) { ViewBag.Status = 1; } else { ViewBag.PC = pc; PCCategory pCCategory = dataContext.PCCategories.FirstOrDefault(p => p.PCCategoryId == pc.PCCategoryId); ViewBag.Category = pCCategory.PCCategoryName; } } return(View(product)); }
public IActionResult Detail(int id) { PC pc = dataContext.PCs.FirstOrDefault(p => p.PCId == id); Product product = dataContext.Products.FirstOrDefault(p => p.ProductId == pc.ProductId); PCCategory pcCategory = dataContext.PCCategories.FirstOrDefault(p => p.PCCategoryId == pc.PCCategoryId); Brand brand = dataContext.Brands.FirstOrDefault(p => p.BrandId == product.BrandId); ViewBag.product = product.ProductName; ViewBag.brand = brand.BrandName; ViewBag.category = pcCategory.PCCategoryName; return(View(pc)); }
public IActionResult Index(string search, string name = null) { var query = dataContext.PCs.Select(p => p).ToList(); List <PCCategory> pcCategories = new List <PCCategory>(); List <Product> pc = new List <Product>(); foreach (var item in query) { PCCategory pcCategory = dataContext.PCCategories.FirstOrDefault(p => p.PCCategoryId == item.PCCategoryId); pcCategories.Add(pcCategory); Product product = dataContext.Products.FirstOrDefault(p => p.ProductId == item.ProductId); pc.Add(product); } var categoryList = dataContext.PCCategories.Select(p => p).ToList(); ViewBag.Category = categoryList; var queryName = dataContext.PCs.Where(s => s.Product.ProductName.Contains(search)).ToList(); if (!string.IsNullOrEmpty(search) && name == "all") { return(View(queryName)); } else if (name != null && !string.IsNullOrEmpty(search)) { var queryNameInCategory = dataContext.PCs.Where(s => s.PCCategory.PCCategoryName == name && s.Product.ProductName.Contains(search)).ToList(); return(View(queryNameInCategory)); } else if (name == null && string.IsNullOrEmpty(search)) { return(View(query)); } else if (string.IsNullOrEmpty(search) && name != "all") { var queryCategory = dataContext.PCs.Where(s => s.PCCategory.PCCategoryName == name).ToList(); return(View(queryCategory)); } return(View(query)); }