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