private void btnDelete_Click(object sender, EventArgs e)
{
try
{
List <AppOrder> list = AppOrderDAO.getAppOrders();
byte cont = 0;
foreach (var order in list)
{
if ((int)nudidOrder.Value == order.idOrder)
{
cont++;
}
}
if (cont > 0)
{
AppOrderDAO.DeleteOrder((int)nudidOrder.Value);
MessageBox.Show("Orden eliminada exitosamente.", "Hugo App",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
Refresh();
}
else
{
MessageBox.Show("El ID de orden ingresado no existe");
}
}
catch (Exception ex)
{
MessageBox.Show("No se pudo eliminar la orden.", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void btnAddOrder_Click(object sender, EventArgs e)
{
try
{
Adress ad = (Adress)cmbAdress.SelectedItem;
Product pro = (Product)cmbProducts.SelectedItem;
AppOrderDAO.InsertOrder(ad, pro);
MessageBox.Show("Orden agregada exitosamente.", "Hugo App",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
Refresh();
}
catch (Exception ex)
{
MessageBox.Show("La orden no pudo ser agregada.", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void Refresh()
{
cmbAdresses.DataSource = null;
cmbAdresses.ValueMember = nameof(Adress.idAdress);
cmbAdresses.DisplayMember = nameof(Adress.adress);
cmbAdresses.DataSource = AddressDAO.getAdresses();
cmbBusiness.DataSource = null;
cmbBusiness.ValueMember = "idBusiness";
cmbBusiness.DisplayMember = "name";
cmbBusiness.DataSource = BusinessDAO.getBusinesses();
cmbAdress.DataSource = null;
cmbAdress.ValueMember = nameof(Adress.idAdress);
cmbAdress.DisplayMember = nameof(Adress.adress);
cmbAdress.DataSource = AddressDAO.getAdresses();
dgvAdresses.DataSource = AddressDAO.AddressesFromUser(user);
dgvOrders.DataSource = AppOrderDAO.ViewUserOrders(user);
CmbProductUpdate();
}
private void NormalUser_Load(object sender, EventArgs e)
{
dgvAdresses.DataSource = AddressDAO.AddressesFromUser(user);
dgvOrders.DataSource = AppOrderDAO.ViewUserOrders(user);
cmbAdresses.DataSource = null;
cmbAdresses.ValueMember = nameof(Adress.idAdress);
cmbAdresses.DisplayMember = nameof(Adress.adress);
cmbAdresses.DataSource = AddressDAO.getAdresses();
cmbBusiness.DataSource = null;
cmbBusiness.ValueMember = "idBusiness";
cmbBusiness.DisplayMember = "name";
cmbBusiness.DataSource = BusinessDAO.getBusinesses();
cmbAdress.DataSource = null;
cmbAdress.ValueMember = nameof(Adress.idAdress);
cmbAdress.DisplayMember = nameof(Adress.adress);
cmbAdress.DataSource = AddressDAO.getAdresses();
CmbProductUpdate();
}