Questions on UI for ASP.NET AJAX Forum

110,814 questions

1 answer

49 views

Not Existing BeforeClientDrop Property in Q2 2009

hi,

I am using latest RadControls for ASP.NET AJAX Q2 2009 SP1

    
             radTree.BeforeClientDrop = "BeforeDropHandler";  
        
              radTree.NodeContextClick += ContextClicked;  
        
            radTree.BeforeClientContextClick = "ContextMenuClick";

"this is Telerik.WebControls Version"
this property not existing latest RadControls for ASP.NET AJAX Q2 2009 SP1
how to use in this property in RadTreeView controls

Thanks & Regards
Vivekanandan.R

General Discussions

answered on 05 Nov 2009

2 answers

136 views

Hierarchical grid - Child refresh causes the initial grid state

Hi,
When I click on a child grid refresh button the whole grid is refreshed and returned to initial state instead of refreshing the child grid only. What could be aproblem.
Thank you,
p.s. Sorry for the long code. Please see below.
.aspx

    
            <%@ Page Title="" Language="C#" MasterPageFile="~/fyd_h.master" AutoEventWireup="true" 
        
                CodeFile="Schools.aspx.cs" Inherits="ContentPages_Management_Schools" %> 
        
            <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">  
        
                <telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxy1" runat="server">  
        
                    <AjaxSettings> 
        
                        <telerik:AjaxSetting AjaxControlID="RadComboBoxOwner">  
        
                            <UpdatedControls> 
        
                                <telerik:AjaxUpdatedControl ControlID="RadComboBoxOwner" /> 
        
                                <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> 
        
                            </UpdatedControls> 
        
                        </telerik:AjaxSetting> 
        
                        <telerik:AjaxSetting AjaxControlID="RadGrid1">  
        
                            <UpdatedControls> 
        
                                <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> 
        
                                <telerik:AjaxUpdatedControl ControlID="HiddenFieldGrid1" /> 
        
                            </UpdatedControls> 
        
                        </telerik:AjaxSetting> 
        
                        <telerik:AjaxSetting AjaxControlID="RadAjaxManagerProxy1">  
        
                            <UpdatedControls> 
        
                                <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> 
        
                                <telerik:AjaxUpdatedControl ControlID="HiddenFieldGrid1" /> 
        
                            </UpdatedControls> 
        
                        </telerik:AjaxSetting> 
        
                    </AjaxSettings> 
        
                </telerik:RadAjaxManagerProxy> 
        
                <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">  
        
                    <script type="text/javascript">  
        
                        function OnClientClose() {  
        
                            $find("<%= RadAjaxManager.GetCurrent(this).ClientID %>").ajaxRequest('refreshGrid');  
        
                        }  
        
                    </script> 
        
                </telerik:RadCodeBlock> 
        
                <telerik:RadComboBox ID="RadComboBoxOwner" runat="server" DataSourceID="LinqOwner" 
        
                    DataTextField="OrgName" DataValueField="OwnerID" AutoPostBack="true" AppendDataBoundItems="True" 
        
                    OnDataBound="RadComboBoxOwner_DataBound" Width="300px" OnSelectedIndexChanged="RadComboBoxOwner_SelectedIndexChanged">  
        
                    <Items> 
        
                        <telerik:RadComboBoxItem runat="server" Text=" - Select Trust -" Value="-1" /> 
        
                    </Items> 
        
                    <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> 
        
                </telerik:RadComboBox> 
        
                <asp:LoginView ID="LoginView1" runat="server">  
        
                    <RoleGroups> 
        
                        <asp:RoleGroup Roles="Admin">  
        
                            <ContentTemplate> 
        
                                &nbsp;&nbsp;&nbsp;<asp:LinkButton ID="LinkButtonTheme" runat="server" CausesValidation="False">Themes</asp:LinkButton> 
        
                                &nbsp;&nbsp;&nbsp;  
        
                                <asp:LinkButton ID="LinkButtonModule" runat="server" CausesValidation="False">Modules</asp:LinkButton> 
        
                                <telerik:RadToolTip ID="RadToolTipTheme" runat="server" RelativeTo="Element" Title="Theme Managment" 
        
                                    HideEvent="ManualClose" ShowEvent="OnClick" TargetControlID="LinkButtonTheme">  
        
                                    <telerik:RadGrid ID="RadGridTheme" runat="server" AllowPaging="True" DataSourceID="LinqTheme" 
        
                                        GridLines="None" AutoGenerateColumns="False">  
        
                                        <MasterTableView DataKeyNames="ThemeId" DataSourceID="LinqTheme" Name="Theme" CommandItemDisplay="Top" 
        
                                            CommandItemSettings-AddNewRecordText="Add New Theme" AllowAutomaticDeletes="True" 
        
                                            AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowFilteringByColumn="true">  
        
                                            <RowIndicatorColumn> 
        
                                                <HeaderStyle Width="20px"></HeaderStyle> 
        
                                            </RowIndicatorColumn> 
        
                                            <CommandItemSettings AddNewRecordText="Add New Theme"></CommandItemSettings> 
        
                                            <Columns> 
        
                                                <telerik:GridEditCommandColumn ButtonType="ImageButton">  
        
                                                </telerik:GridEditCommandColumn> 
        
                                                <telerik:GridBoundColumn DataField="ThemeId" DataType="System.Int32" HeaderText="ThemeId" 
        
                                                    ReadOnly="True" SortExpression="ThemeId" UniqueName="ThemeId" Display="False">  
        
                                                </telerik:GridBoundColumn> 
        
                                                <telerik:GridBoundColumn DataField="Name" HeaderText="Name" SortExpression="Name" 
        
                                                    UniqueName="Name" AutoPostBackOnFilter="True" CurrentFilterFunction="Contains">  
        
                                                </telerik:GridBoundColumn> 
        
                                                <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" ConfirmText="Are you sure you want to Delete?" 
        
                                                    Text="Delete" UniqueName="DeleteTheme">  
        
                                                </telerik:GridButtonColumn> 
        
                                            </Columns> 
        
                                            <EditFormSettings> 
        
                                                <EditColumn ButtonType="ImageButton">  
        
                                                </EditColumn> 
        
                                            </EditFormSettings> 
        
                                        </MasterTableView> 
        
                                    </telerik:RadGrid> 
        
                                </telerik:RadToolTip> 
        
                                <telerik:RadToolTip ID="RadToolTipModule" runat="server" HideEvent="ManualClose" 
        
                                    RelativeTo="Element" ShowEvent="OnClick" TargetControlID="LinkButtonModule" Title="Module Management">  
        
                                    <telerik:RadGrid ID="RadGridModule" runat="server" AllowPaging="True" DataSourceID="LinqModule" 
        
                                        GridLines="None" AutoGenerateColumns="False">  
        
                                        <MasterTableView DataKeyNames="ModuleId" DataSourceID="LinqModule" Name="Module" 
        
                                            CommandItemDisplay="Top" CommandItemSettings-AddNewRecordText="Add New Module" 
        
                                            AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" 
        
                                            AllowFilteringByColumn="True">  
        
                                            <RowIndicatorColumn> 
        
                                                <HeaderStyle Width="20px"></HeaderStyle> 
        
                                            </RowIndicatorColumn> 
        
                                            <CommandItemSettings AddNewRecordText="Add New Module"></CommandItemSettings> 
        
                                            <Columns> 
        
                                                <telerik:GridEditCommandColumn ButtonType="ImageButton">  
        
                                                </telerik:GridEditCommandColumn> 
        
                                                <telerik:GridBoundColumn DataField="ModuleId" DataType="System.Int32" HeaderText="ModuleId" 
        
                                                    ReadOnly="True" SortExpression="ModuleId" UniqueName="ModuleId" ForceExtractValue="Always" 
        
                                                    Display="False">  
        
                                                </telerik:GridBoundColumn> 
        
                                                <telerik:GridBoundColumn DataField="Name" HeaderText="Module" SortExpression="Name" 
        
                                                    UniqueName="ModuleName" AutoPostBackOnFilter="True" CurrentFilterFunction="Contains">  
        
                                                </telerik:GridBoundColumn> 
        
                                                <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" ConfirmText="Are you sure you want to Delete?" 
        
                                                    Text="Delete" UniqueName="DeleteModule">  
        
                                                </telerik:GridButtonColumn> 
        
                                            </Columns> 
        
                                            <EditFormSettings> 
        
                                                <EditColumn ButtonType="ImageButton">  
        
                                                </EditColumn> 
        
                                            </EditFormSettings> 
        
                                        </MasterTableView> 
        
                                    </telerik:RadGrid> 
        
                                </telerik:RadToolTip> 
        
                            </ContentTemplate> 
        
                        </asp:RoleGroup> 
        
                    </RoleGroups> 
        
                </asp:LoginView> 
        
                <telerik:RadGrid ID="RadGrid1" runat="server" OnNeedDataSource="RadGrid1_NeedDataSource" 
        
                    AutoGenerateColumns="False" GroupingEnabled="False" OnDetailTableDataBind="RadGrid1_DetailTableDataBind" 
        
                    GridLines="None" OnItemCommand="RadGrid1_ItemCommand"   
        
                OnItemDataBound="RadGrid1_ItemDataBound" ShowFooter="True" ShowStatusBar="True">  
        
                    <ExportSettings FileName="SchoolExport" IgnorePaging="True" OpenInNewWindow="True">  
        
                    </ExportSettings> 
        
                    <ValidationSettings ValidationGroup="School" /> 
        
                    <MasterTableView DataKeyNames="OrgID" Name="School" AllowFilteringByColumn="True" 
        
                        AllowPaging="True" CommandItemDisplay="Top" AllowSorting="True" InsertItemPageIndexAction="ShowItemOnCurrentPage">  
        
                        <RowIndicatorColumn> 
        
                            <HeaderStyle Width="20px" /> 
        
                        </RowIndicatorColumn> 
        
                        <DetailTables> 
        
                            <telerik:GridTableView runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" 
        
                                AllowAutomaticUpdates="True" AllowSorting="True" Caption="&lt;hr /&gt; School Ethnithity" 
        
                                CommandItemDisplay="Top" DataKeyNames="SchoolEthnicityId,SchoolId" DataSourceID="LinqSchoolEthnicity" 
        
                                Name="School Ethnithity" PageSize="16">  
        
                                <ParentTableRelation> 
        
                                    <telerik:GridRelationFields DetailKeyField="SchoolId" MasterKeyField="OrgID" /> 
        
                                </ParentTableRelation> 
        
                                <CommandItemSettings AddNewRecordText="Add New Ethnicity" /> 
        
                                <RowIndicatorColumn> 
        
                                    <HeaderStyle Width="20px" /> 
        
                                </RowIndicatorColumn> 
        
                                <ExpandCollapseColumn> 
        
                                    <HeaderStyle Width="20px" /> 
        
                                </ExpandCollapseColumn> 
        
                                <Columns> 
        
                                    <telerik:GridEditCommandColumn ButtonType="ImageButton">  
        
                                    </telerik:GridEditCommandColumn> 
        
                                    <telerik:GridBoundColumn AllowFiltering="False" DataField="SchoolEthnicityId" DataType="System.Int32" 
        
                                        HeaderText="Id" ReadOnly="True" SortExpression="SchoolEthnicityId" UniqueName="SchoolEthnicityId">  
        
                                    </telerik:GridBoundColumn> 
        
                                    <telerik:GridDropDownColumn DataField="EthnicityId" DataSourceID="LinqEthnicity" 
        
                                        DataType="System.Int32" HeaderText="Ethnicity" ListTextField="Ethnicity" ListValueField="EthnicityID" 
        
                                        SortExpression="EthnicityId" UniqueName="SchoolEthnicity">  
        
                                    </telerik:GridDropDownColumn> 
        
                                    <telerik:GridNumericColumn DataField="Percentage" DataType="System.Int32" HeaderText="Percentage" 
        
                                        NumericType="Percent" SortExpression="Percentage" UniqueName="Percentage">  
        
                                    </telerik:GridNumericColumn> 
        
                                    <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" ConfirmText="Are you sure you want to Delete?" 
        
                                        ConfirmTitle="Delete the School Ethnicity" Text="Delete" UniqueName="DeleteEthnicity">  
        
                                    </telerik:GridButtonColumn> 
        
                                </Columns> 
        
                                <EditFormSettings> 
        
                                    <EditColumn UniqueName="EditEthnithity">  
        
                                    </EditColumn> 
        
                                </EditFormSettings> 
        
                            </telerik:GridTableView> 
        
                            <telerik:GridTableView runat="server" Name="Course" AllowFilteringByColumn="True" 
        
                                DataKeyNames="CourseID,SchoolID" AllowCustomPaging="False" AllowSorting="True" 
        
                                AllowPaging="True" Caption="&lt;hr /&gt;COURSE" CommandItemDisplay="Top">  
        
                                <RowIndicatorColumn> 
        
                                    <HeaderStyle Width="20px" /> 
        
                                </RowIndicatorColumn> 
        
                                <ExpandCollapseColumn Visible="True">  
        
                                </ExpandCollapseColumn> 
        
                                <DetailTables> 
        
                                    <telerik:GridTableView runat="server" Caption="&lt;hr /&gt;COURSE - SURVEY" DataKeyNames="VoterID" 
        
                                        Name="Course Survey" CommandItemDisplay="Top">  
        
                                        <RowIndicatorColumn> 
        
                                            <HeaderStyle Width="20px" /> 
        
                                        </RowIndicatorColumn> 
        
                                        <ExpandCollapseColumn> 
        
                                            <HeaderStyle Width="20px" /> 
        
                                        </ExpandCollapseColumn> 
        
                                        <CommandItemSettings AddNewRecordText="Add New Survey" /> 
        
                                        <Columns> 
        
                                            <telerik:GridBoundColumn DataField="VoterID" DataType="System.Int32" HeaderText="VoterID" 
        
                                                ReadOnly="True" SortExpression="VoterID" UniqueName="cVoterID">  
        
                                            </telerik:GridBoundColumn> 
        
                                            <telerik:GridHyperLinkColumn DataTextField="Title" SortExpression="Title" Target="_blank" 
        
                                                UniqueName="CourseSurvey" DataNavigateUrlFields="VoterID" DataNavigateUrlFormatString="~/ContentPages/VoterAnswerReport_NoMaster.aspx?voterId={0}" 
        
                                                HeaderText="Survey">  
        
                                            </telerik:GridHyperLinkColumn> 
        
                                            <telerik:GridBoundColumn DataField="VoterDate" DataType="System.DateTime" HeaderText="VoterDate" 
        
                                                ReadOnly="True" SortExpression="VoterDate" UniqueName="cVoterDate">  
        
                                            </telerik:GridBoundColumn> 
        
                                            <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" ConfirmText="Are you sure you want to Delete?" 
        
                                                ConfirmTitle="Delete Survey" Text="Delete" UniqueName="cDeleteSurvey">  
        
                                            </telerik:GridButtonColumn> 
        
                                        </Columns> 
        
                                        <EditFormSettings> 
        
                                            <EditColumn UniqueName="EditCourseSurvey">  
        
                                            </EditColumn> 
        
                                        </EditFormSettings> 
        
                                    </telerik:GridTableView> 
        
                                </DetailTables> 
        
                                <CommandItemSettings AddNewRecordText="Add New Course" /> 
        
                                <Columns> 
        
                                    <telerik:GridEditCommandColumn ButtonType="ImageButton">  
        
                                    </telerik:GridEditCommandColumn> 
        
                                    <telerik:GridBoundColumn DataField="CourseID" DataType="System.Int32" HeaderText="ID" 
        
                                        ForceExtractValue="Always" ReadOnly="True" SortExpression="CourseID" UniqueName="CourseID" 
        
                                        AllowFiltering="False">  
        
                                    </telerik:GridBoundColumn> 
        
                                    <telerik:GridBoundColumn DataField="CourseName" HeaderText="Course" SortExpression="CourseName" 
        
                                        UniqueName="CourseName" AutoPostBackOnFilter="True" CurrentFilterFunction="Contains" 
        
                                        ReadOnly="True">  
        
                                    </telerik:GridBoundColumn> 
        
                                    <telerik:GridDateTimeColumn DataField="StartDate" DataFormatString="{0:d}" DataType="System.DateTime" 
        
                                        HeaderText="Start Date" SortExpression="StartDate" UniqueName="StartDate" AutoPostBackOnFilter="True" 
        
                                        CurrentFilterFunction="EqualTo">  
        
                                    </telerik:GridDateTimeColumn> 
        
                                    <telerik:GridDateTimeColumn DataField="GraduationDate" DataFormatString="{0:d}" DataType="System.DateTime" 
        
                                        HeaderText="Finish Date" SortExpression="GraduationDate" UniqueName="FinishDate" 
        
                                        AutoPostBackOnFilter="True" CurrentFilterFunction="EqualTo">  
        
                                    </telerik:GridDateTimeColumn> 
        
                                    <telerik:GridDropDownColumn DataField="ProgramId" DataSourceID="LinqProgrames" HeaderText="Programme" 
        
                                        ListTextField="ProgramName" ListValueField="ProgramId" UniqueName="CourseProgramme">  
        
                                    </telerik:GridDropDownColumn> 
        
                                    <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" Text="Delete" 
        
                                        UniqueName="DeleteCourse" ConfirmText="Are you sure you want to Delete?" ConfirmTitle="Delete Course">  
        
                                    </telerik:GridButtonColumn> 
        
                                </Columns> 
        
                                <EditFormSettings> 
        
                                    <EditColumn UniqueName="EditCourse">  
        
                                    </EditColumn> 
        
                                </EditFormSettings> 
        
                            </telerik:GridTableView> 
        
                            <telerik:GridTableView runat="server" Name="Term" DataKeyNames="TermId" CommandItemDisplay="Top" 
        
                                Caption="&lt;hr /&gt;TERMS" Summary="Kiwi Can">  
        
                                <RowIndicatorColumn> 
        
                                    <HeaderStyle Width="20px" /> 
        
                                </RowIndicatorColumn> 
        
                                <ExpandCollapseColumn> 
        
                                    <HeaderStyle Width="20px" /> 
        
                                </ExpandCollapseColumn> 
        
                                <DetailTables> 
        
                                    <telerik:GridTableView runat="server" Caption="&lt;hr /&gt;TERMS - SURVEY" DataKeyNames="VoterID" 
        
                                        Name="Term Survey" CommandItemDisplay="Top">  
        
                                        <RowIndicatorColumn> 
        
                                            <HeaderStyle Width="20px" /> 
        
                                        </RowIndicatorColumn> 
        
                                        <ExpandCollapseColumn> 
        
                                            <HeaderStyle Width="20px" /> 
        
                                        </ExpandCollapseColumn> 
        
                                        <CommandItemSettings AddNewRecordText="Add New Survey" /> 
        
                                        <Columns> 
        
                                            <telerik:GridBoundColumn DataField="VoterID" DataType="System.Int32" HeaderText="VoterID" 
        
                                                ReadOnly="True" SortExpression="VoterID" UniqueName="tVoterID">  
        
                                            </telerik:GridBoundColumn> 
        
                                            <telerik:GridHyperLinkColumn DataTextField="Title" SortExpression="Title" Target="_blank" 
        
                                                UniqueName="TermSurvey" DataNavigateUrlFields="VoterID" DataNavigateUrlFormatString="~/ContentPages/VoterAnswerReport_NoMaster.aspx?voterId={0}" 
        
                                                HeaderText="Survey">  
        
                                            </telerik:GridHyperLinkColumn> 
        
                                            <telerik:GridBoundColumn DataField="VoterDate" DataType="System.DateTime" HeaderText="VoterDate" 
        
                                                ReadOnly="True" SortExpression="VoterDate" UniqueName="tVoterDate">  
        
                                            </telerik:GridBoundColumn> 
        
                                            <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" ConfirmText="Are you sure you want to Delete?" 
        
                                                ConfirmTitle="Delete Survey" Text="Delete" UniqueName="tDeleteSurvey">  
        
                                            </telerik:GridButtonColumn> 
        
                                        </Columns> 
        
                                        <EditFormSettings> 
        
                                            <EditColumn UniqueName="EditTermSurvey">  
        
                                            </EditColumn> 
        
                                        </EditFormSettings> 
        
                                    </telerik:GridTableView> 
        
                                </DetailTables> 
        
                                <CommandItemSettings AddNewRecordText="Add New Term"></CommandItemSettings> 
        
                                <Columns> 
        
                                    <telerik:GridEditCommandColumn ButtonType="ImageButton">  
        
                                    </telerik:GridEditCommandColumn> 
        
                                    <telerik:GridBoundColumn AllowFiltering="False" DataField="TermId" DataType="System.Int32" 
        
                                        HeaderText="TermId" ReadOnly="True" UniqueName="TermId" ForceExtractValue="Always">  
        
                                    </telerik:GridBoundColumn> 
        
                                    <telerik:GridBoundColumn AutoPostBackOnFilter="True" CurrentFilterFunction="Contains" 
        
                                        DataField="Term" HeaderText="Term" SortExpression="Term" UniqueName="Term" ReadOnly="True">  
        
                                    </telerik:GridBoundColumn> 
        
                                    <telerik:GridTemplateColumn DataField="Suffix" DataType="System.Int32" Display="False" 
        
                                        ForceExtractValue="InEditMode" HeaderText="Suffix" UniqueName="Suffix" EditFormHeaderTextFormat="Term:" 
        
                                        SortExpression="Suffix">  
        
                                        <EditItemTemplate> 
        
                                            <telerik:RadComboBox ID="SuffixRadComboBox" runat="server" SelectedValue='<%# Bind("Suffix") %>'>  
        
                                                <Items> 
        
                                                    <telerik:RadComboBoxItem runat="server" Text="1" Value="1" /> 
        
                                                    <telerik:RadComboBoxItem runat="server" Text="2" Value="2" /> 
        
                                                    <telerik:RadComboBoxItem runat="server" Text="3" Value="3" /> 
        
                                                    <telerik:RadComboBoxItem runat="server" Text="4" Value="4" /> 
        
                                                </Items> 
        
                                            </telerik:RadComboBox> 
        
                                        </EditItemTemplate> 
        
                                        <ItemTemplate> 
        
                                            <asp:Label ID="SuffixLabel" runat="server" Text='<%# Eval("Suffix") %>'></asp:Label> 
        
                                        </ItemTemplate> 
        
                                    </telerik:GridTemplateColumn> 
        
                                    <telerik:GridDropDownColumn DataField="Year" DataSourceID="LinqYear" DataType="System.Int32" 
        
                                        Display="False" HeaderText="Year" UniqueName="Year">  
        
                                    </telerik:GridDropDownColumn> 
        
                                    <telerik:GridBoundColumn DataField="ThemeId" DataType="System.UInt32" Display="False" 
        
                                        ForceExtractValue="Always" ReadOnly="True" UniqueName="ThemeId" HeaderText="ThemeId">  
        
                                    </telerik:GridBoundColumn> 
        
                                    <telerik:GridDropDownColumn AutoPostBackOnFilter="true" DataSourceID="LinqTheme" 
        
                                        UniqueName="Theme" DataField="ThemeId" ListValueField="ThemeId" CurrentFilterFunction="Contains" 
        
                                        ListTextField="Name" HeaderText="Theme">  
        
                                    </telerik:GridDropDownColumn> 
        
                                    <telerik:GridTemplateColumn HeaderText="Modules" UniqueName="Modules" EditFormColumnIndex="1" 
        
                                        SortExpression="Modules">  
        
                                        <EditItemTemplate> 
        
                                            <asp:CheckBoxList ID="CheckBoxList2" runat="server" DataSourceID="LinqModule" DataTextField="Name" 
        
                                                DataValueField="ModuleId" RepeatColumns="4">  
        
                                            </asp:CheckBoxList> 
        
                                        </EditItemTemplate> 
        
                                        <ItemTemplate> 
        
                                            <asp:Label runat="server" Text='<%# Eval("Modules") %>'></asp:Label> 
        
                                        </ItemTemplate> 
        
                                    </telerik:GridTemplateColumn> 
        
                                    <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" ConfirmText="Are you sure you want Delete?" 
        
                                        ConfirmTitle="Delete Term" Text="Delete" UniqueName="DeleteTerm">  
        
                                    </telerik:GridButtonColumn> 
        
                                </Columns> 
        
                                <EditFormSettings ColumnNumber="2">  
        
                                    <EditColumn UniqueName="EditTerm">  
        
                                    </EditColumn> 
        
                                </EditFormSettings> 
        
                            </telerik:GridTableView> 
        
                        </DetailTables> 
        
                        <CommandItemSettings AddNewRecordText="Add New School"></CommandItemSettings> 
        
                        <ExpandCollapseColumn Visible="True">  
        
                        </ExpandCollapseColumn> 
        
                        <Columns> 
        
                            <telerik:GridEditCommandColumn ButtonType="ImageButton">  
        
                            </telerik:GridEditCommandColumn> 
        
                            <telerik:GridBoundColumn DataField="OrgID" DataType="System.Int32" HeaderText="ID" 
        
                                ReadOnly="True" SortExpression="OrgID" UniqueName="OrgID" AutoPostBackOnFilter="True" 
        
                                ForceExtractValue="Always" FilterControlWidth="30px">  
        
                            </telerik:GridBoundColumn> 
        
                            <telerik:GridTemplateColumn DataField="OrgName" HeaderText="School" SortExpression="OrgName" 
        
                                UniqueName="OrgName" Display="False">  
        
                                <EditItemTemplate> 
        
                                    <asp:TextBox ID="OrgNameTextBox" runat="server" Text='<%# Bind("OrgName") %>'></asp:TextBox> 
        
                                    <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="OrgNameTextBox" 
        
                                        ErrorMessage="School Name" ValidationGroup="School">*</asp:RequiredFieldValidator> 
        
                                </EditItemTemplate> 
        
                                <ItemTemplate> 
        
                                    <asp:Label ID="OrgNameLabel" runat="server" Text='<%# Eval("OrgName") %>'></asp:Label> 
        
                                </ItemTemplate> 
        
                            </telerik:GridTemplateColumn> 
        
                            <telerik:GridHyperLinkColumn DataNavigateUrlFields="OrgName" AutoPostBackOnFilter="True" 
        
                                DataTextField="OrgName" Target="_blank" UniqueName="WebInfo" HeaderText="School" 
        
                                DataNavigateUrlFormatString="http://www.tki.org.nz/e/schools/simple_search.php?ss_search_type=contain&ss_search_string={0}" 
        
                                DataTextFormatString="{0}" CurrentFilterFunction="Contains" HeaderTooltip="Click school name for more details" 
        
                                SortExpression="OrgName">  
        
                            </telerik:GridHyperLinkColumn> 
        
                            <telerik:GridNumericColumn AutoPostBackOnFilter="True" CurrentFilterFunction="EqualTo" 
        
                                DataField="Decile" DataType="System.Int32" HeaderText="Decile" SortExpression="Decile" 
        
                                UniqueName="Decile" FilterControlWidth="30px">  
        
                            </telerik:GridNumericColumn> 
        
                            <telerik:GridNumericColumn AutoPostBackOnFilter="True" CurrentFilterFunction="GreaterThan" 
        
                                DataField="Enrol" DataType="System.Int32" HeaderText="Enrol" SortExpression="Enrol" 
        
                                UniqueName="Enrol" FilterControlWidth="30px">  
        
                            </telerik:GridNumericColumn> 
        
                            <telerik:GridTemplateColumn AutoPostBackOnFilter="True" CurrentFilterFunction="Contains" 
        
                                DataField="Type" HeaderText="Type" SortExpression="Type" UniqueName="SchoolType">  
        
                                <EditItemTemplate> 
        
                                    <telerik:RadComboBox ID="TypeRadComboBox" runat="server" AllowCustomText="True" DataSourceID="LinqSchoolType" 
        
                                        DataTextField="Type" DataValueField="Type" SelectedValue='<%# Bind("Type") %>'>  
        
                                    </telerik:RadComboBox> 
        
                                </EditItemTemplate> 
        
                                <ItemTemplate> 
        
                                    <asp:Label runat="server" Text='<%# Eval("Type") %>'></asp:Label> 
        
                                </ItemTemplate> 
        
                            </telerik:GridTemplateColumn> 
        
                            <telerik:GridTemplateColumn AutoPostBackOnFilter="True" DataField="PersonName" ReadOnly="true" 
        
                                HeaderText="Principal Name" SortExpression="PersonName" UniqueName="PersonName">  
        
                                <ItemTemplate> 
        
                                    <asp:LinkButton ID="LinkButtonPrincipal" runat="server" OnClientClick='<%# String.Format("radopen(\"peopleOrg.aspx?anybodyId={0}&orgId={1}&ownerId={2}\",\"RadWindow1\");", Eval("PersonId"),Eval("OrgID"),ownerId) %>' 
        
                                        Text='<%# String.IsNullOrEmpty((String)Eval("PersonName")) ? "Add Principal" : (String)Eval("PersonName") %>' 
        
                                        ToolTip="Click to View, Edit or Add"></asp:LinkButton> 
        
                                </ItemTemplate> 
        
                            </telerik:GridTemplateColumn> 
        
                            <telerik:GridBoundColumn DataField="AddressLine1" HeaderText="Address Line1" SortExpression="AddressLine1" 
        
                                AutoPostBackOnFilter="True" UniqueName="AddressLine1" EditFormColumnIndex="1" 
        
                                Display="False" ConvertEmptyStringToNull="False">  
        
                            </telerik:GridBoundColumn> 
        
                            <telerik:GridBoundColumn DataField="AddressLine2" HeaderText="Line2" SortExpression="AddressLine2" 
        
                                AutoPostBackOnFilter="True" UniqueName="AddressLine2" EditFormColumnIndex="1" 
        
                                ConvertEmptyStringToNull="False" Display="False">  
        
                            </telerik:GridBoundColumn> 
        
                            <telerik:GridTemplateColumn DataField="City" HeaderText="City" SortExpression="City" 
        
                                AutoPostBackOnFilter="True" UniqueName="City" EditFormColumnIndex="1" Display="False">  
        
                                <EditItemTemplate> 
        
                                    <asp:TextBox ID="CityTextBox" runat="server" Text='<%# Bind("City") %>'></asp:TextBox> 
        
                                    <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="CityTextBox" 
        
                                        ErrorMessage="City" ValidationGroup="School" Display="Dynamic">*</asp:RequiredFieldValidator> 
        
                                </EditItemTemplate> 
        
                                <ItemTemplate> 
        
                                    <asp:Label ID="CityLabel" runat="server" Text='<%# Eval("City") %>'></asp:Label> 
        
                                </ItemTemplate> 
        
                            </telerik:GridTemplateColumn> 
        
                            <telerik:GridBoundColumn DataField="PostCode" Display="False" HeaderText="PostCode" 
        
                                ConvertEmptyStringToNull="False" UniqueName="PostCode" EditFormColumnIndex="1">  
        
                            </telerik:GridBoundColumn> 
        
                            <telerik:GridBoundColumn DataField="AddressPhysical" HeaderText="Address Physical" 
        
                                AutoPostBackOnFilter="True" SortExpression="AddressPhysical" UniqueName="AddressPhysical" 
        
                                ReadOnly="True">  
        
                            </telerik:GridBoundColumn> 
        
                            <telerik:GridBoundColumn DataField="POBox" HeaderText="POBox" SortExpression="POBox" 
        
                                UniqueName="POBox" EditFormColumnIndex="1" Display="False" ConvertEmptyStringToNull="False">  
        
                            </telerik:GridBoundColumn> 
        
                            <telerik:GridMaskedColumn DataField="PhoneWork" HeaderText="Phone Work" SortExpression="PhoneWork" 
        
                                ConvertEmptyStringToNull="False" UniqueName="PhoneWork" Display="False" Mask="## ### #### a ######" 
        
                                EditFormColumnIndex="2">  
        
                            </telerik:GridMaskedColumn> 
        
                            <telerik:GridMaskedColumn DataField="Mobile" HeaderText="Mobile" SortExpression="Mobile" 
        
                                ConvertEmptyStringToNull="False" UniqueName="Mobile" Display="False" Mask="### ### ####" 
        
                                EditFormColumnIndex="2">  
        
                            </telerik:GridMaskedColumn> 
        
                            <telerik:GridBoundColumn DataField="Fax" HeaderText="Fax" SortExpression="Fax" UniqueName="Fax" 
        
                                ConvertEmptyStringToNull="False" AutoPostBackOnFilter="True" EditFormColumnIndex="2" 
        
                                Display="False">  
        
                            </telerik:GridBoundColumn> 
        
                            <telerik:GridTemplateColumn DataField="Email" EditFormColumnIndex="2" AutoPostBackOnFilter="True" 
        
                                ConvertEmptyStringToNull="False" HeaderText="Email" SortExpression="Email" UniqueName="Email">  
        
                                <EditItemTemplate> 
        
                                    <asp:TextBox ID="EmailTextBox" runat="server" Text='<%# Bind("Email") %>'></asp:TextBox> 
        
                                    <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="EmailTextBox" 
        
                                        ErrorMessage="People" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*">*</asp:RegularExpressionValidator> 
        
                                </EditItemTemplate> 
        
                                <ItemTemplate> 
        
                                    <asp:HyperLink ID="EmailHyperLink" runat="server" Text='<%# Eval("Email") %>' NavigateUrl='<%# String.Format("mailto:{0}", Eval("Email")) %>' /> 
        
                                </ItemTemplate> 
        
                            </telerik:GridTemplateColumn> 
        
                            <telerik:GridBoundColumn DataField="Programmes" HeaderText="Programmes" ReadOnly="True" 
        
                                UniqueName="SchoolProgrammes">  
        
                            </telerik:GridBoundColumn> 
        
                            <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" Text="Delete" 
        
                                UniqueName="DeleteSchool" ConfirmText="Are you sure you want to DELETE?" ConfirmTitle="Delete School">  
        
                            </telerik:GridButtonColumn> 
        
                        </Columns> 
        
                        <EditFormSettings ColumnNumber="3">  
        
                            <EditColumn UniqueName="EditSchool">  
        
                            </EditColumn> 
        
                            <PopUpSettings ScrollBars="None"></PopUpSettings> 
        
                        </EditFormSettings> 
        
                        <PagerStyle Mode="NextPrevNumericAndAdvanced" /> 
        
                    </MasterTableView> 
        
                </telerik:RadGrid> 
        
                <telerik:RadWindowManager ID="RadWindowManager1" runat="server">  
        
                    <Windows> 
        
                        <telerik:RadWindow ID="RadWindow1" runat="server" Modal="true" OnClientClose="OnClientClose" 
        
                            AutoSize="True" /> 
        
                    </Windows> 
        
                </telerik:RadWindowManager> 
        
                <asp:LinqDataSource ID="LinqOwner" runat="server" OnSelecting="LinqOwner_Selecting">  
        
                </asp:LinqDataSource> 
        
                <asp:LinqDataSource ID="LinqSchoolEthnicity" runat="server" ContextTypeName="FYDEvlDataContext" 
        
                    EnableDelete="True" EnableInsert="True" EnableUpdate="True" TableName="tblSchoolEthnicities" 
        
                    Where="SchoolId == @SchoolId">  
        
                    <WhereParameters> 
        
                        <asp:SessionParameter DefaultValue="-1" Name="SchoolId" SessionField="OrgID" Type="Int32" /> 
        
                    </WhereParameters> 
        
                </asp:LinqDataSource> 
        
                <asp:LinqDataSource ID="LinqSchoolType" runat="server" OnSelecting="LinqSchoolType_Selecting">  
        
                </asp:LinqDataSource> 
        
                <asp:LinqDataSource ID="LinqEthnicity" runat="server" ContextTypeName="FYDEvlDataContext" 
        
                    OrderBy="Ethnicity" Select="new (EthnicityID, Ethnicity)" TableName="tblEthnicities">  
        
                </asp:LinqDataSource> 
        
                <asp:LinqDataSource ID="LinqTheme" runat="server" ContextTypeName="FYDEvlDataContext" 
        
                    EnableDelete="True" EnableInsert="True" EnableUpdate="True" OrderBy="Name" TableName="tblThemes">  
        
                </asp:LinqDataSource> 
        
                <asp:LinqDataSource ID="LinqTerm" runat="server" ContextTypeName="FYDEvlDataContext" 
        
                    OrderBy="Name" TableName="tblTerms">  
        
                </asp:LinqDataSource> 
        
                <asp:LinqDataSource ID="LinqProgrames" runat="server" OnSelecting="LinqProgrames_Selecting">  
        
                </asp:LinqDataSource> 
        
                <asp:LinqDataSource ID="LinqModule" runat="server" ContextTypeName="FYDEvlDataContext" 
        
                    EnableDelete="True" EnableInsert="True" EnableUpdate="True" OrderBy="Name" TableName="tblModules">  
        
                </asp:LinqDataSource> 
        
                <asp:LinqDataSource ID="LinqYear" runat="server" OnSelecting="LinqYear_Selecting">  
        
                </asp:LinqDataSource> 
        
                <asp:HiddenField ID="HiddenFieldGrid1" runat="server" /> 
        
            </asp:Content>

