| <telerik:RadChart runat="server" ID="rchTest" Skin="Office2007" AutoLayout="true"> |
| <ChartTitle> |
| <TextBlock Visible="false" /> |
| </ChartTitle> |
| <Legend> |
| <Appearance Position-AlignedPosition="Bottom"> |
| </Appearance> |
| </Legend> |
| <PlotArea> |
| <Appearance> |
| <Border Width="0" /> |
| </Appearance> |
| <XAxis LayoutMode="Inside" MinValue="1" Step="1"> |
| <AxisLabel> |
| <TextBlock Text="TestX"> |
| <Appearance Position-AlignedPosition="Left" /> |
| </TextBlock> |
| </AxisLabel> |
| <Appearance ValueFormat="General"> |
| <MajorGridLines Visible="true" PenStyle="Dot" Width="1" /> |
| <MinorGridLines Visible="false" /> |
| </Appearance> |
| </XAxis> |
| <YAxis AutoScale="false"> |
| <AxisLabel> |
| <TextBlock Text="TestY"> |
| <Appearance Position-AlignedPosition="Left" /> |
| </TextBlock> |
| </AxisLabel> |
| <Appearance ValueFormat="General"> |
| <MajorGridLines Visible="true" Width="1" /> |
| <MinorGridLines Visible="false" /> |
| </Appearance> |
| <Items> |
| <telerik:ChartAxisItem TextBlock-Text="" Value="0" /> |
| <telerik:ChartAxisItem TextBlock-Text="L1" Value="1" /> |
| <telerik:ChartAxisItem TextBlock-Text="L2" Value="2" /> |
| <telerik:ChartAxisItem TextBlock-Text="L3" Value="3" /> |
| <telerik:ChartAxisItem TextBlock-Text="L4" Value="4" /> |
| <telerik:ChartAxisItem TextBlock-Text="L5" Value="5" /> |
| </Items> |
| </YAxis> |
| </PlotArea> |
| <Series> |
| <telerik:ChartSeries Name="Series 1" Type="Line"> |
| <Appearance ShowLabels="false"> |
| <FillStyle MainColor="Red"> |
| </FillStyle> |
| </Appearance> |
| <Items> |
| <telerik:ChartSeriesItem YValue="1" Name="Item 1"> |
| </telerik:ChartSeriesItem> |
| <telerik:ChartSeriesItem YValue="2" Name="Item 2"> |
| </telerik:ChartSeriesItem> |
| <telerik:ChartSeriesItem YValue="1" Name="Item 3"> |
| </telerik:ChartSeriesItem> |
| <telerik:ChartSeriesItem YValue="3" Name="Item 4"> |
| </telerik:ChartSeriesItem> |
| <telerik:ChartSeriesItem YValue="2" Name="Item 5"> |
| </telerik:ChartSeriesItem> |
| </Items> |
| </telerik:ChartSeries> |
| <telerik:ChartSeries Name="Series 2" Type="Line"> |
| <Appearance ShowLabels="false"> |
| <FillStyle MainColor="Blue"> |
| </FillStyle> |
| </Appearance> |
| <Items> |
| <telerik:ChartSeriesItem YValue="3" Name="Item 1"> |
| </telerik:ChartSeriesItem> |
| <telerik:ChartSeriesItem YValue="1" Name="Item 2"> |
| </telerik:ChartSeriesItem> |
| <telerik:ChartSeriesItem YValue="5" Name="Item 3"> |
| </telerik:ChartSeriesItem> |
| <telerik:ChartSeriesItem YValue="1" Name="Item 4"> |
| </telerik:ChartSeriesItem> |
| <telerik:ChartSeriesItem YValue="2" Name="Item 5"> |
| </telerik:ChartSeriesItem> |
| </Items> |
| </telerik:ChartSeries> |
| </Series> |
| </telerik:RadChart> |
telerik:RadGrid ID="RadGridPersons" runat="server"
AutoGenerateColumns="False" AllowFilteringByColumn="false" AllowSorting="True"
SortingSettings-EnableSkinSortStyles="true" Width="80%" Visible="false"
OnSortCommand="RadGridPersons_SortCommand" onitemdatabound="RadGridPersons_ItemDataBound">
<MasterTableView CellSpacing="-1" TableLayout="Fixed" Width="100%"
AllowNaturalSort="false" AllowMultiColumnSorting="false">
<SortExpressions>
<telerik:GridSortExpression FieldName="LastName" SortOrder="Ascending" />
</SortExpressions>
<RowIndicatorColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
<Columns>
<telerik:GridBoundColumn DataField="CustomerId"
HeaderText='<%$Resources:Customers, PersonCustomerSearchResultHeader_CustomerNumber%>'
SortExpression="CustomerId" UniqueName="CustomerId" Visible="false">
</telerik:GridBoundColumn>
<telerik:GridHyperLinkColumn DataTextField="LastName"
HeaderText='<%$Resources:Customers, PersonCustomerSearchResultHeader_LastName%>'
SortExpression="LastName" UniqueName="LastName" DataNavigateUrlFields="CustomerId"
DataNavigateUrlFormatString="PersonCustomer.aspx?CustomerId={0}" Visible="true"
HeaderStyle-Width="90" HeaderStyle-Wrap="true" ItemStyle-Font-Italic="true"
ItemStyle-Width="90" ItemStyle-Wrap="false">
</telerik:GridHyperLinkColumn>
| protected void RadGridPersons_SortCommand(object source, Telerik.Web.UI.GridSortCommandEventArgs e) |
| { |
| GridDataItemCollection Coll = RadGridPersons.MasterTableView.Items; |
| var Items = from GridDataItem item in Coll |
| orderby e.CommandSource ascending |
| select new |
| { |
| CustomerId = item["CustomerId"].Text.ToString(), |
| LastName = (item["LastName"].Controls[0] as HyperLink).Text.ToString(), |
| ForeNames = item["ForeNames"].Text.ToString(), |
| Street = item["Street"].Text.ToString(), |
| PostalCode = item["PostalCode"].Text.ToString(), |
| City = item["City"].Text.ToString(), |
| SocialSecurityId = item["SocialSecurityId"].Text.ToString(), |
| StatusKey = item["StatusKey"].Text.ToString(), |
| }; |
| RadGridPersons.DataSource = |
| (e.NewSortOrder == GridSortOrder.Ascending) ? Items : Items.OrderByDescending(x => x.LastName); |
| RadGridPersons.DataBind(); |
| } |
| <%@ Control Language="C#" AutoEventWireup="true" CodeBehind="Sample.ascx.cs" Inherits="Touchstone.PT.Daimler.Web.Views.P2P.Sample" %> |
| <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Charting" TagPrefix="telerik" %> |
| <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> |
| <telerik:RadAjaxLoadingPanel ID="AjaxLoadingPanel1" runat="server" Transparency="15" Width="800" BackColor="white"> |
| <div style="height:30px"> </div> |
| <img alt="Saving..." src='<%= RadAjaxLoadingPanel.GetWebResourceUrl(Page, "Telerik.Web.UI.Skins.Default.Ajax.loading.gif") %>' style="border: 0px; vertical-align: middle;" /> |
| </telerik:RadAjaxLoadingPanel> |
| <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" UpdatePanelsRenderMode="Inline"> |
| <AjaxSettings> |
| <telerik:AjaxSetting AjaxControlID="btnSearch"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="rgUsers" LoadingPanelID="AjaxLoadingPanel1" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| <telerik:AjaxSetting AjaxControlID="rgUsers"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="rgUsers" LoadingPanelID="AjaxLoadingPanel1" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| </AjaxSettings> |
| </telerik:RadAjaxManager> |
| <asp:Button id="btnSearch" runat="server" Text="Search" OnClick="btnSearch_Click" /> |
| <br /> |
| <telerik:RadGrid ID="rgUsers" runat="server" Width="100%" ShowStatusBar="false" AllowSorting="true" AllowMultiRowSelection="True" OnNeedDataSource="rgUsers_NeedDataSource"> |
| <MasterTableView AutoGenerateColumns="false" TableLayout="fixed" Width="100%" AllowNaturalSort="false"> |
| <Columns> |
| <telerik:GridClientSelectColumn Reorderable="False" UniqueName="ClientSelectColumn"> |
| <HeaderStyle Width="42px"></HeaderStyle> |
| </telerik:GridClientSelectColumn> |
| </Columns> |
| </MasterTableView> |
| <PagerStyle NextPageText="Next" PrevPageText="Prev" Mode="NextPrevAndNumeric"></PagerStyle> |
| <ClientSettings AllowDragToGroup="True"> |
| <Selecting AllowRowSelect="True"></Selecting> |
| </ClientSettings> |
| </telerik:RadGrid> |
| protected void btnSearch_Click(object sender, EventArgs e) |
| { |
| rgUsers.MasterTableView.Rebind(); |
| } |
| protected void rgUsers_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) |
| { |
| rgUsers.DataSource = new string[] { "Bob", "Tom", "Gary" }; |
| } |
| private WebServiceAppointmentController Controller | |
| { | |
| get | |
| { | |
| if (_controller == null) | |
| { | |
| //_controller = | |
| // new WebServiceAppointmentController( | |
| // new XmlSchedulerProvider(HttpContext.Current.Server.MapPath("~/App_Data/Appointments_Outlook.xml"), | |
| // false)); | |
| _controller = new WebServiceAppointmentController("ReadOnlySchedulerData"); | |
| } | |
| return _controller; | |
| } | |
| } | |
| private void LoadResources(Appointment apt) | |
| { | |
| using (DbConnection conn = OpenConnection()) | |
| { | |
| DbCommand cmd = DbFactory.CreateCommand(); | |
| cmd.Connection = conn; | |
| cmd.Parameters.Add(CreateParameter("@ClassID", apt.ID)); | |
| cmd.CommandText = "SELECT [TeacherID] FROM [DbProvider_Classes] WHERE [ClassID] = @ClassID AND [TeacherID] IS NOT NULL"; | |
| using (DbDataReader reader = cmd.ExecuteReader()) | |
| { | |
| if (reader.Read()) | |
| { | |
| Resource teacher = apt.Owner.Resources.GetResource("Teacher", reader["TeacherID"]); | |
| apt.Resources.Add(teacher); | |
| } | |
| } | |
| cmd.Parameters.Clear(); | |
| cmd.Parameters.Add(CreateParameter("@ClassID", apt.ID)); | |
| cmd.CommandText = "SELECT [StudentID] FROM [DbProvider_ClassStudents] WHERE [ClassID] = @ClassID"; | |
| using (DbDataReader reader = cmd.ExecuteReader()) | |
| { | |
| while (reader.Read()) | |
| { | |
| Resource student = apt.Owner.Resources.GetResource("Student", reader["StudentID"]); | |
| apt.Resources.Add(student); | |
| } | |
| } | |
| } | |
| } | |