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