public List <ExerciseShow> RoutineShowSend(String RoutineName) { List <ExerciseShow> exerciseShows = new List <ExerciseShow>(); RoutineShow routine = RoutineShowSend().Find(x => x.RoutineName.Equals(RoutineName)); List <String> exList = routine.ExcerciseList; String timeList = routine.ExTime; List <Int32> sets = routine.Sets; List <String> reps = routine.Reps; List <String> lbs = routine.Lbs; for (int i = 0; i < routine.ExcerciseList.Count; i++) { ExerciseShow exerciseShow = new ExerciseShow(); exerciseShow.ExcerciseName = exList[i]; char firstChar = Char.ToLower(exerciseShow.ExcerciseName[0]); exerciseShow.ImageURL = "alphabet/" + firstChar; exerciseShow.ExTime = timeList; exerciseShow.Sets = sets[i]; exerciseShow.Reps = reps[i]; exerciseShow.Lbs = lbs[i]; exerciseShow.RoutineName = RoutineName; exerciseShows.Add(exerciseShow); } return(exerciseShows); }
public Int32 RoutineShowInsertExecuted(ExerciseShow exerciseShow) { rsList = new List <RoutineShow>(); Int32 Exerciseid, routineAdded, routineID = 0; Exerciseid = exerciseList.Find(x => x.Name.Equals(exerciseShow.ExcerciseName)).ExcerciseID; // add record in Routine table routine.RoutineName = exerciseShow.RoutineName; routineAdded = bLRoutine.InsertRoutine(routine); routineList = bLRoutine.ReadRoutine(); if (routineAdded != 0) { Console.WriteLine(); routineID = routineList.Find(x => x.RoutineName.Equals(exerciseShow.RoutineName)).RoutineID; rExecuted.RoutinePlannedID = planneds.Find(x => (x.ExcerciseID == Exerciseid) && (x.RoutineID == routineID)).ID; rExecuted.ExerciseID = Exerciseid; rExecuted.RoutineID = routineID; rExecuted.Date = exerciseShow.ExTime; rExecuted.Sets = exerciseShow.Sets; rExecuted.Reps = exerciseShow.Reps; rExecuted.lbs = exerciseShow.Lbs; Console.WriteLine(); return(InsertRoutineExecuted(rExecuted)); } return(0); }
public void UpdatePlanned(ExerciseShow exerciseShow) { Planned planned = ReadRoutinePlanned(exerciseShow); planned.Reps = exerciseShow.Reps; planned.Lbs = exerciseShow.Lbs; DataLinkLayer.DBupdate(planned); }
// delete exercise from planned routine public Boolean DeletePlanned(ExerciseShow exerciseShow) { Planned toDelPlanned = ReadRoutinePlanned(exerciseShow); if (DataLinkLayer.DBdelete <Planned>(toDelPlanned) > 0) { return(true); } return(false); }
public Planned ReadRoutinePlanned(ExerciseShow exerciseShow) { List <Planned> planneds = ReadRoutinePlanned(); List <Exercise> exerciseList = DataLinkLayer.DBread <Exercise>(new Exercise()); List <Routine> routineList = DataLinkLayer.DBread <Routine>(new Routine()); Int32 routineID = routineList.Find(x => x.RoutineName.Equals(exerciseShow.RoutineName)).RoutineID; Int32 Exerciseid = exerciseList.Find(x => x.Name.Equals(exerciseShow.ExcerciseName)).ExcerciseID; return(planneds.Find(x => x.RoutineID == routineID && x.ExcerciseID == Exerciseid)); }
public Int32 RoutineShowInsert(ExerciseShow exerciseShow) { List <RoutineShow> rsList = new List <RoutineShow>(); Planned rp = new Planned(); Routine routine = new Routine(); Exercise exercise = new Exercise(); BLRoutine bLRoutine = new BLRoutine(); BLPlanned bLPlanned = new BLPlanned(); Int32 Exerciseid, routineAdded, routineID = 0; List <Exercise> exerciseList = DataLinkLayer.DBread <Exercise>(new Exercise()); List <Routine> routineList = DataLinkLayer.DBread <Routine>(new Routine()); Exerciseid = exerciseList.Find(x => x.Name.Equals(exerciseShow.ExcerciseName)).ExcerciseID; // add record in Routine table routine.RoutineName = exerciseShow.RoutineName; routineAdded = bLRoutine.InsertRoutine(routine); routineList = DataLinkLayer.DBread <Routine>(new Routine()); if (routineAdded != 0) { Console.WriteLine(); routineID = routineList.Find(x => x.RoutineName.Equals(exerciseShow.RoutineName)).RoutineID; rp.ExcerciseID = Exerciseid; rp.RoutineID = routineID; rp.Date = exerciseShow.ExTime; rp.Sets = exerciseShow.Sets; rp.Reps = exerciseShow.Reps; rp.Lbs = exerciseShow.Lbs; Console.WriteLine(); return(bLPlanned.InsertRoutinePlanned(rp)); } return(0); }