protected void Page_Load(object sender, EventArgs e)
{


}



protected void signup_Click(object sender, EventArgs e)
{
    string role = string.Empty;
    if (user.Checked == true)
    {
        role = "U";
    }
    else if (agent.Checked == true)
    {
        role = "T";
    }




    {
         SqlConnection con = new SqlConnection(@"Data Source=HPSQLEXPRESS;Initial Catalog=trotters;Integrated Security=True");
        SqlCommand cmd = new SqlCommand("INSERT INTO [user] ([name],[username],[password],[email],[contactNo],[dob],[role]) VALUES (@fullname,@username,@password,@email,@contactNo,@dob,@role)", con);
        cmd.CommandType = CommandType.Text;
        try
        {

            con.Open();

            cmd.ExecuteNonQuery();
            cmd.Parameters.AddWithValue("name", fullname.Text);
            cmd.Parameters.AddWithValue("username", username.Text);
            cmd.Parameters.AddWithValue("password", password.Text);
            cmd.Parameters.AddWithValue("email", email.Text);
            cmd.Parameters.AddWithValue("contactNo", contactNo.Text);
            cmd.Parameters.AddWithValue("dob", dob.Text);
            cmd.Parameters.AddWithValue("role", role);

            Response.Write("<script>alert('Successfully registered')</script>");

        }
        catch
        {
            Response.Write("<script>alert('ERROR')</script>");
        }

        con.Close();
    }
}

</td>
    </tr>
    <tr>
        <th>
            DATE OF BIRTH:
        </th>
        <td>
            <asp:TextBox ID="dob" runat="server" TextMode="Date"></asp:TextBox></td>

    </tr>
    <tr>
        <th>
            E-MAIL:
        </th>
        <td>
            <asp:TextBox ID="email" runat="server" TextMode="Email"></asp:TextBox>
            <asp:RequiredFieldValidator ID="mail" runat="server" ErrorMessage="Please enter email" ControlToValidate="email" ForeColor="Red"></asp:RequiredFieldValidator>

        </td>
    </tr>
    <tr>
        <th>
            CONTACT NO:
        </th>
        <td>
            <asp:TextBox ID="contactNo" runat="server" TextMode="Phone"></asp:TextBox>

        </td>
    </tr>
    <tr>
        <th>
            USERNAME:
        </th>
        <td>
            <asp:TextBox ID="username" runat="server"></asp:TextBox>
            <asp:RequiredFieldValidator ID="usr" runat="server" ErrorMessage="Please enter username" ControlToValidate="username" ForeColor="Red"></asp:RequiredFieldValidator>
        </td>
    </tr>
    <tr>
        <th>
            PASSWORD:
        </th>
        <td>
            <asp:TextBox ID="password" runat="server" TextMode="Password"></asp:TextBox>
            <asp:RequiredFieldValidator ID="pswd" runat="server" ErrorMessage="Please enter password" ControlToValidate="password" ForeColor="Red"></asp:RequiredFieldValidator>
        </td>
    </tr>
    <tr>
        <th>
            YOU ARE:
        </th>
        <td>

           <asp:RadioButton ID="user" Text="NORMAL USER" runat="server"  GroupName="role" /></td>
        <td>
        <asp:RadioButton ID="agent" Text="TRAVEL AGENT" runat="server" GroupName="role" />

        </td>
    </tr>
</table>
<asp:Button ID="signup" runat="server" Text="SIGN UP" OnClick="signup_Click" />