Link to home
Start Free TrialLog in
Avatar of westdh
westdhFlag for United States of America

asked on

asp.net C# inline code: why is my events not firing??

asp.net C#  inline code: why is my events not firing??
<%@ Page language="c#" Debug="True" AutoEventWireup="false" smartNavigation="True" %>

<%@ Import Namespace="System" %>
<%@ Import Namespace="System.Collections" %>
<%@ Import Namespace="System.Configuration" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Web" %>
<%@ Import Namespace="System.Web.UI" %>
<%@ Import Namespace="System.Web.UI.WebControls" %>
<%@ Import Namespace="System.Web.UI.HtmlControls" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Web.Security" %>

<script runat="server">
    
    public class Register : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.TextBox FirstName;
        protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator5;
        protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator6;
        protected System.Web.UI.WebControls.TextBox Company;
        protected System.Web.UI.WebControls.TextBox Address1;
        protected System.Web.UI.WebControls.TextBox Address2;
        protected System.Web.UI.WebControls.TextBox City;
        protected System.Web.UI.WebControls.TextBox State;
        protected System.Web.UI.WebControls.TextBox Zip;
        protected System.Web.UI.WebControls.RadioButtonList Certificate_Type;
        protected System.Web.UI.WebControls.TextBox Name_of_Balloon;
        protected System.Web.UI.WebControls.TextBox Balloon_Type;
        protected System.Web.UI.WebControls.TextBox Year;
        protected System.Web.UI.WebControls.TextBox Balloon_Hours;
        protected System.Web.UI.WebControls.RadioButtonList Balloon_Entry_Type;
        protected System.Web.UI.WebControls.RadioButtonList Special_Shape;
        protected System.Web.UI.WebControls.RadioButtonList Addt_Crew;
        protected System.Web.UI.WebControls.TextBox How_Many_Crew;
        protected System.Web.UI.WebControls.RadioButtonList Polo_Shirt;

        protected System.Web.UI.WebControls.RadioButtonList Crew_T_shirts1;
        protected System.Web.UI.WebControls.RadioButtonList Crew_T_shirts2;
        protected System.Web.UI.WebControls.RadioButtonList Crew_T_shirts3;
        protected System.Web.UI.WebControls.RadioButtonList Crew_T_shirts4;

        protected System.Web.UI.WebControls.RadioButtonList Sweat_Shirt;
        protected System.Web.UI.WebControls.RadioButtonList Arrival;
        protected System.Web.UI.WebControls.RadioButtonList Preference;
        protected System.Web.UI.WebControls.RadioButtonList Invitation_List;
        protected System.Web.UI.WebControls.TextBox Comments;
        protected System.Web.UI.WebControls.LinkButton CancelBtn;
        protected System.Web.UI.WebControls.LinkButton RegisterBtn;
        protected System.Web.UI.WebControls.TextBox LastName;
        protected System.Web.UI.WebControls.TextBox Email;
        protected System.Web.UI.WebControls.Label Message;
        protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
        protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
        protected System.Web.UI.WebControls.TextBox HomePhone;
        protected System.Web.UI.WebControls.TextBox WorkPhone;
        protected System.Web.UI.WebControls.TextBox CellPhone;
        protected System.Web.UI.WebControls.TextBox FaxNumber;
        protected System.Web.UI.WebControls.TextBox TotalHours;
        protected System.Web.UI.WebControls.TextBox Hours12Mos;
        protected System.Web.UI.WebControls.TextBox Manufacturer;
        protected System.Web.UI.WebControls.CheckBox Fri_Am;
        protected System.Web.UI.WebControls.CheckBox Sat_Am;
        protected System.Web.UI.WebControls.CheckBox Sun_Am;
        protected System.Web.UI.WebControls.CheckBox Fri_Pm;
        protected System.Web.UI.WebControls.CheckBox Sat_Pm;
        protected System.Web.UI.WebControls.CheckBox Sun_Pm;
        protected System.Web.UI.WebControls.RadioButtonList Media_Flt;
        protected System.Web.UI.WebControls.TextBox How_Many_Media;
        protected System.Web.UI.WebControls.RadioButtonList Fun_Flt;

        string FriMor = "";
        string FriEve = "";
        string SatMor = "";
        string SatEve = "";
        string SunMor = "";
        string SunEve = "";
        string Insurance;
        protected System.Web.UI.WebControls.TextBox Registration;
        protected System.Web.UI.WebControls.TextBox Insurance_other;
        protected System.Web.UI.WebControls.RadioButtonList InsuranceList;
        
        public String VerifyPilotRegistered(String FirstName, String LastName)
        {
            // Create Instance of Connection and Command Object
            SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
            SqlCommand myCommand = new SqlCommand("VerifyPilotRegistered", myConnection);

            // Mark the Command as a SPROC
            myCommand.CommandType = CommandType.StoredProcedure;

            // Add Parameters to SPROC
            SqlParameter parameterFirstName = new SqlParameter("@FirstName", SqlDbType.NVarChar, 30);
            parameterFirstName.Value = FirstName;
            myCommand.Parameters.Add(parameterFirstName);

            SqlParameter parameterLastName = new SqlParameter("@LastName", SqlDbType.NVarChar, 30);
            parameterLastName.Value = LastName;
            myCommand.Parameters.Add(parameterLastName);

            SqlParameter parameterPilotName = new SqlParameter("@PilotName", SqlDbType.NVarChar, 62);
            parameterPilotName.Direction = ParameterDirection.Output;
            myCommand.Parameters.Add(parameterPilotName);

            // Open the database connection and execute the command
            myConnection.Open();
            myCommand.ExecuteNonQuery();
            myConnection.Close();

            if ((parameterPilotName.Value != null) && (parameterPilotName.Value != System.DBNull.Value))
            {
                return ((String)parameterPilotName.Value).Trim();
            }
            else
            {
                return String.Empty;
            }
        }

        private void RegisterBtn_Click(object sender, System.EventArgs e)
        {
            //Trace.Write("test1: " + How_Many_Crew.Text);
            // Only attempt a login if all form fields on the page are valid
            if (Page.IsValid == true)
            {
                // Attempt to Validate User Credentials using PilotsDB
                string PilotId = VerifyPilotRegistered(FirstName.Text, LastName.Text);

             
      
                if ((PilotId == null) || (PilotId == ""))
                {
                    // Add New User to Portal User Database
                    ///ASPNetPortal.PilotsDB accountSystem = new ASPNetPortal.PilotsDB();
                    ///AddPilot("Y", FirstName.Text, LastName.Text, Company.Text, Address1.Text, Address2.Text, City.Text, State.Text, Zip.Text, HomePhone.Text, WorkPhone.Text, CellPhone.Text, FaxNumber.Text, Email.Text, Certificate_Type.SelectedValue, TotalHours.Text, Hours12Mos.Text, Name_of_Balloon.Text, Registration.Text, Manufacturer.Text, Balloon_Type.Text, Year.Text, Balloon_Hours.Text, Balloon_Entry_Type.SelectedValue, Special_Shape.SelectedValue, Addt_Crew.SelectedValue, How_Many_Crew.Text, FriMor, FriEve, SatMor, SatEve, SunMor, SunEve, Media_Flt.SelectedValue, How_Many_Media.Text, Fun_Flt.SelectedValue, Polo_Shirt.SelectedValue, Crew_T_shirts1.SelectedValue, Crew_T_shirts2.SelectedValue, Crew_T_shirts3.SelectedValue, Crew_T_shirts4.SelectedValue, Sweat_Shirt.SelectedValue, Arrival.SelectedValue, Preference.SelectedValue, "", Invitation_List.SelectedValue, Comments.Text, Insurance);

                    // Set the user's authentication name to the userId
                    ///FormsAuthentication.SetAuthCookie(Email.Text, false);

                    // Redirect browser back to home page
                    ///Response.Redirect("http://planoballoonfest.org/pbfpr/RegClose.aspx");
                }
                else
                {
                    Message.Text = "You are already registered.  Please Login Instead.....yyyy this is a test";
                }
            }
        }

        private void CancelBtn_Click(Object sender, EventArgs e)
        {
            // Redirect back to the portal home page
            Response.Redirect("http://planoballoonfest.org/pbfpr/Default.aspx");
        }
    }
 </script>

<html>
	
	<%--
   The Register.aspx page is used to enable clients to register a new unique username
   and password with the portal system.  The page contains a single server event
   handler -- RegisterBtn_Click -- that executes in response to the page's Register
   Button being clicked.

   The Register.aspx page uses the UsersDB class to manage the actual account creation.
   Note that the Usernames and passwords are stored within a table in a SQL database.
     --%>
    <head>
		<link href='<%= Request.ApplicationPath + "/Portal.css" %>' type=text/css rel=stylesheet>
	</head>
	
