--- /dev/null
+<?php
+
+class PdoTypeHebergementManager extends AbstractPdoManager {
+
+
+ public function edit($type_hebergement_key,$libelle){
+ $sql = "SELECT id FROM type_hebergement WHERE type_hebergement_key=?";
+ $hebergement_id = $this->queryOne($sql,$type_hebergement_key);
+ if ($hebergement_id){
+ $sql = "UPDATE type_hebergement SET libelle=? WHERE type_hebergement_key=?";
+ $this->query($sql,$libelle,$type_hebergement_key);
+ } else {
+ $sql = "INSERT INTO type_hebergement (type_hebergement_key, libelle) VALUE (?,?)";
+ $this->query($sql,$type_hebergement_key,$libelle);
+ $hebergement_id = $this->lastInsertId();
+ }
+ return $hebergement_id;
+ }
+
+ public function getList(){
+ $sql = "SELECT * FROM type_hebergement ORDER BY libelle";
+ return $this->query($sql);
+ }
+
+ /**
+ * @param $type_hebergement_id
+ * @return TypeHebergement|null
+ */
+ public function getTypeHebergement($type_hebergement_id){
+ $sql = "SELECT * FROM type_hebergement WHERE id=?";
+ $info = $this->queryOne($sql,$type_hebergement_id);
+ return $this->createObjectModel($info);
+ }
+
+ /**
+ * @param $type_hebergement_key
+ * @return TypeHebergement|null
+ */
+ public function getTypeHebergementByKey($type_hebergement_key){
+ $sql = "SELECT * FROM type_hebergement WHERE type_hebergement_key=?";
+ $info = $this->queryOne($sql,$type_hebergement_key);
+ return $this->createObjectModel($info);
+ }
+
+
+}
\ No newline at end of file