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);
}
public void addTransaction(int foodId, double proportion) {
String currentTime = getCurrentTime();
Log.d("addTransaction", Integer.toString(foodId));
SQLiteDatabase db = this.getWritableDatabase();
// add new food transaction
ContentValues values = new ContentValues();
values.put(FOOD_ID, foodId);
values.put(COL_PROPORTION, proportion);
values.put(COL_TIME, currentTime);
db.insert(TABLE_TRANSACTION, null, values);
db.close();
// update food
Food food = getFood(foodId);
food.setFrequency(food.getFrequency() + 1);
food.setStrLastTransaction(currentTime);
Log.d(currentTime, food.toString());
updateFood(foodId, food);
}
public String toString() {
return food.toString();
}
