ตอนที่ 8 : Show Case 4 : Delete Data (Android C# (Xamarin) and Mobile Services)

using System;
using Android.App;
using Android.Content;
using Android.Runtime;
using Android.Views;
using Android.Widget;
using Android.OS;

using Microsoft.WindowsAzure.MobileServices;
using Newtonsoft.Json;

namespace myFirstApps
{
    public class MyMember
    {
        public int Id { get; set; }

        [JsonProperty(PropertyName = "username")]
        public string Username { get; set; }

        [JsonProperty(PropertyName = "password")]
        public string Password { get; set; }

        [JsonProperty(PropertyName = "name")]
        public string Name { get; set; }

        [JsonProperty(PropertyName = "email")]
        public string Email { get; set; }

        [JsonProperty(PropertyName = "tel")]
        public string Tel { get; set; }
    }

    [Activity(Label = "myFirstApps", MainLauncher = true, Icon = "@drawable/icon")]
    public class MainActivity : Activity
    {

        public const string ApplicationURL = @"https://thaicreate.azure-mobile.net/";
        public const string ApplicationKey = @"wXYfvYuGLIaDCZdqHjTwDgeDSHZOtL94";

        private MobileServiceClient client; // Mobile Service Client references
        private IMobileServiceTable<MyMember> memberTable; // Mobile Service Table used to access data   

        protected override void OnCreate(Bundle bundle)
        {
            base.OnCreate(bundle);

            // Set our view from the "main" layout resource
            SetContentView(Resource.Layout.Main);

            // Delete
            Button btnDelete = FindViewById<Button>(Resource.Id.btnDelete);
            btnDelete.Click += (object sender, EventArgs e) =>
            {
                btnDeleteClick(sender, e);
            };

        }

        private async void btnDeleteClick(object sender, EventArgs e)
        {

            client = new MobileServiceClient(ApplicationURL, ApplicationKey);
            TextView txtUsername = FindViewById<TextView>(Resource.Id.txtUsername);

            memberTable = client.GetTable<MyMember>();

            //*** Get Data for Delete ***//
            var items = await memberTable.Where(item => item.Username == txtUsername.Text).ToCollectionAsync();

            AlertDialog.Builder builder = new AlertDialog.Builder(this);
            AlertDialog confirm = builder.Create();
            confirm.SetTitle("Confirm Data");
            confirm.SetMessage("Are you sure delete?");
            confirm.SetButton("OK", (s, ev) =>
            {
                MyMember delete = items[0];
                memberTable.DeleteAsync(delete);

                Toast.MakeText(this, "Delete Data Successfully", ToastLength.Short).Show();
            });
            confirm.SetButton2("Cancel", (s, ev) =>
            {
  
            });
            confirm.Show();

        }

    }
}