private void button6_Click(object sender, EventArgs e)
{
if (textBox5.Text.Equals(""))
{
MessageBox.Show("Llene todos los campos");
}
else
{
try
{
var qr = $"SELECT idBusiness FROM public.business WHERE" +
$" name = '{comboBox3.GetItemText(comboBox3.SelectedItem)}'";
DataTable dt = ConnectionBD.ExecuteQuery(qr);
int id4 = Convert.ToInt32(dt.Rows[0][0].ToString());
ConnectionBD.ExecuteNonQuery($"INSERT INTO public.product(idBusiness, name)" +
$" VALUES({id4}, '{textBox5.Text}')");
MessageBox.Show("Se ha guardado el producto");
}
catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un error");
}
}
}
private void button3_Click(object sender, EventArgs e)
{
if (textBox2.Text.Equals(""))
{
MessageBox.Show("Llene todos los campos");
}
else
{
try
{
var qr =
$"SELECT idAddress FROM public.address WHERE" +
$" address = '{comboBox2.GetItemText(comboBox2.SelectedItem)}'";
DataTable dt = ConnectionBD.ExecuteQuery(qr);
int id2 = Convert.ToInt32(dt.Rows[0][0].ToString());
//MODIFICAR DIRECCION
ConnectionBD.ExecuteNonQuery(
$"UPDATE public.address SET address = '{textBox2.Text}' WHERE idAddress = {id2}");
MessageBox.Show("Se ha modificado la direccion");
}
catch (Exception ex)
{
MessageBox.Show("ha ocurrido un error");
}
}
}
private void button4_Click(object sender, EventArgs e)
{
try
{
var qr =
$"SELECT idAddress FROM public.address WHERE" +
$" address = '{comboBox4.GetItemText(comboBox4.SelectedItem)}'";
DataTable dt = ConnectionBD.ExecuteQuery(qr);
int id3 = Convert.ToInt32(dt.Rows[0][0].ToString());
var qr2 = $"SELECT idProduct FROM public.product WHERE" +
$" name = '{comboBox3.GetItemText(comboBox3.SelectedItem)}'";
DataTable dt2 = ConnectionBD.ExecuteQuery(qr2);
int id4 = Convert.ToInt32(dt2.Rows[0][0].ToString());
var date = ((DateTime.Now)).ToString(@"yyyy-MM-dd");;
ConnectionBD.ExecuteNonQuery($"INSERT INTO public.appOrder(createDate, idProduct, idAddress)" +
$" VALUES('{date}', {id4}, {id3})");
MessageBox.Show("Su orden ha sido procesada");
}
catch (Exception exception)
{
MessageBox.Show("Ha ocurrido un error!");
}
}
private void button7_Click(object sender, EventArgs e)
{
var qr = $"SELECT idProduct FROM public.product WHERE name" +
$" = '{comboBox4.GetItemText(comboBox4.SelectedItem)}'";
DataTable dt = ConnectionBD.ExecuteQuery(qr);
int id5 = Convert.ToInt32(dt.Rows[0][0].ToString());
ConnectionBD.ExecuteNonQuery($"DELETE FROM public.product WHERE idProduct = {id5}");
MessageBox.Show("El producto ha sido eliminado!");
}
private void button5_Click(object sender, EventArgs e)
{
var qr = $"SELECT idBusiness FROM public.business WHERE" +
$" name = '{comboBox2.GetItemText(comboBox2.SelectedItem)}'";
DataTable dt = ConnectionBD.ExecuteQuery(qr);
int id3 = Convert.ToInt32(dt.Rows[0][0].ToString());
ConnectionBD.ExecuteNonQuery($"DELETE FROM public.business WHERE idBusiness = {id3}");
MessageBox.Show("El negocio ha sido eliminado!");
}
private void button2_Click_1(object sender, EventArgs e)
{
var qr = $"SELECT idUser FROM public.appuser WHERE" +
$" username = '******'";
DataTable dt = ConnectionBD.ExecuteQuery(qr);
int idd = Convert.ToInt32(dt.Rows[0][0].ToString());
ConnectionBD.ExecuteNonQuery($"DELETE FROM public.appuser WHERE idUser = {idd}");
MessageBox.Show("El usuario ha sido eliminado!");
}
private void button2_Click(object sender, EventArgs e)
{
var qr = $"SELECT idAddress FROM public.address WHERE" +
$" address = '{comboBox1.GetItemText(comboBox1.SelectedItem)}'";
DataTable dt = ConnectionBD.ExecuteQuery(qr);
int idd = Convert.ToInt32(dt.Rows[0][0].ToString());
ConnectionBD.ExecuteNonQuery($"DELETE FROM public.address WHERE idAddress = {idd}");
MessageBox.Show("La direccion ha sido eliminada!");
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Equals("") ||
textBox2.Text.Equals(""))
{
MessageBox.Show("Llene todos los campos");
}
else
{
try
{
var sl = $"SELECT * FROM public.appuser WHERE username = '******'";
var dt = ConnectionBD.ExecuteQuery(sl);
if (dt != null)
{
if (checkBox1.Checked)
{
ConnectionBD.ExecuteNonQuery($"INSERT INTO" +
$" public.appuser(fullname, username, password," +
$" userType) VALUES('{textBox1.Text}', '{textBox2.Text}'," +
$" '{textBox2.Text}'," +
$" {true})");
}
else
{
ConnectionBD.ExecuteNonQuery($"INSERT INTO" +
$" public.appuser(fullname, username, password," +
$" userType) VALUES('{textBox1.Text}', '{textBox2.Text}'," +
$" '{textBox2.Text}'," +
$" {false})");
}
MessageBox.Show("El usuario ha sido creado");
}
}
catch (Exception ex)
{
MessageBox.Show("El usuario ya existe...");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Equals(""))
{
MessageBox.Show("Llene todos los campos!");
}
else
{
try
{
ConnectionBD.ExecuteNonQuery($"INSERT INTO public.address(idUser, address)" +
$" VALUES({id}, '{textBox1.Text}')");
MessageBox.Show("La direccion se ha guardado!");
}
catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un error!");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Equals("") ||
textBox2.Text.Equals("") ||
textBox3.Text.Equals("") ||
textBox4.Text.Equals(""))
{
MessageBox.Show("Llene todos los campos");
}
else
{
try
{
string query =
$"SELECT * FROM public.appuser WHERE username='******' AND password='******'";
var dt = ConnectionBD.ExecuteQuery(query);
if (dt.Rows.Count == 1)
{
if (textBox3.Text.Equals(textBox4.Text))
{
ConnectionBD.ExecuteNonQuery($"UPDATE public.appuser SET password = '******' WHERE" +
$" username = '******'");
MessageBox.Show("Se ha actualizado la contraseña");
Hide();
new Form1().Show();
}
}
else
{
MessageBox.Show("Usuario y/o Contraseña Incorrecta");
}
}
catch (Exception exception)
{
MessageBox.Show("Ha ocurrido un error!");
}
}
}
private void button4_Click(object sender, EventArgs e)
{
if (textBox3.Text.Equals("") ||
textBox4.Text.Equals(""))
{
MessageBox.Show("Llene todos los campos");
}
else
{
try
{
ConnectionBD.ExecuteNonQuery($"INSERT INTO public.business(name, description)" +
$" VALUES('{textBox3.Text}', '{textBox4.Text}')");
MessageBox.Show("Se ha creado el negocio");
}
catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un error");
}
}
}
