private void LoadStatus(int _resourceid) { int intResourceWorkflow = Int32.Parse(lblResourceWorkflow.Text); int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow); ddlCurrentStatus.SelectedValue = oResourceRequest.GetWorkflow(intResourceWorkflow, "status"); }
private void LoadInformation(int _request) { if (intProject > 0) { lblName.Text = oProject.Get(intProject, "name"); lblNumber.Text = oProject.Get(intProject, "number"); lblType.Text = "Project"; } else { lblName.Text = oResourceRequest.GetWorkflow(_request, "name"); lblNumber.Text = "CVT" + intRequest.ToString(); lblType.Text = "Task"; } if (Request.QueryString["div"] != null) { switch (Request.QueryString["div"]) { case "E": boolExecution = true; break; } } if (boolDetails == false && boolExecution == false) { boolDetails = true; } }
public void UpdateCheckboxes(HttpRequest oForm, int _resourceid, int _requestid, int _itemid, int _number) { ResourceRequest oResourceRequest = new ResourceRequest(user, dsn); bool boolJoined = (oResourceRequest.GetWorkflow(_resourceid, "joined") == "1"); // First, uncheck the checkboxes. if (boolJoined) { oResourceRequest.DeleteDetails(_requestid, _itemid, _number); } else { oResourceRequest.DeleteDetails(_requestid, _itemid, _number, _resourceid); } int intParent = oResourceRequest.GetWorkflowParent(_resourceid); DataSet dsWF = oResourceRequest.GetWorkflowsParent(intParent); if (boolJoined) { foreach (DataRow drWF in dsWF.Tables[0].Rows) { oResourceRequest.DeleteWorkflowHours(Int32.Parse(drWF["id"].ToString())); oResourceRequest.UpdateWorkflowUsed(Int32.Parse(drWF["id"].ToString()), 0.00); } } else { oResourceRequest.DeleteWorkflowHours(_resourceid); oResourceRequest.UpdateWorkflowUsed(_resourceid, 0.00); } double dblQuantity = double.Parse(oResourceRequest.GetWorkflow(_resourceid, "devices")); foreach (string strForm in oForm.Form) { string strNameID = strForm; strNameID = strNameID.ToUpper(); if (strForm.StartsWith("hdnDetail_") == true) { string strValue = oForm.Form[strForm]; int intDetail = Int32.Parse(strForm.Substring(strForm.IndexOf("hdnDetail_") + 10)); oResourceRequest.AddDetails(_requestid, _itemid, _number, (boolJoined ? 0 : _resourceid), intDetail, Int32.Parse(strValue)); if (Int32.Parse(strValue) == 1) { // selected - the following function will update all JOINED values oResourceRequest.UpdateWorkflowHours(_resourceid, (double.Parse(Get(intDetail, "hours")) * dblQuantity)); } } } }
private void LoadInformation(int _request) { if (intProject > 0) { lblName.Text = oProject.Get(intProject, "name"); lblNumber.Text = oProject.Get(intProject, "number"); lblType.Text = "Project"; } else { lblName.Text = oResourceRequest.GetWorkflow(_request, "name"); lblNumber.Text = "CVT" + intRequest.ToString(); lblType.Text = "Task"; } }
protected void btnSubmit_Click(Object Sender, EventArgs e) { bool boolSent = false; DataSet dsWF = oResourceRequest.GetWorkflow(intResource); int intTo = 0; if (dsWF.Tables[0].Rows.Count > 0 && Int32.TryParse(Request.Form[hdnEmployee.UniqueID], out intTo) == true) { int intParent = Int32.Parse(dsWF.Tables[0].Rows[0]["parent"].ToString()); DataSet ds = oResourceRequest.Get(intParent); if (ds.Tables[0].Rows.Count > 0) { int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString()); int intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString()); int intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString()); oFunction.SendEmail("Service Request [CVT" + intRequest.ToString() + "-" + intService.ToString() + "-" + intNumber.ToString() + "]", oUser.GetName(intTo), "", oUser.GetName(intProfile), "Service Request [CVT" + intRequest.ToString() + "-" + intService.ToString() + "-" + intNumber.ToString() + "]", "<p>The following service request information has been sent to you by <b>" + oUser.GetFullName(intProfile) + "</b>.</p>" + (txtComments.Text == "" ? "" : "<p>" + txtComments.Text + "</p>") + "<p>" + oResourceRequest.GetSummary(intParent, intResource, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p>", true, false); boolSent = true; } } if (boolSent) { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "reload", "<script type=\"text/javascript\">alert('An email was successfully sent.');window.parent.location.reload();window.close();<" + "/" + "script>"); } else { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "reload", "<script type=\"text/javascript\">alert('There was a problem sending the email.');window.parent.location.reload();window.close();<" + "/" + "script>"); } }
private void LoadInformation(int intResourceWorkflow) { int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow); int intRequest = Int32.Parse(oResourceRequest.Get(intResourceParent, "requestid")); DataSet ds = oRequest.Get(intRequest); lblName.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "name"); lblStart.Text = DateTime.Parse(ds.Tables[0].Rows[0]["start_date"].ToString()).ToLongDateString(); lblEnd.Text = DateTime.Parse(ds.Tables[0].Rows[0]["end_date"].ToString()).ToLongDateString(); lblDescription.Text = ds.Tables[0].Rows[0]["description"].ToString(); if (Request.QueryString["div"] != null) { switch (Request.QueryString["div"]) { case "E": boolExecution = true; break; case "C": boolChange = true; break; case "M": boolMyDocuments = true; break; } } if (boolExecution == false && boolChange == false && boolMyDocuments == false) { boolExecution = true; } }
private string GetImplementor(int intProject, int intAnswer) { string strImplementor = ""; try { int intImplementor = 0; DataSet dsTasks = oOnDemandTasks.GetPending(intAnswer); if (dsTasks.Tables[0].Rows.Count > 0) { intImplementor = Int32.Parse(dsTasks.Tables[0].Rows[0]["resourceid"].ToString()); intImplementor = Int32.Parse(oResourceRequest.GetWorkflow(intImplementor, "userid")); } else { intImplementor = -999; } if (intImplementor > 0 || intImplementor == -999) { strImplementor = oUser.GetFullName(intImplementor) + " (" + oUser.GetName(intImplementor) + ")"; } } catch { strImplementor = "** ERROR **"; } return(strImplementor); }
private void LoadInformation(int _request) { lblView.Text = oRequestField.GetBodyWorkflow(_request, dsnServiceEditor, intEnvironment, dsnAsset, dsnIP); if (intProject > 0) { lblName.Text = oProject.Get(intProject, "name"); lblNumber.Text = oProject.Get(intProject, "number"); lblType.Text = "Project"; } else { lblName.Text = oResourceRequest.GetWorkflow(_request, "name"); //lblName.Text = oResourceRequest.GetWorkflow(_request, "name"); lblNumber.Text = "CVT" + intRequest.ToString(); lblType.Text = "Task"; } DataSet dsAudit = oAudit.GetError(intRequest, intService, intNumber); if (dsAudit.Tables[0].Rows.Count > 0) { radActionFix.Checked = (dsAudit.Tables[0].Rows[0]["fixed"].ToString() == "1"); radActionIgnore.Checked = (dsAudit.Tables[0].Rows[0]["fixed"].ToString() == "0"); if (radActionIgnore.Checked) { trIgnore.Style["display"] = "inline"; txtReason.Text = dsAudit.Tables[0].Rows[0]["reason"].ToString(); } } if (Request.QueryString["div"] != null) { switch (Request.QueryString["div"]) { case "E": boolExecution = true; break; } } if (boolDetails == false && boolExecution == false) { boolDetails = true; } }
private void LoadInformation(int _request) { lblView.Text = oRequestField.GetBodyWorkflow(_request, dsnServiceEditor, intEnvironment, dsnAsset, dsnIP); if (intProject > 0) { lblName.Text = oProject.Get(intProject, "name"); lblNumber.Text = oProject.Get(intProject, "number"); lblType.Text = "Project"; } else { lblName.Text = oResourceRequest.GetWorkflow(_request, "name"); //lblName.Text = oResourceRequest.GetWorkflow(_request, "name"); lblNumber.Text = "CVT" + intRequest.ToString(); lblType.Text = "Task"; } if (Request.QueryString["div"] != null) { switch (Request.QueryString["div"]) { case "E": boolExecution = true; break; case "C": boolChange = true; break; case "D": boolDocuments = true; break; case "S": boolStatusUpdates = true; break; } } if (boolDetails == false && boolExecution == false && boolStatusUpdates == false && boolChange == false && boolDocuments == false) { boolDetails = true; } }
public string LoadCheckboxes(int _requestid, int _itemid, int _number, int _resourceid, int _serviceid) { ResourceRequest oResourceRequest = new ResourceRequest(user, dsn); DataSet dsWF = oResourceRequest.GetRequestService(_requestid, _serviceid, _number); bool boolDone = false; if (dsWF.Tables[0].Rows.Count > 0) { int intStatus = 0; Int32.TryParse(dsWF.Tables[0].Rows[0]["status"].ToString(), out intStatus); boolDone = (intStatus == 3 || dsWF.Tables[0].Rows[0]["completed"].ToString() != ""); } StringBuilder sbReturn = new StringBuilder(); DataSet ds = Gets(_serviceid, 0, 1); foreach (DataRow dr in ds.Tables[0].Rows) { int intID = Int32.Parse(dr["id"].ToString()); if (dr["checkbox"].ToString() == "1") { int intValue = oResourceRequest.GetDetailValue(_requestid, _itemid, _number, (oResourceRequest.GetWorkflow(_resourceid, "joined") == "1" ? 0 : _resourceid), intID); if (intValue == -1) { intValue = 0; oResourceRequest.AddDetails(_requestid, _itemid, _number, (oResourceRequest.GetWorkflow(_resourceid, "joined") == "1" ? 0 : _resourceid), intID, intValue); } sbReturn.Append("<tr><td><table id=\"chkTaskList" + _resourceid.ToString() + "\" cellpadding=\"2\" cellspacing=\"1\" border=\"0\"><tr><td valign=\"top\"><input id=\"chkDetail_"); sbReturn.Append(intID.ToString()); sbReturn.Append("\" type=\"checkbox\" name=\"chkDetail_"); sbReturn.Append(intID.ToString()); sbReturn.Append("\" onclick=\"UpdateRRCheckDetail('hdnDetail_"); sbReturn.Append(intID.ToString()); sbReturn.Append("', this);\""); sbReturn.Append(intValue == 1 || boolDone ? " checked" : ""); sbReturn.Append(" /></td><td><label for=\"chkDetail_"); sbReturn.Append(intID.ToString()); sbReturn.Append("\">"); sbReturn.Append(dr["name"].ToString()); sbReturn.Append("</label><input type=\"hidden\" name=\"hdnDetail_"); sbReturn.Append(intID.ToString()); sbReturn.Append("\" id=\"hdnDetail_"); sbReturn.Append(intID.ToString()); sbReturn.Append("\" value=\""); sbReturn.Append(intValue.ToString()); sbReturn.Append("\" /></td></tr></table></td></tr>"); } } if (sbReturn.ToString() != "") { sbReturn.Insert(0, "<table cellpadding=\"2\" cellspacing=\"1\" border=\"0\">"); sbReturn.Append("</table>"); } return(sbReturn.ToString()); }
private bool LoadInformation(int _request) { lblView.Text = oRequestField.GetBodyWorkflow(_request, dsnServiceEditor, intEnvironment, dsnAsset, dsnIP); if (intProject > 0) { lblName.Text = oProject.Get(intProject, "name"); lblNumber.Text = oProject.Get(intProject, "number"); lblType.Text = "Project"; } else { lblName.Text = oResourceRequest.GetWorkflow(_request, "name"); lblNumber.Text = "CVT" + intRequest.ToString(); lblType.Text = "Task"; } bool boolDone = false; DataSet ds = oCustomized.GetServerArchive(intRequest, intItem, intNumber); if (ds.Tables[0].Rows.Count > 0) { txtHostname.Text = ds.Tables[0].Rows[0]["hostname"].ToString(); chkHostname.Checked = (txtHostname.Text != ""); lblG1.Text = txtHostname.Text; chkG1.Checked = (ds.Tables[0].Rows[0]["G1"].ToString() == "1"); chkG2.Checked = (ds.Tables[0].Rows[0]["G2"].ToString() == "1"); chkG3.Checked = (ds.Tables[0].Rows[0]["G3"].ToString() == "1"); chkG4.Checked = (ds.Tables[0].Rows[0]["G4"].ToString() == "1"); chkG5.Checked = (ds.Tables[0].Rows[0]["G5"].ToString() == "1"); boolDone = (txtHostname.Text.Trim() != "" && chkG1.Checked && chkG2.Checked && chkG3.Checked && chkG4.Checked && chkG5.Checked); } if (Request.QueryString["div"] != null) { switch (Request.QueryString["div"]) { case "E": boolExecution = true; break; case "X": boolExtension = true; break; } } if (boolDetails == false && boolExecution == false && boolExtension == false) { boolDetails = true; } return(boolDone); }
private bool LoadInformation(int _request_workflow) { if (intProject > 0) { lblName.Text = oProject.Get(intProject, "name"); lblNumber.Text = oProject.Get(intProject, "number"); lblType.Text = "Project"; } else { lblName.Text = oResourceRequest.GetWorkflow(_request_workflow, "name"); lblNumber.Text = "CVT" + intRequest.ToString(); lblType.Text = "Task"; } bool boolDone = false; DataSet ds = oOnDemandTasks.GetVirtualII(intRequest, intItem, intNumber); if (ds.Tables[0].Rows.Count > 0) { Forecast oForecast = new Forecast(intProfile, dsn); int intAnswer = Int32.Parse(ds.Tables[0].Rows[0]["answerid"].ToString()); lblAnswer.Text = intAnswer.ToString(); btnView.Attributes.Add("onclick", "return OpenWindow('FORECAST_EQUIPMENT','?id=" + intAnswer.ToString() + "');"); //btnBirth.Attributes.Add("onclick", "return OpenWindow('PDF_BIRTH','?id=" + intAnswer.ToString() + "');"); //btnSC.Attributes.Add("onclick", "return OpenWindow('PDF_BIRTH','?id=" + intAnswer.ToString() + "');"); lblView.Text = oOnDemandTasks.GetBody(intAnswer, intImplementorDistributed, intImplementorMidrange); int intModel = Int32.Parse(ds.Tables[0].Rows[0]["modelid"].ToString()); ModelsProperties oModelsProperties = new ModelsProperties(intProfile, dsn); intModel = Int32.Parse(oModelsProperties.Get(intModel, "modelid")); Models oModel = new Models(intProfile, dsn); int intType = Int32.Parse(oModel.Get(intModel, "typeid")); Types oType = new Types(intProfile, dsn); string strExecute = oType.Get(intType, "forecast_execution_path"); if (strExecute != "") { btnExecute.Attributes.Add("onclick", "return OpenWindow('FORECAST_EXECUTE','" + strExecute + "?id=" + intAnswer.ToString() + "');"); } chk1.Checked = (ds.Tables[0].Rows[0]["chk1"].ToString() == "1"); chk2.Checked = (ds.Tables[0].Rows[0]["chk2"].ToString() == "1"); txtSCID.Text = ds.Tables[0].Rows[0]["scid"].ToString(); chk3.Checked = (ds.Tables[0].Rows[0]["chk3"].ToString() == "1"); chk4.Checked = (ds.Tables[0].Rows[0]["chk4"].ToString() == "1"); boolDone = (chk1.Checked && chk2.Checked && chk3.Checked && chk4.Checked); img1.ImageUrl = "/images/green_arrow.gif"; if (chk1.Checked == true) { btnExecute.Enabled = false; img1.ImageUrl = "/images/check.gif"; img2.ImageUrl = "/images/green_arrow.gif"; chk2.Enabled = true; Servers oServer = new Servers(intProfile, dsn); DataSet dsAnswer = oServer.GetAnswer(intAnswer); foreach (DataRow drAnswer in dsAnswer.Tables[0].Rows) { if (lbl1.Text != "") { lbl1.Text += "<br/>"; } int intServerName = Int32.Parse(drAnswer["nameid"].ToString()); ServerName oServerName = new ServerName(0, dsn); lbl1.Text += "Server Name: " + oservername.getname2(intServerName, 0) + "<br/>"; int intServer = Int32.Parse(drAnswer["id"].ToString()); Zeus oZeus = new Zeus(intProfile, dsnZeus); DataSet dsZeus = oZeus.GetBuildServer(intServer); if (dsZeus.Tables[0].Rows.Count > 0) { lbl1.Text += "Serial Number: " + dsZeus.Tables[0].Rows[0]["serial"].ToString() + "<br/>"; } int intDomain = Int32.Parse(drAnswer["domainid"].ToString()); Domains oDomain = new Domains(intProfile, dsn); boolMove = (oDomain.Get(intDomain, "move") == "1"); if (boolMove == true) { lbl1.Text += "DHCP Address: " + drAnswer["dhcp"].ToString() + "<br/>"; } int intIPAddress = 0; IPAddresses oIPAddresses = new IPAddresses(0, dsnIP, dsn); if (drAnswer["ipaddressid"].ToString() != "") { intIPAddress = Int32.Parse(drAnswer["ipaddressid"].ToString()); lbl1.Text += "Assigned IP Address: " + oIPAddresses.GetName(intIPAddress, 0) + "<br/>"; } if (drAnswer["ipaddressid_final"].ToString() != "") { intIPAddress = Int32.Parse(drAnswer["ipaddressid_final"].ToString()); lbl1.Text += "Final IP Address: " + oIPAddresses.GetName(intIPAddress, 0) + "<br/>"; } } } } if (boolMove == false) { } if (chk2.Checked == true) { chk1.Enabled = false; img2.ImageUrl = "/images/check.gif"; img3.ImageUrl = "/images/green_arrow.gif"; chk3.Enabled = true; } if (chk3.Checked == true) { chk2.Enabled = false; img3.ImageUrl = "/images/check.gif"; img4.ImageUrl = "/images/green_arrow.gif"; chk4.Enabled = true; } if (chk4.Checked == true) { chk3.Enabled = false; img4.ImageUrl = "/images/check.gif"; } if (Request.QueryString["div"] != null) { switch (Request.QueryString["div"]) { case "E": boolExecution = true; break; } } if (boolDetails == false && boolExecution == false) { boolDetails = true; } return(boolDone); }
private bool LoadInformation(int _request) { lblView.Text = oRequestField.GetBodyWorkflow(_request, dsnServiceEditor, intEnvironment, dsnAsset, dsnIP); if (intProject > 0) { lblName.Text = oProject.Get(intProject, "name"); lblNumber.Text = oProject.Get(intProject, "number"); lblType.Text = "Project"; } else { lblName.Text = oResourceRequest.GetWorkflow(_request, "name"); lblNumber.Text = "CVT" + intRequest.ToString(); lblType.Text = "Task"; } bool boolDone = false; DataSet ds = oCustomized.GetServerArchive(intRequest, intItem, intNumber); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["backto"].ToString() == "Virtual") { panTestCenterVirtual.Visible = true; lblT1.Text = ds.Tables[0].Rows[0]["hostname"].ToString(); if (lblT1.Text == "") { lblT1.Text = "N/A"; } chkTV1.Checked = (ds.Tables[0].Rows[0]["TV1"].ToString() == "1"); chkTV2.Checked = (ds.Tables[0].Rows[0]["TV2"].ToString() == "1"); boolDone = (chkTV1.Checked && chkTV2.Checked); } else { panTestCenterPhysical.Visible = true; Models oModel = new Models(intProfile, dsn); lblModelNumber.Text = oModel.Get(Int32.Parse(ds.Tables[0].Rows[0]["modelid"].ToString()), "name"); chkTP1.Checked = (ds.Tables[0].Rows[0]["TP1"].ToString() == "1"); chkTP2.Checked = (ds.Tables[0].Rows[0]["TP2"].ToString() == "1"); chkTP3.Checked = (ds.Tables[0].Rows[0]["TP3"].ToString() == "1"); chkTP4.Checked = (ds.Tables[0].Rows[0]["TP4"].ToString() == "1"); chkTP5.Checked = (ds.Tables[0].Rows[0]["TP5"].ToString() == "1"); chkTP6.Checked = (ds.Tables[0].Rows[0]["TP6"].ToString() == "1"); chkTP7.Checked = (ds.Tables[0].Rows[0]["TP7"].ToString() == "1"); chkTP8.Checked = (ds.Tables[0].Rows[0]["TP8"].ToString() == "1"); chkTP9.Checked = (ds.Tables[0].Rows[0]["TP9"].ToString() == "1"); chkTP10.Checked = (ds.Tables[0].Rows[0]["TP10"].ToString() == "1"); boolDone = (chkTP1.Checked && chkTP2.Checked && chkTP3.Checked && chkTP4.Checked && chkTP5.Checked && chkTP6.Checked && chkTP7.Checked && chkTP8.Checked && chkTP9.Checked && chkTP10.Checked); } } if (Request.QueryString["div"] != null) { switch (Request.QueryString["div"]) { case "E": boolExecution = true; break; case "X": boolExtension = true; break; } } if (boolDetails == false && boolExecution == false && boolExtension == false) { boolDetails = true; } return(boolDone); }
protected void Page_Load(object sender, EventArgs e) { AuthenticateUser(); intProfile = Int32.Parse(Request.Cookies["profileid"].Value); oResourceRequest = new ResourceRequest(intProfile, dsn); oRequestItem = new RequestItems(intProfile, dsn); oApplication = new Applications(intProfile, dsn); oRequest = new Requests(intProfile, dsn); oProject = new Projects(intProfile, dsn); oProjectNumber = new ProjectNumber(intProfile, dsn); oService = new Services(intProfile, dsn); oUser = new Users(intProfile, dsn); oDelegate = new Delegates(intProfile, dsn); if (Request.QueryString["action"] != null && Request.QueryString["action"] != "") { panFinish.Visible = true; } else { panForm.Visible = true; if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "") { int intResourceWorkflow = Int32.Parse(Request.QueryString["rrid"]); int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow); DataSet ds = oResourceRequest.Get(intResourceParent); if (ds.Tables[0].Rows.Count > 0) { int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid")); int intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString()); int intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString()); int intApp = oRequestItem.GetItemApplication(intItem); //if (intProfile == intUser || oService.IsManager(intService, intProfile) || oDelegate.Get(intUser, intProfile) > 0 || (oApplication.IsManager(intApp, intProfile) && oApplication.Get(intApp, "disable_manager") != "1") || (oUser.IsManager(intUser, intProfile, true) && oApplication.Get(intApp, "disable_manager") != "1")) //{ int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString()); hdnRequestID.Value = intRequest.ToString(); int intProject = oRequest.GetProjectNumber(intRequest); string strPath = ""; if (intItem == 0) { strPath = strPCWM; } else if (intItem == -1) { strPath = strTaskWM; } else { if (oApplication.Get(intApp, "tpm") != "1" && oProject.Get(intProject, "number") == "") { oProject.Update(intProject, oProjectNumber.New()); } strPath = oService.Get(intService, "wm_path"); } if (strPath != "") { oForm.Controls.Add((Control)LoadControl(strPath)); } string strTitle = "Task"; if (intProject > 0) { strTitle = oProject.Get(intProject, "name"); } Master.Page.Title = strTitle + " | " + oService.GetName(intService); //} //else // panDenied.Visible = true; } else { panDenied.Visible = true; } } } btnFinish.Attributes.Add("onclick", "return CloseWindow();"); btnClose.Attributes.Add("onclick", "return CloseWindow();"); }
protected void Page_Load(object sender, EventArgs e) { intProfile = Int32.Parse(Request.Cookies["profileid"].Value); oProject = new Projects(intProfile, dsn); oFunction = new Functions(intProfile, dsn, intEnvironment); oUser = new Users(intProfile, dsn); oPage = new Pages(intProfile, dsn); oResourceRequest = new ResourceRequest(intProfile, dsn); oRequestItem = new RequestItems(intProfile, dsn); oRequest = new Requests(intProfile, dsn); oService = new Services(intProfile, dsn); oServiceRequest = new ServiceRequests(intProfile, dsn); oRequestField = new RequestFields(intProfile, dsn); oApplication = new Applications(intProfile, dsn); oServiceDetail = new ServiceDetails(intProfile, dsn); oDelegate = new Delegates(intProfile, dsn); oDocument = new Documents(intProfile, dsn); oOnDemandTasks = new OnDemandTasks(intProfile, dsn); if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "") { intApplication = Int32.Parse(Request.QueryString["applicationid"]); } if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "") { intPage = Int32.Parse(Request.QueryString["pageid"]); } if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "") { intApplication = Int32.Parse(Request.Cookies["application"].Value); } if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "") { // Start Workflow Change lblResourceWorkflow.Text = Request.QueryString["rrid"]; int intResourceWorkflow = Int32.Parse(Request.QueryString["rrid"]); int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow); ds = oResourceRequest.Get(intResourceParent); // End Workflow Change intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString()); lblRequestedBy.Text = oUser.GetFullName(oRequest.GetUser(intRequest)); lblRequestedOn.Text = DateTime.Parse(oRequest.Get(intRequest, "created")).ToString(); lblDescription.Text = oRequest.Get(intRequest, "description"); if (lblDescription.Text == "") { lblDescription.Text = "<i>No information</i>"; } intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString()); intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString()); // Start Workflow Change bool boolComplete = (oResourceRequest.GetWorkflow(intResourceWorkflow, "status") == "3"); int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid")); txtCustom.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "name"); double dblAllocated = double.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated")); boolJoined = (oResourceRequest.GetWorkflow(intResourceWorkflow, "joined") == "1"); // End Workflow Change intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString()); lblService.Text = oService.Get(intService, "name"); int intApp = oRequestItem.GetItemApplication(intItem); if (Request.QueryString["save"] != null && Request.QueryString["save"] != "") { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "saved", "<script type=\"text/javascript\">alert('Information Saved Successfully');<" + "/" + "script>"); } if (Request.QueryString["status"] != null && Request.QueryString["status"] != "") { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "statusd", "<script type=\"text/javascript\">alert('Weekly Status has been Added');<" + "/" + "script>"); } if (!IsPostBack) { double dblUsed = oResourceRequest.GetWorkflowUsed(intResourceWorkflow); lblUpdated.Text = oResourceRequest.GetUpdated(intResourceParent); if (dblAllocated == dblUsed) { if (boolComplete == false) { oFunction.ConfigureToolButton(btnComplete, "/images/tool_complete"); btnComplete.Attributes.Add("onclick", "return confirm('Are you sure you want to mark this as completed and remove it from your workload?');"); } else { oFunction.ConfigureToolButton(btnComplete, "/images/tool_complete"); btnComplete.Attributes.Add("onclick", "alert('This task has already been marked COMPLETE. You can close this window.');return false;"); } } else { btnComplete.ImageUrl = "/images/tool_complete_dbl.gif"; btnComplete.Enabled = false; } if (oService.Get(intService, "sla") != "") { oFunction.ConfigureToolButton(btnSLA, "/images/tool_sla"); int intDays = oResourceRequest.GetSLA(intResourceParent); if (intDays < 1) { btnSLA.Style["border"] = "solid 2px #FF0000"; } else if (intDays < 3) { btnSLA.Style["border"] = "solid 2px #FF9999"; } btnSLA.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST_SLA','?rrid=" + intResourceParent.ToString() + "');"); } else { btnSLA.ImageUrl = "/images/tool_sla_dbl.gif"; btnSLA.Enabled = false; } oFunction.ConfigureToolButton(btnEmail, "/images/tool_email"); btnEmail.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST_EMAIL','?rrid=" + intResourceWorkflow.ToString() + "&type=GENERIC');"); dblUsed = (dblUsed / dblAllocated) * 100; strCheckboxes = oServiceDetail.LoadCheckboxes(intRequest, intItem, intNumber, intResourceWorkflow, intService); if (oService.Get(intService, "tasks") != "1" || strCheckboxes == "") { if (oService.Get(intService, "no_slider") == "1") { panNoSlider.Visible = true; btnComplete.ImageUrl = "/images/tool_complete.gif"; btnComplete.Enabled = true; btnComplete.Attributes.Add("onclick", "return confirm('Are you sure you want to mark this as completed and remove it from your workload?');"); btnComplete.CommandArgument = "FAST"; } else { panSlider.Visible = true; sldHours._StartPercent = dblUsed.ToString(); sldHours._TotalHours = dblAllocated.ToString(); } } else { panCheckboxes.Visible = true; } intProject = oRequest.GetProjectNumber(intRequest); hdnTab.Value = "D"; panWorkload.Visible = true; LoadStatus(intResourceWorkflow); LoadChange(intResourceWorkflow); LoadInformation(intResourceWorkflow); chkDescription.Checked = (Request.QueryString["doc"] != null); lblDocuments.Text = oDocument.GetDocuments_Request(intRequest, 0, Request.PhysicalApplicationPath, 1, (Request.QueryString["doc"] != null)); // GetDocuments(string _physical, int _projectid, int _requestid, int _userid, int _security, bool _show_description, bool _mine) //lblDocuments.Text = oDocument.GetDocuments(Request.PhysicalApplicationPath, 0, intRequest, 0, 1, (Request.QueryString["doc"] != null), false); btnDenied.Attributes.Add("onclick", "return CloseWindow();"); oFunction.ConfigureToolButton(btnSave, "/images/tool_save"); oFunction.ConfigureToolButton(btnPrint, "/images/tool_print"); btnPrint.Attributes.Add("onclick", "return PrintWindow();"); oFunction.ConfigureToolButton(btnClose, "/images/tool_close"); btnClose.Attributes.Add("onclick", "return ExitWindow();"); btnSave.Attributes.Add("onclick", "return ValidateStatus('" + ddlStatus.ClientID + "','" + txtComments.ClientID + "');"); btnChange.Attributes.Add("onclick", "return ValidateText('" + txtNumber.ClientID + "','Please enter a change control number')" + " && ValidateDate('" + txtDate.ClientID + "','Please enter a valid implementation date')" + " && ValidateTime('" + txtTime.ClientID + "','Please enter a valid implementation time')" + ";"); imgDate.Attributes.Add("onclick", "return ShowCalendar('" + txtDate.ClientID + "');"); // 6/1/2009 - Load ReadOnly View if (oResourceRequest.CanUpdate(intProfile, intResourceWorkflow, false) == false) { oFunction.ConfigureToolButtonRO(btnSave, btnComplete); //panDenied.Visible = true; } } } else { panDenied.Visible = true; } }
private bool LoadInformation(int _request_workflow) { if (intProject > 0) { lblName.Text = oProject.Get(intProject, "name"); lblNumber.Text = oProject.Get(intProject, "number"); lblType.Text = "Project"; } else { lblName.Text = oResourceRequest.GetWorkflow(_request_workflow, "name"); lblNumber.Text = "CVT" + intRequest.ToString(); lblType.Text = "Task"; } bool boolDone = false; DataSet ds = oOnDemandTasks.GetVMWareII(intRequest, intItem, intNumber); if (ds.Tables[0].Rows.Count > 0) { Forecast oForecast = new Forecast(intProfile, dsn); int intAnswer = Int32.Parse(ds.Tables[0].Rows[0]["answerid"].ToString()); if (oForecast.IsHARoom(intAnswer) == true) { DataSet dsServer = oServer.GetAnswer(intAnswer); foreach (DataRow drServer in dsServer.Tables[0].Rows) { int intHA = Int32.Parse(drServer["id"].ToString()); DataSet dsHA = oServer.GetHA(intHA); if (dsHA.Tables[0].Rows.Count > 0) { if (lblHA.Text != "") { lblHA.Text += "<br/>"; } lblHA.Text += oServer.GetName(intHA, true) + " = " + oServer.GetName(Int32.Parse(dsHA.Tables[0].Rows[0]["serverid_ha"].ToString()), true); panHA.Visible = true; } } } lblAnswer.Text = intAnswer.ToString(); btnView.Attributes.Add("onclick", "return OpenWindow('FORECAST_EQUIPMENT','?id=" + intAnswer.ToString() + "');"); btnBirth.Attributes.Add("onclick", "return OpenWindow('PDF_BIRTH','?id=" + intAnswer.ToString() + "');"); btnSC.Attributes.Add("onclick", "return OpenWindow('PDF_BIRTH','?id=" + intAnswer.ToString() + "');"); lblView.Text = oOnDemandTasks.GetBody(intAnswer, intImplementorDistributed, intImplementorMidrange); int intModel = Int32.Parse(ds.Tables[0].Rows[0]["modelid"].ToString()); ModelsProperties oModelsProperties = new ModelsProperties(intProfile, dsn); intModel = Int32.Parse(oModelsProperties.Get(intModel, "modelid")); Models oModel = new Models(intProfile, dsn); int intType = Int32.Parse(oModel.Get(intModel, "typeid")); Types oType = new Types(intProfile, dsn); string strExecute = oType.Get(intType, "forecast_execution_path"); if (strExecute != "") { btnExecute.Attributes.Add("onclick", "return OpenWindow('FORECAST_EXECUTE','" + strExecute + "?id=" + intAnswer.ToString() + "');"); } chk1.Checked = (ds.Tables[0].Rows[0]["chk1"].ToString() == "1"); chk3.Checked = (ds.Tables[0].Rows[0]["chk3"].ToString() == "1"); chk4.Checked = (ds.Tables[0].Rows[0]["chk4"].ToString() == "1"); chk5.Checked = (ds.Tables[0].Rows[0]["chk5"].ToString() == "1"); chk6.Checked = (ds.Tables[0].Rows[0]["chk6"].ToString() == "1"); chk7.Checked = (ds.Tables[0].Rows[0]["chk7"].ToString() == "1"); chk8.Checked = (ds.Tables[0].Rows[0]["chk8"].ToString() == "1"); chk9.Checked = (ds.Tables[0].Rows[0]["chk9"].ToString() == "1"); chk10.Checked = (ds.Tables[0].Rows[0]["chk10"].ToString() == "1"); chk11.Checked = (ds.Tables[0].Rows[0]["chk11"].ToString() == "1"); int intNotifications = Int32.Parse(ds.Tables[0].Rows[0]["notifications"].ToString()); int intClass = Int32.Parse(oForecast.GetAnswer(intAnswer, "classid")); if (oClass.Get(intClass, "prod") != "1") { chk9.Checked = true; img9.ImageUrl = "/images/cancel.gif"; chk10.Checked = true; img10.ImageUrl = "/images/cancel.gif"; chk11.Checked = true; img11.ImageUrl = "/images/cancel.gif"; } boolDone = (chk1.Checked && chk3.Checked && chk4.Checked && chk5.Checked && chk6.Checked && chk7.Checked && chk8.Checked && chk9.Checked && chk10.Checked && chk11.Checked); img1.ImageUrl = "/images/green_arrow.gif"; if (chk1.Checked == true) { btnExecute.Enabled = false; img1.ImageUrl = "/images/check.gif"; img3.ImageUrl = "/images/green_arrow.gif"; chk3.Enabled = true; Servers oServer = new Servers(intProfile, dsn); DataSet dsAnswer = oServer.GetAnswer(intAnswer); foreach (DataRow drAnswer in dsAnswer.Tables[0].Rows) { if (lbl1.Text != "") { lbl1.Text += "<br/>"; } int intServer = Int32.Parse(drAnswer["id"].ToString()); int intServerName = Int32.Parse(drAnswer["nameid"].ToString()); ServerName oServerName = new ServerName(0, dsn); string strName = oServer.GetName(intServer, boolUsePNCNaming); lbl1.Text += "Server Name: " + strName + "<br/>"; Zeus oZeus = new Zeus(intProfile, dsnZeus); DataSet dsZeus = oZeus.GetBuildServer(intServer); if (dsZeus.Tables[0].Rows.Count > 0) { lbl1.Text += "Serial Number: " + dsZeus.Tables[0].Rows[0]["serial"].ToString() + "<br/>"; lbl1.Text += "Asset Tag: " + dsZeus.Tables[0].Rows[0]["asset"].ToString() + "<br/>"; } int intDomain = Int32.Parse(drAnswer["domainid"].ToString()); Domains oDomain = new Domains(intProfile, dsn); boolMove = (oDomain.Get(intDomain, "move") == "1"); if (boolMove == true) { lbl1.Text += "DHCP Address: " + drAnswer["dhcp"].ToString() + "<br/>"; } int intIPAddress = 0; IPAddresses oIPAddresses = new IPAddresses(0, dsnIP, dsn); lbl1.Text += "Assigned IP Address: " + oServer.GetIPs(intServer, 1, 0, 0, dsnIP, "", "") + "<br/>"; lbl1.Text += "Final IP Address: " + oServer.GetIPs(intServer, 0, 1, 0, dsnIP, "", "") + "<br/>"; Asset oAsset = new Asset(intProfile, dsnAsset); VMWare oVMWare = new VMWare(intProfile, dsn); int intAsset = 0; if (drAnswer["assetid"].ToString() != "") { intAsset = Int32.Parse(drAnswer["assetid"].ToString()); } if (intAsset > 0) { DataSet dsGuest = oVMWare.GetGuest(strName); if (dsGuest.Tables[0].Rows.Count > 0) { int intHost = Int32.Parse(dsGuest.Tables[0].Rows[0]["hostid"].ToString()); int intCluster = Int32.Parse(oVMWare.GetHost(intHost, "clusterid")); int intFolder = Int32.Parse(oVMWare.GetCluster(intCluster, "folderid")); int intDataCenter = Int32.Parse(oVMWare.GetFolder(intFolder, "datacenterid")); lbl1.Text += "DataCenter: " + oVMWare.GetDatacenter(intDataCenter, "name") + "<br/>"; lbl1.Text += "Host: " + oVMWare.GetHost(intHost, "name") + "<br/>"; int intDatastore = Int32.Parse(dsGuest.Tables[0].Rows[0]["datastoreid"].ToString()); lbl1.Text += "DataStore: " + oVMWare.GetDatastore(intDatastore, "name") + "<br/>"; int intPool = Int32.Parse(dsGuest.Tables[0].Rows[0]["poolid"].ToString()); //lbl1.Text += "Pool: " + oVMWare.GetPool(intPool, "name") + "<br/>"; int intVlan = Int32.Parse(dsGuest.Tables[0].Rows[0]["vlanid"].ToString()); lbl1.Text += "VLAN: " + oVMWare.GetVlan(intVlan, "name") + "<br/>"; } } Storage oStorage = new Storage(intProfile, dsn); int intCluster2 = Int32.Parse(drAnswer["clusterid"].ToString()); int intCSMConfig2 = Int32.Parse(drAnswer["csmconfigid"].ToString()); int intNumber2 = Int32.Parse(drAnswer["number"].ToString()); DataSet dsLuns = oStorage.GetLuns(intAnswer, 0, intCluster2, intCSMConfig2, intNumber2); StringBuilder sbStorage = new StringBuilder(); int intRow = 0; bool boolOverride = (oForecast.GetAnswer(intAnswer, "storage_override") == "1"); foreach (DataRow drLun in dsLuns.Tables[0].Rows) { intRow++; sbStorage.Append("<tr>"); sbStorage.Append("<td>"); sbStorage.Append(intRow.ToString()); sbStorage.Append("</td>"); string strLetter = drLun["letter"].ToString(); if (strLetter == "") { if (drLun["driveid"].ToString() == "-1000") { strLetter = "E"; } else if (drLun["driveid"].ToString() == "-100") { strLetter = "F"; } else if (drLun["driveid"].ToString() == "-10") { strLetter = "P"; } else if (drLun["driveid"].ToString() == "-1") { strLetter = "Q"; } } if ((boolOverride == true && drLun["driveid"].ToString() == "0") || oForecast.IsOSMidrange(intAnswer) == true) { sbStorage.Append("<td>"); sbStorage.Append(drLun["path"].ToString()); sbStorage.Append("</td>"); } else { sbStorage.Append("<td>"); sbStorage.Append(strLetter); sbStorage.Append(":"); sbStorage.Append(drLun["path"].ToString()); sbStorage.Append("</td>"); } sbStorage.Append("<td>"); sbStorage.Append(drLun["performance"].ToString()); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drLun["size"].ToString()); sbStorage.Append(" GB</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drLun["actual_size"].ToString() == "-1" ? "Pending" : drLun["actual_size"].ToString() + " GB"); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drLun["size_qa"].ToString()); sbStorage.Append(" GB</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drLun["actual_size_qa"].ToString() == "-1" ? "Pending" : drLun["actual_size_qa"].ToString() + " GB"); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drLun["size_test"].ToString()); sbStorage.Append(" GB</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drLun["actual_size_test"].ToString() == "-1" ? "Pending" : drLun["actual_size_test"].ToString() + " GB"); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drLun["replicated"].ToString() == "0" ? "No" : "Yes"); sbStorage.Append("</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drLun["actual_replicated"].ToString() == "-1" ? "Pending" : (drLun["actual_replicated"].ToString() == "0" ? "No" : "Yes")); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drLun["high_availability"].ToString() == "0" ? "No" : "Yes (" + drLun["size"].ToString() + " GB)"); sbStorage.Append("</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drLun["actual_high_availability"].ToString() == "-1" ? "Pending" : (drLun["actual_high_availability"].ToString() == "0" ? "No" : "Yes (" + drLun["actual_size"].ToString() + " GB)")); sbStorage.Append("</td>"); sbStorage.Append("</tr>"); DataSet dsPoints = oStorage.GetMountPoints(Int32.Parse(drLun["id"].ToString())); int intPoint = 0; foreach (DataRow drPoint in dsPoints.Tables[0].Rows) { intRow++; intPoint++; sbStorage.Append("<tr>"); sbStorage.Append("<td>"); sbStorage.Append(intRow.ToString()); sbStorage.Append("</td>"); if (oForecast.IsOSMidrange(intAnswer) == true) { sbStorage.Append("<td>"); sbStorage.Append(drPoint["path"].ToString()); sbStorage.Append("</td>"); } else { sbStorage.Append("<td>"); sbStorage.Append(strLetter); sbStorage.Append(":\\SH"); sbStorage.Append(drLun["driveid"].ToString()); sbStorage.Append("VOL"); sbStorage.Append(intPoint < 10 ? "0" : ""); sbStorage.Append(intPoint.ToString()); sbStorage.Append("</td>"); } sbStorage.Append("<td>"); sbStorage.Append(drPoint["performance"].ToString()); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drPoint["size"].ToString()); sbStorage.Append(" GB</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drPoint["actual_size"].ToString() == "-1" ? "Pending" : drPoint["actual_size"].ToString() + " GB"); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drPoint["size_qa"].ToString()); sbStorage.Append(" GB</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drPoint["actual_size_qa"].ToString() == "-1" ? "Pending" : drPoint["actual_size_qa"].ToString() + " GB"); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drPoint["size_test"].ToString()); sbStorage.Append(" GB</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drPoint["actual_size_test"].ToString() == "-1" ? "Pending" : drPoint["actual_size_test"].ToString() + " GB"); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drPoint["replicated"].ToString() == "0" ? "No" : "Yes"); sbStorage.Append("</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drPoint["actual_replicated"].ToString() == "-1" ? "Pending" : (drPoint["actual_replicated"].ToString() == "0" ? "No" : "Yes")); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drPoint["high_availability"].ToString() == "0" ? "No" : "Yes (" + drPoint["size"].ToString() + " GB)"); sbStorage.Append("</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drPoint["actual_high_availability"].ToString() == "-1" ? "Pending" : (drPoint["actual_high_availability"].ToString() == "0" ? "No" : "Yes (" + drPoint["actual_size"].ToString() + " GB)")); sbStorage.Append("</td>"); sbStorage.Append("</tr>"); } } if (sbStorage.ToString() != "") { sbStorage.Insert(0, "<tr class=\"bold\"><td></td><td>Path</td><td>Performance</td><td>Requested<br/>Size in Prod</td><td>Actual<br/>Size in Prod</td><td>Requested<br/>Size in QA</td><td>Actual<br/>Size in QA</td><td>Requested<br/>Size in Test</td><td>Actual<br/>Size in Test</td><td>Requested<br/>Replication</td><td>Actual<br/>Replication</td><td>Requested<br/>High Availability</td><td>Actual<br/>High Availability</td></tr>"); sbStorage.Insert(0, "<table width=\"100%\" cellpadding=\"2\" cellspacing=\"1\" border=\"0\">"); sbStorage.Append("</table>"); } lbl1.Text += sbStorage.ToString(); } } if (chk3.Checked == true) { img3.ImageUrl = "/images/check.gif"; img4.ImageUrl = "/images/green_arrow.gif"; chk4.Enabled = true; } if (chk4.Checked == true) { img4.ImageUrl = "/images/check.gif"; if (boolMove == true) { img5.ImageUrl = "/images/green_arrow.gif"; chk5.Enabled = true; } else { chk5.Checked = true; img7.ImageUrl = "/images/green_arrow.gif"; chk7.Enabled = true; } } if (chk5.Checked == true) { if (boolMove == true) { img5.ImageUrl = "/images/check.gif"; } else { img5.ImageUrl = "/images/cancel.gif"; } if (boolMove == true) { img6.ImageUrl = "/images/green_arrow.gif"; chk6.Enabled = true; } } if (chk6.Checked == true) { if (boolMove == true) { img6.ImageUrl = "/images/check.gif"; } else { img6.ImageUrl = "/images/cancel.gif"; } if (boolMove == true) { img7.ImageUrl = "/images/green_arrow.gif"; chk7.Enabled = true; } } if (chk7.Checked == true) { img7.ImageUrl = "/images/check.gif"; img8.ImageUrl = "/images/green_arrow.gif"; chk8.Enabled = true; } if (chk8.Checked == true) { img8.ImageUrl = "/images/check.gif"; img9.ImageUrl = "/images/green_arrow.gif"; chk9.Enabled = true; } if (chk9.Checked == true) { img9.ImageUrl = "/images/check.gif"; img10.ImageUrl = "/images/green_arrow.gif"; chk10.Enabled = true; } if (chk10.Checked == true) { img10.ImageUrl = "/images/check.gif"; img11.ImageUrl = "/images/green_arrow.gif"; chk11.Enabled = true; } if (chk11.Checked == true) { img11.ImageUrl = "/images/check.gif"; } } if (Request.QueryString["div"] != null) { switch (Request.QueryString["div"]) { case "E": boolExecution = true; break; } } if (boolDetails == false && boolExecution == false) { boolDetails = true; } return(boolDone); }
protected void Page_Load(object sender, EventArgs e) { AuthenticateUser(); intProfile = Int32.Parse(Request.Cookies["profileid"].Value); oResourceRequest = new ResourceRequest(intProfile, dsn); if (Request.QueryString["save"] != null) { lblUpdate.Visible = true; } if (!IsPostBack) { if (Request.QueryString["id"] != null && Request.QueryString["id"] != "") { int intId = Int32.Parse(Request.QueryString["id"]); DataSet ds = oResourceRequest.GetChangeControl(intId); if (ds.Tables[0].Rows.Count > 0) { int intResourceWorkflow = Int32.Parse(ds.Tables[0].Rows[0]["parent"].ToString()); int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow); int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid")); int intRequest = Int32.Parse(oResourceRequest.Get(intResourceParent, "requestid")); Requests oRequest = new Requests(intProfile, dsn); ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn); Projects oProject = new Projects(intProfile, dsn); Users oUser = new Users(intProfile, dsn); int intProject = oRequest.GetProjectNumber(intRequest); if (intProject > 0) { panProject.Visible = true; lblName.Text = oProject.Get(intProject, "name"); lblNumber.Text = oProject.Get(intProject, "number"); } else { panTask.Visible = true; lblTName.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "name"); lblTNumber.Text = "CVT" + intRequest.ToString(); } lblImplementor.Text = oUser.GetFullName(intUser); string strComments = ds.Tables[0].Rows[0]["comments"].ToString().Trim(); if (intProfile == intUser) { txtChange.Visible = true; txtDate.Visible = true; txtTime.Visible = true; btnSubmit.Visible = true; btnDelete.Visible = true; txtComments.Visible = true; txtChange.Text = ds.Tables[0].Rows[0]["number"].ToString(); txtDate.Text = DateTime.Parse(ds.Tables[0].Rows[0]["implementation"].ToString()).ToShortDateString(); txtTime.Text = DateTime.Parse(ds.Tables[0].Rows[0]["implementation"].ToString()).ToShortTimeString(); txtComments.Text = strComments; btnSubmit.Attributes.Add("onclick", "return ValidateText('" + txtChange.ClientID + "','Please enter a change control number')" + " && ValidateDate('" + txtDate.ClientID + "','Please enter a valid implementation date')" + " && ValidateTime('" + txtTime.ClientID + "','Please enter a valid implementation time')" + ";"); btnDelete.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this change control?');"); } else { lblChange.Visible = true; lblDate.Visible = true; lblTime.Visible = true; panComments.Visible = true; lblChange.Text = ds.Tables[0].Rows[0]["number"].ToString(); lblDate.Text = DateTime.Parse(ds.Tables[0].Rows[0]["implementation"].ToString()).ToLongDateString(); lblTime.Text = DateTime.Parse(ds.Tables[0].Rows[0]["implementation"].ToString()).ToLongTimeString(); if (strComments == "") { strComments = "<i>No additional information</i>"; } lblComments.Text = strComments; } btnToday.Text += DateTime.Parse(ds.Tables[0].Rows[0]["implementation"].ToString()).ToShortDateString(); } } } }
protected void btnSave_Click(Object Sender, EventArgs e) { int intResourceWorkflow = Int32.Parse(lblResourceWorkflow.Text); int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow); int intOldUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid")); int intNewUser = Int32.Parse(ddlUser.SelectedItem.Value); int intOldItem = Int32.Parse(oResourceRequest.Get(intResourceParent, "itemid")); int intNewItem = Int32.Parse(ddlActivity.SelectedItem.Value); int intNumber = Int32.Parse(oResourceRequest.Get(intResourceParent, "number")); int intService = Int32.Parse(oResourceRequest.Get(intResourceParent, "serviceid")); int intApp = oRequestItem.GetItemApplication(intNewItem); int intRequest = Int32.Parse(oResourceRequest.Get(intResourceParent, "requestid")); int intProject = oRequest.GetProjectNumber(intRequest); int intRequester = oRequest.GetUser(intRequest); int intStatus = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "status")); Functions oFunction = new Functions(intProfile, dsn, intEnvironment); strEMailIdsBCC = oFunction.GetGetEmailAlertsEmailIds("EMAILGRP_REQUEST_ASSIGNMENT"); if (intOldUser != intNewUser) { string strSpacerRow = "<tr><td colspan=\"3\"><img src=\"" + oVariable.ImageURL() + "/images/spacer.gif\" border=\"0\" width=\"1\" height=\"7\" /></td></tr>"; string strDefault = oUser.GetApplicationUrl(intNewUser, intWorkload); // Notify Old User // NOTIFICATION oFunction.SendEmail("Request Assignment", oUser.GetName(intOldUser), "", strEMailIdsBCC, "Request Assignment", "<p><b>The following request has been removed from your workload</b><p><p>" + oResourceRequest.GetWorkflowSummary(intResourceWorkflow, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p>", true, false); // Notify New User if (strDefault == "") { oFunction.SendEmail("Request Assignment", oUser.GetName(intNewUser), "", strEMailIdsBCC, "Request Assignment", "<p><b>The following request has been re-assigned to you by " + oUser.GetFullName(intProfile) + "</b><p><p>" + oResourceRequest.GetWorkflowSummary(intResourceWorkflow, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p>", true, false); } else { if (intProject > 0) { oFunction.SendEmail("Request Assignment", oUser.GetName(intNewUser), "", strEMailIdsBCC, "Request Assignment", "<p><b>The following request has been re-assigned to you by " + oUser.GetFullName(intProfile) + "</b><p><p>" + oResourceRequest.GetWorkflowSummary(intResourceWorkflow, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p><p><a href=\"" + oVariable.URL() + "/redirect.aspx?referrer=/" + strDefault + oPage.GetFullLink(intWorkload) + "?pid=" + intProject.ToString() + "\" target=\"_blank\">Click here to review your new assignment.</a></p>", true, false); } else { oFunction.SendEmail("Request Assignment", oUser.GetName(intNewUser), "", strEMailIdsBCC, "Request Assignment", "<p><b>The following request has been re-assigned to you by " + oUser.GetFullName(intProfile) + "</b><p><p>" + oResourceRequest.GetWorkflowSummary(intResourceWorkflow, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p><p><a href=\"" + oVariable.URL() + "/redirect.aspx?referrer=/frame/resource_request.aspx?rrid=" + intResourceWorkflow.ToString() + "\" target=\"_blank\">Click here to review your new assignment.</a></p>", true, false); } } string strActivity = "<tr><td><b>Resource:</b></td><td> </td><td>" + oUser.GetFullName(intNewUser) + "</td></tr>"; strActivity += strSpacerRow; strActivity += "<tr><td><b>Activity Type:</b></td><td> </td><td>" + oService.GetName(intService) + "</td></tr>"; strActivity = "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"" + oVariable.DefaultFontStyle() + "\">" + strActivity + "</table>"; string strDeliverable = oApplication.Get(intApp, "deliverables_doc"); if (strDeliverable.Trim() != "") { strDeliverable = "<p><a href=\"" + oVariable.URL() + strDeliverable + "\">Click here to view the service deliverables</a></p>"; } // if (oService.Get(intService, "notify_client") != "0") // oFunction.SendEmail("Request Assignment", oUser.GetName(intRequester), "", strBCC, "Request Assignment", "<p><b>A resource has been assigned to the following request...</b><p><p>" + oResourceRequest.GetWorkflowSummary(intResourceWorkflow, intEnvironment, dsnServiceEditor) + "</p><p>" + strActivity + "</p>" + strDeliverable, true, false); } oResourceRequest.UpdateWorkflow(intResourceWorkflow, Int32.Parse(txtDevices.Text), double.Parse(txtAllocated.Text), (chkOpen.Checked ? 2 : intStatus)); oResourceRequest.UpdateWorkflowAssigned(intResourceWorkflow, intNewUser); oResourceRequest.UpdateItemAndService(intResourceParent, intNewItem, intService); if (chkOpen.Checked == true && intProject > 0) { oProject.Update(intProject, 2); } Response.Redirect(Request.Path + "?rrid=" + intResourceWorkflow.ToString() + "&save=true"); }
protected void Page_Load(object sender, EventArgs e) { intProfile = Int32.Parse(Request.Cookies["profileid"].Value); oProject = new Projects(intProfile, dsn); oFunction = new Functions(intProfile, dsn, intEnvironment); oUser = new Users(intProfile, dsn); oPage = new Pages(intProfile, dsn); oResourceRequest = new ResourceRequest(intProfile, dsn); oRequestItem = new RequestItems(intProfile, dsn); oRequest = new Requests(intProfile, dsn); oService = new Services(intProfile, dsn); oServiceRequest = new ServiceRequests(intProfile, dsn); oRequestField = new RequestFields(intProfile, dsn); oApplication = new Applications(intProfile, dsn); oServiceDetail = new ServiceDetails(intProfile, dsn); oDelegate = new Delegates(intProfile, dsn); oCustomized = new Customized(intProfile, dsn); oVariable = new Variables(intEnvironment); oClass = new Classes(intProfile, dsn); oEnvironment = new Environments(intProfile, dsn); oLocation = new Locations(intProfile, dsn); if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "") { intApplication = Int32.Parse(Request.QueryString["applicationid"]); } if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "") { intPage = Int32.Parse(Request.QueryString["pageid"]); } if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "") { intApplication = Int32.Parse(Request.Cookies["application"].Value); } if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "") { // Start Workflow Change lblResourceWorkflow.Text = Request.QueryString["rrid"]; int intResourceWorkflow = Int32.Parse(Request.QueryString["rrid"]); int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow); ds = oResourceRequest.Get(intResourceParent); // End Workflow Change intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString()); lblRequestedBy.Text = oUser.GetFullName(oRequest.GetUser(intRequest)); lblRequestedOn.Text = DateTime.Parse(oResourceRequest.Get(intResourceParent, "created")).ToString(); intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString()); intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString()); // Start Workflow Change bool boolComplete = (oResourceRequest.GetWorkflow(intResourceWorkflow, "status") == "3"); int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid")); txtCustom.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "name"); double dblAllocated = double.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated")); // End Workflow Change intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString()); lblService.Text = oService.Get(intService, "name"); int intApp = oRequestItem.GetItemApplication(intItem); if (Request.QueryString["save"] != null && Request.QueryString["save"] != "") { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "saved", "<script type=\"text/javascript\">alert('Information Saved Successfully');<" + "/" + "script>"); } if (Request.QueryString["status"] != null && Request.QueryString["status"] != "") { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "statusd", "<script type=\"text/javascript\">alert('Status Updates has been Added');<" + "/" + "script>"); } if (!IsPostBack) { double dblUsed = oResourceRequest.GetWorkflowUsed(intResourceWorkflow); lblUpdated.Text = oResourceRequest.GetUpdated(intResourceWorkflow); if (dblAllocated == dblUsed) { if (boolComplete == false) { oFunction.ConfigureToolButton(btnComplete, "/images/tool_complete"); btnComplete.Attributes.Add("onclick", "return confirm('Are you sure you want to mark this as completed and remove it from your workload?');"); } else { oFunction.ConfigureToolButton(btnComplete, "/images/tool_complete"); btnComplete.Attributes.Add("onclick", "alert('This task has already been marked COMPLETE. You can close this window.');return false;"); } panComplete.Visible = true; } else { btnComplete.ImageUrl = "/images/tool_complete_dbl.gif"; btnComplete.Enabled = false; } dblUsed = (dblUsed / dblAllocated) * 100; intProject = oRequest.GetProjectNumber(intRequest); hdnTab.Value = "D"; panWorkload.Visible = true; LoadStatus(intResourceWorkflow); LoadInformation(intResourceWorkflow); LoadDetails(); btnDenied.Attributes.Add("onclick", "return CloseWindow();"); oFunction.ConfigureToolButton(btnSave, "/images/tool_save"); oFunction.ConfigureToolButton(btnPrint, "/images/tool_print"); btnPrint.Attributes.Add("onclick", "return PrintWindow();"); oFunction.ConfigureToolButton(btnClose, "/images/tool_close"); btnClose.Attributes.Add("onclick", "return ExitWindow();"); btnSave.Attributes.Add("onclick", "return ValidateNumber0('" + txtAmount.ClientID + "','Please enter the total amount of storage')" + " && ValidateStatus('" + ddlStatus.ClientID + "','" + txtComments.ClientID + "')" + ";"); // 6/1/2009 - Load ReadOnly View if (oResourceRequest.CanUpdate(intProfile, intResourceWorkflow, false) == false) { oFunction.ConfigureToolButtonRO(btnSave, btnComplete); //panDenied.Visible = true; } } } else { panDenied.Visible = true; } }
private void LoadInformation(int _request) { lblView.Text = oEnhancement.GetBody(intID, intEnvironment); if (intProject > 0) { lblName.Text = oProject.Get(intProject, "name"); lblNumber.Text = oProject.Get(intProject, "number"); lblType.Text = "Project"; } else { lblName.Text = oResourceRequest.GetWorkflow(_request, "name"); lblNumber.Text = "CVT" + intRequest.ToString(); lblType.Text = "Task"; } int intMenuTab = 0; if (Request.QueryString["menu_tab"] != null && Request.QueryString["menu_tab"] != "") { intMenuTab = Int32.Parse(Request.QueryString["menu_tab"]); } Tab oTab = new Tab(hdnTab.ClientID, intMenuTab, "divMenu1", true, false); oTab.AddTab("Enhancement Details", ""); oTab.AddTab("Execution", ""); int intStep = 1; DataSet dsSteps = oEnhancement.GetSteps(intID, 0, 0); if (dsSteps.Tables[0].Rows.Count > 0) { intStep = Int32.Parse(dsSteps.Tables[0].Rows[0]["step"].ToString()); } intStep = LoadStep(1, intStep, img1, null, tr1, tr1Done, lbl1, dsSteps); intStep = LoadStep(2, intStep, img2, tr2Wait, tr2, tr2Done, lbl2, dsSteps); intStep = LoadStep(3, intStep, img3, tr3Wait, tr3, tr3Done, lbl3, dsSteps); intStep = LoadStep(4, intStep, img4, tr4Wait, tr4, tr4Done, lbl4, dsSteps); intStep = LoadStep(5, intStep, img5, tr5Wait, tr5, tr5Done, lbl5, dsSteps); intStep = LoadStep(6, intStep, img6, tr6Wait, tr6, tr6Done, lbl6, dsSteps); DataSet dsDocuments = oEnhancement.GetDocuments(intID); // Step # 1 switch (intStep) { case 1: btnSave.Attributes.Add("onclick", "return (document.getElementById('" + chk1.ClientID + "').checked == true)" + " || (document.getElementById('" + chk1.ClientID + "').checked == false" + " && ValidateText('" + filFunctional.ClientID + "','Select a functional requirement document')" + " && ValidateNumber0('" + txtDays.ClientID + "','Enter a valid number for the estimated date range')" + " && ValidateRadioList('" + radEstimate.ClientID + "','Make a selection for your estimated release date')" + ") && ProcessControlButton() && LoadWait()" + ";"); break; case 2: rptApprovers.DataSource = oEnhancement.GetApprovalResults(intID, intStep); rptApprovers.DataBind(); lblApprovers.Visible = (rptApprovers.Items.Count == 0); btnApprovalGroup.Attributes.Add("onclick", "return OpenWindow('ENHANCEMENT_APPROVAL_GROUPS','?enhancementid=" + intID.ToString() + "&step=" + intStep.ToString() + "');"); break; case 3: if (dsDocuments.Tables[0].Rows.Count > 0) { lblEstimate.Text = dsDocuments.Tables[0].Rows[0]["release"].ToString(); } ; radEstimateYes.Attributes.Add("onclick", "ShowHideDiv('" + divEstimate.ClientID + "','none');"); radEstimateNo.Attributes.Add("onclick", "ShowHideDiv('" + divEstimate.ClientID + "','inline');"); btnSave.Attributes.Add("onclick", "return ValidateRadioButtons('" + radEstimateYes.ClientID + "','" + radEstimateNo.ClientID + "','Select whether or not the estimated release date is OK')" + " && (document.getElementById('" + radEstimateYes.ClientID + "').checked == true || (document.getElementById('" + radEstimateNo.ClientID + "').checked == true && ValidateRadioList('" + radRelease.ClientID + "','Make a selection for your estimated release date')))" + " && ProcessControlButton() && LoadWait()" + ";"); break; } strMessages = oEnhancement.GetMessages(intID, false, "#E1FFE1"); oTab.AddTab("Message Thread (" + oEnhancement.GetMessages(intID).Tables[0].Rows.Count.ToString() + ")", ""); rptDocuments.DataSource = dsDocuments; rptDocuments.DataBind(); lblDocuments.Visible = (rptDocuments.Items.Count == 0); foreach (RepeaterItem ri in rptDocuments.Items) { LinkButton _delete = (LinkButton)ri.FindControl("btnDeleteDocument"); _delete.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this document?');"); } oTab.AddTab("Functional Requirements Documentation (" + rptDocuments.Items.Count.ToString() + ")", ""); oTab.AddTab("Log (" + oEnhancement.LoadLog(intID, rptLog, lblLog) + ")", ""); oTab.AddTab("Release Notes", ""); strMenuTab1 = oTab.GetTabs(); }
protected void LoadSearch(int _search) { Search oSearch = new Search(intProfile, dsn); RequestItems oRequestItem = new RequestItems(intProfile, dsn); Services oService = new Services(intProfile, dsn); Applications oApplication = new Applications(intProfile, dsn); StatusLevels oStatusLevel = new StatusLevels(); Users oUser = new Users(intProfile, dsn); Projects oProject = new Projects(intProfile, dsn); ResourceRequest oResourceRequest = new ResourceRequest(intProfile, dsn); ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn); DataSet ds = oSearch.GetProject(_search); int intApplication = 0; if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "") { intApplication = Int32.Parse(Request.QueryString["applicationid"]); } if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "") { intApplication = Int32.Parse(Request.Cookies["application"].Value); } if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["userid"].ToString() == intProfile.ToString()) { string strType = ds.Tables[0].Rows[0]["type"].ToString(); string strClause = "cv_projects.deleted = 0 AND cv_projects.number NOT LIKE 'CV%' AND cv_projects.number NOT LIKE 'EPS%'"; string strOr1 = ""; string strOr2 = ""; string strSQL = "SELECT DISTINCT '?pid=' + CAST(cv_projects.projectid AS varchar(10)) + '&sid=" + _search.ToString() + "' AS query, cv_projects.name, cv_projects.number, cv_projects.status, cv_projects.modified FROM cv_projects INNER JOIN cv_requests LEFT OUTER JOIN cv_service_requests ON cv_service_requests.requestid = cv_requests.requestid AND cv_service_requests.deleted = 0 LEFT OUTER JOIN cv_project_requests ON cv_project_requests.requestid = cv_requests.requestid AND cv_project_requests.deleted = 0 INNER JOIN cv_resource_requests INNER JOIN cv_request_items INNER JOIN cv_applications ON cv_request_items.applicationid = cv_applications.applicationid AND cv_applications.deleted = 0 ON cv_request_items.itemid = cv_resource_requests.itemid AND cv_request_items.deleted = 0 INNER JOIN cv_users ON cv_resource_requests.userid = cv_users.userid AND cv_users.deleted = 0 AND cv_users.enabled = 1 ON cv_requests.requestid = cv_resource_requests.requestid AND cv_resource_requests.deleted = 0 ON cv_requests.projectid = cv_projects.projectid AND cv_requests.deleted = 0 WHERE "; string strApplication = " AND cv_request_items.applicationid = " + intApplication.ToString(); switch (strType) { case "O": strApplication = ""; string strOName = ds.Tables[0].Rows[0]["oname"].ToString().Trim(); string strONumber = ds.Tables[0].Rows[0]["onumber"].ToString().Trim(); if (strONumber != "") { strClause += " AND cv_projects.number LIKE '%" + strONumber + "%'"; lblResults.Text = "Project Number LIKE "" + strONumber + """; } else { strClause += " AND cv_projects.name LIKE '%" + strOName + "%'"; lblResults.Text = "Project Name LIKE "" + strOName + """; } string strOStatus = ds.Tables[0].Rows[0]["ostatus"].ToString(); if (strOStatus != "0") { strClause += " AND cv_projects.status = " + strOStatus; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Status = "" + oStatusLevel.Name(Int32.Parse(strOStatus)) + """; } string strOStart = ds.Tables[0].Rows[0]["ostart"].ToString(); if (strOStart != "") { strOStart = DateTime.Parse(strOStart).ToShortDateString(); strClause += " AND cv_projects.modified > " + strOStart; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Project Date > "" + strOStart + """; } string strOEnd = ds.Tables[0].Rows[0]["oend"].ToString(); if (strOEnd != "") { strOEnd = DateTime.Parse(strOEnd).ToShortDateString(); strClause += " AND cv_projects.modified < " + strOEnd; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Project Date < "" + strOEnd + """; } break; case "P": string strDepartment = ds.Tables[0].Rows[0]["department"].ToString(); if (strDepartment == "0") { strApplication = ""; lblResults.Text += "Department = "ALL""; } else { strApplication = " AND cv_request_items.applicationid = " + strDepartment; lblResults.Text += "Department = "" + oApplication.GetName(Int32.Parse(strDepartment)) + """; } string strDStatus = ds.Tables[0].Rows[0]["dstatus"].ToString(); if (strDStatus != "0") { strClause += " AND cv_resource_requests.status = " + strDStatus; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Status = "" + oStatusLevel.Name(Int32.Parse(strDStatus)) + """; } string strDStart = ds.Tables[0].Rows[0]["dstart"].ToString(); if (strDStart != "") { strDStart = DateTime.Parse(strDStart).ToShortDateString(); strClause += " AND cv_requests.modified > " + strDStart; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Request Date > "" + strDStart + """; } string strDEnd = ds.Tables[0].Rows[0]["dend"].ToString(); if (strDEnd != "") { strDEnd = DateTime.Parse(strDEnd).ToShortDateString(); strClause += " AND cv_requests.modified < " + strDEnd; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Request Date < "" + strDEnd + """; } break; case "T": string strTechnician = ds.Tables[0].Rows[0]["technician"].ToString(); if (strTechnician != "0") { strClause += " AND cv_resource_requests.userid = " + strTechnician; lblResults.Text += "Technician = "" + oUser.GetFullName(Int32.Parse(strTechnician)) + """; } string strTStatus = ds.Tables[0].Rows[0]["tstatus"].ToString(); if (strTStatus != "0") { strClause += " AND cv_resource_requests.status = " + strTStatus; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Status = "" + oStatusLevel.Name(Int32.Parse(strTStatus)) + """; } string strTStart = ds.Tables[0].Rows[0]["tstart"].ToString(); if (strTStart != "") { strTStart = DateTime.Parse(strTStart).ToShortDateString(); strClause += " AND cv_requests.modified > " + strTStart; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Request Date > "" + strTStart + """; } string strTEnd = ds.Tables[0].Rows[0]["tend"].ToString(); if (strTEnd != "") { strTEnd = DateTime.Parse(strTEnd).ToShortDateString(); strClause += " AND cv_requests.modified < " + strTEnd; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Request Date < "" + strTEnd + """; } break; case "L": string strLead = ds.Tables[0].Rows[0]["lead"].ToString(); if (strLead != "0") { int intLead = Int32.Parse(strLead); strClause += " AND cv_users.manager = " + intLead.ToString(); lblResults.Text += "Team Lead = "" + oUser.GetFullName(intLead) + """; } string strLStatus = ds.Tables[0].Rows[0]["lstatus"].ToString(); if (strLStatus != "0") { strClause += " AND cv_resource_requests.status = " + strLStatus; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Status = "" + oStatusLevel.Name(Int32.Parse(strLStatus)) + """; } string strLStart = ds.Tables[0].Rows[0]["lstart"].ToString(); if (strLStart != "") { strLStart = DateTime.Parse(strLStart).ToShortDateString(); strClause += " AND cv_requests.modified > " + strLStart; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Request Date < "" + strLStart + """; } string strLEnd = ds.Tables[0].Rows[0]["lend"].ToString(); if (strLEnd != "") { strLEnd = DateTime.Parse(strLEnd).ToShortDateString(); strClause += " AND cv_requests.modified < " + strLEnd; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Request Date > "" + strLEnd + """; } break; case "G": string strItem = ds.Tables[0].Rows[0]["itemid"].ToString(); if (strItem != "0") { strClause += " AND cv_resource_requests.itemid = " + strItem; lblResults.Text += "Activity Type = "" + oRequestItem.GetItemName(Int32.Parse(strItem)) + """; } string strGStatus = ds.Tables[0].Rows[0]["gstatus"].ToString(); if (strGStatus != "0") { strClause += " AND cv_resource_requests.status = " + strGStatus; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Status = "" + oStatusLevel.Name(Int32.Parse(strGStatus)) + """; } string strGStart = ds.Tables[0].Rows[0]["gstart"].ToString(); if (strGStart != "") { strGStart = DateTime.Parse(strGStart).ToShortDateString(); strClause += " AND cv_requests.modified > " + strGStart; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Request Date < "" + strGStart + """; } string strGEnd = ds.Tables[0].Rows[0]["gend"].ToString(); if (strGEnd != "") { strGEnd = DateTime.Parse(strGEnd).ToShortDateString(); strClause += " AND cv_requests.modified < " + strGEnd; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Request Date > "" + strGEnd + """; } break; case "S": break; } strClause = strClause + strApplication; if (strOr1 != "" && strOr2 != "") { strClause = strClause + " AND " + strOr1 + " AND cv_project_requests.id IS NOT NULL OR " + strClause + " AND " + strOr1 + " AND cv_service_requests.id IS NOT NULL OR " + strClause + " AND " + strOr2 + " AND cv_project_requests.id IS NOT NULL OR " + strClause + " AND " + strOr2 + " AND cv_service_requests.id IS NOT NULL"; } else { strClause = strClause + " AND cv_project_requests.id IS NOT NULL OR " + strClause + " AND cv_service_requests.id IS NOT NULL"; } ds = SqlHelper.ExecuteDataset(dsn, CommandType.Text, strSQL + strClause); DataView dv = ds.Tables[0].DefaultView; if (Request.QueryString["sort"] != null) { dv.Sort = Request.QueryString["sort"]; } rptView.DataSource = dv; rptView.DataBind(); foreach (RepeaterItem ri in rptView.Items) { Label _progress = (Label)ri.FindControl("lblProgress"); Label _status = (Label)ri.FindControl("lblStatus"); _status.Text = oStatusLevel.HTML(Int32.Parse(_status.Text)); Label _updated = (Label)ri.FindControl("lblUpdated"); Label _number = (Label)ri.FindControl("lblNumber"); if (_number.Text == "") { _number.Text = "<i>TBD...</i>"; } double dblUsed = 0.00; double dblAllocated = 0.00; if (_progress.Text.Contains("?pid=") == true) { int intProject = 0; if (Request.QueryString["sid"] != null && Request.QueryString["sid"] != "") { string strProgress = _progress.Text.Substring(0, _progress.Text.IndexOf("&")); intProject = Int32.Parse(strProgress.Substring(5)); } else { intProject = Int32.Parse(_progress.Text.Substring(5)); } _updated.Text = oProject.GetLastUpdated(intProject); DataSet dsAll = oResourceRequest.GetWorkflowProject(intProject); foreach (DataRow drAll in dsAll.Tables[0].Rows) { int intResourceWorkflow = Int32.Parse(drAll["id"].ToString()); dblAllocated += double.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated")); dblUsed += oResourceRequest.GetWorkflowUsed(intResourceWorkflow); } } else if (_progress.Text.Contains("?rid=") == true) { int intRequest = Int32.Parse(_progress.Text.Substring(5)); DataSet dsAll = oResourceRequest.GetWorkflowRequestAll(intRequest); foreach (DataRow drAll in dsAll.Tables[0].Rows) { int intResourceWorkflow = Int32.Parse(drAll["id"].ToString()); dblAllocated += double.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated")); dblUsed += oResourceRequest.GetWorkflowUsed(intResourceWorkflow); } } double dblProgress = 0.00; if (dblAllocated > 0.00) { dblProgress = (dblUsed / dblAllocated) * 100.00; } _progress.Text = oServiceRequest.GetStatusBar(dblProgress, "100", "6", true); } lblNone.Visible = (rptView.Items.Count == 0); } } }
private void LoadInformation(int _request) { StringBuilder sb = new StringBuilder(); Reports oReport = new Reports(intProfile, dsn); Variables oVariable = new Variables(intEnvironment); ds = oReport.GetOrderReport(intRequest, intItem, intNumber); sb.Append("<table width=\"100%\" cellpadding=\"2\" cellspacing=\"3\" border=\"0\">"); if (ds.Tables[0].Rows.Count > 0) { sb.Append("<tr><td valign=\"top\"><b>Title: </b></td>"); sb.Append("<td>"); sb.Append(ds.Tables[0].Rows[0]["title"]); sb.Append("</td></tr>"); sb.Append("<tr><td valign=\"top\"><b>Data Source: </b></td>"); sb.Append("<td>"); sb.Append(ds.Tables[0].Rows[0]["data_source"]); sb.Append("</td></tr>"); sb.Append("<tr><td valign=\"top\"><b>Chart Type: </b></td>"); sb.Append("<td>"); sb.Append(ds.Tables[0].Rows[0]["chart_type"]); sb.Append("</td></tr>"); sb.Append("<tr><td valign=\"top\"><b>Report Upload: </b></td>"); if ((string)ds.Tables[0].Rows[0]["report_upload"] != DBNull.Value.ToString()) { sb.Append("<td><a href=\""); sb.Append(oVariable.URL()); sb.Append("/"); sb.Append(ds.Tables[0].Rows[0]["report_upload"]); sb.Append("\" target=\"_blank\">Click here to view the document</a></td></tr>"); } sb.Append("<tr><td valign=\"top\"><b>Instructions: </b></td>"); sb.Append("<td>"); sb.Append(ds.Tables[0].Rows[0]["instructions"]); sb.Append("</td></tr>"); sb.Append("<tr><td valign=\"top\"><b>Data Exclusion: </b></td>"); sb.Append("<td>"); sb.Append(ds.Tables[0].Rows[0]["data_exclusion"]); sb.Append("</td></tr>"); int intId = Int32.Parse(ds.Tables[0].Rows[0]["id"].ToString()); DataSet ds2 = oReport.GetOrderReportDataFields(intId); DataSet ds3 = oReport.GetOrderReportCalculations(intId); DataSet ds4 = oReport.GetOrderReportApplications(intId); sb.Append("<tr><td valign=\"top\"><b>Data Fields:</b></td>"); sb.Append("<td colspan=\"2\"><table width=\"50%\" cellpadding=\"2\" cellspacing=\"0\">"); sb.Append("<tr bgcolor=\"#EEEEEE\"><td><b>Field Name</b></td><td><b>Field Type</b></td></tr>"); string strRep1 = ""; foreach (DataRow dr in ds2.Tables[0].Rows) { strRep1 += "<tr><td>" + dr["name"] + "</td><td>" + dr["type"] + "</td></tr>"; } if (strRep1 == "") { sb.Append("<tr><td colspan=\"2\"><img src=\"/images/alert.gif\" border=\"0\" align=\"absmiddle\"> There are no items </td></tr></table></td></tr>"); } else { sb.Append(strRep1); sb.Append("</table></td></tr>"); } sb.Append("<tr><td valign=\"top\"><b>Calculations:</b></td>"); sb.Append("<td colspan=\"2\"><table width=\"50%\" cellpadding=\"2\" cellspacing=\"0\">"); sb.Append("<tr bgcolor=\"#EEEEEE\"><td><b>Field Name</b></td><td><b>Formula</b></td></tr>"); string strRep2 = ""; foreach (DataRow dr in ds3.Tables[0].Rows) { strRep2 += "<tr><td>" + dr["name"] + "</td><td>" + dr["formula"] + "</td></tr>"; } if (strRep2 == "") { sb.Append("<tr><td colspan=\"2\"><img src=\"/images/alert.gif\" border=\"0\" align=\"absmiddle\"> There are no items </td></tr></table></td></tr>"); } else { sb.Append(strRep2); sb.Append("</table></td></tr>"); } sb.Append("<tr><td valign=\"top\"><b>Who can view this report?:</b></td><td><span>"); foreach (DataRow dr in ds4.Tables[0].Rows) { sb.Append(dr["appname"]); sb.Append("; <br>"); } sb.Append("</span></td></tr>"); } sb.Append("</table>"); strView = sb.ToString(); if (intProject > 0) { lblName.Text = oProject.Get(intProject, "name"); lblNumber.Text = oProject.Get(intProject, "number"); lblType.Text = "Project"; } else { lblName.Text = oResourceRequest.GetWorkflow(_request, "name"); lblNumber.Text = "CVT" + intRequest.ToString(); lblType.Text = "Task"; } if (Request.QueryString["div"] != null) { switch (Request.QueryString["div"]) { case "E": boolExecution = true; break; case "C": boolChange = true; break; case "X": boolExtension = true; break; } } if (boolDetails == false && boolExecution == false && boolChange == false && boolExtension == false) { boolDetails = true; } }
protected void btnConfidenceUnlock_Click(Object Sender, EventArgs e) { Encryption oEncryption = new Encryption(); string strEMailIdsBCC = oFunction.GetGetEmailAlertsEmailIds("EMAILGRP_DESIGN_BUILDER"); string strDate = DateTime.Today.Month.ToString() + DateTime.Today.Day.ToString() + DateTime.Today.Year.ToString(); if (txtConfidenceUnlock.Text == oEncryption.Encrypt(lblConfidenceUnlock.Text + strDate, "UNLOCK_100")) { if (oForecast.GetAnswer(intID, "override") == "-1") { // Send Email to iARB stating that they do not have to approve the design string[] strEmail; char[] strSplit = { ';' }; strEmail = strIARB.Split(strSplit); for (int ii = 0; ii < strEmail.Length; ii++) { if (strEmail[ii].Trim() != "") { string strAddress = strEmail[ii]; oFunction.SendEmail("Review Board Approval UNLOCKED", strAddress, "", strEMailIdsBCC, "Review Board Approval UNLOCKED", "<p><b>An overridden design has been unlocked and no longer requires your approval.</b><p><p>" + oForecast.GetAnswerBody(intID, intEnvironment, dsnAsset, dsnIP) + "</p>", true, false); } } } oForecast.AddAnswerUnlock(intID, intProfile, txtConfidenceReason.Text); oForecast.UpdateAnswerConfidence(intID, intConfidenceUnlock); int intForecast = Int32.Parse(oForecast.GetAnswer(intID, "forecastid")); int intRequest = Int32.Parse(oForecast.Get(intForecast, "requestid")); Requests oRequest = new Requests(0, dsn); int intProject = oRequest.GetProjectNumber(intRequest); OnDemandTasks oOnDemandTasks = new OnDemandTasks(0, dsn); ResourceRequest oResourceRequest = new ResourceRequest(0, dsn); Variables oVariable = new Variables(intEnvironment); Projects oProject = new Projects(0, dsn); DataSet ds = oOnDemandTasks.GetPending(intID); foreach (DataRow dr in ds.Tables[0].Rows) { int intResourceWorkflow = Int32.Parse(dr["resourceid"].ToString()); int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow); int intImplementor = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid")); oResourceRequest.UpdateItemAndService(intResourceParent, -1, -1); oResourceRequest.UpdateName(intResourceParent, "Provisioning Task [Unlocked]"); string strDefault = oUser.GetApplicationUrl(intImplementor, intViewPage); string strSpacerRow = "<tr><td colspan=\"3\"><img src=\"" + oVariable.ImageURL() + "/images/spacer.gif\" border=\"0\" width=\"1\" height=\"7\" /></td></tr>"; string strCC = ""; Delegates oDelegate = new Delegates(0, dsn); DataSet dsDelegates = oDelegate.Gets(intImplementor); foreach (DataRow drDelegate in dsDelegates.Tables[0].Rows) { strCC += oUser.GetName(Int32.Parse(drDelegate["delegate"].ToString())) + ";"; } if (strDefault == "") { oFunction.SendEmail("ClearView Provisioning Task Unlocked", oUser.GetName(intImplementor), strCC, strEMailIdsBCC, "ClearView Provisioning Task Unlocked", "<p><b>A provisioning request has been unlocked. This request no longer requires you to take action.</b><p><p>" + oProject.GetBody(intProject, intEnvironment, false) + "</p>", true, false); } else { oFunction.SendEmail("ClearView Provisioning Task Unlocked", oUser.GetName(intImplementor), strCC, strEMailIdsBCC, "ClearView Provisioning Task Unlocked", "<p><b>A provisioning request has been unlocked. This request no longer requires you to take action.</b><p><p>" + oProject.GetBody(intProject, intEnvironment, false) + "</p><p><a href=\"" + oVariable.URL() + "/redirect.aspx?referrer=/" + strDefault + oPage.GetFullLink(intViewPage) + "?pid=" + intProject.ToString() + "\" target=\"_blank\">Click here to review this project.</a></p>", true, false); } } oOnDemandTasks.DeleteAll(intID); Response.Redirect(Request.Path + "?id=" + intID.ToString()); } else { Response.Redirect(Request.Path + "?id=" + intID.ToString() + "&unlock=true"); } }
protected void Page_Load(object sender, EventArgs e) { AuthenticateUser(); intProfile = Int32.Parse(Request.Cookies["profileid"].Value); oProject = new Projects(intProfile, dsn); oServiceRequest = new ServiceRequests(intProfile, dsn); oOrganization = new Organizations(intProfile, dsn); oResourceRequest = new ResourceRequest(intProfile, dsn); oRequestItem = new RequestItems(intProfile, dsn); oService = new Services(intProfile, dsn); oPage = new Pages(intProfile, dsn); oVariable = new Variables(intEnvironment); oApplication = new Applications(intProfile, dsn); oRequest = new Requests(intProfile, dsn); oUser = new Users(intProfile, dsn); if (Request.QueryString["action"] != null && Request.QueryString["action"] != "") { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "saved", "<script type=\"text/javascript\">alert('Information Saved Successfully');<" + "/" + "script>"); } if (!IsPostBack) { if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "") { lblResourceWorkflow.Text = Request.QueryString["rrid"]; int intResourceWorkflow = Int32.Parse(lblResourceWorkflow.Text); int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow); ds = oResourceRequest.Get(intResourceParent); if (ds.Tables[0].Rows.Count > 0) { int intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString()); int intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString()); int intApp = oRequestItem.GetItemApplication(intItem); int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid")); int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString()); int intProject = oRequest.GetProjectNumber(intRequest); bool boolManager = false; if (intProject > 0) { panProject.Visible = true; lblName.Text = oProject.Get(intProject, "name"); lblNumber.Text = oProject.Get(intProject, "number"); lblOrganization.Text = oOrganization.GetName(Int32.Parse(oProject.Get(intProject, "organization"))); } else { panTask.Visible = true; lblTaskName.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "name"); lblTaskNumber.Text = "CVT" + intRequest.ToString(); } lblSubmitter.Text = oUser.GetFullName(oRequest.GetUser(intRequest)); lblStatement.Text = oRequest.Get(intRequest, "description"); if (oRequest.Get(intRequest, "start_date") != "") { lblStart.Text = DateTime.Parse(oRequest.Get(intRequest, "start_date")).ToShortDateString(); } else { lblStart.Text = "N / A"; } if (oRequest.Get(intRequest, "end_date") != "") { lblEnd.Text = DateTime.Parse(oRequest.Get(intRequest, "end_date")).ToShortDateString(); } else { lblEnd.Text = "N / A"; } double dblUsed = oResourceRequest.GetWorkflowUsed(intResourceWorkflow); lblUsed.Text = dblUsed.ToString("F"); lblAllocated.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated"); txtAllocated.Text = lblAllocated.Text; txtDevices.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "devices"); lblDevices.Text = txtDevices.Text; if (ds.Tables[0].Rows[0]["solo"].ToString() == "0") { btnView.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intViewRequest.ToString() + "&rid=" + intRequest.ToString() + "');"); btnView.Text = "View Original Request Details"; } else { btnView.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intViewResourceRequest.ToString() + "&rrid=" + intResourceParent.ToString() + "');"); if (oApplication.Get(intApp, "tpm") == "1") { btnView.Text = "View Original Request Details"; } else { btnView.Text = "View Original Request Details"; } } string strStatus = ds.Tables[0].Rows[0]["status"].ToString(); int intAppManager = oApplication.GetManager(intApp); LoadList(intAppManager, intApp); LoadAvailable(intAppManager, intApp); if (oUser.IsAdmin(intProfile) || oService.IsManager(intService, intProfile) || (oApplication.IsManager(intApp, intProfile) && oApplication.Get(intApp, "disable_manager") != "1") || (oUser.IsManager(intUser, intProfile, true) && oApplication.Get(intApp, "disable_manager") != "1")) { boolManager = true; } else if (intProfile == intUser) { panVirtual.Visible = true; btnVirtual.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST','" + intResourceWorkflow.ToString() + "');"); btnVirtual.Text = "View This Request"; } try { ddlActivity.SelectedValue = intItem.ToString(); lblActivity.Text = ddlActivity.SelectedItem.Text; ddlUser.SelectedValue = intUser.ToString(); lblUser.Text = ddlUser.SelectedItem.Text; } catch { } if (boolManager == true) { Master.Page.Title = "Resource Request #" + intResourceWorkflow.ToString() + " Management View"; panView.Visible = true; panManager.Visible = true; chkOpen.Enabled = (strStatus == "3" || strStatus == "-2" || strStatus == "5"); txtAllocated.Visible = true; txtDevices.Visible = true; ddlActivity.Visible = true; ddlUser.Visible = true; lnkAvailable.Visible = true; panVirtual.Visible = true; btnVirtual.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST','" + intResourceWorkflow.ToString() + "');"); btnVirtual.Text = "Virtual Login as " + oUser.Get(intUser, "fname") + " " + oUser.Get(intUser, "lname"); btnSave.Attributes.Add("onclick", "return ValidateNumber('" + txtAllocated.ClientID + "','Please enter a valid number for the allocated hours')" + " && ValidateNumber('" + txtDevices.ClientID + "','Please enter a valid number for the device count')" + " && ValidateDropDown('" + ddlActivity.ClientID + "','Please make a selection for the activity type')" + " && ValidateDropDown('" + ddlUser.ClientID + "','Please make a selection for the assigned technician')" + ";"); } else { Master.Page.Title = "Resource Request #" + intResourceWorkflow.ToString() + " Technician View"; panView.Visible = true; lblAllocated.Visible = true; lblDevices.Visible = true; lblActivity.Visible = true; lblUser.Visible = true; } } else { panDenied.Visible = true; } } else { panDenied.Visible = true; } lnkAvailable.Attributes.Add("onclick", "return ShowHideAvailable('" + divAvailable.ClientID + "');"); btnFinish.Attributes.Add("onclick", "return CloseWindow();"); btnClose.Attributes.Add("onclick", "return CloseWindow();"); btnDenied.Attributes.Add("onclick", "return CloseWindow();"); } }
protected void Page_Load(object sender, EventArgs e) { intProfile = Int32.Parse(Request.Cookies["profileid"].Value); oProject = new Projects(intProfile, dsn); oFunction = new Functions(intProfile, dsn, intEnvironment); oUser = new Users(intProfile, dsn); oPage = new Pages(intProfile, dsn); oResourceRequest = new ResourceRequest(intProfile, dsn); oRequestItem = new RequestItems(intProfile, dsn); oRequest = new Requests(intProfile, dsn); oService = new Services(intProfile, dsn); oRequestField = new RequestFields(intProfile, dsn); oServiceRequest = new ServiceRequests(intProfile, dsn); oApplication = new Applications(intProfile, dsn); oOnDemandTasks = new OnDemandTasks(intProfile, dsn); oDelegate = new Delegates(intProfile, dsn); oClass = new Classes(intProfile, dsn); oServer = new Servers(0, dsn); if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "") { intApplication = Int32.Parse(Request.QueryString["applicationid"]); } if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "") { intPage = Int32.Parse(Request.QueryString["pageid"]); } if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "") { intApplication = Int32.Parse(Request.Cookies["application"].Value); } if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "") { lblResourceWorkflow.Text = Request.QueryString["rrid"]; int intResourceWorkflow = Int32.Parse(Request.QueryString["rrid"]); int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow); DataSet ds = oResourceRequest.Get(intResourceParent); intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString()); intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString()); intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString()); // Workflow start bool boolComplete = (oResourceRequest.GetWorkflow(intResourceWorkflow, "status") == "3"); int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid")); txtCustom.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "name"); double dblAllocated = double.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated")); // Workflow end int intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString()); lblService.Text = oService.Get(intService, "name"); int intApp = oRequestItem.GetItemApplication(intItem); double dblUsed = oResourceRequest.GetWorkflowUsed(intResourceWorkflow); lblUpdated.Text = oResourceRequest.GetUpdated(intResourceParent); dblUsed = (dblUsed / dblAllocated) * 100; if (Request.QueryString["save"] != null && Request.QueryString["save"] != "") { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "saved", "<script type=\"text/javascript\">alert('Information Saved Successfully');<" + "/" + "script>"); } if (Request.QueryString["status"] != null && Request.QueryString["status"] != "") { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "statusd", "<script type=\"text/javascript\">alert('Weekly Status has been Added');<" + "/" + "script>"); } intProject = oRequest.GetProjectNumber(intRequest); hdnTab.Value = "D"; panWorkload.Visible = true; LoadStatus(intResourceWorkflow); bool boolDone = LoadInformation(intResourceWorkflow); if (boolDone == true) { if (boolComplete == false) { oFunction.ConfigureToolButton(btnComplete, "/images/tool_complete"); btnComplete.Attributes.Add("onclick", "return ValidateDropDown('" + ddlSuccess.ClientID + "','Please select a status') && confirm('Are you sure you want to mark this as completed and remove it from your workload?');"); } else { oFunction.ConfigureToolButton(btnComplete, "/images/tool_complete"); btnComplete.Attributes.Add("onclick", "alert('This task has already been marked COMPLETE. You can close this window.');return false;"); } imgSuccess.ImageUrl = "/images/green_arrow.gif"; btnSave.ImageUrl = "/images/tool_save.gif"; btnSave.Enabled = false; } else { btnComplete.ImageUrl = "/images/tool_complete_dbl.gif"; btnComplete.Enabled = false; oFunction.ConfigureToolButton(btnSave, "/images/tool_save"); } btnDenied.Attributes.Add("onclick", "return CloseWindow();"); oFunction.ConfigureToolButton(btnSave, "/images/tool_save"); oFunction.ConfigureToolButton(btnPrint, "/images/tool_print"); btnPrint.Attributes.Add("onclick", "return PrintWindow();"); oFunction.ConfigureToolButton(btnClose, "/images/tool_close"); btnClose.Attributes.Add("onclick", "return ExitWindow();"); btnSave.Attributes.Add("onclick", "return ValidateStatus('" + ddlStatus.ClientID + "','" + txtIssues.ClientID + "');"); // 6/1/2009 - Load ReadOnly View if (oResourceRequest.CanUpdate(intProfile, intResourceWorkflow, false) == false) { oFunction.ConfigureToolButtonRO(btnSave, btnComplete); //panDenied.Visible = true; } } else { panDenied.Visible = true; } }
private void LoadRequest() { // Get Workflow Details lblResourceWorkflow.Text = Request.QueryString["rrid"]; int intResourceWorkflow = Int32.Parse(Request.QueryString["rrid"]); int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow); int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid")); bool boolComplete = (oResourceRequest.GetWorkflow(intResourceWorkflow, "status") == "3"); double dblAllocated = double.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated")); bool boolJoined = (oResourceRequest.GetWorkflow(intResourceWorkflow, "joined") == "1"); DataSet ds = oResourceRequest.Get(intResourceParent); //Project or Task Details intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString()); intProject = oRequest.GetProjectNumber(intRequest); if (intProject > 0) { lblName.Text = oProject.Get(intProject, "name"); lblNumber.Text = oProject.Get(intProject, "number"); lblType.Text = "Project"; } else { lblName.Text = oResourceRequest.GetWorkflow(intRequest, "name"); lblNumber.Text = "CVT" + intRequest.ToString(); lblType.Text = "Task"; } intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString()); intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString()); intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString()); int intApp = oRequestItem.GetItemApplication(intItem); lblService.Text = oService.Get(intService, "name"); lblRequestedBy.Text = oUser.GetFullName(oRequest.GetUser(intRequest)); lblRequestedOn.Text = DateTime.Parse(oResourceRequest.Get(intResourceParent, "created")).ToString(); lblDescription.Text = oRequest.Get(intRequest, "description"); if (lblDescription.Text == "") { lblDescription.Text = "<i>No information</i>"; } txtCustom.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "name"); lblUpdated.Text = oResourceRequest.GetUpdated(intResourceParent); if (!IsPostBack) { double dblUsed = oResourceRequest.GetWorkflowUsed(intResourceWorkflow); if (dblAllocated == dblUsed) { if (boolComplete == false) { btnComplete.Attributes.Add("onclick", "return confirm('Are you sure you want to mark this as completed and remove it from your workload?');"); } else { btnComplete.Attributes.Add("onclick", "alert('This task has already been marked COMPLETE. You can close this window.');return false;"); } } else { btnComplete.ImageUrl = "/images/tool_complete_dbl.gif"; btnComplete.Enabled = false; } bool boolSLABreached = false; if (oService.Get(intService, "sla") != "") { int intDays = oResourceRequest.GetSLA(intResourceParent); if (intDays > -99999) { if (intDays < 1) { btnSLA.Style["border"] = "solid 2px #FF0000"; } else if (intDays < 3) { btnSLA.Style["border"] = "solid 2px #FF9999"; } boolSLABreached = (intDays < 0); btnSLA.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST_SLA','?rrid=" + intResourceParent.ToString() + "');"); } else { btnSLA.ImageUrl = "/images/tool_sla_dbl.gif"; btnSLA.Enabled = false; } } else { btnSLA.ImageUrl = "/images/tool_sla_dbl.gif"; btnSLA.Enabled = false; } btnEmail.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST_EMAIL','?rrid=" + intResourceWorkflow.ToString() + "&type=GENERIC');"); dblUsed = (dblUsed / dblAllocated) * 100; panWorkload.Visible = true; bool boolRed = LoadStatus(intResourceWorkflow); if (boolRed == false && boolSLABreached == true) { btnComplete.Attributes.Add("onclick", "alert('NOTE: Your Service Level Agreement (SLA) has been breached!\\n\\nYou must provide a RED STATUS update with an explanation of why your SLA was breached for this request.\\n\\nOnce a RED STATUS update has been provided, you will be able to complete this request.');return false;"); } LoadInformation(); chkDescription.Checked = (Request.QueryString["doc"] != null); //Change Control and Documents //ucWMStatusUpdates.RRWorkflowId = intResourceWorkflow; LoadChange(intResourceWorkflow); lblDocuments.Text = oDocument.GetDocuments_Service(intRequest, intService, oVariable.DocumentsFolder(), 1, (Request.QueryString["doc"] != null)); // 6/1/2009 - Load ReadOnly View if ((oResourceRequest.CanUpdate(intProfile, intResourceWorkflow, false) == false) || boolComplete == true) { oFunction.ConfigureToolButtonRO(btnSave, btnComplete); } btnReturn.Visible = false; //btnComplete.Visible = false; } //div selection if (Request.QueryString["div"] != null) { switch (Request.QueryString["div"]) { case "E": boolExecution = true; break; case "C": boolChange = true; break; case "D": boolDocuments = true; break; case "S": boolStatusUpdates = true; break; } } if (boolDetails == false && boolExecution == false && boolStatusUpdates == false && boolChange == false && boolDocuments == false) { boolDetails = true; } }
public string GetBody(int _requestid, int _itemid, int _number, int _serviceid, int _rrid, int _rr_workflowid, string _se_dsn, int _environment, string _dsn_asset, string _dsn_ip) { string strView = ""; Applications oApplication = new Applications(user, dsn); RequestItems oRequestItem = new RequestItems(user, dsn); ResourceRequest oResourceRequest = new ResourceRequest(user, dsn); Users oUser = new Users(user, dsn); Services oService = new Services(user, dsn); Variables oVariable = new Variables(_environment); Functions oFunction = new Functions(0, dsn, _environment); Requests oRequest = new Requests(user, dsn); Projects oProject = new Projects(user, dsn); ServiceRequests oServiceRequest = new ServiceRequests(user, dsn); ServiceEditor oServiceEditor = new ServiceEditor(user, _se_dsn); Servers oServer = new Servers(user, dsn); Workstations oWorkstation = new Workstations(user, dsn); AssetOrder oAssetOrder = new AssetOrder(user, dsn, _dsn_asset, _environment); AssetSharedEnvOrder oAssetSharedEnvOrder = new AssetSharedEnvOrder(user, dsn, _dsn_asset, _environment); PNCTasks oPNCTask = new PNCTasks(user, dsn); TSM oTSM = new TSM(user, dsn); StatusLevels oStatusLevel = new StatusLevels(); DataSet dsRR = oResourceRequest.GetRequestService(_requestid, _serviceid, _number); if (dsRR.Tables[0].Rows.Count > 0) { if (_rrid == 0) { Int32.TryParse(dsRR.Tables[0].Rows[0]["parent"].ToString(), out _rrid); } if (_rr_workflowid == 0) { Int32.TryParse(dsRR.Tables[0].Rows[0]["id"].ToString(), out _rr_workflowid); } } // Workflow string strWorkflowName = ""; int intProject = oRequest.GetProjectNumber(_requestid); if (intProject > 0) { strView += "<tr><td valign=\"top\"><b>Project Name:</b></td>"; strView += "<td colspan=\"40\">" + oProject.Get(intProject, "name") + "</td></tr>"; strView += "<tr><td valign=\"top\"><b>Project Number:</b></td>"; strView += "<td>" + "<a href=\"" + oRequest.GetDataPointLink(_requestid, _environment) + "\" target=\"_blank\">" + oProject.Get(intProject, "number") + "</a></td></tr>"; } else { string strTaskName = "N/A"; if (_rr_workflowid > 0) { strTaskName = oResourceRequest.GetWorkflow(_rr_workflowid, "name").Trim(); } if ((strTaskName == "" || strTaskName == "N/A") && _rrid > 0) { strTaskName = oResourceRequest.Get(_rrid, "name").Trim(); } if ((strTaskName == "" || strTaskName == "N/A") && _requestid > 0) { strTaskName = oServiceRequest.Get(_requestid, "name").Trim(); } strView += "<tr><td valign=\"top\"><b>Task Name:</b></td>"; strView += "<td colspan=\"40\">" + strTaskName + "</td></tr>"; } strView += "<tr><td valign=\"top\"><b>Task Number:</b></td>"; strView += "<td>" + "<a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"OpenNewWindowMenu('/datapoint/service/resource.aspx?id=" + oFunction.encryptQueryString(_rrid.ToString()) + "', '800', '600');\">CVT" + _requestid.ToString() + "-" + _serviceid.ToString() + "-" + _number.ToString() + "</a></td></tr>"; //strWorkflowName += "<td>" + "<a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"OpenNewWindowMenu('" + oRequest.GetDataPointLink(_requestid, _environment) + "', '800', '600');\">CVT" + _requestid.ToString() + "</a></td>"; string strWorkflowRequested = ""; string strWorkflowCreated = ""; string strWorkflowService = ""; string strWorkflowDepartment = ""; string strWorkflowResources = ""; string strWorkflowStatus = ""; string strWorkflowComments = ""; int intStatus = 0; // Requested strWorkflowRequested += "<td valign=\"top\"><b>Requested By:</b></td>"; int intRequestor = oRequest.GetUser(_requestid); int intRequestorManager = 0; Int32.TryParse(oUser.Get(intRequestor, "manager"), out intRequestorManager); Int32.TryParse(oResourceRequest.Get(_rrid, "status"), out intStatus); strWorkflowRequested += "<td>" + oUser.GetFullName(intRequestor) + " (" + oUser.GetName(intRequestor) + ")" + "</td>"; strWorkflowCreated += "<td valign=\"top\"><b>Created On:</b></td>"; if (_rrid > 0) { strWorkflowCreated += "<td>" + DateTime.Parse(oResourceRequest.Get(_rrid, "created")).ToLongDateString() + "</td>"; } else { strWorkflowCreated += "<td>" + DateTime.Parse(oRequest.Get(_requestid, "created")).ToLongDateString() + "</td>"; } // Service strWorkflowService += "<td valign=\"top\"><b>Service:</b></td>"; if (_serviceid == 0) { strWorkflowService += "<td>" + oRequestItem.GetItem(_itemid, "service_title") + "</td>"; } else { strWorkflowService += "<td>" + oService.GetName(_serviceid) + "</td>"; } // Department strWorkflowDepartment += "<td valign=\"top\"><b>Department:</b></td>"; strWorkflowDepartment += "<td>" + oApplication.Get(oRequestItem.GetItemApplication(_itemid), "service_title") + "</td>"; // Resources string strApprovers = ""; DataSet dsApprovals = oResourceRequest.GetApprovals(_requestid, _serviceid, _number); foreach (DataRow drApprover in dsApprovals.Tables[0].Rows) { int intApprover = Int32.Parse(drApprover["userid"].ToString()); if (drApprover["approved"].ToString() == "" && drApprover["denied"].ToString() == "") { if (strApprovers != "") { strApprovers += "\\n"; } strApprovers += oUser.GetFullName(intApprover) + " (" + oUser.GetName(intApprover) + ")"; } } bool boolAutomated = (oService.Get(_serviceid, "automate") == "1"); if (boolAutomated == false) { DataSet dsReqForm = oRequestItem.GetForm(_requestid, _serviceid, _itemid, _number); if (dsReqForm.Tables[0].Rows.Count > 0) { boolAutomated = (dsReqForm.Tables[0].Rows[0]["automated"].ToString() == "1" ? true : false); } } strWorkflowResources += "<td valign=\"top\"><b>Assigned:</b></td>"; strWorkflowStatus += "<td><b>Status:</b></td>"; if (boolAutomated == true) { strWorkflowResources += "<td valign=\"top\">---</td>"; intStatus = (int)ResourceRequestStatus.NotAvailable; // Set to N/A since it is automated... strWorkflowStatus += "<td>" + oStatusLevel.HTML(intStatus) + "</td>"; } else { List <WorkflowStatus> RR = oResourceRequest.GetStatus(null, _rrid, null, null, null, null, false, _se_dsn); if (RR.Count > 0) { StringBuilder strUsers = new StringBuilder(); foreach (string strUser in RR[0].users) { if (String.IsNullOrEmpty(strUser) == false) { strUsers.Append(strUser); strUsers.AppendLine("<br/>"); } } strWorkflowResources += "<td valign=\"top\">" + strUsers.ToString() + "</td>"; strWorkflowStatus += "<td>" + RR[0].status + "</td>"; if (String.IsNullOrEmpty(RR[0].comments) == false) { strWorkflowComments += "<td valign=\"top\"><b>Comments:</b></td>"; strWorkflowComments += "<td valign=\"top\">" + oFunction.FormatText(RR[0].comments) + "</td>"; } } else { strWorkflowResources += "<td valign=\"top\"> N / A </td>"; strWorkflowStatus += "<td> N / A </td>"; } } strView += "<tr>" + strWorkflowRequested + "</tr><tr>" + strWorkflowCreated + "</tr><tr>" + strWorkflowService + "</tr><tr>" + strWorkflowDepartment + "</tr>" + "<tr>" + strWorkflowStatus + "</tr>" + (strWorkflowResources == "" ? "" : "<tr>" + strWorkflowResources + "</tr>") + (strWorkflowComments == "" ? "" : "<tr>" + strWorkflowComments + "</tr>"); if (strView == "") { strView = "Information Unavailable"; } else { strView = "<table cellpadding=\"3\" cellspacing=\"2\" border=\"0\" style=\"" + oVariable.DefaultFontStyle() + "\">" + strView + "</table>"; StringBuilder sbViewRequest = new StringBuilder(); Customized oCustomized = new Customized(user, dsn); DNS oDNS = new DNS(user, dsn); OnDemandTasks oOnDemandTask = new OnDemandTasks(user, dsn); Reports oReport = new Reports(user, dsn); Audit oAudit = new Audit(user, dsn); Enhancements oEnhancement = new Enhancements(user, dsn); ServerDecommission oServerDecommission = new ServerDecommission(0, dsn); Storage oStorage = new Storage(0, dsn); string strCatch = "1"; try { sbViewRequest.Append(oServiceEditor.GetRequestBody(_requestid, _serviceid, _number, dsn)); if (sbViewRequest.ToString() == "") { strCatch = "2"; sbViewRequest.Append(oCustomized.GetPNCDNSConflictBody(_requestid, _itemid, _number)); } if (sbViewRequest.ToString() == "") { strCatch = "3"; sbViewRequest.Append(oCustomized.GetStorage3rdBody(_requestid, _itemid, _number, _environment)); } if (sbViewRequest.ToString() == "") { strCatch = "4"; sbViewRequest.Append(oOnDemandTask.GetServerOther(_requestid, _serviceid, _number, _environment, _dsn_asset, _dsn_ip)); } if (sbViewRequest.ToString() == "") { strCatch = "5"; sbViewRequest.Append(GetBody(oReport.GetOrderReport(_requestid, _itemid, _number), _serviceid)); } if (sbViewRequest.ToString() == "") { strCatch = "6"; sbViewRequest.Append(oServerDecommission.GetBody(_requestid, _number, _dsn_asset, _environment)); } if (sbViewRequest.ToString() == "") { strCatch = "7"; sbViewRequest.Append(oCustomized.GetDecommissionServerBody(_requestid, _itemid, _number, _dsn_asset)); } if (sbViewRequest.ToString() == "") { strCatch = "7.1"; sbViewRequest.Append(oWorkstation.GetApprovalSummary(_requestid)); } if (sbViewRequest.ToString() == "") { strCatch = "8"; int intEnhancementID = oCustomized.GetEnhancementID(_requestid); if (intEnhancementID > 0) { sbViewRequest.Append("<tr><td>"); sbViewRequest.Append(oCustomized.GetEnhancementBody(intEnhancementID, _environment, false)); sbViewRequest.Append("</td></tr>"); } } if (sbViewRequest.ToString() == "") { strCatch = "9"; int intIssueID = oCustomized.GetIssueID(_requestid); if (intIssueID > 0) { sbViewRequest.Append("<tr><td>"); sbViewRequest.Append(oCustomized.GetIssueBody(intIssueID, _environment, false)); sbViewRequest.Append("</td></tr>"); } } if (sbViewRequest.ToString() == "") { strCatch = "10"; sbViewRequest.Append(GetBody(oCustomized.GetIIS(_requestid, _itemid, _number), _serviceid)); } if (sbViewRequest.ToString() == "") { strCatch = "11"; sbViewRequest.Append(GetBody(oCustomized.GetRemediation(_requestid, _itemid, _number), _serviceid)); } if (sbViewRequest.ToString() == "") { strCatch = "12"; sbViewRequest.Append(GetBody(oCustomized.GetServerArchive(_requestid, _itemid, _number), _serviceid)); } if (sbViewRequest.ToString() == "") { strCatch = "13"; sbViewRequest.Append(GetBody(oCustomized.GetServerRetrieve(_requestid, _itemid, _number), _serviceid)); } if (sbViewRequest.ToString() == "") { strCatch = "14"; sbViewRequest.Append(GetBody(oCustomized.GetTPM(_requestid, _itemid, _number), _serviceid)); } if (sbViewRequest.ToString() == "") { strCatch = "15"; sbViewRequest.Append(GetBody(oCustomized.GetWorkstation(_requestid, _itemid, _number), _serviceid)); } if (sbViewRequest.ToString() == "") { strCatch = "16"; sbViewRequest.Append(GetBody(oCustomized.GetThirdTierDistributed(_requestid, _itemid, _number), _serviceid)); } if (sbViewRequest.ToString() == "") { strCatch = "17"; sbViewRequest.Append(GetBody(oCustomized.GetGeneric(_requestid, _itemid, _number), _serviceid)); } if (sbViewRequest.ToString() == "") { strCatch = "18"; sbViewRequest.Append(oDNS.GetDNSBody(_requestid, _itemid, _number, false, _environment)); } if (sbViewRequest.ToString() == "") { strCatch = "19"; sbViewRequest.Append(oAudit.GetErrorBody(_requestid, _serviceid, _number)); } if (sbViewRequest.ToString() == "")//Server Error Provisioning Support { strCatch = "20"; sbViewRequest.Append(oServer.GetErrorDetailsBody(_requestid, _itemid, _number, _environment)); } if (sbViewRequest.ToString() == "") //Workstation Error Provisioning Support { strCatch = "21"; sbViewRequest.Append(oWorkstation.GetVirtualErrorDetailsBody(_requestid, _number, _environment)); } if (sbViewRequest.ToString() == "") //Asset Procurement { strCatch = "22"; sbViewRequest.Append(oAssetOrder.GetOrderBody(_requestid, _itemid, _number)); } if (sbViewRequest.ToString() == "") //Shared Environement - IM { strCatch = "23"; sbViewRequest.Append(oAssetSharedEnvOrder.GetOrderBody(_requestid, _itemid, _number)); } if (sbViewRequest.ToString() == "") //Backup { strCatch = "24"; sbViewRequest.Append(oTSM.GetBody(_requestid, _itemid, _number, _dsn_asset, _dsn_ip)); } if (sbViewRequest.ToString() == "") // New Enhancement { strCatch = "25"; sbViewRequest.Append(oEnhancement.GetBodyRequest(_requestid, _environment)); } if (sbViewRequest.ToString() == "") // New Enhancement { strCatch = "26"; sbViewRequest.Append(oStorage.GetBody(_requestid, _itemid, _number, _dsn_asset, _dsn_ip, _environment, false)); } if (sbViewRequest.ToString() == "") { //strViewRequest = "Information Unavailable"; sbViewRequest.Append(" "); } else { if (sbViewRequest.ToString().Trim().StartsWith("<table") == false) { sbViewRequest.Insert(0, "<table cellpadding=\"3\" cellspacing=\"2\" border=\"0\" style=\"" + oVariable.DefaultFontStyle() + "\">"); sbViewRequest.Append("</table>"); } } } catch { sbViewRequest = new StringBuilder(" ** WARNING: Information Unavailable (# " + strCatch + ") ** "); } sbViewRequest.Insert(0, "<table cellpadding=\"3\" cellspacing=\"2\" border=\"0\" style=\"" + oVariable.DefaultFontStyle() + "\"><tr><td>"); sbViewRequest.Append("</td></tr></table>"); strView += "<br/>" + sbViewRequest.ToString(); } return(strView); }
protected void Page_Load(object sender, EventArgs e) { Servers oServer = new Servers(0, dsn); VMWare oVMWare = new VMWare(0, dsn); Forecast oForecast = new Forecast(0, dsn); Environments oEnvironment = new Environments(0, dsn); OperatingSystems oOperatingSystem = new OperatingSystems(0, dsn); Classes oClass = new Classes(0, dsn); Requests oRequest = new Requests(0, dsn); Projects oProject = new Projects(0, dsn); ServerName oServerName = new ServerName(0, dsn); Locations oLocations = new Locations(0, dsn); ModelsProperties oModelsProperties = new ModelsProperties(0, dsn); ServicePacks oServicePacks = new ServicePacks(0, dsn); Users oUser = new Users(0, dsn); Organizations oOrganization = new Organizations(0, dsn); IPAddresses oIPAddresses = new IPAddresses(0, dsnIP, dsn); ResourceRequest oResourceRequest = new ResourceRequest(0, dsn); Domains oDomains = new Domains(0, dsn); oVariables = new Variables(intEnvironment); if (Request.QueryString["id"] != null && Request.QueryString["id"] != "") { StringBuilder sbTable = new StringBuilder(strTable); int intServer = Int32.Parse(Request.QueryString["id"]); DataSet ds = oServer.Get(intServer); if (ds.Tables[0].Rows.Count > 0) { int intAnswer = Int32.Parse(ds.Tables[0].Rows[0]["answerid"].ToString()); int intName = Int32.Parse(ds.Tables[0].Rows[0]["nameid"].ToString()); string strName = oServer.GetName(intServer, boolUsePNCNaming); int intForecast = Int32.Parse(oForecast.GetAnswer(intAnswer, "forecastid")); int intRequest = Int32.Parse(oForecast.Get(intForecast, "requestid")); int intProject = oRequest.GetProjectNumber(intRequest); int intClass = Int32.Parse(oForecast.GetAnswer(intAnswer, "classid")); int intEnv = Int32.Parse(oForecast.GetAnswer(intAnswer, "environmentid")); int intModel = Int32.Parse(ds.Tables[0].Rows[0]["modelid"].ToString()); string _save_location = oVariables.UploadsFolder() + "SC\\"; string strFileName = "SC_" + intServer.ToString() + "_" + oProject.Get(intProject, "number") + ".HTM"; if (Directory.Exists(_save_location) == false) { Directory.CreateDirectory(_save_location); } string strFile = _save_location + strFileName; StreamWriter fp = File.CreateText(strFile); string strDefault = "<table cellpadding=\"2\" cellspacing=\"2\" border=\"0\" class=\"default\">"; StringBuilder sbLeft1 = new StringBuilder(); string strLead = oProject.Get(intProject, "lead"); int intLead = 0; if (strLead != "") { intLead = Int32.Parse(strLead); } sbLeft1.Append("<fieldset>"); sbLeft1.Append("<legend><b>Who is this for?</b></legend>"); sbLeft1.Append(strDefault); sbLeft1.Append("<tr>"); sbLeft1.Append("<td>Client XID:</td>"); sbLeft1.Append("<td>"); sbLeft1.Append(GetBox(intLead > 0 ? oUser.GetName(intLead) : "***ERROR**", 200)); sbLeft1.Append("</td>"); sbLeft1.Append("</tr>"); sbLeft1.Append("<tr>"); sbLeft1.Append("<td>Client Name:</td>"); sbLeft1.Append("<td>"); sbLeft1.Append(GetBox(intLead > 0 ? oUser.GetFullName(intLead) : "***ERROR**", 200)); sbLeft1.Append("</td>"); sbLeft1.Append("</tr>"); sbLeft1.Append("<tr>"); sbLeft1.Append("<td>Client Phone No.:</td>"); sbLeft1.Append("<td>"); sbLeft1.Append(GetBox(intLead > 0 ? oUser.Get(intLead, "phone") : "***ERROR**", 200)); sbLeft1.Append("</td>"); sbLeft1.Append("</tr>"); sbLeft1.Append("<tr>"); sbLeft1.Append("<td>Client Department:</td>"); sbLeft1.Append("<td>"); sbLeft1.Append(GetBox("", 200)); sbLeft1.Append("</td>"); sbLeft1.Append("</tr>"); sbLeft1.Append("<tr>"); sbLeft1.Append("<td>Client Fax:</td>"); sbLeft1.Append("<td>"); sbLeft1.Append(GetBox("", 200)); sbLeft1.Append("</td>"); sbLeft1.Append("</tr>"); sbLeft1.Append("<tr>"); sbLeft1.Append("<td>Client Cost Center:</td>"); sbLeft1.Append("<td>"); sbLeft1.Append(GetBox("", 200)); sbLeft1.Append("</td>"); sbLeft1.Append("</tr>"); sbLeft1.Append("</table>"); sbLeft1.Append("</fieldset>"); StringBuilder sbRight1 = new StringBuilder(); string strIE = oProject.Get(intProject, "engineer"); int intIE = 0; if (strIE != "") { intIE = Int32.Parse(strIE); } sbRight1.Append("<fieldset>"); sbRight1.Append("<legend><b>Requestor Information</b></legend>"); sbRight1.Append(strDefault); sbRight1.Append("<tr>"); sbRight1.Append("<td>Requested By Name:</td>"); sbRight1.Append("<td>"); sbRight1.Append(GetBox(intIE > 0 ? oUser.GetFullName(intIE) : "***ERROR**", 200)); sbRight1.Append("</td>"); sbRight1.Append("</tr>"); sbRight1.Append("<tr>"); sbRight1.Append("<td>Requested By Phone No.:</td>"); sbRight1.Append("<td>"); sbRight1.Append(GetBox(intIE > 0 ? oUser.Get(intIE, "phone") : "***ERROR**", 200)); sbRight1.Append("</td>"); sbRight1.Append("</tr>"); sbRight1.Append("<tr>"); sbRight1.Append("<td>Requested By Email:</td>"); sbRight1.Append("<td>"); sbRight1.Append(GetBox(intIE > 0 ? oUser.GetEmail(oUser.GetName(intIE), intEnvironment) : "***ERROR**", 200)); sbRight1.Append("</td>"); sbRight1.Append("</tr>"); sbRight1.Append("</table>"); sbRight1.Append("</fieldset>"); sbRight1.Append("<fieldset>"); sbRight1.Append("<legend><b>Location Information:</b></legend>"); sbRight1.Append(strDefault); sbRight1.Append("<tr>"); sbRight1.Append("<td>Location:</td>"); sbRight1.Append("<td>"); sbRight1.Append(GetBox("", 200)); sbRight1.Append("</td>"); sbRight1.Append("</tr>"); sbRight1.Append("<tr>"); sbRight1.Append("<td>Location Full Name:</td>"); sbRight1.Append("<td>"); sbRight1.Append(GetBox("", 200)); sbRight1.Append("</td>"); sbRight1.Append("</tr>"); sbRight1.Append("</table>"); sbRight1.Append("</fieldset>"); StringBuilder sbCenter1 = new StringBuilder(); sbCenter1.Append("<fieldset>"); sbCenter1.Append("<legend><b>Brief Desc:</b></legend>"); sbCenter1.Append(strDefault); sbCenter1.Append("<tr>"); sbCenter1.Append("<td>"); sbCenter1.Append(GetBox(oForecast.GetAnswer(intAnswer, "name") + " (" + strName + ")", 600)); sbCenter1.Append("</td>"); sbCenter1.Append("</tr>"); sbCenter1.Append("</table>"); sbCenter1.Append("</fieldset>"); StringBuilder sbLeft2 = new StringBuilder(); sbLeft2.Append("<fieldset>"); sbLeft2.Append("<legend><b>Project Information:</b></legend>"); sbLeft2.Append(strDefault); sbLeft2.Append("<tr>"); sbLeft2.Append("<td>Project ID:</td>"); sbLeft2.Append("<td>"); sbLeft2.Append(GetBox(oProject.Get(intProject, "number"), 200)); sbLeft2.Append("</td>"); sbLeft2.Append("<td>Project Manager XID:</td>"); sbLeft2.Append("<td>"); sbLeft2.Append(GetBox(intLead > 0 ? oUser.GetName(intLead) : "***ERROR**", 200)); sbLeft2.Append("</td>"); sbLeft2.Append("</tr>"); sbLeft2.Append("<tr>"); sbLeft2.Append("<td>Project Name:</td>"); sbLeft2.Append("<td>"); sbLeft2.Append(GetBox(oProject.Get(intProject, "name"), 200)); sbLeft2.Append("</td>"); sbLeft2.Append("<td>Project Manager Name:</td>"); sbLeft2.Append("<td>"); sbLeft2.Append(GetBox(intLead > 0 ? oUser.GetFullName(intLead) : "***ERROR**", 200)); sbLeft2.Append("</td>"); sbLeft2.Append("</tr>"); sbLeft2.Append("<tr>"); sbLeft2.Append("<td>Project Budgeted:</td>"); sbLeft2.Append("<td>"); sbLeft2.Append(GetBox(oProject.Get(intProject, "bd"), 200)); sbLeft2.Append("</td>"); sbLeft2.Append("<td>Project Manager Phone:</td>"); sbLeft2.Append("<td>"); sbLeft2.Append(GetBox(intLead > 0 ? oUser.Get(intLead, "phone") : "***ERROR**", 200)); sbLeft2.Append("</td>"); sbLeft2.Append("</tr>"); sbLeft2.Append("<tr>"); sbLeft2.Append("<td>Project Cost Ctr:</td>"); sbLeft2.Append("<td>"); sbLeft2.Append(GetBox("", 200)); sbLeft2.Append("</td>"); sbLeft2.Append("<td>Project Manager Email:</td>"); sbLeft2.Append("<td>"); sbLeft2.Append(GetBox(intLead > 0 ? oUser.GetEmail(oUser.GetName(intLead), intEnvironment) : "***ERROR**", 200)); sbLeft2.Append("</td>"); sbLeft2.Append("</tr>"); sbLeft2.Append("</table>"); sbLeft2.Append("</fieldset>"); OnDemandTasks oOnDemandTasks = new OnDemandTasks(0, dsn); int intImplementor = 0; DataSet dsTasks = oOnDemandTasks.GetPending(intAnswer); if (dsTasks.Tables[0].Rows.Count > 0) { intImplementor = Int32.Parse(dsTasks.Tables[0].Rows[0]["resourceid"].ToString()); intImplementor = Int32.Parse(oResourceRequest.GetWorkflow(intImplementor, "userid")); } else { intImplementor = -999; } sbTable = new StringBuilder("<table cellpadding=\"2\" cellspacing=\"2\" border=\"0\" class=\"default\">"); sbTable.Append("<tr>"); sbTable.Append("<td colspan=\"2\"><b>NOTE:</b> ASSIGN THIS REQUEST TO: "); sbTable.Append(intImplementor > 0 || intImplementor == -999 ? oUser.GetFullName(intImplementor) + " (" + oUser.GetName(intImplementor) + ")" : "***ERROR**"); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>"); sbTable.Append(sbLeft1.ToString()); sbTable.Append("</td>"); sbTable.Append("<td>"); sbTable.Append(sbRight1.ToString()); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td colspan=\"2\">"); sbTable.Append(sbCenter1.ToString()); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td colspan=\"2\">"); sbTable.Append(sbLeft2.ToString()); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td colspan=\"2\"><p> </p></td>"); sbTable.Append("</tr>"); bool boolVirtual = false; if (boolVirtual == true) { sbTable.Append("<tr>"); sbTable.Append("<td colspan=\"2\" class=\"header\">REQUISITION VIRTUAL SERVER GUEST</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Requested Server Completion Date:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox(oForecast.GetAnswer(intAnswer, "implementation"), 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Server Hardware Specifications:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox("VIRTUAL SERVER GUEST VMWARE", 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Server Operating System:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox(oOperatingSystem.Get(Int32.Parse(ds.Tables[0].Rows[0]["osid"].ToString()), "name").ToUpper() + " (" + oServicePacks.Get(Int32.Parse(ds.Tables[0].Rows[0]["spid"].ToString()), "name").ToUpper() + ")", 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Environment:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox(oEnvironment.Get(Int32.Parse(oForecast.GetAnswer(intAnswer, "environmentid")), "name").ToUpper(), 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Destination Class:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox(oClass.Get(Int32.Parse(oForecast.GetAnswer(intAnswer, "classid")), "name").ToUpper(), 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr><td colspan=\"2\"><p> </p></td></tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Destination Domain:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox(oDomains.Get(Int32.Parse(ds.Tables[0].Rows[0]["domainid"].ToString()), "name").ToUpper(), 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Backup Method:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox("TSM", 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); string strHost = "***ERROR***"; DataSet dsGuest = oVMWare.GetGuest(strName); if (dsGuest.Tables[0].Rows.Count > 0) { strHost = oVMWare.GetHost(Int32.Parse(dsGuest.Tables[0].Rows[0]["hostid"].ToString()), "name").ToUpper(); } sbTable.Append("<tr>"); sbTable.Append("<td>Host Server Name:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox(strHost, 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr><td colspan=\"2\"><p> </p></td></tr>"); sbTable.Append("<tr>"); sbTable.Append("<td bgcolor=\"#CCCCCC\" style=\"border:2px outset #FFFFFF\">Network Protocols</td>"); sbTable.Append("<td bgcolor=\"#CCCCCC\" style=\"border:2px outset #FFFFFF\">Server Software - click in box below to add</td>"); sbTable.Append("</tr>"); bool boolSQL = false; bool boolIIS = false; DataSet dsComp = oServerName.GetComponentDetailSelected(intServer, 1); foreach (DataRow drComp in dsComp.Tables[0].Rows) { if (drComp["code"].ToString() == "IIS") { boolIIS = true; } if (drComp["code"].ToString() == "SQL") { boolSQL = true; } } sbTable.Append("<tr>"); sbTable.Append("<td>"); sbTable.Append(GetBox("TCP/IP", 250)); sbTable.Append("</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox((boolSQL ? "SQL" : ""), 350)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>"); sbTable.Append(GetBox("", 250)); sbTable.Append("</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox((boolIIS ? "IIS" : ""), 350)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr><td colspan=\"2\"><p> </p></td></tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Attached to SAN?:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox("NO", 150)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Server is Clustered:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox("NO", 150)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Server Load Balanced:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox("NO", 150)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Maximum Allowable Downtime:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox("Not Applicable", 150) + "</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td colspan=\"2\"><input type=\"checkbox\" class=\"default\"/> Hardware Refresh</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr><td colspan=\"2\"><p> </p></td></tr>"); sbTable.Append("<tr>"); sbTable.Append("<td colspan=\"2\">Intended Use Description:</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td colspan=\"2\">"); sbTable.Append(GetBox("", 500)); sbTable.Append("</td>"); sbTable.Append("</tr>"); } else { sbTable.Append("<tr>"); sbTable.Append("<td colspan=\"2\" class=\"header\">REQUISITION SERVER</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Requested Server Completion Date:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox(oForecast.GetAnswer(intAnswer, "implementation"), 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Server Hardware Specifications:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox(oModelsProperties.Get(intModel, "name"), 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td colspan=\"2\"><input type=\"checkbox\" class=\"default\" checked/> User re-deployable hardware if applicable</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>PO:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox("", 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Server Operating System:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox(oOperatingSystem.Get(Int32.Parse(ds.Tables[0].Rows[0]["osid"].ToString()), "name").ToUpper() + " (" + oServicePacks.Get(Int32.Parse(ds.Tables[0].Rows[0]["spid"].ToString()), "name").ToUpper() + ")", 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Environment:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox(oEnvironment.Get(Int32.Parse(oForecast.GetAnswer(intAnswer, "environmentid")), "name").ToUpper(), 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Destination Class:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox(oClass.Get(Int32.Parse(oForecast.GetAnswer(intAnswer, "classid")), "name").ToUpper(), 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr><td colspan=\"2\"><p> </p></td></tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Destination Domain:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox(oDomains.Get(Int32.Parse(ds.Tables[0].Rows[0]["domainid"].ToString()), "name").ToUpper(), 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Server Location:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox(oLocations.GetFull(Int32.Parse(oForecast.GetAnswer(intAnswer, "addressid"))).ToUpper(), 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Backup Method:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox("TSM", 300)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr><td colspan=\"2\"><p> </p></td></tr>"); sbTable.Append("<tr>"); sbTable.Append("<td bgcolor=\"#CCCCCC\" style=\"border:2px outset #FFFFFF\">Network Protocols</td>"); sbTable.Append("<td bgcolor=\"#CCCCCC\" style=\"border:2px outset #FFFFFF\">Server Software - click in box below to add</td>"); sbTable.Append("</tr>"); bool boolSQL = false; bool boolIIS = false; DataSet dsComp = oServerName.GetComponentDetailSelected(intServer, 1); foreach (DataRow drComp in dsComp.Tables[0].Rows) { if (drComp["code"].ToString() == "IIS") { boolIIS = true; } if (drComp["code"].ToString() == "SQL") { boolSQL = true; } } sbTable.Append("<tr>"); sbTable.Append("<td>"); sbTable.Append(GetBox("TCP/IP", 250)); sbTable.Append("</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox((boolSQL ? "SQL" : ""), 350)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>"); sbTable.Append(GetBox("", 250)); sbTable.Append("</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox((boolIIS ? "IIS" : ""), 350)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr><td colspan=\"2\"><p> </p></td></tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Attached to SAN?:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox("NO", 150)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Server is Clustered:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox("NO", 150)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Server Load Balanced:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox("NO", 150)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td>Maximum Allowable Downtime:</td>"); sbTable.Append("<td>"); sbTable.Append(GetBox("Not Applicable", 150)); sbTable.Append("</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td colspan=\"2\"><input type=\"checkbox\" class=\"default\"/> Hardware Refresh</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr><td colspan=\"2\"><p> </p></td></tr>"); sbTable.Append("<tr>"); sbTable.Append("<td colspan=\"2\">Intended Use Description:</td>"); sbTable.Append("</tr>"); sbTable.Append("<tr>"); sbTable.Append("<td colspan=\"2\">"); sbTable.Append(GetBox("", 500)); sbTable.Append("</td>"); sbTable.Append("</tr>"); } sbTable.Append("</table>"); fp.WriteLine("<html>"); fp.WriteLine("<head>"); fp.WriteLine("<title>ClearView | Service Center Request Form</title>"); fp.WriteLine("<style type=\"text/css\">"); fp.WriteLine(".default {font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 10px;}"); fp.WriteLine(".header {font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 16px;font-style: italic;font-weight: bold;}"); fp.WriteLine("</style>"); fp.WriteLine("<body leftmargin=\"0\" topmargin=\"0\">"); fp.WriteLine(sbTable.ToString()); fp.WriteLine("</body>"); fp.WriteLine("</html>"); fp.Close(); } strTable = sbTable.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { intProfile = Int32.Parse(Request.Cookies["profileid"].Value); oFunction = new Functions(intProfile, dsn, intEnvironment); oUser = new Users(intProfile, dsn); oPage = new Pages(intProfile, dsn); oResourceRequest = new ResourceRequest(intProfile, dsn); oRequestItem = new RequestItems(intProfile, dsn); oRequest = new Requests(intProfile, dsn); oApplication = new Applications(intProfile, dsn); oAccountRequest = new AccountRequest(intProfile, dsn); oDelegate = new Delegates(intProfile, dsn); oService = new Services(intProfile, dsn); if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "") { intApplication = Int32.Parse(Request.QueryString["applicationid"]); } if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "") { intPage = Int32.Parse(Request.QueryString["pageid"]); } if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "") { intApplication = Int32.Parse(Request.Cookies["application"].Value); } string strAttributes = ""; bool boolIncomplete = false; if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "") { intResourceWorkflow = Int32.Parse(Request.QueryString["rrid"]); int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow); DataSet ds = oResourceRequest.Get(intResourceParent); if (ds.Tables[0].Rows.Count > 0) { intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString()); intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString()); intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString()); // Workflow start bool boolComplete = (oResourceRequest.GetWorkflow(intResourceWorkflow, "status") == "3"); int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid")); double dblAllocated = double.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated")); // Workflow end intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString()); int intApp = oRequestItem.GetItemApplication(intItem); if (Request.QueryString["save"] != null && Request.QueryString["save"] != "") { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "saved", "<script type=\"text/javascript\">alert('Information Saved Successfully');<" + "/" + "script>"); } if (oService.Get(intService, "sla") != "") { oFunction.ConfigureToolButton(btnSLA, "/images/tool_sla"); int intDays = oResourceRequest.GetSLA(intResourceParent); if (intDays < 1) { btnSLA.Style["border"] = "solid 2px #FF0000"; } else if (intDays < 3) { btnSLA.Style["border"] = "solid 2px #FF9999"; } btnSLA.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST_SLA','?rrid=" + intResourceParent.ToString() + "');"); } else { btnSLA.ImageUrl = "/images/tool_sla_dbl.gif"; btnSLA.Enabled = false; } if (!IsPostBack) { if (intResourceWorkflow > 0) { ds = oRequest.Get(intRequest); if (ds.Tables[0].Rows.Count > 0) { ds = oAccountRequest.GetMaintenance(intRequest, intItem, intNumber); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["completed"].ToString() == "") { boolIncomplete = true; } else { lblComplete.Text = ds.Tables[0].Rows[0]["completed"].ToString(); panComplete.Visible = true; } lblRequestBy.Text = oUser.GetFullName(oRequest.GetUser(intRequest)); lblRequestOn.Text = DateTime.Parse(oRequest.Get(intRequest, "created")).ToLongDateString(); int intDomain = Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()); Domains oDomain = new Domains(intProfile, dsn); intDomain = Int32.Parse(oDomain.Get(intDomain, "environment")); AD oAD = new AD(intProfile, dsn, intDomain); DataSet dsParameters = oAccountRequest.GetMaintenanceParameters(intRequest, intItem, intNumber); switch (ds.Tables[0].Rows[0]["maintenance"].ToString()) { case "DISABLE": lblType.Text = "Account Disable"; strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>"; strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>"; break; case "UNLOCK": lblType.Text = "Account Unlock"; strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>"; strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>"; break; case "ENABLE": lblType.Text = "Account Enable"; strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>"; strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>"; break; case "EMAIL": lblType.Text = "Email Enable an Account"; strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>"; strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>"; break; case "MOVE": lblType.Text = "Account Move"; strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>"; strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>"; strDetails += "<tr><td><b>New Location:</b></td><td>" + dsParameters.Tables[0].Rows[0]["value"].ToString() + "</td>"; break; case "PASSWORD": lblType.Text = "Account Password Change"; strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>"; strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>"; break; case "COPY": lblType.Text = "Account Copy"; panPassword.Visible = true; strAttributes += "ValidateText('" + txtPassword.ClientID + "','Please enter a password') && "; strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>"; strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>"; panID.Visible = true; txtID.Text = dsParameters.Tables[0].Rows[0]["value"].ToString(); panFirst.Visible = true; txtFirst.Text = dsParameters.Tables[0].Rows[1]["value"].ToString(); panLast.Visible = true; txtLast.Text = dsParameters.Tables[0].Rows[2]["value"].ToString(); panGroups.Visible = true; string[] strGroups; char[] strSplit = { ';' }; strGroups = dsParameters.Tables[0].Rows[3]["value"].ToString().Split(strSplit); for (int ii = 0; ii < strGroups.Length; ii++) { if (strGroups[ii].Trim() != "") { ListItem oList = new ListItem(strGroups[ii].Trim()); chkGroups.Items.Add(oList); oList.Selected = true; } } break; case "DELETE": lblType.Text = "Account Deletion"; strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>"; strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>"; break; case "RENAME": lblType.Text = "Account Rename"; strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>"; strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>"; panID.Visible = true; txtID.Text = dsParameters.Tables[0].Rows[0]["value"].ToString(); panFirst.Visible = true; txtFirst.Text = dsParameters.Tables[0].Rows[1]["value"].ToString(); panLast.Visible = true; txtLast.Text = dsParameters.Tables[0].Rows[2]["value"].ToString(); break; default: lblType.Text = "Unavailable"; strDetails += "<tr><td colspan=\"2\"><b>Invalid Maintenance Code!</b></td>"; break; } panWorkload.Visible = true; } else { panDenied.Visible = true; } } else { panDenied.Visible = true; } } else { panDenied.Visible = true; } btnDenied.Attributes.Add("onclick", "return CloseWindow();"); oFunction.ConfigureToolButton(btnApprove, "/images/tool_approve"); oFunction.ConfigureToolButton(btnDeny, "/images/tool_deny"); if (boolIncomplete == true) { btnApprove.Attributes.Add("onclick", "return " + strAttributes + "confirm('Are you sure you want to APPROVE this request?');"); btnDeny.Attributes.Add("onclick", "return ValidateText('" + txtComments.ClientID + "','Please enter a reason') && confirm('Are you sure you want to DENY this request?');"); } else { btnApprove.Attributes.Add("onclick", "alert('This request has already been completed.\\n\\nIf this request continues to appear in your work queue, please contact a ClearView administrator.');return false;"); btnDeny.Attributes.Add("onclick", "alert('This request has already been completed.\\n\\nIf this request continues to appear in your work queue, please contact a ClearView administrator.');return false;"); } oFunction.ConfigureToolButton(btnPrint, "/images/tool_print"); btnPrint.Attributes.Add("onclick", "return PrintWindow();"); oFunction.ConfigureToolButton(btnClose, "/images/tool_close"); btnClose.Attributes.Add("onclick", "return ExitWindow();"); // 6/1/2009 - Load ReadOnly View if (oResourceRequest.CanUpdate(intProfile, intResourceWorkflow, false) == false) { oFunction.ConfigureToolButtonRO(btnApprove, btnDeny); //panDenied.Visible = true; } } } else { panDenied.Visible = true; } } else { panDenied.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { AuthenticateUser(); intProfile = Int32.Parse(Request.Cookies["profileid"].Value); oForecast = new Forecast(intProfile, dsn); oModelsProperties = new ModelsProperties(intProfile, dsn); oFunction = new Functions(intProfile, dsn, intEnvironment); Pages oPage = new Pages(intProfile, dsn); if (Request.QueryString["done"] != null && Request.QueryString["done"] != "") { oForecast.UpdateAnswerSetComplete(Int32.Parse(Request.QueryString["done"])); Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "saved", "<script type=\"text/javascript\">alert('Design Marked Completed Successfully\\n\\nPlease wait while the page reloads....');window.navigate('" + Request.Path + "?model=" + Request.QueryString["model"] + "&filters=" + Request.QueryString["filters"] + "');<" + "/" + "script>"); } else if (Request.QueryString["model"] != null && Request.QueryString["model"] != "" && Request.QueryString["filters"] != null) { string strFilter = oFunction.decryptQueryString(Request.QueryString["filters"]); intModel = Int32.Parse(Request.QueryString["model"]); int intType = oModelsProperties.GetType(intModel); Types oType = new Types(intProfile, dsn); int intPlatform = oType.GetPlatform(intType); lblModel.Text = oModelsProperties.Get(intModel, "name"); bool boolOther = false; DataSet dsDemand = oForecast.GetAnswersModel(intPlatform); DataTable dtDemand = dsDemand.Tables[0]; DataRow[] drModels = dtDemand.Select("model = " + intModel.ToString() + strFilter); ResourceRequest oResourceRequest = new ResourceRequest(0, dsn); Users oUser = new Users(0, dsn); StringBuilder sb = new StringBuilder(strResults); OnDemandTasks oOnDemandTasks = new OnDemandTasks(0, dsn); foreach (DataRow dr in drModels) { int intProject = Int32.Parse(dr["projectid"].ToString()); int intAnswer = Int32.Parse(dr["id"].ToString()); int intImplementor = 0; DataSet dsTasks = oOnDemandTasks.GetPending(intAnswer); if (dsTasks.Tables[0].Rows.Count > 0) { intImplementor = Int32.Parse(dsTasks.Tables[0].Rows[0]["resourceid"].ToString()); intImplementor = Int32.Parse(oResourceRequest.GetWorkflow(intImplementor, "userid")); } else { intImplementor = -999; } string strXID = ""; if (intImplementor > 0 || intImplementor == -999) { strXID = oUser.GetFullName(intImplementor); } boolOther = !boolOther; sb.Append("<tr"); sb.Append(boolOther ? " bgcolor=\"F6F6F6\"" : ""); sb.Append("><td><a onclick=\"return confirm('Are you sure you want to mark this design as being completed?');\" title=\"Mark as Complete\" href=\""); sb.Append(Request.Path); sb.Append("?model="); sb.Append(intModel.ToString()); sb.Append("&filters="); sb.Append(Request.QueryString["filters"]); sb.Append("&done="); sb.Append(dr["id"].ToString()); sb.Append("\"><img src=\"/images/check.gif\" border=\"0\" align=\"absmiddle\"/></a></td><td>"); sb.Append(dr["id"].ToString()); sb.Append("</td><td><a href=\""); sb.Append(oPage.GetFullLink(intDesignBuilder)); sb.Append("?id="); sb.Append(dr["forecastid"].ToString()); sb.Append("&highlight="); sb.Append(dr["id"].ToString()); sb.Append("\" target=\"_blank\">"); sb.Append(dr["project_name"].ToString()); sb.Append("</a></td><td>"); sb.Append(dr["project_number"].ToString()); sb.Append("</td><td>"); sb.Append(dr["confidence"].ToString()); sb.Append("</td><td>"); sb.Append(dr["implementation"].ToString()); sb.Append("</td><td>"); sb.Append(dr["class"].ToString()); sb.Append("</td><td>"); sb.Append(dr["environment"].ToString()); sb.Append("</td><td>"); sb.Append(dr["location"].ToString()); sb.Append("</td><td>"); sb.Append(strXID); sb.Append("</td><td align=\"right\">"); sb.Append(dr["quantity"].ToString()); sb.Append("</td><td align=\"right\">"); sb.Append(dr["recovery_number"].ToString()); sb.Append("</td></tr>"); } strResults = sb.ToString(); } }