public static void CreateBusiness(Business business)
{
String querySql = $"INSERT INTO BUSINESS(name, description) VALUES('{business.Name}'," +
$"'{business.Description}');";
ConnectionDB.ExecuteNonQuery(querySql);
}
private void buttonAdd_Click(object sender, EventArgs e)
{
ConnectionDB.ExecuteNonQuery($"insert into address(iduser, address) values({iduser}, '{textBox1.Text}')");
MessageBox.Show("¡Se ha agregado correctamente!",
"Hugo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
actualizar();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Equals("") ||
textBox2.Equals(""))
{
MessageBox.Show("No puede dejar los campos vacios!");
}
else
{
try
{
ConnectionDB.ExecuteNonQuery(
$"INSERT INTO BUSINESS(name, description) VALUES(" +
$"'{textBox1.Text}'," +
$"'{textBox2.Text}')");
MessageBox.Show("Negocio Añadido");
}
catch (Exception esg)
{
MessageBox.Show("Ha ocurrido un error");
}
}
}
private void btnAddBuisness_Click(object sender, EventArgs e)
{
string name = txtNameBuisness.Text;
string description = txtdescripcion.Text;
int iduser = 0;
string query =
$"INSERT INTO BUSINESS(name, description) VALUES ('{name}', '{description}');";
try
{
if (txtNameBuisness.Text.Equals("") || txtdescripcion.Text.Equals(""))
{
MessageBox.Show("No se permiten campos vacios.");
}
else if (txtNameBuisness.Text.Length < 3 || txtdescripcion.Text.Length < 10)
{
throw new UnreachedMinimumNumberOfCharacters("No alcanzó los requerimientos minimos." +
"\nLongitud minima para el nombre de la empresa: 3 caracteres." +
"\nLongitud minima para la descripcion del negocio: 10 caracteres.");
}
else
{
ConnectionDB.ExecuteNonQuery(query);
MessageBox.Show("Negocion agregado con exito!!");
}
}catch (UnreachedMinimumNumberOfCharacters exc) {
MessageBox.Show("Intente nuevamente.");
}catch (Exception ex) {
MessageBox.Show("Intente nuevamente.");
}
}
public static void DeleteProduct(Product product, int idBusiness)
{
String querySql = $"DELETE FROM PRODUCT WHERE name = '{product.Name}' AND idbusiness = {idBusiness} " +
$"AND idproduct = {product.IdProduct};";
ConnectionDB.ExecuteNonQuery(querySql);
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Equals("") ||
textBox2.Equals(""))
{
MessageBox.Show("No puede dejar los campos vacios!");
}
else
{
try
{
ConnectionDB.ExecuteNonQuery($"INSERT INTO APPUSER(fullname, username, password, userType) VALUES(" +
$"'{textBox1.Text}'," +
$"'{textBox2.Text}'," +
$"'{textBox2.Text}'," +
$"{comboBox1.SelectedItem})");
MessageBox.Show("USUARIO ANADIDO");
}
catch (Exception esg)
{
MessageBox.Show("Ha ocurrido un error");
}
}
}
public static void UpdateAddress(Address address)
{
String querySql = $"UPDATE ADDRESS SET address = '{address.SAddress}' WHERE idaddress = " +
$"{address.IdAddress};";
ConnectionDB.ExecuteNonQuery(querySql);
}
private void button3_Click(object sender, EventArgs e)
{
string Location = txtNewLocation.Text;
int iduser = 0;
string query =
$"INSERT INTO ADDRESS(idUser, address) INSERT INTO ADDRESS({iduser}, '{Location}')";
try
{
if (txtNewLocation.Text.Equals(""))
{
MessageBox.Show("No se permiten campos vacios.");
}
else if (txtNewLocation.Text.Length < 6)
{
throw new UnreachedMinimumNumberOfCharacters("No alcanzó los requerimientos minimos." +
"\nLongitud minima para la direccion: 6 caracteres.");
}
else
{
ConnectionDB.ExecuteNonQuery(query);
MessageBox.Show("Ubicacion agregada exitosamente!!");
}
}catch (UnreachedMinimumNumberOfCharacters exc) {
MessageBox.Show("Intente nuevamente.");
}catch (Exception ex) {
MessageBox.Show("Intente nuevamente.");
}
}
public static void DeleteAddress(Address address)
{
String querySql = $"DELETE FROM ADDRESS WHERE idaddress = {address.IdAddress} " +
$"AND iduser = {address.IdUser}";
ConnectionDB.ExecuteNonQuery(querySql);
}
private void button1_Click(object sender, EventArgs e)
{
bool type = false;
try
{
if (textBox1.Text.Equals("") || textBox2.Text.Equals(""))
{
MessageBox.Show("No se pueden dejar campos vacíos");
}
else
{
if (radioButton1.Checked)
{
type = false;
}
else if (radioButton2.Checked)
{
type = true;
}
string query = $"INSERT INTO APPUSER (fullname, username, password, usertype) " +
$"VALUES ('{textBox1.Text}', '{textBox2.Text}', '{textBox2.Text}', {type}); ";
ConnectionDB.ExecuteNonQuery(query);
MessageBox.Show("Se ha registrado al usuario");
}
}
catch (Exception exception)
{
MessageBox.Show("Error");
}
}
public static void CreateUser(User user)
{
String querySql = $"INSERT INTO APPUSER(fullname,username,password,usertype)" +
$"VALUES ('{user.Fullname}','{user.Username}','{user.Password}', {user.UserType});";
ConnectionDB.ExecuteNonQuery(querySql);
}
private void btnCreateUser_Click(object sender, EventArgs e)
{
string Fullname = txtFullName.Text;
string Username = txtUsername.Text;
string query =
$"INSERT INTO APPUSER(fullname, username, password, userType) VALUES('{Fullname}', '{Username}', '{Username}', false);";
try
{
if (txtUsername.Text.Equals("") || txtFullName.Text.Equals(""))
{
MessageBox.Show("No se permiten campos vacios.");
}
else if (txtFullName.Text.Length < 10 || txtUsername.Text.Length < 5)
{
throw new UnreachedMinimumNumberOfCharacters("No alcanzó los requerimientos minimos." +
"\nLongitud minima para el nombre: 10 caracteres." +
"\nLongitud minima para el nombre de usuario: 5 caracteres.");
}
else
{
ConnectionDB.ExecuteNonQuery(query);
MessageBox.Show("Cuenta creada exitosamente, volviendo a pantalla principal." +
"\n Recordando: su clave es igual a su nombre de usuario.");
}
}catch (UnreachedMinimumNumberOfCharacters exc) {
MessageBox.Show("Intente nuevamente.");
}catch (Exception ex) {
MessageBox.Show("Intente nuevamente.");
}
}
public static void CreateOrder(Order order)
{
String querySql = $"INSERT INTO APPORDER(createdate,idproduct,idaddress) VALUES " +
$"('{order.CreateDate.ToString("d")}',{order.IdProduct}," +
$"{order.IdAddress});";
ConnectionDB.ExecuteNonQuery(querySql);
}
public static void DeleteOrder(int userID, int orderID)
{
String query = $"DELETE from apporder where idorder = {orderID} AND idaddress IN " +
$"(SELECT idaddress FROM ADDRESS WHERE iduser = "******"(SELECT iduser FROM APPUSER WHERE iduser = {userID}));";
ConnectionDB.ExecuteNonQuery(query);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
ConnectionDB.ExecuteNonQuery($"DELETE FROM APPORDER WHERE idOrder = {comboBox2.SelectedItem}");
MessageBox.Show("Orden Eliminada con exito");
}
catch (Exception esg)
{
MessageBox.Show("Ha ocurrido un error");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
ConnectionDB.ExecuteNonQuery($"DELETE FROM ADDRESS WHERE idAddress = {comboBox2.SelectedItem}");
MessageBox.Show("Direccion Eliminada");
}
catch (Exception esg)
{
MessageBox.Show("Ha ocurrido un error");
}
}
private void Eliminar_Click_1(object sender, EventArgs e)
{
try
{
ConnectionDB.ExecuteNonQuery($"DELETE FROM BUSINESS WHERE idBusiness = {comboBox1.SelectedItem}");
MessageBox.Show("Negocio Eliminado");
}
catch (Exception esg)
{
MessageBox.Show("Ha cocurrido un problema");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
ConnectionDB.ExecuteNonQuery($"DELETE FROM PRODUCT WHERE idbusiness={comboBox1.SelectedItem} AND " +
$"name='{comboBox2.SelectedItem}'");
MessageBox.Show("Producto Eliminado");
}
catch (Exception esg)
{
MessageBox.Show("Ha cocurrido un problema");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
ConnectionDB.ExecuteNonQuery(
$"UPDATE ADDRESS SET address = 'nueva' WHERE idAddress = {comboBox1.SelectedItem}");
MessageBox.Show("Direccion Modificada");
}
catch (Exception esg)
{
MessageBox.Show("Ha ocurrido un error");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
ConnectionDB.ExecuteNonQuery($"DELETE FROM APPUSER WHERE iduser = '******'");
MessageBox.Show("Usuario eliminado correctamente");
}
catch (Exception exception)
{
MessageBox.Show("Error");
}
}
private void button4_Click(object sender, EventArgs e)
{
try
{
ConnectionDB.ExecuteNonQuery($"INSERT INTO ADDRESS(iduser, address) VALUES ('{LogUsu.Iduser}', '{textBox1.Text}')");
PopulateControls3();
MessageBox.Show("Dirección agregada");
}
catch
{
MessageBox.Show("No se ha podido guardar la dirección");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string nonQuery = $"DELETE FROM APPUSER WHERE username='******'";
ConnectionDB.ExecuteNonQuery(nonQuery);
MessageBox.Show("Usuario Eliminado");
}
catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un error!");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
DateTime f = DateTime.Now;
ConnectionDB.ExecuteNonQuery($"INSERT INTO APPORDER(createDate, idProduct, idAddress) VALUES('{f}', '{listBox2.SelectedValue}', '{comboBox1.SelectedValue}'); ");
ActGrid();
MessageBox.Show("Orden agregada");
}
catch (Exception ex)
{
MessageBox.Show("No se ha podido procesar su orden");
}
}
private void button3_Click(object sender, EventArgs e)
{
try
{
ConnectionDB.ExecuteNonQuery($"DELETE FROM PRODUCT WHERE idProduct = '{comboBox2.SelectedValue}'");
MessageBox.Show("Producto eliminado correctamente");
PopulateControls2();
}
catch (Exception exception)
{
MessageBox.Show("Error");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
ConnectionDB.ExecuteNonQuery($"delete from apporder where idorder ='{ordenes.SelectedItem.ToString()}'");
MessageBox.Show($"¡Orden eliminada!", "Hugo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
actualizarComponentes();
}
catch (Exception exception)
{
MessageBox.Show("¡Ha ocurrido un error!",
"Hugo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
ConnectionDB.ExecuteNonQuery("INSERT INTO PRODUCT(idBusiness, name)" +
$"VALUES({comboBox1.SelectedItem}, '{textBox2.Text}')");
MessageBox.Show("Producto Añadido");
}
catch (Exception esg)
{
MessageBox.Show("Ha ocurrido un error");
}
}
private void buttonDelete_Click(object sender, EventArgs e)
{
try
{
ConnectionDB.ExecuteNonQuery($"delete from address where iduser = {iduser} and address = '{comboBoxD.SelectedItem.ToString()}'");
MessageBox.Show("¡Se ha eliminado correctamente!",
"Hugo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
actualizar();
}
catch (Exception exception)
{
MessageBox.Show("¡Ha ocurrido un error!",
"Hugo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
ConnectionDB.ExecuteNonQuery($"DELETE FROM BUSINESS WHERE idBusiness = {comboBox1.SelectedValue}");
MessageBox.Show("Negocio eliminado correctamente");
}
catch (Exception exception)
{
MessageBox.Show("Error");
}
ActGrid();
}
private void buttonAdd_Click(object sender, EventArgs e)
{
try
{
ConnectionDB.ExecuteNonQuery($"insert into business(name, description) values('{textBoxName.Text}', '{textBoxDesc.Text}')");
MessageBox.Show("¡Negocio añadido correctamente!",
"Hugo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
actucombobox();
}
catch (Exception exception)
{
MessageBox.Show("¡Ha ocurrido un error!",
"Hugo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void buttonAddP_Click(object sender, EventArgs e)
{
try
{
int id = idbusi(comboBoxnegocios.SelectedItem.ToString());
ConnectionDB.ExecuteNonQuery($"insert into product(idBusiness, name) values({id}, '{textBoxNameP.Text}')");
MessageBox.Show("¡Producto agregado exitosamente!",
"Hugo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
actucombobox();
}
catch (Exception exception)
{
MessageBox.Show("¡Ha ocurrido un error!",
"Hugo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}