or
<
telerik:GridTemplateColumn
FilterControlAltText
=
"Filter TotalCost column"
HeaderText
=
"Total Cost"
UniqueName
=
"TotalCost"
>
<
HeaderStyle
Width
=
"70px"
/>
<
ItemStyle
HorizontalAlign
=
"Right"
/>
</
telerik:GridTemplateColumn
>
protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
#region Calculate Total Cost
//Get the special cost. If the value does not exist, it means the special cost is 0
double specialcost = ((cell.Text.Trim()) != " " && !String.IsNullOrWhiteSpace(cell.Text.Trim())) ? double.Parse(cell.Text.Trim()) : 0;
double cost = ((dataBoundItem["Cost"].Text.Trim()) != " " && !String.IsNullOrWhiteSpace(dataBoundItem["Cost"].Text.Trim())) ? double.Parse(dataBoundItem["Cost"].Text.Trim()) : 0;
//If the special cost is 0 than total cost = cost * quantity
if (specialcost == 0)
{
dataBoundItem["TotalCost"].Text = (cost * (Convert.ToDouble(dataBoundItem["Quantity"].Text))).ToString("N0");
}
else //If special cost exists than total cost = special cost * quantity
{
dataBoundItem["TotalCost"].Text = ((Convert.ToDouble(dataBoundItem["AlternCost"].Text)) * (Convert.ToDouble(dataBoundItem["Quantity"].Text))).ToString("N0");
}
#endregion
}
}
01.
<telerik:RadGrid ID=
"RadGrid1"
runat=
"server"
CellSpacing=
"0"
GridLines=
"None"
ShowFooter=
"True"
Skin=
"Forest"
DataSourceID=
"SqlDataSourceRegion"
>
02.
<MasterTableView AutoGenerateColumns=
"true"
DataKeyNames=
"region_id"
ShowFooter=
"False"
>
03.
<DetailTables>
04.
<telerik:GridTableView runat=
"server"
DataKeyNames=
"region_id"
DataSourceID=
"SqlDataSourceCommunity"
ShowFooter=
"False"
AllowMultiColumnSorting=
"True"
AllowSorting=
"True"
>
05.
<DetailTables>
06.
<telerik:GridTableView runat=
"server"
DataKeyNames=
"community_id"
DataSourceID=
"SqlDataSourceHomes"
AllowSorting=
"True"
>
07.
<ParentTableRelation>
08.
<telerik:GridRelationFields DetailKeyField=
"community_id"
MasterKeyField=
"community_id"
/>
09.
</ParentTableRelation>
10.
</telerik:GridTableView>
11.
</DetailTables>
12.
<ParentTableRelation>
13.
<telerik:GridRelationFields DetailKeyField=
"region_id"
MasterKeyField=
"region_id"
/>
14.
</ParentTableRelation>
15.
</telerik:GridTableView>
16.
</DetailTables>
17.
</MasterTableView>
18.
</telerik:RadGrid>
19.
</div>
20.
<br />
21.
<asp:SqlDataSource ID=
"SqlDataSourceRegion"
22.
ConnectionString=
"<%$ ConnectionStrings:LEAD %>"
23.
ProviderName=
"System.Data.SqlClient"
24.
SelectCommand=
"SELECT region_id, region_name FROM all_communities_regions_types "
runat=
"server"
></asp:SqlDataSource>
25.
26.
<asp:SqlDataSource ID=
"SqlDataSourceCommunity"
27.
ConnectionString=
"<%$ ConnectionStrings:LEAD %>"
28.
ProviderName=
"System.Data.SqlClient"
29.
SelectCommand=
"SELECT c.community_id, c.name, r.region_id FROM all_communities c INNER JOIN all_communities_regions r ON c.community_id=r.community_id WHERE r.region_id=@region_id"
30.
runat=
"server"
>
31.
<SelectParameters>
32.
<asp:SessionParameter Name=
"region_id"
SessionField=
"region_id"
Type=
"string"
/>
33.
</SelectParameters>
34.
</asp:SqlDataSource>
35.
36.
<asp:SqlDataSource ID=
"SqlDataSourceHomes"
37.
ConnectionString=
"<%$ ConnectionStrings:LEAD %>"
38.
ProviderName=
"System.Data.SqlClient"
39.
SelectCommand=
"SELECT TOP 5 home_id, beds, bath, community_id FROM homes WHERE community_id = @community_id"
runat=
"server"
>
40.
<SelectParameters>
41.
<asp:SessionParameter Name=
"community_id"
SessionField=
"community_id"
Type=
"string"
/>
42.
</SelectParameters>
43.
</asp:SqlDataSource>
<
head
runat
=
"server"
>
<
title
>Trader Position</
title
>
<
link
href
=
"../Content/CotUI.css"
rel
=
"stylesheet"
/>
<
script
type
=
"text/javascript"
>
function requestStart(sender, args) {
if (args.get_eventTarget().indexOf("DownloadPDF") > 0)
args.set_enableAjax(false);
}
</
script
>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
AsyncPostBackTimeout
=
"900"
></
telerik:RadScriptManager
>
<
div
>
<
asp:Button
ID
=
"ViewDataButton"
runat
=
"server"
Text
=
"View Trader Data"
CssClass
=
"blu-btn"
ToolTip
=
"Click to View Trader Data"
OnClick
=
"ViewDataButton_Click"
/>
</
div
>
<
br
/>
<
div
id
=
"TradersPositionDataGrid"
>
<
telerik:RadAjaxLoadingPanel
ID
=
"RadAjaxLoadingPanel1"
runat
=
"server"
Skin
=
"Black"
>
</
telerik:RadAjaxLoadingPanel
>
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
ClientEvents-OnRequestStart
=
"requestStart"
DefaultLoadingPanelID
=
"RadAjaxLoadingPanel1"
UpdatePanelsRenderMode
=
"Inline"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"ViewDataButton"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"TraderRadGrid"
></
telerik:AjaxUpdatedControl
>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
<
asp:ImageButton
ID
=
"DownloadPDF"
runat
=
"server"
ImageUrl
=
"~/Images/pdf-icon.png"
OnClick
=
"DownloadPDF_Click"
/>
<
telerik:RadGrid
ID
=
"TraderRadGrid"
runat
=
"server"
PageSize
=
"500"
AutoGenerateColumns
=
"false"
AllowPaging
=
"true"
Width
=
"1100"
OnUpdateCommand
=
"TraderRadGrid_UpdateCommand"
OnItemCreated
=
"TraderRadGrid_ItemCreated"
>
<
ExportSettings
IgnorePaging
=
"true"
OpenInNewWindow
=
"true"
HideStructureColumns
=
"true"
>
<
Pdf
PageHeight
=
"210mm"
PageWidth
=
"297mm"
DefaultFontFamily
=
"Arial Unicode MS"
PageTopMargin
=
"45mm"
BorderStyle
=
"Medium"
BorderColor
=
"#666666"
>
</
Pdf
>
</
ExportSettings
>
<
ClientSettings
>
<%--<
Scrolling
AllowScroll
=
"true"
UseStaticHeaders
=
"true"
></
Scrolling
>--%>
<%--<
Scrolling
AllowScroll
=
"false"
UseStaticHeaders
=
"false"
></
Scrolling
>--%>
<
Virtualization
ItemsPerView
=
"500"
EnableVirtualization
=
"true"
EnableCurrentPageScrollOnly
=
"true"
InitiallyCachedItemsCount
=
"2000"
/>
<
Resizing
AllowColumnResize
=
"true"
/>
</
ClientSettings
>
<
MasterTableView
EditMode
=
"InPlace"
EnableNoRecordsTemplate
=
"true"
CommandItemDisplay
=
"Top"
AutoGenerateColumns
=
"false"
DataKeyNames
=
"OWNER_ID"
>
<
CommandItemSettings
ShowAddNewRecordButton
=
"false"
/>
<
ColumnGroups
>
<
telerik:GridColumnGroup
HeaderText
=
"Futures"
Name
=
"FuturesInfo"
HeaderStyle-HorizontalAlign
=
"Center"
></
telerik:GridColumnGroup
>
<
telerik:GridColumnGroup
HeaderText
=
"Adjusted Options"
Name
=
"AdjOptionInfo"
HeaderStyle-HorizontalAlign
=
"Center"
></
telerik:GridColumnGroup
>
</
ColumnGroups
>
<
Columns
>
<
telerik:GridEditCommandColumn
ButtonType
=
"ImageButton"
></
telerik:GridEditCommandColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"TraderId"
DataField
=
"OWNER_ID"
HeaderText
=
"Trader Id"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"TraderName"
DataField
=
"TRADER_NAME"
HeaderText
=
"Trader Name"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"ContractMarket"
DataField
=
"CONTRACT_MARKET_CODE"
HeaderText
=
"Contract Market"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"ExpirationDate"
DataField
=
"FUTURES_EXPIRATION_DATE"
HeaderText
=
"Expiration Date"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"FutureLong"
DataField
=
"FUT_LONG"
HeaderText
=
"Future Long"
ColumnGroupName
=
"FuturesInfo"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"FutureShort"
DataField
=
"FUT_SHORT"
HeaderText
=
"Future Short"
ColumnGroupName
=
"FuturesInfo"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"AdjOptionLong"
DataField
=
"ADJ_OPT_LONG"
HeaderText
=
"Adjusted Option Long"
ColumnGroupName
=
"AdjOptionInfo"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"AdjOptionShort"
DataField
=
"ADJ_OPT_SHORT"
HeaderText
=
"Adjusted Option Short"
ColumnGroupName
=
"AdjOptionInfo"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"CommercialFlag"
DataField
=
"COMMERCIAL_FLAG"
HeaderText
=
"Commercial Flag"
></
telerik:GridBoundColumn
>
</
Columns
>
<
EditFormSettings
EditColumn-HeaderStyle-Width
=
"50px"
>
<
EditColumn
ButtonType
=
"ImageButton"
/>
</
EditFormSettings
>
</
MasterTableView
>
<
PagerStyle
AlwaysVisible
=
"true"
Mode
=
"NextPrev"
></
PagerStyle
>
</
telerik:RadGrid
>
</
div
>
</
form
>
</
body
>
</
html
>
bool
isPdfExport =
false
;
protected
void
DownloadPDF_Click(
object
sender, ImageClickEventArgs e)
{
isPdfExport =
true
;
//TraderRadGrid.Rebind();
//TraderRadGrid.MasterTableView.Rebind();
TraderRadGrid.MasterTableView.ExportToPdf();
}
Again Thank You.