// update parent
public void updateParentDetail(ArrayList<Parent> parentList) {
// TODO Auto-generated method stub
SQLiteDatabase db = this.getWritableDatabase();
for (int i = 0; i < parentList.size(); i++) {
Parent ParentList = parentList.get(i);
// String selectQuery1 = "SELECT * FROM "+TABLE_PARENTS_DETAILS +" where "+PID+"="+
// ParentList.getParentId();
try {
ContentValues values = new ContentValues();
values.put(PID, ParentList.getParentId());
values.put(ParentName, ParentList.getName());
values.put(ParentEmail, ParentList.getEmail());
values.put(ParentAddress, ParentList.getAddress());
values.put(ParentContactInfo, ParentList.getContactNumber());
values.put(ParentContactInfo_Alt, ParentList.getAltContactNumber());
values.put(Parent_NO_Students, ParentList.getStudentCount());
values.put(Parent_No_Of_Active_Student, ParentList.getActivestudents());
values.put(ParentNotes, ParentList.getNotes());
values.put(Parent_Out_Standing_Balance, ParentList.getOutstandingBalance());
// cursor = (SQLiteCursor) db.rawQuery(selectQuery1, null);
// if (cursor.moveToFirst()) {
// updating row
// int a=db.update(TABLE_PARENTS_DETAILS, values, PID + " = ?",
// new String[] { String.valueOf(ParentList.getParentId()) });
// }else{
db.insert(TABLE_PARENTS_DETAILS, null, values);
// }
} catch (Exception e) {
e.printStackTrace();
}
}
db.close();
}
