Intersoft ClientUI Documentation
Walkthrough: Handle CUD Operation using UXGridView and WCF RIA
Intersoft ClientUI 8 > ClientUI Controls > Control Library > Data Controls Overview > UXGridView > UXGridView Walkthroughs > Walkthrough: Handle CUD Operation using UXGridView and WCF RIA

This walkthrough provides step-by-step instructions to handle CUD operation using UXGridView and WCF RIA Services using MVVM pattern. You will also implement simple binding using UXGridView without CUD operation. To learn more, see Walkthrough: Bind UXGridView to WCF RIA Services using MVVM Pattern.

In this walkthrough, you will perform the following tasks:

Prerequisites

You need the following components to complete this walkthrough:

Creating a new ClientUI MVVM Data Application (WCF RIA SP1) Project

The first step is to create a new ClientUI MVVM Data Application (WCF RIA SP1) project using Intersoft ClientUI MVVM Data Application (WCF RIA SP1) project template in Visual Studio.

To create the ClientUI MVVM Data Application (WCF RIA SP1) project

  1. Start Visual Studio 2010.
  2. Create a new ClientUI MVVM Data Application (WCF RIA SP1) project using Intersoft ClientUI MVVM Data Application (WCF RIA SP1) project template. To learn more, see Walkthrough: Create New Intersoft ClientUI MVVM Data Application (WCF RIA SP1) Template.

Creating Model Repository Class

This section shows how to create the CustomersRepository class that represents the customer data repository used in this walkthrough.

To Create the CustomersRepository Model Class

  1. Create a new data repository for Customers using Intersoft MVVM Data Repository (WCF RIA) item template under the ModelServcices folder. You can name it CustomersRepository.cs
  2. Notice that the class you just created is inherited from EditableDataRepository<T>, which is used to implement editable entity.
  3. Replace all the <T> placeholders with the target entity type such as Customer.
  4. Replace the type of the EntityContext property to the default domain context type such as NorthwindDomainContext.

Creating The View

This section steps you through the process of changing the existing customers pages by using a variety of ClientUI controls such as UXGridView and StylishLabel. The UXGridView is used to display a collection of customers data.

  1. Open the existing Customers.xaml page.
  2. Remove the default TextBlock inside Grid.
  3. Add UXGridView control to the Grid after StylishLabel control and set the following properties to the control.
    Property Value
    AutoGenerateColumns False
    QueryOperation Server
    CanUserAddRows True
    CanUserDeleteRows True
    CanUserEditRows True

    C#
    Copy Code 
    <Intersoft:DockPanel... >
    <Intersoft:StylishLabel... />
    <Grid... >
        <Intersoft:UXGridView />
    </Grid>
</Intersoft:DockPanel>

Creating the ViewModel

This section steps you through the process of creating a ViewModel class that contains the properties to describe the View that you created in the previous section. The ViewModel will inherit from the EditableGridViewModelBase class which already contains a set of common members that can be bound to UXGridView such as Items as well as the properties related to CUD operation.

To create the CustomersViewModel

  1. Add a new class to the ViewModels folder in your Silverlight project and name it CustomersViewModel.
  2. Open CustomersViewModel.cs and inherit it from the EditableGridViewModelBase class, then replace the placeholders with the target entity type. I.e.: <Customer>. The EditableGridViewModelBase class contains common members that can be bound to the UXGridView control.
    C#
    Copy Code 
    public class CustomersViewModel : EditableGridViewModelBase<Customer> {  }
  3. Override the DataSource property from the base class and change the getter for this property to CustomersRepository.Instance.
    C#
    Copy Code 
    public class CustomersViewModel : EditableGridViewModelBase<Customer> 
{  
        protected override IDataRepository DataSource
    {
        get
        {
            return CustomersRepository.Instance;
        }
    }
}
  4. Create anconstructor and call the LoadData method to get the customers data.
    C#
    Copy Code 
    public class CustomersViewModel : GridViewModelBase<Customer>
{
    public CustomersViewModel()
    {
        if (!IsInDesignMode)
                this.LoadData();
    }


