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()); }