public void updateTimestamp(String timeStamp) {
ContentValues initialValues = new ContentValues();
initialValues.put("updatetimestamp", timeStamp);
String[] strArray = {MyUIApplication.EventCode, MyUIApplication.ClientCode};
long n =
dbAdapter.updateRecordsInDB(
"speakerList", initialValues, "EventCode=? and ClientCode=?", strArray);
}
public void visited(String seminarName, String visited) {
String isVisited = "false";
if (visited.equals("false")) {
isVisited = "true";
} else if (visited.equals("true")) {
isVisited = "false";
}
ContentValues initialValues = new ContentValues();
initialValues.put("visited", isVisited);
String[] strArray = {MyUIApplication.EventCode, MyUIApplication.ClientCode, seminarName};
long n =
dbAdapter.updateRecordsInDB(
"speakerSeminar", initialValues, "EventCode=? and ClientCode=? and Title=?", strArray);
}
public void favourites(String id, String favourites) {
String isFavourite = "false";
if (favourites.equals("false")) {
isFavourite = "true";
} else if (favourites.equals("true")) {
isFavourite = "false";
}
ContentValues initialValues = new ContentValues();
initialValues.put("favourites", isFavourite);
String[] strArray = {MyUIApplication.EventCode, MyUIApplication.ClientCode, id};
long n =
dbAdapter.updateRecordsInDB(
"speakerList", initialValues, "EventCode=? and ClientCode=? and _id=?", strArray);
}
public int updateTable(ArrayList<SpeakerWrapper> array) {
int n = 0;
for (int i = 0; i < array.size(); i++) {
ContentValues initialValues = new ContentValues();
initialValues.put("_id", array.get(i).id);
initialValues.put("name", array.get(i).name);
initialValues.put("email", array.get(i).email);
initialValues.put("post", array.get(i).post);
initialValues.put("companyname", array.get(i).companyname);
initialValues.put("description", array.get(i).description);
initialValues.put("image", array.get(i).image);
initialValues.put("EventCode", MyUIApplication.EventCode);
initialValues.put("ClientCode", MyUIApplication.ClientCode);
String[] strArray = {array.get(i).id, MyUIApplication.EventCode, MyUIApplication.ClientCode};
n =
dbAdapter.updateRecordsInDB(
"speakerList", initialValues, "_id=? and EventCode=? and ClientCode=?", strArray);
}
return n;
}
public int updateTable(ArrayList<SpeakerSeminarsWrapper> array) {
int n = 0;
for (int i = 0; i < array.size(); i++) {
ContentValues initialValues = new ContentValues();
initialValues.put("_id", MyUIApplication.speakerId);
initialValues.put("name", array.get(i).name);
initialValues.put("Title", array.get(i).Title);
initialValues.put("Day", array.get(i).Day);
initialValues.put("description", array.get(i).description);
initialValues.put("visited", array.get(i).visited);
initialValues.put("favourites", array.get(i).favourites);
initialValues.put("EventCode", MyUIApplication.EventCode);
initialValues.put("ClientCode", MyUIApplication.ClientCode);
String[] strArray = {
MyUIApplication.speakerId, MyUIApplication.EventCode, MyUIApplication.ClientCode
};
n =
dbAdapter.updateRecordsInDB(
"speakerSeminar", initialValues, "_id=? and EventCode=? and ClientCode=?", strArray);
}
return n;
}