protected void Page_Load(object sender, EventArgs e)
 {
     if (Request.Cookies["adminid"] != null && Request.Cookies["adminid"].Value != "")
     {
         intProfile = Int32.Parse(Request.Cookies["adminid"].Value);
     }
     else
     {
         Reload();
     }
     oModel       = new Models(intProfile, dsn);
     oClass       = new Classes(intProfile, dsn);
     oEnvironment = new Environments(intProfile, dsn);
     if (Request.QueryString["save"] != null && Request.QueryString["save"] != "")
     {
         Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "save", "<script type=\"text/javascript\">alert('Record Added Successfully');<" + "/" + "script>");
     }
     if (Request.QueryString["delete"] != null && Request.QueryString["delete"] != "")
     {
         Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "delete", "<script type=\"text/javascript\">alert('Record Deleted Successfully');<" + "/" + "script>");
     }
     if (Request.QueryString["modelid"] != null && Request.QueryString["modelid"] != "")
     {
         intModel = Int32.Parse(Request.QueryString["modelid"]);
     }
     if (Request.QueryString["classid"] != null && Request.QueryString["classid"] != "")
     {
         intClass = Int32.Parse(Request.QueryString["classid"]);
     }
     if (Request.QueryString["environmentid"] != null && Request.QueryString["environmentid"] != "")
     {
         intEnv = Int32.Parse(Request.QueryString["environmentid"]);
     }
     if (intModel > 0 && intClass > 0 && intEnv > 0)
     {
         DataSet ds = oModel.GetReservation(intModel, intClass, intEnv);
         if (ds.Tables[0].Rows.Count > 0)
         {
             intParent = Int32.Parse(ds.Tables[0].Rows[0]["id"].ToString());
         }
         if (!IsPostBack)
         {
             lblName.Text        = oModel.Get(intModel, "name");
             lblClass.Text       = oClass.Get(intClass, "name");
             lblEnvironment.Text = oEnvironment.Get(intEnv, "name");
             LoadLists();
         }
         btnClose.Attributes.Add("onclick", "return HidePanel();");
         btnRemove.Attributes.Add("onclick", "return confirm('Are you sure you want to remove this item?');");
         ddlClass.Attributes.Add("onchange", "PopulateEnvironments('" + ddlClass.ClientID + "','" + ddlEnvironment.ClientID + "',0);");
         ddlEnvironment.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlEnvironment.ClientID + "','" + hdnEnvironment.ClientID + "');");
     }
 }
        private void LoadLists()
        {
            Classes oClass = new Classes(intProfile, dsn);

            ddlClass.DataValueField = "id";
            ddlClass.DataTextField  = "name";
            ddlClass.DataSource     = oClass.Gets(1);
            ddlClass.DataBind();
            ddlClass.Items.Insert(0, new ListItem("-- SELECT --", "0"));
            int intClass = 0;

            if (Request.QueryString["cid"] != null && Request.QueryString["cid"] != "")
            {
                intClass = Int32.Parse(Request.QueryString["cid"]);
            }
            if (oClass.Get(intClass).Tables[0].Rows.Count > 0)
            {
                ddlClass.SelectedValue = intClass.ToString();
                ddlEnvironment.Enabled = true;
                Environments oEnvironment = new Environments(intProfile, dsn);
                ddlEnvironment.DataValueField = "id";
                ddlEnvironment.DataTextField  = "name";
                ddlEnvironment.DataSource     = oClass.GetEnvironment(intClass, 1);
                ddlEnvironment.DataBind();
                ddlEnvironment.Items.Insert(0, new ListItem("-- SELECT --", "0"));
                int intEnvironment = 0;
                if (Request.QueryString["eid"] != null && Request.QueryString["eid"] != "")
                {
                    intEnvironment = Int32.Parse(Request.QueryString["eid"]);
                }
                if (oEnvironment.Get(intEnvironment).Tables[0].Rows.Count > 0)
                {
                    ddlEnvironment.SelectedValue = intEnvironment.ToString();
                }
            }
            else
            {
                ddlEnvironment.Enabled = false;
                ddlEnvironment.Items.Insert(0, new ListItem("-- Please select a Class --", "0"));
            }
        }
