public ActionResult loadColor(int?productId, int?sizeId) { var productSize = db.ProductColorSize.Where(s => s.ProductId == productId && s.SizeId == sizeId).ToList(); var color = productSize.First().ColorId; int amount = db.ProductColorSize.Where(s => s.SizeId == sizeId && s.ColorId == color).First().Amount; List <Color> list = new List <Color>(); foreach (var item in db.Colors) { foreach (var item2 in productSize) { if (item.Id == item2.ColorId) { list.Add(item); } } } Details_VM vm = new Details_VM { Colors = list, Amount = amount }; return(PartialView("_loadColors", vm)); }
public ActionResult Details(int?id) { Details_VM vm = new Details_VM { Furniture = _context.Furniture.Where(f => f.Id == id).FirstOrDefault(), CategoryId = _context.Furniture.Where(f => f.Id == id).FirstOrDefault().CategoryId }; return(View(vm)); }
// GET: Details public ActionResult Index(int?Id) { if (Id == null) { return(HttpNotFound()); } var user = Session["user"] as User; var product = db.Products.Find(Id); ProductColorSize productColorSize = db.ProductColorSize.Where(p => p.ProductId == Id).FirstOrDefault(); int sizeId = db.ProductColorSize.Where(p => p.ProductId == Id).FirstOrDefault().SizeId; List <Image> productImages = db.Images.Where(s => s.ProductId == Id).ToList(); List <int> productsSize = db.ProductColorSize.Where(i => i.ProductId == Id).ToList().DistinctBy(x => x.SizeId).Select(s => s.SizeId).ToList(); List <int> productsColor = db.ProductColorSize.Where(i => i.ProductId == Id && i.SizeId == sizeId).Select(s => s.ColorId).ToList(); List <Size> sizes = new List <Size>(); List <Color> colors = new List <Color>(); foreach (var item in db.Sizes) { foreach (var item2 in productsSize) { if (item.Id == item2) { sizes.Add(item); } } } foreach (var item in db.Colors) { foreach (var item2 in productsColor) { if (item.Id == item2) { colors.Add(item); } } } if (user == null) { Details_VM vm = new Details_VM { ProductSize = productColorSize, Images = productImages, Sizes = sizes, Colors = colors, Product = product }; } Details_VM vm2 = new Details_VM { ProductSize = productColorSize, Images = productImages, Sizes = sizes, Colors = colors, Product = product, User = Session["user"] as User, Favorites = db.Favorites.ToList() }; return(View(vm2)); }