Exemple #1
0
        protected void dlDetails_ItemDataBound(object sender, DataListItemEventArgs e)
        {
            int intMax = 100;

            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                DataRow drv       = (DataRow)e.Item.DataItem;
                int     intDemand = Int32.Parse(drv["Demandcount"].ToString());
                int     intSupply = Int32.Parse(drv["SupplyCount"].ToString());

                Label lblInfo = (Label)e.Item.FindControl("lblInfo");
                lblInfo.Text = "";

                if (chkWarningAndCritial.Checked == true)
                {
                    if (drv["InventoryCritical"].ToString() == "1")
                    {
                        lblInfo.Text = "<img src=\"/images/Error.gif\" border=\"0\" align=\"absmiddle\"/> ";
                    }
                    else if (drv["InventoryWarning"].ToString() == "1")
                    {
                        lblInfo.Text = "<img src=\"/images/Alert.gif\" border=\"0\" align=\"absmiddle\"/> ";
                    }
                }
                Label lblModel = (Label)e.Item.FindControl("lblModel");
                lblModel.Text = drv["ModelName"].ToString();

                Label lblDemand   = (Label)e.Item.FindControl("lblDemand");
                Label lblDemandNo = (Label)e.Item.FindControl("lblDemandNo");

                lblDemandNo.Text = intDemand.ToString();
                lblDemand.Text   = oServiceRequest.GetStatusBarFill(((double.Parse(intDemand.ToString()) / double.Parse(intMax.ToString())) * 100.00), "75%", false, "#CC3300");


                Label lblSupply   = (Label)e.Item.FindControl("lblSupply");
                Label lblSupplyNo = (Label)e.Item.FindControl("lblSupplyNo");


                lblSupplyNo.Text = intSupply.ToString();
                lblSupply.Text   = oServiceRequest.GetStatusBarFill(((double.Parse(intSupply.ToString()) / double.Parse(intMax.ToString())) * 100.00), "75%", false, "#6699CC");
            }
        }
        protected void dlDetails_ItemDataBound(object sender, DataListItemEventArgs e)
        {
            int intMax = 100;

            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                DataRow drv       = (DataRow)e.Item.DataItem;
                int     intDemand = Int32.Parse(drv["ForcastServerCount"].ToString());

                Label lblModel = (Label)e.Item.FindControl("lblModel");
                lblModel.Text = drv["ModelName"].ToString();

                Label lblDemand   = (Label)e.Item.FindControl("lblDemand");
                Label lblDemandNo = (Label)e.Item.FindControl("lblDemandNo");

                lblDemandNo.Text = intDemand.ToString();
                lblDemand.Text   = oServiceRequest.GetStatusBarFill(((double.Parse(intDemand.ToString()) / double.Parse(intMax.ToString())) * 100.00), "75%", false, "#CC3300");
            }
        }
 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>&nbsp;</p><p>&nbsp;</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>";
             }
         }
     }
 }
Exemple #4
0
        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>";
                    }
                }
            }
        }
Exemple #5
0
        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>&nbsp;</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);
        }
