// Getters
 // Getting specific assignment
 public Assignment getAssignment(int aid) {
   Log.d("Went into getAssignment", "yes: " + Integer.toString(aid));
   String selectQuery = "SELECT * FROM Assignment " + " WHERE aid = " + aid;
   Log.d("selectQuery: ", selectQuery);
   SQLiteDatabase db = this.getWritableDatabase();
   Cursor cursor = db.rawQuery(selectQuery, null);
   cursor.moveToFirst();
   Log.d("getAssignment cursor size: ", Integer.toString(cursor.getCount()));
   Log.d("getAssignment cursor 1st entry: ", cursor.getString(0));
   Assignment assignment = new Assignment();
   assignment.setaid(Integer.parseInt(cursor.getString(0)));
   assignment.settitle(cursor.getString(1));
   assignment.settype(cursor.getString(2));
   assignment.setmonth(Integer.parseInt(cursor.getString(3)));
   assignment.setday(Integer.parseInt(cursor.getString(4)));
   assignment.setyear(Integer.parseInt(cursor.getString(5)));
   assignment.setpriority(Integer.parseInt(cursor.getString(6)));
   Log.d("Got priority", cursor.getString(6));
   Log.d("Course = ", cursor.getString(7));
   if (cursor.getInt(7) > 0)
     assignment.setCourse(getCourse(Integer.parseInt(cursor.getString(7))));
   else assignment.setCourse(null);
   if (cursor.getInt(8) > 0)
     assignment.setInstructor(getInstructor(Integer.parseInt(cursor.getString(8))));
   else assignment.setInstructor(null);
   assignment.setPartner(getPartners(assignment.getaid()));
   assignment.setnotes(cursor.getString(9));
   assignment.setCompleted(cursor.getInt(10));
   if (cursor.getInt(10) == 1) {
     assignment.setGrade(getGrade(assignment.getaid()));
   }
   Log.d("Got everything successfully", "yes");
   return assignment;
 }
  // Setters
  // Adding new Assignment
  public void addAssignment(Assignment assignment) {
    Log.d("cane into addAssignment", "yes");
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(TITLE, assignment.gettitle());
    values.put(TYPE, assignment.gettype());
    values.put(MONTH, assignment.getmonth());
    values.put(DAY, assignment.getday());
    values.put(YEAR, assignment.getyear());
    values.put(PRIORITY, assignment.getpriority());
    Log.d("set priority", "yes");
    if (assignment.getCourse() != null) values.put(C_ID, assignment.getCourse().getcid());
    else values.put(C_ID, 0);
    if (assignment.getinstructor() != null) values.put(I_ID, assignment.getinstructor().getiid());
    else values.put(I_ID, 0);
    values.put(NOTES, assignment.getnotes());
    values.put(COMPLETED, assignment.getcompleted());
    Log.d("ContentValues:", values.toString());
    Log.d("Am about to input values to database", "yes");
    long aid = db.insert(TABLE_ASSIGNMENT, null, values);
    assignment.setaid((int) aid);
    db.close(); // Closing database connection

    if (assignment.getpartners().size() > 0) {
      for (int count = 0; count < assignment.getpartners().size(); count++) {
        assignment.getpartners().get(count).setaid(assignment.getaid());
      }
      addPartner(assignment.getpartners());
    }
    if (assignment.getgrade() != null) {
      assignment.getgrade().setaid(assignment.getaid());
      addGrade(assignment.getgrade());
    }
  }
 // Delete
 public void deleteAssignment(Assignment assignment) {
   SQLiteDatabase db = this.getWritableDatabase();
   db.delete(TABLE_ASSIGNMENT, A_ID + "=?", new String[] {String.valueOf(assignment.getaid())});
   db.close();
   deletePartners(assignment.getpartners());
   deleteGrade(assignment.getgrade());
 }
  // Update
  public int updateAssignment(Assignment assignment) {
    int update;
    Log.d("Went into updateAssignment", "yes");
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(TITLE, assignment.gettitle());
    values.put(TYPE, assignment.gettype());
    values.put(MONTH, assignment.getmonth());
    values.put(DAY, assignment.getday());
    values.put(YEAR, assignment.getyear());
    values.put(PRIORITY, assignment.getpriority());
    if (assignment.getCourse() != null) values.put(C_ID, assignment.getCourse().getcid());
    if (assignment.getinstructor() != null) values.put(I_ID, assignment.getinstructor().getiid());
    values.put(NOTES, assignment.getnotes());
    values.put(COMPLETED, assignment.getcompleted());

    update =
        db.update(
            TABLE_ASSIGNMENT,
            values,
            A_ID + "= ?",
            new String[] {String.valueOf(assignment.getaid())});
    if (assignment.getpartners() != null) updatePartner(assignment.getpartners());
    if (assignment.getgrade() != null) updateGrade(assignment.getgrade());
    return update;
  }