public ArrayList<SpeakerSeminarsWrapper> getFavRecord() {
    ArrayList<SpeakerSeminarsWrapper> array = new ArrayList<SpeakerSeminarsWrapper>();

    String query1 =
        "Select  distinct title from  speakerSeminar where ClientCode=? and EventCode=? and favourites=?";

    Cursor c =
        dbAdapter.selectRecordsFromDB(
            query1, new String[] {MyUIApplication.ClientCode, MyUIApplication.EventCode, "true"});
    if (c.moveToFirst()) {
      do {
        String title = c.getString(c.getColumnIndex("Title"));

        String query = "Select * from  speakerSeminar where title=? limit 1";

        Cursor cursor = dbAdapter.selectRecordsFromDB(query, new String[] {title});
        if (cursor.moveToFirst()) {
          SpeakerSeminarsWrapper _objSpeakerWrapper = new SpeakerSeminarsWrapper();

          _objSpeakerWrapper.id = cursor.getString(cursor.getColumnIndex("_id"));
          _objSpeakerWrapper.name = cursor.getString(cursor.getColumnIndex("name"));
          _objSpeakerWrapper.Title = cursor.getString(cursor.getColumnIndex("Title"));
          _objSpeakerWrapper.Day = cursor.getString(cursor.getColumnIndex("Day"));
          _objSpeakerWrapper.description = cursor.getString(cursor.getColumnIndex("description"));
          _objSpeakerWrapper.visited = cursor.getString(cursor.getColumnIndex("visited"));
          _objSpeakerWrapper.favourites = cursor.getString(cursor.getColumnIndex("favourites"));

          array.add(_objSpeakerWrapper);
        }
      } while (c.moveToNext());
    }
    return array;
  }
  public void deleteTable() {
    try {
      dbAdapter.createDataBase();
    } catch (IOException e) {
      Log.i("*** Delete ", e.getMessage());
    }
    dbAdapter.deleteAll("speakerSeminar");
    // int id=dbAdapter.deleteRecordInDB("BOOK", "1", new String[]{"1"});
    // Toast.makeText(view, String.valueOf(n),Toast.LENGTH_SHORT).show();

  }
  public SpeakerSeminarsWrapper getRecord(String urlLink, String id) {
    // TODO Auto-generated method stub
    SpeakerSeminarsWrapper _objSpeakerWrapper = null;

    String query =
        "Select * from  speakerSeminar where ClientCode=? and EventCode=? and _id=? and Title=?";

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

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

        _objSpeakerWrapper.id = c.getString(c.getColumnIndex("_id"));
        _objSpeakerWrapper.name = c.getString(c.getColumnIndex("name"));
        _objSpeakerWrapper.Title = c.getString(c.getColumnIndex("Title"));
        _objSpeakerWrapper.Day = c.getString(c.getColumnIndex("Day"));
        _objSpeakerWrapper.description = c.getString(c.getColumnIndex("description"));
        _objSpeakerWrapper.visited = c.getString(c.getColumnIndex("visited"));
        _objSpeakerWrapper.favourites = c.getString(c.getColumnIndex("favourites"));

      } while (c.moveToNext());
    }

    return _objSpeakerWrapper;
  }
  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;
  }
  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;
  }
  public void updateTimestamp(String timeStamp) {
    ContentValues initialValues = new ContentValues();
    initialValues.put("updatetimestamp", timeStamp);

    String[] strArray = {MyUIApplication.EventCode, MyUIApplication.ClientCode};
    long n =
        dbAdapter.updateRecordsInDB(
            "speakerList", initialValues, "EventCode=? and ClientCode=?", strArray);
  }
  public String getTimeStamp() {

    String updateTime = "";

    String query = "Select updatetimestamp from  speakerList where ClientCode=? and EventCode=?";

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

    if (c.moveToFirst()) {
      updateTime = c.getString(c.getColumnIndex("updatetimestamp"));
    }

    return updateTime;
  }
  public void visited(String seminarName, String visited) {
    String isVisited = "false";

    if (visited.equals("false")) {

      isVisited = "true";

    } else if (visited.equals("true")) {
      isVisited = "false";
    }

    ContentValues initialValues = new ContentValues();
    initialValues.put("visited", isVisited);

    String[] strArray = {MyUIApplication.EventCode, MyUIApplication.ClientCode, seminarName};
    long n =
        dbAdapter.updateRecordsInDB(
            "speakerSeminar", initialValues, "EventCode=? and ClientCode=? and Title=?", strArray);
  }
  public int insertRecords(ArrayList<SpeakerSeminarsWrapper> array) {
    long id = 0;
    for (int i = 0; i < array.size(); i++) {
      ContentValues initialValues = new ContentValues();
      initialValues.put("_id", MyUIApplication.speakerId);
      initialValues.put("name", array.get(i).name);
      initialValues.put("Title", array.get(i).Title);
      initialValues.put("Day", array.get(i).Day);
      initialValues.put("description", array.get(i).description);
      initialValues.put("visited", array.get(i).visited);
      initialValues.put("favourites", array.get(i).favourites);
      initialValues.put("EventCode", MyUIApplication.EventCode);
      initialValues.put("ClientCode", MyUIApplication.ClientCode);

      id = dbAdapter.insertRecordsInDB("speakerSeminar", null, initialValues);
    }

    return (int) id;
  }
