protected void Page_Load(object sender, EventArgs e) { AuthenticateUser(); intProfile = Int32.Parse(Request.Cookies["profileid"].Value); oServiceEditor = new ServiceEditor(intProfile, dsnServiceEditor); oService = new Services(intProfile, dsn); oUser = new Users(intProfile, dsn); Int32.TryParse(Request.QueryString["id"], out intID); Int32.TryParse(Request.QueryString["serviceid"], out intService); Int32.TryParse(Request.QueryString["nextservice"], out intNextService); if (Request.QueryString["saved"] != null) { trSaved.Visible = true; } if (!IsPostBack) { if (String.IsNullOrEmpty(Request.QueryString["id"]) == false) { panCondition.Visible = true; DataSet dsConfigs = oServiceEditor.GetConfigs(intService, -1, 1); //DataSet dsConfigs = oServiceEditor.GetConfigs(intService, 0, 1); foreach (DataRow dr in dsConfigs.Tables[0].Rows) { int _configid = Int32.Parse(dr["id"].ToString()); TreeNode oNode = new TreeNode(); oNode.Text = dr["question"].ToString(); oNode.ToolTip = dr["question"].ToString(); oNode.Value = dr["id"].ToString(); oNode.SelectAction = TreeNodeSelectAction.None; oNode.Checked = false; treConditional.Nodes.Add(oNode); DataSet dsValues = oServiceEditor.GetConfigValues(_configid); //dr["code"].ToString() == "DROPDOWN" || dr["code"].ToString() == "RADIOLIST" if (dsValues.Tables[0].Rows.Count > 0) { foreach (DataRow drValue in dsValues.Tables[0].Rows) { TreeNode oChild = new TreeNode(); oChild.Text = drValue["value"].ToString(); oChild.ToolTip = drValue["value"].ToString(); oChild.Value = drValue["id"].ToString(); oChild.SelectAction = TreeNodeSelectAction.None; oChild.Checked = oServiceEditor.IsWorkflowConditionValue(intID, Int32.Parse(drValue["id"].ToString())); oNode.ChildNodes.Add(oChild); } } else { TreeNode oChild = new TreeNode(); oChild.Text = "<b>Unavailable.</b> Only "valued" controls can be used for conditional workflow"; oChild.Value = "0"; oChild.SelectAction = TreeNodeSelectAction.None; oChild.ShowCheckBox = false; oNode.ChildNodes.Add(oChild); } } if (intID > 0) { DataSet ds = oServiceEditor.GetWorkflowCondition(intID); if (ds.Tables[0].Rows.Count > 0) { txtName.Text = ds.Tables[0].Rows[0]["name"].ToString(); chkEnabled.Checked = (ds.Tables[0].Rows[0]["enabled"].ToString() == "1"); } } btnAdd.Attributes.Add("onclick", "return ValidateText('" + txtName.ClientID + "','Enter a name for this condition')" + ";"); } else if (intService > 0 && intNextService > 0) { DataSet ds = oService.GetWorkflow(intService, intNextService); if (ds.Tables[0].Rows.Count > 0) { panList.Visible = true; radConditionOnly.Checked = (ds.Tables[0].Rows[0]["only"].ToString() == "1"); radConditionUnless.Checked = (ds.Tables[0].Rows[0]["only"].ToString() == "0"); radContinueYes.Checked = (ds.Tables[0].Rows[0]["continue"].ToString() == "1"); radContinueNo.Checked = (ds.Tables[0].Rows[0]["continue"].ToString() == "0"); btnSave.Attributes.Add("onclick", "return ValidateRadioButtons3('" + radConditionOnly.ClientID + "','" + radConditionUnless.ClientID + "','" + radConditionNeither.ClientID + "','Please select your condition for initiating this workflow')" + " && ValidateRadioButtons('" + radContinueYes.ClientID + "','" + radContinueNo.ClientID + "','Please select how you want to handle subsequent workflows if this workflow is not initiated')" + ";"); rptConditions.DataSource = oServiceEditor.GetWorkflowConditions(intService, intNextService, 0); rptConditions.DataBind(); lblNone.Visible = (rptConditions.Items.Count == 0); foreach (RepeaterItem ri in rptConditions.Items) { ((LinkButton)ri.FindControl("btnDelete")).Attributes.Add("onclick", "return confirm('Are you sure you want to delete this condition set?');"); } } } if (radConditionOnly.Checked == false && radConditionUnless.Checked == false) { radConditionNeither.Checked = true; } if (radContinueNo.Checked == false && radContinueYes.Checked == false) { radContinueNo.Checked = true; } } }
private StringBuilder LoadWorkflowForm(int _serviceid, int _previous_serviceid, int _children, bool _first) { StringBuilder strReturn = new StringBuilder(); strReturn.Append("<table width=\"350\" cellpadding=\"4\" cellspacing=\"0\" border=\"0\" style=\"border:dotted 1px #999\">"); strReturn.Append("<tr><td colspan=\"3\" class=\"box_blue header\">"); strReturn.Append(oService.GetName(_serviceid)); strReturn.Append("</td></tr>"); // From if (_first == false) { strReturn.Append("<tr><td colspan=\"3\" align=\"right\" class=\"smalldefault\">"); strReturn.Append(oService.GetName(_previous_serviceid)); strReturn.Append("</td></tr>"); } // Conditions bool boolConditional = false; DataSet dsConditions = oServiceEditor.GetWorkflowConditions(_previous_serviceid, _serviceid, 1); if (dsConditions.Tables[0].Rows.Count > 0) { boolConditional = true; if (oService.GetWorkflow(_previous_serviceid, _serviceid, "only") == "1") { strReturn.Append("<tr><td colspan=\"3\" class=\"redbold\">Initiate ONLY when:</td></tr>"); } else if (oService.GetWorkflow(_previous_serviceid, _serviceid, "only") == "0") { strReturn.Append("<tr><td colspan=\"3\" class=\"redbold\">Always initiate UNLESS:</td></tr>"); } else { boolConditional = false; } if (boolConditional) { for (int cc = 0; cc < dsConditions.Tables[0].Rows.Count; cc++) { DataSet dsConditionValues = oServiceEditor.GetWorkflowConditionValues(Int32.Parse(dsConditions.Tables[0].Rows[cc]["id"].ToString()), 0, 0); if (dsConditionValues.Tables[0].Rows.Count > 0) { if (cc > 0) { strReturn.Append("<tr><td></td><td colspan=\"2\" class=\"redbold\"> -- -- -- OR -- -- -- </td></tr>"); } strReturn.Append("<tr><td></td><td colspan=\"2\">"); for (int vv = 0; vv < dsConditionValues.Tables[0].Rows.Count; vv++) { if (vv > 0) { strReturn.Append(" <b>and</b> "); } strReturn.Append(dsConditionValues.Tables[0].Rows[vv]["question"].ToString()); strReturn.Append(" = ""); strReturn.Append(dsConditionValues.Tables[0].Rows[vv]["value"].ToString()); strReturn.Append(""<br/>"); } strReturn.Append("</td></tr>"); } } } } // Managers int intWorkflowServiceID = 0; if (Int32.TryParse(oService.Get(_serviceid, "workflow_userid"), out intWorkflowServiceID) == true && intWorkflowServiceID > 0) { strReturn.Append("<tr><td colspan=\"3\" class=\"greenbold\">" + (boolConditional ? "<br/>" : "") + "<b>Assign To (Service):</td></tr>"); strReturn.Append("<tr><td></td><td colspan=\"2\">"); strReturn.Append(oService.GetName(intWorkflowServiceID)); strReturn.Append("</td></tr>"); } else { DataSet dsTechnicians = oService.GetUser(_serviceid, 0); if (dsTechnicians.Tables[0].Rows.Count > 0) { strReturn.Append("<tr><td colspan=\"3\" class=\"greenbold\">" + (boolConditional ? "<br/>" : "") + "<b>Assign To (Technician):</td></tr>"); foreach (DataRow drTechnician in dsTechnicians.Tables[0].Rows) { strReturn.Append("<tr><td></td><td colspan=\"2\">"); strReturn.Append(oUser.GetFullName(Int32.Parse(drTechnician["userid"].ToString()))); strReturn.Append("</td></tr>"); } } else { strReturn.Append("<tr><td colspan=\"3\" class=\"greenbold\">" + (boolConditional ? "<br/>" : "") + "<b>Assign By:</td></tr>"); DataSet dsManagers = oService.GetUser(_serviceid, 1); foreach (DataRow drManager in dsManagers.Tables[0].Rows) { strReturn.Append("<tr><td></td><td colspan=\"2\">"); strReturn.Append(oUser.GetFullName(Int32.Parse(drManager["userid"].ToString()))); strReturn.Append("</td></tr>"); } } } if (_first) { DataSet dsSR = oServiceEditor.GetConfigs(_serviceid, 0, 1); // Original Request Details strReturn.Append("<tr><td colspan=\"3\"><br/><b>Service Request Questions:</b></td></tr>"); foreach (DataRow drSR in dsSR.Tables[0].Rows) { strReturn.Append("<tr><td nowrap valign=\"top\" nowrap><img src=\"/images/help.gif\" border=\"0\"/></td><td colspan=\"2\" width=\"100%\">"); strReturn.Append(drSR["question"].ToString() + "<br/>"); strReturn.Append("</td></tr>"); DataSet dsConfigs = oServiceEditor.GetConfigValues(Int32.Parse(drSR["id"].ToString())); foreach (DataRow drConfig in dsConfigs.Tables[0].Rows) { strReturn.Append("<tr><td></td><td valign=\"top\" nowrap>-</td><td width=\"100%\">"); strReturn.Append(drConfig["value"].ToString() + "<br/>"); strReturn.Append("</td></tr>"); } } } // Workload Manager DataSet dsWM = oServiceEditor.GetConfigs(_serviceid, 1, 1); DataView dvWM = dsWM.Tables[0].DefaultView; dvWM.Sort = "wm ASC"; strReturn.Append("<tr><td colspan=\"3\"><br/><b>Workload Manager Fields:</b></td></tr>"); foreach (DataRowView drWM in dvWM) { bool boolWM = (drWM["wm"].ToString() == "1"); bool boolInherited = (drWM["inherited"].ToString() == "1"); strReturn.Append("<tr>"); if (boolInherited) { strReturn.Append("<td nowrap valign=\"top\" nowrap><img src=\"/images/hand_right.gif\" border=\"0\"/></td><td colspan=\"2\" width=\"100%\">"); } else { strReturn.Append("<td nowrap valign=\"top\" nowrap><img src=\"/images/help.gif\" border=\"0\"/></td><td colspan=\"2\" width=\"100%\">"); } //strReturn.Append(boolWM ? "" : "<i>"); //strReturn.Append(boolInherited ? "<span class=\"component_unavailable\">" : ""); strReturn.Append(drWM["question"].ToString()); //strReturn.Append(boolInherited ? "</span>" : ""); //strReturn.Append(boolWM ? "" : "</i>"); strReturn.Append("</td></tr>"); DataSet dsConfigs = oServiceEditor.GetConfigValues(Int32.Parse(drWM["id"].ToString())); foreach (DataRow drConfig in dsConfigs.Tables[0].Rows) { if (boolInherited) { strReturn.Append("<tr><td></td><td valign=\"top\" nowrap>-></td><td width=\"100%\">"); } else { strReturn.Append("<tr><td></td><td valign=\"top\" nowrap>-</td><td width=\"100%\">"); } //strReturn.Append(boolInherited ? "<span class=\"component_unavailable\">" : ""); strReturn.Append(drConfig["value"].ToString() + "<br/>"); //strReturn.Append(boolInherited ? "</span>" : ""); strReturn.Append("</td></tr>"); } } strReturn.Append("</table><br/>"); return(strReturn); }