<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="DisplaySong.aspx.vb" Inherits="Metallica.Webforms_DisplaySong" %>

<!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>Display Song</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Panel
            ID="Panel1" runat="server" Height="8px" Width="537px">
            <a href="Index.aspx"><span style="font-size: 10pt; font-family: Arial">Home</span></a>&nbsp;
            &nbsp; <a href="AllSongs.aspx"><span style="font-size: 10pt; font-family: Arial">View All Songs</span></a>&nbsp;
            &nbsp; <a href="SongStats.aspx"><span style="font-size: 10pt; font-family: Arial">View Song
                Statistics</span></a>&nbsp;&nbsp; &nbsp;<a href="AllShows.aspx"><span style="font-size: 10pt; font-family: Arial">View All Shows</span></a>&nbsp;&nbsp;
            &nbsp;<a href="UserFiles/AddShow.aspx"><span style="font-size: 10pt; font-family: Arial">Add
                a Show</span></a>&nbsp;&nbsp; &nbsp;<asp:LinkButton ID="lbSignOut" runat="server" Font-Names="Arial" Font-Size="Small"
            Visible="False">Log Out</asp:LinkButton></asp:Panel>
        <br />
         <br /><asp:Label ID="lblTitle" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="Large"></asp:Label><br />
        <br />
        <asp:Label ID="lblTimesPlayed" runat="server" Font-Names="arial" Font-Size="Small"></asp:Label><br />
        <br />
        <asp:GridView ID="gvData" runat="server" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSource1" Font-Names="Arial" Font-Size="Small" GridLines="Vertical" AutoGenerateColumns="False">
            <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
            <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
            <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
            <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="Gainsboro" />
            <Columns>
                <asp:BoundField DataField="Year" HeaderText="Year" SortExpression="Year">
                    <ItemStyle HorizontalAlign="Center" />
                </asp:BoundField>
                <asp:BoundField DataField="Month" HeaderText="Month" SortExpression="Month">
                    <ItemStyle HorizontalAlign="Center" />
                </asp:BoundField>
                <asp:BoundField DataField="Day" HeaderText="Day" SortExpression="Day">
                    <ItemStyle HorizontalAlign="Center" />
                </asp:BoundField>
                <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
                <asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />
                <asp:BoundField DataField="Country" HeaderText="Country" SortExpression="Country" />
                <asp:BoundField DataField="Venue" HeaderText="Venue" SortExpression="Venue" />
                <asp:HyperLinkField DataNavigateUrlFields="ShowNumber" DataNavigateUrlFormatString="~/Webforms/DisplayShow.aspx?ShowNumber={0}"
                    HeaderText="Setlist" NavigateUrl="~/Webforms/DisplayShow.aspx" Text="view">
                    <ItemStyle HorizontalAlign="Center" />
                </asp:HyperLinkField>
                <asp:BoundField DataField="Notes" HeaderText="Notes" SortExpression="Notes" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Metallica.My.MySettings.csMetallica %>"
            SelectCommand="SELECT Show.ShowNumber, Show.Year, Show.Month, Show.Day, Show.City, Show.State, Show.Country, Show.Venue, Show.Notes FROM Show INNER JOIN Setlist ON Show.ShowNumber = Setlist.ShowNumber WHERE (Setlist.Song01 = @songnum) OR (Setlist.Song02 = @songnum) OR (Setlist.Song03 = @songnum) OR (Setlist.Song04 = @songnum) OR (Setlist.Song05 = @songnum) OR (Setlist.Song06 = @songnum) OR (Setlist.Song07 = @songnum) OR (Setlist.Song08 = @songnum) OR (Setlist.Song09 = @songnum) OR (Setlist.Song10 = @songnum) OR (Setlist.Song11 = @songnum) OR (Setlist.Song12 = @songnum) OR (Setlist.Song13 = @songnum) OR (Setlist.Song14 = @songnum) OR (Setlist.Song15 = @songnum) OR (Setlist.Song16 = @songnum) OR (Setlist.Song17 = @songnum) OR (Setlist.Song18 = @songnum) OR (Setlist.Song19 = @songnum) OR (Setlist.Song20 = @songnum) OR (Setlist.Song21 = @songnum) OR (Setlist.Song22 = @songnum) OR (Setlist.Song23 = @songnum) OR (Setlist.Song24 = @songnum) OR (Setlist.Song25 = @songnum) ORDER BY Show.Year, Show.Month, Show.Day">
            <SelectParameters>
                <asp:ControlParameter ControlID="lblSongNum" DefaultValue="200" Name="songnum" PropertyName="Text" />
            </SelectParameters>
        </asp:SqlDataSource>
        <br />
        <asp:Label ID="lblSongNum" runat="server" Visible="False"></asp:Label></div>
    </form>
</body>
</html>
