using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;

namespace WCFCRMProxyRole
{
  [ServiceContract]
  public interface ICRMProxyService
  {
    [OperationContract]
    List<AzureAccount> GetAccounts();
  }

  // Note that the CRM datatypes defined in myorganizationcrmsdktypes.cs are not
  // compatible with Silverlight client
  [DataContract]
  public class AzureOpportunity
  {
    private string _Name;
    [DataMember]
    public string Name
    {
      get { return _Name; }
      set { _Name = value; }
    }

    private decimal _EstimatedRevenue;
    [DataMember]
    public decimal EstimatedRevenue
    {
      get { return _EstimatedRevenue; }
      set { _EstimatedRevenue = value; }
    }
  }

  [DataContract]
  public class AzureAccount
  {
    [DataMember]
    public List<AzureOpportunity> Opportunities;

    private string _AccountID;
    [DataMember]
    public string AccountID
    {
      get { return _AccountID; }
      set { _AccountID = value; }
    }

    private string _AccountName;
    [DataMember]
    public string AccountName
    {
      get { return _AccountName; }
      set { _AccountName = value; }
    }

    private string _MainPhone;
    [DataMember]
    public string MainPhone
    {
      get { return _MainPhone; }
      set { _MainPhone = value; }
    }

    private string _Email;
    [DataMember]
    public string Email
    {
      get { return _Email; }
      set { _Email = value; }
    }

    private string _City;
    [DataMember]
    public string City
    {
      get { return _City; }
      set { _City = value; }
    }

    private string _State;
    [DataMember]
    public string State
    {
      get { return _State; }
      set { _State = value; }
    }
  }
}

<appSettings>
  <add key="OrganizationUri"
  value="https://yourcrm.api.crm.dynamics.com/XRMServices/2011/Organization.svc"/>
  <add key="WLIDUsername" value="[email protected]"/>
  <add key="WLIDPassword" value="yourpassword"/>
</appSettings>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;
using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Client;
using System.ServiceModel.Description;
using System.Configuration;

namespace WCFCRMProxyRole
{
  public class CRMProxyService : ICRMProxyService
  {
    public Uri OrganizationUri;
    public Uri HomeRealmUri = null;
    public ClientCredentials Credentials = null;
    public ClientCredentials DeviceCredentials = null;

    private OrganizationServiceProxy _serviceProxy;
    private IOrganizationService _service;

    public List<AzureAccount> GetAccounts()
    {
    }
  }
}

...
// Retrieve the CRMOnline Organization from the web.config settings
OrganizationUri = new Uri(ConfigurationManager.AppSettings["OrganizationUri"]);
ClientCredentials Credentials = new ClientCredentials(); ;
Credentials.UserName.UserName = ConfigurationManager.AppSettings["WLIDUsername"];
Credentials.UserName.Password = ConfigurationManager.AppSettings["WLIDPassword"];
DeviceCredentials = Microsoft.Crm.Services.Utility.DeviceIdManager.
                                                        LoadOrRegisterDevice();

// Connect to the Organization service.
// The using statement assures that the service proxy will be properly disposed.
using (_serviceProxy = new OrganizationServiceProxy(OrganizationUri,
                                                    HomeRealmUri,
                                                    Credentials,
                                                    DeviceCredentials))
{
  // This statement is required to enable early-bound type support.
  _serviceProxy.EnableProxyTypes();

  _service = (IOrganizationService)_serviceProxy;
  OrganizationServiceContext orgContext = new
      OrganizationServiceContext(_service);

  List<AzureAccount> azureAccounts = new List<AzureAccount>();
  // Get the list of Accounts from CRMOnline
  azureAccounts = (from a in orgContext.CreateQuery<Account>()
                    select new AzureAccount
                    {
                      AccountID = a.Id.ToString(),
                      AccountName = a.Name,
                      City = a.Address1_City,
                      Email = a.EMailAddress1,
                      MainPhone = a.Telephone1,
                      State = a.Address1_StateOrProvince,
                      Opportunities = new List<AzureOpportunity>()
                    }).ToList();

  List<AzureOpportunity> azureOpps = new List<AzureOpportunity>();
  // Get the list of corresponding opportunities from CRMOnline
  var allCRMOpps = (from accountId in
                      (from a in azureAccounts
                        select Guid.Parse(a.AccountID))
                    join o in orgContext.CreateQuery<Opportunity>()
                    on accountId equals o.CustomerId.Id
                    where o.StateCode.Value == OpportunityState.Open
                    select new Opportunity
                    {
                      CustomerId = o.CustomerId,
                      Name = o.Name,
                      EstimatedValue = o.EstimatedValue
                    });

  // Associate the opportunities to account objects
  foreach (Opportunity opp in allCRMOpps)
  {
    AzureAccount currentAccount = azureAccounts.FirstOrDefault(acc =>
        acc.AccountID.Equals(opp.CustomerId.Id.ToString()));
    currentAccount.Opportunities.Add(new AzureOpportunity()
    {
      Name = opp.Name,
      EstimatedRevenue = opp.EstimatedValue.Value
    });
  }
  return azureAccounts;
}
...

