protected void Page_Load(object sender, EventArgs e) { intProfile = Int32.Parse(Request.Cookies["profileid"].Value); oPage = new Pages(intProfile, dsn); oUser = new Users(intProfile, dsn); oServer = new Servers(intProfile, dsn); oResourceRequest = new ResourceRequest(intProfile, dsn); oForecast = new Forecast(intProfile, dsn); oFunctions = new Functions(intProfile, dsn, intEnvironment); 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); } lblTitle.Text = oPage.Get(intPage, "title"); if (!IsPostBack) { if (Request.QueryString["name"] != null) { string strQuery = oFunctions.decryptQueryString(Request.QueryString["name"]); txtName.Text = strQuery; CheckResults(strQuery); } txtName.Attributes.Add("onkeydown", "if(event.which || event.keyCode){if ((event.which == 13) || (event.keyCode == 13)) {document.getElementById('" + btnSearch.ClientID + "').click();return false;}} else {return true}; "); btnSearch.Attributes.Add("onclick", "return ValidateText('" + txtName.ClientID + "','Please enter the server name');"); } }
protected void btnNext_Click(Object Sender, EventArgs e) { int intDone = Save(); OnDemandTasks oOnDemandTasks = new OnDemandTasks(0, dsn); if (intDone == 1) { if (oForecast.CanAutoProvision(intID) == false && oOnDemandTasks.GetPending(intID).Tables[0].Rows.Count == 0) { // Add Resource Request 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); ResourceRequest oResourceRequest = new ResourceRequest(0, dsn); int intImplementor = 0; string strType = "Distributed"; DataSet dsResource = oResourceRequest.GetProjectItem(intProject, intImplementorDistributed); if (oForecast.GetPlatformDistributed(intID, intWorkstationPlatform) == false) { dsResource = oResourceRequest.GetProjectItem(intProject, intImplementorMidrange); strType = "Midrange"; } if (dsResource.Tables[0].Rows.Count > 0) { intImplementor = (dsResource.Tables[0].Rows[0]["userid"].ToString() == "" ? 0 : Int32.Parse(dsResource.Tables[0].Rows[0]["userid"].ToString())); } if (intImplementor > 0) { int intNextNumber = oResourceRequest.GetNumber(intRequest); int intResourceParent = oResourceRequest.Add(intRequest, -1, -1, intNextNumber, "Provisioning Task (" + strType + ")", 0, 6.00, 2, 1, 1, 1); int intResourceWorkflow = oResourceRequest.AddWorkflow(intResourceParent, 0, "Provisioning Task (" + strType + ")", intImplementor, 0, 6.00, 2, 0); oOnDemandTasks.AddPending(intID, intResourceWorkflow); oResourceRequest.UpdateAssignedBy(intResourceParent, -999); } } } oForecast.UpdateAnswerStep(intID, 1, intDone); Response.Redirect(Request.Path + "?id=" + intID.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); 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; } }
protected void Page_Load(object sender, EventArgs e) { Response.Cookies["loginreferrer"].Value = "/admin/projects_pending.aspx"; Response.Cookies["loginreferrer"].Expires = DateTime.Now.AddDays(30); if (Request.Cookies["adminid"] != null && Request.Cookies["adminid"].Value != "") { intProfile = Int32.Parse(Request.Cookies["adminid"].Value); } else { Response.Redirect("/admin/login.aspx"); } oProject = new Projects(intProfile, dsn); oProjectNumber = new ProjectNumber(intProfile, dsn); oRequest = new Requests(intProfile, dsn); oRequestItem = new RequestItems(intProfile, dsn); oService = new Services(intProfile, dsn); oProjectPending = new ProjectsPending(intProfile, dsn, intEnvironment); oOrganization = new Organizations(intProfile, dsn); oDocument = new Documents(intProfile, dsn); oUser = new Users(intProfile, dsn); oForecast = new Forecast(intProfile, dsn); oServiceRequest = new ServiceRequests(intProfile, dsn); if (!IsPostBack) { if (Request.QueryString["rid"] != null && Request.QueryString["rid"] != "") { // Process Service Requests int intRequest = Int32.Parse(Request.QueryString["rid"]); DataSet dsForm = oRequestItem.GetForms(intRequest); foreach (DataRow drForm in dsForm.Tables[0].Rows) { if (drForm["done"].ToString() == "0") { int intItem = Int32.Parse(drForm["itemid"].ToString()); int intNumber = Int32.Parse(drForm["number"].ToString()); int intService = Int32.Parse(drForm["serviceid"].ToString()); string strPath = oService.Get(intService, "cp_path"); if (strPath.Trim() == "") { // For now, bypass oRequestItem.UpdateFormDone(intRequest, intItem, intNumber, 1); } else { Control oControl = (Control)LoadControl(strPath); PHcp.Controls.Add(oControl); } } } panPH.Visible = true; } else if (Request.QueryString["id"] != null && Request.QueryString["id"] != "") { DataSet ds = oProjectPending.Get(Int32.Parse(Request.QueryString["id"])); int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString()); if (Request.QueryString["pid"] != null && Request.QueryString["pid"] != "") { int intProject = Int32.Parse(Request.QueryString["pid"]); if (intProject > 0) { // Process Design Builder DataSet dsForecast = oForecast.GetRequest(intRequest); if (dsForecast.Tables[0].Rows.Count > 0) { int intForecast = Int32.Parse(dsForecast.Tables[0].Rows[0]["id"].ToString()); DataSet dsDesigns = oForecast.GetAnswers(intForecast); OnDemandTasks oOnDemandTasks = new OnDemandTasks(0, dsn); ResourceRequest oResourceRequest = new ResourceRequest(0, dsn); foreach (DataRow drDesign in dsDesigns.Tables[0].Rows) { int intDesign = Int32.Parse(drDesign["id"].ToString()); int intDesignRequest = 0; if (Int32.TryParse(oForecast.GetAnswer(intDesign, "requestid"), out intDesignRequest) == true) { if (intDesignRequest > 0) { // Update the REQUESTID in CV_FORECAST_ANSWERS with the new project correlation oRequest.Update(intDesignRequest, intProject); } } if (oForecast.CanAutoProvision(intDesign) == false) { // Need to add a builder int intImplementorD = 0; DataSet dsResourceD = oResourceRequest.GetProjectItem(intProject, intImplementorDistributed); if (dsResourceD.Tables[0].Rows.Count > 0) { intImplementorD = Int32.Parse(dsResourceD.Tables[0].Rows[0]["userid"].ToString()); } int intImplementorM = 0; DataSet dsResourceM = oResourceRequest.GetProjectItem(intProject, intImplementorMidrange); if (dsResourceM.Tables[0].Rows.Count > 0) { intImplementorM = Int32.Parse(dsResourceM.Tables[0].Rows[0]["userid"].ToString()); } if (oForecast.GetPlatformDistributedForecast(intDesign, intWorkstationPlatform) == true) { if (intImplementorD > 0) { int intNextNumber = oResourceRequest.GetNumber(intRequest); int intResourceParent = oResourceRequest.Add(intRequest, -1, -1, intNextNumber, "Provisioning Task (Distributed)", 0, 6.00, 2, 1, 1, 1); int intResourceWorkflow = oResourceRequest.AddWorkflow(intResourceParent, 0, "Provisioning Task (Distributed)", intImplementorD, 0, 6.00, 2, 0); oOnDemandTasks.AddPending(intDesign, intResourceWorkflow); oResourceRequest.UpdateAssignedBy(intResourceParent, -999); } else { // Submit for assignment if (oServiceRequest.Get(intRequest, "requestid") == "") { oServiceRequest.Add(intRequest, 1, 1); } int intResource = oServiceRequest.AddRequest(intRequest, intImplementorDistributed, intImplementorDistributedService, 0, 0.00, 2, 1, dsnServiceEditor); if (oServiceRequest.NotifyApproval(intResource, intResourceRequestApprove, intEnvironment, "", dsnServiceEditor) == false) { oServiceRequest.NotifyTeamLead(intImplementorDistributed, intResource, intAssignPage, intViewPage, intEnvironment, "", dsnServiceEditor, dsnAsset, dsnIP, 0); } } } if (oForecast.GetPlatformMidrangeForecast(intDesign) == true) { if (intImplementorM > 0) { int intNextNumber = oResourceRequest.GetNumber(intRequest); int intResourceParent = oResourceRequest.Add(intRequest, -1, -1, intNextNumber, "Provisioning Task (Midrange)", 0, 6.00, 2, 1, 1, 1); int intResourceWorkflow = oResourceRequest.AddWorkflow(intResourceParent, 0, "Provisioning Task (Midrange)", intImplementorM, 0, 6.00, 2, 0); oOnDemandTasks.AddPending(intDesign, intResourceWorkflow); oResourceRequest.UpdateAssignedBy(intResourceParent, -999); } else { // Submit for assignment if (oServiceRequest.Get(intRequest, "requestid") == "") { oServiceRequest.Add(intRequest, 1, 1); } int intResource = oServiceRequest.AddRequest(intRequest, intImplementorMidrange, intImplementorMidrangeService, 0, 0.00, 2, 1, dsnServiceEditor); if (oServiceRequest.NotifyApproval(intResource, intResourceRequestApprove, intEnvironment, "", dsnServiceEditor) == false) { oServiceRequest.NotifyTeamLead(intImplementorMidrange, intResource, intAssignPage, intViewPage, intEnvironment, "", dsnServiceEditor, dsnAsset, dsnIP, 0); } } } } } } } oRequest.Update(intRequest, intProject); oDocument.Update(intRequest, intProject); oProjectPending.Approve(Int32.Parse(Request.QueryString["id"])); if (intProject == 0) { oServiceRequest.Update(intRequest, ds.Tables[0].Rows[0]["name"].ToString()); } Response.Redirect(Request.Path + "?rid=" + intRequest.ToString()); } else { if (Request.QueryString["reject"] != null) { panReject.Visible = true; } else { strProject = LoadProject(0, ds.Tables[0].Rows[0], intRequest, true); btnView.Attributes.Add("onclick", "return ShowServiceRequests('" + intRequest.ToString() + "');"); btnViewDesigns.Attributes.Add("onclick", "return ShowDesigns('" + intRequest.ToString() + "');"); if (Request.QueryString["c"] != null && Request.QueryString["c"] != "") { panCompare.Visible = true; string[] strProjects; char[] strSplit = { ' ' }; strProjects = Request.QueryString["c"].Split(strSplit); bool boolOther = false; for (int jj = 0; jj < strProjects.Length; jj++) { if (strProjects[jj].Trim() != "") { TableRow oRow = new TableRow(); TableCell oCell = new TableCell(); oCell.Text = strProject; oRow.Cells.Add(oCell); oCell = new TableCell(); HyperLink oCheck = new HyperLink(); oCheck.ImageUrl = "/images/bigCheck.gif"; oCheck.ToolTip = "Click to Assign"; oCheck.NavigateUrl = Request.Path + "?id=" + Request.QueryString["id"] + "&pid=" + strProjects[jj]; oCheck.Attributes.Add("onclick", "return confirm('Are you sure you want to assign this project?');"); oCell.Controls.Add(oCheck); oRow.Cells.Add(oCell); oCell = new TableCell(); oCell.Text = LoadProject(Int32.Parse(strProjects[jj]), null, 0, false); if (boolOther == true) { oRow.Attributes.Add("bgcolor", "#EFEFEF"); } boolOther = !boolOther; oRow.Cells.Add(oCell); tblCompare.Rows.Add(oRow); } } } else { panView.Visible = true; LoadList(); } } } } else { panAll.Visible = true; DataSet ds = oProjectPending.Gets(); rptView.DataSource = ds; rptView.DataBind(); } } btnCreateProject.Attributes.Add("onclick", "return confirm('Are you sure you want to create this PROJECT?');"); btnCreateTask.Attributes.Add("onclick", "return confirm('Are you sure you want to create this TASK?');"); btnCreateTask.Enabled = false; btnRejectConfirm.Attributes.Add("onclick", "return confirm('Are you sure you want to reject this project / task?');"); }
protected void Page_Load(object sender, EventArgs e) { intProfile = Int32.Parse(Request.Cookies["profileid"].Value); oAsset = new Asset(intProfile, dsnAsset); oForecast = new Forecast(intProfile, dsn); oWorkstation = new Workstations(intProfile, dsn); oServiceRequest = new ServiceRequests(intProfile, dsn); oOnDemandTasks = new OnDemandTasks(intProfile, dsn); //Menu int intMenuTab = 0; if (Request.QueryString["menu_tab"] != null && Request.QueryString["menu_tab"] != "") { intMenuTab = Int32.Parse(Request.QueryString["menu_tab"]); } Tab oTab = new Tab("", intMenuTab, "divMenu1", true, false); //End Menu 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); } int intForecast = 0; if (Request.QueryString["id"] != null && Request.QueryString["id"] != "") { intID = Int32.Parse(Request.QueryString["id"]); intForecast = Int32.Parse(oForecast.GetAnswer(intID, "forecastid")); intRequest = oForecast.GetRequestID(intID, true); DataSet dsRequest = oServiceRequest.Get(intRequest); if (dsRequest.Tables[0].Rows.Count > 0) { Response.Redirect(Request.Path + "?rid=" + intRequest); } } if (Request.QueryString["rid"] != null && Request.QueryString["rid"] != "") { intRequest = Int32.Parse(Request.QueryString["rid"]); } if (Request.QueryString["notify"] != null) { string strRedirect = Request.Url.PathAndQuery; strRedirect = strRedirect.Substring(0, strRedirect.IndexOf("¬ify")); if (Request.QueryString["notify"] == "true") { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">alert('Your design implementor has been successfully notified!');window.navigate('" + strRedirect + "');<" + "/" + "script>"); } else if (Request.QueryString["notify"] == "false") { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">alert('Your design implementor has ALREADY been notified!');window.navigate('" + strRedirect + "');<" + "/" + "script>"); } else { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">alert('There was a problem notifying your design implementor\\n\\nPlease contact your ClearView administrator\\n\\nRequestID: " + intRequest.ToString() + "');window.navigate('" + strRedirect + "');<" + "/" + "script>"); } } if (intID > 0) { panBegin.Visible = true; bool boolAssigned = false; if (oForecast.CanAutoProvision(intID) == true) { boolAssigned = true; } else if (oOnDemandTasks.GetPending(intID).Tables[0].Rows.Count > 0) { boolAssigned = true; } if (intForecast == 0) { btnStart.Attributes.Add("onclick", "return ProcessButton(this);"); } else if (boolAssigned == false) { btnStart.Attributes.Add("onclick", "alert('You cannot execute a design until a design implementor has been assigned.');return false;"); } else { lblNotify.Visible = true; //btnStart.Attributes.Add("onclick", "return confirm('NOTE: Billing will begin: " + DateTime.Today.ToShortDateString() + "\\n\\nAre you sure you want to continue?') && OpenWindow('AUTO_PROVISIONING','?answerid=" + intID.ToString() + "&modelid=" + oForecast.GetModel(intID).ToString() + "');"); btnStart.Attributes.Add("onclick", "return confirm('NOTE: Billing will begin: " + DateTime.Today.ToShortDateString() + "\\n\\nAre you sure you want to continue?');"); } } else if (intRequest > 0) { intRequest = Int32.Parse(Request.QueryString["rid"]); panStart.Visible = true; DataSet ds = oWorkstation.GetVirtualRequests(intRequest); int intCount = 0; Functions oFunction = new Functions(intProfile, dsn, intEnvironment); foreach (DataRow dr in ds.Tables[0].Rows) { intCount++; int intDevice = Int32.Parse(dr["id"].ToString()); int intAsset = Int32.Parse(dr["assetid"].ToString()); string strName = "Device " + intCount.ToString(); if (intAsset > 0) { string strTempName = oAsset.Get(intAsset, "name"); if (strTempName != "") { strName = strTempName; } } if (intCount == 1) { //strTab += "<td><img src=\"/images/TabOnLeftCap.gif\"></td><td nowrap background=\"/images/TabOnBackground.gif\"><a href=\"javascript:void(0);\" onclick=\"ChangeTab(this,'divTab" + intCount.ToString() + "',null,null,true);\" class=\"tabheader\">" + strName + "</a></td><td><img src=\"/images/TabOnRightCap.gif\"></td>"; oTab.AddTab(strName, ""); strDivs += "<div id=\"divTab" + intCount.ToString() + "\" style=\"display:inline\"><iframe width=\"100%\" height=\"100%\" frameborder=\"0\" scrolling=\"auto\" src=\"/ondemand/ondemand_workstation_virtual.aspx?id=" + oFunction.encryptQueryString(intDevice.ToString()) + "&c=" + intCount.ToString() + "\"></iframe></div>"; } else { // strTab += "<td><img src=\"/images/TabOffLeftCap.gif\"></td><td nowrap background=\"/images/TabOffBackground.gif\"><a href=\"javascript:void(0);\" onclick=\"ChangeTab(this,'divTab" + intCount.ToString() + "',null,null,true);\" class=\"tabheader\">" + strName + "</a></td><td><img src=\"/images/TabOffRightCap.gif\"></td>"; oTab.AddTab(strName, ""); strDivs += "<div id=\"divTab" + intCount.ToString() + "\" style=\"display:none\"><iframe width=\"100%\" height=\"100%\" frameborder=\"0\" scrolling=\"auto\" src=\"/ondemand/ondemand_workstation_virtual.aspx?id=" + oFunction.encryptQueryString(intDevice.ToString()) + "&c=" + intCount.ToString() + "\"></iframe></div>"; } } //if (strTab != "") // strMenuTab1 += "<tr>" + strTab + "<td width=\"100%\" background=\"/images/TabEmptyBackground.gif\"> </td></tr>"; //strMenuTab1 = "<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">" + strMenuTab1 + "</table>"; strMenuTab1 = oTab.GetTabs(); } }
protected void Page_Load(object sender, EventArgs e) { intProfile = Int32.Parse(Request.Cookies["profileid"].Value); oProjectRequest = new ProjectRequest(intProfile, dsn); oResourceRequest = new ResourceRequest(intProfile, dsn); oProjectNumber = new ProjectNumber(intProfile, dsn); oPage = new Pages(intProfile, dsn); oUser = new Users(intProfile, dsn); oRequestItem = new RequestItems(intProfile, dsn); oApplication = new Applications(intProfile, dsn); oRequest = new Requests(intProfile, dsn); oVariable = new Variables(intEnvironment); oService = new Services(intProfile, dsn); oDelegate = new Delegates(intProfile, dsn); oStatusLevel = new StatusLevels(); oEnhancement = new Enhancements(intProfile, dsn); oLog = new Log(intProfile, dsn); oFunction = new Functions(intProfile, dsn, intEnvironment); if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "") { intPage = Int32.Parse(Request.QueryString["pageid"]); } if (Request.QueryString["action"] != null && Request.QueryString["action"] != "") { panFinish.Visible = true; } else { 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 (!IsPostBack) { if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "") { lblResourceParent.Text = Request.QueryString["rrid"]; int intResourceParent = Int32.Parse(lblResourceParent.Text); 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 intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString()); int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString()); Forecast oForecast = new Forecast(intProfile, dsn); if (intService == intStorageService) { try { OnDemandTasks oOnDemandTask = new OnDemandTasks(0, dsn); Locations oLocation = new Locations(0, dsn); DataSet dsDesign = oOnDemandTask.GetServerStorage(intRequest, intItem, intNumber); if (dsDesign.Tables[0].Rows.Count == 1) { int intAnswer = Int32.Parse(dsDesign.Tables[0].Rows[0]["answerid"].ToString()); int intAddress = Int32.Parse(oForecast.GetAnswer(intAnswer, "addressid")); lblLocation.Text = oLocation.GetFull(intAddress); panLocation.Visible = true; } } catch { } } int intProject = Int32.Parse(oRequest.Get(intRequest, "projectid")); int intApp = oRequestItem.GetItemApplication(intItem); int intForecast = 0; DataSet dsForecast = oForecast.GetProject(intProject); if (dsForecast.Tables[0].Rows.Count > 0) { intForecast = Int32.Parse(dsForecast.Tables[0].Rows[0]["id"].ToString()); } if (intForecast > 0) { btnView.Attributes.Add("oncontextmenu", "return OpenWindow('NEW_WINDOW','" + oPage.GetFullLink(intDesignBuilder) + "?id=" + intForecast.ToString() + "');"); } else { btnView.Attributes.Add("oncontextmenu", "alert('There is no design for this project');return false;"); } 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 = "Click here to view the project details"; lblType.Text = "Project Request"; } else { btnView.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intViewResourceRequest.ToString() + "&rrid=" + intResourceParent.ToString() + "');"); if (oApplication.Get(intApp, "tpm") == "1") { btnView.Text = "Click here to view the project details"; } else { btnView.Text = "Click here to view this request"; } lblType.Text = "Service Request"; } btnAssignments.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intSearchPage.ToString() + "&pid=" + intProject + "&aid=" + intApp.ToString() + "&sort=userid');"); //btnAssignments.Attributes.Add("onclick", "return OpenNewWindowMenu('/datapoint/projects/datapoint_projects.aspx?id=" + oFunction.encryptQueryString(intProject.ToString()) + "', '800', '600');"); lblItem.Text = intItem.ToString(); lblService.Text = oService.GetName(intService); if (oApplication.Get(intApp, "request_items") == "1") { lblGroup.Text = oApplication.GetName(intApp) + " | " + oRequestItem.GetItemName(intItem); } else { lblGroup.Text = oApplication.GetName(intApp); } int intUser = Int32.Parse(oRequest.Get(intRequest, "userid")); int intAppManager = oApplication.GetManager(intApp); if (ds.Tables[0].Rows[0]["accepted"].ToString() == "-1" && oApplication.Get(intApp, "tpm") == "1") { if (intUser == intProfile || oDelegate.Get(intUser, intProfile) > 0) { panRequest.Visible = true; panAssignSingle.Visible = true; txtHours.Text = double.Parse(ds.Tables[0].Rows[0]["allocated"].ToString()).ToString("F"); panHours.Visible = !(oApplication.Get(intApp, "tpm") == "1"); txtHours.Enabled = (oService.Get(intService, "disable_hours") == "1" ? false : true); lblQuantity.Text = ds.Tables[0].Rows[0]["devices"].ToString(); lblStatus.Text = oStatusLevel.HTML(Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString())); panQuantity.Visible = (lblQuantity.Text != "0"); txtQuantity.Text = lblQuantity.Text; txtQuantity.Enabled = (txtQuantity.Text != "0"); txtQuantity.Enabled = false; lblAssign.Text = oUser.GetFullName(intProfile); strSummary = oResourceRequest.GetBodyOverallFix(intResourceParent, 0, intEnvironment, false); } else { Response.Write("no rights"); panDenied.Visible = true; } btnSubmit.Attributes.Add("onclick", "return ValidateNumber0('" + txtHours.ClientID + "','Please enter a valid number for the hours allocated') && ValidateHidden('" + hdnManager.ClientID + "','" + txtManager.ClientID + "','Please enter a valid LAN ID') && ProcessButton(this);"); } else { string strValidate = ""; if (oUser.IsAdmin(intProfile) || oService.IsManager(intService, intProfile) || (oApplication.IsManager(intApp, intProfile) && oApplication.Get(intApp, "disable_manager") != "1")) { panRequest.Visible = true; panAssignMultiple.Visible = true; btnSubmit.Enabled = (ds.Tables[0].Rows[0]["assigned"].ToString() == ""); if (ds.Tables[0].Rows[0]["status"].ToString() == "5") { radHold.Checked = true; divChoice.Style["display"] = "inline"; divHold.Style["display"] = "inline"; txtHold.Text = ds.Tables[0].Rows[0]["reason"].ToString(); } else { divChoice.Style["display"] = (ds.Tables[0].Rows[0]["accepted"].ToString() == "0" ? "inline" : "none"); divAccept.Style["display"] = (ds.Tables[0].Rows[0]["accepted"].ToString() == "1" ? "inline" : "none"); } int intEnhancementService = 0; Int32.TryParse(ConfigurationManager.AppSettings["HELP_ENHANCEMENT_SERVICEID"], out intEnhancementService); if (intService == intEnhancementService) { panEnhancement.Visible = true; ddlModule.DataTextField = "name"; ddlModule.DataValueField = "id"; ddlModule.DataSource = oEnhancement.GetModules(1); ddlModule.DataBind(); ddlModule.Items.Insert(0, new ListItem("-- SELECT --", "0")); strValidate += "ValidateDropDown('" + ddlModule.ClientID + "','Select a classification') && "; radEnhancementShort.Checked = true; radEnhancementReject.Attributes.Add("onclick", "ShowHideDiv('" + trEnhancementReject.ClientID + "','inline');ShowHideDiv('" + trEnhancementClassification.ClientID + "','none');ShowHideDiv('" + divAccept.ClientID + "','none');"); radEnhancementDuplicate.Attributes.Add("onclick", "ShowHideDiv('" + trEnhancementReject.ClientID + "','inline');ShowHideDiv('" + trEnhancementClassification.ClientID + "','none');ShowHideDiv('" + divAccept.ClientID + "','none');"); radEnhancementShort.Attributes.Add("onclick", "ShowHideDiv('" + trEnhancementReject.ClientID + "','none');ShowHideDiv('" + trEnhancementClassification.ClientID + "','inline');ShowHideDiv('" + divAccept.ClientID + "','inline');"); radEnhancementLong.Attributes.Add("onclick", "ShowHideDiv('" + trEnhancementReject.ClientID + "','inline');ShowHideDiv('" + trEnhancementClassification.ClientID + "','inline');ShowHideDiv('" + divAccept.ClientID + "','inline');"); } panDelete.Visible = (intItem == intImplementorDistributed || intItem == intImplementorMidrange); btnDelete.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this request');"); txtHours.Text = double.Parse(ds.Tables[0].Rows[0]["allocated"].ToString()).ToString("F"); panHours.Visible = !(oApplication.Get(intApp, "tpm") == "1"); txtHours.Enabled = (oService.Get(intService, "disable_hours") == "1" ? false : true); lblQuantity.Text = ds.Tables[0].Rows[0]["devices"].ToString(); panQuantity.Visible = (lblQuantity.Text != "0"); txtQuantity.Text = lblQuantity.Text; txtQuantity.Enabled = (txtQuantity.Text != "0"); txtQuantity.Enabled = false; lblStatus.Text = oStatusLevel.HTML(Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString())); trAssigned.Visible = !(btnSubmit.Enabled); string strAssign = ""; DataSet dsManager = oService.GetUser(intService, 1); foreach (DataRow drManager in dsManager.Tables[0].Rows) { if (strAssign != "") { strAssign += ", "; } strAssign += oUser.GetFullName(Int32.Parse(drManager["userid"].ToString())); } lblAssign.Text = strAssign; DataSet dsReports = oUser.GetManagerReports(intAppManager, intRequest, intService, intNumber); DataTable dtReports = dsReports.Tables[0].Copy(); dtReports.Clear(); DataSet dsAssignment = oService.GetUser(intService, -100); foreach (DataRow drAssignment in dsAssignment.Tables[0].Rows) { int intAssignment = Int32.Parse(drAssignment["userid"].ToString()); DataSet dsAssignees = oUser.GetManagerReports(intAssignment, intRequest, intService, intNumber); foreach (DataRow drAssignee in dsAssignees.Tables[0].Rows) { dtReports.ImportRow(drAssignee); } } if (dtReports.Rows.Count > 0) { // Use custom assignment list // First, remove duplicates Hashtable hTable = new Hashtable(); ArrayList duplicateList = new ArrayList(); foreach (DataRow drow in dtReports.Rows) { if (hTable.Contains(drow["userid"])) { duplicateList.Add(drow); } else { hTable.Add(drow["userid"], string.Empty); } } foreach (DataRow dRow in duplicateList) { dtReports.Rows.Remove(dRow); } // Next, sort by username dtReports.DefaultView.Sort = "username"; // Now add to dataset dsReports = new DataSet(); dsReports.Tables.Add(dtReports.DefaultView.ToTable()); } LoadList(dsReports, intApp); LoadAvailable(dsReports, intApp); strSummary = oResourceRequest.GetBodyOverallFix(intResourceParent, 0, intEnvironment, false); } else { Response.Write("no delegate"); panDenied.Visible = true; } btnSubmit.Attributes.Add("onclick", "return " + strValidate + "ValidateChoice('" + divChoice.ClientID + "','" + radAccept.ClientID + "','" + radReject.ClientID + "','" + radHold.ClientID + "','" + ddlUser.ClientID + "','" + txtHours.ClientID + "') && ProcessButton(this);"); } } else { panDenied.Visible = true; } } else { panDenied.Visible = true; } } } btnClose.Attributes.Add("onclick", "return CloseWindow();"); lnkAvailable.Attributes.Add("onclick", "return ShowHideAvailable('" + divAvailable.ClientID + "');"); radAccept.Attributes.Add("onclick", "ShowHideDiv('" + divAccept.ClientID + "','inline');ShowHideDiv('" + divReject.ClientID + "','none');ShowHideDiv('" + divHold.ClientID + "','none');"); radReject.Attributes.Add("onclick", "ShowHideDiv('" + divReject.ClientID + "','inline');ShowHideDiv('" + divAccept.ClientID + "','none');ShowHideDiv('" + divHold.ClientID + "','none');"); radHold.Attributes.Add("onclick", "ShowHideDiv('" + divHold.ClientID + "','inline');ShowHideDiv('" + divAccept.ClientID + "','none');ShowHideDiv('" + divReject.ClientID + "','none');"); txtManager.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'300','195','" + divManager.ClientID + "','" + lstManager.ClientID + "','" + hdnManager.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);"); lstManager.Attributes.Add("ondblclick", "AJAXClickRow();"); }
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; } }
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(); } }
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 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) { 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) { Page.Title = "ClearView Auto-Provisioning"; intProfile = Int32.Parse(Request.Cookies["profileid"].Value); oAsset = new Asset(intProfile, dsnAsset); oForecast = new Forecast(intProfile, dsn); oServer = new Servers(intProfile, dsn); oServerName = new ServerName(intProfile, dsn); oServiceRequest = new ServiceRequests(intProfile, dsn); oModelsProperties = new ModelsProperties(intProfile, dsn); oModel = new Models(intProfile, dsn); oRequest = new Requests(intProfile, dsn); oClass = new Classes(intProfile, dsn); oUser = new Users(intProfile, dsn); oFunction = new Functions(intProfile, dsn, intEnvironment); oOnDemandTasks = new OnDemandTasks(intProfile, dsn); oResourceRequest = new ResourceRequest(intProfile, dsn); oProject = new Projects(intProfile, dsn); oSetting = new Settings(intProfile, dsn); //Menu int intMenuTab = 0; if (Request.QueryString["menu_tab"] != null && Request.QueryString["menu_tab"] != "") { intMenuTab = Int32.Parse(Request.QueryString["menu_tab"]); } Tab oTab = new Tab("", intMenuTab, "divMenu1", true, true); //End Menu 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["id"] != null && Request.QueryString["id"] != "") { intID = Int32.Parse(Request.QueryString["id"]); intRequest = oForecast.GetRequestID(intID, true); DataSet dsRequest = oServiceRequest.Get(intRequest); if (dsRequest.Tables[0].Rows.Count > 0) { Response.Redirect(Request.Path + "?rid=" + intRequest); } } if (Request.QueryString["rid"] != null && Request.QueryString["rid"] != "") { intRequest = Int32.Parse(Request.QueryString["rid"]); } if (Request.QueryString["notify"] != null) { string strRedirect = Request.Url.PathAndQuery; strRedirect = strRedirect.Substring(0, strRedirect.IndexOf("¬ify")); if (Request.QueryString["notify"] == "none") { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">window.navigate('" + strRedirect + "');<" + "/" + "script>"); } else if (Request.QueryString["notify"] == "true") { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">alert('Your design implementor has been successfully notified!');window.navigate('" + strRedirect + "');<" + "/" + "script>"); } else if (Request.QueryString["notify"] == "false") { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">alert('Your design implementor has ALREADY been notified!');window.navigate('" + strRedirect + "');<" + "/" + "script>"); } else { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">alert('There was a problem notifying your design implementor\\n\\nPlease contact your ClearView administrator\\n\\nRequestID: " + intRequest.ToString() + "');window.navigate('" + strRedirect + "');<" + "/" + "script>"); } } if (intID > 0) { Page.Title = "ClearView Auto-Provisioning | Design # " + intID.ToString(); btnPrint.Attributes.Add("onclick", "return OpenWindow('DESIGN_PRINT', '?id=" + intID.ToString() + "');"); bool boolApproveNeeded = false; bool boolApproved = false; bool boolPending = false; bool boolDenied = false; Tab oTabServer = new Tab("", 0, "divMenuApprove", true, false); DataSet dsServers = oServer.GetAnswer(intID); int intServerCount = 0; foreach (DataRow drServer in dsServers.Tables[0].Rows) { int intServer = Int32.Parse(drServer["id"].ToString()); intServerCount++; DataSet dsApprove = oServerName.GetComponentDetailUserApprovalsByServer(intServer); if (dsApprove.Tables[0].Rows.Count > 0) { boolApproveNeeded = true; oTabServer.AddTab("Device # " + intServerCount.ToString(), ""); string strApproveItem = ""; bool boolOther = true; foreach (DataRow drApprove in dsApprove.Tables[0].Rows) { boolOther = (boolOther == false); int intDetail = Int32.Parse(drApprove["detailid"].ToString()); int intApprover = 0; string strApproverComments = ""; int intApproverApproved = -1; DateTime datApproved = DateTime.Now; DataSet dsApprovals = oServerName.GetComponentDetailUserApprovals(intServer, intDetail); if (dsApprovals.Tables[0].Rows.Count == 0) { boolPending = true; } else { intApprover = Int32.Parse(dsApprovals.Tables[0].Rows[0]["userid"].ToString()); strApproverComments = dsApprovals.Tables[0].Rows[0]["comments"].ToString(); intApproverApproved = Int32.Parse(dsApprovals.Tables[0].Rows[0]["approved"].ToString()); datApproved = DateTime.Parse(dsApprovals.Tables[0].Rows[0]["modified"].ToString()); if (intApproverApproved == 0) { boolDenied = true; } } string strApprovers = ""; DataSet dsApprovers = oServerName.GetComponentDetailUsers(intDetail, 1); foreach (DataRow drApprover in dsApprovers.Tables[0].Rows) { int intUser = Int32.Parse(drApprover["userid"].ToString()); strApprovers += "<tr><td><a href=\"javascript:void(0);\" onclick=\"OpenWindow('PROFILE','?userid=" + intUser.ToString() + "');\"><img src=\"/images/" + (intApprover == 0 ? "pending" : (intUser == intApprover ? (intApproverApproved == 1 ? "check" : "cancel") : "user")) + ".gif\" border=\"0\" align=\"absmiddle\"/> " + oUser.GetFullName(intUser) + " (" + oUser.GetName(intUser) + ")</a></td></tr>"; } strApprovers = "<table>" + strApprovers + "</table>"; strApproveItem += "<tr" + (boolOther ? " bgcolor=\"#F6F6F6\"" : "") + ">"; string strLabel = drApprove["name"].ToString(); if (intApproverApproved > -1) { strLabel = "<a href=\"javascript:void(0);\" onclick=\"ShowHideDiv2('trApproval" + intServerCount.ToString() + "_" + intDetail.ToString() + "');\">" + strLabel + "</a>"; } strApproveItem += "<td valign=\"top\" width=\"45%\" class=\"biggerbold\">" + strLabel + "</td>"; strApproveItem += "<td valign=\"top\" width=\"10%\">" + (intApproverApproved == -1 ? "Pending" : (intApproverApproved == 0 ? "Denied" : "Approved")) + "</td>"; strApproveItem += "<td valign=\"top\" width=\"45%\" align=\"right\">" + strApprovers + "</td>"; strApproveItem += "</tr>"; if (intApproverApproved > -1) { string strApproveTable = "<tr><td colspan=\"2\"><span style=\"width:100%;border-bottom:1 dotted #CCCCCC;\"/></td></tr>"; strApproveTable += "<tr>"; strApproveTable += "<td nowrap valign=\"top\"><img src=\"/images/" + (intApproverApproved == 0 ? "cancel" : "check") + ".gif\" border=\"0\" align=\"absmiddle\"/></td>"; strApproveTable += "<td width=\"100%\" valign=\"top\">" + oUser.GetFullName(intApprover) + " " + (intApproverApproved == 0 ? "DENIED" : "APPROVED") + " this request on " + datApproved.ToString() + "</td>"; strApproveTable += "</tr>"; if (strApproverComments != "") { strApproveTable += "<tr>"; strApproveTable += "<td colspan=\"2\">The following comments were added...</td>"; strApproveTable += "</tr>"; strApproveTable += "<tr>"; strApproveTable += "<td nowrap valign=\"top\"><img src=\"/images/comment.gif\" border=\"0\" align=\"absmiddle\"/></td>"; strApproveTable += "<td width=\"100%\" valign=\"top\" class=\"comment\">" + strApproverComments + "</td>"; strApproveTable += "</tr>"; } strApproveTable = "<table width=\"100%\" cellpadding=\"4\" cellspacing=\"3\" border=\"0\">" + strApproveTable + "</table>"; strApproveItem += "<tr id=\"trApproval" + intServerCount.ToString() + "_" + intDetail.ToString() + "\" style=\"display:none\"" + (boolOther ? " bgcolor=\"#F6F6F6\"" : "") + "><td colspan=\"3\">" + strApproveTable + "</td></tr>"; } } strApproveItem = "<tr bgcolor=\"#EEEEEE\"><td class=\"header\">Component</td><td class=\"header\">Status</td><td class=\"header\" align=\"right\">Approver(s)</td></tr>" + strApproveItem; strApproveItem = "<table width=\"100%\" cellpadding=\"4\" cellspacing=\"0\" border=\"0\" style=\"border:solid 1px #CCCCCC\">" + strApproveItem + "</table>"; strApprove += "<div id=\"divTab" + intServerCount.ToString() + "\" style=\"display:none\">" + strApproveItem + "</div>"; } } if (boolApproveNeeded == true) { trApprove.Visible = true; if (boolDenied == true) { btnSoftwareBack.Visible = true; imgApproved.ImageUrl = "/images/ico_error.gif"; lblApprovedHeader.Text = "Software Component(s) Denied"; lblApproved.Text = "One or more of the software components you requested have been denied. You cannot continue until all components have been approved.<br/>You will need to make changes to this design - please click <b>Make Changes</b> to change your software component requirements.<br/>All questions and status inquiries should be sent to the approver(s) listed below."; } else if (boolPending == true) { imgApproved.ImageUrl = "/images/ico_hourglass.gif"; lblApprovedHeader.Text = "Software Component(s) Pending"; lblApproved.Text = "One or more of the software components you requested are awaiting approval. You cannot continue until all components have been approved.<br/>All questions and status inquiries should be sent to the approver(s) listed below."; } else { boolApproved = true; lblApprovedHeader.Text = "Software Component(s) Approved"; lblApproved.Text = "All of the software components you requested have been approved!"; } btnApproved.Attributes.Add("onclick", "ShowHideDiv2('" + trApprove.ClientID + "');return false;"); strMenuTabApprove = oTabServer.GetTabs(); } else { boolApproved = true; lblApprovedHeader.Text = "No Approval Required"; lblApproved.Text = "There are no approvals required for your software components"; btnApproved.Enabled = false; } string strSchedule = oForecast.GetAnswer(intID, "execution"); if (strSchedule != "") { DateTime datSchedule = DateTime.Parse(strSchedule); txtScheduleDate.Text = datSchedule.ToShortDateString(); txtScheduleTime.Text = datSchedule.ToShortTimeString(); btnSchedule.Text = "Update the Build"; } panBegin.Visible = true; bool boolAssigned = false; int intModel = oForecast.GetModelAsset(intID); if (intModel == 0) { intModel = oForecast.GetModel(intID); } string strChange = "true"; string strFreeze = ""; // Check Freeze Dates bool boolFreeze = false; strFreezeStart = oSetting.Get("freeze_start"); strFreezeEnd = oSetting.Get("freeze_end"); if (strFreezeStart != "" && strFreezeEnd != "" && DateTime.Parse(strFreezeStart) <= DateTime.Now && DateTime.Parse(strFreezeEnd) > DateTime.Now) { boolFreeze = true; divChange.Style["display"] = "inline"; if (!IsPostBack) { txtChange.Text = oForecast.GetAnswer(intID, "change"); } strChange = "ValidateTextLength('" + txtChange.ClientID + "', 'Please enter a valid change control number\\n\\n - Must start with \"CHG\" or \"PTM\"\\n - Must be exactly 10 characters in length', 10, 'CHG', 'PTM')"; } int intClass = Int32.Parse(oForecast.GetAnswer(intID, "classid")); int intForecast = 0; Int32.TryParse(oForecast.GetAnswer(intID, "forecastid"), out intForecast); int intRequestID = 0; Int32.TryParse(oForecast.Get(intForecast, "requestid"), out intRequestID); int intProject = 0; if (intRequestID > 0) { intProject = oRequest.GetProjectNumber(intRequestID); } int intProjectStatus = 0; if (intProject > 0) { Int32.TryParse(oProject.Get(intProject, "status"), out intProjectStatus); } if (oForecast.CanAutoProvision(intID) == true) { boolAssigned = true; } else { if (oOnDemandTasks.GetPending(intID).Tables[0].Rows.Count > 0) { boolAssigned = true; } else { // Add Resource Request int intImplementor = 0; string strType = "Distributed"; DataSet dsResource = oResourceRequest.GetProjectItem(intProject, intImplementorDistributed); if (oForecast.GetPlatformDistributed(intID, intWorkstationPlatform) == false) { dsResource = oResourceRequest.GetProjectItem(intProject, intImplementorMidrange); strType = "Midrange"; } if (dsResource.Tables[0].Rows.Count > 0) { intImplementor = (dsResource.Tables[0].Rows[0]["userid"].ToString() == "" ? 0 : Int32.Parse(dsResource.Tables[0].Rows[0]["userid"].ToString())); } if (intImplementor > 0) { int intNextNumber = oResourceRequest.GetNumber(intRequestID); int intResourceParent = oResourceRequest.Add(intRequestID, -1, -1, intNextNumber, "Provisioning Task (" + strType + ")", 0, 6.00, 2, 1, 1, 1); int intResourceWorkflow = oResourceRequest.AddWorkflow(intResourceParent, 0, "Provisioning Task (" + strType + ")", intImplementor, 0, 6.00, 2, 0); oOnDemandTasks.AddPending(intID, intResourceWorkflow); oResourceRequest.UpdateAssignedBy(intResourceParent, -999); } } } lblNotify.Visible = boolBurnIn; bool boolOKtoExecute = false; if (intProject == -100) { // Pending project approval btnStart.Attributes.Add("onclick", "alert('This design cannot be executed because the associated project is currently pending approval.\\n\\nMost likely, this is because you just entered a new project into the system\\n\\nPlease contact your ClearView administrator or check back later.');return false;"); btnSchedule.Attributes.Add("onclick", "alert('This design cannot be scheduled because the associated project is currently pending approval.\\n\\nMost likely, this is because you just entered a new project into the system\\n\\nPlease contact your ClearView administrator or check back later.');return false;"); } else { if (oForecast.CanAutoProvision(intID) == true) { btnSchedule.Enabled = true; boolOKtoExecute = true; } else { if (boolAssigned == false) { btnStart.Attributes.Add("onclick", "alert('You cannot execute a design until a design implementor has been assigned.');return false;"); btnSchedule.Attributes.Add("onclick", "alert('You cannot schedule the execution of a design until a design implementor has been assigned.');return false;"); } else { boolOKtoExecute = true; } } } imgScheduleDate.Attributes.Add("onclick", "return ShowCalendar('" + txtScheduleDate.ClientID + "');"); if (boolOKtoExecute == true) { btnStart.Attributes.Add("onclick", "return " + strChange + " && confirm('NOTE: Billing will begin: " + DateTime.Today.ToShortDateString() + "\\n\\nAre you sure you want to continue?');"); btnSchedule.Attributes.Add("onclick", "return ValidateDate('" + txtScheduleDate.ClientID + "','Please enter a valid schedule date')" + " && ValidateDateToday('" + txtScheduleDate.ClientID + "','The scheduled date must occur after today')" + " && ValidateFreeze('" + txtScheduleDate.ClientID + "','" + divChange.ClientID + "','" + txtChange.ClientID + "'," + (boolFreeze ? "true" : "false") + ")" + " && ValidateTime('" + txtScheduleTime.ClientID + "','Please enter a valid start time')" + " && confirm('NOTE: Billing will begin: ' + document.getElementById('" + txtScheduleDate.ClientID + "').value + '\\n\\nAre you sure you want to continue?')" + " && ProcessButton(this)" + ";"); } if (oModelsProperties.IsInventory(intModel) == true) { panInventoryYes.Visible = true; if (boolApproved == false) { divSoftware.Style["display"] = "inline"; divDefault.Style["display"] = "none"; radStart.Enabled = false; btnStart.Enabled = false; radSchedule.Enabled = false; btnSchedule.Enabled = false; radApproval.Enabled = false; btnApprovals.Enabled = false; } } else { lblInventory.Text = oModelsProperties.Get(intModel, "name"); panInventoryNo.Visible = true; divSoftware.Style["display"] = "none"; divDefault.Style["display"] = "none"; radStart.Enabled = false; btnStart.Enabled = false; radSchedule.Enabled = false; btnSchedule.Enabled = false; radApproval.Enabled = false; btnApprovals.Enabled = false; } } else if (intRequest > 0) { intRequest = Int32.Parse(Request.QueryString["rid"]); DateTime datSchedule = DateTime.Now; DataSet ds = oServer.GetRequests(intRequest, 1); bool boolPending = false; int intAnswer = 0; int intModel = 0; if (ds.Tables[0].Rows.Count > 0) { intAnswer = Int32.Parse(ds.Tables[0].Rows[0]["answerid"].ToString()); intModel = oForecast.GetModelAsset(intAnswer); if (intModel == 0) { intModel = oForecast.GetModel(intAnswer); } string strSchedule = oForecast.GetAnswer(intAnswer, "execution"); if (strSchedule != "") { datSchedule = DateTime.Parse(strSchedule); lblScheduleDate.Text = datSchedule.ToShortDateString(); lblScheduleTime.Text = datSchedule.ToShortTimeString(); if (DateTime.Now < datSchedule) { boolPending = true; } } } Page.Title = "ClearView Auto-Provisioning | Design # " + intAnswer.ToString(); if (oForecast.CanAutoProvision(intAnswer) == false) { panNotExecutable.Visible = true; lblInitiated.Text = oForecast.GetAnswer(intAnswer, "executed"); lblCompleted.Text = oForecast.GetAnswer(intAnswer, "completed"); int intImplementorUser = 0; DataSet dsImplementor = oOnDemandTasks.GetPending(intAnswer); if (dsImplementor.Tables[0].Rows.Count > 0) { intImplementorUser = Int32.Parse(dsImplementor.Tables[0].Rows[0]["resourceid"].ToString()); intImplementorUser = Int32.Parse(oResourceRequest.GetWorkflow(intImplementorUser, "userid")); } strManualImage = "<img src=\"/frame/picture.aspx?xid=" + oUser.GetName(intImplementorUser) + "\" border=\"0\" align=\"absmiddle\" style=\"height:90px;width:90px;border-width:0px;border:solid 1px #999999;\" />"; lblImplementor.Text = oUser.GetFullName(intImplementorUser) + " (" + oUser.GetName(intImplementorUser) + ")"; strManualReason = oForecast.CanAutoProvisionReason(intAnswer); btnManual.NavigateUrl = "/datapoint/service/design.aspx?t=design&q=" + oFunction.encryptQueryString(intAnswer.ToString()); rptServers.DataSource = oServer.GetManual(intAnswer, false); rptServers.DataBind(); foreach (RepeaterItem ri in rptServers.Items) { Label lblName = (Label)ri.FindControl("lblName"); if (lblName.Text != "--- Pending ---") { lblName.Text = "<a href=\"javascript:void(0);\" onclick=\"OpenNewWindow('/datapoint/asset/datapoint_asset_search.aspx?t=name&q=" + oFunction.encryptQueryString(lblName.Text) + "&id=" + oFunction.encryptQueryString(lblName.ToolTip) + "',800,600);\">" + lblName.Text + "</a>"; } else { lblName.Text = "<i>" + lblName.Text + "</i>"; } Label lblAsset = (Label)ri.FindControl("lblAsset"); if (lblAsset.Text != "--- Pending ---") { lblAsset.Text = "<a href=\"javascript:void(0);\" onclick=\"OpenNewWindow('/datapoint/asset/datapoint_asset_search.aspx?t=serial&q=" + oFunction.encryptQueryString(lblAsset.Text) + "',800,600);\">" + lblAsset.Text + "</a>"; } else { lblAsset.Text = "<i>" + lblAsset.Text + "</i>"; } Label lblAssetDR = (Label)ri.FindControl("lblAssetDR"); if (lblAssetDR.Text != "--- None ---") { if (lblAssetDR.Text != "--- Pending ---") { if (lblAssetDR.Text != "Missing!!!") { lblAssetDR.Text = "<a href=\"javascript:void(0);\" onclick=\"OpenNewWindow('/datapoint/asset/datapoint_asset_search.aspx?t=serial&q=" + oFunction.encryptQueryString(lblAssetDR.Text) + "',800,600);\">" + lblAssetDR.Text + "</a>"; } else { lblAssetDR.Text = "<span class=\"highlight\">" + lblAssetDR.Text + "</span>"; } } else { lblAssetDR.Text = "<i>" + lblAssetDR.Text + "</i>"; } } else { lblAssetDR.Text = "<i>Not Required</i>"; } Label lblIP1 = (Label)ri.FindControl("lblIP1"); if (lblIP1.Text == "--- Pending ---") { lblIP1.Text = "<i>" + lblIP1.Text + "</i>"; } Label lblIP2 = (Label)ri.FindControl("lblIP2"); if (lblIP2.Text == "--- Pending ---") { lblIP2.Text = "<i>" + lblIP2.Text + "</i>"; } Label lblIP3 = (Label)ri.FindControl("lblIP3"); if (lblIP3.Text == "--- Pending ---") { lblIP3.Text = "<i>" + lblIP3.Text + "</i>"; } } } else { if (boolPending == true) { panPending.Visible = true; TimeSpan oSpan = datSchedule.Subtract(DateTime.Now); if (oSpan.Seconds > 0) { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "cdown", "<script type=\"text/javascript\">StartClockCountdown('" + lblCountdown.ClientID + "'," + oSpan.TotalMilliseconds.ToString() + ");<" + "/" + "script>"); } else { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "cdown", "<script type=\"text/javascript\">StartClockCountdown('" + lblCountdown.ClientID + "',0);<" + "/" + "script>"); } } else { panStart.Visible = true; int intCount = 0; Types oType = new Types(intProfile, dsn); foreach (DataRow dr in ds.Tables[0].Rows) { intCount++; int intServer = Int32.Parse(dr["id"].ToString()); int intAsset = 0; if (dr["assetid"].ToString() != "") { intAsset = Int32.Parse(dr["assetid"].ToString()); } int intType = 0; intModel = 0; if (dr["modelid"].ToString() != "") { intModel = Int32.Parse(dr["modelid"].ToString()); } if (intModel > 0) { intType = oModelsProperties.GetType(intModel); } string strName = "Device " + intCount.ToString(); if (intAsset > 0) { string strTempName = oAsset.Get(intAsset, "name"); if (strTempName != "") { strName = strTempName; } } if (intCount == 1) { //strTab += "<td><img src=\"/images/TabOnLeftCap.gif\"></td><td nowrap background=\"/images/TabOnBackground.gif\"><a href=\"javascript:void(0);\" onclick=\"ChangeTab(this,'divTab" + intCount.ToString() + "',null,null,true);\" class=\"tabheader\">" + strName + "</a></td><td><img src=\"/images/TabOnRightCap.gif\"></td>"; oTab.AddTab(strName, ""); strDivs += "<div id=\"divTab" + intCount.ToString() + "\" style=\"display:inline\"><iframe width=\"100%\" height=\"100%\" frameborder=\"0\" scrolling=\"auto\" src=\"" + oType.Get(intType, "ondemand_steps_path") + "?id=" + oFunction.encryptQueryString(intServer.ToString()) + "&c=" + intCount.ToString() + "\"></iframe></div>"; } else { // strTab += "<td><img src=\"/images/TabOffLeftCap.gif\"></td><td nowrap background=\"/images/TabOffBackground.gif\"><a href=\"javascript:void(0);\" onclick=\"ChangeTab(this,'divTab" + intCount.ToString() + "',null,null,true);\" class=\"tabheader\">" + strName + "</a></td><td><img src=\"/images/TabOffRightCap.gif\"></td>"; oTab.AddTab(strName, ""); strDivs += "<div id=\"divTab" + intCount.ToString() + "\" style=\"display:none\"><iframe width=\"100%\" height=\"100%\" frameborder=\"0\" scrolling=\"auto\" src=\"" + oType.Get(intType, "ondemand_steps_path") + "?id=" + oFunction.encryptQueryString(intServer.ToString()) + "&c=" + intCount.ToString() + "\"></iframe></div>"; } } strMenuTab1 = oTab.GetTabs(); //if (strTab != "") // strMenuTab1 += "<tr>" + strTab + "<td width=\"100%\" background=\"/images/TabEmptyBackground.gif\"> </td></tr>"; //strMenuTab1 = "<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">" + strMenuTab1 + "</table>"; } } } radStart.Attributes.Add("onclick", "ShowBuildDivs('" + divStart.ClientID + "','" + divDefault.ClientID + "','" + divSchedule.ClientID + "','" + divApproval.ClientID + "');"); radSchedule.Attributes.Add("onclick", "ShowBuildDivs('" + divSchedule.ClientID + "','" + divDefault.ClientID + "','" + divStart.ClientID + "','" + divApproval.ClientID + "');"); radApproval.Attributes.Add("onclick", "ShowBuildDivs('" + divApproval.ClientID + "','" + divDefault.ClientID + "','" + divStart.ClientID + "','" + divSchedule.ClientID + "');"); btnApprovals.Attributes.Add("onclick", "return OpenWindow('DESIGN_APPROVERS','?id=" + intID.ToString() + "');"); }
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); oForecast = new Forecast(intProfile, dsn); oVariable = new Variables(intEnvironment); oLTM = new LTM(intProfile, dsn); oServer = new Servers(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(); 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 (!IsPostBack) { 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>"); } 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; } bool boolSLABreached = false; if (oService.Get(intService, "sla") != "") { oFunction.ConfigureToolButton(btnSLA, "/images/tool_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; } oFunction.ConfigureToolButton(btnEmail, "/images/tool_email"); btnEmail.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST_EMAIL','?rrid=" + intResourceWorkflow.ToString() + "&type=GENERIC');"); dblUsed = (dblUsed / dblAllocated) * 100; LoadLTM(); btnComplete.ImageUrl = "/images/tool_complete.gif"; btnComplete.Enabled = true; btnComplete.Attributes.Add("onclick", "return EnsureLTMok('" + strValidation + "','" + txtVipName.ClientID + "','" + txtVipIP1.ClientID + "','" + txtVipIP2.ClientID + "','" + txtVipIP3.ClientID + "','" + txtVipIP4.ClientID + "') && confirm('Are you sure you want to mark this as completed and remove it from your workload?') && AlertMessage('This action requires validation that might take a few minutes to complete...\\n\\nPlease be patient and wait for the window to finish processing...') && ProcessControlButton();;"); btnComplete.CommandArgument = "FAST"; intProject = oRequest.GetProjectNumber(intRequest); hdnTab.Value = "D"; 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;"); } LoadChange(intResourceWorkflow); LoadInformation(intResourceWorkflow); chkDescription.Checked = (Request.QueryString["doc"] != null); lblDocuments.Text = oDocument.GetDocuments_Service(intRequest, intService, oVariable.DocumentsFolder(), 1, (Request.QueryString["doc"] != null)); 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 + "') && ProcessControlButton();"); 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; } }
protected void btnGo_Click(Object Sender, EventArgs e) { Design oDesign = new Design(0, dsn); Log oLog = new Log(0, dsn); Forecast oForecast = new Forecast(0, dsn); Users oUser = new Users(0, dsn); int intID = Int32.Parse(txtID.Text); DataSet dsDesign = oDesign.Get(intID); if (dsDesign.Tables[0].Rows.Count > 0) { Int32.TryParse(dsDesign.Tables[0].Rows[0]["answerid"].ToString(), out intID); } if (oForecast.GetAnswer(intID).Tables[0].Rows.Count > 0) { ResourceRequest oResourceRequest = new ResourceRequest(0, dsn); int intForecast = Int32.Parse(oForecast.GetAnswer(intID, "forecastid")); int intRequestExecute = oForecast.GetRequestID(intID, true); int intRequest = Int32.Parse(oForecast.Get(intForecast, "requestid")); Requests oRequest = new Requests(0, dsn); ServiceRequests oServiceRequest = new ServiceRequests(0, dsn); int intProject = oRequest.GetProjectNumber(intRequest); Variables oVariable = new Variables(intEnvironment); Functions oFunction = new Functions(0, dsn, intEnvironment); Projects oProject = new Projects(0, dsn); Pages oPage = new Pages(0, dsn); Servers oServer = new Servers(0, dsn); Cluster oCluster = new Cluster(0, dsn); ServerName oServerName = new ServerName(0, dsn); Asset oAsset = new Asset(0, dsnAsset); IPAddresses oIPAddresses = new IPAddresses(intProfile, dsnIP, dsn); OnDemand oOnDemand = new OnDemand(0, dsn); ModelsProperties oModelsProperties = new ModelsProperties(0, dsn); Types oType = new Types(0, dsn); Storage oStorage = new Storage(0, dsn); OnDemandTasks oOnDemandTasks = new OnDemandTasks(0, dsn); VMWare oVMWare = new VMWare(0, dsn); PNCTasks oPNCTasks = new PNCTasks(0, dsn); Zeus oZeus = new Zeus(intProfile, dsnZeus); DataSet dsServers = oServer.GetRequests(intRequestExecute, 0); if (chkTimes.Checked == true && (chkExitAP.Checked == true || chkConfig.Checked == true || chkUnlock.Checked == true)) { strError = "You can not and should not reset times and alter the design at the same time. RESET PROVISIONING TIMES can not be selected with any other selections."; } else { oLog.AddEvent(intID, "", "", "Design " + intID.ToString() + " reset by " + oUser.GetFullNameWithLanID(intProfile), LoggingType.Information); oForecast.AddReset(intID, -999); if (chkTimes.Checked == true) { DateTime datTimes = DateTime.Today; if (DateTime.TryParse(txtTimes.Text, out datTimes) == true) { // Update Design Dates int intExecutedBy = 0; Int32.TryParse(oForecast.GetAnswer(intID, "executed_by"), out intExecutedBy); if (intExecutedBy > 0) { if (chkTimesForecastExecuted.Checked == true) { oForecast.UpdateAnswerExecuted(intID, datTimes.ToString(), intExecutedBy); } if (chkTimesForecastCompleted.Checked == true) { oForecast.UpdateAnswerCompleted(intID, datTimes.ToString()); } if (chkTimesTasksStart.Checked == true) { // Reset all pre-production online tasks (including storage, backup, etc...) DataSet dsTasks = oPNCTasks.GetStepsDesign(intID, 0, 0); foreach (DataRow drTask in dsTasks.Tables[0].Rows) { int intRRID = 0; if (Int32.TryParse(drTask["id"].ToString(), out intRRID) == true) { // Reset the started and completed (if not null) oOnDemandTasks.UpdateTime(intRRID, datTimes, chkTimesTasksCompleted.Checked); } } } DataSet dsAnswer = oServer.GetAnswer(intID); foreach (DataRow drServer in dsAnswer.Tables[0].Rows) { int intServer = Int32.Parse(drServer["id"].ToString()); int intModel = Int32.Parse(drServer["modelid"].ToString()); int intType = oModelsProperties.GetType(intModel); DataSet dsSteps = oOnDemand.GetSteps(intType, 1); // Update Server Dates if (oServer.Get(intServer, "build_started") != "") { if (chkTimesServerStart.Checked == true) { oServer.UpdateBuildStarted(intServer, datTimes.ToString(), true); } if (chkTimesServerSteps.Checked == true) { int intStep = 0; foreach (DataRow drStep in dsSteps.Tables[0].Rows) { intStep++; oOnDemand.UpdateStepDoneServer(intServer, intStep, datTimes); } } } if (chkTimesServerComplete.Checked == true) { oServer.UpdateBuildCompleted(intServer, datTimes.ToString()); } if (chkTimesServerReady.Checked == true) { oServer.UpdateBuildReady(intServer, datTimes.ToString(), true); } } } else { strError = "The design has not been executed"; } } else { strError = "Invalid DateTime"; } } if (chkExitAP.Checked == true) { // Delete the Manual Build Task DataSet dsManual = oOnDemandTasks.GetGenericII(intID); if (dsManual.Tables[0].Rows.Count > 0) { int intRequestID = Int32.Parse(dsManual.Tables[0].Rows[0]["requestid"].ToString()); int intItem = Int32.Parse(dsManual.Tables[0].Rows[0]["itemid"].ToString()); int intNumber = Int32.Parse(dsManual.Tables[0].Rows[0]["number"].ToString()); oOnDemandTasks.DeleteGenericII(intID); DataSet dsParent = oResourceRequest.Get(intRequestID, intItem, intNumber); if (dsParent.Tables[0].Rows.Count > 0) { int intRRID = Int32.Parse(dsParent.Tables[0].Rows[0]["parent"].ToString()); oResourceRequest.Delete(intRRID); int intRRWID = Int32.Parse(dsParent.Tables[0].Rows[0]["id"].ToString()); oResourceRequest.DeleteWorkflow(intRRWID); } } // Reset automated servers foreach (DataRow drServer in dsServers.Tables[0].Rows) { int intServer = Int32.Parse(drServer["id"].ToString()); int intAsset = 0; Int32.TryParse(drServer["assetid"].ToString(), out intAsset); // Clear MDT / Altiris oServer.ClearMDT(intServer, dsnAsset, dsnZeus, intEnvironment); // Clear ZEUS if (intAsset > 0) { oZeus.DeleteBuild(oAsset.Get(intAsset, "serial")); } // Clear Steps oServer.UpdateStep(intServer, 0); oOnDemand.DeleteStepDoneServers(intServer, 1); // Clear Dates oServer.UpdateBuildStarted(intServer, "", true); oServer.UpdateBuildCompleted(intServer, ""); oServer.UpdateBuildReady(intServer, "", true); // Clear Errors DataSet dsError = oServer.GetErrors(intServer); foreach (DataRow drError in dsError.Tables[0].Rows) { if (drError["fixed"].ToString() == "") { oServer.UpdateError(intServer, Int32.Parse(drError["step"].ToString()), 0, 0, true, dsnAsset); } } // Clear VMware oVMWare.DeleteGuest(oServer.GetName(intServer, true)); oServiceRequest.Delete(intRequestExecute); if (chkExitAP_Name.Checked == true && drServer["nameid"].ToString() != "") { int intName = Int32.Parse(drServer["nameid"].ToString()); oServer.UpdateServerNamed(intServer, 0); oServerName.UpdateFactory(intName, 1); } if (chkExitAP_IP.Checked == true) { oServer.DeleteIP(intServer, 0, 0, 0, 0, dsnIP); } if (chkExitAP_Asset.Checked == true && intAsset > 0) { oServer.DeleteAsset(intServer); oAsset.AddStatus(intAsset, "", (int)AssetStatus.Available, -100, DateTime.Now); } } // Clear the execution and completion dates oForecast.UpdateAnswerExecution(intID, ""); oForecast.UpdateAnswerExecuted(intID, "", 0); oForecast.UpdateAnswerCompleted(intID, ""); // Clear the new design builder. if (dsDesign.Tables[0].Rows.Count > 0) { int intDesign = Int32.Parse(dsDesign.Tables[0].Rows[0]["id"].ToString()); oForecast.DeleteAnswer(intID); foreach (DataRow drServer in dsServers.Tables[0].Rows) { int intServer = Int32.Parse(drServer["id"].ToString()); oServer.Delete(intServer); } oDesign.UpdateAnswerId(intDesign, 0); if (chkExitAP_Approvals.Checked == true) { oDesign.DeleteApproverFieldWorkflow(intDesign); oDesign.DeleteApproverGroupWorkflow(intDesign, 0); oDesign.DeleteApproverGroupWorkflow(intDesign, 1); oDesign.DeleteSoftwareComponents(intDesign, true); if (chkExitAP_Submissions.Checked == false) { // Reset back to original requestor. oDesign.Approve(intDesign, 0, (oDesign.Get(intDesign, "is_exception") == "1"), intEnvironment, intImplementorDistributedService, intWorkstationPlatform, intImplementorMidrangeService, dsnAsset, dsnIP, dsnServiceEditor, intAssignPage, intResourceRequestApprove, intViewPage); } } if (chkExitAP_Submissions.Checked == true) { oDesign.DeleteSubmitted(intDesign); } } } if (chkConfig.Checked == true) { int intModel = oForecast.GetModel(intID); int intType = oModelsProperties.GetType(intModel); string strExecute = oType.Get(intType, "forecast_execution_path"); int intCount = 0; DataSet dsWizard = oOnDemand.GetWizardStepsDoneBack(intID); foreach (DataRow drWizard in dsWizard.Tables[0].Rows) { intCount++; if (intCount != dsWizard.Tables[0].Rows.Count) { oOnDemand.DeleteWizardStepDone(intID, Int32.Parse(drWizard["step"].ToString())); } } if (chkConfig_Reset.Checked == true) { oForecast.UpdateAnswer(intID, "", "", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); } if (chkConfig_Device.Checked == true) { foreach (DataRow drServer in dsServers.Tables[0].Rows) { int intServer = Int32.Parse(drServer["id"].ToString()); int intCluster = Int32.Parse(drServer["clusterid"].ToString()); oCluster.Delete(intCluster, intID); oServer.Delete(intServer); } } if (chkConfig_Storage.Checked == true) { oStorage.DeleteLuns(intID); } } if (chkUnlock.Checked == true) { if (chkUnlock_80.Checked == true) { 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]; string strEMailIdsBCC = oFunction.GetGetEmailAlertsEmailIds("EMAILGRP_DESIGN_BUILDER"); 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, 0, "Reset by administrator at client's request"); oForecast.UpdateAnswerConfidence(intID, intConfidenceUnlock); } oForecast.DeleteReset(intID); oForecast.AddReset(intID, intRequestExecute); oForecast.UpdateAnswer(intID, 0); DataSet dsPending = oOnDemandTasks.GetPending(intID); if (dsPending.Tables[0].Rows.Count > 0) { int intResourceWorkflow = Int32.Parse(dsPending.Tables[0].Rows[0]["resourceid"].ToString()); int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow); int intImplementor = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid")); oResourceRequest.UpdateItemAndService(intResourceParent, -1, -1); oResourceRequest.UpdateWorkflowName(intResourceWorkflow, "Auto-Provisioning Task [Reset]", 0); oOnDemandTasks.DeleteAll(intID); if (intImplementor > 0) { 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 strEMailIdsBCC = oFunction.GetGetEmailAlertsEmailIds("EMAILGRP_DESIGN_BUILDER"); if (strDefault == "") { oFunction.SendEmail("RESET: ClearView Auto-Provisioning Reset", oUser.GetName(intImplementor), "", strEMailIdsBCC, "RESET: ClearView Auto-Provisioning Reset", "<p><b>An auto-provisioning request has been reset. This request no longer requires immediate attention.</b><p><p>" + oForecast.GetAnswerBody(intID, intEnvironment, dsnAsset, dsnIP) + "</p>", true, false); } else { oFunction.SendEmail("RESET: ClearView Auto-Provisioning Reset", oUser.GetName(intImplementor), "", strEMailIdsBCC, "RESET: ClearView Auto-Provisioning Reset", "<p><b>An auto-provisioning request has been reset. This request no longer requires immediate attention.</b><p><p>" + oForecast.GetAnswerBody(intID, intEnvironment, dsnAsset, dsnIP) + "</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); } } } } } if (strError == "") { lblDone.Text = "<img src='/images/bigcheck.gif' border='0' align='absmiddle'/> <b>Finished!</b> ClearView reset the design"; } else { lblDone.Text = "<img src='/images/bigerror.gif' border='0' align='absmiddle'/> <b>Error!</b> " + strError; } } else if (dsDesign.Tables[0].Rows.Count > 0) { int intDesign = Int32.Parse(dsDesign.Tables[0].Rows[0]["id"].ToString()); oLog.AddEvent(intDesign, "", "", "Design " + intDesign.ToString() + " reset by " + oUser.GetFullNameWithLanID(intProfile), LoggingType.Information); oDesign.UpdateAnswerId(intDesign, 0); if (chkExitAP_Approvals.Checked == true) { oDesign.DeleteApproverFieldWorkflow(intDesign); oDesign.DeleteApproverGroupWorkflow(intDesign, 0); oDesign.DeleteApproverGroupWorkflow(intDesign, 1); oDesign.DeleteSoftwareComponents(intDesign, true); if (chkExitAP_Submissions.Checked == false) { // Reset back to original requestor. oDesign.Approve(intDesign, 0, (oDesign.Get(intDesign, "is_exception") == "1"), intEnvironment, intImplementorDistributedService, intWorkstationPlatform, intImplementorMidrangeService, dsnAsset, dsnIP, dsnServiceEditor, intAssignPage, intResourceRequestApprove, intViewPage); } } if (chkExitAP_Submissions.Checked == true) { oDesign.DeleteSubmitted(intDesign); } lblDone.Text = "<img src='/images/bigAlert.gif' border='0' align='absmiddle'/> <b>Done!</b> ClearView reset the new design builder"; } else { lblDone.Text = "<img src='/images/bigerror.gif' border='0' align='absmiddle'/> <b>Error!</b> ClearView could not find the design"; } }
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); oStorage = new Storage(intProfile, dsn); oApplication = new Applications(intProfile, dsn); oOnDemandTasks = new OnDemandTasks(intProfile, dsn); oDelegate = new Delegates(intProfile, dsn); oSolaris = new Solaris(intProfile, dsn); oMnemonic = new Mnemonic(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"] != "") { 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()); int intStatus = 0; Int32.TryParse(oResourceRequest.GetWorkflow(intResourceWorkflow, "status"), out intStatus); // 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 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); txtHours.Text = dblUsed.ToString("F"); 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; bool boolRed = LoadStatus(intResourceWorkflow); bool boolDone = LoadInformation(intResourceWorkflow); if (boolDone == true) { 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?') && ProcessControlButton();"); } else { btnSave.ImageUrl = "/images/tool_save_dbl.gif"; btnSave.Enabled = false; btnReturn.ImageUrl = "/images/tool_return_dbl.gif"; btnReturn.Enabled = false; 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; } bool boolSLABreached = false; if (oService.Get(intService, "sla") != "" && oService.Get(intService, "sla") != "0") { 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"; } 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; } 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;"); } oFunction.ConfigureToolButton(btnEmail, "/images/tool_email"); btnEmail.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST_EMAIL','?rrid=" + intResourceWorkflow.ToString() + "&type=STORAGE');"); btnDenied.Attributes.Add("onclick", "return CloseWindow();"); oFunction.ConfigureToolButton(btnSave, "/images/tool_save"); btnSave.Attributes.Add("onclick", "return ValidateNumber('" + txtHours.ClientID + "','Please enter a valid number of hours') && EnsureTextbox() && EnsureTextbox0() && EnsureStatus('" + hdnTab.ClientID + "','" + ddlStatus.ClientID + "','" + txtComments.ClientID + "') && ProcessControlButton();"); 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(btnSave, btnComplete); //panDenied.Visible = true; } if (intStatus != (int)ResourceRequestStatus.AwaitingResponse) //Awaiting Client Response { oFunction.ConfigureToolButton(btnReturn, "/images/tool_return"); btnReturn.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST_RETURN','?rrid=" + intResourceParent.ToString() + "&rrwfid=" + intResourceWorkflow.ToString() + "');"); } } else { panDenied.Visible = true; } }