public bool updateDailyFood(DailyFood dailyFood)
{
try
{
using (var myDb = new FoodContext())
{
var daily = myDb.DailyFoods.SingleOrDefault(d => d.EmailAddress.Equals(dailyFood.EmailAddress) && (d.CurrentDate.Day == dailyFood.CurrentDate.Day && d.CurrentDate.Month == dailyFood.CurrentDate.Month && d.CurrentDate.Year == dailyFood.CurrentDate.Year));
if (daily != null)
{
myDb.Entry(daily).CurrentValues.SetValues(dailyFood);
myDb.SaveChanges();
}
}
return(true);
}
catch (Exception e) { return(false); }
}
public bool updateUser(User user)
{
try
{
using (var myDb = new FoodContext())
{
var userTemp = myDb.Users.SingleOrDefault(d => d.EmailAddress.Equals(user.EmailAddress));
if (userTemp != null)
{
myDb.Entry(userTemp).CurrentValues.SetValues(user);
myDb.SaveChanges();
}
}
return(true);
}
catch (Exception e) { return(false); }
}
public bool updateWeekGoals(WeekGoals weekGoals)
{
try
{
using (var myDb = new FoodContext())
{
var weekGoalsTemp = myDb.WeekGoals.SingleOrDefault(d => d.EmailAddress.Equals(weekGoals.EmailAddress) && (d.SundayDate.Day == weekGoals.SundayDate.Day) &&
(d.SundayDate.Year == weekGoals.SundayDate.Year) && (d.SundayDate.Month == weekGoals.SundayDate.Month));
if (weekGoalsTemp != null)
{
myDb.Entry(weekGoalsTemp).CurrentValues.SetValues(weekGoals);
myDb.SaveChanges();
}
}
return(true);
}
catch (Exception e) { return(false); }
}
public bool updateMeals(DateTime currentDate, String emailAddress, List <FoodItem> breakfast, List <FoodItem> brunch, List <FoodItem> dinner, List <FoodItem> snacks)
{
try
{
/* DecreaseProteins = 0;
* DecreaseFats = 0;
* DecreaseCarbs = 0;*/
using (var db = new FoodContext())
{
foreach (var breakfastItem in breakfast)
{
Meal meal = new Meal()
{
CurrentDate = currentDate, EmailAddress = emailAddress, MealTime = MEALTIME.BREAKFAST, FoodKey = breakfastItem.Key, FoodName = breakfastItem.Name, FoodAmount = breakfastItem.AmountGm, Calories100Gm = breakfastItem.Calories100G
};
var mealTmp = db.Meals.SingleOrDefault(m => m.EmailAddress.Equals(meal.EmailAddress) && (m.CurrentDate.Day == meal.CurrentDate.Day && m.CurrentDate.Month == meal.CurrentDate.Month && m.CurrentDate.Year == meal.CurrentDate.Year) && m.MealTime == meal.MealTime && m.FoodKey.Equals(meal.FoodKey));
if (mealTmp != null)
{
db.Entry(mealTmp).CurrentValues.SetValues(meal);
db.SaveChanges();
}
else
{
db.Meals.Add(meal);
db.SaveChanges();
}
}
var queryBreakfast = ((from b in db.Meals
where b.MealTime == MEALTIME.BREAKFAST && b.EmailAddress.Equals(emailAddress) && b.CurrentDate.Day == currentDate.Day &&
b.CurrentDate.Month == currentDate.Month && b.CurrentDate.Year == currentDate.Year
select new FoodItem()
{
AmountGm = b.FoodAmount, Calories100G = b.Calories100Gm, Key = b.FoodKey, Name = b.FoodName
}).ToList());
foreach (var item in queryBreakfast)
{
if (breakfast.Find(c => c.Name.Equals(item.Name) && c.Key.Equals(item.Key) && c.Calories100G == item.Calories100G && c.AmountGm == item.AmountGm) == null)
{
Meal m = new Meal()
{
CurrentDate = currentDate, EmailAddress = emailAddress, MealTime = MEALTIME.BREAKFAST, FoodKey = item.Key, FoodName = item.Name, FoodAmount = item.AmountGm, Calories100Gm = item.Calories100G
};
DecreaseProteins -= getFoodDetails(item.Key).Protien;
DecreaseFats -= getFoodDetails(item.Key).Fats;
DecreaseCarbs -= getFoodDetails(item.Key).Carbohydrate;
db.Meals.Attach(m);
db.Meals.Remove(m);
db.SaveChanges();
}
}
foreach (var brunchItem in brunch)
{
Meal meal = new Meal()
{
CurrentDate = currentDate, EmailAddress = emailAddress, MealTime = MEALTIME.BRUNCH, FoodKey = brunchItem.Key, FoodName = brunchItem.Name, FoodAmount = brunchItem.AmountGm, Calories100Gm = brunchItem.Calories100G
};
var mealTmp = db.Meals.SingleOrDefault(m => m.EmailAddress.Equals(meal.EmailAddress) && (m.CurrentDate.Day == meal.CurrentDate.Day && m.CurrentDate.Month == meal.CurrentDate.Month && m.CurrentDate.Year == meal.CurrentDate.Year) && m.MealTime == meal.MealTime && m.FoodKey.Equals(meal.FoodKey));
if (mealTmp != null)
{
db.Entry(mealTmp).CurrentValues.SetValues(meal);
db.SaveChanges();
}
else
{
db.Meals.Add(meal);
db.SaveChanges();
}
}
var queryBrunch = ((from b in db.Meals
where b.MealTime == MEALTIME.BRUNCH && b.EmailAddress.Equals(emailAddress) && b.CurrentDate.Day == currentDate.Day &&
b.CurrentDate.Month == currentDate.Month && b.CurrentDate.Year == currentDate.Year
select new FoodItem()
{
AmountGm = b.FoodAmount, Calories100G = b.Calories100Gm, Key = b.FoodKey, Name = b.FoodName
}).ToList());
foreach (var item in queryBrunch)
{
if (brunch.Find(c => c.Name.Equals(item.Name) && c.Key.Equals(item.Key) && c.Calories100G == item.Calories100G && c.AmountGm == item.AmountGm) == null)
{
Meal m = new Meal()
{
CurrentDate = currentDate, EmailAddress = emailAddress, MealTime = MEALTIME.BRUNCH, FoodKey = item.Key, FoodName = item.Name, FoodAmount = item.AmountGm, Calories100Gm = item.Calories100G
};
DecreaseProteins -= getFoodDetails(item.Key).Protien;
DecreaseFats -= getFoodDetails(item.Key).Fats;
DecreaseCarbs -= getFoodDetails(item.Key).Carbohydrate;
db.Meals.Attach(m);
db.Meals.Remove(m);
db.SaveChanges();
}
}
foreach (var dinnerItem in dinner)
{
Meal meal = new Meal()
{
CurrentDate = currentDate, EmailAddress = emailAddress, MealTime = MEALTIME.DINNER, FoodKey = dinnerItem.Key, FoodName = dinnerItem.Name, FoodAmount = dinnerItem.AmountGm, Calories100Gm = dinnerItem.Calories100G
};
var mealTmp = db.Meals.SingleOrDefault(m => m.EmailAddress.Equals(meal.EmailAddress) && (m.CurrentDate.Day == meal.CurrentDate.Day && m.CurrentDate.Month == meal.CurrentDate.Month && m.CurrentDate.Year == meal.CurrentDate.Year) && m.MealTime == meal.MealTime && m.FoodKey.Equals(meal.FoodKey));
if (mealTmp != null)
{
db.Entry(mealTmp).CurrentValues.SetValues(meal);
db.SaveChanges();
}
else
{
db.Meals.Add(meal);
db.SaveChanges();
}
}
var queryDinner = ((from b in db.Meals
where b.MealTime == MEALTIME.DINNER && b.EmailAddress.Equals(emailAddress) && b.CurrentDate.Day == currentDate.Day &&
b.CurrentDate.Month == currentDate.Month && b.CurrentDate.Year == currentDate.Year
select new FoodItem()
{
AmountGm = b.FoodAmount, Calories100G = b.Calories100Gm, Key = b.FoodKey, Name = b.FoodName
}).ToList());
foreach (var item in queryDinner)
{
if (dinner.Find(c => c.Name.Equals(item.Name) && c.Key.Equals(item.Key) && c.Calories100G == item.Calories100G && c.AmountGm == item.AmountGm) == null)
{
Meal m = new Meal()
{
CurrentDate = currentDate, EmailAddress = emailAddress, MealTime = MEALTIME.DINNER, FoodKey = item.Key, FoodName = item.Name, FoodAmount = item.AmountGm, Calories100Gm = item.Calories100G
};
DecreaseProteins -= getFoodDetails(item.Key).Protien;
DecreaseFats -= getFoodDetails(item.Key).Fats;
DecreaseCarbs -= getFoodDetails(item.Key).Carbohydrate;
db.Meals.Attach(m);
db.Meals.Remove(m);
db.SaveChanges();
}
}
foreach (var snacksItem in snacks)
{
Meal meal = new Meal()
{
CurrentDate = currentDate, EmailAddress = emailAddress, MealTime = MEALTIME.SNACKS, FoodKey = snacksItem.Key, FoodName = snacksItem.Name, FoodAmount = snacksItem.AmountGm, Calories100Gm = snacksItem.Calories100G
};
var mealTmp = db.Meals.SingleOrDefault(m => m.EmailAddress.Equals(meal.EmailAddress) && (m.CurrentDate.Day == meal.CurrentDate.Day && m.CurrentDate.Month == meal.CurrentDate.Month && m.CurrentDate.Year == meal.CurrentDate.Year) && m.MealTime == meal.MealTime && m.FoodKey.Equals(meal.FoodKey));
if (mealTmp != null)
{
db.Entry(mealTmp).CurrentValues.SetValues(meal);
db.SaveChanges();
}
else
{
db.Meals.Add(meal);
db.SaveChanges();
}
}
var querySnacks = ((from b in db.Meals
where b.MealTime == MEALTIME.SNACKS && b.EmailAddress.Equals(emailAddress) && b.CurrentDate.Day == currentDate.Day &&
b.CurrentDate.Month == currentDate.Month && b.CurrentDate.Year == currentDate.Year
select new FoodItem()
{
AmountGm = b.FoodAmount, Calories100G = b.Calories100Gm, Key = b.FoodKey, Name = b.FoodName
}).ToList());
foreach (var item in querySnacks)
{
if (snacks.Find(c => c.Name.Equals(item.Name) && c.Key.Equals(item.Key) && c.Calories100G == item.Calories100G && c.AmountGm == item.AmountGm) == null)
{
Meal m = new Meal()
{
CurrentDate = currentDate, EmailAddress = emailAddress, MealTime = MEALTIME.SNACKS, FoodKey = item.Key, FoodName = item.Name, FoodAmount = item.AmountGm, Calories100Gm = item.Calories100G
};
DecreaseProteins -= getFoodDetails(item.Key).Protien;
DecreaseFats -= getFoodDetails(item.Key).Fats;
DecreaseCarbs -= getFoodDetails(item.Key).Carbohydrate;
db.Meals.Attach(m);
db.Meals.Remove(m);
db.SaveChanges();
}
}
db.SaveChanges();
}
return(true);
}
catch (Exception e) { return(false); }
}