// Add a workout to the database and collections. public void AddWorkout(Workout newWorkout) { // Add a workout to the data context. workoutDB.Workout.InsertOnSubmit(newWorkout); // Save changes to the database. workoutDB.SubmitChanges(); // Add a workout to the "all" observable collection. AllWorkouts.Add(newWorkout); }
// Remove a workout from the database and collections. public void DeleteWorkout(Workout workoutForDelete) { // Remove the workout from the "all" observable collection. AllWorkouts.Remove(workoutForDelete); // Remove the workout from the data context. workoutDB.Workout.DeleteOnSubmit(workoutForDelete); // Save changes to the database. workoutDB.SubmitChanges(); }
public ActionResult <AllWorkouts> GetAllWorkouts() { var userName = User.Claims.Single(a => a.Type == ClaimTypes.NameIdentifier).Value; var exercises = _context.Exercises.Where(i => i.Creator == userName || i.Creator == "").ToList(); if (exercises == null) { return(NotFound("Exercises not found")); } var UserData = _context.UserData.Where(i => i.User == userName).First(); var result = _context.Workouts .Where(i => i.UserData == UserData) .Include(i => i.Exercises).ThenInclude(i => i.Sets) .ToList(); if (result == null) { return(NotFound("Workouts not found")); } AllWorkouts allworkouts = new AllWorkouts { Workouts = result.Select(i => new GymBuddyAPI.Models.WorkoutModel() { Id = i.Id, Name = i.WorkoutName, Exercises = i.Exercises.Select(j => new ExerciseModel() { Id = j.Id, ExerciseName = j.Name, Type = j.ExerciseType, Sets = j.Sets.Select(k => new SetModel() { Id = k.Id, RepCount = k.RepCount, Weights = k.Weight }).ToList() }).ToList() }).ToList() }; return(Ok(allworkouts)); }
public ActionResult <AllWorkouts> DeleteWorkout(long id) { var userName = User.Claims.Single(a => a.Type == ClaimTypes.NameIdentifier).Value; var value = _context.Workouts.First(i => i.UserData.User == userName && i.Id == id); if (value == null) { return(NotFound("Workout not found")); } var schedule = _context.UserData.Include(i => i.UserSchedule).First(i => i.User == userName).UserSchedule; if (schedule.Monday == value) { schedule.Monday = null; } if (schedule.Tuesday == value) { schedule.Tuesday = null; } if (schedule.Wednesday == value) { schedule.Wednesday = null; } if (schedule.Thursday == value) { schedule.Thursday = null; } if (schedule.Friday == value) { schedule.Friday = null; } if (schedule.Saturday == value) { schedule.Saturday = null; } if (schedule.Sunday == value) { schedule.Sunday = null; } _context.SaveChanges(); var delete = _context.Workouts.Remove(value); var databaseFunction = _context.Workouts.Include(i => i.UserData).Select(i => i.UserData.User == userName).ToList(); _context.SaveChanges(); var result2 = new AllWorkouts() { Workouts = _context.Workouts .Include(i => i.UserData) .Where(i => i.UserData.User == userName) .Select(i => new WorkoutModel { Id = i.Id, Name = i.WorkoutName, }).ToList() }; return(Ok(result2)); }