// neil - create logged exercise with a routine public LoggedExercise createLoggedExercise(Int32 userID, Int32 exerciseID, Int32 routineID) { using (var context = new Layer2Container()) { Exercise exercise = context.Exercises.Where(e => e.id == exerciseID).FirstOrDefault(); LimitBreaker limitBreaker = context.LimitBreakers.Where(l => l.id == userID).FirstOrDefault(); Routine routine = context.Routines.Where(r => r.id == routineID).FirstOrDefault(); if (exercise != null && limitBreaker != null && routine != null) { LoggedExercise log; log = new LoggedExercise(); log.timeLogged = DateTime.Now; log.Exercise = exercise; log.LimitBreaker = limitBreaker; log.Routine = routine; context.LoggedExercises.AddObject(log); context.SaveChanges(); return log; } else { return null; } } }
public ActionResult DeleteConfirmed(int id) { LoggedExercise loggedexercise = db.LoggedExercises.Find(id); db.LoggedExercises.Remove(loggedexercise); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Delete(int id = 0) { LoggedExercise loggedexercise = db.LoggedExercises.Find(id); if (loggedexercise == null) { return(HttpNotFound()); } return(View(loggedexercise)); }
public LoggedExercise createLoggedExerciseRoutine(int userID, int exerciseID, int routineID, int sets, DateTime logTime, string note) { using (var context = new Layer2Container()) { LoggedExercise rc = new LoggedExercise(); try { LimitBreaker lb = context.LimitBreakers.Where(x => x.id == userID).FirstOrDefault(); Exercise ex = context.Exercises.Where(x => x.id == exerciseID).FirstOrDefault(); Routine rtn = context.Routines.Where(x => x.id == routineID).FirstOrDefault(); if (lb != null && ex != null) { rc.LimitBreaker = lb; rc.Exercise = ex; rc.Routine = rtn; rc.timeLogged = logTime; context.LoggedExercises.AddObject(rc); context.SaveChanges(); } } catch (NullReferenceException e) { Console.WriteLine(e.Message + Environment.NewLine + e.StackTrace); // write off the execeptions to my error.log file StreamWriter wrtr = new StreamWriter(System.Web.HttpContext.Current.ApplicationInstance.Server.MapPath("~/assets/documents/" + @"\" + "error.log"), true); wrtr.WriteLine(DateTime.Now.ToString() + " | Error: " + e); wrtr.Close(); } return rc; } }