.aspx.cs

    
            using System;  
        
            using System.Collections;  
        
            using System.Collections.Generic;  
        
            using System.Data.SqlClient;  
        
            using System.Globalization;  
        
            using System.Linq;  
        
            using System.Web.Security;  
        
            using System.Web.UI;  
        
            using System.Web.UI.WebControls;  
        
            using Telerik.Web.UI;  
        
            public partial class ContentPages_Management_Schools : System.Web.UI.Page  
        
            {  
        
                private FYDEvlDataContext db;  
        
                protected int ownerId  
        
                {  
        
                    get 
        
                    {  
        
                        if (RadComboBoxOwner.Visible)  
        
                        {  
        
                            return int.Parse(RadComboBoxOwner.SelectedValue);  
        
                        }  
        
                        else 
        
                        {  
        
                            return Profile.UserData.OwnerID;  
        
                        }  
        
                    }  
        
                }  
        
                private int orgIdEdit(GridCommandEventArgs e)  
        
                {  
        
                    GridDataItem parentItem = e.Item.OwnerTableView.ParentItem;  
        
                    return Int32.Parse(parentItem.OwnerTableView.DataKeyValues[parentItem.ItemIndex]["OrgID"].ToString());  
        
                }  
        
                protected void RadAjaxManager1_AjaxRequest(object sender, AjaxRequestEventArgs e)  
        
                {  
        
                    if (e.Argument.ToString().Equals("refreshGrid") && !String.IsNullOrEmpty(HiddenFieldGrid1.Value))  
        
                    {  
        
                        GridTableView tableView;  
        
                        tableView = this.Page.FindControl(HiddenFieldGrid1.Value) as GridTableView;  
        
                        tableView.Rebind();  
        
                        HiddenFieldGrid1.Value = String.Empty;  
        
                    }  
        
                }  
        
                protected void Page_Load(object sender, EventArgs e)  
        
                {  
        
                    RadAjaxManager manager = RadAjaxManager.GetCurrent(Page);  
        
                    manager.AjaxRequest += new RadAjaxControl.AjaxRequestDelegate(RadAjaxManager1_AjaxRequest);  
        
                    if (!IsPostBack)  
        
                    {  
        
                        if (User.IsInRole("Admin"))  
        
                        {  
        
                            RadComboBoxOwner.Visible = true;  
        
                        }  
        
                        else 
        
                        {  
        
                            RadComboBoxOwner.Visible = false;  
        
                        }  
        
                    }  
        
                } 
        
                #region Grid  
        
                protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)  
        
                {  
        
                    if (!e.IsFromDetailTable)  
        
                    {  
        
                        db = new FYDEvlDataContext();  
        
                        RadGrid1.DataSource = db.GetSchoolByOwner(ownerId);  
        
                    }  
        
                }  
        
                protected void RadGrid1_DetailTableDataBind(object source, Telerik.Web.UI.GridDetailTableDataBindEventArgs e)  
        
                {  
        
                    GridDataItem dataItem = (GridDataItem)e.DetailTableView.ParentItem;  
        
                    db = new FYDEvlDataContext();  
        
                    List<int> ownerInProgrammes = new List<int>(db.tblOwnerInProgrammes.Where(op => op.OwnerID.Equals(ownerId)).Select(op => op.tblProgram.ProgramID).ToArray<int>());  
        
                    switch (e.DetailTableView.Name)  
        
                    {  
        
                        case "Course":  
        
                            e.DetailTableView.DataSource = db.tblCourses.Where(c => c.SchoolID.Equals(Int32.Parse(dataItem.GetDataKeyValue("OrgID").ToString()))).Select(c => new { c.CourseID, c.CourseName, c.CourseSuffix, c.CourseYear, c.CreatedDate, c.GraduationDate, c.Graduated, c.ProgramId, c.SchoolID, c.StartDate, c.tblProgram.ProgramName }).OrderByDescending(c => c.CourseYear).ThenBy(c => c.CourseName);  
        
                            break;  
        
                        case "Course Survey":  
        
                            if (ownerInProgrammes.Contains(1) | ownerInProgrammes.Contains(4)) // 1-Stars 4-KiwiCan  
        
                            {  
        
                                e.DetailTableView.DataSource = db.tblpkVoters.Where(v => v.CourseId.Equals(Int32.Parse(dataItem.GetDataKeyValue("CourseID").ToString()))).Select(v => new { v.VoterID, v.SurveyID, v.vts_tbSurvey.Title, v.VoterDate });  
        
                                e.DetailTableView.Visible = true;  
        
                            }  
        
                            else 
        
                            {  
        
                                e.DetailTableView.Visible = false;  
        
                            }  
        
                            break;  
        
                        case "Term":  
        
                            if (db.tblOwnerInProgrammes.Where(op => op.OwnerID.Equals(ownerId)).Select(op => op.tblProgram.ProgramName).Contains("Kiwi Can"))  
        
                            {  
        
                                e.DetailTableView.DataSource = db.tblTerms.Where(t => t.OrganisationId.Equals(Int32.Parse(dataItem.GetDataKeyValue("OrgID").ToString()))).Select(t => new { t.TermId, Term = t.Name, t.Suffix, t.Year, ThemeId = t.tblTermThemeModules.Select(ttm => ttm.ThemeId).FirstOrDefault(), Theme = t.tblTermThemeModules.Select(ttm => ttm.tblTheme.Name).FirstOrDefault(), Modules = ConvertArray.ArrayToString(db.tblModules.Where(m => m.tblTermThemeModules.Any(ttm => ttm.TermId.Equals(t.TermId))).Select(m => m.Name).ToList(), "<br />") }).AsEnumerable().Distinct();  
        
                                e.DetailTableView.Visible = true;  
        
                            }  
        
                            else 
        
                            {  
        
                                e.DetailTableView.Visible = false;  
        
                            }  
        
                            break;  
        
                        case "Term Survey":  
        
                            if (ownerInProgrammes.Contains(4)) // 4-KiwiCan  
        
                            {  
        
                                e.DetailTableView.DataSource = db.tblpkVoters.Where(v => v.TermId.Equals(Int32.Parse(dataItem.GetDataKeyValue("TermId").ToString()))).Select(v => new { v.VoterID, v.SurveyID, v.vts_tbSurvey.Title, v.VoterDate });  
        
                                e.DetailTableView.Visible = true;  
        
                            }  
        
                            else 
        
                            {  
        
                                e.DetailTableView.Visible = false;  
        
                            }  
        
                            break;  
        
                    }  
        
                }  
        
                protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)  
        
                {  
        
                    GridDataItem parentItem = e.Item.OwnerTableView.ParentItem;  
        
                    if (!String.IsNullOrEmpty(RadGrid1.MasterTableView.Caption))  
        
                    {  
        
                        RadGrid1.MasterTableView.Caption = "";  
        
                    }  
        
                    //Single expand in hierarchical grid  
        
                    if (e.CommandName == RadGrid.ExpandCollapseCommandName)  
        
                    {  
        
                        foreach (GridItem item in e.Item.OwnerTableView.Items)  
        
                        {  
        
                            if (item.Expanded && item != e.Item)  
        
                            {  
        
                                item.Expanded = false;  
        
                            }  
        
                        }  
        
                    }  
        
                    if (e.CommandName.Equals(RadGrid.InitInsertCommandName))  
        
                    {  
        
                        if (e.Item.OwnerTableView.Items.Count.Equals(0))  
        
                        {  
        
                            e.Canceled = true;  
        
                            // If grid is empty  
        
                            // http://www.telerik.com/community/forums/aspnet/grid/insert-new-record-into-empty-grid.aspx  
        
                            //Prepare an IDictionary with the predefined values     
        
                            System.Collections.Specialized.ListDictionary newVal = new System.Collections.Specialized.ListDictionary();  
        
                            newVal["ThemeId"] = "1";  
        
                            newVal["Suffix"] = "1";  
        
                            newVal["Year"] = DateTime.Now.Year;  
        
                            e.Item.OwnerTableView.InsertItem(newVal);  
        
                        }  
        
                        switch (e.Item.OwnerTableView.Name)  
        
                        {  
        
                            case "Course Survey":  
        
                                {  
        
                                    e.Canceled = true;  
        
                                    HiddenFieldGrid1.Value = e.Item.OwnerID.Replace("_", "$");  
        
                                    string navigateUrl = string.Format("'SchoolCourseSurveyBox.aspx?SurveyList=Stars&courseId={0}&pkuId={1}'",  
        
                                                        Int32.Parse(parentItem.GetDataKeyValue("CourseID").ToString()),  
        
                                                        Int32.Parse(parentItem.OwnerTableView.ParentItem.GetDataKeyValue("OrgID").ToString()));  
        
                                    RadAjaxManager.GetCurrent(Page).ResponseScripts.Add("window.radopen(" + navigateUrl + ",'RadWindow1')");  
        
                                }  
        
                                break;  
        
                            case "Term Survey":  
        
                                {  
        
                                    e.Canceled = true;  
        
                                    HiddenFieldGrid1.Value = e.Item.OwnerID.Replace("_", "$");  
        
                                    string navigateUrl = string.Format("'SchoolCourseSurveyBox.aspx?SurveyList=KiwiCan&termId={0}&pkuId={1}'",  
        
                                                        Int32.Parse(parentItem.GetDataKeyValue("TermId").ToString()),  
        
                                                        Int32.Parse(parentItem.OwnerTableView.ParentItem.GetDataKeyValue("OrgID").ToString()));  
        
                                    RadAjaxManager.GetCurrent(Page).ResponseScripts.Add("window.radopen(" + navigateUrl + ",'RadWindow1')");  
        
                                }  
        
                                break;  
        
                        }  
        
                    }  
        
                    if (e.Item is GridEditableItem)  
        
                    {  
        
                        List<string> userRoles = Roles.GetRolesForUser(User.Identity.Name).ToList();  
        
                        if (  
        
                            (!userRoles.Any(ur => ur.Contains("Admin") | ur.Contains("Power Users"))) &&  
        
                            (e.CommandName.Equals(RadGrid.EditCommandName) | e.CommandName.Equals(RadGrid.DeleteCommandName) | e.CommandName.Equals(RadGrid.InitInsertCommandName)) &&  
        
                            (e.Item.OwnerTableView.Name.Equals("School") | e.Item.OwnerTableView.Name.Equals("Course") | e.Item.OwnerTableView.Name.Equals("Term"))  
        
                            )  
        
                        {  
        
                            e.Canceled = true;  
        
                            RadGrid1.MasterTableView.Caption = "<span style='color: #008000'>You don't have appropriate permission to perform this operation</span>";  
        
                        }  
        
                        Page.Validate("School");  
        
                        if (Page.IsValid)  
        
                        {  
        
                            db = new FYDEvlDataContext();  
        
                            if (e.Item.IsInEditMode && (e.CommandName.Equals(RadGrid.PerformInsertCommandName) | e.CommandName.Equals(RadGrid.UpdateCommandName)))  
        
                            {  
        
                                GridEditableItem editedItem = e.Item as GridEditableItem;  
        
                                Hashtable newValues = new Hashtable();  
        
                                e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editedItem);  
        
                                //Hashtable newValues = new Hashtable();  
        
                                //foreach (DictionaryEntry item in gridValues)  
        
                                //{  
        
                                //    newValues[item.Key.ToString()] = item.Value != null ? item.Value : "";  
        
                                //}  
        
                                DateTime valDateTime;  
        
                                CultureInfo MyCultureInfo = new CultureInfo("en-NZ");  
        
                                switch (e.Item.OwnerTableView.Name)  
        
                                {  
        
                                    case "School":  
        
                                        {  
        
                                            int? orgid = null;  
        
                                            if (e.CommandName.Equals(RadGrid.UpdateCommandName))  
        
                                            {  
        
                                                orgid = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["OrgID"] != null ? Int32.Parse(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["OrgID"].ToString()) : (int?)null;  
        
                                            }  
        
                                            orgid = db.AnybodyUpdateInsert(orgid, 2, newValues["OrgName"].ToString(), 4, "", "", "", "", (int?)null, (int?)null, (int?)null, (DateTime?)null, newValues["AddressLine1"].ToString(), newValues["AddressLine2"].ToString(), newValues["City"].ToString(), newValues["PostCode"].ToString(), "NZ", newValues["POBox"].ToString(), "", newValues["Email"].ToString(), "", newValues["PhoneWork"].ToString(), newValues["Mobile"].ToString(), newValues["Fax"].ToString(), ownerId);  
        
                                            //tblSchool  
        
                                            int? decile = newValues["Decile"] != null ? Int32.Parse(newValues["Decile"].ToString()) : (int?)null;  
        
                                            int? enrol = newValues["Enrol"] != null ? Int32.Parse(newValues["Enrol"].ToString()) : (int?)null;  
        
                                            string schoolType = (editedItem.FindControl("TypeRadComboBox") as RadComboBox).Text;  
        
                                            switch (e.CommandName)  
        
                                            {  
        
                                                case RadGrid.PerformInsertCommandName:  
        
                                                    {  
        
                                                        tblSchool school_i = new tblSchool();  
        
                                                        school_i.SchoolId = orgid.Value;  
        
                                                        school_i.Decile = decile;  
        
                                                        school_i.Enrol = enrol;  
        
                                                        school_i.Type = schoolType;  
        
                                                        db.tblSchools.InsertOnSubmit(school_i);  
        
                                                    }  
        
                                                    break;  
        
                                                case RadGrid.UpdateCommandName:  
        
                                                    {  
        
                                                        tblSchool school_u = db.tblSchools.Single(s => s.SchoolId.Equals(orgid));  
        
                                                        school_u.Decile = decile;  
        
                                                        school_u.Enrol = enrol;  
        
                                                        school_u.Type = schoolType;  
        
                                                    }  
        
                                                    break;  
        
                                            }  
        
                                        }  
        
                                        break;  
        
                                    case "Course":  
        
                                        {  
        
                                            int programId = Int32.Parse(newValues["ProgramId"].ToString());  
        
                                            DateTime? startDate = (DateTime.TryParse(newValues["StartDate"].ToString(), MyCultureInfo, DateTimeStyles.None, out valDateTime) ? valDateTime : (DateTime?)null); // (editedItem["StartDate"].Controls[0] as RadDatePicker).SelectedDate;  
        
                                            switch (e.CommandName)  
        
                                            {  
        
                                                case RadGrid.UpdateCommandName:  
        
                                                    {  
        
                                                        tblCourse course = db.tblCourses.First(c => c.CourseID.Equals(Int32.Parse(newValues["CourseID"].ToString())));  
        
                                                        course.ProgramId = programId;  
        
                                                        course.StartDate = startDate;  
        
                                                        course.GraduationDate = newValues["GraduationDate"] != null ? DateTime.Parse(newValues["GraduationDate"].ToString(), MyCultureInfo, DateTimeStyles.None) : (DateTime?)null;  
        
                                                    }  
        
                                                    break;  
        
                                                case RadGrid.PerformInsertCommandName:  
        
                                                    {  
        
                                                        tblCourse course = new tblCourse();  
        
                                                        course.SchoolID = orgIdEdit(e);  
        
                                                        course.ProgramId = programId;  
        
                                                        course.StartDate = startDate;  
        
                                                        db.tblCourses.InsertOnSubmit(course);  
        
                                                    }  
        
                                                    break;  
        
                                            }  
        
                                        }  
        
                                        break;  
        
                                    case "Term":  
        
                                        {  
        
                                            int themeid = Int32.Parse(newValues["ThemeId"].ToString());  
        
                                            string year = newValues["Year"].ToString();  
        
                                            CheckBoxList Check1 = editedItem.FindControl("CheckBoxList2") as CheckBoxList;  
        
                                            switch (e.CommandName)  
        
                                            {  
        
                                                case RadGrid.UpdateCommandName:  
        
                                                    {  
        
                                                        string suffix = newValues["Suffix"].ToString();  
        
                                                        int termId = Int32.Parse(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["TermId"].ToString());  
        
                                                        tblTerm term = db.tblTerms.First(t => t.TermId.Equals(termId) && t.OrganisationId.Equals(orgIdEdit(e)));  
        
                                                        term.Suffix = suffix;  
        
                                                        term.Year = year;  
        
                                                        var ttmodules = db.tblTermThemeModules.Where(ttm => ttm.TermId.Equals(termId));  
        
                                                        foreach (var vtt in ttmodules)  
        
                                                        {  
        
                                                            db.tblTermThemeModules.DeleteOnSubmit(vtt);  
        
                                                        }  
        
                                                        for (int i = 0; i < Check1.Items.Count; i++)  
        
                                                        {  
        
                                                            if (Check1.Items[i].Selected)  
        
                                                            {  
        
                                                                tblTermThemeModule tblttModule = new tblTermThemeModule();  
        
                                                                tblttModule.TermId = termId;  
        
                                                                tblttModule.ThemeId = themeid;  
        
                                                                tblttModule.ModuleId = Int32.Parse(Check1.Items[i].Value);  
        
                                                                db.tblTermThemeModules.InsertOnSubmit(tblttModule);  
        
                                                            }  
        
                                                        }  
        
                                                    }  
        
                                                    break;  
        
                                                case RadGrid.PerformInsertCommandName:  
        
                                                    {  
        
                                                        tblTerm term = new tblTerm();  
        
                                                        string suffix = newValues["Suffix"].ToString();  
        
                                                        term.Suffix = suffix;  
        
                                                        term.Year = year;  
        
                                                        term.OrganisationId = orgIdEdit(e);  
        
                                                        db.tblTerms.InsertOnSubmit(term);  
        
                                                        int themeId = themeid;  
        
                                                        if (Check1.SelectedItem != null)  
        
                                                        {  
        
                                                            for (int i = 0; i < Check1.Items.Count; i++)  
        
                                                            {  
        
                                                                if (Check1.Items[i].Selected)  
        
                                                                {  
        
                                                                    tblTermThemeModule ttm = new tblTermThemeModule();  
        
                                                                    ttm.tblTerm = term;  
        
                                                                    ttm.ThemeId = themeId;  
        
                                                                    ttm.ModuleId = Int32.Parse(Check1.Items[i].Value);  
        
                                                                    db.tblTermThemeModules.InsertOnSubmit(ttm);  
        
                                                                }  
        
                                                            }  
        
                                                        }  
        
                                                        else 
        
                                                        {  
        
                                                            tblTermThemeModule ttm = new tblTermThemeModule();  
        
                                                            ttm.tblTerm = term;  
        
                                                            ttm.ThemeId = themeId;  
        
                                                        }  
        
                                                    }  
        
                                                    break;  
        
                                            }  
        
                                        }  
        
                                        break;  
        
                                }  
        
                                db.SubmitChanges();  
        
                            }  
        
                        }  
        
                    }  
        
                    if (e.CommandName == RadGrid.DeleteCommandName)  
        
                    {  
        
                        switch (e.Item.OwnerTableView.Name)  
        
                        {  
        
                            case "School":  
        
                                {  
        
                                    db.sppkUID_d(Int32.Parse(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["OrgID"].ToString()));  
        
                                    RadGrid1.MasterTableView.Caption = "<span style='color: #008000'>School has been deleted.</span>";  
        
                                }  
        
                                break;  
        
                            case "Course":  
        
                                {  
        
                                    tblCourse course = db.tblCourses.Single(c => c.CourseID.Equals(Int32.Parse(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["CourseID"].ToString())));  
        
                                    db.tblCourses.DeleteOnSubmit(course);  
        
                                }  
        
                                break;  
        
                            case "Term":  
        
                                {  
        
                                    int termId = Int32.Parse(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["TermId"].ToString());  
        
                                    var terms = db.tblTerms.Where(t => t.TermId.Equals(termId));  
        
                                    foreach (var tm in terms)  
        
                                    {  
        
                                        db.tblTerms.DeleteOnSubmit(tm);  
        
                                    }  
        
                                }  
        
                                break;  
        
                        }  
        
                        if (e.Item.OwnerTableView.Name.Contains("Survey"))  
        
                        {  
        
                            IQueryable<tblpkVoter> pkvoters = db.tblpkVoters.Where(v => v.VoterID.Equals(Int32.Parse(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["VoterID"].ToString())));  
        
                            foreach (var voter in pkvoters)  
        
                            {  
        
                                db.tblpkVoters.DeleteOnSubmit(voter);  
        
                            }  
        
                        }  
        
                        try 
        
                        {  
        
                            db.SubmitChanges();  
        
                        }  
        
                        catch (SqlException)  
        
                        {  
        
                            RadGrid1.MasterTableView.Caption = "<span style='color: #FF0000'>Unable to delete. Reason: Some data is related to the this record.</span>";  
        
                        }  
        
                    }  
        
                }  
        
                protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)  
        
                {  
        
                    if (e.Item is GridEditFormItem && e.Item.IsInEditMode)  
        
                    {  
        
                        if (!e.Item.DataItem.GetType().Name.Equals("GridInsertionObject"))  
        
                        {  
        
                            GridEditFormItem editFormItem = e.Item as GridEditFormItem;  
        
                            switch (e.Item.OwnerTableView.Name)  
        
                            {  
        
                                case "Term":  
        
                                    int termId = Int32.Parse(editFormItem.OwnerTableView.DataKeyValues[editFormItem.ItemIndex]["TermId"].ToString());  
        
                                    CheckBoxList _CheckBoxList2 = editFormItem.FindControl("CheckBoxList2") as CheckBoxList;  
        
                                    var sModules = db.tblTermThemeModules.Where(m => m.TermId.Equals(termId));  
        
                                    foreach (var v in sModules)  
        
                                    {  
        
                                        try 
        
                                        {  
        
                                            ListItem _CheckItem = _CheckBoxList2.Items.FindByValue(v.ModuleId.Value.ToString());  
        
                                            _CheckItem.Selected = true;  
        
                                        }  
        
                                        catch (Exception)  
        
                                        {  
        
                                        }  
        
                                    }  
        
                                    break;  
        
                            }  
        
                        }  
        
                    }  
        
                } 
        
                #endregion  
        
                protected void RadComboBoxOwner_DataBound(object sender, EventArgs e)  
        
                {  
        
                    if (User.IsInRole("Admin"))  
        
                    {  
        
                        RadComboBoxItem item = RadComboBoxOwner.Items.FindItemByValue(ownerId.ToString());  
        
                        item.Selected = true;  
        
                    }  
        
                }  
        
                protected void RadComboBoxOwner_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)  
        
                {  
        
                    RadGrid1.Rebind();  
        
                }  
        
                protected void LinqOwner_Selecting(object sender, LinqDataSourceSelectEventArgs e)  
        
                {  
        
                    e.Result = db.tblOwners.Select(s => new { s.OwnerID, s.tblOrganisation.OrgName }).OrderBy(s => s.OrgName).Distinct();  
        
                }  
        
                protected void LinqProgrames_Selecting(object sender, LinqDataSourceSelectEventArgs e)  
        
                {  
        
                    e.Result = db.GetProgramsByOwner(ownerId);  
        
                }  
        
                protected void LinqYear_Selecting(object sender, LinqDataSourceSelectEventArgs e)  
        
                {  
        
                    CurrentYears years = new CurrentYears();  
        
                    e.Result = years.Years().OrderByDescending(y => y);  
        
                }  
        
                protected void LinqSchoolType_Selecting(object sender, LinqDataSourceSelectEventArgs e)  
        
                {  
        
                    db = new FYDEvlDataContext();  
        
                    e.Result = db.tblSchools.Where(s => s.Type.Trim().Length > 1).OrderBy(s => s.Type).Select(s => new { s.Type }).Distinct();  
        
                }  
        
            }