<body text="#000000" vLink="#666666" aLink="#ffffff" link="#00ffff" bgColor="#ffffff">
		<table cellSpacing="0" cellPadding="0" width="100%">
		
			<tr bgColor="#99cc00" width="98%">
				<td>&nbsp;&nbsp;</td>
			</tr>
		</table>
		<form id="Form1" style="LEFT: 40px; POSITION: relative" runat="server">
			<h3><font face="Arial" color="#ff0000"><u>Section 1 - Attendance Information</u></font></h3>
			<P><FONT face="Arial">First Name:</FONT>&nbsp;&nbsp;
				<asp:textbox id="FirstName" runat="server" maxlength="50"></asp:textbox>&nbsp; <FONT face="Arial">
					Last<STRONG> </STRONG>Name:</FONT> &nbsp;
				<asp:textbox id="LastName" runat="server" maxlength="50" Columns="30"></asp:textbox><asp:requiredfieldvalidator id="Requiredfieldvalidator5" runat="server" Display="Static" ControlToValidate="FirstName"
					ErrorMessage="You must enter your First Name"></asp:requiredfieldvalidator><asp:requiredfieldvalidator id="Requiredfieldvalidator6" runat="server" Display="Static" ControlToValidate="LastName"
					ErrorMessage="You must enter your Last Name"></asp:requiredfieldvalidator><br>
			</P>
			<h3><font face="Arial" color="#ff0000"><u>Section 2 - Pilot Information</u></font></h3>
			<P><FONT face="Arial">Company Name</FONT> (If applicable):&nbsp;&nbsp;
				<asp:textbox id="Company" runat="server" maxlength="50" Columns="30"></asp:textbox></P>
			<p></p>
			<p><FONT face="Arial">Address1:</FONT>&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Address1" runat="server" maxlength="52" Columns="52"></asp:textbox></p>
			<p></p>
			<p></p>
			<p><FONT face="Arial">Address2:</FONT>&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Address2" runat="server" maxlength="52" Columns="52"></asp:textbox></p>
			<p><STRONG>&nbsp;</STRONG><FONT face="Arial">City:</FONT>&nbsp;&nbsp;&nbsp;
				<asp:textbox id="City" runat="server" maxlength="30" Columns="27"></asp:textbox><FONT face="Arial">State<STRONG>:</STRONG></FONT>&nbsp;&nbsp;
				<asp:textbox id="State" runat="server" maxlength="12" Columns="12"></asp:textbox><FONT face="Arial"><STRONG>&nbsp;
					</STRONG>Zip:</FONT>&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Zip" runat="server" maxlength="11" Columns="11"></asp:textbox></p>
			<FONT face="Arial"><STRONG></STRONG></FONT>
			<p><FONT face="Arial">Home Phone:</FONT>&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="HomePhone" runat="server" maxlength="30" Columns="27"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Work Phone:</FONT>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
				<asp:textbox id="WorkPhone" runat="server" maxlength="12" Columns="12" Width="184px"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Cell Phone :</FONT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="CellPhone" runat="server" maxlength="30" Columns="27" Width="184px"></asp:textbox></p>
			<p></p>
			<p></p>
			<p><FONT face="Arial">Fax:</FONT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
				&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="FaxNumber" runat="server" maxlength="12" Columns="12" Width="176px"></asp:textbox>&nbsp;</p>
			<FONT face="Arial">E-mail Address:</FONT> &nbsp;&nbsp;&nbsp;
			<asp:textbox id="Email" runat="server" maxlength="80" Columns="54" Width="312px"></asp:textbox>&nbsp;
			<asp:regularexpressionvalidator id="RegularExpressionValidator1" runat="server" Display="Dynamic" ControlToValidate="Email"
				ErrorMessage="Must use a valid email address." ValidationExpression="[\w\.-]+(\+[\w-]*)?@([\w-]+\.)+[\w-]+"></asp:regularexpressionvalidator><asp:requiredfieldvalidator id="RequiredFieldValidator2" runat="server" ControlToValidate="Email" ErrorMessage="'Email' must not be left blank."></asp:requiredfieldvalidator>
			<p><FONT face="Arial">Certificate Type</FONT><ASP:RADIOBUTTONLIST id="Certificate_Type" runat="server" Width="232px" RepeatDirection="Horizontal"
					Font-Name="Arial" RepeatLayout="Table" Font-Names="Arial" Font-Bold="True">
					<asp:ListItem Value="Private">Private</asp:ListItem>
					<asp:ListItem Value="Commercial">Commercial</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p></p>
			<p><FONT face="Arial">Total Hours as LTA PIC :</FONT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="TotalHours" runat="server" maxlength="6" Columns="6"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Total Hours as LTA PIC in Last 12 Months :</FONT>&nbsp;&nbsp;
				<asp:textbox id="Hours12Mos" runat="server" maxlength="6" Columns="6"></asp:textbox></p>
			<p></p>
			<H3><FONT face="Arial" color="#ff0000">Section 3 - Balloon Information</FONT></H3>
			<p><FONT face="Arial">Name of Balloon:</FONT>&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Name_of_Balloon" runat="server" maxlength="30" Columns="25"></asp:textbox></p>
			<p><FONT face="Arial">Registration Number:</FONT> &nbsp;<asp:textbox id="Registration" runat="server" maxlength="8" Columns="8"></asp:textbox></p>
			<p><FONT face="Arial">Manufacturer:<STRONG>&nbsp;</STRONG></FONT>&nbsp;<asp:textbox id="Manufacturer" runat="server" maxlength="30" Columns="18"></asp:textbox>
			</p>
			<p><FONT face="Arial">Balloon Type:</FONT> &nbsp;&nbsp;<asp:textbox id="Balloon_Type" runat="server" maxlength="6" Columns="6"></asp:textbox></p>
			<p><FONT face="Arial">Year:</FONT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Year" runat="server" maxlength="30" Columns="18"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Hours:</FONT>&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Balloon_Hours" runat="server" maxlength="8" Columns="8"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Balloon Entry Type:</FONT>&nbsp;
				<ASP:RADIOBUTTONLIST id="Balloon_Entry_Type" runat="server" Width="204px" RepeatDirection="Horizontal"
					Font-Name="Arial" RepeatLayout="Table" Font-Names="Arial" Font-Bold="True">
					<asp:ListItem Value="C">Commercial</asp:ListItem>
					<asp:ListItem Value="S">Sport</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p><FONT face="Arial">Special Shape:</FONT>
			&nbsp;&nbsp;
			<p><ASP:RADIOBUTTONLIST id="Special_Shape" runat="server" Width="128px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True">
					<asp:ListItem Value="Yes">Yes</asp:ListItem>
					<asp:ListItem Value="No">No</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p>
				<h3><font face="Arial" color="#ff0000"><U>Section 4 - Crew Requirements</U></font></h3>
			<p><FONT face="Arial">Will you need the Festival to provide you with crew?</FONT>&nbsp;&nbsp;</p>
			<p><ASP:RADIOBUTTONLIST id="Addt_Crew" runat="server" Width="128px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True">
					<asp:ListItem Value="Y">Yes</asp:ListItem>
					<asp:ListItem Value="N">No</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p><FONT face="Arial">How Many?:</FONT> &nbsp;&nbsp;<asp:textbox id="How_Many_Crew" runat="server" maxlength="2" Columns="2"></asp:textbox>
			</p>
			<FONT face="Arial"><STRONG>&nbsp;&nbsp;</STRONG> Check which flights you will need 
				extra crew:</FONT>
			<p><asp:checkbox id="Fri_Am" runat="server" Font-Bold="True" Text="Friday Morning" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox><STRONG>&nbsp;&nbsp; &nbsp; </STRONG>
				<asp:checkbox id="Sat_Am" runat="server" Font-Bold="True" Text="Saturday Morning" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox><STRONG>&nbsp;&nbsp; </STRONG>
				<asp:checkbox id="Sun_Am" runat="server" Font-Bold="True" Text="Sunday Morning" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox></p>
			<p><asp:checkbox id="Fri_Pm" runat="server" Font-Bold="True" Text="Friday Evening" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox>&nbsp;&nbsp;&nbsp;&nbsp;<asp:checkbox id="Sat_Pm" runat="server" Font-Bold="True" Text="Saturday Evening" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox>&nbsp;&nbsp; &nbsp;<asp:checkbox id="Sun_Pm" runat="server" Font-Bold="True" Text="Sunday Evening" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox></p>
			<h3><font face="Arial" color="#ff0000"><U>Section 5 - Special Flights</U></font></h3>
			<p><FONT face="Arial">Will you fly in the media flight Friday morning 9/17/2010?</FONT>&nbsp;</p>
			<p><ASP:RADIOBUTTONLIST id="Media_Flt" runat="server" Width="136px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True">
					<asp:ListItem Value="Y">Yes</asp:ListItem>
					<asp:ListItem Value="N">No</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p><FONT face="Arial">How many media/sponsor passengers can you fly?:</FONT>&nbsp; 
				&nbsp;<asp:textbox id="How_Many_Media" runat="server" maxlength="2" Columns="2"></asp:textbox>
			</p>
			<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><font color="#000000" size="4"><sup><STRONG>(Passengers 
							will be assigned by the Festival for the media flight)</STRONG></sup></font></p>
			<p><FONT face="Arial"> Will you fly Sunday afternoon 9/19/2010?</FONT></p>
			<p><ASP:RADIOBUTTONLIST id="Fun_Flt" runat="server" Width="120px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True">
					<asp:ListItem Value="Y">Yes</asp:ListItem>
					<asp:ListItem Value="N">No</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<H3><font color="#ff0000" Size:face="Arial"><U><FONT face="Arial">Section 6 - Details</FONT></U></H3>
			<p><FONT face="Arial" color="#000000">Polo Shirt Size:</FONT>
				<ASP:RADIOBUTTONLIST id="Polo_Shirt" runat="server" Width="440px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
					<asp:ListItem Value="S">Small</asp:ListItem>
					<asp:ListItem Value="M">Medium</asp:ListItem>
					<asp:ListItem Value="L">Large</asp:ListItem>
					<asp:ListItem Value="XL">XL</asp:ListItem>
					<asp:ListItem Value="XXL">XXL</asp:ListItem>
					<asp:ListItem Value="XXXL">XXXL</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p></p>
                <H3><font color="#ff0000" Size:face="Arial"><U><FONT face="Arial">Crew t_shirts(up to 4)</FONT></U></H3>
                 <p><FONT face="Arial" color="#000000">Crew T Shirt 1:</FONT>
				<ASP:RADIOBUTTONLIST id="Crew_T_shirts1" runat="server" Width="440px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
					<asp:ListItem Value="S">Small</asp:ListItem>
					<asp:ListItem Value="M">Medium</asp:ListItem>
					<asp:ListItem Value="L">Large</asp:ListItem>
					<asp:ListItem Value="XL">XL</asp:ListItem>
					<asp:ListItem Value="XXL">XXL</asp:ListItem>
					<asp:ListItem Value="XXXL">XXXL</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p></p>
                        <p><FONT face="Arial" color="#000000">Crew T Shirt 2:</FONT>
				<ASP:RADIOBUTTONLIST id="Crew_T_shirts2" runat="server" Width="440px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
					<asp:ListItem Value="S">Small</asp:ListItem>
					<asp:ListItem Value="M">Medium</asp:ListItem>
					<asp:ListItem Value="L">Large</asp:ListItem>
					<asp:ListItem Value="XL">XL</asp:ListItem>
					<asp:ListItem Value="XXL">XXL</asp:ListItem>
					<asp:ListItem Value="XXXL">XXXL</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p></p>
                        <p><FONT face="Arial" color="#000000">Crew T Shirt 3:</FONT>
				<ASP:RADIOBUTTONLIST id="Crew_T_shirts3" runat="server" Width="440px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
					<asp:ListItem Value="S">Small</asp:ListItem>
					<asp:ListItem Value="M">Medium</asp:ListItem>
					<asp:ListItem Value="L">Large</asp:ListItem>
					<asp:ListItem Value="XL">XL</asp:ListItem>
					<asp:ListItem Value="XXL">XXL</asp:ListItem>
					<asp:ListItem Value="XXXL">XXXL</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p></p>
                        <p><FONT face="Arial" color="#000000">Crew T Shirt 4:</FONT>
				<ASP:RADIOBUTTONLIST id="Crew_T_shirts4" runat="server" Width="440px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
					<asp:ListItem Value="S">Small</asp:ListItem>
					<asp:ListItem Value="M">Medium</asp:ListItem>
					<asp:ListItem Value="L">Large</asp:ListItem>
					<asp:ListItem Value="XL">XL</asp:ListItem>
					<asp:ListItem Value="XXL">XXL</asp:ListItem>
					<asp:ListItem Value="XXXL">XXXL</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p></p>
			<p><FONT face="Arial" color="#000000">Sweat Shirt:</FONT>
				<ASP:RADIOBUTTONLIST id="Sweat_Shirt" runat="server" Width="440px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
					<asp:ListItem Value="S">Small</asp:ListItem>
					<asp:ListItem Value="M">Medium</asp:ListItem>
					<asp:ListItem Value="L">Large</asp:ListItem>
					<asp:ListItem Value="XL">XL</asp:ListItem>
					<asp:ListItem Value="XXL">XXL</asp:ListItem>
					<asp:ListItem Value="XXXL">XXXL</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p></p>
			<p><FONT face="Arial" color="#000000">Arrival Date:
					<ASP:RADIOBUTTONLIST id="Arrival" runat="server" Width="354px" RepeatDirection="Horizontal" Font-Name="Arial"
						RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
						<asp:ListItem Value="T">Thursday 9/16/10</asp:ListItem>
						<asp:ListItem Value="F">Friday 9/17/10</asp:ListItem>
					</ASP:RADIOBUTTONLIST></FONT></p>
			<p></p>
			<p>
				<H3><FONT color="#ff0000" size="3"></FONT></H3>
			<P></P>
			<p></p>
			<FONT face="Arial" color="#000000">Bed Preference:</FONT>
			<ASP:RADIOBUTTONLIST id="Preference" runat="server" Width="316px" RepeatDirection="Horizontal" Font-Name="Arial"
				RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
				<asp:ListItem Value="King">One King Bed</asp:ListItem>
				<asp:ListItem Value="Double">Two Double Beds</asp:ListItem>
			</ASP:RADIOBUTTONLIST>
			<P></P>
			<P><FONT face="Arial" color="#000000"><FONT face="Arial" color="#ff0000"><U><STRONG>Section 7 - 
								Miscellaneous</STRONG></U></FONT></FONT></P>
			<P><FONT face="Arial" color="#000000">Name of Insurance Company:
			</P>
			<P><ASP:RADIOBUTTONLIST id="InsuranceList" runat="server" Width="264px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black" Height="22px">
					<asp:ListItem Value="IMC">IMC</asp:ListItem>
					<asp:ListItem Value="SHANTZ">SHANTZ</asp:ListItem>
					<asp:ListItem Value="OTHER">OTHER</asp:ListItem>
				</ASP:RADIOBUTTONLIST></P>
			<P>If other, insert name of insurance company,
				<asp:textbox id="Insurance_other" runat="server" Width="132px"></asp:textbox></P>
			</FONT><font face="Arial" color="#ff0000"><U></U></font>
			<P><FONT face="Arial"><FONT size="3"><FONT color="#000000">If you are not flying in Plano this 
							year and haven't in several years do you wish to remain on the invitation 
							list?:</FONT> </FONT></FONT>
			</P>
			<ASP:RADIOBUTTONLIST id="Invitation_List" runat="server" Width="128px" RepeatDirection="Horizontal" Font-Name="Arial"
				RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
				<asp:ListItem Value="Y">Yes</asp:ListItem>
				<asp:ListItem Value="N">No</asp:ListItem>
			</ASP:RADIOBUTTONLIST><FONT face="Arial" color="#000000"></FONT>
			<P><FONT face="Arial" color="#000000"><FONT size="3">Comments, additional information 
						and/or feedback:</FONT></P>
			<p></p>
			<asp:textbox id="Comments" runat="server" maxlength="255" Columns="50" Width="704px" TextMode="MultiLine"
				Height="90px"></asp:textbox></FONT>
			<P></P>
			<p><font color="#000000" size="4"><STRONG>Be sure to send your $50 deposit by June 30, 2010 
						to:</STRONG></font>
			<P><FONT face="Arial"><STRONG>Plano Balloon Festival, Inc.<br>
						P.O. Box 867706<br>
						Plano, Texas 75086</STRONG></FONT></P>
			<STRONG><FONT color="#000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (<FONT size="4">Be 
						sure we know who the check is from)</FONT></FONT></STRONG>
			<P>Thank you for registering. Your application has been submitted to the Pilot Registration Coordinator. Please remember to send in your $50 deposit by June 30th. <br />You will receive a letter via email by mid-July regarding your acceptance to the 2010 Plano Balloon Festival</P>

			<p>Please contact us via email at pilots@planoballoonfest.org<br/><br/>Win Myers</p>
			<center>
				<p><asp:linkbutton class="CommandButton" id="RegisterBtn" runat="server" Width="75px" Font-Names="Arial"
						Font-Bold="True" Text=" Submit " ForeColor="Black" Font-Size="Medium" BorderStyle="None" BorderColor="Black"
						BorderWidth="2" BackColor="Gainsboro"> Submit </asp:linkbutton>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
					&nbsp;
					<asp:linkbutton class="CommandButton" id="CancelBtn" runat="server" Width="76px" Font-Names="Arial"
						Font-Bold="True" Text=" Cancel " ForeColor="Black" Font-Size="Medium" BorderStyle="None" BorderColor="Black"
						BorderWidth="2" BackColor="Gainsboro" CausesValidation="False"> Return </asp:linkbutton>
				&nbsp;
				<P></P>
			</center>
		</form>
		</FONT>
		<p><asp:label id="Message" runat="server" CssClass="NormalRed"></asp:label></p>
	</body>
</html>

Open in new window

Avatar of NazoUK
NazoUK
Flag of United Kingdom of Great Britain and Northern Ireland image

You have to tell it what events to fire and when.

e.g. add OnClick="RegisterBtn_Click" to your button tag and so on.
ASKER CERTIFIED SOLUTION
Avatar of ronney_leslie
ronney_leslie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of westdh

ASKER

Thanks that works:

Now I have added another procedure and got the following error?
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0103: The name 'FriMor' does not exist in the current context

Source Error:

 
Line 100:                // Add New User to Portal User Database
Line 101:                ///ASPNetPortal.PilotsDB accountSystem = new ASPNetPortal.PilotsDB();
Line 102:                AddPilot("Y", FirstName.Text, LastName.Text, Company.Text, Address1.Text, Address2.Text, City.Text, State.Text, Zip.Text, HomePhone.Text, WorkPhone.Text, CellPhone.Text, FaxNumber.Text, Email.Text, Certificate_Type.SelectedValue, TotalHours.Text, Hours12Mos.Text, Name_of_Balloon.Text, Registration.Text, Manufacturer.Text, Balloon_Type.Text, Year.Text, Balloon_Hours.Text, Balloon_Entry_Type.SelectedValue, Special_Shape.SelectedValue, Addt_Crew.SelectedValue, How_Many_Crew.Text, FriMor, FriEve, SatMor, SatEve, SunMor, SunEve, Media_Flt.SelectedValue, How_Many_Media.Text, Fun_Flt.SelectedValue, Polo_Shirt.SelectedValue, Crew_T_shirts1.SelectedValue, Crew_T_shirts2.SelectedValue, Crew_T_shirts3.SelectedValue, Crew_T_shirts4.SelectedValue, Sweat_Shirt.SelectedValue, Arrival.SelectedValue, Preference.SelectedValue, "", Invitation_List.SelectedValue, Comments.Text, Insurance);
Line 103:
Line 104:                // Set the user's authentication name to the userId
<%@ Page language="c#" Debug="True" AutoEventWireup="false" smartNavigation="True" %>
 

<%@ Import Namespace="System" %>
<%@ Import Namespace="System.Collections" %>
<%@ Import Namespace="System.Configuration" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Web" %>
<%@ Import Namespace="System.Web.UI" %>
<%@ Import Namespace="System.Web.UI.WebControls" %>
<%@ Import Namespace="System.Web.UI.HtmlControls" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Web.Security" %>

