Add missing update to vehicle table

1 files changed, 8 insertions, 0 deletions

diff --git a/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/H2RegistrationDAO.java b/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/H2RegistrationDAO.java
index 825dc80..c1ea533 100644
--- a/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/H2RegistrationDAO.java
+++ b/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/H2RegistrationDAO.java
@@ -23,6 +23,8 @@ public class H2RegistrationDAO implements RegistrationDAO {
 
     private static final String ADD_REGISTRATION =
             "INSERT INTO Registration (vehicleId, employeeId, start, end, active) VALUES (?,?,?,?,?);";
+    private static final String UPDATE_VEHICLE =
+            "UPDATE Vehicle SET status = 'frei_wache' WHERE id = ?;";
 
     private Connection connection;
 
@@ -64,6 +66,12 @@ public class H2RegistrationDAO implements RegistrationDAO {
                     }
                 }
             }
+
+            try (PreparedStatement updateVehicle = connection.prepareStatement(UPDATE_VEHICLE)) {
+                updateVehicle.setLong(1, vehicleId);
+                updateVehicle.executeUpdate();
+            }
+
             connection.commit();
             return returnValues;
         } catch (SQLException e) {