public List <CreatePie> GetWorkoutDatePie(DateTime start, DateTime end)
{
CreatePie dto = new CreatePie();
var q = from p in db.WorkoutLogs
where p.EditTime >= start && p.EditTime <= end
group p by p.Workout.Name into g
select new CreatePie
{
WorkoutName = g.Key,
Count = g.Count()
};
return(q.ToList());
}
public List <CreatePie> GetWorkoutNamePie()
{
CreatePie dto = new CreatePie();
var q = from p in db.WorkoutLogs
group p by p.Workout.Name into g
select new CreatePie
{
WorkoutName = g.Key,
Count = g.Count(),
//Persent = g.Count() / g.All()
};
return(q.ToList());
}
public List <CreatePie> GetWorkoutGenderPie(bool gender)
{
CreatePie dto = new CreatePie();
var q = /*db.WorkoutLogs.Where(x=>x.)*/
from p in db.WorkoutLogs
where p.Member.Gender == gender
group p by p.Workout.Name into g
select new CreatePie
{
WorkoutName = g.Key,
Count = g.Count()
};
return(q.ToList());
}
