| <%@ Page Title="" Language="C#" MasterPageFile="~/Mentor.Master" AutoEventWireup="true" CodeBehind="Test.aspx.cs" Inherits="Mentor.Test" %> |
| <asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server"> |
| <style type="text/css"> |
| .style4 |
| { |
| border-bottom: 1px solid #d0d7e5; |
| font-weight: bold; |
| color: #274c89; |
| background-color: #dde8fe; |
| width: 113px; |
| } |
| .style5 |
| { |
| border-bottom: 1px solid #d0d7e5; |
| font-weight: bold; |
| color: #274c89; |
| background-color: #dde8fe; |
| width: 404px; |
| } |
| .style6 |
| { |
| border-bottom: 1px solid #d0d7e5; |
| font-weight: bold; |
| color: #274c89; |
| background-color: #dde8fe; |
| width: 82px; |
| } |
| </style> |
| </asp:Content> |
| <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server"> |
| <telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxy1" runat="server"> |
| <AjaxSettings> |
| <telerik:AjaxSetting AjaxControlID="RadComboBox1"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="RadComboBox1" |
| LoadingPanelID="RadAjaxLoadingPanel1" /> |
| <telerik:AjaxUpdatedControl ControlID="RadListBox1" |
| LoadingPanelID="RadAjaxLoadingPanel1" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| <telerik:AjaxSetting AjaxControlID="RadComboBox2"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="RadComboBox2" |
| LoadingPanelID="RadAjaxLoadingPanel1" /> |
| <telerik:AjaxUpdatedControl ControlID="RadListBox1" |
| LoadingPanelID="RadAjaxLoadingPanel1" /> |
| <telerik:AjaxUpdatedControl ControlID="RadListBox2" |
| LoadingPanelID="RadAjaxLoadingPanel1" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| <telerik:AjaxSetting AjaxControlID="RadListBox1"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="RadListBox1" |
| LoadingPanelID="RadAjaxLoadingPanel1" /> |
| <telerik:AjaxUpdatedControl ControlID="RadListBox2" |
| LoadingPanelID="RadAjaxLoadingPanel1" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| <telerik:AjaxSetting AjaxControlID="RadListBox2"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="RadListBox1" |
| LoadingPanelID="RadAjaxLoadingPanel1" /> |
| <telerik:AjaxUpdatedControl ControlID="RadListBox2" |
| LoadingPanelID="RadAjaxLoadingPanel1" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| </AjaxSettings> |
| </telerik:RadAjaxManagerProxy> |
| <asp:SqlDataSource ID="dsCategory" runat="server" |
| ConnectionString="<%$ ConnectionStrings:MentorDBConnectionString %>" |
| SelectCommand="SELECT [Category_ID], [CategoryName], [Client_ID] FROM [Categories] WHERE ([Client_ID] = @Client_ID) ORDER BY [CategoryName]"> |
| <SelectParameters> |
| <asp:Parameter DefaultValue="1" Name="Client_ID" Type="Int32" /> |
| </SelectParameters> |
| </asp:SqlDataSource> |
| <asp:SqlDataSource ID="dsRole" runat="server" |
| ConnectionString="<%$ ConnectionStrings:MentorDBConnectionString %>" |
| SelectCommand="SELECT [Role_ID], [Client_ID], [RoleName] FROM [Roles] WHERE ([Client_ID] = @Client_ID) ORDER BY [RoleName]"> |
| <SelectParameters> |
| <asp:Parameter DefaultValue="1" Name="Client_ID" Type="Int32" /> |
| </SelectParameters> |
| </asp:SqlDataSource> |
| <asp:SqlDataSource ID="dsTopics" runat="server" |
| ConnectionString="<%$ ConnectionStrings:MentorDBConnectionString %>" |
| InsertCommand="INSERT INTO [TopicAssignment] ([Topic_ID], [Role_ID], [SortOrder]) VALUES (@Topic_ID, @Role_ID, @SortOrder)" |
| SelectCommand="SELECT Topic_ID, TopicName, Category_ID, SortOrder FROM Topics WHERE (Category_ID = @Category_ID) AND (NOT EXISTS (SELECT Topic_ID, Role_ID FROM TopicAssignment WHERE (Topic_ID = Topics.Topic_ID) AND (Role_ID = @Role_ID))) ORDER BY TopicName"> |
| <SelectParameters> |
| <asp:ControlParameter ControlID="RadComboBox1" DefaultValue="1" |
| Name="Category_ID" PropertyName="SelectedValue" /> |
| <asp:ControlParameter ControlID="RadComboBox2" DefaultValue="1" Name="Role_ID" |
| PropertyName="SelectedValue" /> |
| </SelectParameters> |
| <InsertParameters> |
| <asp:Parameter Name="Topic_ID" /> |
| <asp:Parameter Name="Role_ID" /> |
| <asp:Parameter Name="SortOrder" /> |
| </InsertParameters> |
| </asp:SqlDataSource> |
| <asp:SqlDataSource ID="rsAssignedTopics" runat="server" |
| ConnectionString="<%$ ConnectionStrings:MentorDBConnectionString %>" |
| DeleteCommand="DELETE FROM [TopicAssignment] WHERE [TopicAssign_ID] = @TopicAssign_ID" |
| InsertCommand="INSERT INTO [TopicAssignment] ([Topic_ID], [Role_ID], [SortOrder]) VALUES (@Topic_ID, @Role_ID, @SortOrder)" |
| SelectCommand="SELECT [TopicAssign_ID], [Topic_ID], [Role_ID], [SortOrder] FROM [TopicAssignment] WHERE ([Role_ID] = @Role_ID) ORDER BY SortOrder" |
| UpdateCommand="UPDATE [TopicAssignment] SET [Topic_ID] = @Topic_ID, [Role_ID] = @Role_ID, [SortOrder] = @SortOrder WHERE [TopicAssign_ID] = @TopicAssign_ID"> |
| <SelectParameters> |
| <asp:ControlParameter ControlID="RadComboBox2" DefaultValue="1" Name="Role_ID" |
| PropertyName="SelectedValue" Type="Int32" /> |
| </SelectParameters> |
| <DeleteParameters> |
| <asp:Parameter Name="TopicAssign_ID" Type="Int32" /> |
| </DeleteParameters> |
| <UpdateParameters> |
| <asp:Parameter Name="Topic_ID" Type="Int32" /> |
| <asp:Parameter Name="Role_ID" Type="Int32" /> |
| <asp:Parameter Name="SortOrder" Type="Int32" /> |
| </UpdateParameters> |
| <InsertParameters> |
| <asp:Parameter Name="Topic_ID" Type="Int32" /> |
| <asp:Parameter Name="Role_ID" Type="Int32" /> |
| <asp:Parameter Name="SortOrder" Type="Int32" /> |
| </InsertParameters> |
| </asp:SqlDataSource> |
| <table width="100%" border="0" cellpadding="0" cellspacing="0" class="panelBorders"> |
| <tr> |
| <td height="24" class="headerCell"> |
| <table border="0" cellspacing="2" |
| cellpadding="2" style="width: 100%"> |
| <tr> |
| <td width="2%" align="center"> |
| <img src="images/assignpositions.png" width="16" |
| height="16" /></td> |
| <td width="100%" class="headerText"> |
| Build Curriculum</td> |
| </tr> |
| </table> |
| </td> |
| </tr> |
| <tr> |
| <td class="panelContent" valign="top"> |
| <table border="0" cellspacing="3" |
| cellpadding="3" style="width: 100%"> |
| <tr> |
| <td class="style5"> |
| Instructions go here</td> |
| </tr> |
| </table> |
| </td> |
| </tr> |
| </table> |
| <table width="100%" border="0" cellspacing="0" cellpadding="0"> |
| <tr> |
| <td><img src="images/shim.gif" width="100" |
| height="6" /></td> |
| </tr> |
| </table> |
| <table width="100%" border="0" cellspacing="0" cellpadding="0"> |
| <tr> |
| <td width="485" valign="top"> |
| <table width="100%" border="0" cellpadding="0" cellspacing="0" class="panelBorders"> |
| <tr> |
| <td height="24" class="headerCell"> |
| <table border="0" cellspacing="2" |
| cellpadding="2" style="width: 100%"> |
| <tr> |
| <td width="2%" align="center"> |
| <img src="images/assignpositions.png" width="16" |
| height="16" /></td> |
| <td width="100%" class="headerText"> |
| Available Topics</td> |
| </tr> |
| </table> |
| </td> |
| </tr> |
| <tr> |
| <td class="panelContent" valign="top"> |
| <table width="100%" border="0" cellspacing="0" cellpadding="0"> |
| <tr> |
| <td height="28" valign="middle" class="style4" align="center">Select Category:</td> |
| <td valign="middle" class="comborowBackground"> |
| <telerik:RadComboBox ID="RadComboBox1" Runat="server" AutoPostBack="True" |
| DataSourceID="dsCategory" DataTextField="CategoryName" |
| DataValueField="Category_ID" EmptyMessage="Select Category" |
| Skin="Office2007" Width="100%"> |
| </telerik:RadComboBox> |
| </td> |
| </tr> |
| </table> |
| <table width="100%" border="0" cellspacing="2" cellpadding="2"> |
| <tr> |
| <td height="23" valign="middle"> |
| <telerik:RadListBox ID="RadListBox1" runat="server" AllowTransfer="True" |
| DataKeyField="Topic_ID" DataSourceID="dsTopics" DataTextField="TopicName" |
| DataValueField="Topic_ID" Height="500px" Skin="Office2007" |
| style="top: 0px; left: 0px" TransferToID="RadListBox2" Width="100%" |
| AllowAutomaticUpdates="True" AutoPostBackOnTransfer="True" TransferMode="Copy"> |
| </telerik:RadListBox> |
| </td> |
| </tr> |
| </table> |
| </td> |
| </tr> |
| </table> |
| </td> |
| <td width="6"> </td> |
| <td width="485" valign="top"> |
| <table width="100%" border="0" cellpadding="0" cellspacing="0" class="panelBorders"> |
| <tr> |
| <td height="24" class="headerCell"> |
| <table border="0" cellspacing="2" |
| cellpadding="2" style="width: 100%"> |
| <tr> |
| <td width="2%" align="center"> |
| <img src="images/assignpositions.png" width="16" |
| height="16" /></td> |
| <td width="100%" class="headerText"> |
| Topics For</td> |
| </tr> |
| </table> |
| </td> |
| </tr> |
| <tr> |
| <td class="panelContent" valign="top"> |
| <table width="100%" border="0" cellspacing="0" cellpadding="0"> |
| <tr> |
| <td height="28" valign="middle" class="style6" align="center">Select Role:</td> |
| <td height="28" valign="middle" class="comborowBackground"> |
| <telerik:RadComboBox ID="RadComboBox2" Runat="server" DataSourceID="dsRole" |
| DataTextField="RoleName" DataValueField="Role_ID" EmptyMessage="Select Role" |
| Skin="Office2007" AutoPostBack="True" Width="100%"> |
| </telerik:RadComboBox> |
| </td> |
| </tr> |
| </table> |
| <table width="100%" border="0" cellspacing="2" cellpadding="2"> |
| <tr> |
| <td height="23" valign="middle"> |
| <telerik:RadListBox ID="RadListBox2" runat="server" |
| AllowAutomaticUpdates="True" AllowDelete="True" AllowReorder="True" |
| AutoPostBackOnDelete="True" AutoPostBackOnReorder="True" |
| DataKeyField="TopicAssign_ID" DataSortField="SortOrder" |
| DataSourceID="rsAssignedTopics" DataTextField="Topic_ID" |
| DataValueField="TopicAssign_ID" Height="500px" Skin="Office2007" |
| style="top: 0px; left: 0px" TransferToID="RadListBox1" Width="100%" TransferMode="Copy"> |
| </telerik:RadListBox> |
| </td> |
| </tr> |
| </table> |
| </td> |
| </tr> |
| </table> |
| </td> |
| </tr> |
| </table> |
| <table width="100%" border="0" cellspacing="0" cellpadding="0"> |
| <tr> |
| <td><img src="images/shim.gif" width="100" |
| height="6" /></td> |
| </tr> |
| </table> |
| </asp:Content> |
| |