From 5d8f7e3f27c9ffb1c252a41a339c9d39438b9c45 Mon Sep 17 00:00:00 2001
From: Felix Kehrer <felix.kehrer@gmail.com>
Date: Fri, 4 May 2018 23:30:10 +0200
Subject: Add missing update to vehicle table

---
 .../groupphase/einsatzverwaltung/dao/H2RegistrationDAO.java       | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'src/main/java/at')

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) {
-- 
cgit v1.2.3-70-g09d2