Questions on UI for ASP.NET AJAX Forum

110,766 questions

4 answers

55 views

Filter Event

Hi:
I need to know wath event fires when I press enter on filterbox on gridview.

thanks.

Grid

answered on 19 May 2011

1 answer

83 views

How to display date and time of an appointment separately in grid view?

Hi,
I am building a rad grid to display all the appointments. The problem I am having right now is to display date and time of an appointment in 2 different columns. May you show me how to separate date and time from an appointment StartTime?

Scheduler

answered on 19 May 2011

3 answers

75 views

IE9 Radeditor - Adding additional Doctype and head junk

Hello,

I just wanted to report another issue with the RadEditor Control and support for IE9 using the latest release build 2011.1.413.35.

Apparently, the control is adding in a bunch of junk (trying to duplicate and then format the doctype and head sections). Here's what I get when I use it normally (in ConvertToXhtml):

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></meta><title>Test</title><style type="text/css">p { margin-top: 10px; }</style></head><body>

<!--CTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt-->

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></meta><title>Test</title><style type="text/css">p { margin-top: 10px; }</style>begin my text

Here's what I should get and DO get when I use the

<meta http-equiv="X-UA-Compatible" content="IE=8" />

workaround:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html><head><title>Test</title><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><style type="text/css">

p { margin-top: 10px; }</style></head><body>begin my text

Anyway, I wanted to report this in case others ran into the problem and also to hopefully get this fixed so I don't have to hack my code.

There should probably be an email that goes out or some form of notification about these problems. They are pretty serious issues that affects a lot of content management and that could really be a pain for users or admins to go back and fix in their systems.

Editor

answered on 19 May 2011

5 answers

142 views

How to insert a recod into databse

Hi,
I have develop a small asp.net Ajax Radcontrole in that i am using a Rad Grid When i try to inset a new record into database it doesn't store into database but it showing the record in grid as temporary .i have given my database connection in web.config and that connection sting name given in
<sds:SessionDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
This is only i have changed ....Please help me how resolve this problem.....

Grid

answered on 19 May 2011

5 answers

454 views

How to get NestedViewTemplate radgrid in client side

Hi,

I have NestedTemplate radgrid in my application. i want how to get Nestedtemplate radgrid in client side.

Please see the attached screenshot.

i want two items.

1. how to get Nestedtemplate radgrid
2. how to get parent row which the Nestedtemplate radgrid item selected.

both i want in client side.

Please check the attached screen shot.

Here is my code.

<telerik:RadGrid ID="rgAddPlans" runat="server" AutoGenerateColumns="False" DataSourceID="sdsDispayPlans" DataKeyNames="sp_pln_id"
                            Width="740px" GridLines="Both">
                            <MasterTableView HierarchyDefaultExpanded="true" AutoGenerateColumns="false" CommandItemDisplay="Top"
                                DataKeyNames="sp_pln_id" ClientDataKeyNames="sp_pln_id" >
                              <Columns>
                                    <telerik:GridTemplateColumn HeaderText="Waive" HeaderStyle-Font-Bold="true">
                                        <ItemTemplate>
                                            <asp:CheckBox ID="rbWaive" runat="server" AutoPostBack="false" />
                                        </ItemTemplate>
                                        <ItemStyle HorizontalAlign="Center" />
                                        <HeaderStyle Width="60px" HorizontalAlign="Center" />
                                    </telerik:GridTemplateColumn>
                                </Columns>
                                <NestedViewTemplate>
                                    <telerik:RadGrid ID="rgFlex" runat="server" AutoGenerateColumns="False" OnItemDataBound="rgFlex_OnItemDataBound"
                                        DataSourceID="sdsFlexBenefit" Width="700px" GridLins="Both">
                                        <MasterTableView AutoGenerateColumns="false" CommandItemDisplay="Top">
                                            <Columns>
                                                 <telerik:GridTemplateColumn HeaderText="Waive" HeaderStyle-Font-Bold="true">
                                        <ItemTemplate>
                                            <asp:CheckBox ID="cbFlexWaive" runat="server" AutoPostBack="false" />
                                        </ItemTemplate>
                                        <ItemStyle HorizontalAlign="Center" />
                                        <HeaderStyle Width="30px" HorizontalAlign="Center" />
                                    </telerik:GridTemplateColumn>
                                            </Columns>
                                        </MasterTableView>
                                    </telerik:RadGrid>
                                </NestedViewTemplate>
                            </MasterTableView>
                        </telerik:RadGrid>

Thanks in advance,
Dhamu.

Grid

answered on 19 May 2011

2 answers

124 views

Minor Problem with deep nested view

Hi, I have an aspx page using Datagrids and the nested view templates.
Lets see if I can explain this.
    The top level grid, GridA has a nested view template. On this template is a panel, with a multi-page and a tab.
    Each page view has a grid.

    These grids in turn my have nestedviews with a panel and a multiview with a tab, and so on and so on.

The only issue I am having, is that by the third level the panels are not displaying the grids.
If there are 3 tabs, and tab 0 is selected, you can see the tab but not the grid.
You select tab 1 and it displays it's grid properly.
You reselect tab 0 and "tada" the grid is now displayed properly.

This only happens once we get deeper into the nested views of the grid. The code is all basically the same.

I will attach my aspx page, the code behind, and a series of three pictures that should demonstrate what I am seeing.

If anyone has any ideas of what is causing it, please let me know.

Thank you.

aspx:

<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"

CodeBehind="Default.aspx.cs" Inherits="ECSMT._Default" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">

</asp:Content>

<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent" >

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="tcbSearch">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="tcbSearch"></telerik:AjaxUpdatedControl>

<telerik:AjaxUpdatedControl ControlID="grdCMT" LoadingPanelID="RadAjaxLoadingPanel1" ></telerik:AjaxUpdatedControl>

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="tcbClear">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="tcbClear"></telerik:AjaxUpdatedControl>

<telerik:AjaxUpdatedControl ControlID="grdCMT" LoadingPanelID="RadAjaxLoadingPanel1" ></telerik:AjaxUpdatedControl>

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="grdCMT">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="grdCMT" LoadingPanelID="RadAjaxLoadingPanel1" ></telerik:AjaxUpdatedControl>

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<telerik:RadScriptManager ID="RadScriptManager1" runat="server" AsyncPostBackTimeout="600">

</telerik:RadScriptManager>

<script type="text/javascript" >

function ShowViewForm(id, rowIndex)

{

window.radopen("/ECSMT/OrderDetail.aspx?OrderNumType=" + id, "frmOrderDetail" + id );

return false;

}

function ShowOrdValidationForm(id, rowIndex)

{

window.radopen("/ECSMT/OrderValidation.aspx?OrderNumType=" + id, "frmOrderValidation" + id);

return false;

}

</script>

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="WebBlue">

</telerik:RadAjaxLoadingPanel>

<asp:UpdatePanel ID="MainUpdatePanel" runat="server" width="100%" height="600" >

<ContentTemplate >

<telerik:RadSplitter ID="rsFilter" runat="server" Width="100%" Height="525" Orientation="Vertical" >

<telerik:RadPane ID="rpFilter" runat="server" Width="40px" BackColor="#DAE2E8" Skin = "WebBlue" MinHeight = "600" Height = "100%">

<telerik:RadSlidingZone ID="rszFilter" Runat="server">

<telerik:RadSlidingPane ID="rspFilter" runat="server" Width="225px" Height="100%" Title="Select Filters"

EnableDock="false" MinWidth="225" BackColor="#DAE2E8" Skin = "WebBlue">

<asp:Table ID="tblFilter" runat="server">

<asp:TableRow ID="tblrJDENum" runat="server">

<asp:TableCell ID="tclJDENum" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblJDENum" runat="server" Text="JDE #"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctJDENum" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtJDENum" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrCMTNum" runat="server">

<asp:TableCell ID="tclCMTNum" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblCMTNum" runat="server" Text="CMT #"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctCMTNum" runat="server" HorizontalAlign="Left">

<%-- <telerik:RadComboBox ID="rcmbCMTNum" runat="server" DataTextField="CustName" DataValueField="ABAN8" skin="WebBlue"

Height="200px" Width="135px" DropDownWidth="300px" AutoPostBack="true" ToolTip="" MarkFirstMatch="True">

</telerik:RadComboBox>--%>

<telerik:RadTextBox ID="rtxtCMT" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrCompanyName" runat="server">

<asp:TableCell ID="tclCompanyName" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblCompanyName" runat="server" Text="Company Name"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctCompanyName" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtCompanyName" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrCustUser" runat="server">

<asp:TableCell ID="tclCustUser" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblCustUser" runat="server" Text="Customer User"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctCustUser" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtCustUser" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrEmail" runat="server">

<asp:TableCell ID="tclEmail" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblEmail" runat="server" Text="EMail"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctEmail" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtEmail" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrCity" runat="server">

<asp:TableCell ID="tclCity" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblCity" runat="server" Text="City"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctCity" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtCity" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrState" runat="server">

<asp:TableCell ID="tclState" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblState" runat="server" Text="State"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctState" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtState" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrZip" runat="server">

<asp:TableCell ID="tclZip" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblZip" runat="server" Text="Zip Code"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctZip" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtZip" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrPhone" runat="server">

<asp:TableCell ID="tclPhone" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblPhone" runat="server" Text="Phone #"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctPhone" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtPhone" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrRM" runat="server">

<asp:TableCell ID="tclRM" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblRM" runat="server" Text="Regional Mgr"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctRM" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtRM" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrTerr" runat="server">

<asp:TableCell ID="tclTerr" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblTerr" runat="server" Text="CMT Terr"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctTerr" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtTerr" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrOrderNum" runat="server">

<asp:TableCell ID="tclOrderNum" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblOrderNum" runat="server" Text="Sales Order #"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctOrderNum" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtOrderNum" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrPO" runat="server">

<asp:TableCell ID="tclPO" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblPO" runat="server" Text="PO #"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctPO" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtPO" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrGP" runat="server">

<asp:TableCell ID="tclGP" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblGP" runat="server" Text="GP #"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctGP" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtGP" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrIncident" runat="server">

<asp:TableCell ID="tclIncident" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblIncident" runat="server" Text="Incident #"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctIncident" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtIncident" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrInstaller" runat="server">

<asp:TableCell ID="tclInstaller" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblInstaller" runat="server" Text="Installer Co. ID"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctInstaller" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtInstaller" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrTracking" runat="server">

<asp:TableCell ID="tclTracking" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblTracking" runat="server" Text="Tracking #"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctTraclomg" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtTracking" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrProduct" runat="server">

<asp:TableCell ID="tclProduct" runat="server" HorizontalAlign="Right">

<asp:Label ID="lblProduct" runat="server" Text="Product Types"></asp:Label>

</asp:TableCell>

<asp:TableCell ID="tctProduct" runat="server" HorizontalAlign="Left">

<telerik:RadTextBox ID="rtxtProduct" runat="server" Skin="WebBlue"></telerik:RadTextBox>

</asp:TableCell>

</asp:TableRow>

<asp:TableRow ID="tblrCommands" runat="server">

<asp:TableCell ID="tcbClear" runat="server" HorizontalAlign="Center" >

<telerik:RadButton ID="btnClear" runat="server" Text = "Clear"

ToolTip="Clears the current filter selections." Skin="WebBlue" OnClick="tcbClear_OnClick">

<Icon PrimaryIconUrl="~/Images/reload_16.png" PrimaryIconLeft="5px" />

</telerik:RadButton>

</asp:TableCell>

<asp:TableCell ID="tcbSearch" runat="server" HorizontalAlign="Center">

<telerik:RadButton ID="rbtnSearch" runat="server" Text = "Search"

