AdapterView.OnItemClickListener mItemListener = new OnItemClickListener() {
public void onItemClick(AdapterView<?> adapter, View v,int pos,long id) {
final int posizione = pos;
Cursor r = db2.fetchProducts2();
int mNameIndex = r.getColumnIndex( MyDatabase2.ProductsMetaDataArt.PRODUCT_NOME_KEY);
int mUriIndex = r.getColumnIndex( MyDatabase2.ProductsMetaDataArt.PRODUCT_URIIMG_KEY);
ImageView image = new ImageView(activity);
AlertDialog.Builder builder = new AlertDialog.Builder(activity);
String s = r.getString(mUriIndex).substring(8);
s=s.replaceAll("%20", " ");
BitmapFactory.Options options = new BitmapFactory.Options();
options.inSampleSize = 2;
Bitmap bm = BitmapFactory.decodeFile(myJpgPath, options);
image.setImageBitmap(bm);
builder.setTitle("Conferma Acquisto");
builder.setIcon(R.drawable.carrello);
builder.setNegativeButton("Annulla", new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dialog, int id) {
builder.setMessage("Vuoi acquistare una confezione di "+r.getString(mNameIndex)+" ?").setCancelable(false);
builder.setPositiveButton("Conferma", new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dialog, int id) {
Cursor r = db2.fetchProducts2();
r.moveToPosition(posizione);
int mIdIndex = r.getColumnIndex( MyDatabase2.ProductsMetaDataLog.PRODUCT_ID_KEY);
int mQtaIndex = r.getColumnIndex( MyDatabase2.ProductsMetaDataLog.PRODUCT_QUANT_KEY);
db2.updateQuantita(Integer.parseInt(r.getString(mIdIndex)), Integer.parseInt(r.getString(mQtaIndex))-1);
((ListView)findViewById(R.id.productsLv)).setOnItemClickListener(mItemListener);