or
Entities in 'CFETSDBContainer.FREQUENCIES' participate in the 'FREQUENCYFreqPool' relationship. 0 related 'FreqPool' were found. 1 'FreqPool' is expected.Why it is doing this is obvious, but I don't know HOW to fix it. When the user enters a new row in the data grid and commits it, it needs to create the new FREQ_POOL and FREQ_TYPE entries as well.
FREQ_POOL and FREQ_TYPE are base classes, and so I need to manually set the types of both and set their properties in the code-behind I believe.
How do I do this? I have only done simple databinding. Here is my code.
<DataGrid AutoGenerateColumns="False" Height="278" HorizontalAlignment="Left" Margin="24,31,0,0" Name="dgIA" VerticalAlignment="Top" Width="520" Loaded="dataGrid1_Loaded" RowEditEnding="dgIA_RowEditEnding" DataContext="{Binding}"> <DataGrid.Columns> <DataGridComboBoxColumn DisplayMemberPath="Name" Header="GACC" SelectedValuePath="{Binding Name}" x:Name="cbGACCS" SelectedValueBinding="{Binding ZONE.GACC,Mode=TwoWay}" /> <DataGridComboBoxColumn DisplayMemberPath="Name" Header="Zones" SelectedValuePath="{Binding Name}" x:Name="cbZONES" SelectedValueBinding="{Binding ZONE,Mode=TwoWay}" /> <DataGridTextColumn Header="Frequency" Binding="{Binding Path=Frequency,Mode=TwoWay}"/> <DataGridComboBoxColumn Header="Frequency Type" x:Name="cbFT" SelectedValueBinding="{Binding Path=FrequencyType,Mode=TwoWay}"/> <DataGridComboBoxColumn Header="Owner" x:Name="cbOwner" SelectedValueBinding="{Binding Path=Owner,Mode=TwoWay}" /> <DataGridTextColumn Header="Usage Type" Binding="{Binding Path=UsageType,Mode=TwoWay}"/> <DataGridTextColumn Header="Comments" Binding="{Binding Path=Comments,Mode=TwoWay}"/> <DataGridTextColumn Header="Serial #" Binding="{Binding Path=Serial,Mode=TwoWay}"/> </DataGrid.Columns> </DataGrid> private void dgIA_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e) { if (!isManualEditCommit) { isManualEditCommit = true; DataGrid grid = (DataGrid)sender; grid.CommitEdit(DataGridEditingUnit.Row, true); ctx.SaveChanges(); isManualEditCommit = false; } }}<UserControl xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation" x:Class="Concord.HIS.Dashboard.UserControls.LabTestOverallUserControl" mc:Ignorable="d" d:DesignHeight="800" d:DesignWidth="900"> <Grid> <StackPanel> <StackPanel Orientation="Horizontal"> <ListBox x:Name="TopTenLabTestsListBox" ItemsSource="{Binding TopTenLabTests}" ItemContainerStyle="{StaticResource ToptenListItem}" /> <telerik:RadChart MaxWidth="300" MaxHeight="200" ItemsSource="{Binding ClinicPieChartdata}" Margin="15 0 15 0"> <telerik:RadChart.SeriesMappings> <telerik:SeriesMapping> <telerik:SeriesMapping.SeriesDefinition> <telerik:PieSeriesDefinition ItemLabelFormat="#%{p0}" ShowItemLabels="True" /> </telerik:SeriesMapping.SeriesDefinition> <telerik:SeriesMapping.ItemMappings> <telerik:ItemMapping DataPointMember="YValue" FieldName="Count" /> <telerik:ItemMapping DataPointMember="LegendLabel" FieldName="Lable" /> </telerik:SeriesMapping.ItemMappings> </telerik:SeriesMapping> </telerik:RadChart.SeriesMappings> </telerik:RadChart> <telerik:RadChart MaxWidth="300" MaxHeight="200" ItemsSource="{Binding ClinicPieChartdata}"> <telerik:RadChart.DefaultView> <telerik:ChartDefaultView> <telerik:ChartDefaultView.ChartLegend> <telerik:ChartLegend Width="0" /> </telerik:ChartDefaultView.ChartLegend> </telerik:ChartDefaultView> </telerik:RadChart.DefaultView> <telerik:RadChart.SeriesMappings> <telerik:SeriesMapping> <telerik:SeriesMapping.ItemMappings> <telerik:ItemMapping DataPointMember="YValue" FieldName="Count" /> <telerik:ItemMapping DataPointMember="XValue" FieldName="Lable" /> </telerik:SeriesMapping.ItemMappings> </telerik:SeriesMapping> </telerik:RadChart.SeriesMappings> </telerik:RadChart> </StackPanel> <StackPanel Orientation="Horizontal" Margin="0 5 0 0"> <StackPanel Width="{Binding ElementName=TopTenLabTestsListBox,Path=Width}"> <StackPanel Orientation="Horizontal"> <StackPanel Width="175"> <TextBlock Text="Most used lab test:" TextWrapping="Wrap" /> </StackPanel> <TextBlock Text="{Binding MostUsedLabTest.Name}" VerticalAlignment="Center" Margin="5 0 0 0"/> </StackPanel> <StackPanel Orientation="Horizontal" Margin="0 5 0 0"> <StackPanel Width="175"> <TextBlock Text="Clinic ordered this test the most:" TextWrapping="Wrap" /> </StackPanel> <TextBlock Text="{Binding MostUsedLabTest.ClinicName}" VerticalAlignment="Center" Margin="5 0 0 0" /> </StackPanel> <StackPanel Orientation="Horizontal" Margin="0 5 0 0"> <StackPanel Width="175"> <TextBlock Text="Doctor ordered this test the most:" TextWrapping="Wrap" /> </StackPanel> <TextBlock Text="{Binding MostUsedLabTest.DoctorName}" VerticalAlignment="Center" Margin="5 0 0 0" /> </StackPanel> <StackPanel Orientation="Horizontal" Margin="0 5 0 0"> <StackPanel Width="175"> <TextBlock Text="Most orders in one day:" TextWrapping="Wrap" /> </StackPanel> <TextBlock Text="{Binding MostUsedLabTest.MostOrderedInOneDay}" VerticalAlignment="Center" Margin="5 0 0 0" /> </StackPanel> <StackPanel Orientation="Horizontal" Margin="0 5 0 0"> <StackPanel Width="175"> <TextBlock Text="Most diagnosis this lab test was ordered for:" TextWrapping="Wrap" /> </StackPanel> <TextBlock Text="{Binding MostUsedLabTest.MostDiagnosis}" VerticalAlignment="Center" Margin="5 0 0 0" /> </StackPanel> <StackPanel Orientation="Horizontal" Margin="0 5 0 0"> <StackPanel Width="175"> <TextBlock Text="Number of children who used this test:" TextWrapping="Wrap" /> </StackPanel> <TextBlock Text="{Binding MostUsedLabTest.ChildrenNumber}" VerticalAlignment="Center" Margin="5 0 0 0" /> </StackPanel> <StackPanel Orientation="Horizontal" Margin="0 5 0 0"> <StackPanel Width="175"> <TextBlock Text="Number of children who used this test:" TextWrapping="Wrap" /> </StackPanel> <TextBlock Text="{Binding MostUsedLabTest.ChildrenNumber}" VerticalAlignment="Center" Margin="5 0 0 0" /> </StackPanel> <StackPanel Orientation="Horizontal" Margin="0 5 0 0"> <StackPanel Width="175"> <TextBlock Text="Lab test total orders:" TextWrapping="Wrap" /> </StackPanel> <TextBlock Text="{Binding MostUsedLabTest.TotalUsed}" VerticalAlignment="Center" Margin="5 0 0 0" /> </StackPanel> </StackPanel> <StackPanel> <StackPanel Orientation="Horizontal"> <telerik:RadChart MaxWidth="200" MaxHeight="200" ItemsSource="{Binding ClinicPieChartdata}" Margin="15 0 15 0"> <telerik:RadChart.SeriesMappings> <telerik:SeriesMapping> <telerik:SeriesMapping.SeriesDefinition> <telerik:PieSeriesDefinition ItemLabelFormat="#%{p0}" ShowItemLabels="True" /> </telerik:SeriesMapping.SeriesDefinition> <telerik:SeriesMapping.ItemMappings> <telerik:ItemMapping DataPointMember="YValue" FieldName="Count" /> <telerik:ItemMapping DataPointMember="LegendLabel" FieldName="Label" /> </telerik:SeriesMapping.ItemMappings> </telerik:SeriesMapping> </telerik:RadChart.SeriesMappings> </telerik:RadChart> <telerik:RadChart MaxWidth="200" MaxHeight="200" ItemsSource="{Binding ClinicPieChartdata}"> <telerik:RadChart.DefaultView> <telerik:ChartDefaultView> <telerik:ChartDefaultView.ChartLegend> <telerik:ChartLegend Width="0" /> </telerik:ChartDefaultView.ChartLegend> </telerik:ChartDefaultView> </telerik:RadChart.DefaultView> <telerik:RadChart.SeriesMappings> <telerik:SeriesMapping> <telerik:SeriesMapping.ItemMappings> <telerik:ItemMapping DataPointMember="YValue" FieldName="Count" /> <telerik:ItemMapping DataPointMember="XValue" FieldName="Label" /> </telerik:SeriesMapping.ItemMappings> </telerik:SeriesMapping> </telerik:RadChart.SeriesMappings> </telerik:RadChart> <telerik:RadChart MaxWidth="200" MaxHeight="200" ItemsSource="{Binding ClinicPieChartdata}" Margin="15 0 0 0"> <telerik:RadChart.SeriesMappings> <telerik:SeriesMapping> <telerik:SeriesMapping.SeriesDefinition> <telerik:PieSeriesDefinition ItemLabelFormat="#%{p0}" ShowItemLabels="True" /> </telerik:SeriesMapping.SeriesDefinition> <telerik:SeriesMapping.ItemMappings> <telerik:ItemMapping DataPointMember="YValue" FieldName="Count" /> <telerik:ItemMapping DataPointMember="LegendLabel" FieldName="Label" /> </telerik:SeriesMapping.ItemMappings> </telerik:SeriesMapping> </telerik:RadChart.SeriesMappings> </telerik:RadChart> </StackPanel> <StackPanel Orientation="Horizontal"> <StackPanel Grid.Row="0" Orientation="Horizontal" Margin="12,6,0,20"> <TextBlock> <Run Text="Date:" FontFamily="Segoe UI" FontSize="12" /> <Run x:Name="date" Text="Mar 18, 2012" FontFamily="Segoe UI" FontSize="16" /> </TextBlock> <TextBlock Margin="10,0,0,0"> <Run Text="Count:" FontFamily="Segoe UI" FontSize="12" /> <Run x:Name="count" Text="5,976,129" FontFamily="Segoe UI" FontSize="16" /> </TextBlock> </StackPanel> <telerik:RadCartesianChart Grid.Row="1" Margin="10,0,10,30" TrackBallLineStyle="{StaticResource trackBallLineStyle}" TrackBallInfoStyle="{StaticResource trackBallInfoStyle}" x:Name="cChart" Background="AliceBlue"> <telerik:RadCartesianChart.Resources> <DataTemplate x:Key="PointTemplate"> <Ellipse Height="8" Width="8" Stroke="White" StrokeThickness="1" Fill="#1B9DDE" /> </DataTemplate> <Style x:Key="BorderStyle" TargetType="Border"> <Setter Property="Background" Value="#1B9DDE" /> </Style> </telerik:RadCartesianChart.Resources> <telerik:RadCartesianChart.Behaviors> <telerik:ChartTooltipBehavior Placement="Top" HorizontalOffset="-6" VerticalOffset="1" /> <telerik:ChartPanAndZoomBehavior ZoomMode="Horizontal" /> <telerik:ChartTrackBallBehavior ShowIntersectionPoints="True" TrackInfoUpdated="ChartTrackBallBehavior_TrackInfoUpdated" /> <telerik:ChartTooltipBehavior Placement="Top" HorizontalOffset="-6" VerticalOffset="1" /> </telerik:RadCartesianChart.Behaviors> <telerik:AreaSeries x:Name="Chart" CategoryBinding="RigestirationDate" ValueBinding="Count" Fill="#2625A0DA" Stroke="#FF25A0DA" telerik:StyleManager.Theme="Windows8" StrokeThickness="2" TrackBallTemplate="{StaticResource trackBallTemplate}" Visibility="Visible"> <telerik:AreaSeries.VerticalAxis> <telerik:LinearAxis > </telerik:LinearAxis> </telerik:AreaSeries.VerticalAxis> </telerik:AreaSeries> <telerik:RadCartesianChart.HorizontalAxis> <telerik:DateTimeCategoricalAxis DateTimeComponent="Ticks" PlotMode="OnTicks" MajorTickInterval="30" LabelFormat="dd MM yyyy" MajorTickStyle="{StaticResource tickStyle}" /> </telerik:RadCartesianChart.HorizontalAxis> <telerik:RadCartesianChart.VerticalAxis> <telerik:LinearAxis /> </telerik:RadCartesianChart.VerticalAxis> <telerik:RadCartesianChart.Grid> <telerik:CartesianChartGrid StripLinesVisibility="None" MajorLinesVisibility="XY"> <telerik:CartesianChartGrid.YStripeBrushes> <SolidColorBrush Color="#FFD7D7D7" Opacity="0.3" /> <SolidColorBrush Color="Transparent" /> </telerik:CartesianChartGrid.YStripeBrushes> </telerik:CartesianChartGrid> </telerik:RadCartesianChart.Grid> </telerik:RadCartesianChart> </StackPanel> </StackPanel> </StackPanel> </StackPanel> </Grid></UserControl>
<Window x:Class="RadControlsWpfApp6.MainWindow" xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation" Title="MainWindow" Height="350" Width="525"> <Grid> <telerik:RadGridView x:Name="radGridView" AutoGenerateColumns="False" ShowGroupFooters="True" CellEditEnded="radGridView_CellEditEnded"> <telerik:RadGridView.Columns> <telerik:GridViewDataColumn x:Name="_colChud" UniqueName="Chud" DataMemberBinding="{Binding Chud}"> <telerik:GridViewDataColumn.AggregateFunctions> <telerik:SumFunction Caption="Total: " /> </telerik:GridViewDataColumn.AggregateFunctions> </telerik:GridViewDataColumn> <telerik:GridViewDataColumn x:Name="_colChud2" UniqueName="Chud2" DataMemberBinding="{Binding Chud2}"> <telerik:GridViewDataColumn.AggregateFunctions> <telerik:SumFunction Caption="Total: " /> </telerik:GridViewDataColumn.AggregateFunctions> </telerik:GridViewDataColumn> </telerik:RadGridView.Columns> </telerik:RadGridView> </Grid></Window>namespace RadControlsWpfApp6{ /// <summary> /// Interaction logic for MainWindow.xaml /// </summary> public partial class MainWindow : Window { public MainWindow() { InitializeComponent(); radGridView.ItemsSource = Data.GetData(); } private void radGridView_CellEditEnded(object sender, Telerik.Windows.Controls.GridViewCellEditEndedEventArgs e) { radGridView.CalculateAggregates(); } } public class Data { private double _chud; public double Chud { get { return _chud; } set { _chud = value; } } private double _chud2; public double Chud2 { get { return _chud2; } set { _chud2 = value; } } public static ObservableCollection<Data> GetData() { ObservableCollection<Data> data = new ObservableCollection<Data>(); Data d = new Data() { Chud = 1, Chud2 = 1 }; data.Add(d); d = new Data() { Chud = 2, Chud2 = 1 }; data.Add(d); d = new Data() { Chud = 3, Chud2 = 1 }; data.Add(d); d = new Data() { Chud = 4, Chud2 = 1 }; data.Add(d); return data; } }}