private void emitirBoleta_Click(object sender, EventArgs e) { emitirBoleta eB = new emitirBoleta(); this.Hide(); eB.Show(); }
private void cobrarBoleta_Click(object sender, EventArgs e) { BD.cnn.Open(); BD.cnn2.Open(); SqlCommand command; SqlDataAdapter adapter = new SqlDataAdapter(); String sql; sql = "update pedido set estado = 1 where id = " + idPedido; command = new SqlCommand(sql, BD.cnn); adapter.UpdateCommand = new SqlCommand(sql, BD.cnn); adapter.UpdateCommand.ExecuteNonQuery(); command.Dispose(); MessageBox.Show("Cobro registrado correctamente"); sql = "insert into boleta values (" + "GETDATE()" + "," + idPedido + "," + costototal.ToString() + ")"; command = new SqlCommand(sql, BD.cnn); adapter.InsertCommand = new SqlCommand(sql, BD.cnn); adapter.InsertCommand.ExecuteNonQuery(); BD.cnn.Close(); BD.cnn2.Close(); this.Hide(); emitirBoleta eB = new emitirBoleta(); eB.Show(); }