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