<script runat="server">
    
    public class Register : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.TextBox FirstName;
        protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator5;
        protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator6;
        protected System.Web.UI.WebControls.TextBox Company;
        protected System.Web.UI.WebControls.TextBox Address1;
        protected System.Web.UI.WebControls.TextBox Address2;
        protected System.Web.UI.WebControls.TextBox City;
        protected System.Web.UI.WebControls.TextBox State;
        protected System.Web.UI.WebControls.TextBox Zip;
        protected System.Web.UI.WebControls.RadioButtonList Certificate_Type;
        protected System.Web.UI.WebControls.TextBox Name_of_Balloon;
        protected System.Web.UI.WebControls.TextBox Balloon_Type;
        protected System.Web.UI.WebControls.TextBox Year;
        protected System.Web.UI.WebControls.TextBox Balloon_Hours;
        protected System.Web.UI.WebControls.RadioButtonList Balloon_Entry_Type;
        protected System.Web.UI.WebControls.RadioButtonList Special_Shape;
        protected System.Web.UI.WebControls.RadioButtonList Addt_Crew;
        protected System.Web.UI.WebControls.TextBox How_Many_Crew;
        protected System.Web.UI.WebControls.RadioButtonList Polo_Shirt;

        protected System.Web.UI.WebControls.RadioButtonList Crew_T_shirts1;
        protected System.Web.UI.WebControls.RadioButtonList Crew_T_shirts2;
        protected System.Web.UI.WebControls.RadioButtonList Crew_T_shirts3;
        protected System.Web.UI.WebControls.RadioButtonList Crew_T_shirts4;

        protected System.Web.UI.WebControls.RadioButtonList Sweat_Shirt;
        protected System.Web.UI.WebControls.RadioButtonList Arrival;
        protected System.Web.UI.WebControls.RadioButtonList Preference;
        protected System.Web.UI.WebControls.RadioButtonList Invitation_List;
        protected System.Web.UI.WebControls.TextBox Comments;
        protected System.Web.UI.WebControls.LinkButton CancelBtn;
        protected System.Web.UI.WebControls.LinkButton RegisterBtn;
        protected System.Web.UI.WebControls.TextBox LastName;
        protected System.Web.UI.WebControls.TextBox Email;
        protected System.Web.UI.WebControls.Label Message;
        protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
        protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
        protected System.Web.UI.WebControls.TextBox HomePhone;
        protected System.Web.UI.WebControls.TextBox WorkPhone;
        protected System.Web.UI.WebControls.TextBox CellPhone;
        protected System.Web.UI.WebControls.TextBox FaxNumber;
        protected System.Web.UI.WebControls.TextBox TotalHours;
        protected System.Web.UI.WebControls.TextBox Hours12Mos;
        protected System.Web.UI.WebControls.TextBox Manufacturer;
        protected System.Web.UI.WebControls.CheckBox Fri_Am;
        protected System.Web.UI.WebControls.CheckBox Sat_Am;
        protected System.Web.UI.WebControls.CheckBox Sun_Am;
        protected System.Web.UI.WebControls.CheckBox Fri_Pm;
        protected System.Web.UI.WebControls.CheckBox Sat_Pm;
        protected System.Web.UI.WebControls.CheckBox Sun_Pm;
        protected System.Web.UI.WebControls.RadioButtonList Media_Flt;
        protected System.Web.UI.WebControls.TextBox How_Many_Media;
        protected System.Web.UI.WebControls.RadioButtonList Fun_Flt;

        string FriMor = "";
        string FriEve = "";
        string SatMor = "";
        string SatEve = "";
        string SunMor = "";
        string SunEve = "";
        string Insurance;
        protected System.Web.UI.WebControls.TextBox Registration;
        protected System.Web.UI.WebControls.TextBox Insurance_other;
        protected System.Web.UI.WebControls.RadioButtonList InsuranceList;
        
    }

    protected void RegisterBtn_Click(object sender, EventArgs e)
    {
        //Trace.Write("test1: " + How_Many_Crew.Text);
        // Only attempt a login if all form fields on the page are valid
        if (Page.IsValid == true)
        {
            // Attempt to Validate User Credentials using PilotsDB
            string PilotId = VerifyPilotRegistered(FirstName.Text, LastName.Text);

            if ((PilotId == null) || (PilotId == ""))
            {
                // Add New User to Portal User Database
                ///ASPNetPortal.PilotsDB accountSystem = new ASPNetPortal.PilotsDB();
                AddPilot("Y", FirstName.Text, LastName.Text, Company.Text, Address1.Text, Address2.Text, City.Text, State.Text, Zip.Text, HomePhone.Text, WorkPhone.Text, CellPhone.Text, FaxNumber.Text, Email.Text, Certificate_Type.SelectedValue, TotalHours.Text, Hours12Mos.Text, Name_of_Balloon.Text, Registration.Text, Manufacturer.Text, Balloon_Type.Text, Year.Text, Balloon_Hours.Text, Balloon_Entry_Type.SelectedValue, Special_Shape.SelectedValue, Addt_Crew.SelectedValue, How_Many_Crew.Text, FriMor, FriEve, SatMor, SatEve, SunMor, SunEve, Media_Flt.SelectedValue, How_Many_Media.Text, Fun_Flt.SelectedValue, Polo_Shirt.SelectedValue, Crew_T_shirts1.SelectedValue, Crew_T_shirts2.SelectedValue, Crew_T_shirts3.SelectedValue, Crew_T_shirts4.SelectedValue, Sweat_Shirt.SelectedValue, Arrival.SelectedValue, Preference.SelectedValue, "", Invitation_List.SelectedValue, Comments.Text, Insurance);

                // Set the user's authentication name to the userId
               FormsAuthentication.SetAuthCookie(Email.Text, false);

                // Redirect browser back to home page
                Response.Redirect("http://planoballoonfest.org/pbfpr/RegClose.aspx");
            }
            else
            {
                Message.Text = "You are already registered.  Please Login Instead.....yyyy this is a test";
            }
        }
    }

    protected void CancelBtn_Click(object sender, EventArgs e)
    {
        // Redirect back to the portal home page
        Response.Redirect("http://planoballoonfest.org/pbfpr/Default.aspx");
    }

    public String VerifyPilotRegistered(String FirstName, String LastName)
    {
        // Create Instance of Connection and Command Object
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
        SqlCommand myCommand = new SqlCommand("VerifyPilotRegistered", myConnection);

        // Mark the Command as a SPROC
        myCommand.CommandType = CommandType.StoredProcedure;

        // Add Parameters to SPROC
        SqlParameter parameterFirstName = new SqlParameter("@FirstName", SqlDbType.NVarChar, 30);
        parameterFirstName.Value = FirstName;
        myCommand.Parameters.Add(parameterFirstName);

        SqlParameter parameterLastName = new SqlParameter("@LastName", SqlDbType.NVarChar, 30);
        parameterLastName.Value = LastName;
        myCommand.Parameters.Add(parameterLastName);

        SqlParameter parameterPilotName = new SqlParameter("@PilotName", SqlDbType.NVarChar, 62);
        parameterPilotName.Direction = ParameterDirection.Output;
        myCommand.Parameters.Add(parameterPilotName);

        // Open the database connection and execute the command
        myConnection.Open();
        myCommand.ExecuteNonQuery();
        myConnection.Close();

        if ((parameterPilotName.Value != null) && (parameterPilotName.Value != System.DBNull.Value))
        {
            return ((String)parameterPilotName.Value).Trim();
        }
        else
        {
            return String.Empty;
        }
    
     }

     public int AddPilot(String App_Recd, String FirstName, String LastName, String Company, String Address1, String Address2, String City, String State, String Zip, String HomePhone, String WorkPhone, String CellPhone, String FaxNumber, String Email, String Certificate_Type, String TotalHours, String Hours12Mos, String Name_of_Balloon, String Registration, String Manufacturer, String Balloon_Type, String Year, String Hours, String Sport_Comm, String Special_Shape, String Addt_Crew, String How_Many_Crew, String FriMor, String FriEve, String SatMor, String SatEve, String SunMor,String SunEve,String Media_Flt,String How_Many_Media, String Fun_Flt,  String Polo_Shirt, String Crew_T_shirts1, String Crew_T_shirts2 ,String Crew_T_shirts3, String Crew_T_shirts4, String Sweat_Shirt, String Arrival, String Preference,String Deposit, String Invitation_List,String Comments, String Insurance) 
     {
			// Create Instance of Connection and Command Object
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
			SqlCommand myCommand = new SqlCommand("AddxPilot", myConnection);

			// Mark the Command as a SPROC
			myCommand.CommandType = CommandType.StoredProcedure;

			// Add Parameters to SPROC

			SqlParameter parameterApp_Recd = new SqlParameter("@App_Recd", SqlDbType.NVarChar, 3);
			parameterApp_Recd.Value = App_Recd;
			myCommand.Parameters.Add(parameterApp_Recd);

			SqlParameter parameterFirstName = new SqlParameter("@FirstName", SqlDbType.NVarChar, 30);
			parameterFirstName.Value = FirstName;
			myCommand.Parameters.Add(parameterFirstName);

			SqlParameter parameterLastName = new SqlParameter("@LastName", SqlDbType.NVarChar, 30);
			parameterLastName.Value = LastName;
			myCommand.Parameters.Add(parameterLastName);

			SqlParameter parameterCompany = new SqlParameter("@Company", SqlDbType.NVarChar, 30);
			parameterCompany.Value = Company;
			myCommand.Parameters.Add(parameterCompany);

			SqlParameter parameterAddress1 = new SqlParameter("@Address1", SqlDbType.NVarChar, 30);
			parameterAddress1.Value = Address1;
			myCommand.Parameters.Add(parameterAddress1);

			SqlParameter parameterAddress2 = new SqlParameter("@Address2", SqlDbType.NVarChar, 30);
			parameterAddress2.Value = Address2;
			myCommand.Parameters.Add(parameterAddress2);

			SqlParameter parameterCity= new SqlParameter("@City", SqlDbType.NVarChar, 30);
			parameterCity.Value = City;
			myCommand.Parameters.Add(parameterCity);

			SqlParameter parameterState = new SqlParameter("@State", SqlDbType.NVarChar, 30);
			parameterState.Value = State;
			myCommand.Parameters.Add(parameterState);

			SqlParameter parameterZip = new SqlParameter("@Zip", SqlDbType.NVarChar, 30);
			parameterZip.Value = Zip;
			myCommand.Parameters.Add(parameterZip);

			SqlParameter parameterHomePhone = new SqlParameter("@HomePhone", SqlDbType.NVarChar, 30);
			parameterHomePhone.Value = HomePhone;
			myCommand.Parameters.Add(parameterHomePhone);

			SqlParameter parameterWorkPhone= new SqlParameter("@WorkPhone", SqlDbType.NVarChar, 30);
			parameterWorkPhone.Value = WorkPhone;
			myCommand.Parameters.Add(parameterWorkPhone);

			SqlParameter parameterCellPhone = new SqlParameter("@CellPhone", SqlDbType.NVarChar, 30);
			parameterCellPhone.Value = CellPhone;
			myCommand.Parameters.Add(parameterCellPhone);

			SqlParameter parameterFaxNumber = new SqlParameter("@FaxNumber", SqlDbType.NVarChar, 30);
			parameterFaxNumber.Value = FaxNumber;
			myCommand.Parameters.Add(parameterFaxNumber);

			SqlParameter parameterEmail = new SqlParameter("@Email", SqlDbType.NVarChar, 100);
			parameterEmail.Value = Email;
			myCommand.Parameters.Add(parameterEmail);

			SqlParameter parameterCertificate_Type = new SqlParameter("@Certificate_Type", SqlDbType.NVarChar, 30);
			parameterCertificate_Type.Value = Certificate_Type;
			myCommand.Parameters.Add(parameterCertificate_Type);

			SqlParameter parameterTotalHours= new SqlParameter("@TotalHours", SqlDbType.NVarChar, 30);
			parameterTotalHours.Value = TotalHours;
			myCommand.Parameters.Add(parameterTotalHours);

			SqlParameter parameterHours12Mos = new SqlParameter("@Hours12Mos", SqlDbType.NVarChar, 30);
			parameterHours12Mos.Value = Hours12Mos;
			myCommand.Parameters.Add(parameterHours12Mos);

			SqlParameter parameterName_of_Balloon = new SqlParameter("@Name_of_Balloon", SqlDbType.NVarChar, 30);
			parameterName_of_Balloon.Value = Name_of_Balloon;
			myCommand.Parameters.Add(parameterName_of_Balloon);

			SqlParameter parameterRegistration = new SqlParameter("@Registration", SqlDbType.NVarChar, 30);
			parameterRegistration.Value = Registration;
			myCommand.Parameters.Add(parameterRegistration);

			SqlParameter parameterManufacturer = new SqlParameter("@Manufacturer", SqlDbType.NVarChar, 30);
			parameterManufacturer.Value = Manufacturer;
			myCommand.Parameters.Add(parameterManufacturer);

			SqlParameter parameterBalloon_Type = new SqlParameter("@Balloon_Type", SqlDbType.NVarChar, 30);
			parameterBalloon_Type.Value = Balloon_Type;
			myCommand.Parameters.Add(parameterBalloon_Type);

			SqlParameter parameterYear = new SqlParameter("@Year", SqlDbType.NVarChar, 30);
			parameterYear.Value = Year;
			myCommand.Parameters.Add(parameterYear);

			SqlParameter parameterHours = new SqlParameter("@Hours", SqlDbType.NVarChar, 30);
			parameterHours.Value = Hours;
			myCommand.Parameters.Add(parameterHours);

			SqlParameter parameterSport_Comm = new SqlParameter("@Sport_Comm", SqlDbType.NVarChar, 30);
			parameterSport_Comm.Value = Sport_Comm;
			myCommand.Parameters.Add(parameterSport_Comm);

			SqlParameter parameterSpecial_Shape = new SqlParameter("@Special_Shape", SqlDbType.NVarChar, 30);
			parameterSpecial_Shape.Value = Special_Shape;
			myCommand.Parameters.Add(parameterSpecial_Shape);

			SqlParameter parameterAddt_Crew = new SqlParameter("@Addt_Crew", SqlDbType.NVarChar, 1);
			parameterAddt_Crew.Value = Addt_Crew;
			myCommand.Parameters.Add(parameterAddt_Crew);

			SqlParameter parameterHow_Many_Crew = new SqlParameter("@How_Many_Crew", SqlDbType.NVarChar, 2);
			parameterHow_Many_Crew.Value = How_Many_Crew;
			myCommand.Parameters.Add(parameterHow_Many_Crew);

			SqlParameter parameterFriMor = new SqlParameter("@FriMor", SqlDbType.NVarChar, 1);
			parameterFriMor.Value = FriMor;
			myCommand.Parameters.Add(parameterFriMor);

			SqlParameter parameterFriEve = new SqlParameter("@FriEve", SqlDbType.NVarChar, 1);
			parameterFriEve.Value = FriEve;
			myCommand.Parameters.Add(parameterFriEve);

			SqlParameter parameterSatMor = new SqlParameter("@SatMor", SqlDbType.NVarChar, 1);
			parameterSatMor.Value = SatMor;
			myCommand.Parameters.Add(parameterSatMor);

			SqlParameter parameterSatEve = new SqlParameter("@SatEve", SqlDbType.NVarChar, 1);
			parameterSatEve.Value = SatEve;
			myCommand.Parameters.Add(parameterSatEve);

			SqlParameter parameterSunMor = new SqlParameter("@SunMor", SqlDbType.NVarChar, 1);
			parameterSunMor.Value = SunMor;
			myCommand.Parameters.Add(parameterSunMor);

			SqlParameter parameterSunEve = new SqlParameter("@SunEve", SqlDbType.NVarChar, 1);
			parameterSunEve.Value = SunEve;
			myCommand.Parameters.Add(parameterSunEve);

			SqlParameter parameterMedia_Flt = new SqlParameter("@Media_Flt", SqlDbType.NVarChar, 1);
			parameterMedia_Flt.Value = Media_Flt;
			myCommand.Parameters.Add(parameterMedia_Flt);

			SqlParameter parameterHow_Many_Media = new SqlParameter("@How_Many_Media", SqlDbType.NVarChar, 2);
			parameterHow_Many_Media.Value = How_Many_Media;
			myCommand.Parameters.Add(parameterHow_Many_Media);

			SqlParameter parameterFun_Flt = new SqlParameter("@Fun_Flt", SqlDbType.NVarChar, 1);
			parameterFun_Flt.Value = Fun_Flt;
			myCommand.Parameters.Add(parameterFun_Flt);

			SqlParameter parameterPolo_Shirt = new SqlParameter("@Polo_Shirt", SqlDbType.NVarChar, 6);
			parameterPolo_Shirt.Value = Polo_Shirt;
			myCommand.Parameters.Add(parameterPolo_Shirt);

			SqlParameter parameterCrew_T_shirts1 = new SqlParameter("@Crew_T_shirts1", SqlDbType.NVarChar, 6);
			parameterCrew_T_shirts1.Value = Crew_T_shirts1;
			myCommand.Parameters.Add(parameterCrew_T_shirts1);

			SqlParameter parameterCrew_T_shirts2 = new SqlParameter("@Crew_T_shirts2", SqlDbType.NVarChar, 6);
			parameterCrew_T_shirts2.Value = Crew_T_shirts2;
			myCommand.Parameters.Add(parameterCrew_T_shirts2);

			SqlParameter parameterCrew_T_shirts3 = new SqlParameter("@Crew_T_shirts3", SqlDbType.NVarChar, 6);
			parameterCrew_T_shirts3.Value = Crew_T_shirts3;
			myCommand.Parameters.Add(parameterCrew_T_shirts3);

			SqlParameter parameterCrew_T_shirts4 = new SqlParameter("@Crew_T_shirts4", SqlDbType.NVarChar, 6);
			parameterCrew_T_shirts4.Value = Crew_T_shirts4;
			myCommand.Parameters.Add(parameterCrew_T_shirts4);

			SqlParameter parameterSweat_Shirt = new SqlParameter("@Sweat_Shirt", SqlDbType.NVarChar, 6);
			parameterSweat_Shirt.Value = Sweat_Shirt;
			myCommand.Parameters.Add(parameterSweat_Shirt);

			SqlParameter parameterArrival = new SqlParameter("@Arrival", SqlDbType.NVarChar, 1);
			parameterArrival.Value = Arrival;
			myCommand.Parameters.Add(parameterArrival);


			SqlParameter parameterPreference = new SqlParameter("@Preference", SqlDbType.NVarChar, 30);
			parameterPreference.Value = Preference;
			myCommand.Parameters.Add(parameterPreference);

			SqlParameter parameterDeposit = new SqlParameter("@Deposit", SqlDbType.NVarChar, 1);
			parameterDeposit.Value = ""; 
			myCommand.Parameters.Add(parameterDeposit);

			SqlParameter parameterInvitation_List = new SqlParameter("@Invitation_List", SqlDbType.NVarChar, 1);
			parameterInvitation_List.Value = Invitation_List;
			myCommand.Parameters.Add(parameterInvitation_List);

			SqlParameter parameterComments = new SqlParameter("@Comments", SqlDbType.NVarChar, 255);
			parameterComments.Value = Comments;
			myCommand.Parameters.Add(parameterComments);

			SqlParameter parameterInsurance = new SqlParameter("@Insurance", SqlDbType.NVarChar, 15);
			parameterInsurance.Value = Insurance; 
			myCommand.Parameters.Add(parameterInsurance);

			SqlParameter parameterPilotsId = new SqlParameter("@PilotsId", SqlDbType.Int);
			parameterPilotsId.Value = ParameterDirection.Output;
			myCommand.Parameters.Add(parameterPilotsId);

			// Open the database connection and execute the command
			myConnection.Open();
			myCommand.ExecuteNonQuery();
			myConnection.Close();

			return (int) parameterPilotsId.Value;
            }
