//Update private void actualizarControles() { // Realizar consulta a la base de datos List <APPUSER> lista = APPUSERDAO.getList(); List <BUSINESS> list = BUSINESSDAO.getList(); List <PRODUCT> listado = PRODUCTDAO.getList(); List <APPORDER> listi = APPORDERDAO.getList(); List <ADDRESS> listo = ADDRESSDAO.getList(); // Tabla (data grid view) dvgUser.DataSource = null; dvgUser.DataSource = lista; // Menu desplegable (combo box) //txtName.DataSource = null; cmbUsername.DataSource = null; cmbUsername.ValueMember = "password"; cmbUsername.DisplayMember = "username"; cmbUsername.DataSource = lista; cmbUsernameId.DataSource = null; cmbUsernameId.ValueMember = "password"; cmbUsernameId.DisplayMember = "username"; cmbUsernameId.DataSource = lista; //cmbUsuario.ValueMember = "contrasena"; //cmbUsuario.DisplayMember = "usuario"; //cmbUsuario.DataSource = lista; // Grafico con estadisticas //poblarGrafico(); dgvBusiness.DataSource = null; dgvBusiness.DataSource = list; cmbBusiness.DataSource = null; cmbBusiness.ValueMember = "businessname"; cmbBusiness.DisplayMember = "businessname"; cmbBusiness.DataSource = list; cmbUsernameAddress.DataSource = null; cmbUsernameAddress.ValueMember = "password"; cmbUsernameAddress.DisplayMember = "username"; cmbUsernameAddress.DataSource = lista; dgvProducts.DataSource = null; dgvProducts.DataSource = listado; dgvProductsOptions.DataSource = null; dgvProductsOptions.DataSource = listado; dgvOrders.DataSource = null; dgvOrders.DataSource = listi; dgvAllOrders.DataSource = null; dgvAllOrders.DataSource = listi; dgvAddressModify.DataSource = null; dgvAddressModify.DataSource = listo; }
//Add Business private void btnAddBusiness_Click(object sender, EventArgs e) { try { BUSINESSDAO.CreateBusiness(txtBusinessName.Text, txtDescription.Text); MessageBox.Show("Business added to HUGO!", "HUGO", MessageBoxButtons.OK, MessageBoxIcon.Information); actualizarControles(); } catch (Exception) { MessageBox.Show("Your Business already exists"); } }
//Delete Business private void button1_Click(object sender, EventArgs e) { try { if (MessageBox.Show("Are you sure you want to delete " + txtBusinessName.Text + "?", "HUGO", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { BUSINESSDAO.delete(txtBusinessName.Text); MessageBox.Show("Delete success!", "HUGO", MessageBoxButtons.OK, MessageBoxIcon.Information); actualizarControles(); } } catch (Exception) { MessageBox.Show("You can't delete a Business with products"); } }