protected string LoadGroup(int _platformid, DataTable _demand, string _additional_filter)
{
string strGroup = "";
//DataSet dsTypes = oType.Gets(_platformid, 1);
DataSet dsTypes = oType.Gets(intPlatformServer, 1);
int intDemand = 0;
foreach (DataRow drType in dsTypes.Tables[0].Rows)
{
DataSet dsModels = oModelsProperties.GetTypes(1, Int32.Parse(drType["id"].ToString()), 1);
foreach (DataRow drModel in dsModels.Tables[0].Rows)
{
int intHost = -1;
if (drModel["hostid"].ToString() != "")
{
intHost = Int32.Parse(drModel["hostid"].ToString());
}
int intModel = Int32.Parse(drModel["id"].ToString());
int intPorts = Int32.Parse(oModelsProperties.Get(intModel, "network_ports"));
DataRow[] drModels = _demand.Select("model = " + intModel.ToString() + strFilter + _additional_filter);
if (intHost == 0)
{
int intModels = drModels.Length;
intModels = intModels * intPorts;
intDemand += intModels;
}
}
}
strGroup += "<tr class=\"" + (intDemand > 0 ? "greendefault" : (intDemand < 0 ? "reddefault" : "default")) + "\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>Ports:</td><td width=\"100%\">" + oServiceRequest.GetStatusBarFill(((double.Parse(intDemand.ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300") + "</td><td nowrap>" + intDemand.ToString() + "</td></tr>";
if (strGroup != "")
{
strGroup = "<table width=\"100%\" cellpadding=\"4\" cellspacing=\"0\" border=\"0\">" + strGroup + "</table>";
}
return(strGroup);
}
private void LoadLists()
{
int intPlatform = 0;
if (Request.QueryString["pid"] != null && Request.QueryString["pid"] != "")
{
intPlatform = Int32.Parse(Request.QueryString["pid"]);
}
if (oPlatform.Get(intPlatform).Tables[0].Rows.Count > 0)
{
int intType = 0;
if (Request.QueryString["tid"] != null && Request.QueryString["tid"] != "")
{
intType = Int32.Parse(Request.QueryString["tid"]);
}
if (oType.Get(intType).Tables[0].Rows.Count > 0)
{
ddlModel.Items.Clear();
ddlModel.DataValueField = "id";
ddlModel.DataTextField = "name";
ddlModel.DataSource = oModelsProperties.GetTypes(1, intType, 1);
ddlModel.DataBind();
if (Request.QueryString["mid"] != null && Request.QueryString["mid"] != "")
{
ddlModel.SelectedValue = Request.QueryString["mid"];
}
ddlDepot.DataValueField = "id";
ddlDepot.DataTextField = "name";
ddlDepot.DataSource = oDepot.Gets(1);
ddlDepot.DataBind();
}
}
ddlModel.Items.Insert(0, new ListItem("-- SELECT --", "0"));
ddlDepot.Items.Insert(0, new ListItem("-- SELECT --", "0"));
}
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();
}
protected void Page_Load(object sender, EventArgs e)
{
string strDirectory = Request.PhysicalApplicationPath + "images\\temp\\barcode";
if (Directory.Exists(strDirectory) == false)
{
Directory.CreateDirectory(strDirectory);
}
else
{
DirectoryInfo oDir = new DirectoryInfo(strDirectory);
DirectoryInfo[] oDirs = oDir.GetDirectories();
System.IO.FileInfo[] oFiles = oDir.GetFiles();
foreach (System.IO.FileInfo oFile in oFiles)
{
if ((File.GetAttributes(strDirectory + "\\" + oFile.Name) & FileAttributes.ReadOnly) != FileAttributes.ReadOnly)
{
File.Delete(strDirectory + "\\" + oFile.Name);
}
}
}
oModelsProperties = new ModelsProperties(0, dsn);
int intCol = 0;
if (Request.QueryString["modelid"] != null)
{
string strFile = LoadImage(Int32.Parse(Request.QueryString["modelid"]), strDirectory);
strCodes1 = "<p><img src=\"/images/temp/barcode/" + strFile + "\" border=\"0\" align=\"absmiddle\"/></p>";
}
else if (Request.QueryString["id"] != null)
{
DataSet ds = oModelsProperties.GetTypes(0, Int32.Parse(Request.QueryString["id"]), 1);
foreach (DataRow dr in ds.Tables[0].Rows)
{
intCol++;
string strFile = LoadImage(Int32.Parse(dr["id"].ToString()), strDirectory);
if (intCol == 3)
{
intCol = 1;
}
if (intCol == 1)
{
strCodes1 += "<p class=\"header\">" + dr["name"].ToString() + "<br/><img src=\"/images/temp/barcode/" + strFile + "\" border=\"0\" align=\"absmiddle\"/></p>";
}
else if (intCol == 2)
{
strCodes2 += "<p class=\"header\">" + dr["name"].ToString() + "<br/><img src=\"/images/temp/barcode/" + strFile + "\" border=\"0\" align=\"absmiddle\"/></p>";
}
else if (intCol == 3)
{
strCodes3 += "<p class=\"header\">" + dr["name"].ToString() + "<br/><img src=\"/images/temp/barcode/" + strFile + "\" border=\"0\" align=\"absmiddle\"/></p>";
}
}
}
}
protected int LoadPlatform(int _platformid, int _typeid, int _classid, int _environmentid, int _addressid)
{
int intCount = 0;
ddlTypes.DataTextField = "name";
ddlTypes.DataValueField = "id";
ddlTypes.DataSource = oType.Gets(_platformid, 1);
ddlTypes.DataBind();
ddlTypes.Items.Insert(0, new ListItem("-- SELECT --", "0"));
if (_typeid > 0)
{
ddlTypes.SelectedValue = _typeid.ToString();
panModels.Visible = true;
ddlModels.DataTextField = "name";
ddlModels.DataValueField = "id";
DataSet ds = oModelsProperties.GetTypes(1, _typeid, 1);
if (ds.Tables[0].Rows.Count > 0)
{
// ddlModels.DataSource = ds;
ddlModels.DataSource = oModel.GetLocation(_classid, _environmentid, _addressid, _typeid);
}
else
{
ddlModels.DataSource = oModel.Gets(_typeid, 1);
}
ddlModels.DataBind();
ddlModels.Items.Insert(0, new ListItem("-- SELECT --", "0"));
ddlRam.DataTextField = "name";
ddlRam.DataValueField = "id";
ddlRam.DataSource = oVirtualRam.GetVMwares(1);
ddlRam.DataBind();
ddlRam.Items.Insert(0, new ListItem("-- SELECT --", "0"));
ddlOS.DataTextField = "name";
ddlOS.DataValueField = "id";
ddlOS.DataSource = oOperatingSystems.Gets(1, 1);
ddlOS.DataBind();
ddlOS.Items.Insert(0, new ListItem("-- SELECT --", "0"));
ddlCPU.DataTextField = "name";
ddlCPU.DataValueField = "id";
ddlCPU.DataSource = oVirtualCPU.GetVMwares(1);
ddlCPU.DataBind();
ddlCPU.Items.Insert(0, new ListItem("-- SELECT --", "0"));
ddlHardDrive.DataTextField = "name";
ddlHardDrive.DataValueField = "id";
ddlHardDrive.DataSource = oVirtualHDD.GetVMwares(1);
ddlHardDrive.DataBind();
ddlHardDrive.Items.Insert(0, new ListItem("-- SELECT --", "0"));
intCount = ddlModels.Items.Count;
}
return(intCount);
}
private void LoadGroup(int _platformid, DataTable _demand, string _additional_filter)
{
foreach (DataRow drType in _demand.Rows)
{
bool boolPhysical = false;
bool boolBlade = false;
bool boolOther = false;
int intOldHost = -1;
DataSet dsModels = oModelsProperties.GetTypes(1, Int32.Parse(drType["id"].ToString()), 1);
foreach (DataRow drModel in dsModels.Tables[0].Rows)
{
boolOther = !boolOther;
int intBlade = Int32.Parse(drModel["blade"].ToString());
int intHost = -1;
if (drModel["hostid"].ToString() != "")
{
intHost = Int32.Parse(drModel["hostid"].ToString());
}
string strType = "Unknown";
if (intBlade == 1)
{
strType = "Blade";
if (boolBlade == false)
{
if (strSupply != "")
{
strSupply += "<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>";
}
strSupply += "<tr><td colspan=\"4\" class=\"bold\">" + strType + "</td></tr>";
boolBlade = true;
}
}
else if (intHost == 0)
{
strType = "Physical";
if (boolPhysical == false)
{
if (strSupply != "")
{
strSupply += "<tr><td colspan=\"4\"><p> </p><p> </p></td></tr>";
}
strSupply += "<tr><td colspan=\"4\" class=\"header\">" + drType["name"].ToString() + "</td></tr>";
strSupply += "<tr><td colspan=\"4\" class=\"bold\">" + strType + "</td></tr>";
boolPhysical = true;
}
}
else if (intOldHost != intHost)
{
strType = drModel["host"].ToString();
if (intHost > 0)
{
if (strSupply != "")
{
strSupply += "<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>";
}
strSupply += "<tr><td colspan=\"4\" class=\"bold\">" + strType + "</td></tr>";
intOldHost = intHost;
}
}
int intModel = Int32.Parse(drModel["id"].ToString());
// Supply
DataSet dsModel = oAsset.GetCount(intModel, (int)AssetStatus.Available);
DataRow[] drModels = dsModel.Tables[0].Select("true " + strFilter + _additional_filter);
if (intHost == 0)
{
int intSupply = drModels.Length;
strSupply += "<tr" + (boolOther ? " bgcolor=\"F6F6F6\"" : "") + "><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>" + (intSupply == 0 ? drModel["name"].ToString() : "<a href=\"javascript:void(0);\" onclick=\"OpenWindow('INVENTORY_SUPPLY','?model=" + drModel["id"].ToString() + "&status=1');\">" + drModel["name"].ToString() + "</a>") + ":</td><td width=\"100%\">" + oServiceRequest.GetStatusBarFill(((double.Parse(intSupply.ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#6699CC") + "</td><td nowrap>" + intSupply.ToString() + "</td></tr>";
}
else
{
DataSet dsHosts = oAsset.GetVMWareHosts(intHost);
double dblRAM = 0.0;
double dblProcessor = 0.0;
double dblDiskSpace = 0.0;
foreach (DataRow drHost in dsHosts.Tables[0].Rows)
{
dblRAM += double.Parse(drHost["ram"].ToString());
dblProcessor += double.Parse(drHost["cpu_count"].ToString());
}
DataSet dsHostStorage = oAsset.GetVMWareHostsStorage(intHost);
foreach (DataRow drHostStorage in dsHostStorage.Tables[0].Rows)
{
dblDiskSpace += double.Parse(drHostStorage["l_actual_size"].ToString());
dblDiskSpace += double.Parse(drHostStorage["l_actual_size_qa"].ToString());
dblDiskSpace += double.Parse(drHostStorage["l_actual_size_test"].ToString());
dblDiskSpace += double.Parse(drHostStorage["m_actual_size"].ToString());
dblDiskSpace += double.Parse(drHostStorage["m_actual_size_qa"].ToString());
dblDiskSpace += double.Parse(drHostStorage["m_actual_size_test"].ToString());
}
strSupply += "<tr" + (boolOther ? " bgcolor=\"F6F6F6\"" : "") + " class=\"" + (dblRAM > 0.00 ? "greendefault" : (dblRAM < 0.00 ? "reddefault" : "default")) + "\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>RAM:</td><td width=\"100%\">" + oServiceRequest.GetStatusBarFill(((dblRAM / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300") + "</td><td nowrap>" + dblRAM.ToString() + " GB</td></tr>";
strSupply += "<tr" + (boolOther ? " bgcolor=\"F6F6F6\"" : "") + " class=\"" + (dblProcessor > 0.00 ? "greendefault" : (dblProcessor < 0.00 ? "reddefault" : "default")) + "\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>Processors:</td><td width=\"100%\">" + oServiceRequest.GetStatusBarFill(((dblProcessor / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300") + "</td><td nowrap>" + dblProcessor.ToString() + "</td></tr>";
strSupply += "<tr" + (boolOther ? " bgcolor=\"F6F6F6\"" : "") + " class=\"" + (dblDiskSpace > 0.00 ? "greendefault" : (dblDiskSpace < 0.00 ? "reddefault" : "default")) + "\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>Disk Space:</td><td width=\"100%\">" + oServiceRequest.GetStatusBarFill(((dblDiskSpace / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300") + "</td><td nowrap>" + dblDiskSpace.ToString() + " GB</td></tr>";
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oPlatform = new Platforms(intProfile, dsn);
oType = new Types(intProfile, dsn);
oModelsProperties = new ModelsProperties(intProfile, dsn);
oAsset = new Asset(intProfile, dsnAsset);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oForecast = new Forecast(intProfile, dsn);
if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "")
{
intApplication = Int32.Parse(Request.QueryString["applicationid"]);
}
if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "")
{
intPage = Int32.Parse(Request.QueryString["pageid"]);
}
if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "")
{
intApplication = Int32.Parse(Request.Cookies["application"].Value);
}
int intPlatform = 0;
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
intPlatform = Int32.Parse(Request.QueryString["id"]);
}
if (intPlatform > 0)
{
intMax = Int32.Parse(oPlatform.Get(intPlatform, "max_inventory1"));
if (!IsPostBack)
{
DataSet dsDemand = oForecast.GetAnswersModel(intPlatform);
DataTable dtDemand = dsDemand.Tables[0];
DataSet dsTypes = oType.Gets(intPlatform, 1);
foreach (DataRow drType in dsTypes.Tables[0].Rows)
{
int intWarning = Int32.Parse(drType["inventory_warning"].ToString());
int intCritical = Int32.Parse(drType["inventory_critical"].ToString());
bool boolOther = false;
DataSet dsModels = oModelsProperties.GetTypes(1, Int32.Parse(drType["id"].ToString()), 1);
foreach (DataRow drModel in dsModels.Tables[0].Rows)
{
int intBlade = Int32.Parse(drModel["blade"].ToString());
int intHost = -1;
if (drModel["hostid"].ToString() != "")
{
intHost = Int32.Parse(drModel["hostid"].ToString());
}
int intModel = Int32.Parse(drModel["id"].ToString());
// Supply
DataSet dsModel = oAsset.GetCount(intModel, (int)AssetStatus.Available);
int intSupply = dsModel.Tables[0].Rows.Count;
// Demand
DataRow[] drModels = dtDemand.Select("model = " + intModel.ToString());
int intDemand = 0;
foreach (DataRow dr in drModels)
{
intDemand += Int32.Parse(dr["quantity"].ToString());
intDemand += Int32.Parse(dr["recovery_number"].ToString());
}
bool boolWarning = (intDemand > 0 && (intDemand + intWarning) >= intSupply);
bool boolCritical = (intDemand > 0 && (intDemand + intCritical) >= intSupply);
if (boolWarning || boolCritical)
{
boolOther = !boolOther;
sb = new StringBuilder(strSummary);
sb.Append("<tr");
sb.Append(boolOther ? " bgcolor=\"F6F6F6\"" : "");
sb.Append(" class=\"header\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td colspan=\"3\"><img src=\"/images/");
sb.Append(boolCritical ? "bigError.gif" : "bigAlert.gif");
sb.Append("\" border=\"0\" align=\"absmiddle\"/> ");
sb.Append(boolCritical ? "CRITICAL" : "WARNING");
sb.Append(": ");
sb.Append(drModel["name"].ToString());
sb.Append("</td></tr>");
sb.Append("<tr");
sb.Append(boolOther ? " bgcolor=\"F6F6F6\"" : "");
sb.Append("><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>Supply:</td><td width=\"100%\">");
sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(intSupply.ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#6699CC"));
sb.Append("</td><td nowrap>");
sb.Append(intSupply.ToString());
sb.Append("</td></tr>");
sb.Append("<tr");
sb.Append(boolOther ? " bgcolor=\"F6F6F6\"" : "");
sb.Append("><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>Demand:</td><td width=\"100%\">");
sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(intDemand.ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
sb.Append("</td><td nowrap>");
sb.Append(intDemand.ToString());
sb.Append("</td></tr>");
strSummary = sb.ToString();
}
}
}
if (strSummary == "")
{
strSummary = "<tr><td class=\"header\"><img src=\"/images/bigCheck.gif\" border=\"0\" align=\"absmiddle\"/> No Action Required</td></tr>";
}
}
}
}
private string LoadGroup(int _platformid, DataTable _demand, string _additional_filter)
{
string strGroup = "";
DataSet dsTypes = oType.Gets(_platformid, 1);
foreach (DataRow drType in dsTypes.Tables[0].Rows)
{
bool boolPhysical = false;
bool boolBlade = false;
bool boolOther = false;
int intOldHost = -1;
DataSet dsModels = oModelsProperties.GetTypes(1, Int32.Parse(drType["id"].ToString()), 1);
foreach (DataRow drModel in dsModels.Tables[0].Rows)
{
boolOther = !boolOther;
int intBlade = Int32.Parse(drModel["blade"].ToString());
int intHost = -1;
if (drModel["hostid"].ToString() != "")
{
intHost = Int32.Parse(drModel["hostid"].ToString());
}
string strType = "Unknown";
if (intBlade == 1)
{
strType = "Blade";
if (boolBlade == false)
{
if (strGroup != "")
{
strGroup += "<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>";
}
strGroup += "<tr><td colspan=\"4\" class=\"bold\">" + drType["name"].ToString() + " | " + strType + "</td></tr>";
boolBlade = true;
}
}
else if (intHost == 0)
{
strType = "Physical";
if (boolPhysical == false)
{
if (strGroup != "")
{
strGroup += "<tr><td colspan=\"4\"><p> </p></td></tr>";
}
strGroup += "<tr><td colspan=\"4\" class=\"bold\">" + drType["name"].ToString() + " | " + strType + "</td></tr>";
boolPhysical = true;
}
}
else if (intOldHost != intHost)
{
strType = drModel["host"].ToString();
if (intHost > 0)
{
if (strGroup != "")
{
strGroup += "<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>";
}
strGroup += "<tr><td colspan=\"4\" class=\"bold\">" + drType["name"].ToString() + " | " + strType + "</td></tr>";
intOldHost = intHost;
}
}
int intModel = Int32.Parse(drModel["id"].ToString());
DataRow[] drModels = _demand.Select("model = " + intModel.ToString() + strFilter + _additional_filter);
int intDemand = 0;
foreach (DataRow dr in drModels)
{
intDemand += Int32.Parse(dr["quantity"].ToString());
intDemand += Int32.Parse(dr["recovery_number"].ToString());
}
strGroup += "<tr" + (boolOther ? " bgcolor=\"F6F6F6\"" : "") + " class=\"" + (intDemand > 0 ? "greendefault" : (intDemand < 0 ? "reddefault" : "default")) + "\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>" + drModel["name"].ToString() + ":</td><td width=\"100%\">" + oServiceRequest.GetStatusBarFill(((double.Parse(intDemand.ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300") + "</td><td nowrap>" + intDemand.ToString() + "</td></tr>";
}
}
if (strGroup != "")
{
strGroup = "<table width=\"100%\" cellpadding=\"4\" cellspacing=\"0\" border=\"0\">" + strGroup + "</table>";
}
return(strGroup);
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oPage = new Pages(intProfile, dsn);
oPlatform = new Platforms(intProfile, dsn);
oType = new Types(intProfile, dsn);
oModelsProperties = new ModelsProperties(intProfile, dsn);
oAsset = new Asset(intProfile, dsnAsset);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oForecast = new Forecast(intProfile, dsn);
if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "")
{
intApplication = Int32.Parse(Request.QueryString["applicationid"]);
}
if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "")
{
intPage = Int32.Parse(Request.QueryString["pageid"]);
}
if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "")
{
intApplication = Int32.Parse(Request.Cookies["application"].Value);
}
int intPlatform = 0;
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
intPlatform = Int32.Parse(Request.QueryString["id"]);
}
if (intPlatform > 0)
{
if (!IsPostBack)
{
txtMax1.Text = oPlatform.Get(intPlatform, "max_inventory1");
bool boolOther2 = false;
DataSet dsTypes = oType.Gets(intPlatform, 1);
foreach (DataRow drType in dsTypes.Tables[0].Rows)
{
boolOther2 = !boolOther2;
strThreshold += "<tr" + (boolOther2 ? " bgcolor=\"F6F6F6\"" : "") + " class=\"default\"><td nowrap class=\"bold\">" + drType["name"].ToString() + ":</td><td nowrap><input id=\"" + drType["id"].ToString() + "_warning\" name=\"" + drType["id"].ToString() + "_warning\" type=\"text\" class=\"default\" maxlength=\"5\" value=\"" + drType["inventory_warning"].ToString() + "\" style=\"width:50px\"/></td><td nowrap><input id=\"" + drType["id"].ToString() + "_critical\" name=\"" + drType["id"].ToString() + "_critical\" type=\"text\" class=\"default\" maxlength=\"5\" value=\"" + drType["inventory_critical"].ToString() + "\" style=\"width:50px\"/></td></tr>";
bool boolPhysical = false;
bool boolBlade = false;
bool boolOther = false;
int intOldHost = -1;
DataSet dsModels = oModelsProperties.GetTypes(1, Int32.Parse(drType["id"].ToString()), 1);
foreach (DataRow drModel in dsModels.Tables[0].Rows)
{
boolOther = !boolOther;
int intBlade = Int32.Parse(drModel["blade"].ToString());
int intHost = -1;
if (drModel["hostid"].ToString() != "")
{
intHost = Int32.Parse(drModel["hostid"].ToString());
}
string strType = "Unknown";
int intModel = Int32.Parse(drModel["id"].ToString());
if (intBlade == 1)
{
strType = "Blade";
if (boolBlade == false)
{
if (strModelThreshold != "")
{
strModelThreshold += "<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>";
}
strModelThreshold += "<tr><td nowrap colspan=\"3\" class=\"bold\">" + strType + "</td><td nowrap align=\"center\" class=\"bold\">Thresholds</td></tr>";
boolBlade = true;
}
}
else if (intHost == 0)
{
strType = "Physical";
if (boolPhysical == false)
{
if (strModelThreshold != "")
{
strModelThreshold += "<tr><td colspan=\"4\"><p> </p><p> </p></td></tr>";
}
strModelThreshold += "<tr><td colspan=\"4\" class=\"header\">" + drType["name"].ToString() + "</td></tr>";
strModelThreshold += "<tr><td nowrap colspan=\"3\" class=\"bold\">" + strType + "</td><td nowrap align=\"center\" class=\"bold\">Thresholds</td></tr>";
boolPhysical = true;
}
}
else if (intOldHost != intHost)
{
strType = drModel["host"].ToString();
if (intHost > 0)
{
if (strModelThreshold != "")
{
strModelThreshold += "<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>";
}
strModelThreshold += "<tr><td nowrap colspan=\"3\" class=\"bold\">" + strType + "</td><td nowrap align=\"center\" class=\"bold\">Thresholds</td></tr>";
intOldHost = intHost;
}
}
strModelThreshold += "<tr" + (boolOther ? " bgcolor=\"F6F6F6\"" : "") + " class=\"default\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap><input type=\"button\" class=\"default\" value=\"Edit\" onclick=\"return OpenWindow('MODEL_THRESHOLDS','?mid=" + drModel["id"].ToString() + "');\" style=\"width:75px\"/></td><td nowrap width=\"100%\">" + drModel["name"].ToString() + ":</td><td nowrap align=\"center\">" + oModelsProperties.GetThresholds(intModel, 1).Tables[0].Rows.Count.ToString() + "</td></tr>";
}
}
}
}
btnMaximum.Attributes.Add("onclick", "return ValidateNumber0('" + txtMax1.ClientID + "','Please enter a valid number');");
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oPlatform = new Platforms(intProfile, dsn);
oType = new Types(intProfile, dsn);
oModelsProperties = new ModelsProperties(intProfile, dsn);
oAsset = new Asset(intProfile, dsnAsset);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oForecast = new Forecast(intProfile, dsn);
oHost = new Host(intProfile, dsn);
if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "")
{
intApplication = Int32.Parse(Request.QueryString["applicationid"]);
}
if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "")
{
intPage = Int32.Parse(Request.QueryString["pageid"]);
}
if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "")
{
intApplication = Int32.Parse(Request.Cookies["application"].Value);
}
int intPlatform = 0;
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
intPlatform = Int32.Parse(Request.QueryString["id"]);
}
if (intPlatform > 0)
{
intMax = Int32.Parse(oPlatform.Get(intPlatform, "max_inventory1"));
if (!IsPostBack)
{
DataSet dsTypes = oType.Gets(intPlatform, 1);
foreach (DataRow drType in dsTypes.Tables[0].Rows)
{
bool boolPhysical = false;
bool boolBlade = false;
bool boolOther = false;
int intOldHost = -1;
DataSet dsModels = oModelsProperties.GetTypes(1, Int32.Parse(drType["id"].ToString()), 1);
foreach (DataRow drModel in dsModels.Tables[0].Rows)
{
boolOther = !boolOther;
int intBlade = Int32.Parse(drModel["blade"].ToString());
int intHost = -1;
if (drModel["hostid"].ToString() != "")
{
intHost = Int32.Parse(drModel["hostid"].ToString());
}
string strType = "Unknown";
if (intBlade == 1)
{
strType = "Blade";
if (boolBlade == false)
{
if (strSupply != "")
{
strSupply += "<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>";
}
strSupply += "<tr><td colspan=\"4\" class=\"bold\">" + strType + "</td></tr>";
boolBlade = true;
}
}
else if (intHost == 0)
{
strType = "Physical";
if (boolPhysical == false)
{
if (strSupply != "")
{
strSupply += "<tr><td colspan=\"4\"><p> </p><p> </p></td></tr>";
}
strSupply += "<tr><td colspan=\"4\" class=\"header\">" + drType["name"].ToString() + "</td></tr>";
strSupply += "<tr><td colspan=\"4\" class=\"bold\">" + strType + "</td></tr>";
boolPhysical = true;
}
}
else if (intOldHost != intHost)
{
strType = drModel["host"].ToString();
if (intHost > 0)
{
if (strSupply != "")
{
strSupply += "<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>";
}
strSupply += "<tr><td colspan=\"4\" class=\"bold\">" + strType + "</td></tr>";
intOldHost = intHost;
}
}
int intModel = Int32.Parse(drModel["id"].ToString());
// Supply
DataSet dsModel = oAsset.GetCount(intModel, (int)AssetStatus.Available);
if (intHost == 0)
{
int intSupply = dsModel.Tables[0].Rows.Count;
strSupply += "<tr" + (boolOther ? " bgcolor=\"F6F6F6\"" : "") + "><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>" + (intSupply == 0 ? drModel["name"].ToString() : "<a href=\"javascript:void(0);\" onclick=\"OpenWindow('INVENTORY_SUPPLY','?model=" + drModel["id"].ToString() + "&status=1');\">" + drModel["name"].ToString() + "</a>") + ":</td><td width=\"100%\">" + oServiceRequest.GetStatusBarFill(((double.Parse(intSupply.ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#6699CC") + "</td><td nowrap>" + intSupply.ToString() + "</td></tr>";
}
else
{
DataSet dsHosts = oAsset.GetVMWareHosts(intHost);
double dblRAM = 0.0;
double dblProcessor = 0.0;
double dblDiskSpace = 0.0;
foreach (DataRow drHost in dsHosts.Tables[0].Rows)
{
dblRAM += double.Parse(drHost["ram"].ToString());
dblProcessor += double.Parse(drHost["cpu_count"].ToString());
}
DataSet dsHostStorage = oAsset.GetVMWareHostsStorage(intHost);
foreach (DataRow drHostStorage in dsHostStorage.Tables[0].Rows)
{
dblDiskSpace += double.Parse(drHostStorage["l_actual_size"].ToString());
dblDiskSpace += double.Parse(drHostStorage["l_actual_size_qa"].ToString());
dblDiskSpace += double.Parse(drHostStorage["l_actual_size_test"].ToString());
dblDiskSpace += double.Parse(drHostStorage["m_actual_size"].ToString());
dblDiskSpace += double.Parse(drHostStorage["m_actual_size_qa"].ToString());
dblDiskSpace += double.Parse(drHostStorage["m_actual_size_test"].ToString());
}
strSupply += "<tr" + (boolOther ? " bgcolor=\"F6F6F6\"" : "") + " class=\"" + (dblRAM > 0.00 ? "greendefault" : (dblRAM < 0.00 ? "reddefault" : "default")) + "\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>RAM:</td><td width=\"100%\">" + oServiceRequest.GetStatusBarFill(((dblRAM / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300") + "</td><td nowrap>" + dblRAM.ToString() + " GB</td></tr>";
strSupply += "<tr" + (boolOther ? " bgcolor=\"F6F6F6\"" : "") + " class=\"" + (dblProcessor > 0.00 ? "greendefault" : (dblProcessor < 0.00 ? "reddefault" : "default")) + "\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>Processors:</td><td width=\"100%\">" + oServiceRequest.GetStatusBarFill(((dblProcessor / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300") + "</td><td nowrap>" + dblProcessor.ToString() + "</td></tr>";
strSupply += "<tr" + (boolOther ? " bgcolor=\"F6F6F6\"" : "") + " class=\"" + (dblDiskSpace > 0.00 ? "greendefault" : (dblDiskSpace < 0.00 ? "reddefault" : "default")) + "\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>Disk Space:</td><td width=\"100%\">" + oServiceRequest.GetStatusBarFill(((dblDiskSpace / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300") + "</td><td nowrap>" + dblDiskSpace.ToString() + " GB</td></tr>";
}
}
}
}
}
}
private string LoadGroup(int _platformid, DataTable _demand, string _additional_filter)
{
StringBuilder sb = new StringBuilder();
DataSet dsTypes = oType.Gets(_platformid, 1);
foreach (DataRow drType in dsTypes.Tables[0].Rows)
{
bool boolPhysical = false;
bool boolOther = false;
int intOldHost = -1;
DataSet dsModels = oModelsProperties.GetTypes(1, Int32.Parse(drType["id"].ToString()), 1);
foreach (DataRow drModel in dsModels.Tables[0].Rows)
{
boolOther = !boolOther;
int intHost = -1;
if (drModel["hostid"].ToString() != "")
{
intHost = Int32.Parse(drModel["hostid"].ToString());
}
string strType = "Unknown";
if (intHost == 0)
{
strType = "Physical";
if (boolPhysical == false)
{
if (sb.ToString() != "")
{
sb.Append("<tr><td colspan=\"4\"><p> </p></td></tr>");
}
sb.Append("<tr><td colspan=\"4\" class=\"bold\">");
sb.Append(drType["name"].ToString());
sb.Append(" | ");
sb.Append(strType);
sb.Append("</td></tr>");
boolPhysical = true;
}
}
else if (intOldHost != intHost)
{
strType = drModel["host"].ToString();
if (intHost > 0)
{
if (sb.ToString() != "")
{
sb.Append("<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>");
}
sb.Append("<tr><td colspan=\"4\" class=\"bold\">");
sb.Append(drType["name"].ToString());
sb.Append(" | ");
sb.Append(strType);
sb.Append("</td></tr>");
intOldHost = intHost;
}
}
int intModel = Int32.Parse(drModel["id"].ToString());
DataRow[] drModels = _demand.Select("model = " + intModel.ToString() + strFilter + _additional_filter);
int intDemand = 0;
if (intHost == 0)
{
foreach (DataRow dr in drModels)
{
intDemand += Int32.Parse(dr["quantity"].ToString());
}
sb.Append("<tr");
sb.Append(boolOther ? " bgcolor=\"F6F6F6\"" : "");
sb.Append(" class=\"");
sb.Append(intDemand > 0 ? "greendefault" : (intDemand < 0 ? "reddefault" : "default"));
sb.Append("\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>");
sb.Append(drModel["name"].ToString());
sb.Append(":</td><td width=\"100%\">");
sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(intDemand.ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
sb.Append("</td><td nowrap>");
sb.Append(intDemand.ToString());
sb.Append("</td></tr>");
}
else
{
double dblRAM = 0.0;
double dblHDD = 0.0;
foreach (DataRow drCount in drModels)
{
if (drCount["ram"].ToString() != "")
{
dblRAM += double.Parse(drCount["ram"].ToString());
}
if (drCount["os"].ToString() != "")
{
dblHDD += double.Parse(drCount["hdd"].ToString());
}
}
sb.Append("<tr");
sb.Append(boolOther ? " bgcolor=\"F6F6F6\"" : "");
sb.Append(" class=\"");
sb.Append(dblRAM > 0.00 ? "greendefault" : (dblRAM < 0.00 ? "reddefault" : "default"));
sb.Append("\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>RAM:</td><td width=\"100%\">");
sb.Append(oServiceRequest.GetStatusBarFill(((dblRAM / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
sb.Append("</td><td nowrap>");
sb.Append(dblRAM.ToString());
sb.Append(" GB</td></tr>");
sb.Append("<tr");
sb.Append(boolOther ? " bgcolor=\"F6F6F6\"" : "");
sb.Append(" class=\"");
sb.Append(dblHDD > 0.00 ? "greendefault" : (dblHDD < 0.00 ? "reddefault" : "default"));
sb.Append("\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>Disk Space:</td><td width=\"100%\">");
sb.Append(oServiceRequest.GetStatusBarFill(((dblHDD / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
sb.Append("</td><td nowrap>");
sb.Append(dblHDD.ToString());
sb.Append(" GB</td></tr>");
}
}
}
if (sb.ToString() != "")
{
return("<table width=\"100%\" cellpadding=\"4\" cellspacing=\"0\" border=\"0\">" + sb.ToString() + "</table>");
}
else
{
return(sb.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oPlatform = new Platforms(intProfile, dsn);
oType = new Types(intProfile, dsn);
oModelsProperties = new ModelsProperties(intProfile, dsn);
oAsset = new Asset(intProfile, dsnAsset);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oForecast = new Forecast(intProfile, dsn);
if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "")
{
intApplication = Int32.Parse(Request.QueryString["applicationid"]);
}
if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "")
{
intPage = Int32.Parse(Request.QueryString["pageid"]);
}
if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "")
{
intApplication = Int32.Parse(Request.Cookies["application"].Value);
}
int intPlatform = 0;
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
intPlatform = Int32.Parse(Request.QueryString["id"]);
}
if (intPlatform > 0)
{
intMax = Int32.Parse(oPlatform.Get(intPlatform, "max_inventory1"));
if (!IsPostBack)
{
DataSet dsTypes = oType.Gets(intPlatform, 1);
foreach (DataRow drType in dsTypes.Tables[0].Rows)
{
bool boolPhysical = false;
bool boolBlade = false;
bool boolOther = false;
int intOldHost = -1;
DataSet dsModels = oModelsProperties.GetTypes(1, Int32.Parse(drType["id"].ToString()), 1);
foreach (DataRow drModel in dsModels.Tables[0].Rows)
{
boolOther = !boolOther;
int intBlade = Int32.Parse(drModel["blade"].ToString());
int intHost = -1;
if (drModel["hostid"].ToString() != "")
{
intHost = Int32.Parse(drModel["hostid"].ToString());
}
string strType = "Unknown";
if (intBlade == 1)
{
strType = "Blade";
if (boolBlade == false)
{
if (sb.ToString() != "")
{
sb.Append("<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>");
}
sb.Append("<tr><td colspan=\"4\" class=\"bold\">");
sb.Append(strType);
sb.Append("</td></tr>");
boolBlade = true;
}
}
else if (intHost == 0)
{
strType = "Physical";
if (boolPhysical == false)
{
if (sb.ToString() != "")
{
sb.Append("<tr><td colspan=\"4\"><p> </p><p> </p></td></tr>");
}
sb.Append("<tr><td colspan=\"4\" class=\"header\">");
sb.Append(drType["name"].ToString());
sb.Append("</td></tr>");
sb.Append("<tr><td colspan=\"4\" class=\"bold\">");
sb.Append(strType);
sb.Append("</td></tr>");
boolPhysical = true;
}
}
else if (intOldHost != intHost)
{
strType = drModel["host"].ToString();
if (intHost > 0)
{
if (sb.ToString() != "")
{
sb.Append("<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>");
}
sb.Append("<tr><td colspan=\"4\" class=\"bold\">");
sb.Append(strType);
sb.Append("</td></tr>");
intOldHost = intHost;
}
}
int intModel = Int32.Parse(drModel["id"].ToString());
// Supply
DataSet dsModel = oAsset.GetCount(intModel, (int)AssetStatus.Available);
int intSupply = dsModel.Tables[0].Rows.Count;
sb.Append("<tr");
sb.Append(boolOther ? " bgcolor=\"F6F6F6\"" : "");
sb.Append("><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>");
sb.Append(intSupply == 0 ? drModel["name"].ToString() : "<a href=\"javascript:void(0);\" onclick=\"OpenWindow('INVENTORY_SUPPLY','?model=" + drModel["id"].ToString() + "&status=1');\">" + drModel["name"].ToString() + "</a>");
sb.Append(":</td><td width=\"100%\">");
sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(intSupply.ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#6699CC"));
sb.Append("</td><td nowrap>");
sb.Append(intSupply.ToString());
sb.Append("</td></tr>");
}
}
}
}
strSupply = sb.ToString();
}
private string LoadGroup(int _platformid, DataTable _demand, string _additional_filter)
{
string strGroup = "";
Functions oFunction = new Functions(intProfile, dsn, intEnvironment);
DataSet dsTypes = oType.Gets(_platformid, 1);
foreach (DataRow drType in dsTypes.Tables[0].Rows)
{
bool boolPhysical = false;
bool boolBlade = false;
bool boolOther = false;
int intOldHost = -1;
DataSet dsModels = oModelsProperties.GetTypes(1, Int32.Parse(drType["id"].ToString()), 1);
foreach (DataRow drModel in dsModels.Tables[0].Rows)
{
boolOther = !boolOther;
int intBlade = Int32.Parse(drModel["blade"].ToString());
int intHost = -1;
if (drModel["hostid"].ToString() != "")
{
intHost = Int32.Parse(drModel["hostid"].ToString());
}
string strType = "Unknown";
if (intBlade == 1)
{
strType = "Blade";
if (boolBlade == false)
{
if (strGroup != "")
{
strGroup += "<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>";
}
strGroup += "<tr><td colspan=\"4\" class=\"bold\">" + drType["name"].ToString() + " | " + strType + "</td></tr>";
boolBlade = true;
}
}
else if (intHost == 0)
{
strType = "Physical";
if (boolPhysical == false)
{
if (strGroup != "")
{
strGroup += "<tr><td colspan=\"4\"><p> </p></td></tr>";
}
strGroup += "<tr><td colspan=\"4\" class=\"bold\">" + drType["name"].ToString() + " | " + strType + "</td></tr>";
boolPhysical = true;
}
}
else if (intOldHost != intHost)
{
strType = drModel["host"].ToString();
if (intHost > 0)
{
if (strGroup != "")
{
strGroup += "<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>";
}
strGroup += "<tr><td colspan=\"4\" class=\"bold\">" + drType["name"].ToString() + " | " + strType + "</td></tr>";
intOldHost = intHost;
}
}
int intModel = Int32.Parse(drModel["id"].ToString());
DataRow[] drModels = _demand.Select("model = " + intModel.ToString() + strFilter + _additional_filter);
int intDemand = 0;
if (intHost == 0)
{
foreach (DataRow dr in drModels)
{
intDemand += Int32.Parse(dr["quantity"].ToString());
intDemand += Int32.Parse(dr["recovery_number"].ToString());
}
strGroup += "<tr" + (boolOther ? " bgcolor=\"F6F6F6\"" : "") + " class=\"" + (intDemand > 0 ? "greendefault" : (intDemand < 0 ? "reddefault" : "default")) + "\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>" + (intDemand == 0 ? drModel["name"].ToString() : "<a href=\"javascript:void(0);\" onclick=\"OpenWindow('INVENTORY_DEMAND','?model=" + drModel["id"].ToString() + "&filters=" + oFunction.encryptQueryString(strFilter + _additional_filter) + "');\">" + drModel["name"].ToString() + "</a>") + ":</td><td width=\"100%\">" + oServiceRequest.GetStatusBarFill(((double.Parse(intDemand.ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300") + "</td><td nowrap>" + intDemand.ToString() + "</td></tr>";
}
else
{
// RAM
double dblRAM = 0.0;
string[] strQuestions;
char[] strSplit = { ';' };
strQuestions = strQuestion.Split(strSplit);
for (int ii = 0; ii < strQuestions.Length; ii++)
{
if (strQuestions[ii].Trim() != "")
{
int intQuestion = Int32.Parse(strQuestions[ii].Trim());
foreach (DataRow drCount in drModels)
{
int intAnswer = Int32.Parse(drCount["id"].ToString());
DataSet dsAnswers = oForecast.GetAnswerPlatform(intAnswer, intQuestion);
foreach (DataRow drAnswer in dsAnswers.Tables[0].Rows)
{
int intResponse = Int32.Parse(drAnswer["responseid"].ToString());
dblRAM += double.Parse(oForecast.GetResponse(intResponse, "response"));
}
}
}
}
strGroup += "<tr" + (boolOther ? " bgcolor=\"F6F6F6\"" : "") + " class=\"" + (dblRAM > 0.00 ? "greendefault" : (dblRAM < 0.00 ? "reddefault" : "default")) + "\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>RAM:</td><td width=\"100%\">" + oServiceRequest.GetStatusBarFill(((dblRAM / double.Parse(intMaxRAM.ToString())) * 100.00), "95", false, "#CC3300") + "</td><td nowrap>" + dblRAM.ToString() + " GB</td></tr>";
// Disk Space
double dblHDD = 0.0;
foreach (DataRow drCount in drModels)
{
if (drCount["high_total"].ToString() != "")
{
dblHDD += double.Parse(drCount["high_total"].ToString());
}
if (drCount["standard_total"].ToString() != "")
{
dblHDD += double.Parse(drCount["standard_total"].ToString());
}
if (drCount["low_total"].ToString() != "")
{
dblHDD += double.Parse(drCount["low_total"].ToString());
}
if (drCount["high_test"].ToString() != "")
{
dblHDD += double.Parse(drCount["high_test"].ToString());
}
if (drCount["standard_test"].ToString() != "")
{
dblHDD += double.Parse(drCount["standard_test"].ToString());
}
if (drCount["low_test"].ToString() != "")
{
dblHDD += double.Parse(drCount["low_test"].ToString());
}
}
strGroup += "<tr" + (boolOther ? " bgcolor=\"F6F6F6\"" : "") + " class=\"" + (dblHDD > 0.00 ? "greendefault" : (dblHDD < 0.00 ? "reddefault" : "default")) + "\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>Disk Space:</td><td width=\"100%\">" + oServiceRequest.GetStatusBarFill(((dblHDD / double.Parse(intMaxSpace.ToString())) * 100.00), "95", false, "#CC3300") + "</td><td nowrap>" + dblHDD.ToString() + " GB</td></tr>";
}
}
}
if (strGroup != "")
{
strGroup = "<table width=\"100%\" cellpadding=\"4\" cellspacing=\"0\" border=\"0\">" + strGroup + "</table>";
}
return(strGroup);
}