<?xml version="1.0" encoding="utf-8"?>
<access-policy>
  <cross-domain-access>
    <policy>
      <allow-from http-request-headers="SOAPAction">
        <domain uri="*"/>
      </allow-from>
      <grant-to>
        <resource path="/" include-subpaths="true"/>
      </grant-to>
    </policy>
  </cross-domain-access>
</access-policy>

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 System.Collections;
using System.Collections.Generic;

namespace CRMSLParts
{
  public class Account : INotifyPropertyChanged
  {
    public List<Opportunity> AccOpps;
    private bool _IsDirty = false;
    public bool IsDirty
    {
      get { return _IsDirty; }
      set { _IsDirty = value; }
    }

    private string _AccountID;
    public string AccountID
    {
      get { return _AccountID; }
      set { _AccountID = value; NotifyPropertyChanged("AccountID"); }
    }

    private string _AccountName;
    public string AccountName
    {
      get { return _AccountName; }
      set { _AccountName = value; NotifyPropertyChanged("AccountName"); }
    }

    private string _MainPhone;
    public string MainPhone
    {
      get { return _MainPhone; }
      set { _MainPhone = value; NotifyPropertyChanged("MainPhone"); }
    }

    private string _Email;
    public string Email
    {
      get { return _Email; }
      set { _Email = value; NotifyPropertyChanged("Email"); }
    }

    private string _City;
    public string City
    {
      get { return _City; }
      set { _City = value; NotifyPropertyChanged("City"); }
    }

    private string _State;
    public string State
    {
      get { return _State; }
      set { _State = value; NotifyPropertyChanged("State"); }
    }

    protected void NotifyPropertyChanged(string PropertyName)
    {
      if (null != PropertyChanged)
      {
        PropertyChanged(this, new PropertyChangedEventArgs(PropertyName));
        this.IsDirty = true;
      }
    }

    public event PropertyChangedEventHandler PropertyChanged;
  }
}

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;

namespace CRMSLParts
{
  public class Opportunity
  {
    private string _OpportunityID;
    public string OpportunityID
    {
      get { return _OpportunityID; }
      set { _OpportunityID = value; }
    }

    private string _Name;
    public string Name
    {
      get { return _Name; }
      set { _Name = value; }
    }

    private decimal _EstimatedRevenue;
    public decimal EstimatedRevenue
    {
      get { return _EstimatedRevenue; }
      set { _EstimatedRevenue = value; }
    }

  }
}

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.Collections.ObjectModel;
using System.Collections.Generic;

using CRMSLParts.CRMProxy;
using System.ServiceModel;
using System.ServiceModel.Channels;
using System.Collections;

namespace CRMSLParts
{
  public class AccountManager
  {
    public ObservableCollection<Account> Accounts { get; set; }
    public ObservableCollection<Opportunity> Opportunities { get; set; }

    public AccountManager()
    {
      Accounts = new ObservableCollection<Account>();
      Opportunities = new ObservableCollection<Opportunity>();
      FillData();
    }

    private void FillData()
    {
      CRMProxyServiceClient service = new CRMProxyServiceClient();
      service.GetAccountsCompleted += new
          EventHandler<GetAccountsCompletedEventArgs>
          (service_GetAccountsCompleted);
      service.GetAccountsAsync();

    }

