Пример #1
0
  public SpeakerWrapper getRecord(String _id) {
    SpeakerWrapper _objSpeakerWrapper = new SpeakerWrapper();
    String query = "Select * from  speakerList where ClientCode=? and EventCode=? and _id=?";

    Cursor c =
        dbAdapter.selectRecordsFromDB(
            query, new String[] {MyUIApplication.ClientCode, MyUIApplication.EventCode, _id});

    if (c.moveToFirst()) {
      do {

        _objSpeakerWrapper.id = c.getString(c.getColumnIndex("_id"));
        _objSpeakerWrapper.name = c.getString(c.getColumnIndex("name"));
        _objSpeakerWrapper.email = c.getString(c.getColumnIndex("email"));
        _objSpeakerWrapper.post = c.getString(c.getColumnIndex("post"));
        _objSpeakerWrapper.companyname = c.getString(c.getColumnIndex("companyname"));
        _objSpeakerWrapper.description = c.getString(c.getColumnIndex("description"));
        _objSpeakerWrapper.image = c.getString(c.getColumnIndex("image"));
        _objSpeakerWrapper.favourites = c.getString(c.getColumnIndex("favourites"));

      } while (c.moveToNext());
    }

    return _objSpeakerWrapper;
  }
Пример #2
0
  public ArrayList<SpeakerWrapper> getSortedRecord() {
    ArrayList<SpeakerWrapper> array = new ArrayList<SpeakerWrapper>();

    String query =
        "Select * from  speakerList where ClientCode=? and EventCode=?  ORDER BY name ASC";

    Cursor c =
        dbAdapter.selectRecordsFromDB(
            query, new String[] {MyUIApplication.ClientCode, MyUIApplication.EventCode});

    if (c.moveToFirst()) {
      do {
        SpeakerWrapper _objSpeakerWrapper = new SpeakerWrapper();

        _objSpeakerWrapper.id = c.getString(c.getColumnIndex("_id"));
        _objSpeakerWrapper.name = c.getString(c.getColumnIndex("name"));
        _objSpeakerWrapper.email = c.getString(c.getColumnIndex("email"));
        _objSpeakerWrapper.post = c.getString(c.getColumnIndex("post"));
        _objSpeakerWrapper.companyname = c.getString(c.getColumnIndex("companyname"));
        _objSpeakerWrapper.description = c.getString(c.getColumnIndex("description"));
        _objSpeakerWrapper.image = c.getString(c.getColumnIndex("image"));
        _objSpeakerWrapper.favourites = c.getString(c.getColumnIndex("favourites"));

        array.add(_objSpeakerWrapper);

      } while (c.moveToNext());
    }

    return array;
  }