//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 Product private void btnAddProduct_Click(object sender, EventArgs e) { try { PRODUCTDAO.CreateProduct(txtProductName.Text, cmbBusiness.Text); MessageBox.Show("Product added to HUGO!", "HUGO", MessageBoxButtons.OK, MessageBoxIcon.Information); actualizarControles(); } catch (Exception) { MessageBox.Show("Your product already exists"); } }
//Delete Products private void button2_Click(object sender, EventArgs e) { try { if (MessageBox.Show("Are you sure you want to delete " + txtProductName.Text + "?", "HUGO", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { PRODUCTDAO.delete(txtProductName.Text); MessageBox.Show("Delete success!", "HUGO", MessageBoxButtons.OK, MessageBoxIcon.Information); actualizarControles(); } } catch (Exception) { MessageBox.Show("You product did not exists"); } }