protected DataSet Search() { ClearMessages(); ulSearch.Controls.Clear(); bool Valid = true; Valid = AddError(txtSearch, "Enter a server name", Valid, ValidationRestriction.Basic, Validation.Required, ulSearch, panSearch); if (Valid) { DataSet dsSearch = oZeus.GetBuildServer(txtSearch.Text); if (dsSearch.Tables[0].Rows.Count < 1) { Valid = AddError("Server not found. Try again...", ulSearch, panSearch); } else if (dsSearch.Tables[0].Rows.Count > 1) { Valid = AddError(dsSearch.Tables[0].Rows.Count.ToString() + "records returned. Try again...", ulSearch, panSearch); } else { return(dsSearch); } } return(null); }
private bool LoadInformation(int _request_workflow) { if (intProject > 0) { lblName.Text = oProject.Get(intProject, "name"); lblNumber.Text = oProject.Get(intProject, "number"); lblType.Text = "Project"; } else { lblName.Text = oResourceRequest.GetWorkflow(_request_workflow, "name"); lblNumber.Text = "CVT" + intRequest.ToString(); lblType.Text = "Task"; } bool boolDone = false; DataSet ds = oOnDemandTasks.GetVirtualII(intRequest, intItem, intNumber); if (ds.Tables[0].Rows.Count > 0) { Forecast oForecast = new Forecast(intProfile, dsn); int intAnswer = Int32.Parse(ds.Tables[0].Rows[0]["answerid"].ToString()); lblAnswer.Text = intAnswer.ToString(); btnView.Attributes.Add("onclick", "return OpenWindow('FORECAST_EQUIPMENT','?id=" + intAnswer.ToString() + "');"); //btnBirth.Attributes.Add("onclick", "return OpenWindow('PDF_BIRTH','?id=" + intAnswer.ToString() + "');"); //btnSC.Attributes.Add("onclick", "return OpenWindow('PDF_BIRTH','?id=" + intAnswer.ToString() + "');"); lblView.Text = oOnDemandTasks.GetBody(intAnswer, intImplementorDistributed, intImplementorMidrange); int intModel = Int32.Parse(ds.Tables[0].Rows[0]["modelid"].ToString()); ModelsProperties oModelsProperties = new ModelsProperties(intProfile, dsn); intModel = Int32.Parse(oModelsProperties.Get(intModel, "modelid")); Models oModel = new Models(intProfile, dsn); int intType = Int32.Parse(oModel.Get(intModel, "typeid")); Types oType = new Types(intProfile, dsn); string strExecute = oType.Get(intType, "forecast_execution_path"); if (strExecute != "") { btnExecute.Attributes.Add("onclick", "return OpenWindow('FORECAST_EXECUTE','" + strExecute + "?id=" + intAnswer.ToString() + "');"); } chk1.Checked = (ds.Tables[0].Rows[0]["chk1"].ToString() == "1"); chk2.Checked = (ds.Tables[0].Rows[0]["chk2"].ToString() == "1"); txtSCID.Text = ds.Tables[0].Rows[0]["scid"].ToString(); chk3.Checked = (ds.Tables[0].Rows[0]["chk3"].ToString() == "1"); chk4.Checked = (ds.Tables[0].Rows[0]["chk4"].ToString() == "1"); boolDone = (chk1.Checked && chk2.Checked && chk3.Checked && chk4.Checked); img1.ImageUrl = "/images/green_arrow.gif"; if (chk1.Checked == true) { btnExecute.Enabled = false; img1.ImageUrl = "/images/check.gif"; img2.ImageUrl = "/images/green_arrow.gif"; chk2.Enabled = true; Servers oServer = new Servers(intProfile, dsn); DataSet dsAnswer = oServer.GetAnswer(intAnswer); foreach (DataRow drAnswer in dsAnswer.Tables[0].Rows) { if (lbl1.Text != "") { lbl1.Text += "<br/>"; } int intServerName = Int32.Parse(drAnswer["nameid"].ToString()); ServerName oServerName = new ServerName(0, dsn); lbl1.Text += "Server Name: " + oservername.getname2(intServerName, 0) + "<br/>"; int intServer = Int32.Parse(drAnswer["id"].ToString()); Zeus oZeus = new Zeus(intProfile, dsnZeus); DataSet dsZeus = oZeus.GetBuildServer(intServer); if (dsZeus.Tables[0].Rows.Count > 0) { lbl1.Text += "Serial Number: " + dsZeus.Tables[0].Rows[0]["serial"].ToString() + "<br/>"; } int intDomain = Int32.Parse(drAnswer["domainid"].ToString()); Domains oDomain = new Domains(intProfile, dsn); boolMove = (oDomain.Get(intDomain, "move") == "1"); if (boolMove == true) { lbl1.Text += "DHCP Address: " + drAnswer["dhcp"].ToString() + "<br/>"; } int intIPAddress = 0; IPAddresses oIPAddresses = new IPAddresses(0, dsnIP, dsn); if (drAnswer["ipaddressid"].ToString() != "") { intIPAddress = Int32.Parse(drAnswer["ipaddressid"].ToString()); lbl1.Text += "Assigned IP Address: " + oIPAddresses.GetName(intIPAddress, 0) + "<br/>"; } if (drAnswer["ipaddressid_final"].ToString() != "") { intIPAddress = Int32.Parse(drAnswer["ipaddressid_final"].ToString()); lbl1.Text += "Final IP Address: " + oIPAddresses.GetName(intIPAddress, 0) + "<br/>"; } } } } if (boolMove == false) { } if (chk2.Checked == true) { chk1.Enabled = false; img2.ImageUrl = "/images/check.gif"; img3.ImageUrl = "/images/green_arrow.gif"; chk3.Enabled = true; } if (chk3.Checked == true) { chk2.Enabled = false; img3.ImageUrl = "/images/check.gif"; img4.ImageUrl = "/images/green_arrow.gif"; chk4.Enabled = true; } if (chk4.Checked == true) { chk3.Enabled = false; img4.ImageUrl = "/images/check.gif"; } if (Request.QueryString["div"] != null) { switch (Request.QueryString["div"]) { case "E": boolExecution = true; break; } } if (boolDetails == false && boolExecution == false) { boolDetails = true; } return(boolDone); }
private bool LoadInformation(int _request_workflow) { if (intProject > 0) { lblName.Text = oProject.Get(intProject, "name"); lblNumber.Text = oProject.Get(intProject, "number"); lblType.Text = "Project"; } else { lblName.Text = oResourceRequest.GetWorkflow(_request_workflow, "name"); lblNumber.Text = "CVT" + intRequest.ToString(); lblType.Text = "Task"; } bool boolDone = false; DataSet ds = oOnDemandTasks.GetVMWareII(intRequest, intItem, intNumber); if (ds.Tables[0].Rows.Count > 0) { Forecast oForecast = new Forecast(intProfile, dsn); int intAnswer = Int32.Parse(ds.Tables[0].Rows[0]["answerid"].ToString()); if (oForecast.IsHARoom(intAnswer) == true) { DataSet dsServer = oServer.GetAnswer(intAnswer); foreach (DataRow drServer in dsServer.Tables[0].Rows) { int intHA = Int32.Parse(drServer["id"].ToString()); DataSet dsHA = oServer.GetHA(intHA); if (dsHA.Tables[0].Rows.Count > 0) { if (lblHA.Text != "") { lblHA.Text += "<br/>"; } lblHA.Text += oServer.GetName(intHA, true) + " = " + oServer.GetName(Int32.Parse(dsHA.Tables[0].Rows[0]["serverid_ha"].ToString()), true); panHA.Visible = true; } } } lblAnswer.Text = intAnswer.ToString(); btnView.Attributes.Add("onclick", "return OpenWindow('FORECAST_EQUIPMENT','?id=" + intAnswer.ToString() + "');"); btnBirth.Attributes.Add("onclick", "return OpenWindow('PDF_BIRTH','?id=" + intAnswer.ToString() + "');"); btnSC.Attributes.Add("onclick", "return OpenWindow('PDF_BIRTH','?id=" + intAnswer.ToString() + "');"); lblView.Text = oOnDemandTasks.GetBody(intAnswer, intImplementorDistributed, intImplementorMidrange); int intModel = Int32.Parse(ds.Tables[0].Rows[0]["modelid"].ToString()); ModelsProperties oModelsProperties = new ModelsProperties(intProfile, dsn); intModel = Int32.Parse(oModelsProperties.Get(intModel, "modelid")); Models oModel = new Models(intProfile, dsn); int intType = Int32.Parse(oModel.Get(intModel, "typeid")); Types oType = new Types(intProfile, dsn); string strExecute = oType.Get(intType, "forecast_execution_path"); if (strExecute != "") { btnExecute.Attributes.Add("onclick", "return OpenWindow('FORECAST_EXECUTE','" + strExecute + "?id=" + intAnswer.ToString() + "');"); } chk1.Checked = (ds.Tables[0].Rows[0]["chk1"].ToString() == "1"); chk3.Checked = (ds.Tables[0].Rows[0]["chk3"].ToString() == "1"); chk4.Checked = (ds.Tables[0].Rows[0]["chk4"].ToString() == "1"); chk5.Checked = (ds.Tables[0].Rows[0]["chk5"].ToString() == "1"); chk6.Checked = (ds.Tables[0].Rows[0]["chk6"].ToString() == "1"); chk7.Checked = (ds.Tables[0].Rows[0]["chk7"].ToString() == "1"); chk8.Checked = (ds.Tables[0].Rows[0]["chk8"].ToString() == "1"); chk9.Checked = (ds.Tables[0].Rows[0]["chk9"].ToString() == "1"); chk10.Checked = (ds.Tables[0].Rows[0]["chk10"].ToString() == "1"); chk11.Checked = (ds.Tables[0].Rows[0]["chk11"].ToString() == "1"); int intNotifications = Int32.Parse(ds.Tables[0].Rows[0]["notifications"].ToString()); int intClass = Int32.Parse(oForecast.GetAnswer(intAnswer, "classid")); if (oClass.Get(intClass, "prod") != "1") { chk9.Checked = true; img9.ImageUrl = "/images/cancel.gif"; chk10.Checked = true; img10.ImageUrl = "/images/cancel.gif"; chk11.Checked = true; img11.ImageUrl = "/images/cancel.gif"; } boolDone = (chk1.Checked && chk3.Checked && chk4.Checked && chk5.Checked && chk6.Checked && chk7.Checked && chk8.Checked && chk9.Checked && chk10.Checked && chk11.Checked); img1.ImageUrl = "/images/green_arrow.gif"; if (chk1.Checked == true) { btnExecute.Enabled = false; img1.ImageUrl = "/images/check.gif"; img3.ImageUrl = "/images/green_arrow.gif"; chk3.Enabled = true; Servers oServer = new Servers(intProfile, dsn); DataSet dsAnswer = oServer.GetAnswer(intAnswer); foreach (DataRow drAnswer in dsAnswer.Tables[0].Rows) { if (lbl1.Text != "") { lbl1.Text += "<br/>"; } int intServer = Int32.Parse(drAnswer["id"].ToString()); int intServerName = Int32.Parse(drAnswer["nameid"].ToString()); ServerName oServerName = new ServerName(0, dsn); string strName = oServer.GetName(intServer, boolUsePNCNaming); lbl1.Text += "Server Name: " + strName + "<br/>"; Zeus oZeus = new Zeus(intProfile, dsnZeus); DataSet dsZeus = oZeus.GetBuildServer(intServer); if (dsZeus.Tables[0].Rows.Count > 0) { lbl1.Text += "Serial Number: " + dsZeus.Tables[0].Rows[0]["serial"].ToString() + "<br/>"; lbl1.Text += "Asset Tag: " + dsZeus.Tables[0].Rows[0]["asset"].ToString() + "<br/>"; } int intDomain = Int32.Parse(drAnswer["domainid"].ToString()); Domains oDomain = new Domains(intProfile, dsn); boolMove = (oDomain.Get(intDomain, "move") == "1"); if (boolMove == true) { lbl1.Text += "DHCP Address: " + drAnswer["dhcp"].ToString() + "<br/>"; } int intIPAddress = 0; IPAddresses oIPAddresses = new IPAddresses(0, dsnIP, dsn); lbl1.Text += "Assigned IP Address: " + oServer.GetIPs(intServer, 1, 0, 0, dsnIP, "", "") + "<br/>"; lbl1.Text += "Final IP Address: " + oServer.GetIPs(intServer, 0, 1, 0, dsnIP, "", "") + "<br/>"; Asset oAsset = new Asset(intProfile, dsnAsset); VMWare oVMWare = new VMWare(intProfile, dsn); int intAsset = 0; if (drAnswer["assetid"].ToString() != "") { intAsset = Int32.Parse(drAnswer["assetid"].ToString()); } if (intAsset > 0) { DataSet dsGuest = oVMWare.GetGuest(strName); if (dsGuest.Tables[0].Rows.Count > 0) { int intHost = Int32.Parse(dsGuest.Tables[0].Rows[0]["hostid"].ToString()); int intCluster = Int32.Parse(oVMWare.GetHost(intHost, "clusterid")); int intFolder = Int32.Parse(oVMWare.GetCluster(intCluster, "folderid")); int intDataCenter = Int32.Parse(oVMWare.GetFolder(intFolder, "datacenterid")); lbl1.Text += "DataCenter: " + oVMWare.GetDatacenter(intDataCenter, "name") + "<br/>"; lbl1.Text += "Host: " + oVMWare.GetHost(intHost, "name") + "<br/>"; int intDatastore = Int32.Parse(dsGuest.Tables[0].Rows[0]["datastoreid"].ToString()); lbl1.Text += "DataStore: " + oVMWare.GetDatastore(intDatastore, "name") + "<br/>"; int intPool = Int32.Parse(dsGuest.Tables[0].Rows[0]["poolid"].ToString()); //lbl1.Text += "Pool: " + oVMWare.GetPool(intPool, "name") + "<br/>"; int intVlan = Int32.Parse(dsGuest.Tables[0].Rows[0]["vlanid"].ToString()); lbl1.Text += "VLAN: " + oVMWare.GetVlan(intVlan, "name") + "<br/>"; } } Storage oStorage = new Storage(intProfile, dsn); int intCluster2 = Int32.Parse(drAnswer["clusterid"].ToString()); int intCSMConfig2 = Int32.Parse(drAnswer["csmconfigid"].ToString()); int intNumber2 = Int32.Parse(drAnswer["number"].ToString()); DataSet dsLuns = oStorage.GetLuns(intAnswer, 0, intCluster2, intCSMConfig2, intNumber2); StringBuilder sbStorage = new StringBuilder(); int intRow = 0; bool boolOverride = (oForecast.GetAnswer(intAnswer, "storage_override") == "1"); foreach (DataRow drLun in dsLuns.Tables[0].Rows) { intRow++; sbStorage.Append("<tr>"); sbStorage.Append("<td>"); sbStorage.Append(intRow.ToString()); sbStorage.Append("</td>"); string strLetter = drLun["letter"].ToString(); if (strLetter == "") { if (drLun["driveid"].ToString() == "-1000") { strLetter = "E"; } else if (drLun["driveid"].ToString() == "-100") { strLetter = "F"; } else if (drLun["driveid"].ToString() == "-10") { strLetter = "P"; } else if (drLun["driveid"].ToString() == "-1") { strLetter = "Q"; } } if ((boolOverride == true && drLun["driveid"].ToString() == "0") || oForecast.IsOSMidrange(intAnswer) == true) { sbStorage.Append("<td>"); sbStorage.Append(drLun["path"].ToString()); sbStorage.Append("</td>"); } else { sbStorage.Append("<td>"); sbStorage.Append(strLetter); sbStorage.Append(":"); sbStorage.Append(drLun["path"].ToString()); sbStorage.Append("</td>"); } sbStorage.Append("<td>"); sbStorage.Append(drLun["performance"].ToString()); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drLun["size"].ToString()); sbStorage.Append(" GB</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drLun["actual_size"].ToString() == "-1" ? "Pending" : drLun["actual_size"].ToString() + " GB"); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drLun["size_qa"].ToString()); sbStorage.Append(" GB</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drLun["actual_size_qa"].ToString() == "-1" ? "Pending" : drLun["actual_size_qa"].ToString() + " GB"); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drLun["size_test"].ToString()); sbStorage.Append(" GB</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drLun["actual_size_test"].ToString() == "-1" ? "Pending" : drLun["actual_size_test"].ToString() + " GB"); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drLun["replicated"].ToString() == "0" ? "No" : "Yes"); sbStorage.Append("</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drLun["actual_replicated"].ToString() == "-1" ? "Pending" : (drLun["actual_replicated"].ToString() == "0" ? "No" : "Yes")); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drLun["high_availability"].ToString() == "0" ? "No" : "Yes (" + drLun["size"].ToString() + " GB)"); sbStorage.Append("</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drLun["actual_high_availability"].ToString() == "-1" ? "Pending" : (drLun["actual_high_availability"].ToString() == "0" ? "No" : "Yes (" + drLun["actual_size"].ToString() + " GB)")); sbStorage.Append("</td>"); sbStorage.Append("</tr>"); DataSet dsPoints = oStorage.GetMountPoints(Int32.Parse(drLun["id"].ToString())); int intPoint = 0; foreach (DataRow drPoint in dsPoints.Tables[0].Rows) { intRow++; intPoint++; sbStorage.Append("<tr>"); sbStorage.Append("<td>"); sbStorage.Append(intRow.ToString()); sbStorage.Append("</td>"); if (oForecast.IsOSMidrange(intAnswer) == true) { sbStorage.Append("<td>"); sbStorage.Append(drPoint["path"].ToString()); sbStorage.Append("</td>"); } else { sbStorage.Append("<td>"); sbStorage.Append(strLetter); sbStorage.Append(":\\SH"); sbStorage.Append(drLun["driveid"].ToString()); sbStorage.Append("VOL"); sbStorage.Append(intPoint < 10 ? "0" : ""); sbStorage.Append(intPoint.ToString()); sbStorage.Append("</td>"); } sbStorage.Append("<td>"); sbStorage.Append(drPoint["performance"].ToString()); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drPoint["size"].ToString()); sbStorage.Append(" GB</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drPoint["actual_size"].ToString() == "-1" ? "Pending" : drPoint["actual_size"].ToString() + " GB"); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drPoint["size_qa"].ToString()); sbStorage.Append(" GB</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drPoint["actual_size_qa"].ToString() == "-1" ? "Pending" : drPoint["actual_size_qa"].ToString() + " GB"); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drPoint["size_test"].ToString()); sbStorage.Append(" GB</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drPoint["actual_size_test"].ToString() == "-1" ? "Pending" : drPoint["actual_size_test"].ToString() + " GB"); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drPoint["replicated"].ToString() == "0" ? "No" : "Yes"); sbStorage.Append("</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drPoint["actual_replicated"].ToString() == "-1" ? "Pending" : (drPoint["actual_replicated"].ToString() == "0" ? "No" : "Yes")); sbStorage.Append("</td>"); sbStorage.Append("<td>"); sbStorage.Append(drPoint["high_availability"].ToString() == "0" ? "No" : "Yes (" + drPoint["size"].ToString() + " GB)"); sbStorage.Append("</td>"); sbStorage.Append("<td class=\"required\">"); sbStorage.Append(drPoint["actual_high_availability"].ToString() == "-1" ? "Pending" : (drPoint["actual_high_availability"].ToString() == "0" ? "No" : "Yes (" + drPoint["actual_size"].ToString() + " GB)")); sbStorage.Append("</td>"); sbStorage.Append("</tr>"); } } if (sbStorage.ToString() != "") { sbStorage.Insert(0, "<tr class=\"bold\"><td></td><td>Path</td><td>Performance</td><td>Requested<br/>Size in Prod</td><td>Actual<br/>Size in Prod</td><td>Requested<br/>Size in QA</td><td>Actual<br/>Size in QA</td><td>Requested<br/>Size in Test</td><td>Actual<br/>Size in Test</td><td>Requested<br/>Replication</td><td>Actual<br/>Replication</td><td>Requested<br/>High Availability</td><td>Actual<br/>High Availability</td></tr>"); sbStorage.Insert(0, "<table width=\"100%\" cellpadding=\"2\" cellspacing=\"1\" border=\"0\">"); sbStorage.Append("</table>"); } lbl1.Text += sbStorage.ToString(); } } if (chk3.Checked == true) { img3.ImageUrl = "/images/check.gif"; img4.ImageUrl = "/images/green_arrow.gif"; chk4.Enabled = true; } if (chk4.Checked == true) { img4.ImageUrl = "/images/check.gif"; if (boolMove == true) { img5.ImageUrl = "/images/green_arrow.gif"; chk5.Enabled = true; } else { chk5.Checked = true; img7.ImageUrl = "/images/green_arrow.gif"; chk7.Enabled = true; } } if (chk5.Checked == true) { if (boolMove == true) { img5.ImageUrl = "/images/check.gif"; } else { img5.ImageUrl = "/images/cancel.gif"; } if (boolMove == true) { img6.ImageUrl = "/images/green_arrow.gif"; chk6.Enabled = true; } } if (chk6.Checked == true) { if (boolMove == true) { img6.ImageUrl = "/images/check.gif"; } else { img6.ImageUrl = "/images/cancel.gif"; } if (boolMove == true) { img7.ImageUrl = "/images/green_arrow.gif"; chk7.Enabled = true; } } if (chk7.Checked == true) { img7.ImageUrl = "/images/check.gif"; img8.ImageUrl = "/images/green_arrow.gif"; chk8.Enabled = true; } if (chk8.Checked == true) { img8.ImageUrl = "/images/check.gif"; img9.ImageUrl = "/images/green_arrow.gif"; chk9.Enabled = true; } if (chk9.Checked == true) { img9.ImageUrl = "/images/check.gif"; img10.ImageUrl = "/images/green_arrow.gif"; chk10.Enabled = true; } if (chk10.Checked == true) { img10.ImageUrl = "/images/check.gif"; img11.ImageUrl = "/images/green_arrow.gif"; chk11.Enabled = true; } if (chk11.Checked == true) { img11.ImageUrl = "/images/check.gif"; } } if (Request.QueryString["div"] != null) { switch (Request.QueryString["div"]) { case "E": boolExecution = true; break; } } if (boolDetails == false && boolExecution == false) { boolDetails = true; } return(boolDone); }