    void service_GetAccountsCompleted(object sender,
                                        GetAccountsCompletedEventArgs e)
    {
      IEnumerable<AzureAccount> crmAccounts =
          (IEnumerable<AzureAccount>)e.Result;

      foreach (AzureAccount account in crmAccounts)
      {

        Account currentAccount = new Account()
            {
              AccountID = account.AccountID,
              AccountName = account.AccountName,
              City = account.City,
              Email = account.Email,
              MainPhone = account.MainPhone,
              State = account.State,
              AccOpps = new List<Opportunity>(),
            };
        foreach (AzureOpportunity opp in account.Opportunities)
        {
          currentAccount.AccOpps.Add(new Opportunity()
          {
            Name = opp.Name,
            EstimatedRevenue = opp.EstimatedRevenue
          });
        }
        Accounts.Add(currentAccount);
      }
    }

    public void GetOpportunityPipeline(string accountID)
    {
      Opportunities.Clear();
      Account acc = FindAccountByID(accountID);
      foreach (Opportunity opp in acc.AccOpps)
      {
        Opportunities.Add(opp);
      }
    }

    public Account FindAccountByID(string accountID)
    {
      foreach (Account acc in Accounts)
      {
        if (acc.AccountID.Equals(accountID,
            StringComparison.OrdinalIgnoreCase))
          return acc;
      }
      return null;
    }

    public void UpdateData()
    {
      // Use  Account.IsDirty to determine accounts that have changed
      // Call the Proxy WebService to update the data back into CRMOnline
    }
  }
}

<UserControl x:Class="CRMSLParts.MainPage"
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"
xmlns:my="clr-namespace:CRMSLParts"
mc:Ignorable="d"
d:DesignHeight="300" d:DesignWidth="400"
xmlns:data="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls .Data"
xmlns:chartingToolkit= "clr-namespace:System.Windows.Controls.DataVisualization .Charting;assembly=System.Windows.Controls.DataVisualization.Toolkit">

<UserControl.Resources>
  <my:AccountManager x:Key="accountManagerViewSource" />
</UserControl.Resources>

<Grid x:Name="LayoutRoot" Background="White">
  <StackPanel Orientation="Vertical" Margin="15">
    <data:DataGrid AutoGenerateColumns="False"
                  DataContext="{Binding Path=Accounts,
                  Source={StaticResource accountManagerViewSource}}"
                  ItemsSource="{Binding}" SelectionChanged="dg_SelectionChanged"
                  HorizontalAlignment="Left" Margin ="5" Height="300"  Name="dg"
                  IsReadOnly="False" HeadersVisibility="Column"
                  Grid.Row="0" Grid.Column="0" >
      <data:DataGrid.Columns>
        <data:DataGridTextColumn Binding="{Binding AccountName}"
                                        Header="Account Name" />
        <data:DataGridTextColumn Binding="{Binding MainPhone}"
                                        Header="Phone" />
        <data:DataGridTextColumn Binding="{Binding Email}"
                                        Header="Email" />
        <data:DataGridTextColumn Binding="{Binding City}" Header="City" />
        <data:DataGridTextColumn Binding="{Binding State}"
                                        Header="State" />
      </data:DataGrid.Columns>
    </data:DataGrid>
    <StackPanel Orientation="Horizontal" Margin="3" Grid.Row="1">
      <Button Margin="3" Content="Save Changes" x:Name="btnSave"
                  Click="btnSave_Click"/>
      <Button Margin="3" Content="Escalate Account" x:Name="btnPublishToSP"
                  Click="btnPublishToSP_Click"/>
    </StackPanel>
    <chartingToolkit:Chart HorizontalAlignment="Left" Margin="12,12,0,0"
                              Name="chart1" Title="Opportunity Pipeline"
                              VerticalAlignment="Top" Height="276" Width="520">
      <chartingToolkit:Chart.Series>
        <chartingToolkit:ColumnSeries Title="Revenue"
                                            ItemsSource="{Binding}"
                          IndependentValueBinding="{Binding Name}"
                          DependentValueBinding="{Binding EstimatedRevenue}"/>
      </chartingToolkit:Chart.Series>
    </chartingToolkit:Chart>
  </StackPanel>
