private void LoadValues() { int intRequest = Int32.Parse(Request.QueryString["rid"]); DataSet dsItems; int intForm = 0; if (Request.QueryString["formid"] != null && Request.QueryString["formid"] != "") { intForm = Int32.Parse(Request.QueryString["formid"]); dsItems = oRequestItem.GetForm(intRequest, intForm); } else { dsItems = oRequestItem.GetForms(intRequest); } if (dsItems.Tables[0].Rows.Count > 0) { lblReturned.Text = intForm.ToString(); foreach (DataRow drItem in dsItems.Tables[0].Rows) { if (drItem["done"].ToString() == "-1" || intForm > 0) { lblItem.Text = drItem["itemid"].ToString(); if (intForm > 0 && Request.QueryString["num"] != null && Request.QueryString["num"] != "") { lblNumber.Text = Request.QueryString["num"]; } else { lblNumber.Text = drItem["number"].ToString(); } lblService.Text = drItem["serviceid"].ToString(); break; } } } else if (intForm > 0 && Request.QueryString["num"] != null && Request.QueryString["num"] != "") { lblNumber.Text = Request.QueryString["num"]; // Coming from workflow - get back to original request. List <WorkflowServices> lstBefore = oService.PreviousService(intRequest, intForm, Int32.Parse(lblNumber.Text)); int serviceid = 0; lblReturned.Text = intForm.ToString(); foreach (WorkflowServices lstService in lstBefore) { if (String.IsNullOrEmpty(lstService.Created) == false) { serviceid = lstService.ServiceID; } } lblService.Text = serviceid.ToString(); lblItem.Text = oService.GetItemId(serviceid).ToString(); } }
private void LoadValues() { int intRequest = Int32.Parse(Request.QueryString["rid"]); DataSet dsItems; int intForm = 0; if (Request.QueryString["formid"] != null && Request.QueryString["formid"] != "") { intForm = Int32.Parse(Request.QueryString["formid"]); dsItems = oRequestItem.GetForm(intRequest, intForm); } else { dsItems = oRequestItem.GetForms(intRequest); } if (dsItems.Tables[0].Rows.Count > 0) { foreach (DataRow drItem in dsItems.Tables[0].Rows) { if (drItem["done"].ToString() == "-1" || intForm > 0) { lblItem.Text = drItem["itemid"].ToString(); lblNumber.Text = drItem["number"].ToString(); lblService.Text = drItem["serviceid"].ToString(); break; } } } }
protected void btnCancel_Click(Object Sender, EventArgs e) { Button btnCancel = (Button)Sender; int intService = Int32.Parse(btnCancel.CommandArgument); // Remove Resource Request int intItem = oService.GetItemId(intService); DataSet dsForm = oRequestItem.GetForms(intRequest, intService); int intCancelNum = Int32.Parse(btnCancel.CommandName); strEMailIdsBCC = oFunction.GetGetEmailAlertsEmailIds("EMAILGRP_REQUEST_ASSIGNMENT,EMAILGRP_REQUEST_STATUS"); foreach (DataRow drForm in dsForm.Tables[0].Rows) { int intCancelNum2 = Int32.Parse(drForm["number"].ToString()); if (intCancelNum > 0) { intCancelNum2 = intCancelNum; } DataSet dsResource = oResourceRequest.Get(intRequest, intItem, intCancelNum2); if (dsResource.Tables[0].Rows.Count > 0) { int intResourceWorkflow = Int32.Parse(dsResource.Tables[0].Rows[0]["id"].ToString()); int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow); oResourceRequest.UpdateStatusOverall(intResourceParent, -2); DataSet dsManager = oService.GetUser(intService, 1); DataSet dsResources = oResourceRequest.GetWorkflowsParent(intResourceParent); foreach (DataRow drResources in dsResources.Tables[0].Rows) { int intUser = Int32.Parse(drResources["userid"].ToString()); if (intUser == 0) { foreach (DataRow drManager in dsManager.Tables[0].Rows) { int intManager = Int32.Parse(drManager["userid"].ToString()); oFunction.SendEmail("ClearView Service Request CANCELLED", oUser.GetName(intManager), "", strEMailIdsBCC, "ClearView Service Request CANCELLED", "<p><b>The following service request has been cancelled by " + oUser.GetFullName(intProfile) + "</b><p><p>" + oResourceRequest.GetWorkflowSummary(Int32.Parse(drResources["id"].ToString()), intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p>", true, false); } } else { foreach (DataRow drManager in dsManager.Tables[0].Rows) { int intManager = Int32.Parse(drManager["userid"].ToString()); oFunction.SendEmail("ClearView Service Request CANCELLED", oUser.GetName(intUser), oUser.GetName(intManager), strEMailIdsBCC, "ClearView Service Request CANCELLED", "<p><b>The following service request has been cancelled by " + oUser.GetFullName(intProfile) + "</b><p><p>" + oResourceRequest.GetWorkflowSummary(Int32.Parse(drResources["id"].ToString()), intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p>", true, false); } } } } oService.CancelSelected(intRequest, intService, intCancelNum2); if (intCancelNum > 0) { break; } } Response.Redirect(Request.Path + "?t=" + Request.QueryString["t"] + "&q=" + Request.QueryString["q"] + "&id=" + oFunction.encryptQueryString(intRequest.ToString()) + "&cancel=true"); }
private void LoadValues() { int intRequest = Int32.Parse(Request.QueryString["rid"]); DataSet dsItems = oRequestItem.GetForms(intRequest); if (dsItems.Tables[0].Rows.Count > 0) { foreach (DataRow drItem in dsItems.Tables[0].Rows) { if (drItem["done"].ToString() == "-1") { lblItem.Text = drItem["itemid"].ToString(); lblNumber.Text = drItem["number"].ToString(); break; } } } }
protected void Page_Load(object sender, EventArgs e) { intProfile = Int32.Parse(Request.Cookies["profileid"].Value); RequestItems oRequestItem = new RequestItems(intProfile, dsn); RequestFields oRequestField = new RequestFields(intProfile, dsn); ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn); Services oService = new Services(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 ************** Asset oAsset = new Asset(intProfile, dsnAsset); Requests oRequest = new Requests(intProfile, dsn); Users oUser = new Users(intProfile, dsn); oAsset.UpdateDecommission(intRequest, intItem, intNumber, 1); strResult += "<p>The server(s) were successfully queued for decommission</p>"; strError = ""; oRequest.AddResult(intRequest, intItem, intNumber, "Server Decommission", strError, strResult, intEnvironment, (oService.Get(intService, "notify_client") == "1"), oUser.GetName(intProfile)); if (strResult == "") { boolSuccess = false; } // ******** END PROCESSING ************** if (oService.Get(intService, "automate") == "1" && boolSuccess == true) { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_check.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + strResult + "</td></tr></table>"; } else { if (boolSuccess == false) { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_error.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + strError + "</td></tr></table>"; } else { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_check.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + oService.GetName(intService) + " Submitted</td></tr></table>"; } } oRequestItem.UpdateFormDone(intRequest, intItem, intNumber, 1); } } } }
private void LoadValues() { //int intRequest = Int32.Parse(Request.QueryString["rid"]); //DataSet dsItems = oRequestItem.GetForms(intRequest); //if (dsItems.Tables[0].Rows.Count > 0) //{ // foreach (DataRow drItem in dsItems.Tables[0].Rows) // { // if (drItem["done"].ToString() == "-1") // { // lblItem.Text = drItem["itemid"].ToString(); // lblService.Text = drItem["serviceid"].ToString(); // lblNumber.Text = drItem["number"].ToString(); // break; // } // } //} int intRequest = Int32.Parse(Request.QueryString["rid"]); DataSet dsItems; int intForm = 0; if (Request.QueryString["formid"] != null && Request.QueryString["formid"] != "") { intForm = Int32.Parse(Request.QueryString["formid"]); dsItems = oRequestItem.GetForm(intRequest, intForm); } else { dsItems = oRequestItem.GetForms(intRequest); } if (dsItems.Tables[0].Rows.Count > 0) { foreach (DataRow drItem in dsItems.Tables[0].Rows) { if (drItem["done"].ToString() == "-1" || intForm > 0) { lblItem.Text = drItem["itemid"].ToString(); lblService.Text = drItem["serviceid"].ToString(); if (intForm > 0 && Request.QueryString["num"] != null && Request.QueryString["num"] != "") { lblNumber.Text = Request.QueryString["num"]; } else { lblNumber.Text = drItem["number"].ToString(); } break; } } } else { lblService.Text = intForm.ToString(); } // Load Data if (Request.QueryString["formid"] != null && Request.QueryString["formid"] != "") { int intItem = Int32.Parse(lblItem.Text); int intNumber = Int32.Parse(lblNumber.Text); DataSet dsEdit = oWorkstation.GetVirtualRebuild(intRequest, intForm, intNumber); foreach (DataRow drEdit in dsEdit.Tables[0].Rows) { if (drEdit["cancelled"].ToString() == "") { int intName = 0; if (Int32.TryParse(drEdit["nameid"].ToString(), out intName) == true) { lblId.Text = drEdit["workstationid"].ToString(); txtDate.Text = DateTime.Parse(drEdit["scheduled"].ToString()).ToShortDateString(); txtName.Text = lblName.Text = oWorkstation.GetName(intName); btnContinue.Enabled = false; panFound.Visible = true; btnNext.Text = "Update"; btnBack.Text = "Cancel"; btnNext.Attributes.Add("onclick", "return ValidateDate('" + txtDate.ClientID + "','Please enter a valid date')" + " && ValidateDateToday('" + txtDate.ClientID + "','The date must occur after today')" + " && ProcessButton(this) && LoadWait()" + ";"); btnCancel1.Visible = false; } break; } } } }
protected void btnApprove_Click(Object Sender, EventArgs e) { if (Request.QueryString["rrid"] != null) { // Approved; Send to team lead for assignment int intResource = Int32.Parse(Request.QueryString["rrid"]); int intRequest = Int32.Parse(oResourceRequest.Get(intResource, "requestid")); int intService = Int32.Parse(oResourceRequest.Get(intResource, "serviceid")); int intNumber = Int32.Parse(oResourceRequest.Get(intResource, "number")); string strCVT = "CVT" + intRequest.ToString() + "-" + intService.ToString() + "-" + intNumber.ToString(); int ApprovalID = 0; DataSet dsApproval = oResourceRequest.GetApprovals(intRequest, intService, intNumber); foreach (DataRow drApproval in dsApproval.Tables[0].Rows) { if (Int32.Parse(drApproval["userid"].ToString()) == intProfile) { if (String.IsNullOrEmpty(drApproval["approved"].ToString()) == false || String.IsNullOrEmpty(drApproval["denied"].ToString()) == false) { ApprovalID = Int32.Parse(drApproval["id"].ToString()); break; } } } if (ApprovalID == 0) { oLog.AddEvent(intRequest.ToString(), strCVT, "Not already approved for user " + oUser.GetName(intProfile), LoggingType.Debug); oResourceRequest.UpdateStatusOverall(intResource, 2); if (oResourceRequest.Get(intResource, "platform_approval") == "0") { // Platform Approve oResourceRequest.ApprovePlatform(intResource, 1); SendEmail(intRequest, true, "PLATFORM", txtReason.Text); oLog.AddEvent(intRequest.ToString(), strCVT, "User " + oUser.GetName(intProfile) + " approved PLATFORM", LoggingType.Debug); } else if (oService.GetSelected(intRequest, intService, intNumber, "approved") == "0") { // Service Manager Approve oService.UpdateSelectedApprove(intRequest, intService, intNumber, 1, intProfile, DateTime.Now, ""); SendEmail(intRequest, true, "SERVICE MANAGER", txtReason.Text); oLog.AddEvent(intRequest.ToString(), strCVT, "User " + oUser.GetName(intProfile) + " approved SERVICE MANAGER", LoggingType.Debug); } else { oResourceRequest.UpdateApproval(intRequest, intService, intNumber, intProfile, txtReason.Text, DateTime.Now.ToString(), ""); SendEmail(intRequest, true, "3RD PARTY APPROVER", txtReason.Text); oLog.AddEvent(intRequest.ToString(), strCVT, "User " + oUser.GetName(intProfile) + " approved 3RD PARTY APPROVER", LoggingType.Debug); } int intItem = Int32.Parse(oResourceRequest.Get(intResource, "itemid")); if (oServiceRequest.NotifyApproval(intResource, intResourceRequestApprove, intEnvironment, "", dsnServiceEditor) == false) { oServiceRequest.NotifyTeamLead(intItem, intResource, intAssignPage, intViewPage, intEnvironment, "", dsnServiceEditor, dsnAsset, dsnIP, 0); } } else { oLog.AddEvent(intRequest.ToString(), strCVT, "Already approved for user " + oUser.GetName(intProfile), LoggingType.Debug); } } if (Request.QueryString["srid"] != null) { // Approved; Permit submission int intServiceSelectedID = Int32.Parse(Request.QueryString["srid"]); DataSet dsServiceSelected = oService.GetSelectedById(intServiceSelectedID); DataRow drServiceSelected = dsServiceSelected.Tables[0].Rows[0]; int intRequest = Int32.Parse(drServiceSelected["requestid"].ToString()); int intService = Int32.Parse(drServiceSelected["serviceid"].ToString()); int intItem = oService.GetItemId(intService); int intNumber = Int32.Parse(drServiceSelected["number"].ToString()); string strCVT = "CVT" + intRequest.ToString() + "-" + intService.ToString() + "-" + intNumber.ToString(); oService.UpdateSelectedApprove(intRequest, intService, intNumber, 1, intProfile, DateTime.Now, ""); SendEmail(intRequest, true, "SERVICE MANAGER", txtReason.Text); oLog.AddEvent(intRequest.ToString(), strCVT, "User " + oUser.GetName(intProfile) + " approved SERVICE MANAGER", LoggingType.Debug); // Kick off any automated processing... Workstations oWorkstation = new Workstations(intProfile, dsn); oWorkstation.ExecuteVMware(intRequest); } if (Request.QueryString["rid"] != null) { // Manager Approve int intRequest = Int32.Parse(Request.QueryString["rid"]); oServiceRequest.UpdateApproval(intRequest, 1); oResourceRequest.UpdateStatusRequest(intRequest, 2); SendEmail(intRequest, true, "MANAGER", txtReason.Text); DataSet dsForm = oRequestItem.GetForms(intRequest); foreach (DataRow drForm in dsForm.Tables[0].Rows) { int intService = 0; Int32.TryParse(drForm["serviceid"].ToString(), out intService); int intNumber = 0; Int32.TryParse(drForm["number"].ToString(), out intNumber); if (intService > 0 && intNumber > 0) { if (oServiceRequest.NotifyApproval(intRequest, intService, intNumber, intResourceRequestApprove, intEnvironment, "", dsnServiceEditor) == false) { // Send to Team Lead for assignment ds = oResourceRequest.GetUnAssigned(intRequest, 0); foreach (DataRow dr in ds.Tables[0].Rows) { int intItem = Int32.Parse(dr["itemid"].ToString()); oServiceRequest.NotifyTeamLead(intItem, Int32.Parse(dr["id"].ToString()), intAssignPage, intViewPage, intEnvironment, "", dsnServiceEditor, dsnAsset, dsnIP, 0); } } } } } Response.Redirect(oPage.GetFullLink(intPage) + "?action=finish"); }
protected void Page_Load(object sender, EventArgs e) { intProfile = Int32.Parse(Request.Cookies["profileid"].Value); RequestItems oRequestItem = new RequestItems(intProfile, dsn); RequestFields oRequestField = new RequestFields(intProfile, dsn); ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn); Services oService = new Services(intProfile, dsn); oFunction = new Functions(intProfile, dsn, intEnvironment); oUser = new Users(intProfile, dsn); oRequest = new Requests(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 strResult = ""; string strError = oService.GetName(intService) + " Error"; // ********* BEGIN PROCESSING ************** Workstations oWorkstation = new Workstations(intProfile, dsn); DataSet dsRebuild = oWorkstation.GetVirtualRebuild(intRequest, intService, intNumber); bool found = false; foreach (DataRow drRebuild in dsRebuild.Tables[0].Rows) { if (drRebuild["cancelled"].ToString() == "") { found = true; int intWorkstation = Int32.Parse(drRebuild["workstationid"].ToString()); int intName = Int32.Parse(drRebuild["nameid"].ToString()); oWorkstation.UpdateVirtualRebuild(intRequest, intService, intNumber); string strName = oWorkstation.GetName(intName); string strPower = drRebuild["scheduled"].ToString(); strResult += "<p>The workstation " + strName + " was successfully queued for rebuild on " + strPower + "</p>"; strError = ""; break; } } if (found == false) { strError = "<p>There was a problem configuring the workstation for rebuild ~ Request not found.</p>"; } if (strResult == "") { boolSuccess = false; } // ******** END PROCESSING ************** if (oService.Get(intService, "automate") == "1" && boolSuccess == true) { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_check.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + strResult + "</td></tr></table>"; } else { if (boolSuccess == false) { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_error.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + strError + "</td></tr></table>"; } else { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_check.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + oService.GetName(intService) + " Submitted</td></tr></table>"; } } oRequestItem.UpdateFormDone(intRequest, intItem, intNumber, 1, 1); } } } }
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) { RequestItems oRequestItem = new RequestItems(intProfile, dsn); RequestFields oRequestField = new RequestFields(intProfile, dsn); ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn); Services oService = new Services(intProfile, dsn); ServiceDetails oServiceDetail = new ServiceDetails(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 ************** Requests oRequest = new Requests(intProfile, dsn); Functions oFunction = new Functions(intProfile, dsn, intEnvironment); Variables oVariable = new Variables(intEnvironment); Users oUser = new Users(intProfile, dsn); Pages oPage = new Pages(intProfile, dsn); if (oRequest.Get(intRequest, "description") == "") { Customized oCustomized = new Customized(intProfile, dsn); DataSet dsStatement = oCustomized.GetWorkstation(intRequest, intItem, intNumber); if (dsStatement.Tables[0].Rows.Count > 0) { oRequest.UpdateDescription(intRequest, dsStatement.Tables[0].Rows[0]["statement"].ToString()); } } int intDevices = 0; double dblQuantity = 0.00; DataSet ds = oService.GetSelected(intRequest, intService); if (ds.Tables[0].Rows.Count > 0) { dblQuantity = double.Parse(ds.Tables[0].Rows[0]["quantity"].ToString()); intDevices = Int32.Parse(ds.Tables[0].Rows[0]["quantity"].ToString()); } double dblHours = oServiceDetail.GetHours(intService, dblQuantity); int intResource = oServiceRequest.AddRequest(intRequest, intItem, intService, intDevices, dblHours, 2, intNumber, dsnServiceEditor); if (oService.Get(intService, "typeid") == "3") { } else if (oService.Get(intService, "typeid") == "2") { } else { if (oServiceRequest.NotifyApproval(intResource, intResourceRequestApprove, intEnvironment, "", dsnServiceEditor) == false) { oServiceRequest.NotifyTeamLead(intItem, intResource, intAssignPage, intViewPage, intEnvironment, "", dsnServiceEditor, dsnAsset, dsnIP, 0); } } // ******** 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) { RequestItems oRequestItem = new RequestItems(intProfile, dsn); RequestFields oRequestField = new RequestFields(intProfile, dsn); ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn); Services oService = new Services(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 = int.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; StringBuilder sbResult = new StringBuilder(oService.GetName(intService) + " Completed"); string strError = oService.GetName(intService) + " Error"; // ********* BEGIN PROCESSING ************** Restart oRestart = new Restart(0, dsn); Scripts oScript = new Scripts(0, dsn); DataSet ds = oRestart.GetRequests(intRequest); sbResult = new StringBuilder(); foreach (DataRow dr in ds.Tables[0].Rows) { string strName = dr["name"].ToString(); string strSeconds = "30"; oRestart.DeleteRequest(Int32.Parse(dr["id"].ToString())); StringBuilder sbScript = new StringBuilder(); sbScript.Append("Dim objShell\r\n"); sbScript.Append("Set objShell = CreateObject(\"WScript.Shell\")\r\n"); sbScript.Append("objShell.Run(\"cmd.exe /c shutdown -r -m \\\\"); sbScript.Append(strName); sbScript.Append(" -t "); sbScript.Append(strSeconds); sbScript.Append(" -f\")\r\n"); sbScript.Append("Set objShell = Nothing\r\n"); oScript.Add(sbScript.ToString(), Int32.Parse(dr["environment"].ToString())); sbResult.Append(strName); sbResult.Append(" was successfully sent a restart request"); } // ******** END PROCESSING ************** if (oService.Get(intService, "automate") == "1" && boolSuccess == true) { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/bigCheck.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + sbResult.ToString() + "</td></tr></table>"; } else { if (boolSuccess == false) { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/bigError.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + strError + "</td></tr></table>"; } else { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/bigCheck.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + oService.GetName(intService) + " Submitted</td></tr></table>"; } } oRequestItem.UpdateFormDone(intRequest, intItem, intNumber, 1); } } } }
protected void Page_Load(object sender, EventArgs e) { RequestItems oRequestItem = new RequestItems(intProfile, dsn); RequestFields oRequestField = new RequestFields(intProfile, dsn); ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn); Services oService = new Services(intProfile, dsn); Log oLog = new Log(intProfile, dsn); Users oUser = new Users(intProfile, dsn); Functions oFunction = new Functions(intProfile, dsn, intEnvironment); Pages oPage = new Pages(intProfile, dsn); Requests oRequest = new Requests(intProfile, dsn); Variables oVariable = new Variables(intEnvironment); 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")) { string strResult = oService.GetName(intService) + " Completed"; string strError = oService.GetName(intService) + " Error"; // ********* BEGIN PROCESSING ************** string strCVT = "CVT" + intRequest.ToString() + "-" + intService.ToString() + "-" + intNumber.ToString(); Forecast oForecast = new Forecast(intProfile, dsn); ModelsProperties oModelsProperties = new ModelsProperties(intProfile, dsn); Types oType = new Types(intProfile, dsn); DataSet dsService = oForecast.GetAnswerService(intRequest); if (dsService.Tables[0].Rows.Count > 0) { int intAnswer = Int32.Parse(dsService.Tables[0].Rows[0]["id"].ToString()); int intModel = Int32.Parse(dsService.Tables[0].Rows[0]["modelid"].ToString()); int intType = oModelsProperties.GetType(intModel); string strExecute = oType.Get(intType, "forecast_execution_path"); DataSet dsSelected = oService.GetSelected(intRequest, intService, intNumber); if (oServiceRequest.NotifyApproval(intRequest, intService, intNumber, intResourceRequestApprove, intEnvironment, "", dsnServiceEditor) == false) { oLog.AddEvent(intRequest.ToString(), strCVT, "Service request has been fully approved", LoggingType.Debug); Workstations oWorkstation = new Workstations(intProfile, dsn); oWorkstation.ExecuteVMware(intRequest); oLog.AddEvent(intRequest.ToString(), strCVT, "Service request ExecuteVMware has completed.", LoggingType.Debug); } else { oLog.AddEvent(intRequest.ToString(), strCVT, "Service request has been sent for approval", LoggingType.Debug); } //if (strExecute != "") // btnStart.Attributes.Add("onclick", "return OpenWindow('FORECAST_EXECUTE','" + strExecute + "?id=" + intAnswer.ToString() + "');"); //else // btnStart.Attributes.Add("onclick", "alert('Execution has not been configured for asset type " + oType.Get(intType, "name") + "');return false;"); strDone += "<table border=\"0\"><tr><td><img src=\"/images/bigCheck.gif\" border=\"0\" align=\"absmiddle\"/></td><td class=\"biggerbold\">" + oService.GetName(intService) + " Submitted</td></tr></table>"; } // ******** END PROCESSING ************** oRequestItem.UpdateFormDone(intRequest, intItem, intNumber, 1); } } } }
protected void Page_Load(object sender, EventArgs e) { intProfile = Int32.Parse(Request.Cookies["profileid"].Value); RequestItems oRequestItem = new RequestItems(intProfile, dsn); RequestFields oRequestField = new RequestFields(intProfile, dsn); ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn); Services oService = new Services(intProfile, dsn); ResourceRequest oResourceRequest = new ResourceRequest(intProfile, dsn); Log oLog = new Log(intProfile, dsn); 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 strWorkflowTitle = oService.Get(intService, "workflow_title"); string strResult = (strWorkflowTitle == "" ? oService.GetName(intService) : strWorkflowTitle) + " Completed"; string strError = (strWorkflowTitle == "" ? oService.GetName(intService) : strWorkflowTitle) + " Error"; // ********* BEGIN PROCESSING ************** double dblHours = 0.00; int intDevices = 1; Field oField = new Field(intProfile, dsn); string strTable = oField.GetTableName2(intService); if (strTable != "") { DataSet ds = oField.GetTableServiceRequest(strTable, intRequest.ToString(), intItem.ToString(), intNumber.ToString()); if (ds.Tables[0].Columns.Contains("hours") == true) { foreach (DataRow dr in ds.Tables[0].Rows) { dblHours += double.Parse(dr["hours"].ToString()); } } if (ds.Tables[0].Columns.Contains("devices") == true) { foreach (DataRow dr in ds.Tables[0].Rows) { intDevices += Int32.Parse(dr["devices"].ToString()); } } } if (oService.Get(intService, "quantity_is_device") == "1") { DataSet dsTemp = oService.GetSelected(intRequest, intService); if (dsTemp.Tables[0].Rows.Count > 0) { intDevices = Int32.Parse(dsTemp.Tables[0].Rows[0]["quantity"].ToString()); } } string strCVT = "CVT" + intRequest.ToString() + "-" + intService.ToString() + "-" + intNumber.ToString(); int intResource = oServiceRequest.AddRequest(intRequest, intItem, intService, intDevices, dblHours, 2, intNumber, dsnServiceEditor); oLog.AddEvent(intRequest.ToString(), strCVT, "Service request has been submitted by " + oUser.GetFullNameWithLanID(intProfile), LoggingType.Debug); if (oServiceRequest.NotifyApproval(intResource, intResourceRequestApprove, intEnvironment, "", dsnServiceEditor) == false) { oLog.AddEvent(intRequest.ToString(), strCVT, "Service request has been fully approved", LoggingType.Debug); oServiceRequest.NotifyTeamLead(intItem, intResource, intAssignPage, intViewPage, intEnvironment, "", dsnServiceEditor, dsnAsset, dsnIP, 0); oLog.AddEvent(intRequest.ToString(), strCVT, "Service request NotifyTeamLead has completed.", LoggingType.Debug); } else { oLog.AddEvent(intRequest.ToString(), strCVT, "Service request has been sent for approval", LoggingType.Debug); } // ******** 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\"/> " + (strWorkflowTitle == "" ? oService.GetName(intService) : strWorkflowTitle) + " Submitted</span></p>"; } } oRequestItem.UpdateFormDone(intRequest, intItem, intNumber, 1); } } } }
protected void Page_Load(object sender, EventArgs e) { RequestItems oRequestItem = new RequestItems(intProfile, dsn); RequestFields oRequestField = new RequestFields(intProfile, dsn); ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn); Services oService = new Services(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 ************** AccountRequest oAccountRequest = new AccountRequest(intProfile, dsn); Requests oRequest = new Requests(intProfile, dsn); Users oUser = new Users(intProfile, dsn); DataSet ds = oAccountRequest.GetMaintenance(intRequest, intItem, intNumber); Domains oDomain = new Domains(intProfile, dsn); if (ds.Tables[0].Rows.Count > 0) { string strUser = ds.Tables[0].Rows[0]["username"].ToString(); int intDomain = Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()); int intEnv = Int32.Parse(oDomain.Get(intDomain, "environment")); int intUser = oRequest.GetUser(intRequest); AD oAD = new AD(intProfile, dsn, intEnv); DirectoryEntry oEntry = oAD.UserSearch(strUser); if (oEntry == null) { strResult = ""; } else { if (oAD.IsLocked(oEntry) == true) { strResult = oAD.Unlock(oEntry); oRequest.AddResult(intRequest, intItem, intNumber, "Account Unlock", strResult, "Account " + strUser + " was successfully unlocked", intEnvironment, (oService.Get(intService, "notify_client") == "1"), oUser.GetName(intUser)); if (strResult == "") { strResult = "<p>Account " + strUser + " was unlocked</p>"; } } else { oRequest.AddResult(intRequest, intItem, intNumber, "Account Unlock", "", "Account " + strUser + " was not locked", intEnvironment, (oService.Get(intService, "notify_client") == "1"), oUser.GetName(intUser)); strResult = "<p>Account " + strUser + " was not locked</p>"; } } } if (strResult == "") { boolSuccess = false; } // ******** END PROCESSING ************** if (oService.Get(intService, "automate") == "1" && boolSuccess == true) { strDone += "<table border=\"0\"><tr><td><img src=\"/images/bigCheck.gif\" border=\"0\" align=\"absmiddle\"/></td><td class=\"biggerbold\">" + strResult + "</td></tr></table>"; } else { if (boolSuccess == false) { strDone += "<table border=\"0\"><tr><td><img src=\"/images/bigError.gif\" border=\"0\" align=\"absmiddle\"/></td><td class=\"biggerbold\">" + strError + "</td></tr></table>"; } else { strDone += "<table border=\"0\"><tr><td><img src=\"/images/bigCheck.gif\" border=\"0\" align=\"absmiddle\"/></td><td class=\"biggerbold\">" + oService.GetName(intService) + " Submitted</td></tr></table>"; } } oRequestItem.UpdateFormDone(intRequest, intItem, intNumber, 1); } } } }
protected void Page_Load(object sender, EventArgs e) { RequestItems oRequestItem = new RequestItems(intProfile, dsn); RequestFields oRequestField = new RequestFields(intProfile, dsn); ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn); Services oService = new Services(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 ************** DNS oDNS = new DNS(intProfile, dsn); strResult = ""; strError = ""; if (intEnvironment < 3) { intEnvironment = 3; } Variables oVariable = new Variables(intEnvironment); Requests oRequest = new Requests(intProfile, dsn); Users oUser = new Users(intProfile, dsn); DataSet ds = oDNS.GetDNS(intRequest, intItem, intNumber); Domains oDomain = new Domains(intProfile, dsn); if (ds.Tables[0].Rows.Count > 0) { string strAction = ds.Tables[0].Rows[0]["action"].ToString(); string strNameCurrent = ds.Tables[0].Rows[0]["name_current"].ToString(); string strIPCurrent = ds.Tables[0].Rows[0]["ip_current"].ToString(); string strAliasCurrent = ds.Tables[0].Rows[0]["alias_current"].ToString(); string strNameNew = ds.Tables[0].Rows[0]["name_new"].ToString(); string strIPNew = ds.Tables[0].Rows[0]["ip_new"].ToString(); string strAliasNew = ds.Tables[0].Rows[0]["alias_new"].ToString(); string strDomain = ds.Tables[0].Rows[0]["domain"].ToString(); string strObject = ds.Tables[0].Rows[0]["value"].ToString(); int intUser = oRequest.GetUser(intRequest); // Connect to DNS to process the request System.Net.NetworkCredential oCredentials = new System.Net.NetworkCredential(oVariable.ADUser(), oVariable.ADPassword(), oVariable.Domain()); ClearViewWebServices oWebService = new ClearViewWebServices(); oWebService.Timeout = Int32.Parse(ConfigurationManager.AppSettings["WS_TIMEOUT"]); oWebService.Credentials = oCredentials; oWebService.Url = oVariable.WebServiceURL(); Settings oSetting = new Settings(0, dsn); bool boolDNS_QIP = oSetting.IsDNS_QIP(); bool boolDNS_Bluecat = oSetting.IsDNS_Bluecat(); string strWebServiceResult = ""; switch (strAction) { case "CREATE": if (strIPNew != "" && strNameNew != "") { if (boolDNS_QIP == true) { strWebServiceResult = oWebService.CreateDNSforPNC(strIPNew, strNameNew, strObject, strAliasNew, oVariable.DNS_Domain(), oVariable.DNS_NameService(), oVariable.DNS_DynamicDNSUpdate(), intProfile, 0, true); if (strWebServiceResult == "SUCCESS") { strResult += "<p>The following record was successfully created in QIP DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p>"; } else if (strWebServiceResult.StartsWith("***DUPLICATE") == true) { strResult += "<p>The following record was already created in QIP DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p>"; } else if (strWebServiceResult.StartsWith("***CONFLICT") == true) { strError += "<p>A CONFLICT occurred when attempting to create the following record in QIP DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p><p>Conflict Message:</p><p>" + strWebServiceResult + "</p>"; } else { strError += "<p>An ERROR occurred when attempting to create the following record in QIP DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p><p>Error Message:</p><p>" + strWebServiceResult + "</p>"; } } if (boolDNS_Bluecat == true) { strWebServiceResult = oWebService.CreateBluecatDNS(strIPNew, strNameNew, strNameNew, ""); if (strWebServiceResult == "SUCCESS") { strResult += "<p>The following record was successfully created in BlueCat DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p>"; } else if (strWebServiceResult.StartsWith("***DUPLICATE") == true) { strResult += "<p>The following record was already created in BlueCat DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p>"; } else if (strWebServiceResult.StartsWith("***CONFLICT") == true) { strError += "<p>A CONFLICT occurred when attempting to create the following record in BlueCat DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p><p>Conflict Message:</p><p>" + strWebServiceResult + "</p>"; } else { strError += "<p>An ERROR occurred when attempting to create the following record in BlueCat DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p><p>Error Message:</p><p>" + strWebServiceResult + "</p>"; } } } else { strError = "<p>Invalid Parameters...</p>"; } break; case "UPDATE": string strIP = (strIPNew != "" ? strIPNew : strIPCurrent); string strName = (strNameNew != "" ? strNameNew : strNameCurrent); string strAlias = (((strAliasCurrent != "" && strAliasNew == "") || strAliasNew != "") ? strAliasNew : strAliasCurrent); if (strObject == "") { strObject = "Server"; } if (boolDNS_QIP == true) { strWebServiceResult = oWebService.UpdateDNSforPNC(strIP, strName, strObject, strAlias, oVariable.DNS_Domain(), oVariable.DNS_NameService(), oVariable.DNS_DynamicDNSUpdate(), intProfile, 0, true); if (strWebServiceResult == "SUCCESS") { strResult += "<p>The following record was successfully updated in QIP DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p>"; } else if (strWebServiceResult.StartsWith("***DUPLICATE") == true) { strResult += "<p>The following record was already updated in QIP DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p>"; } else if (strWebServiceResult.StartsWith("***CONFLICT") == true) { strError += "<p>A CONFLICT occurred when attempting to update the following record in QIP DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p><p>Conflict Message:</p><p>" + strWebServiceResult + "</p>"; } else { strError += "<p>An ERROR occurred when attempting to update the following record in QIP DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p><p>Error Message:</p><p>" + strWebServiceResult + "</p>"; } } if (boolDNS_Bluecat == true) { strWebServiceResult = oWebService.UpdateBluecatDNS(strIP, strName, strNameNew, ""); if (strWebServiceResult == "SUCCESS") { strResult += "<p>The following record was successfully updated in BlueCat DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p>"; } else if (strWebServiceResult.StartsWith("***DUPLICATE") == true) { strResult += "<p>The following record was already updated in BlueCat DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p>"; } else if (strWebServiceResult.StartsWith("***CONFLICT") == true) { strError += "<p>A CONFLICT occurred when attempting to update the following record in BlueCat DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p><p>Conflict Message:</p><p>" + strWebServiceResult + "</p>"; } else { strError += "<p>An ERROR occurred when attempting to update the following record in BlueCat DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p><p>Error Message:</p><p>" + strWebServiceResult + "</p>"; } } break; case "DELETE": if (boolDNS_QIP == true) { if (strIPCurrent != "") { strWebServiceResult = oWebService.DeleteDNSforPNC(strIPCurrent, "", intProfile, true); } else if (strNameCurrent != "") { strWebServiceResult = oWebService.DeleteDNSforPNC("", strNameCurrent, intProfile, true); } if (strWebServiceResult == "SUCCESS") { strResult += "<p>The following record was successfully deleted in QIP DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p>"; } else { strError += "<p>An ERROR occurred when attempting to delete the following record in QIP DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p><p>Error Message:</p><p>" + strWebServiceResult + "</p>"; } } if (boolDNS_Bluecat == true) { if (strIPCurrent != "") { strWebServiceResult = oWebService.DeleteBluecatDNS(strIPCurrent, "", false, false); } else if (strNameCurrent != "") { strWebServiceResult = oWebService.DeleteBluecatDNS("", strNameCurrent, false, false); } if (strWebServiceResult == "SUCCESS") { strResult += "<p>The following record was successfully deleted in BlueCat DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p>"; } else { strError += "<p>An ERROR occurred when attempting to delete the following record in BlueCat DNS...</p><p>" + oDNS.GetDNSBody(intRequest, intItem, intNumber, true, intEnvironment) + "</p><p>Error Message:</p><p>" + strWebServiceResult + "</p>"; } } break; } if (strResult != "") { oRequest.AddResult(intRequest, intItem, intNumber, oService.GetName(intService), "", strResult, intEnvironment, (oService.Get(intService, "notify_client") == "1"), oUser.GetName(intUser)); } else if (strError != "") { oRequest.AddResult(intRequest, intItem, intNumber, oService.GetName(intService), strError, "", intEnvironment, (oService.Get(intService, "notify_client") == "1"), oUser.GetName(intUser)); } oDNS.UpdateDNSCompleted(intRequest, intItem, intNumber); } if (strResult == "") { boolSuccess = false; } // ******** END PROCESSING ************** if (oService.Get(intService, "automate") == "1" && boolSuccess == true) { strDone += "<table border=\"0\"><tr><td><img src=\"/images/bigCheck.gif\" border=\"0\" align=\"absmiddle\"/></td><td class=\"biggerbold\">" + strResult + "</td></tr></table>"; } else { if (boolSuccess == false) { strDone += "<table border=\"0\"><tr><td><img src=\"/images/bigError.gif\" border=\"0\" align=\"absmiddle\"/></td><td class=\"biggerbold\">" + strError + "</td></tr></table>"; } else { strDone += "<table border=\"0\"><tr><td><img src=\"/images/bigCheck.gif\" border=\"0\" align=\"absmiddle\"/></td><td class=\"biggerbold\">" + oService.GetName(intService) + " Submitted</td></tr></table>"; } } oRequestItem.UpdateFormDone(intRequest, intItem, intNumber, 1); } } } }
protected void Page_Load(object sender, EventArgs e) { intProfile = Int32.Parse(Request.Cookies["profileid"].Value); RequestItems oRequestItem = new RequestItems(intProfile, dsn); RequestFields oRequestField = new RequestFields(intProfile, dsn); ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn); Services oService = new Services(intProfile, dsn); oFunction = new Functions(intProfile, dsn, intEnvironment); oUser = new Users(intProfile, dsn); oRequest = new Requests(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 ************** bool boolIsServerVMWare = false; bool boolIsNotManual = false; int intServer = 0; int intModel = 0; Customized oCustomized = new Customized(intProfile, dsn); DataSet dsDecomServer = oCustomized.GetDecommissionServer(intRequest, intItem, intNumber); if (dsDecomServer.Tables[0].Rows.Count > 0) { intServer = Int32.Parse(dsDecomServer.Tables[0].Rows[0]["serverid"].ToString()); DateTime datPower = DateTime.Parse(dsDecomServer.Tables[0].Rows[0]["poweroff"].ToString()); string strPowerNew = dsDecomServer.Tables[0].Rows[0]["poweroff_new"].ToString(); string strName = dsDecomServer.Tables[0].Rows[0]["servername"].ToString(); Asset oAsset = new Asset(intProfile, dsnAsset); Servers oServers = new Servers(intProfile, dsn); DataSet dsAssets = oServers.GetAssets(intServer); if (intServer > 0) { DataSet dsServer = oServers.Get(intServer); ModelsProperties oModelsProperties = new ModelsProperties(intProfile, dsn); if (dsServer.Tables[0].Rows[0]["modelid"] != DBNull.Value) { intModel = Int32.Parse(dsServer.Tables[0].Rows[0]["modelid"].ToString()); } if (intModel > 0 && oModelsProperties.IsTypeVMware(intModel) == true) { boolIsServerVMWare = true; } boolIsNotManual = true; } // VMWARE if (boolIsNotManual == true) { bool boolUnique = true; foreach (DataRow drAsset in dsAssets.Tables[0].Rows) { if (drAsset["latest"].ToString() == "1" || drAsset["dr"].ToString() == "1") { int intAsset = Int32.Parse(drAsset["assetid"].ToString()); boolUnique = oAsset.AddDecommission(intRequest, intItem, intNumber, intAsset, intProfile, dsDecomServer.Tables[0].Rows[0]["reason"].ToString(), datPower, strName + (drAsset["dr"].ToString() == "1" ? "-DR" : ""), (drAsset["dr"].ToString() == "1" ? 1 : 0), strPowerNew); if (boolUnique == false) { break; } } } if (boolUnique == true || strPowerNew != "") { oAsset.UpdateDecommission(intRequest, intItem, intNumber, 1); strResult += "<p>The server " + strName + " was successfully queued for decommission on " + (strPowerNew != "" ? strPowerNew : datPower.ToShortDateString()) + "</p>"; strError = ""; } else { strError = "<p>The server " + strName + " has already been queued for decommission</p>"; } //Send service center notification //"Assignment: Complete and Close" # region "Send Service Center Notification" ResourceRequest oResourceRequest = new ResourceRequest(intProfile, dsn); DataSet dsRR = oResourceRequest.GetResourceRequest(intRequest, intItem, intNumber); int intRRId = 0; if (dsRR.Tables[0].Rows.Count > 0) { intRRId = Int32.Parse(dsRR.Tables[0].Rows[0]["id"].ToString()); } //int intServerDecommServiceID = Int32.Parse(ConfigurationManager.AppSettings["SERVICEID_SERVER_DECOMMISSION"]); //if (intService == intServerDecommServiceID) //{ // SendServiceCenterNotification(intRequest, intItem, intService, intNumber, 0); //} #endregion } else { // MANUAL (non-automated) double dblHours = 0.00; int intDevices = 1; Field oField = new Field(intProfile, dsn); strResult += "<p>The server decommission request was submitted for " + strName + ".</p>"; strError = ""; string strTable = oField.GetTableName2(intService); if (strTable != "") { DataSet ds = oField.GetTableServiceRequest(strTable, intRequest.ToString(), intItem.ToString(), intNumber.ToString()); if (ds.Tables[0].Columns.Contains("hours") == true) { foreach (DataRow dr in ds.Tables[0].Rows) { dblHours += double.Parse(dr["hours"].ToString()); } } if (ds.Tables[0].Columns.Contains("devices") == true) { foreach (DataRow dr in ds.Tables[0].Rows) { intDevices += Int32.Parse(dr["devices"].ToString()); } } } if (oService.Get(intService, "quantity_is_device") == "1") { DataSet dsTemp = oService.GetSelected(intRequest, intService); if (dsTemp.Tables[0].Rows.Count > 0) { intDevices = Int32.Parse(dsTemp.Tables[0].Rows[0]["quantity"].ToString()); } } int intResource = oServiceRequest.AddRequest(intRequest, intItem, intService, intDevices, dblHours, 2, intNumber, dsnServiceEditor); if (oServiceRequest.NotifyApproval(intResource, intResourceRequestApprove, intEnvironment, "", dsnServiceEditor) == false) { oServiceRequest.NotifyTeamLead(intItem, intResource, intAssignPage, intViewPage, intEnvironment, "", dsnServiceEditor, dsnAsset, dsnIP, 0); } oRequest.AddResult(intRequest, intItem, intNumber, "Server Decommission", strError, strResult, intEnvironment, (oService.Get(intService, "notify_client") == "1"), oUser.GetName(intProfile)); } } else { strResult = ""; dsDecomServer = oCustomized.GetDecommissionServerDeleted(intRequest, intItem, intNumber); string strName = ""; if (dsDecomServer.Tables[0].Rows.Count > 0) { strName = dsDecomServer.Tables[0].Rows[0]["servername"].ToString(); } if (strName == "") { strError = "<p>One or more of the servers you attempted to decommission have already been queued for decommission</p>"; } else { strError = "<p>The server " + strName + " has already been queued for decommission</p>"; } oRequestItem.DeleteForms(intRequest, intService, intNumber); } if (strResult == "") { boolSuccess = false; } // ******** END PROCESSING ************** if (oService.Get(intService, "automate") == "1" && boolSuccess == true) { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_check.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + strResult + "</td></tr></table>"; } else { if (boolSuccess == false) { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_error.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + strError + "</td></tr></table>"; } else { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_check.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + oService.GetName(intService) + " Submitted</td></tr></table>"; } } oRequestItem.UpdateFormDone(intRequest, intItem, intNumber, 1, (boolIsNotManual?1:0)); } } }
protected void Page_Load(object sender, EventArgs e) { RequestItems oRequestItem = new RequestItems(intProfile, dsn); RequestFields oRequestField = new RequestFields(intProfile, dsn); ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn); Services oService = new Services(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 ************** AccountRequest oAccountRequest = new AccountRequest(intProfile, dsn); Requests oRequest = new Requests(intProfile, dsn); Users oUser = new Users(intProfile, dsn); DataSet ds = oAccountRequest.GetMaintenance(intRequest, intItem, intNumber); Domains oDomain = new Domains(intProfile, dsn); if (ds.Tables[0].Rows.Count > 0) { string strUser = ds.Tables[0].Rows[0]["username"].ToString(); int intDomain = Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()); int intEnv = Int32.Parse(oDomain.Get(intDomain, "environment")); int intUser = oRequest.GetUser(intRequest); DataSet dsParameters = oAccountRequest.GetMaintenanceParameters(intRequest, intItem, intNumber); AD oAD = new AD(intProfile, dsn, intEnv); Variables oVariable = new Variables(intEnv); DirectoryEntry oEntry = oAD.UserSearch(strUser); if (oEntry != null) { strResult = "<p>The account " + strUser + " already exists in " + oDomain.Get(intDomain, "name") + "</p>"; } else { strError = ""; Encryption oEncrypt = new Encryption(); string strFirst = dsParameters.Tables[0].Rows[0]["value"].ToString(); string strLast = dsParameters.Tables[0].Rows[1]["value"].ToString(); string strEmail = dsParameters.Tables[0].Rows[2]["value"].ToString(); string strTechnical = dsParameters.Tables[0].Rows[3]["value"].ToString(); string strPassword = oEncrypt.Decrypt(dsParameters.Tables[0].Rows[4]["value"].ToString(), "adpass"); if (strTechnical == "1") { strResult = oAD.CreateUser(strUser, strFirst, strLast, strPassword, "", "Created By ClearView on " + DateTime.Today.ToShortDateString() + Environment.NewLine + "Requested by " + oUser.GetFullName(intProfile) + " (" + oUser.GetName(intProfile) + ")", oVariable.UserOUTechnical()); if (strResult == "") { strResult = "<p>The account " + strUser + " was successfully created in " + oDomain.Get(intDomain, "name") + " with registry access (Password: "******")</p>"; } } else { strResult = oAD.CreateUser(strUser, strFirst, strLast, strPassword, "", "Created By ClearView on " + DateTime.Today.ToShortDateString() + Environment.NewLine + "Requested by " + oUser.GetFullName(intProfile) + " (" + oUser.GetName(intProfile) + ")", oVariable.UserOU()); if (strResult == "") { strResult = "<p>The account " + strUser + " was successfully created in " + oDomain.Get(intDomain, "name") + " (Password: "******")</p>"; } } string strGroupsRequested = dsParameters.Tables[0].Rows[5]["value"].ToString(); string[] strGroupRequested; char[] strSplit = { ';' }; strGroupRequested = strGroupsRequested.Split(strSplit); // Add Groups for (int ii = 0; ii < strGroupRequested.Length; ii++) { if (strGroupRequested[ii].Trim() != "") { // Add the group string strJoin = oAD.JoinGroup(strUser, strGroupRequested[ii].Trim(), 0); if (strJoin == "") { strResult += "<p>The user " + strUser + " was successfully joined to the group " + strGroupRequested[ii].Trim() + "</p>"; } else { strError += "<p>The user " + strUser + " was NOT successfully joined to the group " + strGroupRequested[ii].Trim() + " : " + strJoin + "</p>"; } } } oRequest.AddResult(intRequest, intItem, intNumber, "Account Modification", strError, strResult, intEnvironment, (oService.Get(intService, "notify_client") == "1"), oUser.GetName(intUser)); } } if (strResult == "") { boolSuccess = false; } // ******** END PROCESSING ************** if (oService.Get(intService, "automate") == "1" && boolSuccess == true) { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_check.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + strResult + "</td></tr></table>"; } else { if (boolSuccess == false) { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_error.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + strError + "</td></tr></table>"; } else { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_check.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + oService.GetName(intService) + " Submitted</td></tr></table>"; } } oRequestItem.UpdateFormDone(intRequest, intItem, intNumber, 1); } } } }
protected void Page_Load(object sender, EventArgs e) { intProfile = Int32.Parse(Request.Cookies["profileid"].Value); RequestItems oRequestItem = new RequestItems(intProfile, dsn); RequestFields oRequestField = new RequestFields(intProfile, dsn); ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn); Services oService = new Services(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 ************** Requests oRequest = new Requests(intProfile, dsn); Users oUser = new Users(intProfile, dsn); Workstations oWorkstation = new Workstations(intProfile, dsn); Workstations oRemote = new Workstations(intProfile, dsnRemote); Asset oAsset = new Asset(intProfile, dsnAsset); Domains oDomain = new Domains(intProfile, dsn); ModelsProperties oModelsProperties = new ModelsProperties(intProfile, dsn); DataSet ds = oWorkstation.GetVirtualDecommissions(intRequest, intItem, intNumber); strResult = ""; foreach (DataRow dr in ds.Tables[0].Rows) { int intID = Int32.Parse(dr["id"].ToString()); int intName = Int32.Parse(dr["nameid"].ToString()); string strName = oWorkstation.GetName(intName); int intAsset = Int32.Parse(dr["assetid"].ToString()); int intModel = Int32.Parse(dr["modelid"].ToString()); if (oModelsProperties.IsTypeVMware(intModel) == true) { // VMware Workstation bool boolUnique = oAsset.AddDecommission(intRequest, intItem, intNumber, intAsset, intProfile, "", DateTime.Now, strName, 0, ""); if (boolUnique == true) { oAsset.UpdateDecommission(intRequest, intItem, intNumber, 1); VMWare oVMWare = new VMWare(intProfile, dsn); DataSet dsGuest = oVMWare.GetGuest(strName); string strCluster = "???"; if (dsGuest.Tables[0].Rows.Count > 0 && dsGuest.Tables[0].Rows[0]["hostid"].ToString() != "") { int intHost = Int32.Parse(dsGuest.Tables[0].Rows[0]["hostid"].ToString()); int intCluster = Int32.Parse(oVMWare.GetHost(intHost, "clusterid")); strCluster = oVMWare.GetCluster(intCluster, "name"); } strResult += "<p>The VMware workstation " + strName + " is queued to be decommissioned from the cluster " + strCluster + ".</p>"; } else { strResult += "<p>The VMware workstation " + strName + " is ALREADY queued to be decommissioned</p>"; } } else { // Microsoft Virtual Workstation int intHost = Int32.Parse(dr["virtualhostid"].ToString()); int intOS = Int32.Parse(dr["osid"].ToString()); string strHost = oAsset.GetServerOrBlade(intHost, "name"); string strVirtualDir = ""; DataSet dsOS = oAsset.GetVirtualHostOs(intHost); foreach (DataRow drOS in dsOS.Tables[0].Rows) { if (Int32.Parse(drOS["osid"].ToString()) == intOS) { strVirtualDir = drOS["virtualdir"].ToString(); break; } } int intDomain = Int32.Parse(dr["domainid"].ToString()); int intEnv = Int32.Parse(oDomain.Get(intDomain, "environment")); oRemote.AddRemoteVirtualDecom(intEnv, strHost, strVirtualDir, strName); // Clean up database oWorkstation.DeleteVirtual(intID); oWorkstation.UpdateName(intName, 1); oAsset.DeleteGuest(intAsset); oAsset.AddStatus(intAsset, "", (int)AssetStatus.Decommissioned, intProfile, DateTime.Now); strResult += "<p>The virtual workstation " + strName + " was successfully decommissioned from the host " + strHost + ".</p>"; } strError = ""; } oRequest.AddResult(intRequest, intItem, intNumber, "Virtual Workstation Decommission", strError, strResult, intEnvironment, (oService.Get(intService, "notify_client") == "1"), oUser.GetName(intProfile)); if (strResult == "") { boolSuccess = false; } // ******** END PROCESSING ************** if (oService.Get(intService, "automate") == "1" && boolSuccess == true) { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_check.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + strResult + "</td></tr></table>"; } else { if (boolSuccess == false) { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_error.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + strError + "</td></tr></table>"; } else { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_check.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + oService.GetName(intService) + " Submitted</td></tr></table>"; } } oRequestItem.UpdateFormDone(intRequest, intItem, intNumber, 1, 1); } } } }
protected void Page_Load(object sender, EventArgs e) { intProfile = Int32.Parse(Request.Cookies["profileid"].Value); RequestItems oRequestItem = new RequestItems(intProfile, dsn); RequestFields oRequestField = new RequestFields(intProfile, dsn); ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn); Services oService = new Services(intProfile, dsn); oFunction = new Functions(intProfile, dsn, intEnvironment); oUser = new Users(intProfile, dsn); oRequest = new Requests(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 strResult = ""; string strError = oService.GetName(intService) + " Error"; // ********* BEGIN PROCESSING ************** Servers oServer = new Servers(intProfile, dsn); OnDemand oOnDemand = new OnDemand(intProfile, dsn); Audit oAudit = new Audit(intProfile, dsn); ServerName oServerName = new ServerName(intProfile, dsn); ModelsProperties oModelsProperties = new ModelsProperties(intProfile, dsn); Asset oAsset = new Asset(intProfile, dsnAsset, dsn); DataSet dsRebuild = oServer.GetRebuild(intRequest, intService, intNumber); bool found = false; foreach (DataRow drRebuild in dsRebuild.Tables[0].Rows) { found = true; int intServer = Int32.Parse(drRebuild["serverid"].ToString()); string strName = oServer.GetName(intServer, true); int intModel = 0; int intRebuildStep = 0; // Load General Information int intAsset = 0; DataSet dsAssets = oServer.GetAssets(intServer); foreach (DataRow drAsset in dsAssets.Tables[0].Rows) { if (drAsset["latest"].ToString() == "1") { intAsset = Int32.Parse(drAsset["assetid"].ToString()); break; } } if (intAsset > 0) { // Asset Information intModel = Int32.Parse(oAsset.Get(intAsset, "modelid")); } if (oModelsProperties.IsTypeVMware(intModel) == false) { intRebuildStep = 6; } else { intRebuildStep = 7; } oServer.UpdateStep(intServer, intRebuildStep); // Redo step...delete current step and update the other step oOnDemand.UpdateStepDoneServerRedo(intServer, intRebuildStep); oServer.DeleteSwitchports(intServer); // Reconfigure switchports oServer.UpdateRebuilding(intServer, 1); // Delete Audits oAudit.DeleteServer(intServer, 0); oAudit.DeleteServer(intServer, 1); // Set installs back DataSet dsInstalls = oServerName.GetComponentDetailSelected(intServer, 0); foreach (DataRow drInstall in dsInstalls.Tables[0].Rows) { oServerName.UpdateComponentDetailSelected(intServer, Int32.Parse(drInstall["detailid"].ToString()), -2); } int intStepSkipStart = 0; int intStepSkipGoto = 0; oServer.UpdateStepSkip(intServer, intStepSkipStart, intStepSkipGoto); strResult += "<p>The server " + strName + " was successfully queued for rebuild</p>"; strError = ""; break; } if (found == false) { strError = "<p>There was a problem configuring the server for rebuild ~ Request not found.</p>"; } if (strResult == "") { boolSuccess = false; } // ******** END PROCESSING ************** if (oService.Get(intService, "automate") == "1" && boolSuccess == true) { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_check.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + strResult + "</td></tr></table>"; } else { if (boolSuccess == false) { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_error.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + strError + "</td></tr></table>"; } else { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_check.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + oService.GetName(intService) + " Submitted</td></tr></table>"; } } oRequestItem.UpdateFormDone(intRequest, intItem, intNumber, 1, 1); } } } }
protected void Page_Load(object sender, EventArgs e) { Response.Cookies["loginreferrer"].Value = "/admin/projects_pending.aspx"; Response.Cookies["loginreferrer"].Expires = DateTime.Now.AddDays(30); if (Request.Cookies["adminid"] != null && Request.Cookies["adminid"].Value != "") { intProfile = Int32.Parse(Request.Cookies["adminid"].Value); } else { Response.Redirect("/admin/login.aspx"); } oProject = new Projects(intProfile, dsn); oProjectNumber = new ProjectNumber(intProfile, dsn); oRequest = new Requests(intProfile, dsn); oRequestItem = new RequestItems(intProfile, dsn); oService = new Services(intProfile, dsn); oProjectPending = new ProjectsPending(intProfile, dsn, intEnvironment); oOrganization = new Organizations(intProfile, dsn); oDocument = new Documents(intProfile, dsn); oUser = new Users(intProfile, dsn); oForecast = new Forecast(intProfile, dsn); oServiceRequest = new ServiceRequests(intProfile, dsn); if (!IsPostBack) { if (Request.QueryString["rid"] != null && Request.QueryString["rid"] != "") { // Process Service Requests int intRequest = Int32.Parse(Request.QueryString["rid"]); DataSet dsForm = oRequestItem.GetForms(intRequest); foreach (DataRow drForm in dsForm.Tables[0].Rows) { if (drForm["done"].ToString() == "0") { int intItem = Int32.Parse(drForm["itemid"].ToString()); int intNumber = Int32.Parse(drForm["number"].ToString()); int intService = Int32.Parse(drForm["serviceid"].ToString()); string strPath = oService.Get(intService, "cp_path"); if (strPath.Trim() == "") { // For now, bypass oRequestItem.UpdateFormDone(intRequest, intItem, intNumber, 1); } else { Control oControl = (Control)LoadControl(strPath); PHcp.Controls.Add(oControl); } } } panPH.Visible = true; } else if (Request.QueryString["id"] != null && Request.QueryString["id"] != "") { DataSet ds = oProjectPending.Get(Int32.Parse(Request.QueryString["id"])); int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString()); if (Request.QueryString["pid"] != null && Request.QueryString["pid"] != "") { int intProject = Int32.Parse(Request.QueryString["pid"]); if (intProject > 0) { // Process Design Builder DataSet dsForecast = oForecast.GetRequest(intRequest); if (dsForecast.Tables[0].Rows.Count > 0) { int intForecast = Int32.Parse(dsForecast.Tables[0].Rows[0]["id"].ToString()); DataSet dsDesigns = oForecast.GetAnswers(intForecast); OnDemandTasks oOnDemandTasks = new OnDemandTasks(0, dsn); ResourceRequest oResourceRequest = new ResourceRequest(0, dsn); foreach (DataRow drDesign in dsDesigns.Tables[0].Rows) { int intDesign = Int32.Parse(drDesign["id"].ToString()); int intDesignRequest = 0; if (Int32.TryParse(oForecast.GetAnswer(intDesign, "requestid"), out intDesignRequest) == true) { if (intDesignRequest > 0) { // Update the REQUESTID in CV_FORECAST_ANSWERS with the new project correlation oRequest.Update(intDesignRequest, intProject); } } if (oForecast.CanAutoProvision(intDesign) == false) { // Need to add a builder int intImplementorD = 0; DataSet dsResourceD = oResourceRequest.GetProjectItem(intProject, intImplementorDistributed); if (dsResourceD.Tables[0].Rows.Count > 0) { intImplementorD = Int32.Parse(dsResourceD.Tables[0].Rows[0]["userid"].ToString()); } int intImplementorM = 0; DataSet dsResourceM = oResourceRequest.GetProjectItem(intProject, intImplementorMidrange); if (dsResourceM.Tables[0].Rows.Count > 0) { intImplementorM = Int32.Parse(dsResourceM.Tables[0].Rows[0]["userid"].ToString()); } if (oForecast.GetPlatformDistributedForecast(intDesign, intWorkstationPlatform) == true) { if (intImplementorD > 0) { int intNextNumber = oResourceRequest.GetNumber(intRequest); int intResourceParent = oResourceRequest.Add(intRequest, -1, -1, intNextNumber, "Provisioning Task (Distributed)", 0, 6.00, 2, 1, 1, 1); int intResourceWorkflow = oResourceRequest.AddWorkflow(intResourceParent, 0, "Provisioning Task (Distributed)", intImplementorD, 0, 6.00, 2, 0); oOnDemandTasks.AddPending(intDesign, intResourceWorkflow); oResourceRequest.UpdateAssignedBy(intResourceParent, -999); } else { // Submit for assignment if (oServiceRequest.Get(intRequest, "requestid") == "") { oServiceRequest.Add(intRequest, 1, 1); } int intResource = oServiceRequest.AddRequest(intRequest, intImplementorDistributed, intImplementorDistributedService, 0, 0.00, 2, 1, dsnServiceEditor); if (oServiceRequest.NotifyApproval(intResource, intResourceRequestApprove, intEnvironment, "", dsnServiceEditor) == false) { oServiceRequest.NotifyTeamLead(intImplementorDistributed, intResource, intAssignPage, intViewPage, intEnvironment, "", dsnServiceEditor, dsnAsset, dsnIP, 0); } } } if (oForecast.GetPlatformMidrangeForecast(intDesign) == true) { if (intImplementorM > 0) { int intNextNumber = oResourceRequest.GetNumber(intRequest); int intResourceParent = oResourceRequest.Add(intRequest, -1, -1, intNextNumber, "Provisioning Task (Midrange)", 0, 6.00, 2, 1, 1, 1); int intResourceWorkflow = oResourceRequest.AddWorkflow(intResourceParent, 0, "Provisioning Task (Midrange)", intImplementorM, 0, 6.00, 2, 0); oOnDemandTasks.AddPending(intDesign, intResourceWorkflow); oResourceRequest.UpdateAssignedBy(intResourceParent, -999); } else { // Submit for assignment if (oServiceRequest.Get(intRequest, "requestid") == "") { oServiceRequest.Add(intRequest, 1, 1); } int intResource = oServiceRequest.AddRequest(intRequest, intImplementorMidrange, intImplementorMidrangeService, 0, 0.00, 2, 1, dsnServiceEditor); if (oServiceRequest.NotifyApproval(intResource, intResourceRequestApprove, intEnvironment, "", dsnServiceEditor) == false) { oServiceRequest.NotifyTeamLead(intImplementorMidrange, intResource, intAssignPage, intViewPage, intEnvironment, "", dsnServiceEditor, dsnAsset, dsnIP, 0); } } } } } } } oRequest.Update(intRequest, intProject); oDocument.Update(intRequest, intProject); oProjectPending.Approve(Int32.Parse(Request.QueryString["id"])); if (intProject == 0) { oServiceRequest.Update(intRequest, ds.Tables[0].Rows[0]["name"].ToString()); } Response.Redirect(Request.Path + "?rid=" + intRequest.ToString()); } else { if (Request.QueryString["reject"] != null) { panReject.Visible = true; } else { strProject = LoadProject(0, ds.Tables[0].Rows[0], intRequest, true); btnView.Attributes.Add("onclick", "return ShowServiceRequests('" + intRequest.ToString() + "');"); btnViewDesigns.Attributes.Add("onclick", "return ShowDesigns('" + intRequest.ToString() + "');"); if (Request.QueryString["c"] != null && Request.QueryString["c"] != "") { panCompare.Visible = true; string[] strProjects; char[] strSplit = { ' ' }; strProjects = Request.QueryString["c"].Split(strSplit); bool boolOther = false; for (int jj = 0; jj < strProjects.Length; jj++) { if (strProjects[jj].Trim() != "") { TableRow oRow = new TableRow(); TableCell oCell = new TableCell(); oCell.Text = strProject; oRow.Cells.Add(oCell); oCell = new TableCell(); HyperLink oCheck = new HyperLink(); oCheck.ImageUrl = "/images/bigCheck.gif"; oCheck.ToolTip = "Click to Assign"; oCheck.NavigateUrl = Request.Path + "?id=" + Request.QueryString["id"] + "&pid=" + strProjects[jj]; oCheck.Attributes.Add("onclick", "return confirm('Are you sure you want to assign this project?');"); oCell.Controls.Add(oCheck); oRow.Cells.Add(oCell); oCell = new TableCell(); oCell.Text = LoadProject(Int32.Parse(strProjects[jj]), null, 0, false); if (boolOther == true) { oRow.Attributes.Add("bgcolor", "#EFEFEF"); } boolOther = !boolOther; oRow.Cells.Add(oCell); tblCompare.Rows.Add(oRow); } } } else { panView.Visible = true; LoadList(); } } } } else { panAll.Visible = true; DataSet ds = oProjectPending.Gets(); rptView.DataSource = ds; rptView.DataBind(); } } btnCreateProject.Attributes.Add("onclick", "return confirm('Are you sure you want to create this PROJECT?');"); btnCreateTask.Attributes.Add("onclick", "return confirm('Are you sure you want to create this TASK?');"); btnCreateTask.Enabled = false; btnRejectConfirm.Attributes.Add("onclick", "return confirm('Are you sure you want to reject this project / task?');"); }
private void LoadValues() { //int intRequest = Int32.Parse(Request.QueryString["rid"]); //DataSet dsItems = oRequestItem.GetForms(intRequest); //if (dsItems.Tables[0].Rows.Count > 0) //{ // foreach (DataRow drItem in dsItems.Tables[0].Rows) // { // if (drItem["done"].ToString() == "-1") // { // lblItem.Text = drItem["itemid"].ToString(); // lblNumber.Text = drItem["number"].ToString(); // break; // } // } //} int intRequest = Int32.Parse(Request.QueryString["rid"]); DataSet dsItems; int intForm = 0; if (Request.QueryString["formid"] != null && Request.QueryString["formid"] != "") { intForm = Int32.Parse(Request.QueryString["formid"]); dsItems = oRequestItem.GetForm(intRequest, intForm); } else { dsItems = oRequestItem.GetForms(intRequest); } if (dsItems.Tables[0].Rows.Count > 0) { foreach (DataRow drItem in dsItems.Tables[0].Rows) { if (drItem["done"].ToString() == "-1" || intForm > 0) { lblItem.Text = drItem["itemid"].ToString(); if (intForm > 0 && Request.QueryString["num"] != null && Request.QueryString["num"] != "") { lblNumber.Text = Request.QueryString["num"]; } else { lblNumber.Text = drItem["number"].ToString(); } break; } } } // Load Data if (Request.QueryString["formid"] != null && Request.QueryString["formid"] != "") { int intItem = Int32.Parse(lblItem.Text); int intNumber = Int32.Parse(lblNumber.Text); DataSet dsEdit = oCustomized.GetDecommissionServer(intRequest, intItem, intNumber); if (dsEdit.Tables[0].Rows.Count > 0) { DataRow drEdit = dsEdit.Tables[0].Rows[0]; panEdit.Visible = true; txtName.Text = drEdit["servername"].ToString(); btnContinue.Enabled = false; //btnBack.Enabled = false; strEdit = oCustomized.GetDecommissionServerBody(intRequest, intItem, intNumber, dsnAsset); txtPower.Text = drEdit["poweroff_new"].ToString(); if (drEdit["poweroff_new"].ToString() == "") { txtPower.Text = DateTime.Parse(drEdit["poweroff"].ToString()).ToShortDateString(); } else { txtPower.Text = DateTime.Parse(drEdit["poweroff_new"].ToString()).ToShortDateString(); } } btnNext.Text = "Update"; btnBack.Text = "Cancel"; btnNext.Attributes.Add("onclick", "return ValidateDate('" + txtPower.ClientID + "','Please enter a valid date')" + " && ValidateDateToday('" + txtPower.ClientID + "','The date must occur after today')" + " && ProcessButton(this)" + ";"); btnCancel1.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { RequestItems oRequestItem = new RequestItems(intProfile, dsn); RequestFields oRequestField = new RequestFields(intProfile, dsn); ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn); Services oService = new Services(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; StringBuilder sbResult = new StringBuilder(oService.GetName(intService) + " Completed"); StringBuilder sbError = new StringBuilder(oService.GetName(intService) + " Error"); // ********* BEGIN PROCESSING ************** AccountRequest oAccountRequest = new AccountRequest(intProfile, dsn); Requests oRequest = new Requests(intProfile, dsn); Users oUser = new Users(intProfile, dsn); DataSet ds = oAccountRequest.GetMaintenance(intRequest, intItem, intNumber); Domains oDomain = new Domains(intProfile, dsn); if (ds.Tables[0].Rows.Count > 0) { string strUser = ds.Tables[0].Rows[0]["username"].ToString(); int intDomain = Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()); int intEnv = Int32.Parse(oDomain.Get(intDomain, "environment")); int intUser = oRequest.GetUser(intRequest); DataSet dsParameters = oAccountRequest.GetMaintenanceParameters(intRequest, intItem, intNumber); AD oAD = new AD(intProfile, dsn, intEnv); DirectoryEntry oEntry = oAD.UserSearch(strUser); if (oEntry == null) { sbResult = new StringBuilder(); } else { sbError = new StringBuilder(); string strFirstOld = ""; if (oEntry.Properties.Contains("givenname") == true) { strFirstOld = oEntry.Properties["givenname"].Value.ToString(); } string strLastOld = ""; if (oEntry.Properties.Contains("sn") == true) { strLastOld = oEntry.Properties["sn"].Value.ToString(); } string strFirstNew = dsParameters.Tables[0].Rows[0]["value"].ToString(); string strLastNew = dsParameters.Tables[0].Rows[1]["value"].ToString(); string strEnable = dsParameters.Tables[0].Rows[2]["value"].ToString(); string strUnlock = dsParameters.Tables[0].Rows[3]["value"].ToString(); string strGroupsRequested = dsParameters.Tables[0].Rows[4]["value"].ToString(); if (strFirstOld != strFirstNew || strLastOld != strLastNew) { if (strFirstOld != strFirstNew && strLastOld != strLastNew) { oEntry.Properties["givenname"].Value = strFirstNew; oEntry.Properties["sn"].Value = strLastNew; oEntry.Properties["displayname"].Value = strLastNew + ", " + strFirstNew; oEntry.CommitChanges(); sbResult.Append("<p>The first name and last name for account "); sbResult.Append(strUser); sbResult.Append(" was successfully updated</p>"); } else if (strFirstOld != strFirstNew) { oEntry.Properties["givenname"].Value = strFirstNew; oEntry.Properties["displayname"].Value = strLastNew + ", " + strFirstNew; oEntry.CommitChanges(); sbResult.Append("<p>The first name for account "); sbResult.Append(strUser); sbResult.Append(" was successfully updated</p>"); } else { oEntry.Properties["sn"].Value = strLastNew; oEntry.Properties["displayname"].Value = strLastNew + ", " + strFirstNew; oEntry.CommitChanges(); sbResult.Append("<p>The last name for account "); sbResult.Append(strUser); sbResult.Append(" was successfully updated</p>"); } } if (strEnable == "1") { strEnable = oAD.Enable(oEntry, true); if (strEnable == "") { sbResult.Append("<p>The user account "); sbResult.Append(strUser); sbResult.Append(" was successfully enabled</p>"); } else { sbError.Append("<p>The user account "); sbError.Append(strUser); sbError.Append(" was NOT successfully enabled</p>"); } } if (strUnlock == "1") { strUnlock = oAD.Unlock(oEntry); if (strUnlock == "") { sbResult.Append("<p>The user account "); sbResult.Append(strUser); sbResult.Append(" was successfully unlocked</p>"); } else { sbError.Append("<p>The user account "); sbError.Append(strUser); sbError.Append(" was NOT successfully unlocked</p>"); } } string strGroupsExist = oAD.GetGroups(oEntry); string[] strGroupRequested; string[] strGroupExist; char[] strSplit = { ';' }; strGroupRequested = strGroupsRequested.Split(strSplit); strGroupExist = strGroupsExist.Split(strSplit); // Add Groups for (int ii = 0; ii < strGroupRequested.Length; ii++) { if (strGroupRequested[ii].Trim() != "") { bool boolExist = false; for (int jj = 0; jj < strGroupExist.Length; jj++) { if (strGroupExist[jj].Trim() != "" && strGroupRequested[ii].Trim() == strGroupExist[jj].Trim()) { boolExist = true; break; } } if (boolExist == false) { // Add the group string strJoin = oAD.JoinGroup(strUser, strGroupRequested[ii].Trim(), 0); if (strJoin == "") { sbResult.Append("<p>The user "); sbResult.Append(strUser); sbResult.Append(" was successfully joined to the group "); sbResult.Append(strGroupRequested[ii].Trim()); sbResult.Append("</p>"); } else { sbError.Append("<p>The user "); sbError.Append(strUser); sbError.Append(" was NOT successfully joined to the group "); sbError.Append(strGroupRequested[ii].Trim()); sbError.Append(" : "); sbError.Append(strJoin); sbError.Append("</p>"); } } } } // Remove Groups for (int ii = 0; ii < strGroupExist.Length; ii++) { if (strGroupExist[ii].Trim() != "") { bool boolExist = false; for (int jj = 0; jj < strGroupRequested.Length; jj++) { if (strGroupRequested[jj].Trim() != "" && strGroupExist[ii].Trim() == strGroupRequested[jj].Trim()) { boolExist = true; break; } } if (boolExist == false) { // Remove the group string strJoin = oAD.RemoveGroup(strUser, strGroupExist[ii].Trim()); if (strJoin == "") { sbResult.Append("<p>The user "); sbResult.Append(strUser); sbResult.Append(" was successfully removed from the group "); sbResult.Append(strGroupExist[ii].Trim()); sbResult.Append("</p>"); } else { sbError.Append("<p>The user "); sbError.Append(strUser); sbError.Append(" was NOT successfully removed from the group "); sbError.Append(strGroupExist[ii].Trim()); sbError.Append(" : "); sbError.Append(strJoin); sbError.Append("</p>"); } } } } oRequest.AddResult(intRequest, intItem, intNumber, "Account Modification", sbError.ToString(), sbResult.ToString(), intEnvironment, (oService.Get(intService, "notify_client") == "1"), oUser.GetName(intUser)); } } if (sbResult.ToString() == "") { boolSuccess = false; } // ******** END PROCESSING ************** if (oService.Get(intService, "automate") == "1" && boolSuccess == true) { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_check.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + sbResult.ToString() + "</td></tr></table>"; } else { if (boolSuccess == false) { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_error.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + sbError.ToString() + "</td></tr></table>"; } else { strDone += "<table border=\"0\"><tr><td valign=\"top\"><img src=\"/images/ico_check.gif\" border=\"0\" align=\"absmiddle\"/></td><td valign=\"top\" class=\"biggerbold\">" + oService.GetName(intService) + " Submitted</td></tr></table>"; } } oRequestItem.UpdateFormDone(intRequest, intItem, intNumber, 1); } } } }
private void LoadValues() { int intRequest = Int32.Parse(Request.QueryString["rid"]); DataSet dsItems; int intForm = 0; if (Request.QueryString["formid"] != null && Request.QueryString["formid"] != "") { intForm = Int32.Parse(Request.QueryString["formid"]); dsItems = oRequestItem.GetForm(intRequest, intForm); } else { dsItems = oRequestItem.GetForms(intRequest); } if (dsItems.Tables[0].Rows.Count > 0) { foreach (DataRow drItem in dsItems.Tables[0].Rows) { if (drItem["done"].ToString() == "-1" || intForm > 0) { lblItem.Text = drItem["itemid"].ToString(); lblService.Text = drItem["serviceid"].ToString(); if (intForm > 0 && Request.QueryString["num"] != null && Request.QueryString["num"] != "") { lblNumber.Text = Request.QueryString["num"]; } else { lblNumber.Text = drItem["number"].ToString(); } break; } } } else { lblService.Text = intForm.ToString(); } // Load Data if (Request.QueryString["formid"] != null && Request.QueryString["formid"] != "") { int intItem = Int32.Parse(lblItem.Text); int intNumber = Int32.Parse(lblNumber.Text); DataSet dsEdit = oServer.GetRebuild(intRequest, intForm, intNumber); foreach (DataRow drEdit in dsEdit.Tables[0].Rows) { int intID = 0; if (Int32.TryParse(drEdit["serverid"].ToString(), out intID) == true) { lblId.Text = intID.ToString(); //txtChange.Text = drEdit["change"].ToString(); txtName.Text = lblName.Text = oServer.GetName(intID, true); btnContinue.Enabled = false; panFound.Visible = true; btnNext.Text = "Update"; btnBack.Text = "Cancel"; //btnNext.Attributes.Add("onclick", "return ValidateTextLength('" + txtChange.ClientID + "', 'Please enter a valid change control number\\n\\n - Must start with either \"CHG\" or \"PTM\"\\n - Must be exactly 10 characters in length', 10, ['CHG','PTM'], ['CHG0000000','PTM0000000','CHG1111111','PTM1111111','CHG9999999','PTM9999999','CHGXXXXXXX','PTMXXXXXXX'])" + // " && ProcessButton(this) && LoadWait()" + // ";"); btnNext.Attributes.Add("onclick", "return ProcessButton(this) && LoadWait()" + ";"); btnCancel1.Visible = false; } break; } } }