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();
}
}
}