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<spSelectFoodBySponsorAndMealTimeType_Result> GetFoodBySponsorAndMealTimeType(int sponsorID, int mealTimeTypeID) { List<spSelectFoodBySponsorAndMealTimeType_Result> foodList=null; using (var context = new NutritionEntities()) { foodList = context.spSelectFoodBySponsorAndMealTimeType(sponsorID, mealTimeTypeID).ToList(); } return foodList; }
public decimal GetUserMenuCalories(int userID, int programID) { decimal? calories; using (var context = new NutritionEntities()) { calories = context.spUserMenuCalories(userID, programID).FirstOrDefault().Calories; } return calories.HasValue ? calories.Value : 0; }
public int UserUpdateFoodMenu(int menuMealTimeFoodXRefID, Food food) { spUserProgramDayMealTimeFoodXRefUpdate_Result result=null; using (var context = new NutritionEntities()) { result = context.spUserProgramDayMealTimeFoodXRefUpdate(menuMealTimeFoodXRefID, food.FoodID, food.Carbohydrate, food.Protein, food.Fat, food.Calories, food.Qty).FirstOrDefault(); } return result!=null ?result.RowCount:0; }
/// <summary> /// /// </summary> /// <param name="user"></param> /// <returns></returns> /// <remarks> /// Se llama cuando el usuario inicia su programa. /// Si ya inicio almenos un programa la siguiente vez, el birthdate y sexo no deben cambiar /// </remarks> public User UpdateUserRegistration(User user) { using (var context = new RegistrationEntities()) { decimal heigh = user.HeighInt + UnitConverter.CentimetersToMeters(user.HeighDec); //estatura en metros user.BMI = Selery.BO.Nutrition.Profile.GetBMI(heigh, user.Weight); int age = Selery.Library.Common.Helper.GetAge(user.BirthDate.Value); //selecctionar el goaltype en base al bmi Selery.BO.Core.Enum.GoalType goalTypeID = Selery.BO.Nutrition.Profile.GetGoalType(user.BMI); //TODO: por ahora solo tenemos 2 goals, el 1 es de LoseWeight y el 2 es de Maintain //cuando haya mas Goals vamos a tener que hacer refactor a este metodo. int goalID = (goalTypeID == Selery.BO.Core.Enum.GoalType.LoseWeight ? (int)Selery.BO.Core.Enum.GoalType.LoseWeight : (int)Selery.BO.Core.Enum.GoalType.Maintain); //Las calorias ya vienen en el usuario int? rowcount = context.spUserRegistrationUpdate(user.UserID, user.Gender, user.HeighInt, user.HeighDec, user.BirthDate, goalID, user.BMI, user.Calories).SingleOrDefault(); decimal? id = context.spUserActivityInsert(user.UserID, user.ActivityID).SingleOrDefault(); } using (var context = new WorkoutEntities()) { //iniciar el programa //guardar cual es el BMI del usuario al inicio del programa int? rowcount = context.spUserProgramUpdate(user.UserID, user.CurrentProgram.ProgramID, user.BMI).SingleOrDefault(); } //insertar el peso this.UserWeightInsert(user.UserID, user.Weight); //inicializar menu using (var context = new NutritionEntities()) { int? rowcount = context.spUserDailyMenuInitialize(user.UserID, user.CurrentProgram.ProgramID).SingleOrDefault(); } return this.SelectUserByID(user.UserID); }