//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 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 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 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); } } }
//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 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); } } }
//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 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); } } }
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(); } }
//update user in database public UserDto PutUser(UserDto userDto) { using (HealthyMenuEntities db = new HealthyMenuEntities()) { try { User user = db.Users.FirstOrDefault(x => x.userId == userDto.userId); if (user == null) { return(null); } user.firstName = userDto.firstName; user.lastName = userDto.lastName; user.email = userDto.email; user.userPassword = userDto.userPassword; user.bornDate = userDto.bornDate; user.phone = userDto.phone; user.vegan = userDto.vegan; user.vegetarian = userDto.vegetarian; db.Users.SqlQuery("UPDATE User set firstName = " + user.firstName + " lastName = " + user.lastName + " email = " + user.email + " userPassword = "******" bornDate = " + user.bornDate + " phone = " + user.phone + " vegan = " + user.vegan + " vegetarian = " + user.vegetarian + " WHERE userId = " + user.userId); db.SaveChanges(); return(Convertion.UserConvertion.convert(user)); } catch (Exception e) { return(null); } } }