    protected override IDataRepository DataSource
    {
        get
        {
            return CustomersRepository.Instance;
        }
    }
}

Binding the View to the ViewModel

In the previous sections, you have learned how to create the Model and ViewModel classes, as well as the View that contains the user interface and controls used in this walkthrough. This section shows how to instantiate the ViewModel in the XAML page and bind the UI elements to the properties in the ViewModel such as the data context and UXGridView ItemSource property. You will also learn how to bind properties in UXGridView control to handle the CUD operation.

To bind the Customers page to the CustomersViewModel class

  1. Declare the namespace that maps to the CustomersViewModel class in the Customers page.
    XAML
    Copy Code 
    <Intersoft:UXPage... 
    xmlns:ViewModels="clr-namespace:CUDGridViewUsingWCFRIASP1.ViewModels">
</Intersoft:UXPage>
  2. Instantiate a new instance of the CustomersViewModel class in the UXPage resources and name it CustomersViewModel.
    XAML
    Copy Code 
    <Intersoft:UXPage.Resources>
    <ViewModels:CustomersViewModel x:Key="CustomersViewModel" />
    ...
</Intersoft:UXPage.Resources>
<Grid x:Name="LayoutRoot" DataContext="{StaticResource CustomersViewModel}">
</Grid>
  3. Then bind the following properties in UXGridView control with property in ViewModel.
    Property Value
    IsRefreshed {Binding IsRefreshed, Mode=TwoWay}
    ItemsSource {Binding Path=Items}
    NewItem {Binding NewItem, Mode=TwoWay}
    ValidateRowCommand {Binding ValidateRowCommand}
    InsertRowCommand {Binding InsertRowCommand}
    DeleteRowCommand {Binding DeleteRowCommand}
    PrepareNewRowCommand {Binding PrepareNewRowCommand}
    UpdateCellCommand {Binding UpdateCellCommand}
    UpdateRowCommand {Binding UpdateRowCommand}
    SaveChangesCommand {Binding SaveChangesCommand}
    RejectRowCommand {Binding RejectRowCommand}
    RejectChangesCommand {Binding RejectChangesCommand}
    HasChanges {Binding HasChanges}
    AutoEditOperation {Binding AutoEditOperation}

    XAML
    Copy Code 
    <Intersoft:UXGridView
            AutoGenerateColumns="False" QueryOperation="Server" IsRefreshed="{Binding IsRefreshed, Mode=TwoWay}"
            CanUserAddRows="True" CanUserDeleteRows="True" CanUserEditRows="True" 
            ItemsSource="{Binding Path=Items}" NewItem="{Binding NewItem, Mode=TwoWay}"
            ValidateRowCommand="{Binding ValidateRowCommand}" InsertRowCommand="{Binding InsertRowCommand}"
            DeleteRowCommand="{Binding DeleteRowCommand}" PrepareNewRowCommand="{Binding PrepareNewRowCommand}"
            UpdateCellCommand="{Binding UpdateCellCommand}" UpdateRowCommand="{Binding UpdateRowCommand}"
            SaveChangesCommand="{Binding SaveChangesCommand}" RejectRowCommand="{Binding RejectRowCommand}"
            RejectChangesCommand="{Binding RejectChangesCommand}" HasChanges="{Binding HasChanges}"
            AutoEditOperation="{Binding AutoEditOperation}"
            >
</Intersoft:UXGridView>

  4. In the UXGridView columns, add UXGridViewTextColumn and set the Header property to the "Customer ID", IsReadOnly property to False and bind the Binding property to CustomerId.
    XAML
    Copy Code 
    <Intersoft:UXGridView...
    >
    <Intersoft:UXGridView.Columns>
        <Intersoft:UXGridViewTextColumn Header="Customer ID" Binding="{Binding CustomerID}" IsReadOnly="False" />
    </Intersoft:UXGridView.Columns>
