public void UpdateFood(int id, Food food)
{
DBConnection connection = new DBConnection();
connection.Connect();
connection.SetCommand(FoodSQLMapper.UpdateFood(id, food));
connection.Execute();
connection.CloseConnection();
}
public Food GetFood(int id)
{
DBConnection connection = new DBConnection();
connection.Connect();
connection.SetCommand(FoodSQLMapper.FindByIdSQL(id));
MySqlDataReader reader = connection.ExecuteQuery();
if (reader.Read())
{
Food food = Food.Map(reader);
connection.CloseConnection();
return(food);
}
connection.CloseConnection();
return(null);
}