ToolTip="Search Using Current Filters" Skin="WebBlue" OnClick="tcbSearch_OnClick">

<Icon PrimaryIconUrl="~/Images/zoom_16.png" PrimaryIconLeft="5px" />

</telerik:RadButton>

</asp:TableCell>

</asp:TableRow>

</asp:Table>

</telerik:RadSlidingPane>

</telerik:RadSlidingZone>

</telerik:RadPane>

<telerik:RadSplitBar ID="rsbFilter" runat="server">

</telerik:RadSplitBar>

<telerik:RadPane ID="rpTree" runat="server" scrolling="Both" width="100%" Height="100%">

<telerik:RadGrid ID="grdCMT" runat="server" Width="100%" Height="100%" ShowStatusBar="true" AutoGenerateColumns="False"

AllowSorting="true" AllowMultiRowSelection="False" AllowPaging="true"

ShowFooter="True" Skin="WebBlue" Pagesize="50" OnNeedDataSource="grdCMT_NeedDataSource"

OnItemCommand="grdCMT_ItemCommand" enabled="false" OnPageSizeChanged="grdCMT_PageSizeChanged">

<FooterStyle BorderStyle="Solid" />

<PagerStyle Mode="NextPrev" ></PagerStyle>

<FilterMenu EnableTheming="True">

<CollapseAnimation Duration="200" Type="OutQuint" />

</FilterMenu>

<MasterTableView Width="100%" DataKeyNames="CustomerNumber" AllowMultiColumnSorting="True" ItemStyle-HorizontalAlign="Justify" ItemStyle-VerticalAlign="Middle" GroupLoadMode="Server" >

<ExpandCollapseColumn Visible="True"></ExpandCollapseColumn>

<Columns>

<telerik:GridBoundColumn SortExpression="CustomerNumber" HeaderText="Customer Number" HeaderButtonType="TextButton"

DataField="CustomerNumber" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="CustomerName" HeaderText="Customer Name" HeaderButtonType="TextButton"

DataField="CustomerName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="City" HeaderText="City" HeaderButtonType="TextButton"

DataField="City">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="State" HeaderText="State" HeaderButtonType="TextButton"

DataField="State">

</telerik:GridBoundColumn>

<telerik:GridDateTimeColumn SortExpression="LastNoteDate" HeaderText="LastNoteDate" HeaderButtonType="TextButton"

DataField="LastNoteDate" DataFormatString="{0:MM/dd/yyyy}" >

</telerik:GridDateTimeColumn>

<telerik:GridBoundColumn SortExpression="ActiveRMA" HeaderText="Active RMA" HeaderButtonType="TextButton"

DataField="ActiveRMA">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="TerrRMNumber" HeaderText="RM #" HeaderButtonType="TextButton"

DataField="TerrRMNumber">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="TerrRMName" HeaderText="RM Name" HeaderButtonType="TextButton"

DataField="TerrRMName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="CreditMgr" HeaderText="Credit Mgr" HeaderButtonType="TextButton"

DataField="CreditMgr">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="GPNum" HeaderText="GP Num" HeaderButtonType="TextButton"

DataField="GPNum">

</telerik:GridBoundColumn>

</Columns>

<ItemStyle HorizontalAlign="Justify" VerticalAlign="Middle" ></ItemStyle>

<PagerStyle AlwaysVisible="True" />

<NestedViewSettings >

<ParentTableRelation >

<telerik:GridRelationFields DetailKeyField="CustomerNumber" MasterKeyField="CustomerNumber" />

</ParentTableRelation>

</NestedViewSettings>

<NestedViewTemplate >

<telerik:RadAjaxPanel ID="InnerPanel1" runat="server" visible="false" >

<telerik:RadTabStrip ID="RadTabStrip1" runat="server" MultiPageID="RadMultiPage1" SelectedIndex="0">

<Tabs>

<telerik:RadTab runat="server" Text="Installs" PageViewID="rpvInstalls"></telerik:RadTab>

<telerik:RadTab runat="server" Text="Address Types" PageViewID="rpvAddress"></telerik:RadTab>

<telerik:RadTab runat="server" Text="Contacts And Users" PageViewID ="rpvCMTContacts"></telerik:RadTab>

<telerik:RadTab runat="server" Text="Orders" PageViewID ="rpvCMTOrders"></telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<telerik:RadMultiPage ID="RadMultiPage1" runat="server" SelectedIndex="0" RenderSelectedPageOnly="false">

<telerik:RadPageView ID="rpvInstalls" runat="server">

<telerik:RadGrid ID="rgrdInstalls" runat="server" AutoGenerateColumns="False"

AllowSorting="true" AllowMultiRowSelection="False" AllowPaging="true"

ShowFooter="false" Skin="WebBlue" Pagesize="5" OnNeedDataSource="grdInstalls_NeedDataSource"

OnItemCommand="grdInstalls_ItemCommand">

<MasterTableView width="100%" DataKeyNames="CustomerNumber" AllowMultiColumnSorting="true">

<Columns>

<telerik:GridBoundColumn SortExpression="CustomerNumber" HeaderText="Addr #" HeaderButtonType="TextButton"

DataField="CustomerNumber">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Location" HeaderText="Location" HeaderButtonType="TextButton"

DataField="Location">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Address1" HeaderText="Street" HeaderButtonType="TextButton"

DataField="Address1">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="City" HeaderText="City" HeaderButtonType="TextButton"

DataField="City">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="State" HeaderText="State" HeaderButtonType="TextButton"

DataField="State">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Zip" HeaderText="Zip" HeaderButtonType="TextButton"

DataField="Zip">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="RMNum" HeaderText="Phys RM #" HeaderButtonType="TextButton"

DataField="RMNum">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="RMName" HeaderText="Phys RM Name" HeaderButtonType="TextButton"

DataField="RMName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Territory" HeaderText="Territory" HeaderButtonType="TextButton"

DataField="Territory">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Active" HeaderText="Active" HeaderButtonType="TextButton"

DataField="Active">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="MaxExpDte" HeaderText="Max Exp Date" HeaderButtonType="TextButton"

DataField="MaxExpDte" DataFormatString="{0:MM/dd/yyyy}" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="CurrentStatus" HeaderText="CurrentStatus" HeaderButtonType="TextButton"

DataField="CurrentStatus">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="ActualInstallDte" HeaderText="ActualInstallDte" HeaderButtonType="TextButton"

DataField="ActualInstallDte" DataFormatString="{0:MM/dd/yyyy}" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="EditionName" HeaderText="Edition Name" HeaderButtonType="TextButton"

DataField="EditionName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="KitNumber" HeaderText="Kit #" HeaderButtonType="TextButton"

DataField="KitNumber">

</telerik:GridBoundColumn>

</Columns>

<NestedViewSettings >

<ParentTableRelation >

<telerik:GridRelationFields DetailKeyField="CustomerNumber" MasterKeyField="CustomerNumber" />

</ParentTableRelation>

</NestedViewSettings>

<NestedViewTemplate>

<telerik:RadAjaxPanel ID="InnerPanelInstalls" runat="server" Visible="false">

<telerik:RadTabStrip ID="rtabInstalls" runat="server" MultiPageID="rmpInstalls" SelectedIndex="0">

<Tabs>

<telerik:RadTab runat="server" Text="Equipment" PageViewID ="rpvInstEquipment"></telerik:RadTab>

<telerik:RadTab runat="server" Text="Contacts" PageViewID ="rpvInstContacts"></telerik:RadTab>

<telerik:RadTab runat="server" Text="Orders" PageViewID ="rpvInstOrders"></telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<telerik:RadMultiPage ID="rmpInstalls" runat="server">

<telerik:RadPageView Id="rpvInstEquipment" runat="server" >

<telerik:RadGrid ID="rgrdInstEquipment" runat="server" AllowSorting="true" AllowMultiRowSelection="false" AutoGenerateColumns="False"

AllowPaging="true" Skin="WebBlue" PageSize="5" OnNeedDataSource="rgrdInstEquipment_NeedDataSource" >

<MasterTableView Width="100%" DataKeyNames="EquipNum" AllowMultiColumnSorting="true" >

<Columns>

<telerik:GridBoundColumn SortExpression="EquipNum" HeaderText="Equipment #" HeaderButtonType="TextButton" DataField="EquipNum" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="ParentNum" HeaderText="ParentNum" HeaderButtonType="TextButton" DataField="ParentNum" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="InvTypeCode" HeaderText="Description" HeaderButtonType="TextButton" DataField="InvTypeCode" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="SerialNum" HeaderText="Serial #" HeaderButtonType="TextButton" DataField="SerialNum">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="OS" HeaderText="OS" HeaderButtonType="TextButton" DataField="OS">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Make" HeaderText="Make" HeaderButtonType="TextButton" DataField="Make" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Model" HeaderText="Model" HeaderButtonType="TextButton" DataField="Model" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="InstallDteInService" HeaderText="Date In Service" HeaderButtonType="TextButton"

DataField="InstallDteInService" DataFormatString="{0:MM/dd/yyyy}" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="InstallDteOutOfService" HeaderText="Date Out Of Service" HeaderButtonType="TextButton"

DataField="InstallDteOutOfService" DataFormatString="{0:MM/dd/yyyy}" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="InstallSpecNotes" HeaderText="Special Notes" HeaderButtonType="TextButton" DataField="InstallSpecNotes" >

</telerik:GridBoundColumn>

</Columns>

<ItemStyle HorizontalAlign="Justify" VerticalAlign="Middle" ></ItemStyle>

<PagerStyle AlwaysVisible="false"></PagerStyle>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

<telerik:RadPageView ID="rpvInstContacts" runat="server">

<telerik:RadGrid ID="rgrdInstContacts" runat="server" AllowSorting="true" AllowMultiRowSelection="false" AutoGenerateColumns="False"

AllowPaging="true" Skin="WebBlue" PageSize="5" OnNeedDataSource="rgrdContacts_NeedDataSource"

OnItemCommand="rgrdInstContacts_ItemCommand">

<MasterTableView Width="100%" DataKeyNames="ContactID" AllowMultiColumnSorting="true" >

<Columns>

<telerik:GridBoundColumn SortExpression="ContactID" HeaderText="ContactID" HeaderButtonType="TextButton" DataField="ContactID" Visible="false" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="FirstName" HeaderText="FirstName" HeaderButtonType="TextButton" DataField="FirstName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="LastName" HeaderText="LastName" HeaderButtonType="TextButton" DataField="LastName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Title" HeaderText="Title" HeaderButtonType="TextButton" DataField="Title">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Description" HeaderText="Description" HeaderButtonType="TextButton" DataField="Description">

</telerik:GridBoundColumn>

</Columns>

<ItemStyle HorizontalAlign="Justify" VerticalAlign="Middle" ></ItemStyle>

<PagerStyle AlwaysVisible="false"></PagerStyle>

<NestedViewSettings >

<ParentTableRelation >

<telerik:GridRelationFields DetailKeyField="ContactID" MasterKeyField="ContactID" />

</ParentTableRelation>

</NestedViewSettings>

<NestedViewTemplate>

<telerik:RadAjaxPanel ID="InnerPanelInstContacts" runat="server" Visible="false" >

<telerik:RadTabStrip ID="rtabInstContacts" runat="server" MultiPageID="rmpInstContacts" SelectedIndex="0">

<Tabs>

<telerik:RadTab runat="server" Text="Phone List" PageViewID ="rpvInstPhones"></telerik:RadTab>

<telerik:RadTab runat="server" Text="EMail List" PageViewID ="rpvInstEmails"></telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<telerik:RadMultiPage ID="rmpInstContacts" runat="server">

<telerik:RadPageView ID="rpvInstPhones" runat="server">