</script>

<html>
	
	<%--
   The Register.aspx page is used to enable clients to register a new unique username
   and password with the portal system.  The page contains a single server event
   handler -- RegisterBtn_Click -- that executes in response to the page's Register
   Button being clicked.

   The Register.aspx page uses the UsersDB class to manage the actual account creation.
   Note that the Usernames and passwords are stored within a table in a SQL database.
     --%>
    <head>
		<link href='<%= Request.ApplicationPath + "/Portal.css" %>' type=text/css rel=stylesheet>
	</head>
	
<body text="#000000" vLink="#666666" aLink="#ffffff" link="#00ffff" bgColor="#ffffff">
		<table cellSpacing="0" cellPadding="0" width="100%">
		
			<tr bgColor="#99cc00" width="98%">
				<td>&nbsp;&nbsp;</td>
			</tr>
		</table>
		<form id="Form1" style="LEFT: 40px; POSITION: relative" runat="server">
			<h3><font face="Arial" color="#ff0000"><u>Section 1 - Attendance Information</u></font></h3>
			<P><FONT face="Arial">First Name:</FONT>&nbsp;&nbsp;
				<asp:textbox id="FirstName" runat="server" maxlength="50"></asp:textbox>&nbsp; <FONT face="Arial">
					Last<STRONG> </STRONG>Name:</FONT> &nbsp;
				<asp:textbox id="LastName" runat="server" maxlength="50" Columns="30"></asp:textbox><asp:requiredfieldvalidator id="Requiredfieldvalidator5" runat="server" Display="Static" ControlToValidate="FirstName"
					ErrorMessage="You must enter your First Name"></asp:requiredfieldvalidator><asp:requiredfieldvalidator id="Requiredfieldvalidator6" runat="server" Display="Static" ControlToValidate="LastName"
					ErrorMessage="You must enter your Last Name"></asp:requiredfieldvalidator><br>
			</P>
			<h3><font face="Arial" color="#ff0000"><u>Section 2 - Pilot Information</u></font></h3>
			<P><FONT face="Arial">Company Name</FONT> (If applicable):&nbsp;&nbsp;
				<asp:textbox id="Company" runat="server" maxlength="50" Columns="30"></asp:textbox></P>
			<p></p>
			<p><FONT face="Arial">Address1:</FONT>&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Address1" runat="server" maxlength="52" Columns="52"></asp:textbox></p>
			<p></p>
			<p></p>
			<p><FONT face="Arial">Address2:</FONT>&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Address2" runat="server" maxlength="52" Columns="52"></asp:textbox></p>
			<p><STRONG>&nbsp;</STRONG><FONT face="Arial">City:</FONT>&nbsp;&nbsp;&nbsp;
				<asp:textbox id="City" runat="server" maxlength="30" Columns="27"></asp:textbox><FONT face="Arial">State<STRONG>:</STRONG></FONT>&nbsp;&nbsp;
				<asp:textbox id="State" runat="server" maxlength="12" Columns="12"></asp:textbox><FONT face="Arial"><STRONG>&nbsp;
					</STRONG>Zip:</FONT>&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Zip" runat="server" maxlength="11" Columns="11"></asp:textbox></p>
			<FONT face="Arial"><STRONG></STRONG></FONT>
			<p><FONT face="Arial">Home Phone:</FONT>&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="HomePhone" runat="server" maxlength="30" Columns="27"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Work Phone:</FONT>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
				<asp:textbox id="WorkPhone" runat="server" maxlength="12" Columns="12" Width="184px"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Cell Phone :</FONT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="CellPhone" runat="server" maxlength="30" Columns="27" Width="184px"></asp:textbox></p>
			<p></p>
			<p></p>
			<p><FONT face="Arial">Fax:</FONT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
				&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="FaxNumber" runat="server" maxlength="12" Columns="12" Width="176px"></asp:textbox>&nbsp;</p>
			<FONT face="Arial">E-mail Address:</FONT> &nbsp;&nbsp;&nbsp;
			<asp:textbox id="Email" runat="server" maxlength="80" Columns="54" Width="312px"></asp:textbox>&nbsp;
			<asp:regularexpressionvalidator id="RegularExpressionValidator1" runat="server" Display="Dynamic" ControlToValidate="Email"
				ErrorMessage="Must use a valid email address." ValidationExpression="[\w\.-]+(\+[\w-]*)?@([\w-]+\.)+[\w-]+"></asp:regularexpressionvalidator><asp:requiredfieldvalidator id="RequiredFieldValidator2" runat="server" ControlToValidate="Email" ErrorMessage="'Email' must not be left blank."></asp:requiredfieldvalidator>
			<p><FONT face="Arial">Certificate Type</FONT><ASP:RADIOBUTTONLIST id="Certificate_Type" runat="server" Width="232px" RepeatDirection="Horizontal"
					Font-Name="Arial" RepeatLayout="Table" Font-Names="Arial" Font-Bold="True">
					<asp:ListItem Value="Private">Private</asp:ListItem>
					<asp:ListItem Value="Commercial">Commercial</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p></p>
			<p><FONT face="Arial">Total Hours as LTA PIC :</FONT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="TotalHours" runat="server" maxlength="6" Columns="6"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Total Hours as LTA PIC in Last 12 Months :</FONT>&nbsp;&nbsp;
				<asp:textbox id="Hours12Mos" runat="server" maxlength="6" Columns="6"></asp:textbox></p>
			<p></p>
			<H3><FONT face="Arial" color="#ff0000">Section 3 - Balloon Information</FONT></H3>
			<p><FONT face="Arial">Name of Balloon:</FONT>&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Name_of_Balloon" runat="server" maxlength="30" Columns="25"></asp:textbox></p>
			<p><FONT face="Arial">Registration Number:</FONT> &nbsp;<asp:textbox id="Registration" runat="server" maxlength="8" Columns="8"></asp:textbox></p>
			<p><FONT face="Arial">Manufacturer:<STRONG>&nbsp;</STRONG></FONT>&nbsp;<asp:textbox id="Manufacturer" runat="server" maxlength="30" Columns="18"></asp:textbox>
			</p>
			<p><FONT face="Arial">Balloon Type:</FONT> &nbsp;&nbsp;<asp:textbox id="Balloon_Type" runat="server" maxlength="6" Columns="6"></asp:textbox></p>
			<p><FONT face="Arial">Year:</FONT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Year" runat="server" maxlength="30" Columns="18"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Hours:</FONT>&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Balloon_Hours" runat="server" maxlength="8" Columns="8"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Balloon Entry Type:</FONT>&nbsp;
				<ASP:RADIOBUTTONLIST id="Balloon_Entry_Type" runat="server" Width="204px" RepeatDirection="Horizontal"
					Font-Name="Arial" RepeatLayout="Table" Font-Names="Arial" Font-Bold="True">
					<asp:ListItem Value="C">Commercial</asp:ListItem>
					<asp:ListItem Value="S">Sport</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p><FONT face="Arial">Special Shape:</FONT>
			&nbsp;&nbsp;
			<p><ASP:RADIOBUTTONLIST id="Special_Shape" runat="server" Width="128px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True">
					<asp:ListItem Value="Yes">Yes</asp:ListItem>
					<asp:ListItem Value="No">No</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p>
				<h3><font face="Arial" color="#ff0000"><U>Section 4 - Crew Requirements</U></font></h3>
			<p><FONT face="Arial">Will you need the Festival to provide you with crew?</FONT>&nbsp;&nbsp;</p>
			<p><ASP:RADIOBUTTONLIST id="Addt_Crew" runat="server" Width="128px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True">
					<asp:ListItem Value="Y">Yes</asp:ListItem>
					<asp:ListItem Value="N">No</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p><FONT face="Arial">How Many?:</FONT> &nbsp;&nbsp;<asp:textbox id="How_Many_Crew" runat="server" maxlength="2" Columns="2"></asp:textbox>
			</p>
			<FONT face="Arial"><STRONG>&nbsp;&nbsp;</STRONG> Check which flights you will need 
				extra crew:</FONT>
			     <p><asp:checkbox id="Fri_Am" runat="server" Font-Bold="True" Text="Friday Morning" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox><STRONG>&nbsp;&nbsp; &nbsp; </STRONG>
				<asp:checkbox id="Sat_Am" runat="server" Font-Bold="True" Text="Saturday Morning" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox><STRONG>&nbsp;&nbsp; </STRONG>
				<asp:checkbox id="Sun_Am" runat="server" Font-Bold="True" Text="Sunday Morning" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox></p>
			     <p><asp:checkbox id="Fri_Pm" runat="server" Font-Bold="True" Text="Friday Evening" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox>&nbsp;&nbsp;&nbsp;&nbsp;
                                <asp:checkbox id="Sat_Pm" runat="server" Font-Bold="True" Text="Saturday Evening" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox>&nbsp;&nbsp; &nbsp;
                                <asp:checkbox id="Sun_Pm" runat="server" Font-Bold="True" Text="Sunday Evening" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox></p>
			<h3><font face="Arial" color="#ff0000"><U>Section 5 - Special Flights</U></font></h3>
			<p><FONT face="Arial">Will you fly in the media flight Friday morning 9/17/2010?</FONT>&nbsp;</p>
			<p><ASP:RADIOBUTTONLIST id="Media_Flt" runat="server" Width="136px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True">
					<asp:ListItem Value="Y">Yes</asp:ListItem>
					<asp:ListItem Value="N">No</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p><FONT face="Arial">How many media/sponsor passengers can you fly?:</FONT>&nbsp; 
				&nbsp;<asp:textbox id="How_Many_Media" runat="server" maxlength="2" Columns="2"></asp:textbox>
			</p>
			<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><font color="#000000" size="4"><sup><STRONG>(Passengers 
							will be assigned by the Festival for the media flight)</STRONG></sup></font></p>
			<p><FONT face="Arial"> Will you fly Sunday afternoon 9/19/2010?</FONT></p>
			<p><ASP:RADIOBUTTONLIST id="Fun_Flt" runat="server" Width="120px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True">
					<asp:ListItem Value="Y">Yes</asp:ListItem>
					<asp:ListItem Value="N">No</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<H3><font color="#ff0000" Size:face="Arial"><U><FONT face="Arial">Section 6 - Details</FONT></U></H3>
			<p><FONT face="Arial" color="#000000">Polo Shirt Size:</FONT>
				<ASP:RADIOBUTTONLIST id="Polo_Shirt" runat="server" Width="440px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
					<asp:ListItem Value="S">Small</asp:ListItem>
					<asp:ListItem Value="M">Medium</asp:ListItem>
					<asp:ListItem Value="L">Large</asp:ListItem>
					<asp:ListItem Value="XL">XL</asp:ListItem>
					<asp:ListItem Value="XXL">XXL</asp:ListItem>
					<asp:ListItem Value="XXXL">XXXL</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p></p>
                <H3><font color="#ff0000" Size:face="Arial"><U><FONT face="Arial">Crew t_shirts(up to 4)</FONT></U></H3>
                 <p><FONT face="Arial" color="#000000">Crew T Shirt 1:</FONT>
				<ASP:RADIOBUTTONLIST id="Crew_T_shirts1" runat="server" Width="440px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
					<asp:ListItem Value="S">Small</asp:ListItem>
					<asp:ListItem Value="M">Medium</asp:ListItem>
					<asp:ListItem Value="L">Large</asp:ListItem>
					<asp:ListItem Value="XL">XL</asp:ListItem>
					<asp:ListItem Value="XXL">XXL</asp:ListItem>
					<asp:ListItem Value="XXXL">XXXL</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p></p>
                        <p><FONT face="Arial" color="#000000">Crew T Shirt 2:</FONT>
				<ASP:RADIOBUTTONLIST id="Crew_T_shirts2" runat="server" Width="440px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
					<asp:ListItem Value="S">Small</asp:ListItem>
					<asp:ListItem Value="M">Medium</asp:ListItem>
					<asp:ListItem Value="L">Large</asp:ListItem>
					<asp:ListItem Value="XL">XL</asp:ListItem>
					<asp:ListItem Value="XXL">XXL</asp:ListItem>
					<asp:ListItem Value="XXXL">XXXL</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p></p>
                        <p><FONT face="Arial" color="#000000">Crew T Shirt 3:</FONT>
				<ASP:RADIOBUTTONLIST id="Crew_T_shirts3" runat="server" Width="440px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
					<asp:ListItem Value="S">Small</asp:ListItem>
					<asp:ListItem Value="M">Medium</asp:ListItem>
					<asp:ListItem Value="L">Large</asp:ListItem>
					<asp:ListItem Value="XL">XL</asp:ListItem>
					<asp:ListItem Value="XXL">XXL</asp:ListItem>
					<asp:ListItem Value="XXXL">XXXL</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p></p>
                        <p><FONT face="Arial" color="#000000">Crew T Shirt 4:</FONT>
				<ASP:RADIOBUTTONLIST id="Crew_T_shirts4" runat="server" Width="440px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
					<asp:ListItem Value="S">Small</asp:ListItem>
					<asp:ListItem Value="M">Medium</asp:ListItem>
					<asp:ListItem Value="L">Large</asp:ListItem>
					<asp:ListItem Value="XL">XL</asp:ListItem>
					<asp:ListItem Value="XXL">XXL</asp:ListItem>
					<asp:ListItem Value="XXXL">XXXL</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p></p>
			<p><FONT face="Arial" color="#000000">Sweat Shirt:</FONT>
				<ASP:RADIOBUTTONLIST id="Sweat_Shirt" runat="server" Width="440px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
					<asp:ListItem Value="S">Small</asp:ListItem>
					<asp:ListItem Value="M">Medium</asp:ListItem>
					<asp:ListItem Value="L">Large</asp:ListItem>
					<asp:ListItem Value="XL">XL</asp:ListItem>
					<asp:ListItem Value="XXL">XXL</asp:ListItem>
					<asp:ListItem Value="XXXL">XXXL</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p></p>
			<p><FONT face="Arial" color="#000000">Arrival Date:
					<ASP:RADIOBUTTONLIST id="Arrival" runat="server" Width="354px" RepeatDirection="Horizontal" Font-Name="Arial"
						RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
						<asp:ListItem Value="T">Thursday 9/16/10</asp:ListItem>
						<asp:ListItem Value="F">Friday 9/17/10</asp:ListItem>
					</ASP:RADIOBUTTONLIST></FONT></p>
			<p></p>
			<p>
				<H3><FONT color="#ff0000" size="3"></FONT></H3>
			<P></P>
			<p></p>
			<FONT face="Arial" color="#000000">Bed Preference:</FONT>
			<ASP:RADIOBUTTONLIST id="Preference" runat="server" Width="316px" RepeatDirection="Horizontal" Font-Name="Arial"
				RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
				<asp:ListItem Value="King">One King Bed</asp:ListItem>
				<asp:ListItem Value="Double">Two Double Beds</asp:ListItem>
			</ASP:RADIOBUTTONLIST>
			<P></P>
			<P><FONT face="Arial" color="#000000"><FONT face="Arial" color="#ff0000"><U><STRONG>Section 7 - 
								Miscellaneous</STRONG></U></FONT></FONT></P>
			<P><FONT face="Arial" color="#000000">Name of Insurance Company:
			</P>
			<P><ASP:RADIOBUTTONLIST id="InsuranceList" runat="server" Width="264px" RepeatDirection="Horizontal" Font-Name="Arial"
					RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black" Height="22px">
					<asp:ListItem Value="IMC">IMC</asp:ListItem>
					<asp:ListItem Value="SHANTZ">SHANTZ</asp:ListItem>
					<asp:ListItem Value="OTHER">OTHER</asp:ListItem>
				</ASP:RADIOBUTTONLIST></P>
			<P>If other, insert name of insurance company,
				<asp:textbox id="Insurance_other" runat="server" Width="132px"></asp:textbox></P>
			</FONT><font face="Arial" color="#ff0000"><U></U></font>
			<P><FONT face="Arial"><FONT size="3"><FONT color="#000000">If you are not flying in Plano this 
							year and haven't in several years do you wish to remain on the invitation 
							list?:</FONT> </FONT></FONT>
			</P>
			<ASP:RADIOBUTTONLIST id="Invitation_List" runat="server" Width="128px" RepeatDirection="Horizontal" Font-Name="Arial"
				RepeatLayout="Table" Font-Names="Arial" Font-Bold="True" ForeColor="Black">
				<asp:ListItem Value="Y">Yes</asp:ListItem>
				<asp:ListItem Value="N">No</asp:ListItem>
			</ASP:RADIOBUTTONLIST><FONT face="Arial" color="#000000"></FONT>
			<P><FONT face="Arial" color="#000000"><FONT size="3">Comments, additional information 
						and/or feedback:</FONT></P>
			<p></p>
			<asp:textbox id="Comments" runat="server" maxlength="255" Columns="50" Width="704px" TextMode="MultiLine"
				Height="90px"></asp:textbox></FONT>
			<P></P>
			<p><font color="#000000" size="4"><STRONG>Be sure to send your $50 deposit by June 30, 2010 
						to:</STRONG></font>
			<P><FONT face="Arial"><STRONG>Plano Balloon Festival, Inc.<br>
						P.O. Box 867706<br>
						Plano, Texas 75086</STRONG></FONT></P>
			<STRONG><FONT color="#000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (<FONT size="4">Be 
						sure we know who the check is from)</FONT></FONT></STRONG>
			<P>Thank you for registering. Your application has been submitted to the Pilot Registration Coordinator. Please remember to send in your $50 deposit by June 30th. <br />You will receive a letter via email by mid-July regarding your acceptance to the 2010 Plano Balloon Festival</P>

			<p>Please contact us via email at pilots@planoballoonfest.org<br/><br/>Win Myers</p>
			<center>
				<p><asp:linkbutton  class="CommandButton" id="RegisterBtn" OnClick="RegisterBtn_Click"  runat="server" Width="75px" Font-Names="Arial"
						Font-Bold="True" Text=" Submit " ForeColor="Black" Font-Size="Medium" BorderStyle="None" BorderColor="Black"
						BorderWidth="2" BackColor="Gainsboro"> Submit </asp:linkbutton>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
					&nbsp;
					<asp:linkbutton class="CommandButton" id="CancelBtn" OnClick="CancelBtn_Click"  runat="server" Width="76px" Font-Names="Arial"
						Font-Bold="True" Text=" Cancel " ForeColor="Black" Font-Size="Medium" BorderStyle="None" BorderColor="Black"
						BorderWidth="2" BackColor="Gainsboro" CausesValidation="False"> Return </asp:linkbutton>
				&nbsp;
				<P></P>
			</center>
		</form>
		</FONT>
		<p><asp:label id="Message" runat="server" CssClass="NormalRed"></asp:label></p>
	</body>
