or
b.Modules.IFrame=function(p,l){var q=0;
var g=0;
var i=null;
var t="RadUrid";
var k=b;
var h={};
a.extend(this,fileInputAdded:
function
(x){
var
v=r();
a(v).change(a.proxy(s,
this
)).addClass(
"ruFileInput"
);
if
(p._getIsRightToLeft()&&$telerik.isIE){
var
w=$telerik.$(
"<span></span>"
).addClass(
"ruRtlWrap"
);
w.append(v);
v=w[0];
}
a(x).append(v);
var
u=p._createLabel(a(v).attr(
"id"
));
a(x).append(u);
}
...
<
CommandItemTemplate
>
<
asp:ImageButton
ID
=
"btnCreateVersion"
runat
=
"server"
CommandName
=
"CreateVersion"
ImageUrl
=
"~/Image/epi_add.png"
Height
=
"14px"
Visible
=
"true"
></
asp:ImageButton
>
<
asp:LinkButton
ID
=
"lblCrtEpi"
runat
=
"server"
Text
=
"Create Versions"
CommandName
=
"CreateVersion"
Visible
=
"true"
></
asp:LinkButton
>
</
CommandItemTemplate
>
<
telerik:RadAjaxManager
ID
=
"ramTicket"
runat
=
"server"
OnAjaxRequest
=
"ramTicket_AjaxRequest"
DefaultLoadingPanelID
=
"ralpPrivate"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"ramTicket"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"panTicketList"
/>
<
telerik:AjaxUpdatedControl
ControlID
=
"panTicket"
/>
<
telerik:AjaxUpdatedControl
ControlID
=
"panTotalTickets"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
<
telerik:RadCodeBlock
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
// The subscribed close function for the Ticket window
function OnTicketClose(sender, args) {
var ramTicket = $find('<%= ramTicket.ClientID %>');
ramTicket.ajaxRequest('Rebind: ' + args);
}
</
script
>
</
telerik:RadCodeBlock
>
<
telerik:RadWindow
ID
=
"wndDownloadAccounts"
runat
=
"server"
Title
=
"Download Accounts"
Skin
=
"Web20"
Width
=
"500px"
Height
=
"270px"
ReloadOnShow
=
"true"
ShowContentDuringLoad
=
"false"
Behaviors
=
"Close"
VisibleStatusbar
=
"false"
DestroyOnClose
=
"false"
NavigateUrl
=
"~/Views/Accounts/DownloadAccountsWindow.aspx"
/>
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DownloadAccountsWindow.aspx.cs" Inherits="Foo.FooBar.Views.Accounts.DownloadAccountsWindow" MasterPageFile="~/Resources/MasterPages/Bare.Master" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<
asp:Content
ContentPlaceHolderID
=
"CP1"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function InitAccountsData() {
var data = getRadWindowParent().GetAllAccountsData();
$get('<%= allAccountsData.ClientID %>').value = data;
}
function OnTypeChanged(sender, args) {
// <%-- This is vestigial code. --%>
var selected = sender.get_selectedItem().get_text();
}
</
script
>
<
asp:HiddenField
ID
=
"allAccountsData"
runat
=
"server"
/>
<
div
style
=
"padding: 10px;"
>
<
table
cellpadding
=
"5"
>
<
tr
>
<
td
>Download Type</
td
>
<
td
>
<
telerik:RadComboBox
ID
=
"cmbDownloadType"
Width
=
"200px"
runat
=
"server"
Skin
=
"Vista"
OnClientSelectedIndexChanged
=
"OnTypeChanged"
OnClientLoad
=
"OnTypeChanged"
>
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"Morningstar Office"
Value
=
"Morningstar"
/>
<
telerik:RadComboBoxItem
Text
=
"Morningstar Principia"
Value
=
"Principia"
/>
<
telerik:RadComboBoxItem
Text
=
"Morningstar Principia CAMS"
Value
=
"CAMS"
/>
<
telerik:RadComboBoxItem
Text
=
"Orion"
Value
=
"Orion"
/>
<
telerik:RadComboBoxItem
Text
=
"EbixCRM SmartOffice"
Value
=
"SmartOffice"
/>
</
Items
>
</
telerik:RadComboBox
>
</
td
>
</
tr
>
<
tr
>
<
td
>As-Of Date</
td
>
<
td
>
<
telerik:RadDatePicker
ID
=
"dateAsOf"
runat
=
"server"
Skin
=
"Vista"
/>
</
td
>
</
tr
>
</
table
>
<
br
/>
<
center
>
<
asp:Button
ID
=
"btnDownload"
runat
=
"server"
Text
=
"Download"
Width
=
"100px"
OnClick
=
"btnDownload_Click"
/>
<
input
type
=
"button"
value
=
"Close"
style
=
"width:100px;"
onclick
=
"getRadWindow().close()"
/>
</
center
>
</
div
>
<
script
>
InitAccountsData();
</
script
>
</
asp:Content
>
I year students ( Group by Year) |
||
Science ( Group by Department) |
||
Name |
Student ID |
Avg mark |
XXX |
11111111 |
89 |
YYY |
22222222 |
56 |
Maths ( Group by Department) |
||
Name |
Student ID |
Avg mark |
GGG |
3333333 |
83 |
HHH |
3333333 |
68 |
II year students ( Group by Year) |
||
Science ( Group by Department) |
||
Name |
Student ID |
Avg mark |
XX |
111111 |
99 |
YY |
222222 |
87 |
<
telerik:RadToolTip
ID
=
"RadToolTip2"
runat
=
"server"
Modal
=
"true"
ShowEvent
=
"FromCode"
Position
=
"TopCenter"
RelativeTo
=
"BrowserWindow"
OnClientBeforeHide
=
"OnClientBeforeHide"
HideEvent
=
"FromCode"
ShowCallout
=
"False"
>
<
asp:UpdatePanel
runat
=
"server"
ID
=
"UpdatePanel2"
UpdateMode
=
"Conditional"
>
<
ContentTemplate
>
<
asp:Panel
ID
=
"pnlScheduleAddReport"
runat
=
"server"
Style
=
"padding-left: 11px;"
>
<
h5
>Schedule A New Report</
h5
>
<
telerik:RadComboBox
ZIndex
=
"999999"
ID
=
"ddScheduleReportName"
Label
=
"Report:"
runat
=
"server"
DataSourceID
=
"SQLDataSource1"
AllowCustomText
=
"false"
DataValueField
=
"id"
DataTextField
=
"reportname"
Width
=
"275px"
>
</
telerik:RadComboBox
>
<
telerik:RadComboBox
ZIndex
=
"999999"
ID
=
"ddScheduleReportFrequency"
Label
=
"Frequency:"
runat
=
"server"
DataSourceID
=
"SQLDataSource3"
AllowCustomText
=
"false"
DataValueField
=
"id"
DataTextField
=
"frequencyDesc"
Width
=
"140px"
OnSelectedIndexChanged
=
"ddScheduleReportFrequency_SelectedIndexChanged"
AutoPostBack
=
"true"
>
</
telerik:RadComboBox
>
<
telerik:RadComboBox
ZIndex
=
"999999"
ID
=
"ddScheduleReportParam"
Label
=
"Run Every:"
runat
=
"server"
AllowCustomText
=
"false"
Width
=
"165px"
>
</
telerik:RadComboBox
>
<
br
/><
br
/>
<
asp:Label
ID
=
"lblScheduleReportError"
runat
=
"server"
Text
=
"error label"
Visible
=
"false"
></
asp:Label
><
br
/>
<
telerik:RadButton
ID
=
"btnScheduleAddSubmit"
runat
=
"server"
Text
=
"Add Report To Schedule"
OnClick
=
"btnScheduleAddSubmit_Click"
AutoPostBack
=
"true"
>
</
telerik:RadButton
>
<
telerik:RadButton
ID
=
"btnScheduleAddCancel"
runat
=
"server"
Text
=
"Cancel"
OnClick
=
"btnScheduleAddCancel_Click"
>
</
telerik:RadButton
>
</
asp:Panel
>
</
ContentTemplate
>
<
Triggers
>
<
asp:AsyncPostBackTrigger
ControlID
=
"btnScheduleAddReport"
EventName
=
"Click"
></
asp:AsyncPostBackTrigger
>
</
Triggers
>
</
asp:UpdatePanel
>
</
telerik:RadToolTip
>
Protected Sub btnScheduleAddSubmit_Click(sender As Object, e As System.EventArgs) Handles btnScheduleAddSubmit.Click
Dim strConn As String = System.Configuration.ConfigurationManager.ConnectionStrings("XXXXX").ConnectionString
Dim strSQL As String = "INSERT INTO TABLE (fld1, fld2, fld3, fld4) VALUES (@userID, @reportID, @reportFrequencyID, @reportFrequencyParam)"
Dim oConn As New Data.SqlClient.SqlConnection(strConn)
Dim oCmd As New Data.SqlClient.SqlCommand(strSQL, oConn)
With oCmd.Parameters
.Add(New SqlClient.SqlParameter("@fld1", Session("userID")))
.Add(New SqlClient.SqlParameter("@reportID", ddScheduleReportName.SelectedValue))
.Add(New SqlClient.SqlParameter("@reportFrequencyID", ddScheduleReportFrequency.SelectedValue))
.Add(New SqlClient.SqlParameter("@reportFrequencyParam", ddScheduleReportParam.SelectedValue))
End With
oConn.Open()
oCmd.ExecuteNonQuery()
oConn.Close()
bindReportSchedule()
'If Not ddScheduleReportName.Equals(String.Empty) AndAlso Not ddScheduleReportFrequency.Equals(String.Empty) AndAlso Not ddScheduleReportParam.Equals(String.Empty) Then
Dim script As String = "toHide = true;GetActiveToolTip().hide()"
ScriptManager.RegisterStartupScript(Me.Page, GetType(Page), "scriptKey", script, True)
Me.lblScheduleReportError.Visible = False
'Else
'Me.lblScheduleReportError.Text = "Please select a Report, Frequency, and Frequency Parameter field before submitting."
'Me.lblScheduleReportError.Visible = True
'End If
End Sub