<telerik:RadGrid ID="rgrdInstPhones" runat="server" AutoGenerateColumns="false"

AllowSorting="true" AllowMultiRowSelection="false" AllowPaging="true"

ShowFooter="false" Skin="WebBlue" PageSize="5" OnNeedDataSource="rgrdPhones_NeedDataSource">

<MasterTableView Width="100%" DataKeyNames="ContactID" AllowMultiColumnSorting="true">

<Columns>

<telerik:GridBoundColumn SortExpression="ContactID" HeaderText="ContactID" HeaderButtonType="TextButton"

DataField="ContactID" Visible="false" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="PhoneType" HeaderText="PhoneType" HeaderButtonType="TextButton"

DataField="PhoneType">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="AreaCode" HeaderText="AreaCode" HeaderButtonType="TextButton"

DataField="AreaCode">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="PhoneNumber" HeaderText="PhoneNumber" HeaderButtonType="TextButton"

DataField="PhoneNumber">

</telerik:GridBoundColumn>

</Columns>

<ItemStyle HorizontalAlign="Justify" VerticalAlign="Middle" ></ItemStyle>

<PagerStyle AlwaysVisible="false"></PagerStyle>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

<telerik:RadPageView ID="rpvInstEmails" runat="server">

<telerik:RadGrid ID="rgrdInstEmails" runat="server" AutoGenerateColumns="false"

AllowSorting="true" AllowMultiRowSelection="false" AllowPaging="true"

ShowFooter="false" Skin="WebBlue" PageSize="5" OnNeedDataSource="rgrdEMails_NeedDataSource">

<MasterTableView Width="100%" DataKeyNames="ContactID" AllowMultiColumnSorting="true">

<Columns>

<telerik:GridBoundColumn SortExpression="ContactID" HeaderText="ContactID" HeaderButtonType="TextButton"

DataField="ContactID" Visible="false" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="EMail" HeaderText="EMail" HeaderButtonType="TextButton"

DataField="EMail">

</telerik:GridBoundColumn>

</Columns>

<ItemStyle HorizontalAlign="Justify" VerticalAlign="Middle" ></ItemStyle>

<PagerStyle AlwaysVisible="false"></PagerStyle>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

</telerik:RadMultiPage>

</telerik:RadAjaxPanel>

</NestedViewTemplate>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

<telerik:RadPageView ID="rpvInstOrders" runat="server">

<telerik:RadGrid ID="rgrdInstOrders" runat="server" AutoGenerateColumns="False"

AllowSorting="true" AllowMultiRowSelection="False" AllowPaging="true"

ShowFooter="False" Skin="WebBlue" Pagesize="5" OnNeedDataSource="rgrdOrders_NeedDataSource" OnItemCreated="rgrdOrders_ItemCreated">

<FooterStyle BorderStyle="Solid" />

<MasterTableView Width="100%" DataKeyNames="OrderNum" AllowMultiColumnSorting="True" ItemStyle-HorizontalAlign="Justify" ItemStyle-VerticalAlign="Middle" >

<ExpandCollapseColumn Visible="True"></ExpandCollapseColumn>

<Columns>

<telerik:GridBoundColumn SortExpression="OrderNumType" HeaderText="OrderNumType" HeaderButtonType="TextButton"

DataField="OrderNumType" Visible="false" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="OrderNum" HeaderText="Order #" HeaderButtonType="TextButton"

DataField="OrderNum">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="OrderType" HeaderText="Type" HeaderButtonType="TextButton"

DataField="OrderType" >

</telerik:GridBoundColumn>

<telerik:GridDateTimeColumn SortExpression="StartDate" HeaderText="Lifetime Start Date" HeaderButtonType="TextButton"

DataField="StartDate" DataFormatString="{0:MM/dd/yyyy}">

</telerik:GridDateTimeColumn>

<telerik:GridDateTimeColumn SortExpression="EndDate" HeaderText="Lifetime End Date" HeaderButtonType="TextButton"

DataField="EndDate" DataFormatString="{0:MM/dd/yyyy}">

</telerik:GridDateTimeColumn>

<telerik:GridBoundColumn SortExpression="OrderRM" HeaderText="Selling RM #" HeaderButtonType="TextButton"

DataField="OrderRM">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="RMName" HeaderText="Selling RM Name" HeaderButtonType="TextButton"

DataField="RMName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="ECSPCSBoth" HeaderText="E/P/B" HeaderButtonType="TextButton"

DataField="ECSPCSBoth">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="MnthlySubscripValue" HeaderText="Monthly Subscrip. $" HeaderButtonType="TextButton"

DataField="MnthlySubscripValue">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn UniqueName="ViewOrderColumn" HeaderText="View">

<ItemTemplate>

<asp:HyperLink ID="ViewLink" runat="server" Text="View"></asp:HyperLink>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="ValidateOrderColumn" HeaderText="Validate">

<ItemTemplate>

<asp:HyperLink ID="ValidationLink" runat="server" Text="Validate"></asp:HyperLink>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

<ItemStyle HorizontalAlign="Justify" VerticalAlign="Middle" ></ItemStyle>

<PagerStyle AlwaysVisible="false" />

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

</telerik:RadMultiPage>

</telerik:RadAjaxPanel>

</NestedViewTemplate>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

<telerik:RadPageView ID="rpvAddress" runat="server">

<telerik:RadGrid ID="grdAddress" runat="server" AutoGenerateColumns="False"

AllowSorting="true" AllowMultiRowSelection="False" AllowPaging="true"

ShowFooter="false" Skin="WebBlue" Pagesize="5" OnNeedDataSource="grdAddress_NeedDataSource"

OnItemCommand="grdAddress_ItemCommand">

<FooterStyle BorderStyle="Solid" />

<PagerStyle Mode="NextPrev" ></PagerStyle>

<MasterTableView Width="100%" DataKeyNames="CustNumAndType" AllowMultiColumnSorting="True" ItemStyle-HorizontalAlign="Justify" ItemStyle-VerticalAlign="Middle" >

<ExpandCollapseColumn Visible="True"></ExpandCollapseColumn>

<Columns>

<telerik:GridBoundColumn SortExpression="CustNumAndType" HeaderText="CustNumAndType" HeaderButtonType="TextButton"

DataField="CustNumAndType" Visible="false">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="CustomerType" HeaderText="Customer Type" HeaderButtonType="TextButton"

DataField="CustomerType" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="AddCount" HeaderText="Total" HeaderButtonType="TextButton"

DataField="AddCount">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="ActiveCount" HeaderText="Active" HeaderButtonType="TextButton"

DataField="ActiveCount">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="InactiveCount" HeaderText="Inactive" HeaderButtonType="TextButton"

DataField="InactiveCount">

</telerik:GridBoundColumn>

</Columns>

<ItemStyle HorizontalAlign="Justify" VerticalAlign="Middle" ></ItemStyle>

<PagerStyle AlwaysVisible="false" />

<NestedViewSettings >

<ParentTableRelation >

<telerik:GridRelationFields DetailKeyField="CustNumAndType" MasterKeyField="CustNumAndType" />

</ParentTableRelation>

</NestedViewSettings>

<NestedViewTemplate >

<telerik:RadAjaxPanel ID="InnerPanel2" runat="server" Visible="false" >

<telerik:RadGrid ID="grdAddresses" runat="server" AutoGenerateColumns="False"

AllowSorting="true" AllowMultiRowSelection="False" AllowPaging="true"

ShowFooter="False" Skin="WebBlue" Pagesize="5" OnNeedDataSource="grdAddresses_NeedDataSource"

OnItemCommand="grdAddresses_ItemCommand">

<FooterStyle BorderStyle="Solid" />

<MasterTableView Width="100%" DataKeyNames="CustomerNumber" AllowMultiColumnSorting="True" ItemStyle-HorizontalAlign="Justify" ItemStyle-VerticalAlign="Middle" >

<ExpandCollapseColumn Visible="True"></ExpandCollapseColumn>

<Columns>

<telerik:GridBoundColumn SortExpression="CustomerNumber" HeaderText="Addr #" HeaderButtonType="TextButton"

DataField="CustomerNumber">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="ContactName" HeaderText="Name" HeaderButtonType="TextButton"

DataField="ContactName" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="ContactTitle" HeaderText="Title" HeaderButtonType="TextButton"

DataField="ContactTitle">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Address1" HeaderText="Street" HeaderButtonType="TextButton"

DataField="Address1">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Address2" HeaderText="Street 2" HeaderButtonType="TextButton"

DataField="Address2">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="City" HeaderText="City" HeaderButtonType="TextButton"

DataField="City">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="State" HeaderText="State" HeaderButtonType="TextButton"

DataField="State">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Zip" HeaderText="Zip" HeaderButtonType="TextButton"

DataField="Zip">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="RMNum" HeaderText="Phys RM #" HeaderButtonType="TextButton"

DataField="RMNum">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="RMName" HeaderText="Phys RM Name" HeaderButtonType="TextButton"

DataField="RMName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Territory" HeaderText="Territory" HeaderButtonType="TextButton"

DataField="Territory">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Active" HeaderText="Active" HeaderButtonType="TextButton"

DataField="Active">

</telerik:GridBoundColumn>

</Columns>

<ItemStyle HorizontalAlign="Justify" VerticalAlign="Middle" ></ItemStyle>

<PagerStyle AlwaysVisible="false" />

<NestedViewSettings >

<ParentTableRelation >

<telerik:GridRelationFields DetailKeyField="CustomerNumber" MasterKeyField="CustomerNumber" />

</ParentTableRelation>

</NestedViewSettings>

<NestedViewTemplate>

<telerik:RadAjaxPanel ID="InnerPanel3" runat="server" Visible="false" >

<telerik:RadTabStrip ID="rtab" runat="server" MultiPageID="RadMultiPage2" SelectedIndex="0">

<Tabs>

<telerik:RadTab runat="server" Text="Contacts" PageViewID ="rpvContacts"></telerik:RadTab>

<telerik:RadTab runat="server" Text="Orders" PageViewID ="rpvOrders"></telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<telerik:RadMultiPage ID="RadMultiPage2" runat="server">

<telerik:RadPageView ID="rpvContacts" runat="server">

<telerik:RadGrid ID="rgrdContacts" runat="server" AllowSorting="true" AllowMultiRowSelection="false" AutoGenerateColumns="False"

AllowPaging="true" Skin="WebBlue" PageSize="5" OnNeedDataSource="rgrdContacts_NeedDataSource"

OnItemCommand="rgrdContacts_ItemCommand" >

<MasterTableView Width="100%" DataKeyNames="ContactID" AllowMultiColumnSorting="true" >

<Columns>

<telerik:GridBoundColumn SortExpression="ContactID" HeaderText="ContactID" HeaderButtonType="TextButton" DataField="ContactID" Visible="false" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="FirstName" HeaderText="FirstName" HeaderButtonType="TextButton" DataField="FirstName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="LastName" HeaderText="LastName" HeaderButtonType="TextButton" DataField="LastName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Title" HeaderText="Title" HeaderButtonType="TextButton" DataField="Title">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Description" HeaderText="Description" HeaderButtonType="TextButton" DataField="Description">

</telerik:GridBoundColumn>

</Columns>

<ItemStyle HorizontalAlign="Justify" VerticalAlign="Middle" ></ItemStyle>

<PagerStyle AlwaysVisible="false"></PagerStyle>

<NestedViewSettings >

<ParentTableRelation >

<telerik:GridRelationFields DetailKeyField="ContactID" MasterKeyField="ContactID" />

</ParentTableRelation>

</NestedViewSettings>

<NestedViewTemplate>

<telerik:RadAjaxPanel ID="InnerPanelContacts" runat="server" Visible="false" >

