public IEnumerable <NumberCommandePerArticle> GetNumberCommandePerArticle()
{
var query = from c in db.Articles
join p in db.Commandes
on c.NumArticle equals p.NumArticle
group new { c, p } by new { c.NumArticle } into g
select new
{
NumberCommande = g.Count(),
NumArticle = g.Key.NumArticle
};
IArticle articles = new ArticleImpl();
foreach (var i in query)
{
NumberCommandePerArticle articlecommande = new NumberCommandePerArticle();
articlecommande.NumberCommande = i.NumberCommande;
articlecommande.ArticleName = articles.GetArticle(i.NumArticle).Designation;
prod.Add(articlecommande);
}
return(prod);
}
public JsonResult GetData()
{
List <NumberCommandePerArticle> prod = new List <NumberCommandePerArticle>();
var query = from c in db.Articles
join p in db.Commandes
on c.NumArticle equals p.NumArticle
group new { c, p } by new { c.Designation } into g
select new
{
NumberCommande = g.Count(),
NumArticle = g.Key.Designation,
};
foreach (var i in query)
{
NumberCommandePerArticle articlecommande = new NumberCommandePerArticle();
articlecommande.NumberCommande = i.NumberCommande;
articlecommande.ArticleName = i.NumArticle;
prod.Add(articlecommande);
}
return(Json(prod, JsonRequestBehavior.AllowGet));
}
