private StatisicsVM GetTotalDistanceDone(string userID) { var totalDistanceStat = WorkoutSession .Where(t => t.UserId == userID && t.Type == "Cardio") .Select(d => d.Distance) .Sum(); StatisicsVM statToReturn = new StatisicsVM(); statToReturn.TypeOfWorkoutSession = "Cardio"; statToReturn.Stats = new TotalCardioDistansStat() { Distans = Convert.ToDouble(totalDistanceStat) }; return(statToReturn); }
private StatisicsVM GetPopularStrength(string userID) { var popularStrength = UserExercises .Where(t => t.UserId == userID && t.Type == "Strength") .Select(d => d.Name) .Count(); StatisicsVM statToReturn = new StatisicsVM(); statToReturn.TypeOfWorkoutSession = "General"; statToReturn.Stats = new MostPopularStrength() { Name = popularStrength.ToString() }; return(statToReturn); }
private StatisicsVM GetTotalLiftetWeight(string userID) { var workOutSessions = WorkoutSession .Where(c => c.UserId == userID && c.Type == "Strength") .Select(x => x.Exercise .Select(y => y.Set.Sum(z => z.Reps * z.UsedWeight))) .Select(w => w.Sum()) .Sum(); StatisicsVM statToReturn = new StatisicsVM(); statToReturn.TypeOfWorkoutSession = "Strength"; statToReturn.Stats = new TotalStrengthStats() { TotalWeightLifted = workOutSessions }; return(statToReturn); }
private StatisicsVM GetWeightStatFull(string userID) { var dataToReturn = new StatisicsVM(); dataToReturn.TypeOfWorkoutSession = "General"; var Data = new WeightChangeGrafStat(); Data.DateData = UserWeight .Where(u => u.UserId == userID) .OrderBy(e => e.Date) .Select(c => c.Date).ToArray(); Data.WeightData = UserWeight .Where(u => u.UserId == userID) .OrderBy(e => e.Date) .Select(c => c.UserWeight1).ToArray(); dataToReturn.Stats = Data; return(dataToReturn); }
private StatisicsVM GetCardioVsStr(string userID) { int [] countArray = new int [3]; var countStrength = WorkoutSession .Where(b => b.UserId == userID && b.Type == "Strength").Count(); countArray[0] = countStrength; var countCardio = WorkoutSession .Where(b => b.UserId == userID && b.Type == "Cardio").Count(); countArray[1] = countCardio; var countOther = WorkoutSession .Where(b => b.UserId == userID && b.Type == "Other").Count(); countArray[2] = countOther; string [] namesArray = new string[3] { "Strength", "Cardio", "Other" }; StatisicsVM statToReturn = new StatisicsVM(); statToReturn.TypeOfWorkoutSession = "General"; var data = new PieChartStat(); data.Data = countArray; data.Names = namesArray; statToReturn.Stats = data; return(statToReturn); }