public dynamic Themestat()
{
IserviceEvent spe = new ServiceEvent();
var eve = spe.GetAll();
var _event = eve.GroupBy(s => s.theme).Select(s => new { thname = s.Key.designation, thval = s.Count() }).ToList();
return(_event);
}
public dynamic Univstat()
{
IserviceEvent spe = new ServiceEvent();
IserviceUniv spun = new serviceUniv();
int total = spe.GetAll().Count();
var univstat = spun.GetAll().Select(x => new { name = x.UnivName, y = spe.GetMany(s => s.hostedby.idUniv == x.idUniv).Count() }).ToList();
return(univstat.Select(x => new { name = x.name, y = x.y }));
}