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");
}
}
}
