or
| <%@ 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); | |
| } | |
| } | |
| } | |
| } | |