public FoodProgramDTO GetCurrentFoodProgramDateByCID(int CID)
{
foodProgram f = new foodProgram();
var currentFp = db.foodProgramDate.OrderByDescending(x => x.date).FirstOrDefault(x => x.customer_CID == CID);
if (currentFp != null)
{
f = db.foodProgram.FirstOrDefault(x => x.FPMID == currentFp.foodProgram_FPMID);
}
var fp = new FoodProgramDTO
{
FPMID = f.FPMID,
name = f.name
};
return(fp);
}
public FoodProgramDTO GetCurrentFoodProgramDateByUserID(string UserId)
{
foodProgram f = new foodProgram();
customer c = db.customer.FirstOrDefault(x => x.ID == UserId);
var currentFp = db.foodProgramDate.OrderByDescending(x => x.date).FirstOrDefault(x => x.customer_CID == c.CID);
if (currentFp != null)
{
f = db.foodProgram.FirstOrDefault(x => x.FPMID == currentFp.foodProgram_FPMID);
}
var fp = new FoodProgramDTO
{
FPMID = f.FPMID,
name = f.name,
};
return(fp);
}
public bool UpdateFoodProgram(FoodProgramDTO FoodProgram)
{
try
{
var f = (from x in db.foodProgram
where x.FPMID == FoodProgram.FPMID
select x).SingleOrDefault();
f.FPMID = FoodProgram.FPMID;
f.name = FoodProgram.name;
f.trainer_TRID = FoodProgram.trainer_TRID;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool UpdateFoodProgram(FoodProgramDTO FoodProgram)
{
return(fpq.UpdateFoodProgram(FoodProgram));
}
public int AddFoodProgram(FoodProgramDTO FoodProgram)
{
return(fpq.AddFoodProgram(FoodProgram.name, UserId));
}