</Intersoft:UXGridView>
     
  5. Repeat step 4 for ContactName, CompanyName, Address, City and Phone without IsReadOnly property.
    XAML
    Copy Code 
    <Intersoft:UXGridView...
    >
    <Intersoft:UXGridView.Columns>
        <Intersoft:UXGridViewTextColumn Header="Customer ID" Binding="{Binding CustomerID}" IsReadOnly="False" />
        <Intersoft:UXGridViewTextColumn Header="Name" Binding="{Binding ContactName}" />
        <Intersoft:UXGridViewTextColumn Header="Company Name" Binding="{Binding CompanyName}" />
        <Intersoft:UXGridViewTextColumn Header="Address" Binding="{Binding Address}" />
        <Intersoft:UXGridViewTextColumn Header="City" Binding="{Binding City}" />
        <Intersoft:UXGridViewTextColumn Header="Phone" Binding="{Binding Phone}" />
    </Intersoft:UXGridView.Columns>
</Intersoft:UXGridView>

    At this step, your design-time surface in Visual Studio should look like the following figure.
  6. Finally, save and run the project.

Conclusion

In this walkthrough, you have learned how to create ClientUI MVVM Data Application (WCF RIA SP1) project using project template, and create the classes and page based on the Model, View and ViewModel pattern and used it to handle CUD operation. You also learned how to bind UXGridView to a collection of data.

Complete Code Listing

This section lists the complete code used in this walkthrough.

CustomersRepository.cs

C#
Copy Code 
using System.ComponentModel.DataAnnotations;
using System.ServiceModel.DomainServices.Client;
using CUDGridViewUsingWCFRIASP1.Web;

namespace CUDGridViewUsingWCFRIASP1.ModelServices
{
    // TODO: Replace all the <T> placeholders with the target entity type. I.e.: <Product>

    /// <summary>
    /// Represents the CustomersRepository class.
    /// </summary>
    public class CustomersRepository : EditableDataRepository<Customer>
    {
        private static IDataRepository _repository;

        /// <summary>
        /// Initializes a new instance of <see cref="CustomersRepository"/> class.
        /// </summary>
        /// <param name="context">A <see cref="DomainContext"/> instance, providing access to all functionality of the data service.</param>
        public CustomersRepository(DomainContext context)
            : base(context)
        {
        }

        private static bool IsReusable
        {
            get { return true; }
        }

        // TODO: Replace DomainContext with the target DomainContext type.
        // I.e., NorthwindDomainContext
        private NorthwindDomainContext EntityContext
        {
            get
            {
                return ((NorthwindDomainContext)this.Context);
            }
        }

        /// <summary>
        /// Returns an instance of <see cref="CustomersRepository"/>. 
        /// If the <see cref="IsReusable"/> is true, the property will return an existing cached copy of the instance.
        /// </summary>
        public static IDataRepository Instance
        {
            get
            {
                if (_repository == null || !IsReusable)
                    _repository = new CustomersRepository(RepositoryManager.Create());

                return _repository;
            }
        }

        /// <summary>
        /// Gets the <see cref="EntitySet"/> that provides access to a collection of entities as the results of the entity query.
        /// </summary>
        public override EntitySet<Customer> EntitySet
        {
            get
            {
                // TODO: Replace Products with the actual EntitySet property.
                return this.EntityContext.Customers;
            }
        }

        /// <summary>
        /// Gets the <see cref="EntityQuery"/> that represents the entity's LINQ query.
        /// </summary>
        public override EntityQuery<Customer> EntityQuery
        {
            get
            {
                // TODO: Replace GetProductsQuery with the actual query method.
                return this.EntityContext.GetCustomersQuery();
            }
        }

        /// <summary>
        /// Validate the specified entity.
        /// </summary>
        /// <param name="entity">The entity to validate.</param>
        public override void Validate(Customer entity)
        {
            base.Validate(entity);

            entity.ValidationErrors.Clear();

            // TODO: Write validation code logic here
        }
    }
}

CustomersViewModel.cs

C#
Copy Code 
using System;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Ink;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using CUDGridViewUsingWCFRIASP1.Web;
using CUDGridViewUsingWCFRIASP1.ModelServices;

namespace CUDGridViewUsingWCFRIASP1.ViewModels
{
    public class CustomersViewModel : EditableGridViewModelBase<Customer>
    {
        public CustomersViewModel()
        {
            if (!IsInDesignMode)
            {
                this.IsBatchUpdate = true;
                this.LoadData();
            }
        }

