Skip to content
/

I received a couple of comments on my article about making the pull-down-to-refresh work with a Windows Phone virtualizing list control.

The problem was that the functionality stopped working after navigating away from the page containing the ItemsControl.
To prevent events from triggering when the list is not in view I deregistered all events. But when the list came back in view I didn’t start monitoring these events again.
Today I committed the code to GitHub to fix this issue.

Source code

You can download my Windows Phone 8 example project on GitHub.

/

Every Microsoft Dynamics CRM developer has faced this problem: How to get the entity type code for your custom entity in JavaScript. If you need the entity type code for the current form there are several supported ways to get it. But when you want the entity type code for a different custom entity, you are in trouble. The SDK has no real solution for this, and hard-coding is no option as the numbers can change per deployment.

So how do most people solve this? A popular choice is the unsupported Remote Command and Lookup service. Because of the asynchronous nature the use of a service adds a performance penalty and complexity to your code. It also seems this will break in CRM 2015 Update 1.

Digging through the client side object model I found a nice, although still unsupported, treasure which works with CRM 2011 and up, including the latest installment: 2015 update 1.

Mscrm.EntityPropUtil.EntityTypeName2CodeMap

This class contains a dictionary of all out-of-the-box entities but also all custom entities. And as it’s already loaded in memory there is no performance loss.

Form JavaScript

When using JavaScript in a form the goodies are readily available:

Mscrm.EntityPropUtil.EntityTypeName2CodeMap.account
// 1

Mscrm.EntityPropUtil.EntityTypeName2CodeMap["account"]
// 1

Mscrm.EntityPropUtil.EntityTypeName2CodeMap.wv_country
// 10025

Web Resource

From a web resource just target the parent window:

window.parent.Mscrm.EntityPropUtil.EntityTypeName2CodeMap

Or if you have included the ClientGlobalContext.js.aspx, you can also use the class directly:

Mscrm.EntityPropUtil.EntityTypeName2CodeMap

Turbo Forms

With the introduction of the turbo forms in CRM 2015 update 1 you need an additional line of code to make the mapping work:

if (Mscrm.EntityPropUtil == null) {
    Mscrm.EntityPropUtil = parent.Mscrm.EntityPropUtil;
}

From entity type code to entity type name

If you want to use this map to get the entity type name from the entity type code you can use the following line of JavaScript:

Object.keys(Mscrm.EntityPropUtil.EntityTypeName2CodeMap).filter(function(key) { 
  return Mscrm.EntityPropUtil.EntityTypeName2CodeMap[key] === 10025 
})[0]
// "wv_country"

It’s that easy!

/

The other day I was working on a Windows Phone app. I wanted to add a “pull down to refresh” panel to a large list of images. Just like the Facebook and Twitter apps have.

Pull-to-refresh in the Twitter app animation. Showing a text to encourage the user pull down further to refresh the list. When pulled down far enough the text changes to let the user know the list will be refreshed after the user releases his finger from the screen.

Pull-to-refresh in the Twitter app. Image by David Washington

As Microsoft does not provide this functionality in their default controls I started searching the web if somebody else has build something like this already.
I found a blog post by Jason Ginchereau where he provided this functionality for Windows Phone 7.
In my app I use an ItemsControl with a VirtualizingStackPanel to prevent memory issues. After I added the PullDownToRefreshPanel control to my list and started testing it on my phone, I ran into some issues.

The issues

Adding the control to my page was easy. But I noticed two things.

  1. Performance, it’s taking up a lot of processing power, resulting in visual lag. Specially when using a low powered phone.
  2. Scrolling, when scrolling through the list with a quick flicking motion the same images kept scrolling by, making the list scroll endlessly until I stopped flicking

In this blog post I will describe my contributions to fix these 2 issues and I will supply the source code for you to use.

1. Improving performance

Looking at the code, the first thing I noticed was that the control subscribes to the LayoutUpdated event. The code in the event handler tries to find the ScrollViewer control to attach to. After the ScrollViewer is successfully found, the event is never unsubscribed and keeps firing quite often. When you add a debug message to the method you’ll see the event fires constantly during the actual scrolling, but also fires when the control is not even on the screen. So the first fix was to unregister the event if the ScrollViewer is found. There is no need to fire unnecessary code.

