<%@ Page Title="Add a New Player" Language="C#" MasterPageFile="~/MasterPages/Management.master" %>

<script runat="server">

   string value;
   Int32 theCustomer;

   protected void Page_Load(object sender, EventArgs e)
   {
     
    if (Request.QueryString.Get("Player_Name") != null)
      {
         DetailsView1.DefaultMode = DetailsViewMode.Edit;
      }

   }//end method Page_Load

   protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
   {
      
      
       if (!IsPostBack)
      {
         GolfDatabaseDataContext db = new GolfDatabaseDataContext();

         var query = from Customer in db.Customers
                     where Customer.UserName == Profile.UserName
                     select Customer.Customer_ID;
         
         //Now we have found the Customer_ID value based upon the Profile.UserName
         //Convert that value to string
         //Create a TextBox (CustomerID) based upon TextBox1 (Customer_ID) to show the Customer_ID value in the DetailsView
         // and limit the results (GridView) to the logged in Customer_ID value
          
         foreach (var result in query)
         {
            value = result.ToString();
            theCustomer = Convert.ToInt32(value);
            TextBox CustomerID = ((TextBox)DetailsView1.FindControl("TextBox1"));
            CustomerID.Text = value;
         }//end foreach

      }//if !IsPostBack

       e.Command.Parameters["@Customer_ID"].Value = theCustomer;

   }//end method SqlDataSource1_Selecting
   
    protected void DetailsView1_ItemInserted(object sender, DetailsViewInsertedEventArgs e)
   {
      // Refresh the GridView control after a new record is inserted 
      // in the DetailsView control.

      GridView1.DataBind();
      
   }//end method
   
</script>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="cpMainContent" Runat="Server">
   <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
   AllowSorting="True" AutoGenerateColumns="False" AutoPostBack="true" DataKeyNames="Player_ID" 
   DataSourceID="SqlDataSource1" 
   EmptyDataText="There are no data records to display.">
   <Columns>
      <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" 
         ShowSelectButton="True" />
      <asp:BoundField DataField="Customer_ID" HeaderText="Customer_ID" 
         SortExpression="Customer_ID" />
      <asp:BoundField DataField="Player_ID" HeaderText="Player_ID" ReadOnly="True" 
         SortExpression="Player_ID" />
      <asp:BoundField DataField="Player_Name" HeaderText="Player_Name" 
         SortExpression="Player_Name" />
      <asp:BoundField DataField="Handicap" HeaderText="Handicap" 
         SortExpression="Handicap" />
   </Columns>
</asp:GridView>
   <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" 
      DataKeyNames="Player_ID" DataSourceID="SqlDataSource1" DefaultMode="Insert" 
      Height="50px" Width="125px" OnItemInserted="DetailsView1_ItemInserted">
      <Fields>
         <asp:TemplateField HeaderText="Customer_ID" SortExpression="Customer_ID">
            <EditItemTemplate>
               <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Customer_ID") %>'></asp:TextBox>
            </EditItemTemplate>
            <InsertItemTemplate>
               <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Customer_ID") %>'></asp:TextBox>
            </InsertItemTemplate>
            <ItemTemplate>
               <asp:Label ID="Label1" runat="server" Text='<%# Bind("Customer_ID") %>'></asp:Label>
            </ItemTemplate>
         </asp:TemplateField>
         <asp:BoundField DataField="Player_ID" HeaderText="Player_ID" 
            InsertVisible="False" ReadOnly="True" SortExpression="Player_ID" />
         <asp:BoundField DataField="Player_Name" HeaderText="Player_Name" 
            SortExpression="Player_Name" />
         <asp:BoundField DataField="Handicap" Visible="false" HeaderText="Handicap" 
            SortExpression="Handicap" />
         <asp:CommandField ShowInsertButton="True" />
      </Fields>
   </asp:DetailsView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
   ConnectionString="<%$ ConnectionStrings:GolfDatabaseConnectionString1 %>" 
   DeleteCommand="DELETE FROM [Player] WHERE [Player_ID] = @Player_ID" 
   InsertCommand="INSERT INTO [Player] ([Customer_ID], [Player_Name], [Handicap]) VALUES (@Customer_ID, @Player_Name, @Handicap)" 
   ProviderName="<%$ ConnectionStrings:GolfDatabaseConnectionString1.ProviderName %>" 
   UpdateCommand="UPDATE [Player] SET [Customer_ID] = @Customer_ID, [Player_Name] = @Player_Name, [Handicap] = @Handicap WHERE [Player_ID] = @Player_ID"
   SelectCommand="SELECT [Customer_ID], [Player_ID], [Player_Name], [Handicap] FROM [Player] WHERE ([Customer_ID] = @Customer_ID)" onselecting="SqlDataSource1_Selecting"> 
   <SelectParameters>
      <asp:Parameter Name="Customer_ID" Type="Int32" />
   </SelectParameters>
   <DeleteParameters>
      <asp:Parameter Name="Player_ID" Type="Int32" />
   </DeleteParameters>
   <InsertParameters>
      <asp:Parameter Name="Customer_ID" Type="Int32" />
      <asp:Parameter Name="Player_Name" Type="String" />
      <asp:Parameter Name="Handicap" Type="Single" />
   </InsertParameters>
   <UpdateParameters>
      <asp:Parameter Name="Customer_ID" Type="Int32" />
      <asp:Parameter Name="Player_Name" Type="String" />
      <asp:Parameter Name="Handicap" Type="Single" />
      <asp:Parameter Name="Player_ID" Type="Int32" />
   </UpdateParameters>
</asp:SqlDataSource>
</asp:Content>