<telerik:RadTabStrip ID="RadTabStrip1" runat="server" MultiPageID="rmpContacts" SelectedIndex="0">

<Tabs>

<telerik:RadTab runat="server" Text="Phone List" PageViewID ="rpvPhones"></telerik:RadTab>

<telerik:RadTab runat="server" Text="EMail List" PageViewID ="rpvEmails"></telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<telerik:RadMultiPage ID="rmpContacts" runat="server">

<telerik:RadPageView ID="rpvPhones" runat="server">

<telerik:RadGrid ID="rgrdPhones" runat="server" AutoGenerateColumns="false"

AllowSorting="true" AllowMultiRowSelection="false" AllowPaging="true"

ShowFooter="false" Skin="WebBlue" PageSize="5" OnNeedDataSource="rgrdPhones_NeedDataSource">

<MasterTableView Width="100%" DataKeyNames="ContactID" AllowMultiColumnSorting="true">

<Columns>

<telerik:GridBoundColumn SortExpression="ContactID" HeaderText="ContactID" HeaderButtonType="TextButton"

DataField="ContactID" Visible="false" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="PhoneType" HeaderText="PhoneType" HeaderButtonType="TextButton"

DataField="PhoneType">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="AreaCode" HeaderText="AreaCode" HeaderButtonType="TextButton"

DataField="AreaCode">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="PhoneNumber" HeaderText="PhoneNumber" HeaderButtonType="TextButton"

DataField="PhoneNumber">

</telerik:GridBoundColumn>

</Columns>

<ItemStyle HorizontalAlign="Justify" VerticalAlign="Middle" ></ItemStyle>

<PagerStyle AlwaysVisible="false"></PagerStyle>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

<telerik:RadPageView ID="rpvEmails" runat="server">

<telerik:RadGrid ID="rgrdEmails" runat="server" AutoGenerateColumns="false"

AllowSorting="true" AllowMultiRowSelection="false" AllowPaging="true"

ShowFooter="false" Skin="WebBlue" PageSize="5" OnNeedDataSource="rgrdEMails_NeedDataSource">

<MasterTableView Width="100%" DataKeyNames="ContactID" AllowMultiColumnSorting="true">

<Columns>

<telerik:GridBoundColumn SortExpression="ContactID" HeaderText="ContactID" HeaderButtonType="TextButton"

DataField="ContactID" Visible="false" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="EMail" HeaderText="EMail" HeaderButtonType="TextButton"

DataField="EMail">

</telerik:GridBoundColumn>

</Columns>

<ItemStyle HorizontalAlign="Justify" VerticalAlign="Middle" ></ItemStyle>

<PagerStyle AlwaysVisible="false"></PagerStyle>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

</telerik:RadMultiPage>

</telerik:RadAjaxPanel>

</NestedViewTemplate>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

<telerik:RadPageView ID="rpvOrders" runat="server">

<telerik:RadGrid ID="rgrdOrders" runat="server" AutoGenerateColumns="False"

AllowSorting="true" AllowMultiRowSelection="False" AllowPaging="true"

ShowFooter="False" Skin="WebBlue" Pagesize="5" OnNeedDataSource="rgrdOrders_NeedDataSource" OnItemCreated="rgrdOrders_ItemCreated">

<FooterStyle BorderStyle="Solid" />

<MasterTableView Width="100%" DataKeyNames="OrderNumType" AllowMultiColumnSorting="True" ItemStyle-HorizontalAlign="Justify" ItemStyle-VerticalAlign="Middle" >

<ExpandCollapseColumn Visible="True"></ExpandCollapseColumn>

<Columns>

<telerik:GridBoundColumn SortExpression="OrderNumType" HeaderText="OrderNumType" HeaderButtonType="TextButton"

DataField="OrderNumType" Visible="false" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="OrderNum" HeaderText="Order #" HeaderButtonType="TextButton"

DataField="OrderNum">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="OrderType" HeaderText="Type" HeaderButtonType="TextButton"

DataField="OrderType" >

</telerik:GridBoundColumn>

<telerik:GridDateTimeColumn SortExpression="StartDate" HeaderText="Lifetime Start Date" HeaderButtonType="TextButton"

DataField="StartDate" DataFormatString="{0:MM/dd/yyyy}">

</telerik:GridDateTimeColumn>

<telerik:GridDateTimeColumn SortExpression="EndDate" HeaderText="Lifetime End Date" HeaderButtonType="TextButton"

DataField="EndDate" DataFormatString="{0:MM/dd/yyyy}">

</telerik:GridDateTimeColumn>

<telerik:GridBoundColumn SortExpression="OrderRM" HeaderText="Selling RM #" HeaderButtonType="TextButton"

DataField="OrderRM">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="RMName" HeaderText="Selling RM Name" HeaderButtonType="TextButton"

DataField="RMName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="ECSPCSBoth" HeaderText="E/P/B" HeaderButtonType="TextButton"

DataField="ECSPCSBoth">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="MnthlySubscripValue" HeaderText="Monthly Subscrip. $" HeaderButtonType="TextButton"

DataField="MnthlySubscripValue">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn UniqueName="ViewOrderColumn" HeaderText="View">

<ItemTemplate>

<asp:HyperLink ID="ViewLink" runat="server" Text="View"></asp:HyperLink>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="ValidateOrderColumn" HeaderText="Validate">

<ItemTemplate>

<asp:HyperLink ID="ValidationLink" runat="server" Text="Validate"></asp:HyperLink>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

<ItemStyle HorizontalAlign="Justify" VerticalAlign="Middle" ></ItemStyle>

<PagerStyle AlwaysVisible="false" />

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

</telerik:RadMultiPage>

</telerik:RadAjaxPanel>

</NestedViewTemplate>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadAjaxPanel>

</NestedViewTemplate>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

<telerik:RadPageView ID="rpvCMTContacts" runat="server">

<telerik:RadGrid ID="rgrdCMTContacts" runat="server" AllowSorting="true" AllowMultiRowSelection="false" AutoGenerateColumns="False"

AllowPaging="true" Skin="WebBlue" PageSize="5" OnNeedDataSource="rgrdCMTContacts_NeedDataSource"

OnItemCommand="rgrdCMTContacts_ItemCommand" >

<MasterTableView Width="100%" DataKeyNames="ContactID" AllowMultiColumnSorting="true" >

<Columns>

<telerik:GridBoundColumn SortExpression="ContactID" HeaderText="ContactID" HeaderButtonType="TextButton" DataField="ContactID" Visible="false" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="FirstName" HeaderText="FirstName" HeaderButtonType="TextButton" DataField="FirstName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="LastName" HeaderText="LastName" HeaderButtonType="TextButton" DataField="LastName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Title" HeaderText="Title" HeaderButtonType="TextButton" DataField="Title">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Description" HeaderText="Description" HeaderButtonType="TextButton" DataField="Description">

</telerik:GridBoundColumn>

</Columns>

<ItemStyle HorizontalAlign="Justify" VerticalAlign="Middle" ></ItemStyle>

<PagerStyle AlwaysVisible="false"></PagerStyle>

<NestedViewSettings >

<ParentTableRelation >

<telerik:GridRelationFields DetailKeyField="ContactID" MasterKeyField="ContactID" />

</ParentTableRelation>

</NestedViewSettings>

<NestedViewTemplate>

<telerik:RadAjaxPanel ID="InnerPanelCMTContacts" runat="server" Visible="false" >

<telerik:RadTabStrip ID="rtbCMTContacts" runat="server" MultiPageID="rmpCMTContacts" SelectedIndex="1">

<Tabs>

<telerik:RadTab runat="server" Text="Phone List" PageViewID ="rpvCMTPhones"></telerik:RadTab>

<telerik:RadTab runat="server" Text="EMail List" PageViewID ="rpvCMTEmails"></telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<telerik:RadMultiPage ID="rmpCMTContacts" runat="server">

<telerik:RadPageView ID="rpvCMTPhones" runat="server">

<telerik:RadGrid ID="rgrdCMTPhones" runat="server" AutoGenerateColumns="false"

AllowSorting="true" AllowMultiRowSelection="false" AllowPaging="true"

ShowFooter="false" Skin="WebBlue" PageSize="5" OnNeedDataSource="rgrdPhones_NeedDataSource">

<MasterTableView Width="100%" DataKeyNames="ContactID" AllowMultiColumnSorting="true">

<Columns>

<telerik:GridBoundColumn SortExpression="ContactID" HeaderText="ContactID" HeaderButtonType="TextButton"

DataField="ContactID" Visible="false" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="PhoneType" HeaderText="PhoneType" HeaderButtonType="TextButton"

DataField="PhoneType">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="AreaCode" HeaderText="AreaCode" HeaderButtonType="TextButton"

DataField="AreaCode">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="PhoneNumber" HeaderText="PhoneNumber" HeaderButtonType="TextButton"

DataField="PhoneNumber">

</telerik:GridBoundColumn>

</Columns>

<ItemStyle HorizontalAlign="Justify" VerticalAlign="Middle" ></ItemStyle>

<PagerStyle AlwaysVisible="false"></PagerStyle>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

<telerik:RadPageView ID="rpvCMTEmails" runat="server">

<telerik:RadGrid ID="rgrdCMTEmails" runat="server" AutoGenerateColumns="false"

AllowSorting="true" AllowMultiRowSelection="false" AllowPaging="true"

ShowFooter="false" Skin="WebBlue" PageSize="5" OnNeedDataSource="rgrdEMails_NeedDataSource">

<MasterTableView Width="100%" DataKeyNames="ContactID" AllowMultiColumnSorting="true">

<Columns>

<telerik:GridBoundColumn SortExpression="ContactID" HeaderText="ContactID" HeaderButtonType="TextButton"

DataField="ContactID" Visible="false" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="EMail" HeaderText="EMail" HeaderButtonType="TextButton"

DataField="EMail">

</telerik:GridBoundColumn>

</Columns>

<ItemStyle HorizontalAlign="Justify" VerticalAlign="Middle" ></ItemStyle>

<PagerStyle AlwaysVisible="false"></PagerStyle>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

</telerik:RadMultiPage>

</telerik:RadAjaxPanel>

</NestedViewTemplate>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

<telerik:RadPageView ID="rpvCMTOrders" runat="server" >

<telerik:RadGrid ID="rgrdCMTOrders" runat="server" AutoGenerateColumns="False"

AllowSorting="true" AllowMultiRowSelection="False" AllowPaging="true"

ShowFooter="False" Skin="WebBlue" Pagesize="5" OnNeedDataSource="rgrdOrders_NeedDataSource"

OnItemCreated="rgrdCMTOrders_ItemCreated">

<FooterStyle BorderStyle="Solid" />

<MasterTableView Width="100%" DataKeyNames="OrderNumType" AllowMultiColumnSorting="True">

<ExpandCollapseColumn Visible="True"></ExpandCollapseColumn>

<Columns>

<telerik:GridBoundColumn SortExpression="OrderNumType" HeaderText="OrderNumType" HeaderButtonType="TextButton"

DataField="OrderNumType" Visible="false" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="OrderNum" HeaderText="Order #" HeaderButtonType="TextButton"

DataField="OrderNum">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="OrderType" HeaderText="Type" HeaderButtonType="TextButton"

DataField="OrderType" >

</telerik:GridBoundColumn>

<telerik:GridDateTimeColumn SortExpression="StartDate" HeaderText="Lifetime Start Date" HeaderButtonType="TextButton"

DataField="StartDate" DataFormatString="{0:MM/dd/yyyy}">

</telerik:GridDateTimeColumn>

<telerik:GridDateTimeColumn SortExpression="EndDate" HeaderText="Lifetime End Date" HeaderButtonType="TextButton"

