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

[Solved] TwoWay Binding on a Textbox in a RowDetailsTemplate is not working

3 Answers 183 Views

GridView

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

This question is locked. New answers and comments are not allowed.

pritesh asked on 19 Oct 2010, 06:51 AM

I have telrik grid with another grid in rowdetails template.I have following columns

   Description,
   OrderAmount(Qty),
   TempPrice,
   CurrencyCode
   Total

Total Column is the multiplication of the OrderAmount(Qty) and TempPrice.User can update TempPrice at runtime and based on the new temp price , total must be updated.

I am using Ado.net Entity framework with domain service as a data model. To calculate the total , i have created partial class with following properties as i do not have permission to update entity model.

Description,OrderAmount(Qty) and CurrencyCode are coming ado.net entity framework.While TempPrice and Total are defined in the partial class.

Now my problem is Total is not updated when TempPrice in a column is updated. Following is the code

Grid

<telerikGridView:RadGridView Name="grdOrders" Grid.Row="0" ShowGroupPanel="False" IsReadOnly="False" MinWidth="550"

<br>                          AutoGenerateColumns="False" CanUserFreezeColumns="False" RowIndicatorVisibility="Collapsed" <

br

>                          CanUserResizeColumns="False"  IsFilteringAllowed="False" HorizontalAlignment="Stretch"<

br

>                          VerticalAlignment="Top" SelectionMode="Single" LoadingRowDetails="grdOrders_LoadingRowDetails" RowDetailsVisibilityChanged="grdOrders_RowDetailsVisibilityChanged" ><

br> <telerikGridView:RadGridView.Resources> <Helper:ArithmeticConverter x:Key="arithmeticconverter"></Helper:ArithmeticConverter> </telerikGridView:RadGridView.Resources> <telerikGridView:RadGridView.Columns> <telerikGridView:GridViewToggleRowDetailsColumn/> <telerikGridView:GridViewDataColumn DataMemberBinding="{Binding OrderNumber}" Header="Order Number" Background="HotPink" /> </telerikGridView:RadGridView.Columns> <telerikGridView:RadGridView.RowDetailsTemplate> <DataTemplate> <Grid VerticalAlignment="Stretch" ShowGridLines="True" > <Grid.RowDefinitions> <RowDefinition Height="Auto"/> <RowDefinition Height="Auto"/> </Grid.RowDefinitions> <Grid.ColumnDefinitions> <ColumnDefinition /> </Grid.ColumnDefinitions> <telerikGridView:RadGridView Name="radgrdOrderDetails"  ShowColumnFooters="True" ShowGroupPanel="False" AutoGenerateColumns="False" IsFilteringAllowed="False" CanUserFreezeColumns="False" RowIndicatorVisibility="Collapsed" CanUserResizeColumns="False" HorizontalAlignment="Stretch" VerticalAlignment="Top" Grid.Row="0"> <telerikGridView:RadGridView.Columns> <telerikGridView:GridViewDataColumn DataMemberBinding="{Binding Description, Mode=TwoWay}" MinWidth="200" Header="Description" IsReadOnly="True" IsVisible="True"/> <telerikGridView:GridViewDataColumn DataMemberBinding="{Binding OrderAmount,Mode=TwoWay}" MinWidth="100" Header="Amount" IsReadOnly="True" IsVisible="True"/> <telerikGridView:GridViewDataColumn DataMemberBinding="{Binding TempPrice,Mode=TwoWay}" MinWidth="100" Header="price" IsReadOnly="false" IsVisible="true"/> <telerikGridView:GridViewDataColumn DataMemberBinding="{Binding CurrencyCode,Mode=TwoWay}" MinWidth="100" Header="CurrencyCode" IsReadOnly="True" /> <telerikGridView:GridViewDataColumn DataMemberBinding="{Binding Total, Mode=TwoWay}" MinWidth="100" Header="Total" IsReadOnly="True" > <telerikGridView:GridViewDataColumn.AggregateFunctions> <telerikData:SumFunction Caption="Sum : "></telerikData:SumFunction> </telerikGridView:GridViewDataColumn.AggregateFunctions> </telerikGridView:GridViewDataColumn> </telerikGridView:RadGridView.Columns> </telerikGridView:RadGridView> </Grid> </DataTemplate> </telerikGridView:RadGridView.RowDetailsTemplate> </telerikGridView:RadGridView>

Binding the child grid

private void grdOrders_LoadingRowDetails(object sender, Telerik.Windows.Controls.GridView.GridViewRowDetailsEventArgs e)<

br> { objDetailGrid = (RadGridView)e.DetailsElement.FindName("radgrdOrderDetails"); vw_SelectOrderWithInvoice objCurrentItem = (vw_SelectOrderWithInvoice)e.Row.DataContext; objDetailGrid.ItemsSource = OrderDetails.Where(ord => ord.ID == objCurrentItem.ID); } 

This is how my partial class looks.Main class is defined in ado.net entity framework

public partial class vw_SelectOrderDetails : EntityObject { /// <summary> /// No Metadata Documentation available. /// </summary> // [EdmScalarPropertyAttribute(EntityKeyProperty = false, IsNullable = false)] [DataMemberAttribute()] public global::System.Decimal? Total { get { if (_Total == null) { _Total = Price * OrderAmount; } return _Total; } set { if (Total != value) { OnTotalChanging(value); ReportPropertyChanging("Total"); _Total = StructuralObject.SetValidValue(value); ReportPropertyChanged("Total"); OnTotalChanged(); } } } private global::System.Decimal? _Total; partial void OnTotalChanging(global::System.Decimal? value); partial void OnTotalChanged(); [DataMemberAttribute()] public global::System.Decimal? TempPrice { get { if (_TempPrice == null) { this._TempPrice = Price; } return _TempPrice; } set { if (_TempPrice != value) { OnTempPriceChanging(value); ReportPropertyChanging("TempPrice"); _TempPrice = StructuralObject.SetValidValue(value); ReportPropertyChanged("TempPrice"); OnTempPriceChanged(); Price = _TempPrice; Total = _TempPrice * OrderAmount; ReportPropertyChanged("Total"); } } } private global::System.Decimal? _TempPrice; partial void OnTempPriceChanging(global::System.Decimal? value); partial void OnTempPriceChanged(); }

Please help me.

3 Answers, 1 is accepted

answered on 19 Oct 2010, 09:06 AM

Hello pritesh,

A similar scenario to yours is described and demonstrated in this blog post. As you may read at the bottom of the article, you can benefit from the INotifyPropertyChanged Interface. In case you implement it, you will be able to change the value of some of the columns and the result in the calculated column will be updated. Furthermore, you can download a sample project demonstrating this approach.

Kind regards,
Maya
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

answered on 20 Oct 2010, 04:40 PM

calculatedcolumns-2010.zip

Hi pritesh,

Another possible approach may be to recalculate the "Total" property, once the value of other properties have been changed. I am sending you a sample project illustrating this approach.

All the best,
Maya
the Telerik team