<asp:ListView ID="ListView1" runat="server" DataKeyNames="PtAcct"
DataSourceID="NutritionCenter">
<ItemTemplate>
<tr style="background-color:#DCDCDC;color: #000000;">
<td>
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
<asp:Button ID="SelectButton" runat="server" CommandName="Select" Text="Select" />
</td>
<td>
<asp:Label ID="PtAcctLabel" runat="server" Text='<%# Eval("PtAcct") %>' />
</td>
<td>
<asp:Label ID="PtNameLabel" runat="server"
Text='<%# Eval("PtName") %>' />
</td>
<td>
<asp:Label ID="VisitDateLabel" runat="server"
Text='<%# Eval("VisitDate") %>' />
</td>
<td>
<asp:Label ID="ResponsibleLabel" runat="server"
Text='<%# Eval("Responsible") %>' />
</td>
<td>
<asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
</td>
<td>
<asp:Label ID="CityLabel" runat="server" Text='<%# Eval("City") %>' />
</td>
<td>
<asp:Label ID="StateLabel" runat="server" Text='<%# Eval("State") %>' />
</td>
<td>
<asp:Label ID="ZipLabel" runat="server" Text='<%# Eval("Zip") %>' />
</td>
<td>
<asp:Label ID="MRNumLabel" runat="server" Text='<%# Eval("MRNum") %>' />
</td>
</tr>
</ItemTemplate>
<AlternatingItemTemplate>
<tr style="background-color:#FFF8DC;">
<td>
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
<asp:Button ID="SelectButton" runat="server" CommandName="Select" Text="Select" />
</td>
<td>
<asp:Label ID="PtAcctLabel" runat="server" Text='<%# Eval("PtAcct") %>' />
</td>
<td>
<asp:Label ID="PtNameLabel" runat="server"
Text='<%# Eval("PtName") %>' />
</td>
<td>
<asp:Label ID="VisitDateLabel" runat="server"
Text='<%# Eval("VisitDate") %>' />
</td>
<td>
<asp:Label ID="ResponsibleLabel" runat="server"
Text='<%# Eval("Responsible") %>' />
</td>
<td>
<asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
</td>
<td>
<asp:Label ID="CityLabel" runat="server" Text='<%# Eval("City") %>' />
</td>
<td>
<asp:Label ID="StateLabel" runat="server" Text='<%# Eval("State") %>' />
</td>
<td>
<asp:Label ID="ZipLabel" runat="server" Text='<%# Eval("Zip") %>' />
</td>
<td>
<asp:Label ID="MRNumLabel" runat="server" Text='<%# Eval("MRNum") %>' />
</td>
</tr>
</AlternatingItemTemplate>
<EmptyDataTemplate>
<table runat="server"
style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;">
<tr>
<td>
No data was returned.</td>
</tr>
</table>
</EmptyDataTemplate>
<InsertItemTemplate>
<tr style="">
<td>
<asp:Button ID="InsertButton" runat="server" CommandName="Insert"
Text="Insert" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel"
Text="Clear" />
</td>
<td>
<asp:TextBox ID="PtAcctTextBox" runat="server" Text='<%# Bind("PtAcct") %>' />
</td>
<td>
<asp:TextBox ID="PtNameTextBox" runat="server" Text='<%# Bind("PtName") %>' />
</td>
<td>
<asp:TextBox ID="VisitDateTextBox" runat="server"
Text='<%# Bind("VisitDate") %>' />
</td>
<td>
<asp:TextBox ID="ResponsibleTextBox" runat="server"
Text='<%# Bind("Responsible") %>' />
</td>
<td>
<asp:TextBox ID="AddressTextBox" runat="server" Text='<%# Bind("Address") %>' />
</td>
<td>
<asp:TextBox ID="CityTextBox" runat="server" Text='<%# Bind("City") %>' />
</td>
<td>
<asp:TextBox ID="StateTextBox" runat="server" Text='<%# Bind("State") %>' />
</td>
<td>
<asp:TextBox ID="ZipTextBox" runat="server" Text='<%# Bind("Zip") %>' />
</td>
<td>
<asp:TextBox ID="MRNumTextBox" runat="server" Text='<%# Bind("MRNum") %>' />
</td>
</tr>
</InsertItemTemplate>
<LayoutTemplate>
<table runat="server">
<tr runat="server">
<td runat="server">
<table ID="itemPlaceholderContainer" runat="server" border="1"
style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;font-family: Verdana, Arial, Helvetica, sans-serif;">
<tr runat="server" style="background-color:#DCDCDC;color: #000000;">
<th runat="server">
</th>
<th runat="server">
PtAcct</th>
<th runat="server">
PtName</th>
<th runat="server">
VisitDate</th>
<th runat="server">
Responsible</th>
<th runat="server">
Address</th>
<th runat="server">
City</th>
<th runat="server">
State</th>
<th runat="server">
Zip</th>
<th runat="server">
MRNum</th>
</tr>
<tr ID="itemPlaceholder" runat="server">
</tr>
</table>
</td>
</tr>
<tr runat="server">
<td runat="server"
style="text-align: center;background-color: #CCCCCC;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000000;">
</td>
</tr>
</table>
</LayoutTemplate>
<EditItemTemplate>
<tr style="background-color:#008A8C;color: #FFFFFF;">
<td>
<asp:Button ID="UpdateButton" runat="server" CommandName="Update"
Text="Update" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel"
Text="Cancel" />
</td>
<td>
<asp:Label ID="PtAcctLabel1" runat="server" Text='<%# Eval("PtAcct") %>' />
</td>
<td>
<asp:TextBox ID="PtNameTextBox" runat="server" Text='<%# Bind("PtName") %>' />
</td>
<td>
<asp:TextBox ID="VisitDateTextBox" runat="server"
Text='<%# Bind("VisitDate") %>' />
</td>
<td>
<asp:TextBox ID="ResponsibleTextBox" runat="server"
Text='<%# Bind("Responsible") %>' />
</td>
<td>
<asp:TextBox ID="AddressTextBox" runat="server" Text='<%# Bind("Address") %>' />
</td>
<td>
<asp:TextBox ID="CityTextBox" runat="server" Text='<%# Bind("City") %>' />
</td>
<td>
<asp:TextBox ID="StateTextBox" runat="server" Text='<%# Bind("State") %>' />
</td>
<td>
<asp:TextBox ID="ZipTextBox" runat="server" Text='<%# Bind("Zip") %>' />
</td>
<td>
<asp:TextBox ID="MRNumTextBox" runat="server" Text='<%# Bind("MRNum") %>' />
</td>
</tr>
</EditItemTemplate>
<SelectedItemTemplate>
<tr style="background-color:#008A8C;font-weight: bold;color: #FFFFFF;">
<td>
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
<asp:Button ID="SelectButton" runat="server" CommandName="Select" Text="Select" />
</td>
<td>
<asp:Label ID="PtAcctLabel" runat="server" Text='<%# Eval("PtAcct") %>' />
</td>
<td>
<asp:Label ID="PtNameLabel" runat="server"
Text='<%# Eval("PtName") %>' />
</td>
<td>
<asp:Label ID="VisitDateLabel" runat="server"
Text='<%# Eval("VisitDate") %>' />
</td>
<td>
<asp:Label ID="ResponsibleLabel" runat="server"
Text='<%# Eval("Responsible") %>' />
</td>
<td>
<asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
</td>
<td>
<asp:Label ID="CityLabel" runat="server" Text='<%# Eval("City") %>' />
</td>
<td>
<asp:Label ID="StateLabel" runat="server" Text='<%# Eval("State") %>' />
</td>
<td>
<asp:Label ID="ZipLabel" runat="server" Text='<%# Eval("Zip") %>' />
</td>
<td>
<asp:Label ID="MRNumLabel" runat="server" Text='<%# Eval("MRNum") %>' />
</td>
</tr>
</SelectedItemTemplate>
</asp:ListView>
<asp:SqlDataSource ID="NutritionCenter" runat="server"
ConnectionString="<%$ ConnectionStrings:NutritionCenterConnectionString2 %>"
SelectCommand="SELECT DISTINCT PtAcctData.PtAcct, PtAcctData.PtName, PtHistory.VisitDate, PtAcctData.Responsible, PtAcctData.Address, PtAcctData.City, PtAcctData.State, PtAcctData.Zip, PtAcctData.MRNum FROM PtAcctData LEFT OUTER JOIN PtHistory ON PtAcctData.PtAcct = PtHistory.PtAcct WHERE (PtAcctData.PtName LIKE '%' + @PtName + '%')"
DeleteCommand="DELETE FROM [PtAcctData] WHERE [PtAcct] = @PtAcct"
InsertCommand="INSERT INTO [PtAcctData] ([PtAcct], [PtName], [Responsible], [Address], [City], [State], [Zip], [MRNum]) VALUES (@PtAcct, @PtName, @Responsible, @Address, @City, @State, @Zip, @MRNum)"
UpdateCommand="UPDATE [PtAcctData] SET [PtName] = @PtName, [Responsible] = @Responsible, [Address] = @Address, [City] = @City, [State] = @State, [Zip] = @Zip, [MRNum] = @MRNum WHERE [PtAcct] = @PtAcct">
<SelectParameters>
<asp:ControlParameter ControlID="txt1" Name="PtName" PropertyName="Text"
Type="String" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="PtAcct" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="PtName" Type="String" />
<asp:Parameter Name="Responsible" Type="String" />
<asp:Parameter Name="Address" Type="String" />
<asp:Parameter Name="City" Type="String" />
<asp:Parameter Name="State" Type="String" />
<asp:Parameter Name="Zip" Type="Int32" />
<asp:Parameter Name="MRNum" Type="String" />
<asp:Parameter Name="PtAcct" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="PtAcct" Type="Int32" />
<asp:Parameter Name="PtName" Type="String" />
<asp:Parameter Name="Responsible" Type="String" />
<asp:Parameter Name="Address" Type="String" />
<asp:Parameter Name="City" Type="String" />
<asp:Parameter Name="State" Type="String" />
<asp:Parameter Name="Zip" Type="Int32" />
<asp:Parameter Name="MRNum" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</p>
<p>
<asp:ListView ID="ListView2" runat="server" DataSourceID="NutritionCenter2">
<ItemTemplate>
<tr style="background-color:#DCDCDC;color: #000000;">
<td>
<asp:Label ID="PtAcctLabel" runat="server" Text='<%# Eval("PtAcct") %>' />
</td>
<td>
<asp:Label ID="VisitNumLabel" runat="server" Text='<%# Eval("VisitNum") %>' />
</td>
<td>
<asp:Label ID="VisitDateLabel" runat="server" Text='<%# Eval("VisitDate") %>' />
</td>
<td>
<asp:Label ID="CPTLabel" runat="server" Text='<%# Eval("CPT") %>' />
</td>
<td>
<asp:Label ID="DescriptionLabel" runat="server"
Text='<%# Eval("Description") %>' />
</td>
<td>
<asp:Label ID="QtyLabel" runat="server" Text='<%# Eval("Qty") %>' />
</td>
<td>
<asp:Label ID="FeeLabel" runat="server" Text='<%# Eval("Fee") %>' />
</td>
<td>
<asp:Label ID="TotalLabel" runat="server" Text='<%# Eval("Total") %>' />
</td>
</tr>
</ItemTemplate>
<AlternatingItemTemplate>
<tr style="background-color:#FFF8DC;">
<td>
<asp:Label ID="PtAcctLabel" runat="server" Text='<%# Eval("PtAcct") %>' />
</td>
<td>
<asp:Label ID="VisitNumLabel" runat="server" Text='<%# Eval("VisitNum") %>' />
</td>
<td>
<asp:Label ID="VisitDateLabel" runat="server" Text='<%# Eval("VisitDate") %>' />
</td>
<td>
<asp:Label ID="CPTLabel" runat="server" Text='<%# Eval("CPT") %>' />
</td>
<td>
<asp:Label ID="DescriptionLabel" runat="server"
Text='<%# Eval("Description") %>' />
</td>
<td>
<asp:Label ID="QtyLabel" runat="server" Text='<%# Eval("Qty") %>' />
</td>
<td>
<asp:Label ID="FeeLabel" runat="server" Text='<%# Eval("Fee") %>' />
</td>
<td>
<asp:Label ID="TotalLabel" runat="server" Text='<%# Eval("Total") %>' />
</td>
</tr>
</AlternatingItemTemplate>
<EmptyDataTemplate>
<table runat="server"
style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;">
<tr>
<td>
No data was returned.</td>
</tr>
</table>
</EmptyDataTemplate>
<InsertItemTemplate>
<tr style="">
<td>
<asp:Button ID="InsertButton" runat="server" CommandName="Insert"
Text="Insert" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel"
Text="Clear" />
</td>
<td>
<asp:TextBox ID="PtAcctTextBox" runat="server" Text='<%# Bind("PtAcct") %>' />
</td>
<td>
<asp:TextBox ID="VisitNumTextBox" runat="server"
Text='<%# Bind("VisitNum") %>' />
</td>
<td>
<asp:TextBox ID="VisitDateTextBox" runat="server"
Text='<%# Bind("VisitDate") %>' />
</td>
<td>
<asp:TextBox ID="CPTTextBox" runat="server" Text='<%# Bind("CPT") %>' />
</td>
<td>
<asp:TextBox ID="DescriptionTextBox" runat="server"
Text='<%# Bind("Description") %>' />
</td>
<td>
<asp:TextBox ID="QtyTextBox" runat="server" Text='<%# Bind("Qty") %>' />
</td>
<td>
<asp:TextBox ID="FeeTextBox" runat="server" Text='<%# Bind("Fee") %>' />
</td>
<td>
<asp:TextBox ID="TotalTextBox" runat="server" Text='<%# Bind("Total") %>' />
</td>
</tr>
</InsertItemTemplate>
<LayoutTemplate>
<table runat="server">
<tr runat="server">
<td runat="server">
<table ID="itemPlaceholderContainer" runat="server" border="1"
style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;font-family: Verdana, Arial, Helvetica, sans-serif;">
<tr runat="server" style="background-color:#DCDCDC;color: #000000;">
<th runat="server">
PtAcct</th>
<th runat="server">
VisitNum</th>
<th runat="server">
VisitDate</th>
<th runat="server">
CPT</th>
<th runat="server">
Description</th>
<th runat="server">
Qty</th>
<th runat="server">
Fee</th>
<th runat="server">
Total</th>
</tr>
<tr ID="itemPlaceholder" runat="server">
</tr>
</table>
</td>
</tr>
<tr runat="server">
<td runat="server"
style="text-align: center;background-color: #CCCCCC;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000000;">
</td>
</tr>
</table>
</LayoutTemplate>
<EditItemTemplate>
<tr style="background-color:#008A8C;color: #FFFFFF;">
<td>
<asp:Button ID="UpdateButton" runat="server" CommandName="Update"
Text="Update" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel"
Text="Cancel" />
</td>
<td>
<asp:TextBox ID="PtAcctTextBox" runat="server" Text='<%# Bind("PtAcct") %>' />
</td>
<td>
<asp:TextBox ID="VisitNumTextBox" runat="server"
Text='<%# Bind("VisitNum") %>' />
</td>
<td>
<asp:TextBox ID="VisitDateTextBox" runat="server"
Text='<%# Bind("VisitDate") %>' />
</td>
<td>
<asp:TextBox ID="CPTTextBox" runat="server" Text='<%# Bind("CPT") %>' />
</td>
<td>
<asp:TextBox ID="DescriptionTextBox" runat="server"
Text='<%# Bind("Description") %>' />
</td>
<td>
<asp:TextBox ID="QtyTextBox" runat="server" Text='<%# Bind("Qty") %>' />
</td>
<td>
<asp:TextBox ID="FeeTextBox" runat="server" Text='<%# Bind("Fee") %>' />
</td>
<td>
<asp:TextBox ID="TotalTextBox" runat="server" Text='<%# Bind("Total") %>' />
</td>
</tr>
</EditItemTemplate>
<SelectedItemTemplate>
<tr style="background-color:#008A8C;font-weight: bold;color: #FFFFFF;">
<td>
<asp:Label ID="PtAcctLabel" runat="server" Text='<%# Eval("PtAcct") %>' />
</td>
<td>
<asp:Label ID="VisitNumLabel" runat="server" Text='<%# Eval("VisitNum") %>' />
</td>
<td>
<asp:Label ID="VisitDateLabel" runat="server" Text='<%# Eval("VisitDate") %>' />
</td>
<td>
<asp:Label ID="CPTLabel" runat="server" Text='<%# Eval("CPT") %>' />
</td>
<td>
<asp:Label ID="DescriptionLabel" runat="server"
Text='<%# Eval("Description") %>' />
</td>
<td>
<asp:Label ID="QtyLabel" runat="server" Text='<%# Eval("Qty") %>' />
</td>
<td>
<asp:Label ID="FeeLabel" runat="server" Text='<%# Eval("Fee") %>' />
</td>
<td>
<asp:Label ID="TotalLabel" runat="server" Text='<%# Eval("Total") %>' />
</td>
</tr>
</SelectedItemTemplate>
</asp:ListView>
<asp:SqlDataSource ID="NutritionCenter2" runat="server"
ConnectionString="<%$ ConnectionStrings:NutritionCenterConnectionString2 %>"
SelectCommand="SELECT PtHistory.PtAcct, PtHistory.VisitNum, PtHistory.VisitDate, PtHistory.CPT, PtHistory.Description, PtHistory.Qty, ItemFeeSchedule.Fee, PtHistory.Qty * ItemFeeSchedule.Fee AS Total FROM PtHistory INNER JOIN ItemFeeSchedule ON PtHistory.CPT = ItemFeeSchedule.CPT WHERE (PtHistory.PtAcct = @PtAcct)">
<SelectParameters>
<asp:ControlParameter ControlID="ListView1" Name="PtAcct"
PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>