Questions on UI for ASP.NET AJAX Forum

110,708 questions

1 answer

68 views

How to strip out image paths in RadEditor HTML view

Hi,

I'm using Radeditor to do some HTML file editing on my website and all the Images on my HTML page is from a shared path that I have assigned to my RadEditor Image manager. When I include any Image on to the content area of the RadEditor it shows the complete shared path in the image src attribute.

Is there any way that I could show just a relative path ?

For example : my images are in a shared path //serverName/FolderName/Images and I'm using an image from this path which is shown in the HTML view as <image src ="//serverName/FolderName/Images/a.jpeg "/>

Is it possible to make the RadEditor to show just a relative path like <image src ="/Images/a.jpeg "/> in the HTML view, I saw some ideas from other threads related to this topic but they are not applicable to the latest version of RadControls. Please let me know your thoughts on this.

Thanks,
Mani

Editor

answered on 19 May 2011

1 answer

76 views

Accessing AsyncUpload from FileExplorer

Hi is there a way how to get full access to the AsynUpload used in the FileExplorer. I want to use some clientside events on the FileExporer related to the AsyncUploader like OnClientFilesSelected. However I can't seem to find these in the FileExplorer.

Thanks a lot

AsyncUpload

answered on 19 May 2011

1 answer

99 views

Resetting controls

Hello,
In the attached screen shot you will see on the left side I have 3 drop down boxes and below them I have a list of employees.
The drop down boxes are Division, region, branch. Upon choosing these it filters the employees to show.
When the user selects an employee then I populate the information on the right side. I am mainly concerned about the pie chart, the bar chart, and the radgrid.

I need to get 2 things done, and I don't know how to get this accomplished.

1. When an employee is selected I need in the bar chart that employee's bars to be a diffenent color, shows that this employee is selected. http://www.telerik.com/community/forums/aspnet-ajax/chart/change-color-of-bars-for-selected-user.aspx corresponding help request.

2. When the user chooses another division, region or branch, I need the pie chart, bar chart, and radgrid to blank out.

The Division, Region, Branch and employee listing are in a user control. The radgrid is in a user control. The chart on on the page I am using the sqldatasource control to do my binding.

All controls are in an Ajax update panel. I have an event handler which fires when an employee is selected for populating that employees info for the right side of the page. I have tried this with selecting of Division, Region and branch but it did not work.
In this event I tried setting the datasource to null and rebinding, I tried .RemoveSeries but nothing has worked.

A small working sample would be very helpful. In item 1 above in the other post they just supplied a few lines of code, not sure where to put that code ect...

If I need to supply specific code or anything else just let me know.
Thanks,
Keith.

Chart (Obsolete)

answered on 19 May 2011

4 answers

50 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

76 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

69 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

132 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

431 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

110 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

99 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

Top users last month