or
<
telerik:GridTemplateColumn
HeaderText
=
"Need Call"
ItemStyle-HorizontalAlign
=
"Center"
>
<
ItemTemplate
>
<
telerik:RadToolTip
ID
=
"RadToolTipCall"
runat
=
"server"
TargetControlID
=
"chkNeedCall"
AutoCloseDelay
=
"10000"
RelativeTo
=
"Element"
Position
=
"MiddleRight"
>
<%# Eval("UsernameNeedCall") %>
</
telerik:RadToolTip
>
<
telerik:RadButton
ID
=
"chkNeedCall"
runat
=
"server"
Width
=
"22px"
Height
=
"22px"
ToggleType
=
"CheckBox"
ButtonType
=
"LinkButton"
CommandArgument='<%# Eval("Id") %>' AutoPostBack="True" OnCommand="btnNeedCall_Click">
<
Image
EnableImageButton
=
"True"
ImageUrl='<%# Eval("NeedCall") %>' IsBackgroundImage="True"></
Image
>
</
telerik:RadButton
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
protected void gridShow_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
try
{
if (!e.IsFromDetailTable)
{
var db = new MyDataContext();
var reciveMsg = db.TBL_ReceiverMsgs.ToList().Select((c, index) => new
{
RowIndex = index + 1,
c.Id,
c.Body,
NeedCall = c.NeedCall ? "../Images/Sms/deliveryorange.png" : "../Images/Sms/deliveryok.png",
NeedFollow = c.NeedFollow ? "../Images/Sms/deliveryorange.png" : "../Images/Sms/deliveryok.png",
c.UsernameNeedCall
});
gridShowSms.DataSource = reciveMsg;
}
}
catch (Exception)
{
lblException.Text = @"Error!!";
}
}
<
telerik:GridTemplateColumn
HeaderText
=
"Body"
ItemStyle-HorizontalAlign
=
"Center"
>
<
ItemTemplate
>
<
telerik:RadToolTip
ID
=
"RadToolTipBody"
runat
=
"server"
TargetControlID
=
"lblBody"
RelativeTo
=
"Element"
Position
=
"Center"
>
<%# DataBinder.Eval(Container, "DataItem.Body") %>
</
telerik:RadToolTip
>
<
div
style
=
"Width:100px"
ID
=
"lblBody"
runat
=
"server"
><%# Eval("Body") %></
div
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:RadHtmlChart
ID
=
"RadHtmlChart2"
runat
=
"server"
DataSourceID
=
"SqlDataSource1"
Height
=
"400px"
Width
=
"1200px"
InvokeLoadData
=
"OnPageLoad"
>
<
PlotArea
>
<
Series
>
<
telerik:LineSeries
DataFieldY
=
"47"
Name
=
"Lync"
></
telerik:LineSeries
>
<
telerik:LineSeries
DataFieldY
=
"48"
Name
=
"Outlook"
></
telerik:LineSeries
>
<
telerik:LineSeries
DataFieldY
=
"49"
Name
=
"IE"
></
telerik:LineSeries
>
</
Series
>
<
XAxis
DataLabelsField
=
"YDate"
Name
=
"ExecutionDate"
Visible
=
"true"
></
XAxis
>
<
YAxis
Name
=
"ExecutionCount"
MaxValue
=
"1000"
MinValue
=
"0"
Step
=
"100"
></
YAxis
>
</
PlotArea
>
</
telerik:RadHtmlChart
>
<
asp:SqlDataSource
ID
=
"SqlDataSource1"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:SmartButton3ConnectionString %>"
SelectCommand="SELECT * FROM (SELECT CoreTriggerPluginID, CONVERT(VARCHAR(10),CreatedDateTime,101) as YDate
FROM [SmartButton3].[Universal].[TblCoreTriggerPluginUsage] where CoreTriggerPluginID IN (47,48,49)) X
PIVOT(COUNT(X.CoreTriggerPluginID)
FOR X.CoreTriggerPluginID IN ([47], [48], [49])) AS PVTTable
ORDER BY PVTTable.YDate"></
asp:SqlDataSource
>