Esempio n. 10
0
  public void favourites(String id, String favourites) {
    String isFavourite = "false";

    if (favourites.equals("false")) {

      isFavourite = "true";

    } else if (favourites.equals("true")) {
      isFavourite = "false";
    }

    ContentValues initialValues = new ContentValues();
    initialValues.put("favourites", isFavourite);

    String[] strArray = {MyUIApplication.EventCode, MyUIApplication.ClientCode, id};
    long n =
        dbAdapter.updateRecordsInDB(
            "speakerList", initialValues, "EventCode=? and ClientCode=? and _id=?", strArray);
  }
Esempio n. 11
0
  public int insertRecords(ArrayList<SpeakerWrapper> array) {
    long id = 0;
    for (int i = 0; i < array.size(); i++) {
      ContentValues initialValues = new ContentValues();
      initialValues.put("_id", array.get(i).id);
      initialValues.put("name", array.get(i).name);
      initialValues.put("email", array.get(i).email);
      initialValues.put("post", array.get(i).post);
      initialValues.put("companyname", array.get(i).companyname);
      initialValues.put("description", array.get(i).description);
      initialValues.put("image", array.get(i).image);
      initialValues.put("favourites", array.get(i).favourites);
      initialValues.put("EventCode", MyUIApplication.EventCode);
      initialValues.put("ClientCode", MyUIApplication.ClientCode);

      id = dbAdapter.insertRecordsInDB("speakerList", null, initialValues);
    }

    return (int) id;
  }
Esempio n. 12
0
  public int updateTable(ArrayList<SpeakerWrapper> array) {
    int n = 0;
    for (int i = 0; i < array.size(); i++) {
      ContentValues initialValues = new ContentValues();
      initialValues.put("_id", array.get(i).id);
      initialValues.put("name", array.get(i).name);
      initialValues.put("email", array.get(i).email);
      initialValues.put("post", array.get(i).post);
      initialValues.put("companyname", array.get(i).companyname);
      initialValues.put("description", array.get(i).description);
      initialValues.put("image", array.get(i).image);
      initialValues.put("EventCode", MyUIApplication.EventCode);
      initialValues.put("ClientCode", MyUIApplication.ClientCode);

      String[] strArray = {array.get(i).id, MyUIApplication.EventCode, MyUIApplication.ClientCode};
      n =
          dbAdapter.updateRecordsInDB(
              "speakerList", initialValues, "_id=? and EventCode=? and ClientCode=?", strArray);
    }

    return n;
  }
  public boolean deleteRecord(ArrayList<SpeakerSeminarsWrapper> array) {
    long n = 0;

    for (int i = 0; i < array.size(); i++) {

      try {

        String[] strArray = {
          MyUIApplication.speakerId, MyUIApplication.EventCode, MyUIApplication.ClientCode
        };

        n =
            dbAdapter.deleteRecordInDB(
                "speakerSeminar", "_id=? and EventCode=? and ClientCode=?", strArray);
      } catch (Exception ex) {
        MyUIApplication.LoggerToSD("Excepion in Deleting row " + array.get(i).id, ex.toString());
      }
    }
    if (n == 0) {
      return false;
    }
    return true;
  }
  public int updateTable(ArrayList<SpeakerSeminarsWrapper> array) {
    int n = 0;
    for (int i = 0; i < array.size(); i++) {
      ContentValues initialValues = new ContentValues();
      initialValues.put("_id", MyUIApplication.speakerId);
      initialValues.put("name", array.get(i).name);
      initialValues.put("Title", array.get(i).Title);
      initialValues.put("Day", array.get(i).Day);
      initialValues.put("description", array.get(i).description);
      initialValues.put("visited", array.get(i).visited);
      initialValues.put("favourites", array.get(i).favourites);
      initialValues.put("EventCode", MyUIApplication.EventCode);
      initialValues.put("ClientCode", MyUIApplication.ClientCode);

      String[] strArray = {
        MyUIApplication.speakerId, MyUIApplication.EventCode, MyUIApplication.ClientCode
      };
      n =
          dbAdapter.updateRecordsInDB(
              "speakerSeminar", initialValues, "_id=? and EventCode=? and ClientCode=?", strArray);
    }

    return n;
  }