Exemple #3
0
        private void LoadDetails()
        {
            StringBuilder sb = new StringBuilder(strDetails);

            DataSet ds = oCustomized.GetStorage3rd(intRequest, intItem, intNumber);

            if (ds.Tables[0].Rows.Count > 0)
            {
                int intUser = oRequest.GetUser(intRequest);

                sb.Append("<tr><td colspan=\"2\">Name of Requestor:</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(oUser.GetFullName(intUser));
                sb.Append(" (");
                sb.Append(oUser.GetName(intUser));
                sb.Append(")");
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">Statement of Work:</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["description"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">Server Name:</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["servername"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">Is this device already SAN Connected:</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["currently"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">What type of device is this:</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["type"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">What class is this device in:</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(oClass.Get(Int32.Parse(ds.Tables[0].Rows[0]["classid"].ToString()), "name"));
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">What environment is this device in:</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(oEnvironment.Get(Int32.Parse(ds.Tables[0].Rows[0]["environmentid"].ToString()), "name"));
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">What location is this device in:</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(oLocation.GetFull(Int32.Parse(ds.Tables[0].Rows[0]["addressid"].ToString())));
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">What fabric is the device on:</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["fabric"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">Is this device being replicated:</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["replicated"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">Please select a type of storage:</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["shared"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">Do you want to expand a LUN or add an additional LUN:</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["expand"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">Additional Total Capacity Needed (in GB):</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(double.Parse(ds.Tables[0].Rows[0]["amount"].ToString()).ToString("F"));
                sb.Append("</td></tr>");

                char[]   strSplit = { ',' };
                string[] strLUNs  = ds.Tables[0].Rows[0]["luns"].ToString().Split(strSplit);
                string   strLUN   = "";

                for (int ii = 0; ii < strLUNs.Length; ii++)
                {
                    if (strLUNs[ii].Trim() != "")
                    {
                        strLUN += strLUNs[ii].Trim() + "<br/>";
                    }
                }

                sb.Append("<tr><td colspan=\"2\">Please enter the LUN drive and UID, followed by the amount of storage you want to have added to that LUN (additional capacity only) (in GB):</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(strLUN);
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">Enter the World Wide Port names:</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["www"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">UID:</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["uid"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">Select the Storage Performance Tier:</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["performance"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">Clustered NODE Server Names:</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["node"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">Enclosure Name (if blade):</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["encname"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">Enclosure Slot (if blade):</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["encslot"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">Server name of DR device (if replicated):</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["repservername"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">World Wide Port names of the DR device (if replicated):</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["repwww"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">Enclosure Name (if blade and replicated):</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["repencname"].ToString());
                sb.Append("</td></tr>");
                sb.Append("<tr><td colspan=\"2\">Enclosure Slot (if blade and replicated):</td></tr>");
                sb.Append("<tr><td><img src=\"/images/spacer.gif\" border=\"0\" width=\"30\" height=\"1\" /></td><td width=\"100%\">");
                sb.Append(ds.Tables[0].Rows[0]["repencslot"].ToString());
                sb.Append("</td></tr>");

                txtAmount.Text   = double.Parse(ds.Tables[0].Rows[0]["allocated"].ToString()).ToString("F");
                lblMidrange.Text = ds.Tables[0].Rows[0]["midrange"].ToString();
            }

            if (sb.ToString() != "")
            {
                sb.Insert(0, "<table width=\"100%\" border=\"0\" cellSpacing=\"2\" cellPadding=\"4\" class=\"default\">");
                sb.Append("</table>");
            }

            strDetails = sb.ToString();
        }
Exemple #4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            AuthenticateUser();
            intProfile        = Int32.Parse(Request.Cookies["profileid"].Value);
            oAsset            = new Asset(intProfile, dsnAsset);
            oModelsProperties = new ModelsProperties(intProfile, dsn);
            oLocation         = new Locations(intProfile, dsn);
            oClass            = new Classes(intProfile, dsn);
            oEnvironment      = new Environments(intProfile, dsn);
            if (Request.QueryString["model"] != null && Request.QueryString["model"] != "" && Request.QueryString["status"] != null && Request.QueryString["status"] != "")
            {
                StringBuilder sb = new StringBuilder(strResults);
                intModel      = Int32.Parse(Request.QueryString["model"]);
                intStatus     = Int32.Parse(Request.QueryString["status"]);
                lblModel.Text = oModelsProperties.Get(intModel, "name");
                DataSet ds          = oAsset.GetServerOrBlades(intModel, intStatus);
                int     intLocation = 0;
                int     intClass    = 0;
                int     intEnv      = 0;
                int     intCount    = 0;
                bool    boolOther   = false;

                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    if (intLocation > 0 && intClass > 0 && intEnv > 0)
                    {
                        if (intLocation != Int32.Parse(dr["addressid"].ToString()) || intClass != Int32.Parse(dr["classid"].ToString()) || intEnv != Int32.Parse(dr["environmentid"].ToString()))
                        {
                            boolOther = !boolOther;
                            sb.Append("<tr");
                            sb.Append(boolOther ? " bgcolor=\"F6F6F6\"" : "");
                            sb.Append("><td>");
                            sb.Append(oClass.Get(intClass, "name"));
                            sb.Append("</td><td>");
                            sb.Append(oEnvironment.Get(intEnv, "name"));
                            sb.Append("</td><td>");
                            sb.Append(oLocation.GetFull(intLocation));
                            sb.Append("</td><td align=\"right\">");
                            sb.Append(intCount.ToString());
                            sb.Append("</td></tr>");
                            intCount = 0;
                        }
                    }
                    intCount++;
                    intLocation = Int32.Parse(dr["addressid"].ToString());
                    intClass    = Int32.Parse(dr["classid"].ToString());
                    intEnv      = Int32.Parse(dr["environmentid"].ToString());
                }

                boolOther = !boolOther;

                if (intLocation > 0 && intClass > 0 && intEnv > 0)
                {
                    sb.Append("<tr");
                    sb.Append(boolOther ? " bgcolor=\"F6F6F6\"" : "");
                    sb.Append("><td>");
                    sb.Append(oClass.Get(intClass, "name"));
                    sb.Append("</td><td>");
                    sb.Append(oEnvironment.Get(intEnv, "name"));
                    sb.Append("</td><td>");
                    sb.Append(oLocation.GetFull(intLocation));
                    sb.Append("</td><td align=\"right\">");
                    sb.Append(intCount.ToString());
                    sb.Append("</td></tr>");
                }

                strResults = sb.ToString();
            }
        }
        private void LoadSearch(int _search)
        {
            lblTitle.Text = "Search Results";
            ds            = oAsset.GetSearch(_search);
            if (ds.Tables[0].Rows.Count > 0)
            {
                panResult.Visible = true;
                lblSearch.Text    = _search.ToString();
                string strSort = "";
                if (Request.QueryString["sort"] != null && Request.QueryString["sort"] != "")
                {
                    strSort = "&sort=" + Request.QueryString["sort"];
                }
                btnPrint.Attributes.Add("onclick", "return OpenWindow('NEW_WINDOW','/frame/print_asset_search.aspx?sid=" + _search.ToString() + strSort + "');");
                if (ds.Tables[0].Rows[0]["userid"].ToString() == intProfile.ToString())
                {
                    string strSearch = ds.Tables[0].Rows[0]["type"].ToString();
                    switch (strSearch)
                    {
                    case "1":
                        if (ds.Tables[0].Rows[0]["name"].ToString().Trim() != "")
                        {
                            lblResults.Text = "Device Name LIKE &quot;" + ds.Tables[0].Rows[0]["name"].ToString().Trim() + "&quot;";
                        }
                        if (ds.Tables[0].Rows[0]["serial"].ToString().Trim() != "")
                        {
                            if (lblResults.Text != "")
                            {
                                lblResults.Text += " AND ";
                            }
                            lblResults.Text = "Serial Number LIKE &quot;" + ds.Tables[0].Rows[0]["serial"].ToString().Trim() + "&quot;";
                        }
                        if (ds.Tables[0].Rows[0]["asset"].ToString().Trim() != "")
                        {
                            if (lblResults.Text != "")
                            {
                                lblResults.Text += " AND ";
                            }
                            lblResults.Text = "Asset Tag LIKE &quot;" + ds.Tables[0].Rows[0]["asset"].ToString().Trim() + "&quot;";
                        }
                        break;

                    case "2":
                        if (ds.Tables[0].Rows[0]["classid"].ToString().Trim() != "0")
                        {
                            lblResults.Text = "Class = &quot;" + oClasses.Get(Int32.Parse(ds.Tables[0].Rows[0]["classid"].ToString().Trim()), "name") + "&quot;";
                        }
                        if (ds.Tables[0].Rows[0]["environmentid"].ToString().Trim() != "0")
                        {
                            if (lblResults.Text != "")
                            {
                                lblResults.Text += " AND ";
                            }
                            lblResults.Text += "Environment = &quot;" + oEnvironment.Get(Int32.Parse(ds.Tables[0].Rows[0]["environmentid"].ToString().Trim()), "name") + "&quot;";
                        }
                        break;

                    case "3":
                        string strPlatform = ds.Tables[0].Rows[0]["platformid"].ToString().Trim();
                        if (strPlatform != "" && strPlatform != "0")
                        {
                            lblResults.Text = "Platform = &quot;" + oPlatform.GetName(Int32.Parse(strPlatform)) + "&quot;";
                        }
                        string strType = ds.Tables[0].Rows[0]["typeid"].ToString().Trim();
                        if (strType != "" && strType != "0")
                        {
                            if (lblResults.Text != "")
                            {
                                lblResults.Text += " AND ";
                            }
                            lblResults.Text += "Asset Type = &quot;" + oType.Get(Int32.Parse(strType), "name") + "&quot;";
                        }
                        string strModel = ds.Tables[0].Rows[0]["modelid"].ToString().Trim();
                        if (strModel != "" && strModel != "0")
                        {
                            if (lblResults.Text != "")
                            {
                                lblResults.Text += " AND ";
                            }
                            lblResults.Text += "Model = &quot;" + oModel.Get(Int32.Parse(strModel), "name") + "&quot;";
                        }
                        break;

                    case "4":
                        string strDepot = ds.Tables[0].Rows[0]["depotid"].ToString().Trim();
                        if (strDepot != "" && strDepot != "0")
                        {
                            if (lblResults.Text != "")
                            {
                                lblResults.Text += " AND ";
                            }
                            lblResults.Text += "Depot = &quot;" + oDepot.Get(Int32.Parse(strDepot), "name") + "&quot;";
                        }
                        break;
                    }
                    ds           = oAsset.GetSearchResults(_search);
                    lblPage.Text = "1";
                    lblSort.Text = "";
                    if (Request.QueryString["page"] != null && Request.QueryString["page"] != "")
                    {
                        lblPage.Text = Request.QueryString["page"];
                    }
                    if (Request.QueryString["sort"] != null && Request.QueryString["sort"] != "")
                    {
                        lblSort.Text = Request.QueryString["sort"];
                    }
                    lblTopPaging.Text = "";
                    LoadPaging(Int32.Parse(lblPage.Text), lblSort.Text);
                }
                else
                {
                    panDenied.Visible = true;
                }
            }
            else
            {
                panDenied.Visible = true;
            }
        }
Exemple #6
0
 protected void Page_Load(object sender, EventArgs e)
 {
     intProfile       = Int32.Parse(Request.Cookies["profileid"].Value);
     oForecast        = new Forecast(intProfile, dsn);
     oServerName      = new ServerName(intProfile, dsn);
     oServer          = new Servers(intProfile, dsn);
     oPage            = new Pages(intProfile, dsn);
     oOperatingSystem = new OperatingSystems(intProfile, dsn);
     if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "")
     {
         intPage = Int32.Parse(Request.QueryString["pageid"]);
     }
     if (Request.QueryString["action"] != null && Request.QueryString["action"] != "")
     {
         panFinish.Visible = true;
     }
     else
     {
         if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "")
         {
             intApplication = Int32.Parse(Request.QueryString["applicationid"]);
         }
         if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "")
         {
             intApplication = Int32.Parse(Request.Cookies["application"].Value);
         }
         if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
         {
             intAnswer = Int32.Parse(Request.QueryString["id"]);
         }
         if (!IsPostBack)
         {
             if (intAnswer > 0)
             {
                 DataSet ds = oForecast.GetAnswer(intAnswer);
                 if (ds.Tables[0].Rows.Count > 0)
                 {
                     Projects         oProject          = new Projects(intProfile, dsn);
                     Requests         oRequest          = new Requests(intProfile, dsn);
                     Organizations    oOrganization     = new Organizations(intProfile, dsn);
                     Segment          oSegment          = new Segment(intProfile, dsn);
                     Platforms        oPlatform         = new Platforms(intProfile, dsn);
                     ModelsProperties oModelsProperties = new ModelsProperties(intProfile, dsn);
                     Confidence       oConfidence       = new Confidence(intProfile, dsn);
                     Classes          oClass            = new Classes(intProfile, dsn);
                     Environments     oEnvironment      = new Environments(intProfile, dsn);
                     Locations        oLocation         = new Locations(intProfile, dsn);
                     Users            oUser             = new Users(intProfile, dsn);
                     lblID.Text = intAnswer.ToString();
                     int intForecast = Int32.Parse(ds.Tables[0].Rows[0]["forecastid"].ToString());
                     int intRequest  = Int32.Parse(oForecast.Get(intForecast, "requestid"));
                     int intProject  = oRequest.GetProjectNumber(intRequest);
                     lblName.Text      = oProject.Get(intProject, "name");
                     lblNumber.Text    = oProject.Get(intProject, "number");
                     lblPortfolio.Text = oOrganization.GetName(Int32.Parse(oProject.Get(intProject, "organization")));
                     lblSegment.Text   = oSegment.GetName(Int32.Parse(oProject.Get(intProject, "segmentid")));
                     lblPlatform.Text  = oPlatform.GetName(Int32.Parse(ds.Tables[0].Rows[0]["platformid"].ToString()));
                     lblNickname.Text  = ds.Tables[0].Rows[0]["name"].ToString();
                     int intModel = Int32.Parse(ds.Tables[0].Rows[0]["modelid"].ToString());
                     if (intModel == 0)
                     {
                         intModel = oForecast.GetModelAsset(intAnswer);
                     }
                     if (intModel == 0)
                     {
                         intModel = oForecast.GetModel(intAnswer);
                     }
                     lblModel.Text      = oModelsProperties.Get(intModel, "name");
                     lblCommitment.Text = DateTime.Parse(ds.Tables[0].Rows[0]["implementation"].ToString()).ToLongDateString();
                     lblQuantity.Text   = ds.Tables[0].Rows[0]["quantity"].ToString();
                     lblConfidence.Text = oConfidence.Get(Int32.Parse(ds.Tables[0].Rows[0]["confidenceid"].ToString()), "name");
                     int intClass = Int32.Parse(ds.Tables[0].Rows[0]["classid"].ToString());
                     lblClass.Text = oClass.Get(intClass, "name");
                     if (oClass.IsProd(intClass))
                     {
                         panTest.Visible = true;
                         lblTest.Text    = (ds.Tables[0].Rows[0]["test"].ToString() == "1" ? "Yes" : "No");
                     }
                     lblEnvironment.Text = oEnvironment.Get(Int32.Parse(ds.Tables[0].Rows[0]["environmentid"].ToString()), "name");
                     lblLocation.Text    = oLocation.GetFull(Int32.Parse(ds.Tables[0].Rows[0]["addressid"].ToString()));
                     lblIP.Text          = ds.Tables[0].Rows[0]["workstation"].ToString();
                     lblDesignedBy.Text  = oUser.GetFullName(Int32.Parse(ds.Tables[0].Rows[0]["userid"].ToString()));
                     lblRequestor.Text   = ds.Tables[0].Rows[0]["userid"].ToString();
                     lblDesignedOn.Text  = DateTime.Parse(ds.Tables[0].Rows[0]["created"].ToString()).ToString();
                     lblUpdated.Text     = DateTime.Parse(ds.Tables[0].Rows[0]["modified"].ToString()).ToString();
                     panShow.Visible     = true;
                     btnSave.Enabled     = true;
                     // Load Components
                     rptApproval.DataSource = oServerName.GetComponentDetailUserApprovalsByUser(intProfile, intAnswer, 0);
                     rptApproval.DataBind();
                     foreach (RepeaterItem ri in rptApproval.Items)
                     {
                         int          intServer   = Int32.Parse(((Label)ri.FindControl("lblServer")).Text);
                         int          intDetail   = Int32.Parse(((Label)ri.FindControl("lblDetail")).Text);
                         RadioButton  radApprove  = (RadioButton)ri.FindControl("radApprove");
                         RadioButton  radDeny     = (RadioButton)ri.FindControl("radDeny");
                         HtmlTableRow trLicense   = (HtmlTableRow)ri.FindControl("trLicense");
                         HtmlTableRow trComments  = (HtmlTableRow)ri.FindControl("trComments");
                         TextBox      txtLicense  = (TextBox)ri.FindControl("txtLicense");
                         TextBox      txtComments = (TextBox)ri.FindControl("txtComments");
                         Label        lblOS       = (Label)ri.FindControl("lblOS");
                         int          intOS       = 0;
                         Int32.TryParse(oServer.Get(intServer, "osid"), out intOS);
                         lblOS.Text = oOperatingSystem.Get(intOS, "name");
                         radApprove.Attributes.Add("onclick", "ShowHideDiv('" + trLicense.ClientID + "','inline');ShowHideDiv('" + trComments.ClientID + "','inline');");
                         radDeny.Attributes.Add("onclick", "ShowHideDiv('" + trLicense.ClientID + "','none');ShowHideDiv('" + trComments.ClientID + "','inline');");
                         DataSet dsResult = oServerName.GetComponentDetailUserApprovals(intServer, intDetail);
                         if (dsResult.Tables[0].Rows.Count > 0)
                         {
                             // Load previous information
                             DataRow drResult = dsResult.Tables[0].Rows[0];
                             if (drResult["approved"].ToString() == "1")
                             {
                                 radApprove.Checked          = true;
                                 txtLicense.Text             = drResult["license"].ToString();
                                 trLicense.Style["display"]  = "inline";
                                 txtComments.Text            = drResult["comments"].ToString();
                                 trComments.Style["display"] = "inline";
                             }
                             if (drResult["approved"].ToString() == "0")
                             {
                                 radDeny.Checked             = true;
                                 txtComments.Text            = drResult["comments"].ToString();
                                 trComments.Style["display"] = "inline";
                             }
                         }
                     }
                 }
             }
         }
     }
 }
        private void LoadSearch(int _search)
        {
            Asset        oAsset       = new Asset(intProfile, dsnAsset);
            Classes      oClasses     = new Classes(intProfile, dsn);
            Environments oEnvironment = new Environments(intProfile, dsn);
            Platforms    oPlatform    = new Platforms(intProfile, dsn);
            Types        oType        = new Types(intProfile, dsn);
            Models       oModel       = new Models(intProfile, dsn);
            Depot        oDepot       = new Depot(intProfile, dsn);
            DataSet      ds           = oAsset.GetSearch(_search);

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["userid"].ToString() == intProfile.ToString())
                {
                    string strSearch = ds.Tables[0].Rows[0]["type"].ToString();

                    switch (strSearch)
                    {
                    case "N":
                        if (ds.Tables[0].Rows[0]["name"].ToString().Trim() != "")
                        {
                            lblResults.Text = "Device Name LIKE &quot;" + ds.Tables[0].Rows[0]["name"].ToString().Trim() + "&quot;";
                        }
                        if (ds.Tables[0].Rows[0]["serial"].ToString().Trim() != "")
                        {
                            if (lblResults.Text != "")
                            {
                                lblResults.Text += " AND ";
                            }
                            lblResults.Text = "Serial Number LIKE &quot;" + ds.Tables[0].Rows[0]["serial"].ToString().Trim() + "&quot;";
                        }
                        if (ds.Tables[0].Rows[0]["asset"].ToString().Trim() != "")
                        {
                            if (lblResults.Text != "")
                            {
                                lblResults.Text += " AND ";
                            }
                            lblResults.Text = "Asset Tag LIKE &quot;" + ds.Tables[0].Rows[0]["asset"].ToString().Trim() + "&quot;";
                        }
                        break;

                    case "C":
                        if (ds.Tables[0].Rows[0]["classid"].ToString().Trim() != "0")
                        {
                            lblResults.Text = "Class = &quot;" + oClasses.Get(Int32.Parse(ds.Tables[0].Rows[0]["classid"].ToString().Trim()), "name") + "&quot;";
                        }
                        if (ds.Tables[0].Rows[0]["environmentid"].ToString().Trim() != "0")
                        {
                            if (lblResults.Text != "")
                            {
                                lblResults.Text += " AND ";
                            }
                            lblResults.Text += "Environment = &quot;" + oEnvironment.Get(Int32.Parse(ds.Tables[0].Rows[0]["environmentid"].ToString().Trim()), "name") + "&quot;";
                        }
                        break;

                    case "T":
                        string strPlatform = ds.Tables[0].Rows[0]["platformid"].ToString().Trim();
                        if (strPlatform != "" && strPlatform != "0")
                        {
                            lblResults.Text = "Platform = &quot;" + oPlatform.GetName(Int32.Parse(strPlatform)) + "&quot;";
                        }
                        string strType = ds.Tables[0].Rows[0]["typeid"].ToString().Trim();
                        if (strType != "" && strType != "0")
                        {
                            if (lblResults.Text != "")
                            {
                                lblResults.Text += " AND ";
                            }
                            lblResults.Text += "Asset Type = &quot;" + oType.Get(Int32.Parse(strType), "name") + "&quot;";
                        }
                        string strModel = ds.Tables[0].Rows[0]["modelid"].ToString().Trim();
                        if (strModel != "" && strModel != "0")
                        {
                            if (lblResults.Text != "")
                            {
                                lblResults.Text += " AND ";
                            }
                            lblResults.Text += "Model = &quot;" + oModel.Get(Int32.Parse(strModel), "name") + "&quot;";
                        }
                        break;

                    case "D":
                        string strDepot = ds.Tables[0].Rows[0]["depotid"].ToString().Trim();
                        if (strDepot != "" && strDepot != "0")
                        {
                            if (lblResults.Text != "")
                            {
                                lblResults.Text += " AND ";
                            }
                            lblResults.Text += "Depot = &quot;" + oDepot.Get(Int32.Parse(strDepot), "name") + "&quot;";
                        }
                        break;
                    }
                    ds = oAsset.GetSearchResults(_search);
                    DataView dv = ds.Tables[0].DefaultView;
                    if (Request.QueryString["sort"] != null)
                    {
                        dv.Sort = Request.QueryString["sort"];
                    }
                    rptView.DataSource = dv;
                    rptView.DataBind();
                    lblNone.Visible = (rptView.Items.Count == 0);
                }
            }
        }
Exemple #8
0
        private void LoadLists()
        {
            ddlLocation.Enabled        = true;
            ddlLocation.DataValueField = "id";
            ddlLocation.DataTextField  = "name";
            ddlLocation.DataSource     = oLocation.GetAddressCommon();
            ddlLocation.DataBind();
            ddlLocation.Items.Add(new ListItem("-- NOT LISTED --", "-1"));
            ddlLocation.Items.Insert(0, new ListItem("-- SELECT --", "0"));
            int intAddress = 0;

            if (Request.QueryString["aid"] != null && Request.QueryString["aid"] != "")
            {
                intAddress = Int32.Parse(Request.QueryString["aid"]);
            }
            if (oLocation.GetAddress(intAddress).Tables[0].Rows.Count > 0)
            {
                ddlLocation.SelectedValue = intAddress.ToString();
                hdnParent.Value           = intAddress.ToString();
                if (ddlLocation.SelectedItem.Value == "0")
                {
                    ddlLocation.SelectedValue = "-1";
                    panLocation.Visible       = true;
                    txtParent.Text            = oLocation.GetFull(intAddress);
                }
                ddlOS.Enabled        = true;
                ddlOS.DataValueField = "id";
                ddlOS.DataTextField  = "name";
                ddlOS.DataSource     = oOperatingSystems.Gets(0, 1);
                ddlOS.DataBind();
                ddlOS.Items.Insert(0, new ListItem("-- SELECT --", "0"));
                int intOS = 0;
                if (Request.QueryString["osid"] != null && Request.QueryString["osid"] != "")
                {
                    intOS = Int32.Parse(Request.QueryString["osid"]);
                }
                if (oOperatingSystems.Get(intOS).Tables[0].Rows.Count > 0)
                {
                    ddlOS.SelectedValue  = intOS.ToString();
                    ddlSP.Enabled        = true;
                    ddlSP.DataValueField = "id";
                    ddlSP.DataTextField  = "name";
                    ddlSP.DataSource     = oOperatingSystems.GetServicePack(intOS);
                    ddlSP.DataBind();
                    ddlSP.Items.Insert(0, new ListItem("-- SELECT --", "0"));
                    int intSP = 0;
                    if (Request.QueryString["spid"] != null && Request.QueryString["spid"] != "")
                    {
                        intSP = Int32.Parse(Request.QueryString["spid"]);
                    }
                    if (oServicePacks.Get(intSP).Tables[0].Rows.Count > 0)
                    {
                        ddlSP.SelectedValue     = intSP.ToString();
                        ddlClass.Enabled        = true;
                        ddlClass.DataValueField = "id";
                        ddlClass.DataTextField  = "name";
                        ddlClass.DataSource     = oServerName.GetCodeClasses(intAddress);
                        ddlClass.DataBind();
                        lblConfig.Visible = (ddlClass.Items.Count == 0);
                        ddlClass.Items.Insert(0, new ListItem("-- SELECT --", "0"));
                        int intClass = 0;
                        if (Request.QueryString["cid"] != null && Request.QueryString["cid"] != "")
                        {
                            intClass = Int32.Parse(Request.QueryString["cid"]);
                        }
                        if (oClass.Get(intClass).Tables[0].Rows.Count > 0)
                        {
                            ddlClass.SelectedValue = intClass.ToString();
                            ddlEnvironment.Enabled = true;
                            Environments oEnvironment = new Environments(intProfile, dsn);
                            ddlEnvironment.DataValueField = "id";
                            ddlEnvironment.DataTextField  = "name";
                            ddlEnvironment.DataSource     = oServerName.GetCodeEnvironments(intAddress, intClass);
                            ddlEnvironment.DataBind();
                            lblConfig.Visible = (lblConfig.Visible || ddlEnvironment.Items.Count == 0);
                            ddlEnvironment.Items.Insert(0, new ListItem("-- SELECT --", "0"));
                            int intEnv = 0;
                            if (Request.QueryString["eid"] != null && Request.QueryString["eid"] != "")
                            {
                                intEnv = Int32.Parse(Request.QueryString["eid"]);
                            }
                            if (oEnvironment.Get(intEnv).Tables[0].Rows.Count > 0)
                            {
                                ddlEnvironment.SelectedValue = intEnv.ToString();
                                // Load Models
                                trModels.Visible = true;
                                LoadTypes(oTreeModels);
                                int intModel = 0;
                                if (Request.QueryString["mid"] != null && Request.QueryString["mid"] != "")
                                {
                                    intModel = Int32.Parse(Request.QueryString["mid"]);
                                }
                                if (oModelsProperties.Get(intModel).Tables[0].Rows.Count > 0)
                                {
                                    lblModel.Text = oModelsProperties.Get(intModel, "name");
                                    ExpandTreeview(oTreeModels, intModel.ToString(), true);
                                    // Load Applications
                                    ddlApplication.DataValueField = "id";
                                    ddlApplication.DataTextField  = "name";
                                    ddlApplication.DataSource     = oServerName.GetApplicationPermissionsOS(intOS);
                                    ddlApplication.DataBind();
                                    ddlApplication.Items.Insert(0, new ListItem("-- NONE --", "0"));
                                    // Load Components
                                    panComponents.Visible = true;
                                    frmComponents.Attributes.Add("src", "/frame/ondemand/config_server_components.aspx?cid=" + intClass.ToString() + "&eid=" + intEnv.ToString() + "&mid=" + intModel.ToString() + "&osid=" + intOS.ToString() + "&spid=" + intSP.ToString());
                                    // Load Clustering
                                    ddlCluster.Items.Add(new ListItem("-- SELECT --", "0"));
                                    ddlCluster.Items.Add(new ListItem("Node of a Cluster (Example: NSQ)", "1"));
                                    if (oOperatingSystems.Get(intOS, "cluster_name") == "1")
                                    {
                                        ddlCluster.Items.Add(new ListItem("Cluster Name (Example: CLU)", "2"));
                                    }
                                    ddlCluster.Items.Add(new ListItem("Cluster Instance Name (Example: CSQ)", "3"));
                                    ddlCluster.Items.Add(new ListItem("None of the Above", "4"));
                                    btnSubmit.Enabled = true;
                                }
                                else
                                {
                                    lblModel.Text          = "<i>Please select a Model</i>";
                                    ddlApplication.Enabled = false;
                                    ddlApplication.Items.Insert(0, new ListItem("-- Please select a Model --", "0"));
                                    ddlCluster.Enabled = false;
                                    ddlCluster.Items.Insert(0, new ListItem("-- Please select a Model --", "0"));
                                }
                            }
                            else
                            {
                                lblModel.Text          = "<i>Please select an Environment</i>";
                                ddlApplication.Enabled = false;
                                ddlApplication.Items.Insert(0, new ListItem("-- Please select an Environment --", "0"));
                                ddlCluster.Enabled = false;
                                ddlCluster.Items.Insert(0, new ListItem("-- Please select an Environment --", "0"));
                            }
                        }
                        else
                        {
                            ddlEnvironment.Enabled = false;
                            ddlEnvironment.Items.Insert(0, new ListItem("-- Please select a Class --", "0"));
                            lblModel.Text          = "<i>Please select a Class</i>";
                            ddlApplication.Enabled = false;
                            ddlApplication.Items.Insert(0, new ListItem("-- Please select a Class --", "0"));
                            ddlCluster.Enabled = false;
                            ddlCluster.Items.Insert(0, new ListItem("-- Please select a Class --", "0"));
                            txtName.Enabled = false;
                        }
                    }
                    else
                    {
                        ddlClass.Enabled = false;
                        ddlClass.Items.Insert(0, new ListItem("-- Please select a Service Pack --", "0"));
                        ddlEnvironment.Enabled = false;
                        ddlEnvironment.Items.Insert(0, new ListItem("-- Please select a Service Pack --", "0"));
                        lblModel.Text          = "<i>Please select a Service Pack</i>";
                        ddlApplication.Enabled = false;
                        ddlApplication.Items.Insert(0, new ListItem("-- Please select a Service Pack --", "0"));
                        ddlCluster.Enabled = false;
                        ddlCluster.Items.Insert(0, new ListItem("-- Please select a Service Pack --", "0"));
                        txtName.Enabled = false;
                    }
                }
                else
                {
                    ddlSP.Enabled = false;
                    ddlSP.Items.Insert(0, new ListItem("-- Please select an Operating System --", "0"));
                    ddlClass.Enabled = false;
                    ddlClass.Items.Insert(0, new ListItem("-- Please select an Operating System --", "0"));
                    ddlEnvironment.Enabled = false;
                    ddlEnvironment.Items.Insert(0, new ListItem("-- Please select an Operating System --", "0"));
                    lblModel.Text          = "<i>Please select an Operating System</i>";
                    ddlApplication.Enabled = false;
                    ddlApplication.Items.Insert(0, new ListItem("-- Please select an Operating System --", "0"));
                    ddlCluster.Enabled = false;
                    ddlCluster.Items.Insert(0, new ListItem("-- Please select an Operating System --", "0"));
                    txtName.Enabled = false;
                }
            }
            else
            {
                ddlLocation.SelectedValue = intAddress.ToString();
                if (intAddress == -1)
                {
                    panLocation.Visible = true;
                    hdnParent.Value     = "0";
                }
                ddlOS.Enabled = false;
                ddlOS.Items.Insert(0, new ListItem("-- Please select a Location --", "0"));
                ddlSP.Enabled = false;
                ddlSP.Items.Insert(0, new ListItem("-- Please select a Location --", "0"));
                ddlClass.Enabled = false;
                ddlClass.Items.Insert(0, new ListItem("-- Please select a Location --", "0"));
                ddlEnvironment.Enabled = false;
                ddlEnvironment.Items.Insert(0, new ListItem("-- Please select a Location --", "0"));
                lblModel.Text          = "<i>Please select a Location</i>";
                ddlApplication.Enabled = false;
                ddlApplication.Items.Insert(0, new ListItem("-- Please select a Location --", "0"));
                ddlCluster.Enabled = false;
                ddlCluster.Items.Insert(0, new ListItem("-- Please select a Location --", "0"));
                txtName.Enabled = false;
            }
        }
Exemple #9
0
        protected void Page_Load(object sender, EventArgs e)
        {
            intProfile        = Int32.Parse(Request.Cookies["profileid"].Value);
            oDesign           = new Design(intProfile, dsn);
            oPage             = new Pages(intProfile, dsn);
            oMnemonic         = new Mnemonic(intProfile, dsn);
            oCostCenter       = new CostCenter(intProfile, dsn);
            oClass            = new Classes(intProfile, dsn);
            oEnvironment      = new Environments(intProfile, dsn);
            oLocation         = new Locations(intProfile, dsn);
            oOperatingSystem  = new OperatingSystems(intProfile, dsn);
            oHoliday          = new Holidays(intProfile, dsn);
            oModelsProperties = new ModelsProperties(intProfile, dsn);
            oUser             = new Users(intProfile, dsn);
            oFunction         = new Functions(intProfile, dsn, intEnvironment);
            oForecast         = new Forecast(intProfile, dsn);
            oRequest          = new Requests(intProfile, dsn);
            oProject          = new Projects(intProfile, dsn);

            //if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
            //intID = Int32.Parse(Request.QueryString["id"]);
            if (!IsPostBack)
            {
                DataSet dsSummary = oDesign.Get(this.DesignId);
                if (dsSummary.Tables[0].Rows.Count > 0)
                {
                    int intModel = oDesign.GetModelProperty(this.DesignId);
                    lblSummarySolution.Text = oModelsProperties.Get(intModel, "name");

                    DataRow drSummary   = dsSummary.Tables[0].Rows[0];
                    bool    boolWeb     = (drSummary["web"].ToString() == "1");
                    bool    boolSQL     = oDesign.IsSQL(this.DesignId);
                    bool    boolOracle  = oDesign.IsOracle(this.DesignId);
                    bool    boolOtherDB = (drSummary["other_db"].ToString() == "1");

                    DataSet dsSubmitted = oDesign.GetSubmitted(this.DesignId);
                    if (dsSubmitted.Tables[0].Rows.Count > 0)
                    {
                        trSubmitted.Visible = true;
                        int intUser = Int32.Parse(dsSubmitted.Tables[0].Rows[0]["userid"].ToString());
                        lblSummarySubmittedBy.Text = oUser.GetFullName(intUser) + " (" + oUser.GetName(intUser) + ")";
                        lblSummarySubmittedOn.Text = dsSubmitted.Tables[0].Rows[0]["created"].ToString();
                        if (dsSubmitted.Tables[0].Rows[0]["comments"].ToString() != "")
                        {
                            trException1.Visible = true;
                            trException2.Visible = true;
                            trException3.Visible = true;
                            lblException.Text    = oFunction.FormatText(dsSubmitted.Tables[0].Rows[0]["comments"].ToString());
                            lblExceptionID.Text  = dsSubmitted.Tables[0].Rows[0]["exceptionID"].ToString();
                        }
                    }

                    // Project
                    int intForecast = 0;
                    int intRequest  = 0;
                    int intProject  = 0;
                    Int32.TryParse(drSummary["forecastid"].ToString(), out intForecast);
                    if (intForecast > 0)
                    {
                        Int32.TryParse(oForecast.Get(intForecast, "requestid"), out intRequest);
                        if (intRequest > 0)
                        {
                            intProject = oRequest.GetProjectNumber(intRequest);
                            if (intProject > 0)
                            {
                                lblSummaryProjectName.Text = oProject.Get(intProject, "name");
                                string strNumber = oProject.Get(intProject, "number");
                                lblSummaryProjectNumber.Text = strNumber;
                                // Check to see if Demo
                                DataSet dsDemo = oFunction.GetSetupValuesByKey("DEMO_PROJECT");
                                foreach (DataRow drDemo in dsDemo.Tables[0].Rows)
                                {
                                    if (strNumber == drDemo["Value"].ToString())
                                    {
                                        boolDemo = true;
                                        break;
                                    }
                                }
                            }
                        }
                    }

                    // Mnemonic
                    int intMnemonic = 0;
                    Int32.TryParse(drSummary["mnemonicid"].ToString(), out intMnemonic);
                    if (intMnemonic > 0)
                    {
                        lblSummaryMnemonic.Text = oMnemonic.Get(intMnemonic, "factory_code") + " - " + oMnemonic.Get(intMnemonic, "name");
                    }
                    // Class + Environment + Location
                    int intClass   = 0;
                    int intEnv     = 0;
                    int intAddress = 0;
                    Int32.TryParse(drSummary["classid"].ToString(), out intClass);
                    if (intClass > 0)
                    {
                        lblSummaryLocation.Text = oClass.Get(intClass, "name") + ", ";
                        Int32.TryParse(drSummary["environmentid"].ToString(), out intEnv);
                        if (intEnv > 0)
                        {
                            lblSummaryLocation.Text += oEnvironment.Get(intEnv, "name");
                            Int32.TryParse(drSummary["addressid"].ToString(), out intAddress);
                            if (intAddress > 0)
                            {
                                lblSummaryLocation.Text += " at <a href=\"javascript:void(0);\" onclick=\"ShowHideDiv2('divLocation');\">" + oLocation.GetFull(intAddress) + " <img src=\"/images/help.gif\" border=\"0\" align=\"absmiddle\"/></a>";
                            }
                            else
                            {
                                bool    boolProd    = oClass.IsProd(intClass);
                                bool    boolQA      = oClass.IsQA(intClass);
                                bool    boolTest    = oClass.IsTestDev(intClass);
                                bool    boolDR      = oClass.IsDR(intClass);
                                DataSet dsLocations = oLocation.GetAddressClass((boolDR ? 1 : 0), (boolProd ? 1 : 0), (boolQA ? 1 : 0), (boolTest ? 1 : 0));
                                if (dsLocations.Tables[0].Rows.Count > 0)
                                {
                                    StringBuilder strLocation      = new StringBuilder();
                                    int           intLocationCount = 0;
                                    foreach (DataRow drLocation in dsLocations.Tables[0].Rows)
                                    {
                                        intLocationCount++;
                                        if (intLocationCount > 1)
                                        {
                                            if (intLocationCount > 2)
                                            {
                                                strLocation.Insert(0, ", ");
                                            }
                                            else
                                            {
                                                strLocation.Insert(0, " or ");
                                            }
                                        }
                                        if (drLocation["commonname"].ToString() != "")
                                        {
                                            strLocation.Insert(0, drLocation["commonname"].ToString());
                                        }
                                        else
                                        {
                                            strLocation.Insert(0, oLocation.GetFull(Int32.Parse(drLocation["id"].ToString())));
                                        }
                                    }
                                    lblSummaryLocation.Text += " at <a href=\"javascript:void(0);\" onclick=\"ShowHideDiv2('divLocation');\">" + strLocation.ToString() + " <img src=\"/images/help.gif\" border=\"0\" align=\"absmiddle\"/></a>";
                                }
                            }
                        }
                    }
                    // Server Type
                    if (oDesign.IsDatabase(this.DesignId) == false)
                    {
                        if (boolWeb)
                        {
                            lblSummaryServerType.Text = "Web";
                        }
                        else
                        {
                            lblSummaryServerType.Text = "Application";
                        }
                    }
                    else
                    {
                        lblSummaryServerType.Text = "Database";
                        if (boolSQL || boolOracle || boolOtherDB)
                        {
                            string strDatabase = "";
                            if (boolSQL == true)
                            {
                                strDatabase = "SQL";
                            }
                            if (boolOracle == true)
                            {
                                strDatabase = "Oracle";
                            }
                            if (boolOtherDB == true)
                            {
                                strDatabase = "Other";
                            }
                            lblSummaryServerType.Text += " (" + strDatabase + ")";
                        }
                        if (boolWeb)
                        {
                            lblSummaryServerType.Text += " + Web";
                        }
                    }
                    // Quantity
                    int intQuantity = 0;
                    Int32.TryParse(drSummary["quantity"].ToString(), out intQuantity);
                    if (intQuantity > 0)
                    {
                        lblSummaryQuantity.Text = intQuantity.ToString();
                    }
                    // OS
                    int intOS = 0;
                    Int32.TryParse(drSummary["osid"].ToString(), out intOS);
                    if (intOS > 0)
                    {
                        lblSummaryOS.Text = oOperatingSystem.Get(intOS, "name");
                    }
                    // SIZE
                    string strSize = drSummary["cores"].ToString() + " CPU(s), " + drSummary["ram"].ToString() + " GB(s) RAM";
                    lblSummarySize.Text = strSize;
                    // STORAGE
                    if (drSummary["storage"].ToString() == "1")
                    {
                        if (drSummary["persistent"].ToString() == "1")
                        {
                            int intPersistent = oDesign.GetStorageTotal(this.DesignId);
                            if (intPersistent > 0)
                            {
                                lblSummaryStorage.Text = "Persistent, " + intPersistent.ToString() + " GB(s)";
                            }
                        }
                        else if (drSummary["persistent"].ToString() == "0")
                        {
                            int intNonPersistent = 0;
                            Int32.TryParse(drSummary["non_persistent"].ToString(), out intNonPersistent);
                            if (intNonPersistent > 0)
                            {
                                lblSummaryStorage.Text = "Non-Persistent, " + intNonPersistent.ToString() + " GB(s)";
                            }
                        }
                        else
                        {
                            int intStorage = oDesign.GetStorageTotal(this.DesignId);
                            if (intStorage > 0)
                            {
                                lblSummaryStorage.Text = intStorage.ToString() + " GB(s)";
                            }
                        }
                    }
                    else if (drSummary["storage"].ToString() == "0")
                    {
                        lblSummaryStorage.Text = "No";
                    }
                    // HA
                    if (drSummary["ha"].ToString() == "1")
                    {
                        if (oModelsProperties.IsSUNVirtual(intModel) == true)
                        {
                            lblSummaryHA.Text = "Sun Virtual Environment (SVE)";
                        }
                        else if (drSummary["ha_clustering"].ToString() == "1")
                        {
                            lblSummaryHA.Text = "Clustered";
                            if (drSummary["active_passive"].ToString() == "1")
                            {
                                lblSummaryHA.Text += " (Active / Passive)";
                            }
                            else if (drSummary["active_passive"].ToString() == "2")
                            {
                                lblSummaryHA.Text += " (Active / Active)";
                            }
                        }
                        else if (drSummary["ha_load_balancing"].ToString() == "1")
                        {
                            lblSummaryHA.Text = "Load Balancing";
                        }
                    }
                    else if (drSummary["ha"].ToString() == "0")
                    {
                        lblSummaryHA.Text = "No";
                    }
                    else
                    {
                        lblSummaryHA.Text = "<i>N / A</i>";
                    }
                    // SPECIAL
                    if (oModelsProperties.IsVMwareVirtual(intModel))
                    {
                        lblSummaryBootType.Text = "Virtual Hard Disk (VHD)";
                    }
                    else if (oModelsProperties.IsStorageDB_BootLocal(intModel))
                    {
                        lblSummaryBootType.Text = "Local Disk";
                    }
                    else
                    {
                        lblSummaryBootType.Text = "SAN Disk";
                    }
                    // DATE
                    DateTime datDate = DateTime.Now;
                    if (DateTime.TryParse(drSummary["commitment"].ToString(), out datDate) == true)
                    {
                        lblSummaryDate.Text = datDate.ToShortDateString();
                        // Target completion date = 2 weeks later than commitment
                        DateTime datTarget = oHoliday.GetDays(dblSLA, datDate);
                        string   strTarget = datTarget.ToShortDateString();
                        if (strTarget != "")
                        {
                            lblSummaryTarget.Text = strTarget + "&nbsp;&nbsp;&nbsp;&nbsp;(<a href=\"javascript:void(0);\" onclick=\"alert('" + strTarget + " is " + dblSLA.ToString() + " business days from your build date (" + lblSummaryDate.Text + ").\\n\\nBusiness days exclude weekends and holidays.');\">How is this calculated?</a>)";
                        }
                    }
                    // CONFIDENCE
                    lblSummaryConfidence.Text = drSummary["confidence"].ToString();
                    //if (oDesign.IsOther(this.DesignId, 1, 0, 0) == true)
                    //    btnUnlock.Visible = true;
                    btnUnlock.Attributes.Add("onclick", "return OpenWindow('DESIGN_UNLOCK','" + this.DesignId.ToString() + "')");

                    /*
                     * if (drSummary["answerid"].ToString() == "")
                     *  lblSummaryAnswerID.Text = "N / A";
                     * else
                     *  lblSummaryAnswerID.Text = "<a href=\"javascript:void(0);\" onclick=\"OpenNewWindow('/datapoint/service/design.aspx?t=design&q=" + oFunction.encryptQueryString(drSummary["answerid"].ToString()) + "',800,600);\">" + drSummary["answerid"].ToString() + "</a>";
                     */

                    if (this.ExceptionServiceFolder > 0)
                    {
                        this.ExceptionRadio.Visible = false;
                    }

                    if (this.ExceptionServiceFolder > 0 && oDesign.IsOther(this.DesignId, 0, 0, 1))
                    {
                        this.ExceptionServiceFolderPanel.Visible = true;
                        this.CompleteRadio.Enabled = false;
                    }
                    else
                    {
                        string strValidation = oDesign.GetValid(this.DesignId);
                        if (strValidation != "")
                        {
                            // Invalid Design
                            if (this.InvalidPanel != null)
                            {
                                this.InvalidPanel.Style["display"] = "inline";
                            }
                            // Hide the Rejection screen (if shown)
                            if (this.RejectPanel != null)
                            {
                                this.RejectPanel.Style["display"] = "none";
                            }

                            if (this.Demo == false && this.CompleteRadio != null)
                            {
                                this.CompleteRadio.Text   += " <i>(Incomplete)</i>";
                                this.CompleteRadio.Enabled = false;
                            }
                            if (this.ValidationLabel != null)
                            {
                                string[] strValidations = strValidation.Split(new char[] { ',' });
                                foreach (string strError in strValidations)
                                {
                                    if (strError.Trim() != "")
                                    {
                                        if (this.ValidationLabel.Text != "")
                                        {
                                            this.ValidationLabel.Text += "<br/>";
                                        }
                                        this.ValidationLabel.Text += " - " + strError.Trim();
                                    }
                                }
                            }
                        }
                        else
                        {
                            btnUnlock.Visible = false;

                            // Valid Design
                            if (this.RejectPanel == null || this.RejectPanel.Style["display"] != "inline")
                            {
                                if (oDesign.IsOther(this.DesignId, 0, 0, 1) == true)
                                {
                                    if (this.ExceptionPanel != null)
                                    {
                                        this.ExceptionPanel.Style["display"] = "inline";
                                    }
                                }
                                else if (this.ValidPanel != null)
                                {
                                    this.ValidPanel.Style["display"] = "inline";
                                }
                            }
                            // Check confidence and Date
                            string strCanExecute = oDesign.CanExecute(this.DesignId);
                            if (this.Demo == true)
                            {
                                if (strCanExecute != "")
                                {
                                    this.InvalidPanel.Style["display"] = "inline";
                                }
                                if (this.ValidationLabel != null)
                                {
                                    this.ValidationLabel.Text = " - " + strCanExecute;
                                }
                            }
                            else if (this.CompleteRadio != null)
                            {
                                if (strCanExecute != "")
                                {
                                    this.CompleteRadio.Text += " <i>(" + strCanExecute + ")</i>";
                                }

                                if (this.CompleteRadio.Text.Contains("<i>"))
                                {
                                    this.CompleteRadio.Enabled = false;
                                    this.CompleteRadio.Checked = false;
                                }
                            }
                        }

                        if (this.Demo == true && InvalidPanel.Style["display"] == "inline")
                        {
                            ValidPanel.Style["display"] = "none";
                            CompleteRadio.Enabled       = false;
                            ScheduleRadio.Enabled       = false;
                        }
                    }
                }
            }
        }
Exemple #10
0
        protected void Page_Load(object sender, EventArgs e)
        {
            Servers          oServer           = new Servers(0, dsn);
            VMWare           oVMWare           = new VMWare(0, dsn);
            Forecast         oForecast         = new Forecast(0, dsn);
            Environments     oEnvironment      = new Environments(0, dsn);
            OperatingSystems oOperatingSystem  = new OperatingSystems(0, dsn);
            Classes          oClass            = new Classes(0, dsn);
            Requests         oRequest          = new Requests(0, dsn);
            Projects         oProject          = new Projects(0, dsn);
            ServerName       oServerName       = new ServerName(0, dsn);
            Locations        oLocations        = new Locations(0, dsn);
            ModelsProperties oModelsProperties = new ModelsProperties(0, dsn);
            ServicePacks     oServicePacks     = new ServicePacks(0, dsn);
            Users            oUser             = new Users(0, dsn);
            Organizations    oOrganization     = new Organizations(0, dsn);
            IPAddresses      oIPAddresses      = new IPAddresses(0, dsnIP, dsn);
            ResourceRequest  oResourceRequest  = new ResourceRequest(0, dsn);
            Domains          oDomains          = new Domains(0, dsn);

            oVariables = new Variables(intEnvironment);
            if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
            {
                StringBuilder sbTable   = new StringBuilder(strTable);
                int           intServer = Int32.Parse(Request.QueryString["id"]);
                DataSet       ds        = oServer.Get(intServer);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    int    intAnswer   = Int32.Parse(ds.Tables[0].Rows[0]["answerid"].ToString());
                    int    intName     = Int32.Parse(ds.Tables[0].Rows[0]["nameid"].ToString());
                    string strName     = oServer.GetName(intServer, boolUsePNCNaming);
                    int    intForecast = Int32.Parse(oForecast.GetAnswer(intAnswer, "forecastid"));
                    int    intRequest  = Int32.Parse(oForecast.Get(intForecast, "requestid"));
                    int    intProject  = oRequest.GetProjectNumber(intRequest);
                    int    intClass    = Int32.Parse(oForecast.GetAnswer(intAnswer, "classid"));
                    int    intEnv      = Int32.Parse(oForecast.GetAnswer(intAnswer, "environmentid"));
                    int    intModel    = Int32.Parse(ds.Tables[0].Rows[0]["modelid"].ToString());

                    string _save_location = oVariables.UploadsFolder() + "SC\\";
                    string strFileName    = "SC_" + intServer.ToString() + "_" + oProject.Get(intProject, "number") + ".HTM";
                    if (Directory.Exists(_save_location) == false)
                    {
                        Directory.CreateDirectory(_save_location);
                    }
                    string       strFile = _save_location + strFileName;
                    StreamWriter fp      = File.CreateText(strFile);


                    string strDefault = "<table cellpadding=\"2\" cellspacing=\"2\" border=\"0\" class=\"default\">";

                    StringBuilder sbLeft1 = new StringBuilder();
                    string        strLead = oProject.Get(intProject, "lead");
                    int           intLead = 0;
                    if (strLead != "")
                    {
                        intLead = Int32.Parse(strLead);
                    }
                    sbLeft1.Append("<fieldset>");
                    sbLeft1.Append("<legend><b>Who is this for?</b></legend>");
                    sbLeft1.Append(strDefault);
                    sbLeft1.Append("<tr>");
                    sbLeft1.Append("<td>Client XID:</td>");
                    sbLeft1.Append("<td>");
                    sbLeft1.Append(GetBox(intLead > 0 ? oUser.GetName(intLead) : "***ERROR**", 200));
                    sbLeft1.Append("</td>");
                    sbLeft1.Append("</tr>");
                    sbLeft1.Append("<tr>");
                    sbLeft1.Append("<td>Client Name:</td>");
                    sbLeft1.Append("<td>");
                    sbLeft1.Append(GetBox(intLead > 0 ? oUser.GetFullName(intLead) : "***ERROR**", 200));
                    sbLeft1.Append("</td>");
                    sbLeft1.Append("</tr>");
                    sbLeft1.Append("<tr>");
                    sbLeft1.Append("<td>Client Phone No.:</td>");
                    sbLeft1.Append("<td>");
                    sbLeft1.Append(GetBox(intLead > 0 ? oUser.Get(intLead, "phone") : "***ERROR**", 200));
                    sbLeft1.Append("</td>");
                    sbLeft1.Append("</tr>");
                    sbLeft1.Append("<tr>");
                    sbLeft1.Append("<td>Client Department:</td>");
                    sbLeft1.Append("<td>");
                    sbLeft1.Append(GetBox("", 200));
                    sbLeft1.Append("</td>");
                    sbLeft1.Append("</tr>");
                    sbLeft1.Append("<tr>");
                    sbLeft1.Append("<td>Client Fax:</td>");
                    sbLeft1.Append("<td>");
                    sbLeft1.Append(GetBox("", 200));
                    sbLeft1.Append("</td>");
                    sbLeft1.Append("</tr>");
                    sbLeft1.Append("<tr>");
                    sbLeft1.Append("<td>Client Cost Center:</td>");
                    sbLeft1.Append("<td>");
                    sbLeft1.Append(GetBox("", 200));
                    sbLeft1.Append("</td>");
                    sbLeft1.Append("</tr>");
                    sbLeft1.Append("</table>");
                    sbLeft1.Append("</fieldset>");

                    StringBuilder sbRight1 = new StringBuilder();
                    string        strIE    = oProject.Get(intProject, "engineer");
                    int           intIE    = 0;
                    if (strIE != "")
                    {
                        intIE = Int32.Parse(strIE);
                    }
                    sbRight1.Append("<fieldset>");
                    sbRight1.Append("<legend><b>Requestor Information</b></legend>");
                    sbRight1.Append(strDefault);
                    sbRight1.Append("<tr>");
                    sbRight1.Append("<td>Requested By Name:</td>");
                    sbRight1.Append("<td>");
                    sbRight1.Append(GetBox(intIE > 0 ? oUser.GetFullName(intIE) : "***ERROR**", 200));
                    sbRight1.Append("</td>");
                    sbRight1.Append("</tr>");
                    sbRight1.Append("<tr>");
                    sbRight1.Append("<td>Requested By Phone No.:</td>");
                    sbRight1.Append("<td>");
                    sbRight1.Append(GetBox(intIE > 0 ? oUser.Get(intIE, "phone") : "***ERROR**", 200));
                    sbRight1.Append("</td>");
                    sbRight1.Append("</tr>");
                    sbRight1.Append("<tr>");
                    sbRight1.Append("<td>Requested By Email:</td>");
                    sbRight1.Append("<td>");
                    sbRight1.Append(GetBox(intIE > 0 ? oUser.GetEmail(oUser.GetName(intIE), intEnvironment) : "***ERROR**", 200));
                    sbRight1.Append("</td>");
                    sbRight1.Append("</tr>");
                    sbRight1.Append("</table>");
                    sbRight1.Append("</fieldset>");
                    sbRight1.Append("<fieldset>");
                    sbRight1.Append("<legend><b>Location Information:</b></legend>");
                    sbRight1.Append(strDefault);
                    sbRight1.Append("<tr>");
                    sbRight1.Append("<td>Location:</td>");
                    sbRight1.Append("<td>");
                    sbRight1.Append(GetBox("", 200));
                    sbRight1.Append("</td>");
                    sbRight1.Append("</tr>");
                    sbRight1.Append("<tr>");
                    sbRight1.Append("<td>Location Full Name:</td>");
                    sbRight1.Append("<td>");
                    sbRight1.Append(GetBox("", 200));
                    sbRight1.Append("</td>");
                    sbRight1.Append("</tr>");
                    sbRight1.Append("</table>");
                    sbRight1.Append("</fieldset>");

                    StringBuilder sbCenter1 = new StringBuilder();
                    sbCenter1.Append("<fieldset>");
                    sbCenter1.Append("<legend><b>Brief Desc:</b></legend>");
                    sbCenter1.Append(strDefault);
                    sbCenter1.Append("<tr>");
                    sbCenter1.Append("<td>");
                    sbCenter1.Append(GetBox(oForecast.GetAnswer(intAnswer, "name") + " (" + strName + ")", 600));
                    sbCenter1.Append("</td>");
                    sbCenter1.Append("</tr>");
                    sbCenter1.Append("</table>");
                    sbCenter1.Append("</fieldset>");

                    StringBuilder sbLeft2 = new StringBuilder();
                    sbLeft2.Append("<fieldset>");
                    sbLeft2.Append("<legend><b>Project Information:</b></legend>");
                    sbLeft2.Append(strDefault);
                    sbLeft2.Append("<tr>");
                    sbLeft2.Append("<td>Project ID:</td>");
                    sbLeft2.Append("<td>");
                    sbLeft2.Append(GetBox(oProject.Get(intProject, "number"), 200));
                    sbLeft2.Append("</td>");
                    sbLeft2.Append("<td>Project Manager XID:</td>");
                    sbLeft2.Append("<td>");
                    sbLeft2.Append(GetBox(intLead > 0 ? oUser.GetName(intLead) : "***ERROR**", 200));
                    sbLeft2.Append("</td>");
                    sbLeft2.Append("</tr>");
                    sbLeft2.Append("<tr>");
                    sbLeft2.Append("<td>Project Name:</td>");
                    sbLeft2.Append("<td>");
                    sbLeft2.Append(GetBox(oProject.Get(intProject, "name"), 200));
                    sbLeft2.Append("</td>");
                    sbLeft2.Append("<td>Project Manager Name:</td>");
                    sbLeft2.Append("<td>");
                    sbLeft2.Append(GetBox(intLead > 0 ? oUser.GetFullName(intLead) : "***ERROR**", 200));
                    sbLeft2.Append("</td>");
                    sbLeft2.Append("</tr>");
                    sbLeft2.Append("<tr>");
                    sbLeft2.Append("<td>Project Budgeted:</td>");
                    sbLeft2.Append("<td>");
                    sbLeft2.Append(GetBox(oProject.Get(intProject, "bd"), 200));
                    sbLeft2.Append("</td>");
                    sbLeft2.Append("<td>Project Manager Phone:</td>");
                    sbLeft2.Append("<td>");
                    sbLeft2.Append(GetBox(intLead > 0 ? oUser.Get(intLead, "phone") : "***ERROR**", 200));
                    sbLeft2.Append("</td>");
                    sbLeft2.Append("</tr>");
                    sbLeft2.Append("<tr>");
                    sbLeft2.Append("<td>Project Cost Ctr:</td>");
                    sbLeft2.Append("<td>");
                    sbLeft2.Append(GetBox("", 200));
                    sbLeft2.Append("</td>");
                    sbLeft2.Append("<td>Project Manager Email:</td>");
                    sbLeft2.Append("<td>");
                    sbLeft2.Append(GetBox(intLead > 0 ? oUser.GetEmail(oUser.GetName(intLead), intEnvironment) : "***ERROR**", 200));
                    sbLeft2.Append("</td>");
                    sbLeft2.Append("</tr>");
                    sbLeft2.Append("</table>");
                    sbLeft2.Append("</fieldset>");

                    OnDemandTasks oOnDemandTasks = new OnDemandTasks(0, dsn);
                    int           intImplementor = 0;
                    DataSet       dsTasks        = oOnDemandTasks.GetPending(intAnswer);
                    if (dsTasks.Tables[0].Rows.Count > 0)
                    {
                        intImplementor = Int32.Parse(dsTasks.Tables[0].Rows[0]["resourceid"].ToString());
                        intImplementor = Int32.Parse(oResourceRequest.GetWorkflow(intImplementor, "userid"));
                    }
                    else
                    {
                        intImplementor = -999;
                    }
                    sbTable = new StringBuilder("<table cellpadding=\"2\" cellspacing=\"2\" border=\"0\" class=\"default\">");
                    sbTable.Append("<tr>");
                    sbTable.Append("<td colspan=\"2\"><b>NOTE:</b> ASSIGN THIS REQUEST TO: ");
                    sbTable.Append(intImplementor > 0 || intImplementor == -999 ? oUser.GetFullName(intImplementor) + " (" + oUser.GetName(intImplementor) + ")" : "***ERROR**");
                    sbTable.Append("</td>");
                    sbTable.Append("</tr>");
                    sbTable.Append("<tr>");
                    sbTable.Append("<td>");
                    sbTable.Append(sbLeft1.ToString());
                    sbTable.Append("</td>");
                    sbTable.Append("<td>");
                    sbTable.Append(sbRight1.ToString());
                    sbTable.Append("</td>");
                    sbTable.Append("</tr>");
                    sbTable.Append("<tr>");
                    sbTable.Append("<td colspan=\"2\">");
                    sbTable.Append(sbCenter1.ToString());
                    sbTable.Append("</td>");
                    sbTable.Append("</tr>");
                    sbTable.Append("<tr>");
                    sbTable.Append("<td colspan=\"2\">");
                    sbTable.Append(sbLeft2.ToString());
                    sbTable.Append("</td>");
                    sbTable.Append("</tr>");
                    sbTable.Append("<tr>");
                    sbTable.Append("<td colspan=\"2\"><p>&nbsp;</p></td>");
                    sbTable.Append("</tr>");

                    bool boolVirtual = false;
                    if (boolVirtual == true)
                    {
                        sbTable.Append("<tr>");
                        sbTable.Append("<td colspan=\"2\" class=\"header\">REQUISITION VIRTUAL SERVER GUEST</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Requested Server Completion Date:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox(oForecast.GetAnswer(intAnswer, "implementation"), 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Server Hardware Specifications:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox("VIRTUAL SERVER GUEST VMWARE", 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Server Operating System:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox(oOperatingSystem.Get(Int32.Parse(ds.Tables[0].Rows[0]["osid"].ToString()), "name").ToUpper() + " (" + oServicePacks.Get(Int32.Parse(ds.Tables[0].Rows[0]["spid"].ToString()), "name").ToUpper() + ")", 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Environment:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox(oEnvironment.Get(Int32.Parse(oForecast.GetAnswer(intAnswer, "environmentid")), "name").ToUpper(), 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Destination Class:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox(oClass.Get(Int32.Parse(oForecast.GetAnswer(intAnswer, "classid")), "name").ToUpper(), 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr><td colspan=\"2\"><p>&nbsp;</p></td></tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Destination Domain:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox(oDomains.Get(Int32.Parse(ds.Tables[0].Rows[0]["domainid"].ToString()), "name").ToUpper(), 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Backup Method:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox("TSM", 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        string  strHost = "***ERROR***";
                        DataSet dsGuest = oVMWare.GetGuest(strName);
                        if (dsGuest.Tables[0].Rows.Count > 0)
                        {
                            strHost = oVMWare.GetHost(Int32.Parse(dsGuest.Tables[0].Rows[0]["hostid"].ToString()), "name").ToUpper();
                        }
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Host Server Name:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox(strHost, 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr><td colspan=\"2\"><p>&nbsp;</p></td></tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td bgcolor=\"#CCCCCC\" style=\"border:2px outset #FFFFFF\">Network Protocols</td>");
                        sbTable.Append("<td bgcolor=\"#CCCCCC\" style=\"border:2px outset #FFFFFF\">Server Software - click in box below to add</td>");
                        sbTable.Append("</tr>");
                        bool    boolSQL = false;
                        bool    boolIIS = false;
                        DataSet dsComp  = oServerName.GetComponentDetailSelected(intServer, 1);
                        foreach (DataRow drComp in dsComp.Tables[0].Rows)
                        {
                            if (drComp["code"].ToString() == "IIS")
                            {
                                boolIIS = true;
                            }
                            if (drComp["code"].ToString() == "SQL")
                            {
                                boolSQL = true;
                            }
                        }
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox("TCP/IP", 250));
                        sbTable.Append("</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox((boolSQL ? "SQL" : ""), 350));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox("", 250));
                        sbTable.Append("</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox((boolIIS ? "IIS" : ""), 350));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr><td colspan=\"2\"><p>&nbsp;</p></td></tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Attached to SAN?:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox("NO", 150));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Server is Clustered:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox("NO", 150));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Server Load Balanced:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox("NO", 150));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Maximum Allowable Downtime:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox("Not Applicable", 150) + "</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td colspan=\"2\"><input type=\"checkbox\" class=\"default\"/> Hardware Refresh</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr><td colspan=\"2\"><p>&nbsp;</p></td></tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td colspan=\"2\">Intended Use Description:</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td colspan=\"2\">");
                        sbTable.Append(GetBox("", 500));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                    }
                    else
                    {
                        sbTable.Append("<tr>");
                        sbTable.Append("<td colspan=\"2\" class=\"header\">REQUISITION SERVER</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Requested Server Completion Date:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox(oForecast.GetAnswer(intAnswer, "implementation"), 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Server Hardware Specifications:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox(oModelsProperties.Get(intModel, "name"), 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td colspan=\"2\"><input type=\"checkbox\" class=\"default\" checked/> User re-deployable hardware if applicable</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>PO:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox("", 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Server Operating System:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox(oOperatingSystem.Get(Int32.Parse(ds.Tables[0].Rows[0]["osid"].ToString()), "name").ToUpper() + " (" + oServicePacks.Get(Int32.Parse(ds.Tables[0].Rows[0]["spid"].ToString()), "name").ToUpper() + ")", 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Environment:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox(oEnvironment.Get(Int32.Parse(oForecast.GetAnswer(intAnswer, "environmentid")), "name").ToUpper(), 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Destination Class:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox(oClass.Get(Int32.Parse(oForecast.GetAnswer(intAnswer, "classid")), "name").ToUpper(), 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr><td colspan=\"2\"><p>&nbsp;</p></td></tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Destination Domain:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox(oDomains.Get(Int32.Parse(ds.Tables[0].Rows[0]["domainid"].ToString()), "name").ToUpper(), 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Server Location:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox(oLocations.GetFull(Int32.Parse(oForecast.GetAnswer(intAnswer, "addressid"))).ToUpper(), 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Backup Method:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox("TSM", 300));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr><td colspan=\"2\"><p>&nbsp;</p></td></tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td bgcolor=\"#CCCCCC\" style=\"border:2px outset #FFFFFF\">Network Protocols</td>");
                        sbTable.Append("<td bgcolor=\"#CCCCCC\" style=\"border:2px outset #FFFFFF\">Server Software - click in box below to add</td>");
                        sbTable.Append("</tr>");
                        bool    boolSQL = false;
                        bool    boolIIS = false;
                        DataSet dsComp  = oServerName.GetComponentDetailSelected(intServer, 1);
                        foreach (DataRow drComp in dsComp.Tables[0].Rows)
                        {
                            if (drComp["code"].ToString() == "IIS")
                            {
                                boolIIS = true;
                            }
                            if (drComp["code"].ToString() == "SQL")
                            {
                                boolSQL = true;
                            }
                        }
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox("TCP/IP", 250));
                        sbTable.Append("</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox((boolSQL ? "SQL" : ""), 350));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox("", 250));
                        sbTable.Append("</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox((boolIIS ? "IIS" : ""), 350));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr><td colspan=\"2\"><p>&nbsp;</p></td></tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Attached to SAN?:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox("NO", 150));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Server is Clustered:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox("NO", 150));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Server Load Balanced:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox("NO", 150));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td>Maximum Allowable Downtime:</td>");
                        sbTable.Append("<td>");
                        sbTable.Append(GetBox("Not Applicable", 150));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td colspan=\"2\"><input type=\"checkbox\" class=\"default\"/> Hardware Refresh</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr><td colspan=\"2\"><p>&nbsp;</p></td></tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td colspan=\"2\">Intended Use Description:</td>");
                        sbTable.Append("</tr>");
                        sbTable.Append("<tr>");
                        sbTable.Append("<td colspan=\"2\">");
                        sbTable.Append(GetBox("", 500));
                        sbTable.Append("</td>");
                        sbTable.Append("</tr>");
                    }
                    sbTable.Append("</table>");

                    fp.WriteLine("<html>");
                    fp.WriteLine("<head>");
                    fp.WriteLine("<title>ClearView | Service Center Request Form</title>");
                    fp.WriteLine("<style type=\"text/css\">");
                    fp.WriteLine(".default {font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 10px;}");
                    fp.WriteLine(".header {font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 16px;font-style: italic;font-weight: bold;}");
                    fp.WriteLine("</style>");
                    fp.WriteLine("<body leftmargin=\"0\" topmargin=\"0\">");
                    fp.WriteLine(sbTable.ToString());
                    fp.WriteLine("</body>");
                    fp.WriteLine("</html>");
                    fp.Close();
                }

                strTable = sbTable.ToString();
            }
        }
Exemple #11
0
 protected void Page_Load(object sender, EventArgs e)
 {
     intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
     oForecast  = new Forecast(intProfile, dsn);
     oPage      = new Pages(intProfile, dsn);
     if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "")
     {
         intPage = Int32.Parse(Request.QueryString["pageid"]);
     }
     if (Request.QueryString["action"] != null && Request.QueryString["action"] != "")
     {
         panFinish.Visible = true;
     }
     else
     {
         if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "")
         {
             intApplication = Int32.Parse(Request.QueryString["applicationid"]);
         }
         if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "")
         {
             intApplication = Int32.Parse(Request.Cookies["application"].Value);
         }
         if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
         {
             intAnswer = Int32.Parse(Request.QueryString["id"]);
         }
         if (!IsPostBack)
         {
             if (intAnswer > 0)
             {
                 DataSet ds = oForecast.GetAnswer(intAnswer);
                 if (ds.Tables[0].Rows.Count > 0)
                 {
                     Projects         oProject          = new Projects(intProfile, dsn);
                     Requests         oRequest          = new Requests(intProfile, dsn);
                     Organizations    oOrganization     = new Organizations(intProfile, dsn);
                     Segment          oSegment          = new Segment(intProfile, dsn);
                     Platforms        oPlatform         = new Platforms(intProfile, dsn);
                     ModelsProperties oModelsProperties = new ModelsProperties(intProfile, dsn);
                     Confidence       oConfidence       = new Confidence(intProfile, dsn);
                     Classes          oClass            = new Classes(intProfile, dsn);
                     Environments     oEnvironment      = new Environments(intProfile, dsn);
                     Locations        oLocation         = new Locations(intProfile, dsn);
                     Users            oUser             = new Users(intProfile, dsn);
                     lblID.Text = intAnswer.ToString();
                     int intForecast = Int32.Parse(ds.Tables[0].Rows[0]["forecastid"].ToString());
                     int intRequest  = Int32.Parse(oForecast.Get(intForecast, "requestid"));
                     int intProject  = oRequest.GetProjectNumber(intRequest);
                     lblName.Text       = oProject.Get(intProject, "name");
                     lblNumber.Text     = oProject.Get(intProject, "number");
                     lblPortfolio.Text  = oOrganization.GetName(Int32.Parse(oProject.Get(intProject, "organization")));
                     lblSegment.Text    = oSegment.GetName(Int32.Parse(oProject.Get(intProject, "segmentid")));
                     lblPlatform.Text   = oPlatform.GetName(Int32.Parse(ds.Tables[0].Rows[0]["platformid"].ToString()));
                     lblNickname.Text   = ds.Tables[0].Rows[0]["name"].ToString();
                     lblModel.Text      = oModelsProperties.Get(Int32.Parse(ds.Tables[0].Rows[0]["modelid"].ToString()), "name");
                     lblCommitment.Text = DateTime.Parse(ds.Tables[0].Rows[0]["implementation"].ToString()).ToLongDateString();
                     lblQuantity.Text   = ds.Tables[0].Rows[0]["quantity"].ToString();
                     lblConfidence.Text = oConfidence.Get(Int32.Parse(ds.Tables[0].Rows[0]["confidenceid"].ToString()), "name");
                     int intClass = Int32.Parse(ds.Tables[0].Rows[0]["classid"].ToString());
                     lblClass.Text = oClass.Get(intClass, "name");
                     if (oClass.IsProd(intClass))
                     {
                         panTest.Visible = true;
                         lblTest.Text    = (ds.Tables[0].Rows[0]["test"].ToString() == "1" ? "Yes" : "No");
                     }
                     lblEnvironment.Text = oEnvironment.Get(Int32.Parse(ds.Tables[0].Rows[0]["environmentid"].ToString()), "name");
                     lblLocation.Text    = oLocation.GetFull(Int32.Parse(ds.Tables[0].Rows[0]["addressid"].ToString()));
                     lblIP.Text          = ds.Tables[0].Rows[0]["workstation"].ToString();
                     lblDesignedBy.Text  = oUser.GetFullName(Int32.Parse(ds.Tables[0].Rows[0]["userid"].ToString()));
                     lblDesignedOn.Text  = DateTime.Parse(ds.Tables[0].Rows[0]["created"].ToString()).ToString();
                     lblUpdated.Text     = DateTime.Parse(ds.Tables[0].Rows[0]["modified"].ToString()).ToString();
                     panShow.Visible     = true;
                     btnApprove.Enabled  = true;
                     btnDeny.Enabled     = true;
                 }
             }
         }
     }
     btnApprove.Attributes.Add("onclick", "return confirm('Are you sure you want to APPROVE this request?');");
     btnDeny.Attributes.Add("onclick", "return ValidateText('" + txtComments.ClientID + "','Please enter a reason for the rejection of this request') && confirm('Are you sure you want to DENY this request?');");
 }
