Telerik Forums / UI for ASP.NET AJAX
This is a migrated thread and some comments may be shown as answers.

radgrid master-detail with full editing

5 Answers 339 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Erik
Top achievements
Rank 2
Erik asked on 05 Nov 2008, 06:50 PM
Hi all,

I have a grid with a sub grid. All works wel, except the detail grid will not insert, update or delete. I can select edit, I'm getting a popup edit, but when I click update, the record is not being updated. No errors. The event "ItemCommand" triggers, and thats it! nothing else, no other events, not from the grid as the datasource.

I've tried (among other 1000 things) to use the detail datasource on a single grid, and there are no problems.

In the example:
http://demos.telerik.com/aspnet/prometheus/Grid/Examples/DataEditing/ThreeLevel/DefaultVB.aspx

it seems a piece of cake... I've copied all the properties edc.. It is costing mne hours and still nothing...

do I need to set other properties? Is detail editing not supported this way?

5 Answers, 1 is accepted

Sort by
0
Kevin Babcock
Top achievements
Rank 1
answered on 05 Nov 2008, 08:43 PM
Hello Proovit,

Would you mind posting your code here so that I can get a better idea of what you might be doing wrong?

Thanks,
Kevin Babcock
0
Princy
Top achievements
Rank 2
answered on 06 Nov 2008, 04:20 AM
Hello Proovit,

Have you set the AllowAutomaticUpdates to true for the DetailTable. If not, try setting it to true and see if it works.
aspx:
<telerik:RadGrid ID="RadGrid1" AutoGenerateColumns="false" runat="server">              
  <MasterTableView EditMode="EditForms" Name="Master">       
   <DetailTables> 
    <telerik:GridTableView AllowAutomaticUpdates="true" Name="Detail" DataSourceID="SqlDataSource1" runat="server" > 
     <Columns> 
      ...... 

Thanks
Princy.
0
Erik
Top achievements
Rank 2
answered on 06 Nov 2008, 10:58 AM

Hello Kevin & Princy,

Thanks for your responces. Yes, i used "AllowAutomaticUpdates" aswel as "AllowAutomaticDeleted" and "AllowAutomaticInserts" both on the master as the detail.

Here is the code:

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default7.aspx.vb" Inherits="Default7" %> 
 
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> 
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
 
