private void roundButton_Click(object sender, EventArgs e) { Database dataBase = new Database(); // dataBase.connect(); string query = "INSERT INTO Traveler ( PhoneNumber,Traveler_Name,Travler_PassWord,Traveler_EMail,city) VALUES(@PhoneNumber,@Traveler_Name,@Travler_PassWord,@Traveler_EMail,@city) "; SqlCommand command = new SqlCommand(query); // way to input into DataBase command.CommandType = CommandType.Text; // to connection DataBase in tabel Traveler command.Connection = dataBase.connect(); // to input Text in TextBox to Save Sql Server command.Parameters.AddWithValue("@PhoneNumber", metroTextBox5.Text); command.Parameters.AddWithValue("@Traveler_Name", metroTextBox1.Text); command.Parameters.AddWithValue("@Travler_PassWord", metroTextBox2.Text); command.Parameters.AddWithValue("@Traveler_EMail", metroTextBox4.Text); command.Parameters.AddWithValue("@city", metroComboBox1.Text); // command.Parameters.AddWithValue("@date", metroDateTime1.Text); command.ExecuteNonQuery(); Vaild v = new Vaild(); if (metroTextBox2.Text != metroTextBox3.Text) { MetroFramework.MetroMessageBox.Show(this, " Your Password was not Identical ", "Sorry " + metroTextBox1.Text, MessageBoxButtons.OK); } else if (!v.chechMails(metroTextBox4.Text.ToString())) { MetroFramework.MetroMessageBox.Show(this, " Your E-Mail not valid ", " Sorry", MessageBoxButtons.OK); } else if (!v.checkPhoneNum(metroTextBox5.Text.ToString())) { MetroFramework.MetroMessageBox.Show(this, " Your Phone not valid ", " Sorry", MessageBoxButtons.OK); } else { MetroFramework.MetroMessageBox.Show(this, " Your Register was sucessful ", "Welcome " + metroTextBox1.Text, MessageBoxButtons.OK); this.Hide(); Form5 f5 = new Form5(); f5.ShowDialog(); this.Close(); } // dataBase.disconnect(); }
private void Submit_Click(object sender, EventArgs e) { Database dataBase = new Database(); //dataBase.connect(); string query = "INSERT INTO Driver ( driver_username,driver_password,phoneNum,driver_email,driver_adress) VALUES(@driver_username,@driver_password,@phoneNum,@driver_email,@driver_adress) "; SqlCommand command = new SqlCommand(query); // way to input into DataBase command.CommandType = CommandType.Text; // to connection DataBase in tabel Traveler command.Connection = dataBase.connect(); // to input Text in TextBox to Save Sql Server command.Parameters.AddWithValue("@phoneNum", metroTextBox5.Text); command.Parameters.AddWithValue("@driver_username", metroTextBox1.Text); command.Parameters.AddWithValue("@driver_password", metroTextBox2.Text); command.Parameters.AddWithValue("@driver_email", metroTextBox4.Text); command.Parameters.AddWithValue("@driver_adress", metroTextBox7.Text); // command.Parameters.AddWithValue("@date", metroDateTime1.Text); command.ExecuteNonQuery(); //dataBase.connection.Close(); Vaild v = new Vaild(); if (metroTextBox2.Text != metroTextBox3.Text) { MetroFramework.MetroMessageBox.Show(this, " Your Password was not Identical ", "Sorry " + metroTextBox1.Text, MessageBoxButtons.OK); } else if (!v.chechMails(metroTextBox4.Text.ToString())) { MetroFramework.MetroMessageBox.Show(this, " Your E-Mail not valid ", " Sorry", MessageBoxButtons.OK); } else if (!v.checkPhoneNum(metroTextBox5.Text.ToString())) { MetroFramework.MetroMessageBox.Show(this, " Your Phone not valid ", " Sorry", MessageBoxButtons.OK); } else { MetroFramework.MetroMessageBox.Show(this, " Your Register was sucessful ", "Welcome " + metroTextBox1.Text, MessageBoxButtons.OK); } }