private void RemoveMeal(Meal meal)
{
Sql.ExecuteNonQuery("DELETE FROM meals WHERE id=" + meal.Id);
LoadMeals();
UpdateMealTree();
}
private void LoadMeals()
{
meals.Clear();
SQLiteCommand command = Sql.SqlConnection.CreateCommand();
command.CommandText = "SELECT id,foodId,date FROM meals";
using(SQLiteDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
int id = reader.GetInt32(0);
int foodId = reader.GetInt32(1);
DateTime date = reader.GetDateTime(2);
Food food = foods.Where(f => f.Id == foodId).Single();
Meal meal = new Meal(id, food, date);
meals.Add(meal);
}
}
}
}
