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