// ########################################################################################################################################
public MOCKioskKioskSlide getSlide(int slideId) {
if (slideId != -1) {
for (MOCKioskKioskSlide slide : this.slides) {
if (slide.getIndeck_id() == slideId) {
// Found matching slide
return slide;
}
}
}
return null;
}
private void updatePopupSlide(
MOCKioskKioskSlide editSlide,
String kioskName,
String popupTitle,
String popupText,
String popupURL,
String popupImageURL,
int popupImageSize) {
editSlide.setName(kioskName);
editSlide.setTitle(popupTitle);
editSlide.setText(popupText);
editSlide.setUrl(popupURL);
editSlide.setImage(popupImageURL);
editSlide.setImage_size(popupImageSize);
PreparedStatement statement =
this.databaseConnection.prepareStatementAndKeys(
"UPDATE `kiosk_slides` SET `name`=?, `title`=?, `text`=?, `url`=?, `image`=?, `image_size`=? WHERE `id`=?");
try {
statement.setString(1, kioskName); // name
statement.setString(2, popupTitle); // title
statement.setString(3, popupText); // text
statement.setString(4, popupURL); // url
statement.setString(5, popupImageURL); // image
statement.setInt(6, popupImageSize); // image_size
statement.setInt(7, editSlide.getId()); // id
this.databaseConnection.updateQuery(statement);
} catch (SQLException e) {
e.printStackTrace();
}
}