Exemple #6
0
        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>&nbsp;</p><p>&nbsp;</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, string _additional_filter)
        {
            DataSet   dsSupply  = oAsset.GetDemandFacilities();
            DataTable dtSupply  = dsSupply.Tables[0];
            double    dblSupply = 0.00;

            if (strFilter.StartsWith(" AND ") == true)
            {
                strFilter = strFilter.Substring(5);
            }

            if (strFilter.StartsWith("AND ") == true)
            {
                strFilter = strFilter.Substring(4);
            }

            DataRow[]     drModels    = dtSupply.Select(strFilter + _additional_filter);
            string        strPlatform = "";
            string        strModel    = "";
            double        dblQuantity = 0.00;
            double        dblAmps     = 0.00;
            StringBuilder sb          = new StringBuilder();

            foreach (DataRow dr in drModels)
            {
                if (strPlatform != dr["platform"].ToString())
                {
                    if (strModel != "")
                    {
                        dblSupply = dblQuantity * dblAmps;
                        sb.Append("<tr class=\"default\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>");
                        sb.Append(strModel);
                        sb.Append(":</td><td width=\"100%\">");
                        sb.Append(oServiceRequest.GetStatusBarFill(((dblSupply / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                        sb.Append("</td><td nowrap>");
                        sb.Append(dblQuantity.ToString());
                        sb.Append("</td><td nowrap>(x ");
                        sb.Append(dblAmps.ToString());
                        sb.Append(" AMPs) =</td><td nowrap>");
                        sb.Append(dblSupply.ToString());
                        sb.Append(" AMPs</td></tr>");
                        dblQuantity = 0.00;
                        dblAmps     = 0.00;
                    }

                    sb.Append("<tr class=\"bold\"><td colspan=\"3\">");
                    sb.Append(dr["platform"].ToString());
                    sb.Append("</td><td nowrap>Qty</td><td>&nbsp;<td nowrap>Total AMPs</td></tr>");
                    strPlatform = dr["platform"].ToString();
                }
                else if (strModel != dr["model"].ToString())
                {
                    if (strModel != "")
                    {
                        dblSupply = dblQuantity * dblAmps;
                        sb.Append("<tr class=\"default\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>");
                        sb.Append(strModel);
                        sb.Append(":</td><td width=\"100%\">");
                        sb.Append(oServiceRequest.GetStatusBarFill(((dblSupply / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                        sb.Append("</td><td nowrap>");
                        sb.Append(dblQuantity.ToString());
                        sb.Append("</td><td nowrap>(x ");
                        sb.Append(dblAmps.ToString());
                        sb.Append(" AMPs) =</td><td nowrap>");
                        sb.Append(dblSupply.ToString());
                        sb.Append(" AMPs</td></tr>");
                        dblQuantity = 0.00;
                        dblAmps     = 0.00;
                    }
                }
                if (dr["quantity"].ToString() != "")
                {
                    dblQuantity += double.Parse(dr["quantity"].ToString());
                }
                if (dr["amp"].ToString() != "")
                {
                    dblAmps = double.Parse(dr["amp"].ToString());
                }
                strModel = dr["model"].ToString();
            }

            if (strModel != "")
            {
                dblSupply = dblQuantity * dblAmps;
                sb.Append("<tr class=\"default\"><td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td><td nowrap>");
                sb.Append(strModel);
                sb.Append(":</td><td width=\"100%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((dblSupply / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap>");
                sb.Append(dblQuantity.ToString());
                sb.Append("</td><td nowrap>(x ");
                sb.Append(dblAmps.ToString());
                sb.Append(" AMPs) =</td><td nowrap>");
                sb.Append(dblSupply.ToString());
                sb.Append(" AMPs</td></tr>");
                dblQuantity = 0.00;
                dblAmps     = 0.00;
            }

            if (sb.ToString() != "")
            {
                return("<table width=\"100%\" cellpadding=\"4\" cellspacing=\"0\" border=\"0\">" + sb.ToString() + "</table>");
            }
            else
            {
                return(sb.ToString());
            }
        }
        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);
        }
Exemple #9
0
        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>&nbsp;</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());
            }
        }
Exemple #10
0
        private string LoadGroup(int _platformid, string _additional_filter)
        {
            string    strGroup = "";
            DataSet   dsSupply = oAsset.GetSupplyNetwork();
            DataTable dtSupply = dsSupply.Tables[0];
            int       intPorts = 0;

            if (strFilter.StartsWith(" AND ") == true)
            {
                strFilter = strFilter.Substring(5);
            }
            if (strFilter.StartsWith("AND ") == true)
            {
                strFilter = strFilter.Substring(4);
            }
            DataRow[] drModels = dtSupply.Select(strFilter + _additional_filter);
            foreach (DataRow dr in drModels)
            {
                if (dr["available_ports"].ToString() != "")
                {
                    intPorts += Int32.Parse(dr["available_ports"].ToString());
                }
            }
            strGroup += "<tr class=\"" + (intPorts > 0 ? "greendefault" : (intPorts < 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(intPorts.ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300") + "</td><td nowrap>" + intPorts.ToString() + "</td></tr>";
            if (strGroup != "")
            {
                strGroup = "<table width=\"100%\" cellpadding=\"4\" cellspacing=\"0\" border=\"0\">" + strGroup + "</table>";
            }
            return(strGroup);
        }
Exemple #11
0
        protected string LoadDetails()
        {
            StringBuilder sb = new StringBuilder();


            string strFilters = "";

            strFilters = strFilters + (strFilters != "" ? (strFilterLocation != "" ? " AND " + strFilterLocation : strFilterLocation) : strFilterLocation);
            strFilters = strFilters + (strFilters != "" ? (strFilterProject != "" ? " AND " + strFilterProject : strFilterProject) : strFilterProject);
            strFilters = strFilters + (strFilters != "" ? (strFilterClass != "" ? " AND " + strFilterClass : strFilterClass) : strFilterClass);
            strFilters = strFilters + (strFilters != "" ? (strFilterEnv != "" ? " AND " + strFilterEnv : strFilterEnv) : strFilterEnv);
            strFilters = strFilters + (strFilters != "" ? (strFilterConfidence != "" ? " AND " + strFilterConfidence : strFilterConfidence) : strFilterConfidence);


            string   strSort = "Location";
            DataList dl      = this.FindControl("dlDetails") as System.Web.UI.WebControls.DataList;

            DataRow[] drSelect = null;
            drSelect = dtSupplyAndDemand.Select(strFilters, strSort);

            foreach (DataRow drDetails in drSelect)
            {
                //Add Location

                // Production
                sb.Append("<tr><td colspan=\"4\" class=\"header\">Production</td></tr>");

                sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                sb.Append("<td nowrap width=\"20%\">High Performance:</td>");
                sb.Append("<td width=\"60%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StorageHighProd"].ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                sb.Append(double.Parse(drDetails["StorageHighProd"].ToString()));
                sb.Append(" GB</td></tr>");

                sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                sb.Append("<td nowrap width=\"20%\">Standard Performance:</td>");
                sb.Append("<td width=\"60%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StorageStandardProd"].ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                sb.Append(double.Parse(drDetails["StorageStandardProd"].ToString()));
                sb.Append(" GB</td></tr>");

                sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                sb.Append("<td nowrap width=\"20%\">Low Performance:</td>");
                sb.Append("<td width=\"60%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StorageLowProd"].ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                sb.Append(double.Parse(drDetails["StorageLowProd"].ToString()));
                sb.Append(" GB</td></tr>");

                sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                sb.Append("<td nowrap width=\"20%\">Ports:</td>");
                sb.Append("<td width=\"60%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StoragePortsProd"].ToString()) / double.Parse(intMaxPorts.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                sb.Append(double.Parse(drDetails["StoragePortsProd"].ToString()));
                sb.Append("</td></tr>");

                sb.Append("<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>");

                // QA
                sb.Append("<tr><td colspan=\"4\" class=\"header\">QA</td></tr>");

                sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                sb.Append("<td nowrap width=\"20%\">High Performance:</td>");
                sb.Append("<td width=\"60%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StorageHighQA"].ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                sb.Append(double.Parse(drDetails["StorageHighQA"].ToString()));
                sb.Append(" GB</td></tr>");

                sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                sb.Append("<td nowrap width=\"20%\">Standard Performance:</td>");
                sb.Append("<td width=\"60%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StorageStandardQa"].ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                sb.Append(double.Parse(drDetails["StorageStandardQa"].ToString()));
                sb.Append(" GB</td></tr>");

                sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                sb.Append("<td nowrap width=\"20%\">Low Performance:</td>");
                sb.Append("<td width=\"60%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StorageLowQa"].ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                sb.Append(double.Parse(drDetails["StorageLowQa"].ToString()));
                sb.Append(" GB</td></tr>");

                sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                sb.Append("<td nowrap width=\"20%\">Ports:</td>");
                sb.Append("<td width=\"60%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StoragePortsQA"].ToString()) / double.Parse(intMaxPorts.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                sb.Append(double.Parse(drDetails["StoragePortsQA"].ToString()));
                sb.Append("</td></tr>");

                sb.Append("<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>");

                // Test
                sb.Append("<tr><td colspan=\"4\" class=\"header\">Test</td></tr>");

                sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                sb.Append("<td nowrap width=\"20%\">High Performance:</td>");
                sb.Append("<td width=\"60%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StorageHighTest"].ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                sb.Append(double.Parse(drDetails["StorageHighTest"].ToString()));
                sb.Append(" GB</td></tr>");

                sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                sb.Append("<td nowrap width=\"20%\">Standard Performance:</td>");
                sb.Append("<td width=\"60%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StorageStandardTest"].ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                sb.Append(double.Parse(drDetails["StorageStandardTest"].ToString()));
                sb.Append(" GB</td></tr>");

                sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                sb.Append("<td nowrap width=\"20%\">Low Performance:</td>");
                sb.Append("<td width=\"60%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StorageLowTest"].ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                sb.Append(double.Parse(drDetails["StorageLowTest"].ToString()));
                sb.Append(" GB</td></tr>");

                sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                sb.Append("<td nowrap width=\"20%\">Ports:</td>");
                sb.Append("<td width=\"60%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StoragePortsTest"].ToString()) / double.Parse(intMaxPorts.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                sb.Append(double.Parse(drDetails["StoragePortsTest"].ToString()));
                sb.Append("</td></tr>");

                sb.Append("<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>");

                // HA
                sb.Append("<tr><td colspan=\"4\" class=\"header\">High Availability</td></tr>");

                sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                sb.Append("<td nowrap width=\"20%\">High Performance:</td>");
                sb.Append("<td width=\"60%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StorageHighHA"].ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                sb.Append(double.Parse(drDetails["StorageHighHA"].ToString()));
                sb.Append(" GB</td></tr>");

                sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                sb.Append("<td nowrap width=\"20%\">Standard Performance:</td>");
                sb.Append("<td width=\"60%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StorageStandardHA"].ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                sb.Append(double.Parse(drDetails["StorageStandardHA"].ToString()));
                sb.Append(" GB</td></tr>");

                sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                sb.Append("<td nowrap width=\"20%\">Low Performance:</td>");
                sb.Append("<td width=\"60%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StorageLowHA"].ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                sb.Append(double.Parse(drDetails["StorageLowHA"].ToString()));
                sb.Append(" GB</td></tr>");

                sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                sb.Append("<td nowrap width=\"20%\">Ports:</td>");
                sb.Append("<td width=\"60%\">");
                sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StoragePortsHA"].ToString()) / double.Parse(intMaxPorts.ToString())) * 100.00), "95", false, "#CC3300"));
                sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                sb.Append(double.Parse(drDetails["StoragePortsHA"].ToString()));
                sb.Append("</td></tr>");

                sb.Append("<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>");

                if (oLocation.GetAddress(Int32.Parse(drDetails["LocationId"].ToString()), "dr") == "1")
                {
                    // Replicated
                    sb.Append("<tr><td colspan=\"4\" class=\"header\">Replication</td></tr>");

                    sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                    sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                    sb.Append("<td nowrap width=\"20%\">High Performance:</td>");
                    sb.Append("<td width=\"60%\">");
                    sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StorageHighReplicated"].ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                    sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                    sb.Append(double.Parse(drDetails["StorageHighReplicated"].ToString()));
                    sb.Append(" GB</td></tr>");

                    sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                    sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                    sb.Append("<td nowrap width=\"20%\">Standard Performance:</td>");
                    sb.Append("<td width=\"60%\">");
                    sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StorageStandardReplicated"].ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                    sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                    sb.Append(double.Parse(drDetails["StorageStandardReplicated"].ToString()));
                    sb.Append(" GB</td></tr>");

                    sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                    sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                    sb.Append("<td nowrap width=\"20%\">Low Performance:</td>");
                    sb.Append("<td width=\"60%\">");
                    sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StorageLowReplicated"].ToString()) / double.Parse(intMax.ToString())) * 100.00), "95", false, "#CC3300"));
                    sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                    sb.Append(double.Parse(drDetails["StorageLowReplicated"].ToString()));
                    sb.Append(" GB</td></tr>");
                }

                //sb.Append("<tr bgcolor=\"F6F6F6\" class=\"default\">");
                //sb.Append("<td nowrap><img src=\"/images/spacer.gif\" border=\"0\" width=\"10\" height=\"1\"/></td>");
                //sb.Append("<td nowrap width=\"20%\">Ports:</td>");
                //sb.Append("<td width=\"60%\">");
                //sb.Append(oServiceRequest.GetStatusBarFill(((double.Parse(drDetails["StoragePortsReplicated"].ToString()) / double.Parse(intMaxPorts.ToString())) * 100.00), "95", false, "#CC3300"));
                //sb.Append("</td><td nowrap width=\"20%\" align=\"right\">");
                //sb.Append(double.Parse(drDetails["StoragePortsReplicated"].ToString()));
                //sb.Append("</td></tr>");

                //sb.Append("<tr><td colspan=\"4\"><span style=\"width:100%;border-bottom:1 dotted #999999;\"/></td></tr>");
            }


            if (sb.ToString() != "")
            {
                sb.Insert(0, "<table width=\"100%\" cellpadding=\"4\" cellspacing=\"0\" border=\"0\" style=\"border:solid 1px #CCCCCC\">");
                sb.Append("</table>");
            }

            return(sb.ToString());
        }
Exemple #12
0
        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>&nbsp;</p><p>&nbsp;</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>&nbsp;</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);
        }