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
}
}
