SilverlightShow: Working with collections in WCF RIA Services (part 2) Comments

Re: Working with collections in WCF RIA Services (part 2)

lou8566 — Thu, 20 Sep 2012 10:20:18 GMT

I got it working by referencing

http://blogs.msdn.com/b/kylemc/archive/2010/12/02/introducing-an-mvvm-friendly-domaindatasource-the-domaincollectionview.aspx

Thank you! :)

Re: Working with collections in WCF RIA Services (part 2)

lou8566 — Thu, 20 Sep 2012 09:24:10 GMT

Hi Kevin.

I am having trouble following these steps, I have attempted to modify my code, so that I can have paging in my datagrid, however it doesn't work.

Is it possible to put a link to your source code so I can figure out what I have done wrong?

Here is my ViewModel

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 System.ComponentModel;

using Silverlight.NRMFA.DataLibrary;

using System.Collections;

using System.Windows.Data;

using Silverlight.NRMFA.Application.Commanding;

using Microsoft.Windows.Data.DomainServices;

using System.ServiceModel.DomainServices.Client;

namespace Silverlight.NRMFA.Application.ViewModels

{

public class DivisionViewModel : ViewModelBase

{

private DomainCollectionView<Division> _view;

public DomainCollectionView<Division> View

{

get

{

return _view;

}

set

{

if (_view != value)

{

_view = value;

OnPropertyChanged("View");

}

private NRMFADomainContext _Context;

public NRMFADomainContext Context

{

get

{

return _Context;

}

set

{

if (_Context != value)

{

_Context = value;

OnPropertyChanged("Context");

}

private DomainCollectionView<Division> _Divisions;

private Division _CurrentDivision;

public Division CurrentDivision

{

get

{

return _CurrentDivision;

}

set

{

if (_CurrentDivision != value)

{

_CurrentDivision = value;

OnPropertyChanged("CurrentDivision");

}

public DomainCollectionView<Division> Divisions

{

get

{

return this.View;

}

set

{

if (_Divisions != value)

{

_Divisions = value;

OnPropertyChanged("Divisions");

}

private EntityList<Division> _source;

public EntityList<Division> Source

{

get

{

return _source;

}

set

{

if (_source != value)

{

_source = value;

OnPropertyChanged("Source");

}

private DomainCollectionViewLoader<Division> _loader;

public DomainCollectionViewLoader<Division> Loader

{

get

{

return _loader;

}

set

{

if (_loader != value)

{

_loader = value;

OnPropertyChanged("Loader");

}

private LoadOperation<Division> OnLoadDivisions()

{

return this.Context.Load(this.Context.GetDivisionsQuery().SortAndPageBy(this.View));

}

private void OnLoadDivisionsCompleted(LoadOperation<Division> op)

{

if (op.HasError)

{

op.MarkErrorAsHandled();

}

else if (!op.IsCanceled)

{

this.Source = new EntityList<Division>(Context.Divisions);

this.Source.Source = op.Entities;

if (op.TotalEntityCount != -1)

{

this.Divisions.SetTotalItemCount(op.TotalEntityCount);

}

public DivisionViewModel()

{

if (!IsDesignTime)

{

InstantiateCommands();

// Load Divisions

Context.Load<Division>(Context.GetDivisionsQuery());

WireCommands();

using (this.View.DeferRefresh())

{

this.View.PageSize = 5;

this.View.MoveToFirstPage();

}

private void InstantiateCommands()

{

Context = new NRMFADomainContext();

this._loader = new DomainCollectionViewLoader<Division>(this.OnLoadDivisions, this.OnLoadDivisionsCompleted);

this._source = new EntityList<Division>(Context.Divisions);

this.View = new DomainCollectionView<Division>(Loader, Source);

}

private ICollectionView CreateView(IEnumerable source)

{

CollectionViewSource cvs = new CollectionViewSource();

cvs.Source = source;

return cvs.View;

}

public RelayCommand SaveCommand

{

get;

private set;

}

public RelayCommand CancelCommand

{

get;

private set;

}

private void WireCommands()

{

SaveCommand = new RelayCommand(Save);

CancelCommand = new RelayCommand(Cancel);

SaveCommand.IsEnabled = true;

CancelCommand.IsEnabled = true;

}

private void Save()

{

if (Context.HasChanges)

{

if (!Context.IsSubmitting)

{

Context.SubmitChanges(so =>

{

if (so.HasError)

{

MessageBox.Show(String.Format("{0}{1}{2}",

"There was an error saving one or more changes.",

Environment.NewLine,

"Please check the errors. " + so.Error.Message + " / " + so.Error.StackTrace));

so.MarkErrorAsHandled();

}

}, null);

}

private void Cancel()

{

if (Context.HasChanges)

{

if (!Context.IsSubmitting)

{

Context.RejectChanges();

}

and my xaml is as follows:

<navigation:Page xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk" x:Class="Silverlight.NRMFA.Application.Views.DivisionView"

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:navigation="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Navigation"

xmlns:vm="clr-namespace:Silverlight.NRMFA.Application.ViewModels"

xmlns:df="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Data.DataForm.Toolkit"

xmlns:i="clr-namespace:System.Windows.Interactivity;assembly=System.Windows.Interactivity"

xmlns:cmd="clr-namespace:GalaSoft.MvvmLight.Command;assembly=GalaSoft.MvvmLight.Extras.SL5"

d:DesignWidth="640" d:DesignHeight="480"

Title="DivisionView Page">

<UserControl.Resources>

<vm:DivisionViewModel x:Key="ViewModel" />

UserControl.Resources>


    <Grid x:Name="LayoutRoot" DataContext="{Binding Source={StaticResource ViewModel}}">
        <StackPanel Orientation="Horizontal" Margin="25">
            <sdk:DataGrid ItemsSource="{Binding Path=Divisions}" Width="300" Height="300" VerticalAlignment="Top" SelectedItem="{Binding Path=CurrentDivision, Mode=TwoWay}" AutoGenerateColumns="False">
                <sdk:DataGrid.Columns>
                    <sdk:DataGridTextColumn Header="ID" Binding="{Binding Path=DivisionID}" />
                    <sdk:DataGridTextColumn Header="Division" Binding="{Binding Path=DivisionName}" />
                    <sdk:DataGridTextColumn Header="Year" Binding="{Binding Path=YearID}" />
                sdk:DataGrid.Columns>

            sdk:DataGrid>

            <StackPanel Orientation="Vertical">
                <df:DataForm AutoGenerateFields="False"
                         Width="400"
                         Height="300"
                         Margin="10,0,0,0"
                         VerticalAlignment="Top"
                         Header="Player" AutoCommit="True"
                         AutoEdit="False"
                         CommandButtonsVisibility="All"
                         ItemsSource="{Binding Path=Divisions}"
                         CurrentItem="{Binding Path=CurrentDivision, Mode=TwoWay}">
                    <df:DataForm.EditTemplate>
                        <DataTemplate>
                            <StackPanel Orientation="Vertical">
                                <df:DataField Label="Division">
                                    <TextBox Text="{Binding DivisionName, Mode=TwoWay}" />
                                df:DataField>

                                <df:DataField Label="Year">
                                    <TextBox Text="{Binding YearID, Mode=TwoWay}" />
                                df:DataField>

                            StackPanel>

                        DataTemplate>

                    df:DataForm.EditTemplate>

 
                df:DataForm>

                <StackPanel Orientation="Horizontal" HorizontalAlignment="Right" Margin="0,0,30,0">
                    <Button Content="Save" Command="{Binding SaveCommand}" Margin="5"/>
                    <Button Content="Cancel" Command="{Binding CancelCommand}" Margin="5" />
                StackPanel>

            StackPanel>

 
 
        StackPanel>

    Grid>

navigation:Page>


Thank you in advance.
Lou



Re: Working with collections in WCF RIA Services (part 2)
lou8566 — Thu, 20 Sep 2012 08:57:51 GMT
Hi Kevin.
I am having trouble following these steps, I have attempted to modify my code, so that I can have paging in my datagrid, however it doesn't work.
Is it possible to put a link to your source code so I can figure out what I have done wrong?
Here is my ViewModel

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 System.ComponentModel;
using Silverlight.NRMFA.DataLibrary;
using System.Collections;
using System.Windows.Data;
using Silverlight.NRMFA.Application.Commanding;
using Microsoft.Windows.Data.DomainServices;
using System.ServiceModel.DomainServices.Client;
 
namespace Silverlight.NRMFA.Application.ViewModels
{
    public class DivisionViewModel : ViewModelBase
    {
 
         
        private DomainCollectionView<Division> _view;
 
        public DomainCollectionView<Division> View
        {
            get
            {
                return _view;
            }
 
            set
            {
                if (_view != value)
                {
                    _view = value;
                    OnPropertyChanged("View");
                }
            }
        }
        private NRMFADomainContext _Context;
 
        public NRMFADomainContext Context
        {
            get
            {
                return _Context;
            }
 
            set
            {
                if (_Context != value)
                {
                    _Context = value;
                    OnPropertyChanged("Context");
                }
            }
        }
        private DomainCollectionView<Division> _Divisions;
         
        private Division _CurrentDivision;
 
        public Division CurrentDivision
        {
            get
            {
                return _CurrentDivision;
            }
 
            set
            {
                if (_CurrentDivision != value)
                {
                    _CurrentDivision = value;
                    OnPropertyChanged("CurrentDivision");
                }
            }
        }
        public DomainCollectionView<Division> Divisions
        {
            get
            {
                return this.View;
            }
 
            set
            {
                if (_Divisions != value)
                {
                    _Divisions = value;
                    OnPropertyChanged("Divisions");
                }
            }
        }
 
         
        private EntityList<Division> _source;
 
        public EntityList<Division> Source
        {
            get
            {
                return _source;
            }
 
            set
            {
                if (_source != value)
                {
                    _source = value;
                    OnPropertyChanged("Source");
                }
            }
        }
         
        private DomainCollectionViewLoader<Division> _loader;
 
        public DomainCollectionViewLoader<Division> Loader
        {
            get
            {
                return _loader;
            }
 
            set
            {
                if (_loader != value)
                {
                    _loader = value;
                    OnPropertyChanged("Loader");
                }
            }
        }
 
        private LoadOperation<Division> OnLoadDivisions()
        {
            return this.Context.Load(this.Context.GetDivisionsQuery().SortAndPageBy(this.View));
        }
 
        private void OnLoadDivisionsCompleted(LoadOperation<Division> op)
        {
            if (op.HasError)
            {
                op.MarkErrorAsHandled();
            }
            else if (!op.IsCanceled)
            {
                this.Source = new EntityList<Division>(Context.Divisions);
                this.Source.Source = op.Entities;
                if (op.TotalEntityCount != -1)
                {
                    this.Divisions.SetTotalItemCount(op.TotalEntityCount);
                }
            }
        }
 
        public DivisionViewModel()
        {
             
            if (!IsDesignTime)
            {
                InstantiateCommands();
                 
                // Load Divisions
                Context.Load<Division>(Context.GetDivisionsQuery());
                WireCommands();
 
                using (this.View.DeferRefresh())
                {
                    this.View.PageSize = 5;
                    this.View.MoveToFirstPage();
                }
            }
        }
 
        private void InstantiateCommands()
        {
            Context = new NRMFADomainContext();
            this._loader = new DomainCollectionViewLoader<Division>(this.OnLoadDivisions, this.OnLoadDivisionsCompleted);
            this._source = new EntityList<Division>(Context.Divisions);
            this.View = new DomainCollectionView<Division>(Loader, Source);
        }
 
        private ICollectionView CreateView(IEnumerable source)
        {
            CollectionViewSource cvs = new CollectionViewSource();
            cvs.Source = source;
            return cvs.View;
        }
 
         
 
        public RelayCommand SaveCommand
        {
            get;
            private set;
        }
 
        public RelayCommand CancelCommand
        {
            get;
            private set;
        }
 
        private void WireCommands()
        {
            SaveCommand = new RelayCommand(Save);
            CancelCommand = new RelayCommand(Cancel);
 
            SaveCommand.IsEnabled = true;
            CancelCommand.IsEnabled = true;
        }
 
         
 
        private void Save()
        {
             if (Context.HasChanges)
            {
                if (!Context.IsSubmitting)
                {
                    Context.SubmitChanges(so =>
                    {
                        if (so.HasError)
                        {
                            MessageBox.Show(String.Format("{0}{1}{2}",
                                "There was an error saving one or more changes.",
                                Environment.NewLine,
                                "Please check the errors. " + so.Error.Message + " / " + so.Error.StackTrace));
                            so.MarkErrorAsHandled();
                        }
                    }, null);
                }
            }
        }
 
        private void Cancel()
        {
            if (Context.HasChanges)
            {
                if (!Context.IsSubmitting)
                {
                    Context.RejectChanges();
                }
            }
        }
    }
}



and my xaml is as follows:

<navigation:Page xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk"  x:Class="Silverlight.NRMFA.Application.Views.DivisionView"
           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:navigation="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Navigation"
           xmlns:vm="clr-namespace:Silverlight.NRMFA.Application.ViewModels"
           xmlns:df="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Data.DataForm.Toolkit"
           xmlns:i="clr-namespace:System.Windows.Interactivity;assembly=System.Windows.Interactivity"
           xmlns:cmd="clr-namespace:GalaSoft.MvvmLight.Command;assembly=GalaSoft.MvvmLight.Extras.SL5"
           d:DesignWidth="640" d:DesignHeight="480"
           Title="DivisionView Page">
    <UserControl.Resources>
        <vm:DivisionViewModel x:Key="ViewModel" />
    UserControl.Resources>

    <Grid x:Name="LayoutRoot" DataContext="{Binding Source={StaticResource ViewModel}}">
        <StackPanel Orientation="Horizontal" Margin="25">
            <sdk:DataGrid ItemsSource="{Binding Path=Divisions}" Width="300" Height="300" VerticalAlignment="Top" SelectedItem="{Binding Path=CurrentDivision, Mode=TwoWay}" AutoGenerateColumns="False">
                <sdk:DataGrid.Columns>
                    <sdk:DataGridTextColumn Header="ID" Binding="{Binding Path=DivisionID}" />
                    <sdk:DataGridTextColumn Header="Division" Binding="{Binding Path=DivisionName}" />
                    <sdk:DataGridTextColumn Header="Year" Binding="{Binding Path=YearID}" />
                sdk:DataGrid.Columns>

            sdk:DataGrid>

            <StackPanel Orientation="Vertical">
                <df:DataForm AutoGenerateFields="False"
                         Width="400"
                         Height="300"
                         Margin="10,0,0,0"
                         VerticalAlignment="Top"
                         Header="Player" AutoCommit="True"
                         AutoEdit="False"
                         CommandButtonsVisibility="All"
                         ItemsSource="{Binding Path=Divisions}"
                         CurrentItem="{Binding Path=CurrentDivision, Mode=TwoWay}">
                    <df:DataForm.EditTemplate>
                        <DataTemplate>
                            <StackPanel Orientation="Vertical">
                                <df:DataField Label="Division">
                                    <TextBox Text="{Binding DivisionName, Mode=TwoWay}" />
                                df:DataField>

                                <df:DataField Label="Year">
                                    <TextBox Text="{Binding YearID, Mode=TwoWay}" />
                                df:DataField>

                            StackPanel>

                        DataTemplate>

                    df:DataForm.EditTemplate>

 
                df:DataForm>

                <StackPanel Orientation="Horizontal" HorizontalAlignment="Right" Margin="0,0,30,0">
                    <Button Content="Save" Command="{Binding SaveCommand}" Margin="5"/>
                    <Button Content="Cancel" Command="{Binding CancelCommand}" Margin="5" />
                StackPanel>

            StackPanel>

 
 
        StackPanel>

    Grid>

navigation:Page>


Thank you in advance.
Lou