--- a/flys-backend/src/main/java/de/intevation/flys/model/BedHeightEpoch.java	Tue May 15 14:19:55 2012 +0000
+++ b/flys-backend/src/main/java/de/intevation/flys/model/BedHeightEpoch.java	Fri May 18 07:01:47 2012 +0000
@@ -16,6 +16,11 @@
 import javax.persistence.OneToOne;
 import javax.persistence.OneToMany;
 
+import org.hibernate.Session;
+import org.hibernate.Query;
+
+import de.intevation.flys.backend.SessionHolder;
+
 
 @Entity
 @Table(name = "bed_height_epoch")
@@ -156,5 +161,31 @@
     public void setValues(List<BedHeightEpochValue> values) {
         this.values = values;
     }
+
+
+    public static List<BedHeightEpoch> getBedHeightEpochs(River river) {
+        Session session = SessionHolder.HOLDER.get();
+
+        Query query = session.createQuery(
+            "from BedHeightEpoch where river=:river");
+
+        query.setParameter("river", river);
+
+        return query.list();
+    }
+
+
+    public static BedHeightEpoch getBedHeightEpochById(int id) {
+        Session session = SessionHolder.HOLDER.get();
+
+        Query query = session.createQuery(
+            "from BedHeightEpoch where id=:id");
+
+        query.setParameter("id", id);
+
+        List<BedHeightEpoch> singles = query.list();
+
+        return singles != null ? singles.get(0) : null;
+    }
 }
 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :