protected void btnSubmit_Click(Object Sender, EventArgs e)
{
oWorkstation.UpdateVirtualAccounts(intWorkstation, 1);
if (chkApply.Visible && chkApply.Checked)
{
DataSet dsAccounts = oWorkstation.GetAccountsVMware(intWorkstation);
for (int ii = 2; dsAccounts.Tables[0].Rows.Count > 0 && ii <= intQuantity; ii++)
{
DataSet dsCopy = oWorkstation.GetVirtual(intAnswer, ii);
int intCopy = 0;
if (dsCopy.Tables[0].Rows.Count > 0)
{
intCopy = Int32.Parse(dsCopy.Tables[0].Rows[0]["id"].ToString());
oWorkstation.DeleteAccounts(intCopy);
foreach (DataRow drAccount in dsAccounts.Tables[0].Rows)
{
int intUser = Int32.Parse(drAccount["userid"].ToString());
int intAdmin = Int32.Parse(drAccount["admin"].ToString());
int intRemote = Int32.Parse(drAccount["remote"].ToString());
oWorkstation.AddAccountFix(0, intCopy, intUser, intAdmin, intRemote);
}
oWorkstation.UpdateVirtualAccounts(intCopy, 1);
}
}
}
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "reload", "<script type=\"text/javascript\">window.opener.location.reload();window.close();<" + "/" + "script>");
}
private void AddDevice(string _type, string _name, string _count, int _number)
{
boolOther = !boolOther;
strDevices += "<tr" + (boolOther ? " bgcolor=\"F6F6F6\"" : "") + ">";
strDevices += "<td>" + _type + "</td>";
strDevices += "<td>" + _name + "</td>";
strDevices += "<td>" + _count + "</td>";
DataSet ds = oWorkstation.GetVirtual(intID, _number);
bool boolDeviceConfigured = true;
if (ds.Tables[0].Rows.Count == 0 || ds.Tables[0].Rows[0]["configured"].ToString() != "1")
{
boolDeviceConfigured = false;
}
if (boolDeviceConfigured == true)
{
strDevices += "<td nowrap align=\"center\"><img src=\"/images/check.gif\" border=\"0\" align=\"absmiddle\"/> <input type=\"button\" class=\"default\" value=\"Edit\" style=\"width:50px\" onclick=\"OpenOnDemandDevice(" + intID + "," + _number.ToString() + ");\"/></td>";
}
else
{
strDevices += "<td nowrap align=\"center\"><img src=\"/images/required.gif\" border=\"0\" align=\"absmiddle\"/> <input type=\"button\" class=\"default\" value=\"Edit\" style=\"width:50px\" onclick=\"OpenOnDemandDevice(" + intID + "," + _number.ToString() + ");\"/></td>";
boolConfigured = false;
}
strDevices += "</tr>";
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
Workstations oWorkstation = new Workstations(0, dsn);
OnDemand oOnDemand = new OnDemand(0, dsn);
Forecast oForecast = new Forecast(0, dsn);
ModelsProperties oModelsProperties = new ModelsProperties(0, dsn);
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
Functions oFunction = new Functions(0, dsn, intEnvironment);
int intWorkstation = Int32.Parse(oFunction.decryptQueryString(Request.QueryString["id"]));
int intType = oModelsProperties.GetType(intModelVirtual);
DataSet dsSteps = oOnDemand.GetSteps(intType, 1);
DataSet ds = oWorkstation.GetVirtual(intWorkstation);
if (ds.Tables[0].Rows.Count > 0)
{
int intAnswer = Int32.Parse(ds.Tables[0].Rows[0]["answerid"].ToString());
int intRemote = Int32.Parse(ds.Tables[0].Rows[0]["remoteid"].ToString());
int intCurrent = Int32.Parse(ds.Tables[0].Rows[0]["step"].ToString());
Workstations workstation = new Workstations(0, dsnRemote);
DataSet dsResult = workstation.GetWorkstationVirtualRemoteStatus(intRemote);
if (dsResult.Tables[0].Rows.Count > 0)
{
int intStep = Int32.Parse(dsResult.Tables[0].Rows[0]["step"].ToString());
int intID = Int32.Parse(dsResult.Tables[0].Rows[0]["id"].ToString());
if (intStep == 1)
{
oWorkstation.AssignHost(intWorkstation, dsnRemote, dsnAsset, intEnvironment, dsnZeus);
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "completed", "<script type=\"text/javascript\">window.onload = new Function(\"redirectWait();\");<" + "/" + "script>");
}
else if (intCurrent < intStep)
{
oOnDemand.UpdateStepDoneWorkstation(intWorkstation, intCurrent, oOnDemand.GetStep(intStep, "done"), 0, false, false);
oWorkstation.NextVirtualStep(intWorkstation);
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "completed", "<script type=\"text/javascript\">window.onload = new Function(\"redirect();\");<" + "/" + "script>");
}
else if (intCurrent == dsSteps.Tables[0].Rows.Count)
{
oWorkstation.NextVirtualStep(intWorkstation);
//SqlHelper.ExecuteNonQuery(dsnRemote, CommandType.Text, "UPDATE cv_virtual_workstations SET deleted = 1 WHERE id = " + intID.ToString() + " AND deleted = 0");
oForecast.UpdateAnswerCompleted(intAnswer);
oWorkstation.UpdateVirtualCompleted(intWorkstation);
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "completed", "<script type=\"text/javascript\">window.onload = new Function(\"redirect();\");<" + "/" + "script>");
}
}
}
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "completed", "<script type=\"text/javascript\">window.onload = new Function(\"redirectWait();\");<" + "/" + "script>");
}
}
protected void btnSaveConfig_Click(Object Sender, EventArgs e)
{
int intConfigured = ((ddlOS.SelectedIndex > 0 && Int32.Parse(Request.Form[hdnServicePack.UniqueID]) > 0 && ddlDomain.SelectedIndex > 0) ? 1 : 0);
int intWorkstation = 0;
if (lblId.Text != "")
{
intWorkstation = Int32.Parse(lblId.Text);
oWorkstation.UpdateVirtual(intWorkstation, Int32.Parse(ddlOS.SelectedItem.Value), Int32.Parse(Request.Form[hdnServicePack.UniqueID]), Int32.Parse(ddlDomain.SelectedItem.Value), intConfigured);
}
else
{
intWorkstation = oWorkstation.AddVirtual(intRequest, intAnswer, intNumber, 1, intModelVMware, Int32.Parse(ddlOS.SelectedItem.Value), Int32.Parse(Request.Form[hdnServicePack.UniqueID]), Int32.Parse(ddlDomain.SelectedItem.Value), Int32.Parse(oForecast.GetAnswerWorkstation(intAnswer, "ramid")), Int32.Parse(oForecast.GetAnswerWorkstation(intAnswer, "recovery")), Int32.Parse(oForecast.GetAnswerWorkstation(intAnswer, "internal")), Int32.Parse(oForecast.GetAnswerWorkstation(intAnswer, "hddid")), Int32.Parse(oForecast.GetAnswerWorkstation(intAnswer, "cpuid")), intConfigured, 0);
}
oWorkstation.DeleteComponents(intWorkstation);
foreach (ListItem oItem in chkComponents.Items)
{
if (oItem.Selected == true)
{
oWorkstation.AddComponents(intWorkstation, Int32.Parse(oItem.Value));
}
}
if (chkApply.Visible && chkApply.Checked)
{
for (int ii = 2; ii <= intQuantity; ii++)
{
DataSet ds = oWorkstation.GetVirtual(intAnswer, ii);
int intCopy = 0;
if (ds.Tables[0].Rows.Count > 0)
{
intCopy = Int32.Parse(ds.Tables[0].Rows[0]["id"].ToString());
oWorkstation.UpdateVirtual(intCopy, Int32.Parse(ddlOS.SelectedItem.Value), Int32.Parse(Request.Form[hdnServicePack.UniqueID]), Int32.Parse(ddlDomain.SelectedItem.Value), intConfigured);
}
else
{
intCopy = oWorkstation.AddVirtual(intRequest, intAnswer, ii, 1, intModelVMware, Int32.Parse(ddlOS.SelectedItem.Value), Int32.Parse(Request.Form[hdnServicePack.UniqueID]), Int32.Parse(ddlDomain.SelectedItem.Value), Int32.Parse(oForecast.GetAnswerWorkstation(intAnswer, "ramid")), Int32.Parse(oForecast.GetAnswerWorkstation(intAnswer, "recovery")), Int32.Parse(oForecast.GetAnswerWorkstation(intAnswer, "internal")), Int32.Parse(oForecast.GetAnswerWorkstation(intAnswer, "hddid")), Int32.Parse(oForecast.GetAnswerWorkstation(intAnswer, "cpuid")), intConfigured, 0);
}
oWorkstation.DeleteComponents(intCopy);
foreach (ListItem oItem in chkComponents.Items)
{
if (oItem.Selected == true)
{
oWorkstation.AddComponents(intCopy, Int32.Parse(oItem.Value));
}
}
}
}
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "save", "<script type=\"text/javascript\">RefreshOpeningWindow();window.close();<" + "/" + "script>");
}
protected void btnStep_Click(Object Sender, EventArgs e)
{
string strError = "";
int intWorkstation = Int32.Parse(lblWorkstation.Text);
if (chkStep.Checked == true)
{
int intAsset2 = 0;
int intStep = 0;
DataSet ds = oWorkstation.GetVirtualErrors(intWorkstation);
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["assetid"].ToString() != "")
{
intAsset2 = Int32.Parse(dr["assetid"].ToString());
}
if (dr["fixed"].ToString() == "")
{
intStep = Int32.Parse(dr["step"].ToString());
}
}
if (intWorkstation > 0)
{
oWorkstation.UpdateVirtualError(intWorkstation, intStep, 0, 0);
if (intAsset2 > 0)
{
string strSerial = oAsset.Get(intAsset2, "serial");
oZeus.UpdateResults(strSerial);
}
else
{
strError = "Warning: Invalid AssetID";
}
}
else
{
strError = "Error: Invalid WorkstationID";
}
}
if (chkStepVMWare.Checked == true)
{
VMWare oVMWare = new VMWare(0, dsn);
int intWorkstationName = 0;
Int32.TryParse(oWorkstation.GetVirtual(intWorkstation, "nameid"), out intWorkstationName);
oVMWare.DeleteGuest(oWorkstation.GetName(intWorkstationName));
}
oWorkstation.UpdateVirtualStep(intWorkstation, Int32.Parse(txtStep.Text));
Response.Redirect(Request.Path + "?q=" + Request.QueryString["q"] + "&id=" + oFunction.encryptQueryString(intAsset.ToString()) + "&admin=true&menu_tab=6&result=" + oFunction.encryptQueryString((strError == "" ? "Success" : strError)));
}
protected void btnNext_Click(Object Sender, EventArgs e)
{
int intRequest = Int32.Parse(Request.QueryString["rid"]);
int intItem = Int32.Parse(lblItem.Text);
int intNumber = Int32.Parse(lblNumber.Text);
foreach (ListItem oList in lstWorkstations.Items)
{
if (oList.Selected == true)
{
int intWorkstation = Int32.Parse(oList.Value);
DataSet dsWorkstation = oWorkstation.GetVirtual(intWorkstation);
if (dsWorkstation.Tables[0].Rows.Count > 0)
{
oCustomized.AddVirtualWorkstationAccount(intRequest, intItem, intNumber, intWorkstation);
oWorkstation.AddAccountFix(Int32.Parse(dsWorkstation.Tables[0].Rows[0]["assetid"].ToString()), 0, Int32.Parse(Request.Form[hdnManager.UniqueID]), 0, 1);
}
}
}
oRequestItem.UpdateForm(intRequest, true);
Response.Redirect(oPage.GetFullLink(intPage) + "?rid=" + intRequest.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
OnDemand oOnDemand = new OnDemand(0, dsn);
Forecast oForecast = new Forecast(0, dsn);
Workstations oWorkstation = new Workstations(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 intWorkstation = Int32.Parse(oFunction.decryptQueryString(Request.QueryString["id"]));
DataSet ds = oWorkstation.GetVirtual(intWorkstation);
if (ds.Tables[0].Rows.Count > 0)
{
int intAnswer = Int32.Parse(ds.Tables[0].Rows[0]["answerid"].ToString());
int intAsset = Int32.Parse(ds.Tables[0].Rows[0]["assetid"].ToString());
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);
}
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 = oWorkstation.GetVirtualStep(intWorkstation);
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('" + intWorkstation.ToString() + "','" + intCurrentWithError.ToString() + "');";
}
}
}
else
{
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.GetStepDoneWorkstation(intWorkstation, 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]["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(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 = oWorkstation.GetVirtualError(intWorkstation, 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()));
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(intWorkstation.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();
//DateTime datSubmitted = DateTime.Parse(ds.Tables[0].Rows[0]["created"].ToString());
//lblDate.Text = datSubmitted.ToString();
//Holidays oHoliday = new Holidays(0, dsn);
//lblDelivered.Text = oHoliday.GetDays(10.00, datSubmitted).ToString();
}
}
else
{
Response.Write("Invalid Configuration - validate host configuration");
}
if (strOnLoad != "")
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "start_count", "<script type=\"text/javascript\">window.onload = new Function(\"" + strOnLoad + "\");" + (strError == "" ? "" : "LoadError('" + strError.Replace("'", "") + "');") + "<" + "/" + "script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
oWorkstation = new Workstations(intProfile, dsn);
oServer = new Servers(intProfile, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oUser = new Users(intProfile, dsn);
oVMWare = new VMWare(intProfile, dsn);
oAsset = new Asset(intProfile, dsnAsset, dsn);
oError = new Errors(intProfile, dsn);
oZeus = new Zeus(intProfile, dsnZeus);
oVariable = new Variables(intEnvironment);
oOperatingSystem = new OperatingSystems(intProfile, dsn);
lblTitle.Text = "Provisioning Issue";
string strUser = Request.ServerVariables["logon_user"];
strUser = strUser.Substring(strUser.LastIndexOf("\\") + 1);
intUser = oUser.GetId(strUser);
if (intUser > 0)
{
if (Request.QueryString["fixed"] != null && Request.QueryString["fixed"] != "")
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "fixed", "<script type=\"text/javascript\">alert('The issue has been saved and the device is queued to continue.\\n\\nThis window will now be closed.');window.close();<" + "/" + "script>");
}
if (Request.QueryString["type"] != null && Request.QueryString["id"] != null)
{
try
{
intID = Int32.Parse(oFunction.decryptQueryString(Request.QueryString["id"]));
}
catch
{
intID = 0;
}
if (intID > 0)
{
if (!IsPostBack)
{
bool boolVMware = false;
if (Request.QueryString["type"] == "s")
{
lblType.Text = "Server";
lblLabel.Text = "Design ID:";
DataSet ds = oServer.GetErrors(intID);
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["fixed"].ToString() == "")
{
lblName.Text = dr["servername"].ToString();
lblDate.Text = dr["created"].ToString();
lblIssue.Text = dr["reason"].ToString();
int intServer = 0;
if (dr["serverid"].ToString() != "")
{
intServer = Int32.Parse(dr["serverid"].ToString());
}
if (intServer > 0)
{
int intOS = 0;
Int32.TryParse(oServer.Get(intServer, "osid"), out intOS);
lblOS.Text = oOperatingSystem.Get(intOS, "name");
lblValue.Text = oServer.Get(intServer, "answerid");
}
int intAsset = 0;
if (dr["assetid"].ToString() != "")
{
intAsset = Int32.Parse(dr["assetid"].ToString());
}
lblAsset.Text = intAsset.ToString();
lblStep.Text = dr["step"].ToString();
if (intAsset != 0)
{
string strILO = oAsset.GetServerOrBlade(intAsset, "ilo");
if (strILO != "")
{
panVMwareNo.Visible = true;
lblConsole.Text = "<a href=\"https://" + strILO + "\" target=\"_blank\">" + strILO + "</a>";
}
else
{
boolVMware = true;
}
}
}
}
// Load Existing Errors
Tab oTab = new Tab("", 0, "divMenu1", true, false);
rptRelated.DataSource = oError.Gets(lblIssue.Text, intUser);
rptRelated.DataBind();
int intTab = 0;
foreach (RepeaterItem ri in rptRelated.Items)
{
intTab++;
oTab.AddTab("Solution # " + intTab.ToString(), "");
((Button)ri.FindControl("btnSelect")).Attributes.Add("onclick", "return confirm('Are you sure you want to select this solution as the fix?');");
Label lblAttach = (Label)ri.FindControl("lblAttach");
Panel panAttach = (Panel)ri.FindControl("panAttach");
if (lblAttach.Text != "")
{
panAttach.Visible = true;
string strAttach = lblAttach.Text;
if (strAttach.Contains("\\") == true)
{
strAttach = strAttach.Substring(strAttach.LastIndexOf("\\") + 1);
}
lblAttach.Text = "<a href=\"" + lblAttach.Text + "\" target=\"_blank\">" + strAttach + "</a>";
}
}
strMenuTab1 = oTab.GetTabs();
trNone.Visible = (rptRelated.Items.Count == 0);
}
else if (Request.QueryString["type"] == "w")
{
if (!IsPostBack)
{
lblType.Text = "Workstation";
lblLabel.Text = "Request ID:";
DataSet ds = oWorkstation.GetVirtualErrors(intID);
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["fixed"].ToString() == "")
{
lblName.Text = dr["workstationname"].ToString();
lblDate.Text = dr["created"].ToString();
lblIssue.Text = dr["reason"].ToString();
int intWorkstation = 0;
if (dr["workstationid"].ToString() != "")
{
intWorkstation = Int32.Parse(dr["workstationid"].ToString());
}
if (intWorkstation > 0)
{
int intOS = 0;
Int32.TryParse(oWorkstation.GetVirtual(intWorkstation, "osid"), out intOS);
lblOS.Text = oOperatingSystem.Get(intOS, "name");
lblValue.Text = oWorkstation.GetVirtual(intWorkstation, "requestid");
}
int intAsset = 0;
if (dr["assetid"].ToString() != "")
{
intAsset = Int32.Parse(dr["assetid"].ToString());
}
lblAsset.Text = intAsset.ToString();
lblStep.Text = dr["step"].ToString();
boolVMware = true;
}
}
// Load Existing Errors
Tab oTab = new Tab("", 0, "divMenu1", true, false);
rptRelated.DataSource = oError.Gets(lblError.Text, 0);
rptRelated.DataBind();
int intTab = 0;
foreach (RepeaterItem ri in rptRelated.Items)
{
intTab++;
oTab.AddTab("Solution # " + intTab.ToString(), "");
((Button)ri.FindControl("btnSelect")).Attributes.Add("onclick", "return confirm('Are you sure you want to select this solution as the fix?');");
Label lblAttach = (Label)ri.FindControl("lblAttach");
Panel panAttach = (Panel)ri.FindControl("panAttach");
if (lblAttach.Text != "")
{
panAttach.Visible = true;
string strAttach = lblAttach.Text;
if (strAttach.Contains("\\") == true)
{
strAttach = strAttach.Substring(strAttach.LastIndexOf("\\") + 1);
}
lblAttach.Text = "<a href=\"" + lblAttach.Text + "\" target=\"_blank\">" + strAttach + "</a>";
}
}
strMenuTab1 = oTab.GetTabs();
trNone.Visible = (rptRelated.Items.Count == 0);
}
}
if (boolVMware == true)
{
panVMware.Visible = true;
DataSet dsGuest = oVMWare.GetGuest(lblName.Text);
if (dsGuest.Tables[0].Rows.Count > 0)
{
DataRow drGuest = dsGuest.Tables[0].Rows[0];
int intDatastore = Int32.Parse(drGuest["datastoreid"].ToString());
lblDataStore.Text = oVMWare.GetDatastore(intDatastore, "name");
int intHost = Int32.Parse(drGuest["hostid"].ToString());
int intCluster = Int32.Parse(oVMWare.GetHost(intHost, "clusterid"));
lblCluster.Text = oVMWare.GetCluster(intCluster, "name");
int intFolder = Int32.Parse(oVMWare.GetCluster(intCluster, "folderid"));
lblFolder.Text = oVMWare.GetFolder(intFolder, "name");
int intDataCenter = Int32.Parse(oVMWare.GetFolder(intFolder, "datacenterid"));
lblDataCenter.Text = oVMWare.GetDatacenter(intDataCenter, "name");
int intVirtualCenter = Int32.Parse(oVMWare.GetDatacenter(intDataCenter, "virtualcenterid"));
lblVirtualCenter.Text = oVMWare.GetVirtualCenter(intVirtualCenter, "name");
}
}
if (lblName.Text == "")
{
lblError.Text = "This device is not experiencing any provisioning issues at the moment (" + intID.ToString() + ")";
}
// Load the case codes
ddlCode.DataTextField = "name";
ddlCode.DataValueField = "id";
ddlCode.DataSource = oError.GetTypeTypes(2, 1);
ddlCode.DataBind();
ddlCode.Items.Insert(0, new ListItem("-- SELECT --", "0"));
}
}
else
{
lblError.Text = "Could not find record";
}
}
else
{
lblError.Text = "Invalid Parameter(s)";
}
}
else
{
lblError.Text = "Could not find a user account for userID = " + strUser;
}
if (lblError.Text == "")
{
panIssue.Visible = true;
btnFixed.Attributes.Add("onclick", "return ValidateText('" + txtIssue.ClientID + "','Please enter the issue') && ValidateText('" + txtResolution.ClientID + "','Please enter the resolution') && ValidateDropDown('" + ddlCode.ClientID + "','Please select a case code') && confirm('Are you sure you want to mark this error as fixed?') && ProcessButton(this);");
radNew.Attributes.Add("onclick", "ShowHideDiv('" + divNew.ClientID + "','inline');ShowHideDiv('" + divExisting.ClientID + "','none');");
radExisting.Attributes.Add("onclick", "ShowHideDiv('" + divNew.ClientID + "','none');ShowHideDiv('" + divExisting.ClientID + "','inline');");
}
else
{
panDenied.Visible = true;
btnClose.Attributes.Add("onclick", "window.close();");
}
}
protected void Page_Load(object sender, EventArgs e)
{
//intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
intProfile = 0;
oWorkstation = new Workstations(intProfile, dsn);
oRemote = new Workstations(intProfile, dsnRemote);
oUser = new Users(intProfile, dsn);
oVariable = new Variables(intEnvironment);
oOnDemand = new OnDemand(intProfile, dsn);
oForecast = new Forecast(intProfile, dsn);
oClass = new Classes(intProfile, dsn);
string strUsers = "";
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
int intWorkstation = Int32.Parse(Request.QueryString["id"]);
DataSet ds = oWorkstation.GetVirtual(intWorkstation);
if (ds.Tables[0].Rows.Count > 0)
{
intStep = Int32.Parse(ds.Tables[0].Rows[0]["step"].ToString());
intAnswer = Int32.Parse(ds.Tables[0].Rows[0]["answerid"].ToString());
intAsset = Int32.Parse(ds.Tables[0].Rows[0]["assetid"].ToString());
intRemote = Int32.Parse(ds.Tables[0].Rows[0]["remoteid"].ToString());
int intClass = Int32.Parse(oForecast.GetAnswer(intAnswer, "classid"));
int intDomain = Int32.Parse(ds.Tables[0].Rows[0]["domainid"].ToString());
Domains oDomain = new Domains(intProfile, dsn);
lblDomain.Text = oDomain.Get(intDomain, "name");
intDomain = Int32.Parse(oDomain.Get(intDomain, "environment"));
int intName = Int32.Parse(ds.Tables[0].Rows[0]["nameid"].ToString());
lblWorkstation.Text = oWorkstation.GetName(intName);
txtUser.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'300','195','" + divAJAX.ClientID + "','" + lstAJAX.ClientID + "','" + hdnUser.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstAJAX.Attributes.Add("ondblclick", "AJAXClickRow();");
DataSet dsAccounts = oWorkstation.GetAccountsVirtual(intAsset);
rptAccounts.DataSource = dsAccounts;
rptAccounts.DataBind();
foreach (RepeaterItem ri in rptAccounts.Items)
{
LinkButton _delete = (LinkButton)ri.FindControl("btnDelete");
_delete.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this account?');");
}
foreach (DataRow drAccount in dsAccounts.Tables[0].Rows)
{
strUsers += oUser.GetName(Int32.Parse(drAccount["userid"].ToString())) + ";";
}
if (rptAccounts.Items.Count == 0)
{
lblNone.Visible = true;
btnSubmit.Attributes.Add("onclick", "alert('You must add at least one account or select the skip button');return false;");
}
if (oClass.IsProd(intClass))
{
panProduction.Visible = true;
}
else
{
panAdmin.Visible = true;
}
}
}
else
{
btnAdd.Enabled = false;
btnSubmit.Enabled = false;
btnSkip.Enabled = false;
}
btnSkip.Enabled = false;
//btnSkip.Attributes.Add("onclick", "return confirm('Are you sure you want to skip the account configuration process?');");
btnAdd.Attributes.Add("onclick", "return ValidateHidden('" + hdnUser.ClientID + "','" + txtUser.ClientID + "','Please enter a username, first name or last name') && EnsureAccenture('" + hdnUser.ClientID + "','" + strUsers + "');");
//btnAdd.Attributes.Add("onclick", "return ValidateHidden('" + hdnUser.ClientID + "','" + txtUser.ClientID + "','Please enter a username, first name or last name')" + (boolProduction == true ? " && EnsureAccenture('" + hdnUser.ClientID + "','" + strUsers + "')" : "") + ";");
btnManager.Attributes.Add("onclick", "return OpenWindow('NEW_USER','');");
}
protected void Page_Load(object sender, EventArgs e)
{
RequestItems oRequestItem = new RequestItems(intProfile, dsn);
ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn);
Services oService = new Services(intProfile, dsn);
Functions oFunction = new Functions(intProfile, dsn, intEnvironment);
Workstations oWorkstation = new Workstations(intProfile, dsn);
Customized oCustomized = new Customized(intProfile, dsn);
Forecast oForecast = new Forecast(intProfile, dsn);
Variables oVariable = new Variables(intEnvironment);
Users oUser = new Users(intProfile, dsn);
int intRequest = Int32.Parse(Request.QueryString["rid"]);
string strStatus = oServiceRequest.Get(intRequest, "checkout");
DataSet dsItems = oRequestItem.GetForms(intRequest);
int intItem = 0;
int intService = 0;
int intNumber = 0;
if (dsItems.Tables[0].Rows.Count > 0)
{
bool boolBreak = false;
foreach (DataRow drItem in dsItems.Tables[0].Rows)
{
if (boolBreak == true)
{
break;
}
if (drItem["done"].ToString() == "0")
{
intItem = Int32.Parse(drItem["itemid"].ToString());
intService = Int32.Parse(drItem["serviceid"].ToString());
intNumber = Int32.Parse(drItem["number"].ToString());
boolBreak = true;
}
if (intItem > 0 && (strStatus == "1" || strStatus == "2"))
{
bool boolSuccess = true;
string strResult = oService.GetName(intService) + " Completed";
string strError = oService.GetName(intService) + " Error";
// ********* BEGIN PROCESSING **************
DataSet ds = oCustomized.GetVirtualWorkstationAccount(intRequest, intItem, intNumber);
foreach (DataRow dr in ds.Tables[0].Rows)
{
int intWorkstation = Int32.Parse(dr["workstationid"].ToString());
int intAnswer = Int32.Parse(oWorkstation.GetVirtual(intWorkstation, "answerid"));
int intUser = Int32.Parse(oForecast.GetAnswer(intAnswer, "appcontact"));
string strEMailIdsBCC = oFunction.GetGetEmailAlertsEmailIds("EMAILGRP_REQUEST_ASSIGNMENT");
oFunction.SendEmail("Virtual Workstation Account Approval", oUser.GetName(intUser), strEMailIdsBCC, strEMailIdsBCC, "Virtual Workstation Account Approval", "<p><b>A virtual workstation account request requires your approval.</b></p><p><a href=\"" + oVariable.URL() + "/redirect.aspx?referrer=/approval/workstation/account.aspx?id=" + intWorkstation.ToString() + "\" target=\"_blank\">Click here to view this request.</a></p>", true, false);
}
// ******** END PROCESSING **************
if (oService.Get(intService, "automate") == "1" && boolSuccess == true)
{
strDone += "<p><span class=\"biggerbold\"><img src=\"/images/bigCheck.gif\" border=\"0\" align=\"absmiddle\"/> " + strResult + "</span></p>";
}
else
{
if (boolSuccess == false)
{
strDone += "<p><span class=\"biggerbold\"><img src=\"/images/bigError.gif\" border=\"0\" align=\"absmiddle\"/> " + strError + "</span></p>";
}
else
{
strDone += "<p><span class=\"biggerbold\"><img src=\"/images/bigCheck.gif\" border=\"0\" align=\"absmiddle\"/> " + oService.GetName(intService) + " Submitted</span></p>";
}
}
oRequestItem.UpdateFormDone(intRequest, intItem, intNumber, 1);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = "ClearView Account Configuration";
AuthenticateUser();
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oUser = new Users(intProfile, dsn);
oVariable = new Variables(intEnvironment);
oFunction = new Functions(0, dsn, intEnvironment);
oForecast = new Forecast(intProfile, dsn);
oWorkstation = new Workstations(intProfile, dsn);
oOnDemand = new OnDemand(intProfile, dsn);
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
intWorkstation = Int32.Parse(Request.QueryString["id"]);
Page.Title = "ClearView Account Configuration | Workstation # " + intWorkstation.ToString();
DataSet ds = oWorkstation.GetVirtual(intWorkstation);
if (ds.Tables[0].Rows.Count > 0)
{
if (Request.QueryString["userid"] != null && Request.QueryString["userid"] != "")
{
int intUser = Int32.Parse(Request.QueryString["userid"]);
trUpdate.Visible = true;
lblXID.Text = oUser.GetFullName(intUser) + " (" + oUser.GetName(intUser) + ")";
btnAdd.Text = "Update";
btnCancel.Visible = true;
}
else
{
trNew.Visible = true;
}
intStep = Int32.Parse(ds.Tables[0].Rows[0]["step"].ToString());
intInternal = Int32.Parse(ds.Tables[0].Rows[0]["internal"].ToString());
intAnswer = Int32.Parse(ds.Tables[0].Rows[0]["answerid"].ToString());
int intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString());
DataSet dsAnswer = oForecast.GetAnswer(intAnswer);
if (dsAnswer.Tables[0].Rows.Count > 0)
{
intQuantity = Int32.Parse(dsAnswer.Tables[0].Rows[0]["quantity"].ToString());
chkApply.Visible = (intQuantity > 1 && intNumber == 1);
}
intRequest = oForecast.GetRequestID(intAnswer, true);
intDomain = Int32.Parse(ds.Tables[0].Rows[0]["domainid"].ToString());
Domains oDomain = new Domains(intProfile, dsn);
int intClass = Int32.Parse(oForecast.GetAnswer(intAnswer, "classid"));
Classes oClass = new Classes(intProfile, dsn);
if (oForecast.GetAnswer(intAnswer, "test") == "1")
{
intDomain = Int32.Parse(ds.Tables[0].Rows[0]["test_domainid"].ToString());
}
lblDomain.Text = oDomain.Get(intDomain, "name");
Requests oRequest = new Requests(intProfile, dsn);
//if (oRequest.GetUser(intRequest) == intProfile)
//{
panPermit.Visible = true;
txtUser.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'300','195','" + divAJAX.ClientID + "','" + lstAJAX.ClientID + "','" + hdnUser.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstAJAX.Attributes.Add("ondblclick", "AJAXClickRow();");
chkAdmin.Attributes.Add("onclick", "CheckAdmin(this);");
ds = oWorkstation.GetAccountsVMware(intWorkstation);
rptAccounts.DataSource = ds;
rptAccounts.DataBind();
foreach (RepeaterItem ri in rptAccounts.Items)
{
LinkButton _delete = (LinkButton)ri.FindControl("btnDelete");
_delete.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this account?');");
}
if (rptAccounts.Items.Count == 0)
{
lblNone.Visible = true;
btnSubmit.Attributes.Add("onclick", "alert('You must add at least one account or select the skip button');return false;");
}
//if (oClass.IsProd(intClass))
panProduction.Visible = true;
//else
// panAdmin.Visible = true;
}
}
else
{
btnAdd.Enabled = false;
btnSubmit.Enabled = false;
btnSkip.Enabled = false;
}
btnSkip.Enabled = false;
//btnSkip.Attributes.Add("onclick", "return confirm('Are you sure you want to skip the account configuration process?');");
btnAdd.Attributes.Add("onclick", "return ValidateHidden('" + hdnUser.ClientID + "','" + txtUser.ClientID + "','Please enter a username, first name or last name');");
btnManager.Attributes.Add("onclick", "return OpenWindow('NEW_USER','');");
}
protected void Page_Load(object sender, EventArgs e)
{
Int32.TryParse(Request.Cookies["profileid"].Value, out intProfile);
oServer = new Servers(intProfile, dsn);
oServerName = new ServerName(intProfile, dsn);
oWorkstation = new Workstations(intProfile, dsn);
oAsset = new Asset(intProfile, dsnAsset, dsn);
Int32.TryParse(Request.QueryString["assetid"], out intAsset);
bool boolMessage = false;
if (Request.QueryString["changed"] != null)
{
boolMessage = true;
Page.ClientScript.RegisterStartupScript(typeof(Page), "changed", "<script type=\"text/javascript\">alert('Device Name Changed Successfully!');RefreshOpeningWindow();window.close();<" + "/" + "script>");
}
if (Request.QueryString["cleared"] != null)
{
boolMessage = true;
Page.ClientScript.RegisterStartupScript(typeof(Page), "cleared", "<script type=\"text/javascript\">alert('Device Name Cleared Successfully!');RefreshOpeningWindow();window.close();<" + "/" + "script>");
}
if (Request.QueryString["error"] != null)
{
boolMessage = true;
Page.ClientScript.RegisterStartupScript(typeof(Page), "bad", "<script type=\"text/javascript\">alert('There was a problem changing the device name...\\n\\n" + Request.QueryString["error"] + "');<" + "/" + "script>");
}
if (Int32.TryParse(oAsset.GetStatus(intAsset, "status"), out intStatus) == true)
{
if (!IsPostBack)
{
string strAdditional = "";
if (intAsset > 0 && Int32.TryParse(oAsset.GetStatus(intAsset, "status"), out intStatus) == true)
{
if (Request.QueryString["clear"] != null)
{
if (Request.QueryString["clear"] == "Clear")
{
radClear.SelectedValue = "Clear";
if (intStatus == (int)AssetStatus.InUse)
{
lblError.Text = "Can not clear the name of an asset while its Status is "In Use".";
}
panClear.Visible = true;
panID.Visible = true;
}
if (Request.QueryString["clear"] == "Change")
{
radClear.SelectedValue = "Change";
panChange.Visible = true;
panID.Visible = true;
}
}
DataSet dsWorkstations = oWorkstation.GetVirtualAsset(intAsset);
if (dsWorkstations.Tables[0].Rows.Count == 1)
{
radClear.Items[0].Enabled = false;
radClear.Items[0].Text += " - cannot clear device name for workstations";
ddlType.SelectedValue = "-1";
int intWorkstation = 0;
int intName = 0;
if (Int32.TryParse(dsWorkstations.Tables[0].Rows[0]["id"].ToString(), out intWorkstation) == true)
{
lblID.Text = intWorkstation.ToString();
if (Int32.TryParse(oWorkstation.GetVirtual(intWorkstation, "nameid"), out intName) == true)
{
lblNameID.Text = intName.ToString();
lblName.Text = oWorkstation.GetName(intName);
lblNew.Text = lblName.Text;
panWorkstation.Visible = true;
DataSet dsWorkstation = oWorkstation.GetNameId(intName);
if (dsWorkstation.Tables[0].Rows.Count == 1)
{
DataRow drWorkstation = dsWorkstation.Tables[0].Rows[0];
#region WORKSTATION NAMING
// Environment
ddlWorkstationEnvironment.Attributes.Add("onchange", "UpdateNamingDDL(this,'" + lblWorkstationEnvironment.ClientID + "','WORKSTATION');");
lblWorkstationEnvironment.Text = drWorkstation["environment"].ToString();
ddlWorkstationEnvironment.SelectedValue = lblWorkstationEnvironment.Text;
// Code
ddlWorkstationCode.Attributes.Add("onchange", "UpdateNamingDDL(this,'" + lblWorkstationCode.ClientID + "','WORKSTATION');");
lblWorkstationCode.Text = drWorkstation["code"].ToString();
ddlWorkstationCode.SelectedValue = lblWorkstationCode.Text;
//Sequence
txtWorkstationSequence.Attributes.Add("onblur", "UpdateNamingText(this,'" + lblWorkstationSequence.ClientID + "','WORKSTATION');");
lblWorkstationSequence.Text = drWorkstation["prefix1"].ToString() + drWorkstation["prefix2"].ToString() + drWorkstation["prefix3"].ToString() + drWorkstation["prefix4"].ToString() + drWorkstation["prefix5"].ToString() + drWorkstation["prefix6"].ToString();
txtWorkstationSequence.Text = lblWorkstationSequence.Text;
panButtons.Visible = (Request.QueryString["clear"] != null);
lblNew.Text = lblWorkstationEnvironment.Text + lblWorkstationCode.Text + lblWorkstationIdentifier.Text + lblWorkstationSequence.Text;
strAdditional += "ValidateTextLength('" + txtWorkstationSequence.ClientID + "', 'Please enter a valid sequence\\n\\n - Must be exactly 6 characters in length', 6) && ";
#endregion
}
}
else
{
lblError.Text = "Invalid Workstation Name Record(" + oWorkstation.GetVirtual(intWorkstation, "nameid") + ")";
}
}
else
{
lblError.Text = "Invalid Workstation Record(" + dsWorkstations.Tables[0].Rows[0]["id"].ToString() + ")";
}
}
else
{
DataSet dsServers = oServer.GetAssetsAsset(intAsset);
if (dsServers.Tables[0].Rows.Count == 1)
{
int intServer = 0;
int intName = 0;
if (Int32.TryParse(dsServers.Tables[0].Rows[0]["serverid"].ToString(), out intServer) == true)
{
lblID.Text = intServer.ToString();
if (Int32.TryParse(oServer.Get(intServer, "nameid"), out intName) == true)
{
lblNameID.Text = intName.ToString();
lblName.Text = oServer.GetName(intServer, true);
if (oServer.Get(intServer, "pnc") == "1")
{
ddlType.SelectedValue = "1";
panPNC.Visible = true;
DataSet dsPNC = oServerName.GetFactory(intName);
if (dsPNC.Tables[0].Rows.Count == 1 || intName == 0)
{
//Operating System
OperatingSystems oOperatingSystem = new OperatingSystems(intProfile, dsn);
DataSet dsOS = oOperatingSystem.Gets(0, 1);
DataView dvOS = dsOS.Tables[0].DefaultView;
dvOS.RowFilter = "factory_code <> '' AND factory_code IS NOT NULL";
ddlPNCOS.DataTextField = "name";
ddlPNCOS.DataValueField = "factory_code";
ddlPNCOS.DataSource = dvOS;
ddlPNCOS.DataBind();
ddlPNCOS.Attributes.Add("onchange", "UpdateNamingDDL(this,'" + lblPNCOS.ClientID + "','PNC');");
//Location
Locations oLocation = new Locations(intProfile, dsn);
DataSet dsLocation = oLocation.GetAddresss(1);
DataView dvLocation = dsLocation.Tables[0].DefaultView;
dvLocation.RowFilter = "factory_code <> 'X' AND factory_code <> '' AND factory_code IS NOT NULL";
ddlPNCLocation.DataTextField = "commonname";
ddlPNCLocation.DataValueField = "factory_code";
ddlPNCLocation.DataSource = dvLocation;
ddlPNCLocation.DataBind();
ddlPNCLocation.Items.Add(new ListItem("Other", "X"));
ddlPNCLocation.Attributes.Add("onchange", "UpdateNamingDDL(this,'" + lblPNCLocation.ClientID + "','PNC');");
//Mnemonic
Variables oVariable = new Variables(intEnvironment);
Mnemonic oMnemonic = new Mnemonic(intProfile, dsn);
txtPNCMnemonic.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'350','150','" + divPNCMnemonic.ClientID + "','" + lstPNCMnemonic.ClientID + "','" + hdnPNCMnemonic.ClientID + "','" + oVariable.URL() + "/frame/ajax/ajax_mnemonics.aspx',2);");
lstPNCMnemonic.Attributes.Add("ondblclick", "AJAXClickRow();");
hdnPNCMnemonic.Attributes.Add("onpropertychange", "UpdateNamingMnemonic('" + hdnPNCMnemonic.ClientID + "','" + txtPNCMnemonic.ClientID + "','" + lblPNCMnemonic.ClientID + "','PNC');");
//Environment
Classes oClass = new Classes(intProfile, dsn);
DataSet dsClass = oClass.Gets(1);
DataView dvClass = dsClass.Tables[0].DefaultView;
dvClass.RowFilter = "factory_code <> '' AND factory_code IS NOT NULL";
ddlPNCEnvironment.DataTextField = "name";
ddlPNCEnvironment.DataValueField = "factory_code";
ddlPNCEnvironment.DataSource = dvClass;
ddlPNCEnvironment.DataBind();
ddlPNCEnvironment.Attributes.Add("onchange", "UpdateNamingDDL(this,'" + lblPNCEnvironment.ClientID + "','PNC');");
//Sequence
txtPNCSequence.Attributes.Add("onblur", "UpdateNamingText(this,'" + lblPNCSequence.ClientID + "','PNC');");
//Function
ddlPNCFunction.Attributes.Add("onchange", "UpdateNamingDDL(this,'" + lblPNCFunction.ClientID + "','PNC');");
//Specific
ddlPNCSpecific.Attributes.Add("onchange", "UpdateNamingDDL(this,'" + lblPNCSpecific.ClientID + "','PNC');");
#region PNC NAMING
if (intName > 0)
{
DataRow drPNC = dsPNC.Tables[0].Rows[0];
//Operating System
lblPNCOS.Text = drPNC["os"].ToString();
ddlPNCOS.SelectedValue = lblPNCOS.Text;
//Location
lblPNCLocation.Text = drPNC["location"].ToString();
ddlPNCLocation.SelectedValue = lblPNCLocation.Text;
//Mnemonic
lblPNCMnemonic.Text = drPNC["mnemonic"].ToString();
DataSet dsMnemonic = oMnemonic.Get(lblPNCMnemonic.Text + " - ");
int intMnemonic = Int32.Parse(dsMnemonic.Tables[0].Rows[0]["id"].ToString());
hdnPNCMnemonic.Value = intMnemonic.ToString();
txtPNCMnemonic.Text = lblPNCMnemonic.Text + " - " + oMnemonic.Get(intMnemonic, "name");
//Environment
lblPNCEnvironment.Text = drPNC["environment"].ToString();
ddlPNCEnvironment.SelectedValue = lblPNCEnvironment.Text;
//Sequence
lblPNCSequence.Text = drPNC["name1"].ToString() + drPNC["name2"].ToString();
txtPNCSequence.Text = lblPNCSequence.Text;
//Function
lblPNCFunction.Text = drPNC["func"].ToString();
ddlPNCFunction.SelectedValue = lblPNCFunction.Text;
//Specific
lblPNCSpecific.Text = drPNC["specific"].ToString();
ddlPNCSpecific.SelectedValue = lblPNCSpecific.Text;
}
else
{
//Operating System
ddlPNCOS.Items.Insert(0, new ListItem("-- SELECT --", "0"));
strAdditional += "ValidateDropDown('" + ddlPNCOS.ClientID + "','Please select an Operating System') && ";
//Location
ddlPNCLocation.Items.Insert(0, new ListItem("-- SELECT --", "0"));
strAdditional += "ValidateDropDown('" + ddlPNCLocation.ClientID + "','Please select a Location') && ";
//Mnemonic
strAdditional += "ValidateHidden0('" + hdnPNCMnemonic.ClientID + "','" + txtPNCMnemonic.ClientID + "','Please enter the mnemonic') && ";
//Environment
ddlPNCEnvironment.Items.Insert(0, new ListItem("-- SELECT --", "0"));
strAdditional += "ValidateDropDown('" + ddlPNCEnvironment.ClientID + "','Please select an Environment') && ";
//Sequence - Done down below
//Function
ddlPNCFunction.Items.Insert(0, new ListItem("-- SELECT --", "0"));
strAdditional += "ValidateDropDown('" + ddlPNCFunction.ClientID + "','Please select a Function') && ";
//Specific
ddlPNCSpecific.Items.Insert(0, new ListItem("-- SELECT --", "0"));
strAdditional += "ValidateDropDown('" + ddlPNCSpecific.ClientID + "','Please select an Option') && ";
}
panButtons.Visible = (Request.QueryString["clear"] != null);
lblNew.Text = lblPNCOS.Text + lblPNCLocation.Text + lblPNCMnemonic.Text + lblPNCEnvironment.Text + lblPNCSequence.Text + lblPNCFunction.Text + lblPNCSpecific.Text;
strAdditional += "ValidateTextLength('" + txtPNCSequence.ClientID + "', 'Please enter a valid sequence\\n\\n - Must be exactly 2 characters in length', 2) && ";
#endregion
}
else
{
lblError.Text = "PNC Names (" + dsPNC.Tables[0].Rows.Count.ToString() + ")";
}
}
else
{
ddlType.SelectedValue = "0";
panNCB.Visible = true;
DataSet dsNCB = oServerName.Get(intName);
if (dsNCB.Tables[0].Rows.Count == 1 || intName == 0)
{
//State
txtNCBState.Attributes.Add("onblur", "UpdateNamingText(this,'" + lblNCBState.ClientID + "','NCB');");
//City
txtNCBCity.Attributes.Add("onblur", "UpdateNamingText(this,'" + lblNCBCity.ClientID + "','NCB');");
//Function
DataSet dsFunction = oServerName.GetFunctions();
DataView dvFunction = dsFunction.Tables[0].DefaultView;
dvFunction.RowFilter = "code <> '' AND code IS NOT NULL";
ddlNCBFunction.DataTextField = "name";
ddlNCBFunction.DataValueField = "code";
ddlNCBFunction.DataSource = dvFunction;
ddlNCBFunction.DataBind();
ddlNCBFunction.Attributes.Add("onchange", "UpdateNamingDDL(this,'" + lblNCBFunction.ClientID + "','NCB');");
//SiteCode
ddlNCBSiteCode.Attributes.Add("onchange", "UpdateNamingDDL(this,'" + lblNCBSiteCode.ClientID + "','NCB');");
//Sequence
txtNCBSequence.Attributes.Add("onblur", "UpdateNamingText(this,'" + lblNCBSequence.ClientID + "','NCB');");
#region NCB NAMING
if (intName > 0)
{
DataRow drNCB = dsNCB.Tables[0].Rows[0];
string strPrefix = drNCB["prefix1"].ToString();
string strPrefix1 = strPrefix.Substring(0, 2);
string strPrefix2 = strPrefix.Substring(2, 3);
//State
lblNCBState.Text = strPrefix1;
txtNCBState.Text = lblNCBState.Text;
//City
lblNCBCity.Text = strPrefix2;
txtNCBCity.Text = lblNCBCity.Text;
//Function
lblNCBFunction.Text = drNCB["prefix2"].ToString();
ddlNCBFunction.SelectedValue = lblNCBFunction.Text;
//SiteCode
lblNCBSiteCode.Text = drNCB["sitecode"].ToString();
ddlNCBSiteCode.SelectedValue = lblNCBSiteCode.Text;
//Sequence
lblNCBSequence.Text = drNCB["name1"].ToString() + drNCB["name2"].ToString();
txtNCBSequence.Text = lblNCBSequence.Text;
}
else
{
//State - Done down below
//City - Done down below
//Function
ddlNCBFunction.Items.Insert(0, new ListItem("-- SELECT --", "0"));
strAdditional += "ValidateDropDown('" + ddlNCBFunction.ClientID + "','Please select a Function') && ";
//SiteCode
ddlNCBSiteCode.Items.Insert(0, new ListItem("-- SELECT --", "0"));
strAdditional += "ValidateDropDown('" + ddlNCBSiteCode.ClientID + "','Please select a Site Code') && ";
//Sequence - Done down below
}
panButtons.Visible = (Request.QueryString["clear"] != null);
lblNew.Text = lblNCBState.Text + lblNCBCity.Text + lblNCBFunction.Text + lblNCBSiteCode.Text + lblNCBSequence.Text;
strAdditional += "ValidateTextLength('" + txtNCBState.ClientID + "', 'Please enter a valid state\\n\\n - Must be exactly 2 characters in length', 2) && ";
strAdditional += "ValidateTextLength('" + txtNCBCity.ClientID + "', 'Please enter a valid city\\n\\n - Must be exactly 3 characters in length', 3) && ";
strAdditional += "ValidateTextLength('" + txtNCBSequence.ClientID + "', 'Please enter a valid sequence\\n\\n - Must be exactly 2 characters in length', 2) && ";
#endregion
}
else
{
lblError.Text = "NCB Names (" + dsNCB.Tables[0].Rows.Count.ToString() + ")";
}
}
}
else
{
lblError.Text = "Invalid Server Name Record(" + oServer.Get(intServer, "nameid") + ")";
}
}
else
{
lblError.Text = "Invalid Server Record(" + dsServers.Tables[0].Rows[0]["serverid"].ToString() + ")";
}
}
else
{
if (dsWorkstations.Tables[0].Rows.Count > 1)
{
lblError.Text = "Workstations (" + dsWorkstations.Tables[0].Rows.Count.ToString() + ")";
}
else if (dsServers.Tables[0].Rows.Count > 1)
{
lblError.Text = "Servers (" + dsServers.Tables[0].Rows.Count.ToString() + ")";
}
else
{
radClear.Items[1].Enabled = false;
panButtons.Visible = (Request.QueryString["clear"] != null);
//lblError.Text = "Asset Not Found";
}
}
}
if (lblName.Text == "")
{
lblName.Text = "---";
}
else
{
lblNew.CssClass = (lblNew.Text == lblName.Text ? "header" : "redheader");
}
if (panChange.Visible == true)
{
btnSubmit.Attributes.Add("onclick", "return " + strAdditional + " IsOKtoChange() && confirm('WARNING: This will permanently change the device name and release the previous name for re-use (if applicable)!\\n\\nAre you sure you want to continue?') && ProcessButton(this,'Changing...','100');");
}
if (panClear.Visible == true)
{
btnSubmit.Attributes.Add("onclick", "return confirm('WARNING: This will permanently clear the device name and release it for re-use (if applicable)!\\n\\nAre you sure you want to continue?') && ProcessButton(this,'Clearing...','100');");
}
btnReset.Attributes.Add("onclick", "return IsOKtoReset(this);");
btnAlreadyChange.Attributes.Add("onclick", "return confirm('LAST CHANCE! This will permanently change the device name and release the previous name for re-use (if applicable)!\\n\\nAre you sure you want to continue?') && ProcessButton(this,'Changing...','100');");
}
else
{
lblError.Text = "Either the asset or the status of the asset could not be identified";
}
}
}
else
{
lblError.Text = "Either the asset or the status of the asset could not be identified";
}
if (lblError.Text != "" && boolMessage == false)
{
panError.Visible = true;
panClear.Visible = false;
btnSubmit.Enabled = false;
}
}
public void SystemError(int _serverid, int _workstationid, int _stepid, string _error, int _assetid, int _modelid, bool _is_vmware, VMWare _vmware, int _environment, string _dsn_asset)
{
int intError = 0;
if (_stepid > 0)
{
string strName = "";
string strType = "";
int intID = 0;
OnDemand oOnDemand = new OnDemand(0, dsn);
if (_serverid > 0)
{
oOnDemand.UpdateStepDoneServer(_serverid, _stepid, _error, 1, false, false);
Servers oServer = new Servers(0, dsn);
intError = oServer.AddError(0, 0, 0, _serverid, _stepid, _error);
strName = oServer.GetName(_serverid, true);
strType = "server";
intID = _serverid;
}
if (_workstationid > 0)
{
oOnDemand.UpdateStepDoneWorkstation(_workstationid, _stepid, _error, 1, false, false);
Workstations oWorkstation = new Workstations(0, dsn);
intError = oWorkstation.AddVirtualError(0, 0, 0, _workstationid, _stepid, _error);
int intName = 0;
if (Int32.TryParse(oWorkstation.GetVirtual(_workstationid, "nameid"), out intName) == true)
{
strName = oWorkstation.GetName(intName);
}
strType = "workstation";
intID = _workstationid;
}
if (_serverid > 0 || _workstationid > 0)
{
ModelsProperties oModelsProperties = new ModelsProperties(0, dsn);
Functions oFunction = new Functions(0, dsn, _environment);
Variables oVariable = new Variables(_environment);
Asset oAsset = new Asset(0, _dsn_asset);
int intType = oModelsProperties.GetType(_modelid);
DataSet dsSteps = oOnDemand.GetSteps(intType, 1);
string strStep = "N / A";
if (dsSteps.Tables[0].Rows.Count > 0)
{
strStep = dsSteps.Tables[0].Rows[_stepid - 1]["name"].ToString();
}
string strEMailIdsBCC = oFunction.GetGetEmailAlertsEmailIds("EMAILGRP_PROVISIONING_SUPPORT");
try
{
if (_is_vmware == true)
{
oFunction.SendEmail("Auto-Provisioning FATAL ERROR: " + strName, strEMailIdsBCC, "", "", "Auto-Provisioning FATAL ERROR: " + strName, "<p><b>This message is to inform you that the " + strType + " " + strName + " has encountered a FATAL error and has been stopped!</b><p><p>Serial Number: " + oAsset.Get(_assetid, "serial").ToUpper() + "<br/>Asset Tag: " + oAsset.Get(_assetid, "asset").ToUpper() + "<br/>Model: " + oModelsProperties.Get(_modelid, "name").ToUpper() + "<br/>Step #: " + _stepid.ToString() + "<br/>Step: " + strStep + "<br/>Error: " + _error + "<br/>DataCenter: " + _vmware.DataCenter() + "<br/>Virtual Center: " + _vmware.VirtualCenter() + "</p><p>When this issue has been resolved, <a href=\"" + oVariable.URL() + "/admin/errors_" + strType + ".aspx?id=" + intID.ToString() + "\" target=\"_blank\">click here</a> to clear this error and continue with the build.</p>", true, false);
}
else
{
oFunction.SendEmail("Auto-Provisioning FATAL ERROR: " + strName, strEMailIdsBCC, "", "", "Auto-Provisioning FATAL ERROR: " + strName, "<p><b>This message is to inform you that the " + strType + " " + strName + " has encountered a FATAL error and has been stopped!</b><p><p>Serial Number: " + oAsset.Get(_assetid, "serial").ToUpper() + "<br/>Asset Tag: " + oAsset.Get(_assetid, "asset").ToUpper() + "<br/>Model: " + oModelsProperties.Get(_modelid, "name").ToUpper() + "<br/>Step #: " + _stepid.ToString() + "<br/>Step: " + strStep + "<br/>Error: " + _error + "<br/>ILO: <a href=\"https://" + oAsset.GetServerOrBlade(_assetid, "ilo") + "\" target=\"_blank\">" + oAsset.GetServerOrBlade(_assetid, "ilo") + "</a></p><p>When this issue has been resolved, <a href=\"" + oVariable.URL() + "/admin/errors_" + strType + ".aspx?id=" + intID.ToString() + "\" target=\"_blank\">click here</a> to clear this error and continue with the build.</p>", true, false);
}
}
catch (Exception ex)
{
oFunction.SendEmail("Auto-Provisioning FATAL ERROR: " + strName, strEMailIdsBCC, "", "", "Auto-Provisioning FATAL ERROR: " + strName, "<p><b>This message is to inform you that the " + strType + " " + strName + " has encountered a FATAL error and has been stopped!</b><p><p>Serial Number: " + oAsset.Get(_assetid, "serial").ToUpper() + "<br/>Asset Tag: " + oAsset.Get(_assetid, "asset").ToUpper() + "<br/>Model: " + oModelsProperties.Get(_modelid, "name").ToUpper() + "<br/>Step #: " + _stepid.ToString() + "<br/>Step: " + strStep + "<br/>Error: " + _error + "<br/>Notification Error: (Error Message: " + ex.Message + ") (Source: " + ex.Source + ") (Stack Trace: " + ex.StackTrace + ")</p><p>When this issue has been resolved, <a href=\"" + oVariable.URL() + "/admin/errors_" + strType + ".aspx?id=" + intID.ToString() + "\" target=\"_blank\">click here</a> to clear this error and continue with the build.</p>", true, false);
}
}
}
UpdateError(_error);
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oOnDemand = new OnDemand(intProfile, dsn);
oForecast = new Forecast(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oWorkstation = new Workstations(intProfile, dsn);
oStorage = new Storage(intProfile, dsn);
oModel = new Models(intProfile, dsn);
oModelsProperties = new ModelsProperties(intProfile, dsn);
oOperatingSystem = new OperatingSystems(intProfile, dsn);
if (Request.QueryString["aid"] != null && Request.QueryString["aid"] != "")
{
intAnswer = Int32.Parse(Request.QueryString["aid"]);
}
if (Request.QueryString["num"] != null && Request.QueryString["num"] != "")
{
intNumber = Int32.Parse(Request.QueryString["num"]);
}
int intWorkstation = 0;
if (intAnswer > 0)
{
DataSet ds = oForecast.GetAnswer(intAnswer);
if (ds.Tables[0].Rows.Count > 0)
{
int intModel = oForecast.GetModel(intAnswer);
intModel = Int32.Parse(oModelsProperties.Get(intModel, "modelid"));
int _classid = Int32.Parse(ds.Tables[0].Rows[0]["classid"].ToString());
intQuantity = Int32.Parse(ds.Tables[0].Rows[0]["quantity"].ToString());
int _environmentid = Int32.Parse(ds.Tables[0].Rows[0]["environmentid"].ToString());
intOS = Int32.Parse(oForecast.GetWorkstation(intAnswer, "osid"));
intRequest = oForecast.GetRequestID(intAnswer, true);
if (!IsPostBack)
{
LoadLists(_classid, _environmentid);
chkApply.Visible = (intQuantity > 1 && intNumber == 1);
ds = oWorkstation.GetVirtual(intAnswer, intNumber);
if (ds.Tables[0].Rows.Count > 0)
{
intWorkstation = Int32.Parse(ds.Tables[0].Rows[0]["id"].ToString());
lblId.Text = intWorkstation.ToString();
intOS = Int32.Parse(ds.Tables[0].Rows[0]["osid"].ToString());
}
if (intOS > 0)
{
ddlOS.SelectedValue = intOS.ToString();
ddlServicePack.Enabled = true;
ddlServicePack.DataValueField = "id";
ddlServicePack.DataTextField = "name";
ddlServicePack.DataSource = oOperatingSystem.GetServicePack(intOS);
ddlServicePack.DataBind();
ddlServicePack.Items.Insert(0, new ListItem("-- SELECT --", "0"));
chkComponents.DataValueField = "id";
chkComponents.DataTextField = "name";
chkComponents.DataSource = oWorkstation.GetComponentPermissionsOS(intOS);
chkComponents.DataBind();
DataSet dsComponents = oWorkstation.GetComponentsSelected(intWorkstation);
foreach (DataRow drComponent in dsComponents.Tables[0].Rows)
{
foreach (ListItem oItem in chkComponents.Items)
{
if (drComponent["componentid"].ToString() == oItem.Value)
{
oItem.Selected = true;
break;
}
}
}
}
if (ds.Tables[0].Rows.Count > 0)
{
ddlServicePack.SelectedValue = ds.Tables[0].Rows[0]["spid"].ToString();
hdnServicePack.Value = ds.Tables[0].Rows[0]["spid"].ToString();
ddlDomain.SelectedValue = ds.Tables[0].Rows[0]["domainid"].ToString();
}
}
btnClose.Attributes.Add("onclick", "return window.close();");
btnSaveConfig.Attributes.Add("onclick", "return ValidateDropDown('" + ddlServicePack.ClientID + "','Please select a service pack')" +
" && ValidateDropDown('" + ddlDomain.ClientID + "','Please select a domain')" +
";");
ddlOS.Attributes.Add("onchange", "PopulateServicePacks('" + ddlOS.ClientID + "','" + ddlServicePack.ClientID + "');");
ddlServicePack.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlServicePack.ClientID + "','" + hdnServicePack.ClientID + "');");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oPage = new Pages(intProfile, dsn);
oRequestItem = new RequestItems(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oApplication = new Applications(intProfile, dsn);
oLocation = new Locations(intProfile, dsn);
oClass = new Classes(intProfile, dsn);
oForecast = new Forecast(intProfile, dsn);
oType = new Types(intProfile, dsn);
oModel = new Models(intProfile, dsn);
oModelsProperties = new ModelsProperties(intProfile, dsn);
oOperatingSystems = new OperatingSystems(intProfile, dsn);
oVirtualHDD = new VirtualHDD(intProfile, dsn);
oVirtualRam = new VirtualRam(intProfile, dsn);
oVirtualCPU = new VirtualCPU(intProfile, dsn);
oVariable = new Variables(intEnvironment);
oFunction = new Functions(0, dsn, intEnvironment);
oUser = new Users(intProfile, dsn);
oDomain = new Domains(intProfile, dsn);
oWorkstation = new Workstations(intProfile, dsn);
oCostCenter = new CostCenter(intProfile, dsn);
if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "")
{
intApplication = Int32.Parse(Request.QueryString["applicationid"]);
}
if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "")
{
intPage = Int32.Parse(Request.QueryString["pageid"]);
}
if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "")
{
intApplication = Int32.Parse(Request.Cookies["application"].Value);
}
if (Request.QueryString["rid"] != "" && Request.QueryString["rid"] != null)
{
if (!IsPostBack)
{
LoadLists();
}
LoadValues();
int intItem = Int32.Parse(lblItem.Text);
int intApp = oRequestItem.GetItemApplication(intItem);
string strDeliverable = oApplication.Get(intApp, "deliverables_doc");
if (strDeliverable != "")
{
panDeliverable.Visible = true;
btnDeliverable.Attributes.Add("onclick", "return OpenWindow('NEW_WINDOW','" + strDeliverable + "');");
}
if (Request.QueryString["id"] != "" && Request.QueryString["id"] != null)
{
Int32.TryParse(Request.QueryString["id"], out intWorkstation);
}
if (intWorkstation > 0)
{
panAccounts.Visible = true;
}
else
{
panAccountsNo.Visible = true;
}
if (Request.QueryString["userid"] != null && Request.QueryString["userid"] != "")
{
int intUser = Int32.Parse(Request.QueryString["userid"]);
trAccountUpdate.Visible = true;
lblXID.Text = oUser.GetFullName(intUser) + " (" + oUser.GetName(intUser) + ")";
btnAddAccount.Text = "Update";
btnCancelAccount.Visible = true;
}
else
{
trNew.Visible = true;
}
if (Request.QueryString["accts"] != null && Request.QueryString["accts"] != "")
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "accts", "<script type=\"text/javascript\">alert('Enter at least one account for this workstation');<" + "/" + "script>");
}
if (Request.QueryString["qty"] != null && Request.QueryString["qty"] != "")
{
if (Request.QueryString["qty"] == intMaxWorkstationsPerDay.ToString())
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "qty", "<script type=\"text/javascript\">alert('NOTE: You can request up to " + intMaxWorkstationsPerDay.ToString() + " virtual workstations per day.\\n\\nCurrently, you have requested " + Request.QueryString["qty"] + " virtual workstations and cannot be allocated additional hardware until tomorrow.\\n\\nIf your initiative requires more than " + intMaxWorkstationsPerDay.ToString() + " virtual workstations per day, you must use design builder.\\nPlease contact your technical lead or ClearView administrator for additional information.');<" + "/" + "script>");
}
else if (Request.QueryString["qty"] == "0")
{
int intDiff = intMaxWorkstationsPerDay - Int32.Parse(Request.QueryString["qty"]);
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "qty", "<script type=\"text/javascript\">alert('NOTE: You can request up to " + intMaxWorkstationsPerDay.ToString() + " virtual workstations per day.\\n\\nCurrently, you have requested " + Request.QueryString["qty"] + " virtual workstations. Please enter a quantity of " + intDiff.ToString() + " or less to continue.\\n\\nIf your initiative requires more than " + intMaxWorkstationsPerDay.ToString() + " virtual workstations per day, you must use design builder.\\nPlease contact your technical lead or ClearView administrator for additional information.');<" + "/" + "script>");
}
else
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "qty", "<script type=\"text/javascript\">alert('NOTE: You can request up to " + intMaxWorkstationsPerDay.ToString() + " virtual workstations per day.\\n\\nPlease enter a quantity of " + intMaxWorkstationsPerDay.ToString() + " or less to continue.\\n\\nIf your initiative requires more than " + intMaxWorkstationsPerDay.ToString() + " virtual workstations per day, you must use design builder.\\nPlease contact your technical lead or ClearView administrator for additional information.');<" + "/" + "script>");
}
}
else if (Request.QueryString["aid"] != null && Request.QueryString["aid"] != "")
{
intAnswer = Int32.Parse(Request.QueryString["aid"]);
if (!IsPostBack)
{
DataSet dsAnswer = oForecast.GetAnswer(intAnswer);
if (dsAnswer.Tables[0].Rows.Count > 0)
{
txtName.Text = dsAnswer.Tables[0].Rows[0]["name"].ToString();
ddlLocation.SelectedValue = dsAnswer.Tables[0].Rows[0]["addressid"].ToString();
ddlClass.SelectedValue = dsAnswer.Tables[0].Rows[0]["classid"].ToString();
txtQuantity.Text = dsAnswer.Tables[0].Rows[0]["quantity"].ToString();
dsAnswer = oForecast.GetWorkstation(intAnswer);
if (dsAnswer.Tables[0].Rows.Count > 0)
{
ddlRam.SelectedValue = dsAnswer.Tables[0].Rows[0]["ramid"].ToString();
ddlOS.SelectedValue = dsAnswer.Tables[0].Rows[0]["osid"].ToString();
chkDR.Checked = (dsAnswer.Tables[0].Rows[0]["recovery"].ToString() == "1");
radEmployee.SelectedValue = dsAnswer.Tables[0].Rows[0]["internal"].ToString();
ddlHardDrive.SelectedValue = dsAnswer.Tables[0].Rows[0]["hddid"].ToString();
ddlCPU.SelectedValue = dsAnswer.Tables[0].Rows[0]["cpuid"].ToString();
}
}
else
{
intAnswer = 0;
}
}
}
if (intAnswer == 0)
{
DataSet dsService = oForecast.GetAnswerService(Int32.Parse(Request.QueryString["rid"]));
if (dsService.Tables[0].Rows.Count > 0)
{
Redirect("&aid=" + dsService.Tables[0].Rows[0]["id"].ToString() + "&menu_tab=2");
}
}
if (intWorkstation > 0)
{
DataSet dsWorkstation = oWorkstation.GetVirtual(intWorkstation);
if (dsWorkstation.Tables[0].Rows.Count > 0)
{
// Load Workstation
txtName.Text = dsWorkstation.Tables[0].Rows[0]["nickname"].ToString();
ddlLocation.SelectedValue = dsWorkstation.Tables[0].Rows[0]["addressid"].ToString();
int intClass = Int32.Parse(dsWorkstation.Tables[0].Rows[0]["classid"].ToString());
ddlClass.SelectedValue = intClass.ToString();
txtQuantity.Text = dsWorkstation.Tables[0].Rows[0]["quantity"].ToString();
int intOS = Int32.Parse(dsWorkstation.Tables[0].Rows[0]["osid"].ToString());
LoadOS(intOS);
ddlOS.SelectedValue = intOS.ToString();
int intDomain = Int32.Parse(dsWorkstation.Tables[0].Rows[0]["domainid"].ToString());
lblDomain.Text = oDomain.Get(intDomain, "name");
radEmployee.SelectedValue = dsWorkstation.Tables[0].Rows[0]["internal"].ToString();
chkDR.Checked = (dsWorkstation.Tables[0].Rows[0]["recovery"].ToString() == "1");
ddlRam.SelectedValue = dsWorkstation.Tables[0].Rows[0]["ramid"].ToString();
ddlHardDrive.SelectedValue = dsWorkstation.Tables[0].Rows[0]["hddid"].ToString();
ddlCPU.SelectedValue = dsWorkstation.Tables[0].Rows[0]["cpuid"].ToString();
int intManager = Int32.Parse(dsWorkstation.Tables[0].Rows[0]["appcontact"].ToString());
txtManager.Text = oUser.GetFullName(intManager);
hdnManager.Value = intManager.ToString();
int intCost = Int32.Parse(dsWorkstation.Tables[0].Rows[0]["costcenterid"].ToString());
txtCostCenter.Text = oCostCenter.GetName(intCost);
hdnCostCenter.Value = intCost.ToString();
// Load Accounts
txtUser.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'300','195','" + divAJAX.ClientID + "','" + lstAJAX.ClientID + "','" + hdnUser.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstAJAX.Attributes.Add("ondblclick", "AJAXClickRow();");
chkAdmin.Attributes.Add("onclick", "CheckAdmin(this);");
rptAccounts.DataSource = oWorkstation.GetAccountsVMware(intWorkstation);
rptAccounts.DataBind();
foreach (RepeaterItem ri in rptAccounts.Items)
{
LinkButton _delete = (LinkButton)ri.FindControl("btnDeleteAccount");
_delete.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this account?') && LoadWait();");
}
if (rptAccounts.Items.Count == 0)
{
lblNone.Visible = true;
btnNext.Attributes.Add("onclick", "alert('Enter at least one account for this workstation');return false;");
}
else
{
btnNext.Attributes.Add("onclick", "return ProcessButton(this) && LoadWait();");
}
if (oClass.IsProd(intClass))
{
panProduction.Visible = true;
}
else
{
panAdmin.Visible = true;
}
btnAddAccount.Attributes.Add("onclick", "return ValidateHidden('" + hdnUser.ClientID + "','" + txtUser.ClientID + "','Please enter a username, first name or last name') && ProcessButton(this) && LoadWait();");
trUpdate.Visible = true;
btnUpdate.Attributes.Add("onclick", "return ValidateDropDown('" + ddlClass.ClientID + "','Please select a class')" +
" && ValidateNumber0('" + txtQuantity.ClientID + "','Please enter a valid quantity')" +
" && ValidateDropDown('" + ddlOS.ClientID + "','Please select an Operating System')" +
" && ValidateDropDown('" + ddlRam.ClientID + "','Please select a RAM')" +
" && ValidateDropDown('" + ddlCPU.ClientID + "','Please select a CPU')" +
" && ValidateDropDown('" + ddlHardDrive.ClientID + "','Please select a hard drive')" +
" && ValidateHidden0('" + hdnManager.ClientID + "','" + txtManager.ClientID + "','Please enter the LAN ID of your user access administrator')" +
" && ValidateHidden0('" + hdnCostCenter.ClientID + "','" + txtCostCenter.ClientID + "','Please enter the cost center to be billed for this workstation')" +
" && ProcessButton(this) && LoadWait()" +
";");
}
else
{
intWorkstation = 0;
}
}
if (intWorkstation == 0)
{
btnNext.Attributes.Add("onclick", "return ValidateDropDown('" + ddlClass.ClientID + "','Please select a class')" +
" && ValidateNumber0('" + txtQuantity.ClientID + "','Please enter a valid quantity')" +
" && ValidateDropDown('" + ddlOS.ClientID + "','Please select an Operating System')" +
" && ValidateDropDown('" + ddlRam.ClientID + "','Please select a RAM')" +
" && ValidateDropDown('" + ddlCPU.ClientID + "','Please select a CPU')" +
" && ValidateDropDown('" + ddlHardDrive.ClientID + "','Please select a hard drive')" +
" && ValidateHidden0('" + hdnManager.ClientID + "','" + txtManager.ClientID + "','Please enter the LAN ID of your user access administrator')" +
" && ValidateHidden0('" + hdnCostCenter.ClientID + "','" + txtCostCenter.ClientID + "','Please enter the cost center to be billed for this workstation')" +
" && ProcessButton(this) && LoadWait()" +
";");
}
}
int intMenuTab = 0;
if (Request.QueryString["menu_tab"] != null && Request.QueryString["menu_tab"] != "")
{
intMenuTab = Int32.Parse(Request.QueryString["menu_tab"]);
}
Tab oTab = new Tab("", intMenuTab, "divMenu1", true, false);
oTab.AddTab("Workstation Details", "");
oTab.AddTab("Account Configuration", "");
strMenuTab1 = oTab.GetTabs();
btnCancel1.Attributes.Add("onclick", "return confirm('Are you sure you want to cancel this service request?');");
ddlOS.Attributes.Add("onchange", "LoadWait();");
ddlRam.Attributes.Add("onchange", "LoadWait();");
ddlCPU.Attributes.Add("onchange", "LoadWait();");
ddlHardDrive.Attributes.Add("onchange", "LoadWait();");
txtManager.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'300','195','" + divManager.ClientID + "','" + lstManager.ClientID + "','" + hdnManager.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstManager.Attributes.Add("ondblclick", "AJAXClickRow();");
btnManager.Attributes.Add("onclick", "return OpenWindow('NEW_USER','');");
btnManager2.Attributes.Add("onclick", "return OpenWindow('NEW_USER','');");
txtCostCenter.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'200','195','" + divCostCenter.ClientID + "','" + lstCostCenter.ClientID + "','" + hdnCostCenter.ClientID + "','" + oVariable.URL() + "/frame/ajax/ajax_cost_centers.aspx',5);");
lstCostCenter.Attributes.Add("ondblclick", "AJAXClickRow();");
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
StringBuilder sb = new StringBuilder(strAccounts);
Page.Title = strTitle;
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
if (Request.QueryString["save"] != null && Request.QueryString["save"] != "")
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "save", "<script type=\"text/javascript\">alert('Approval has been submitted');<" + "/" + "script>");
}
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
intID = Int32.Parse(Request.QueryString["id"]);
Workstations oWorkstation = new Workstations(intProfile, dsn);
Forecast oForecast = new Forecast(intProfile, dsn);
Users oUser = new Users(intProfile, dsn);
Asset oAsset = new Asset(intProfile, dsnAsset);
int intAnswer = Int32.Parse(oWorkstation.GetVirtual(intID, "answerid"));
if (Int32.Parse(oForecast.GetAnswer(intAnswer, "appcontact")) == intProfile)
{
panPermit.Visible = true;
int intAsset = Int32.Parse(oWorkstation.GetVirtual(intID, "assetid"));
lblName.Text = oAsset.Get(intAsset, "name");
lblManager.Text = oUser.GetFullName(intProfile);
DataSet ds = oWorkstation.GetAccountsVirtual(intAsset);
foreach (DataRow dr in ds.Tables[0].Rows)
{
sb.Append("<tr>");
sb.Append("<td>");
sb.Append(oUser.GetFullName(Int32.Parse(dr["userid"].ToString())));
sb.Append("</td>");
string strRights = "";
if (dr["remote"].ToString() == "1")
{
strRights = "Remote Access";
}
if (dr["admin"].ToString() == "1")
{
if (strRights != "")
{
strRights += ", ";
}
strRights += "Administrator";
}
sb.Append("<td>");
sb.Append(strRights);
sb.Append("</td>");
sb.Append("<td align=\"center\"><input type=\"radio\" name=\"approve");
sb.Append(dr["id"].ToString());
sb.Append("\" onclick=\"ApproveCheckBox(this, '");
sb.Append(dr["id"].ToString());
sb.Append("','");
sb.Append(hdnApprove.ClientID);
sb.Append("');\"/></td>");
sb.Append("<td align=\"center\"><input type=\"radio\" name=\"approve");
sb.Append(dr["id"].ToString());
sb.Append("\" onclick=\"ApproveCheckBox(this, '");
sb.Append(dr["id"].ToString());
sb.Append("','");
sb.Append(hdnDeny.ClientID);
sb.Append("');\"/></td>");
sb.Append("</tr>");
}
if (sb.ToString() == "")
{
sb.Append("<tr><td colspan=\"4\"><img src=\"/images/alert.gif\" border=\"0\" align=\"absmiddle\"/> There are no accounts</td></tr>");
btnSave.Enabled = false;
}
}
else
{
panDenied.Visible = true;
}
}
strAccounts = sb.ToString();
btnSave.Attributes.Add("onclick", "return confirm('WARNING: The accounts you have approved will automatically be added to the appropriate groups.\\n\\nAre you sure you want to continue?');");
btnClose.Attributes.Add("onclick", "return CloseWindow();");
Control oControl = (Control)LoadControl("/controls/sys/sys_rotator_header.ascx");
PH4.Controls.Add(oControl);
}
protected void btnSave_Click(Object Sender, EventArgs e)
{
string strGroupRemote = "GSGu_WKS" + lblName.Text + "RemoteA";
string strGroupAdmin = "GSGu_WKS" + lblName.Text + "Adm";
bool bool2000 = (lblName.Text.ToUpper().StartsWith("T2K") == true || lblName.Text.ToUpper().StartsWith("W2K") == true);
Workstations oWorkstation = new Workstations(intProfile, dsn);
Users oUser = new Users(intProfile, dsn);
Domains oDomain = new Domains(intProfile, dsn);
int intDomain = Int32.Parse(oWorkstation.GetVirtual(intID, "domainid"));
intDomain = Int32.Parse(oDomain.Get(intDomain, "environment"));
AD oAD = new AD(intProfile, dsn, intDomain);
string strHidden = Request.Form[hdnApprove.UniqueID];
while (strHidden != "")
{
string strField = strHidden.Substring(0, strHidden.IndexOf("&"));
strHidden = strHidden.Substring(strHidden.IndexOf("&") + 1);
string strFlag = strField.Substring(strField.IndexOf("_") + 1);
strField = strField.Substring(0, strField.IndexOf("_"));
if (strFlag == "1")
{
int intAccount = Int32.Parse(strField);
DataSet ds = oWorkstation.GetAccount(intAccount);
if (ds.Tables[0].Rows.Count > 0)
{
int intUser = Int32.Parse(ds.Tables[0].Rows[0]["userid"].ToString());
string strID = oUser.GetName(intUser);
if (intDomain != (int)CurrentEnvironment.CORPDMN && intDomain != (int)CurrentEnvironment.PNCNT_PROD)
{
strID = "E" + strID.Substring(1);
if (oAD.Search(strID, false) == null)
{
strID = "T" + strID.Substring(1);
if (oAD.Search(strID, false) == null)
{
oAD.CreateUser(strID, strID, strID, "Abcd1234", "", "Created by ClearView - " + DateTime.Now.ToShortDateString(), "");
}
}
if (ds.Tables[0].Rows[0]["admin"].ToString() == "1")
{
oAD.JoinGroup(strID, strGroupAdmin, 0);
}
}
if (ds.Tables[0].Rows[0]["remote"].ToString() == "1" && bool2000 == false)
{
oAD.JoinGroup(strID, strGroupRemote, 0);
}
}
oWorkstation.UpdateAccount(intAccount);
}
}
strHidden = Request.Form[hdnDeny.UniqueID];
while (strHidden != "")
{
string strField = strHidden.Substring(0, strHidden.IndexOf("&"));
strHidden = strHidden.Substring(strHidden.IndexOf("&") + 1);
string strFlag = strField.Substring(strField.IndexOf("_") + 1);
strField = strField.Substring(0, strField.IndexOf("_"));
if (strFlag == "1")
{
int intAccount = Int32.Parse(strField);
oWorkstation.UpdateAccount(intAccount);
}
}
}
