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