i am trying to set up a delete button to delete a customer from a table, the customers are displayed in card views using a recycler view so each customer will have their own delete button, the customer information are displayed using textviews. i need to pass the customer id to the delete method i order to search the table for that specific id to delete. how do i pass the data succesfully?
when i click the button in app i get blank screen and it returns to the home screen, if anyone can help me be much appreciated
this is what iver currently got to try and pass the data i need
passing data to method
public void onBindViewHolder(@NonNull MyHolder holder, final int position) {
holder.idText.setText(String.valueOf(id.get(position)));
holder.nameText.setText(String.valueOf(name.get(position)));
holder.surnameText.setText(String.valueOf(surname.get(position)));
holder.add1Text.setText(String.valueOf(add1.get(position)));
holder.add2Text.setText(String.valueOf(add2.get(position)));
holder.add3Text.setText(String.valueOf(add3.get(position)));
holder.postCodeText.setText(String.valueOf(postCode.get(position)));
holder.phoneNumberText.setText(String.valueOf(phoneNumber.get(position)));
holder.emailText.setText(String.valueOf(email.get(position)));
GlobalVars.id = holder.idText.getText().toString();
holder.delete.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
db.deleteCustomer(GlobalVars.id);
}
});
}
delete method
public long deleteCustomer(String id)
{
SQLiteDatabase db = this.getWriteableDatabase();
ContentValues idValue = new ContentValues();
idValue.put(CUSTOMER_ID, id);
return db.delete(TABLE_NAME, "where Customer_ID = " + idValue, null);
}
What I have tried:
holder.delete.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
db.deleteCustomer(GlobalVars.id);
}
});