DataField="EndDate" DataFormatString="{0:MM/dd/yyyy}">

</telerik:GridDateTimeColumn>

<telerik:GridBoundColumn SortExpression="OrderRM" HeaderText="Selling RM #" HeaderButtonType="TextButton"

DataField="OrderRM">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="RMName" HeaderText="Selling RM Name" HeaderButtonType="TextButton"

DataField="RMName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="ECSPCSBoth" HeaderText="E/P/B" HeaderButtonType="TextButton"

DataField="ECSPCSBoth">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="MnthlySubscripValue" HeaderText="Monthly Subscrip. $" HeaderButtonType="TextButton"

DataField="MnthlySubscripValue">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn UniqueName="ViewOrderColumn" HeaderText="View">

<ItemTemplate>

<asp:HyperLink ID="CMTViewLink" runat="server" Text="View"></asp:HyperLink>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="ValidateOrderColumn" HeaderText="Validate">

<ItemTemplate>

<asp:HyperLink ID="CMTValidationLink" runat="server" Text="Validate"></asp:HyperLink>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

<ItemStyle HorizontalAlign="Justify" VerticalAlign="Middle" ></ItemStyle>

<PagerStyle AlwaysVisible="false" />

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

</telerik:RadMultiPage>

</telerik:RadAjaxPanel>

</NestedViewTemplate>

</MasterTableView>

<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" />

</telerik:RadGrid>

</telerik:RadPane>

</telerik:RadSplitter>

</ContentTemplate>

</asp:UpdatePanel>

<telerik:RadWindowManager ID="RadWindowManager1" runat="server" VisibleStatusbar="false" ReloadOnShow="true" EnableShadow="true"

ShowContentDuringLoad="false" Animation="Slide" Opacity="90" AutoSize="True" Modal="False" EnableEmbeddedSkins="True" Skin="Telerik">

</telerik:RadWindowManager>

</asp:Content>

Code behind in C#

using System;

using System.Collections;

using System.ComponentModel;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using Telerik.Web.UI;

using System.Net.Mail;

using System.Collections.Generic;

using System.Text;

using System.Reflection;

namespace ECSMT

