// INSERT ISSUE
public long createIssue(Bug bug) {
long id;
ContentValues values = new ContentValues();
values.put(Bugtracking.IssueEntry.TITLE, bug.getTitle());
values.put(Bugtracking.IssueEntry.CATEGORY, bug.getCategory());
values.put(Bugtracking.IssueEntry.DATE, bug.getDate());
values.put(Bugtracking.IssueEntry.DESCRIPTION, bug.getDescription());
values.put(Bugtracking.IssueEntry.DEVID, bug.getDevId());
values.put(Bugtracking.IssueEntry.EFFECT, bug.getEffects());
values.put(Bugtracking.IssueEntry.PRIORITY, bug.getPriority());
values.put(Bugtracking.IssueEntry.PROID, bug.getProjectId());
values.put(Bugtracking.IssueEntry.REFERENCE, bug.getReference());
values.put(Bugtracking.IssueEntry.REPRODUCE, bug.getReproduce());
values.put(Bugtracking.IssueEntry.STATE, bug.getState());
id = this.db.insert(Bugtracking.IssueEntry.TABLE_ISSUE, null, values);
return id;
}
// UPDATE ISSUE
public int updateIssue(Bug bug) {
ContentValues values = new ContentValues();
values.put(Bugtracking.IssueEntry.TITLE, bug.getTitle());
values.put(Bugtracking.IssueEntry.CATEGORY, bug.getCategory());
values.put(Bugtracking.IssueEntry.DATE, bug.getDate());
values.put(Bugtracking.IssueEntry.DESCRIPTION, bug.getDescription());
values.put(Bugtracking.IssueEntry.DEVID, bug.getDevId());
values.put(Bugtracking.IssueEntry.EFFECT, bug.getEffects());
values.put(Bugtracking.IssueEntry.PRIORITY, bug.getPriority());
values.put(Bugtracking.IssueEntry.PROID, bug.getProjectId());
values.put(Bugtracking.IssueEntry.REFERENCE, bug.getReference());
values.put(Bugtracking.IssueEntry.REPRODUCE, bug.getReproduce());
values.put(Bugtracking.IssueEntry.STATE, bug.getState());
return this.db.update(
Bugtracking.IssueEntry.TABLE_ISSUE,
values,
Bugtracking.IssueEntry.ID + " = ?",
new String[] {String.valueOf(bug.getId())});
}