protected int LoadPlatform(int _platformid, int _typeid)
{
int intCount = 0;
ddlPlatforms.DataTextField = "name";
ddlPlatforms.DataValueField = "platformid";
DataSet ds = oPlatform.Gets(1);
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["name"].ToString().ToUpper() == "VENDOR")
{
dr.Delete();
}
}
ddlPlatforms.DataSource = ds;
ddlPlatforms.DataBind();
ddlPlatforms.Items.Insert(0, new ListItem("-- SELECT --", "0"));
if (_typeid > 0)
{
ddlPlatforms.SelectedValue = _typeid.ToString();
panTypes.Visible = true;
ddlTypes.DataTextField = "name";
ddlTypes.DataValueField = "id";
ddlTypes.DataSource = oType.Gets(_typeid, 1);
ddlTypes.DataBind();
ddlTypes.Items.Insert(0, new ListItem("-- SELECT --", "0"));
}
return(intCount);
}
protected void btnGo_Click(Object Sender, EventArgs e)
{
XmlDocument oDoc = new XmlDocument();
string strResponse = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
strResponse += "<models>";
DataSet dsPlatform = oPlatform.Gets(1);
foreach (DataRow drPlatform in dsPlatform.Tables[0].Rows)
{
DataSet dsTypes = oType.Gets(Int32.Parse(drPlatform["platformid"].ToString()), 1);
foreach (DataRow drType in dsTypes.Tables[0].Rows)
{
DataSet ds = oModelsProperties.GetTypes(0, Int32.Parse(drType["id"].ToString()), 1);
foreach (DataRow dr in ds.Tables[0].Rows)
{
strResponse += "<model>";
strResponse += "<id><![CDATA[" + dr["id"].ToString() + "]]></id><name><![CDATA[" + dr["name"].ToString() + "]]></name>";
strResponse += "</model>";
}
}
}
strResponse += "</models>";
Response.Write(strResponse);
Response.ContentType = "application/xml";
Response.AddHeader("Content-Disposition", "attachment; filename=models.xml");
Response.End();
Response.Flush();
}
private void LoadList()
{
lstCurrent.DataValueField = "id";
lstCurrent.DataTextField = "name";
lstCurrent.DataSource = oDataPoint.GetDeployModel();
lstCurrent.DataBind();
ddlPlatform.DataValueField = "platformid";
ddlPlatform.DataTextField = "name";
ddlPlatform.DataSource = oPlatform.Gets(1);
ddlPlatform.DataBind();
ddlPlatform.Items.Insert(0, new ListItem("-- SELECT --", "0"));
}
private void LoadPlatforms()
{
DataSet ds = oPlatform.Gets(1);
foreach (DataRow dr in ds.Tables[0].Rows)
{
TreeNode oNode = new TreeNode();
oNode.Text = dr["name"].ToString();
oNode.ToolTip = dr["name"].ToString();
oNode.ImageUrl = "/images/folder.gif";
oNode.SelectAction = TreeNodeSelectAction.Expand;
oTreeview.Nodes.Add(oNode);
LoadTypes(Int32.Parse(dr["platformid"].ToString()), oNode);
}
}
private void Load()
{
DataSet ds = oPlatform.Gets(1);
foreach (DataRow dr in ds.Tables[0].Rows)
{
TreeNode oNode = new TreeNode();
oNode.Text = dr["name"].ToString();
oNode.ToolTip = dr["name"].ToString();
oNode.ImageUrl = "/images/folder.gif";
oNode.SelectAction = TreeNodeSelectAction.Expand;
oTreeview.Nodes.Add(oNode);
LoadTypes(Int32.Parse(dr["platformid"].ToString()), oNode);
}
oTreeview.ExpandDepth = 0;
oTreeview.Attributes.Add("oncontextmenu", "return false;");
}
private void Load()
{
DataSet ds = oPlatform.Gets(1);
foreach (DataRow dr in ds.Tables[0].Rows)
{
TreeNode oNode = new TreeNode();
oNode.Text = dr["name"].ToString();
oNode.ToolTip = dr["name"].ToString();
oNode.ImageUrl = "/images/folder.gif";
oNode.SelectAction = TreeNodeSelectAction.Expand;
oTreeview.Nodes.Add(oNode);
Load(Int32.Parse(dr["platformid"].ToString()), oNode);
TreeNode oNew = new TreeNode();
oNew.Text = " Add Form";
oNew.ToolTip = "Add Form";
oNew.ImageUrl = "/images/green_right.gif";
oNew.NavigateUrl = "javascript:Add('" + dr["platformid"].ToString() + "','" + oPlatform.GetName(Int32.Parse(dr["platformid"].ToString())) + "');";
oNode.ChildNodes.Add(oNew);
}
}
protected void LoadLists()
{
ddlPlatform.Attributes.Add("onchange", "PopulatePlatformTypes('" + ddlPlatform.ClientID + "','" + ddlPlatformType.ClientID + "','" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatform.DataTextField = "name";
ddlPlatform.DataValueField = "platformid";
ddlPlatform.DataSource = oPlatform.Gets(1);
ddlPlatform.DataBind();
ddlPlatform.Items.Insert(0, new ListItem("-- SELECT --", "0"));
ddlPlatformType.Attributes.Add("onchange", "PopulatePlatformModels('" + ddlPlatformType.ClientID + "','" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformType.Items.Insert(0, new ListItem("-- Select a platform --", "0"));
ddlPlatformType.Enabled = false;
ddlPlatformModel.Attributes.Add("onchange", "PopulatePlatformModelPropertiesAll('" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformModel.Items.Insert(0, new ListItem("-- Select a type --", "0"));
ddlPlatformModel.Enabled = false;
ddlPlatformModelProperty.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlPlatformModelProperty.ClientID + "','" + hdnModel.ClientID + "');");
ddlPlatformModelProperty.Items.Insert(0, new ListItem("-- Select a model --", "0"));
ddlPlatformModelProperty.Enabled = false;
ddlClass.DataTextField = "name";
ddlClass.DataValueField = "id";
ddlClass.DataSource = oClass.Gets(1);
ddlClass.DataBind();
ddlClass.Items.Insert(0, new ListItem("-- SELECT --", "0"));
}
private void LoadLists()
{
LoadDDL(ddlClass, "name", "id", oClass.Gets(1), "");
LoadDDL(ddlPlatform, "name", "platformid", oPlatform.Gets(1), "");
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
if (Request.Cookies["profileid"] != null && Request.Cookies["profileid"].Value != "")
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
}
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);
}
oDataPoint = new DataPoint(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oServer = new Servers(intProfile, dsn);
oAsset = new Asset(intProfile, dsnAsset);
oForecast = new Forecast(intProfile, dsn);
oPlatform = new Platforms(intProfile, dsn);
oType = new Types(intProfile, dsn);
oModel = new Models(intProfile, dsn);
oModelsProperties = new ModelsProperties(intProfile, dsn);
oIPAddresses = new IPAddresses(intProfile, dsnIP, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oOperatingSystem = new OperatingSystems(intProfile, dsn);
oServicePack = new ServicePacks(intProfile, dsn);
oClass = new Classes(intProfile, dsn);
oEnvironment = new Environments(intProfile, dsn);
oResiliency = new Resiliency(intProfile, dsn);
if (oUser.IsAdmin(intProfile) == true || (oDataPoint.GetPagePermission(intApplication, "ASSET") == true || intDataPointAvailableAsset == 1))
{
panAllow.Visible = true;
if (Request.QueryString["save"] != null)
{
panSave.Visible = true;
}
if (Request.QueryString["error"] != null)
{
panError.Visible = true;
lblError.Text = "Name Already Exists";
}
Int32.TryParse(oFunction.decryptQueryString(Request.QueryString["id"]), out intID);
if (Request.QueryString["close"] != null)
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">window.close();<" + "/" + "script>");
}
else if (intID > 0)
{
DataSet ds = oDataPoint.GetAsset(intID);
if (ds.Tables[0].Rows.Count == 1)
{
// Load General Information
intAsset = Int32.Parse(ds.Tables[0].Rows[0]["id"].ToString());
lblAssetID.Text = "#" + intAsset.ToString();
string strSerial = ds.Tables[0].Rows[0]["serial"].ToString();
string strAsset = ds.Tables[0].Rows[0]["asset"].ToString();
string strHeader = (strSerial.Length > 15 ? strSerial.Substring(0, 15) + "..." : strSerial);
lblHeader.Text = """ + strHeader.ToUpper() + """;
Master.Page.Title = "DataPoint | Enclosure (" + strHeader + ")";
lblHeaderSub.Text = "Provides all the information about an enclosure...";
int intMenuTab = 0;
if (Request.QueryString["menu_tab"] != null && Request.QueryString["menu_tab"] != "")
{
intMenuTab = Int32.Parse(Request.QueryString["menu_tab"]);
}
Tab oTab = new Tab(hdnTab.ClientID, intMenuTab, "divMenu1", true, false);
oTab.AddTab("Asset Information", "");
oTab.AddTab("Location Information", "");
oTab.AddTab("Virtual Connect IPs", "");
oTab.AddTab("Resource Dependencies", "");
oTab.AddTab("Provisioning History", "");
oTab.AddTab("Blades", "");
//oTab.AddTab("Network Adapter Configuration", "");
strMenuTab1 = oTab.GetTabs();
if (oUser.IsAdmin(intProfile) == true || oDataPoint.GetFieldPermission(intProfile, "SERVER_ADMIN") == true)
{
panOldLocationInfo.Visible = true;
}
if (!IsPostBack)
{
//DataSet dsAssets = oServer.GetAsset(intAsset);
//foreach (DataRow drAsset in dsAssets.Tables[0].Rows)
//{
// if (drAsset["latest"].ToString() == "1")
// {
// intAsset = Int32.Parse(drAsset["assetid"].ToString());
// intAssetClass = Int32.Parse(drAsset["classid"].ToString());
// intAssetEnv = Int32.Parse(drAsset["environmentid"].ToString());
// break;
// }
//}
// Asset Information
oDataPoint.LoadTextBox(txtPlatformSerial, intProfile, null, "", lblPlatformSerial, fldPlatformSerial, "ENCLOSURE_SERIAL", strSerial, "", false, true);
oDataPoint.LoadTextBox(txtPlatformAsset, intProfile, null, "", lblPlatformAsset, fldPlatformAsset, "ENCLOSURE_ASSET", strAsset, "", false, true);
int intAssetAttribute = Int32.Parse(oAsset.Get(intAsset, "asset_attribute"));
oDataPoint.LoadDropDown(ddlAssetAttribute, intProfile, null, "", lblAssetAttribute, fldAssetAttribute, "ASSET_ATTRIBUTE", "Name", "AttributeId", oAsset.getAssetAttributes(null, "", 1), intAssetAttribute, true, false, false);
oDataPoint.LoadTextBox(txtAssetAttributeComment, intProfile, null, "", lblAssetAttributeComment, fldAssetAttributeComment, "ASSET_ATTRIBUTE_COMMENT", oAsset.getAssetAttributesComments(intAsset), "", false, true);
ddlAssetAttribute.Attributes.Add("onclick", "return SetControlsForAssetAttributes()");
ddlPlatform.Attributes.Add("onchange", "PopulatePlatformTypes('" + ddlPlatform.ClientID + "','" + ddlPlatformType.ClientID + "','" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformType.Attributes.Add("onchange", "PopulatePlatformModels('" + ddlPlatformType.ClientID + "','" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformModel.Attributes.Add("onchange", "PopulatePlatformModelProperties('" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformModelProperty.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlPlatformModelProperty.ClientID + "','" + hdnModel.ClientID + "');");
int intModel = Int32.Parse(oAsset.Get(intAsset, "modelid"));
hdnModel.Value = intModel.ToString();
int intModelParent = Int32.Parse(oModelsProperties.Get(intModel, "modelid"));
int intType = oModel.GetType(intModelParent);
int intPlatform = oType.GetPlatform(intType);
oDataPoint.LoadDropDown(ddlPlatform, intProfile, null, "", lblPlatform, fldPlatform, "ENCLOSURE_PLATFORM", "name", "platformid", oPlatform.Gets(1), intPlatform, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformType, intProfile, null, "", lblPlatformType, fldPlatformType, "ENCLOSURE_TYPE", "name", "id", oType.Gets(intPlatform, 1), intType, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformModel, intProfile, null, "", lblPlatformModel, fldPlatformModel, "ENCLOSURE_MODEL", "name", "id", oModel.Gets(intType, 1), intModelParent, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformModelProperty, intProfile, null, "", lblPlatformModelProperty, fldPlatformModelProperty, "ENCLOSURE_MODEL_PROP", "name", "id", oModelsProperties.GetModels(0, intModelParent, 1), intModel, false, false, true);
// Get Asset
DataSet dsAsset = oAsset.GetEnclosure(intAsset);
if (dsAsset.Tables[0].Rows.Count > 0)
{
oDataPoint.LoadTextBox(txtName, intProfile, null, "", lblName, fldName, "ENCLOSURE_NAME", dsAsset.Tables[0].Rows[0]["name"].ToString(), "", false, false);
if (txtName.Text != "")
{
lblHeader.Text += " [" + txtName.Text + "]";
}
lblStatus.Text = dsAsset.Tables[0].Rows[0]["statusname"].ToString();
int intClass = Int32.Parse(dsAsset.Tables[0].Rows[0]["classid"].ToString());
int intEnv = Int32.Parse(dsAsset.Tables[0].Rows[0]["environmentid"].ToString());
hdnEnvironment.Value = intEnv.ToString();
oDataPoint.LoadDropDown(ddlPlatformClass, intProfile, null, "", lblPlatformClass, fldPlatformClass, "ENCLOSURE_CLASS", "name", "id", oClass.Gets(1), intClass, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformEnvironment, intProfile, null, "", lblPlatformEnvironment, fldPlatformEnvironment, "ENCLOSURE_ENVIRONMENT", "name", "id", oClass.GetEnvironment(intClass, 0), intEnv, false, false, true);
oDataPoint.LoadTextBox(txtPlatformVLAN, intProfile, null, "", lblPlatformVLAN, fldPlatformVLAN, "ENCLOSURE_VLAN", dsAsset.Tables[0].Rows[0]["vlan"].ToString(), "", false, true);
if (dsAsset.Tables[0].Rows[0]["oa_ip"].ToString() != "")
{
oDataPoint.LoadTextBox(txtPlatformOA, intProfile, btnOA, "https://" + dsAsset.Tables[0].Rows[0]["oa_ip"].ToString(), lblPlatformOA, fldPlatformOA, "ENCLOSURE_OA", dsAsset.Tables[0].Rows[0]["oa_ip"].ToString(), "", false, true);
}
else
{
oDataPoint.LoadTextBox(txtPlatformOA, intProfile, null, "", lblPlatformOA, fldPlatformOA, "ENCLOSURE_OA", dsAsset.Tables[0].Rows[0]["oa_ip"].ToString(), "", false, true);
}
int intResiliency = 0;
Int32.TryParse(dsAsset.Tables[0].Rows[0]["resiliencyid"].ToString(), out intResiliency);
oDataPoint.LoadDropDown(ddlPlatformResiliency, intProfile, null, "", lblPlatformResiliency, fldPlatformResiliency, "ENCLOSURE_RESILIENCY", "name", "id", oResiliency.Gets(1), intResiliency, false, false, true);
lblOldlocation.Text = dsAsset.Tables[0].Rows[0]["OldLocation"].ToString();
lblOldRoom.Text = dsAsset.Tables[0].Rows[0]["OldRoom"].ToString();
lblOldRack.Text = dsAsset.Tables[0].Rows[0]["OldRack"].ToString();
txtLocation.Text = dsAsset.Tables[0].Rows[0]["Location"].ToString();
txtRoom.Text = dsAsset.Tables[0].Rows[0]["Room"].ToString();
txtZone.Text = dsAsset.Tables[0].Rows[0]["Zone"].ToString();
txtRack.Text = dsAsset.Tables[0].Rows[0]["Rack"].ToString();
txtRackPosition.Text = dsAsset.Tables[0].Rows[0]["Rackposition"].ToString();
oDataPoint.LoadTextBox(txtRackPosition, intProfile, null, "", lblRackPositionValue, fldLocation, "CHANGE_LOCATION", dsAsset.Tables[0].Rows[0]["rackposition"].ToString(), "", false, true);
hdnRackId.Value = dsAsset.Tables[0].Rows[0]["NewRackId"].ToString();
oDataPoint.LoadButton(btnSelectLocation, intProfile, fldLocation, "CHANGE_LOCATION",
"return LoadLocationRoomRack('" + "rack" + "','" + hdnRackId.ClientID + "', '" + txtLocation.ClientID + "','" + txtRoom.ClientID + "','" + txtZone.ClientID + "','" + txtRack.ClientID + "');");
//DR Counterpart
int intDR = oAsset.GetDR(intAsset);
string strDR = oAsset.Get(intDR, "serial");
if (intDR > 0)
{
oDataPoint.LoadTextBox(txtPlatformDRCounterPart, intProfile, btnPlatformDRCounterPart, "/datapoint/asset/datapoint_asset_search.aspx?t=serial&q=" + oFunction.encryptQueryString(strDR) + "&id=" + oFunction.encryptQueryString(intDR.ToString()), lblPlatformDRCounterPart, fldPlatformDRCounterPart, "BLADE_DR", strDR, "", true, false);
}
else
{
oDataPoint.LoadTextBox(txtPlatformDRCounterPart, intProfile, null, "", lblPlatformDRCounterPart, fldPlatformDRCounterPart, "BLADE_DR", "", "", true, false);
}
ddlStatus.SelectedValue = dsAsset.Tables[0].Rows[0]["status"].ToString();
ddlStatus.Enabled = (intAssetAttribute == (int)AssetAttribute.Ok);
panStatus.Visible = (ddlStatus.Enabled == false);
}
else
{
Response.Redirect("/datapoint/asset/enclosure_deploy.aspx?t=serial&q=" + oFunction.encryptQueryString(strSerial) + "&id=" + oFunction.encryptQueryString(intAsset.ToString()) + "&r=0");
}
// Resource Dependencies
AssetOrder oAssetOrder = new AssetOrder(0, dsn, dsnAsset, intEnvironment);
Services oService = new Services(0, dsn);
ServiceRequests oServiceRequest = new ServiceRequests(0, dsn);
rptServiceRequests.DataSource = oAssetOrder.GetByAsset(intAsset, false);
rptServiceRequests.DataBind();
trServiceRequests.Visible = (rptServiceRequests.Items.Count == 0);
foreach (RepeaterItem ri in rptServiceRequests.Items)
{
Label lblServiceID = (Label)ri.FindControl("lblServiceID");
int intService = Int32.Parse(lblServiceID.Text);
Label lblDetails = (Label)ri.FindControl("lblDetails");
Label lblProgress = (Label)ri.FindControl("lblProgress");
if (lblProgress.Text == "")
{
lblProgress.Text = "<i>Unavailable</i>";
}
else
{
int intResource = Int32.Parse(lblProgress.Text);
double dblAllocated = 0.00;
double dblUsed = 0.00;
int intStatus = 0;
bool boolAssigned = false;
DataSet dsResource = oDataPoint.GetServiceRequestResource(intResource);
if (dsResource.Tables[0].Rows.Count > 0)
{
Int32.TryParse(dsResource.Tables[0].Rows[0]["status"].ToString(), out intStatus);
}
foreach (DataRow drResource in dsResource.Tables[1].Rows)
{
boolAssigned = true;
dblAllocated += double.Parse(drResource["allocated"].ToString());
dblUsed += double.Parse(drResource["used"].ToString());
intStatus = Int32.Parse(drResource["status"].ToString());
}
if (intStatus == (int)ResourceRequestStatus.Closed)
{
lblProgress.Text = oServiceRequest.GetStatusBar(100.00, "100", "12", true);
}
else if (intStatus == (int)ResourceRequestStatus.Cancelled)
{
lblProgress.Text = "Cancelled";
}
else if (boolAssigned == false)
{
string strManager = "";
DataSet dsManager = oService.GetUser(intService, 1); // Managers
foreach (DataRow drManager in dsManager.Tables[0].Rows)
{
if (strManager != "")
{
strManager += "\\n";
}
int intManager = Int32.Parse(drManager["userid"].ToString());
strManager += " - " + oUser.GetFullName(intManager) + " [" + oUser.GetName(intManager) + "]";
}
lblProgress.Text = "<a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"alert('This request is pending assignment by the following...\\n\\n" + strManager + "');\">Pending Assignment</a>";
}
else if (dblAllocated > 0.00)
{
lblProgress.Text = oServiceRequest.GetStatusBar((dblUsed / dblAllocated) * 100.00, "100", "12", true);
}
else
{
lblProgress.Text = "<i>N / A</i>";
}
lblDetails.Text = "<a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"OpenNewWindowMenu('/datapoint/service/resource.aspx?id=" + oFunction.encryptQueryString(intResource.ToString()) + "', '800', '600');\">" + lblDetails.Text + "</a>";
}
}
// Provioning History
rptHistory.DataSource = oAsset.GetProvisioningHistory(oDataPoint.AssetHistorySelect(intAsset));
rptHistory.DataBind();
lblHistory.Visible = (rptHistory.Items.Count == 0);
oDataPoint.LoadPanel(panProvisioning, intProfile, fldProvisioning, "ENCLOSURE_STATUS");
// Virtual Connects
rptVirtualConnect.DataSource = oAsset.GetEnclosureVCs(intAsset, 1);
rptVirtualConnect.DataBind();
lblVirtualConnect.Visible = (rptVirtualConnect.Items.Count == 0);
oDataPoint.LoadButton(btnVC, intProfile, fldVC, "ENCLOSURE_VC", "return OpenWindow('ASSET_DEPLOY_VCs','" + intAsset.ToString() + "');");
if (Request.QueryString["highlight"] != null && Request.QueryString["highlight"] != "")
{
intHighlight = Int32.Parse(Request.QueryString["highlight"]);
}
// Blades
rptBlades.DataSource = oAsset.GetEnclosureBlades(intAsset);
rptBlades.DataBind();
lblBlades.Visible = (rptBlades.Items.Count == 0);
// Redeploy
oDataPoint.LoadButton(btnRedeploy, intProfile, fldRedeploy, "ENCLOSURE_REDEPLOY");
if (rptBlades.Items.Count == 0)
{
btnRedeploy.Attributes.Add("onclick", "return confirm('Are you sure you want to redeploy this enclosure?') && confirm('WARNING! Redeploying an asset means that ALL the information regarding this asset will be erased.\\n\\nAre you sure you want to redeploy this enclosure?');");
}
else
{
btnRedeploy.Attributes.Add("onclick", "return confirm('Are you sure you want to redeploy this enclosure?\\n\\WARNING: The blades associated with this enclosure have not been redployed!\\nIt is STRONGLY recommended that you redeploy the blades first to avoid corrupting the asset database.\\n\\nAre you sure you want to continue?');");
}
oDataPoint.LoadButton(btnRedeployBlades, intProfile, fldRedeployBlades, "ENCLOSURE_REDEPLOY_BLADES");
if (rptBlades.Items.Count == 0)
{
btnRedeployBlades.Attributes.Add("onclick", "alert('All blades have already been redeployed');return false;;");
}
else
{
btnRedeployBlades.Attributes.Add("onclick", "return confirm('Are you sure you want to redeploy ALL the blades in this enclosure?') && confirm('WARNING! Redeploying an asset means that ALL the information regarding this asset will be erased.\\n\\nAre you sure you want to redeploy ALL the blades in this enclosure?');");
}
}
}
else
{
if (Request.QueryString["t"] != null && Request.QueryString["q"] != null)
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx?t=" + Request.QueryString["t"] + "&q=" + Request.QueryString["q"] + "&r=0");
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx");
}
}
}
else if (Request.QueryString["q"] != null && Request.QueryString["q"] != "")
{
string strQuery = oFunction.decryptQueryString(Request.QueryString["q"]);
DataSet ds = oDataPoint.GetAssetName(strQuery, intID, 0, "", "", 0);
if (ds.Tables[0].Rows.Count == 1)
{
intAsset = Int32.Parse(ds.Tables[0].Rows[0]["assetid"].ToString());
Response.Redirect(Request.Path + "?t=" + Request.QueryString["t"] + "&q=" + Request.QueryString["q"] + "&id=" + oFunction.encryptQueryString(intAsset.ToString()));
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx?multiple=true&t=" + Request.QueryString["t"] + "&q=" + Request.QueryString["q"]);
}
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx");
}
btnClose.Attributes.Add("onclick", "window.close();return false;");
btnPrint.Attributes.Add("onclick", "window.print();return false;");
btnSave.Attributes.Add("onclick", oDataPoint.LoadValidation());
btnSaveClose.Attributes.Add("onclick", oDataPoint.LoadValidation());
ddlPlatformClass.Attributes.Add("onchange", "PopulateEnvironments('" + ddlPlatformClass.ClientID + "','" + ddlPlatformEnvironment.ClientID + "',0);");
ddlPlatformEnvironment.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlPlatformEnvironment.ClientID + "','" + hdnEnvironment.ClientID + "');");
//ddlLocationState.Attributes.Add("onchange", "LoadLocationCity('" + ddlLocationCity.ClientID + "');LoadLocationAddress('" + ddlLocationAddress.ClientID + "');PopulateCitys('" + ddlLocationState.ClientID + "','" + ddlLocationCity.ClientID + "');ResetDropDownHidden('" + hdnAddress.ClientID + "');");
//ddlLocationCity.Attributes.Add("onchange", "LoadLocationAddress('" + ddlLocationAddress.ClientID + "');PopulateAddresss('" + ddlLocationCity.ClientID + "','" + ddlLocationAddress.ClientID + "');ResetDropDownHidden('" + hdnAddress.ClientID + "');");
//ddlLocationAddress.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlLocationAddress.ClientID + "','" + hdnAddress.ClientID + "');");
}
else
{
panDenied.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
if (Request.Cookies["profileid"] != null && Request.Cookies["profileid"].Value != "")
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
}
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);
}
oDataPoint = new DataPoint(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oServer = new Servers(intProfile, dsn);
oAsset = new Asset(intProfile, dsnAsset);
oForecast = new Forecast(intProfile, dsn);
oPlatform = new Platforms(intProfile, dsn);
oType = new Types(intProfile, dsn);
oModel = new Models(intProfile, dsn);
oModelsProperties = new ModelsProperties(intProfile, dsn);
oIPAddresses = new IPAddresses(intProfile, dsnIP, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oOperatingSystem = new OperatingSystems(intProfile, dsn);
oServicePack = new ServicePacks(intProfile, dsn);
oClass = new Classes(intProfile, dsn);
oEnvironment = new Environments(intProfile, dsn);
oResiliency = new Resiliency(intProfile, dsn);
oSolaris = new Solaris(intProfile, dsn);
oStatusList = new StatusLevels(intProfile, dsn);
if (oUser.IsAdmin(intProfile) == true || (oDataPoint.GetPagePermission(intApplication, "ASSET") == true || intDataPointAvailableAsset == 1))
{
panAllow.Visible = true;
if (Request.QueryString["save"] != null)
{
panSave.Visible = true;
}
if (Request.QueryString["error"] != null)
{
panError.Visible = true;
}
if (Request.QueryString["close"] != null)
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">window.close();<" + "/" + "script>");
}
else if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
string strID = oFunction.decryptQueryString(Request.QueryString["id"]);
DataSet ds = oDataPoint.GetAsset(Int32.Parse(strID));
if (ds.Tables[0].Rows.Count == 1)
{
// Load General Information
intAsset = Int32.Parse(ds.Tables[0].Rows[0]["id"].ToString());
lblAssetID.Text = "#" + intAsset.ToString();
string strSerial = ds.Tables[0].Rows[0]["serial"].ToString();
string strAsset = ds.Tables[0].Rows[0]["asset"].ToString();
string strHeader = (strSerial.Length > 15 ? strSerial.Substring(0, 15) + "..." : strSerial);
lblHeader.Text = """ + strHeader.ToUpper() + """;
Master.Page.Title = "DataPoint | Physical Deploy (" + strHeader + ")";
lblHeaderSub.Text = "Complete the following information to deploy a physical server...";
int intMenuTab = 0;
if (Request.QueryString["menu_tab"] != null && Request.QueryString["menu_tab"] != "")
{
intMenuTab = Int32.Parse(Request.QueryString["menu_tab"]);
}
Tab oTab = new Tab(hdnTab.ClientID, intMenuTab, "divMenu1", true, false);
oTab.AddTab("Asset Information", "");
oTab.AddTab("Location Information", "");
oTab.AddTab("World Wide Port Names", "");
oTab.AddTab("Resource Dependencies", "");
oTab.AddTab("Provisioning History", "");
strMenuTab1 = oTab.GetTabs();
if (oUser.IsAdmin(intProfile) == true || oDataPoint.GetFieldPermission(intProfile, "SERVER_ADMIN") == true)
{
panOldLocationInfo.Visible = true;
}
if (!IsPostBack)
{
LoadList();
// Asset Information
oDataPoint.LoadTextBox(txtPlatformSerial, intProfile, null, "", lblPlatformSerial, fldPlatformSerial, "PHYSICAL_SERIAL", strSerial, "", false, true);
oDataPoint.LoadTextBox(txtPlatformAsset, intProfile, null, "", lblPlatformAsset, fldPlatformAsset, "PHYSICAL_ASSET", strAsset, "", false, true);
int intAssetAttribute = Int32.Parse(oAsset.Get(intAsset, "asset_attribute"));
oDataPoint.LoadDropDown(ddlAssetAttribute, intProfile, null, "", lblAssetAttribute, fldAssetAttribute, "ASSET_ATTRIBUTE", "Name", "AttributeId", oAsset.getAssetAttributes(null, "", 1), intAssetAttribute, true, false, false);
oDataPoint.LoadTextBox(txtAssetAttributeComment, intProfile, null, "", lblAssetAttributeComment, fldAssetAttributeComment, "ASSET_ATTRIBUTE_COMMENT", oAsset.getAssetAttributesComments(intAsset), "", false, true);
ddlAssetAttribute.Attributes.Add("onclick", "return SetControlsForAssetAttributes()");
ddlPlatform.Attributes.Add("onchange", "PopulatePlatformTypes('" + ddlPlatform.ClientID + "','" + ddlPlatformType.ClientID + "','" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformType.Attributes.Add("onchange", "PopulatePlatformModels('" + ddlPlatformType.ClientID + "','" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformModel.Attributes.Add("onchange", "PopulatePlatformModelProperties('" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformModelProperty.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlPlatformModelProperty.ClientID + "','" + hdnModel.ClientID + "');");
int intModel = Int32.Parse(oAsset.Get(intAsset, "modelid"));
int intParent = Int32.Parse(oModelsProperties.Get(intModel, "modelid"));
if (oDataPoint.GetDeployModel(intProfile, intParent) == false && oUser.IsAdmin(intProfile) == false)
{
panAllow.Visible = false;
panDenied.Visible = true;
}
hdnModel.Value = intModel.ToString();
int intModelParent = Int32.Parse(oModelsProperties.Get(intModel, "modelid"));
int intType = oModel.GetType(intModelParent);
int intPlatform = oType.GetPlatform(intType);
oDataPoint.LoadDropDown(ddlPlatform, intProfile, null, "", lblPlatform, fldPlatform, "PHYSICAL_PLATFORM", "name", "platformid", oPlatform.Gets(1), intPlatform, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformType, intProfile, null, "", lblPlatformType, fldPlatformType, "PHYSICAL_TYPE", "name", "id", oType.Gets(intPlatform, 1), intType, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformModel, intProfile, null, "", lblPlatformModel, fldPlatformModel, "PHYSICAL_MODEL", "name", "id", oModel.Gets(intType, 1), intModelParent, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformModelProperty, intProfile, null, "", lblPlatformModelProperty, fldPlatformModelProperty, "PHYSICAL_MODEL_PROP", "name", "id", oModelsProperties.GetModels(0, intModelParent, 1), intModel, false, false, true);
// Get Asset
DataSet dsAsset = oAsset.GetServerOrBlade(intAsset);
if (dsAsset.Tables[0].Rows.Count > 0)
{
Response.Redirect("/datapoint/asset/physical.aspx?t=serial&q=" + oFunction.encryptQueryString(strSerial) + "&id=" + oFunction.encryptQueryString(intAsset.ToString()) + "&r=0");
}
oDataPoint.LoadDropDown(ddlPlatformClass, intProfile, null, "", lblPlatformClass, fldPlatformClass, "PHYSICAL_CLASS", "name", "id", oClass.Gets(1), 0, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformEnvironment, intProfile, null, "", lblPlatformEnvironment, fldPlatformEnvironment, "PHYSICAL_ENVIRONMENT", "name", "id", oClass.GetEnvironment(0, 0), 0, false, false, true);
oDataPoint.LoadTextBox(txtPlatformILO, intProfile, null, "", lblPlatformILO, fldPlatformILO, "PHYSICAL_ILO", "", "", false, true);
oDataPoint.LoadTextBox(txtPlatformDummy, intProfile, null, "", lblPlatformDummy, fldPlatformDummy, "PHYSICAL_DUMMY", "", "", false, true);
oDataPoint.LoadTextBox(txtPlatformMAC, intProfile, null, "", lblPlatformMAC, fldPlatformMAC, "PHYSICAL_MAC", "", "", false, true);
oDataPoint.LoadTextBox(txtPlatformVLAN, intProfile, null, "", lblPlatformVLAN, fldPlatformVLAN, "PHYSICAL_VLAN", "", "", false, true);
oDataPoint.LoadDropDown(ddlPlatformBuildNetwork, intProfile, null, "", lblPlatformBuildNetwork, fldPlatformBuildNetwork, "PHYSICAL_BUILD_NETWORK", "name", "id", oSolaris.GetBuildNetworks(1), 0, false, false, false);
oDataPoint.LoadDropDown(ddlPlatformResiliency, intProfile, null, "", lblPlatformResiliency, fldPlatformResiliency, "PHYSICAL_RESILIENCY", "name", "id", oResiliency.Gets(1), 0, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformOperatingSystemGroup, intProfile, null, "", lblPlatformOperatingSystemGroup, fldPlatformOperatingSystemGroup, "PHYSICAL_OS_GROUP", "name", "id", oOperatingSystem.GetGroups(1), 0, false, false, false);
if (dsAsset.Tables[0].Rows.Count > 0)
{
lblOldlocation.Text = dsAsset.Tables[0].Rows[0]["OldLocation"].ToString();
lblOldRoom.Text = dsAsset.Tables[0].Rows[0]["OldRoom"].ToString();
lblOldRack.Text = dsAsset.Tables[0].Rows[0]["OldRack"].ToString();
txtLocation.Text = dsAsset.Tables[0].Rows[0]["Location"].ToString();
txtRoom.Text = dsAsset.Tables[0].Rows[0]["Room"].ToString();
txtZone.Text = dsAsset.Tables[0].Rows[0]["Zone"].ToString();
txtRack.Text = dsAsset.Tables[0].Rows[0]["Rack"].ToString();
txtRackPosition.Text = dsAsset.Tables[0].Rows[0]["Rackposition"].ToString();
oDataPoint.LoadTextBox(txtRackPosition, intProfile, null, "", lblRackPositionValue, fldLocation, "CHANGE_LOCATION", dsAsset.Tables[0].Rows[0]["rackposition"].ToString(), "", false, true);
hdnRackId.Value = dsAsset.Tables[0].Rows[0]["RackId"].ToString();
}
oDataPoint.LoadButton(btnSelectLocation, intProfile, fldLocation, "CHANGE_LOCATION",
"return LoadLocationRoomRack('" + "rack" + "','" + hdnRackId.ClientID + "', '" + txtLocation.ClientID + "','" + txtRoom.ClientID + "','" + txtZone.ClientID + "','" + txtRack.ClientID + "');");
ddlPlatformStatus.SelectedValue = oAsset.GetStatus(intAsset, "status");
// Resource Dependencies
AssetOrder oAssetOrder = new AssetOrder(0, dsn, dsnAsset, intEnvironment);
Services oService = new Services(0, dsn);
ServiceRequests oServiceRequest = new ServiceRequests(0, dsn);
rptServiceRequests.DataSource = oAssetOrder.GetByAsset(intAsset, false);
rptServiceRequests.DataBind();
trServiceRequests.Visible = (rptServiceRequests.Items.Count == 0);
foreach (RepeaterItem ri in rptServiceRequests.Items)
{
Label lblServiceID = (Label)ri.FindControl("lblServiceID");
int intService = Int32.Parse(lblServiceID.Text);
Label lblDetails = (Label)ri.FindControl("lblDetails");
Label lblProgress = (Label)ri.FindControl("lblProgress");
if (lblProgress.Text == "")
{
lblProgress.Text = "<i>Unavailable</i>";
}
else
{
int intResource = Int32.Parse(lblProgress.Text);
double dblAllocated = 0.00;
double dblUsed = 0.00;
int intStatus = 0;
bool boolAssigned = false;
DataSet dsResource = oDataPoint.GetServiceRequestResource(intResource);
if (dsResource.Tables[0].Rows.Count > 0)
{
Int32.TryParse(dsResource.Tables[0].Rows[0]["status"].ToString(), out intStatus);
}
foreach (DataRow drResource in dsResource.Tables[1].Rows)
{
boolAssigned = true;
dblAllocated += double.Parse(drResource["allocated"].ToString());
dblUsed += double.Parse(drResource["used"].ToString());
intStatus = Int32.Parse(drResource["status"].ToString());
}
if (intStatus == (int)ResourceRequestStatus.Closed)
{
lblProgress.Text = oServiceRequest.GetStatusBar(100.00, "100", "12", true);
}
else if (intStatus == (int)ResourceRequestStatus.Cancelled)
{
lblProgress.Text = "Cancelled";
}
else if (boolAssigned == false)
{
string strManager = "";
DataSet dsManager = oService.GetUser(intService, 1); // Managers
foreach (DataRow drManager in dsManager.Tables[0].Rows)
{
if (strManager != "")
{
strManager += "\\n";
}
int intManager = Int32.Parse(drManager["userid"].ToString());
strManager += " - " + oUser.GetFullName(intManager) + " [" + oUser.GetName(intManager) + "]";
}
lblProgress.Text = "<a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"alert('This request is pending assignment by the following...\\n\\n" + strManager + "');\">Pending Assignment</a>";
}
else if (dblAllocated > 0.00)
{
lblProgress.Text = oServiceRequest.GetStatusBar((dblUsed / dblAllocated) * 100.00, "100", "12", true);
}
else
{
lblProgress.Text = "<i>N / A</i>";
}
lblDetails.Text = "<a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"OpenNewWindowMenu('/datapoint/service/resource.aspx?id=" + oFunction.encryptQueryString(intResource.ToString()) + "', '800', '600');\">" + lblDetails.Text + "</a>";
}
}
// Provioning History
rptHistory.DataSource = oAsset.GetProvisioningHistory(intAsset);
rptHistory.DataBind();
lblHistory.Visible = (rptHistory.Items.Count == 0);
// WWW
rptWWW.DataSource = oAsset.GetHBA(intAsset);
rptWWW.DataBind();
lblWWW.Visible = (rptWWW.Items.Count == 0);
oDataPoint.LoadButton(btnWWW, intProfile, fldWWW, "PHYSICAL_WWW", "return OpenWindow('ASSET_DEPLOY_HBAs','" + intAsset.ToString() + "');");
}
}
else
{
if (Request.QueryString["t"] != null && Request.QueryString["q"] != null)
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx?t=" + Request.QueryString["t"] + "&q=" + Request.QueryString["q"] + "&r=0");
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx");
}
}
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx");
}
btnClose.Attributes.Add("onclick", "window.close();return false;");
btnPrint.Attributes.Add("onclick", "window.print();return false;");
btnDeploy.Attributes.Add("onclick", oDataPoint.LoadValidation());
ddlPlatformClass.Attributes.Add("onchange", "PopulateEnvironments('" + ddlPlatformClass.ClientID + "','" + ddlPlatformEnvironment.ClientID + "',0);");
ddlPlatformEnvironment.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlPlatformEnvironment.ClientID + "','" + hdnEnvironment.ClientID + "');");
}
else
{
panDenied.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
if (Request.Cookies["profileid"] != null && Request.Cookies["profileid"].Value != "")
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
}
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);
}
oDataPoint = new DataPoint(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oServer = new Servers(intProfile, dsn);
oAsset = new Asset(intProfile, dsnAsset);
oWorkstation = new Workstations(intProfile, dsn);
oForecast = new Forecast(intProfile, dsn);
oPlatform = new Platforms(intProfile, dsn);
oType = new Types(intProfile, dsn);
oModel = new Models(intProfile, dsn);
oModelsProperties = new ModelsProperties(intProfile, dsn);
oIPAddresses = new IPAddresses(intProfile, dsnIP, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oOperatingSystem = new OperatingSystems(intProfile, dsn);
oServicePack = new ServicePacks(intProfile, dsn);
oClass = new Classes(intProfile, dsn);
oEnvironment = new Environments(intProfile, dsn);
oDomain = new Domains(intProfile, dsn);
oVirtualHDD = new VirtualHDD(intProfile, dsn);
oVirtualRam = new VirtualRam(intProfile, dsn);
oZeus = new Zeus(intProfile, dsnZeus);
oLog = new Log(intProfile, dsn);
oService = new Services(intProfile, dsn);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
if (oUser.IsAdmin(intProfile) == true || (oDataPoint.GetPagePermission(intApplication, "ASSET") == true || intDataPointAvailableAsset == 1))
{
panAllow.Visible = true;
if (Request.QueryString["save"] != null)
{
panSave.Visible = true;
}
if (Request.QueryString["error"] != null)
{
panError.Visible = true;
// -100: More than one device name
// -10: No device names
// -5: Improper Name Format
// -1: ServerID = 0
if (Request.QueryString["error"] == "-100")
{
lblError.Text = "More than one name";
}
else if (Request.QueryString["error"] == "-10")
{
lblError.Text = "User Cancelled Prompt";
}
else if (Request.QueryString["error"] == "-5")
{
lblError.Text = "Name is in Incorrect Format";
}
else if (Request.QueryString["error"] == "-1")
{
lblError.Text = "DeviceID = 0";
}
else
{
lblError.Text = "Generic Error";
}
}
Int32.TryParse(oFunction.decryptQueryString(Request.QueryString["id"]), out intID);
if (Request.QueryString["close"] != null)
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">window.close();<" + "/" + "script>");
}
else if (intID > 0)
{
DataSet ds = oDataPoint.GetAsset(intID);
if (ds.Tables[0].Rows.Count == 1)
{
// Load General Information
intAsset = Int32.Parse(ds.Tables[0].Rows[0]["id"].ToString());
lblAssetID.Text = "#" + intAsset.ToString();
string strSerial = ds.Tables[0].Rows[0]["serial"].ToString();
string strAsset = ds.Tables[0].Rows[0]["asset"].ToString();
string strHeader = (strSerial.Length > 15 ? strSerial.Substring(0, 15) + "..." : strSerial);
lblHeader.Text = """ + strHeader.ToUpper() + """;
Master.Page.Title = "DataPoint | VMware Workstation (" + strHeader + ")";
lblHeaderSub.Text = "Provides all the information about a VMware Workstation...";
int intMenuTab = 0;
if (Request.QueryString["menu_tab"] != null && Request.QueryString["menu_tab"] != "")
{
intMenuTab = Int32.Parse(Request.QueryString["menu_tab"]);
}
Tab oTab = new Tab(hdnTab.ClientID, intMenuTab, "divMenu1", true, false);
oTab.AddTab("Asset Information", "");
oTab.AddTab("Guest Information", "");
oTab.AddTab("Account Information", "");
oTab.AddTab("Resource Dependencies", "");
oTab.AddTab("Provisioning Information", "");
if (oUser.IsAdmin(intProfile) == true || oDataPoint.GetFieldPermission(intProfile, "SERVER_ADMIN") == true)
{
oTab.AddTab("Administration", "");
panAdministration.Visible = true;
}
strMenuTab1 = oTab.GetTabs();
if (!IsPostBack)
{
// Asset Information
oDataPoint.LoadTextBox(txtPlatformSerial, intProfile, null, "", lblPlatformSerial, fldPlatformSerial, "WORKSTATION_VMWARE_SERIAL", strSerial, "", false, true);
oDataPoint.LoadTextBox(txtPlatformAsset, intProfile, null, "", lblPlatformAsset, fldPlatformAsset, "WORKSTATION_VMWARE_ASSET", strAsset, "", false, true);
int intAssetAttribute = Int32.Parse(oAsset.Get(intAsset, "asset_attribute"));
oDataPoint.LoadDropDown(ddlAssetAttribute, intProfile, null, "", lblAssetAttribute, fldAssetAttribute, "ASSET_ATTRIBUTE", "Name", "AttributeId", oAsset.getAssetAttributes(null, "", 1), intAssetAttribute, true, false, false);
oDataPoint.LoadTextBox(txtAssetAttributeComment, intProfile, null, "", lblAssetAttributeComment, fldAssetAttributeComment, "ASSET_ATTRIBUTE_COMMENT", oAsset.getAssetAttributesComments(intAsset), "", false, true);
ddlAssetAttribute.Attributes.Add("onclick", "return SetControlsForAssetAttributes()");
ddlPlatform.Attributes.Add("onchange", "PopulatePlatformTypes('" + ddlPlatform.ClientID + "','" + ddlPlatformType.ClientID + "','" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformType.Attributes.Add("onchange", "PopulatePlatformModels('" + ddlPlatformType.ClientID + "','" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformModel.Attributes.Add("onchange", "PopulatePlatformModelProperties('" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformModelProperty.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlPlatformModelProperty.ClientID + "','" + hdnModel.ClientID + "');");
int intModel = Int32.Parse(oAsset.Get(intAsset, "modelid"));
hdnModel.Value = intModel.ToString();
int intModelParent = Int32.Parse(oModelsProperties.Get(intModel, "modelid"));
int intType = oModel.GetType(intModelParent);
string strExecute = oType.Get(intType, "forecast_execution_path");
if (strExecute != "")
{
DataSet dsVirtual = oWorkstation.GetVirtualAsset(intAsset);
if (dsVirtual.Tables[0].Rows.Count > 0)
{
btnExecute.Attributes.Add("onclick", "return OpenWindow('FORECAST_EXECUTE','" + strExecute + "?id=" + dsVirtual.Tables[0].Rows[0]["answerid"].ToString() + "');");
}
else
{
btnExecute.Enabled = false;
}
}
else
{
btnExecute.Enabled = false;
}
int intPlatform = oType.GetPlatform(intType);
oDataPoint.LoadDropDown(ddlPlatform, intProfile, null, "", lblPlatform, fldPlatform, "WORKSTATION_VMWARE_PLATFORM", "name", "platformid", oPlatform.Gets(1), intPlatform, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformType, intProfile, null, "", lblPlatformType, fldPlatformType, "WORKSTATION_VMWARE_TYPE", "name", "id", oType.Gets(intPlatform, 1), intType, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformModel, intProfile, null, "", lblPlatformModel, fldPlatformModel, "WORKSTATION_VMWARE_MODEL", "name", "id", oModel.Gets(intType, 1), intModelParent, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformModelProperty, intProfile, null, "", lblPlatformModelProperty, fldPlatformModelProperty, "WORKSTATION_VMWARE_MODEL_PROP", "name", "id", oModelsProperties.GetModels(0, intModelParent, 1), intModel, false, false, true);
// Get Asset
int intWorkstation = 0;
DataSet dsAsset = oWorkstation.GetVirtualAsset(intAsset);
if (dsAsset.Tables[0].Rows.Count > 0)
{
intWorkstation = Int32.Parse(dsAsset.Tables[0].Rows[0]["id"].ToString());
lblWorkstation.Text = intWorkstation.ToString();
txtStep.Text = dsAsset.Tables[0].Rows[0]["step"].ToString();
oDataPoint.LoadTextBoxDeviceName(txtName, btnName, null, true, hdnPNC, intProfile, null, "", lblName, fldName, "WORKSTATION_VMWARE_NAME", dsAsset.Tables[0].Rows[0]["name"].ToString(), "", false, false);
if (txtName.Text != "")
{
lblHeader.Text += " [" + txtName.Text + "]";
}
lblStatus.Text = dsAsset.Tables[0].Rows[0]["statusname"].ToString();
// Administrative Functions
if (Request.QueryString["admin"] != null)
{
if (Request.QueryString["result"] != null)
{
strAdministration = "<tr><td>" + oFunction.decryptQueryString(Request.QueryString["result"]) + "</td></tr>";
}
if (Request.QueryString["output"] != null)
{
DataSet dsOutput = oWorkstation.GetVirtualOutput(intWorkstation);
foreach (DataRow drOutput in dsOutput.Tables[0].Rows)
{
strAdministration += "<tr><td><a href=\"javascript:void(0);\" onclick=\"ShowHideDiv2('div" + drOutput["id"].ToString() + "');\">" + drOutput["type"].ToString() + "</a></td></tr>";
strAdministration += "<tr id=\"div" + drOutput["id"].ToString() + "\" style=\"display:none\"><td>" + oFunction.FormatText(drOutput["output"].ToString()) + "</td></tr>";
}
if (lblStatus.Text != "")
{
strAdministration += "<tr><td>" + oLog.GetEvents(oLog.GetEventsByName(txtName.Text.ToUpper(), (int)LoggingType.Error), intEnvironment) + "</td></tr>";
}
}
}
int intClass = Int32.Parse(dsAsset.Tables[0].Rows[0]["classid"].ToString());
int intEnv = Int32.Parse(dsAsset.Tables[0].Rows[0]["environmentid"].ToString());
hdnEnvironment.Value = intEnv.ToString();
oDataPoint.LoadDropDown(ddlPlatformClass, intProfile, null, "", lblPlatformClass, fldPlatformClass, "WORKSTATION_VMWARE_CLASS", "name", "id", oClass.GetWorkstationVMwares(1), intClass, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformEnvironment, intProfile, null, "", lblPlatformEnvironment, fldPlatformEnvironment, "WORKSTATION_VMWARE_ENVIRONMENT", "name", "id", oClass.GetEnvironment(intClass, 0), intEnv, false, false, true);
ddlStatus.SelectedValue = dsAsset.Tables[0].Rows[0]["status"].ToString();
ddlStatus.Enabled = (intAssetAttribute == (int)AssetAttribute.Ok);
panStatus.Visible = (ddlStatus.Enabled == false);
int intOS = Int32.Parse(dsAsset.Tables[0].Rows[0]["osid"].ToString());
bool boolXP = (oOperatingSystem.Get(intOS, "code") == "XP");
bool boolWin7 = (oOperatingSystem.Get(intOS, "code") == "7");
oDataPoint.LoadDropDown(ddlPlatformOS, intProfile, null, "", lblPlatformOS, fldPlatformOS, "WORKSTATION_VMWARE_OS", "name", "id", oOperatingSystem.Gets(1, 1), intOS, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformServicePack, intProfile, null, "", lblPlatformServicePack, fldPlatformServicePack, "WORKSTATION_VMWARE_SP", "name", "id", oOperatingSystem.GetServicePack(intOS), Int32.Parse(dsAsset.Tables[0].Rows[0]["spid"].ToString()), false, false, true);
oDataPoint.LoadDropDown(ddlPlatformDomain, intProfile, null, "", lblPlatformDomain, fldPlatformDomain, "WORKSTATION_VMWARE_DOMAIN", "name", "id", oDomain.Gets(1), Int32.Parse(dsAsset.Tables[0].Rows[0]["domainid"].ToString()), false, false, true);
oDataPoint.LoadDropDown(ddlPlatformHDD, intProfile, null, "", lblPlatformHDD, fldPlatformHDD, "WORKSTATION_VMWARE_HDD", "name", "id", oVirtualHDD.GetVMwares((boolXP ? 1 : 0), (boolWin7 ? 1 : 0), 1), Int32.Parse(dsAsset.Tables[0].Rows[0]["hddid"].ToString()), false, false, true);
oDataPoint.LoadDropDown(ddlPlatformRam, intProfile, null, "", lblPlatformRam, fldPlatformRam, "WORKSTATION_VMWARE_RAM", "name", "id", oVirtualRam.GetVMwares((boolXP ? 1 : 0), (boolWin7 ? 1 : 0), 1), Int32.Parse(dsAsset.Tables[0].Rows[0]["ramid"].ToString()), false, false, true);
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx");
}
// Get Host
oDataPoint.LoadTextBox(txtHostName, intProfile, btnHostName, "/datapoint/asset/server.aspx?t=name&q=" + oFunction.encryptQueryString(dsAsset.Tables[0].Rows[0]["hostname"].ToString()), lblHostName, fldHostName, "WORKSTATION_VMWARE_HOST", dsAsset.Tables[0].Rows[0]["hostname"].ToString(), "", false, false);
if (Request.Cookies["virtual_guest"] != null && Request.Cookies["virtual_guest"].Value != "")
{
string strHost = "";
string strFind = txtName.Text;
//strFind = "ohcleapp103d";
DateTime datStart = DateTime.Parse(Request.Cookies["virtual_guest"].Value);
Response.Cookies["virtual_guest"].Value = "";
VMWare oVMWare = new VMWare(intProfile, dsn);
string strConnect = oVMWare.Connect(strFind);
VimService _service = oVMWare.GetService();
ServiceContent _sic = oVMWare.GetSic();
try
{
ManagedObjectReference oVM = oVMWare.GetVM(strFind);
ManagedObjectReference oParent = (ManagedObjectReference)oVMWare.getObjectProperty(oVM, "parent");
ManagedObjectReference oDataCenter = (ManagedObjectReference)oVMWare.getObjectProperty(oParent, "parent");
string strDataCenter = (string)oVMWare.getObjectProperty(oDataCenter, "name");
GuestInfo ginfo = (GuestInfo)oVMWare.getObjectProperty(oVM, "guest");
lblGuestState.Text = ginfo.guestState;
GuestNicInfo[] nInfo = ginfo.net;
foreach (GuestNicInfo nic in nInfo)
{
string[] strIPAddresses = nic.ipAddress;
foreach (string strIPAddress in strIPAddresses)
{
if (lblIPAddress.Text != "")
{
lblIPAddress.Text += ", ";
}
lblIPAddress.Text += strIPAddress;
}
if (lblMACAddress.Text != "")
{
lblMACAddress.Text += ", ";
}
lblMACAddress.Text += nic.macAddress;
if (lblNetwork.Text != "")
{
lblNetwork.Text += ", ";
}
lblNetwork.Text += nic.network;
}
// HDD
GuestDiskInfo[] oVMDisks = ginfo.disk;
foreach (GuestDiskInfo oDisk in oVMDisks)
{
if (lblHDD.Text != "")
{
lblHDD.Text += "<br/>";
}
double dblCapacity = double.Parse(oDisk.capacity.ToString());
dblCapacity = dblCapacity / 1024.00;
dblCapacity = dblCapacity / 1024.00;
dblCapacity = dblCapacity / 1024.00;
double dblAvailable = double.Parse(oDisk.freeSpace.ToString());
dblAvailable = dblAvailable / 1024.00;
dblAvailable = dblAvailable / 1024.00;
dblAvailable = dblAvailable / 1024.00;
lblHDD.Text += oDisk.diskPath + " " + dblCapacity.ToString("F") + " GB (" + dblAvailable.ToString("F") + " GB available)";
}
// Status
VirtualMachineSummary oVMSummary = (VirtualMachineSummary)oVMWare.getObjectProperty(oVM, "summary");
ManagedEntityStatus oVMStatus = oVMSummary.overallStatus;
//lblOverallStatus.Text = (string)oVMStatus;
lblOverallStatus.Text = Enum.GetName(typeof(ManagedEntityStatus), (ManagedEntityStatus)oVMStatus);
// RAM & CPUs & Host
VirtualMachineConfigSummary oVMConfig = oVMSummary.config;
lblRAM.Text = oVMConfig.memorySizeMB.ToString();
lblCPUs.Text = oVMConfig.numCpu.ToString();
VirtualMachineRuntimeInfo oVMRuntime = oVMSummary.runtime;
ManagedObjectReference oVMHost = oVMRuntime.host;
strHost = (string)oVMWare.getObjectProperty(oVMHost, "name");
if (strHost.IndexOf(".") > -1)
{
strHost = strHost.Substring(0, strHost.IndexOf("."));
}
lblVirtualCenter.Text = oVMWare.VirtualCenter();
lblDataCenter.Text = oVMWare.DataCenter();
}
catch { }
finally
{
if (_service != null)
{
_service.Abort();
if (_service.Container != null)
{
_service.Container.Dispose();
}
try
{
_service.Logout(_sic.sessionManager);
}
catch { }
_service.Dispose();
_service = null;
_sic = null;
}
}
if (strHost != "")
{
panGuestYes.Visible = true;
oDataPoint.LoadTextBox(txtHostName, intProfile, btnHostName, "/datapoint/asset/server.aspx?t=name&q=" + oFunction.encryptQueryString(strHost), lblHostName, fldHostName, "WORKSTATION_VMWARE_HOST", strHost, "", false, false);
}
else
{
panGuestNo.Visible = true;
}
TimeSpan oSpan = DateTime.Now.Subtract(datStart);
btnGuestQuery.Enabled = false;
btnGuestQuery.Text = "Query Time: " + oSpan.TotalSeconds.ToString("0") + " seconds...";
}
oDataPoint.LoadPanel(panGuestQuery, intProfile, fldHostQuery, "WORKSTATION_VMWARE_HOST_QUERY");
// Account Information
DataSet dsAccounts = oWorkstation.GetAccountsVMware(intWorkstation);
rptAccounts.DataSource = dsAccounts;
rptAccounts.DataBind();
lblNone.Visible = (rptAccounts.Items.Count == 0);
// Resource Dependencies
rptServiceRequests.DataSource = ds.Tables[1];
rptServiceRequests.DataBind();
trServiceRequests.Visible = (rptServiceRequests.Items.Count == 0);
foreach (RepeaterItem ri in rptServiceRequests.Items)
{
Label lblRequestID = (Label)ri.FindControl("lblRequestID");
Label lblServiceID = (Label)ri.FindControl("lblServiceID");
Label lblNumber = (Label)ri.FindControl("lblNumber");
int intService = Int32.Parse(lblServiceID.Text);
Label lblDetails = (Label)ri.FindControl("lblDetails");
Label lblProgress = (Label)ri.FindControl("lblProgress");
if (lblProgress.Text == "")
{
lblProgress.Text = "<i>Unavailable</i>";
}
else
{
int intResource = Int32.Parse(lblProgress.Text);
//lblProgress.Text = oResourceRequest.GetStatus(Int32.Parse(lblRequestID.Text), Int32.Parse(lblServiceID.Text), Int32.Parse(lblNumber.Text), true, true, dsnServiceEditor, dsnAsset, intServiceDecommission);
lblProgress.Text = oResourceRequest.GetStatus(null, null, Int32.Parse(lblRequestID.Text), Int32.Parse(lblServiceID.Text), null, Int32.Parse(lblNumber.Text), true, dsnServiceEditor)[0].status;
/*
* double dblAllocated = 0.00;
* double dblUsed = 0.00;
* int intStatus = 0;
* bool boolAssigned = false;
* DataSet dsResource = oDataPoint.GetServiceRequestResource(intResource);
* if (dsResource.Tables[0].Rows.Count > 0)
* Int32.TryParse(dsResource.Tables[0].Rows[0]["status"].ToString(), out intStatus);
* foreach (DataRow drResource in dsResource.Tables[1].Rows)
* {
* boolAssigned = true;
* dblAllocated += double.Parse(drResource["allocated"].ToString());
* dblUsed += double.Parse(drResource["used"].ToString());
* intStatus = Int32.Parse(drResource["status"].ToString());
* }
* if (intStatus == (int)ResourceRequestStatus.Closed)
* lblProgress.Text = oServiceRequest.GetStatusBar(100.00, "100", "12", true);
* else if (intStatus == (int)ResourceRequestStatus.Cancelled)
* lblProgress.Text = "Cancelled";
* else if (boolAssigned == false)
* {
* string strManager = "";
* DataSet dsManager = oService.GetUser(intService, 1); // Managers
* foreach (DataRow drManager in dsManager.Tables[0].Rows)
* {
* if (strManager != "")
* strManager += "\\n";
* int intManager = Int32.Parse(drManager["userid"].ToString());
* strManager += " - " + oUser.GetFullName(intManager) + " [" + oUser.GetName(intManager) + "]";
* }
* lblProgress.Text = "<a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"alert('This request is pending assignment by the following...\\n\\n" + strManager + "');\">Pending Assignment</a>";
* }
* else if (dblAllocated > 0.00)
* lblProgress.Text = oServiceRequest.GetStatusBar((dblUsed / dblAllocated) * 100.00, "100", "12", true);
* else
* lblProgress.Text = "<i>N / A</i>";
*/
lblDetails.Text = "<a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"OpenNewWindowMenu('/datapoint/service/resource.aspx?id=" + oFunction.encryptQueryString(intResource.ToString()) + "', '800', '600');\">" + lblDetails.Text + "</a>";
}
}
// Provioning History
rptHistory.DataSource = SqlHelper.ExecuteDataset(dsnAsset, CommandType.Text, oDataPoint.AssetHistorySelect(intAsset));
rptHistory.DataBind();
lblHistory.Visible = (rptHistory.Items.Count == 0);
oDataPoint.LoadPanel(panProvisioning, intProfile, fldProvisioning, "WORKSTATION_VMWARE_STATUS");
}
}
else
{
if (Request.QueryString["t"] != null && Request.QueryString["q"] != null)
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx?t=" + Request.QueryString["t"] + "&q=" + Request.QueryString["q"] + "&r=0");
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx");
}
}
}
else if (Request.QueryString["q"] != null && Request.QueryString["q"] != "")
{
string strQuery = oFunction.decryptQueryString(Request.QueryString["q"]);
DataSet ds = oDataPoint.GetAssetName(strQuery, intID, 0, "", "", 0);
if (ds.Tables[0].Rows.Count == 1)
{
intAsset = Int32.Parse(ds.Tables[0].Rows[0]["assetid"].ToString());
Response.Redirect(Request.Path + "?t=" + Request.QueryString["t"] + "&q=" + Request.QueryString["q"] + "&id=" + oFunction.encryptQueryString(intAsset.ToString()));
}
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx");
}
btnClose.Attributes.Add("onclick", "window.close();return false;");
btnPrint.Attributes.Add("onclick", "window.print();return false;");
btnName.Attributes.Add("onclick", "return OpenWindow('DEVICE_NAME','?assetid=" + intAsset.ToString() + "');");
btnSave.Attributes.Add("onclick", oDataPoint.LoadValidation("ProcessControlButton()"));
btnSaveClose.Attributes.Add("onclick", oDataPoint.LoadValidation("ProcessControlButton()"));
ddlPlatformClass.Attributes.Add("onchange", "PopulateEnvironments('" + ddlPlatformClass.ClientID + "','" + ddlPlatformEnvironment.ClientID + "',0);");
ddlPlatformEnvironment.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlPlatformEnvironment.ClientID + "','" + hdnEnvironment.ClientID + "');");
btnGuestQuery.Attributes.Add("onclick", "ProcessButton(this,'Querying... please be patient...','225') && ProcessControlButton();");
btnOutput.Attributes.Add("onclick", "return ProcessButton(this) && ProcessControlButton();");
}
else
{
panDenied.Visible = true;
}
}
private void LoadList()
{
string strBind = "";
if (lblType.Text == "PLAT")
{
ds = oPlatform.Gets(1);
lstOrder.DataValueField = "platformid";
}
if (lblType.Text == "ORG")
{
ds = oOrganization.Gets(1);
lstOrder.DataValueField = "organizationid";
}
if (lblType.Text == "COST")
{
ds = oCost.Gets(1);
lstOrder.DataValueField = "costid";
}
if (lblType.Text == "AT")
{
ds = oUserAt.Gets(1);
lstOrder.DataValueField = "atid";
}
if (lblType.Text == "ITEMS")
{
ds = oRequestItem.GetItems(Int32.Parse(lblId.Text), 0, 1);
lstOrder.DataValueField = "itemid";
}
if (lblType.Text == "SERVICEDETAIL")
{
ds = oServiceDetail.Gets(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "SERVICES")
{
int intFolder = Int32.Parse(oService.GetFolders(Int32.Parse(lblId.Text), "folderid"));
ds = oService.Gets(intFolder, 1, 1, 1, 0);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "SERVICE_FOLDERS")
{
ds = oService.GetFolders(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "REPORTS")
{
ds = oReport.Gets(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "reportid";
strBind = "title";
}
if (lblType.Text == "A_SITE")
{
ds = oSites.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "A_TYPE")
{
ds = oType.Gets(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "A_MODEL")
{
ds = oModel.Gets(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "A_LOCATION_S")
{
ds = oDepot.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "A_SHELF")
{
ds = oShelf.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "A_RACK")
{
ds = oRacks.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "CLASS")
{
ds = oClasses.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "A_ROOM")
{
ds = oRooms.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "A_FLOOR")
{
ds = oFloor.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "ENVIRONMENT")
{
ds = oEnvironment.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "S_CODE")
{
ds = oSolution.GetCodes(1);
lstOrder.DataValueField = "id";
strBind = "code";
}
if (lblType.Text == "F_QUESTION")
{
ds = oForecast.GetQuestions(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "F_RESPONSE")
{
ds = oForecast.GetResponses(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "F_LINE_ITEMS")
{
ds = oForecast.GetLineItems(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "CONFIDENCE")
{
ds = oConfidence.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "LOCATION_S")
{
ds = oLocation.GetStates(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "F_STEPS")
{
ds = oForecast.GetSteps(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "F_STEPS_ADD")
{
ds = oForecast.GetStepAdditionals(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "FIELD")
{
ds = oField.Gets(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
strBind = "fieldname";
}
if (lblType.Text == "DOMAIN_CONTROLLER")
{
ds = oDomainController.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "DOMAIN")
{
ds = oDomain.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "SERVERNAME_A")
{
ds = oServerName.GetApplications(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "SERVERNAME_SUBA")
{
ds = oServerName.GetSubApplications(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "SERVERNAME_C")
{
ds = oServerName.GetComponents(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "WORKSTATION_C")
{
ds = oWorkstation.GetComponents(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "OPERATING_SYSTEM")
{
ds = oOperatingSystems.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "OD_W_STEPS")
{
ds = oOnDemand.GetWizardSteps(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "OD_STEPS")
{
ds = oOnDemand.GetSteps(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "SERVICE_PACK")
{
ds = oServicePack.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "COMPONENT_SCRIPTS")
{
ds = oServerName.GetComponentDetailScripts(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "HOST")
{
ds = oHost.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "VIRTUAL_HDD")
{
ds = oVirtualHDD.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "VIRTUAL_RAM")
{
ds = oVirtualRam.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "RESTART")
{
ds = oRestart.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "SEGMENT")
{
ds = oSegment.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "DOMAIN_SUFFIX")
{
ds = oDomain.GetSuffixs(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "DOMAIN_ADMIN_GROUP")
{
ds = oDomain.GetAdminGroups(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "SERVICE_EDITOR_FIELDS")
{
ds = oServiceEditor.GetFields(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "PROJECT_REQUEST_QUESTION")
{
ds = oProjectRequest.GetQuestions(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "PROJECT_REQUEST_RESPONSE")
{
ds = oProjectRequest.GetResponses(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "PROJECT_REQUEST_CLASS")
{
ds = oProjectRequest.GetClasses(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "VMWARE_TEMPLATE")
{
ds = oVMWare.GetTemplates(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "ORDER_REPORT_DATASOURCE")
{
ds = oReport.GetDataSources(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "ORDER_REPORT_CHARTS")
{
ds = oReport.GetCharts(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "PLATFORM_FORM")
{
ds = oPlatform.GetForms(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
//if (lblType.Text == "NEW")
//{
// ds = oNew.Gets(1);
// lstOrder.DataValueField = "id";
// strBind = "title";
//}
if (lblType.Text == "WHATSNEW")
{
ds = oWhatsNew.Gets(1);
lstOrder.DataValueField = "id";
strBind = "title";
}
//if (lblType.Text == "RECOVERY_LOCATIONS")
//{
// ds = oRecoveryLocations.Gets(1);
// lstOrder.DataValueField = "id";
//}
if (lblType.Text == "MAINTENANCE_WINDOW")
{
ds = oMaintenanceWindow.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "TSM")
{
ds = oTSM.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "TSM_DOMAINS")
{
ds = oTSM.GetDomains(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "TSM_SCHEDULES")
{
ds = oTSM.GetSchedules(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "DNS")
{
ds = oDNS.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "SOLARIS_BUILD_NETWORKS")
{
ds = oSolaris.GetBuildNetworks(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "SOLARIS_BUILD_TYPES")
{
ds = oSolaris.GetBuildTypes(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "SOLARIS_INTERFACES")
{
ds = oSolaris.GetInterfaces(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "ZEUS_ARRAY_CONFIGS")
{
ds = oZeus.GetArrayConfigs(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "ZEUS_BUILD_TYPES")
{
ds = oZeus.GetBuildTypes(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "ERROR_TYPES")
{
ds = oError.GetTypes(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "ERROR_TYPES_TYPES")
{
ds = oError.GetTypeTypes(Int32.Parse(lblId.Text), 1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "D_PHASES")
{
ds = oDesign.GetPhases(1);
strBind = "title";
lstOrder.DataValueField = "id";
}
if (lblType.Text == "D_QUESTIONS")
{
ds = oDesign.GetQuestions(Int32.Parse(lblId.Text), 1);
strBind = "summary";
lstOrder.DataValueField = "id";
}
if (lblType.Text == "D_RESPONSES")
{
ds = oDesign.GetResponses(Int32.Parse(lblId.Text), 0, 1);
strBind = "admin";
lstOrder.DataValueField = "id";
}
if (lblType.Text == "D_MODELS")
{
ds = oDesign.GetModels(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "RESILIENCY")
{
ds = oResiliency.Gets(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "ENHANCEMENT_MODULES")
{
ds = oEnhancement.GetModules(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "OPERATING_SYSTEM_GROUPS")
{
ds = oOperatingSystems.GetGroups(1);
lstOrder.DataValueField = "id";
}
if (lblType.Text == "DESIGN_APPROVE_CONDITION")
{
ds = oDesign.GetApprovalConditionals(1);
lstOrder.DataValueField = "id";
}
if (strBind == "")
{
strBind = "name";
}
lstOrder.DataTextField = strBind;
lstOrder.DataSource = ds;
lstOrder.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
if (Request.Cookies["profileid"] != null && Request.Cookies["profileid"].Value != "")
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
}
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);
}
oDataPoint = new DataPoint(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oServer = new Servers(intProfile, dsn);
oAsset = new Asset(intProfile, dsnAsset);
oWorkstation = new Workstations(intProfile, dsn);
oForecast = new Forecast(intProfile, dsn);
oPlatform = new Platforms(intProfile, dsn);
oType = new Types(intProfile, dsn);
oModel = new Models(intProfile, dsn);
oModelsProperties = new ModelsProperties(intProfile, dsn);
oIPAddresses = new IPAddresses(intProfile, dsnIP, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oOperatingSystem = new OperatingSystems(intProfile, dsn);
oServicePack = new ServicePacks(intProfile, dsn);
oClass = new Classes(intProfile, dsn);
oEnvironment = new Environments(intProfile, dsn);
oDomain = new Domains(intProfile, dsn);
oVirtualHDD = new VirtualHDD(intProfile, dsn);
oVirtualRam = new VirtualRam(intProfile, dsn);
if (oUser.IsAdmin(intProfile) == true || (oDataPoint.GetPagePermission(intApplication, "ASSET") == true || intDataPointAvailableAsset == 1))
{
panAllow.Visible = true;
if (Request.QueryString["save"] != null)
{
panSave.Visible = true;
}
if (Request.QueryString["error"] != null)
{
panError.Visible = true;
// -100: More than one device name
// -10: No device names
// -5: Improper Name Format
// -1: ServerID = 0
if (Request.QueryString["error"] == "-100")
{
lblError.Text = "More than one name";
}
else if (Request.QueryString["error"] == "-10")
{
lblError.Text = "User Cancelled Prompt";
}
else if (Request.QueryString["error"] == "-5")
{
lblError.Text = "Name is in Incorrect Format";
}
else if (Request.QueryString["error"] == "-1")
{
lblError.Text = "DeviceID = 0";
}
else
{
lblError.Text = "Generic Error";
}
}
Int32.TryParse(oFunction.decryptQueryString(Request.QueryString["id"]), out intID);
if (Request.QueryString["close"] != null)
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">window.close();<" + "/" + "script>");
}
else if (intID > 0)
{
DataSet ds = oDataPoint.GetAsset(intID);
if (ds.Tables[0].Rows.Count == 1)
{
// Load General Information
intAsset = Int32.Parse(ds.Tables[0].Rows[0]["id"].ToString());
lblAssetID.Text = "#" + intAsset.ToString();
string strSerial = ds.Tables[0].Rows[0]["serial"].ToString();
string strAsset = ds.Tables[0].Rows[0]["asset"].ToString();
string strHeader = (strSerial.Length > 15 ? strSerial.Substring(0, 15) + "..." : strSerial);
lblHeader.Text = """ + strHeader.ToUpper() + """;
Master.Page.Title = "DataPoint | Virtual Workstation (" + strHeader + ")";
lblHeaderSub.Text = "Provides all the information about a Microsoft Virtual Workstation...";
int intMenuTab = 0;
if (Request.QueryString["menu_tab"] != null && Request.QueryString["menu_tab"] != "")
{
intMenuTab = Int32.Parse(Request.QueryString["menu_tab"]);
}
Tab oTab = new Tab(hdnTab.ClientID, intMenuTab, "divMenu1", true, false);
oTab.AddTab("Asset Information", "");
oTab.AddTab("Host Information", "");
oTab.AddTab("Account Information", "");
oTab.AddTab("Provisioning Information", "");
strMenuTab1 = oTab.GetTabs();
if (!IsPostBack)
{
// Asset Information
oDataPoint.LoadTextBox(txtPlatformSerial, intProfile, null, "", lblPlatformSerial, fldPlatformSerial, "WORKSTATION_VIRTUAL_SERIAL", strSerial, "", false, true);
oDataPoint.LoadTextBox(txtPlatformAsset, intProfile, null, "", lblPlatformAsset, fldPlatformAsset, "WORKSTATION_VIRTUAL_ASSET", strAsset, "", false, true);
int intAssetAttribute = Int32.Parse(oAsset.Get(intAsset, "asset_attribute"));
oDataPoint.LoadDropDown(ddlAssetAttribute, intProfile, null, "", lblAssetAttribute, fldAssetAttribute, "ASSET_ATTRIBUTE", "Name", "AttributeId", oAsset.getAssetAttributes(null, "", 1), intAssetAttribute, true, false, false);
oDataPoint.LoadTextBox(txtAssetAttributeComment, intProfile, null, "", lblAssetAttributeComment, fldAssetAttributeComment, "ASSET_ATTRIBUTE_COMMENT", oAsset.getAssetAttributesComments(intAsset), "", false, true);
ddlAssetAttribute.Attributes.Add("onclick", "return SetControlsForAssetAttributes()");
ddlPlatform.Attributes.Add("onchange", "PopulatePlatformTypes('" + ddlPlatform.ClientID + "','" + ddlPlatformType.ClientID + "','" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformType.Attributes.Add("onchange", "PopulatePlatformModels('" + ddlPlatformType.ClientID + "','" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformModel.Attributes.Add("onchange", "PopulatePlatformModelProperties('" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformModelProperty.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlPlatformModelProperty.ClientID + "','" + hdnModel.ClientID + "');");
int intModel = Int32.Parse(oAsset.Get(intAsset, "modelid"));
hdnModel.Value = intModel.ToString();
int intModelParent = Int32.Parse(oModelsProperties.Get(intModel, "modelid"));
int intType = oModel.GetType(intModelParent);
int intPlatform = oType.GetPlatform(intType);
oDataPoint.LoadDropDown(ddlPlatform, intProfile, null, "", lblPlatform, fldPlatform, "WORKSTATION_VIRTUAL_PLATFORM", "name", "platformid", oPlatform.Gets(1), intPlatform, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformType, intProfile, null, "", lblPlatformType, fldPlatformType, "WORKSTATION_VIRTUAL_TYPE", "name", "id", oType.Gets(intPlatform, 1), intType, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformModel, intProfile, null, "", lblPlatformModel, fldPlatformModel, "WORKSTATION_VIRTUAL_MODEL", "name", "id", oModel.Gets(intType, 1), intModelParent, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformModelProperty, intProfile, null, "", lblPlatformModelProperty, fldPlatformModelProperty, "WORKSTATION_VIRTUAL_MODEL_PROP", "name", "id", oModelsProperties.GetModels(0, intModelParent, 1), intModel, false, false, true);
// Get Asset
DataSet dsAsset = oWorkstation.GetVirtualAsset(intAsset);
if (dsAsset.Tables[0].Rows.Count > 0)
{
oDataPoint.LoadTextBoxDeviceName(txtName, btnName, null, true, hdnPNC, intProfile, null, "", lblName, fldName, "WORKSTATION_VIRTUAL_NAME", dsAsset.Tables[0].Rows[0]["name"].ToString(), "", false, false);
if (txtName.Text != "")
{
lblHeader.Text += " [" + txtName.Text + "]";
}
lblStatus.Text = dsAsset.Tables[0].Rows[0]["statusname"].ToString();
int intClass = Int32.Parse(dsAsset.Tables[0].Rows[0]["classid"].ToString());
int intEnv = Int32.Parse(dsAsset.Tables[0].Rows[0]["environmentid"].ToString());
hdnEnvironment.Value = intEnv.ToString();
oDataPoint.LoadDropDown(ddlPlatformClass, intProfile, null, "", lblPlatformClass, fldPlatformClass, "WORKSTATION_VIRTUAL_CLASS", "name", "id", oClass.Gets(1), intClass, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformEnvironment, intProfile, null, "", lblPlatformEnvironment, fldPlatformEnvironment, "WORKSTATION_VIRTUAL_ENVIRONMENT", "name", "id", oClass.GetEnvironment(intClass, 0), intEnv, false, false, true);
ddlStatus.SelectedValue = dsAsset.Tables[0].Rows[0]["status"].ToString();
ddlStatus.Enabled = (intAssetAttribute == (int)AssetAttribute.Ok);
panStatus.Visible = (ddlStatus.Enabled == false);
int intOS = Int32.Parse(dsAsset.Tables[0].Rows[0]["osid"].ToString());
oDataPoint.LoadDropDown(ddlPlatformOS, intProfile, null, "", lblPlatformOS, fldPlatformOS, "WORKSTATION_VIRTUAL_OS", "name", "id", oOperatingSystem.Gets(1, 1), intOS, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformServicePack, intProfile, null, "", lblPlatformServicePack, fldPlatformServicePack, "WORKSTATION_VIRTUAL_SP", "name", "id", oOperatingSystem.GetServicePack(intOS), Int32.Parse(dsAsset.Tables[0].Rows[0]["spid"].ToString()), false, false, true);
oDataPoint.LoadDropDown(ddlPlatformDomain, intProfile, null, "", lblPlatformDomain, fldPlatformDomain, "WORKSTATION_VIRTUAL_DOMAIN", "name", "id", oDomain.Gets(1), Int32.Parse(dsAsset.Tables[0].Rows[0]["domainid"].ToString()), false, false, true);
oDataPoint.LoadDropDown(ddlPlatformHDD, intProfile, null, "", lblPlatformHDD, fldPlatformHDD, "WORKSTATION_VIRTUAL_HDD", "name", "id", oVirtualHDD.GetVirtuals(1), Int32.Parse(dsAsset.Tables[0].Rows[0]["hddid"].ToString()), false, false, true);
oDataPoint.LoadDropDown(ddlPlatformRam, intProfile, null, "", lblPlatformRam, fldPlatformRam, "WORKSTATION_VIRTUAL_RAM", "name", "id", oVirtualRam.GetVirtuals(1), Int32.Parse(dsAsset.Tables[0].Rows[0]["ramid"].ToString()), false, false, true);
lblCPUs.Text = "1";
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx");
}
// Get Host
oDataPoint.LoadTextBox(txtHostName, intProfile, btnHostName, "/datapoint/asset/server.aspx?t=name&q=" + oFunction.encryptQueryString(dsAsset.Tables[0].Rows[0]["hostname"].ToString()), lblHostName, fldHostName, "WORKSTATION_VIRTUAL_HOST", dsAsset.Tables[0].Rows[0]["hostname"].ToString(), "", false, false);
// Account Information
DataSet dsAccounts = oWorkstation.GetAccountsVirtual(intAsset);
rptAccounts.DataSource = dsAccounts;
rptAccounts.DataBind();
lblNone.Visible = (rptAccounts.Items.Count == 0);
// Provioning History
rptHistory.DataSource = SqlHelper.ExecuteDataset(dsnAsset, CommandType.Text, oDataPoint.AssetHistorySelect(intAsset));
rptHistory.DataBind();
lblHistory.Visible = (rptHistory.Items.Count == 0);
oDataPoint.LoadPanel(panProvisioning, intProfile, fldProvisioning, "WORKSTATION_VIRTUAL_STATUS");
}
}
else
{
if (Request.QueryString["t"] != null && Request.QueryString["q"] != null)
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx?t=" + Request.QueryString["t"] + "&q=" + Request.QueryString["q"] + "&r=0");
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx");
}
}
}
else if (Request.QueryString["q"] != null && Request.QueryString["q"] != "")
{
string strQuery = oFunction.decryptQueryString(Request.QueryString["q"]);
DataSet ds = oDataPoint.GetAssetName(strQuery, intID, 0, "", "", 0);
if (ds.Tables[0].Rows.Count == 1)
{
intAsset = Int32.Parse(ds.Tables[0].Rows[0]["assetid"].ToString());
Response.Redirect(Request.Path + "?t=" + Request.QueryString["t"] + "&q=" + Request.QueryString["q"] + "&id=" + oFunction.encryptQueryString(intAsset.ToString()));
}
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx");
}
btnClose.Attributes.Add("onclick", "window.close();return false;");
btnPrint.Attributes.Add("onclick", "window.print();return false;");
btnName.Attributes.Add("onclick", "return OpenWindow('DEVICE_NAME','?assetid=" + intAsset.ToString() + "');");
btnSave.Attributes.Add("onclick", oDataPoint.LoadValidation("ProcessControlButton()"));
btnSaveClose.Attributes.Add("onclick", oDataPoint.LoadValidation("ProcessControlButton()"));
ddlPlatformClass.Attributes.Add("onchange", "PopulateEnvironments('" + ddlPlatformClass.ClientID + "','" + ddlPlatformEnvironment.ClientID + "',0);");
ddlPlatformEnvironment.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlPlatformEnvironment.ClientID + "','" + hdnEnvironment.ClientID + "');");
}
else
{
panDenied.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
if (Request.Cookies["profileid"] != null && Request.Cookies["profileid"].Value != "")
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
}
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);
}
oDataPoint = new DataPoint(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oServer = new Servers(intProfile, dsn);
oAsset = new Asset(intProfile, dsnAsset);
oForecast = new Forecast(intProfile, dsn);
oPlatform = new Platforms(intProfile, dsn);
oType = new Types(intProfile, dsn);
oModel = new Models(intProfile, dsn);
oModelsProperties = new ModelsProperties(intProfile, dsn);
oIPAddresses = new IPAddresses(intProfile, dsnIP, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oOperatingSystem = new OperatingSystems(intProfile, dsn);
oServicePack = new ServicePacks(intProfile, dsn);
oClass = new Classes(intProfile, dsn);
oEnvironment = new Environments(intProfile, dsn);
if (oUser.IsAdmin(intProfile) == true || (oDataPoint.GetPagePermission(intApplication, "ASSET") == true || intDataPointAvailableAsset == 1))
{
panAllow.Visible = true;
if (Request.QueryString["save"] != null)
{
panSave.Visible = true;
}
if (Request.QueryString["error"] != null)
{
panError.Visible = true;
// -100: More than one device name
// -10: No device names
// -5: Improper Name Format
// -1: ServerID = 0
if (Request.QueryString["error"] == "-100")
{
lblError.Text = "More than one name";
}
else if (Request.QueryString["error"] == "-10")
{
lblError.Text = "User Cancelled Prompt";
}
else if (Request.QueryString["error"] == "-5")
{
lblError.Text = "Name is in Incorrect Format";
}
else if (Request.QueryString["error"] == "-1")
{
lblError.Text = "DeviceID = 0";
}
else
{
lblError.Text = "Generic Error";
}
}
Int32.TryParse(oFunction.decryptQueryString(Request.QueryString["id"]), out intID);
if (Request.QueryString["close"] != null)
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">window.close();<" + "/" + "script>");
}
else if (intID > 0)
{
DataSet ds = oDataPoint.GetAsset(intID);
if (ds.Tables[0].Rows.Count == 1)
{
// Load General Information
intAsset = Int32.Parse(ds.Tables[0].Rows[0]["id"].ToString());
lblAssetID.Text = "#" + intAsset.ToString();
string strSerial = ds.Tables[0].Rows[0]["serial"].ToString();
string strAsset = ds.Tables[0].Rows[0]["asset"].ToString();
string strHeader = (strSerial.Length > 15 ? strSerial.Substring(0, 15) + "..." : strSerial);
lblHeader.Text = """ + strHeader.ToUpper() + """;
Master.Page.Title = "DataPoint | VMware (" + strHeader + ")";
lblHeaderSub.Text = "Provides all the information about a VMware guest...";
int intMenuTab = 0;
if (Request.QueryString["menu_tab"] != null && Request.QueryString["menu_tab"] != "")
{
intMenuTab = Int32.Parse(Request.QueryString["menu_tab"]);
}
Tab oTab = new Tab(hdnTab.ClientID, intMenuTab, "divMenu1", true, false);
oTab.AddTab("Asset Information", "");
oTab.AddTab("Host Information", "");
oTab.AddTab("Resource Dependencies", "");
oTab.AddTab("Provisioning Information", "");
//oTab.AddTab("Network Adapter Configuration", "");
strMenuTab1 = oTab.GetTabs();
if (!IsPostBack)
{
//DataSet dsAssets = oServer.GetAsset(intAsset);
//foreach (DataRow drAsset in dsAssets.Tables[0].Rows)
//{
// if (drAsset["latest"].ToString() == "1")
// {
// intAsset = Int32.Parse(drAsset["assetid"].ToString());
// intAssetClass = Int32.Parse(drAsset["classid"].ToString());
// intAssetEnv = Int32.Parse(drAsset["environmentid"].ToString());
// break;
// }
//}
// Asset Information
oDataPoint.LoadTextBox(txtPlatformSerial, intProfile, null, "", lblPlatformSerial, fldPlatformSerial, "VMWARE_SERIAL", strSerial, "", false, true);
oDataPoint.LoadTextBox(txtPlatformAsset, intProfile, null, "", lblPlatformAsset, fldPlatformAsset, "VMWARE_ASSET", strAsset, "", false, true);
int intAssetAttribute = 0;
Int32.TryParse(oAsset.Get(intAsset, "asset_attribute"), out intAssetAttribute);
oDataPoint.LoadDropDown(ddlAssetAttribute, intProfile, null, "", lblAssetAttribute, fldAssetAttribute, "ASSET_ATTRIBUTE", "Name", "AttributeId", oAsset.getAssetAttributes(null, "", 1), intAssetAttribute, true, false, false);
oDataPoint.LoadTextBox(txtAssetAttributeComment, intProfile, null, "", lblAssetAttributeComment, fldAssetAttributeComment, "ASSET_ATTRIBUTE_COMMENT", oAsset.getAssetAttributesComments(intAsset), "", false, true);
ddlAssetAttribute.Attributes.Add("onclick", "return SetControlsForAssetAttributes()");
ddlPlatform.Attributes.Add("onchange", "PopulatePlatformTypes('" + ddlPlatform.ClientID + "','" + ddlPlatformType.ClientID + "','" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformType.Attributes.Add("onchange", "PopulatePlatformModels('" + ddlPlatformType.ClientID + "','" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformModel.Attributes.Add("onchange", "PopulatePlatformModelProperties('" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformModelProperty.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlPlatformModelProperty.ClientID + "','" + hdnModel.ClientID + "');");
int intModel = 0;
Int32.TryParse(oAsset.Get(intAsset, "modelid"), out intModel);
hdnModel.Value = intModel.ToString();
int intModelParent = 0;
Int32.TryParse(oModelsProperties.Get(intModel, "modelid"), out intModelParent);
int intType = oModel.GetType(intModelParent);
int intPlatform = oType.GetPlatform(intType);
oDataPoint.LoadDropDown(ddlPlatform, intProfile, null, "", lblPlatform, fldPlatform, "VMWARE_PLATFORM", "name", "platformid", oPlatform.Gets(1), intPlatform, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformType, intProfile, null, "", lblPlatformType, fldPlatformType, "VMWARE_TYPE", "name", "id", oType.Gets(intPlatform, 1), intType, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformModel, intProfile, null, "", lblPlatformModel, fldPlatformModel, "VMWARE_MODEL", "name", "id", oModel.Gets(intType, 1), intModelParent, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformModelProperty, intProfile, null, "", lblPlatformModelProperty, fldPlatformModelProperty, "VMWARE_MODEL_PROP", "name", "id", oModelsProperties.GetModels(0, intModelParent, 1), intModel, false, false, true);
// Get Asset
DataSet dsAsset = oAsset.GetGuest(intAsset);
if (dsAsset.Tables[0].Rows.Count > 0)
{
oDataPoint.LoadTextBoxDeviceName(txtName, btnName, null, true, hdnPNC, intProfile, btnNameLookup, "/datapoint/asset/datapoint_asset_search.aspx?t=name&q=" + oFunction.encryptQueryString(dsAsset.Tables[0].Rows[0]["name"].ToString()), lblName, fldName, "VMWARE_NAME", dsAsset.Tables[0].Rows[0]["name"].ToString(), "", false, false);
if (txtName.Text != "")
{
lblHeader.Text += " [" + txtName.Text + "]";
}
lblStatus.Text = dsAsset.Tables[0].Rows[0]["statusname"].ToString();
int intClass = Int32.Parse(dsAsset.Tables[0].Rows[0]["classid"].ToString());
int intEnv = Int32.Parse(dsAsset.Tables[0].Rows[0]["environmentid"].ToString());
hdnEnvironment.Value = intEnv.ToString();
oDataPoint.LoadDropDown(ddlPlatformClass, intProfile, null, "", lblPlatformClass, fldPlatformClass, "VMWARE_CLASS", "name", "id", oClass.Gets(1), intClass, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformEnvironment, intProfile, null, "", lblPlatformEnvironment, fldPlatformEnvironment, "VMWARE_ENVIRONMENT", "name", "id", oClass.GetEnvironment(intClass, 0), intEnv, false, false, true);
ddlStatus.SelectedValue = dsAsset.Tables[0].Rows[0]["status"].ToString();
ddlStatus.Enabled = (intAssetAttribute == (int)AssetAttribute.Ok);
panStatus.Visible = (ddlStatus.Enabled == false);
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx");
}
// Get Original Detail
VMWare oVMWare = new VMWare(intProfile, dsn);
DataSet dsGuest = oVMWare.GetGuest(dsAsset.Tables[0].Rows[0]["name"].ToString());
if (dsGuest.Tables[0].Rows.Count > 0)
{
panVMWare.Visible = true;
DataRow drGuest = dsGuest.Tables[0].Rows[0];
int intDatastore = Int32.Parse(drGuest["datastoreid"].ToString());
lblBuildDataStore.Text = oVMWare.GetDatastore(intDatastore, "name");
int intHost = Int32.Parse(drGuest["hostid"].ToString());
lblBuildHost.Text = oVMWare.GetHost(intHost, "name");
int intCluster = Int32.Parse(oVMWare.GetHost(intHost, "clusterid"));
lblBuildCluster.Text = oVMWare.GetCluster(intCluster, "name");
int intFolder = Int32.Parse(oVMWare.GetCluster(intCluster, "folderid"));
lblBuildFolder.Text = oVMWare.GetFolder(intFolder, "name");
int intDataCenter = Int32.Parse(oVMWare.GetFolder(intFolder, "datacenterid"));
lblBuildDataCenter.Text = oVMWare.GetDatacenter(intDataCenter, "name");
int intVirtualCenter = Int32.Parse(oVMWare.GetDatacenter(intDataCenter, "virtualcenterid"));
lblBuildVirtualCenter.Text = oVMWare.GetVirtualCenter(intVirtualCenter, "name");
// Get Host
if (Request.Cookies["host"] != null && Request.Cookies["host"].Value != "")
{
string strHost = "";
string strFind = txtName.Text;
//strFind = "ohcleapp103d";
DateTime datStart = DateTime.Parse(Request.Cookies["host"].Value);
Response.Cookies["host"].Value = "";
//VMWare oVMWare = new VMWare(intProfile, dsn);
DataSet dsVirtualCenter = oVMWare.GetVirtualCenters(1);
foreach (DataRow drVirtualCenter in dsVirtualCenter.Tables[0].Rows)
{
intVirtualCenter = Int32.Parse(drVirtualCenter["id"].ToString());
string strVirtualCenter = drVirtualCenter["name"].ToString();
string strVirtualCenterURL = drVirtualCenter["url"].ToString();
int intVirtualCenterEnv = Int32.Parse(drVirtualCenter["environment"].ToString());
DataSet dsDataCenter = oVMWare.GetDatacenters(intVirtualCenter, 1);
foreach (DataRow drDataCenter in dsDataCenter.Tables[0].Rows)
{
intDataCenter = Int32.Parse(drDataCenter["id"].ToString());
string strDataCenter = drDataCenter["name"].ToString();
string strConnect = oVMWare.ConnectDEBUG(strVirtualCenterURL, intVirtualCenterEnv, strDataCenter);
VimService _service = oVMWare.GetService();
ServiceContent _sic = oVMWare.GetSic();
try
{
ManagedObjectReference oVM = oVMWare.GetVM(strFind);
GuestInfo ginfo = (GuestInfo)oVMWare.getObjectProperty(oVM, "guest");
lblGuestName.Text = ginfo.guestFullName;
lblGuestState.Text = ginfo.guestState;
GuestNicInfo[] nInfo = ginfo.net;
foreach (GuestNicInfo nic in nInfo)
{
string[] strIPAddresses = nic.ipAddress;
foreach (string strIPAddress in strIPAddresses)
{
if (lblIPAddress.Text != "")
{
lblIPAddress.Text += ", ";
}
lblIPAddress.Text += strIPAddress;
}
if (lblMACAddress.Text != "")
{
lblMACAddress.Text += ", ";
}
lblMACAddress.Text += nic.macAddress;
if (lblNetwork.Text != "")
{
lblNetwork.Text += ", ";
}
lblNetwork.Text += nic.network;
}
VirtualMachineConfigInfo vminfo = (VirtualMachineConfigInfo)oVMWare.getObjectProperty(oVM, "config");
VirtualMachineSummary oVMSummary = (VirtualMachineSummary)oVMWare.getObjectProperty(oVM, "summary");
VirtualMachineConfigSummary oVMConfig = oVMSummary.config;
lblRAM.Text = oVMConfig.memorySizeMB.ToString();
lblCPUs.Text = oVMConfig.numCpu.ToString();
lblPath.Text = oVMConfig.vmPathName;
VirtualMachineRuntimeInfo oVMRuntime = oVMSummary.runtime;
ManagedObjectReference oVMHost = oVMRuntime.host;
strHost = (string)oVMWare.getObjectProperty(oVMHost, "name");
if (strHost.IndexOf(".") > -1)
{
strHost = strHost.Substring(0, strHost.IndexOf("."));
}
lblVirtualCenter.Text = strVirtualCenter;
lblDataCenter.Text = strDataCenter;
break;
}
catch { }
finally
{
if (_service != null)
{
_service.Abort();
if (_service.Container != null)
{
_service.Container.Dispose();
}
try
{
_service.Logout(_sic.sessionManager);
}
catch { }
_service.Dispose();
_service = null;
_sic = null;
}
}
}
}
if (strHost != "")
{
oDataPoint.LoadTextBox(txtHostName, intProfile, btnHostName, "/datapoint/asset/server.aspx?t=name&q=" + oFunction.encryptQueryString(strHost), lblHostName, fldHostName, "VMWARE_HOST", strHost, "", false, false);
}
else
{
panHostNo.Visible = true;
}
TimeSpan oSpan = DateTime.Now.Subtract(datStart);
btnHostQuery.Enabled = false;
btnHostQuery.Text = "Query Time: " + oSpan.TotalSeconds.ToString("0") + " seconds...";
}
else
{
txtHostName.Visible = false;
lblHostName.Text = "---";
lblDataCenter.Text = "---";
lblVirtualCenter.Text = "---";
}
oDataPoint.LoadPanel(panHostQuery, intProfile, fldHostQuery, "VMWARE_HOST_QUERY");
}
else
{
Solaris oSolaris = new Solaris(intProfile, dsn);
DataSet dsServers = oServer.GetAssetsAsset(intAsset);
foreach (DataRow drServer in dsServers.Tables[0].Rows)
{
DataSet dsSVE = oSolaris.GetSVEGuest(Int32.Parse(drServer["serverid"].ToString()));
if (dsSVE.Tables[0].Rows.Count > 0)
{
panSVE.Visible = true;
int intCluster = Int32.Parse(dsSVE.Tables[0].Rows[0]["clusterid"].ToString());
lblSVECluster.Text = oSolaris.GetSVECluster(intCluster, "name");
}
}
}
// Resource Dependencies
AssetOrder oAssetOrder = new AssetOrder(0, dsn, dsnAsset, intEnvironment);
Services oService = new Services(0, dsn);
ServiceRequests oServiceRequest = new ServiceRequests(0, dsn);
rptServiceRequests.DataSource = oAssetOrder.GetByAsset(intAsset, false);
rptServiceRequests.DataBind();
trServiceRequests.Visible = (rptServiceRequests.Items.Count == 0);
foreach (RepeaterItem ri in rptServiceRequests.Items)
{
Label lblServiceID = (Label)ri.FindControl("lblServiceID");
int intService = Int32.Parse(lblServiceID.Text);
Label lblDetails = (Label)ri.FindControl("lblDetails");
Label lblProgress = (Label)ri.FindControl("lblProgress");
if (lblProgress.Text == "")
{
lblProgress.Text = "<i>Unavailable</i>";
}
else
{
int intResource = Int32.Parse(lblProgress.Text);
double dblAllocated = 0.00;
double dblUsed = 0.00;
int intStatus = 0;
bool boolAssigned = false;
DataSet dsResource = oDataPoint.GetServiceRequestResource(intResource);
if (dsResource.Tables[0].Rows.Count > 0)
{
Int32.TryParse(dsResource.Tables[0].Rows[0]["status"].ToString(), out intStatus);
}
foreach (DataRow drResource in dsResource.Tables[1].Rows)
{
boolAssigned = true;
dblAllocated += double.Parse(drResource["allocated"].ToString());
dblUsed += double.Parse(drResource["used"].ToString());
intStatus = Int32.Parse(drResource["status"].ToString());
}
if (intStatus == (int)ResourceRequestStatus.Closed)
{
lblProgress.Text = oServiceRequest.GetStatusBar(100.00, "100", "12", true);
}
else if (intStatus == (int)ResourceRequestStatus.Cancelled)
{
lblProgress.Text = "Cancelled";
}
else if (boolAssigned == false)
{
string strManager = "";
DataSet dsManager = oService.GetUser(intService, 1); // Managers
foreach (DataRow drManager in dsManager.Tables[0].Rows)
{
if (strManager != "")
{
strManager += "\\n";
}
int intManager = Int32.Parse(drManager["userid"].ToString());
strManager += " - " + oUser.GetFullName(intManager) + " [" + oUser.GetName(intManager) + "]";
}
lblProgress.Text = "<a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"alert('This request is pending assignment by the following...\\n\\n" + strManager + "');\">Pending Assignment</a>";
}
else if (dblAllocated > 0.00)
{
lblProgress.Text = oServiceRequest.GetStatusBar((dblUsed / dblAllocated) * 100.00, "100", "12", true);
}
else
{
lblProgress.Text = "<i>N / A</i>";
}
lblDetails.Text = "<a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"OpenNewWindowMenu('/datapoint/service/resource.aspx?id=" + oFunction.encryptQueryString(intResource.ToString()) + "', '800', '600');\">" + lblDetails.Text + "</a>";
}
}
// Provioning History
rptHistory.DataSource = oAsset.GetProvisioningHistory(oDataPoint.AssetHistorySelect(intAsset));
rptHistory.DataBind();
lblHistory.Visible = (rptHistory.Items.Count == 0);
oDataPoint.LoadPanel(panProvisioning, intProfile, fldProvisioning, "VMWARE_STATUS");
}
}
else
{
if (Request.QueryString["t"] != null && Request.QueryString["q"] != null)
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx?t=" + Request.QueryString["t"] + "&q=" + Request.QueryString["q"] + "&r=0");
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx");
}
}
}
else if (Request.QueryString["q"] != null && Request.QueryString["q"] != "")
{
string strQuery = oFunction.decryptQueryString(Request.QueryString["q"]);
DataSet ds = oDataPoint.GetAssetName(strQuery, intID, 0, "", "", 0);
if (ds.Tables[0].Rows.Count == 1)
{
intID = Int32.Parse(ds.Tables[0].Rows[0]["id"].ToString());
Response.Redirect(Request.Path + "?t=" + Request.QueryString["t"] + "&q=" + Request.QueryString["q"] + "&id=" + oFunction.encryptQueryString(intID.ToString()));
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx?multiple=true&t=" + Request.QueryString["t"] + "&q=" + Request.QueryString["q"]);
}
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx");
}
btnClose.Attributes.Add("onclick", "window.close();return false;");
btnPrint.Attributes.Add("onclick", "window.print();return false;");
btnName.Attributes.Add("onclick", "return OpenWindow('DEVICE_NAME','?assetid=" + intAsset.ToString() + "');");
btnSave.Attributes.Add("onclick", oDataPoint.LoadValidation("ProcessControlButton()"));
btnSaveClose.Attributes.Add("onclick", oDataPoint.LoadValidation("ProcessControlButton()"));
ddlPlatformClass.Attributes.Add("onchange", "PopulateEnvironments('" + ddlPlatformClass.ClientID + "','" + ddlPlatformEnvironment.ClientID + "',0);");
ddlPlatformEnvironment.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlPlatformEnvironment.ClientID + "','" + hdnEnvironment.ClientID + "');");
btnHostQuery.Attributes.Add("onclick", "ProcessButton(this,'Querying... please be patient...','225') && ProcessControlButton();");
}
else
{
panDenied.Visible = true;
}
}