public Order create(Order order) {
ContentValues values = new ContentValues();
values.put(OrdersDBOpenHelper.COLUMN_PHONE, order.getPhoneNumber());
values.put(OrdersDBOpenHelper.COLUMN_ADDRESS, order.getAddress());
values.put(OrdersDBOpenHelper.COLUMN_CREDITCARD, order.getCreditCardNumber());
values.put(OrdersDBOpenHelper.COLUMN_ORDER, order.getOrderString());
values.put(OrdersDBOpenHelper.COLUMN_PRICE, order.getPrice());
long insertid = database.insert(OrdersDBOpenHelper.TABLE_ORDERS, null, values);
order.setId(insertid);
return order;
}
public List<Order> findAll() {
List<Order> orders = new ArrayList<>();
Cursor cursor =
database.query(OrdersDBOpenHelper.TABLE_ORDERS, allColumns, null, null, null, null, null);
if (cursor.getCount() > 0) {
while (cursor.moveToNext()) {
Order order = new Order();
order.setId(cursor.getLong(cursor.getColumnIndex(OrdersDBOpenHelper.COLUMN_ID)));
order.setPhoneNumber(
cursor.getString(cursor.getColumnIndex(OrdersDBOpenHelper.COLUMN_PHONE)));
order.setAddress(
cursor.getString(cursor.getColumnIndex(OrdersDBOpenHelper.COLUMN_ADDRESS)));
order.setCreditCardNumber(
cursor.getString(cursor.getColumnIndex(OrdersDBOpenHelper.COLUMN_CREDITCARD)));
order.setOrderFromString(
cursor.getString(cursor.getColumnIndex(OrdersDBOpenHelper.COLUMN_ORDER)));
order.setPrice(cursor.getString(cursor.getColumnIndex(OrdersDBOpenHelper.COLUMN_PRICE)));
orders.add(order);
}
}
return orders;
}