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 BLProfile()
{
db = DataLinkLayer.DBconnect();
BLRoutine bl = new BLRoutine();
//DeleteProfile(12);
//ReadProfile(db);
}
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;
}
public int RoutineShowInsert(List<RoutineShow> rsList)
{
Planned rp = new Planned();
Routine routine = new Routine();
Exercise exercise = new Exercise();
BLRoutine bLRoutine = new BLRoutine();
Int32 Exerciseid,routineAdded,routineID = 0;
List<Exercise> exerciseList = DataLinkLayer.DBread<Exercise>(new Exercise());
List<Routine> routineList = DataLinkLayer.DBread<Routine>(new Routine());
Console.WriteLine(routineList);
foreach (RoutineShow routineShow in rsList)
{
Exerciseid = exerciseList.Find(x => x.Name.Equals(routineShow.ExcerciseName)).ExcerciseID;
// add record in Routine table
routine.RoutineName = routineShow.RoutineName;
routineAdded= bLRoutine.InsertRoutine(routine);
routineList = DataLinkLayer.DBread<Routine>(new Routine());
routineID = routineList.Find(x => x.RoutineName.Equals(routineShow.RoutineName)).RoutineID;
if (routineAdded != 0)
{
rp.ExcerciseID = Exerciseid;
rp.RoutineID = routineID;
return InsertRoutinePlanned(rp);
}
}
return 0;
}
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);
}