Grid

answered on 05 Nov 2009

1 answer

118 views

Tab with matching pageview

I have a tabstrip control with 5 tabs, and a Multipage object with 5 pageview. So each tab matches one pageview.

However, if I make the first tab visible=false so that the second tab becomes the first tab, the first pageview is now under the second tab. I can't figure out a way to hide the pageview as well.

So how do I hide the first tab and also make the pageview matching correctly to its original tab?

Thanks!

TabStrip

answered on 05 Nov 2009

2 answers

159 views

RadComboBox problem

I have a problem with a RadComboBox creating a scroll in a popup as soon as data gets filled in multiple rows, the ui on the combo box also breaks where it creates a weird height and the arrow drop down image becomes broken.

If I set visible to false inside the radcomboBox column it fixes it. Not sure what is going on, any help on this issue is appraciated.

Thank you.

Code sample below.

<telerik:GridTemplateColumn HeaderStyle-Width="40%" HeaderText="<% $Resources:PageControls, CoverageLevel %>">
                                            <ItemTemplate>
                                                <telerik:RadComboBox ID="cmbZoneCoverage" runat="server" EnableEmbeddedSkins="false"
                                                    Skin="Premise" Width="200px" />
                                            </ItemTemplate>
                                        </telerik:GridTemplateColumn>