{

public partial class _Default : System.Web.UI.Page

{

private Marlin.Common.User.cUser mcUserInfo;

protected void Page_Load(object sender, EventArgs e)

{

MethodBase lmth = MethodBase.GetCurrentMethod();

string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;

mcUserInfo = (Marlin.Common.User.cUser)HttpContext.Current.Session["UserInfo"];

Session["BindgrdCMT"] = "No";

try

{

if (!IsPostBack)

{

// LoadrcmbCMTNum();

RadWindowManager1.Behavior = Telerik.Web.UI.WindowBehaviors.Maximize | Telerik.Web.UI.WindowBehaviors.Minimize | Telerik.Web.UI.WindowBehaviors.Close | Telerik.Web.UI.WindowBehaviors.Move | Telerik.Web.UI.WindowBehaviors.Resize | Telerik.Web.UI.WindowBehaviors.Pin | Telerik.Web.UI.WindowBehaviors.Default;

}

catch (Exception ex)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(ex, lsRoutineName, Session["UserName"].ToString());

}

protected void grdCMT_PageSizeChanged(object source, GridCommandEventArgs e)

{

Session["BindgrdCMT"] = "Yes";

}

protected void grdCMT_ItemCommand(object source, GridCommandEventArgs e)

{

if (e.CommandName == RadGrid.ExpandCollapseCommandName && e.Item is GridDataItem && !e.Item.Expanded)

{

RadAjaxPanel rpInnerPanel1;

rpInnerPanel1 = (RadAjaxPanel)((GridDataItem)e.Item).ChildItem.FindControl("InnerPanel1");

rpInnerPanel1.Visible = true;

RadMultiPage rmMultiPage1 = (RadMultiPage)(rpInnerPanel1.FindControl("RadMultiPage1"));

RadPageView rpvInstalls = (RadPageView)(rmMultiPage1.FindControl("rpvInstalls"));

RadGrid rgInstalls = (RadGrid)(rpvInstalls.FindControl("rgrdInstalls"));

rgInstalls.Rebind();

RadPageView rpvAddress = (RadPageView)(rmMultiPage1.FindControl("rpvAddress"));

RadGrid rgAddress = (RadGrid)(rpvAddress.FindControl("grdAddress"));

rgAddress.Rebind();

RadPageView rpvCMTContacts = (RadPageView)(rmMultiPage1.FindControl("rpvCMTContacts"));

RadGrid rgrdCMTContacts = (RadGrid)(rpvCMTContacts.FindControl("rgrdCMTContacts"));

rgrdCMTContacts.Rebind();

RadPageView rpvCMTOrders = (RadPageView)(rmMultiPage1.FindControl("rpvCMTOrders"));

RadGrid rgrdCMTOrders = (RadGrid)(rpvCMTOrders.FindControl("rgrdCMTOrders"));

rgrdCMTOrders.Rebind();

}

else if (e.CommandName == RadGrid.ExpandCollapseCommandName && e.Item is GridDataItem && e.Item.Expanded)

{

RadAjaxPanel rpInnerPanel1;

rpInnerPanel1 = (RadAjaxPanel)((GridDataItem)e.Item).ChildItem.FindControl("InnerPanel1");

rpInnerPanel1.Visible = false;

}

else if (e.CommandName == RadGrid.SortCommandName)

{

Session["BindgrdCMT"] = "Yes";

}

protected void grdInstalls_ItemCommand(object source, GridCommandEventArgs e)

{

if (e.CommandName == RadGrid.ExpandCollapseCommandName && e.Item is GridDataItem && !e.Item.Expanded)

{

RadAjaxPanel InnerPanelInstalls;

InnerPanelInstalls = (RadAjaxPanel)((GridDataItem)e.Item).ChildItem.FindControl("InnerPanelInstalls");

InnerPanelInstalls.Visible = true;

RadMultiPage rmpInstalls = (RadMultiPage)(InnerPanelInstalls.FindControl("rmpInstalls"));

RadPageView rpvInstContacts = (RadPageView)(rmpInstalls.FindControl("rpvInstContacts"));

RadGrid rgrdInstContacts = (RadGrid)(rpvInstContacts.FindControl("rgrdInstContacts"));

rgrdInstContacts.Rebind();

RadPageView rpvInstOrders = (RadPageView)(rmpInstalls.FindControl("rpvInstOrders"));

RadGrid rgrdInstOrders = (RadGrid)(rpvInstOrders.FindControl("rgrdInstOrders"));

rgrdInstOrders.Rebind();

RadPageView rpvInstEquipment = (RadPageView)(rmpInstalls.FindControl("rpvInstEquipment"));

RadGrid rgrdInstEquipment = (RadGrid)(rpvInstEquipment.FindControl("rgrdInstEquipment"));

rgrdInstEquipment.Rebind();

}

else if (e.CommandName == RadGrid.ExpandCollapseCommandName && e.Item is GridDataItem && e.Item.Expanded)

{

RadAjaxPanel InnerPanelInstalls;

InnerPanelInstalls = (RadAjaxPanel)((GridDataItem)e.Item).ChildItem.FindControl("InnerPanelInstalls");

InnerPanelInstalls.Visible = false;

}

protected void rgrdInstContacts_ItemCommand(object source, GridCommandEventArgs e)

{

if (e.CommandName == RadGrid.ExpandCollapseCommandName && e.Item is GridDataItem && !e.Item.Expanded)

{

RadAjaxPanel InnerPanelInstContacts;

InnerPanelInstContacts = (RadAjaxPanel)((GridDataItem)e.Item).ChildItem.FindControl("InnerPanelInstContacts");

InnerPanelInstContacts.Visible = true;

RadMultiPage rmpInstContacts = (RadMultiPage)(InnerPanelInstContacts.FindControl("rmpInstContacts"));

RadPageView rpvInstPhones = (RadPageView)(rmpInstContacts.FindControl("rpvInstPhones"));

RadGrid rgrdInstPhones = (RadGrid)(rpvInstPhones.FindControl("rgrdInstPhones"));

rgrdInstPhones.Rebind();

RadPageView rpvInstEmails = (RadPageView)(rmpInstContacts.FindControl("rpvInstEmails"));

RadGrid rgrdInstEmails = (RadGrid)(rpvInstEmails.FindControl("rgrdInstEmails"));

rgrdInstEmails.Rebind();

}

else if (e.CommandName == RadGrid.ExpandCollapseCommandName && e.Item is GridDataItem && e.Item.Expanded)

{

RadAjaxPanel InnerPanelInstContacts;

InnerPanelInstContacts = (RadAjaxPanel)((GridDataItem)e.Item).ChildItem.FindControl("InnerPanelInstContacts");

InnerPanelInstContacts.Visible = false;

}

protected void grdAddress_ItemCommand(object source, GridCommandEventArgs e)

{

if (e.CommandName == RadGrid.ExpandCollapseCommandName && e.Item is GridDataItem && !e.Item.Expanded)

{

RadAjaxPanel InnerPanel2;

InnerPanel2 = (RadAjaxPanel)((GridDataItem)e.Item).ChildItem.FindControl("InnerPanel2");

InnerPanel2.Visible = true;

RadGrid grdAddresses = (RadGrid)(InnerPanel2.FindControl("grdAddresses"));

grdAddresses.Rebind();

}

else if (e.CommandName == RadGrid.ExpandCollapseCommandName && e.Item is GridDataItem && e.Item.Expanded)

{

RadAjaxPanel InnerPanel2;

InnerPanel2 = (RadAjaxPanel)((GridDataItem)e.Item).ChildItem.FindControl("InnerPanel2");

InnerPanel2.Visible = false;

}

protected void grdAddresses_ItemCommand(object source, GridCommandEventArgs e)

{

if (e.CommandName == RadGrid.ExpandCollapseCommandName && e.Item is GridDataItem && !e.Item.Expanded)

{

RadAjaxPanel InnerPanel3;

InnerPanel3 = (RadAjaxPanel)((GridDataItem)e.Item).ChildItem.FindControl("InnerPanel3");

InnerPanel3.Visible = true;

RadMultiPage RadMultiPage2 = (RadMultiPage)(InnerPanel3.FindControl("RadMultiPage2"));

RadPageView rpvContacts = (RadPageView)(RadMultiPage2.FindControl("rpvContacts"));

RadGrid rgrdContacts = (RadGrid)(rpvContacts.FindControl("rgrdContacts"));

rgrdContacts.Rebind();

RadPageView rpvOrders = (RadPageView)(RadMultiPage2.FindControl("rpvOrders"));

RadGrid rgrdOrders = (RadGrid)(rpvOrders.FindControl("rgrdOrders"));

rgrdOrders.Rebind();

}

else if (e.CommandName == RadGrid.ExpandCollapseCommandName && e.Item is GridDataItem && e.Item.Expanded)

{

RadAjaxPanel InnerPanel3;

InnerPanel3 = (RadAjaxPanel)((GridDataItem)e.Item).ChildItem.FindControl("InnerPanel3");

InnerPanel3.Visible = false;

}

protected void rgrdContacts_ItemCommand(object source, GridCommandEventArgs e)

{

if (e.CommandName == RadGrid.ExpandCollapseCommandName && e.Item is GridDataItem && !e.Item.Expanded)

{

RadAjaxPanel InnerPanelContacts;

InnerPanelContacts = (RadAjaxPanel)((GridDataItem)e.Item).ChildItem.FindControl("InnerPanelContacts");

InnerPanelContacts.Visible = true;

RadMultiPage rmpContacts = (RadMultiPage)(InnerPanelContacts.FindControl("rmpContacts"));

RadPageView rpvPhones = (RadPageView)(rmpContacts.FindControl("rpvPhones"));

RadGrid rgrdPhones = (RadGrid)(rpvPhones.FindControl("rgrdPhones"));

rgrdPhones.Rebind();

RadPageView rpvEmails = (RadPageView)(rmpContacts.FindControl("rpvOrders"));

RadGrid rgrdEmails = (RadGrid)(rpvEmails.FindControl("rgrdEmails"));

rgrdEmails.Rebind();

}

else if (e.CommandName == RadGrid.ExpandCollapseCommandName && e.Item is GridDataItem && e.Item.Expanded)

{

RadAjaxPanel InnerPanelContacts;

InnerPanelContacts = (RadAjaxPanel)((GridDataItem)e.Item).ChildItem.FindControl("InnerPanelContacts");

InnerPanelContacts.Visible = false;

}

protected void rgrdCMTContacts_ItemCommand(object source, GridCommandEventArgs e)

{

if (e.CommandName == RadGrid.ExpandCollapseCommandName && e.Item is GridDataItem && !e.Item.Expanded)

{

RadAjaxPanel InnerPanelCMTContacts;

InnerPanelCMTContacts = (RadAjaxPanel)((GridDataItem)e.Item).ChildItem.FindControl("InnerPanelCMTContacts");

InnerPanelCMTContacts.Visible = true;

RadMultiPage rmpCMTContacts = (RadMultiPage)(InnerPanelCMTContacts.FindControl("rmpCMTContacts"));

RadPageView rpvCMTPhones = (RadPageView)(rmpCMTContacts.FindControl("rpvCMTPhones"));

RadGrid rgrdCMTPhones = (RadGrid)(rpvCMTPhones.FindControl("rgrdCMTPhones"));

rgrdCMTPhones.Rebind();

RadPageView rpvCMTEmails = (RadPageView)(rmpCMTContacts.FindControl("rpvCMTEmails"));

RadGrid rgrdCMTEmails = (RadGrid)(rpvCMTEmails.FindControl("rgrdCMTEmails"));

rgrdCMTEmails.Rebind();

}

else if (e.CommandName == RadGrid.ExpandCollapseCommandName && e.Item is GridDataItem && e.Item.Expanded)

{

RadAjaxPanel InnerPanelCMTContacts;

InnerPanelCMTContacts = (RadAjaxPanel)((GridDataItem)e.Item).ChildItem.FindControl("InnerPanelCMTContacts");

InnerPanelCMTContacts.Visible = false;

}

protected void grdCMT_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

if (Session["BindgrdCMT"] == "Yes" || !IsPostBack)

{

MethodBase lmth = MethodBase.GetCurrentMethod();

string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;

SqlConnection lconn = new SqlConnection(ConfigurationManager.ConnectionStrings["JDECommon"].ConnectionString);

SqlCommand lcmd = new SqlCommand();

lcmd.CommandTimeout = 600;

lcmd.CommandType = CommandType.StoredProcedure;

lcmd.Connection = lconn;

lcmd.Parameters.Add(new SqlParameter("@Sys", "JDERT"));

lcmd.Parameters.Add(new SqlParameter("@strWho", mcUserInfo.LoginName.ToUpper()));

if (!IsPostBack)

{

lcmd.CommandText = "dbo.uspGetCMTInformationByCustomerNameCityState";

lcmd.Parameters.Add(new SqlParameter("@strCustName", "Retrun Nothing"));

}

else

{

if (rtxtCMT.Text.Trim().Length > 0)

{

lcmd.CommandText = "dbo.uspGetCMTInformationByCMTNum";

lcmd.Parameters.Add(new SqlParameter("@intCMTNumber", Convert.ToInt32(rtxtCMT.Text.ToString().Trim())));

}

else if (rtxtJDENum.Text.Trim().Length > 0)

{

lcmd.CommandText = "dbo.uspGetCMTInformationByJDENum";

lcmd.Parameters.Add(new SqlParameter("@intJDENumber", Convert.ToInt32(rtxtJDENum.Text.ToString().Trim())));

}

else if (rtxtOrderNum.Text.Trim().Length > 0)

{

lcmd.CommandText = "dbo.uspGetCMTInformationByOrderNumber";

lcmd.Parameters.Add(new SqlParameter("@intOrderNumber", Convert.ToInt32(rtxtOrderNum.Text.ToString().Trim())));

}

else if (rtxtGP.Text.Trim().Length > 0)

{

lcmd.CommandText = "dbo.uspGetCMTInformationByGPNum";

lcmd.Parameters.Add(new SqlParameter("@strGPNumber", Convert.ToInt32(rtxtGP.Text.ToString().Trim())));

}

else if (rtxtTracking.Text.Trim().Length > 0)

{

lcmd.CommandText = "dbo.uspGetCMTInformationByTrackingNum";

lcmd.Parameters.Add(new SqlParameter("@strTrackingNum", Convert.ToInt32(rtxtTracking.Text.ToString().Trim())));

}

else

{

if

((rtxtCustUser.Text.Trim().Length == 0) && (rtxtEmail.Text.Trim().Length == 0) && (rtxtPhone.Text.Trim().Length == 0) && (rtxtTerr.Text.Trim().Length == 0))

{

lcmd.CommandText = "dbo.uspGetCMTInformationByCustomerNameCityState";

}

else

{

lcmd.CommandText = "dbo.uspGetCMTInformationByCustomerName";

}

if (rtxtCompanyName.Text.Trim().Length > 0)

{

lcmd.Parameters.Add(new SqlParameter("@strCustName", rtxtCompanyName.Text.ToString().Trim()));

}

if (rtxtCity.Text.Trim().Length > 0)

{

lcmd.Parameters.Add(new SqlParameter("@strCity", rtxtCity.Text.ToString().Trim()));

}

if (rtxtState.Text.Trim().Length > 0)

{

lcmd.Parameters.Add(new SqlParameter("@strState", rtxtState.Text.ToString().Trim()));

}

if (rtxtTerr.Text.Trim().Length > 0)

{

lcmd.Parameters.Add(new SqlParameter("@strTerr", rtxtTerr.Text.ToString().Trim()));

}

if (rtxtEmail.Text.Trim().Length > 0)

{

lcmd.Parameters.Add(new SqlParameter("@strEmail", rtxtEmail.Text.ToString().Trim()));

}

if (this.rtxtCustUser.Text.Trim().Length > 0)

{

lcmd.Parameters.Add(new SqlParameter("@strCustUser", rtxtCustUser.Text.ToString().Trim()));

}

if (this.rtxtPhone.Text.Trim().Length > 0)

{

lcmd.Parameters.Add(new SqlParameter("@strPhone", rtxtPhone.Text.ToString().Trim()));

}

SqlDataAdapter ldsa = new SqlDataAdapter(lcmd);

DataTable ldt = new DataTable();

try

{

lconn.Open();

ldsa.Fill(ldt);

grdCMT.DataSource = ldt;

if (ldt.Rows.Count <= 0)

{

grdCMT.Enabled = false;

}

else

{

grdCMT.Enabled = true;

}

catch (SqlException exSQL)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(exSQL, lsRoutineName, lcmd, Session["UserName"].ToString());

}

catch (Exception ex)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(ex, lsRoutineName, Session["UserName"].ToString());

}

finally

{

lconn.Close();

Session["BindgrdCMT"] = "No";

}

protected void grdAddress_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

MethodBase lmth = MethodBase.GetCurrentMethod();

string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;

SqlConnection lconn = new SqlConnection(ConfigurationManager.ConnectionStrings["JDECommon"].ConnectionString);

RadGrid nestedgrid = (RadGrid)source;

GridNestedViewItem dataItem = (GridNestedViewItem)nestedgrid.NamingContainer;

GridDataItem parentItem = dataItem.ParentItem;

int intCustID = Convert.ToInt32(parentItem.GetDataKeyValue("CustomerNumber").ToString());

SqlCommand lcmd = new SqlCommand();

lcmd.CommandTimeout = 600;

lcmd.CommandText = "dbo.uspGetActiveInactiveCountsByCMT";

lcmd.CommandType = CommandType.StoredProcedure;

lcmd.Connection = lconn;

lcmd.Parameters.Add(new SqlParameter("@Sys", "JDERT"));

lcmd.Parameters.Add(new SqlParameter("@strWho", mcUserInfo.LoginName.ToUpper()));

lcmd.Parameters.Add(new SqlParameter("@intCMT", intCustID));

SqlDataAdapter ldsa = new SqlDataAdapter(lcmd);

DataTable ldt = new DataTable();

try

{

lconn.Open();

ldsa.Fill(ldt);

nestedgrid.DataSource = ldt;

}

catch (SqlException exSQL)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(exSQL, lsRoutineName, lcmd, Session["UserName"].ToString());

}

catch (Exception ex)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(ex, lsRoutineName, Session["UserName"].ToString());

}

finally

{

lconn.Close();

}

protected void grdInstalls_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

MethodBase lmth = MethodBase.GetCurrentMethod();

string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;

SqlConnection lconn = new SqlConnection(ConfigurationManager.ConnectionStrings["JDECommon"].ConnectionString);

RadGrid nestedgrid = (RadGrid)source;

GridNestedViewItem dataItem = (GridNestedViewItem)nestedgrid.NamingContainer;

GridDataItem parentItem = dataItem.ParentItem;

int intCustID = Convert.ToInt32(parentItem.GetDataKeyValue("CustomerNumber").ToString());

SqlCommand lcmd = new SqlCommand();

lcmd.CommandTimeout = 600;

lcmd.CommandText = "dbo.uspGetInstallInfoForECSMTGridByCMTNum";

lcmd.CommandType = CommandType.StoredProcedure;

lcmd.Connection = lconn;

lcmd.Parameters.Add(new SqlParameter("@Sys", "JDERT"));

lcmd.Parameters.Add(new SqlParameter("@strWho", mcUserInfo.LoginName.ToUpper()));

lcmd.Parameters.Add(new SqlParameter("@intAN8", intCustID));

SqlDataAdapter ldsa = new SqlDataAdapter(lcmd);

DataTable ldt = new DataTable();

try

{

lconn.Open();

ldsa.Fill(ldt);

nestedgrid.DataSource = ldt;

}

catch (SqlException exSQL)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(exSQL, lsRoutineName, lcmd, Session["UserName"].ToString());

}

catch (Exception ex)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(ex, lsRoutineName, Session["UserName"].ToString());

}

finally

{

lconn.Close();

}

protected void grdAddresses_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

MethodBase lmth = MethodBase.GetCurrentMethod();

string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;

SqlConnection lconn = new SqlConnection(ConfigurationManager.ConnectionStrings["JDECommon"].ConnectionString);

RadGrid nestedgrid = (RadGrid)source;

GridNestedViewItem dataItem = (GridNestedViewItem)nestedgrid.NamingContainer;

GridDataItem parentItem = dataItem.ParentItem;

string strCustInfo = parentItem.GetDataKeyValue("CustNumAndType").ToString();

int intDash = strCustInfo.IndexOf("-", 0);

string strCustID = "";

string strCustType = "";

strCustID = strCustInfo.Substring(0, intDash);

strCustType = strCustInfo.Substring(intDash + 1);

int intCustID = Convert.ToInt32(strCustID);

SqlCommand lcmd = new SqlCommand();

lcmd.CommandTimeout = 600;

lcmd.CommandText = "dbo.uspGetAddressInfoForECSMTGridByCMTNumAndAddresssType";

lcmd.CommandType = CommandType.StoredProcedure;

lcmd.Connection = lconn;

lcmd.Parameters.Add(new SqlParameter("@Sys", "JDERT"));

lcmd.Parameters.Add(new SqlParameter("@strWho", mcUserInfo.LoginName.ToUpper()));

lcmd.Parameters.Add(new SqlParameter("@intAN8", intCustID));

lcmd.Parameters.Add(new SqlParameter("@strType", strCustType));

SqlDataAdapter ldsa = new SqlDataAdapter(lcmd);

DataTable ldt = new DataTable();

try

{

lconn.Open();

ldsa.Fill(ldt);

nestedgrid.DataSource = ldt;

}

catch (SqlException exSQL)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(exSQL, lsRoutineName, lcmd, Session["UserName"].ToString());

}

catch (Exception ex)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(ex, lsRoutineName, Session["UserName"].ToString());

}

finally

{

lconn.Close();

}

protected void rgrdOrders_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

MethodBase lmth = MethodBase.GetCurrentMethod();

string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;

SqlConnection lconn = new SqlConnection(ConfigurationManager.ConnectionStrings["JDECommon"].ConnectionString);

RadGrid nestedgrid = (RadGrid)source;

GridNestedViewItem dataItem = (GridNestedViewItem)nestedgrid.NamingContainer;

GridDataItem parentItem = dataItem.ParentItem;

string strCustInfo = parentItem.GetDataKeyValue("CustomerNumber").ToString();

int intCustID = Convert.ToInt32(strCustInfo);

SqlCommand lcmd = new SqlCommand();

lcmd.CommandTimeout = 600;

lcmd.CommandText = "dbo.uspGetOrderInfoForECSMTByAN8";

lcmd.CommandType = CommandType.StoredProcedure;

lcmd.Connection = lconn;

lcmd.Parameters.Add(new SqlParameter("@Sys", "JDERT"));

lcmd.Parameters.Add(new SqlParameter("@strWho", mcUserInfo.LoginName.ToUpper()));

lcmd.Parameters.Add(new SqlParameter("@intAN8", intCustID));

SqlDataAdapter ldsa = new SqlDataAdapter(lcmd);

DataTable ldt = new DataTable();

try

{

lconn.Open();

ldsa.Fill(ldt);

nestedgrid.DataSource = ldt;

}

catch (SqlException exSQL)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(exSQL, lsRoutineName, lcmd, Session["UserName"].ToString());

}

catch (Exception ex)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(ex, lsRoutineName, Session["UserName"].ToString());

}

finally

{

lconn.Close();

}

protected void rgrdCMTContacts_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

MethodBase lmth = MethodBase.GetCurrentMethod();

string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;

SqlConnection lconn = new SqlConnection(ConfigurationManager.ConnectionStrings["JDECommon"].ConnectionString);

RadGrid nestedgrid = (RadGrid)source;

GridNestedViewItem dataItem = (GridNestedViewItem)nestedgrid.NamingContainer;

GridDataItem parentItem = dataItem.ParentItem;

string strCustInfo = parentItem.GetDataKeyValue("CustomerNumber").ToString();

int intCustID = Convert.ToInt32(strCustInfo);

SqlCommand lcmd = new SqlCommand();

lcmd.CommandTimeout = 600;

lcmd.CommandText = "dbo.uspGetContactInfoForECSMTByCMT";

lcmd.CommandType = CommandType.StoredProcedure;

lcmd.Connection = lconn;

lcmd.Parameters.Add(new SqlParameter("@Sys", "JDERT"));

lcmd.Parameters.Add(new SqlParameter("@strWho", mcUserInfo.LoginName.ToUpper()));

lcmd.Parameters.Add(new SqlParameter("@intAN8", intCustID));

SqlDataAdapter ldsa = new SqlDataAdapter(lcmd);

DataTable ldt = new DataTable();

try

{

lconn.Open();

ldsa.Fill(ldt);

nestedgrid.DataSource = ldt;

}

catch (SqlException exSQL)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(exSQL, lsRoutineName, lcmd, Session["UserName"].ToString());

}

catch (Exception ex)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(ex, lsRoutineName, Session["UserName"].ToString());

}

finally

{

lconn.Close();

}

protected void rgrdInstEquipment_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

MethodBase lmth = MethodBase.GetCurrentMethod();

string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;

SqlConnection lconn = new SqlConnection(ConfigurationManager.ConnectionStrings["JDECommon"].ConnectionString);

RadGrid nestedgrid = (RadGrid)source;

GridNestedViewItem dataItem = (GridNestedViewItem)nestedgrid.NamingContainer;

GridDataItem parentItem = dataItem.ParentItem;

string strCustInfo = parentItem.GetDataKeyValue("CustomerNumber").ToString();

int intCustID = Convert.ToInt32(strCustInfo);

SqlCommand lcmd = new SqlCommand();

lcmd.CommandTimeout = 600;

lcmd.CommandText = "dbo.uspGetEquipmentInformationByCEI";

lcmd.CommandType = CommandType.StoredProcedure;

lcmd.Connection = lconn;

lcmd.Parameters.Add(new SqlParameter("@Sys", "JDERT"));

lcmd.Parameters.Add(new SqlParameter("@strWho", mcUserInfo.LoginName.ToUpper()));

lcmd.Parameters.Add(new SqlParameter("@intAN8", intCustID));

SqlDataAdapter ldsa = new SqlDataAdapter(lcmd);

DataTable ldt = new DataTable();

try

{

lconn.Open();

ldsa.Fill(ldt);

nestedgrid.DataSource = ldt;

}

catch (SqlException exSQL)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(exSQL, lsRoutineName, lcmd, Session["UserName"].ToString());

}

catch (Exception ex)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(ex, lsRoutineName, Session["UserName"].ToString());

}