private void PullDownToRefreshPanel_LayoutUpdated(object sender, EventArgs e)
{
    if (this.targetScrollViewer == null)
    {
        this.targetScrollViewer = 
             FindVisualElement<ScrollViewer>(VisualTreeHelper.GetParent(this));
        if (this.targetScrollViewer != null)
        {
            this.LayoutUpdated -= PullDownToRefreshPanel_LayoutUpdated;
            // *snip*
        }
    }
}

The second thing I observed were the NegativeValueConverters. The ValueConvertor adds negative space at the bottom to keep the ScrollViewer positioned on the same location if the PullDownToRefreshPanel was growing in height.
Inside the convertor there is an unnecessary Convert from Object to Double. When resizing the control this conversion was called a lot of times. So this could be written a bit simpler as the value is already of the type Double.

//double doubleValue = -System.Convert.ToDouble(value);
double doubleValue = -(double)value; // No System.Convert needed

When looking at the original example project by Jason, the negative space was needed because the control and the list are in separate rows in a grid. By changing the XAML to put both controls in the same grid cell there is no need for this negative space because the controls are now floating on top of each other. Eliminating the ValueConvertors all together made the process much lighter.
My XAML looks a bit like this:

<Grid>
  <rlb:PullDownToRefreshPanel x:Name="refreshPanel"
                              RefreshRequested="refreshPanel_RefreshRequested" 
                              VerticalAlignment="Top" />
  <ItemsControl x:Name="listBox"
                ItemsSource="{Binding}">
      <ItemsControl.ItemsPanel>
        <ItemsPanelTemplate>
          <VirtualizingStackPanel Orientation="Vertical" />
        </ItemsPanelTemplate>
      </ItemsControl.ItemsPanel>
      <ItemsControl.Template>
        <ControlTemplate TargetType="ItemsControl">
          <ScrollViewer ManipulationMode="Control">
            <ItemsPresenter/>
          </ScrollViewer>
        </ControlTemplate>
    </ItemsControl.Template>
  </ItemsControl>
</Grid>

2. Fixing the scrolling

To make the pull-to-refresh list work, it’s mandatory to change the ManipulationMode property of the ScrollViewer to “Control“. This allows you to catch the MouseMove event and the MouseLeftButtonUp event. With these events you can detect the change of the position of the content inside the ScrollViewer by monitoring the TranslateY property which changes when the compression happens.

Because I noticed the same images kept scrolling by, I was suspecting the VirtualizingStackPanel was not receiving the correct signals and was recycling the same placeholders (and images) over and over without getting fresh data as it should.
Searching the web again I came across a blog post by Matthijs Krempel describing that the Mango update added some new candy that would allow you to detect the compression using VisualStates and therefore you can leave the ManipulationMode on “System”. Resulting in a better performance and in a correctly functioning VirtualizingStackPanel. This does not work out-of-the-box, you need to add a specific template to the ScrollViewer.
Matthijs added this to his own “PullToRefreshPanel” control.

However, the VisualStates let you only know if compression has started or ended. It doesn’t let you know how much compression is applied. Without the mouse events I needed another way to detect the amount of compression. Which led me to build my own version of the control.

Building a new Pull-Down-To-Refresh Panel

Windows Phone provides the Touch class which is an application-level service that processes touch input from the operating system and raises the FrameReported event. Inside this event you can read what kind of interaction is happening between the fingers and the screen.

private void TouchFrameReported(object sender, TouchFrameEventArgs e)
{
    var primaryTouchPoint = e.GetPrimaryTouchPoint(this);

    switch (primaryTouchPoint.Action)
    {
        case TouchAction.Down:
            this.initialPoint = primaryTouchPoint.Position;

            if (this.isCompressed)
            {
                this.StartMeasuring();
            }

            break;

        case TouchAction.Move:
            if (this.isMeasuring)
            {
                // Only update if the finger moves up/down the screen
                if (this.currentPosition.Y != primaryTouchPoint.Position.Y)
                {
                    this.currentPosition = primaryTouchPoint.Position;
                    this.UpdateControl();
                }
            }
            else
            {
                this.initialPoint = primaryTouchPoint.Position;
            }

            break;

        case TouchAction.Up:
            this.StopMeasuring();

            break;
    }
}

