ตอนที่ 14 : Show Case 2 : Login User Password (WP and Mobile Services)

using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Navigation;
using Microsoft.Phone.Controls;
using Microsoft.Phone.Shell;
using myPhoneApp.Resources;

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

namespace myPhoneApp
{

    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 = "tel")]
        public string Tel { get; set; }

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

    }

    public partial class MainPage : PhoneApplicationPage
    {

        private MobileServiceCollection<MyMember, MyMember> items;
        private IMobileServiceTable<MyMember> memberTable = App.MobileService.GetTable<MyMember>();

        // Constructor
        public MainPage()
        {
            InitializeComponent();
        }

        private async void btnLogin_Click(object sender, RoutedEventArgs e)
        {
            try
            {

                items = await memberTable
                .Where(memberItem => memberItem.Username == txtUsername.Text
                && memberItem.Password == txtPassword.Password)
                .ToCollectionAsync();

                if (items.Count > 0)
                {
                    MyMember member = items[0];
                    NavigationService.Navigate(new Uri("/PageInfo.xaml?sid=" + member.Id.ToString(), UriKind.Relative));
                }
                else
                {
                    MessageBox.Show("Incorrect Username and Password!");
                }
            }
            catch (MobileServiceInvalidOperationException ex)
            {
                MessageBox.Show("Error : " + ex.Message);
            }
        }
    }

}

<phone:PhoneApplicationPage
    x:Class="myPhoneApp.PageInfo"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:phone="clr-namespace:Microsoft.Phone.Controls;assembly=Microsoft.Phone"
    xmlns:shell="clr-namespace:Microsoft.Phone.Shell;assembly=Microsoft.Phone"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    FontFamily="{StaticResource PhoneFontFamilyNormal}"
    FontSize="{StaticResource PhoneFontSizeNormal}"
    Foreground="{StaticResource PhoneForegroundBrush}"
    SupportedOrientations="Portrait" Orientation="Portrait"
    mc:Ignorable="d"
    shell:SystemTray.IsVisible="True">


    <!--LayoutRoot is the root grid where all page content is placed-->
    <Grid x:Name="LayoutRoot" Background="Transparent">
        <Grid.RowDefinitions>
            <RowDefinition Height="Auto"/>
            <RowDefinition Height="*"/>
        </Grid.RowDefinitions>

        <!--TitlePanel contains the name of the application and page title-->
        <StackPanel x:Name="TitlePanel" Grid.Row="0" Margin="12,17,0,28">
            <TextBlock Text="MY APPLICATION" Style="{StaticResource PhoneTextNormalStyle}" Margin="12,0"/>
            <TextBlock Text="ThaiCrate.Com" Margin="9,-7,0,0" Style="{StaticResource PhoneTextTitle1Style}" FontSize="45"/>
        </StackPanel>

        <!--ContentPanel - place additional content here-->
        <Grid x:Name="ContentPanel" Grid.Row="1" Margin="12,0,12,0">
            <TextBlock HorizontalAlignment="Left" Margin="10,8,0,0" TextWrapping="Wrap" Text="User Info" VerticalAlignment="Top" FontSize="36"/>

            <TextBlock HorizontalAlignment="Left" Margin="10,71,0,0" TextWrapping="Wrap" Text="Username :" VerticalAlignment="Top"/>
            <TextBlock x:Name="txtUsername" Text="Username" HorizontalAlignment="Left" Margin="136,74,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="234"/>

            <TextBlock HorizontalAlignment="Left" Margin="10,142,0,0" TextWrapping="Wrap" Text="Password :" VerticalAlignment="Top"/>
            <TextBlock x:Name="txtPassword" Text="Password" HorizontalAlignment="Left" Margin="138,144,0,0" VerticalAlignment="Top" Width="194"/>

            <TextBlock HorizontalAlignment="Left" Margin="10,210,0,0" TextWrapping="Wrap" Text="Name :" VerticalAlignment="Top"/>
            <TextBlock x:Name="txtName" Text="Name" HorizontalAlignment="Left" Margin="140,211,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="284"/>

            <TextBlock HorizontalAlignment="Left" Margin="10,280,0,0" TextWrapping="Wrap" Text="Email :" VerticalAlignment="Top"/>
            <TextBlock x:Name="txtEmail" Text="Email" HorizontalAlignment="Left" Margin="142,283,-12,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="326"/>

            <TextBlock HorizontalAlignment="Left" Margin="10,355,0,0" TextWrapping="Wrap" Text="Tel :" VerticalAlignment="Top"/>
            <TextBlock x:Name="txtTel"  Text="Tel" HorizontalAlignment="Left"  Margin="146,354,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="234"/>
        </Grid>

    </Grid>

</phone:PhoneApplicationPage>