private void AddMeal(Food food,DateTime dateTime) { SQLiteCommand command = Sql.SqlConnection.CreateCommand(); command.Parameters.AddWithValue("@foodId", food.Id); command.Parameters.AddWithValue("@date", dateTime); command.CommandText = "INSERT INTO meals (foodId,date) VALUES(@foodId,@date)"; command.ExecuteNonQuery(); LoadMeals(); UpdateMealTree(); }
public Meal(int id,Food food,DateTime date) { Id = id; Food = food; Date = date; }
private void RemoveFood(Food food) { Sql.ExecuteNonQuery("UPDATE food SET hidden=1 WHERE id=" + food.Id); LoadFoods(); UpdateFoodList(); }
private void LoadFoods() { foods.Clear(); SQLiteCommand command = Sql.SqlConnection.CreateCommand(); command.CommandText = "SELECT * FROM food ORDER BY name"; using(SQLiteDataReader reader = command.ExecuteReader()) { if(reader.HasRows) { while(reader.Read()) { int id = reader.GetInt32(0); string name = reader.GetString(1); int kcalPer100g = reader.GetInt32(2); int grams = reader.GetInt32(3); bool hidden = reader.GetBoolean(4); Food food = new Food(id, name, kcalPer100g, grams, hidden); foods.Add(food); } } } }