public void deleteTransaction(Transaction transaction) { int transactionId = transaction.getTransactionId(); int foodId = transaction.getFoodId(); String deletedTime = transaction.getStrTimeStamp(); SQLiteDatabase db_write = this.getWritableDatabase(); db_write.delete( TABLE_TRANSACTION, TRANSACTION_ID + "=" + Integer.toString(transactionId), null); Log.d("deleteTransaction", "id=" + Integer.toString(transactionId)); db_write.close(); SQLiteDatabase db_read = this.getReadableDatabase(); Cursor cursor = db_read.rawQuery( GET_LATEST_TRANSACTION_TIME_FOR_FOOD, new String[] {Integer.toString(foodId)}); String lastTransactionTime; if (cursor.getCount() > 0) { cursor.moveToFirst(); lastTransactionTime = cursor.getString(0); } else { lastTransactionTime = ""; } db_read.close(); Food food = getFood(foodId); food.setFrequency(food.getFrequency() - 1); food.setStrLastTransaction(lastTransactionTime); Log.d("INFO", food.toString()); updateFood(foodId, food); }
void editTransaction() { System.out.println("Enter the transaction Id to be Edit"); Scanner in = new Scanner(System.in); int tid = in.nextInt(); for (Transaction t : transactions.values()) { if (tid == t.getTransactionId()) { t.editTransaction(); } } }