public List <RoutineShow> RoutineShowSend()
{
Routine rt = new Routine();
//BLRoutine r = new BLRoutine();
//Int32 c = r.InsertRoutine(rt);
RoutinePlanned rpd = new RoutinePlanned();
// Int32 d = InsertRoutinePlanned(rpd);
int d = InsertRoutinePlanned(rpd);
List <RoutinePlanned> routinePlanned = DataLinkLayer.DBread <RoutinePlanned>(rpd);
List <Routine> routine = DataLinkLayer.DBread <Routine>(new Routine());
List <Exercise> exercise = DataLinkLayer.DBread <Exercise>(new Exercise());
List <RoutineShow> myRoutine = new List <RoutineShow>();
{
foreach (RoutinePlanned rp in routinePlanned)
{
String a = routine.Find(x => x.RoutineID == rp.RoutineID).RoutineName;
String b = exercise.Find(x => x.ExcerciseID == (rp.ExcertciseID)).Name;
myRoutine.Add(new RoutineShow {
RoutineName = a, ExcerciseName = b
});
}
};
Console.WriteLine(myRoutine.ToString());
return(myRoutine);
}
public Int32 InsertRoutinePlanned(RoutinePlanned routinePlanned)
{
int count = 0;
db.CreateTable <RoutinePlanned>();
foreach (RoutinePlanned rp in GetRoutinePlanned())
{
Int32 x = DataLinkLayer.DBinsert <RoutinePlanned>(rp);
count += x;
}
return(count);
}
public List <RoutinePlanned> ReadRoutinePlanned()
{
RoutinePlanned rp = new RoutinePlanned();
List <RoutinePlanned> list = DataLinkLayer.DBread <RoutinePlanned>(rp);
String s = "";
foreach (RoutinePlanned l in list)
{
s = s + "\n" + l.ToString();
}
Console.WriteLine(s);
return(list);
}
