public int updateInstructor(Instructor instructor) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(NAME, instructor.getname()); values.put(DEPARTMENT, instructor.getdepartment()); values.put(C_ID, instructor.getcourse().getcid()); values.put(EMAIL, instructor.getemail()); values.put(WEBPAGE, instructor.getwebpage()); values.put(PHONE, instructor.getphone()); values.put(OFFICEHOURS, instructor.getoffice_hours()); values.put(NOTES, instructor.getnotes()); return db.update( TABLE_INSTRUCTOR, values, I_ID + "= ?", new String[] {String.valueOf(instructor.getiid())}); }
// Adding new Instructor public void addInstructor(Instructor instructor) { Log.d("entered addInstructor", "yes"); SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(NAME, instructor.getname()); values.put(DEPARTMENT, instructor.getdepartment()); if (instructor.getcourse() != null) values.put(C_ID, instructor.getcourse().getcid()); else values.put(C_ID, 0); values.put(EMAIL, instructor.getemail()); values.put(WEBPAGE, instructor.getwebpage()); values.put(PHONE, instructor.getphone()); values.put(OFFICEHOURS, instructor.getoffice_hours()); values.put(NOTES, instructor.getnotes()); Long success = db.insert(TABLE_INSTRUCTOR, null, values); Log.d("added instructor successfully", success.toString()); db.close(); }