public void addOrder(Order order) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(KEY_ID, order.getId()); // Contact Name
values.put(KEY_TABLE_ID, order.getTable().getId()); // Contact Phone Number
values.put(KEY_CREATED_AT, order.getCreated_at());
values.put(KEY_UPDATED_AT, order.getUpdated_at());
// Inserting Row
db.insert(TABLE_ORDERS, null, values);
ordersAdapter.aNotifyDataSetChanged();
db.close(); // Closing database connection
}
public void addOrders(List<Order> orders) {
SQLiteDatabase db = this.getWritableDatabase();
db.delete(TABLE_ORDERS, null, null);
for (Order order : orders) {
ContentValues values = new ContentValues();
values.put(KEY_ID, order.getId());
values.put(KEY_TABLE_ID, order.getTable_id());
values.put(KEY_TOTAL, order.getTotal());
values.put(KEY_READY, order.isReady());
values.put(KEY_ACTIVE, order.isActive());
values.put(KEY_CREATED_AT, order.getCreated_at());
values.put(KEY_UPDATED_AT, order.getUpdated_at());
// Inserting Row
db.insert(TABLE_ORDERS, null, values);
}
db.close(); // Closing database connection
}