// public IEnumerable<product> getProdById(int id)
// {
//
// return uf.getRepository<product>().GetAll().Where(e => e.CategoryId == id);
// }
public List <GroupModel> getQuantiteProdByCat()
{
/* var productListResult = uf.getRepository<product>().GetAll()
* .GroupBy(pv => pv.ProductPk)
* .Select(g => new
* {
* Product = g.Key,
* TotalOrderCount = g.Count(),
* TotalSales = g.Sum(pv => pv.Price),
* TotalQuantity = g.Sum(pv => pv.Quantity),
* })
* .OrderByDescending(x => x.TotalOrderCount).ToList();*/
/* foreach (var line in uf.getRepository<product>().GetAll().GroupBy(info => info.CategoryId)
* .Select(group => new {
* Metric = group.Key,
* Count = group.Count()
* })
* .OrderBy(x => x.Metric)
* {
* Console.WriteLine("{0} {1}", line.Metric, line.Count);
* }*/
var query = from p in uf.getRepository <product>().GetAll()
join c in uf.getRepository <category>().GetAll() on p.CategoryId equals c.CategoryId into e
from j in e.DefaultIfEmpty()
group p by p.CategoryId into g
select new GroupModel
{
id = i++,
Color = String.Format("#{0:X6}", rnd.Next(0x1000000)),
Highlight = String.Format("#{0:X6}", rnd.Next(0x1000000)),
Quantite = g.ToList().Count(),
CateogryName = uf.getRepository <category>().GetAll().Where(e => e.CategoryId == g.First().CategoryId).Single()
};
return(query.ToList());
}
public IEnumerable <product> getProdById(int id)
{
return(utwk.getRepository <product>().GetAll().Where(e => e.category_fk == id));
}
public virtual conger GetById(long id)
{
// return _repository.GetById(id);
return(uof.getRepository <conger>().GetById(id));
}
public List <ExpositionArtwork> ExpositionArtworksByIdExposition(int idE)
{
return(utw.getRepository <ExpositionArtwork>().GetMany().Where(a => a.exposureId == idE).ToList());
}
public IEnumerable <ReservationEvent> getReservationsEventByUser(string idSimpleUSer)
{
return(ut.getRepository <ReservationEvent>().GetMany(x => x.IdSimpleUser == idSimpleUSer));
}
