1 files changed, 109 insertions, 0 deletions
diff --git a/ecomp-sdk/epsdk-workflow/src/main/java/org/openecomp/portalsdk/workflow/dao/WorkflowDAOImpl.java b/ecomp-sdk/epsdk-workflow/src/main/java/org/openecomp/portalsdk/workflow/dao/WorkflowDAOImpl.java
new file mode 100644
index 00000000..a3382dbb
--- /dev/null
+++ b/ecomp-sdk/epsdk-workflow/src/main/java/org/openecomp/portalsdk/workflow/dao/WorkflowDAOImpl.java
@@ -0,0 +1,109 @@
+/*-
+ * ================================================================================
+ * eCOMP Portal SDK
+ * ================================================================================
+ * Copyright (C) 2017 AT&T Intellectual Property
+ * ================================================================================
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ * 
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ * 
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ * ================================================================================
+ */
+package org.openecomp.portalsdk.workflow.dao;
+
+import java.util.Date;
+import java.util.List;
+
+import org.hibernate.Query;
+import org.hibernate.Session;
+import org.hibernate.SessionFactory;
+import org.hibernate.Transaction;
+import org.openecomp.portalsdk.core.domain.User;
+import org.openecomp.portalsdk.workflow.models.Workflow;
+import org.openecomp.portalsdk.workflow.models.WorkflowLite;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Repository;
+@Repository
+public class WorkflowDAOImpl implements WorkflowDAO{
+	
+	@Autowired
+	private SessionFactory sessionFactory;
+	
+	public Workflow save(Workflow workflow, String creatorId){
+        Session session = this.sessionFactory.openSession();
+        Transaction tx = session.beginTransaction();
+        
+        try{
+        	Query query = session.createQuery("from User where loginId =:loginId");
+        	query.setParameter("loginId", creatorId);
+        	User creator = (User)(query.list().get(0));
+        	
+        	workflow.setCreatedBy(creator);
+            workflow.setCreated(new Date());
+        }
+        catch(Exception e){
+        	e.printStackTrace();
+        }
+        
+        long id = (Long) session.save(workflow);
+        Workflow savedWorkflow = (Workflow) session.get(Workflow.class, id);        
+        tx.commit();
+        session.close();
+        return savedWorkflow;
+	}
+	
+	public List<Workflow> getWorkflows(){
+		Session session = this.sessionFactory.openSession();
+        @SuppressWarnings("unchecked")
+		List<Workflow> workflows = session.createQuery("from Workflow").list();
+        session.close();
+        return workflows;
+	}
+
+	@Override
+	public void delete(Long workflowId) {
+		Session session = this.sessionFactory.openSession();
+        Transaction tx = session.beginTransaction();
+        Query query = session.createQuery("delete from Workflow where id =:id");
+        query.setParameter("id", workflowId);
+        query.executeUpdate();    
+        tx.commit();
+        session.close();        	
+    }
+
+	@Override
+	public Workflow edit(WorkflowLite workflowLight, String creatorId) {
+        Session session = this.sessionFactory.openSession();
+        Transaction tx = session.beginTransaction();
+        
+        Query query = session.createQuery("from User where loginId =:loginId");
+    	query.setParameter("loginId", creatorId);
+    	User creator = (User)(query.list().get(0));
+    	
+    	Workflow workflowToModify = (Workflow) session.get(Workflow.class, workflowLight.getId());
+        
+    	workflowToModify.setActive(workflowLight.getActive().equalsIgnoreCase("true") ? true : false );
+    	workflowToModify.setSuspendLink(workflowLight.getSuspendLink());
+    	workflowToModify.setRunLink(workflowLight.getRunLink());
+    	workflowToModify.setDescription(workflowLight.getDescription());
+    	workflowToModify.setWorkflowKey(workflowLight.getWorkflowKey());
+    	workflowToModify.setName(workflowLight.getName());
+    	
+    	workflowToModify.setModifiedBy(creator);
+    	workflowToModify.setLastUpdated(new Date());
+        
+        session.update(workflowToModify);
+        Workflow savedWorkflow = (Workflow) session.get(Workflow.class, workflowLight.getId());
+        tx.commit();
+        session.close();
+        return savedWorkflow;
+	}
+}