public static string ProcessWorkflow(Int32 workflow_id, Int32 userID) { qDbs_SQLcode sql = new qDbs_SQLcode(); qPtl_Workflow c_workflow = new qPtl_Workflow(workflow_id); string returnMessage = string.Empty; if (c_workflow.WorkflowActionType == "sql") { // get sql and then replace the parameters string finalSql = c_workflow.SQL; // replace values finalSql = finalSql.Replace("{UserID}", Convert.ToString(userID)); if (c_workflow.ReferenceID > 0) { finalSql = finalSql.Replace("{ReferenceID}", Convert.ToString(c_workflow.ReferenceID)); } if (c_workflow.WorkflowActionReferenceID > 0) { finalSql = finalSql.Replace("{WorkflowActionReferenceID}", Convert.ToString(c_workflow.WorkflowActionReferenceID)); } returnMessage = sql.ExecuteSQL(finalSql); } return(returnMessage); }
public static string ProcessWorkflow(Int32 workflow_id, Int32 userID) { qDbs_SQLcode sql = new qDbs_SQLcode(); qPtl_Workflow c_workflow = new qPtl_Workflow(workflow_id); string returnMessage = string.Empty; if (c_workflow.WorkflowActionType == "sql") { // get sql and then replace the parameters string finalSql = c_workflow.SQL; // replace values finalSql = finalSql.Replace("{UserID}", Convert.ToString(userID)); if (c_workflow.ReferenceID > 0) finalSql = finalSql.Replace("{ReferenceID}", Convert.ToString(c_workflow.ReferenceID)); if (c_workflow.WorkflowActionReferenceID > 0) finalSql = finalSql.Replace("{WorkflowActionReferenceID}", Convert.ToString(c_workflow.WorkflowActionReferenceID)); returnMessage = sql.ExecuteSQL(finalSql); } return returnMessage; }