Exemple #12
0
        protected void Page_Load(object sender, EventArgs e)
        {
            intProfile        = Int32.Parse(Request.Cookies["profileid"].Value);
            oDesign           = new Design(intProfile, dsn);
            oUser             = new Users(intProfile, dsn);
            oModelsProperties = new ModelsProperties(intProfile, dsn);
            oFunction         = new Functions(intProfile, dsn, intEnvironment);

            if (Request.QueryString["id"] != null)
            {
                Int32.TryParse(Request.QueryString["id"], out intID);
            }

            if (intID > 0)
            {
                lblID.Text = intID.ToString();
                DataSet dsSummary = oDesign.Get(intID);
                if (dsSummary.Tables[0].Rows.Count > 0)
                {
                    DataRow          drSummary        = dsSummary.Tables[0].Rows[0];
                    Mnemonic         oMnemonic        = new Mnemonic(intProfile, dsn);
                    CostCenter       oCostCenter      = new CostCenter(intProfile, dsn);
                    OperatingSystems oOperatingSystem = new OperatingSystems(intProfile, dsn);
                    Classes          oClass           = new Classes(intProfile, dsn);
                    Environments     oEnvironment     = new Environments(intProfile, dsn);
                    Locations        oLocation        = new Locations(intProfile, dsn);

                    bool boolWeb     = (drSummary["web"].ToString() == "1");
                    bool boolSQL     = oDesign.IsSQL(intID);
                    bool boolOracle  = oDesign.IsOracle(intID);
                    bool boolOtherDB = (drSummary["other_db"].ToString() == "1");
                    boolWindows = oDesign.IsWindows(intID);

                    DataSet dsSubmitted = oDesign.GetSubmitted(intID);
                    if (dsSubmitted.Tables[0].Rows.Count > 0)
                    {
                        int intUser = Int32.Parse(dsSubmitted.Tables[0].Rows[0]["userid"].ToString());
                        lblRequestedBy.Text = oUser.GetFullName(intUser) + " (" + oUser.GetName(intUser) + ")";
                        lblRequestedOn.Text = dsSubmitted.Tables[0].Rows[0]["created"].ToString();
                        if (dsSubmitted.Tables[0].Rows[0]["comments"].ToString() != "")
                        {
                            trException1.Visible = true;
                            trException2.Visible = true;
                            lblException.Text    = dsSubmitted.Tables[0].Rows[0]["comments"].ToString();
                        }
                    }
                    else
                    {
                        lblRequestedBy.Text = oUser.GetFullName(intProfile) + " (" + oUser.GetName(intProfile) + ")";
                        lblRequestedOn.Text = dsSummary.Tables[0].Rows[0]["modified"].ToString();
                    }

                    // Mnemonic
                    int intMnemonic = 0;
                    Int32.TryParse(drSummary["mnemonicid"].ToString(), out intMnemonic);
                    if (intMnemonic > 0)
                    {
                        lblMnemonic.Text = oMnemonic.Get(intMnemonic, "factory_code") + " - " + oMnemonic.Get(intMnemonic, "name");
                        string strMnemonicCode   = oMnemonic.Get(intMnemonic, "factory_code");
                        string strMnemonicStatus = oMnemonic.GetFeed(strMnemonicCode, MnemonicFeed.Status);
                        if (strMnemonicStatus == "")
                        {
                            strMnemonicStatus = oMnemonic.Get(intMnemonic, "status");
                        }
                        lblMnemonicStatus.Text = strMnemonicStatus;
                        string strMnemonicRTO = oMnemonic.GetFeed(strMnemonicCode, MnemonicFeed.ResRating);
                        if (strMnemonicRTO == "")
                        {
                            strMnemonicRTO = oMnemonic.Get(intMnemonic, "ResRating");
                        }
                        lblMnemonicRTO.Text = strMnemonicRTO;
                    }
                    // Server Type
                    if (oDesign.IsDatabase(intID) == false)
                    {
                        if (boolWeb)
                        {
                            lblServerType.Text = "Web";
                        }
                        else
                        {
                            lblServerType.Text = "Application";
                        }
                    }
                    else
                    {
                        lblServerType.Text = "Database";
                        if (boolSQL || boolOracle || boolOtherDB)
                        {
                            string strDatabase = "";
                            if (boolSQL == true)
                            {
                                strDatabase = "SQL";
                            }
                            if (boolOracle == true)
                            {
                                strDatabase = "Oracle";
                            }
                            if (boolOtherDB == true)
                            {
                                strDatabase = "Other";
                            }
                            lblServerType.Text += " (" + strDatabase + ")";
                        }
                        if (boolWeb)
                        {
                            lblServerType.Text += " + Web";
                        }
                    }
                    // OS
                    int intOS = 0;
                    Int32.TryParse(drSummary["osid"].ToString(), out intOS);
                    if (intOS > 0)
                    {
                        lblOS.Text = oOperatingSystem.Get(intOS, "name");
                    }
                    // SIZE
                    string strSize = drSummary["cores"].ToString() + " CPU(s), " + drSummary["ram"].ToString() + " GB(s) RAM";
                    lblSize.Text = strSize;
                    // MAINFRAME
                    if (drSummary["mainframe"].ToString() == "1")
                    {
                        lblMainframe.Text = "Yes";
                    }
                    else if (drSummary["mainframe"].ToString() == "0")
                    {
                        lblMainframe.Text = "No";
                    }
                    // SPECIAL
                    lblSpecial.Text = drSummary["special"].ToString();
                    if (lblSpecial.Text == "")
                    {
                        lblSpecial.Text = "None";
                    }
                    // HA
                    if (drSummary["ha"].ToString() == "1")
                    {
                        if (drSummary["ha_clustering"].ToString() == "1")
                        {
                            lblHA.Text = "Clustering";
                            if (drSummary["active_passive"].ToString() == "1")
                            {
                                lblHA.Text += " (Active / Passive)";
                            }
                            else if (drSummary["active_passive"].ToString() == "2")
                            {
                                lblHA.Text += " (Active / Active)";
                            }
                            lblHA.Text += "<br/>" + drSummary["instances"].ToString() + " Instances";
                            //lblHA.Text += ", " + drSummary["nodes"].ToString() + " Nodes";
                        }
                        else if (drSummary["ha_load_balancing"].ToString() == "1")
                        {
                            lblHA.Text = "Load Balancing";
                            if (drSummary["middleware"].ToString() == "1")
                            {
                                lblHA.Text += " (Middleware)";
                            }
                            else if (boolWeb == true)
                            {
                                if (drSummary["application"].ToString() == "1")
                                {
                                    lblHA.Text += " (Web + App)";
                                }
                                else
                                {
                                    lblHA.Text += " (Web)";
                                }
                            }
                            else
                            {
                                lblHA.Text += " (App)";
                            }
                        }
                    }
                    else if (drSummary["ha"].ToString() == "0")
                    {
                        lblHA.Text = "No";
                    }
                    // SOFTWARE
                    if (drSummary["ndm"].ToString() == "1")
                    {
                        lblSoftware.Text += "ConnectDirect";
                    }
                    if (drSummary["ca7"].ToString() == "1")
                    {
                        lblSoftware.Text += (lblSoftware.Text != "" ? "<br/>" : "") + "CA7";
                    }
                    if (lblSoftware.Text == "")
                    {
                        lblSoftware.Text = "None";
                    }

                    // Middlware
                    DataSet dsSoftware = oDesign.GetSoftwareComponents(intID);
                    foreach (DataRow drSoftware in dsSoftware.Tables[0].Rows)
                    {
                        // Loop through select components
                        int intComponentID = Int32.Parse(drSoftware["componentid"].ToString());
                        int intResponse    = Int32.Parse(drSoftware["responseid"].ToString());
                        lblMiddleware.Text += (lblMiddleware.Text != "" ? "<br/>" : "") + oDesign.GetResponse(intResponse, "response");
                    }
                    if (lblMiddleware.Text == "")
                    {
                        lblMiddleware.Text = "None";
                    }

                    // Legacy Design ID
                    if (drSummary["answerid"].ToString() == "")
                    {
                        lblAnswerID.Text = "N / A";
                    }
                    else
                    {
                        lblAnswerID.Text = "<a href=\"javascript:void(0);\" onclick=\"OpenNewWindow('/datapoint/service/design.aspx?t=design&q=" + oFunction.encryptQueryString(drSummary["answerid"].ToString()) + "',800,600);\">" + drSummary["answerid"].ToString() + "</a>";
                    }


                    // Quantity
                    int intQuantity = 0;
                    Int32.TryParse(drSummary["quantity"].ToString(), out intQuantity);
                    if (intQuantity > 0)
                    {
                        lblQuantity.Text = intQuantity.ToString();
                    }
                    if (oDesign.IsProd(intID) == true && oDesign.IsUnder48(intID, true) == true)
                    {
                        lblQuantity.Text += " ( + " + intQuantity.ToString() + " for DR)";
                    }
                    // DATE
                    DateTime datDate = DateTime.Now;
                    if (DateTime.TryParse(drSummary["commitment"].ToString(), out datDate) == true)
                    {
                        lblDate.Text = datDate.ToShortDateString();
                    }
                    // CONFIDENCE
                    lblConfidence.Text = drSummary["confidence"].ToString();

                    // LOCATION
                    int intClass   = 0;
                    int intEnv     = 0;
                    int intAddress = 0;
                    Int32.TryParse(drSummary["classid"].ToString(), out intClass);
                    if (intClass > 0)
                    {
                        lblLocation.Text = oClass.Get(intClass, "name") + ", ";
                        Int32.TryParse(drSummary["environmentid"].ToString(), out intEnv);
                        if (intEnv > 0)
                        {
                            lblLocation.Text += oEnvironment.Get(intEnv, "name");
                            Int32.TryParse(drSummary["addressid"].ToString(), out intAddress);
                            if (intAddress > 0)
                            {
                                lblLocation.Text += " at " + oLocation.GetFull(intAddress);
                            }
                            else
                            {
                                lblLocation.Text += " at <a href=\"javascript:void(0);\" onclick=\"alert('The datacenter will be either the Cleveland Data Center or the Summit Data Center.\\n\\nThis will be decided during execution. It is based on the available inventory at that time.');\">Cleveland or Summit Data Center</a>";
                            }
                        }
                    }
                    // SOLUTION
                    int intModel = oDesign.GetModelProperty(intID);
                    lblSolution.Text = oModelsProperties.Get(intModel, "name");

                    // Server Boot Type
                    if (oModelsProperties.IsVMwareVirtual(intModel))
                    {
                        lblServerBootType.Text = "Virtual Hard Disk (VHD)";
                    }
                    else if (oModelsProperties.IsStorageDB_BootLocal(intModel))
                    {
                        lblServerBootType.Text = "Local Disk";
                    }
                    else
                    {
                        lblServerBootType.Text = "SAN Disk";
                    }

                    // ACCOUNTS
                    rptAccounts.DataSource = oDesign.GetAccounts(intID);
                    rptAccounts.DataBind();
                    foreach (RepeaterItem ri in rptAccounts.Items)
                    {
                        Label _permissions = (Label)ri.FindControl("lblPermissions");
                        switch (_permissions.Text)
                        {
                        case "0":
                            _permissions.Text = "-----";
                            break;

                        case "D":
                            _permissions.Text = "Developer";
                            break;

                        case "P":
                            _permissions.Text = "Promoter";
                            break;

                        case "S":
                            _permissions.Text = "AppSupport";
                            break;

                        case "U":
                            _permissions.Text = "AppUsers";
                            break;
                        }
                        if (_permissions.ToolTip == "1")
                        {
                            _permissions.Text += " (R/D)";
                        }
                    }
                    lblNone.Visible = (rptAccounts.Items.Count == 0);

                    // STORAGE
                    if (drSummary["storage"].ToString() == "1")
                    {
                        if (drSummary["persistent"].ToString() == "1")
                        {
                            panStorage.Visible = true;
                            int intPersistent = oDesign.GetStorageTotal(intID);
                            if (intPersistent > 0)
                            {
                                lblStorage.Text = "Persistent, " + intPersistent.ToString() + " GB(s)";
                            }
                        }
                        else if (drSummary["persistent"].ToString() == "0")
                        {
                            int intNonPersistent = 0;
                            Int32.TryParse(drSummary["non_persistent"].ToString(), out intNonPersistent);
                            if (intNonPersistent > 0)
                            {
                                lblStorage.Text = "Non-Persistent, " + intNonPersistent.ToString() + " GB(s)";
                            }
                        }
                        else
                        {
                            panStorage.Visible = true;
                            int intStorage = oDesign.GetStorageTotal(intID);
                            if (intStorage > 0)
                            {
                                lblStorage.Text = intStorage.ToString() + " GB(s)";
                            }
                        }
                    }
                    else if (drSummary["storage"].ToString() == "0")
                    {
                        lblStorage.Text = "No";
                    }
                    // STORAGE LUNs
                    rptStorage.DataSource = oDesign.GetStorageDrives(intID);
                    rptStorage.DataBind();
                    foreach (RepeaterItem ri in rptStorage.Items)
                    {
                        CheckBox _shared = (CheckBox)ri.FindControl("chkStorageSize");
                        _shared.Checked = (_shared.Text == "1");
                        _shared.Text    = "";
                    }
                    if (boolWindows)
                    {
                        trStorageApp.Visible = true;
                        DataSet dsApp = oDesign.GetStorageDrive(intID, -1000);
                        if (dsApp.Tables[0].Rows.Count > 0)
                        {
                            int intTemp = 0;
                            if (Int32.TryParse(dsApp.Tables[0].Rows[0]["size"].ToString(), out intTemp) == true)
                            {
                                txtStorageSizeE.Text = intTemp.ToString();
                            }
                        }
                    }
                    if (oDesign.IsProd(intID) == true || oDesign.IsQA(intID) == true)
                    {
                        // BACKUP
                        panBackup.Visible = true;
                        lblFrequency.Text = (drSummary["backup_frequency"].ToString() == "D" ? "Daily" : (drSummary["backup_frequency"].ToString() == "W" ? "Weekly" : (drSummary["backup_frequency"].ToString() == "M" ? "Monthly" : "N / A")));
                        strBackup         = new StringBuilder();
                        DataSet dsBackup = oDesign.GetBackup(intID);
                        if (dsBackup.Tables[0].Rows.Count > 0)
                        {
                            DataRow drBackup = dsBackup.Tables[0].Rows[0];
                            for (int ii = 0; ii < 7; ii++)
                            {
                                strBackup.Append("<tr>");
                                strBackup.Append("<td>");
                                string strCheck = "";
                                if (ii == 0)
                                {
                                    strBackup.Append("Sunday");
                                    strCheck = drBackup["sun"].ToString();
                                }
                                else if (ii == 1)
                                {
                                    strBackup.Append("Monday");
                                    strCheck = drBackup["mon"].ToString();
                                }
                                else if (ii == 2)
                                {
                                    strBackup.Append("Tuesday");
                                    strCheck = drBackup["tue"].ToString();
                                }
                                else if (ii == 3)
                                {
                                    strBackup.Append("Wednesday");
                                    strCheck = drBackup["wed"].ToString();
                                }
                                else if (ii == 4)
                                {
                                    strBackup.Append("Thursday");
                                    strCheck = drBackup["thu"].ToString();
                                }
                                else if (ii == 5)
                                {
                                    strBackup.Append("Friday");
                                    strCheck = drBackup["fri"].ToString();
                                }
                                else
                                {
                                    strBackup.Append("Saturday");
                                    strCheck = drBackup["sat"].ToString();
                                }
                                strBackup.Append("</td>");
                                for (int jj = 0; jj < 24; jj++)
                                {
                                    strBackup.Append("<td>");
                                    if (strCheck[jj] == '1')
                                    {
                                        strBackup.Append("<b>B</b>");
                                    }
                                    else
                                    {
                                        strBackup.Append("-");
                                    }
                                    strBackup.Append("</td>");
                                }
                                strBackup.Append("</tr>");
                            }
                        }
                        // BACKUP EXCLUSIONS
                        panExclusions.Visible    = true;
                        rptExclusions.DataSource = oDesign.GetExclusions(intID);
                        rptExclusions.DataBind();
                        lblExclusion.Visible = (rptExclusions.Items.Count == 0);

                        // MAINTENANCE WINDOW
                        panMaintenance.Visible = true;
                        strMaintenance         = new StringBuilder();
                        DataSet dsMaintenance = oDesign.GetMaintenance(intID);
                        if (dsMaintenance.Tables[0].Rows.Count > 0)
                        {
                            DataRow drMaintenance = dsMaintenance.Tables[0].Rows[0];
                            for (int ii = 0; ii < 7; ii++)
                            {
                                strMaintenance.Append("<tr>");
                                strMaintenance.Append("<td>");
                                string strCheck = "";
                                if (ii == 0)
                                {
                                    strMaintenance.Append("Sunday");
                                    strCheck = drMaintenance["sun"].ToString();
                                }
                                else if (ii == 1)
                                {
                                    strMaintenance.Append("Monday");
                                    strCheck = drMaintenance["mon"].ToString();
                                }
                                else if (ii == 2)
                                {
                                    strMaintenance.Append("Tuesday");
                                    strCheck = drMaintenance["tue"].ToString();
                                }
                                else if (ii == 3)
                                {
                                    strMaintenance.Append("Wednesday");
                                    strCheck = drMaintenance["wed"].ToString();
                                }
                                else if (ii == 4)
                                {
                                    strMaintenance.Append("Thursday");
                                    strCheck = drMaintenance["thu"].ToString();
                                }
                                else if (ii == 5)
                                {
                                    strMaintenance.Append("Friday");
                                    strCheck = drMaintenance["fri"].ToString();
                                }
                                else
                                {
                                    strMaintenance.Append("Saturday");
                                    strCheck = drMaintenance["sat"].ToString();
                                }
                                strMaintenance.Append("</td>");
                                for (int jj = 0; jj < 24; jj++)
                                {
                                    strMaintenance.Append("<td>");
                                    if (strCheck[jj] == '1')
                                    {
                                        strMaintenance.Append("<b>M</b>");
                                    }
                                    else
                                    {
                                        strMaintenance.Append("-");
                                    }
                                    strMaintenance.Append("</td>");
                                }
                                strMaintenance.Append("</tr>");
                            }
                        }
                    }
                    else
                    {
                        lblHA.Text        = "N / A";
                        lblMainframe.Text = "N / A";
                    }
                    // APPROVALS
                    rptWorkflow.DataSource = oDesign.LoadWorkflow(intID);
                    rptWorkflow.DataBind();
                    lblWorkflow.Visible = (rptWorkflow.Items.Count == 0);
                }
            }
        }
        private void LoadServer()
        {
            string strName = oFunction.decryptQueryString(Request.QueryString["n"]);

            txtName.Text = strName;
            bool boolFound   = false;
            bool boolAlready = false;

            DataSet dsRecom = oAsset.GetDecommissionRecommission(strName);

            foreach (DataRow drRecom in dsRecom.Tables[0].Rows)
            {
                if (drRecom["name"].ToString().ToUpper().Trim() == strName.ToUpper().Trim())
                {
                    DateTime datDecom = DateTime.Now;
                    boolAlready             = true;
                    lblAlreadySerial.Text   = drRecom["serial"].ToString();
                    lblAlreadySerialDR.Text = drRecom["serialdr"].ToString();
                    lblAlreadyBy.Text       = drRecom["username"].ToString();
                    lblAlreadyOn.Text       = drRecom["created"].ToString();
                    lblAlreadyReason.Text   = drRecom["reason"].ToString();
                    lblAlreadyPower.Text    = drRecom["decom"].ToString();
                    if (drRecom["running"].ToString() == "-1")
                    {
                        lblAlreadyStatus.Text = "Manual Intervention Required";
                    }
                    else if (drRecom["running"].ToString() == "-2")
                    {
                        boolAlready           = false;
                        lblAlreadyStatus.Text = "Cancelled";
                    }
                    else if (drRecom["running"].ToString() == "2")
                    {
                        lblAlreadyStatus.Text = "In Progress";
                    }
                    else if (drRecom["running"].ToString() == "3")
                    {
                        lblAlreadyStatus.Text = "Completed";
                    }
                    else if (drRecom["running"].ToString() == "1")
                    {
                        lblAlreadyStatus.Text = "Running...";
                    }
                    else if (drRecom["running"].ToString() == "0")
                    {
                        if (drRecom["recommissioned"].ToString() != "")
                        {
                            boolAlready           = false;
                            lblAlreadyStatus.Text = "Recommissioned on " + drRecom["recommissioned"].ToString();
                        }
                        else if (drRecom["destroyed"].ToString() != "")
                        {
                            lblAlreadyStatus.Text  = "Powered off on " + drRecom["turnedoff"].ToString();
                            lblAlreadyStatus.Text += "<br/>Finished on " + drRecom["destroyed"].ToString();
                        }
                        else if (drRecom["destroy"].ToString() != "")
                        {
                            lblAlreadyStatus.Text  = "Powered off on " + drRecom["turnedoff"].ToString();
                            lblAlreadyStatus.Text += "<br/>Will be finished on " + drRecom["destroy"].ToString();
                        }
                        else if (drRecom["turnedoff"].ToString() != "")
                        {
                            lblAlreadyStatus.Text = "Powered off on " + drRecom["turnedoff"].ToString();
                        }
                        else
                        {
                            lblAlreadyStatus.Text = "Will be powered off on " + drRecom["decom"].ToString();
                        }
                    }
                    else
                    {
                        lblAlreadyStatus.Text = "Status Unavailable";
                    }
                }
            }

            if (boolAlready == false)
            {
                DataSet ds = oServer.GetDecommission(strName);
                if (ds.Tables[0].Rows.Count == 1)
                {
                    boolFound = true;
                    bool boolPermit = false;
                    int  intServer  = Int32.Parse(ds.Tables[0].Rows[0]["id"].ToString());

                    int      intRequest = Int32.Parse(Request.QueryString["rid"]);
                    int      intProject = oRequest.GetProjectNumber(intRequest);
                    Projects oProject   = new Projects(intProfile, dsn);
                    bool     boolDemo   = false;
                    string   strNumber  = oProject.Get(intProject, "number");
                    // Check to see if Demo
                    DataSet dsDemo = oFunction.GetSetupValuesByKey("DEMO_PROJECT");
                    foreach (DataRow drDemo in dsDemo.Tables[0].Rows)
                    {
                        if (strNumber == drDemo["Value"].ToString())
                        {
                            boolDemo = true;
                            break;
                        }
                    }

                    if (boolDemo == false &&
                        (String.IsNullOrEmpty(oServer.Get(intServer, "build_ready")) == true ||
                         oServer.Get(intServer, "rebuilding") == "1"))
                    {
                        panBuilding.Visible = true;
                        btnNext.Enabled     = false;
                    }
                    else
                    {
                        int intAnswer = 0;
                        if (ds.Tables[0].Rows[0]["answerid"].ToString() != "")
                        {
                            intAnswer = Int32.Parse(ds.Tables[0].Rows[0]["answerid"].ToString());
                        }
                        int intUser = 0;
                        if (ds.Tables[0].Rows[0]["userid"].ToString() != "")
                        {
                            intUser = Int32.Parse(ds.Tables[0].Rows[0]["userid"].ToString());
                        }
                        int    intOwner     = 0;
                        int    intPrimary   = 0;
                        int    intSecondary = 0;
                        int    intRequestor = 0;
                        string strAgree     = "";
                        if (intAnswer > 0)
                        {
                            if (oForecast.GetAnswer(intAnswer, "appcontact") != "")
                            {
                                intOwner = Int32.Parse(oForecast.GetAnswer(intAnswer, "appcontact"));
                            }
                            if (oForecast.GetAnswer(intAnswer, "admin1") != "")
                            {
                                intPrimary = Int32.Parse(oForecast.GetAnswer(intAnswer, "admin1"));
                            }
                            if (oForecast.GetAnswer(intAnswer, "admin2") != "")
                            {
                                intSecondary = Int32.Parse(oForecast.GetAnswer(intAnswer, "admin2"));
                            }
                            if (oForecast.GetAnswer(intAnswer, "userid") != "")
                            {
                                intRequestor = Int32.Parse(oForecast.GetAnswer(intAnswer, "userid"));
                            }
                            if (intProfile == intOwner || intProfile == intPrimary || intProfile == intSecondary || intProfile == intRequestor)
                            {
                                boolPermit = true;
                            }

                            if (intOwner > 0)
                            {
                                strAgree += " - " + oUser.GetFullName(intOwner) + " (" + oUser.GetName(intOwner) + ")\\n";
                            }
                            if (intPrimary > 0)
                            {
                                strAgree += " - " + oUser.GetFullName(intPrimary) + " (" + oUser.GetName(intPrimary) + ")\\n";
                            }
                            if (intSecondary > 0)
                            {
                                strAgree += " - " + oUser.GetFullName(intSecondary) + " (" + oUser.GetName(intSecondary) + ")\\n";
                            }
                            if (intRequestor > 0)
                            {
                                strAgree += " - " + oUser.GetFullName(intRequestor) + " (" + oUser.GetName(intRequestor) + ")\\n";
                            }
                        }
                        if (oApplication.Get(intApplication, "decom") == "1" || oUser.IsAdmin(intProfile) || intProfile == intUser)
                        {
                            boolPermit = true;
                        }

                        if (boolPermit == true)
                        {
                            chkAgree.Attributes.Add("onclick", "ShowAgreeAlert(this,\"" + strAgree + "\");");
                            int     intAsset   = 0;
                            int     intAssetDR = 0;
                            DataSet dsAsset    = oServer.GetAssets(intServer);
                            foreach (DataRow drAsset in dsAsset.Tables[0].Rows)
                            {
                                if (drAsset["latest"].ToString() == "1")
                                {
                                    intAsset = Int32.Parse(drAsset["assetid"].ToString());
                                }
                                if (drAsset["dr"].ToString() == "1")
                                {
                                    intAssetDR = Int32.Parse(drAsset["assetid"].ToString());
                                }
                            }

                            if (intAsset > 0)
                            {
                                panFound.Visible  = true;
                                panDetail.Visible = true;

                                int intClass   = 0;
                                int intEnv     = 0;
                                int intAddress = 0;
                                try
                                {
                                    intClass   = Int32.Parse(oAsset.GetServerOrBlade(intAsset, "classid"));
                                    intEnv     = Int32.Parse(oAsset.GetServerOrBlade(intAsset, "environmentid"));
                                    intAddress = Int32.Parse(oAsset.GetServerOrBlade(intAsset, "addressid"));
                                }
                                catch
                                {
                                    DataSet dsCatch = oServer.GetAsset(intAsset);
                                    if (dsCatch.Tables[0].Rows.Count > 0)
                                    {
                                        intClass   = Int32.Parse(dsCatch.Tables[0].Rows[0]["classid"].ToString());
                                        intEnv     = Int32.Parse(dsCatch.Tables[0].Rows[0]["environmentid"].ToString());
                                        intAddress = Int32.Parse(dsCatch.Tables[0].Rows[0]["addressid"].ToString());
                                    }
                                }
                                if (intClass == 0 && intAnswer > 0)
                                {
                                    Int32.TryParse(oForecast.GetAnswer(intAnswer, "classid"), out intClass);
                                }
                                if (intEnv == 0 && intAnswer > 0)
                                {
                                    Int32.TryParse(oForecast.GetAnswer(intAnswer, "environmentid"), out intEnv);
                                }
                                if (intAddress == 0 && intAnswer > 0)
                                {
                                    Int32.TryParse(oForecast.GetAnswer(intAnswer, "addressid"), out intAddress);
                                }
                                int intModel = 0;
                                if (oAsset.Get(intAsset, "modelid") != "")
                                {
                                    intModel = Int32.Parse(oAsset.Get(intAsset, "modelid"));
                                }
                                lblModel.Text     = oModelsProperties.Get(intModel, "name");
                                lblModel.ToolTip  = "ModelID: " + intModel.ToString();
                                lblSerial.Text    = oAsset.Get(intAsset, "serial");
                                lblSerial.ToolTip = "AssetID: " + intAsset.ToString();
                                if (intAssetDR > 0)
                                {
                                    panDR.Visible       = true;
                                    lblSerialDR.Text    = oAsset.Get(intAssetDR, "serial");
                                    lblSerialDR.ToolTip = "AssetID: " + intAssetDR.ToString();
                                }
                                lblClass.Text       = oClass.Get(intClass, "name");
                                lblClass.ToolTip    = intClass.ToString();
                                lblEnvironment.Text = oEnvironment.Get(intEnv, "name");
                                lblAddress.Text     = oLocation.GetFull(intAddress);
                                panValid.Visible    = true;
                                lblId.Text          = intServer.ToString();
                                btnNext.Attributes.Add("onclick", "return ValidateCheck('" + chkAgree.ClientID + "','Please check the box stating that you agree to the disclaimer notice')" +
                                                       " && ValidateDate('" + txtDate.ClientID + "','Please enter a valid date')" +
                                                       " && ValidateDateToday('" + txtDate.ClientID + "','The date must occur after today')" +
                                                       GetClass(intServer, intClass, intEnv) +
                                                       " && ValidateText('" + txtReason.ClientID + "','Please enter a reason')" +
                                                       " && ValidateRadioButtons('" + radRetrieveYes.ClientID + "','" + radRetrieveNo.ClientID + "','Please select whether or not special hardware should be retrieved')" +
                                                       " && (document.getElementById('" + radRetrieveYes.ClientID + "').checked == false || (document.getElementById('" + radRetrieveYes.ClientID + "').checked == true && ValidateText('" + txtRetrieve.ClientID + "','Please provide a description')))" +
                                                       " && (document.getElementById('" + radRetrieveYes.ClientID + "').checked == false || (document.getElementById('" + radRetrieveYes.ClientID + "').checked == true && ValidateText('" + txtRetrieveAddress.ClientID + "','Please provide an address')))" +
                                                       " && (document.getElementById('" + radRetrieveYes.ClientID + "').checked == false || (document.getElementById('" + radRetrieveYes.ClientID + "').checked == true && ValidateText('" + txtRetrieveLocator.ClientID + "','Please provide a locator')))" +
                                                       " && ProcessButton(this)" +
                                                       ";");
                            }
                            else
                            {
                                boolFound = false;
                            }
                        }
                        else
                        {
                            panInvalid.Visible = true;
                            if (intUser > 0)
                            {
                                strContacts += "<tr><td>Server Owner:</td><td>" + oUser.GetFullName(intUser) + " (" + oUser.GetName(intUser) + ")" + "</td></tr>";
                            }
                            if (intOwner > 0)
                            {
                                strContacts += "<tr><td>Departmental Manager:</td><td>" + oUser.GetFullName(intOwner) + " (" + oUser.GetName(intOwner) + ")" + "</td></tr>";
                            }
                            if (intPrimary > 0)
                            {
                                strContacts += "<tr><td>Application Technical Lead:</td><td>" + oUser.GetFullName(intPrimary) + " (" + oUser.GetName(intPrimary) + ")" + "</td></tr>";
                            }
                            if (intSecondary > 0)
                            {
                                strContacts += "<tr><td>Administrative Contact:</td><td>" + oUser.GetFullName(intSecondary) + " (" + oUser.GetName(intSecondary) + ")" + "</td></tr>";
                            }
                            if (intRequestor > 0)
                            {
                                strContacts += "<tr><td>Design Initiated By:</td><td>" + oUser.GetFullName(intRequestor) + " (" + oUser.GetName(intRequestor) + ")" + "</td></tr>";
                            }
                            DataSet dsDecoms = oApplication.GetDecoms();
                            if (dsDecoms.Tables[0].Rows.Count > 0)
                            {
                                strContacts += "<tr><td colspan=\"2\">Alternatively, you can contact a resource from one of the following departments:</td></tr>";
                                foreach (DataRow drDecom in dsDecoms.Tables[0].Rows)
                                {
                                    strContacts += "<tr><td></td><td>" + drDecom["name"].ToString() + "</td></tr>";
                                }
                            }
                            btnNext.Enabled = false;
                        }
                    }
                }
                else if (ds.Tables[0].Rows.Count > 1)
                {
                    boolFound       = true;
                    panMore.Visible = true;
                    btnNext.Enabled = false;
                }

                if (boolFound == false)
                {
                    panNotFound.Visible = true;
                    lblName.Text        = strName;
                    if (Request.QueryString["yn"] != null)
                    {
                        if (Request.QueryString["yn"] == "y")
                        {
                            panConfirm.Visible = true;
                            radYes.Checked     = true;
                            LoadLists();
                            int intClass = 0;
                            if (Request.QueryString["cid"] != null && Request.QueryString["cid"] != "")
                            {
                                intClass = Int32.Parse(Request.QueryString["cid"]);
                            }
                            if (oClass.Get(intClass).Tables[0].Rows.Count > 0)
                            {
                                panClass.Visible       = true;
                                ddlClass.SelectedValue = intClass.ToString();
                                ddlEnvironment.Enabled = true;
                                Environments oEnvironment = new Environments(intProfile, dsn);
                                ddlEnvironment.DataValueField = "id";
                                ddlEnvironment.DataTextField  = "name";
                                ddlEnvironment.DataSource     = oClass.GetEnvironment(intClass, 0);
                                ddlEnvironment.DataBind();
                                ddlEnvironment.Items.Insert(0, new ListItem("-- SELECT --", "0"));
                                int intEnv = 0;
                                if (Request.QueryString["eid"] != null && Request.QueryString["eid"] != "")
                                {
                                    intEnv = Int32.Parse(Request.QueryString["eid"]);
                                }
                                if (oEnvironment.Get(intEnv).Tables[0].Rows.Count > 0)
                                {
                                    panEnvironment.Visible       = true;
                                    panDetail.Visible            = true;
                                    ddlEnvironment.SelectedValue = intEnv.ToString();
                                    lblId.Text = "0";
                                    btnNext.Attributes.Add("onclick", "return ValidateDropDown('" + ddlPlatform.ClientID + "','Please select a platform')" +
                                                           " && ValidateDropDown('" + ddlPlatformType.ClientID + "','Please select a type')" +
                                                           " && ValidateDropDown('" + ddlPlatformModel.ClientID + "','Please select a model')" +
                                                           " && ValidateDropDown('" + ddlPlatformModelProperty.ClientID + "','Please select a model property')" +
                                                           " && ValidateText('" + txtSerial.ClientID + "','Please enter a serial number')" +
                                                           " && ValidateHidden0('" + hdnLocation.ClientID + "','ddlState','Please select a location')" +
                                                           " && ValidateCheck('" + chkAgree.ClientID + "','Please check the box stating that you agree to the disclaimer notice')" +
                                                           " && ValidateDate('" + txtDate.ClientID + "','Please enter a valid date')" +
                                                           " && ValidateDateToday('" + txtDate.ClientID + "','The date must occur after today')" +
                                                           GetClass(0, intClass, intEnv) +
                                                           " && ValidateText('" + txtReason.ClientID + "','Please enter a reason')" +
                                                           " && ValidateRadioButtons('" + radRetrieveYes.ClientID + "','" + radRetrieveNo.ClientID + "','Please select whether or not special hardware should be retrieved')" +
                                                           " && (document.getElementById('" + radRetrieveYes.ClientID + "').checked == false || (document.getElementById('" + radRetrieveYes.ClientID + "').checked == true && ValidateText('" + txtRetrieve.ClientID + "','Please provide a description')))" +
                                                           " && (document.getElementById('" + radRetrieveYes.ClientID + "').checked == false || (document.getElementById('" + radRetrieveYes.ClientID + "').checked == true && ValidateText('" + txtRetrieveAddress.ClientID + "','Please provide an address')))" +
                                                           " && (document.getElementById('" + radRetrieveYes.ClientID + "').checked == false || (document.getElementById('" + radRetrieveYes.ClientID + "').checked == true && ValidateText('" + txtRetrieveLocator.ClientID + "','Please provide a locator')))" +
                                                           " && ProcessButton(this)" +
                                                           ";");
                                }
                                else
                                {
                                    btnNext.Enabled = false;
                                }
                            }
                            else
                            {
                                btnNext.Enabled = false;
                            }
                        }
                    }
                    else
                    {
                        btnNext.Enabled = false;
                    }
                }
            }
            else
            {
                panAlready.Visible = true;
                btnNext.Enabled    = false;
            }
        }