private void manageDuplicate(final MyDBHandler dbHandler) {
String result =
dbHandler.runRawQueryIfExists(
"SELECT * FROM lentout WHERE album_id='" + recordID + "'", "album_id");
if (!result.equals("-1")) {
AlertDialog.Builder builder = new AlertDialog.Builder(this);
builder.setTitle("Duplicate Lent Out");
builder.setMessage("This record is show as already out, would you like override?");
builder.setPositiveButton(
"YES",
new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dialog, int which) {
dbHandler.runRawQueryNoResult(
"DELETE FROM " + "lentout WHERE album_id=\"" + recordID + "\";");
dialog.dismiss();
lendOutRecord(dbHandler);
}
});
builder.setNegativeButton(
"NO",
new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
// Do nothing
dialog.dismiss();
}
});
AlertDialog alert = builder.create();
alert.show();
} else lendOutRecord(dbHandler);
}