<html xmlns="http://www.w3.org/1999/xhtml">  
    <head runat="server">  
        <title>Untitled Page</title> 
    </head> 
    <body> 
        <form id="form1" runat="server">  
            <div> 
                <telerik:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager> 
      
        <telerik:RadGrid ID="RadGrid_Release" runat="server" AutoGenerateColumns="False"   
            DataSourceID="SqlDataSource_Release" GridLines="None" Skin="Office2007">  
            <MasterTableView DataKeyNames="Releasenummer" DataSourceID="SqlDataSource_Release" EditMode="PopUp" CommandItemDisplay="TopAndBottom" Name="Master" 
                             CommandItemSettings-AddNewRecordText="New Release" AllowAutomaticDeletes="true" AllowAutomaticInserts="true" AllowAutomaticUpdates="true" > 
                <RowIndicatorColumn> 
                    <HeaderStyle Width="20px"></HeaderStyle> 
                </RowIndicatorColumn> 
 
                <ExpandCollapseColumn> 
                    <HeaderStyle Width="20px"></HeaderStyle> 
                </ExpandCollapseColumn> 
                  
                <DetailTables> 
                    <telerik:GridTableView DataSourceID="SqlDataSource_Stem" DataKeyNames="Stemaanvraagnummer" Caption="Stem for this release" 
                        Name="Detail_Stem" CommandItemDisplay="TopAndBottom" EditMode="PopUp" CommandItemSettings-AddNewRecordText="New Stem"   
                        AllowAutomaticDeletes="true" AllowAutomaticInserts="true" AllowAutomaticUpdates="true" ShowFooter="true" > 
                        <ParentTableRelation> 
                            <telerik:GridRelationFields DetailKeyField="Releasenummer" MasterKeyField="Releasenummer" /> 
                        </ParentTableRelation> 
                        <RowIndicatorColumn> 
                            <HeaderStyle Width="20px"></HeaderStyle> 
                        </RowIndicatorColumn> 
 
                        <ExpandCollapseColumn> 
                            <HeaderStyle Width="20px"></HeaderStyle> 
                        </ExpandCollapseColumn> 
                          
                        <Columns> 
                            <telerik:GridEditCommandColumn ButtonType="ImageButton"></telerik:GridEditCommandColumn> 
                            <telerik:GridButtonColumn CommandName="Delete" Text="Delete" ButtonType="ImageButton"></telerik:GridButtonColumn> 
 
                            <telerik:GridBoundColumn DataField="Status" HeaderText="Status" SortExpression="Status" UniqueName="Status" HeaderStyle-Width="40px">  
                            </telerik:GridBoundColumn> 
                              
                            <telerik:GridBoundColumn DataField="Tons" DataType="System.Int32" DataFormatString="{0:N0}" HeaderText="Tons" SortExpression="Tons"   
                                UniqueName="Tons" HeaderStyle-HorizontalAlign="Right" ItemStyle-HorizontalAlign="Right" Aggregate="Sum" > 
                            </telerik:GridBoundColumn> 
 
                            <telerik:GridBoundColumn DataField="Klantreferentie1" HeaderText="Ref. 1" SortExpression="Klantreferentie1" UniqueName="Klantreferentie1"></telerik:GridBoundColumn> 
                            <telerik:GridBoundColumn DataField="Klantreferentie2" HeaderText="Ref. 2" SortExpression="Klantreferentie2" UniqueName="Klantreferentie2"></telerik:GridBoundColumn> 
                            <telerik:GridBoundColumn DataField="Klantreferentie3" HeaderText="Ref. 3" SortExpression="Klantreferentie3" UniqueName="Klantreferentie3"></telerik:GridBoundColumn> 
 
                            <telerik:GridBoundColumn DataField="Stemaanvraagnummer" DataType="System.Int32" HeaderText="{ID}" SortExpression="Stemaanvraagnummer"   
                                UniqueName="Stemaanvraagnummer" HeaderStyle-Width="40px" HeaderStyle-ForeColor="Red" ItemStyle-ForeColor="Red">  
                            </telerik:GridBoundColumn> 
                            <telerik:GridBoundColumn DataField="Releasenummer" DataType="System.Int32" HeaderText="{ReID}" SortExpression="Releasenummer"   
                                UniqueName="Releasenummer" HeaderStyle-Width="40px" HeaderStyle-ForeColor="Red" ItemStyle-ForeColor="Red">  
                            </telerik:GridBoundColumn> 
                        </Columns> 
                        <CommandItemSettings /> 
                  
                        <EditFormSettings EditFormType="Template" CaptionFormatString="Stem Entry" > 
                            <PopUpSettings Modal="true" ScrollBars="Auto" Height="400px" Width="800px" /> 
                            <EditColumn UniqueName="EditCommandColumn1"></EditColumn> 
 
                            <FormStyle BackColor="#ECFED8" /> 
                            <FormTemplate> 
                                <table id="Table1" cellspacing="1" cellpadding="1" width="90%" border="0">  
                                    <tr> 
                                        <td></td>  
                                        <td></td>  
                                        <td></td>  
                                        <td></td>  
                                        <td></td>  
                                        <td></td>  
                                    </tr> 
                                    <tr> 
                                        <td><asp:Label ID="lbl_Ton" runat="server" Text="Tons" AssociatedControlID="txt_Tons" /></td><td>:</td> 
                                        <td> 
                                            <telerik:RadNumericTextBox ID="txt_Tons" runat="server" Type="Number" MaxValue="99999999" MinValue="0" MaxLength="8" ShowSpinButtons="True" NumberFormat-DecimalDigits="0" Skin="Office2007" DbValue='<%# Bind("Tons") %>'></telerik:RadNumericTextBox> 
                                        </td> 
                                        <td></td>  
                                        <td></td>  
                                        <td style="text-align:right; "><%#Eval("Stemaanvraagnummer")%>/<%#Eval("Releasenummer")%></td>  
                                    </tr> 
 
                                    <tr> 
                                        <td><asp:Label ID="lbl_Grade" runat="server" Text="Grade" AssociatedControlID="ddl_Grade" /></td><td>:</td> 
                                        <td> 
                                            <telerik:RadComboBox ID="ddl_Grade" Runat="server" AutoCompleteSeparator="|" 
                                                DataSourceID="SqlDataSource_PartijLading" DataTextField="lading_soort_Desc" 
                                                DataValueField="LADINGNUMMER" DropDownWidth="200px" 
                                                EmptyMessage="(select)" EnableVirtualScrolling="True" 
                                                Filter="Contains" NoWrap="True" Skin="Office2007" AppendDataBoundItems="true" 
                                                SortCaseSensitive="False" SelectedValue='<%# Bind("Ladingnummer") %>' > 
                                                <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> 
                                                <Items> 
                                                    <telerik:RadComboBoxItem Text="(select)" Value="<%# DBNull.Value %>" /> 
                                                </Items> 
                                            </telerik:RadComboBox> 
                                        </td> 
                                    </tr> 
                                      
                                    <tr> 
                                        <td><asp:Label ID="lbl_Operator" runat="server" Text="operator" AssociatedControlID="ddl_Agent" /></td><td>:</td> 
                                        <td> 
                                            <telerik:RadComboBox ID="ddl_Agent" Runat="server" AutoCompleteSeparator="|" 
                                                DataSourceID="SqlDataSource_Agent1" DataTextField="Naam" 
                                                DataValueField="FIRMA_ID" DropDownWidth="200px" 
                                                EmptyMessage="<No agents available>" EnableVirtualScrolling="True" 
                                                Filter="Contains" NoWrap="True" Skin="Office2007" AppendDataBoundItems="true" 
                                                SortCaseSensitive="False" SelectedValue='<%# Bind("Agent") %>' > 
                                                <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> 
                                                <Items> 
                                                    <telerik:RadComboBoxItem Text="(select)" Value="<%# DBNull.Value %>" /> 
                                                    <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="NNB" /> 
                                                    <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="GEEN" /> 
                                                </Items> 
                                            </telerik:RadComboBox> 
                                        </td> 
                                        <td><asp:Label ID="lbl_Klantreferentie1" runat="server" Text="Reference 1" AssociatedControlID="txt_Klantreferentie1" /></td><td>:</td> 
                                        <td><asp:TextBox ID="txt_Klantreferentie1" Text='<%# Bind("Klantreferentie1") %>' MaxLength="50" runat="server" /></td>  
                                    </tr> 
                                      
 
                                    <tr> 
                                        <td><asp:Label ID="lbl_IJker" runat="server" Text="gauger" AssociatedControlID="ddl_IJker" /></td><td>:</td> 
                                        <td> 
                                            <telerik:RadComboBox ID="ddl_IJker" Runat="server" AutoCompleteSeparator="|"   
                                                DataSourceID="SqlDataSource_Agent3" DataTextField="Naam"   
                                                DataValueField="FIRMA_ID" DropDownWidth="200px"   
                                                EmptyMessage="<No agents available>" EnableVirtualScrolling="True"   
                                                Filter="Contains" NoWrap="True" Skin="Office2007" AppendDataBoundItems="true"   
                                                SortCaseSensitive="False" SelectedValue='<%# Bind("IJker") %>' > 
                                                <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> 
                                                <Items> 
                                                    <telerik:RadComboBoxItem Text="(select)" Value="<%# DBNull.Value %>" /> 
                                                    <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="NNB" /> 
                                                    <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="GEEN" /> 
                                                </Items> 
                                            </telerik:RadComboBox> 
                                        </td> 
                                        <td><asp:Label ID="lbl_Klantreferentie2" runat="server" Text="Reference 2" AssociatedControlID="txt_Klantreferentie2" /></td><td>:</td> 
                                        <td><asp:TextBox ID="txt_Klantreferentie2" Text='<%# Bind("Klantreferentie2") %>' MaxLength="50" runat="server" /></td>  
                                    </tr> 
                                    <tr> 
                                        <td><asp:Label ID="lbl_Monsteraar" runat="server" Text="sampler" AssociatedControlID="ddl_Monsteraar" /></td><td>:</td> 
                                        <td> 
                                            <telerik:RadComboBox ID="ddl_Monsteraar" Runat="server" AutoCompleteSeparator="|"   
                                                DataSourceID="SqlDataSource_Agent4" DataTextField="Naam"   
                                                DataValueField="FIRMA_ID" DropDownWidth="200px"   
                                                EmptyMessage="<No agents available>" EnableVirtualScrolling="True"   
                                                Filter="Contains" NoWrap="True" Skin="Office2007" AppendDataBoundItems="true"   
                                                SortCaseSensitive="False" SelectedValue='<%# Bind("Monsteraar") %>' > 
                                                <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> 
                                                <Items> 
                                                    <telerik:RadComboBoxItem Text="(select)" Value="<%# DBNull.Value %>" /> 
                                                    <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="NNB" /> 
                                                    <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="GEEN" /> 
                                                </Items> 
                                            </telerik:RadComboBox> 
                                        </td> 
                                        <td><asp:Label ID="lbl_Klantreferentie3" runat="server" Text="Reference 3" AssociatedControlID="txt_Klantreferentie3" /></td><td>:</td> 
                                        <td><asp:TextBox ID="txt_Klantreferentie3" Text='<%# Bind("Klantreferentie3") %>' MaxLength="50" runat="server" /></td>  
                                    </tr> 
 
                                    <tr> 
                                        <td><asp:Label ID="lbl_Remarks" runat="server" Text="Remarks" AssociatedControlID="txt_Remarks" /></td><td>:</td> 
                                        <td><asp:TextBox ID="txt_Remarks" Text='<%# Bind("Opmerking_agent") %>' MaxLength="50" Columns="25" runat="server" /></td>  
                                    </tr> 
                                      
                                    <tr> 
                                        <td colspan="6">  
                                            <img src="spacer.gif" alt="" style="width:1px; height:5px; border:0; display:block; " /> 
                                            <img id="Img1" src="~/APP_Images/HdrGradientUnderline.png" runat="server" style="height:1px; display:block; " alt="" /> 
                                            <img src="spacer.gif" alt="" style="width:1px; height:5px; border:0; display:block; " /> 
                                            <asp:LinkButton ID="Button1" style="white-space:nowrap;" Text='<%# IIf(Container.GetType.ToString = "Telerik.Web.UI.GridEditFormItem", "<img src=""APP_Images/update.gif"" alt=""Update Release"" style=""border:0"" />&nbsp;Update Release", "<img src=""APP_Images/update.gif"" alt=""Update Release"" style=""border:0"" />&nbsp;Add Release") %>' runat="server" CommandName='<%# IIf(Container.GetType.ToString = "Telerik.Web.UI.GridEditFormItem", "Update", "PerformInsert") %>' /> 
                                            &nbsp;  
                                            <asp:LinkButton ID="Button2" Text='<img src="APP_Images/cancel.gif" alt="Cancel Update" style="border:0" />&nbsp;Cancel' runat="server" CausesValidation="False" CommandName="Cancel" /> 
                                        </td> 
                                    </tr> 
                                      
                                        <tr style="background-color:Red; Display:block">  
                                            <td colspan="6">  
                                                <asp:Label ID="lbl_Releasenummer" runat="server" Text='<%# Bind("Releasenummer") %>' /><br /> 
                                                <asp:Label ID="lbl_Partijnummer" runat="server" Text='<%# Bind("Stemaanvraagnummer") %>' /><br /> 
                                                <asp:Label ID="lbl_Mutatiecode" runat="server" Text='<%# Bind("Mutatiecode") %>' /><br /> 
                                                <asp:Label ID="lbl_Status" runat="server" Text='<%# Bind("Status") %>' /><br /> 
                                            </td> 
                                        </tr> 
                                      
                                </table> 
                            </FormTemplate> 
                        </EditFormSettings> 
                  
                          
                    </telerik:GridTableView>   
                  
                </DetailTables>   
 
                  
                <Columns> 
                    <telerik:GridEditCommandColumn ButtonType="ImageButton" HeaderStyle-Width="10px"></telerik:GridEditCommandColumn> 
                    <telerik:GridButtonColumn CommandName="Delete" Text="Delete" UniqueName="column" ButtonType="ImageButton" HeaderStyle-Width="10px"></telerik:GridButtonColumn> 
                    <telerik:GridBoundColumn DataField="Status" HeaderText="Status" SortExpression="Status" UniqueName="Status"   
                                             ItemStyle-VerticalAlign="Top" HeaderStyle-Width="40px">  
                    </telerik:GridBoundColumn> 
                    <telerik:GridBoundColumn DataField="Bestemming" HeaderText="Destination" SortExpression="Bestemming" UniqueName="Bestemming"   
                                             ItemStyle-VerticalAlign="Top" HeaderStyle-Width="120px">  
                    </telerik:GridBoundColumn> 
                    <telerik:GridTemplateColumn DataField="Periode_start" HeaderText="Period" SortExpression="Periode_start" DataType="System.DateTime" UniqueName="Periode_start" 
                                                HeaderStyle-Width="100px">  
                        <ItemTemplate> 
                            <asp:Label ID="PeriodS" runat="server" Text='<%# Eval("Periode_start", "{0:yyyy/MM/dd  HH:mm}") %>'></asp:Label><br /> 
                            <asp:Label ID="PeriodE" runat="server" Text='<%# Eval("Periode_eind", "{0:yyyy/MM/dd  HH:mm}") %>'></asp:Label> 
                        </ItemTemplate> 
                    </telerik:GridTemplateColumn> 
                    <telerik:GridTemplateColumn DataField="Released_tons" HeaderText="Released_tons" SortExpression="Released_tons"  DataType="System.Int32" UniqueName="Released_tons"   
                                                ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="100px">  
                        <ItemTemplate> 
                            <asp:Label ID="ReleasedT" runat="server" Text='<%# Eval("Released_tons", "{0:N0}") %>'></asp:Label><br /> 
                            <asp:Label ID="ReleasedD" runat="server" Text='<%# Eval("Release_datum", "{0:yyyy/MM/dd  HH:mm}") %>'></asp:Label> 
                        </ItemTemplate> 
                    </telerik:GridTemplateColumn> 
 
                    <telerik:GridTemplateColumn HeaderText="Information" UniqueName="Information1" HeaderStyle-Width="150px">  
                        <ItemTemplate>                              
                            <div> 
                                <div style="float:left; white-space:nowrap; ">  
                                    <span>Operator:</span><br /> 
                                    <span>Reference 1:</span> 
                                </div> 
                                <div style="float:left; white-space:nowrap; ">  
                                    <asp:Label ID="Label7" runat="server" Text='<%# Eval("Agent_Desc") %>'></asp:Label><br /> 
                                    <asp:Label ID="Label8" runat="server" Text='<%# Eval("Klantreferentie1") %>'></asp:Label> 
                                </div>                              
                            </div>                              
                        </ItemTemplate> 
                    </telerik:GridTemplateColumn> 
                    <telerik:GridTemplateColumn HeaderText="" UniqueName="Information2" HeaderStyle-Width="150px">  
                        <ItemTemplate>                              
                            <div> 
                                <div style="float:left; white-space:nowrap; ">  
                                    <span>Gauger:</span><br /> 
                                    <span>Reference 2:</span> 
                                </div> 
                                <div style="float:left; white-space:nowrap; ">  
                                    <asp:Label ID="Label9" runat="server" Text='<%# Eval("IJker_Desc") %>'></asp:Label><br /> 
                                    <asp:Label ID="Label10" runat="server" Text='<%# Eval("Klantreferentie2") %>'></asp:Label> 
                                </div> 
                            </div>                              
                        </ItemTemplate> 
                    </telerik:GridTemplateColumn> 
                    <telerik:GridTemplateColumn HeaderText="" UniqueName="Information3" HeaderStyle-Width="150px">  
                        <ItemTemplate> 
                                <div style="float:left; white-space:nowrap; ">  
                                    <span>Sampler:</span><br /> 
                                    <span>Reference 3:</span> 
                                </div> 
                                <div style="float:left; white-space:nowrap; ">  
                                    <asp:Label ID="Label11" runat="server" Text='<%# Eval("Monsteraar_Desc") %>'></asp:Label><br /> 
                                    <asp:Label ID="Label12" runat="server" Text='<%# Eval("Klantreferentie3") %>'></asp:Label> 
                                </div>                              
                            </div>                              
                        </ItemTemplate> 
                    </telerik:GridTemplateColumn> 
                    <telerik:GridTemplateColumn HeaderText="EMO" UniqueName="Information4">  
                        <ItemTemplate> 
                                <div style="float:left; white-space:nowrap; ">  
                                    <span>Start:</span><br /> 
                                    <span>Status:</span> 
                                </div> 
                                <div style="float:left; white-space:nowrap; ">  
                                    <asp:Label ID="lbl_EMO_Start" runat="server" Text="2008-00-00 Spil III"></asp:Label><br /> 
                                    <asp:Label ID="lbl_EMO_Status" runat="server" Text="[TODO]"></asp:Label> 
                                </div>                              
                            </div>                              
                        </ItemTemplate> 
                    </telerik:GridTemplateColumn> 
 
                    <telerik:GridBoundColumn DataField="Releasenummer" HeaderText="{ReID}" SortExpression="Releasenummer" UniqueName="Releasenummer"   
                                             ItemStyle-VerticalAlign="Top" HeaderStyle-Width="40px" HeaderStyle-ForeColor="Red" ItemStyle-ForeColor="Red">  
                    </telerik:GridBoundColumn> 
                </Columns> 
                  
                <EditFormSettings EditFormType="Template" CaptionFormatString="Release" > 
                    <PopUpSettings Modal="true" ScrollBars="Auto" Height="400px" Width="800px" /> 
                    <EditColumn UniqueName="EditCommandColumn1"></EditColumn> 
 
                    <FormStyle BackColor="#ECFED8" /> 
                    <FormTemplate> 
                        <table id="Table1" cellspacing="1" cellpadding="1" width="90%" border="0">  
                            <tr> 
                                <td></td>  
                                <td></td>  
                                <td></td>  
                                <td></td>  
                                <td></td>  
                                <td></td>  
                            </tr> 
                            <tr> 
                                <td><asp:Label ID="lbl_Ton" runat="server" Text="Tons" AssociatedControlID="txt_Tons" /></td><td>:</td> 
                                <td> 
                                    <telerik:RadNumericTextBox ID="txt_Tons" runat="server" Type="Number" MaxValue="99999999" MinValue="0" MaxLength="8" ShowSpinButtons="True" NumberFormat-DecimalDigits="0" Skin="Office2007" DbValue='<%# Bind("Released_tons") %>'></telerik:RadNumericTextBox> 
                                </td> 
                                <td></td>  
                                <td></td>  
                                <td style="text-align:right; "><%# Eval("Releasenummer") %>/<%#Eval("Partijnummer")%></td>  
                            </tr> 
                              
                            <tr> 
                                <td><asp:Label ID="lbl_Period" runat="server" Text="Period" AssociatedControlID="rdtp_PeriodStart" /></td><td>:</td> 
                                <td> 
                                    <telerik:RadDateTimePicker ID="rdtp_PeriodStart" runat="server" SelectedDate='<%#Bind("Periode_start")%>' Skin="Office2007" TimeView-EndTime="23:01:00" TimeView-StartTime="07:00:00" TimeView-Interval="08:00:00" TimeView-Columns="1" ></telerik:RadDateTimePicker> 
                                </td> 
                                <td><asp:Label ID="lbl_PeriodEnd" runat="server" Text="until" AssociatedControlID="rdtp_PeriodEnd" /></td><td>:</td> 
                                <td> 
                                    <telerik:RadDateTimePicker ID="rdtp_PeriodEnd" runat="server" SelectedDate='<%#Bind("Periode_eind")%>' Skin="Office2007" TimeView-EndTime="23:01:00" TimeView-StartTime="07:00:00" TimeView-Interval="08:00:00" TimeView-Columns="1" ></telerik:RadDateTimePicker> 
                                </td> 
                            </tr> 
 
                            <tr> 
                                <td><asp:Label ID="lbl_Destination" runat="server" Text="Destination" AssociatedControlID="txt_Destination" /></td><td>:</td> 
                                <td><asp:TextBox ID="txt_Destination" Text='<%# Bind("Bestemming") %>' MaxLength="50" runat="server" /></td>  
                                <td><asp:Label ID="lbl_ReleaseDate" runat="server" Text="Release date" /></td><td>:</td> 
                                <td><asp:Label ID="txt_ReleaseDate" runat="server" Text='<%# Bind("Release_datum") %>' /></td>  
                            </tr> 
                              
                            <tr> 
                                <td><asp:Label ID="lbl_Operator" runat="server" Text="operator" AssociatedControlID="ddl_Agent" /></td><td>:</td> 
                                <td> 
                                    <telerik:RadComboBox ID="ddl_Agent" Runat="server" AutoCompleteSeparator="|" 
                                        DataSourceID="SqlDataSource_Agent1" DataTextField="Naam" 
                                        DataValueField="FIRMA_ID" DropDownWidth="200px" 
                                        EmptyMessage="<No agents available>" EnableVirtualScrolling="True" 
                                        Filter="Contains" NoWrap="True" Skin="Office2007" AppendDataBoundItems="true" 
                                        SortCaseSensitive="False" SelectedValue='<%# Bind("Agent") %>' > 
                                        <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> 
                                        <Items> 
                                            <telerik:RadComboBoxItem Text="(select)" Value="<%# DBNull.Value %>" /> 
                                            <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="NNB" /> 
                                            <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="GEEN" /> 
                                        </Items> 
                                    </telerik:RadComboBox> 
                                </td> 
                                <td><asp:Label ID="lbl_Klantreferentie1" runat="server" Text="Reference 1" AssociatedControlID="txt_Klantreferentie1" /></td><td>:</td> 
                                <td><asp:TextBox ID="txt_Klantreferentie1" Text='<%# Bind("Klantreferentie1") %>' MaxLength="50" runat="server" /></td>  
                            </tr> 
                              
 
                            <tr> 
                                <td><asp:Label ID="lbl_IJker" runat="server" Text="gauger" AssociatedControlID="ddl_IJker" /></td><td>:</td> 
                                <td> 
                                    <telerik:RadComboBox ID="ddl_IJker" Runat="server" AutoCompleteSeparator="|"   
                                        DataSourceID="SqlDataSource_Agent3" DataTextField="Naam"   
                                        DataValueField="FIRMA_ID" DropDownWidth="200px"   
                                        EmptyMessage="<No agents available>" EnableVirtualScrolling="True"   
                                        Filter="Contains" NoWrap="True" Skin="Office2007" AppendDataBoundItems="true"   
                                        SortCaseSensitive="False" SelectedValue='<%# Bind("IJker") %>' > 
                                        <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> 
                                        <Items> 
                                            <telerik:RadComboBoxItem Text="(select)" Value="<%# DBNull.Value %>" /> 
                                            <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="NNB" /> 
                                            <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="GEEN" /> 
                                        </Items> 
                                    </telerik:RadComboBox> 
                                </td> 
                                <td><asp:Label ID="lbl_Klantreferentie2" runat="server" Text="Reference 2" AssociatedControlID="txt_Klantreferentie2" /></td><td>:</td> 
                                <td><asp:TextBox ID="txt_Klantreferentie2" Text='<%# Bind("Klantreferentie2") %>' MaxLength="50" runat="server" /></td>  
                            </tr> 
                            <tr> 
                                <td><asp:Label ID="lbl_Monsteraar" runat="server" Text="sampler" AssociatedControlID="ddl_Monsteraar" /></td><td>:</td> 
                                <td> 
                                    <telerik:RadComboBox ID="ddl_Monsteraar" Runat="server" AutoCompleteSeparator="|"   
                                        DataSourceID="SqlDataSource_Agent4" DataTextField="Naam"   
                                        DataValueField="FIRMA_ID" DropDownWidth="200px"   
                                        EmptyMessage="<No agents available>" EnableVirtualScrolling="True"   
                                        Filter="Contains" NoWrap="True" Skin="Office2007" AppendDataBoundItems="true"   
                                        SortCaseSensitive="False" SelectedValue='<%# Bind("Monsteraar") %>' > 
                                        <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> 
                                        <Items> 
                                            <telerik:RadComboBoxItem Text="(select)" Value="<%# DBNull.Value %>" /> 
                                            <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="NNB" /> 
                                            <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="GEEN" /> 
                                        </Items> 
                                    </telerik:RadComboBox> 
                                </td> 
                                <td><asp:Label ID="lbl_Klantreferentie3" runat="server" Text="Reference 3" AssociatedControlID="txt_Klantreferentie3" /></td><td>:</td> 
                                <td><asp:TextBox ID="txt_Klantreferentie3" Text='<%# Bind("Klantreferentie3") %>' MaxLength="50" runat="server" /></td>  
                            </tr> 
                              
                            <tr> 
                                <td colspan="6">  
                                    <img src="spacer.gif" alt="" style="width:1px; height:5px; border:0; display:block; " /> 
                                    <img id="Img1" src="~/APP_Images/HdrGradientUnderline.png" runat="server" style="height:1px; display:block; " alt="" /> 
                                    <img src="spacer.gif" alt="" style="width:1px; height:5px; border:0; display:block; " /> 
                                    <asp:LinkButton ID="Button1" style="white-space:nowrap;" Text='<%# IIf(Container.GetType.ToString = "Telerik.Web.UI.GridEditFormItem", "<img src=""APP_Images/update.gif"" alt=""Update Release"" style=""border:0"" />&nbsp;Update Release", "<img src=""APP_Images/update.gif"" alt=""Update Release"" style=""border:0"" />&nbsp;Add Release") %>' runat="server" CommandName='<%# IIf(Container.GetType.ToString = "Telerik.Web.UI.GridEditFormItem", "Update", "PerformInsert") %>' /> 
                                    &nbsp;  
                                    <asp:LinkButton ID="Button2" Text='<img src="APP_Images/cancel.gif" alt="Cancel Update" style="border:0" />&nbsp;Cancel' runat="server" CausesValidation="False" CommandName="Cancel" /> 
                                </td> 
                            </tr> 
                              
                                <tr style="background-color:Red; Display:block">  
                                    <td colspan="6">  
                                        <asp:Label ID="lbl_Releasenummer" runat="server" Text='<%# Bind("Releasenummer") %>' /><br /> 
                                        <asp:Label ID="lbl_Partijnummer" runat="server" Text='<%# Bind("Partijnummer") %>' /><br /> 
                                        <asp:Label ID="lbl_Mutatiecode" runat="server" Text='<%# Bind("Mutatiecode") %>' /><br /> 
                                        <asp:Label ID="lbl_Status" runat="server" Text='<%# Bind("Status") %>' /><br /> 
                                    </td> 
                                </tr> 
                              
                        </table> 
                    </FormTemplate> 
                </EditFormSettings> 
            </MasterTableView> 
 
            <ClientSettings> 
                <Selecting AllowRowSelect="True" /> 
            </ClientSettings> 
 
        </telerik:RadGrid> 
      
      
    </div> 
      
    <asp:SqlDataSource ID="SqlDataSource_Release" runat="server" ConnectionString="<%$ ConnectionStrings:EMO_SCDB %>"   
        DeleteCommand="UPDATE [INT_SNS_RELEASE] SET [Status] = 'X' WHERE [Releasenummer] = @Releasenummer" 
        InsertCommand="INSERT INTO [INT_SNS_RELEASE] ([Partijnummer], [Mutatiecode], [Status], [Agent], [Monsteraar], [IJker], [Bestemming], [Periode_start], [Periode_eind], [Release_datum], [Klantreferentie1], [Klantreferentie2], [Klantreferentie3]) VALUES (@Partijnummer, @Mutatiecode, @Status, @Agent, @Monsteraar, @IJker, @Bestemming, @Periode_start, @Periode_eind, @Release_datum, @Klantreferentie1, @Klantreferentie2, @Klantreferentie3)" 
        UpdateCommand="UPDATE [INT_SNS_RELEASE] SET [Partijnummer] = @Partijnummer, [Mutatiecode] = @Mutatiecode, [Status] = @Status, [Agent] = @Agent, [Monsteraar] = @Monsteraar, [IJker] = @IJker, [Bestemming] = @Bestemming, [Periode_start] = @Periode_start, [Periode_eind] = @Periode_eind, [Release_datum] = @Release_datum, [Klantreferentie1] = @Klantreferentie1, [Klantreferentie2] = @Klantreferentie2, [Klantreferentie3] = @Klantreferentie3 WHERE [Releasenummer] = @Releasenummer"        
        SelectCommand="SELECT INT_SNS_RELEASE.Releasenummer, INT_SNS_RELEASE.Partijnummer, INT_SNS_RELEASE.Mutatiecode, INT_SNS_RELEASE.Status,   
                              INT_SNS_RELEASE.Agent, INT_SNS_RELEASE.Monsteraar, INT_SNS_RELEASE.IJker, INT_SNS_RELEASE.Bestemming,   
                              INT_SNS_RELEASE.Periode_start, INT_SNS_RELEASE.Periode_eind, INT_SNS_RELEASE.Released_tons, INT_SNS_RELEASE.Release_datum,   
                              INT_SNS_RELEASE.Klantreferentie1, INT_SNS_RELEASE.Klantreferentie2, INT_SNS_RELEASE.Klantreferentie3,   
                              dbo.ProperCase(DB_RELATIE_1.FIRMANAAM) AS Agent_Desc, dbo.ProperCase(DB_RELATIE_2.FIRMANAAM) AS Monsteraar_Desc,   
                              dbo.ProperCase(DB_RELATIE_3.FIRMANAAM) AS IJker_Desc,  
                              (CASE WHEN IsNull(PA.TON_VOORRAAD, 0) = 0 THEN .PA.TON_VOORRAAD_PLAN ELSE PA.TON_VOORRAAD END) AS VOORRAAD  
                       FROM   DB_RELATIE AS DB_RELATIE_2 RIGHT OUTER JOIN INT_SNS_RELEASE LEFT OUTER JOIN  
                              (SELECT DB_PARTIJ.PARTIJNUMMER, Sum(DB_VOORRAAD.TON_VOORRAAD) AS TON_VOORRAAD, Sum(DB_VOORRAAD.TON_VOORRAAD_PLAN) AS TON_VOORRAAD_PLAN, Sum(DB_VOORRAAD.TON_VOORRAAD_FIXED) AS TON_VOORRAAD_FIXED  
                               FROM DB_PARTIJ LEFT OUTER JOIN DB_VOORRAAD ON DB_PARTIJ.LADINGNUMMER = DB_VOORRAAD.LADINGNUMMER  
                               GROUP BY Partijnummer  
                              ) AS PA ON INT_SNS_RELEASE.Partijnummer = PA.PARTIJNUMMER LEFT OUTER JOIN  
                              DB_RELATIE AS DB_RELATIE_3 ON INT_SNS_RELEASE.IJker = DB_RELATIE_3.FIRMA_ID ON   
                              DB_RELATIE_2.FIRMA_ID = INT_SNS_RELEASE.Monsteraar LEFT OUTER JOIN  
                              DB_RELATIE AS DB_RELATIE_1 ON INT_SNS_RELEASE.Agent = DB_RELATIE_1.FIRMA_ID  
                       WHERE  (INT_SNS_RELEASE.Klant = @Current_ClientID)   
                          AND ((INT_SNS_RELEASE.Agent = @Current_GradeOperator) OR (1 = @Current_UseGradeOperatorFilter))  
                          AND (INT_SNS_RELEASE.Partijnummer = @Current_PartijNummer)  
                      "> 
        <SelectParameters> 
            <asp:SessionParameter SessionField="EMOServiceNET\Current\Client_ID"                    Name="Current_ClientID"  /> 
            <asp:SessionParameter SessionField="EMOServiceNET\Current\Login_ID"                     Name="Current_ShipOperator"  /> 
            <asp:SessionParameter SessionField="EMOServiceNET\Current\LoginRollUseAgentInSelect"    Name="Current_UseShipOperatorFilter"  /> 
            <asp:SessionParameter SessionField="EMOServiceNET\Current\Login_ID"                     Name="Current_GradeOperator"  /> 
            <asp:SessionParameter SessionField="EMOServiceNET\Current\LoginRollUseAgentInSelect"    Name="Current_UseGradeOperatorFilter"  /> 
            <asp:SessionParameter SessionField="EMOServiceNET\Current\Partij_ID"                    Name="Current_PartijNummer"  /> 
        </SelectParameters> 
        <UpdateParameters> 
            <asp:Parameter Name="Releasenummer" Type="Int32" /> 
            <asp:Parameter Name="Partijnummer" Type="Int32" /> 
            <asp:Parameter Name="Mutatiecode" Type="String" /> 
            <asp:Parameter Name="Status" Type="String" /> 
            <asp:Parameter Name="Agent" Type="String" /> 
            <asp:Parameter Name="Monsteraar" Type="String" /> 
            <asp:Parameter Name="IJker" Type="String" /> 
            <asp:Parameter Name="Bestemming" Type="String" /> 
            <asp:Parameter Name="Periode_start" Type="DateTime" /> 
            <asp:Parameter Name="Periode_eind" Type="DateTime" /> 
            <asp:Parameter Name="Release_datum" Type="DateTime" /> 
            <asp:Parameter Name="Klantreferentie1" Type="String" /> 
            <asp:Parameter Name="Klantreferentie2" Type="String" /> 
            <asp:Parameter Name="Klantreferentie3" Type="String" /> 
        </UpdateParameters> 
        <InsertParameters> 
            <asp:Parameter Name="Releasenummer" Type="Int32" /> 
            <asp:Parameter Name="Partijnummer" Type="Int32" /> 
            <asp:Parameter Name="Mutatiecode" Type="String" /> 
            <asp:Parameter Name="Status" Type="String" /> 
            <asp:Parameter Name="Agent" Type="String" /> 
            <asp:Parameter Name="Monsteraar" Type="String" /> 
            <asp:Parameter Name="IJker" Type="String" /> 
            <asp:Parameter Name="Bestemming" Type="String" /> 
            <asp:Parameter Name="Periode_start" Type="DateTime" /> 
            <asp:Parameter Name="Periode_eind" Type="DateTime" /> 
            <asp:Parameter Name="Release_datum" Type="DateTime" /> 
            <asp:Parameter Name="Klantreferentie1" Type="String" /> 
            <asp:Parameter Name="Klantreferentie2" Type="String" /> 
            <asp:Parameter Name="Klantreferentie3" Type="String" /> 
        </InsertParameters> 
    </asp:SqlDataSource> 
 
    <asp:SqlDataSource ID="SqlDataSource_Stem" runat="server" ConnectionString="<%$ ConnectionStrings:EMO_SCDB %>"   
        DeleteCommand="UPDATE [INT_SNS_STEMAANVRAAG] SET [Status] = 'X' WHERE [Stemaanvraagnummer] = @Stemaanvraagnummer"   
        InsertCommand="INSERT INTO [INT_SNS_STEMAANVRAAG] ([Releasenummer], [Ladingnummer], [Status], [Agent], [Monsteraar], [IJker], [Opmerking_agent], [Opmerking_EMO], [Tons], [Mutatiecode], [Klantreferentie1], [Klantreferentie2], [Klantreferentie3]) VALUES (@Releasenummer, @Ladingnummer, @Status, @Agent, @Monsteraar, @IJker, @Opmerking_agent, @Opmerking_EMO, @Tons, @Mutatiecode, @Klantreferentie1, @Klantreferentie2, @Klantreferentie3)"   
        SelectCommand="SELECT [Stemaanvraagnummer], [Releasenummer], [Ladingnummer], [Status], [Agent], [Monsteraar], [IJker], [Opmerking_agent], [Opmerking_EMO], [Tons], [Mutatiecode], [Klantreferentie1], [Klantreferentie2], [Klantreferentie3] FROM [INT_SNS_STEMAANVRAAG] WHERE [Releasenummer] = @Releasenummer"   
        UpdateCommand="UPDATE [INT_SNS_STEMAANVRAAG] SET [Releasenummer] = @Releasenummer, [Ladingnummer] = @Ladingnummer, [Status] = @Status, [Agent] = @Agent, [Monsteraar] = @Monsteraar, [IJker] = @IJker, [Opmerking_agent] = @Opmerking_agent, [Opmerking_EMO] = @Opmerking_EMO, [Tons] = @Tons, [Mutatiecode] = @Mutatiecode, [Klantreferentie1] = @Klantreferentie1, [Klantreferentie2] = @Klantreferentie2, [Klantreferentie3] = @Klantreferentie3 WHERE [Stemaanvraagnummer] = @Stemaanvraagnummer" 
        > 
        <SelectParameters> 
            <asp:SessionParameter Name="Releasenummer" SessionField="Releasenummer" /> 
        </SelectParameters> 
        <DeleteParameters> 
            <asp:Parameter Name="Stemaanvraagnummer" Type="Int32" /> 
        </DeleteParameters> 
        <UpdateParameters> 
            <asp:Parameter Name="Releasenummer" Type="Int32" /> 
            <asp:Parameter Name="Ladingnummer" Type="Int32" /> 
            <asp:Parameter Name="Status" Type="String" /> 
            <asp:Parameter Name="Agent" Type="String" /> 
            <asp:Parameter Name="Monsteraar" Type="String" /> 
            <asp:Parameter Name="IJker" Type="String" /> 
            <asp:Parameter Name="Opmerking_agent" Type="String" /> 
            <asp:Parameter Name="Opmerking_EMO" Type="String" /> 
            <asp:Parameter Name="Tons" Type="Int32" /> 
            <asp:Parameter Name="Mutatiecode" Type="String" /> 
            <asp:Parameter Name="Klantreferentie1" Type="String" /> 
            <asp:Parameter Name="Klantreferentie2" Type="String" /> 
            <asp:Parameter Name="Klantreferentie3" Type="String" /> 
            <asp:Parameter Name="Stemaanvraagnummer" Type="Int32" /> 
        </UpdateParameters> 
        <InsertParameters> 
            <asp:Parameter Name="Releasenummer" Type="Int32" /> 
            <asp:Parameter Name="Ladingnummer" Type="Int32" /> 
            <asp:Parameter Name="Status" Type="String" /> 
            <asp:Parameter Name="Agent" Type="String" /> 
            <asp:Parameter Name="Monsteraar" Type="String" /> 
            <asp:Parameter Name="IJker" Type="String" /> 
            <asp:Parameter Name="Opmerking_agent" Type="String" /> 
            <asp:Parameter Name="Opmerking_EMO" Type="String" /> 
            <asp:Parameter Name="Tons" Type="Int32" /> 
            <asp:Parameter Name="Mutatiecode" Type="String" /> 
            <asp:Parameter Name="Klantreferentie1" Type="String" /> 
            <asp:Parameter Name="Klantreferentie2" Type="String" /> 
            <asp:Parameter Name="Klantreferentie3" Type="String" /> 
        </InsertParameters> 
    </asp:SqlDataSource> 
 
    <asp:SqlDataSource ID="SqlDataSource_PartijLading" runat="server" ConnectionString="<%$ ConnectionStrings:EMO_SCDB %>"   
        SelectCommand="SELECT DB_PARTIJ.LADINGNUMMER, DB_PARTIJ.LADING_SOORT, dbo.ProperCase(DB_PARTIJ.LADING_SOORT) + ' (' + RTrim(Convert(char, (CASE WHEN IsNull(DB_VOORRAAD.TON_VOORRAAD, 0) = 0 THEN IsNull(TON_VOORRAAD_PLAN, 0) ELSE DB_VOORRAAD.TON_VOORRAAD END))) + ')' AS lading_soort_Desc,  
                              CASE WHEN IsNull(DB_VOORRAAD.TON_VOORRAAD, 0) = 0 THEN IsNull(TON_VOORRAAD_PLAN, 0) ELSE DB_VOORRAAD.TON_VOORRAAD END AS VR  
                       FROM   DB_PARTIJ LEFT OUTER JOIN DB_VOORRAAD ON DB_PARTIJ.LADINGNUMMER = DB_VOORRAAD.LADINGNUMMER  
                       WHERE  (DB_PARTIJ.KLANT_ID = @Current_ClientID)   
                          AND ((DB_PARTIJ.AGENT_ID = @Current_GradeOperator) OR (1=@Current_UseGradeOperatorFilter))   
                          AND (DB_PARTIJ.PARTIJNUMMER = @Current_PartijNummer)  
                      "> 
        <SelectParameters> 
            <asp:SessionParameter SessionField="EMOServiceNET\Current\Client_ID"                    Name="Current_ClientID"  /> 
            <asp:SessionParameter SessionField="EMOServiceNET\Current\Login_ID"                     Name="Current_ShipOperator"  /> 
            <asp:SessionParameter SessionField="EMOServiceNET\Current\LoginRollUseAgentInSelect"    Name="Current_UseShipOperatorFilter"  /> 
            <asp:SessionParameter SessionField="EMOServiceNET\Current\Login_ID"                     Name="Current_GradeOperator"  /> 
            <asp:SessionParameter SessionField="EMOServiceNET\Current\LoginRollUseAgentInSelect"    Name="Current_UseGradeOperatorFilter"  /> 
            <asp:SessionParameter SessionField="EMOServiceNET\Current\Partij_ID"                    Name="Current_PartijNummer"  /> 
        </SelectParameters>          
    </asp:SqlDataSource> 
      
    <asp:SqlDataSource ID="SqlDataSource_Agent1" runat="server" ConnectionString="<%$ ConnectionStrings:EMO_SCDB %>"                                  
        SelectCommand="SELECT RTrim(FIRMA_ID) As FIRMA_ID, dbo.ProperCase(FIRMANAAM) As Naam  FROM DB_Relatie WHERE LTRIM(FIRMANAAM) <> '' AND agent_firma = 'J' Order By FIRMANAAM">  
    </asp:SqlDataSource> 
    <asp:SqlDataSource ID="SqlDataSource_Agent2" runat="server" ConnectionString="<%$ ConnectionStrings:EMO_SCDB %>"                                  
        SelectCommand="SELECT RTrim(FIRMA_ID) As FIRMA_ID, dbo.ProperCase(FIRMANAAM) As Naam  FROM DB_Relatie WHERE LTRIM(FIRMANAAM) <> '' AND agent_firma = 'J' Order By FIRMANAAM">  
    </asp:SqlDataSource> 
    <asp:SqlDataSource ID="SqlDataSource_Agent3" runat="server" ConnectionString="<%$ ConnectionStrings:EMO_SCDB %>"                                  
        SelectCommand="SELECT RTrim(FIRMA_ID) As FIRMA_ID, dbo.ProperCase(FIRMANAAM) As Naam  FROM DB_Relatie WHERE LTRIM(FIRMANAAM) <> '' AND agent_firma = 'J' Order By FIRMANAAM">  
    </asp:SqlDataSource> 
    <asp:SqlDataSource ID="SqlDataSource_Agent4" runat="server" ConnectionString="<%$ ConnectionStrings:EMO_SCDB %>"                                  
        SelectCommand="SELECT RTrim(FIRMA_ID) As FIRMA_ID, dbo.ProperCase(FIRMANAAM) As Naam  FROM DB_Relatie WHERE LTRIM(FIRMANAAM) <> '' AND agent_firma = 'J' Order By FIRMANAAM">  
    </asp:SqlDataSource> 
      
    </div> 
    </form> 
</body> 
</html> 
 

hope you can provide me with a solution...
0
Erik
Top achievements
Rank 2
answered on 06 Nov 2008, 11:23 AM
0
Cynthia
Top achievements
Rank 1
answered on 20 Apr 2018, 04:21 PM

can you post me the solution please? this link is not working...

Thanks!

Tags
Grid
Asked by
Erik
Top achievements
Rank 2
Answers by
Kevin Babcock
Top achievements
Rank 1
Princy
Top achievements
Rank 2
Erik
Top achievements
Rank 2
Cynthia
Top achievements
Rank 1
Share this question
or