finally

{

lconn.Close();

}

protected void rgrdContacts_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

MethodBase lmth = MethodBase.GetCurrentMethod();

string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;

SqlConnection lconn = new SqlConnection(ConfigurationManager.ConnectionStrings["JDECommon"].ConnectionString);

RadGrid nestedgrid = (RadGrid)source;

GridNestedViewItem dataItem = (GridNestedViewItem)nestedgrid.NamingContainer;

GridDataItem parentItem = dataItem.ParentItem;

string strCustInfo = parentItem.GetDataKeyValue("CustomerNumber").ToString();

int intCustID = Convert.ToInt32(strCustInfo);

SqlCommand lcmd = new SqlCommand();

lcmd.CommandTimeout = 600;

lcmd.CommandText = "dbo.uspGetContactInfoForECSMTByAN8";

lcmd.CommandType = CommandType.StoredProcedure;

lcmd.Connection = lconn;

lcmd.Parameters.Add(new SqlParameter("@Sys", "JDERT"));

lcmd.Parameters.Add(new SqlParameter("@strWho", mcUserInfo.LoginName.ToUpper()));

lcmd.Parameters.Add(new SqlParameter("@intAN8", intCustID));

SqlDataAdapter ldsa = new SqlDataAdapter(lcmd);

DataTable ldt = new DataTable();

try

{

lconn.Open();

ldsa.Fill(ldt);

nestedgrid.DataSource = ldt;

}

catch (SqlException exSQL)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(exSQL, lsRoutineName, lcmd, Session["UserName"].ToString());

}

catch (Exception ex)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(ex, lsRoutineName, Session["UserName"].ToString());

}

finally

{

lconn.Close();

}

protected void rgrdPhones_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

MethodBase lmth = MethodBase.GetCurrentMethod();

string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;

SqlConnection lconn = new SqlConnection(ConfigurationManager.ConnectionStrings["JDECommon"].ConnectionString);

RadGrid nestedgrid = (RadGrid)source;

GridNestedViewItem dataItem = (GridNestedViewItem)nestedgrid.NamingContainer;

GridDataItem parentItem = dataItem.ParentItem;

string strCustInfo = parentItem.GetDataKeyValue("ContactID").ToString();

int intDash = strCustInfo.IndexOf("-", 0);

string strCustID = "";

string strPhoneID = "";

strCustID = strCustInfo.Substring(0, intDash);

strPhoneID = strCustInfo.Substring(intDash + 1);

int intCustID = Convert.ToInt32(strCustID);

int intPhoneiD = Convert.ToInt32(strPhoneID);

SqlCommand lcmd = new SqlCommand();

lcmd.CommandTimeout = 600;

lcmd.CommandText = "dbo.uspGetPHoneByAN8andIDLN";

lcmd.CommandType = CommandType.StoredProcedure;

lcmd.Connection = lconn;

lcmd.Parameters.Add(new SqlParameter("@Sys", "JDERT"));

lcmd.Parameters.Add(new SqlParameter("@strWho", mcUserInfo.LoginName.ToUpper()));

lcmd.Parameters.Add(new SqlParameter("@intAN8", intCustID));

lcmd.Parameters.Add(new SqlParameter("@intIDLN", intPhoneiD));

SqlDataAdapter ldsa = new SqlDataAdapter(lcmd);

DataTable ldt = new DataTable();

try

{

lconn.Open();

ldsa.Fill(ldt);

nestedgrid.DataSource = ldt;

}

catch (SqlException exSQL)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(exSQL, lsRoutineName, lcmd, Session["UserName"].ToString());

}

catch (Exception ex)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(ex, lsRoutineName, Session["UserName"].ToString());

}

finally

{

lconn.Close();

}

protected void rgrdEMails_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

MethodBase lmth = MethodBase.GetCurrentMethod();

string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;

SqlConnection lconn = new SqlConnection(ConfigurationManager.ConnectionStrings["JDECommon"].ConnectionString);

RadGrid nestedgrid = (RadGrid)source;

GridNestedViewItem dataItem = (GridNestedViewItem)nestedgrid.NamingContainer;

GridDataItem parentItem = dataItem.ParentItem;

string strCustInfo = parentItem.GetDataKeyValue("ContactID").ToString();

int intDash = strCustInfo.IndexOf("-", 0);

string strCustID = "";

string strPhoneID = "";

strCustID = strCustInfo.Substring(0, intDash);

strPhoneID = strCustInfo.Substring(intDash + 1);

int intCustID = Convert.ToInt32(strCustID);

int intPhoneiD = Convert.ToInt32(strPhoneID);

SqlCommand lcmd = new SqlCommand();

lcmd.CommandTimeout = 600;

lcmd.CommandText = "dbo.uspGetEMailsByAN8andIDLN";

lcmd.CommandType = CommandType.StoredProcedure;

lcmd.Connection = lconn;

lcmd.Parameters.Add(new SqlParameter("@Sys", "JDERT"));

lcmd.Parameters.Add(new SqlParameter("@strWho", mcUserInfo.LoginName.ToUpper()));

lcmd.Parameters.Add(new SqlParameter("@intAN8", intCustID));

lcmd.Parameters.Add(new SqlParameter("@intIDLN", intPhoneiD));

SqlDataAdapter ldsa = new SqlDataAdapter(lcmd);

DataTable ldt = new DataTable();

try

{

lconn.Open();

ldsa.Fill(ldt);

nestedgrid.DataSource = ldt;

}

catch (SqlException exSQL)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(exSQL, lsRoutineName, lcmd, Session["UserName"].ToString());

}

catch (Exception ex)

{

Marlin.ErrorHandlers.ErrorAtServer lobjError = new Marlin.ErrorHandlers.ErrorAtServer();

lobjError.ProcessError(ex, lsRoutineName, Session["UserName"].ToString());

}

finally

{

lconn.Close();

}

protected void tcbSearch_OnClick(object sender, System.EventArgs e)

{

grdCMT.DataSource = null;

Session["BindgrdCMT"] = "Yes";

grdCMT.Rebind();

}

protected void tcbClear_OnClick(object sender, System.EventArgs e)

