Example #1
0
  public String[] retrieveVendorNameList(Context context) {
    db = getDatabase(context);
    Cursor cursor = salesDB.retrieveHeaderList(db);
    ArrayList<String> mVendorNameList = new ArrayList<String>();

    while (cursor.moveToNext()) {
      String vendorName = cursor.getString(1);
      mVendorNameList.add(vendorName);
    }
    cursor.close();
    db.close();

    String[] strVendorNameList = new String[mVendorNameList.size()];
    for (int i = 0; i < mVendorNameList.size(); i++) {
      strVendorNameList[i] = mVendorNameList.get(i);
    }
    return strVendorNameList;
  }
Example #2
0
  public ArrayList<Header> retrieveHeaderList(Context context) {
    db = getDatabase(context);
    Cursor cursor = salesDB.retrieveHeaderList(db);
    ArrayList<Header> mHeaderList = new ArrayList<Header>();

    while (cursor.moveToNext()) {
      Header header =
          new Header(
              cursor.getString(0),
              cursor.getString(1),
              cursor.getString(2),
              cursor.getString(3),
              cursor.getString(4),
              cursor.getString(5));
      mHeaderList.add(header);
    }
    cursor.close();
    db.close();

    return mHeaderList;
  }