<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Start.aspx.vb" Inherits="Start" %>

<!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></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Panel ID="Panel2" runat="server">
            <asp:Label ID="Label5" runat="server" Text="初期設定に必要なプログラムが見つかりません"></asp:Label>
        </asp:Panel>
        <asp:Panel ID="PanelMsg" runat="server" Visible="False">
            <asp:Label ID="LabelMsg2" runat="server" Text="" ForeColor="Red"></asp:Label>
        </asp:Panel>
        <asp:Panel ID="Panel1" runat="server">
                <asp:Label ID="Label1" runat="server" Text="初期設定のプログラム"></asp:Label>
            <asp:Button ID="Button2" runat="server" Text="①クッキーの消去" />
                <br />
        <asp:Label ID="LabelMsg" runat="server" Text="" ForeColor="Red"></asp:Label>
        <br />
        <table style="width: 100%;">
            <tr>
                <td colspan="2">
                    <asp:Label ID="Label6" runat="server" Text="②必要情報の入力"></asp:Label>
                </td>
            </tr>
            <tr>
                <td style="width:120px;">
                    <asp:Label ID="Label2" runat="server" Text="名前"></asp:Label>
                    &nbsp;
                </td>
                <td>
                    <asp:TextBox ID="TextBoxName" runat="server"></asp:TextBox>
                    &nbsp;
                </td>
                <td>
                    &nbsp;
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label3" runat="server" Text="メール"></asp:Label>
                    &nbsp;
                </td>
                <td>
                    <asp:TextBox ID="TextBoxMail" runat="server"></asp:TextBox>
                    &nbsp;
                </td>
                <td>
                    &nbsp;
                </td>
            </tr>            
            <tr>
                <td>
                    <asp:Label ID="Label4" runat="server" Text="設定の実行"></asp:Label>
                    &nbsp;
                </td>
                <td>
                    <asp:Button ID="Button1" runat="server" Text="③実行" />
                    &nbsp;
                </td>
                <td>
                    &nbsp;
                </td>
            </tr>
        </table>
        </asp:Panel>
        <asp:SqlDataSource ID="SqlDataSourceMember" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            DeleteCommand="DELETE FROM [Member] WHERE [id] = @id" 
            InsertCommand="INSERT INTO [Member] ([date], [name], [mail], [IP], [status], [cookie]) VALUES (@date, @name, @mail, @IP, @status, @cookie)" 
            SelectCommand="SELECT * FROM [Member] ORDER BY [id] DESC" 
            
            UpdateCommand="UPDATE [Member] SET [date] = @date, [name] = @name, [mail] = @mail, [IP] = @IP, [status] = @status, [cookie] = @cookie WHERE [id] = @id">
            <DeleteParameters>
                <asp:SessionParameter Name="id" SessionField="id" Type="Int32" />
            </DeleteParameters>
            <InsertParameters>
                <asp:SessionParameter Name="date" SessionField="date" Type="DateTime" />
                <asp:SessionParameter Name="name" SessionField="name" Type="String" />
                <asp:SessionParameter Name="mail" SessionField="mail" Type="String" />
                <asp:SessionParameter Name="IP" SessionField="IP" Type="String" />
                <asp:SessionParameter Name="status" SessionField="status" Type="String" />
                <asp:SessionParameter Name="cookie" SessionField="cookie" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:SessionParameter Name="date" SessionField="date" Type="DateTime" />
                <asp:SessionParameter Name="name" SessionField="name" Type="String" />
                <asp:SessionParameter Name="mail" SessionField="mail" Type="String" />
                <asp:SessionParameter Name="IP" SessionField="IP" Type="String" />
                <asp:SessionParameter Name="status" SessionField="status" Type="String" />
                <asp:SessionParameter Name="cookie" SessionField="cookie" Type="String" />
                <asp:SessionParameter Name="id" SessionField="id" Type="Int32" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSourceAdmin" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            DeleteCommand="DELETE FROM [Admin] WHERE [id] = @id" 
            InsertCommand="INSERT INTO [Admin] ([date], [name], [mail], [IP], [status], [cookie]) VALUES (@date, @name, @mail, @IP, @status, @cookie)" 
            SelectCommand="SELECT * FROM [Admin]" 
            UpdateCommand="UPDATE [Admin] SET [date] = @date, [name] = @name, [mail] = @mail, [IP] = @IP, [status] = @status, [cookie] = @cookie WHERE [id] = @id">
            <DeleteParameters>
                <asp:Parameter Name="id" Type="Int32" />
            </DeleteParameters>
            <InsertParameters>
                <asp:SessionParameter Name="date" SessionField="date" Type="DateTime" />
                <asp:SessionParameter Name="name" SessionField="name" Type="String" />
                <asp:SessionParameter Name="mail" SessionField="mail" Type="String" />
                <asp:SessionParameter Name="IP" SessionField="IP" Type="String" />
                <asp:SessionParameter Name="status" SessionField="status" Type="String" />
                <asp:SessionParameter Name="cookie" SessionField="cookie" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="date" Type="DateTime" />
                <asp:Parameter Name="name" Type="String" />
                <asp:Parameter Name="mail" Type="String" />
                <asp:Parameter Name="IP" Type="String" />
                <asp:Parameter Name="status" Type="String" />
                <asp:Parameter Name="cookie" Type="String" />
                <asp:Parameter Name="id" Type="Int32" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSourceSystem" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            DeleteCommand="DELETE FROM [System] WHERE [id] = @id" 
            InsertCommand="INSERT INTO [System] ([date], [name], [mail], [IP], [status], [cookie]) VALUES (@date, @name, @mail, @IP, @status, @cookie)" 
            SelectCommand="SELECT * FROM [System]" 
            UpdateCommand="UPDATE [System] SET [date] = @date, [name] = @name, [mail] = @mail, [IP] = @IP, [status] = @status, [cookie] = @cookie WHERE [id] = @id">
            <DeleteParameters>
                <asp:Parameter Name="id" Type="Int32" />
            </DeleteParameters>
            <InsertParameters>
                <asp:SessionParameter Name="date" SessionField="date" Type="DateTime" />
                <asp:SessionParameter Name="name" SessionField="name" Type="String" />
                <asp:SessionParameter Name="mail" SessionField="mail" Type="String" />
                <asp:SessionParameter Name="IP" SessionField="IP" Type="String" />
                <asp:SessionParameter Name="status" SessionField="status" Type="String" />
                <asp:SessionParameter Name="cookie" SessionField="cookie" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="date" Type="DateTime" />
                <asp:Parameter Name="name" Type="String" />
                <asp:Parameter Name="mail" Type="String" />
                <asp:Parameter Name="IP" Type="String" />
                <asp:Parameter Name="status" Type="String" />
                <asp:Parameter Name="cookie" Type="String" />
                <asp:Parameter Name="id" Type="Int32" />
            </UpdateParameters>
        </asp:SqlDataSource>
    </div>
    </form>
</body>
</html>
