public async Task <ActionResult <UserWorkout> > PostUserWorkout(UserWorkout userWorkout) { _context.UserWorkout.Add(userWorkout); await _context.SaveChangesAsync(); return(CreatedAtAction("GetUserWorkout", new { id = userWorkout.Id }, userWorkout)); }
public async Task <IActionResult> PutUserWorkout(int id, UserWorkout userWorkout) { if (id != userWorkout.Id) { return(BadRequest()); } _context.Entry(userWorkout).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UserWorkoutExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public ActionResult DeleteConfirmed(int id) { UserWorkout userWorkout = db.UserWorkouts.Find(id); db.UserWorkouts.Remove(userWorkout); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "UserWorkoutID,WorkoutID,WorkoutDesc,UserID,WeightLifted,TimeOfWorkout,Distance,DistanceUnits,WeightUnits,SentimentID,WorkoutDate,Reps")] UserWorkout userWorkout) { if (ModelState.IsValid) { db.Entry(userWorkout).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UserID = new SelectList(db.Users, "UserID", "UserName", userWorkout.UserID); ViewBag.WorkoutID = new SelectList(db.Workouts, "WorkoutID", "WorkoutBodyArea", userWorkout.WorkoutID); return(View(userWorkout)); }
// GET: UserWorkouts/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } UserWorkout userWorkout = db.UserWorkouts.Find(id); if (userWorkout == null) { return(HttpNotFound()); } return(View(userWorkout)); }
// GET: UserWorkouts/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } UserWorkout userWorkout = db.UserWorkouts.Find(id); if (userWorkout == null) { return(HttpNotFound()); } ViewBag.UserID = new SelectList(db.Users, "UserID", "UserName", userWorkout.UserID); ViewBag.WorkoutID = new SelectList(db.Workouts, "WorkoutID", "WorkoutBodyArea", userWorkout.WorkoutID); return(View(userWorkout)); }
static void Main(string[] args) { // USER TABLE DATA using (var db = new WorkoutManagementContext()) { var user1 = new User(); // user1.Name = "Thomas Thungberg"; user1.FirstName = "Thomas"; user1.LastName = "Thungberg"; db.Add(user1); var user2 = new User(); //user2.Name = "Mattias Karlsson"; user2.FirstName = "Mattias"; user2.LastName = "Karlsson"; db.Add(user2); var user3 = new User(); // user3.Name = "Katarin Peterson"; user3.FirstName = "Katarin"; user3.LastName = "Petersson"; db.Add(user3); db.SaveChanges(); } //ACCESSORY TABLE DATA using (var db = new WorkoutManagementContext()) { var accesory1 = new Accessory(); accesory1.Name = "Skor"; db.Add(accesory1); var accesory2 = new Accessory(); accesory2.Name = "Towel"; db.Add(accesory2); var accesory3 = new Accessory(); accesory3.Name = "YogaMat"; db.Add(accesory3); var accesory4 = new Accessory(); accesory4.Name = "SwimCap"; db.Add(accesory4); var accesory5 = new Accessory(); accesory5.Name = "SmartWatch"; db.Add(accesory5); db.SaveChanges(); } //WORKOUT TABLE DATA using (var db = new WorkoutManagementContext()) { var workout1 = new Workout(); workout1.Name = "Lekis"; workout1.Description = "Motion"; workout1.StartTime = "07:15"; workout1.EndTime = "08:15"; workout1.Type = "Cykling"; db.Add(workout1); var workout2 = new Workout(); workout2.Name = "skoldpadda"; workout2.Description = "Motion"; workout2.StartTime = "09:00"; workout2.EndTime = "10:00"; workout2.Type = "Swimming"; db.Add(workout2); var workout3 = new Workout(); workout3.Name = "Lekrum"; workout3.Description = "Dance"; workout3.StartTime = "16:30"; workout3.EndTime = "17:30"; workout3.Type = "Zumba"; db.Add(workout3); var workout4 = new Workout(); workout4.Name = "Peace"; workout4.Description = "Breathing"; workout4.StartTime = "18:45"; workout4.EndTime = "19:45"; workout4.Type = "Yoga"; db.Add(workout4); var workout5 = new Workout(); workout5.Name = "Sweat"; workout5.Description = "Motion"; workout5.StartTime = "19:50"; workout5.EndTime = "20:50"; workout5.Type = "Jogging"; db.Add(workout5); db.SaveChanges(); } // EXERCISE TABLE DATA using (var db = new WorkoutManagementContext()) { var exercise1 = new Exercise(); exercise1.Name = "Water arm Lifts"; exercise1.Repetition = "10"; db.Add(exercise1); var exercise2 = new Exercise(); exercise2.Name = "BackWall Glide"; exercise2.Repetition = "5 min"; db.Add(exercise2); var exercise3 = new Exercise(); exercise3.Name = "Pranayama"; exercise3.Repetition = "20 min"; db.Add(exercise3); var exercise4 = new Exercise(); exercise4.Name = "Mountain Climbing"; exercise4.Repetition = "20 min"; db.Add(exercise4); var exercise5 = new Exercise(); exercise5.Name = "Macho Dance"; exercise5.Repetition = "25 min"; db.Add(exercise5); db.SaveChanges(); } //USERWORKOUT TABLE DATA using (var db = new WorkoutManagementContext()) { var UW1 = new UserWorkout(); UW1.UserId = 2; UW1.WorkoutId = 2; UW1.AccessoryID = 4; UW1.ExtraAccessory = 2; UW1.ExerciseId = 2; UW1.Difficulty = 4; db.Add(UW1); var UW2 = new UserWorkout(); UW2.UserId = 3; UW2.WorkoutId = 4; UW2.AccessoryID = 3; UW2.ExerciseId = 3; UW2.Difficulty = 6; db.Add(UW2); var UW3 = new UserWorkout(); UW3.UserId = 1; UW3.WorkoutId = 5; UW3.AccessoryID = 2; db.Add(UW3); var UW4 = new UserWorkout(); UW4.UserId = 3; UW4.WorkoutId = 3; UW4.AccessoryID = 1; UW4.ExerciseId = 5; UW4.Difficulty = 8; db.Add(UW4); var UW5 = new UserWorkout(); UW5.UserId = 3; UW5.WorkoutId = 1; UW5.AccessoryID = 1; UW5.ExtraAccessory = 2; UW5.ExerciseId = 4; UW5.Difficulty = 7; db.Add(UW5); var UW6 = new UserWorkout(); UW6.UserId = 2; UW6.WorkoutId = 2; UW6.AccessoryID = 4; UW6.ExtraAccessory = 2; UW6.ExerciseId = 1; UW6.Difficulty = 5; db.Add(UW6); var UW7 = new UserWorkout(); UW7.UserId = 1; UW7.WorkoutId = 4; UW7.AccessoryID = 3; UW7.ExerciseId = 3; UW7.Difficulty = 4; db.Add(UW7); var UW8 = new UserWorkout(); UW8.UserId = 3; UW8.WorkoutId = 5; UW8.AccessoryID = 2; db.Add(UW8); var UW9 = new UserWorkout(); UW9.UserId = 1; UW9.WorkoutId = 3; UW9.AccessoryID = 1; UW9.ExtraAccessory = 2; UW9.ExerciseId = 5; UW9.Difficulty = 9; db.Add(UW9); var UW10 = new UserWorkout(); UW10.UserId = 3; UW10.WorkoutId = 2; UW10.AccessoryID = 4; UW10.ExerciseId = 2; UW10.Difficulty = 2; db.Add(UW10); db.SaveChanges(); } //1. Console.WriteLine("\n\nQueries\n\n"); Console.WriteLine("\n\n1.ALL USER, THEIR WORKOUTNAME AND USERWORKOUTID\n\n"); using (var db = new WorkoutManagementContext()) { var userWorkouts = db.UserWorkouts.OrderBy(UW => UW.user.FirstName).Include(UW => UW.user).Include(UW => UW.workout).ToList(); foreach (var userworkout in userWorkouts) { Console.WriteLine($"UserName: { userworkout.user.FirstName} {userworkout.user.LastName}"); Console.WriteLine($"WorkoutName: {userworkout.workout.Name}"); Console.WriteLine("------"); } } // 4. Console.WriteLine("\n\n4.Highest difficulty level with Exercise,Workout Name Details\n\n "); using (var db = new WorkoutManagementContext()) { var userWorkouts = db.UserWorkouts.OrderByDescending(UW => UW.Difficulty).Include(UW => UW.user). Include(UW => UW.workout).Include(UW => UW.exercise).ToList().First(); Console.WriteLine($"UserWorkoutName:{userWorkouts.workout.Name}" + $"\nUserFirstname: {userWorkouts.user.FirstName}," + $"\nExerciseName: {userWorkouts.exercise.Name.ToString()} " + $"\nDifficulty:{ userWorkouts.Difficulty.ToString()}"); } //3. Console.WriteLine("\n\n3.Displaying how many times each accessory is used\n\n"); //not fully completed using (var db = new WorkoutManagementContext()) { var accessory = db.Accessories.ToList(); int totalitems = accessory.Count(); var userworkouts = db.UserWorkouts.OrderBy(UW => UW.AccessoryID).GroupBy(UW => UW.AccessoryID).ToList(); int i = 1; foreach (var userworkout in userworkouts) { Console.WriteLine($"AccessoryID {i}: Count: {userworkout.Count()} "); i++; } using (var db1 = new WorkoutManagementContext()) { var eList = db1.Accessories.Where( Accessory => !db1.UserWorkouts.Any( we => we.AccessoryID == Accessory.AccessoryId)). Select(Accessory => Accessory.AccessoryId).ToList(); foreach (var e in eList) { Console.WriteLine($"AccessoryID {e}: Count: 0"); } } } //2. Console.WriteLine("\n\n2. Accessory which is not used"); using (var db = new WorkoutManagementContext()) { var eList = db.Accessories.Where( Accessory => !db.UserWorkouts.Any( we => we.AccessoryID == Accessory.AccessoryId)). Select(Accessory => Accessory.Name).ToList(); Console.WriteLine("\n\nUnused Accessory:"); foreach (var e in eList) { Console.WriteLine(e); } } }