コード例 #1
0
  private void importData() throws ClientProtocolException, JSONException, IOException {
    String sendReadRequest = sendReadRequest();
    JSONObject result = new JSONObject(sendReadRequest);
    // Je�eli co� poszlo nie tak to konczymy import
    if (!"OK".equals(result.getString("response"))) return;

    JSONObject data = result.getJSONObject("data");
    JSONArray tasks = data.getJSONArray("tasks");

    TaskQueries.deleteTasks(TaskDb.getWritableDatabase());

    for (int i = 0; i < tasks.length(); i++) {
      JSONObject task = tasks.getJSONObject(i);

      ContentValues vals = new ContentValues();
      vals.put(Task._ID, task.getLong(Task._ID));
      vals.put(Task.C_NAME, task.getString(Task.C_NAME));
      vals.put(Task.C_DESCR, task.getString(Task.C_DESCR));

      // Dodajemy rekordy do bazy
      TaskQueries.insertTask(TaskDb.getWritableDatabase(), vals);
    }

    Toast.makeText(this, "Zaladowalem " + tasks.length() + " zada�.", Toast.LENGTH_SHORT).show();
  }
コード例 #2
0
  @Override
  public boolean onContextItemSelected(MenuItem item) {
    ContextMenuInfo menuInfo = item.getMenuInfo();
    AdapterContextMenuInfo aMenuInfo = (AdapterContextMenuInfo) menuInfo;

    TaskQueries.deleteTask(TaskDb.getWritableDatabase(), aMenuInfo.id);
    reloadList();

    /*
    AlertDialog.Builder adb=new AlertDialog.Builder(TaskListActivity.this);
    adb.setTitle("Usuna�?");
          adb.setMessage("Czy jeste� pewien, �e chesz usuna� pozycje " + aMenuInfo.id);
          adb.setNegativeButton("Anuluj", null);
          adb.setPositiveButton("Usu�", new AlertDialog.OnClickListener() {

    	@Override
    	public void onClick(DialogInterface arg0, int arg1) {
    		//Toast.makeText(TaskListActivity.this, "menu ctx id = ", Toast.LENGTH_SHORT).show();
    		//TaskQueries.deleteTask(TaskDb.getWritableDatabase(), aMenuInfo.id);
    	}

          });
          adb.show();
    */

    return true;
  }
コード例 #3
0
 private JSONArray readTaskList() throws JSONException {
   Cursor cursor = null;
   JSONArray retult = new JSONArray();
   try {
     cursor = TaskQueries.selectTasks(TaskDb.getReadableDatabase());
     if (cursor.moveToFirst()) {
       do {
         JSONObject taskObject = new JSONObject();
         taskObject.put(Task._ID, cursor.getLong(cursor.getColumnIndex(Task._ID)));
         taskObject.put(Task.C_NAME, cursor.getString(cursor.getColumnIndex(Task.C_NAME)));
         taskObject.put(Task.C_DESCR, cursor.getString(cursor.getColumnIndex(Task.C_DESCR)));
         retult.put(taskObject);
       } while (cursor.moveToNext());
     }
   } catch (Exception e) {
     Log.d("BUBA", e.getMessage());
   } finally {
     if (cursor != null) cursor.close();
   }
   return retult;
 }
コード例 #4
0
 @Override
 protected Cursor doInBackground(szkolenie.tasklist.TaskDb... params) {
   return TaskQueries.selectTasks(params[0].getReadableDatabase());
 }