public ActionResult TopSeller() { var sellergroup = from p in db.booked_properties group p by p.seller_id; var topseller = sellergroup.OrderByDescending(s => s.Count()).Take(5); var topsellerid = topseller.Select(s => s.Key); List <TopSellers> sellerss = new List <TopSellers>(); foreach (var item in topsellerid) { var seller = db.sellers.Find(item); var sellerinfo = new TopSellers() { Sellers = seller, TotalBooking = db.booked_properties.Count(s => s.seller_id == seller.seller_id) }; sellerss.Add(sellerinfo); } return(View(sellerss)); }
public void TopSellers() { var c = new TopSellers(); c.Go(); }