public void Load() { 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); dataConnector.CloseConnection(); }
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(); }
protected void submitBtn_Click(object sender, EventArgs e) { //To do validations here if (courseInput.SelectedIndex == 0) { lblErrorMsgTest.Visible = true; lblErrorMsgTest.Text = "Got error"; } //Assume all fields entered correctly //declaration of variables WorkflowDAO wfDAO = new WorkflowDAO(); TNFDAO tnfDAO = new TNFDAO(); User currentUser = (User)Session["currentUser"]; int courseID = Convert.ToInt32(courseInput.SelectedValue); int lessonID = Convert.ToInt32(Request.Form["rbnLessonID"]); string prepareForNewJobRole = null; string prepareForNewJobRoleText = null; DateTime? prepareForNewJobRoleCompletedDate = null; string shareKnowledge = null; string shareKnowledgeText = null; DateTime? shareKnowledgeCompletedDate = null; string otherObjectives = null; string otherObjectivesText = null; DateTime? otherObjectivesCompletedDate = null; DateTime applicationDate = DateTime.Now.Date; if (objectiveInput1.Checked) { prepareForNewJobRole = "y"; prepareForNewJobRoleText = objectiveElaborate1.Text; prepareForNewJobRoleCompletedDate = DateTime.ParseExact(completeDateInput1.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture); } else { prepareForNewJobRole = "n"; } if (objectiveInput2.Checked) { shareKnowledge = "y"; shareKnowledgeText = objectiveElaborate2.Text; shareKnowledgeCompletedDate = DateTime.ParseExact(completeDateInput2.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture); } else { shareKnowledge = "n"; } if (objectiveInput3.Checked) { otherObjectives = "y"; otherObjectivesText = objectiveElaborate3.Text; otherObjectivesCompletedDate = DateTime.ParseExact(completeDateInput3.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture); } else { otherObjectives = "n"; } //creation of TNF object Workflow currentWF = wfDAO.getCurrentActiveWorkflow("individual"); TNF newTNF = new TNF(currentUser, "individual", "pending", 0, currentWF, applicationDate); int tnfid = tnfDAO.createTNF(newTNF); newTNF.setTNFID(tnfid); tnfDAO.createTNF_Data(tnfid, courseID, prepareForNewJobRole, prepareForNewJobRoleText, prepareForNewJobRoleCompletedDate, shareKnowledge, shareKnowledgeText, shareKnowledgeCompletedDate, otherObjectives, otherObjectivesText, otherObjectivesCompletedDate, lessonID); //start routing Boolean successOrNot = Workflow_Route.routeForApproval(newTNF); if (successOrNot) { //to create lesson info Response.Redirect("submitTRF.aspx"); } else { //do something } }