| <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" |
| DataSourceID="EntityDataSource1" GridLines="None"> |
| <MasterTableView datakeynames="ProductID" datasourceid="EntityDataSource1"> |
| <Columns> |
| <telerik:GridEditCommandColumn ButtonType="LinkButton"> |
| </telerik:GridEditCommandColumn> |
| <telerik:GridBoundColumn DataField="Name" HeaderText="Name" |
| SortExpression="Name" UniqueName="Name"> |
| </telerik:GridBoundColumn> |
| </Columns> |
| </MasterTableView> |
| </telerik:RadGrid> |
| <browsers> |
| <browser refID="Default"> |
| <controlAdapters> |
| <adapter controlType="System.Web.UI.Page" adapterType="Telerik.Web.UI.RadSessionPageStateCompression" /> |
| </controlAdapters> |
| </browser> |
| </browsers> |

| <%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="~/MasterPage.master" |
| CodeFile="Tsk200.aspx.cs" Inherits="Tak200" EnableEventValidation="false" %> |
| <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> |
| <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %> |
| <asp:Content ID="Content1" ContentPlaceHolderID="CSS_ScriptPlaceHolder" runat="Server"> |
| <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"> |
| <link href="CSS/Css.css" rel="stylesheet" type="text/css" /> |
| <script type="text/javascript"> |
| function onAgrtypeOther() { |
| if (document.getElementById('tabTskDet_tabAgreInfo_ddlAgreementType').selectedIndex == 4) |
| document.getElementById('trAgrTypeOther').style.visibility = 'visible'; |
| else |
| document.getElementById('trAgrTypeOther').style.visibility = 'hidden'; |
| return false; |
| } |
| function onPertypeOther() { |
| if (document.getElementById('tabTskDet_tabPermit_ddlPermitType').selectedIndex == 3) |
| document.getElementById('tdPerTypeOther').style.visibility = 'visible'; |
| else |
| document.getElementById('tdPerTypeOther').style.visibility = 'hidden'; |
| return false; |
| } |
| function onSitetypeOther() { |
| if (document.getElementById('tabTskDet_tabGenTskDet_ddlSiteType').selectedIndex == 4) |
| document.getElementById('tabTskDet_tabGenTskDet_tdSiteTypeOth').style.visibility = 'visible'; |
| else |
| document.getElementById('tabTskDet_tabGenTskDet_tdSiteTypeOth').style.visibility = 'hidden'; |
| return false; |
| } |
| function onPwrtypeOther() { |
| if (document.getElementById('tabTskDet_tabGenTskDet_ddlPwrStatus').selectedIndex == 4) |
| document.getElementById('tabTskDet_tabGenTskDet_tdPwrStatusOth').style.visibility = 'visible'; |
| else |
| document.getElementById('tabTskDet_tabGenTskDet_tdPwrStatusOth').style.visibility = 'hidden'; |
| return false; |
| } |
| function onEqiLoctypeOther() { |
| if (document.getElementById('tabTskDet_tabGenTskDet_ddlEquiLocDesc').selectedIndex == 3) |
| document.getElementById('tabTskDet_tabGenTskDet_tdEquiLocDescOth').style.visibility = 'visible'; |
| else |
| document.getElementById('tabTskDet_tabGenTskDet_tdEquiLocDescOth').style.visibility = 'hidden'; |
| return false; |
| } |
| function showOthRea() { |
| var dt1 = new Date(document.getElementById("tabTskDet_tabGenTskDet_txtConstSchCompDate").value); |
| var dt2 = new Date(document.getElementById("tabTskDet_tabGenTskDet_txtConstActCompDate").value); |
| if (dt1 < dt2) { |
| document.getElementById("tabTskDet_tabGenTskDet_tdDtLateRea306").style.display = "block" |
| } |
| else { |
| document.getElementById("tabTskDet_tabGenTskDet_tdDtLateRea306").style.display = "none" |
| document.getElementById("tabTskDet_tabGenTskDet_lblDueDtLateRea").value = '' |
| } |
| } |
| function showOthRea303() { |
| var dt1 = new Date(document.getElementById("tabTskDet_tabGenTskDet_txtContSchComDt").value); |
| var dt2 = new Date(document.getElementById("tabTskDet_tabGenTskDet_txtConstActComDt").value); |
| if (dt1 < dt2) { |
| document.getElementById("tabTskDet_tabGenTskDet_tdDtLateRea303").style.display = "block" |
| } |
| else { |
| document.getElementById("tabTskDet_tabGenTskDet_tdDtLateRea303").style.display = "none" |
| document.getElementById("tabTskDet_tabGenTskDet_lbl303DueDtLateRea").value = '' |
| } |
| } |
| function DisplayDateToday(sender, args) { |
| if (sender._selectedDate == null) { |
| sender._selectedDate = new Date(); |
| } |
| } |
| function onRequestStart(sender, args) { |
| if (args.get_eventTarget().indexOf("ExportToExcelButton") >= 0 || |
| args.get_eventTarget().indexOf("ExportToWordButton") >= 0 || |
| args.get_eventTarget().indexOf("ExportToPdfButton") >= 0 || |
| args.get_eventTarget().indexOf("ExportToCsvButton") >= 0) { |
| args.set_enableAjax(false); |
| } |
| } |
| </script> |
| <style> |
| .modalBackground |
| { |
| background-color: Gray; |
| filter: alpha(opacity=70); |
| opacity: 0.7; |
| } |
| .AjaxCalendar .ajax__calendar_container |
| { |
| border: 1px solid #646464; |
| background-color: White; |
| color: Black; |
| } |
| .AjaxCalendar .ajax__calendar_other .ajax__calendar_day, .AjaxCalendar .ajax__calendar_other .ajax__calendar_year |
| { |
| color: #999999; |
| } |
| .AjaxCalendar .ajax__calendar_hover .ajax__calendar_day, .AjaxCalendar .ajax__calendar_hover .ajax__calendar_month, .AjaxCalendar .ajax__calendar_hover .ajax__calendar_year |
| { |
| color: Red; |
| } |
| .AjaxCalendar .ajax__calendar_active .ajax__calendar_day, .AjaxCalendar .ajax__calendar_active .ajax__calendar_month, .AjaxCalendar .ajax__calendar_active .ajax__calendar_year |
| { |
| background-color: #78C43C; |
| color: Black; |
| text-align: center; |
| font-weight: bold; |
| } |
| .rgPageFirst, .rgPagePrev, .rgPageNext, .rgPageLast |
| { |
| display: none !important; |
| } |
| div.RadGrid_Default .rgHeader, div.RadGrid_Default th.rgResizeCol |
| { |
| background-image: none; |
| } |
| </style> |
| </telerik:RadCodeBlock> |
| </asp:Content> |
| <asp:Content ID="Content2" ContentPlaceHolderID="PagePlaceholder" runat="Server"> |
| <div style="width: 100%; padding-top: 20px"> |
| <table style="width: 98%"> |
| <tr> |
| <td colspan="2"> |
| <asp:Label runat="server" Font-Bold="true" Font-Size="14pt" ID="lblTskName"></asp:Label> |
| </td> |
| </tr> |
| <tr> |
| <td colspan="2"> |
| <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> |
| </telerik:RadScriptManager> |
| <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> |
| <ClientEvents OnRequestStart="onRequestStart" /> |
| <AjaxSettings> |
| <telerik:AjaxSetting AjaxControlID="rg200"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="rg200" LoadingPanelID="RadAjaxLoadingPanel1" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| </AjaxSettings> |
| </telerik:RadAjaxManager> |
| <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Default"> |
| </telerik:RadAjaxLoadingPanel> |
| <telerik:RadGrid ID="rg200" runat="server" AutoGenerateColumns="False" PageSize="30" |
| Height="550px" OnNeedDataSource="rg200_NeedDataSource" Width="100%" AllowPaging="True" |
| AllowSorting="True" AllowMultiRowSelection="True" EnableHeaderContextMenu="True" |
| GridLines="None" EnableHeaderContextFilterMenu="True" AllowMultiRowEdit="True" |
| AllowFilteringByColumn="True" OnPreRender="rg200_PreRender" OnItemCreated="rg200_ItemCreated" |
| EnableViewState="False" OnUpdateCommand="rg200_UpdateCommand"> |
| <HeaderStyle Height="20px" BackColor="#004000" Font-Size="8pt" Font-Bold="True" ForeColor="White" |
| HorizontalAlign="Center" BorderColor="White" BorderWidth="1px" /> |
| <ExportSettings IgnorePaging="true" ExportOnlyData="true"> |
| <Pdf AllowModify="false" AllowPrinting="true" PageBottomMargin="" PageFooterMargin="" |
| PageHeaderMargin="" PageHeight="11in" PageLeftMargin="" PageRightMargin="" PageTopMargin="" |
| PageWidth="14in" /> |
| </ExportSettings> |
| <MasterTableView GridLines="None" DataKeyNames="orderId" CommandItemDisplay="Top" |
| EditMode="InPlace"> |
| <CommandItemSettings ShowExportToWordButton="true" ShowExportToExcelButton="true" |
| ShowExportToCsvButton="true" ShowExportToPdfButton="true" ShowAddNewRecordButton="false" /> |
| <Columns> |
| <telerik:GridClientSelectColumn UniqueName="ClientSelectColumn" HeaderStyle-Width="3%" |
| ItemStyle-Width="3%"> |
| <HeaderStyle Width="3%"></HeaderStyle> |
| <ItemStyle Width="3%"></ItemStyle> |
| </telerik:GridClientSelectColumn> |
| <telerik:GridBoundColumn UniqueName="sId" HeaderText="sId" DataField="sId" Visible="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="orderId" HeaderText="orderId" DataField="orderId"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="Customer Name" HeaderText="Customer Name" DataField="Customer Name" |
| ReadOnly="true"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="Market Name" HeaderText="Market Name" DataField="Market Name" |
| ReadOnly="true"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="LOB" HeaderText="LOB" DataField="LOB" ReadOnly="true"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="Headend Name" HeaderText="Headend Name" DataField="Headend Name" |
| ReadOnly="true"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="Project Name" HeaderText="Project Name" DataField="Project Name" |
| ReadOnly="true"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="Site Name" HeaderText="Site Name" DataField="Site Name" |
| ReadOnly="true"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="Task Status" HeaderText="Task Status" DataField="Task Status" |
| ReadOnly="true"> |
| </telerik:GridBoundColumn> |
| <%--<telerik:GridTemplateColumn UniqueName="Clarify Account Nbr" HeaderText="Clarify Account Nbr" |
| DataField="Clarify Account Nbr"> |
| <ItemTemplate> |
| <asp:Label ID="lblClarifyAccountNbr" Text='<%# Eval("Clarify Account Nbr") %>' runat="server"></asp:Label> |
| </ItemTemplate> |
| <EditItemTemplate> |
| <asp:TextBox ID="txtClarifyAccountNbr" Text='<%# Eval("Clarify Account Nbr") %>' |
| runat="server"></asp:TextBox> |
| </EditItemTemplate> |
| </telerik:GridTemplateColumn>--%> |
| <telerik:GridBoundColumn UniqueName="Clarify Account Nbr" HeaderText="Clarify Account Nbr" |
| DataField="Clarify Account Nbr"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="Site ID" HeaderText="Site ID" DataField="Site ID"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="Quote ID" HeaderText="Quote ID" DataField="Quote ID"> |
| </telerik:GridBoundColumn> |
| <telerik:GridCheckBoxColumn UniqueName="EDP Created?" HeaderText="EDP Created?" DataField="EDP Created?"> |
| </telerik:GridCheckBoxColumn> |
| <telerik:GridEditCommandColumn UniqueName="ECC200"> |
| </telerik:GridEditCommandColumn> |
| </Columns> |
| <PagerStyle AlwaysVisible="True"></PagerStyle> |
| </MasterTableView> |
| <ClientSettings EnableRowHoverStyle="true" ReorderColumnsOnClient="false" AllowDragToGroup="false" |
| AllowColumnsReorder="True"> |
| <Scrolling AllowScroll="true" EnableVirtualScrollPaging="false" UseStaticHeaders="true" /> |
| <Selecting AllowRowSelect="True"></Selecting> |
| <Resizing AllowRowResize="true" AllowColumnResize="True" EnableRealTimeResize="True" |
| ResizeGridOnColumnResize="False"></Resizing> |
| <%--<ClientEvents OnGridCreated="GridCreated" OnCommand="GridCommand" />--%> |
| </ClientSettings> |
| <PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="true"></PagerStyle> |
| </telerik:RadGrid> |
| </td> |
| </tr> |
| <tr> |
| <td colspan="2"> |
| |
| </td> |
| </tr> |
| </table> |
| </div> |
| </asp:Content> |
| protected void Page_Load(object sender, EventArgs e) |
| { |
| try |
| { |
| if (!IsPostBack) |
| { |
| Session["SearchRes"] = null; |
| if (Session["TaskName"] != null) |
| lblTskName.Text = Session["TaskName"].ToString(); |
| Session["FilColms"] = null; |
| Session["SortExp"] = null; |
| Session["FilExp"] = null; |
| Session["ViewAll"] = null; |
| BindGrid(); |
| } |
| } |
| catch (Exception ex) |
| { |
| throw ex; |
| } |
| } |
| private void BindGrid() |
| { |
| try |
| { |
| DataSet dsResult = new DataSet(); |
| clsSearch_BL clsObj = new clsSearch_BL(); |
| clsObj.TaskID = (string)Session["TaskID"]; |
| clsObj.CustName = (string)Session["CustName"]; |
| clsObj.MarketName = (string)Session["MarketName"]; |
| clsObj.HeadendName = (string)Session["HeadendName"]; |
| clsObj.SiteName = (string)Session["SiteName"]; |
| clsObj.TaskStatus = (string)Session["TaskStatus"]; |
| clsObj.OrdType = (string)Session["OrdType"]; |
| clsObj.OrdStatus = (string)Session["OrdStatus"]; |
| clsObj.ProName = (string)Session["ProName"]; |
| clsObj.LOC = (string)Session["LOC"]; |
| clsObj.QuoteID = (string)Session["QuoteID"]; |
| clsObj.CMNumber = (string)Session["CMNumber"]; |
| if (Session["SearchRes"] == null) |
| { |
| dsResult = clsObj.getSearchResults_BL(clsObj); |
| Session["SearchRes"] = dsResult; |
| } |
| else |
| dsResult = (DataSet)Session["SearchRes"]; |
| DataView dataView = dsResult.Tables[0].DefaultView; |
| rg200.DataSource = dsResult; |
| //rg200.DataBind(); |
| } |
| catch (Exception ex) |
| { |
| throw ex; |
| } |
| } |
| protected void rg200_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) |
| { |
| BindGrid(); |
| } |
| protected void rg200_PreRender(object sender, EventArgs e) |
| { |
| rg200.MasterTableView.GetColumnSafe("RowIndicator").Display = false; |
| } |
| protected void rg200_ItemCreated(object sender, GridItemEventArgs e) |
| { |
| if (e.Item is GridPagerItem) |
| { |
| RadComboBox combo = (e.Item as GridPagerItem).FindControl("PageSizeComboBox") as RadComboBox; |
| // The number of items shown when all is selected |
| int allRowsCount = int.MaxValue; |
| // Remove duplicates |
| RadComboBoxItem duplicate = combo.Items.FindItemByValue(allRowsCount.ToString()); |
| if (duplicate != null) |
| { |
| duplicate.Remove(); |
| } |
| // Create a new item for showing all |
| RadComboBoxItem item = new RadComboBoxItem("All", allRowsCount.ToString()); |
| item.Attributes.Add("ownerTableViewId", e.Item.OwnerTableView.ClientID); |
| combo.Items.Add(item); |
| // Set the current pagesize as the selected value |
| combo.Items.FindItemByValue(rg200.PageSize.ToString()).Selected = true; |
| } |
| } |
| protected void rg200_UpdateCommand(object source, Telerik.Web.UI.GridCommandEventArgs e) |
| { |
| int intTskID = Convert.ToInt16(Session["TaskID"]); |
| GridEditableItem eeditedItem = e.Item as GridEditableItem; |
| //Get the primary key value using the DataKeyValue. |
| string Id = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["orderId"].ToString(); |
| //Access the textbox from the edit form template and store the values in string variables. |
| string ClarifyAccountNbr = (editedItem["Clarify Account Nbr"].Controls[0] as TextBox).Text; |
| string SiteID = (editedItem["Site ID"].Controls[0] as TextBox).Text; |
| string QuoteID = (editedItem["Quote ID"].Controls[0] as TextBox).Text; |
| } |

