Ejemplo n.º 1
0
  @Override
  public ShoppingList getShoppingListFromDatabase() {
    database = this.getReadableDatabase();
    ShoppingList list = new ShoppingList();
    Cursor cursor =
        database.query(
            SQLiteHelper.TABLE_SHOPPINGLIST,
            null,
            null,
            null,
            null,
            null,
            SQLiteHelper.SHOPPINGLIST_PRODUCT + " DESC");

    cursor.moveToFirst();
    while (!cursor.isAfterLast()) {
      int id = cursor.getInt(cursor.getColumnIndex(SHOPPINGLIST_PRODUCT));
      Product p = getProductById(id);

      if (p != null) {
        list.addToList(p);
      }
      cursor.moveToNext();
    }
    cursor.close();
    database.close();

    return list;
  }
Ejemplo n.º 2
0
  @Override
  public void saveShoppingListToDatabase(ShoppingList list) {

    database = this.getWritableDatabase();

    ArrayList<Product> datalist = new ArrayList<Product>(list.getContents());
    Iterator<Product> iter = datalist.iterator();
    while (iter.hasNext()) {
      Product prod = iter.next();
      createRow(prod);
    }
    database.close();
  }