ComboBox

answered on 05 Nov 2009

1 answer

197 views

How do I set file to upload path from server?

How do I set the path displayed in the upload control from server-side?
I want a user to select a file to upload, and after user selected a file, I use an Ajax request to send the file info to server side.
After a postback by a button, I want to set the radUpload control to still display the path previously selected by the user.

Upload (Obsolete)

answered on 05 Nov 2009

3 answers

187 views

control ID

Hi,

I am getting a issue as "Multiple Controls with same Id". Find control requires Unique Control id's.

I am not setting any control ids through code. But i do not know where these are getting set and exception are getting thrown.

Help me out as quick as possible.

Thnx in advance.

General Discussions

answered on 05 Nov 2009

3 answers

127 views

Files arent getting uploaded

Hi,
I am trying to upload files (.zip/.doc of max size 250MB). But not being able to upload. RadUpload.UploadedFiles.Count is always 0.

Can somebody please help me with this?

PFB my code :

aspx :
<telerik:RadUpload ID="RadUpload" Runat="server"

ControlObjectsVisibility="None"

OverwriteExistingFiles="false"

AllowedFileExtensions=".zip" ForeColor="#00CC00" MaxFileSize="409600"

MaxFileInputsCount="1" TargetFolder="~/bin">

</telerik:RadUpload>

