public void submit_click(object sender, EventArgs e) { try { string radioButtons = ""; con.Open(); if (radioButton1.Checked) { radioButtons = "INSERT INTO DataBaseName(plan)VALUES ('Basic')"; } if (radioButton2.Checked) { radioButtons = "INSERT INTO DataBaseName(plan)VALUES ('Standard')"; } if (radioButton3.Checked) { radioButtons = "INSERT INTO DataBaseName(plan)VALUES ('Premium')"; } MySqlCommand cmd = new MySqlCommand(radioButtons, con); cmd.ExecuteNonQuery(); con.Close(); var answer = MessageBox.Show("Are you sure the filled in Information is Accurate and you have selected desired plan ?", "", MessageBoxButtons.YesNo); if (answer.ToString().ToLower().Equals("yes")) { MessageBox.Show("Customer Added Successfully"); HomeForm homeForm = new HomeForm(); homeForm.Show(); this.Close(); } else { MessageBox.Show("Please reselect"); } } catch (Exception ex) { MessageBox.Show("error"); } }
public void login(object sender, EventArgs e) { try { //checking if user info entered in password and username boxes matches an entry in the database string conString = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=\"F: \\UNIVERSITY\\SEMESTER 2\\.NET WITH C#\\PROJECT\\github connected\\TDMS\\Database1.mdf\";"; string sql = "SELECT * FROM login where username= '******' and password= '******'"; SqlConnection con = new SqlConnection(conString); int j = 0; con.Open(); SqlCommand cmd = new SqlCommand(sql, con); cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter dataAdapt = new SqlDataAdapter(cmd); dataAdapt.Fill(dt); j = dt.Rows.Count; //moves to the homepage if correct, prints error message if incorrect if (j == 0) { invalidUserLabel.Text = "Invalid user or password"; } else { this.Hide(); HomeForm homeForm = new HomeForm(); homeForm.Show(); } con.Close(); } catch (Exception ex) { MessageBox.Show("error:" + ex.Message); } finally { this.Hide(); HomeForm homeForm = new HomeForm(); homeForm.Show(); } }