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