.cs :

protected

void btnUploaded_Click(object sender, EventArgs e)

{

if (rulTaxForms.UploadedFiles.Count> 0)

{

}

Upload (Obsolete)

answered on 05 Nov 2009

1 answer

95 views

Child item opens over instead of displacing other items

Hi

Urgent problem.. about to go live!

I have a master page with a panel bar as menu that has been working for some months.
Today it has developed a strange problem on my development machine:
When you click a top level item, the child items open in in a layer above the subsequent item,
and only shows as text (no bar background image). It does not displace lower items downwards.

It seems like ajax not quite working.

I tried two things:

1 ) I copied back a working version from my remote server
It still doesn't work on the development machine, so it looks like the page itslef is OK.

2 ) I created a Panel bar on a test page on my local machine - it works normally

I am baffled, and don't know where to look. Can you suggest where to start looking?

I am using the latest hotfix, downloaded last week

Thanks for urgent response!

Clive

PanelBar

answered on 05 Nov 2009

3 answers

243 views

Google Maps API in MultiPage

Hi,

I have been having trouble adding a Google Maps APi to a MultiPage and TabStrip. If the Google Maps is in the selected index 0, that is the first page everything works fine, but if I have the map in a different page, say index 1 or 2 the map appears but it does not work properly. I also have a asp button in the same page of the map, which for the moment has no function, if I press it the page reloads and the map works fine.
Thanks...
Paco Valverde

TabStrip

answered on 05 Nov 2009

5 answers

150 views

Telerik webparts personalization

The issue which we are facing while working on Telerik web parts personalization is, we are not able to save current position of web parts.

We need to save state of a particular web part in each and every drag drop, for that we have attached “OnDockPositionChanged” to every RadDock control, but this event is not getting fired while moving the web parts.

So please suggest that:

1. Which event should be used to save state for every movement.

2. What is the ideal approach to implement personalization using database.

Thanks in advance.

Parimal Modi

Dock