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