Android Open Source - iEtueri Homework Fragment

• Back to App/log  ↑

From Project

Back to project page iEtueri.

License

The source code is released under:

GNU General Public License

Java Source Code

package homework;
//from   w ww.  j  a v a 2s . c  o  m
import java.util.ArrayList;
import java.util.Collections;

import navigationdrawer.MainActivity;
import navigationdrawer.NavigationDrawerController;
import utility.DatabaseContract;
import utility.DatabaseHelper;
import android.app.Activity;
import android.app.Fragment;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemLongClickListener;
import android.widget.ListView;
import android.widget.TextView;

import com.javils.ietueri.R;

public class HomeworkFragment extends Fragment {

  private DatabaseHelper dbHelper;
  private SQLiteDatabase db;
  private ListView listHomework;

  @Override
  public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {
    View view = inflater.inflate(R.layout.fragment_homework, container, false);

    /** Get the instances of the views */
    listHomework = (ListView) view.findViewById(R.id.list_homework);

    ArrayList<Homework> homework = getAllHomework();
    if (homework.size() == 0) {
      view = inflater.inflate(R.layout.fragment_void, container, false);
      TextView description = (TextView) view.findViewById(R.id.fragment_void_description);
      description.setText(R.string.homework_description);
    } else {
      final HomeworkAdapter adapter = new HomeworkAdapter(getActivity(), R.layout.subject_detail_homework_item,
          homework);
      listHomework.setAdapter(adapter);

      listHomework.setOnItemLongClickListener(new OnItemLongClickListener() {

        @Override
        public boolean onItemLongClick(AdapterView<?> parent, View view, int position, long id) {
          TextView tIdHomeowrk = (TextView) view.findViewById(R.id.detail_subject_homework_homeworkId);
          String idHomework = tIdHomeowrk.getText().toString();

          String[] projection = { DatabaseContract.Homework.COLUMN_NAME_SUBJECT_ID };

          String[] argsHomeworkId = { idHomework };
          Cursor cur = db.query(DatabaseContract.Homework.TABLE_NAME, projection,
              DatabaseContract.Homework._ID + "= ?", argsHomeworkId, null, null, null);

          cur.moveToFirst();

          String subjectId = cur.getString(cur
              .getColumnIndexOrThrow(DatabaseContract.Homework.COLUMN_NAME_SUBJECT_ID));

          db.delete(DatabaseContract.Homework.TABLE_NAME, DatabaseContract.Homework._ID + "=" + idHomework,
              null);

          cur.close();

          /** Quit the homework id on subject */
          projection = new String[] { DatabaseContract.Subjects.COLUMN_NAME_HOMEWORK_ID };

          String[] argsId = { String.valueOf(subjectId) };
          cur = db.query(DatabaseContract.Subjects.TABLE_NAME, projection, DatabaseContract.Subjects._ID
              + "= ?", argsId, null, null, null);

          cur.moveToFirst();
          String sHomeworkIds = cur.getString(cur
              .getColumnIndexOrThrow(DatabaseContract.Subjects.COLUMN_NAME_HOMEWORK_ID));
          String[] homeworkIds = sHomeworkIds.split(";");
          String result = new String();
          for (int i = 0; i < homeworkIds.length; i++) {
            if (homeworkIds[i].isEmpty())
              continue;

            if (!homeworkIds[i].equals(idHomework))
              result += homeworkIds[i] + ";";
          }

          /** Update with the new values */
          ContentValues values = new ContentValues();
          values.put(DatabaseContract.Subjects.COLUMN_NAME_HOMEWORK_ID, result);
          db.update(DatabaseContract.Subjects.TABLE_NAME, values, DatabaseContract.Subjects._ID + "="
              + subjectId, null);

          adapter.remove(adapter.getItem(position));

          adapter.notifyDataSetChanged();
          return true;
        }
      });
    }
    return view;
  }

  private ArrayList<Homework> getAllHomework() {
    ArrayList<Homework> result = new ArrayList<Homework>();
    dbHelper = new DatabaseHelper(getActivity());
    db = dbHelper.getReadableDatabase();

    String[] projection = { DatabaseContract.Homework._ID, DatabaseContract.Homework.COLUMN_NAME_SUBJECT_ID,
        DatabaseContract.Homework.COLUMN_NAME_HOMEWORK_NAME, DatabaseContract.Homework.COLUMN_NAME_END_DATE,
        DatabaseContract.Homework.COLUMN_NAME_NOTE, DatabaseContract.Homework.COLUMN_NAME_DESCRIPTION,
        DatabaseContract.Homework.COLUMN_NAME_PRIORITY };

    Cursor cur = db.query(DatabaseContract.Homework.TABLE_NAME, projection, null, null, null, null, null);

    cur.moveToFirst();
    for (int i = 0; i < cur.getCount(); i++) {

      int homeworkId = Integer.parseInt(cur.getString(cur.getColumnIndexOrThrow(DatabaseContract.Homework._ID)));
      String homeworkName = cur.getString(cur
          .getColumnIndexOrThrow(DatabaseContract.Homework.COLUMN_NAME_HOMEWORK_NAME));
      int subjectId = Integer.parseInt(cur.getString(cur
          .getColumnIndexOrThrow(DatabaseContract.Homework.COLUMN_NAME_SUBJECT_ID)));
      String endDate = cur.getString(cur.getColumnIndexOrThrow(DatabaseContract.Homework.COLUMN_NAME_END_DATE));
      float note = cur.getFloat(cur.getColumnIndexOrThrow(DatabaseContract.Homework.COLUMN_NAME_NOTE));
      String description = cur.getString(cur
          .getColumnIndexOrThrow(DatabaseContract.Homework.COLUMN_NAME_DESCRIPTION));
      int priority = cur.getInt(cur.getColumnIndexOrThrow(DatabaseContract.Homework.COLUMN_NAME_PRIORITY));
      result.add(new Homework(homeworkId, subjectId, description, homeworkName, endDate, note, priority));
      cur.moveToNext();
    }

    Collections.sort(result);
    return result;
  }

  @Override
  public void onAttach(Activity activity) {
    super.onAttach(activity);
    ((MainActivity) activity).onSectionAttached(getArguments()
        .getInt(NavigationDrawerController.ARG_SECTION_NUMBER));
  }
}

Java Source Code List

• Back to App/log  ↑