or
<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<telerik:RadAsyncUpload runat="server" AllowedFileExtensions=".jpg,.png" MultipleFileSelection="Automatic" ID="rupImagens" TemporaryFolder="~/Maquinas/Dealer/Anexos/Foto/Tradin" Width="210px" Culture="Portuguese (Brazil)" Skin="Default" MaxFileInputsCount="50" OverwriteExistingFiles="true" OnFileUploaded="OnFileUploaded" OnClientFilesUploaded="OnFileUploaded" OnClientFileUploading="DesabilitaIbtInserir"> <Localization Remove="Remover" Select="Procurar..." Add="Adicionar" Clear="Limpar" Delete="Deletar" /> </telerik:RadAsyncUpload>
