private void frmUsuario_Load(object sender, EventArgs e)
{
cmbAddress.DataSource = null;
cmbAddress.ValueMember = "idAddress";
cmbAddress.DisplayMember = "address";
cmbAddress.DataSource = AddressDAO.GetLista();
dgAddress.DataSource = null;
dgAddress.DataSource = AddressDAO.GetLista();
cmbProductos.DataSource = null;
cmbProductos.ValueMember = "idProduct";
cmbProductos.DisplayMember = "name";
cmbProductos.DataSource = ProducDAO.GetLista();
cmbDirecciones.DataSource = null;
cmbDirecciones.ValueMember = "idAddress";
cmbDirecciones.DisplayMember = "address";
cmbDirecciones.DataSource = AddressDAO.GetLista();
dgOrders.DataSource = null;
dgOrders.DataSource = AppOrderDAO.GetLista();
cmbOrders.DataSource = null;
cmbOrders.ValueMember = "idOrder";
cmbOrders.DisplayMember = "product";
cmbOrders.DataSource = AppOrderDAO.GetLista();
}
private void frmPrincipal_Load(object sender, EventArgs e)
{
cmbUsuarios.DataSource = null;
cmbUsuarios.ValueMember = "idUser";
cmbUsuarios.DisplayMember = "username";
cmbUsuarios.DataSource = AppUserDAO.GetLista();
cmbNegociosProd.DataSource = null;
cmbNegociosProd.ValueMember = "idBusiness";
cmbNegociosProd.DisplayMember = "name";
cmbNegociosProd.DataSource = BusinessDAO.GetLista();
cmbNegocios.DataSource = null;
cmbNegocios.ValueMember = "idBusiness";
cmbNegocios.DisplayMember = "name";
cmbNegocios.DataSource = BusinessDAO.GetLista();
cmbProds.DataSource = null;
cmbProds.ValueMember = "idProduct";
cmbProds.DisplayMember = "name";
cmbProds.DataSource = ProducDAO.GetProdsNeg();
dgUsuarios.DataSource = null;
dgUsuarios.DataSource = AppUserDAO.GetLista();
dgNegocios.DataSource = null;
dgNegocios.DataSource = BusinessDAO.GetLista();
}
private void btnAddProdtoNeg_Click(object sender, EventArgs e)
{
try
{
if (txtNuevoProd.Text.Length >= 5)
{
int idneg = Convert.ToInt32(cmbNegocios.SelectedValue.ToString());
ProducDAO.CrearProd(idneg, txtNuevoProd.Text);
MessageBox.Show("Producto agregado",
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtNuevoProd.Clear();
actualizarDatos();
}
else
{
MessageBox.Show("Verifique que los datos sean válidos",
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception)
{
MessageBox.Show("Verifique que los datos sean válidos",
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
void actualizarDatos()
{
cmbAddress.DataSource = AddressDAO.GetLista();
dgAddress.DataSource = AddressDAO.GetLista();
cmbProductos.DataSource = ProducDAO.GetLista();
cmbDirecciones.DataSource = AddressDAO.GetLista();
dgOrders.DataSource = AppOrderDAO.GetLista();
cmbOrders.DataSource = AppOrderDAO.GetLista();
}
void actualizarDatos()
{
cmbUsuarios.DataSource = AppUserDAO.GetLista();
dgUsuarios.DataSource = AppUserDAO.GetLista();
cmbNegociosProd.DataSource = BusinessDAO.GetLista();
dgNegocios.DataSource = BusinessDAO.GetLista();
cmbNegocios.DataSource = BusinessDAO.GetLista();
dgOrdenes.DataSource = AppOrderDAO.GetLista();
cmbProds.DataSource = ProducDAO.GetProdsNeg();
}
private void btnDeleteProd_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("¿Seguro que desea eliminar el producto?",
"Hugo App", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
;
}
{
int id = Convert.ToInt32(cmbProds.SelectedValue.ToString());
ProducDAO.EliminarProd(id);
MessageBox.Show("Se eliminó el producto",
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Information);
actualizarDatos();
}
}
catch (Exception exception)
{
Console.WriteLine(exception);
throw;
}
}
