public class MainActivity extends AppCompatActivity {
DbHelper helper =new DbHelper(this);
Map<Integer, myCustomObject> listp = new TreeMap<>();
Adapter_MainActivity adapter_MainActivity;
@<a rel="nofollow" href="https://www.androidiani.com/forum/members/override.html" target="_blank">Override</a>
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
setSupportActionBar(toolbar);
db= helper.getReadableDatabase();
listView = (ListView) findViewById(R.id.listView);
listView.setFastScrollEnabled(true);
listView.setOnItemClickListener(new AdapterView.OnItemClickListener() {
public void onItemClick(AdapterView<?> arg0, View v, int position, long arg3) {
v.setBackgroundColor(0x8BC7DB);
TextView lblListHeader = (TextView) v.findViewById(R.id.textViewList);
String nome = lblListHeader.getText().toString();
String[] selectionArg = {nome};
Cursor g = db.rawQuery("SELECT _id FROM contatore WHERE titolo = ?", selectionArg);
String id = g.getString(0);
intent = new Intent(getApplicationContext(), Contatore.class);
String Salsiccia = getPackageName();
intent.putExtra(Salsiccia + ".myString", nome);
intent.putExtra(Salsiccia + ".myInt", id);
listView.setOnItemLongClickListener(new AdapterView.OnItemLongClickListener() {
@<a rel="nofollow" href="https://www.androidiani.com/forum/members/override.html" target="_blank">Override</a>
public boolean onItemLongClick(AdapterView<?> parent, View view, int position, long id) {
TextView lblListHeader = (TextView) view.findViewById(R.id.textViewList);
final String nome = lblListHeader.getText().toString();
final AlertDialog.Builder adb = new AlertDialog.Builder(MainActivity.this);
adb.setTitle("Elimina:");
adb.setMessage("Sei sicuro di voler eliminare " + (nome) + " ?");
adb.setNegativeButton("Annulla", null);
adb.setPositiveButton("Ok", new AlertDialog.OnClickListener() {
public void onClick(DialogInterface dialog, int which) {
String[] selectionArg = {nome};
Cursor g = db.rawQuery("SELECT _id FROM contatore WHERE titolo = ?", selectionArg);
String id = g.getString(0);
String table_name2 = "promemoria ";
String where2 = "idcont=?";
String[] whereArgs2 = {id};
db.delete(table_name2, where2, whereArgs2);
String table_name = "contatore ";
String where = "titolo=?";
String[] whereArgs = {nome};
db.delete(table_name, where, whereArgs);
FloatingActionButton fab = (FloatingActionButton) findViewById(R.id.fab);
fab.setOnClickListener(new View.OnClickListener() {
@<a rel="nofollow" href="https://www.androidiani.com/forum/members/override.html" target="_blank">Override</a>
public void onClick(View view) {
intent = new Intent(getApplicationContext(), Add.class)
.addFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP);
adapter_MainActivity.clear();
@<a rel="nofollow" href="https://www.androidiani.com/forum/members/override.html" target="_blank">Override</a>
protected void onRestart() {
public void Aggiornare(){
adapter_MainActivity = new Adapter_MainActivity(this, R.layout.row_principale, listp);
Cursor c = db.rawQuery("SELECT * FROM contatore",null);
for (int i = 0; i < c.getCount(); i++) {
Cursor a = db.rawQuery("SELECT numero FROM promemoria WHERE idcont=? ORDER BY _id DESC LIMIT 1", new String[]{c.getString(0)});
listp.put(i, new myCustomObject(c.getString(1), a.getInt(0)));
adapter_MainActivity.clear();
adapter_MainActivity.notifyDataSetChanged();
adapter_MainActivity.add(listp);
adapter_MainActivity.notifyDataSetChanged();
listView.setAdapter(adapter_MainActivity);