This is a migrated thread and some comments may be shown as answers.

Multiple Gauges with Ria Services

5 Answers 50 Views
Gauge
This is a migrated thread and some comments may be shown as answers.
David Gunderson
Top achievements
Rank 1
David Gunderson asked on 18 May 2010, 03:02 PM
This is a two part question
I am attempting to load 9 Gauges with Data from a SQL 2005 Database.

1. When i place 5 gauges of the 9 on the page it will load it takes it a min but it will load when i place the 6th on the page it times out. I am currently using a specific query for the KpiSid (Unique Identifer in the db that = the gauge i want to display)

    
Public Function GetCognosMetricsByKPIID(ByVal KPInum As IntegerAs IQueryable(Of CognosMetric)  
        Return Me.ObjectContext.CognosMetrics.Where(Function(c) c.KpiSid.Equals(KPInum) = True)  
    End Function 
 
Is there a way to dump all the data to the page in like a datagrid (hidden) then loop through it for each gauge?

MainPage.xaml
<UserControl  
    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:MetricsDashAuto.Web"   
    xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk" 
    xmlns:local="clr-namespace:MetricsDashAuto" x:Class="MetricsDashAuto.MainPage"   
    mc:Ignorable="d" d:DesignWidth="640" d:DesignHeight="480" HorizontalAlignment="Center" VerticalAlignment="Center">  
    <Grid x:Name="Layout_Root" Background="#FF373737">  
        <Grid.RowDefinitions> 
            <RowDefinition Height="33*" /> 
            <RowDefinition Height="33*" /> 
            <RowDefinition Height="33*" /> 
        </Grid.RowDefinitions> 
        <Grid.ColumnDefinitions> 
            <ColumnDefinition Width="25*"/>  
            <ColumnDefinition Width="25*"/>  
            <ColumnDefinition Width="25*"/>  
            <ColumnDefinition Width="25*"/>  
        </Grid.ColumnDefinitions> 
        <local:SLUC15337 Grid.Row="0" Grid.Column="0" /> 
        <local:SLUC10089 Grid.Row="0" Grid.Column="1"/>  
        <local:SLUC10517 Grid.Row="0" Grid.Column="2" /> 
        <local:SLUC10677 Grid.Row="0" Grid.Column="3"/>  
        <local:SLUC11330 Grid.Row="1" Grid.Column="0" /> 
        <local:SLUC12345 Grid.Row="1" Grid.Column="1" /> 
        <local:SLUC14708 Grid.Row="1" Grid.Column="2" /> 
        <local:SLUC14725 Grid.Row="1" Grid.Column="3" /> 
        <local:SLUC11904 Grid.Row="2" Grid.Column="0" /> 
        <local:SLUC9652 Grid.Row="2" Grid.Column="1" />    
    </Grid> 
 
</UserControl> 

One of the usercontrols.xaml
<UserControl  
    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:Telerik_Windows_Controls="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls.Gauge"   
    xmlns:Telerik_Windows_Controls_Gauges="clr-namespace:Telerik.Windows.Controls.Gauges;assembly=Telerik.Windows.Controls.Gauge" 
    xmlns:Telerik_Windows_Controls_Map="clr-namespace:Telerik.Windows.Controls.Map;assembly=Telerik.Windows.Controls.DataVisualization"   
    xmlns:riaControls="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.DomainServices"   
    xmlns:MetricsDashAuto_Web="clr-namespace:MetricsDashAuto.Web" 
    mc:Ignorable="d" 
    x:Class="MetricsDashAuto.SLUC14725" 
    d:DesignWidth="640" d:DesignHeight="480">  
 
    <Grid x:Name="LayoutRoot_14725" DataContext="{Binding Data, ElementName=CognosMetricDomainDataSource14725}" Background="#FF373737"   
          HorizontalAlignment="Center" Width="640">  
        <Grid.RowDefinitions> 
            <RowDefinition Height="80*"/>  
            <RowDefinition Height="10*"/>  
            <RowDefinition Height="10*"/>  
        </Grid.RowDefinitions> 
        <Telerik_Windows_Controls:RadGauge HorizontalAlignment="Center" x:Name="CognosMetricRadGauge14725" VerticalAlignment="Center">  
 
            <Telerik_Windows_Controls_Gauges:RadialGauge x:Name="Gauge14725">  
                <Telerik_Windows_Controls_Gauges:RadialScale Min="0.80964" Max="1.09956" Radius="0.75">  
                    <Telerik_Windows_Controls_Gauges:RangeList> 
                        <Telerik_Windows_Controls_Gauges:RadialRange Background="#AB34E800" 
                            StartWidth="0.12" 
                            EndWidth="0.12" 
                            Max="{Binding GMax}" 
                            Min="{Binding GMin}" 
                            ToolTipService.ToolTip="Yellow"/>  
                        <Telerik_Windows_Controls_Gauges:RadialRange Background="Yellow" 
                            StartWidth="0.12" 
                            EndWidth="0.12" 
                            Max="{Binding GMin}" 
                            Min="{Binding RMax}"/>  
                        <Telerik_Windows_Controls_Gauges:RadialRange Background="Red" 
                            StartWidth="0.12" 
                            EndWidth="0.12" 
                            Max="{Binding RMax}" 
                            Min="{Binding RMin}" 
                            ToolTipService.ToolTip="{Binding RMax}"/>  
                    </Telerik_Windows_Controls_Gauges:RangeList> 
                    <Telerik_Windows_Controls_Gauges:IndicatorList> 
                        <Telerik_Windows_Controls_Gauges:Needle Value="{Binding ActualVal}"/>  
                    </Telerik_Windows_Controls_Gauges:IndicatorList> 
                </Telerik_Windows_Controls_Gauges:RadialScale> 
            </Telerik_Windows_Controls_Gauges:RadialGauge> 
        </Telerik_Windows_Controls:RadGauge> 
        <Ellipse   
            x:Name="Ellipse14725" ToolTipService.ToolTip="{Binding Description}" 
            Fill="#00EFA400"   
            Width="{Binding Width, ElementName=Gauge}" 
            Height="{Binding Height, ElementName=Gauge}"   
            VerticalAlignment="Stretch" HorizontalAlignment="Stretch" Cursor="Hand" 
            Stroke="#00000000" MouseLeftButtonUp="Ellipse14725_MouseLeftButtonUp" 
            /> 
        <Grid> 
            <Grid.RowDefinitions> 
                <RowDefinition Height="96*" /> 
                <RowDefinition Height="96*" /> 
                <RowDefinition Height="53*" /> 
                <RowDefinition Height="43*" /> 
                <RowDefinition Height="96*" /> 
            </Grid.RowDefinitions> 
              
            <TextBlock Grid.Row="4" Foreground="GhostWhite" Text="{Binding ActualVal}" FontSize="14" VerticalAlignment="Center" Margin="1,0,0,0" TextAlignment="Center" HorizontalAlignment="Center" /> 
            <Telerik_Windows_Controls_Map:Arrow Grid.Row="3" HorizontalAlignment="Center" x:Name="Arrow14725" VerticalAlignment="Bottom" Direction="Down" Margin="316,0" /> 
            <TextBox Text="{Binding Trend}" x:Name="TxtblkTrend14725" Visibility="Visible" HorizontalAlignment="Left" VerticalAlignment="Top"/>  
        </Grid> 
        <TextBlock Foreground="GhostWhite" HorizontalAlignment="Center" Text="{Binding MName}" Grid.Row="1" FontSize="14" FontStretch="Condensed" /> 
        <Grid Grid.Row="2">  
            <Grid.ColumnDefinitions> 
                <ColumnDefinition /> 
                <ColumnDefinition /> 
            </Grid.ColumnDefinitions> 
            <TextBlock Foreground="GhostWhite" HorizontalAlignment="Right" Text="Goal: " Grid.Row="2" Grid.Column="0" FontSize="14" FontStretch="Condensed" /> 
            <TextBlock Foreground="GhostWhite" HorizontalAlignment="Left" Text="{Binding GMin}" Grid.Row="2" Grid.Column="1" FontStretch="Condensed" FontSize="14" /> 
 
        </Grid> 
        <riaControls:DomainDataSource AutoLoad="True" Height="0" x:Name="CognosMetricDomainDataSource14725" QueryName="GetCognosMetricsByKPIIDQuery" Width="0">  
            <riaControls:DomainDataSource.DomainContext> 
                <MetricsDashAuto_Web:CognosMetricsDS /> 
            </riaControls:DomainDataSource.DomainContext> 
            <riaControls:DomainDataSource.QueryParameters> 
                <riaControls:Parameter x:Name="Parameter14725" ParameterName="KPInum" Value="14725" /> 
            </riaControls:DomainDataSource.QueryParameters> 
        </riaControls:DomainDataSource> 
    </Grid> 
</UserControl> 

one of the usercontrols.xaml.vb
Imports System  
Imports System.Windows  
Imports System.Windows.Controls  
Imports System.Windows.Media  
Imports System.Windows.Media.Animation  
Imports System.Windows.Shapes  
Imports System.Windows.Threading  
Imports Telerik.Windows.Controls  
Imports Telerik.Windows.Controls.Gauges  
Imports System.Windows.Browser  
Imports MetricsDashAuto.Web  
Imports System.ServiceModel.Web  
 
Partial Public Class SLUC14725  
    Inherits UserControl  
 
    Public Sub New()  
        ' Required to initialize variables  
        InitializeComponent()  
 
 
    End Sub 
    Private Sub CognosMetricDomainDataSource14725_LoadedData(ByVal sender As System.ObjectByVal e As System.Windows.Controls.LoadedDataEventArgs)  
 
        If e.HasError Then 
            System.Windows.MessageBox.Show(e.Error.ToString, "Load Error", System.Windows.MessageBoxButton.OK)  
            e.MarkErrorAsHandled()  
        Else 
        End If 
    End Sub 
 
    Private Sub Ellipse14725_MouseLeftButtonUp(ByVal sender As System.ObjectByVal e As System.Windows.Input.MouseButtonEventArgs) Handles Ellipse14725.MouseLeftButtonUp  
        HtmlPage.Window.Navigate(New Uri("http://ngmnc2-j6ops-a1/StratPlan/Include/Graph.aspx?sid=" + Parameter14725.Value, UriKind.Absolute), "Blank")  
    End Sub 
 
    Private Sub TxtblkTrend14725_TextChanged(ByVal sender As System.ObjectByVal e As System.Windows.Controls.TextChangedEventArgs) Handles TxtblkTrend14725.TextChanged  
 
        If TxtblkTrend14725.Text = "U" Then 
            Arrow14725.Direction = Map.ArrowDirection.Up  
            TxtblkTrend14725.Visibility = Windows.Visibility.Collapsed  
        ElseIf TxtblkTrend14725.Text = "S" Then 
            Arrow14725.Visibility = Windows.Visibility.Collapsed  
            TxtblkTrend14725.Visibility = Windows.Visibility.Collapsed  
        End If 
    End Sub 
End Class 
 


2. is there a way to Bind to the Min and Max Values for a gauge? Rmin = 0.80964 GMax=1.09956

<

 

 

Telerik_Windows_Controls_Gauges:RadialScale Min="{Binding RMin}" Max="{Binding GMax}" Radius="0.75">

I get a Invalid Value Error when i attempt this. 

 

5 Answers, 1 is accepted

Sort by
0
Jim Daly
Top achievements
Rank 1
answered on 24 May 2010, 08:55 PM
One thing you could do, if it would be ok to return all of the KPI data to the client in one call, is to filter it on the client via LINQ. So for example you could do something like:

RadGauge1.ItemsSource = MyKPIs.Where(k => k.KpiSid == 1);
RadGauge2.ItemsSource = MyKPIs.Where(k => k.KpiSid == 2);

Assuming that MyKPIs is a property holding the collection of KPI data that you return from your service.

It look as though the Min and Max properties of RadialScale are readonly.
0
David Gunderson
Top achievements
Rank 1
answered on 25 May 2010, 05:25 PM
Thanks Jim, 
    I will try that method. I am able to bind to the  Min Max values now that i updated the Assemblies to the latetest ones.

Dave
0
David Gunderson
Top achievements
Rank 1
answered on 25 May 2010, 08:18 PM
So I have the gauges working the way i want them now but i am running into an issue with one piece of data that I am passing to one of the gauges
<Telerik_Windows_Controls_Gauges:RadialScale Min="{Binding RMin}" Max="{Binding GMax}" Radius="0.75" MajorTicks="0" MinorTicks="0" MiddleTicks="0"

This is working on 11 of the guages that i am passing data to on one of the gauges i am not using small numbers and i think that is what may be causing an issue. The RMin is set at 9919.3572 and the GMax is Set at 12295.8. I am getting an Error that states the Min is Greater than the Max. Which you can see really isn't true.

When i input the numbers manually on the gauge and remove the binding I get the same Error
<Telerik_Windows_Controls_Gauges:RadialScale Min="9919.3572" Max="12295.8" Radius="0.75" MajorTicks="0" MinorTicks="0" MiddleTicks="0"
I have also tried to change the Max to have the same number of decimal points as the Min
<Telerik_Windows_Controls_Gauges:RadialScale Min="9919.3572" Max="12295.8000" Radius="0.75" MajorTicks="0" MinorTicks="0" MiddleTicks="0"
and rounded the numbers (this really wouldn't work for my production needs but figured i would try it)
<Telerik_Windows_Controls_Gauges:RadialScale Min="9919" Max="12296" Radius="0.75" MajorTicks="0" MinorTicks="0" MiddleTicks="0"

None of the above worked. It still throws the same error. is there an issue passing 4 to 5 digits to a gauge?


Thanks Dave
0
Andrey
Telerik team
answered on 26 May 2010, 09:20 AM
Hi David,

The scale validates min-max properties. The max property should be greater than min.
Default min-max range of scale is 0-100. So, when you change the min property to 9919.3572 then it is greater than max (100).
You can try to change max property before min. For example the following code will work properly:

<Telerik_Windows_Controls_Gauges:RadialScale Max="12295.8" Min="9919.3572" Radius="0.75" MajorTicks="0" MinorTicks="0" MiddleTicks="0">

Regards,
Andrey Murzov
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
David Gunderson
Top achievements
Rank 1
answered on 26 May 2010, 04:13 PM
<Telerik_Windows_Controls_Gauges:RadialScale Max="{Binding GMax}" Min="{Binding RMin}"  Radius="0.75" MajorTicks="0" MinorTicks="0" MiddleTicks="0"
So basically if i call the Min Value first it doesn't work because of the way it is being built and if i call out the max value first it does work. Nice to know. That thought never crossed my mind in testing.

Thanks
Dave
Tags
Gauge
Asked by
David Gunderson
Top achievements
Rank 1
Answers by
Jim Daly
Top achievements
Rank 1
David Gunderson
Top achievements
Rank 1
Andrey
Telerik team
Share this question
or