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();
}
