public void markAsBookmark(int point_id) {
SQLiteDatabase db = mNavigationDBHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(POINT_ID, point_id);
if (!pointExists(point_id)) {
db.insert(SCHOOL_BOOKMARK_TABLE, POINT_ID, values);
}
}
public void saveNavigationListItem(NavigationListItem item) {
SQLiteDatabase db = mNavigationDBHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(TYPE, item.type);
values.put(POINT_ID, item.point_id);
if (!isNavigationListItemExists(item.point_id)) {
db.insert(NAVIGATION_TYPE_TABLE, POINT_ID, values);
} else {
db.update(
NAVIGATION_TYPE_TABLE,
values,
POINT_ID_WHERE,
new String[] {String.valueOf(item.point_id)});
}
}
public boolean saveNavigationItem(NavigationItem item) {
boolean bFlags = false;
SQLiteDatabase db = mNavigationDBHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(NAME, item.name);
values.put(TYPE, item.type);
values.put(POINT_ID, item.point_id);
values.put(PARENT_ID, item.parent_id);
values.put(SCHOOL_KEY, item.key);
values.put(TITLEURL, item.titleurl);
values.put(STATUS, item.status);
if (schoolDistrictExist(item.point_id)) {
db.update(
SCHOOL_DISTRICT_TABLE,
values,
POINT_ID_WHERE,
new String[] {String.valueOf(item.point_id)});
} else {
bFlags = true;
db.insert(SCHOOL_DISTRICT_TABLE, POINT_ID, values);
}
return bFlags;
}
public void endTransaction() {
mNavigationDBHelper.getWritableDatabase().setTransactionSuccessful();
mNavigationDBHelper.getWritableDatabase().endTransaction();
}
public void startTransaction() {
mNavigationDBHelper.getWritableDatabase().beginTransaction();
}
private NavigationDB(Context context) {
mNavigationDBHelper = NavigationDatabaseHelper.getInstance(context);
SQLiteDatabase db = mNavigationDBHelper.getWritableDatabase();
createTable(db);
db.close();
}
public void deleteBookmarkFlag(int point_id) {
SQLiteDatabase db = mNavigationDBHelper.getWritableDatabase();
if (pointExists(point_id)) {
db.delete(SCHOOL_BOOKMARK_TABLE, POINT_ID_WHERE, new String[] {String.valueOf(point_id)});
}
}
public void clearAllNavigationList() {
SQLiteDatabase db = mNavigationDBHelper.getWritableDatabase();
db.delete(NAVIGATION_TYPE_TABLE, null, null);
}
public void clearChildBySearchKey(String searchkey) {
SQLiteDatabase db = mNavigationDBHelper.getWritableDatabase();
db.delete(SCHOOL_DISTRICT_TABLE, NAME + " LIKE '%" + searchkey + "%'", null);
}
public void clearChildID(String parentid) {
SQLiteDatabase db = mNavigationDBHelper.getWritableDatabase();
db.delete(SCHOOL_DISTRICT_TABLE, PARENT_ID + "=?", new String[] {parentid});
}
