public ActionResult Index() { Models.Home home = new Models.Home(); using (var context = new BanDoDienTuEntities()) { var feature = from sp in context.SanPhams join lsp in context.LoaiSanPhams on sp.MaLoai equals lsp.MaLoai where lsp.TenLoai == "mới nhập" select new Models.Product { MaSP = sp.MaSP, TenSP = sp.TenSP, DonGia = sp.GiaBan, Hinh = sp.Hinh }; home.FeaturePhone = feature.Take(6).ToList(); //đếm số lượng sản phẩm List <Models.BrandHome> li = new List <Models.BrandHome>(); Models.Brand brand = new Models.Brand(); List <Models.Brand> b = brand.GetBrand(); foreach (Models.Brand item in b) { Models.BrandHome brh = new Models.BrandHome(); brh.MaNSX = item.MaNSX; brh.TenNSX = item.TenNSX; var h = from sp in context.SanPhams join nsx in context.NhaSanXuats on sp.MaNSX equals nsx.MaNSX where nsx.TenNSX == item.TenNSX select new Models.Product { }; brh.SoLuong = h.Count(); li.Add(brh); } home.brand = li; } return(View(home)); }
//brand #region public ActionResult Brand(int page = 1) { Models.Brand listbrand = new Models.Brand(); return(View(listbrand.GetBrand().ToPagedList(page, 2))); }