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