public List <RoutineShow> RoutineShowSend() { Routine rt = new Routine(); Planned rpd = new Planned(); Exercise ex = new Exercise(); BLExercise addExerciseData = new BLExercise(); BLRoutine addRoutineData = new BLRoutine(); RoutineShow eachRoutineShow = new RoutineShow(); //db.DropTable<Routine>(); //db.CreateTable<Routine>(); //BLRoutine bL = new BLRoutine(); //bL.InsertRoutine(new Routine()); //db.DropTable<Planned>(); //db.CreateTable<Planned>(); List <Routine> routine = DataLinkLayer.DBread <Routine>(new Routine()); List <Exercise> exercise = DataLinkLayer.DBread <Exercise>(new Exercise()); List <RoutineShow> finalList = new List <RoutineShow>(); finalList.Clear(); List <Planned> routinePlanned = DataLinkLayer.DBread <Planned>(rpd); Console.WriteLine(routinePlanned); RoutineShow myRoutineShow = new RoutineShow(); foreach (Planned rp in routinePlanned) { String a = routine.Find(x => x.RoutineID == rp.RoutineID).RoutineName; String b = exercise.Find(x => x.ExcerciseID == (rp.ExcerciseID)).Name; Console.WriteLine(a + "-" + b + "-" + rp.Date); if (finalList.Find(x => x.RoutineName.Equals(a)) == null) { RoutineShow routineShow = new RoutineShow(); routineShow.RoutineName = a; routineShow.ExcerciseList.Add(b); routineShow.ExTime = rp.Date; routineShow.Sets.Add(rp.Sets); routineShow.Reps.Add(rp.Reps); routineShow.Lbs.Add(rp.Lbs); finalList.Add(routineShow); } else { finalList.Find(x => x.RoutineName.Equals(a)).ExcerciseList.Add(b); finalList.Find(x => x.RoutineName.Equals(a)).ExTime = rp.Date; finalList.Find(x => x.RoutineName.Equals(a)).Sets.Add(rp.Sets); finalList.Find(x => x.RoutineName.Equals(a)).Reps.Add(rp.Reps); finalList.Find(x => x.RoutineName.Equals(a)).Lbs.Add(rp.Lbs); } } return(finalList); }
public BLPlanned() { db = DataLinkLayer.DBconnect(); bLExercise = new BLExercise(); bLRoutine = new BLRoutine(); exercises = bLExercise.ReadExercise(); routines = bLRoutine.ReadRoutine(); //Planned rpd = new Planned(); // Int32 d = InsertRoutinePlanned(rpd); }
public List<RoutineShow> RoutineShowSend() { Routine rt = new Routine(); //BLRoutine r = new BLRoutine(); //Int32 c = r.InsertRoutine(rt); Planned rpd = new Planned(); // Int32 d = InsertRoutinePlanned(rpd); Exercise ex = new Exercise(); BLExercise addExerciseData = new BLExercise(); // int exCount = addExerciseData.InsertExcercise(ex); BLRoutine addRoutineData = new BLRoutine(); // int rCount = addRoutineData.InsertRoutine(rt); // int d = InsertRoutinePlanned(rpd); List<Routine> routine = DataLinkLayer.DBread<Routine>(new Routine()); List<Exercise> exercise = DataLinkLayer.DBread<Exercise>(new Exercise()); List<Planned> routinePlanned = DataLinkLayer.DBread<Planned>(rpd); Console.WriteLine(routinePlanned); List<RoutineShow> myRoutine = new List<RoutineShow>(); { foreach (Planned rp in routinePlanned) { String a = routine.Find(x => x.RoutineID == rp.RoutineID).RoutineName; String b = exercise.Find(x => x.ExcerciseID == (rp.ExcerciseID)).Name; myRoutine.Add(new RoutineShow { RoutineName = a, ExcerciseName = b }); Console.WriteLine(a + "-" + b); } }; return myRoutine; }