public static Tuple2<Button, Button> add2ButtonsAfterGroup(
GridPane gridPane, int rowIndex, String title1, String title2, double top) {
HBox hBox = new HBox();
hBox.setSpacing(10);
Button button1 = new Button(title1);
button1.setDefaultButton(true);
Button button2 = new Button(title2);
hBox.getChildren().addAll(button1, button2);
GridPane.setRowIndex(hBox, rowIndex);
GridPane.setColumnIndex(hBox, 1);
GridPane.setMargin(hBox, new Insets(top, 10, 0, 0));
gridPane.getChildren().add(hBox);
return new Tuple2<>(button1, button2);
}
public static Tuple2<Button, CheckBox> addButtonCheckBox(
GridPane gridPane, int rowIndex, String buttonTitle, String checkBoxTitle, double top) {
Button button = new Button(buttonTitle);
button.setDefaultButton(true);
CheckBox checkBox = new CheckBox(checkBoxTitle);
HBox.setMargin(checkBox, new Insets(6, 0, 0, 0));
HBox hBox = new HBox();
hBox.setSpacing(20);
hBox.getChildren().addAll(button, checkBox);
GridPane.setRowIndex(hBox, rowIndex);
GridPane.setColumnIndex(hBox, 1);
hBox.setPadding(new Insets(top, 0, 0, 0));
gridPane.getChildren().add(hBox);
return new Tuple2<>(button, checkBox);
}
public static Tuple3<Label, InputTextField, CheckBox> addLabelInputTextFieldCheckBox(
GridPane gridPane, int rowIndex, String title, String checkBoxTitle) {
Label label = addLabel(gridPane, rowIndex, title, 0);
InputTextField inputTextField = new InputTextField();
CheckBox checkBox = new CheckBox(checkBoxTitle);
checkBox.setPadding(new Insets(6, 0, 0, 0));
HBox hBox = new HBox();
hBox.setSpacing(10);
hBox.getChildren().addAll(inputTextField, checkBox);
GridPane.setRowIndex(hBox, rowIndex);
GridPane.setColumnIndex(hBox, 1);
gridPane.getChildren().add(hBox);
return new Tuple3<>(label, inputTextField, checkBox);
}
public static Tuple3<Label, ComboBox, ComboBox> addLabelComboBoxComboBox(
GridPane gridPane, int rowIndex, String title, double top) {
Label label = addLabel(gridPane, rowIndex, title, top);
HBox hBox = new HBox();
hBox.setSpacing(10);
ComboBox comboBox1 = new ComboBox();
ComboBox comboBox2 = new ComboBox();
hBox.getChildren().addAll(comboBox1, comboBox2);
GridPane.setRowIndex(hBox, rowIndex);
GridPane.setColumnIndex(hBox, 1);
// GridPane.setMargin(hBox, new Insets(15, 0, 0, 0));
gridPane.getChildren().add(hBox);
return new Tuple3<>(label, comboBox1, comboBox2);
}
public static Tuple3<Label, ComboBox, Button> addLabelComboBoxButton(
GridPane gridPane, int rowIndex, String title, String buttonTitle, double top) {
Label label = addLabel(gridPane, rowIndex, title, top);
HBox hBox = new HBox();
hBox.setSpacing(10);
Button button = new Button(buttonTitle);
button.setDefaultButton(true);
ComboBox comboBox = new ComboBox();
hBox.getChildren().addAll(comboBox, button);
GridPane.setRowIndex(hBox, rowIndex);
GridPane.setColumnIndex(hBox, 1);
GridPane.setMargin(hBox, new Insets(15, 0, 0, 0));
gridPane.getChildren().add(hBox);
return new Tuple3<>(label, comboBox, button);
}
public static Tuple3<Button, ProgressIndicator, Label> addButtonWithStatus(
GridPane gridPane, int rowIndex, String buttonTitle, double top) {
HBox hBox = new HBox();
hBox.setSpacing(10);
Button button = new Button(buttonTitle);
button.setDefaultButton(true);
ProgressIndicator progressIndicator = new ProgressIndicator(0);
progressIndicator.setPrefHeight(24);
progressIndicator.setPrefWidth(24);
progressIndicator.setVisible(false);
Label label = new Label();
label.setPadding(new Insets(5, 0, 0, 0));
hBox.getChildren().addAll(button, progressIndicator, label);
GridPane.setRowIndex(hBox, rowIndex);
GridPane.setColumnIndex(hBox, 1);
GridPane.setMargin(hBox, new Insets(top, 0, 0, 0));
gridPane.getChildren().add(hBox);
return new Tuple3<>(button, progressIndicator, label);
}
private void onSelectDispute(Dispute dispute) {
if (dispute == null) {
if (root.getChildren().size() > 1) root.getChildren().remove(1);
selectedDispute = null;
} else if (selectedDispute != dispute) {
this.selectedDispute = dispute;
boolean isTrader = disputeManager.isTrader(dispute);
TableGroupHeadline tableGroupHeadline = new TableGroupHeadline();
tableGroupHeadline.setText("Messages");
tableGroupHeadline.prefWidthProperty().bind(root.widthProperty());
AnchorPane.setTopAnchor(tableGroupHeadline, 10d);
AnchorPane.setRightAnchor(tableGroupHeadline, 0d);
AnchorPane.setBottomAnchor(tableGroupHeadline, 0d);
AnchorPane.setLeftAnchor(tableGroupHeadline, 0d);
ObservableList<DisputeDirectMessage> list =
dispute.getDisputeDirectMessagesAsObservableList();
SortedList<DisputeDirectMessage> sortedList = new SortedList<>(list);
sortedList.setComparator((o1, o2) -> o1.getDate().compareTo(o2.getDate()));
list.addListener((ListChangeListener<DisputeDirectMessage>) c -> scrollToBottom());
messageListView = new ListView<>(sortedList);
messageListView.setId("message-list-view");
messageListView.prefWidthProperty().bind(root.widthProperty());
messageListView.setMinHeight(150);
AnchorPane.setTopAnchor(messageListView, 30d);
AnchorPane.setRightAnchor(messageListView, 0d);
AnchorPane.setLeftAnchor(messageListView, 0d);
messagesAnchorPane = new AnchorPane();
messagesAnchorPane.prefWidthProperty().bind(root.widthProperty());
VBox.setVgrow(messagesAnchorPane, Priority.ALWAYS);
inputTextArea = new TextArea();
inputTextArea.setPrefHeight(70);
inputTextArea.setWrapText(true);
Button sendButton = new Button("Send");
sendButton.setDefaultButton(true);
sendButton.setOnAction(e -> onSendMessage(inputTextArea.getText(), dispute));
sendButton.setDisable(true);
inputTextArea
.textProperty()
.addListener(
(observable, oldValue, newValue) -> {
sendButton.setDisable(
newValue.length() == 0
&& tempAttachments.size() == 0
&& dispute.disputeResultProperty().get() == null);
});
Button uploadButton = new Button("Add attachments");
uploadButton.setOnAction(e -> onRequestUpload());
sendMsgInfoLabel = new Label();
sendMsgInfoLabel.setVisible(false);
sendMsgInfoLabel.setManaged(false);
sendMsgInfoLabel.setPadding(new Insets(5, 0, 0, 0));
sendMsgProgressIndicator = new ProgressIndicator(0);
sendMsgProgressIndicator.setPrefHeight(24);
sendMsgProgressIndicator.setPrefWidth(24);
sendMsgProgressIndicator.setVisible(false);
sendMsgProgressIndicator.setManaged(false);
dispute
.isClosedProperty()
.addListener(
(observable, oldValue, newValue) -> {
messagesInputBox.setVisible(!newValue);
messagesInputBox.setManaged(!newValue);
AnchorPane.setBottomAnchor(messageListView, newValue ? 0d : 120d);
});
if (!dispute.isClosed()) {
HBox buttonBox = new HBox();
buttonBox.setSpacing(10);
buttonBox
.getChildren()
.addAll(sendButton, uploadButton, sendMsgProgressIndicator, sendMsgInfoLabel);
if (!isTrader) {
Button closeDisputeButton = new Button("Close ticket");
closeDisputeButton.setOnAction(e -> onCloseDispute(dispute));
closeDisputeButton.setDefaultButton(true);
Pane spacer = new Pane();
HBox.setHgrow(spacer, Priority.ALWAYS);
buttonBox.getChildren().addAll(spacer, closeDisputeButton);
}
messagesInputBox = new VBox();
messagesInputBox.setSpacing(10);
messagesInputBox.getChildren().addAll(inputTextArea, buttonBox);
VBox.setVgrow(buttonBox, Priority.ALWAYS);
AnchorPane.setRightAnchor(messagesInputBox, 0d);
AnchorPane.setBottomAnchor(messagesInputBox, 5d);
AnchorPane.setLeftAnchor(messagesInputBox, 0d);
AnchorPane.setBottomAnchor(messageListView, 120d);
messagesAnchorPane
.getChildren()
.addAll(tableGroupHeadline, messageListView, messagesInputBox);
} else {
AnchorPane.setBottomAnchor(messageListView, 0d);
messagesAnchorPane.getChildren().addAll(tableGroupHeadline, messageListView);
}
messageListView.setCellFactory(
new Callback<ListView<DisputeDirectMessage>, ListCell<DisputeDirectMessage>>() {
@Override
public ListCell<DisputeDirectMessage> call(ListView<DisputeDirectMessage> list) {
return new ListCell<DisputeDirectMessage>() {
final Pane bg = new Pane();
final ImageView arrow = new ImageView();
final Label headerLabel = new Label();
final Label messageLabel = new Label();
final HBox attachmentsBox = new HBox();
final AnchorPane messageAnchorPane = new AnchorPane();
final Label statusIcon = new Label();
final double arrowWidth = 15d;
final double attachmentsBoxHeight = 20d;
final double border = 10d;
final double bottomBorder = 25d;
final double padding = border + 10d;
{
bg.setMinHeight(30);
messageLabel.setWrapText(true);
headerLabel.setTextAlignment(TextAlignment.CENTER);
attachmentsBox.setSpacing(5);
statusIcon.setStyle("-fx-font-size: 10;");
messageAnchorPane
.getChildren()
.addAll(bg, arrow, headerLabel, messageLabel, attachmentsBox, statusIcon);
}
@Override
public void updateItem(final DisputeDirectMessage item, boolean empty) {
super.updateItem(item, empty);
if (item != null && !empty) {
/* messageAnchorPane.prefWidthProperty().bind(EasyBind.map(messageListView.widthProperty(),
w -> (double) w - padding - GUIUtil.getScrollbarWidth(messageListView)));*/
if (!messageAnchorPane.prefWidthProperty().isBound())
messageAnchorPane
.prefWidthProperty()
.bind(
messageListView
.widthProperty()
.subtract(padding + GUIUtil.getScrollbarWidth(messageListView)));
AnchorPane.setTopAnchor(bg, 15d);
AnchorPane.setBottomAnchor(bg, bottomBorder);
AnchorPane.setTopAnchor(headerLabel, 0d);
AnchorPane.setBottomAnchor(arrow, bottomBorder + 5d);
AnchorPane.setTopAnchor(messageLabel, 25d);
AnchorPane.setBottomAnchor(attachmentsBox, bottomBorder + 10);
boolean senderIsTrader = item.isSenderIsTrader();
boolean isMyMsg = isTrader ? senderIsTrader : !senderIsTrader;
arrow.setVisible(!item.isSystemMessage());
arrow.setManaged(!item.isSystemMessage());
statusIcon.setVisible(false);
if (item.isSystemMessage()) {
headerLabel.setStyle("-fx-text-fill: -bs-green; -fx-font-size: 11;");
bg.setId("message-bubble-green");
messageLabel.setStyle("-fx-text-fill: white;");
} else if (isMyMsg) {
headerLabel.setStyle("-fx-text-fill: -fx-accent; -fx-font-size: 11;");
bg.setId("message-bubble-blue");
messageLabel.setStyle("-fx-text-fill: white;");
if (isTrader) arrow.setId("bubble_arrow_blue_left");
else arrow.setId("bubble_arrow_blue_right");
sendMsgProgressIndicator
.progressProperty()
.addListener(
(observable, oldValue, newValue) -> {
if ((double) oldValue == -1 && (double) newValue == 0) {
if (item.arrivedProperty().get()) showArrivedIcon();
else if (item.storedInMailboxProperty().get()) showMailboxIcon();
}
});
if (item.arrivedProperty().get()) showArrivedIcon();
else if (item.storedInMailboxProperty().get()) showMailboxIcon();
// TODO show that icon on error
/*else if (sendMsgProgressIndicator.getProgress() == 0)
showNotArrivedIcon();*/
} else {
headerLabel.setStyle("-fx-text-fill: -bs-light-grey; -fx-font-size: 11;");
bg.setId("message-bubble-grey");
messageLabel.setStyle("-fx-text-fill: black;");
if (isTrader) arrow.setId("bubble_arrow_grey_right");
else arrow.setId("bubble_arrow_grey_left");
}
if (item.isSystemMessage()) {
AnchorPane.setLeftAnchor(headerLabel, padding);
AnchorPane.setRightAnchor(headerLabel, padding);
AnchorPane.setLeftAnchor(bg, border);
AnchorPane.setRightAnchor(bg, border);
AnchorPane.setLeftAnchor(messageLabel, padding);
AnchorPane.setRightAnchor(messageLabel, padding);
AnchorPane.setLeftAnchor(attachmentsBox, padding);
AnchorPane.setRightAnchor(attachmentsBox, padding);
} else if (senderIsTrader) {
AnchorPane.setLeftAnchor(headerLabel, padding + arrowWidth);
AnchorPane.setLeftAnchor(bg, border + arrowWidth);
AnchorPane.setRightAnchor(bg, border);
AnchorPane.setLeftAnchor(arrow, border);
AnchorPane.setLeftAnchor(messageLabel, padding + arrowWidth);
AnchorPane.setRightAnchor(messageLabel, padding);
AnchorPane.setLeftAnchor(attachmentsBox, padding + arrowWidth);
AnchorPane.setRightAnchor(attachmentsBox, padding);
AnchorPane.setRightAnchor(statusIcon, padding);
} else {
AnchorPane.setRightAnchor(headerLabel, padding + arrowWidth);
AnchorPane.setLeftAnchor(bg, border);
AnchorPane.setRightAnchor(bg, border + arrowWidth);
AnchorPane.setRightAnchor(arrow, border);
AnchorPane.setLeftAnchor(messageLabel, padding);
AnchorPane.setRightAnchor(messageLabel, padding + arrowWidth);
AnchorPane.setLeftAnchor(attachmentsBox, padding);
AnchorPane.setRightAnchor(attachmentsBox, padding + arrowWidth);
AnchorPane.setLeftAnchor(statusIcon, padding);
}
AnchorPane.setBottomAnchor(statusIcon, 7d);
headerLabel.setText(formatter.formatDateTime(item.getDate()));
messageLabel.setText(item.getMessage());
if (item.getAttachments().size() > 0) {
AnchorPane.setBottomAnchor(
messageLabel, bottomBorder + attachmentsBoxHeight + 10);
attachmentsBox
.getChildren()
.add(
new Label("Attachments: ") {
{
setPadding(new Insets(0, 0, 3, 0));
if (isMyMsg) setStyle("-fx-text-fill: white;");
else setStyle("-fx-text-fill: black;");
}
});
item.getAttachments()
.stream()
.forEach(
attachment -> {
final Label icon = new Label();
setPadding(new Insets(0, 0, 3, 0));
if (isMyMsg) icon.getStyleClass().add("attachment-icon");
else icon.getStyleClass().add("attachment-icon-black");
AwesomeDude.setIcon(icon, AwesomeIcon.FILE_TEXT);
icon.setPadding(new Insets(-2, 0, 0, 0));
icon.setTooltip(new Tooltip(attachment.getFileName()));
icon.setOnMouseClicked(event -> onOpenAttachment(attachment));
attachmentsBox.getChildren().add(icon);
});
} else {
attachmentsBox.getChildren().clear();
AnchorPane.setBottomAnchor(messageLabel, bottomBorder + 10);
}
// TODO There are still some cell rendering issues on updates
setGraphic(messageAnchorPane);
} else {
messageAnchorPane.prefWidthProperty().unbind();
AnchorPane.clearConstraints(bg);
AnchorPane.clearConstraints(headerLabel);
AnchorPane.clearConstraints(arrow);
AnchorPane.clearConstraints(messageLabel);
AnchorPane.clearConstraints(statusIcon);
AnchorPane.clearConstraints(attachmentsBox);
setGraphic(null);
}
}
/* private void showNotArrivedIcon() {
statusIcon.setVisible(true);
AwesomeDude.setIcon(statusIcon, AwesomeIcon.WARNING_SIGN, "14");
Tooltip.install(statusIcon, new Tooltip("Message did not arrive. Please try to send again."));
statusIcon.setTextFill(Paint.valueOf("#dd0000"));
}*/
private void showMailboxIcon() {
statusIcon.setVisible(true);
AwesomeDude.setIcon(statusIcon, AwesomeIcon.ENVELOPE_ALT, "14");
Tooltip.install(statusIcon, new Tooltip("Message saved in receivers mailbox"));
statusIcon.setTextFill(Paint.valueOf("#0f87c3"));
}
private void showArrivedIcon() {
statusIcon.setVisible(true);
AwesomeDude.setIcon(statusIcon, AwesomeIcon.OK, "14");
Tooltip.install(statusIcon, new Tooltip("Message arrived at receiver"));
statusIcon.setTextFill(Paint.valueOf("#0f87c3"));
}
};
}
});
if (root.getChildren().size() > 1) root.getChildren().remove(1);
root.getChildren().add(1, messagesAnchorPane);
scrollToBottom();
}
}
public ConfigurationsDialogBuilder create(
DependencyDotFileGenerator dependencyDotFileGenerator,
GradleScriptPreferences preferences,
Os os,
String outputFileName) {
this.outputFileName = outputFileName;
this.dependencyDotFileGenerator = dependencyDotFileGenerator;
this.preferences = preferences;
this.os = os;
dialog = new ConfigurationChoiceDialog(this);
dialog.setResizable(true);
dialog.initStyle(UTILITY);
dialog.initModality(APPLICATION_MODAL);
dialog.setIconified(false);
dialog.centerOnScreen();
dialog.borderPanel = BorderPaneBuilder.create().styleClass("dialog").build();
dialog.stackPane = new StackPane();
StackPane stackPane = dialog.stackPane;
dialog.log = new TextArea();
TextArea log = dialog.log;
BorderPane borderPanel = dialog.borderPanel;
// message
dialog.configurationsBox = new VBox();
VBox configurationsBox = dialog.configurationsBox;
dialog.configurationsBox = configurationsBox;
dialog.progressIndicator = new ProgressIndicator();
ProgressIndicator progressIndicator = dialog.progressIndicator;
stackPane.getChildren().add(log);
stackPane.getChildren().add(progressIndicator);
progressIndicator.setPrefSize(50, 50);
progressIndicator.setMaxSize(50, 50);
configurationsBox.setSpacing(15);
configurationsBox.setAlignment(CENTER_LEFT);
dialog.scrollPane = new ScrollPane();
ScrollPane scrollPane = dialog.scrollPane;
scrollPane.setContent(configurationsBox);
dialog.borderPanel.setCenter(stackPane);
BorderPane.setAlignment(configurationsBox, CENTER_LEFT);
BorderPane.setMargin(configurationsBox, new Insets(MARGIN, MARGIN, MARGIN, 2 * MARGIN));
// buttons
dialog.buttonsPanel = new HBox();
final HBox buttonsPanel = dialog.buttonsPanel;
buttonsPanel.setSpacing(MARGIN);
buttonsPanel.setAlignment(BOTTOM_CENTER);
BorderPane.setMargin(buttonsPanel, new Insets(0, 0, 1.5 * MARGIN, 0));
borderPanel.setBottom(buttonsPanel);
borderPanel
.widthProperty()
.addListener(
new ChangeListener<Number>() {
public void changed(ObservableValue<? extends Number> ov, Number t, Number t1) {
buttonsPanel.layout();
}
});
dialog.scene = new Scene(borderPanel);
dialog.setScene(dialog.scene);
URL resource =
ConfigurationsDialogBuilder.class.getResource(
"/com/nurflugel/gradle/ui/dialogservice/dialog.css");
String externalForm = resource.toExternalForm();
// dialog.borderPanel.styleClass("dialog");
dialog.getScene().getStylesheets().add(externalForm);
return this;
}
private void updateSelectedEntry() {
ObservableList<PolizistDaten> Nutzerauswahl = Tabelle.getSelectionModel().getSelectedItems();
if (Nutzerauswahl.size() != 1) {
IM.setErrorText("Es muss genau ein Element ausgewählt werden");
return;
}
PolizistDaten Auswahl = Nutzerauswahl.get(0);
// Jetzt erzeugen wir ein PopUp zum veraendern des Eintrags
Stage PopUp = new Stage();
PopUp.initModality(Modality.APPLICATION_MODAL);
PopUp.setTitle("Neuer Eintrag");
PopUp.setAlwaysOnTop(true);
PopUp.setResizable(false);
GridPane Gitter = new GridPane();
Gitter.setHgap(10);
Gitter.setVgap(10);
Label LabelA = new Label("PersonenID");
Label LabelAWert = new Label(Integer.toString(Auswahl.getPersonenID()));
Label LabelB = new Label("Name");
TextField LabelBWert = new TextField();
Label LabelC = new Label("Geburtsdatum");
DatePicker LabelCWert = new DatePicker();
Label LabelD = new Label("Nationalität");
TextField LabelDWert = new TextField();
Label LabelE = new Label("Geschlecht");
ComboBox LabelEWert = new ComboBox();
Label LabelF = new Label("Todesdatum");
DatePicker LabelFWert = new DatePicker();
Label LabelG = new Label("Dienstgrad");
TextField LabelGWert = new TextField();
final Callback<DatePicker, DateCell> TagesZellenFabtrik =
new Callback<DatePicker, DateCell>() {
@Override
public DateCell call(final DatePicker DP) {
return new DateCell() {
@Override
public void updateItem(LocalDate item, boolean empty) {
super.updateItem(item, empty);
if (item.isBefore(LabelCWert.getValue().plusDays(1))) {
setDisable(true);
setStyle("-fx-background-color: #ffc0cb;");
}
}
};
}
};
LabelFWert.setDayCellFactory(TagesZellenFabtrik);
LabelEWert.getItems().addAll("m", "w");
LabelEWert.setValue(Auswahl.getGeschlecht());
LabelBWert.setText(Auswahl.getName());
LabelCWert.setValue(LocalDate.parse(Auswahl.getGebDatum())); // TODO exception
LabelDWert.setText(Auswahl.getNation());
if (!Auswahl.getTodDatum().isEmpty()) {
LabelFWert.setValue(LocalDate.parse(Auswahl.getTodDatum())); // TODO exception
}
LabelGWert.setText(Auswahl.getDienstgrad());
Button ButtonFort = new Button("Fortfahren");
Button ButtonAbb = new Button("Abbrechen");
ButtonFort.defaultButtonProperty();
ButtonAbb.cancelButtonProperty();
ButtonFort.setMaxWidth(Double.MAX_VALUE);
ButtonAbb.setMaxWidth(Double.MAX_VALUE);
Gitter.addColumn(0, LabelA, LabelB, LabelC, LabelD, LabelE, LabelF, LabelG);
Gitter.addColumn(
1, LabelAWert, LabelBWert, LabelCWert, LabelDWert, LabelEWert, LabelFWert, LabelGWert);
VBox AussenBox = new VBox(10);
HBox InnenBox = new HBox();
AussenBox.setSpacing(10);
AussenBox.setPadding(new Insets(10));
InnenBox.setSpacing(10);
AussenBox.setAlignment(Pos.CENTER);
InnenBox.setAlignment(Pos.BOTTOM_CENTER);
AussenBox.getChildren().addAll(Gitter, InnenBox);
InnenBox.getChildren().addAll(ButtonFort, ButtonAbb);
ButtonAbb.setOnAction(event -> PopUp.close());
ButtonFort.setOnAction(
event -> {
String SQLString;
if (LabelFWert.getEditor().getText().isEmpty()) {
SQLString =
"UPDATE PERSON SET Name=?, Geburtsdatum=?, Nationalität=?, Geschlecht=?, Todesdatum=NULL WHERE PersonenID = "
+ Auswahl.getPersonenID();
} else {
SQLString =
"UPDATE PERSON SET Name=?, Geburtsdatum=?, Nationalität=?, Geschlecht=?, Todesdatum=? WHERE PersonenID = "
+ Auswahl.getPersonenID();
}
try {
PreparedStatement InsertStatement = DH.prepareStatement(SQLString);
InsertStatement.setString(1, LabelBWert.getText());
InsertStatement.setString(2, LabelCWert.getValue().toString()); // TODO exception
InsertStatement.setString(3, LabelDWert.getText());
InsertStatement.setString(4, LabelEWert.getValue().toString());
if (LabelFWert.getValue() != null && !LabelFWert.getEditor().getText().isEmpty()) {
InsertStatement.setString(5, LabelFWert.getValue().toString());
}
InsertStatement.executeUpdate();
SQLString =
"UPDATE POLIZIST SET Dienstgrad = ? WHERE PersonenID = " + Auswahl.getPersonenID();
InsertStatement = DH.prepareStatement(SQLString);
InsertStatement.setString(1, LabelGWert.getText());
InsertStatement.execute();
IM.setInfoText("Änderung durchgeführt");
} catch (SQLException e) {
IM.setErrorText("Ändern Fehlgeschlagen", e);
}
refreshPolizistAnsicht();
PopUp.close();
});
PopUp.setScene(new Scene(AussenBox));
PopUp.showAndWait();
}
private void insertNewEntry() {
Stage PopUp = new Stage();
PopUp.initModality(Modality.APPLICATION_MODAL);
PopUp.setTitle("Neuer Eintrag");
PopUp.setAlwaysOnTop(true);
PopUp.setResizable(false);
GridPane Gitter = new GridPane();
Gitter.setHgap(10);
Gitter.setVgap(10);
Label LabelB = new Label("Name");
TextField LabelBWert = new TextField();
Label LabelC = new Label("Geburtsdatum");
DatePicker LabelCWert = new DatePicker();
Label LabelD = new Label("Nationalität");
TextField LabelDWert = new TextField();
Label LabelE = new Label("Geschlecht");
ComboBox LabelEWert = new ComboBox();
Label LabelF = new Label("Todesdatum");
DatePicker LabelFWert = new DatePicker();
Label LabelG = new Label("Dienstgrad");
TextField LabelGWert = new TextField();
final Callback<DatePicker, DateCell> TagesZellenFabtrik =
new Callback<DatePicker, DateCell>() {
@Override
public DateCell call(final DatePicker DP) {
return new DateCell() {
@Override
public void updateItem(LocalDate item, boolean empty) {
super.updateItem(item, empty);
if (item.isBefore(LabelCWert.getValue().plusDays(1))) {
setDisable(true);
setStyle("-fx-background-color: #ffc0cb;");
}
}
};
}
};
LabelFWert.setDayCellFactory(TagesZellenFabtrik);
LabelEWert.getItems().addAll("m", "w");
LabelEWert.setValue("m");
Button ButtonFort = new Button("Fortfahren");
Button ButtonAbb = new Button("Abbrechen");
ButtonFort.defaultButtonProperty();
ButtonAbb.cancelButtonProperty();
ButtonFort.setMaxWidth(Double.MAX_VALUE);
ButtonAbb.setMaxWidth(Double.MAX_VALUE);
Gitter.addColumn(0, LabelB, LabelC, LabelD, LabelE, LabelF, LabelG);
Gitter.addColumn(1, LabelBWert, LabelCWert, LabelDWert, LabelEWert, LabelFWert, LabelGWert);
VBox AussenBox = new VBox(10);
HBox InnenBox = new HBox();
AussenBox.setSpacing(10);
AussenBox.setPadding(new Insets(10));
InnenBox.setSpacing(10);
AussenBox.setAlignment(Pos.CENTER);
InnenBox.setAlignment(Pos.BOTTOM_CENTER);
AussenBox.getChildren().addAll(Gitter, InnenBox);
InnenBox.getChildren().addAll(ButtonFort, ButtonAbb);
ButtonAbb.setOnAction(event -> PopUp.close());
ButtonFort.setOnAction(
event -> {
String SQLString;
if (LabelFWert.getValue() != null) {
SQLString =
"INSERT INTO PERSON (Name, Geburtsdatum, Nationalität, Geschlecht, Todesdatum) VALUES (?, ?, ?, ?, ?)";
} else {
SQLString =
"INSERT INTO PERSON (Name, Geburtsdatum, Nationalität, Geschlecht) VALUES (?, ?, ?, ?)";
}
try {
PreparedStatement InsertStatement = DH.prepareStatement(SQLString);
InsertStatement.setString(1, LabelBWert.getText());
InsertStatement.setString(2, LabelCWert.getValue().toString()); // TODO exception
InsertStatement.setString(3, LabelDWert.getText());
InsertStatement.setString(4, LabelEWert.getValue().toString());
if (LabelFWert.getValue() != null) {
InsertStatement.setString(5, LabelFWert.getValue().toString()); // TODO exception
}
InsertStatement.executeUpdate();
ResultSet PersID = DH.getAnfrageObjekt().executeQuery("SELECT last_insert_rowid();");
if (!PersID.next()) {
IM.setErrorText("Konnte Primärschlüssel nicht mehr bestimmen.");
}
SQLString = "INSERT INTO POLIZIST (PersonenID, Dienstgrad) VALUES (?, ?)";
InsertStatement = DH.prepareStatement(SQLString);
InsertStatement.setInt(1, PersID.getInt(1)); // TODO das hier verifizieren
InsertStatement.setString(2, LabelGWert.getText());
InsertStatement.executeUpdate();
IM.setInfoText("Einfügen durchgeführt");
} catch (SQLException e) {
IM.setErrorText("Einfügen Fehlgeschlagen", e);
}
refreshPolizistAnsicht();
PopUp.close();
});
PopUp.setScene(new Scene(AussenBox));
PopUp.showAndWait();
}