private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Equals("") || textBox2.Text.Equals("")) { MessageBox.Show("No se pueden dejar campos vacíos"); } else { try { string direccion = "SELECT idAddress FROM address " + $"WHERE address = '{comboBox1.SelectedItem}'"; ConnectionDB.ExecuteNonQuery("INSERT INTO apporder(createDate, idProduct, idAddress) " + "VALUES( " + $"CURRENT_DATE, " + $"'{textBox2.Text}'," + $"'{direccion}')"); MessageBox.Show("Agregado exitosamente"); } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error"); } } }
private void button2_Click(object sender, EventArgs e) { var query = ConnectionDB.executeQuery($"SELECT idBusiness FROM business WHERE name = '{comboBox2.SelectedItem}'"); var dr = query.Rows[0][0]; if (textBox2.Text.Equals("")) { MessageBox.Show("No se pueden dejar campos vacíos"); } else { try { ConnectionDB.ExecuteNonQuery("INSERT INTO product(idBusiness, name)" + "VALUES(" + $"{dr}," + $"'{textBox2.Text}')"); MessageBox.Show("Agregado exitosamente"); } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error"); } } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Equals("")) { MessageBox.Show("No se pueden dejar campos vacíos"); } else { try { ConnectionDB.ExecuteNonQuery($"DELETE FROM product WHERE idProduct = {idProduct}"); MessageBox.Show("Eliminado exitosamente"); } catch (Exception ex) { MessageBox.Show("Se ha producido un error"); } } }
private void button2_Click(object sender, EventArgs e) { if (textBox3.Text.Equals("") || textBox4.Text.Equals("")) { MessageBox.Show("No se pueden dejar campos vacíos"); } else { try { ConnectionDB.ExecuteNonQuery("INSERT INTO business(name, description) VALUES( " + $"'{textBox3.Text}'," + $"'{textBox4.Text}')"); MessageBox.Show("Agregado exitosamente"); } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error"); } } }
private void button2_Click(object sender, EventArgs e) { if (textBox5.Text.Equals("") || textBox4.Text.Equals("")) { MessageBox.Show("No se pueden dejar campos vacíos"); } else { try { bool tipouser = false; if (comboBox2.SelectedIndex == 0) { tipouser = true; } else { tipouser = false; } ConnectionDB.ExecuteNonQuery($"INSERT INTO appuser(fullname, username, password, userType) " + $"VALUES( " + $"'{textBox4.Text}'," + $"'{textBox5.Text}'," + $"'{textBox5.Text}'," + $"{tipouser})"); MessageBox.Show("Agregado exitosamente"); } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error"); } } }