<%@ Page Title="Products" Language="VB" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="GridViewTotals_Products.aspx.vb" Inherits="Northwind45.GridViewTotals_Products" %>
 
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
    <%: Styles.Render("~/Styles/jquery.tooltip.css"%>
    <%: Scripts.Render("~/Scripts/jquery.tooltip.min.js"%>
    <%: Scripts.Render("~/Scripts/gridview-totals-script.js"%>
    <script type="text/javascript">
        $(function () {
            InitializeToolTip();
        });
    </script>
</asp:Content>
 
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <b>Number of Records: <asp:Label ID="LblNumberOfRecords" runat="server" /></b><br /><br />
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
            <asp:GridView ID="GridView1" runat="server" DataKeyNames="ProductID"
            ItemType="Northwind45.BusinessObject.Products" SelectMethod="GetGridData" DeleteMethod="DeleteGridItem"
            onrowdatabound="GridView1_RowDataBound" onrowcreated="GridView1_RowCreated" SkinID="GridViewProfessional">
                <Columns>
                    <asp:BoundField DataField="ProductID" HeaderText="Product ID" ReadOnly="true" SortExpression="ProductID" ItemStyle-HorizontalAlign="Right" />
                    <asp:BoundField DataField="ProductName" HeaderText="Product Name" ReadOnly="true" SortExpression="ProductName" />
                    <asp:TemplateField HeaderText="Supplier ID" SortExpression="SupplierID" HeaderStyle-Wrap="false">
                        <ItemStyle Width="30px" HorizontalAlign="Center" />
                        <ItemTemplate>
                            <div class="tag">
                                <a href="#" class="gridViewToolTip"><%#: If(Item.SupplierID.HasValue, Item.SupplierID, Nothing%></a>
                                <div id="tooltip" style="displaynone;">
                                    <table style="text-alignleft;">
                                        <tr>
                                            <td style="white-spacenowrap;"><b>Supplier ID:</b>&nbsp;</td>
                                            <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.SupplierID, 0) %></td>
                                        </tr>
                                        <tr>
                                            <td style="white-spacenowrap;"><b>Company Name:</b>&nbsp;</td>
                                            <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.CompanyName, Nothing%></td>
                                        </tr>
                                        <tr>
                                            <td style="white-spacenowrap;"><b>Contact Name:</b>&nbsp;</td>
                                            <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.ContactName, Nothing%></td>
                                        </tr>
                                        <tr>
                                            <td style="white-spacenowrap;"><b>Contact Title:</b>&nbsp;</td>
                                            <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.ContactTitle, Nothing%></td>
                                        </tr>
                                        <tr>
                                            <td style="white-spacenowrap;"><b>Address:</b>&nbsp;</td>
                                            <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.Address, Nothing%></td>
                                        </tr>
                                        <tr>
                                            <td style="white-spacenowrap;"><b>City:</b>&nbsp;</td>
                                            <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.City, Nothing%></td>
                                        </tr>
                                        <tr>
                                            <td style="white-spacenowrap;"><b>Region:</b>&nbsp;</td>
                                            <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.Region, Nothing%></td>
                                        </tr>
                                        <tr>
                                            <td style="white-spacenowrap;"><b>Postal Code:</b>&nbsp;</td>
                                            <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.PostalCode, Nothing%></td>
                                        </tr>
                                        <tr>
                                            <td style="white-spacenowrap;"><b>Country:</b>&nbsp;</td>
                                            <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.Country, Nothing%></td>
                                        </tr>
                                        <tr>
                                            <td style="white-spacenowrap;"><b>Phone:</b>&nbsp;</td>
                                            <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.Phone, Nothing%></td>
                                        </tr>
                                        <tr>
                                            <td style="white-spacenowrap;"><b>Fax:</b>&nbsp;</td>
                                            <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.Fax, Nothing%></td>
                                        </tr>
                                        <tr>
                                            <td style="white-spacenowrap;"><b>Home Page:</b>&nbsp;</td>
                                            <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.HomePage, Nothing%></td>
                                        </tr>
                                    </table>
                                </div>
                            </div>
                        </ItemTemplate>
                    </asp:TemplateField> 
                    <asp:TemplateField HeaderText="Category ID" SortExpression="CategoryID" HeaderStyle-Wrap="false">
                        <ItemStyle Width="30px" HorizontalAlign="Center" />
                        <ItemTemplate>
                            <div class="tag">
                                <a href="#" class="gridViewToolTip"><%#: If(Item.CategoryID.HasValue, Item.CategoryID, Nothing%></a>
                                <div id="tooltip" style="displaynone;">
                                    <table style="text-alignleft;">
                                        <tr>
                                            <td style="white-spacenowrap;"><b>Category ID:</b>&nbsp;</td>
                                            <td><%#: If(Item.CategoryID.HasValue, Item.Categories.Value.CategoryID, 0) %></td>
                                        </tr>
                                        <tr>
                                            <td style="white-spacenowrap;"><b>Category Name:</b>&nbsp;</td>
                                            <td><%#: If(Item.CategoryID.HasValue, Item.Categories.Value.CategoryName, Nothing%></td>
                                        </tr>
                                        <tr>
                                            <td style="white-spacenowrap;"><b>Description:</b>&nbsp;</td>
                                            <td><%#: If(Item.CategoryID.HasValue, Item.Categories.Value.Description, Nothing%></td>
                                        </tr>
                                    </table>
                                </div>
                            </div>
                        </ItemTemplate>
                    </asp:TemplateField> 
                    <asp:BoundField DataField="QuantityPerUnit" HeaderText="Quantity Per Unit" ReadOnly="true" SortExpression="QuantityPerUnit" />
                    <asp:BoundField DataField="UnitPrice" HeaderText="Unit Price" ReadOnly="true" SortExpression="UnitPrice" DataFormatString="{0:c}" HtmlEncode="false" ItemStyle-HorizontalAlign="Right" />
                    <asp:BoundField DataField="UnitsInStock" HeaderText="Units In Stock" ReadOnly="true" SortExpression="UnitsInStock" DataFormatString="{0:N0}" HtmlEncode="false" ItemStyle-HorizontalAlign="Right" />
                    <asp:BoundField DataField="UnitsOnOrder" HeaderText="Units On Order" ReadOnly="true" SortExpression="UnitsOnOrder" DataFormatString="{0:N0}" HtmlEncode="false" ItemStyle-HorizontalAlign="Right" />
                    <asp:BoundField DataField="ReorderLevel" HeaderText="Reorder Level" ReadOnly="true" SortExpression="ReorderLevel" DataFormatString="{0:N0}" HtmlEncode="false" ItemStyle-HorizontalAlign="Right" />
                    <asp:CheckBoxField DataField="Discontinued" HeaderText="Discontinued" ReadOnly="true" SortExpression="Discontinued" ItemStyle-HorizontalAlign="Center" />
                </Columns>
                <EmptyDataTemplate>No records found!</EmptyDataTemplate>
            </asp:GridView>
        </ContentTemplate>
    </asp:UpdatePanel>
 
    <asp:UpdateProgress ID="UpdateProgress1" AssociatedUpdatePanelID="UpdatePanel1" runat="server" DisplayAfter="0">
        <ProgressTemplate>
        <br />
        <img src="Images/ActivityIndicator.gif" alt="" /> Processing your request.  Please wait....
        </ProgressTemplate>
    </asp:UpdateProgress>
 
</asp:Content>