//update ingredient in database public ingredientDto PutIngredient(ingredientDto IngredientDto, ref string f) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { ingredient Ingredient = db.ingredients.FirstOrDefault(x => x.id == IngredientDto.id); if (Ingredient == null) { f = "לא קיים"; return(null); } Ingredient.id = IngredientDto.id; Ingredient.CDescription = IngredientDto.CDescription; Ingredient.RecommendedDoseMale = IngredientDto.RecommendedDoseMale; Ingredient.RecommendedDoseFemale = IngredientDto.RecommendedDoseFemale; Ingredient.UnitCode = IngredientDto.UnitCode; return(Convertion.IngredientConvertion.convert(Ingredient)); } catch { return(null); } } }
//update food in database public FoodDto PutFood(FoodDto foodDto) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { Food food = db.Foods.FirstOrDefault(x => x.id == foodDto.id); if (food == null) { return(null); } food.cosher = foodDto.cosher; food.foodName = foodDto.foodName; food.id = foodDto.id; food.picture = foodDto.picture; food.suitableToID = foodDto.suitableToID; food.category = foodDto.category; return(Convertion.FoodConvetrtion.convert(food)); } catch { return(null); } } }
//update ageDimension in database public ageDimensionDto PutAgeDimension(ageDimensionDto AgeDimensionDto) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { ageDimension AgeDimension = db.ageDimensions.FirstOrDefault(x => x.id == AgeDimensionDto.id); if (AgeDimension == null) { return(null); } AgeDimension.id = AgeDimensionDto.id; AgeDimension.statusCode = AgeDimensionDto.statusCode; AgeDimension.UnitsOfMeasurementCode = AgeDimensionDto.UnitsOfMeasurementCode; AgeDimension.RecommendedDose = AgeDimensionDto.RecommendedDose; AgeDimension.MaxDose = AgeDimensionDto.MaxDose; AgeDimension.highMissing = AgeDimensionDto.highMissing; return(Convertion.ageDimensionConvertion.convert(AgeDimension)); } catch { return(null); } } }
public resultDto PostUserNutrition(detailsDto UserNutritionDto) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { //try //{ // Dictionary<int, menuList> food; unit = this.unitfunc(UserNutritionDto); //foreach (var item in unit) //{ // item.Value.client = item.Value.client / 3; //} resultDto r = new menuService().CalcAllMeals(unit); return(r); // } //catch(Exception e) //{ // return null; //} } }
//get all users from database public List <UserDto> GetUsers() { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { return(Convertion.UserConvertion.convert(db.Users.ToList())); } catch { return(null); } } }
public Dictionary <int, menuList> food() { Dictionary <int, menuList> keyValuePairs = new Dictionary <int, menuList>(); using (HealthyMenuEntities db = new HealthyMenuEntities()) { var foods = db.Foods.Where(x => x.suitableToID == 1); //int d= unit.FirstOrDefault(x=>x.Value.count== unit.Max(f => f.Value.count)).Key; // foods.Select(x =>x.ingredientsInProes.ingredientsId) //keyValuePairs.Add(); return(keyValuePairs.OrderBy(k => k.Key).ToDictionary(k => k.Key, k => k.Value)); } }
//get all ingredients from database public List <ingredientDto> GetIngredients() { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { return(Convertion.IngredientConvertion.convert(db.ingredients.ToList())); } catch { return(null); } } }
//get all status from database public List <statusDto> GetStatuses() { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { return(Convertion.statusConvertion.convert(db.statuses.ToList())); } catch { return(null); } } }
//get all foods from database public List <FoodDto> GetFoods() { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { return(Convertion.FoodConvetrtion.convert(db.Foods.ToList())); } catch { return(null); } } }
//get all ageDimension from database public List <ageDimensionDto> GetAgeDimensions() { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { return(Convertion.ageDimensionConvertion.convert(db.ageDimensions.ToList())); } catch { return(null); } } }
//add food to database public FoodDto PostFood(FoodDto foodDto) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { Food food = db.Foods.Add(Convertion.FoodConvetrtion.convert(foodDto)); db.SaveChanges(); return(Convertion.FoodConvetrtion.convert(food)); } catch { return(null); } } }
//remove user from database public UserDto RemoveUser(UserDto NewUser) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { User user = db.Users.Remove(Convertion.UserConvertion.convert(NewUser)); db.SaveChanges(); return(Convertion.UserConvertion.convert(user)); } catch { return(null); } } }
//add ingredientInPro to database public ingredientsInProDto PostIngredientInPro(ingredientsInProDto IngredientsInProDto) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { ingredientsInPro IngredientsInPro = db.ingredientsInProes.Add(Convertion.IngredientsInProConvertion.convert(IngredientsInProDto)); db.SaveChanges(); return(Convertion.IngredientsInProConvertion.convert(IngredientsInPro)); } catch { return(null); } } }
//remove ingredient to database public ingredientDto RemoveIngredient(ingredientDto IngredientDto) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { ingredient Ingredient = db.ingredients.Remove(Convertion.IngredientConvertion.convert(IngredientDto)); db.SaveChanges(); return(Convertion.IngredientConvertion.convert(Ingredient)); } catch { return(null); } } }
//remove SuitableTo from database public suitableToDto RemoveSuitableTo(suitableToDto SuitableToDto) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { suitableTo SuitableTo = db.suitableToes.Remove(Convertion.SuitableToConvertion.convert(SuitableToDto)); db.SaveChanges(); return(Convertion.SuitableToConvertion.convert(SuitableTo)); } catch { return(null); } } }
//sign up- add new user to database public UserDto PostUser(UserDto NewUser) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { User user = db.Users.Add(Convertion.UserConvertion.convert(NewUser)); db.SaveChanges(); return(Convertion.UserConvertion.convert(user)); } catch (Exception e) { return(null); } } }
//remove UserNutrition from database public userNutritionDto RemoveUserNutrition(userNutritionDto UserNutritionDto) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { userNutrition UserNutrition = db.userNutritions.Remove(Convertion.userNutritionConvertion.convert(UserNutritionDto)); db.SaveChanges(); return(Convertion.userNutritionConvertion.convert(UserNutrition)); } catch { return(null); } } }
//remove ageDimension from database public ageDimensionDto RemoveAgeDimension(ageDimensionDto AgeDimensionDto) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { ageDimension AgeDimension = db.ageDimensions.Remove(Convertion.ageDimensionConvertion.convert(AgeDimensionDto)); db.SaveChanges(); return(Convertion.ageDimensionConvertion.convert(AgeDimension)); } catch { return(null); } } }
//remove UnitsOfMeasurement from database public UnitsOfMeasurementDto RemoveUnitsOfMeasurement(UnitsOfMeasurementDto unitsOfMeasurementDto) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { UnitsOfMeasurement unitsOfMeasurement = db.UnitsOfMeasurements.Remove(Convertion.UnitsOfMeasurementConvertion.convert(unitsOfMeasurementDto)); db.SaveChanges(); return(Convertion.UnitsOfMeasurementConvertion.convert(unitsOfMeasurement)); } catch { return(null); } } }
//remove status from database public statusDto RemoveStatus(statusDto StatusDto) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { status Status = db.statuses.Remove(Convertion.statusConvertion.convert(StatusDto)); db.SaveChanges(); return(Convertion.statusConvertion.convert(Status)); } catch { return(null); } } }
public void FillIngrediantsInPro(int foodId) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { var allIngredients = db.ingredients.ToList(); foreach (var item in allIngredients) { if (!item.ingredientsInProes.Any(i => i.foodID == foodId)) { db.ingredientsInProes.Add(new ingredientsInPro { foodID = foodId, ingredientsId = item.id, countFor100gr = 0 }); } } db.SaveChanges(); } }
//get user by id from database public UserDto GetUser(string password, string str) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { User user = db.Users.FirstOrDefault(x => x.userPassword == password && (x.email == str || x.phone == str || x.userId == str)); if (user == null) { return(null); } return(Convertion.UserConvertion.convert(user)); } catch { return(null); } } }
//get food by id from database public FoodDto GetFood(int id) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { Food food = db.Foods.FirstOrDefault(x => x.id == id); if (food == null) { return(null); } return(Convertion.FoodConvetrtion.convert(food)); } catch { return(null); } } }
//get SuitableTo by id from database public suitableToDto GetSuitableTo(int id) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { suitableTo SuitableTo = db.suitableToes.FirstOrDefault(x => x.id == id); if (SuitableTo == null) { return(null); } return(Convertion.SuitableToConvertion.convert(SuitableTo)); } catch { return(null); } } }
public Dictionary <FoodDto, double[]> GetFoodsNutritionValues(int sutableTo) { Dictionary <FoodDto, double[]> foodsNutritionValues = new Dictionary <FoodDto, double[]>(); using (HealthyMenuEntities db = new HealthyMenuEntities()) { int numIngridiants = db.ingredients.Count(); //todo Check if food is good for user //לחלק את הכמויות בין הארוחות וכל פעם לשלוף רק את המאכלים שמתאימים לארוחה foreach (var food in db.Foods.Where(f => f.suitableToID == sutableTo)) { foodsNutritionValues.Add( Convertion.FoodConvetrtion.convert(food), food.ingredientsInProes.OrderBy(i => i.ingredient.CDescription).Select(i => i.countFor100gr.Value).ToFixedLength(numIngridiants) ); } } return(foodsNutritionValues); }
//get UnitsOfMeasurement by id from database public UnitsOfMeasurementDto GetUnitsOfMeasurement(int id) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { UnitsOfMeasurement unitsOfMeasurement = db.UnitsOfMeasurements.FirstOrDefault(x => x.id == id); if (unitsOfMeasurement == null) { return(null); } return(Convertion.UnitsOfMeasurementConvertion.convert(unitsOfMeasurement)); } catch { return(null); } } }
//get status by id from database public statusDto GetStatus(int id) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { status Status = db.statuses.FirstOrDefault(x => x.id == id); if (Status == null) { return(null); } return(Convertion.statusConvertion.convert(Status)); } catch { return(null); } } }
//get one ingredients by id from database public ingredientDto GetIngredient(int id) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { ingredient Ingredient = db.ingredients.FirstOrDefault(x => x.id == id); if (Ingredient == null) { return(null); } return(Convertion.IngredientConvertion.convert(Ingredient)); } catch { return(null); } } }
//get ageDimension by id from database public ageDimensionDto GetageDimension(int id) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { ageDimension AgeDimension = db.ageDimensions.FirstOrDefault(x => x.id == id); if (AgeDimension == null) { return(null); } return(Convertion.ageDimensionConvertion.convert(AgeDimension)); } catch { return(null); } } }
//get userNutrition by id from database public userNutritionDto GetUserNutrition(int id) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { userNutrition UserNutrition = db.userNutritions.FirstOrDefault(x => x.id == id); if (UserNutrition == null) { return(null); } return(Convertion.userNutritionConvertion.convert(UserNutrition)); } catch { return(null); } } }