private void populateList(ArrayList<Records> recordList, boolean artistMode) {
final MyDBHandler dbHandler = new MyDBHandler(getApplicationContext(), null, null, 1);
recordDisplayList = (ListView) findViewById(R.id.listViewMainDisplay);
if (!databaseTable.equals("lentout")) {
customAdapter = new ListViewAdapterMain(this, recordList, null);
customAdapter.artistView = artistMode;
customAdapter.callingTable = databaseTable;
} else {
ArrayList<LentOut> lentOutList =
dbHandler.getLentOut("SELECT * FROM lentout ORDER BY album_id");
customAdapter = new ListViewAdapterMain(this, recordList, lentOutList);
customAdapter.setIsOnLendOutScreen(true);
customAdapter.callingTable = databaseTable;
}
recordDisplayList.setAdapter(customAdapter);
recordDisplayList.setOnItemClickListener(
new AdapterView.OnItemClickListener() {
@Override
public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
Records selectedRecord = customAdapter.getItem(position);
String selectedBandName = selectedRecord.get_bandname();
populateArrayList(
"SELECT * FROM " + databaseTable + " WHERE bandname='" + selectedBandName + "';",
false);
}
});
customAdapter.notifyDataSetChanged();
dbHandler.close();
}
private void populateGenreList(ArrayList<Records> recordList) {
recordDisplayList = (ListView) findViewById(R.id.listViewMainDisplay);
customAdapter = new ListViewAdapterMain(this, recordList, null);
customAdapter.artistView = true;
recordDisplayList.setAdapter(customAdapter);
recordDisplayList.setOnItemClickListener(
new AdapterView.OnItemClickListener() {
@Override
public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
Records selectedRecord = customAdapter.getItem(position);
String selectedBandName = selectedRecord.get_bandname();
populateArrayList(
"SELECT * FROM records INNER JOIN recordsgenres ON records._id=recordsgenres.album_id WHERE recordsgenres.genre='"
+ selectedBandName
+ "' ORDER BY records._id;",
false);
}
});
customAdapter.notifyDataSetChanged();
}