// listens for the click for the user to delete the selected item displays a alert to make sure
// the user wants to delete that item
@Override
public void onItemClick(AdapterView<?> parent, View v, int pos, long id) {
cursor = dbHelper.fetchScoresForBowlerLeague(bowler, league);
cursor.moveToPosition(pos);
row = cursor.getLong(cursor.getColumnIndex(BowlerDatabaseAdapter.KEY_ROWID));
AlertDialog.Builder alert = new AlertDialog.Builder(this);
alert.setTitle("DELETE?");
alert.setMessage(
"Are you sure you want to delete this record? This will delete the detailed score information too.");
alert.setPositiveButton(
"YES",
new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
dbHelper.deleteBowlerScore(row);
fillData();
}
});
alert.setNegativeButton(
"NO",
new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
// Do Nothing
}
});
alert.show();
}
private void fillData() {
cursor = dbHelper.fetchScoresForBowlerLeague(bowler, league);
startManagingCursor(cursor);
String[] from =
new String[] {
BowlerDatabaseAdapter.KEY_BOWLER_NAME,
BowlerDatabaseAdapter.KEY_LEAGUE_NAME,
BowlerDatabaseAdapter.KEY_DATE,
BowlerDatabaseAdapter.KEY_GAME_ONE_SCORE,
BowlerDatabaseAdapter.KEY_GAME_TWO_SCORE,
BowlerDatabaseAdapter.KEY_GAME_THREE_SCORE,
BowlerDatabaseAdapter.KEY_SERIES_SCORE
};
int[] to =
new int[] {
R.id.bowler_entry,
R.id.league_entry,
R.id.date_entry,
R.id.g1_entry,
R.id.g2_entry,
R.id.g3_entry,
R.id.series_entry
};
SimpleCursorAdapter leagues =
new SimpleCursorAdapter(this, R.layout.leaguenightlist, cursor, from, to);
this.setListAdapter(leagues);
}
