ตอนที่ 17 : Show Case 4 : Delete Data (Android and Mobile Services)

package com.example.thaicreate;

public class MyMember {
	
	@com.google.gson.annotations.SerializedName("id")
	private int mId;
	
	@com.google.gson.annotations.SerializedName("username")
	private String mUsername;
	
	@com.google.gson.annotations.SerializedName("password")
	private String mPassword;	
	
	@com.google.gson.annotations.SerializedName("name")
	private String mName;	
	
	@com.google.gson.annotations.SerializedName("tel")
	private String mTel;		
	
	@com.google.gson.annotations.SerializedName("email")
	private String mEmail;	
	
	public MyMember() {
		// empty
	}
	
	public MyMember(String username, String password, 
			String name,String tel,String email) {
		this.setUsername(username);
		this.setPassword(password);
		this.setName(name);
		this.setTel(tel);
		this.setEmail(email);
	}
	
	public final void setId(int id) {
		mId = id;
	}	
	public int getId() {
		return mId;
	}
	
	public final void setUsername(String username) {
		mUsername = username;
	}
	public String getUsername() {
		return mUsername;
	}
	
	public final void setPassword(String password) {
		mPassword = password;
	}
	public String getPassword() {
		return mPassword;
	}
	
	public final void setName(String name) {
		mName = name;
	}
	public String getName() {
		return mName;
	}	
	
	public final void setTel(String tel) {
		mTel = tel;
	}
	public String getTel() {
		return mTel;
	}	
	
	public final void setEmail(String email) {
		mEmail = email;
	}
	public String getEmail() {
		return mEmail;
	}	
}

package com.example.thaicreate;

import java.net.MalformedURLException;
import java.util.List;

import android.app.Activity;
import android.app.AlertDialog;
import android.content.Context;
import android.content.DialogInterface;
import android.graphics.Color;
import android.os.Bundle;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.Menu;
import android.view.View;
import android.view.ViewGroup;
import android.widget.ArrayAdapter;
import android.widget.ImageButton;
import android.widget.ListView;
import android.widget.TextView;
import android.widget.Toast;

import com.microsoft.windowsazure.mobileservices.MobileServiceClient;
import com.microsoft.windowsazure.mobileservices.MobileServiceTable;
import com.microsoft.windowsazure.mobileservices.ServiceFilterResponse;
import com.microsoft.windowsazure.mobileservices.TableDeleteCallback;
import com.microsoft.windowsazure.mobileservices.TableQueryCallback;

public class MainActivity extends Activity {
	
	private MobileServiceClient mClient;
	private MobileServiceTable<MyMember> mMyMember;
	private MyMemberAdapter mAdapter;
	
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        
        /*** Create to Mobile Service ***/
        try {
			mClient = new MobileServiceClient(
				      "https://thaicreate.azure-mobile.net/",
				      "QUjngFknhHZjdaGgYAAzdoXkOzKoxi24",
				      this);
			
		} catch (MalformedURLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
        
        /*** Create getTable ***/
        mMyMember = mClient.getTable(MyMember.class);
        
        // listView1
        final ListView lstView1 = (ListView)findViewById(R.id.listView1); 
        mAdapter = new MyMemberAdapter(this,R.layout.activity_column);
        lstView1.setAdapter(mAdapter);
        registerForContextMenu(lstView1);
        
        refreshItemsFromTable();
        
    }
    
	private void refreshItemsFromTable() {

		mMyMember.execute(new TableQueryCallback<MyMember>() {
			public void onCompleted(List<MyMember> result, int count, Exception exception, 
					ServiceFilterResponse response) {
				
				if (exception == null) {
					mAdapter.clear();
					for (MyMember item : result) {
						mAdapter.add(item);
					}
				} else {
					Log.d("Error","Error Load Data from Mobile Service");
				}
			}
		});
	}


	public class MyMemberAdapter extends ArrayAdapter<MyMember> {
		Context mContext;
		int mLayoutResourceId;

		public MyMemberAdapter(Context context, int layoutResourceId) {
			super(context, layoutResourceId);

			mContext = context;
			mLayoutResourceId = layoutResourceId;
		}

		@Override
		public View getView(int position, View convertView, ViewGroup parent) {
			View row = convertView;

			final MyMember currentItem = getItem(position);

			if (row == null) {
				LayoutInflater inflater = ((Activity) mContext).getLayoutInflater();
				row = inflater.inflate(mLayoutResourceId, parent, false);
			}

			row.setTag(currentItem);
			
			// imgCmdDelete
			ImageButton cmdDelete = (ImageButton) row.findViewById(R.id.btnDelete);
			cmdDelete.setBackgroundColor(Color.TRANSPARENT);
			
			final AlertDialog.Builder adb = new AlertDialog.Builder(MainActivity.this);
			
			cmdDelete.setOnClickListener(new View.OnClickListener() {
				public void onClick(View v) {
					adb.setTitle("Delete?");
					adb.setMessage("Are you sure delete ?");
					adb.setNegativeButton("Cancel", null);
					adb.setPositiveButton("Ok", new AlertDialog.OnClickListener() {
					public void onClick(DialogInterface dialog, int which) {
					  
				    	//** Select Record ***//
						mMyMember.where().field("id").eq(currentItem.getId())
						 .execute(new TableQueryCallback<MyMember>() {
							
							public void onCompleted(List<MyMember> result, int count, Exception exception, 
									ServiceFilterResponse response) {
								
								if (exception == null) {
									MyMember item = result.get(0);
									// Delete Record ***/
									mMyMember.delete(item, new TableDeleteCallback() {
									    public void onCompleted(Exception exception, 
									            ServiceFilterResponse response) {
									        if(exception == null){
									        	Toast.makeText(MainActivity.this, "Delete Data Successfully", Toast.LENGTH_SHORT).show();
									        }
									        else
									        {
												Toast.makeText(MainActivity.this, "Delete Failed!", Toast.LENGTH_SHORT).show();
												Log.d("Error : ",exception.getMessage());   	
									        }
									    }
									});
									

								} else {
									Log.d("Error","Error Load Data from Mobile Service");
								}
							}
						});
						

					  refreshItemsFromTable(); // Reload New Data
					  
				  }});
				  adb.show();
				}
			});
			
			
			// Column id
			final TextView txt_id = (TextView) row.findViewById(R.id.col_id);
			txt_id.setText(String.valueOf(currentItem.getId()));
			
			// Column username
			final TextView txt_name = (TextView) row.findViewById(R.id.col_username);
			txt_name.setText(currentItem.getUsername());
			
			// Column name
			final TextView txt_email = (TextView) row.findViewById(R.id.col_name);
			txt_email.setText(currentItem.getName());
			
			return row;
		}
	}
    

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        getMenuInflater().inflate(R.menu.activity_main, menu);
        return true;
    }

}