lundi 2 mai 2016

Insert Or Update in Android

I have a method like that

private void addDataToDailyStatisticsIncome(String date, String money, int idUser){
    Cursor res1 = db.getDataTableDailyStatistic(idUser);
    int temp = 0;
    int money1, money2;

    res1.moveToFirst();
    while (res1.moveToNext()) {
        if (date.equals(res1.getString(1)) == true) {
            temp = 1;
            break;
        } else {
            temp = 0;
        }
    }

    if(temp == 1){
        money1 = Integer.parseInt(res1.getString(3));
        money2 = Integer.parseInt(money);

        money1 = money1 + money2;

        long isUpdated = db.updateTableDailyStatistic(res1.getString(1), Integer.toString(money1), idUser, Integer.parseInt(res1.getString(0)));

    } else{
        long isInserted = db.insertTableDailyStatistic(date, money, idUser);
    }
}

I want to check when new data insert to app. If "date" is available, i will update "money" in same date. Or if "date" is not available, i will insert new Date with Money.

But i have 1 problem that it always inserts, it never updates although i have a same Date in Database. Can you help me fix this problem?

Aucun commentaire:

Enregistrer un commentaire