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

memberTable = client.GetTable<MyMember>();

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

MyMember delete = items[0];
memberTable.DeleteAsync(delete);

using System;
using System.Drawing;
using System.Collections.Generic;

using MonoTouch.Foundation;
using MonoTouch.UIKit;

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

namespace iOSApp
{

    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; }
    }

    public partial class RootViewController : UIViewController
    {

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

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

        public RootViewController(IntPtr handle)
            : base(handle)
        {
        }

        public override void DidReceiveMemoryWarning()
        {
            // Releases the view if it doesn't have a superview.
            base.DidReceiveMemoryWarning();

            // Release any cached data, images, etc that aren't in use.
        }

        public override void ViewDidLoad()
        {
            base.ViewDidLoad();
        }

        partial void btnDelete_TouchUpInside(UIButton sender)
        {
            var alert = new UIAlertView("Confirm Data", "Are you sure delete?", null, "OK", new string[] { "Cancel" });
            alert.Clicked += (s, b) =>
            {

                client = new MobileServiceClient(ApplicationURL, ApplicationKey);
                memberTable = client.GetTable<MyMember>();

                // Confirm OK
                if (b.ButtonIndex == 0)
                {
                    //*** Get Data for Delete ***//
                    var items = memberTable.Where(item => item.Username == txtUsername.Text).ToCollectionAsync();
                    memberTable.DeleteAsync(items);

                    new UIAlertView("Result", "Delete Data Successfully", null, "OK", null).Show();
                }
            };
            alert.Show();
        }


    }
}