public int AddTrainingProgram(string UserId, TrainingProgramDTO trainingProgram)
{
var trainer = (from x in db.trainer
where x.ID == UserId
select x).FirstOrDefault();
var tp = new trainingProgram
{
name = trainingProgram.name,
trainer_TRID = trainer.TRID,
difficulty = trainingProgram.difficulty
};
db.trainingProgram.Add(tp);
db.SaveChanges();
return(tp.TPID);
}
public TrainingProgramDTO GetCurrentTrainingProgramByCid(int id)
{
trainingProgram p = new trainingProgram();
var currentTp = db.trainingProgramDate.OrderByDescending(x => x.date).FirstOrDefault(x => x.customer_CID == id);
if (currentTp != null)
{
p = db.trainingProgram.FirstOrDefault(x => x.TPID == currentTp.trainingProgram_TPID);
}
var tp = new TrainingProgramDTO
{
TPID = p.TPID,
name = p.name,
};
return(tp);
}
public bool UpdateTrainingProgram(TrainingProgramDTO x)
{
try
{
var tp = (from y in db.trainingProgram
where x.TPID == y.TPID
select y).SingleOrDefault();
tp.TPID = x.TPID;
tp.name = x.name;
tp.trainer_TRID = x.trainer_TRID;
tp.difficulty = x.difficulty;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool UpdateTrainingProgram(TrainingProgramDTO TP)
{
return(tpq.UpdateTrainingProgram(TP));
}
public int AddTrainingProgram(TrainingProgramDTO TP)
{
var UserId = User.Identity.GetUserId();
return(tpq.AddTrainingProgram(UserId, TP));
}
