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