samedi 11 avril 2015

My columns in my Database will not update

Hi I'm using an app which takes in a calorie input from the user through an edit text and adds this value to a database column which corresponds with the day the user entered the calorie. However when i run my app the value for the calorie amount on the certain day does not add on instead the previous input is replaced by the new input?


Users Table:



private static final String KEY_U_ID = "U_ID";
private static final String KEY_USERNAME = "Username";
private static final String KEY_PASSWORD = "Password";
private static final String KEY_AGE = "Age";
private static final String KEY_EMAIL = "Email";
private static final String KEY_GENDER = "Gender";
private static final String KEY_HEIGHT = "Height";
private static final String KEY_WEIGHT = "Weight";
private static final String KEY_BMI = "BMI";
private static final String KEY_BMR = "BMR";
private static final String KEY_MON_CAL = "Monday_Calories";
private static final String KEY_TUES_CAL = "Tuesday_Calories";
private static final String KEY_WED_CAL = "Wednesday_Calories";
private static final String KEY_THURS_CAL = "Thursday_Calories";
private static final String KEY_FRI_CAL = "Friday_Calories";
private static final String KEY_SAT_CAL = "Saturday_Calories";
private static final String KEY_SUN_CAL = "Sunday_Calories";


Im using an if statement to determine which day column to enter into:



Globals g = Globals.getInstance();
DateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd");
Calendar cal = Calendar.getInstance();
SimpleDateFormat sdf = new SimpleDateFormat("EEEE");
Date d = new Date();
String dayOfTheWeek = sdf.format(d);

//get current user ID
int currentUserid = g.getID();
//GET CURRENT USER
Users currentuser = db.getUser(g.getID());
//GET CURRENT DATE
Date currentdate = cal.getTime();
//CHANGE DATE TO STRING
DateFormat df = new SimpleDateFormat("MM/dd/yyyy");
String date = df.format(currentdate);
//GET CURRENT DAY
String currentday = dayOfTheWeek;
//GET CALORIE INTAKE
double CalorieIntake = calories;
double newcalories;
Users users = db.getUser(currentUserid);
if(currentday.equals("Monday")){
newcalories = users.get_Monday_Cal() + calories;
users.set_Monday_Cal(newcalories);
db.updateUser(users);
}
else if (currentday.equals("Tuesday")){
newcalories = users.get_Tuesday_Cal() + calories;
users.set_Tuesday_Cal(newcalories);
db.updateUser(users);
}
else if (currentday.equals("Wednesday")) {
newcalories = users.get_Wednesday_Cal() + calories;
users.set_Wednesday_Cal(newcalories);
db.updateUser(users);
}
else if (currentday.equals("Thursday")){
newcalories = (users.get_Thursday_Cal() + calories);
users.set_Thursday_Cal(newcalories);
db.updateUser(users);
}
else if (currentday.equals("Friday")){
newcalories = (users.get_Friday_Cal() + calories);
users.set_Friday_Cal(newcalories);
db.updateUser(users);
}
else if(currentday.equals("Saturday")){
users.set_Saturday_Cal(users.get_Saturday_Cal() + calories);
users.get_Saturday_Cal();
db.updateUser(users);
}
else if (currentday.equals("Sunday")){
newcalories = users.get_Sunday_Cal() + calories;
users.set_Sunday_Cal(newcalories);
db.updateUser(users);
}
String calorielog = "Userid: " + users.get_id() + "Username: " + users.get_username() + "Password: " + users.get_password() + "Monday " + users.get_Monday_Cal() + "Tuesday " + users.get_Tuesday_Cal() + "Wednesday " + users.get_Wednesday_Cal() + "Thursday " + users.get_Thursday_Cal() + "Friday " + users.get_Friday_Cal() + "Saturday " + users.get_Saturday_Cal() + "Sunday " + users.get_Sunday_Cal();
Log.d("User", calorielog);

Aucun commentaire:

Enregistrer un commentaire