public JsonResult getTopSale() { List <string> label = new List <string>(); List <int> data = new List <int>(); ProductService ps = new ProductService(); TopSaleListViewModel result = ps.GetTopSale(); foreach (var item in result.Item) { label.Add(item.Product_Name.Replace(" ", "").ToString()); data.Add(item.Quantity); } var datas = new { label, data }; //var datas = new { psv.data }; return(Json(datas, JsonRequestBehavior.AllowGet)); }
public TopSaleListViewModel GetTopSale() { TopSaleListViewModel result = new TopSaleListViewModel(); result.Item = new List <TopSaleViewModel>(); DBModel context = new DBModel(); //DbRepository<Order> repo = new DbRepository<Order>(context); var tmp = context.Database.SqlQuery <TopSaleViewModel>(@"select Product_Name, COUNT(*)Quantity FROM[dbo].[OrderDetail] Group By Product_Name Order By Quantity DESC;" ); foreach (var i in tmp) { TopSaleViewModel sqv = new TopSaleViewModel() { Product_Name = i.Product_Name, Quantity = i.Quantity }; result.Item.Add(sqv); } return(result); }