or
1 answer
154 views
Hi,
I am using Radgrid control for my custom Grid control. I am simply wrapping all the properties to RadGrid control internally.
So i wrapped 'AllowAutomaticUpadates' property also.
When i am using my custom grid and set the 'AllowAutomaticUpadates' property from Property window as 'True', The below Bold and Italian font code adding to design code:
I am using Radgrid control for my custom Grid control. I am simply wrapping all the properties to RadGrid control internally.
So i wrapped 'AllowAutomaticUpadates' property also.
When i am using my custom grid and set the 'AllowAutomaticUpadates' property from Property window as 'True', The below Bold and Italian font code adding to design code:
<CSP:CSPGrid ID="ClientiGrid" runat="server" AutoGenerateColumns="False" AutoGenerateHierarchy="True"
GridLines="None" Skin="Web20" AllowAutomaticUpdates="True">
<ClientSettings ColumnsReorderMethod="Swap">
<DataBinding FilterParameterType="List" ResponseType="Json">
<DataService DataServiceType="AdoNet" />
</DataBinding>
</ClientSettings>
<MasterTableView AllowAutomaticUpdates="True" DataKeyNames="ClienteStudioId"
TableLayout="Fixed">
<columns>
<CSP:CSPGridBoundColumn DataField="ClienteStudioId"
HeaderText="ClienteStudioId" Resizable="false" UniqueName="ClienteStudioId"
Visible="false">
</CSP:CSPGridBoundColumn>
<CSP:CSPGridBoundColumn DataField="RagioneSociale" HeaderText="RagioneSociale"
Resizable="false" UniqueName="RagioneSociale" Visible="true">
</CSP:CSPGridBoundColumn>
<CSP:CSPGridBoundColumn DataField="CodFiscale" HeaderText="CodFiscale"
Resizable="false" UniqueName="CodFiscale" Visible="true">
</CSP:CSPGridBoundColumn>
<CSP:CSPGridBoundColumn DataField="PIva" HeaderText="PIva" Resizable="false"
UniqueName="PIva" Visible="true">
</CSP:CSPGridBoundColumn>
<CSP:CSPGridBoundColumn DataField="Fax" HeaderText="Fax" Resizable="false"
UniqueName="Fax" Visible="true">
</CSP:CSPGridBoundColumn>
</columns>
<CommandItemSettings ExportToPdfText="Export to Pdf" />
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column">
</EditColumn>
</EditFormSettings>
<ExpandCollapseColumn AndCurrentFilterFunction="NoFilter"
CurrentFilterFunction="NoFilter" DataSecurity="Read" FilterDelay=""
FilterListOptions="VaryByDataType">
</ExpandCollapseColumn>
<RowIndicatorColumn AndCurrentFilterFunction="NoFilter"
CurrentFilterFunction="NoFilter" DataSecurity="Read" FilterDelay=""
FilterListOptions="VaryByDataType">
</RowIndicatorColumn>
</MasterTableView>
<PagerStyle CssClass="rgPager" Mode="NextPrevAndNumeric" Wrap="True" />
</CSP:CSPGrid>
But in RadGrid the above code are not adding.So Please help me in this regards.
Thanks & Regards,
Anita Sahu
Mira
Telerik team
answered
on
20 Jul 2011
2 answers
123 views
Hi there,
here my problem:
I have a RadGrid with 3 levels hierarchy created using NestedViewTemplate on 2nd and 3rd levels.
When I dblclick a row in 2nd/3rd level, I want to open a popup form to edit the double clicked record.
When I close the popup form, if data has been saved I want (if possible) to refresh only the grid level of the edited row.
I want that the edit form is an independent form, that contains all the logic to edit/insert a record (so that I can reuse it and call it from different RadGrids and pages).
The edit form should accept a querystring value "ID=x" in order to go into edit mode, or a "ParentID=y" in order to go into insert mode, with ParentID being the ID of the "father table".
Let's suppose that in the calling TableView I've got a column called RowID which contains the key of the record to edit.
I've started to work using you demo Window.ReturningValuesFromDialog...
how to inject the querystring value into the call to the popup ?
how to rebind only the level of the grid that contains the edited row ?
Which is the best strategy to achieve such an application scenario ? Is there any sample that I have not found yet that face this challenge ?
Thanks in advance
Ubaldo
here my problem:
I have a RadGrid with 3 levels hierarchy created using NestedViewTemplate on 2nd and 3rd levels.
When I dblclick a row in 2nd/3rd level, I want to open a popup form to edit the double clicked record.
When I close the popup form, if data has been saved I want (if possible) to refresh only the grid level of the edited row.
I want that the edit form is an independent form, that contains all the logic to edit/insert a record (so that I can reuse it and call it from different RadGrids and pages).
The edit form should accept a querystring value "ID=x" in order to go into edit mode, or a "ParentID=y" in order to go into insert mode, with ParentID being the ID of the "father table".
Let's suppose that in the calling TableView I've got a column called RowID which contains the key of the record to edit.
I've started to work using you demo Window.ReturningValuesFromDialog...
how to inject the querystring value into the call to the popup ?
how to rebind only the level of the grid that contains the edited row ?
Which is the best strategy to achieve such an application scenario ? Is there any sample that I have not found yet that face this challenge ?
Thanks in advance
Ubaldo
Maria Ilieva
Telerik team
answered
on
20 Jul 2011
2 answers
133 views
I am currently manually databinding a RadGrid via server side. Although when I try to edit a record the Grid clears out, until I bind it again, then the item goes into edit mode. I'm not sure how to resolve this. Below is the code I have so far.
ASPX
C#
ASPX
<telerik:RadAjaxLoadingPanel ID="itemsLoadingPanel" runat="server" Skin="Vista" Transparency="30"></telerik:RadAjaxLoadingPanel> <telerik:RadAjaxPanel ID="itemsPanel" runat="server" LoadingPanelID="itemsLoadingPanel"> <div> <telerik:RadTextBox ID="itemSearchPSTxt" runat="server" EmptyMessage="PS #" /> <telerik:RadTextBox ID="itemSearchDescriptionTxt" runat="server" EmptyMessage="Description" /> <telerik:RadTextBox ID="itemSearchPartNumTxt" runat="server" EmptyMessage="Part #" /> <telerik:RadButton ID="itemSearchBtn" runat="server" Text="Search" OnClick="itemSearchBtn_Click"/> <asp:Label ID="itemSearchErrorlbl" runat="server" Text="*You must input a search value" CssClass="error" Visible="false" /> </div> <telerik:RadGrid ID="itemsRadGrid" runat="server" AutoGenerateColumns="true" AutoGenerateEditColumn="true" AllowPaging="true" OnItemCommand="itemsRadGrid_ItemCommand"> <MasterTableView CommandItemDisplay="Top" NoMasterRecordsText="No Records" EditMode="PopUp"> <CommandItemSettings ShowAddNewRecordButton="false" ShowRefreshButton="false" /> <EditFormSettings EditFormType="Template" PopUpSettings-Modal="true" PopUpSettings-Width="720px" CaptionFormatString="Edit Item"> <FormTemplate> <table> <tr> <td>Description:</td> <td>Part Number:</td> <td>Category:</td> </tr> <tr> <td><telerik:RadTextBox ID="editItemDescription" runat="server" /></td> <td><telerik:RadTextBox ID="editItemPartNum" runat="server" /></td> <td><telerik:RadTextBox ID="editItemCategory" runat="server" /></td> </tr> <tr> <td>Internal Account Number:</td> <td>Status:</td> <td></td> </tr> <tr> <td><telerik:RadTextBox ID="editItemAcctNum" runat="server" /></td> <td><telerik:RadTextBox ID="editItemStatus" runat="server" Text /></td> <td></td> </tr> <tr> <td>Expires: <asp:DropDownList ID="editItemExpires" runat="server"><asp:ListItem Text="Yes" Value="1" /><asp:ListItem Text="No" Value="0" /></asp:DropDownList></td> <td>Serial Numbered: <asp:DropDownList ID="editItemSerialNum" runat="server"><asp:ListItem Text="Yes" Value="1" /><asp:ListItem Text="No" Value="0" /></asp:DropDownList></td> <td>Lot Numbered: <asp:DropDownList ID="editItemLotNum" runat="server"><asp:ListItem Text="Yes" Value="1" /><asp:ListItem Text="No" Value="0" /></asp:DropDownList></td> <td>Consigned: <asp:DropDownList ID="editItemConsigned" runat="server"><asp:ListItem Text="Yes" Value="1" /><asp:ListItem Text="No" Value="0" /></asp:DropDownList></td> </tr> <tr> <td>OEM:</td> <td>OEM ID:</td> <td>OEM Item ID:</td> </tr> <tr> <td><telerik:RadTextBox ID="editItemOEM" runat="server" /></td> <td><telerik:RadTextBox ID="editItemOEMID" runat="server" /></td> <td><telerik:RadTextBox ID="editItemOEMItemID" runat="server" /></td> </tr> <tr> <td>Vendor:</td> <td>Vendor ID:</td> <td>Vendor Item ID:</td> </tr> <tr> <td><telerik:RadTextBox ID="editItemVendor" runat="server" /></td> <td><telerik:RadTextBox ID="editItemVendorID" runat="server" /></td> <td><telerik:RadTextBox ID="editItemVendorItemID" runat="server" /></td> </tr> <tr> <td>Vendor Price:</td> <td>Price Each:</td> <td>Cost Code:</td> <td>Conversion Rate:</td> <td>Unit of Measure:</td> </tr> <tr> <td><telerik:RadTextBox ID="editItemVendorPrice" runat="server" /></td> <td><telerik:RadTextBox ID="editItemPriceEach" runat="server" /></td> <td><telerik:RadTextBox ID="editItemCostCode" runat="server" /></td> <td><telerik:RadTextBox ID="editItemCoversionRate" runat="server" /></td> <td><telerik:RadTextBox ID="editItemUnitMeasure" runat="server" /></td> </tr> <tr> <td colspan="4"><telerik:RadButton ID="editItemUpdateBtn" runat="server" Text="Update" /></td> </tr> </table> </FormTemplate> </EditFormSettings> </MasterTableView> </telerik:RadGrid> </telerik:RadAjaxPanel>C#
protected void itemSearchBtn_Click (object sender, EventArgs e) { itemSearchErrorlbl.Visible = false; string PartNum = itemSearchPartNumTxt.Text; string Description = itemSearchDescriptionTxt.Text; string PSNum = itemSearchPSTxt.Text; string whereStatement = ""; if (PartNum != "" || Description != "" || PSNum != "") { if (PartNum != "") { whereStatement = "items.PartNumber = " + "'" + PartNum + "'"; } if (Description != "") { // See if there is already a statement to see if we need to add AND if (whereStatement == "") { whereStatement = "items.Description like " + "'%" + Description + "%'"; } else { whereStatement = whereStatement + " AND items.Description like " + "'%" + Description + "%'"; } } if (PSNum != "") { if (whereStatement == "") { whereStatement = "items.CrossRefID = " + "'" + PSNum + "'"; } else { whereStatement = whereStatement + " AND items.CrossRefID = " + "'" + PSNum + "'"; } } itemsRadGrid.DataSource = GetDataTable("SELECT ItemParValues.ID, Min, Max, Locations.Name, ItemID FROM ItemParValues INNER JOIN items on ItemParValues.ItemID = items.ID INNER JOIN Locations on Locations.ID = ItemParValues.LocationID WHERE " + whereStatement); itemsRadGrid.DataBind(); } else // Display error itemSearchErrorlbl.Visible = true; } protected void itemsRadGrid_ItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == RadGrid.EditCommandName) { } } public DataTable GetDataTable(string queryString) { using (SqlCommand cmd = new SqlCommand(queryString, connection)) { SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return dt; } }2 answers
59 views
Here is my code
<telerik:RadGrid ID="RadGrid1" runat="server"
AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True"
DataSourceID="GetProvider" GridLines="None" Skin="Windows7" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True">
<MasterTableView AutoGenerateColumns="False" DataSourceID="GetProvider" CommandItemDisplay="Top" DataKeyNames="SuspendedProviderId" >
<Columns>
<telerik:GridBoundColumn DataField="SocialSecurityAct" HeaderText="SocialSecurityAct"
SortExpression="SocialSecurityAct" UniqueName="SocialSecurityAct">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="42CFR" HeaderText="42CFR" SortExpression="42CFR"
UniqueName="42CFR">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="42USC" HeaderText="42USC" SortExpression="42USC"
UniqueName="42USC">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Description" HeaderText="Description" SortExpression="Description"
UniqueName="Description">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="SuspendedProviderId" DataType="System.Int32" Visible="false"
HeaderText="SuspendedProviderId" ReadOnly="True" SortExpression="SuspendedProviderId"
UniqueName="SuspendedProviderId">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Id" DataType="System.Int32" HeaderText="Id" Visible="false"
SortExpression="Id" UniqueName="Id">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="SuspendedProviderId" DataType="System.Int32" Visible="false"
HeaderText="SuspendedProviderId" SortExpression="SuspendedProviderId" UniqueName="SuspendedProviderId">
</telerik:GridBoundColumn>
</Columns>
<EditFormSettings EditFormType="Template">
<FormTemplate>
<table id="Table2" cellspacing="2" cellpadding="1" width="100%" border="0" rules="none"
style="border-collapse: collapse; background: white;">
<tr class="EditFormHeader">
<td colspan="2" style="font-size: small">
<b>SocialSecurityAct</b>
</td>
</tr>
<tr class="EditFormHeader">
<td colspan="2" style="font-size: small">
<b>42 CFR</b>
</td>
<td>
<asp:TextBox runat="server" ID="txt42CFR" Text='<%# Bind("42CFR") %>' Enabled="false"/>
</td>
</tr>
<tr class="EditFormHeader">
<td colspan="2" style="font-size: small">
<b>42 USC</b>
</td>
<td>
<asp:TextBox runat="server" ID="txt42USC" Text='<%# Bind("42USC") %>' Enabled="false" />
</td>
</tr>
<tr class="EditFormHeader">
<td colspan="2" style="font-size: small">
<b>Description</b>
</td>
<td>
<asp:TextBox runat="server" ID="txtDescription" Text='<%# Bind("Description") %>' Enabled="false"/>
</td>
</tr>
<tr>
<td align="right" colspan="2">
<asp:ImageButton ID="btnUpdate" ImageUrl="~/Img/Update.gif" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>'
runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'>
</asp:ImageButton>
<asp:ImageButton ID="btnCancel" runat="server" ImageUrl="~/Img/Cancel.gif" CausesValidation="False"
CommandName="Cancel"></asp:ImageButton>
</td>
</tr>
</table>
</FormTemplate>
</EditFormSettings>
<CommandItemSettings AddNewRecordText="Add " />
</MasterTableView>
</telerik:RadGrid>
</fieldset>
<asp:SqlDataSource ID="GetProvider" runat="server"
InsertCommand="spInsert" UpdateCommand="spUpdate"
DeleteCommand="spDelete" DeleteCommandType="StoredProcedure"
InsertCommandType="StoredProcedure" UpdateCommandType="StoredProcedure"
onupdating="GetProvider_Updating"
oninserting="GetProvider_Inserting">
<SelectParameters>
<asp:QueryStringParameter Name="SuspendedProviderId" QueryStringField="SuspendedProviderId"
Type="Int32" />
</SelectParameters>
<InsertParameters>
<asp:QueryStringParameter Name="SuspendedProviderId" QueryStringField="SuspendedProviderId" Type="Int32" />
<asp:Parameter Name="Id" Type="Int32" DefaultValue="1" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="Id" Type="Int32" DefaultValue="1" />
<asp:Parameter Name="SuspendedProviderId" Type="Int32" />
</UpdateParameters>
<DeleteParameters>
<asp:Parameter Name="SuspendedProviderId" />
</DeleteParameters>
</asp:SqlDataSource>
During the insert it passes all the column value , but i just want to pass the insert paramenter value. That means
Just pass these values.
<InsertParameters>
<asp:QueryStringParameter Name="SuspendedProviderId" QueryStringField="SuspendedProviderId" Type="Int32" />
<asp:Parameter Name="Id" Type="Int32" DefaultValue="1" />
</InsertParameters>
Help needed ASAP
Thanks
Eva
Iana Tsolova
Telerik team
answered
on
20 Jul 2011
1 answer
41 views
Hi
Is it possible to make a rad grid like the one below
http://www.findmyshift.com/overview?r=3xa00v7l5d53j8z41902ec7875
how to update in db when they enter text in cell and press enter button or click on another cell?
Is it possible to make a rad grid like the one below
http://www.findmyshift.com/overview?r=3xa00v7l5d53j8z41902ec7875
how to update in db when they enter text in cell and press enter button or click on another cell?
Mira
Telerik team
answered
on
20 Jul 2011
1 answer
103 views
Hello,
I've a Grid that work fine in my pc. It has a lot of functionality like, Sorting, Paging, Filtering by column, etc.
The problem is that the site has deployed in a Testing envirotment, and all the application work fine exept the RadGrid. Every functionalaty that requered a postback, like Sorting Column, Filtering, Paging, doesn't work and I have this js error:
Unable to cast object of type 'Telerik.Web.UI.GridHeaderItem' to type 'Telerik.Web.UI.GridDataItem'. (this for sorting)
Unable to cast object of type 'Telerik.Web.UI.GridPagerItem' to type 'Telerik.Web.UI.GridDataItem'. (this for paging)
Any idea what happend? Maybe some configuration in IIS.
Thanks.
Julio.
I've a Grid that work fine in my pc. It has a lot of functionality like, Sorting, Paging, Filtering by column, etc.
The problem is that the site has deployed in a Testing envirotment, and all the application work fine exept the RadGrid. Every functionalaty that requered a postback, like Sorting Column, Filtering, Paging, doesn't work and I have this js error:
Unable to cast object of type 'Telerik.Web.UI.GridHeaderItem' to type 'Telerik.Web.UI.GridDataItem'. (this for sorting)
Unable to cast object of type 'Telerik.Web.UI.GridPagerItem' to type 'Telerik.Web.UI.GridDataItem'. (this for paging)
Any idea what happend? Maybe some configuration in IIS.
Thanks.
Julio.
Iana Tsolova
Telerik team
answered
on
20 Jul 2011
1 answer
63 views
Does anybody know how (using c#) I can prevent dragging and dropping onto another dock that is pinned? When a dock is pinned, you can no longer move it. However, you can drag another dock to it's place and that bumps the pinned dock down one position. In essence allowing a user to move it while it's supposed to be pinned. How do I prevent this behavior?
Slav
Telerik team
answered
on
20 Jul 2011
4 answers
248 views
I have a panelbar that have links. If I click on one link the page open, but I can’t right click and open the page in a new tab (IE tab).
I have no choice to open in new tab.
How should I do if I want that?
My panelbar is bind to xml.
Shailendra
Top achievements
Rank 1
Rank 1
answered
on
20 Jul 2011
1 answer
165 views
I have a radwindow that contains a grid. I want to edit items in the grid inside another radwindow so when a user selects 'edit' or 'add' in the grid, a second radwindow is activated. Are there any examples of this functionality available ?
Marin Bratanov
Telerik team
answered
on
20 Jul 2011
3 answers
125 views
I have a page with three RadGrid controls on it. The idea was to map records from two of the RadGrids to the main one using row drag and drop. The row drag and drop portion works really well. However, when I try to filter the grids, the FilterExpression property comes back as a T-SQL expression rather than a Linq Expression. The property 'EnableLinqExpressions' has been set to 'true' for all grids. The Data Sources used for the RadGrid controls are ObjectDataSource objects. The main RadGrid also has two sub-Grids that expand out, however those are populated using the 'DetailTableDataBind' event rather than using a DataSource.
Is there some setting I am missing? Below are some code samples:
ASP.NET
Some of the Code Behind:
Is there some setting that is interfering with the RadGrid creating a Linq Filter Expression instead of the T-SQL statement?
Is there some setting I am missing? Below are some code samples:
ASP.NET
<asp:ObjectDataSource ID="LineItemGroupObjectDataSource" runat="server" EnablePaging="True" OldValuesParameterFormatString="original_{0}" OnSelected="LineItemGroupObjectDataSource_Selected" OnSelecting="LineItemGroupObjectDataSource_Selecting" SelectCountMethod="GetLineItemGroupCount" SelectMethod="GetLineItemGroups" SortParameterName="sortExpression" TypeName="Telarix.IxTools.IxAudit.Web.ObjectDataSources"> <SelectParameters> <asp:Parameter Name="filterExpression" Type="String" ConvertEmptyStringToNull="true" /> </SelectParameters> </asp:ObjectDataSource> <asp:ObjectDataSource ID="UnmappedIncomingLineItemObjectDataSource" runat="server" EnablePaging="True" OldValuesParameterFormatString="original_{0}" SelectCountMethod="GetUnmappedIncomingLineItemCount" SelectMethod="GetUnmappedIncomingLineItems" SortParameterName="sortExpression" TypeName="Telarix.IxTools.IxAudit.Web.ObjectDataSources" OnSelected="UnmappedIncomingLineItemObjectDataSource_Selected" OnSelecting="UnmappedIncomingLineItemObjectDataSource_Selecting"> <SelectParameters> <asp:Parameter Name="filterExpression" Type="String" ConvertEmptyStringToNull="true" /> </SelectParameters> </asp:ObjectDataSource> <asp:ObjectDataSource ID="UnmappedExpectedLineItemObjectDataSource" runat="server" EnablePaging="True" OldValuesParameterFormatString="original_{0}" SelectCountMethod="GetUnmappedExpectedLineItemCount" SelectMethod="GetUnmappedExpectedLineItems" SortParameterName="sortExpression" TypeName="Telarix.IxTools.IxAudit.Web.ObjectDataSources" OnSelected="UnmappedExpectedLineItemObjectDataSource_Selected" OnSelecting="UnmappedExpectedLineItemObjectDataSource_Selecting"> <SelectParameters> <asp:Parameter Name="filterExpression" Type="String" ConvertEmptyStringToNull="true" /> </SelectParameters> </asp:ObjectDataSource> <div id="container"> <asp:Panel ID="MainPanel" runat="server"> <div id="PageButtons" style="float: right; padding: 10px"> <asp:LinkButton ID="btnSaveContinue" runat="server" CssClass="button" OnClick="SaveContinue_Click" Style="margin: 0px 2px 0px 0px"><span>Save & Continue</span></asp:LinkButton> <asp:LinkButton ID="btnSaveClose" runat="server" CssClass="button" OnClick="SaveClose_Click" Style="margin: 0px 2px 0px 2px"><span>Save & Close</span></asp:LinkButton> <asp:LinkButton ID="btnExportExcel" runat="server" CssClass="button" CausesValidation="false" OnClick="ExportExcel_Click" Style="margin: 0px 2px 0px 2px"><span>Export to Excel</span></asp:LinkButton> <asp:LinkButton ID="btnCancel" runat="server" CssClass="button" OnClick="Cancel_Click" Style="margin: 0px 2px 0px 2px"><span>Close</span></asp:LinkButton> <asp:LinkButton ID="btnUndo" runat="server" CssClass="button" OnClick="Undo_Click" Style="margin: 0px 0px 0px 2px"><span>Undo</span></asp:LinkButton> </div> <div class="clear"> </div> <div id="MappedItemsSection" style="padding: 10px"> <table class="dash" cellpadding="0" cellspacing="0"> <tr> <td> <img src="Common/images/chartHeaderLeft.gif" alt="" /> </td> <td class="title"> Line Item Groups </td> <td> <img src="Common/images/chartHeaderRight.gif" alt="" /> </td> </tr> </table> <asp:Panel ID="MappedItemsGridPanel" runat="server" CssClass="boxLayer" Style="margin-bottom: 20px;"> <table> <tr> <td align="left"> <telerik:RadGrid ID="LineItemGroupRadGrid" runat="server" AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" OnItemCommand="LineItemGroupRadGrid_ItemCommand" DataSourceID="LineItemGroupObjectDataSource" PageSize="5" AutoGenerateColumns="False" GroupingEnabled="False" OnPreRender="LineItemGroupRadGrid_PreRender" OnDeleteCommand="LineItemGroupRadGrid_DeleteCommand" EnableHeaderContextMenu="True" OnDetailTableDataBind="LineItemGroupRadGrid_DetailTableDataBind" GridLines="None"> <ValidationSettings EnableValidation="False" /> <MasterTableView AllowMultiColumnSorting="True" DataKeyNames="lineItemGroupIndex,lineItemGroupId" HierarchyLoadMode="ServerBind" DataSourceID="LineItemGroupObjectDataSource" GridLines="Both" Name="LineItemGroups" NoDetailRecordsText="No mapped line items for this group" NoMasterRecordsText="No line items have been mapped."> <SortExpressions> <telerik:GridSortExpression FieldName="Name" SortOrder="Ascending" /> </SortExpressions> <DetailTables> <telerik:GridTableView runat="server" AllowMultiColumnSorting="True" AllowFilteringByColumn="False" DataKeyNames="lineItemGroupIndex,lineItemGroupId" Frame="LHS" GridLines="Both" HorizontalAlign="Left" Name="MappedExpectedLineItems" NoDetailRecordsText="No Mapped Internal Line Items" NoMasterRecordsText="No Mapped Internal Line Items" Width="49%"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="lineItemGroupId" MasterKeyField="lineItemGroupId" /> </ParentTableRelation> <SortExpressions> <telerik:GridSortExpression FieldName="Product" SortOrder="Ascending" /> <telerik:GridSortExpression FieldName="TimeBand" SortOrder="Ascending" /> <telerik:GridSortExpression FieldName="Tier" SortOrder="Ascending" /> </SortExpressions> <Columns> <telerik:GridNumericColumn Aggregate="Count" AllowFiltering="False" AllowSorting="False" DataField="lineItemGroupIndex" DataType="System.Int32" Display="False" Groupable="False" GroupByExpression="lineItemGroupIndex" HeaderText="Line Item Group Index" ReadOnly="True" SortExpression="lineItemGroupIndex" UniqueName="lineItemGroupIndex" Visible="False"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Count" AllowFiltering="False" AllowSorting="False" DataField="lineItemGroupId" DataType="System.Int32" Display="False" Groupable="False" GroupByExpression="lineItemGroupId" HeaderText="line Item Group Id" ReadOnly="True" SortExpression="lineItemGroupId" UniqueName="lineItemGroupId" Visible="False"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Count" AllowFiltering="False" AllowSorting="False" DataField="LineItemIndex" DataType="System.Int32" Display="False" Groupable="False" GroupByExpression="LineItemIndex" HeaderText="Line Item Index" ReadOnly="True" SortExpression="LineItemIndex" UniqueName="LineItemIndex" Visible="False"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Count" AllowFiltering="False" AllowSorting="False" DataField="LineItemId" DataType="System.Int32" Display="False" Groupable="False" GroupByExpression="LineItemId" HeaderText="Line Item Id" ReadOnly="True" SortExpression="LineItemId" UniqueName="LineItemId" Visible="False"> </telerik:GridNumericColumn> <telerik:GridBoundColumn Aggregate="Count" AutoPostBackOnFilter="True" CurrentFilterFunction="StartsWith" DataField="Product" GroupByExpression="Product" HeaderText="(Internal) Product" ReadOnly="True" SortExpression="Product" UniqueName="Product"> <HeaderStyle Width="20%" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn Aggregate="Count" DataField="TimeBand" GroupByExpression="TimeBand" HeaderText="Time Band" ReadOnly="True" SortExpression="TimeBand" UniqueName="TimeBand"> </telerik:GridBoundColumn> <telerik:GridBoundColumn Aggregate="Count" DataField="Tier" GroupByExpression="Tier" HeaderText="Tier" ReadOnly="True" SortExpression="Tier" UniqueName="Tier"> </telerik:GridBoundColumn> <telerik:GridDateTimeColumn Aggregate="Min" DataField="BeginDate" DataFormatString="{0:d}" DataType="System.DateTime" GroupByExpression="BeginDate" HeaderText="Begin Date" ReadOnly="True" SortExpression="BeginDate" UniqueName="BeginDate"> </telerik:GridDateTimeColumn> <telerik:GridDateTimeColumn Aggregate="Max" DataField="EndDate" DataFormatString="{0:d}" DataType="System.DateTime" GroupByExpression="EndDate" HeaderText="End Date" ReadOnly="True" SortExpression="EndDate" UniqueName="EndDate"> </telerik:GridDateTimeColumn> <telerik:GridNumericColumn Aggregate="Sum" DataField="Calls" DataType="System.Int32" GroupByExpression="Calls" HeaderText="Calls" ReadOnly="True" SortExpression="Calls" UniqueName="Calls"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Sum" DataField="Units" DataFormatString="{0:N2}" DataType="System.Decimal" GroupByExpression="Units" HeaderText="Units" ReadOnly="True" SortExpression="Units" UniqueName="Units"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Avg" DataField="Rate" DataFormatString="{0:N6}" DataType="System.Decimal" GroupByExpression="Rate" HeaderText="Rate" ReadOnly="True" SortExpression="Rate" UniqueName="Rate"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Sum" DataField="Amount" DataFormatString="{0:N2}" DataType="System.Decimal" GroupByExpression="Amount" HeaderText="Amount" ReadOnly="True" SortExpression="Amount" UniqueName="Amount"> </telerik:GridNumericColumn> <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" ConfirmDialogType="RadWindow" ConfirmText="This action will remove the selected mapped line item from the group" ConfirmTitle="Remove Mapped Line Item" ImageUrl="~/Common/images/deleterow.gif" UniqueName="RemoveButton"> <HeaderStyle Width="30px" /> </telerik:GridButtonColumn> </Columns> <PagerStyle Mode="NextPrev" /> </telerik:GridTableView> <telerik:GridTableView runat="server" AllowMultiColumnSorting="True" AllowFilteringByColumn="False" DataKeyNames="lineItemGroupIndex,lineItemGroupId" Frame="RHS" HorizontalAlign="Right" Name="MappedIncomingLineItems" NoDetailRecordsText="No Mapped Received Line Items" NoMasterRecordsText="No Mapped Received Line Items" Width="49%"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="lineItemGroupId" MasterKeyField="lineItemGroupId" /> </ParentTableRelation> <SortExpressions> <telerik:GridSortExpression FieldName="Product" SortOrder="Ascending" /> <telerik:GridSortExpression FieldName="TimeBand" SortOrder="Ascending" /> <telerik:GridSortExpression FieldName="Tier" SortOrder="Ascending" /> </SortExpressions> <Columns> <telerik:GridNumericColumn Aggregate="Count" AllowFiltering="False" AllowSorting="False" DataField="lineItemGroupIndex" DataType="System.Int32" Display="False" Groupable="False" GroupByExpression="lineItemGroupIndex" HeaderText="Line Item Group Index" ReadOnly="True" SortExpression="lineItemGroupIndex" UniqueName="lineItemGroupIndex" Visible="False"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Count" AllowFiltering="False" AllowSorting="False" DataField="lineItemGroupId" DataType="System.Int32" Display="False" Groupable="False" GroupByExpression="lineItemGroupId" HeaderText="line Item Group Id" ReadOnly="True" SortExpression="lineItemGroupId" UniqueName="lineItemGroupId" Visible="False"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Count" AllowFiltering="False" AllowSorting="False" DataField="LineItemIndex" DataType="System.Int32" Display="False" Groupable="False" GroupByExpression="LineItemIndex" HeaderText="Line Item Index" ReadOnly="True" SortExpression="LineItemIndex" UniqueName="LineItemIndex" Visible="False"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Count" AllowFiltering="False" AllowSorting="False" DataField="LineItemId" DataType="System.Int32" Display="False" Groupable="False" GroupByExpression="LineItemId" HeaderText="Line Item Id" ReadOnly="True" SortExpression="LineItemId" UniqueName="LineItemId" Visible="False"> </telerik:GridNumericColumn> <telerik:GridBoundColumn Aggregate="Count" AutoPostBackOnFilter="True" CurrentFilterFunction="StartsWith" DataField="Product" GroupByExpression="Product" HeaderText="(Received) Product" ReadOnly="True" SortExpression="Product" UniqueName="Product"> <HeaderStyle Width="20%" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn Aggregate="Count" DataField="TimeBand" GroupByExpression="TimeBand" HeaderText="Time Band" ReadOnly="True" SortExpression="TimeBand" UniqueName="TimeBand"> </telerik:GridBoundColumn> <telerik:GridBoundColumn Aggregate="Count" DataField="Tier" GroupByExpression="Tier" HeaderText="Tier" ReadOnly="True" SortExpression="Tier" UniqueName="Tier"> </telerik:GridBoundColumn> <telerik:GridDateTimeColumn Aggregate="Min" DataField="BeginDate" DataFormatString="{0:d}" DataType="System.DateTime" GroupByExpression="BeginDate" HeaderText="Begin Date" ReadOnly="True" SortExpression="BeginDate" UniqueName="BeginDate"> </telerik:GridDateTimeColumn> <telerik:GridDateTimeColumn Aggregate="Max" DataField="EndDate" DataFormatString="{0:d}" DataType="System.DateTime" GroupByExpression="EndDate" HeaderText="End Date" ReadOnly="True" SortExpression="EndDate" UniqueName="EndDate"> </telerik:GridDateTimeColumn> <telerik:GridNumericColumn Aggregate="Sum" DataField="Calls" DataType="System.Int32" GroupByExpression="Calls" HeaderText="Calls" ReadOnly="True" SortExpression="Calls" UniqueName="Calls"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Sum" DataField="Units" DataFormatString="{0:N2}" DataType="System.Decimal" GroupByExpression="Units" HeaderText="Units" ReadOnly="True" SortExpression="Units" UniqueName="Units"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Avg" DataField="Rate" DataFormatString="{0:N6}" DataType="System.Decimal" GroupByExpression="Rate" HeaderText="Rate" ReadOnly="True" SortExpression="Rate" UniqueName="Rate"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Sum" DataField="Amount" DataFormatString="{0:N2}" DataType="System.Decimal" GroupByExpression="Amount" HeaderText="Amount" ReadOnly="True" SortExpression="Amount" UniqueName="Amount"> </telerik:GridNumericColumn> <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" ConfirmDialogType="RadWindow" ConfirmText="This action will remove the selected mapped line item from the group" ConfirmTitle="Remove Mapped Line Item" ImageUrl="~/Common/images/deleterow.gif" UniqueName="RemoveButton"> <HeaderStyle Width="30px" /> </telerik:GridButtonColumn> </Columns> <PagerStyle Mode="NextPrev" /> </telerik:GridTableView> </DetailTables> <ExpandCollapseColumn Visible="True"> </ExpandCollapseColumn> <Columns> <telerik:GridNumericColumn Aggregate="Count" AllowFiltering="False" AllowSorting="False" DataField="lineItemGroupIndex" DataType="System.Int32" Display="False" Groupable="False" GroupByExpression="lineItemGroupIndex" HeaderText="Line Item Group Index" ReadOnly="True" SortExpression="lineItemGroupIndex" UniqueName="lineItemGroupIndex" Visible="False"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Count" AllowFiltering="False" AllowSorting="False" DataField="lineItemGroupId" DataType="System.Int32" Display="False" Groupable="False" GroupByExpression="lineItemGroupId" HeaderText="Line Item Group Id" ReadOnly="True" SortExpression="lineItemGroupId" UniqueName="lineItemGroupId" Visible="False"> </telerik:GridNumericColumn> <telerik:GridBoundColumn Aggregate="Count" AutoPostBackOnFilter="True" CurrentFilterFunction="StartsWith" DataField="Name" GroupByExpression="Name" HeaderText="Name" ReadOnly="True" SortExpression="Name" UniqueName="Name" FilterControlWidth="90%"> <HeaderStyle Width="20%" /> </telerik:GridBoundColumn> <telerik:GridDateTimeColumn Aggregate="Min" DataField="BeginDate" AllowFiltering="false" DataFormatString="{0:d}" DataType="System.DateTime" GroupByExpression="BeginDate" HeaderText="Begin Date" ReadOnly="True" SortExpression="BeginDate" UniqueName="BeginDate" FilterControlWidth="75%"> </telerik:GridDateTimeColumn> <telerik:GridDateTimeColumn Aggregate="Max" DataField="EndDate" AllowFiltering="false" DataFormatString="{0:d}" DataType="System.DateTime" GroupByExpression="EndDate" HeaderText="End Date" ReadOnly="True" SortExpression="EndDate" UniqueName="EndDate" FilterControlWidth="75%"> </telerik:GridDateTimeColumn> <telerik:GridNumericColumn Aggregate="Sum" DataField="TotalExpectedCalls" AllowFiltering="false" DataType="System.Int32" Groupable="False" GroupByExpression="TotalExpectedCalls" HeaderText="Internal Calls" ReadOnly="True" SortExpression="TotalExpectedCalls" UniqueName="TotalExpectedCalls"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Sum" AllowRounding="True" AllowFiltering="false" DataField="TotalExpectedUnits" DataFormatString="{0:N2}" DataType="System.Decimal" Groupable="False" GroupByExpression="TotalExpectedUnits" HeaderText="Internal Units" ReadOnly="True" SortExpression="TotalExpectedUnits" UniqueName="TotalExpectedUnits"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Avg" AllowRounding="True" AllowFiltering="false" DataField="ExpectedRate" DataFormatString="{0:N6}" DataType="System.Decimal" Groupable="False" GroupByExpression="ExpectedRate" HeaderText="Internal Rate" ReadOnly="True" SortExpression="ExpectedRate" UniqueName="ExpectedRate"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Sum" AllowRounding="True" AllowFiltering="false" DataField="TotalExpectedAmount" DataFormatString="{0:N2}" DataType="System.Decimal" GroupByExpression="TotalExpectedAmount" HeaderText="Internal Amount" ReadOnly="True" SortExpression="TotalExpectedAmount" UniqueName="TotalExpectedAmount"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Sum" DataField="TotalIncomingCalls" AllowFiltering="false" DataType="System.Int32" Groupable="False" GroupByExpression="TotalIncomingCalls" HeaderText="Received Calls" ReadOnly="True" SortExpression="TotalIncomingCalls" UniqueName="TotalIncomingCalls"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Sum" AllowRounding="True" AllowFiltering="false" DataField="TotalIncomingUnits" DataFormatString="{0:N2}" DataType="System.Decimal" Groupable="False" GroupByExpression="TotalIncomingUnits" HeaderText="Received Units" ReadOnly="True" SortExpression="TotalIncomingUnits" UniqueName="TotalIncomingUnits"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Avg" AllowRounding="True" AllowFiltering="false" DataField="IncomingRate" DataFormatString="{0:N6}" DataType="System.Decimal" Groupable="False" GroupByExpression="IncomingRate" HeaderText="Received Rate" ReadOnly="True" SortExpression="IncomingRate" UniqueName="IncomingRate"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Sum" AllowRounding="True" AllowFiltering="false" DataField="TotalIncomingAmount" DataFormatString="{0:N2}" DataType="System.Decimal" GroupByExpression="TotalIncomingAmount" HeaderText="Received Amount" ReadOnly="True" SortExpression="TotalIncomingAmount" UniqueName="TotalIncomingAmount"> </telerik:GridNumericColumn> <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" ConfirmDialogType="RadWindow" ConfirmText="This action will delete the Line-Item Group and move the underlying line-items to the unmapped section" ConfirmTitle="Confirm Mapping Delete" HeaderButtonType="None" ImageUrl="~/Common/images/deleterow.gif" Reorderable="False" Resizable="False" ShowSortIcon="False" UniqueName="DeleteColumn"> <HeaderStyle Width="30px" /> </telerik:GridButtonColumn> </Columns> <PagerStyle Mode="NextPrevNumericAndAdvanced" Position="Top" /> </MasterTableView> <GroupingSettings CaseSensitive="False" /> <ClientSettings AllowColumnHide="True" AllowColumnsReorder="True" AllowKeyboardNavigation="True" AllowRowHide="True" ReorderColumnsOnClient="True" AllowRowsDragDrop="True" EnableRowHoverStyle="True"> <Selecting AllowRowSelect="True" EnableDragToSelectRows="False" /> <Resizing AllowColumnResize="True" EnableRealTimeResize="True" /> </ClientSettings> </telerik:RadGrid> </td> </tr> </table> </asp:Panel> </div> <div class="clear"> </div> <div style="text-align: center"> <div> <asp:Label ID="DragDropNewLabel" runat="server" Text="Drag to image for new grouping"></asp:Label> </div> <div> <img id="DragDropNewGroup" src="Common/images/dropInsert.gif" alt="New Line Item Group" runat="server" /> </div> </div> <div id="UnmappedItemsSection"> <div id="ExpectedLineItems" style="float: left; width: 48%; padding: 10px"> <table class="dash" cellpadding="0" cellspacing="0"> <tr> <td> <img src="Common/images/chartHeaderLeft.gif" alt="" /> </td> <td class="title"> Unmapped Internal Line Items </td> <td> <img src="Common/images/chartHeaderRight.gif" alt="" /> </td> </tr> </table> <asp:Panel ID="ExpectedLineItemPanel" CssClass="boxLayer" Style="margin-bottom: 20px" runat="server"> <table style="width: 100%"> <tr align="left"> <td> <telerik:RadGrid ID="UnmappedExpectedLineItemRadGrid" runat="server" AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" EnableViewState="False" OnItemCommand="UnmappedExpectedLineItemRadGrid_ItemCommand" DataSourceID="UnmappedExpectedLineItemObjectDataSource" AllowMultiRowSelection="True" HorizontalAlign="Left" OnPreRender="UnmappedExpectedLineItemRadGrid_PreRender" PageSize="5" BorderStyle="None" OnRowDrop="UnmappedExpectedLineItemRadGrid_RowDrop" GroupingEnabled="False" GridLines="None"> <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"> </HeaderContextMenu> <ValidationSettings EnableValidation="False" /> <MasterTableView DataSourceID="UnmappedExpectedLineItemObjectDataSource" AllowMultiColumnSorting="True" GridLines="Both" Name="Unmapped Internal Line Items" DataKeyNames="LineItemIndex,LineItemId" EnableHeaderContextMenu="True" NoMasterRecordsText="No unmapped internal line items"> <CommandItemSettings ExportToPdfText="Export to Pdf" /> <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"> </RowIndicatorColumn> <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"> </ExpandCollapseColumn> <SortExpressions> <telerik:GridSortExpression FieldName="Product" SortOrder="Ascending" /> <telerik:GridSortExpression FieldName="TimeBand" SortOrder="Ascending" /> <telerik:GridSortExpression FieldName="Tier" SortOrder="Ascending" /> </SortExpressions> <Columns> <telerik:GridNumericColumn Aggregate="Count" AllowFiltering="False" AllowSorting="False" DataField="LineItemIndex" DataType="System.Int32" Display="False" Groupable="False" GroupByExpression="LineItemIndex" HeaderText="Line Item Index" ReadOnly="True" SortExpression="LineItemIndex" UniqueName="LineItemIndex" Visible="False"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Count" AllowFiltering="False" AllowSorting="False" DataField="LineItemId" DataType="System.Int32" Display="False" Groupable="False" GroupByExpression="LineItemId" HeaderText="Line Item Id" ReadOnly="True" SortExpression="LineItemId" UniqueName="LineItemId" Visible="False"> </telerik:GridNumericColumn> <telerik:GridBoundColumn Aggregate="Count" AutoPostBackOnFilter="True" CurrentFilterFunction="StartsWith" DataField="Product" GroupByExpression="Product" HeaderText="Product" ReadOnly="True" SortExpression="Product" UniqueName="Product"> <HeaderStyle Width="20%" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn Aggregate="Count" AllowFiltering="False" DataField="TimeBand" GroupByExpression="TimeBand" HeaderText="Time Band" ReadOnly="True" SortExpression="TimeBand" UniqueName="TimeBand"> </telerik:GridBoundColumn> <telerik:GridBoundColumn Aggregate="Count" AllowFiltering="False" DataField="Tier" GroupByExpression="Tier" HeaderText="Tier" ReadOnly="True" SortExpression="Tier" UniqueName="Tier"> </telerik:GridBoundColumn> <telerik:GridDateTimeColumn Aggregate="Min" AllowFiltering="false" DataField="BeginDate" DataFormatString="{0:d}" DataType="System.DateTime" GroupByExpression="BeginDate" HeaderText="Begin Date" ReadOnly="True" SortExpression="BeginDate" UniqueName="BeginDate"> </telerik:GridDateTimeColumn> <telerik:GridDateTimeColumn Aggregate="Max" AllowFiltering="false" DataField="EndDate" DataFormatString="{0:d}" DataType="System.DateTime" GroupByExpression="EndDate" HeaderText="End Date" ReadOnly="True" SortExpression="EndDate" UniqueName="EndDate"> </telerik:GridDateTimeColumn> <telerik:GridNumericColumn Aggregate="Sum" AllowFiltering="false" DataField="Calls" DataType="System.Int32" GroupByExpression="Calls" HeaderText="Calls" ReadOnly="True" SortExpression="Calls" UniqueName="Calls"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Sum" AllowFiltering="false" DataField="Units" DataFormatString="{0:F2}" DataType="System.Decimal" GroupByExpression="Units" HeaderText="Units" ReadOnly="True" SortExpression="Units" UniqueName="Units"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Avg" AllowFiltering="false" DataField="Rate" DataFormatString="{0:F6}" DataType="System.Decimal" GroupByExpression="Rate" HeaderText="Rate" ReadOnly="True" SortExpression="Rate" UniqueName="Rate"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Sum" AllowFiltering="false" DataField="Amount" DataFormatString="{0:F2}" DataType="System.Decimal" GroupByExpression="Amount" HeaderText="Amount" ReadOnly="True" SortExpression="Amount" UniqueName="Amount"> </telerik:GridNumericColumn> </Columns> <EditFormSettings> <EditColumn FilterControlAltText="Filter EditCommandColumn column"> </EditColumn> </EditFormSettings> <PagerStyle Mode="NextPrev" Position="Top" /> </MasterTableView> <GroupingSettings CaseSensitive="False" /> <ClientSettings AllowColumnHide="True" AllowColumnsReorder="True" AllowKeyboardNavigation="True" AllowRowHide="True" ReorderColumnsOnClient="True" AllowRowsDragDrop="True" EnableRowHoverStyle="True"> <Selecting AllowRowSelect="True" EnableDragToSelectRows="False" /> <Resizing AllowColumnResize="True" EnableRealTimeResize="True" /> </ClientSettings> <FilterMenu EnableImageSprites="False"> </FilterMenu> </telerik:RadGrid> </td> </tr> </table> </asp:Panel> </div> <div id="IncomingLineItems" style="float: right; width: 48%; padding: 10px"> <table class="dash" cellpadding="0" cellspacing="0"> <tr> <td> <img src="Common/images/chartHeaderLeft.gif" alt="" /> </td> <td class="title"> Unmapped Received Line Items </td> <td> <img src="Common/images/chartHeaderRight.gif" alt="" /> </td> </tr> </table> <asp:Panel ID="IncomingLineItemsPanel" CssClass="boxLayer" Style="margin-bottom: 20px" runat="server"> <table style="width: 100%"> <tr align="left"> <td> <telerik:RadGrid ID="UnmappedIncomingLineItemRadGrid" runat="server" AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" EnableViewState="False" OnItemCommand="UnmappedIncomingLineItemRadGrid_ItemCommand" DataSourceID="UnmappedIncomingLineItemObjectDataSource" AllowMultiRowSelection="True" HorizontalAlign="Left" PageSize="5" OnPreRender="UnmappedIncomingLineItemRadGrid_PreRender" OnRowDrop="UnmappedIncomingLineItemRadGrid_RowDrop" GroupingEnabled="False" GridLines="None"> <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"> </HeaderContextMenu> <ValidationSettings EnableValidation="False" /> <MasterTableView DataSourceID="UnmappedIncomingLineItemObjectDataSource" AllowMultiColumnSorting="True" GridLines="Both" Name="Unmapped Internal Line Items" DataKeyNames="LineItemIndex,LineItemId" EnableHeaderContextMenu="True" NoMasterRecordsText="No unmapped received line items"> <CommandItemSettings ExportToPdfText="Export to Pdf" /> <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"> </RowIndicatorColumn> <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"> </ExpandCollapseColumn> <SortExpressions> <telerik:GridSortExpression FieldName="Product" SortOrder="Ascending" /> <telerik:GridSortExpression FieldName="TimeBand" SortOrder="Ascending" /> <telerik:GridSortExpression FieldName="Tier" SortOrder="Ascending" /> </SortExpressions> <Columns> <telerik:GridNumericColumn Aggregate="Count" AllowFiltering="False" AllowSorting="False" DataField="LineItemIndex" DataType="System.Int32" Display="False" Groupable="False" GroupByExpression="LineItemIndex" HeaderText="Line Item Index" ReadOnly="True" SortExpression="LineItemIndex" UniqueName="LineItemIndex" Visible="False"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Count" AllowFiltering="False" AllowSorting="False" DataField="LineItemId" DataType="System.Int32" Display="False" Groupable="False" GroupByExpression="LineItemId" HeaderText="Line Item Id" ReadOnly="True" SortExpression="LineItemId" UniqueName="LineItemId" Visible="False"> </telerik:GridNumericColumn> <telerik:GridBoundColumn Aggregate="Count" AutoPostBackOnFilter="True" CurrentFilterFunction="StartsWith" DataField="Product" GroupByExpression="Product" HeaderText="Product" ReadOnly="True" SortExpression="Product" UniqueName="Product"> <HeaderStyle Width="20%" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn Aggregate="Count" AllowFiltering="False" DataField="TimeBand" GroupByExpression="TimeBand" HeaderText="Time Band" ReadOnly="True" SortExpression="TimeBand" UniqueName="TimeBand"> </telerik:GridBoundColumn> <telerik:GridBoundColumn Aggregate="Count" AllowFiltering="False" DataField="Tier" GroupByExpression="Tier" HeaderText="Tier" ReadOnly="True" SortExpression="Tier" UniqueName="Tier"> </telerik:GridBoundColumn> <telerik:GridDateTimeColumn Aggregate="Min" AllowFiltering="false" DataField="BeginDate" DataFormatString="{0:d}" DataType="System.DateTime" GroupByExpression="BeginDate" HeaderText="Begin Date" ReadOnly="True" SortExpression="BeginDate" UniqueName="BeginDate"> </telerik:GridDateTimeColumn> <telerik:GridDateTimeColumn Aggregate="Max" AllowFiltering="false" DataField="EndDate" DataFormatString="{0:d}" DataType="System.DateTime" GroupByExpression="EndDate" HeaderText="End Date" ReadOnly="True" SortExpression="EndDate" UniqueName="EndDate"> </telerik:GridDateTimeColumn> <telerik:GridNumericColumn Aggregate="Sum" AllowFiltering="false" DataField="Calls" DataType="System.Int32" GroupByExpression="Calls" HeaderText="Calls" ReadOnly="True" SortExpression="Calls" UniqueName="Calls"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Sum" AllowFiltering="false" DataField="Units" DataFormatString="{0:F2}" DataType="System.Decimal" GroupByExpression="Units" HeaderText="Units" ReadOnly="True" SortExpression="Units" UniqueName="Units"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Avg" AllowFiltering="false" DataField="Rate" DataFormatString="{0:F6}" DataType="System.Decimal" GroupByExpression="Rate" HeaderText="Rate" ReadOnly="True" SortExpression="Rate" UniqueName="Rate"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Sum" AllowFiltering="false" DataField="Amount" DataFormatString="{0:F2}" DataType="System.Decimal" GroupByExpression="Amount" HeaderText="Amount" ReadOnly="True" SortExpression="Amount" UniqueName="Amount"> </telerik:GridNumericColumn> </Columns> <EditFormSettings> <EditColumn FilterControlAltText="Filter EditCommandColumn column"> </EditColumn> </EditFormSettings> <PagerStyle Mode="NextPrev" Position="Top" /> </MasterTableView> <GroupingSettings CaseSensitive="False" /> <ClientSettings AllowColumnHide="True" AllowColumnsReorder="True" AllowKeyboardNavigation="True" AllowRowHide="True" ReorderColumnsOnClient="True" AllowRowsDragDrop="True" EnableRowHoverStyle="True"> <Selecting AllowRowSelect="True" EnableDragToSelectRows="False" /> <Resizing AllowColumnResize="True" EnableRealTimeResize="True" /> </ClientSettings> <FilterMenu EnableImageSprites="False"> </FilterMenu> </telerik:RadGrid> </td> </tr> </table> </asp:Panel> </div> </div>Some of the Code Behind:
/// <summary> /// Handles the Init event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param> protected void Page_Init(object sender, EventArgs e) { this.LineItemGroupRadGrid.Culture = CultureInfo.CurrentUICulture; this.LineItemGroupRadGrid.GridLines = GridLines.Both; this.UnmappedExpectedLineItemRadGrid.Culture = CultureInfo.CurrentUICulture; this.UnmappedExpectedLineItemRadGrid.GridLines = GridLines.Both; this.UnmappedIncomingLineItemRadGrid.Culture = CultureInfo.CurrentUICulture; this.UnmappedIncomingLineItemRadGrid.GridLines = GridLines.Both; } /// <summary> /// Page load event handler. /// </summary> /// <param name="sender">The event sender</param> /// <param name="e">The event arguments</param> protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { this.Response.Cache.SetCacheability(HttpCacheability.NoCache); } } /// <summary> /// Handles the DetailTableDataBind event for LineItemGroupRadGrid. /// </summary> /// <param name="source">The event source.</param> /// <param name="e">The event arguments.</param> protected void LineItemGroupRadGrid_DetailTableDataBind(object source, GridDetailTableDataBindEventArgs e) { GridDataItem parentItem = e.DetailTableView.ParentItem; int index = Convert.ToInt32(parentItem["lineItemGroupIndex"].Text, CultureInfo.InvariantCulture); int? id; int temp; if (int.TryParse(parentItem["lineItemGroupId"].Text, NumberStyles.Integer, CultureInfo.InvariantCulture, out temp)) { id = temp; } else { id = null; } if (e.DetailTableView.Name == "MappedExpectedLineItems") { e.DetailTableView.DataSource = ObjectDataSources.GetMappedExpectedLineItems(0, int.MaxValue, e.DetailTableView.FilterExpression, e.DetailTableView.SortExpressions.GetSortString(), index, id); } else if (e.DetailTableView.Name == "MappedIncomingLineItems") { e.DetailTableView.DataSource = ObjectDataSources.GetMappedIncomingLineItems(0, int.MaxValue, e.DetailTableView.FilterExpression, e.DetailTableView.SortExpressions.GetSortString(), index, id); } else { e.Canceled = true; } } /// <summary> /// Event handler for the Selecting event of the LineItemGroupObjectDataSource object. /// </summary> /// <param name="sender">Event sender.</param> /// <param name="e">Event arguments.</param> protected void LineItemGroupObjectDataSource_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { e.InputParameters["filterExpression"] = this.LineItemGroupRadGrid.MasterTableView.FilterExpression;}Is there some setting that is interfering with the RadGrid creating a Linq Filter Expression instead of the T-SQL statement?
Mira
Telerik team
answered
on
20 Jul 2011
