<%
@ Page Language="C#" AutoEventWireup="true" CodeBehind="ShipmentForwardingVendorCrews.aspx.cs"
Inherits="Graebel.RITS.Web.Relocations.ShipmentForwardingVendorCrews" %>
<%
@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<%
@ Register assembly="System.Web.Entity, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" namespace="System.Web.UI.WebControls" tagprefix="asp" %>
<!
DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
html xmlns="http://www.w3.org/1999/xhtml">
<
head runat="server">
<title>Shipment Forwarding Vendor Crews</title>
<link href="../Graebel.css" rel="stylesheet" />
</
head>
<
body>
<form id="ShipmentForwardingVendorCrews" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:Panel ID="PageContent" runat="server">
<h1>
Shipment Forwarding Vendor Crews
</h1>
<br />
<asp:DropDownList ID="ddlODAgent" runat="server">
</asp:DropDownList>
<br />
<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server">
<telerik:RadListBox ID="rlbIsNotCrewLeads" runat="server" Width="200px"
Height="200px" AllowTransfer="True"
TransferToID="rlbIsCrewLeads" AutoPostBackOnTransfer="True"
AllowReorder="True" AutoPostBackOnReorder="True" EnableDragAndDrop="True"
DataSourceID="UnassignedCrewLeadsDataSource" DataKeyField="VendorCrewId" DataTextField="FirstName"
DataValueField="VendorCrewId" Skin="Sunset" BorderColor="Black"
BorderWidth="2px" CausesValidation="False" EmptyMessage="No Crew Members Exist"
ForeColor="Black">
<EmptyMessageTemplate>
No Crew Members Exist
</EmptyMessageTemplate>
</telerik:RadListBox>
<telerik:RadListBox ID="rlbIsCrewLeads" runat="server" Width="200px" Height="200px"
SelectionMode="Multiple" AllowReorder="True" AutoPostBackOnReorder="True"
EnableDragAndDrop="True" Skin="Telerik"
EmptyMessage="No Assigned Crew Members Exist">
<EmptyMessageTemplate>
No Assigned Crew Members Exist
</EmptyMessageTemplate>
</telerik:RadListBox>
<br />
</telerik:RadAjaxPanel>
<asp:EntityDataSource ID="UnassignedCrewLeadsDataSource" runat="server"
AutoGenerateWhereClause="True"
CommandText="SELECT value crew
FROM VendorCrew AS crew
WHERE NOT EXISTS(SELECT sfvc.VendorCrew.VendorCrewId
FROM ShipmentForwardingVendorCrew AS sfvc
WHERE sfvc.Shipments.ShipmentId = @ShipmentId)
AND crew.CompanyEntities.CompanyEntityId = @VendorId
AND crew.IsActive = true
AND crew.IsCrewLead = true"
ConnectionString="name=RITSNetEntities"
DefaultContainerName="RITSNetEntities"
Include="ShipmentForwardingVendorCrew,CompanyEntities">
<CommandParameters>
<asp:QueryStringParameter Name="ShipmentId" QueryStringField="10" Type="Int32" />
<asp:ControlParameter ControlID="ddlODAgent" Name="VendorId"
PropertyName="SelectedValue" Type="Int32" />
</CommandParameters>
</asp:EntityDataSource>
<%
--<asp:EntityDataSource ID="AssignedCrewLeadsDataSource" runat="server"
AutoGenerateWhereClause="True"
CommandText="SELECT value crew
FROM VendorCrew AS crew
WHERE EXISTS(SELECT sfvc.VendorCrew.VendorCrewId
FROM ShipmentForwardingVendorCrew AS sfvc
WHERE sfvc.Shipments.ShipmentId = @ShipmentId)
AND crew.CompanyEntities.CompanyEntityId = @VendorId
AND crew.IsActive = true
AND crew.IsCrewLead = true"
ConnectionString="name=RITSNetEntities"
DefaultContainerName="RITSNetEntities"
Include="ShipmentForwardingVendorCrew,CompanyEntities">
<CommandParameters>
<asp:QueryStringParameter Name="ShipmentId" QueryStringField="10" Type="Int32" />
<asp:ControlParameter ControlID="ddlODAgent" Name="VendorId"
PropertyName="SelectedValue" Type="Int32" />
</CommandParameters>
</asp:EntityDataSource>--
%>
<asp:EntityDataSource ID="UnassignedCrewDataSource" runat="server"
AutoGenerateWhereClause="True"
CommandText="SELECT value crew
FROM VendorCrew AS crew
WHERE NOT EXISTS(SELECT sfvc.VendorCrew.VendorCrewId
FROM ShipmentForwardingVendorCrew AS sfvc
WHERE sfvc.Shipments.ShipmentId = @ShipmentId)
AND crew.CompanyEntities.CompanyEntityId = @VendorId
AND crew.IsActive = true"
ConnectionString="name=RITSNetEntities"
DefaultContainerName="RITSNetEntities"
Include="ShipmentForwardingVendorCrew,CompanyEntities">
<CommandParameters>
<asp:QueryStringParameter Name="ShipmentId" QueryStringField="10" Type="Int32" />
<asp:ControlParameter ControlID="ddlODAgent" Name="VendorId"
PropertyName="SelectedValue" Type="Int32" />
</CommandParameters>
</asp:EntityDataSource>
<%
--<asp:EntityDataSource ID="AssignedCrewDataSource" runat="server"
AutoGenerateWhereClause="True"
CommandText="SELECT value crew
FROM VendorCrew AS crew
WHERE EXISTS(SELECT sfvc.VendorCrew.VendorCrewId
FROM ShipmentForwardingVendorCrew AS sfvc
WHERE sfvc.Shipments.ShipmentId = @ShipmentId)
AND crew.CompanyEntities.CompanyEntityId = @VendorId
AND crew.IsActive = true"
ConnectionString="name=RITSNetEntities"
DefaultContainerName="RITSNetEntities"
Include="ShipmentForwardingVendorCrew,CompanyEntities">
<CommandParameters>
<asp:QueryStringParameter Name="ShipmentId" QueryStringField="10" Type="Int32" />
<asp:ControlParameter ControlID="ddlODAgent" Name="VendorId"
PropertyName="SelectedValue" Type="Int32" />
</CommandParameters>
</asp:EntityDataSource>--
%>
</asp:Panel>
</form>
</
body>
</
html>