Questions on UI for ASP.NET AJAX Forum

110,829 questions

2 answers

108 views

BackGround Image

Hi,

I have a dock,with exapnd/collapse buttons.
i need to apply images for the expand/collapse buttons
but i'am unable to do so by setting the background-image for rdcollapse in the style.

.rdTitlebar,.rdTitle,

{

color:#525E75 !important;

font-family:Trebuchet MS !important;

font-weight: bold !important;

}

.rdCollapse

{

background-image:url('C:\SaaS\DockStlye\DockStlye\Images\green.arrow.down.19x19.gif') !important;

}

</style>

Above is the stlye which has been applied,but no image is being displayed.
Need help on this issue

Thanks in Advance
Pushpa.

Dock

answered on 06 Nov 2009

4 answers

91 views

RadDatePicker pop up problem

hi....
i want open a pop up of RadDateTime picker according screen if below radDatePicker is less space then it wil open on top side and if above rad date picker is less space then it wil be open below side.it adjustable accordinding screen...
plz reply

General Discussions

answered on 06 Nov 2009

6 answers

196 views

[Solved] Disable dockcommand?

May i know what's the client side command to disable/enable the dockcommand?

Thanks.

Dock

answered on 06 Nov 2009

1 answer

155 views

RADMenu vanishes if page is postback

Hi,

I am using RADMenu in my project. I am using load panel and rad ajax manager. I have placed the full page in the rad ajax load panel. So when user clicks any item on the menu for example Save button then the page shows waiting image and then loads the page. Hence gives user the effect that the page does not refresh.

I am facing the following issue

The rad menu (strip on top of the page) disappears when the page is postback. I have saved the record to database after clicking save button. The functionality of save works perfect and record is saved to database but after postback radmenu disappears.

Secondly if i use <ajaxsettings> in radajaxmanager and give id of radmenu in <updatecontrols> then at this time menu does not disappear but the page functionality is unseen. For example i am disabling textbox on the page after save then menu does not vanish but textbox does not get disabled. The code does not throw any error.

Moreover i am using master page and ScriptManager also

Can anybody please give me the solution so that the menu does not disappear on postback by using radajaxmanager, ajaxloadpanel?

answered on 06 Nov 2009

2 answers

144 views

Node templates without databinding

Hello,

I have a treeview structure that is being created without using databinding.

I manually create nodes and add the to the tree/ other nodes.

The question is: How do I template some of my nodes. Is this even possible ?

TreeView

answered on 05 Nov 2009

1 answer

53 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

144 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

124 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

169 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

207 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

Top users last month