private void btnNuevoPedido_Click(object sender, RoutedEventArgs e)
{
string query = "UPDATE pedido_venta SET Comentario = '" + txtComentario.Text + "' WHERE Codigo = " + txt_CodigoPedido.Text;
if (!txtComentario.Text.Equals(String.Empty) && !txt_CodigoPedido.Text.Equals(String.Empty))
{
string cadenaConexion = "server=localhost;database=lynse;uid=root;pwd=\"\";";
MySqlConnection conexionBBDD = new MySqlConnection(cadenaConexion);
try
{
conexionBBDD.Open();
MySqlCommand cmd = new MySqlCommand(query, conexionBBDD);
cmd.ExecuteNonQuery();
conexionBBDD.Close();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.ToString());
}
}
Ventana_Venta_Principal ventana_Venta = new Ventana_Venta_Principal();
ventana_Venta.Show();
this.Close();
}
public void EliminarPedidoEntero()
{
string cadenaConexion = "server=localhost;database=lynse;uid=root;pwd=\"\";";
MySqlConnection conexionBBDD = new MySqlConnection(cadenaConexion);
try
{
conexionBBDD.Open();
MySqlCommand cmd = new MySqlCommand("DELETE FROM pedido_venta WHERE Codigo = " + txt_CodigoPedido.Text, conexionBBDD);
cmd.ExecuteNonQuery();
conexionBBDD.Close();
Ventana_Venta_Principal ventana_Venta = new Ventana_Venta_Principal();
ventana_Venta.Show();
this.Close();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.ToString());
}
}
private void Label_PreviewMouseDown_3(object sender, MouseButtonEventArgs e)
{
Ventana_Venta_Principal ventanaVenta = new Ventana_Venta_Principal();
ventanaVenta.Show();
}
