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