private void LoadInformation()
{
lblView.Text = oAssetOrder.GetOrderBody(intRequest, intItem, intNumber);
//Get the Execution Tab Details
DataSet ds = oAssetOrder.Get(intRequest, intItem, intNumber);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
hdnOrderId.Value = dr["OrderId"].ToString();
hdnRequestedQuantity.Value = dr["RequestedQuantity"].ToString();
hdnModel.Value = dr["ModelId"].ToString();
//Populate Existing comments
PopulateOrderReqComments();
LoadAssetsForOrder();
if (oWMServiceTasks.IsWMServiceTaskCompleted(intRequest, intService, intItem, intNumber) == false)
{
btnComplete.Visible = false;
}
else
{
btnComplete.Enabled = true;
btnComplete.Visible = true;
}
}
}
private void LoadInformation()
{
lblView.Text = oAssetOrder.GetOrderBody(intRequest, intItem, intNumber);
//Get the Execution Tab Details
DataSet ds = oAssetOrder.Get(intRequest, intItem, intNumber);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
hdnOrderId.Value = dr["OrderId"].ToString();
hdnRequestedQuantity.Value = dr["RequestedQuantity"].ToString();
hdnModel.Value = dr["ModelId"].ToString();
//Populate Existing comments
PopulateOrderReqComments();
LoadAssetsForOrder();
}
}
private void LoadInformation()
{
lblView.Text = oAssetOrder.GetOrderBody(intRequest, intItem, intNumber);
//Get the Execution Tab Details
DataSet ds = oAssetOrder.Get(intRequest, intItem, intNumber);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
hdnOrderId.Value = dr["OrderId"].ToString();
hdnProcureQuantity.Value = dr["ProcureQuantity"].ToString();
hdnModel.Value = dr["ModelId"].ToString();
ddlDepot.SelectedValue = (dr["ReceivedDepotId"].ToString() == "" ? "0" : dr["ReceivedDepotId"].ToString());
txtDateReceived.Text = (dr["ReceivedDate"].ToString() != "" ? DateTime.Parse(dr["ReceivedDate"].ToString()).ToShortDateString() : "");
//Populate Existing comments
PopulateOrderReqComments();
LoadAssetsForOrder();
}
}
public string GetBody(int _requestid, int _itemid, int _number, int _serviceid, int _rrid, int _rr_workflowid, string _se_dsn, int _environment, string _dsn_asset, string _dsn_ip)
{
string strView = "";
Applications oApplication = new Applications(user, dsn);
RequestItems oRequestItem = new RequestItems(user, dsn);
ResourceRequest oResourceRequest = new ResourceRequest(user, dsn);
Users oUser = new Users(user, dsn);
Services oService = new Services(user, dsn);
Variables oVariable = new Variables(_environment);
Functions oFunction = new Functions(0, dsn, _environment);
Requests oRequest = new Requests(user, dsn);
Projects oProject = new Projects(user, dsn);
ServiceRequests oServiceRequest = new ServiceRequests(user, dsn);
ServiceEditor oServiceEditor = new ServiceEditor(user, _se_dsn);
Servers oServer = new Servers(user, dsn);
Workstations oWorkstation = new Workstations(user, dsn);
AssetOrder oAssetOrder = new AssetOrder(user, dsn, _dsn_asset, _environment);
AssetSharedEnvOrder oAssetSharedEnvOrder = new AssetSharedEnvOrder(user, dsn, _dsn_asset, _environment);
PNCTasks oPNCTask = new PNCTasks(user, dsn);
TSM oTSM = new TSM(user, dsn);
StatusLevels oStatusLevel = new StatusLevels();
DataSet dsRR = oResourceRequest.GetRequestService(_requestid, _serviceid, _number);
if (dsRR.Tables[0].Rows.Count > 0)
{
if (_rrid == 0)
{
Int32.TryParse(dsRR.Tables[0].Rows[0]["parent"].ToString(), out _rrid);
}
if (_rr_workflowid == 0)
{
Int32.TryParse(dsRR.Tables[0].Rows[0]["id"].ToString(), out _rr_workflowid);
}
}
// Workflow
string strWorkflowName = "";
int intProject = oRequest.GetProjectNumber(_requestid);
if (intProject > 0)
{
strView += "<tr><td valign=\"top\"><b>Project Name:</b></td>";
strView += "<td colspan=\"40\">" + oProject.Get(intProject, "name") + "</td></tr>";
strView += "<tr><td valign=\"top\"><b>Project Number:</b></td>";
strView += "<td>" + "<a href=\"" + oRequest.GetDataPointLink(_requestid, _environment) + "\" target=\"_blank\">" + oProject.Get(intProject, "number") + "</a></td></tr>";
}
else
{
string strTaskName = "N/A";
if (_rr_workflowid > 0)
{
strTaskName = oResourceRequest.GetWorkflow(_rr_workflowid, "name").Trim();
}
if ((strTaskName == "" || strTaskName == "N/A") && _rrid > 0)
{
strTaskName = oResourceRequest.Get(_rrid, "name").Trim();
}
if ((strTaskName == "" || strTaskName == "N/A") && _requestid > 0)
{
strTaskName = oServiceRequest.Get(_requestid, "name").Trim();
}
strView += "<tr><td valign=\"top\"><b>Task Name:</b></td>";
strView += "<td colspan=\"40\">" + strTaskName + "</td></tr>";
}
strView += "<tr><td valign=\"top\"><b>Task Number:</b></td>";
strView += "<td>" + "<a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"OpenNewWindowMenu('/datapoint/service/resource.aspx?id=" + oFunction.encryptQueryString(_rrid.ToString()) + "', '800', '600');\">CVT" + _requestid.ToString() + "-" + _serviceid.ToString() + "-" + _number.ToString() + "</a></td></tr>";
//strWorkflowName += "<td>" + "<a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"OpenNewWindowMenu('" + oRequest.GetDataPointLink(_requestid, _environment) + "', '800', '600');\">CVT" + _requestid.ToString() + "</a></td>";
string strWorkflowRequested = "";
string strWorkflowCreated = "";
string strWorkflowService = "";
string strWorkflowDepartment = "";
string strWorkflowResources = "";
string strWorkflowStatus = "";
string strWorkflowComments = "";
int intStatus = 0;
// Requested
strWorkflowRequested += "<td valign=\"top\"><b>Requested By:</b></td>";
int intRequestor = oRequest.GetUser(_requestid);
int intRequestorManager = 0;
Int32.TryParse(oUser.Get(intRequestor, "manager"), out intRequestorManager);
Int32.TryParse(oResourceRequest.Get(_rrid, "status"), out intStatus);
strWorkflowRequested += "<td>" + oUser.GetFullName(intRequestor) + " (" + oUser.GetName(intRequestor) + ")" + "</td>";
strWorkflowCreated += "<td valign=\"top\"><b>Created On:</b></td>";
if (_rrid > 0)
{
strWorkflowCreated += "<td>" + DateTime.Parse(oResourceRequest.Get(_rrid, "created")).ToLongDateString() + "</td>";
}
else
{
strWorkflowCreated += "<td>" + DateTime.Parse(oRequest.Get(_requestid, "created")).ToLongDateString() + "</td>";
}
// Service
strWorkflowService += "<td valign=\"top\"><b>Service:</b></td>";
if (_serviceid == 0)
{
strWorkflowService += "<td>" + oRequestItem.GetItem(_itemid, "service_title") + "</td>";
}
else
{
strWorkflowService += "<td>" + oService.GetName(_serviceid) + "</td>";
}
// Department
strWorkflowDepartment += "<td valign=\"top\"><b>Department:</b></td>";
strWorkflowDepartment += "<td>" + oApplication.Get(oRequestItem.GetItemApplication(_itemid), "service_title") + "</td>";
// Resources
string strApprovers = "";
DataSet dsApprovals = oResourceRequest.GetApprovals(_requestid, _serviceid, _number);
foreach (DataRow drApprover in dsApprovals.Tables[0].Rows)
{
int intApprover = Int32.Parse(drApprover["userid"].ToString());
if (drApprover["approved"].ToString() == "" && drApprover["denied"].ToString() == "")
{
if (strApprovers != "")
{
strApprovers += "\\n";
}
strApprovers += oUser.GetFullName(intApprover) + " (" + oUser.GetName(intApprover) + ")";
}
}
bool boolAutomated = (oService.Get(_serviceid, "automate") == "1");
if (boolAutomated == false)
{
DataSet dsReqForm = oRequestItem.GetForm(_requestid, _serviceid, _itemid, _number);
if (dsReqForm.Tables[0].Rows.Count > 0)
{
boolAutomated = (dsReqForm.Tables[0].Rows[0]["automated"].ToString() == "1" ? true : false);
}
}
strWorkflowResources += "<td valign=\"top\"><b>Assigned:</b></td>";
strWorkflowStatus += "<td><b>Status:</b></td>";
if (boolAutomated == true)
{
strWorkflowResources += "<td valign=\"top\">---</td>";
intStatus = (int)ResourceRequestStatus.NotAvailable; // Set to N/A since it is automated...
strWorkflowStatus += "<td>" + oStatusLevel.HTML(intStatus) + "</td>";
}
else
{
List <WorkflowStatus> RR = oResourceRequest.GetStatus(null, _rrid, null, null, null, null, false, _se_dsn);
if (RR.Count > 0)
{
StringBuilder strUsers = new StringBuilder();
foreach (string strUser in RR[0].users)
{
if (String.IsNullOrEmpty(strUser) == false)
{
strUsers.Append(strUser);
strUsers.AppendLine("<br/>");
}
}
strWorkflowResources += "<td valign=\"top\">" + strUsers.ToString() + "</td>";
strWorkflowStatus += "<td>" + RR[0].status + "</td>";
if (String.IsNullOrEmpty(RR[0].comments) == false)
{
strWorkflowComments += "<td valign=\"top\"><b>Comments:</b></td>";
strWorkflowComments += "<td valign=\"top\">" + oFunction.FormatText(RR[0].comments) + "</td>";
}
}
else
{
strWorkflowResources += "<td valign=\"top\"> N / A </td>";
strWorkflowStatus += "<td> N / A </td>";
}
}
strView += "<tr>" + strWorkflowRequested + "</tr><tr>" + strWorkflowCreated + "</tr><tr>" + strWorkflowService + "</tr><tr>" + strWorkflowDepartment + "</tr>" + "<tr>" + strWorkflowStatus + "</tr>" + (strWorkflowResources == "" ? "" : "<tr>" + strWorkflowResources + "</tr>") + (strWorkflowComments == "" ? "" : "<tr>" + strWorkflowComments + "</tr>");
if (strView == "")
{
strView = "Information Unavailable";
}
else
{
strView = "<table cellpadding=\"3\" cellspacing=\"2\" border=\"0\" style=\"" + oVariable.DefaultFontStyle() + "\">" + strView + "</table>";
StringBuilder sbViewRequest = new StringBuilder();
Customized oCustomized = new Customized(user, dsn);
DNS oDNS = new DNS(user, dsn);
OnDemandTasks oOnDemandTask = new OnDemandTasks(user, dsn);
Reports oReport = new Reports(user, dsn);
Audit oAudit = new Audit(user, dsn);
Enhancements oEnhancement = new Enhancements(user, dsn);
ServerDecommission oServerDecommission = new ServerDecommission(0, dsn);
Storage oStorage = new Storage(0, dsn);
string strCatch = "1";
try
{
sbViewRequest.Append(oServiceEditor.GetRequestBody(_requestid, _serviceid, _number, dsn));
if (sbViewRequest.ToString() == "")
{
strCatch = "2";
sbViewRequest.Append(oCustomized.GetPNCDNSConflictBody(_requestid, _itemid, _number));
}
if (sbViewRequest.ToString() == "")
{
strCatch = "3";
sbViewRequest.Append(oCustomized.GetStorage3rdBody(_requestid, _itemid, _number, _environment));
}
if (sbViewRequest.ToString() == "")
{
strCatch = "4";
sbViewRequest.Append(oOnDemandTask.GetServerOther(_requestid, _serviceid, _number, _environment, _dsn_asset, _dsn_ip));
}
if (sbViewRequest.ToString() == "")
{
strCatch = "5";
sbViewRequest.Append(GetBody(oReport.GetOrderReport(_requestid, _itemid, _number), _serviceid));
}
if (sbViewRequest.ToString() == "")
{
strCatch = "6";
sbViewRequest.Append(oServerDecommission.GetBody(_requestid, _number, _dsn_asset, _environment));
}
if (sbViewRequest.ToString() == "")
{
strCatch = "7";
sbViewRequest.Append(oCustomized.GetDecommissionServerBody(_requestid, _itemid, _number, _dsn_asset));
}
if (sbViewRequest.ToString() == "")
{
strCatch = "7.1";
sbViewRequest.Append(oWorkstation.GetApprovalSummary(_requestid));
}
if (sbViewRequest.ToString() == "")
{
strCatch = "8";
int intEnhancementID = oCustomized.GetEnhancementID(_requestid);
if (intEnhancementID > 0)
{
sbViewRequest.Append("<tr><td>");
sbViewRequest.Append(oCustomized.GetEnhancementBody(intEnhancementID, _environment, false));
sbViewRequest.Append("</td></tr>");
}
}
if (sbViewRequest.ToString() == "")
{
strCatch = "9";
int intIssueID = oCustomized.GetIssueID(_requestid);
if (intIssueID > 0)
{
sbViewRequest.Append("<tr><td>");
sbViewRequest.Append(oCustomized.GetIssueBody(intIssueID, _environment, false));
sbViewRequest.Append("</td></tr>");
}
}
if (sbViewRequest.ToString() == "")
{
strCatch = "10";
sbViewRequest.Append(GetBody(oCustomized.GetIIS(_requestid, _itemid, _number), _serviceid));
}
if (sbViewRequest.ToString() == "")
{
strCatch = "11";
sbViewRequest.Append(GetBody(oCustomized.GetRemediation(_requestid, _itemid, _number), _serviceid));
}
if (sbViewRequest.ToString() == "")
{
strCatch = "12";
sbViewRequest.Append(GetBody(oCustomized.GetServerArchive(_requestid, _itemid, _number), _serviceid));
}
if (sbViewRequest.ToString() == "")
{
strCatch = "13";
sbViewRequest.Append(GetBody(oCustomized.GetServerRetrieve(_requestid, _itemid, _number), _serviceid));
}
if (sbViewRequest.ToString() == "")
{
strCatch = "14";
sbViewRequest.Append(GetBody(oCustomized.GetTPM(_requestid, _itemid, _number), _serviceid));
}
if (sbViewRequest.ToString() == "")
{
strCatch = "15";
sbViewRequest.Append(GetBody(oCustomized.GetWorkstation(_requestid, _itemid, _number), _serviceid));
}
if (sbViewRequest.ToString() == "")
{
strCatch = "16";
sbViewRequest.Append(GetBody(oCustomized.GetThirdTierDistributed(_requestid, _itemid, _number), _serviceid));
}
if (sbViewRequest.ToString() == "")
{
strCatch = "17";
sbViewRequest.Append(GetBody(oCustomized.GetGeneric(_requestid, _itemid, _number), _serviceid));
}
if (sbViewRequest.ToString() == "")
{
strCatch = "18";
sbViewRequest.Append(oDNS.GetDNSBody(_requestid, _itemid, _number, false, _environment));
}
if (sbViewRequest.ToString() == "")
{
strCatch = "19";
sbViewRequest.Append(oAudit.GetErrorBody(_requestid, _serviceid, _number));
}
if (sbViewRequest.ToString() == "")//Server Error Provisioning Support
{
strCatch = "20";
sbViewRequest.Append(oServer.GetErrorDetailsBody(_requestid, _itemid, _number, _environment));
}
if (sbViewRequest.ToString() == "") //Workstation Error Provisioning Support
{
strCatch = "21";
sbViewRequest.Append(oWorkstation.GetVirtualErrorDetailsBody(_requestid, _number, _environment));
}
if (sbViewRequest.ToString() == "") //Asset Procurement
{
strCatch = "22";
sbViewRequest.Append(oAssetOrder.GetOrderBody(_requestid, _itemid, _number));
}
if (sbViewRequest.ToString() == "") //Shared Environement - IM
{
strCatch = "23";
sbViewRequest.Append(oAssetSharedEnvOrder.GetOrderBody(_requestid, _itemid, _number));
}
if (sbViewRequest.ToString() == "") //Backup
{
strCatch = "24";
sbViewRequest.Append(oTSM.GetBody(_requestid, _itemid, _number, _dsn_asset, _dsn_ip));
}
if (sbViewRequest.ToString() == "") // New Enhancement
{
strCatch = "25";
sbViewRequest.Append(oEnhancement.GetBodyRequest(_requestid, _environment));
}
if (sbViewRequest.ToString() == "") // New Enhancement
{
strCatch = "26";
sbViewRequest.Append(oStorage.GetBody(_requestid, _itemid, _number, _dsn_asset, _dsn_ip, _environment, false));
}
if (sbViewRequest.ToString() == "")
{
//strViewRequest = "Information Unavailable";
sbViewRequest.Append(" ");
}
else
{
if (sbViewRequest.ToString().Trim().StartsWith("<table") == false)
{
sbViewRequest.Insert(0, "<table cellpadding=\"3\" cellspacing=\"2\" border=\"0\" style=\"" + oVariable.DefaultFontStyle() + "\">");
sbViewRequest.Append("</table>");
}
}
}
catch
{
sbViewRequest = new StringBuilder(" ** WARNING: Information Unavailable (# " + strCatch + ") ** ");
}
sbViewRequest.Insert(0, "<table cellpadding=\"3\" cellspacing=\"2\" border=\"0\" style=\"" + oVariable.DefaultFontStyle() + "\"><tr><td>");
sbViewRequest.Append("</td></tr></table>");
strView += "<br/>" + sbViewRequest.ToString();
}
return(strView);
}
private void LoadInformation()
{
lblView.Text = oAssetOrder.GetOrderBody(intRequest, intItem, intNumber);
//Get the Execution Tab Details
DataSet ds = oAssetOrder.Get(intRequest, intItem, intNumber);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
hdnOrderId.Value = dr["OrderId"].ToString();
int intProjectId = 0;
Int32.TryParse(dr["ProjectId"].ToString(), out intProjectId);
if (Request.QueryString["projectid"] != null)
{
if (Request.QueryString["projectid"] != "")
{
Int32.TryParse(Request.QueryString["projectid"], out intProjectId);
}
else
{
Page.ClientScript.RegisterStartupScript(typeof(Page), "reload", "<script type=\"text/javascript\">alert('There were " + Request.QueryString["projects"] + " projects found with that project number. Please try again.');<" + "/" + "script>");
}
}
DataSet dsProject = oProject.Get(intProjectId);
if (dsProject.Tables[0].Rows.Count == 1)
{
txtProjectNumber.Text = dsProject.Tables[0].Rows[0]["number"].ToString();
txtProjectName.Text = dsProject.Tables[0].Rows[0]["name"].ToString();
int intLead = 0;
Int32.TryParse(dsProject.Tables[0].Rows[0]["lead"].ToString(), out intLead);
if (intLead > 0)
{
txtProjectManager.Text = oUser.GetFullName(intLead) + " (" + oUser.GetName(intLead) + ")";
txtProjectManager.Enabled = false;
}
else
{
txtProjectManager.Enabled = true;
}
}
hdnProjectId.Value = intProjectId.ToString();
txtNickName.Text = dr["NickName"].ToString();
txtModel.Text = dr["ModelName"].ToString();
hdnModel.Value = dr["ModelId"].ToString();
txtQuantity.Text = dr["RequestedQuantity"].ToString();
txtProcureQuantity.Text = dr["ProcureQuantity"].ToString();
txtReDeployQuantity.Text = dr["ReDeployQuantity"].ToString();
txtReturnedQuantity.Text = dr["ReturnedQuantity"].ToString();
txtPurchaseOrderNumber.Text = dr["PurchaseOrderNumber"].ToString();
ddlPurchaseOrderStatus.SelectedValue = (dr["PurchaseOrderStatusId"].ToString() != "" ? dr["PurchaseOrderStatusId"].ToString() : "0");
txtPurchaseOrderDate.Text = (dr["PurchaseOrderDate"].ToString() != "" ? DateTime.Parse(dr["PurchaseOrderDate"].ToString()).ToShortDateString() : "");
txtApprovedQuantity.Text = dr["ApprovedQuantity"].ToString();
txtApprovedOn.Text = (dr["ApprovedOn"].ToString() != "" ? DateTime.Parse(dr["ApprovedOn"].ToString()).ToShortDateString() : "");
if (dr["PurchaseOrderUpload"].ToString() != "")
{
hypPurchaseOrderUpload.Text = "<img src='/images/file.gif' border='0' align='absmiddle'/> Click here to view the file";
hypPurchaseOrderUpload.NavigateUrl = dr["PurchaseOrderUpload"].ToString();
}
else
{
hypPurchaseOrderUpload.Text = "<img src='/images/alert.gif' border='0' align='absmiddle'/> Please upload a file";
}
txtQuoteNumber.Text = dr["QuoteNumber"].ToString();
txtQuoteDate.Text = (dr["QuoteDate"].ToString() != "" ? DateTime.Parse(dr["QuoteDate"].ToString()).ToShortDateString() : "");
txtWarrantyDate.Text = (dr["WarrantyDate"].ToString() != "" ? DateTime.Parse(dr["WarrantyDate"].ToString()).ToShortDateString() : "");
txtSystemPrice.Text = (dr["SystemPrice"].ToString() != "" ? dr["SystemPrice"].ToString() : "0.00");
txtPurchaseOrderPrice.Text = (dr["PurchaseOrderPrice"].ToString() != "" ? dr["PurchaseOrderPrice"].ToString() : "0.00");
txtSalesTax.Text = (dr["SalesTax"].ToString() != "" ? dr["SalesTax"].ToString() : "0.00");
if (dr["ManufacturerQuoteUpload"].ToString() != "")
{
hypManufacturerQuoteUpload.Text = "<img src='/images/file.gif' border='0' align='absmiddle'/> Click here to view the file";
hypManufacturerQuoteUpload.NavigateUrl = dr["ManufacturerQuoteUpload"].ToString();
}
else
{
hypManufacturerQuoteUpload.Text = "<img src='/images/alert.gif' border='0' align='absmiddle'/> Please upload a file";
}
txtVendorTrackingNumber.Text = dr["VendorTrackingNumber"].ToString();
txtVendorOrderDate.Text = (dr["VendorOrderDate"].ToString() != "" ? DateTime.Parse(dr["VendorOrderDate"].ToString()).ToShortDateString() : "");
ddlVendorOrderStatus.SelectedValue = (dr["VendorOrderStatusId"].ToString() != "" ? dr["VendorOrderStatusId"].ToString() : "0");
int intAttentionTo = 0;
if (Int32.TryParse(dr["AttentionTo"].ToString(), out intAttentionTo) == true)
{
if (intAttentionTo > 0)
{
txtAttentionTo.Text = oUser.GetFullName(intAttentionTo) + " (" + oUser.GetName(intAttentionTo) + ")";
}
}
hdnAttentionTo.Value = intAttentionTo.ToString();
txtPurchaseOrderComments.Text = dr["PurchaseOrderComments"].ToString();
//if Purchase Order status= Approved and Vendor Order Status = Shipped OR
//if Purchase Order status= Rejected Or if Purchase Order status= Skip
if ((dr["PurchaseOrderStatusId"].ToString() == "2" && dr["VendorOrderStatusId"].ToString() == "1") ||
(dr["PurchaseOrderStatusId"].ToString() == "3" || dr["PurchaseOrderStatusId"].ToString() == "4"))
{
btnComplete.Visible = true;
}
else
{
btnComplete.Visible = false;
}
//Populate Existing comments
PopulateOrderReqComments();
}
}