</Grid>

private void dg_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
  AccountManager dataObject = this.Resources["accountManagerViewSource"]
                                      as AccountManager;
  dataObject.GetOpportunityPipeline((dg.SelectedItem as Account).AccountID);
}
private void btnPublishToSP_Click(object sender, RoutedEventArgs e)
{
  // To be implemented.
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
  // To be implemented.
}

public MainPage()
{
  InitializeComponent();
  Loaded += new RoutedEventHandler(MainPage_Loaded);
}

void MainPage_Loaded(object sender, RoutedEventArgs e)
{
  AccountManager dataObject = this.Resources["accountManagerViewSource"]
                                      as AccountManager;
  ColumnSeries column = chart1.Series[0] as ColumnSeries;
  column.ItemsSource = dataObject.Opportunities;
}

<?xml version="1.0" encoding="utf-8"?>
<Elements xmlns="http://schemas.microsoft.com/sharepoint/">
  <Module Name="XAPModule" Url="XAP_Bin">
    <File Path="CRMSLParts.xap" Url="CRMSLParts.xap" />
  </Module>
</Elements>

using System;
using System.ComponentModel;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;

namespace CRMSPOWebPartProj.CRMDashboard
{
  [ToolboxItemAttribute(false)]
  public class CRMDashboard : WebPart
  {
    protected override void CreateChildControls()
    {
      string slStreamCode = "<div id="slApp"/>" +
      "<script language="JavaScript" type="text/javascript">" +
      "var slSPDIV = document.getElementById(‘slApp’);" +
      "slSPDIV.appendChild(slSPDIV);" +
      "slSPDIV.innerHTML =" +
      "‘<object data="data:application/x-silverlight," " +
      " type="application/x-silverlight" width="740" height="800">" +
      "<param name="source" " +
      "value="http://intranet.contoso.com/XAP_Bin/CRMSLParts.xap"/> " +
      "<param name="initParams" value="MS.SP.url=" +
      SPContext.Current.Site.Url + "" /></object>’;" +
      "</script>";

      this.Controls.Add(new LiteralControl(slStreamCode));

      base.CreateChildControls();
    }
  }
}

…
using Microsoft.SharePoint.Client;

namespace CRMSLParts
{
  public partial class MainPage : UserControl
  {
    List CRMEscalations;
    Account selectedAccount;

    public MainPage()
…

private void btnPublishToSP_Click(object sender, RoutedEventArgs e)
{
  ClientContext context;

  if (App.Current.IsRunningOutOfBrowser)
  {
    context = new ClientContext("http://intranet.contoso.com");
  }
  else
  {
    context = ClientContext.Current;
  }

  //Get the list
  CRMEscalations = context.Web.Lists.GetByTitle("CRM Escalations");
  context.Load(CRMEscalations);

  //Create the escalation list item
  ListItemCreationInformation itemCreateInfo =
      new ListItemCreationInformation();
  ListItem listItem = CRMEscalations.AddItem(itemCreateInfo);
  selectedAccount = dg.SelectedItem as Account;
  listItem["Title"] = selectedAccount.AccountName;
  listItem["Phone"] = selectedAccount.MainPhone;
  listItem["Email"] = selectedAccount.Email;
  listItem.Update();

  //Make the call to the SharePoint server
  context.ExecuteQueryAsync(
              succeededCallback,
              failedCallback);

}

void succeededCallback(object sender, ClientRequestSucceededEventArgs args)
{
  this.Dispatcher.BeginInvoke(() =>
  {
    MessageBox.Show(selectedAccount.AccountName +
        " has been escalated to the Senior Leadership Team");
  });

}
void failedCallback(object sender, ClientRequestFailedEventArgs args)
{
  this.Dispatcher.BeginInvoke(() =>
  {
    MessageBox.Show(
        string.Format("Failed - msg:{0} errcode:{1} stackTrace:{2}",
        args.Message, args.ErrorCode, args.StackTrace));
  });
}