So I combined the control Jason originally wrote with the extensions Matthijs made to detect compression. Then I replaced the mouse events with touch actions. Resulting in a faster control that also works with virtualized controls like an ItemsControl with a VirtualizingStackPanel or the ListBox.

I’ll have to note that the PullDownToRefreshPanel control will not work with the LongListSelector as that control does not expose a ScrollViewer.

Source code

You can download my Windows Phone 8 example project on GitHub.

/

With Windows Azure we can use Windows Azure SQL Database service (formerly known as SQL Azure) when we need a Relational Database. Microsoft offers a 99.9% monthly SLA for this service. But Microsoft doesn’t provide you with the service to restore your data to a moment back in time when you (accidentally) delete of corrupt data.

With an “on premise” Microsoft SQL Server installation you would solve this by configuring and scheduling (transactional log) backups. But this isn’t possible for the Windows Azure service.

You could replicate a copy of your database using SQL Data Sync with a delay. But if you fail to discover the issue in time for the next scheduled sync your copy won’t make a difference.

To have a backup in time I wrote some code to allow a Worker Role to backup my Windows Azure SQL Database every hour. Most solutions you find online are relying on the REST Endpoints but the address of the endpoint is different depending on which datacenter your database is hosted. I found a different solution where you only need the connection string to your database using the DacServices.

Pre-requisites

To make a backup I use the Microsoft SQL Server 2012 Data-Tier Application Framework. This framework provides the DacServices Class.

You need to configure Local Storage to store the backup temporary and you need a Storage Account to store the backup file permanently.

The solution

// Get the Storage Account
var backupStorageAccount = 
                CloudStorageAccount.FromConfigurationSetting("StorageAccount");

// The container to store backups
var backupBlobClient = backupStorageAccount.CreateCloudBlobClient();
backupContainer = backupBlobClient.GetContainerReference("backups");
backupContainer.CreateIfNotExist();

// The backup file on blob storage
var storageName = 
  string.Format("Backup_{0}.bacpac", DateTime.Now.ToString("yyyyMMdd-HHmmss"));
var backupFile = backupContainer.GetBlobReference(storageName);

// Get a reference to the temporary files
var localResource = RoleEnvironment.GetLocalResource("TempFiles");
var file = string.Format("{0}{1}", localResource.RootPath, backupFile.Name);

// Connect to the DacServices
var services = new DacServices(ConfigurationManager
                          .ConnectionStrings["DatabaseName"].ConnectionString);
services.Message += (sender, e) =>
    {
        // If you use a lock file, 
        // this would be a good location to extend the lease
    };

// Export the database to the local disc
services.ExportBacpac(file, "DatabaseName");

// Upload the file to Blob Storage
backupFile.Properties.ContentType = "binary/octet-stream";
backupFile.UploadFile(file);

// Remove the temporary file
File.Delete(file);

Explanation

The code does the following:

  1. Connect to the Storage Account
  2. Get a reference to the container and file where you want to store the backup
  3. Get a reference to the local storage location
  4. Connect to the DacService using the database connection string
  5. Export the database to a “.bacpac” file
  6. Upload the file to blob storage
  7. Delete the local file

A Catch

Before you deploy your Worker Role you’ll have to make sure each of the listed assemblies are referenced and the property “Copy Local” is set to “True” otherwise you will run into trouble.

  • Microsoft.Data.Tools.Schema.Sql
  • Microsoft.Data.Tools.Utilities
  • Microsoft.SqlServer.Dac
  • Microsoft.SqlServer.TransactSql
  • Microsoft.SqlServer.TransactSql.ScriptDom
  • Microsoft.SqlServer.Types
/

Techdays 2013 Netherlands

I’m invited to speak at the in the Netherlands. The event is held on the & of March at the World Forum in Den Haag

My session, in Dutch, is called “” and I will be talking about my experiences using Windows Azure to build a high available and scaling platform for the various applications used during “3FM Serious Request“, the annual charity event organized by the Dutch radio station 3FM for the Dutch Red Cross.

If the schedule doesn’t change I will be speaking in the Africa Room on Friday between .

Update

I’ve uploaded my slides for this session (PowerPoint PPTX, 6,83MB).
You can also view my presentation on SlideShare (but the fonts get messed up):

Techdays 2013 NL – Serious Request met Windows Azure from Michaël Hompus