public void CreateSavedWorkoutDateTime() { var userId = ReturnCurrentUserId(); var actualSquatTotals = db.ActualProgramTotals.Where(r => r.UserId == userId && r.Exercise == "Squat").FirstOrDefault(); var actualBenchTotals = db.ActualProgramTotals.Where(r => r.UserId == userId && r.Exercise == "Benchpress").FirstOrDefault(); var actualDeadliftTotals = db.ActualProgramTotals.Where(r => r.UserId == userId && r.Exercise == "Deadlift").FirstOrDefault(); var expectedSquatTotals = db.ExpectedProgramTotals.Where(r => r.UserId == userId && r.Exercise == "Squat").FirstOrDefault(); var expectedBenchTotals = db.ExpectedProgramTotals.Where(r => r.UserId == userId && r.Exercise == "Benchpress").FirstOrDefault(); var expectedDeadliftTotals = db.ExpectedProgramTotals.Where(r => r.UserId == userId && r.Exercise == "Deadlift").FirstOrDefault(); var newSavedWorkoutDateTime = new SavedWorkoutDateTime(); newSavedWorkoutDateTime.Date = DateTime.Now; tempSavedWorkoutDate = newSavedWorkoutDateTime.Date; newSavedWorkoutDateTime.ActualSquatReps = actualSquatTotals.Reps; var actualSquatReps = Convert.ToString(newSavedWorkoutDateTime.ActualSquatReps); newSavedWorkoutDateTime.ActualSquatWeight = actualSquatTotals.Weight; var actualSquatWeight = Convert.ToString(newSavedWorkoutDateTime.ActualSquatWeight); newSavedWorkoutDateTime.ActualBenchReps = actualBenchTotals.Reps; var actualBenchReps = Convert.ToString(newSavedWorkoutDateTime.ActualBenchReps); newSavedWorkoutDateTime.ActualBenchWeight = actualBenchTotals.Weight; var actualBenchWeight = Convert.ToString(newSavedWorkoutDateTime.ActualBenchWeight); newSavedWorkoutDateTime.ActualDeadliftReps = actualDeadliftTotals.Reps; var actualDeadliftReps = Convert.ToString(newSavedWorkoutDateTime.ActualDeadliftReps); newSavedWorkoutDateTime.ActualDeadliftWeight = actualDeadliftTotals.Weight; var actualDeadliftWeight = Convert.ToString(newSavedWorkoutDateTime.ActualDeadliftWeight); newSavedWorkoutDateTime.ExpectedSquatReps = expectedSquatTotals.Reps; var expectedSquatReps = Convert.ToString(newSavedWorkoutDateTime.ExpectedSquatReps); newSavedWorkoutDateTime.ExpectedSquatWeight = expectedSquatTotals.Weight; var expectedSquatWeight = Convert.ToString(newSavedWorkoutDateTime.ExpectedSquatWeight); newSavedWorkoutDateTime.ExpectedBenchReps = expectedBenchTotals.Reps; var expectedBenchReps = Convert.ToString(newSavedWorkoutDateTime.ExpectedBenchReps); newSavedWorkoutDateTime.ExpectedBenchWeight = expectedBenchTotals.Weight; var expectedBenchWeight = Convert.ToString(newSavedWorkoutDateTime.ExpectedBenchWeight); newSavedWorkoutDateTime.ExpectedDeadliftReps = expectedDeadliftTotals.Reps; var expectedDeadliftReps = Convert.ToString(newSavedWorkoutDateTime.ExpectedDeadliftReps); newSavedWorkoutDateTime.ExpectedDeadliftWeight = expectedDeadliftTotals.Weight; var expectedDeadliftWeight = Convert.ToString(newSavedWorkoutDateTime.ExpectedDeadliftWeight); newSavedWorkoutDateTime.CompletedSquatReps = $"{actualSquatReps} / {expectedSquatReps}"; newSavedWorkoutDateTime.CompletedSquatWeight = $"{actualSquatWeight} / {expectedSquatWeight}"; newSavedWorkoutDateTime.CompletedBenchReps = $"{actualBenchReps} / {expectedBenchReps}"; newSavedWorkoutDateTime.CompletedBenchWeight = $"{actualBenchWeight} / {expectedBenchWeight}"; newSavedWorkoutDateTime.CompletedDeadliftReps = $"{actualDeadliftReps} / {expectedDeadliftReps}"; newSavedWorkoutDateTime.CompletedDeadliftWeight = $"{actualDeadliftWeight} / {expectedDeadliftWeight}"; newSavedWorkoutDateTime.UserId = userId; db.SavedWorkoutDateTimes.Add(newSavedWorkoutDateTime); db.SaveChanges(); }
public ActionResult DeleteConfirmed(int id) { SavedWorkoutDateTime savedWorkoutDateTime = db.SavedWorkoutDateTimes.Find(id); db.SavedWorkoutDateTimes.Remove(savedWorkoutDateTime); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "SavedWorkoutDateTimeId,Date,CompletedSquatReps,CompletedSquatWeight,CompletedBenchReps,CompletedBenchWeight,CompletedDeadliftReps,CompletedDeadliftWeight,ActualSquatReps,ExpectedSquatReps,ActualBenchReps,ExpectedBenchReps,ActualDeadliftReps,ExpectedDeadliftReps,ActualSquatWeight,ExpectedSquatWeight,ActualBenchWeight,ExpectedBenchWeight,ActualDeadliftWeight,ExpectedDeadliftWeight,UserId")] SavedWorkoutDateTime savedWorkoutDateTime) { if (ModelState.IsValid) { db.Entry(savedWorkoutDateTime).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UserId = new SelectList(db.UserProfiles, "UserId", "FirstName", savedWorkoutDateTime.UserId); return(View(savedWorkoutDateTime)); }
// GET: SavedWorkoutDateTimes/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SavedWorkoutDateTime savedWorkoutDateTime = db.SavedWorkoutDateTimes.Find(id); if (savedWorkoutDateTime == null) { return(HttpNotFound()); } return(View(savedWorkoutDateTime)); }
// GET: SavedWorkoutDateTimes/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SavedWorkoutDateTime savedWorkoutDateTime = db.SavedWorkoutDateTimes.Find(id); if (savedWorkoutDateTime == null) { return(HttpNotFound()); } ViewBag.UserId = new SelectList(db.UserProfiles, "UserId", "FirstName", savedWorkoutDateTime.UserId); return(View(savedWorkoutDateTime)); }
public ActionResult Create([Bind(Include = "SavedWorkoutDateTimeId,Date,CompletedSquatReps,CompletedSquatWeight,CompletedBenchReps,CompletedBenchWeight,CompletedDeadliftReps,CompletedDeadliftWeight,ActualSquatReps,ExpectedSquatReps,ActualBenchReps,ExpectedBenchReps,ActualDeadliftReps,ExpectedDeadliftReps,ActualSquatWeight,ExpectedSquatWeight,ActualBenchWeight,ExpectedBenchWeight,ActualDeadliftWeight,ExpectedDeadliftWeight,UserId")] SavedWorkoutDateTime savedWorkoutDateTime) { if (ModelState.IsValid) { var appUserId = User.Identity.GetUserId(); var currentUser = db.UserProfiles.Where(u => u.ApplicationId == appUserId).FirstOrDefault(); savedWorkoutDateTime.UserId = currentUser.UserId; db.SavedWorkoutDateTimes.Add(savedWorkoutDateTime); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UserId = new SelectList(db.UserProfiles, "UserId", "FirstName", savedWorkoutDateTime.UserId); return(View(savedWorkoutDateTime)); }
// GET: SavedWorkoutDateTimes/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SavedWorkoutDateTime savedWorkoutDateTime = db.SavedWorkoutDateTimes.Find(id); if (savedWorkoutDateTime == null) { return(HttpNotFound()); } var foundSavedWorkouts = db.SavedWorkouts.Where(s => s.SavedWorkoutDateId == id).ToList(); return(View(foundSavedWorkouts.ToList())); }