public IEnumerable <UserDailyMenu> GetUserDailyMenu(int userID, int day) { List <UserDailyMenu> userDailyMenuList = new List <UserDailyMenu>(); IEnumerable <spUserDailyMenuSelectByDay_Result> userDailyMenuEFList; using (var context = new NutritionEntities()) { userDailyMenuEFList = context.spUserDailyMenuSelectByDay(userID, day).ToList(); foreach (spUserDailyMenuSelectByDay_Result item in userDailyMenuEFList) { UserDailyMenu userDailyMenu = new UserDailyMenu(); userDailyMenu.MenuMealTimeFoodXRefID = item.MenuMealTimeFoodXRefID; userDailyMenu.UserProgramXRefID = item.UserProgramXRefID; userDailyMenu.MenuMealTimeOrderID = item.MenuMealTimeOrderID; userDailyMenu.MealTimeTypeID = item.MealTimeTypeID; userDailyMenu.MealTimeName = item.MealTimeName; userDailyMenu.FoodName = item.FoodName; userDailyMenu.Qty = item.Qty; userDailyMenu.Calories = item.Calories; userDailyMenuList.Add(userDailyMenu); } } return(userDailyMenuList); }
public IEnumerable<UserDailyMenu> GetUserDailyMenu(int userID, int day) { List<UserDailyMenu> userDailyMenuList = new List<UserDailyMenu>(); IEnumerable<spUserDailyMenuSelectByDay_Result> userDailyMenuEFList; using (var context = new NutritionEntities()) { userDailyMenuEFList = context.spUserDailyMenuSelectByDay(userID, day).ToList(); foreach (spUserDailyMenuSelectByDay_Result item in userDailyMenuEFList) { UserDailyMenu userDailyMenu = new UserDailyMenu(); userDailyMenu.MenuMealTimeFoodXRefID = item.MenuMealTimeFoodXRefID; userDailyMenu.UserProgramXRefID = item.UserProgramXRefID; userDailyMenu.MenuMealTimeOrderID = item.MenuMealTimeOrderID; userDailyMenu.MealTimeTypeID = item.MealTimeTypeID; userDailyMenu.MealTimeName = item.MealTimeName; userDailyMenu.FoodName = item.FoodName; userDailyMenu.Qty = item.Qty; userDailyMenu.Calories = item.Calories; userDailyMenuList.Add(userDailyMenu); } } return userDailyMenuList; }