</html> 

Open in new window

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of westdh

ASKER

How can I give you more points for all the good your doing me?
----------------------------------------------------------------------------------------------------------
I have one more on line 640 'SqlDataReader' used to return a value ...not working?

Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0246: The type or namespace name 'SqlDataReader' could not be found (are you missing a using directive or an assembly reference?)

Source Error:

Line 638:            //*********************************************************************
Line 639:
Line 640:            public SqlDataReader GetSinglePilot(String FirstName, String LastName)
Line 641:            {
Line 642:
 

Source File: e:\hosting\member\planofest\pbfpr\PilotReg.aspx    Line: 640

<%@ Page language="c#" Codebehind="PilotReg.aspx.cs" AutoEventWireup="false" Inherits="ASPNetPortal.PilotReg" smartNavigation="True" %>
<%@ Register TagPrefix="portal" TagName="Banner" Src="~/DesktopPortalBanner.ascx" %>
<%@ Reference Page="~/DesktopDefault.aspx" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

using System;
using System.Collections;
using System.Configuration;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Diagnostics;

<script runat="server">

	public class PilotReg : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox FirstName;
		protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator2;
		protected System.Web.UI.WebControls.TextBox LastName;
		protected System.Web.UI.WebControls.RadioButtonList Addt_Crew;
		protected System.Web.UI.WebControls.TextBox Address_1;
		protected System.Web.UI.WebControls.TextBox Textbox1;
		protected System.Web.UI.WebControls.TextBox Company;
		protected System.Web.UI.WebControls.TextBox City;
		protected System.Web.UI.WebControls.TextBox Zip;
		protected System.Web.UI.WebControls.TextBox Email;
		protected System.Web.UI.WebControls.RadioButtonList Certificate_Type;
		protected System.Web.UI.WebControls.TextBox TotalHours;
		protected System.Web.UI.WebControls.TextBox Hours12Mos;
		protected System.Web.UI.WebControls.TextBox Name_of_Balloon;
		protected System.Web.UI.WebControls.TextBox Manufacturer;
		protected System.Web.UI.WebControls.TextBox Balloon_Type;
		protected System.Web.UI.WebControls.TextBox Year;
		protected System.Web.UI.WebControls.TextBox Hours;
		protected System.Web.UI.WebControls.RadioButtonList Special_Shape;
		protected System.Web.UI.WebControls.RadioButtonList Sport_Comm;
		protected System.Web.UI.WebControls.TextBox How_Many_Media;
		protected System.Web.UI.WebControls.TextBox Address_2;
		protected System.Web.UI.WebControls.RadioButtonList Polo_Shirt;
		protected System.Web.UI.WebControls.RadioButtonList Sweat_Shirt;
		protected System.Web.UI.WebControls.RadioButtonList Arrival;
		protected System.Web.UI.WebControls.RadioButtonList Preference;
		protected System.Web.UI.WebControls.TextBox Comments;
		protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator1;
		protected System.Web.UI.WebControls.TextBox State;
		protected System.Web.UI.WebControls.LinkButton UpdateBtn;
		protected System.Web.UI.WebControls.TextBox Deposit;
		protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator4;
		protected System.Web.UI.WebControls.TextBox HomePhone;
		protected System.Web.UI.WebControls.TextBox WorkPhone;
		protected System.Web.UI.WebControls.TextBox CellPhone;
		protected System.Web.UI.WebControls.TextBox FaxNumber;
		protected System.Web.UI.WebControls.LinkButton CancelBtn;
		protected System.Web.UI.WebControls.TextBox How_Many_Crew;
		protected System.Web.UI.WebControls.CheckBox Fri_Am;
		protected System.Web.UI.WebControls.CheckBox Sat_Am;
		protected System.Web.UI.WebControls.CheckBox Sun_Am;
		protected System.Web.UI.WebControls.CheckBox Fri_Pm;
		protected System.Web.UI.WebControls.CheckBox Sat_Pm;
		protected System.Web.UI.WebControls.CheckBox Sun_Pm;
		protected System.Web.UI.WebControls.RadioButtonList Media_Flt;
		protected System.Web.UI.WebControls.RadioButtonList Fun_Flt;
		protected System.Web.UI.WebControls.TextBox Registration;
		protected System.Web.UI.WebControls.RadioButtonList Invitation_List;
		protected System.Web.UI.WebControls.TextBox Textbox2;
		protected System.Web.UI.WebControls.RadioButtonList InsuranceList;
		protected System.Web.UI.WebControls.Label Insurance;
		protected System.Web.UI.WebControls.TextBox Insurance_other;
		protected System.Web.UI.HtmlControls.HtmlForm Form1;
		protected System.Web.UI.WebControls.TextBox InsuranceReceived;
		protected System.Web.UI.WebControls.TextBox txtMsg;
	 
        }

	private void Page_Load(object sender, System.EventArgs e)
	{
			int PilotsID = System.Convert.ToInt32(Session["PilotsID"]);
			
			//Trace.Write("test1: " + PilotsID.ToString());

			// Put user code to initialize the page here
			if (Page.IsPostBack == false) 
			{
				//Trace.Write("Test 1: " + PilotsID.ToString());
				//ASPNetPortal.PilotsDB Pilots = new ASPNetPortal.PilotsDB();
				SqlDataReader dr = GetSinglePilotsID(PilotsID);
				//Read first row from database
				dr.Read();

				//string var1 = (string)dr["App_Recd"];
				//if (var1 == "Y" )
				//{
				//	App_Recd.Items.FindByValue("Y").Selected = true;
				//}
				//if (var1 == "No" )
				//{
				//	App_Recd.Items.FindByValue("N").Selected = true;
				//}
				//App_Recd.Items = "Y";

				FirstName.Text = (string)dr["FirstName"];
				LastName.Text = (string)dr["LastName"];
				Company.Text = (string)dr["Company"];
				Address_1.Text = (string)dr["Address1"];
				Address_2.Text = (string)dr["Address2"];
				City.Text = (string)dr["City"];
				State.Text = (string)dr["State"];
				Zip.Text = (string)dr["Zip"];
				HomePhone.Text = (string)dr["HomePhone"];
				WorkPhone.Text = (string)dr["WorkPhone"];
				CellPhone.Text = (string)dr["CellPhone"];
				FaxNumber.Text = (string)dr["FaxNumber"];
				Email.Text = (string)dr["Email"];

				string var2 = (string)dr["Certificate_Type"];
				if (var2 == "Private" )
				{
					Certificate_Type.Items.FindByValue("Private").Selected = true;
				}
				if (var2 == "Commercial" )
				{
					Certificate_Type.Items.FindByValue("Commercial").Selected = true;
				}

				TotalHours.Text = (string)dr["TotalHours"];
				Hours12Mos.Text = (string)dr["Hours12Mos"];
				Name_of_Balloon.Text = (string)dr["Name_of_Balloon"];
				Registration.Text = (string)dr["Registration"];
				Manufacturer.Text = (string)dr["Manufacturer"];
				Balloon_Type.Text = (string)dr["Balloon_Type"];
				Year.Text = (string)dr["Year"];
				Hours.Text = (string)dr["Hours"];

				string var3 = (string)dr["Sport_Comm"];
				if (var3 == "C" )
				{
					Sport_Comm.Items.FindByValue("C").Selected = true;
				}
				if(var3 == "S" )
				{
					Sport_Comm.Items.FindByValue("S").Selected = true;
				}

				string var40 = (string)dr["Special_Shape"];
				if (var40 == "Yes" )
				{
					Special_Shape.Items.FindByValue("Yes").Selected = true;
				}
				if(var40 == "N0" )
				{
					Special_Shape.Items.FindByValue("No").Selected = true;
				}
				
				string var41 = (string)dr["Addt_Crew"];
				if (var41 == "Y" )
				{
					Addt_Crew.Items.FindByValue("Y").Selected = true;
				}
				if(var41 == "N" )
				{
					Addt_Crew.Items.FindByValue("N").Selected = true;
				}
	          
				How_Many_Crew.Text = (string)dr["How_Many_Crew"];

				string var5 = (string)dr["Fri_AM"];
				if (var5 == "Y")
				{
					Fri_Am.Checked=true;
				}
				string var6 = (string)dr["Fri_PM"];
				if (var6 == "Y")
				{
					Fri_Pm.Checked=true;
				}
				string var7 = (string)dr["Sat_AM"];
				if (var7 == "Y")
				{
					Sat_Am.Checked=true;
				}
				string var8 = (string)dr["Sat_PM"];
				if (var8 == "Y")
				{
					Sat_Pm.Checked=true;
				}
				string var9 = (string)dr["Sun_AM"];
				if (var9 == "Y")
				{
					Sun_Am.Checked=true;
				}
				string var10 = (string)dr["Sun_PM"];
				if (var10 == "Y")
				{
					Sun_Pm.Checked=true;
				}

				string var11 = (string)dr["Media_Flt"];
				if (var11 == "Y" )
				{
					Media_Flt.Items.FindByValue("Y").Selected = true;
				}
				if(var11 == "N" )
				{
					Media_Flt.Items.FindByValue("N").Selected = true;
				}

				How_Many_Media.Text = (string)dr["How_Many_Media"];

				string var12 = (string)dr["Fun_Flt"];
				if (var12 == "Y" )
				{
					Fun_Flt.Items.FindByValue("Y").Selected = true;
				}
				if(var12 == "N" )
				{
					Fun_Flt.Items.FindByValue("N").Selected = true;
				}

				string var15 = (string)dr["Polo_Shirt"];
				if (var15 == "S" )
				{
					Polo_Shirt.Items.FindByValue("S").Selected = true;
				}
				if(var15 == "M" )
				{
					Polo_Shirt.Items.FindByValue("M").Selected = true;
				}
				if(var15 == "L" )
				{
					Polo_Shirt.Items.FindByValue("L").Selected = true;
				}
				if(var15 == "XL" )
				{
					Polo_Shirt.Items.FindByValue("XL").Selected = true;
				}
				if(var15 == "XXL" )
				{
					Polo_Shirt.Items.FindByValue("XXL").Selected = true;
				}
				if(var15 == "XXXL" )
				{
					Polo_Shirt.Items.FindByValue("XXXL").Selected = true;
				}

				string var16 = (string)dr["Sweat_Shirt"];
				if (var16 == "S" )
				{
					Sweat_Shirt.Items.FindByValue("S").Selected = true;
				}
				if(var16 == "M" )
				{
					Sweat_Shirt.Items.FindByValue("M").Selected = true;
				}
				if(var16 == "L" )
				{
					Sweat_Shirt.Items.FindByValue("L").Selected = true;
				}
				if(var16 == "XL" )
				{
					Sweat_Shirt.Items.FindByValue("XL").Selected = true;
				}
				if(var16 == "XXL" )
				{
					Sweat_Shirt.Items.FindByValue("XXL").Selected = true;
				}
				if(var16 == "XXXL" )
				{
					Sweat_Shirt.Items.FindByValue("XXXL").Selected = true;
				}

				string var17 = (string)dr["Arrival"];
				if (var17 == "T" )
				{
					Arrival.Items.FindByValue("T").Selected = true;
				}
				if(var17 == "F" )
				{
					Arrival.Items.FindByValue("F").Selected = true;
				}

				string var18 = (string)dr["Preference"];
				if (var18 == "King" )
				{
					Preference.Items.FindByValue("King").Selected = true;
				}
				if (var18 == "Double" )
				{
					Preference.Items.FindByValue("Double").Selected = true;
				}

				Deposit.Text = (string)dr["Deposit"];

				string var19 = (string)dr["Invitation_List"];
				if (var19== "Y" )
				{
					Invitation_List.Items.FindByValue("Y").Selected = true;
				}
				if(var19 == "N" )
				{
					Invitation_List.Items.FindByValue("N").Selected = true;
				}

				Comments.Text = (string)dr["Comments"];
				
				string var20 = (string)dr["Insurance"];
				if((var20 != "IMC")&&(var20 != "SHANTZ" )&& (var20 != ""))
				{
					InsuranceList.Items.FindByValue("OTHER").Selected = true;
					Insurance_other.Text = (string)dr["Insurance"];
				}
				
				if (var20 == "IMC" )
				{
					InsuranceList.Items.FindByValue("IMC").Selected = true;
					Insurance_other.Text = "";

				}
				if(var20 == "SHANTZ" )
				{
					InsuranceList.Items.FindByValue("SHANTZ").Selected = true;
					Insurance_other.Text = "";

				}

				dr.Close();
			}
		}

		public void Index_Changed(Object sender, EventArgs e) 
		{ 
			txtMsg.Text = "!. you got here";
			if ((InsuranceList.SelectedItem.Text == "IMC") || (InsuranceList.SelectedItem.Text == "SHANTZ"))
			{
				txtMsg.Text = "2. you got here";
				Insurance_other.Text = "";
			}
		}


		//****************************************************************
		//
		// The UpdateBtn_Click event handler on this Page is used to either
		// create or update a contact.  It  uses the ASPNetPortal.ContactsDB()
		// data component to encapsulate all data functionality.
		//
		//****************************************************************

		string FriMor="";
		string FriEve="";
		string SatMor="";
		string SatEve="";
		string SunMor="";
		string SunEve="";

		private void UpdateBtn_Click(Object sender, EventArgs e) 
		{

			if (Fri_Am.Checked == true) 
			{
				FriMor = "Y";
			}
			if (Fri_Pm.Checked == true) 
			{
				FriEve = "Y";
			}

			if (Sat_Am.Checked == true) 
			{
				SatMor = "Y";
			}
			if (Sat_Pm.Checked == true) 
			{
				SatEve = "Y";
			}

			if (Sun_Am.Checked == true) 
			{
				SunMor = "Y";
			}
			if (Sun_Pm.Checked == true) 
			{
				SunEve = "Y";
			}
			// Only Update if Entered data is Valid
			if (Page.IsValid == true) 
			{
				// Create an instance of the VolunteersDB component
				
                
				if (System.Convert.ToString(Session["PilotsID"]) == "0") 
				{
					//Trace.Write("test2: " + System.Convert.ToInt32(Session["PilotsID"]));
					Server.Transfer("~/RegError.aspx");
				}
				else 
				{
					// Update the Volunteer within the Volunteer table
					int pilotsId = System.Convert.ToInt32(Session["PilotsID"]);
					//ASPNetPortal.PilotsDB pilots = new ASPNetPortal.PilotsDB();
					if(Insurance_other.Text != "")
					{
						//txtMsg.Text = "3. you got here";
						UpdatePilots(pilotsId, "Y", FirstName.Text, LastName.Text, Company.Text, Address_1.Text, Address_2.Text, City.Text, State.Text, Zip.Text, HomePhone.Text, WorkPhone.Text, CellPhone.Text, FaxNumber.Text, Email.Text, Certificate_Type.SelectedValue , TotalHours.Text, Hours12Mos.Text, Name_of_Balloon.Text, Registration.Text, Manufacturer.Text, Balloon_Type.Text, Year.Text, Hours.Text, Sport_Comm.SelectedValue, Special_Shape.SelectedValue, Addt_Crew.SelectedValue, How_Many_Crew.Text, FriMor , FriEve , SatMor, SatEve, SunMor, SunEve , Media_Flt.SelectedValue, How_Many_Media.Text, Fun_Flt.SelectedValue, Polo_Shirt.SelectedValue,  Sweat_Shirt.SelectedValue, Arrival.SelectedValue, Preference.SelectedValue, Deposit.Text ,Invitation_List.SelectedValue,Comments.Text,Insurance_other.Text);
						Server.Transfer("~/RegClose.aspx");
					}
					else
					{
						//txtMsg.Text = "4. you got here";
						UpdatePilots(pilotsId, "Y", FirstName.Text, LastName.Text, Company.Text, Address_1.Text, Address_2.Text, City.Text, State.Text, Zip.Text, HomePhone.Text, WorkPhone.Text, CellPhone.Text, FaxNumber.Text, Email.Text, Certificate_Type.SelectedValue , TotalHours.Text, Hours12Mos.Text, Name_of_Balloon.Text, Registration.Text, Manufacturer.Text, Balloon_Type.Text, Year.Text, Hours.Text, Sport_Comm.SelectedValue, Special_Shape.SelectedValue, Addt_Crew.SelectedValue, How_Many_Crew.Text, FriMor , FriEve , SatMor, SatEve, SunMor, SunEve , Media_Flt.SelectedValue, How_Many_Media.Text, Fun_Flt.SelectedValue, Polo_Shirt.SelectedValue,  Sweat_Shirt.SelectedValue, Arrival.SelectedValue, Preference.SelectedValue, Deposit.Text ,Invitation_List.SelectedValue,Comments.Text,InsuranceList.SelectedValue);
						Server.Transfer("~/RegClose.aspx");

					}
				}
			}
				
		}


                public void UpdatePilots(int PilotsId, String App_Recd, String FirstName, String LastName, String Company, String Address1, String Address2, String City, String State, String Zip, String HomePhone, String WorkPhone, String CellPhone, String FaxNumber, String Email, String Certificate_Type, String TotalHours, String Hours12Mos, String Name_of_Balloon, String Registration, String Manufacturer, String Balloon_Type, String Year, String Hours, String Sport_Comm, String Special_Shape, String Addt_Crew, String How_Many_Crew, String FriMor, String FriEve, String SatMor, String SatEve, String SunMor, String SunEve, String Media_Flt, String How_Many_Media, String Fun_Flt, String Polo_Shirt, String Sweat_Shirt, String Arrival, String Preference, String Deposit, String Invitation_List, String Comments, String Insurance)                                                                                      
		{
			// Create Instance of Connection and Command Object
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
			SqlCommand myCommand = new SqlCommand("UpdatePilots", myConnection);

			// Mark the Command as a SPROC
			myCommand.CommandType = CommandType.StoredProcedure;

			SqlParameter parameterPilotsId = new SqlParameter("@PilotsId", SqlDbType.Int, 4);
			parameterPilotsId.Value = PilotsId;
			myCommand.Parameters.Add(parameterPilotsId);
			
			SqlParameter parameterApp_Recd = new SqlParameter("@App_Recd", SqlDbType.NVarChar, 3);
			parameterApp_Recd.Value = App_Recd;
			myCommand.Parameters.Add(parameterApp_Recd);

			SqlParameter parameterFirstName = new SqlParameter("@FirstName", SqlDbType.NVarChar, 30);
			parameterFirstName.Value = FirstName;
			myCommand.Parameters.Add(parameterFirstName);

			SqlParameter parameterLastName = new SqlParameter("@LastName", SqlDbType.NVarChar, 30);
			parameterLastName.Value = LastName;
			myCommand.Parameters.Add(parameterLastName);

			SqlParameter parameterCompany = new SqlParameter("@Company", SqlDbType.NVarChar, 30);
			parameterCompany.Value = Company;
			myCommand.Parameters.Add(parameterCompany);

			SqlParameter parameterAddress1 = new SqlParameter("@Address1", SqlDbType.NVarChar, 30);
			parameterAddress1.Value = Address1;
			myCommand.Parameters.Add(parameterAddress1);

			SqlParameter parameterAddress2 = new SqlParameter("@Address2", SqlDbType.NVarChar, 30);
			parameterAddress2.Value = Address2;
			myCommand.Parameters.Add(parameterAddress2);

			SqlParameter parameterCity= new SqlParameter("@City", SqlDbType.NVarChar, 30);
			parameterCity.Value = City;
			myCommand.Parameters.Add(parameterCity);

			SqlParameter parameterState = new SqlParameter("@State", SqlDbType.NVarChar, 30);
			parameterState.Value = State;
			myCommand.Parameters.Add(parameterState);

			SqlParameter parameterZip = new SqlParameter("@Zip", SqlDbType.NVarChar, 30);
			parameterZip.Value = Zip;
			myCommand.Parameters.Add(parameterZip);

			SqlParameter parameterHomePhone = new SqlParameter("@HomePhone", SqlDbType.NVarChar, 30);
			parameterHomePhone.Value = HomePhone;
			myCommand.Parameters.Add(parameterHomePhone);

			SqlParameter parameterWorkPhone= new SqlParameter("@WorkPhone", SqlDbType.NVarChar, 30);
			parameterWorkPhone.Value = WorkPhone;
			myCommand.Parameters.Add(parameterWorkPhone);

			SqlParameter parameterCellPhone = new SqlParameter("@CellPhone", SqlDbType.NVarChar, 30);
			parameterCellPhone.Value = CellPhone;
			myCommand.Parameters.Add(parameterCellPhone);

			SqlParameter parameterFaxNumber = new SqlParameter("@FaxNumber", SqlDbType.NVarChar, 30);
			parameterFaxNumber.Value = FaxNumber;
			myCommand.Parameters.Add(parameterFaxNumber);

			SqlParameter parameterEmail = new SqlParameter("@Email", SqlDbType.NVarChar, 100);
			parameterEmail.Value = Email;
			myCommand.Parameters.Add(parameterEmail);

			SqlParameter parameterCertificate_Type = new SqlParameter("@Certificate_Type", SqlDbType.NVarChar, 30);
			parameterCertificate_Type.Value = Certificate_Type;
			myCommand.Parameters.Add(parameterCertificate_Type);

			SqlParameter parameterTotalHours= new SqlParameter("@TotalHours", SqlDbType.NVarChar, 30);
			parameterTotalHours.Value = TotalHours;
			myCommand.Parameters.Add(parameterTotalHours);

			SqlParameter parameterHours12Mos = new SqlParameter("@Hours12Mos", SqlDbType.NVarChar, 30);
			parameterHours12Mos.Value = Hours12Mos;
			myCommand.Parameters.Add(parameterHours12Mos);

			SqlParameter parameterName_of_Balloon = new SqlParameter("@Name_of_Balloon", SqlDbType.NVarChar, 30);
			parameterName_of_Balloon.Value = Name_of_Balloon;
			myCommand.Parameters.Add(parameterName_of_Balloon);

			SqlParameter parameterRegistration = new SqlParameter("@Registration", SqlDbType.NVarChar, 30);
			parameterRegistration.Value = Registration;
			myCommand.Parameters.Add(parameterRegistration);

			SqlParameter parameterManufacturer = new SqlParameter("@Manufacturer", SqlDbType.NVarChar, 30);
			parameterManufacturer.Value = Manufacturer;
			myCommand.Parameters.Add(parameterManufacturer);

			SqlParameter parameterBalloon_Type = new SqlParameter("@Balloon_Type", SqlDbType.NVarChar, 30);
			parameterBalloon_Type.Value = Balloon_Type;
			myCommand.Parameters.Add(parameterBalloon_Type);

			SqlParameter parameterYear = new SqlParameter("@Year", SqlDbType.NVarChar, 30);
			parameterYear.Value = Year;
			myCommand.Parameters.Add(parameterYear);

			SqlParameter parameterHours = new SqlParameter("@Hours", SqlDbType.NVarChar, 30);
			parameterHours.Value = Hours;
			myCommand.Parameters.Add(parameterHours);

			SqlParameter parameterSport_Comm = new SqlParameter("@Sport_Comm", SqlDbType.NVarChar, 30);
			parameterSport_Comm.Value = Sport_Comm;
			myCommand.Parameters.Add(parameterSport_Comm);

			SqlParameter parameterSpecial_Shape = new SqlParameter("@Special_Shape", SqlDbType.NVarChar, 30);
			parameterSpecial_Shape.Value = Special_Shape;
			myCommand.Parameters.Add(parameterSpecial_Shape);


			SqlParameter parameterAddt_Crew = new SqlParameter("@Addt_Crew", SqlDbType.NVarChar, 1);
			parameterAddt_Crew.Value = Addt_Crew;
			myCommand.Parameters.Add(parameterAddt_Crew);

			SqlParameter parameterHow_Many_Crew = new SqlParameter("@How_Many_Crew", SqlDbType.NVarChar, 2);
			parameterHow_Many_Crew.Value = How_Many_Crew;
			myCommand.Parameters.Add(parameterHow_Many_Crew);

			SqlParameter parameterExtra_Crew_FriMor = new SqlParameter("@FriMor", SqlDbType.NVarChar, 1);
			parameterExtra_Crew_FriMor.Value = FriMor;
			myCommand.Parameters.Add(parameterExtra_Crew_FriMor);

			SqlParameter parameterFriEve = new SqlParameter("@FriEve", SqlDbType.NVarChar, 1);
			parameterFriEve.Value = FriEve;
			myCommand.Parameters.Add(parameterFriEve);

			SqlParameter parameterSatMor = new SqlParameter("@SatMor", SqlDbType.NVarChar, 1);
			parameterSatMor.Value = SatMor;
			myCommand.Parameters.Add(parameterSatMor);

			SqlParameter parameterSatEve= new SqlParameter("@SatEve", SqlDbType.NVarChar, 1);
			parameterSatEve.Value = SatEve;
			myCommand.Parameters.Add(parameterSatEve);

			SqlParameter parameterSunMor = new SqlParameter("@SunMor", SqlDbType.NVarChar, 1);
			parameterSunMor.Value = SunMor;
			myCommand.Parameters.Add(parameterSunMor);

			SqlParameter parameterSunEve = new SqlParameter("@SunEve", SqlDbType.NVarChar, 1);
			parameterSunEve.Value = SunEve;
			myCommand.Parameters.Add(parameterSunEve);

			SqlParameter parameterMedia_Flt = new SqlParameter("@Media_Flt", SqlDbType.NVarChar, 1);
			parameterMedia_Flt.Value = Media_Flt;
			myCommand.Parameters.Add(parameterMedia_Flt);

			SqlParameter parameterHow_Many_Media = new SqlParameter("@How_Many_Media", SqlDbType.NVarChar, 30);
			parameterHow_Many_Media.Value = "";
			myCommand.Parameters.Add(parameterHow_Many_Media);

			SqlParameter parameterFun_Flt = new SqlParameter("@Fun_Flt", SqlDbType.NVarChar, 1);
			parameterFun_Flt.Value = Fun_Flt;
			myCommand.Parameters.Add(parameterFun_Flt);

                        //SqlParameter parameterSat_Static_Display = new SqlParameter("@Sat_Static_Display", SqlDbType.NVarChar, 1);
			//parameterSat_Static_Display.Value = "";
			//myCommand.Parameters.Add(parameterSat_Static_Display);

                        //SqlParameter parameterSun_Static_Display = new SqlParameter("@Sun_Static_Display", SqlDbType.NVarChar, 1);
			//parameterSun_Static_Display.Value = Sun_Static_Display;
			//myCommand.Parameters.Add(parameterSun_Static_Display);

			SqlParameter parameterPolo_Shirt = new SqlParameter("@Polo_Shirt", SqlDbType.NVarChar, 6);
			parameterPolo_Shirt.Value = Polo_Shirt;
			myCommand.Parameters.Add(parameterPolo_Shirt);

			SqlParameter parameterSweat_Shirt = new SqlParameter("@Sweat_Shirt", SqlDbType.NVarChar, 6);
			parameterSweat_Shirt.Value = Sweat_Shirt;
			myCommand.Parameters.Add(parameterSweat_Shirt);

			SqlParameter parameterArrival = new SqlParameter("@Arrival", SqlDbType.NVarChar, 1);
			parameterArrival.Value = Arrival;
			myCommand.Parameters.Add(parameterArrival);

			SqlParameter parameterPreference = new SqlParameter("@Preference", SqlDbType.NVarChar, 30);
			parameterPreference.Value = Preference;
			myCommand.Parameters.Add(parameterPreference);

			SqlParameter parameterDeposit = new SqlParameter("@Deposit", SqlDbType.NVarChar, 1);
			parameterDeposit.Value = Deposit; 
			myCommand.Parameters.Add(parameterDeposit);

			SqlParameter parameterInvitation_List = new SqlParameter("@Invitation_List", SqlDbType.NVarChar, 1);
			parameterInvitation_List.Value = Invitation_List;
			myCommand.Parameters.Add(parameterInvitation_List);

			SqlParameter parameterComments = new SqlParameter("@Comments", SqlDbType.NVarChar, 255);
			parameterComments.Value = Comments;
			myCommand.Parameters.Add(parameterComments);

			SqlParameter parameterInsurance = new SqlParameter("@Insurance", SqlDbType.NVarChar, 15);
			parameterInsurance.Value = Insurance; 
			myCommand.Parameters.Add(parameterInsurance);

			// Open the database connection and execute the command
			myConnection.Open();
			myCommand.ExecuteNonQuery();
			myConnection.Close();
		}


		//*********************************************************************
		//
		// GetSinglePilot Method
		//
		// The GetSinglePilot method returns a SqlDataReader containing details
		// about a specific user from the Pilots database table.
		//
		//*********************************************************************

		public SqlDataReader GetSinglePilot(String FirstName, String LastName) 
		{

			// Create Instance of Connection and Command Object
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
			SqlCommand myCommand = new SqlCommand("GetSinglePilot", myConnection);

			// Mark the Command as a SPROC
			myCommand.CommandType = CommandType.StoredProcedure;

			// Add Parameters to SPROC
			SqlParameter parameterFirstName = new SqlParameter("@FirstName", SqlDbType.NVarChar, 30);
			parameterFirstName.Value = FirstName;
			myCommand.Parameters.Add(parameterFirstName);

			SqlParameter parameterLastName = new SqlParameter("@LastName", SqlDbType.NVarChar, 30);
			parameterLastName.Value = LastName;
			myCommand.Parameters.Add(parameterLastName);

			// Open the database connection and execute the command
			myConnection.Open();
			SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);

			// Return the datareader
			return dr;
		}

		//****************************************************************
		//
		// The CancelBtn_Click event handler on this Page is used to cancel
		// out of the page, and return the user back to the portal home
		// page.
		//
		//****************************************************************

		private void CancelBtn_Click(Object sender, EventArgs e) 
		{
			// Redirect back to the portal home page
			//Response.Redirect(Request.ApplicationPath);
			Response.Redirect("http://planoballoonfest.org/pbfpr/Default.aspx");
		}
        
