private void putInList() {
Cursor c = mDbHelper.getAllRows();
// Cursor life time
startManagingCursor(c);
// Cursor map to view fields
String[] fieldNames =
new String[] {
DBAdapterUsers.KEY_ROWID,
DBAdapterUsers.KEY_USERFNAME,
DBAdapterUsers.KEY_USERSNAME,
DBAdapterUsers.KEY_USERNUM,
DBAdapterUsers.KEY_USEREMAIL
};
int[] getIds =
new int[] {
R.id.textViewUserID,
R.id.textViewFname,
R.id.textViewSname,
R.id.textViewNum,
R.id.textviewEmail
};
SimpleCursorAdapter cAdapter =
new SimpleCursorAdapter(this, R.layout.user_layout, c, fieldNames, getIds);
ListView UserList = (ListView) findViewById(R.id.listViewUsers);
UserList.setAdapter(cAdapter);
}
@Override
protected void onPrepareDialog(int id, Dialog dialog) {
switch (id) {
case 0:
UserList.clear();
Cursor c = mDbHelper.getAllRows();
startManagingCursor(c);
c.moveToFirst();
for (int i = 0; i < c.getCount(); i++) {
UserList.add(c.getString(c.getColumnIndex("userfname")));
c.moveToNext();
}
UserItems = UserList.toArray(new CharSequence[UserList.size()]);
AlertDialog ad = (AlertDialog) dialog;
ad.getListView()
.setAdapter(
new ArrayAdapter<String>(this, android.R.layout.select_dialog_item, UserList));
}
}
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_user);
if (savedInstanceState == null) {
getSupportFragmentManager()
.beginTransaction()
.add(R.id.container, new PlaceholderFragment())
.commit();
}
setupAddTaskButton();
setUpDeleteUserButton();
setUpOnClickList();
// DATABASE POPULATE
mDbHelper = new DBAdapterUsers(this);
mDbHelper.open();
putInList();
}
