private void button1_Click(object sender, EventArgs e) { ConnectionDB.ExecuteNonQuery($"DELETE FROM APPORDER WHERE idOrder = {textBox1.Text}"); MessageBox.Show("Se ha eliminado la orden con exito."); }
private void button1_Click(object sender, EventArgs e) { ConnectionDB.ExecuteNonQuery($"DELETE FROM ADDRESS WHERE idAddress = {Convert.ToInt32(textBox1.Text)}"); MessageBox.Show("Se ha eliminado al producto con exito"); }
private void button1_Click(object sender, EventArgs e) { try { String user = "", password = "", confirm = ""; var tab = ConnectionDB.ExecuteQuery($"SELECT username FROM APPUSER where username = '******'"); foreach (DataRow dr in tab.Rows) { user = dr[0].ToString(); } if (user.Equals("")) { MessageBox.Show("El usuario no existe"); } else { var tab2 = ConnectionDB.ExecuteQuery($"SELECT password FROM APPUSER where username = '******'"); foreach (DataRow dr in tab2.Rows) { password = dr[0].ToString(); } if (password.Equals(textBox2.Text)) { var tab3 = ConnectionDB.ExecuteQuery( $"SELECT userType FROM APPUSER where username = '******'"); foreach (DataRow dr in tab3.Rows) { confirm = dr[0].ToString(); } if (confirm.Equals("True")) { label1.Visible = false; label3.Visible = false; textBox1.Visible = false; textBox2.Visible = false; button1.Visible = false; button2.Visible = false; current = new Admin(); tableLayoutPanel1.Controls.Add(current, 0, 0); tableLayoutPanel1.SetColumnSpan(current, 2); tableLayoutPanel1.SetRowSpan(current, 4); } else { label1.Visible = false; label3.Visible = false; textBox1.Visible = false; textBox2.Visible = false; button1.Visible = false; button2.Visible = false; current = new Normal(); tableLayoutPanel1.Controls.Add(current, 0, 0); tableLayoutPanel1.SetColumnSpan(current, 2); tableLayoutPanel1.SetRowSpan(current, 4); } } else { throw new WrongPasswordException("Contraseña equivocada"); } } } catch (WrongPasswordException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error"); } }
private void button1_Click(object sender, EventArgs e) { ConnectionDB.ExecuteNonQuery($"DELETE FROM PRODUCT WHERE name = '{textBox1.Text}'"); MessageBox.Show("Se ha eliminado al producto con exito"); }
private void button1_Click(object sender, EventArgs e) { ConnectionDB.ExecuteNonQuery($"UPDATE ADDRESS SET address = '{textBox2.Text}'" + $"WHERE idAddress = {Convert.ToInt32(textBox1.Text)}"); MessageBox.Show("Se ha modificado la dirección con exito"); }