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));
}
