private void LoadSecurity()
{
ModelsProperties oModelsProperties = new ModelsProperties(intProfile, dsn);
Servers oServer = new Servers(intProfile, dsn);
OnDemand oOnDemand = new OnDemand(0, dsn);
int intAnswer = 0;
int intModel = 0;
DataSet dsSecurity = oOnDemandTasks.GetServerOther(intRequest, intService, intNumber);
if (dsSecurity.Tables[0].Rows.Count > 0)
{
intAnswer = Int32.Parse(dsSecurity.Tables[0].Rows[0]["answerid"].ToString());
intModel = Int32.Parse(dsSecurity.Tables[0].Rows[0]["modelid"].ToString());
}
//intAnswer = 2681;
//intModel = 395;
int intStep = (oModelsProperties.IsTypeVMware(intModel) ? 6 : 4);
if (intAnswer > 0)
{
panSecurity.Visible = true;
string strRequestResult = "";
// PRE (creation of groups)
DataSet dsServers = oServer.GetAnswer(intAnswer);
foreach (DataRow drServer in dsServers.Tables[0].Rows)
{
strRequestResult += "<tr>";
int intServer = Int32.Parse(drServer["id"].ToString());
strRequestResult += "<td valign=\"top\"><b>" + oServer.GetName(intServer, true) + ":</b></td>";
DataSet dsStep = oOnDemand.GetStepDoneServer(intServer, intStep);
if (dsStep.Tables[0].Rows.Count > 0)
{
strRequestResult += "<td valign=\"top\">" + dsStep.Tables[0].Rows[0]["result"].ToString() + "</td>";
}
strRequestResult += "</tr>";
}
if (strRequestResult != "")
{
strRequestResult = "<table cellpadding=\"3\" cellspacing=\"2\" border=\"0\">" + strRequestResult + "</table>";
}
lblSecurityPre.Text = strRequestResult;
// POST (account generation and ties to groups)
strRequestResult = "";
int intRequestAD = oForecast.GetRequestID(intAnswer, true);
DataSet dsRequestResult = oRequest.GetResult(intRequestAD);
foreach (DataRow drRequestResult in dsRequestResult.Tables[0].Rows)
{
strRequestResult += drRequestResult["result"].ToString();
}
lblSecurityPost.Text = strRequestResult;
}
}
protected void Page_Load(object sender, EventArgs e)
{
OnDemand oOnDemand = new OnDemand(0, dsn);
Classes oClass = new Classes(0, dsn);
Forecast oForecast = new Forecast(0, dsn);
Servers oServer = new Servers(0, dsn);
Models oModel = new Models(0, dsn);
Users oUser = new Users(0, dsn);
ModelsProperties oModelsProperties = new ModelsProperties(0, dsn);
Functions oFunction = new Functions(0, dsn, intEnvironment);
Asset oAsset = new Asset(0, dsnAsset);
Tokens oToken = new Tokens(0, dsn);
string strOnLoad = "";
string strError = "";
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
int intServer = Int32.Parse(oFunction.decryptQueryString(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 intClass = Int32.Parse(oForecast.GetAnswer(intAnswer, "classid"));
int intAsset = 0;
if (ds.Tables[0].Rows[0]["assetid"].ToString() != "")
{
intAsset = Int32.Parse(ds.Tables[0].Rows[0]["assetid"].ToString());
}
string strSerial = oAsset.Get(intAsset, "serial");
strName = oServer.GetName(intServer, true);
if (strName == "")
{
if (intAsset > 0 && oAsset.Get(intAsset, "name") != "")
{
strName = oAsset.Get(intAsset, "name");
}
else
{
strName = "Device " + Request.QueryString["c"];
}
}
int intModel = oForecast.GetModelAsset(intAnswer);
if (intModel == 0)
{
intModel = oForecast.GetModel(intAnswer);
}
if (oModelsProperties.IsInventory(intModel) == true)
{
panInventoryYes.Visible = true;
intModel = Int32.Parse(oModelsProperties.Get(intModel, "modelid"));
int intType = oModel.GetType(intModel);
int intCurrent = Int32.Parse(ds.Tables[0].Rows[0]["step"].ToString());
int intCurrentWithError = oServer.GetStep(intServer);
strPreviewName = strName;
DataSet dsSteps = oOnDemand.GetSteps(intType, 1);
if (dsSteps.Tables[0].Rows.Count >= intCurrent)
{
int intNewStep = Int32.Parse(dsSteps.Tables[0].Rows[intCurrent - 1]["id"].ToString());
DataSet dsStep = oOnDemand.GetStep(intNewStep);
if (dsStep.Tables[0].Rows.Count > 0)
{
string strPath = dsStep.Tables[0].Rows[0]["path"].ToString();
if (dsStep.Tables[0].Rows[0]["show_build"].ToString() == "1")
{
chkPreview.Disabled = false;
if (!IsPostBack && Request.QueryString["preview"] != null)
{
intShowBuild = 1;
chkPreview.Checked = true;
// Token
strPreviewToken = oToken.Add(strPreviewName, 50);
}
}
else
{
chkPreview.Disabled = true;
}
if (strPath != "")
{
Control oControl = (Control)LoadControl(strPath);
PH.Controls.Add(oControl);
strOnLoad = "redirectWait();";
}
else
{
strOnLoad = "redirectAJAX('" + intServer.ToString() + "','" + intCurrentWithError.ToString() + "');";
}
}
}
else
{
btnDesign.Visible = true;
btnDesign.Attributes.Add("onclick", "return OpenWindow('FORECAST_EQUIPMENT','?id=" + intAnswer.ToString() + "');");
panDone.Visible = true;
if (ds.Tables[0].Rows[0]["completed"].ToString() != "")
{
lblCompleted.Text = DateTime.Parse(ds.Tables[0].Rows[0]["completed"].ToString()).ToString();
}
else
{
lblCompleted.Text = DateTime.Now.ToString();
}
}
int intStep = 0;
StringBuilder sbStep = new StringBuilder();
bool boolError = false;
foreach (DataRow drStep in dsSteps.Tables[0].Rows)
{
intStep++;
string strClass = "cantclose";
if (drStep["type"].ToString() == "1")
{
strClass = "canclose";
}
if (drStep["type"].ToString() == "-1")
{
strClass = "default";
}
DataSet dsResult = oOnDemand.GetStepDoneServer(intServer, intStep);
if (intStep < intCurrent)
{
string strImage = "<img src=\"/images/check.gif\" border=\"0\" align=\"absmiddle\">";
string strDone = "";
string strMessage = "";
if (dsResult.Tables[0].Rows.Count > 0)
{
foreach (DataRow drResult in dsResult.Tables[0].Rows)
{
strMessage += drResult["result"].ToString();
}
if (dsResult.Tables[0].Rows[0]["error"].ToString() == "1")
{
strImage = "<img src=\"/images/error.gif\" border=\"0\" align=\"absmiddle\">";
}
if (dsResult.Tables[0].Rows[0]["finished"].ToString() != "")
{
strDone = " (" + DateTime.Parse(dsResult.Tables[0].Rows[0]["finished"].ToString()).ToString() + ")";
}
}
sbStep.Append("<tr><td>");
sbStep.Append(strImage);
sbStep.Append("</td><td nowrap><a href=\"javascript:void(0);\" onclick=\"ShowHideResult('divResult_");
sbStep.Append(intAnswer.ToString());
sbStep.Append("_");
sbStep.Append(intStep.ToString());
sbStep.Append("');\">");
sbStep.Append(drStep["title"].ToString());
sbStep.Append("</a>");
sbStep.Append(strDone);
sbStep.Append("</td></tr>");
sbStep.Append("<tr id=\"divResult_");
sbStep.Append(intAnswer.ToString());
sbStep.Append("_");
sbStep.Append(intStep.ToString());
sbStep.Append("\" style=\"display:none\"><td></td><td>");
sbStep.Append(drStep["zeus"].ToString() == "1" && strSerial != "" ? " [<a href=\"javascript:void(0);\" onclick=\"OpenWindow('ZEUS_STATUS','" + strSerial + "');\">View Status</a>]" : (strMessage == "" ? "No information" : strMessage));
sbStep.Append("</td></tr>");
}
else if (intStep == intCurrent)
{
strError = "";
if (dsResult.Tables[0].Rows.Count > 0)
{
if (dsResult.Tables[0].Rows[0]["error"].ToString() == "1")
{
boolError = true;
sbStep.Append("<tr><td><img src=\"/images/error.gif\" border=\"0\" align=\"absmiddle\"></td><td class=\"");
sbStep.Append(strClass);
sbStep.Append("\" nowrap><a href=\"javascript:void(0);\" onclick=\"ShowHideResult('divResult_");
sbStep.Append(intAnswer.ToString());
sbStep.Append("_");
sbStep.Append(intStep.ToString());
sbStep.Append("');\">");
sbStep.Append(drStep["title"].ToString());
sbStep.Append("</a></td></tr>");
sbStep.Append("<tr id=\"divResult_");
sbStep.Append(intAnswer.ToString());
sbStep.Append("_");
sbStep.Append(intStep.ToString());
sbStep.Append("\" style=\"display:none\"><td></td><td>");
strError = dsResult.Tables[0].Rows[0]["result"].ToString();
if (strError.Contains("~") == true)
{
strError = strError.Substring(0, strError.IndexOf("~"));
}
sbStep.Append(strError);
DataSet dsError = oServer.GetError(intServer, intStep);
string incident = "";
int assigned = 0;
if (dsError.Tables[0].Rows.Count > 0)
{
incident = dsError.Tables[0].Rows[0]["incident"].ToString();
Int32.TryParse(dsError.Tables[0].Rows[0]["assigned"].ToString(), out assigned);
if (string.IsNullOrEmpty(incident) == false)
{
sbStep.Append("<br/><br/>Tracking # " + incident);
bool IncidentFound = false;
DataSet dsKey = oFunction.GetSetupValuesByKey("INCIDENTS");
if (dsKey.Tables[0].Rows.Count > 0)
{
string incidents = dsKey.Tables[0].Rows[0]["Value"].ToString();
StreamReader theReader = new StreamReader(incidents);
string theContents = theReader.ReadToEnd();
string[] theLines = theContents.Split(new string[] { "\n" }, StringSplitOptions.RemoveEmptyEntries);
foreach (string theLine in theLines)
{
if (theLine.Contains(incident))
{
IncidentFound = true;
string[] theFields = theLine.Split(new char[] { ',' }, StringSplitOptions.None);
string person = theFields[5].Replace("\"", "");
if (String.IsNullOrEmpty(person) == false)
{
sbStep.Append("<br/>Assigned To: " + person);
}
string group = theFields[4].Replace("\"", "");
if (String.IsNullOrEmpty(group) == false)
{
sbStep.Append("<br/>Group: " + group);
}
break;
}
}
}
if (IncidentFound == false)
{
if (assigned > 0)
{
sbStep.Append("<br/>Assigned To: " + oUser.GetFullNameWithLanID(assigned));
}
}
}
}
if (strError != "")
{
sbStep.Append("<br/><br/><a class='build_error' href=\"javascript:void(0);\" onclick=\"OpenWindow('PROVISIONING_ERROR', '");
sbStep.Append(oFunction.encryptQueryString(dsResult.Tables[0].Rows[0]["result"].ToString()) + "&incident=" + incident);
sbStep.Append("');\"><img src='/images/plus.gif' border='0' align='absmiddle'/> For more information about this error, click here</a>");
}
sbStep.Append("</td></tr>");
}
}
if (boolError == false)
{
if (drStep["interact_path"].ToString() == "")
{
sbStep.Append("<tr><td><img src=\"/images/green_arrow.gif\" border=\"0\" align=\"absmiddle\"></td><td class=\"");
sbStep.Append(strClass);
sbStep.Append("\" nowrap><b>");
sbStep.Append(drStep["title"].ToString());
sbStep.Append("</b></td></tr>");
}
else
{
sbStep.Append("<tr><td><img src=\"/images/alert.gif\" border=\"0\" align=\"absmiddle\"></td><td class=\"");
sbStep.Append(strClass);
sbStep.Append("\" nowrap><b>");
sbStep.Append(drStep["title"].ToString());
sbStep.Append("</b></td></tr>");
sbStep.Append("<tr><td></td><td><input type=\"button\" onclick=\"OpenWindow('NEW_WINDOW','");
sbStep.Append(drStep["interact_path"].ToString());
sbStep.Append("?id=");
sbStep.Append(intServer.ToString());
sbStep.Append("');\" value=\"Click Here\" class=\"default\" style=\"width:100px\"></td></tr>");
}
}
}
else if (intStep > intCurrent)
{
sbStep.Append("<tr><td></td><td class=\"");
sbStep.Append(strClass);
sbStep.Append("\">");
sbStep.Append(drStep["title"].ToString());
sbStep.Append("</td></tr>");
}
}
sbStep.Insert(0, "<p><table border=\"0\" cellpadding=\"4\" cellspacing=\"3\">");
sbStep.Append("</table></p>");
strResult += sbStep.ToString();
}
else
{
panInventoryNo.Visible = true;
lblInventory.Text = oModelsProperties.Get(intModel, "name");
}
}
}
if (strOnLoad != "")
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "start_count", "<script type=\"text/javascript\">window.onload = new Function(\"" + strOnLoad + "\");" + (strError == "" ? "" : "LoadError('" + strError.Replace("'", "") + "');") + "<" + "/" + "script>");
}
}
