//is workout null
public bool CreateWorkoutLog(WorkoutLogDTO workout)
{
using (var dbTransaction = db.Database.BeginTransaction())
{
try
{
int getUserID = (from cred in db.Credentials
where workout.userName == cred.UserName
select cred.UserID).FirstOrDefault();
WorkoutLog work = new WorkoutLog
{
UserID = getUserID,
WorkoutType = workout.WorkoutType,
Date_Time = workout.Date_Time,
};
db.Workouts.Add(work);
if (workout.WorkoutType.Equals("Cardio"))
{
Cardio card = new Cardio
{
CardioType = workout.CardioType,
Distance = workout.Distance,
Time = workout.Time
};
db.Cardios.Add(card);
}
else if (workout.WorkoutType.Equals("WeightLifting"))
{
WeightLifting weight = new WeightLifting
{
LiftingType = workout.LiftingType,
Reps = workout.Reps,
Sets = workout.Sets
};
db.WeightLiftings.Add(weight);
}
//add into database t he new instance and saves
db.SaveChanges();
dbTransaction.Commit();
return(true);
}
catch (SqlException)
{
dbTransaction.Rollback();
return(false);
}
catch (DataException)
{
dbTransaction.Rollback();
return(false);
}
}
}
public bool CreateWorkout()
{
using (var dbTransaction = db.Database.BeginTransaction())
{
try
{
WorkoutLog w = new WorkoutLog
{
UserID = 1,
WorkoutType = "WeightLifting",
Date_Time = new DateTime(2015, 12, 12)
};
db.Workouts.Add(w);
if (w.WorkoutType.Equals("Cardio"))
{
Cardio card = new Cardio
{
CardioType = "sprinting",
Distance = 12.21,
Time = "12:32"
};
db.Cardios.Add(card);
}
else if (w.WorkoutType.Equals("WeightLifting"))
{
WeightLifting weight = new WeightLifting
{
LiftingType = "Curls",
Reps = 12,
Sets = 11
};
db.WeightLiftings.Add(weight);
}
//add into database t he new instance and saves
db.SaveChanges();
dbTransaction.Commit();
return(true);
}
catch (SqlException)
{
dbTransaction.Rollback();
return(false);
}
catch (DataException)
{
dbTransaction.Rollback();
return(false);
}
}
}
