private void btnSignUp_Click(object sender, EventArgs e) { string errorString = ""; bool showMessage = false; isFilled = new bool[7]; if (txtRptPassword.Text != typedPassword) { errorString += "The given password doesn't match with the previous one.\n"; isFilled[0] = false; showMessage = true; } if (txtCity.Text == "" || txtCountry.Text == "" || txtEmail.Text == "" || txtPhoneNumber.Text == "" || txtState.Text == "" || txtZipCode.Text == "") { errorString += "All fields must be filled in order to create an account!"; showMessage = true; } if (showMessage) { MessageBox.Show(errorString); } else { DBSteamDataSet db = new DBSteamDataSet(); DBSteamDataSetTableAdapters.UserTableAdapter userTableAdapter = new DBSteamDataSetTableAdapters.UserTableAdapter(); DBSteamDataSetTableAdapters.AddressTableAdapter addressTableAdapter = new DBSteamDataSetTableAdapters.AddressTableAdapter(); DBSteamDataSet.UserRow newUserRow = db.User.NewUserRow(); userTableAdapter.Insert(txtEmail.Text, 0, typedPassword, txtPhoneNumber.Text, 0, typedUsername); SqlDataReader MineReader = DatabaseAccess.getDataFromDB("SELECT ID FROM [User] WHERE userName LIKE '" + typedUsername + "'"); int id = 0; if (MineReader.Read()) { id = Convert.ToInt32(MineReader["ID"].ToString()); DBSteamDataSet.AddressRow newAddressRow = db.Address.NewAddressRow(); addressTableAdapter.Insert(id, txtCity.Text, txtCountry.Text, txtState.Text, txtZipCode.Text, "default"); } MessageBox.Show("Account successfully created!"); this.Close(); } }
private void btnSignUp_Click(object sender, EventArgs e) { string errorString = ""; bool showMessage = false; isFilled = new bool[7]; if (txtRptPassword.Text != typedPassword) { errorString += "The given password doesn't match with the previous one.\n"; isFilled[0] = false; showMessage = true; } if (txtCity.Text == "" || txtCountry.Text == "" || txtEmail.Text == "" || txtPhoneNumber.Text == "" || txtState.Text == "" || txtZipCode.Text == "") { errorString += "All fields must be filled in order to create an account!"; showMessage = true; } if (showMessage) MessageBox.Show(errorString); else { DBSteamDataSet db = new DBSteamDataSet(); DBSteamDataSetTableAdapters.UserTableAdapter userTableAdapter = new DBSteamDataSetTableAdapters.UserTableAdapter(); DBSteamDataSetTableAdapters.AddressTableAdapter addressTableAdapter = new DBSteamDataSetTableAdapters.AddressTableAdapter(); DBSteamDataSet.UserRow newUserRow = db.User.NewUserRow(); userTableAdapter.Insert(txtEmail.Text, 0, typedPassword, txtPhoneNumber.Text, 0, typedUsername); SqlDataReader MineReader = DatabaseAccess.getDataFromDB("SELECT ID FROM [User] WHERE userName LIKE '" + typedUsername + "'"); int id = 0; if (MineReader.Read()) { id = Convert.ToInt32(MineReader["ID"].ToString()); DBSteamDataSet.AddressRow newAddressRow = db.Address.NewAddressRow(); addressTableAdapter.Insert(id,txtCity.Text,txtCountry.Text,txtState.Text,txtZipCode.Text,"default"); } MessageBox.Show("Account successfully created!"); this.Close(); } }