예제 #1
0
 private void btnLogin_Click(object sender, EventArgs e)
 {
     this.Hide();
     Interface.registrant_info info = new Interface.registrant_info();
     info.Show();
     this.Close();
 }
예제 #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                OleDbConnection conn     = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=goFlyAKite.accdb;Persist Security Info=True");
                OleDbCommand    addCreds = new OleDbCommand("INSERT INTO Users (Username, Pass) VALUES (@Username, @Password)", conn);
                addCreds.Parameters.AddWithValue("@Username", this.tbUsername.Text);
                addCreds.Parameters.AddWithValue("@Password", this.tbPassword.Text);



                OleDbCommand addInfo = new OleDbCommand("INSERT INTO Registrants (First_Name, Last_Name, Group, Street, City, State, Zip, Phone, Email) VALUES (@First_Name, @Last_Name, @Group, @Street, @City, @State, @Zip, @Phone, @Email)", conn);
                addInfo.Parameters.AddWithValue("@First_Name", this.fname.Text);
                addInfo.Parameters.AddWithValue("@Last_Name", this.lname.Text);
                addInfo.Parameters.AddWithValue("@Group", this.group.Text);
                addInfo.Parameters.AddWithValue("@Street", this.street.Text);
                addInfo.Parameters.AddWithValue("@City", this.city.Text);
                addInfo.Parameters.AddWithValue("@State", this.tbState.Text);
                addInfo.Parameters.AddWithValue("@Zip", this.zip.Text);
                addInfo.Parameters.AddWithValue("@Phone", this.phone.Text);
                addInfo.Parameters.AddWithValue("@Email", this.email.Text);

                conn.Open();
                addCreds.ExecuteNonQuery();
                addInfo.ExecuteNonQuery();
                conn.Close();
                this.Validate();
                this.bindingSource1.EndEdit();
            }
            catch (System.Exception ex)
            {
                //MessageBox.Show(ex.Message);
            }

            if (regHelper == null)
            {
                regHelper = new RegisterController();
            }
            String fname  = this.fname.Text;
            String lname  = this.lname.Text;
            String group  = this.group.Text;
            String street = this.street.Text;
            String state  = this.tbState.Text;
            String city   = this.city.Text;
            String zip    = this.zip.Text;
            String phone  = this.phone.Text;
            String email  = this.email.Text;

            if (group.Equals("Adult"))
            {
                regHelper.createMainRegistrant(fname, lname, Data_Models.Registrant.groupType.Adult, street, city, state, zip, phone, email);
            }
            else
            {
                regHelper.createMainRegistrant(fname, lname, Data_Models.Registrant.groupType.Professional, street, city, state, zip, phone, email);
            }
            regHelper.user          = new Data_Models.RegistrantUser();
            regHelper.user.username = this.tbUsername.Text;
            regHelper.user.password = this.tbPassword.Text;



            this.Hide();
            Interface.registrant_info info = new registrant_info();
            info.Show();
            this.Close();
        }