public List <CompanyCodeCounts> TotalItemsByCompany()
{
using (PharmaDBEntities context = new PharmaDBEntities())
{
var companyCodeCounts = itemMasterDao.GetAllItems().GroupBy(p => p.CompanyCode)
.Select(q => new CompanyCodeCounts()
{
CompanyCode = q.Key,
CompanyCodeCount = q.Count()
}
).ToList();
return(companyCodeCounts);
}
}