{

rtxtCity.Text = "";

rtxtCMT.Text = "";

rtxtCompanyName.Text = "";

rtxtCustUser.Text = "";

rtxtEmail.Text = "";

rtxtGP.Text = "";

rtxtIncident.Text = "";

rtxtInstaller.Text = "";

rtxtJDENum.Text = "";

rtxtOrderNum.Text = "";

rtxtPhone.Text = "";

rtxtPO.Text = "";

rtxtProduct.Text = "";

rtxtRM.Text = "";

rtxtState.Text = "";

rtxtTerr.Text = "";

rtxtTracking.Text = "";

rtxtZip.Text = "";

grdCMT.DataSource = null;

}

protected void rgrdOrders_ItemCreated(object sender, GridItemEventArgs e)

{

if (e.Item is GridDataItem)

{

HyperLink viewLink = (HyperLink)e.Item.FindControl("ViewLink");

viewLink.Attributes["href"] = "#";

viewLink.Attributes["onclick"] = String.Format("return ShowViewForm('{0}','{1}');", e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["OrderNumType"], e.Item.ItemIndex);

HyperLink validationLink = (HyperLink)e.Item.FindControl("ValidationLink");

validationLink.Attributes["href"] = "#";

validationLink.Attributes["onclick"] = String.Format("return ShowOrdValidationForm('{0}','{1}');", e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["OrderNumType"], e.Item.ItemIndex);

}

protected void rgrdCMTOrders_ItemCreated(object sender, GridItemEventArgs e)

{

if (e.Item is GridDataItem)

{

HyperLink viewLink = (HyperLink)e.Item.FindControl("CMTViewLink");

viewLink.Attributes["href"] = "#";

viewLink.Attributes["onclick"] = String.Format("return ShowViewForm('{0}','{1}');", e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["OrderNumType"], e.Item.ItemIndex);

HyperLink validationLink = (HyperLink)e.Item.FindControl("CMTValidationLink");

validationLink.Attributes["href"] = "#";

validationLink.Attributes["onclick"] = String.Format("return ShowOrdValidationForm('{0}','{1}');", e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["OrderNumType"], e.Item.ItemIndex);

}

Grid

answered on 19 May 2011

7 answers

108 views

How to use List<T> as Source in Hierarchy Grid

Greetings,

I have an odd request. I am making a 3-table hierarchy grid and I need the for the data source of the 3rd grid, to use a List from it's parent grid( the 2nd grid in the hierarchy).

Grid A - datasource is a List<EventDto> called "results"

Grid B - datasource is one or more records of type List<EntityDto> called "details." Details has several fields that are displayed, and it also has another List, of type <EntityRowDto>, and it is possible to have one or more of these (which is why I need a 3rd grid).

So how do I pull out all <EntityRowDto> records for a given detail and set it as the datasource for Grid C?

ASP.NET Markup for the grid:
<telerik:RadGrid ID="radGridNewAuditLog" runat="server" AutoGenerateColumns="False"
                     GridLines="None" Skin="Office2007" AllowFilteringByColumn="True" AllowPaging="True"
                     AllowSorting="True" OnNeedDataSource="radGridNewAuditLog_NeedDataSource" EnableLinqExpressions="False"
                     Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Size="Small"
                     Font-Strikeout="False" Font-Underline="False"
                     OnDetailTableDataBind="radGridNewAuditLog_DetailTableDatabind"
                     OnPreRender="radGridNewAuditLog_PreRender">
      <ClientSettings Selecting-AllowRowSelect="false" EnableRowHoverStyle="true">
          <ClientEvents />
      </ClientSettings>
      <PagerStyle Position="TopAndBottom" />
      <MasterTableView PageSize="20" EnableNoRecordsTemplate="true" ShowHeadersWhenNoRecords="true"
          Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Size="Small"
          Font-Strikeout="False" Font-Underline="False" DataKeyNames="SessionId" HierarchyDefaultExpanded="true"
          HierarchyLoadMode="ServerOnDemand">
          <DetailTables>
            <telerik:GridTableView Name="Details" DataKeyNames="EntityId" HierarchyDefaultExpanded="true">
                <Columns>
                <telerik:GridBoundColumn DataField="EntityId" UniqueName="EntityId" Visible="true"/>
                <telerik:GridBoundColumn DataField="EntityName" HeaderText="Entity Name" UniqueName="EntityName"
                                     CurrentFilterFunction="Contains" AutoPostBackOnFilter="true"/>
                <telerik:GridBoundColumn DataField="EntitySystem" HeaderText="System" UniqueName="EntitySystem"
                                     CurrentFilterFunction="Contains" AutoPostBackOnFilter="true"/>
                </Columns>
            </telerik:GridTableView>
          </DetailTables>
          <RowIndicatorColumn>
              <HeaderStyle Width="20px"></HeaderStyle>
          </RowIndicatorColumn>
          <ExpandCollapseColumn>
              <HeaderStyle Width="20px"></HeaderStyle>
          </ExpandCollapseColumn>
          <Columns>
            <telerik:GridBoundColumn DataField="EventType" HeaderText="Event" UniqueName="EventType"
                                     CurrentFilterFunction="Contains" AutoPostBackOnFilter="true"/>
            <telerik:GridBoundColumn DataField="Username" HeaderText="User" UniqueName="Username"
                                     CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" />
            <telerik:GridBoundColumn DataField="Description" HeaderText="Description" UniqueName="Description"
                                     AllowFiltering="false" />
            <telerik:GridBoundColumn DataField="InitiatingApp" HeaderText="Initiating App" UniqueName="InitiatingApp"
                                     CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" />
            <telerik:GridBoundColumn DataField="EventId" UniqueName="EventId" Visible="false"/>
            <telerik:GridBoundColumn HeaderText="Created On" ItemStyle-Width="160px" UniqueName="CreatedOn" DataField="CreatedOn"
                            AllowFiltering="false" DataType="System.DateTime" DataFormatString="{0:MM/dd/yyyy hh:mm tt CT}">
            </telerik:GridBoundColumn>
          </Columns>
      </MasterTableView>
    </telerik:RadGrid>

C# CodeBehind:
protected void radGridNewAuditLog_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
        if (!e.IsFromDetailTable)
            SetGridDataSource();
}

protected void radGridNewAuditLog_DetailTableDatabind(object sender, Telerik.Web.UI.GridDetailTableDataBindEventArgs e)
        {
            GridDataItem dataItem = (GridDataItem)e.DetailTableView.ParentItem;
            List<EntityDto> details = new List<EntityDto>();
            switch (e.DetailTableView.Name)
            {
                case "Details":
                    {

                        LoggingRepository logrepodetails = new LoggingRepository();
                        TableCell cellEventId = dataItem["EventId"];
                        string strEventId = cellEventId.Text;
                        int eventId = -1;
                        int.TryParse(strEventId, out eventId);
                        if (eventId <= 0)
                            return;
                        details = logrepodetails.GetEventDetails(eventId);

                        e.DetailTableView.DataSource = details;


                        break;
                    }

            }

        }

protected void SetGridDataSource()
        {
            LoggingRepository logrepo = new LoggingRepository();
            List<string> et = new List<string>();
            List<EventDto> results=null;


            if (_userid == null)
                results = logrepo.GetEvents(new Guid(), et, (DateTime)FromDateText.SelectedDate, (DateTime)ToDateText.SelectedDate); //All are optional. If dates are blank I default to last 5 days
            else
            {
                Guid gUserId = new Guid(_userid);
                results = logrepo.GetEvents(gUserId, et, (DateTime)FromDateText.SelectedDate, (DateTime)ToDateText.SelectedDate); //All are optional. If dates are blank I default to last 5 days
            }

            if (results.Count == 0)
                return;
            radGridNewAuditLog.DataSource = results;

        }

protected void radGridNewAuditLog_PreRender(object sender, EventArgs e)
        {
            HideExpandColumnRecursive(radGridNewAuditLog.MasterTableView);
        }

        public void HideExpandColumnRecursive(GridTableView tableView)
        {
            GridItem[] nestedViewItems = tableView.GetItems(GridItemType.NestedView);
            foreach (GridNestedViewItem nestedViewItem in nestedViewItems)
            {
                foreach (GridTableView nestedView in nestedViewItem.NestedTableViews)
                {
                    if (nestedView.Items.Count == 0)
                    {
                        TableCell cell = nestedView.ParentItem["ExpandColumn"];
                        cell.Controls[0].Visible = false;
                        nestedViewItem.Visible = false;
                    }
                    if (nestedView.HasDetailTables)
                    {
                        HideExpandColumnRecursive(nestedView);
                    }
                }
            }
        }

Grid

answered on 19 May 2011

1 answer

222 views

Remove RadToolBar-border

Hello
How can I remove the border of the RadToolBar?
This is my code:

<telerik:RadToolBar ID="RadToolBar_Layout" runat="server">

<Items>

<telerik:RadToolBarDropDown CssClass="CustomTelerik" ImageUrl="~/Ressources/Images/Telerik/Dropdown/pagemap_16x16.png">

<Buttons>

<telerik:RadToolBarButton id="OpenBoth" Text="Normal" CheckOnClick="true" AllowSelfUnCheck="true" ImageUrl="~/Ressources/Images/Telerik/Dropdown/pagemap_normal_16x16_blue.png" />

<telerik:RadToolBarButton id="CloseBoth" Text="Vollbild" CheckOnClick="true" AllowSelfUnCheck="true" ImageUrl="~/Ressources/Images/Telerik/Dropdown/pagemap_full_16x16_blue.png" />

<telerik:RadToolBarButton id="CloseLeft" Text="Linke Sidebar" CheckOnClick="true" AllowSelfUnCheck="true" ImageUrl="~/Ressources/Images/Telerik/Dropdown/pagemap_left_16x16_blue.png" />

<telerik:RadToolBarButton id="CloseRight" Text="RechteSidebar" CheckOnClick="true" AllowSelfUnCheck="true" ImageUrl="~/Ressources/Images/Telerik/Dropdown/pagemap_right_16x16_blue.png"></telerik:RadToolBarButton>

</Buttons>

</telerik:RadToolBarDropDown>

</Items>

</telerik:RadToolBar>

I have try to remove the border over a custom CSS class. But it doesn't work...

.CustomTelerik

{

background: none;

border: 0 none !important;

text-decoration: none;

border-bottom-width: 0px !important;

}

In the attached files you can see how it looks at the moment.
And by the way. Is it possible to change the dropdown side, so that it has a left "float".

Thanks for the help!

kind regard
Luca

ToolBar

answered on 19 May 2011

18 answers

640 views

TreeList datasources

Hello,

maybe I am missing something, but basically I am trying to load the Treelist on demand only, loading the data as the user drilldown.
Is it possible to do such a thing with the current treelist control ?

I cannot seem to find any property to set on the server side in order to tell that an item has children and therefore needs to have the "expand" capability.

The idea would be to use functionalities such as WebMethod databinding (treeview) in order to do a proper drilldown in the treelist.

Is/will something like this be possible ?

Thank you

TreeList

answered on 19 May 2011

1 answer

92 views

Limit the scheduler (help ;-) )

I got a scheduler that is inheriting from the RadScheduler and I would like to limit the available dates on it (Range).
For example I want the range of the scheduler will be between 1/1/2009 until 1/1/2012.
I want the user would not be able to see or choose or create anything that is not between these dates.
The problems I have are in the following parts :
The scheduler header have the navigation where the option to choose a date should be only in the relevant dates.
If the user Create / Modify an Appointment the StartDate and EndDate selectors should behave the same .
The scheduler navigation should stay in bound of the dates.
There is no Markup to show as it is dynamically created all in code and I would like to keep it this way :-)
Any ideas, guidelines ?

P.S.
I could not find anywhere in the forums or kb's or examples that would point me in the right direction.
Thanks again.

Scheduler

answered on 19 May 2011

Top users last month