public string Patch(Guid UUID) { WorkflowDTO workflowSelected = context.WorkFlow.Find(UUID); workflowSelected.Status = StatusWF.Consumed; context.WorkFlow.Update(workflowSelected); context.SaveChanges(); return("Successo"); }
public void Store() { DataConnector dataConnector = new DataConnector(); dataConnector.OpenConnection("mySql"); WorkflowDAO workflowDAO = new WorkflowDAO(dataConnector.MySqlConnection); ElementDAO elementDAO = new ElementDAO(dataConnector.MySqlConnection); RelationDAO relationDAO = new RelationDAO(dataConnector.MySqlConnection); WorkflowDTO workflowDTO = new WorkflowDTO(); workflowDTO.id = this.id; workflowDTO.name = this.name; if (this.startElement != null) { workflowDTO.startElement = this.startElement.id; } if (this.finishElement != null) { workflowDTO.finishElement = this.finishElement.id; } this.id = (int)workflowDAO.StoreWorkflow(workflowDTO); foreach (FlowElement element in elements) { ElementDTO elementDTO = new ElementDTO(); elementDTO.id = element.id; elementDTO.owner = this.id; elementDTO.name = element.name; elementDTO.enabled = element.enabled; elementDTO.elementType = element.elementType; elementDAO.StoreElement(elementDTO); } foreach (Relation relation in relations) { RelationDTO relationDTO = new RelationDTO(); relationDTO.origin = relation.origin.id; relationDTO.destinarion = relation.destination.id; relationDAO.StoreRelation(relationDTO); } dataConnector.CloseConnection(); }
public Int64 StoreWorkflow(WorkflowDTO workflow) { String commandText = "INSERT INTO `flowManager`.`workflow` VALUES(null, '" + workflow.name + "', " + workflow.startElement + ", " + workflow.finishElement + ")"; if (workflow.id != 0) { commandText = "UPDATE `flowManager`.`workflow` SET name = '" + workflow.name + "', startElement = " + workflow.startElement + ", finishElement = " + workflow.finishElement + " WHERE id = " + workflow.id; } commandText = commandText + ';' + Environment.NewLine + "SELECT LAST_INSERT_ID()"; MySqlCommand command = new MySqlCommand(commandText, this.mySqlConnection); Int64 insertId = (Int64)command.ExecuteScalar(); if (workflow.id != 0) { insertId = workflow.id; } return(insertId); }
public List <WorkflowDTO> RetrieveWorkflows(String filter) { List <WorkflowDTO> workflowList = new List <WorkflowDTO>(); String query = "SELECT * FROM `flowManager`.`workflow`"; MySqlCommand command = new MySqlCommand(query, this.mySqlConnection); MySqlDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { WorkflowDTO workflow = new WorkflowDTO(); workflow.id = (int)dataReader["id"]; workflow.name = (String)dataReader["name"]; workflow.startElement = (int)dataReader["startElement"]; workflow.finishElement = (int)dataReader["finishElement"]; workflowList.Add(workflow); } dataReader.Close(); return(workflowList); }
public HttpResponseMessage Consume(int id) { MemoryStream stream = new MemoryStream(); StreamWriter writer = new StreamWriter(stream); string data = MessageHandler.Receive(MYQUEUE); WorkflowDTO workflowSelected = context.WorkFlow.Find(Guid.Parse(data)); writer.Write(workflowSelected.Data); writer.Flush(); stream.Position = 0; HttpResponseMessage result = new HttpResponseMessage(HttpStatusCode.OK); result.Content = new StreamContent(stream); result.Content.Headers.ContentType = new MediaTypeHeaderValue("text/csv"); result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment") { FileName = "Export.csv" }; return(result); }