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(); }