        protected override IDataRepository DataSource
        {
            get
            {
                return CustomersRepository.Instance;
            }
        }
    }
}

Customers.xaml

XAML
Copy Code 
<Intersoft:UXPage 
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" 
        xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
        xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
        mc:Ignorable="d"
        xmlns:Intersoft="http://intersoft.clientui.com/schemas"
    xmlns:ViewModels="clr-namespace:CUDGridViewUsingWCFRIASP1.ViewModels"
        x:Class="CUDGridViewUsingWCFRIASP1.Views.Customers" 
        Title="Customers Page"
        d:DesignWidth="800" d:DesignHeight="600"
    Style="{StaticResource CommonPageStyle}">
    <Intersoft:UXPage.Resources>
        <ViewModels:CustomersViewModel x:Key="CustomersViewModel"/>
    </Intersoft:UXPage.Resources>
    <Grid x:Name="LayoutRoot" DataContext="{StaticResource CustomersViewModel}">
                <Grid.Background>
                        <ImageBrush AlignmentY="Bottom" AlignmentX="Right" Stretch="None" Opacity="0.5" ImageSource="../Assets/Images/CustomersFolderLarge.png">
                                <ImageBrush.Transform>
                                        <TranslateTransform X="40" Y="40"/>
                                </ImageBrush.Transform>
                        </ImageBrush>
                </Grid.Background>
        <Intersoft:DockPanel Margin="10" FillChildMode="Custom">
            <Intersoft:StylishLabel Content="Customers Page" Intersoft:DockPanel.Dock="Top" Style="{StaticResource PageHeaderStyle}"/>
            <Grid Intersoft:DockPanel.IsFillElement="True">
                <Intersoft:UXGridView
                    AutoGenerateColumns="False" QueryOperation="Server" IsRefreshed="{Binding IsRefreshed, Mode=TwoWay}"
                    CanUserAddRows="True" CanUserDeleteRows="True" CanUserEditRows="True" 
                    ItemsSource="{Binding Path=Items}" NewItem="{Binding NewItem, Mode=TwoWay}"
                    ValidateRowCommand="{Binding ValidateRowCommand}" InsertRowCommand="{Binding InsertRowCommand}"
                    DeleteRowCommand="{Binding DeleteRowCommand}" PrepareNewRowCommand="{Binding PrepareNewRowCommand}"
                    UpdateCellCommand="{Binding UpdateCellCommand}" UpdateRowCommand="{Binding UpdateRowCommand}"
                    SaveChangesCommand="{Binding SaveChangesCommand}" RejectRowCommand="{Binding RejectRowCommand}"
                    RejectChangesCommand="{Binding RejectChangesCommand}" HasChanges="{Binding HasChanges}"
                    AutoEditOperation="{Binding AutoEditOperation}"
                    >
                    <Intersoft:UXGridView.Columns>
                        <Intersoft:UXGridViewTextColumn Header="Customer ID" Binding="{Binding CustomerID}" IsReadOnly="False" />
                        <Intersoft:UXGridViewTextColumn Header="Name" Binding="{Binding ContactName}" />
                        <Intersoft:UXGridViewTextColumn Header="Company Name" Binding="{Binding CompanyName}" />
                        <Intersoft:UXGridViewTextColumn Header="Address" Binding="{Binding Address}" />
                        <Intersoft:UXGridViewTextColumn Header="City" Binding="{Binding City}" />
                        <Intersoft:UXGridViewTextColumn Header="Phone" Binding="{Binding Phone}" />
                    </Intersoft:UXGridView.Columns>
                </Intersoft:UXGridView>
            </Grid>
        </Intersoft:DockPanel>
    </Grid>
</Intersoft:UXPage>
See Also
UXGridView Class
QueryDescriptor Class

Concepts

UXGridView
QueryDescriptor Overview
Editing Data with UXGridView
Customizing Edit Controls in UXGridView
Data Access Overview
MVVM Pattern Overview

Other Resources

Walkthroughs and How-to Topics
Locating the Samples in Local Installation