private void Submit_Click(object sender, EventArgs e)
{
bool x = true;
String sql = "Data Source=DESKTOP-8TO2TNB;Initial Catalog=car_sales;Integrated Security=True";
SqlConnection con = new SqlConnection(sql);
con.Open();
String query = "SELECT *FROM customer_inf";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if (FirstName.Text == reader.GetString(1))
{
MessageBox.Show("Enter another name");
x = false;
}
}
reader.Close();
cmd.ExecuteNonQuery();
if (x == true)
{
sql = "Data Source=DESKTOP-8TO2TNB;Initial Catalog=car_sales;Integrated Security=True";
con = new SqlConnection(sql);
con.Open();
query = "INSERT INTO customer_inf (name , passward , address , email , phone , gender ) VALUES (@name , @passward , @address , @email , @phone , @gender )";
cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@name", FirstName.Text);
cmd.Parameters.AddWithValue("@passward", Password.Text);
cmd.Parameters.AddWithValue("@address", textBox1.Text);
cmd.Parameters.AddWithValue("@email", E_mail.Text);
cmd.Parameters.AddWithValue("@phone", textBox2.Text);
if (Male.TabStop == true)
{
cmd.Parameters.AddWithValue("@gender", "male");
}
else
{
cmd.Parameters.AddWithValue("@gender", "female");
}
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Data saved successfuly");
test.Form10 f = new test.Form10();
f.Show();
this.Close();
}
}
private void Submit_Login_Click(object sender, EventArgs e)
{
bool visit = false;
String sql = "Data Source=DESKTOP-8TO2TNB;Initial Catalog=car_sales;Integrated Security=True";
SqlConnection con = new SqlConnection(sql);
con.Open();
String query = "SELECT name,passward,customer_id FROM customer_inf";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if (textBox1.Text == reader.GetString(0))
{
visit = true;
if (textBox2.Text == reader.GetString(1))
{
test.Form10 f = new test.Form10(reader.GetInt32(2));
f.Show();
this.Close();
}
else
{
MessageBox.Show("Wrong Passward");
}
}
}
if (visit == false)
{
MessageBox.Show("Wrong Name");
}
// cmd.ExecuteNonQuery();
con.Close();
}
