public ActionResult DeleteConfirmed(int id) { ActualProgramTotal actualProgramTotal = db.ActualProgramTotals.Find(id); db.ActualProgramTotals.Remove(actualProgramTotal); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ActualTotalId,Exercise,Reps,Weight,SavedWorkoutDateId,UserId")] ActualProgramTotal actualProgramTotal) { if (ModelState.IsValid) { db.Entry(actualProgramTotal).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UserId = new SelectList(db.UserProfiles, "UserId", "FirstName", actualProgramTotal.UserId); return(View(actualProgramTotal)); }
// GET: ActualProgramTotals/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ActualProgramTotal actualProgramTotal = db.ActualProgramTotals.Find(id); if (actualProgramTotal == null) { return(HttpNotFound()); } return(View(actualProgramTotal)); }
// GET: ActualProgramTotals/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ActualProgramTotal actualProgramTotal = db.ActualProgramTotals.Find(id); if (actualProgramTotal == null) { return(HttpNotFound()); } ViewBag.UserId = new SelectList(db.UserProfiles, "UserId", "FirstName", actualProgramTotal.UserId); return(View(actualProgramTotal)); }
public void SaveProgramTotals(int userId, int?WorkoutSerial) { var foundLifts = db.Lifts.Where(l => l.UserId == userId && l.WorkoutId == WorkoutSerial && l.Completed == true).ToList(); foreach (var item in foundLifts) { if (item.Exercise == "Squat") { var squatTotalsCount = db.ActualProgramTotals.Where(s => s.Exercise == "Squat" && s.UserId == userId).Count(); if (squatTotalsCount < 1) { ActualProgramTotal programTotals = new ActualProgramTotal(); programTotals.Exercise = "Squat"; programTotals.Reps = 0; programTotals.Weight = 0; programTotals.UserId = userId; db.ActualProgramTotals.Add(programTotals); db.SaveChanges(); var foundProgramTotals = db.ActualProgramTotals.Where(f => f.UserId == userId && f.Exercise == "Squat").FirstOrDefault(); foundProgramTotals.Reps += item.Reps; foundProgramTotals.Weight += item.Weight * item.Reps; db.SaveChanges(); } else { var foundProgramTotals = db.ActualProgramTotals.Where(f => f.UserId == userId && f.Exercise == "Squat").FirstOrDefault(); foundProgramTotals.Reps += item.Reps; foundProgramTotals.Weight += item.Weight * item.Reps; db.SaveChanges(); } } else if (item.Exercise == "Benchpress") { var benchTotalsCount = db.ActualProgramTotals.Where(s => s.Exercise == "Benchpress" && s.UserId == userId).Count(); if (benchTotalsCount < 1) { ActualProgramTotal programTotals = new ActualProgramTotal(); programTotals.Exercise = "Benchpress"; programTotals.Reps = 0; programTotals.Weight = 0; programTotals.UserId = userId; db.ActualProgramTotals.Add(programTotals); db.SaveChanges(); var foundProgramTotals = db.ActualProgramTotals.Where(f => f.UserId == userId && f.Exercise == "Benchpress").FirstOrDefault(); foundProgramTotals.Reps += item.Reps; foundProgramTotals.Weight += item.Weight * item.Reps; db.SaveChanges(); } else { var foundProgramTotals = db.ActualProgramTotals.Where(f => f.UserId == userId && f.Exercise == "Benchpress").FirstOrDefault(); foundProgramTotals.Reps += item.Reps; foundProgramTotals.Weight += item.Weight * item.Reps; db.SaveChanges(); } } else if (item.Exercise == "Deadlift" || item.Exercise == "Deadlift^Knee" || item.Exercise == "Def Deadlift") { var deadTotalsCount = db.ActualProgramTotals.Where(s => s.Exercise == "Deadlift" && s.UserId == userId).Count(); if (deadTotalsCount < 1) { ActualProgramTotal programTotals = new ActualProgramTotal(); programTotals.Exercise = "Deadlift"; programTotals.Reps = 0; programTotals.Weight = 0; programTotals.UserId = userId; db.ActualProgramTotals.Add(programTotals); db.SaveChanges(); var foundProgramTotals = db.ActualProgramTotals.Where(f => f.UserId == userId && f.Exercise == "Deadlift").FirstOrDefault(); foundProgramTotals.Reps += item.Reps; foundProgramTotals.Weight += item.Weight * item.Reps; db.SaveChanges(); } else { var foundProgramTotals = db.ActualProgramTotals.Where(f => f.UserId == userId && f.Exercise == "Deadlift").FirstOrDefault(); foundProgramTotals.Reps += item.Reps; foundProgramTotals.Weight += item.Weight * item.Reps; db.SaveChanges(); } } } db.SaveChanges(); }