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();
}