| <telerik:RadSplitter ID="rsEC" |
| runat="server" |
| Height="100%" |
| Width="100%" |
| Orientation="Horizontal" |
| ResizeWithParentPane="False" |
| ResizeWithBrowserWindow="True" |
| BorderSize="0" |
| VisibleDuringInit="False" |
| HeightOffset="16" |
| > |
| <telerik:radpane runat="server" id="aPane" Scrolling="None" Width="100%" Height="100%" CssClass="TabbedPage2" > |
| <telerik:RadTabStrip ID="tsC" |
| runat="server" |
| MultiPageID="mpC" |
| SelectedIndex="0" |
| Skin="Office2007" |
| width="100%" |
| CausesValidation="False" |
| > |
| <Tabs> |
| <telerik:RadTab ID="tab2" runat="server" PageViewID="pvPhone" Text="Phones" Value="Phone"> |
| </telerik:RadTab> |
| <telerik:RadTab ID="tab3" runat="server" PageViewID="pvEmail" Text="Emails" Value="Email"> |
| </telerik:RadTab> |
| </Tabs> |
| </telerik:RadTabStrip> |
| <telerik:RadMultiPage ID="mpC" |
| runat="server" |
| CSSClass="TabbedContent" |
| SelectedIndex="0" |
| Height="100%"> |
| <telerik:RadPageView ID="pvPhone" runat="server" Height="100%"> |
| <div style="padding:7px; height:100%;"> |
| <telerik:RadSplitter ID="rsPL" |
| runat="server" |
| Height="100%" |
| Width="100%" |
| Orientation="Horizontal" |
| ResizeWithParentPane="False" |
| ResizeWithBrowserWindow="True" |
| BorderSize="0" |
| VisibleDuringInit="False" |
| HeightOffset="47" |
| > |
| <telerik:radpane runat="server" id="Radpane1" Scrolling="None" Width="100%" Height="37px"> |
| a toolbar |
| </telerik:radpane> |
| <telerik:radpane runat="server" id="bPane" Scrolling="None" Width="100%" Height="100%"> |
| Some content </telerik:radpane> |
| </telerik:RadSplitter> |
| </div> |
| </telerik:RadPageView> |
| <telerik:RadPageView ID="pvEmail" runat="server" Height="100%"> |
| <div style="padding:7px; height:100%;"> |
| <telerik:RadSplitter ID="rsCIEC" |
| runat="server" |
| Height="100%" |
| Width="100%" |
| Orientation="Horizontal" |
| ResizeWithParentPane="False" |
| ResizeWithBrowserWindow="True" |
| BorderSize="0" |
| VisibleDuringInit="False" |
| HeightOffset="37" |
| > |
| <telerik:radpane runat="server" id="tbPane" Scrolling="None" Width="100%" Height="37px" |
| another toolbar |
| </telerik:radpane> |
| <telerik:radpane runat="server" id="bPane" Scrolling="None" Width="100%" Height="100%"> |
| more content |
| </telerik:radpane> |
| </telerik:RadSplitter> |
| </div> |
| </telerik:RadPageView> |
| </telerik:RadMultiPage> |
| </telerik:radpane> |
| </telerik:RadSplitter> |
Here is what I want my solution to do:
1) Grid loads unfiltered, shows list of deals with company information for each, one-to-many companies to deals, one row per deal.
2) User clicks "Add new record" button
a) Filter row is VISIBLE
b) Insert row is HIDDEN
3) User types in RadComboBox in filter row of company column to select company, tabs-out or hits enter
a) Filter row is HIDDEN
b) Insert row is VISIBLE
c) Grid filters to just those deal records for the company selected
d) 3 columns of info in Insert row prepopulate with company information
4) User enters info for remaining columns in Insert row, saves record
My solution is almost 100%, except for Step 2.
Your example at:
http://www.telerik.com/help/aspnet/grid/grdinsertingvaluesusercontrolformtemplate.html
under the section
"Setting predefined values for controls inside user control on item insertion"
does not work for me as-is because canceling the event does not allow the code to set the IsFilterItemExpanded to true.
Please tell me how I can satisfy step 2 as defined above, HIDING the Insert row and SHOWING the Filter row on InitInsert.
Thanks!
Code samples and screenshots to follow in responses.