public IEnumerable <FoodPortionDTO> GetFoodPortions(int FPMID, string userId, bool trainer) { IEnumerable <foodProgramPortion> fp = null; if (trainer) { trainer tr = db.trainer.FirstOrDefault(x => x.ID == userId); fp = db.foodProgramPortion.Where(x => x.foodProgram_FPMID == FPMID && x.foodProgram.trainer_TRID == tr.TRID); } else { customer c = db.customer.FirstOrDefault(x => x.ID == userId); foodProgramDate fpd = db.foodProgramDate.OrderByDescending(x => x.date).FirstOrDefault(x => x.customer_CID == c.CID); if (fpd != null) { fp = db.foodProgramPortion.Where(x => x.foodProgram_FPMID == FPMID && fpd.foodProgram_FPMID == FPMID); } } List <FoodPortionDTO> trainingList = new List <FoodPortionDTO>(); if (fp != null) { foreach (foodProgramPortion x in fp) { var portion = (from p in db.foodPortion where p.FPID == x.foodPortion_FPID select new FoodPortionDTO { FPID = p.FPID, quantity = p.quantity, foodItem_FIID = p.foodItem_FIID, sunday = p.sunday, monday = p.monday, tuesday = p.tuesday, wednesday = p.wednesday, thursday = p.thursday, friday = p.friday, saturday = p.saturday, timeOfDay = p.timeOfDay, className = p.className }).FirstOrDefault(); var name = GetFoodItemName(portion.foodItem_FIID); portion.name = name; trainingList.Add(portion); } } return(trainingList); }
public bool AddFoodProgramDate(FoodProgramDateDTO FoodProgramDate) { try { DateTime d = DateTime.Now; var g = new foodProgramDate { customer_CID = FoodProgramDate.customer_CID, foodProgram_FPMID = FoodProgramDate.foodProgram_FPMID, date = d }; db.foodProgramDate.Add(g); db.SaveChanges(); return(true); } catch (Exception) { return(false); } }