</script>


<HTML>
	<HEAD>
		<title>PilotReg</title>
		<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
		<meta content="C#" name="CODE_LANGUAGE">
		<meta content="JavaScript" name="vs_defaultClientScript">
		<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
	</HEAD>
	<body>
		<table cellSpacing="0" cellPadding="0" width="100%">
			<tr vAlign="top">
				<td colSpan="2"><portal:banner id="Banner1" runat="server" ShowTabs="false"></portal:banner></td>
			</tr>
			<tr bgColor="#99cc00">
				<td></td>
			</tr>
		</table>
		<p><FONT size="4"><font color="#000000">Please review and update the registration 
					information we have recorded in our Pilot Database.&nbsp;</font></FONT>
		<P><FONT size="4"><FONT color="#000000">Make sure the sections reflect your Insurance and 
					choices for this year's event.</FONT>&nbsp;</P>
		<form id="Form1" style="POSITION: relative; LEFT: 40px" runat="server" method="post">
			<h3><font face="Arial" color="#ff0000"><u>Section 1 - Attendance Information</u></font></h3>
			<P><FONT face="Arial">First Name:</FONT>&nbsp;&nbsp;
				<asp:textbox id="FirstName" runat="server" maxlength="50"></asp:textbox>&nbsp; <FONT face="Arial">
					Last<STRONG> </STRONG>Name:</FONT> &nbsp;
				<asp:textbox id="LastName" runat="server" maxlength="50" Columns="30"></asp:textbox>&nbsp;&nbsp;
				<asp:requiredfieldvalidator id="Requiredfieldvalidator1" runat="server" Display="Static" ErrorMessage="Enter your First Name"
					ControlToValidate="FirstName"></asp:requiredfieldvalidator><asp:requiredfieldvalidator id="Requiredfieldvalidator2" runat="server" Display="Static" ErrorMessage="Enter your Last Name"
					ControlToValidate="LastName"></asp:requiredfieldvalidator><FONT face="Arial" color="#000000" size="4"></FONT></P>
			<P></P>
			<h3><font face="Arial" color="#ff0000"><u>Section 2 - Pilot Information</u></font></h3>
			<P><FONT face="Arial">Company Name</FONT> (If applicable):&nbsp;&nbsp;
				<asp:textbox id="Company" runat="server" maxlength="50" Columns="30"></asp:textbox></P>
			<p></p>
			<p><FONT face="Arial">Address1:</FONT>&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Address_1" runat="server" maxlength="52" Columns="52"></asp:textbox></p>
			<p></p>
			<p></p>
			<p><FONT face="Arial">Address2:</FONT>&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Address_2" runat="server" maxlength="52" Columns="52"></asp:textbox></p>
			<p><STRONG>&nbsp;</STRONG><FONT face="Arial">City:</FONT>&nbsp;&nbsp;&nbsp;
				<asp:textbox id="City" runat="server" maxlength="30" Columns="27"></asp:textbox><FONT face="Arial">State<STRONG>:</STRONG></FONT>&nbsp;&nbsp;
				<asp:textbox id="State" runat="server" maxlength="12" Columns="12"></asp:textbox><FONT face="Arial"><STRONG>&nbsp;
					</STRONG>Zip:</FONT>&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Zip" runat="server" maxlength="11" Columns="11"></asp:textbox></p>
			<P><FONT face="Arial" color="#000000">Name of Insurance Company:
			</P>
			<P><ASP:RADIOBUTTONLIST id="InsuranceList" OnSelectedIndexChanged="Index_Changed" AutoPostBack="True" runat="server"
					Width="264px" Font-Bold="True" Font-Names="Arial" RepeatLayout="Table" Font-Name="Arial" RepeatDirection="Horizontal"
					ForeColor="Black" Height="22px">
					<asp:ListItem Value="IMC">IMC</asp:ListItem>
					<asp:ListItem Value="SHANTZ">SHANTZ</asp:ListItem>
					<asp:ListItem Value="OTHER">OTHER</asp:ListItem>
				</ASP:RADIOBUTTONLIST></P>
			<P>If other, insert name of insurance company,
				<asp:textbox id="Insurance_other" runat="server" Width="132px"></asp:textbox></P>
			</FONT> <FONT face="Arial"><STRONG></STRONG></FONT>
			<p><FONT face="Arial">Home Phone:</FONT>&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="HomePhone" runat="server" maxlength="30" Columns="27"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Work Phone:</FONT>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
				<asp:textbox id="WorkPhone" runat="server" maxlength="12" Columns="12"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Cell Phone :</FONT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="CellPhone" runat="server" maxlength="30" Columns="27" Width="184px"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Fax:</FONT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
				&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="FaxNumber" runat="server" maxlength="12" Columns="12" Width="184px"></asp:textbox>&nbsp;</p>
			<p><FONT color="#ff0000">To receive online notices of future events and event alerts we 
					need an email address.</FONT></p>
			<FONT face="Arial">E-mail Address:</FONT> &nbsp;&nbsp;&nbsp;
			<asp:textbox id="Email" runat="server" maxlength="80" Columns="54" Width="312px"></asp:textbox>
			<p><FONT face="Arial">Certificate Type:</FONT><ASP:RADIOBUTTONLIST id="Certificate_Type" runat="server" Width="232px" Font-Bold="True" Font-Names="Arial"
					RepeatLayout="Table" Font-Name="Arial" RepeatDirection="Horizontal">
					<asp:ListItem Value="Private">Private</asp:ListItem>
					<asp:ListItem Value="Commercial">Commercial</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p><FONT face="Arial">Total Hours as LTA PIC :</FONT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="TotalHours" runat="server" maxlength="6" Columns="6"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Total Hours as LTA PIC in Last 12 Months :</FONT>&nbsp;&nbsp;
				<asp:textbox id="Hours12Mos" runat="server" maxlength="6" Columns="6"></asp:textbox></p>
			<p></p>
			<p><font face="Arial" color="#ff0000"><STRONG><U>Section 3 - Balloon Information</U></STRONG></font></p>
			<p><FONT face="Arial">Name of Balloon:</FONT>&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Name_of_Balloon" runat="server" maxlength="30" Columns="25"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Registration Number:</FONT> &nbsp;<asp:textbox id="Registration" runat="server" maxlength="8" Columns="8"></asp:textbox></p>
			<p><FONT face="Arial">Manufacturer:<STRONG>&nbsp;</STRONG></FONT>&nbsp;<asp:textbox id="Manufacturer" runat="server" maxlength="30" Columns="18"></asp:textbox>
			</p>
			<p><FONT face="Arial">Balloon Type:</FONT> &nbsp;&nbsp;<asp:textbox id="Balloon_Type" runat="server" maxlength="6" Columns="6"></asp:textbox></p>
			<p><FONT face="Arial">Year:</FONT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Year" runat="server" maxlength="30" Columns="18"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Hours:</FONT>&nbsp;&nbsp;&nbsp;
				<asp:textbox id="Hours" runat="server" maxlength="8" Columns="8"></asp:textbox></p>
			<p></p>
			<p><FONT face="Arial">Balloon Entry Type:</FONT>&nbsp;
				<ASP:RADIOBUTTONLIST id="Sport_Comm" runat="server" Width="204px" Font-Bold="True" Font-Names="Arial"
					RepeatLayout="Table" Font-Name="Arial" RepeatDirection="Horizontal">
					<asp:ListItem Value="C">Commercial</asp:ListItem>
					<asp:ListItem Value="S">Sport</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p><FONT face="Arial">Special Shape:</FONT>
			&nbsp;&nbsp;
			<p><ASP:RADIOBUTTONLIST id="Special_Shape" runat="server" Width="128px" Font-Bold="True" Font-Names="Arial"
					RepeatLayout="Table" Font-Name="Arial" RepeatDirection="Horizontal">
					<asp:ListItem Value="Yes">Yes</asp:ListItem>
					<asp:ListItem Value="No">No</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p>
				<h3><font face="Arial" color="#ff0000"><U>Section 4 - Crew Requirements</U></font></h3>
			<p><FONT face="Arial">Will you need the Festival to provide you with crew?</FONT>&nbsp;&nbsp;</p>
			<p><ASP:RADIOBUTTONLIST id="Addt_Crew" runat="server" Width="128px" Font-Bold="True" Font-Names="Arial"
					RepeatLayout="Table" Font-Name="Arial" RepeatDirection="Horizontal">
					<asp:ListItem Value="Y">Yes</asp:ListItem>
					<asp:ListItem Value="N">No</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p><FONT face="Arial">How Many?:</FONT> &nbsp;&nbsp;<asp:textbox id="How_Many_Crew" runat="server" maxlength="2" Columns="2"></asp:textbox>
			</p>
			<FONT face="Arial"><STRONG>&nbsp;&nbsp;</STRONG> Check which flights you will need 
				extra crew:</FONT>
			<p><asp:checkbox id="Fri_Am" runat="server" Font-Bold="True" Text="Friday Morning" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox><STRONG>&nbsp;&nbsp; &nbsp; </STRONG>
				<asp:checkbox id="Sat_Am" runat="server" Font-Bold="True" Text="Saturday Morning" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox><STRONG>&nbsp;&nbsp; </STRONG>
				<asp:checkbox id="Sun_Am" runat="server" Font-Bold="True" Text="Sunday Morning" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox></p>
			<p><asp:checkbox id="Fri_Pm" runat="server" Font-Bold="True" Text="Friday Evening" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox>&nbsp;&nbsp;&nbsp;&nbsp;<asp:checkbox id="Sat_Pm" runat="server" Font-Bold="True" Text="Saturday Evening" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox>&nbsp;&nbsp; &nbsp;<asp:checkbox id="Sun_Pm" runat="server" Font-Bold="True" Text="Sunday Evening" TextAlign="Right"
					AutoPostBack="True"></asp:checkbox></p>
			<h3><font face="Arial" color="#ff0000"><U>Section 5 - Special Flights</U></font></h3>
			<p><FONT face="Arial">Will you fly in the media flight Friday morning 9/17/2010 ?</FONT></p>
			<p><ASP:RADIOBUTTONLIST id="Media_Flt" runat="server" Width="136px" Font-Bold="True" Font-Names="Arial"
					RepeatLayout="Table" Font-Name="Arial" RepeatDirection="Horizontal">
					<asp:ListItem Value="Y">Yes</asp:ListItem>
					<asp:ListItem Value="N">No</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p><FONT face="Arial">How many media/sponsor passengers can you fly?:</FONT>&nbsp; 
				&nbsp;<asp:textbox id="How_Many_Media" runat="server" maxlength="2" Columns="2"></asp:textbox>
			</p>
			<p style="LINE-HEIGHT: 100%; MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><font color="#000000" size="4"><sup><STRONG>(Passengers 
							will be assigned by the Festival for the media flight)</STRONG></sup></font></p>
			<p><FONT face="Arial"> Will you fly Sunday afternoon&nbsp;9/19/2010 ?</FONT>&nbsp;</p>
			<p><ASP:RADIOBUTTONLIST id="Fun_Flt" runat="server" Width="120px" Font-Bold="True" Font-Names="Arial" RepeatLayout="Table"
					Font-Name="Arial" RepeatDirection="Horizontal">
					<asp:ListItem Value="Y">Yes</asp:ListItem>
					<asp:ListItem Value="N">No</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>

			<H3><font color="#ff0000" Size:face="Arial"><U><FONT face="Arial">Section 6 - Details</FONT></U></H3>
			<p><FONT face="Arial" color="#000000">Polo Shirt Size:</FONT>
				<ASP:RADIOBUTTONLIST id="Polo_Shirt" runat="server" Width="440px" Font-Bold="True" Font-Names="Arial"
					RepeatLayout="Table" Font-Name="Arial" RepeatDirection="Horizontal" ForeColor="Black">
					<asp:ListItem Value="S">Small</asp:ListItem>
					<asp:ListItem Value="M">Medium</asp:ListItem>
					<asp:ListItem Value="L">Large</asp:ListItem>
					<asp:ListItem Value="XL">XL</asp:ListItem>
					<asp:ListItem Value="XXL">XXL</asp:ListItem>
					<asp:ListItem Value="XXXL">XXXL</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p></p>
			<p><FONT face="Arial" color="#000000">Sweat Shirt:</FONT>
				<ASP:RADIOBUTTONLIST id="Sweat_Shirt" runat="server" Width="440px" Font-Bold="True" Font-Names="Arial"
					RepeatLayout="Table" Font-Name="Arial" RepeatDirection="Horizontal" ForeColor="Black">
					<asp:ListItem Value="S">Small</asp:ListItem>
					<asp:ListItem Value="M">Medium</asp:ListItem>
					<asp:ListItem Value="L">Large</asp:ListItem>
					<asp:ListItem Value="XL">XL</asp:ListItem>
					<asp:ListItem Value="XXL">XXL</asp:ListItem>
					<asp:ListItem Value="XXXL">XXXL</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<p></p>
			<p><FONT face="Arial" color="#000000">Arrival Date:
					<ASP:RADIOBUTTONLIST id="Arrival" runat="server" Width="320px" Font-Bold="True" Font-Names="Arial" RepeatLayout="Table"
						Font-Name="Arial" RepeatDirection="Horizontal" ForeColor="Black">
						<asp:ListItem Value="T">Thursday 9/16/10</asp:ListItem>
						<asp:ListItem Value="F">Friday 9/17/10</asp:ListItem>
					</ASP:RADIOBUTTONLIST></FONT><FONT color="#ff0000" size="3"></FONT></p>
			<P></P>
			<p><FONT face="Arial" color="#000000">Bed Preference:</FONT>
				<ASP:RADIOBUTTONLIST id="Preference" runat="server" Width="316px" Font-Bold="True" Font-Names="Arial"
					RepeatLayout="Table" Font-Name="Arial" RepeatDirection="Horizontal" ForeColor="Black">
					<asp:ListItem Value="King">One King Bed</asp:ListItem>
					<asp:ListItem Value="Double">Two Double Beds</asp:ListItem>
				</ASP:RADIOBUTTONLIST></p>
			<FONT face="Arial" color="#000000">
				<H3><FONT face="Arial" color="#ff0000"><U>Section 7 - Miscellaneous</U></FONT></H3>
			</FONT>
			<p></p>
			<P><FONT face="Arial"><FONT size="3"><FONT color="#000000">If you are not flying in Plano this 
							year and haven't in several years do you wish to remain on the invitation 
							list?:</FONT> </FONT></FONT>
			</P>
			<ASP:RADIOBUTTONLIST id="Invitation_List" runat="server" Width="128px" Font-Bold="True" Font-Names="Arial"
				RepeatLayout="Table" Font-Name="Arial" RepeatDirection="Horizontal" ForeColor="Black">
				<asp:ListItem Value="Y">Yes</asp:ListItem>
				<asp:ListItem Value="N">No</asp:ListItem>
			</ASP:RADIOBUTTONLIST><asp:requiredfieldvalidator id="Requiredfieldvalidator4" runat="server" Display="Static" ErrorMessage="Required Entry"
				ControlToValidate="Invitation_List"></asp:requiredfieldvalidator>
			<P></P>
			<P><FONT face="Arial" color="#000000"><FONT size="3">Comments, additional information 
						and/or feedback:</FONT></P>
			<p></p>
			<asp:textbox id="Comments" runat="server" maxlength="255" Columns="50" Width="704px" TextMode="MultiLine"
				Height="90px"></asp:textbox></FONT>
			<P></P>
			<p><FONT face="Arial" color="#000000"><STRONG>Received Deposit:</STRONG></FONT>&nbsp;&nbsp;&nbsp;Admin(only)&nbsp;
				<asp:textbox id="Deposit" runat="server" maxlength="6" Columns="6" Width="32px" ReadOnly="True"></asp:textbox></p>
			<P><FONT face="Arial" color="#000000"><STRONG>Received Insurance:</STRONG></FONT>&nbsp;&nbsp;&nbsp;Admin(only)&nbsp;
				<asp:textbox id="InsuranceReceived" runat="server" maxlength="15" Columns="15" Width="32px" ReadOnly="True"></asp:textbox></P>
			Name of Insurance:
			<asp:Label id="Insurance" runat="server" maxlength="15" Columns="15" Width="32px" ReadOnly="True"></asp:Label>
			<P></P>
			<p></p>
			<p><font color="#000000" size="4"><STRONG>Be sure to send your $50 deposit by June 30, 2010 
						to:</STRONG></font>
			<p><FONT face="Arial"><STRONG> Plano Balloon Festival, Inc.<br>
						P.O. Box 867706<br>
						Plano, Texas 75086</STRONG></FONT></p>
			<p><STRONG><FONT color="#000000">(<FONT size="4">Be sure we know who the check is from)</FONT></FONT></STRONG></p>
			<p></p>
			<center>
				<p><asp:linkbutton class="CommandButton" id="UpdateBtn" runat="server" Width="75px" Font-Bold="True"
						Font-Names="Arial" Text=" Submit " ForeColor="Black" BorderWidth="2" BorderColor="Black" BorderStyle="None"
						Font-Size="Medium" BackColor="Gainsboro"> Submit</asp:linkbutton>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
					&nbsp;
					<asp:linkbutton class="CommandButton" id="CancelBtn" runat="server" Width="76px" Font-Bold="True"
						Font-Names="Arial" Text=" Cancel " ForeColor="Black" BorderWidth="2" BorderColor="Black" BorderStyle="None"
						Font-Size="Medium" BackColor="Gainsboro" CausesValidation="False"> Cancel</asp:linkbutton>
				&nbsp;
				<P></P>
			</center>
			<asp:TextBox id="txtMsg" Width="100" Runat="server"></asp:TextBox></form>
		</FONT></FONT>
	</body>
</HTML>

Open in new window

Avatar of westdh

ASKER

I have post a new question;
asp.net compile error on inline code - 'SqlDataReader' used to return a value ...not working?
Avatar of westdh

ASKER

Very good a quick support.
Avatar of ronney_leslie
ronney_leslie

I am away from my computer & it's night here. Will post the fix tomorrow morning. (approx in 12 hrs). Hope you can wait.

Ronney
Avatar of westdh

ASKER

Ok I will wait.
Looks like you got it sorted.

Ronney