private void btnAddAddres_Click(object sender, EventArgs e)
{
if (txtAddAddress.Text.Equals(""))
{
MessageBox.Show("Direccion agregada con exito", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else
{
ADDRESS address = new ADDRESS();
address.idUser = usuario.idUser;
address.address = txtAddAddress.Text;
try
{
ConsultaADDRESS.Add(address);
this.Close();
MessageBox.Show("Acceso concedido, Binevenido", "Confirmacion", MessageBoxButtons.OK,
MessageBoxIcon.Asterisk);
}
catch (Exception exception)
{
MessageBox.Show("Ha ocurrido un error", "ERROR",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnDeleteAddress_Click(object sender, EventArgs e)
{
string dir = (string)cmbAddress.SelectedItem;
ADDRESS ad = new ADDRESS();
foreach (var d in list)
{
if (d.address.Equals(dir))
{
ad.address = d.address;
ad.idAddress = d.idAddress;
ad.idUser = d.idUser;
}
}
try
{
string sql = "DELETE FROM ADDRESS WHERE idAddress = " + ad.idAddress;
ConnectionDB.ExecuteNonQuery(sql);
this.Close();
MessageBox.Show("Direccion eliminada con exito", "Confirmacion", MessageBoxButtons.OK,
MessageBoxIcon.Asterisk);
}
catch (Exception exception)
{
MessageBox.Show("Ha ocurrido un error", "ERROR",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnAddOrder_Click(object sender, EventArgs e)
{
string dir = (string)cmbSAddress.SelectedItem;
ADDRESS ad = new ADDRESS();
foreach (var d in list)
{
if (d.address.Equals(dir))
{
ad.address = d.address;
ad.idAddress = d.idAddress;
ad.idUser = d.idUser;
}
}
string dira = (string)cmbProducts.SelectedItem;
PRODUCT ada = new PRODUCT();
foreach (var d in lista)
{
if (d.name.Equals(dira))
{
ada.idProduct = d.idProduct;
ada.idBusiness = d.idBusiness;
ada.name = d.name;
}
}
APPORDER NOrder = new APPORDER();
DateTime today = DateTime.Today;
string fecha = today.ToString("yyyy/MM/dd");
NOrder.createDate = DateTime.Today;
NOrder.idProduct = ada.idProduct;
NOrder.idAddress = ad.idAddress;
try
{
string sql = String.Format("INSERT INTO APPORDER(createDate, idProduct, idAddress) " +
"VALUES('{0}', {1}, {2});", fecha, NOrder.idProduct, NOrder.idAddress);
ConnectionDB.ExecuteNonQuery(sql);
this.Close();
MessageBox.Show("Orden agregada exitosamente", "Confirmacion", MessageBoxButtons.OK,
MessageBoxIcon.Asterisk);
}
catch (Exception exception)
{
MessageBox.Show("Ha ocurrido un error", "ERROR",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnUpdateAddress_Click(object sender, EventArgs e)
{
if (txtNewA.Text.Equals(""))
{
MessageBox.Show("No puede dejar campos vacios", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else
{
string dir = (string)cmbAddress.SelectedItem;
ADDRESS ad = new ADDRESS();
foreach (var d in list)
{
if (d.address.Equals(dir))
{
ad.address = d.address;
ad.idAddress = d.idAddress;
ad.idUser = d.idUser;
}
}
try
{
string sql = String.Format("UPDATE ADDRESS SET address = '{0}' WHERE idAddress = "
+ ad.idAddress, txtNewA.Text).ToString();
ConnectionDB.ExecuteNonQuery(sql);
this.Close();
MessageBox.Show("Direccion actualizada con exito", "Confirmacion", MessageBoxButtons.OK,
MessageBoxIcon.Asterisk);
}
catch (Exception exception)
{
MessageBox.Show("Ha ocurrido un error", "ERROR",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}