public BLRoutineShow() { db = DataLinkLayer.DBconnect(); bLPlanned = new BLPlanned(); bLExecuted = new BLExecuted(); Executed executed = new Executed() { ID = 1, RoutinePlannedID = 0, RoutineID = 0, ExerciseID = 0, Date = "01:01:01", Reps = "0", Sets = 2, lbs = "0" }; // db.CreateTable<Executed>(); //bLExecuted.InsertRoutineExecuted(executed); //db.DropTable<Exercise>(); //db.CreateTable<Exercise>(); //BLExercise bl = new BLExercise(); //bl.InsertExcercise(new Exercise()); //db.DropTable<Routine>(); //db.CreateTable<Routine>(); //BLRoutine bL = new BLRoutine(); //bL.InsertRoutine(new Routine()); //db.DropTable<Planned>(); //db.CreateTable<Planned>(); }
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); }