private void LoadStatus(int _resourceid)
{
int intResourceWorkflow = Int32.Parse(lblResourceWorkflow.Text);
int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow);
ddlCurrentStatus.SelectedValue = oResourceRequest.GetWorkflow(intResourceWorkflow, "status");
}
private void LoadInformation(int _request)
{
if (intProject > 0)
{
lblName.Text = oProject.Get(intProject, "name");
lblNumber.Text = oProject.Get(intProject, "number");
lblType.Text = "Project";
}
else
{
lblName.Text = oResourceRequest.GetWorkflow(_request, "name");
lblNumber.Text = "CVT" + intRequest.ToString();
lblType.Text = "Task";
}
if (Request.QueryString["div"] != null)
{
switch (Request.QueryString["div"])
{
case "E":
boolExecution = true;
break;
}
}
if (boolDetails == false && boolExecution == false)
{
boolDetails = true;
}
}
public void UpdateCheckboxes(HttpRequest oForm, int _resourceid, int _requestid, int _itemid, int _number)
{
ResourceRequest oResourceRequest = new ResourceRequest(user, dsn);
bool boolJoined = (oResourceRequest.GetWorkflow(_resourceid, "joined") == "1");
// First, uncheck the checkboxes.
if (boolJoined)
{
oResourceRequest.DeleteDetails(_requestid, _itemid, _number);
}
else
{
oResourceRequest.DeleteDetails(_requestid, _itemid, _number, _resourceid);
}
int intParent = oResourceRequest.GetWorkflowParent(_resourceid);
DataSet dsWF = oResourceRequest.GetWorkflowsParent(intParent);
if (boolJoined)
{
foreach (DataRow drWF in dsWF.Tables[0].Rows)
{
oResourceRequest.DeleteWorkflowHours(Int32.Parse(drWF["id"].ToString()));
oResourceRequest.UpdateWorkflowUsed(Int32.Parse(drWF["id"].ToString()), 0.00);
}
}
else
{
oResourceRequest.DeleteWorkflowHours(_resourceid);
oResourceRequest.UpdateWorkflowUsed(_resourceid, 0.00);
}
double dblQuantity = double.Parse(oResourceRequest.GetWorkflow(_resourceid, "devices"));
foreach (string strForm in oForm.Form)
{
string strNameID = strForm;
strNameID = strNameID.ToUpper();
if (strForm.StartsWith("hdnDetail_") == true)
{
string strValue = oForm.Form[strForm];
int intDetail = Int32.Parse(strForm.Substring(strForm.IndexOf("hdnDetail_") + 10));
oResourceRequest.AddDetails(_requestid, _itemid, _number, (boolJoined ? 0 : _resourceid), intDetail, Int32.Parse(strValue));
if (Int32.Parse(strValue) == 1)
{
// selected - the following function will update all JOINED values
oResourceRequest.UpdateWorkflowHours(_resourceid, (double.Parse(Get(intDetail, "hours")) * dblQuantity));
}
}
}
}
private void LoadInformation(int _request)
{
if (intProject > 0)
{
lblName.Text = oProject.Get(intProject, "name");
lblNumber.Text = oProject.Get(intProject, "number");
lblType.Text = "Project";
}
else
{
lblName.Text = oResourceRequest.GetWorkflow(_request, "name");
lblNumber.Text = "CVT" + intRequest.ToString();
lblType.Text = "Task";
}
}
protected void btnSubmit_Click(Object Sender, EventArgs e)
{
bool boolSent = false;
DataSet dsWF = oResourceRequest.GetWorkflow(intResource);
int intTo = 0;
if (dsWF.Tables[0].Rows.Count > 0 && Int32.TryParse(Request.Form[hdnEmployee.UniqueID], out intTo) == true)
{
int intParent = Int32.Parse(dsWF.Tables[0].Rows[0]["parent"].ToString());
DataSet ds = oResourceRequest.Get(intParent);
if (ds.Tables[0].Rows.Count > 0)
{
int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
int intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString());
int intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString());
oFunction.SendEmail("Service Request [CVT" + intRequest.ToString() + "-" + intService.ToString() + "-" + intNumber.ToString() + "]", oUser.GetName(intTo), "", oUser.GetName(intProfile), "Service Request [CVT" + intRequest.ToString() + "-" + intService.ToString() + "-" + intNumber.ToString() + "]", "<p>The following service request information has been sent to you by <b>" + oUser.GetFullName(intProfile) + "</b>.</p>" + (txtComments.Text == "" ? "" : "<p>" + txtComments.Text + "</p>") + "<p>" + oResourceRequest.GetSummary(intParent, intResource, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p>", true, false);
boolSent = true;
}
}
if (boolSent)
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "reload", "<script type=\"text/javascript\">alert('An email was successfully sent.');window.parent.location.reload();window.close();<" + "/" + "script>");
}
else
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "reload", "<script type=\"text/javascript\">alert('There was a problem sending the email.');window.parent.location.reload();window.close();<" + "/" + "script>");
}
}
private void LoadInformation(int intResourceWorkflow)
{
int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow);
int intRequest = Int32.Parse(oResourceRequest.Get(intResourceParent, "requestid"));
DataSet ds = oRequest.Get(intRequest);
lblName.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "name");
lblStart.Text = DateTime.Parse(ds.Tables[0].Rows[0]["start_date"].ToString()).ToLongDateString();
lblEnd.Text = DateTime.Parse(ds.Tables[0].Rows[0]["end_date"].ToString()).ToLongDateString();
lblDescription.Text = ds.Tables[0].Rows[0]["description"].ToString();
if (Request.QueryString["div"] != null)
{
switch (Request.QueryString["div"])
{
case "E":
boolExecution = true;
break;
case "C":
boolChange = true;
break;
case "M":
boolMyDocuments = true;
break;
}
}
if (boolExecution == false && boolChange == false && boolMyDocuments == false)
{
boolExecution = true;
}
}
private string GetImplementor(int intProject, int intAnswer)
{
string strImplementor = "";
try
{
int intImplementor = 0;
DataSet dsTasks = oOnDemandTasks.GetPending(intAnswer);
if (dsTasks.Tables[0].Rows.Count > 0)
{
intImplementor = Int32.Parse(dsTasks.Tables[0].Rows[0]["resourceid"].ToString());
intImplementor = Int32.Parse(oResourceRequest.GetWorkflow(intImplementor, "userid"));
}
else
{
intImplementor = -999;
}
if (intImplementor > 0 || intImplementor == -999)
{
strImplementor = oUser.GetFullName(intImplementor) + " (" + oUser.GetName(intImplementor) + ")";
}
}
catch
{
strImplementor = "** ERROR **";
}
return(strImplementor);
}
private void LoadInformation(int _request)
{
lblView.Text = oRequestField.GetBodyWorkflow(_request, dsnServiceEditor, intEnvironment, dsnAsset, dsnIP);
if (intProject > 0)
{
lblName.Text = oProject.Get(intProject, "name");
lblNumber.Text = oProject.Get(intProject, "number");
lblType.Text = "Project";
}
else
{
lblName.Text = oResourceRequest.GetWorkflow(_request, "name");
//lblName.Text = oResourceRequest.GetWorkflow(_request, "name");
lblNumber.Text = "CVT" + intRequest.ToString();
lblType.Text = "Task";
}
DataSet dsAudit = oAudit.GetError(intRequest, intService, intNumber);
if (dsAudit.Tables[0].Rows.Count > 0)
{
radActionFix.Checked = (dsAudit.Tables[0].Rows[0]["fixed"].ToString() == "1");
radActionIgnore.Checked = (dsAudit.Tables[0].Rows[0]["fixed"].ToString() == "0");
if (radActionIgnore.Checked)
{
trIgnore.Style["display"] = "inline";
txtReason.Text = dsAudit.Tables[0].Rows[0]["reason"].ToString();
}
}
if (Request.QueryString["div"] != null)
{
switch (Request.QueryString["div"])
{
case "E":
boolExecution = true;
break;
}
}
if (boolDetails == false && boolExecution == false)
{
boolDetails = true;
}
}
private void LoadInformation(int _request)
{
lblView.Text = oRequestField.GetBodyWorkflow(_request, dsnServiceEditor, intEnvironment, dsnAsset, dsnIP);
if (intProject > 0)
{
lblName.Text = oProject.Get(intProject, "name");
lblNumber.Text = oProject.Get(intProject, "number");
lblType.Text = "Project";
}
else
{
lblName.Text = oResourceRequest.GetWorkflow(_request, "name");
//lblName.Text = oResourceRequest.GetWorkflow(_request, "name");
lblNumber.Text = "CVT" + intRequest.ToString();
lblType.Text = "Task";
}
if (Request.QueryString["div"] != null)
{
switch (Request.QueryString["div"])
{
case "E":
boolExecution = true;
break;
case "C":
boolChange = true;
break;
case "D":
boolDocuments = true;
break;
case "S":
boolStatusUpdates = true;
break;
}
}
if (boolDetails == false && boolExecution == false && boolStatusUpdates == false && boolChange == false && boolDocuments == false)
{
boolDetails = true;
}
}
public string LoadCheckboxes(int _requestid, int _itemid, int _number, int _resourceid, int _serviceid)
{
ResourceRequest oResourceRequest = new ResourceRequest(user, dsn);
DataSet dsWF = oResourceRequest.GetRequestService(_requestid, _serviceid, _number);
bool boolDone = false;
if (dsWF.Tables[0].Rows.Count > 0)
{
int intStatus = 0;
Int32.TryParse(dsWF.Tables[0].Rows[0]["status"].ToString(), out intStatus);
boolDone = (intStatus == 3 || dsWF.Tables[0].Rows[0]["completed"].ToString() != "");
}
StringBuilder sbReturn = new StringBuilder();
DataSet ds = Gets(_serviceid, 0, 1);
foreach (DataRow dr in ds.Tables[0].Rows)
{
int intID = Int32.Parse(dr["id"].ToString());
if (dr["checkbox"].ToString() == "1")
{
int intValue = oResourceRequest.GetDetailValue(_requestid, _itemid, _number, (oResourceRequest.GetWorkflow(_resourceid, "joined") == "1" ? 0 : _resourceid), intID);
if (intValue == -1)
{
intValue = 0;
oResourceRequest.AddDetails(_requestid, _itemid, _number, (oResourceRequest.GetWorkflow(_resourceid, "joined") == "1" ? 0 : _resourceid), intID, intValue);
}
sbReturn.Append("<tr><td><table id=\"chkTaskList" + _resourceid.ToString() + "\" cellpadding=\"2\" cellspacing=\"1\" border=\"0\"><tr><td valign=\"top\"><input id=\"chkDetail_");
sbReturn.Append(intID.ToString());
sbReturn.Append("\" type=\"checkbox\" name=\"chkDetail_");
sbReturn.Append(intID.ToString());
sbReturn.Append("\" onclick=\"UpdateRRCheckDetail('hdnDetail_");
sbReturn.Append(intID.ToString());
sbReturn.Append("', this);\"");
sbReturn.Append(intValue == 1 || boolDone ? " checked" : "");
sbReturn.Append(" /></td><td><label for=\"chkDetail_");
sbReturn.Append(intID.ToString());
sbReturn.Append("\">");
sbReturn.Append(dr["name"].ToString());
sbReturn.Append("</label><input type=\"hidden\" name=\"hdnDetail_");
sbReturn.Append(intID.ToString());
sbReturn.Append("\" id=\"hdnDetail_");
sbReturn.Append(intID.ToString());
sbReturn.Append("\" value=\"");
sbReturn.Append(intValue.ToString());
sbReturn.Append("\" /></td></tr></table></td></tr>");
}
}
if (sbReturn.ToString() != "")
{
sbReturn.Insert(0, "<table cellpadding=\"2\" cellspacing=\"1\" border=\"0\">");
sbReturn.Append("</table>");
}
return(sbReturn.ToString());
}
private bool LoadInformation(int _request)
{
lblView.Text = oRequestField.GetBodyWorkflow(_request, dsnServiceEditor, intEnvironment, dsnAsset, dsnIP);
if (intProject > 0)
{
lblName.Text = oProject.Get(intProject, "name");
lblNumber.Text = oProject.Get(intProject, "number");
lblType.Text = "Project";
}
else
{
lblName.Text = oResourceRequest.GetWorkflow(_request, "name");
lblNumber.Text = "CVT" + intRequest.ToString();
lblType.Text = "Task";
}
bool boolDone = false;
DataSet ds = oCustomized.GetServerArchive(intRequest, intItem, intNumber);
if (ds.Tables[0].Rows.Count > 0)
{
txtHostname.Text = ds.Tables[0].Rows[0]["hostname"].ToString();
chkHostname.Checked = (txtHostname.Text != "");
lblG1.Text = txtHostname.Text;
chkG1.Checked = (ds.Tables[0].Rows[0]["G1"].ToString() == "1");
chkG2.Checked = (ds.Tables[0].Rows[0]["G2"].ToString() == "1");
chkG3.Checked = (ds.Tables[0].Rows[0]["G3"].ToString() == "1");
chkG4.Checked = (ds.Tables[0].Rows[0]["G4"].ToString() == "1");
chkG5.Checked = (ds.Tables[0].Rows[0]["G5"].ToString() == "1");
boolDone = (txtHostname.Text.Trim() != "" && chkG1.Checked && chkG2.Checked && chkG3.Checked && chkG4.Checked && chkG5.Checked);
}
if (Request.QueryString["div"] != null)
{
switch (Request.QueryString["div"])
{
case "E":
boolExecution = true;
break;
case "X":
boolExtension = true;
break;
}
}
if (boolDetails == false && boolExecution == false && boolExtension == false)
{
boolDetails = true;
}
return(boolDone);
}
private bool LoadInformation(int _request_workflow)
{
if (intProject > 0)
{
lblName.Text = oProject.Get(intProject, "name");
lblNumber.Text = oProject.Get(intProject, "number");
lblType.Text = "Project";
}
else
{
lblName.Text = oResourceRequest.GetWorkflow(_request_workflow, "name");
lblNumber.Text = "CVT" + intRequest.ToString();
lblType.Text = "Task";
}
bool boolDone = false;
DataSet ds = oOnDemandTasks.GetVirtualII(intRequest, intItem, intNumber);
if (ds.Tables[0].Rows.Count > 0)
{
Forecast oForecast = new Forecast(intProfile, dsn);
int intAnswer = Int32.Parse(ds.Tables[0].Rows[0]["answerid"].ToString());
lblAnswer.Text = intAnswer.ToString();
btnView.Attributes.Add("onclick", "return OpenWindow('FORECAST_EQUIPMENT','?id=" + intAnswer.ToString() + "');");
//btnBirth.Attributes.Add("onclick", "return OpenWindow('PDF_BIRTH','?id=" + intAnswer.ToString() + "');");
//btnSC.Attributes.Add("onclick", "return OpenWindow('PDF_BIRTH','?id=" + intAnswer.ToString() + "');");
lblView.Text = oOnDemandTasks.GetBody(intAnswer, intImplementorDistributed, intImplementorMidrange);
int intModel = Int32.Parse(ds.Tables[0].Rows[0]["modelid"].ToString());
ModelsProperties oModelsProperties = new ModelsProperties(intProfile, dsn);
intModel = Int32.Parse(oModelsProperties.Get(intModel, "modelid"));
Models oModel = new Models(intProfile, dsn);
int intType = Int32.Parse(oModel.Get(intModel, "typeid"));
Types oType = new Types(intProfile, dsn);
string strExecute = oType.Get(intType, "forecast_execution_path");
if (strExecute != "")
{
btnExecute.Attributes.Add("onclick", "return OpenWindow('FORECAST_EXECUTE','" + strExecute + "?id=" + intAnswer.ToString() + "');");
}
chk1.Checked = (ds.Tables[0].Rows[0]["chk1"].ToString() == "1");
chk2.Checked = (ds.Tables[0].Rows[0]["chk2"].ToString() == "1");
txtSCID.Text = ds.Tables[0].Rows[0]["scid"].ToString();
chk3.Checked = (ds.Tables[0].Rows[0]["chk3"].ToString() == "1");
chk4.Checked = (ds.Tables[0].Rows[0]["chk4"].ToString() == "1");
boolDone = (chk1.Checked && chk2.Checked && chk3.Checked && chk4.Checked);
img1.ImageUrl = "/images/green_arrow.gif";
if (chk1.Checked == true)
{
btnExecute.Enabled = false;
img1.ImageUrl = "/images/check.gif";
img2.ImageUrl = "/images/green_arrow.gif";
chk2.Enabled = true;
Servers oServer = new Servers(intProfile, dsn);
DataSet dsAnswer = oServer.GetAnswer(intAnswer);
foreach (DataRow drAnswer in dsAnswer.Tables[0].Rows)
{
if (lbl1.Text != "")
{
lbl1.Text += "<br/>";
}
int intServerName = Int32.Parse(drAnswer["nameid"].ToString());
ServerName oServerName = new ServerName(0, dsn);
lbl1.Text += "Server Name: " + oservername.getname2(intServerName, 0) + "<br/>";
int intServer = Int32.Parse(drAnswer["id"].ToString());
Zeus oZeus = new Zeus(intProfile, dsnZeus);
DataSet dsZeus = oZeus.GetBuildServer(intServer);
if (dsZeus.Tables[0].Rows.Count > 0)
{
lbl1.Text += "Serial Number: " + dsZeus.Tables[0].Rows[0]["serial"].ToString() + "<br/>";
}
int intDomain = Int32.Parse(drAnswer["domainid"].ToString());
Domains oDomain = new Domains(intProfile, dsn);
boolMove = (oDomain.Get(intDomain, "move") == "1");
if (boolMove == true)
{
lbl1.Text += "DHCP Address: " + drAnswer["dhcp"].ToString() + "<br/>";
}
int intIPAddress = 0;
IPAddresses oIPAddresses = new IPAddresses(0, dsnIP, dsn);
if (drAnswer["ipaddressid"].ToString() != "")
{
intIPAddress = Int32.Parse(drAnswer["ipaddressid"].ToString());
lbl1.Text += "Assigned IP Address: " + oIPAddresses.GetName(intIPAddress, 0) + "<br/>";
}
if (drAnswer["ipaddressid_final"].ToString() != "")
{
intIPAddress = Int32.Parse(drAnswer["ipaddressid_final"].ToString());
lbl1.Text += "Final IP Address: " + oIPAddresses.GetName(intIPAddress, 0) + "<br/>";
}
}
}
}
if (boolMove == false)
{
}
if (chk2.Checked == true)
{
chk1.Enabled = false;
img2.ImageUrl = "/images/check.gif";
img3.ImageUrl = "/images/green_arrow.gif";
chk3.Enabled = true;
}
if (chk3.Checked == true)
{
chk2.Enabled = false;
img3.ImageUrl = "/images/check.gif";
img4.ImageUrl = "/images/green_arrow.gif";
chk4.Enabled = true;
}
if (chk4.Checked == true)
{
chk3.Enabled = false;
img4.ImageUrl = "/images/check.gif";
}
if (Request.QueryString["div"] != null)
{
switch (Request.QueryString["div"])
{
case "E":
boolExecution = true;
break;
}
}
if (boolDetails == false && boolExecution == false)
{
boolDetails = true;
}
return(boolDone);
}
private bool LoadInformation(int _request)
{
lblView.Text = oRequestField.GetBodyWorkflow(_request, dsnServiceEditor, intEnvironment, dsnAsset, dsnIP);
if (intProject > 0)
{
lblName.Text = oProject.Get(intProject, "name");
lblNumber.Text = oProject.Get(intProject, "number");
lblType.Text = "Project";
}
else
{
lblName.Text = oResourceRequest.GetWorkflow(_request, "name");
lblNumber.Text = "CVT" + intRequest.ToString();
lblType.Text = "Task";
}
bool boolDone = false;
DataSet ds = oCustomized.GetServerArchive(intRequest, intItem, intNumber);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["backto"].ToString() == "Virtual")
{
panTestCenterVirtual.Visible = true;
lblT1.Text = ds.Tables[0].Rows[0]["hostname"].ToString();
if (lblT1.Text == "")
{
lblT1.Text = "N/A";
}
chkTV1.Checked = (ds.Tables[0].Rows[0]["TV1"].ToString() == "1");
chkTV2.Checked = (ds.Tables[0].Rows[0]["TV2"].ToString() == "1");
boolDone = (chkTV1.Checked && chkTV2.Checked);
}
else
{
panTestCenterPhysical.Visible = true;
Models oModel = new Models(intProfile, dsn);
lblModelNumber.Text = oModel.Get(Int32.Parse(ds.Tables[0].Rows[0]["modelid"].ToString()), "name");
chkTP1.Checked = (ds.Tables[0].Rows[0]["TP1"].ToString() == "1");
chkTP2.Checked = (ds.Tables[0].Rows[0]["TP2"].ToString() == "1");
chkTP3.Checked = (ds.Tables[0].Rows[0]["TP3"].ToString() == "1");
chkTP4.Checked = (ds.Tables[0].Rows[0]["TP4"].ToString() == "1");
chkTP5.Checked = (ds.Tables[0].Rows[0]["TP5"].ToString() == "1");
chkTP6.Checked = (ds.Tables[0].Rows[0]["TP6"].ToString() == "1");
chkTP7.Checked = (ds.Tables[0].Rows[0]["TP7"].ToString() == "1");
chkTP8.Checked = (ds.Tables[0].Rows[0]["TP8"].ToString() == "1");
chkTP9.Checked = (ds.Tables[0].Rows[0]["TP9"].ToString() == "1");
chkTP10.Checked = (ds.Tables[0].Rows[0]["TP10"].ToString() == "1");
boolDone = (chkTP1.Checked && chkTP2.Checked && chkTP3.Checked && chkTP4.Checked && chkTP5.Checked && chkTP6.Checked && chkTP7.Checked && chkTP8.Checked && chkTP9.Checked && chkTP10.Checked);
}
}
if (Request.QueryString["div"] != null)
{
switch (Request.QueryString["div"])
{
case "E":
boolExecution = true;
break;
case "X":
boolExtension = true;
break;
}
}
if (boolDetails == false && boolExecution == false && boolExtension == false)
{
boolDetails = true;
}
return(boolDone);
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oRequestItem = new RequestItems(intProfile, dsn);
oApplication = new Applications(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oProject = new Projects(intProfile, dsn);
oProjectNumber = new ProjectNumber(intProfile, dsn);
oService = new Services(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oDelegate = new Delegates(intProfile, dsn);
if (Request.QueryString["action"] != null && Request.QueryString["action"] != "")
{
panFinish.Visible = true;
}
else
{
panForm.Visible = true;
if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "")
{
int intResourceWorkflow = Int32.Parse(Request.QueryString["rrid"]);
int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow);
DataSet ds = oResourceRequest.Get(intResourceParent);
if (ds.Tables[0].Rows.Count > 0)
{
int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid"));
int intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString());
int intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString());
int intApp = oRequestItem.GetItemApplication(intItem);
//if (intProfile == intUser || oService.IsManager(intService, intProfile) || oDelegate.Get(intUser, intProfile) > 0 || (oApplication.IsManager(intApp, intProfile) && oApplication.Get(intApp, "disable_manager") != "1") || (oUser.IsManager(intUser, intProfile, true) && oApplication.Get(intApp, "disable_manager") != "1"))
//{
int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
hdnRequestID.Value = intRequest.ToString();
int intProject = oRequest.GetProjectNumber(intRequest);
string strPath = "";
if (intItem == 0)
{
strPath = strPCWM;
}
else if (intItem == -1)
{
strPath = strTaskWM;
}
else
{
if (oApplication.Get(intApp, "tpm") != "1" && oProject.Get(intProject, "number") == "")
{
oProject.Update(intProject, oProjectNumber.New());
}
strPath = oService.Get(intService, "wm_path");
}
if (strPath != "")
{
oForm.Controls.Add((Control)LoadControl(strPath));
}
string strTitle = "Task";
if (intProject > 0)
{
strTitle = oProject.Get(intProject, "name");
}
Master.Page.Title = strTitle + " | " + oService.GetName(intService);
//}
//else
// panDenied.Visible = true;
}
else
{
panDenied.Visible = true;
}
}
}
btnFinish.Attributes.Add("onclick", "return CloseWindow();");
btnClose.Attributes.Add("onclick", "return CloseWindow();");
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oProject = new Projects(intProfile, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oUser = new Users(intProfile, dsn);
oPage = new Pages(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oRequestItem = new RequestItems(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oService = new Services(intProfile, dsn);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oRequestField = new RequestFields(intProfile, dsn);
oApplication = new Applications(intProfile, dsn);
oServiceDetail = new ServiceDetails(intProfile, dsn);
oDelegate = new Delegates(intProfile, dsn);
oDocument = new Documents(intProfile, dsn);
oOnDemandTasks = new OnDemandTasks(intProfile, dsn);
if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "")
{
intApplication = Int32.Parse(Request.QueryString["applicationid"]);
}
if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "")
{
intPage = Int32.Parse(Request.QueryString["pageid"]);
}
if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "")
{
intApplication = Int32.Parse(Request.Cookies["application"].Value);
}
if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "")
{
// Start Workflow Change
lblResourceWorkflow.Text = Request.QueryString["rrid"];
int intResourceWorkflow = Int32.Parse(Request.QueryString["rrid"]);
int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow);
ds = oResourceRequest.Get(intResourceParent);
// End Workflow Change
intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
lblRequestedBy.Text = oUser.GetFullName(oRequest.GetUser(intRequest));
lblRequestedOn.Text = DateTime.Parse(oRequest.Get(intRequest, "created")).ToString();
lblDescription.Text = oRequest.Get(intRequest, "description");
if (lblDescription.Text == "")
{
lblDescription.Text = "<i>No information</i>";
}
intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString());
intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString());
// Start Workflow Change
bool boolComplete = (oResourceRequest.GetWorkflow(intResourceWorkflow, "status") == "3");
int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid"));
txtCustom.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "name");
double dblAllocated = double.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated"));
boolJoined = (oResourceRequest.GetWorkflow(intResourceWorkflow, "joined") == "1");
// End Workflow Change
intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString());
lblService.Text = oService.Get(intService, "name");
int intApp = oRequestItem.GetItemApplication(intItem);
if (Request.QueryString["save"] != null && Request.QueryString["save"] != "")
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "saved", "<script type=\"text/javascript\">alert('Information Saved Successfully');<" + "/" + "script>");
}
if (Request.QueryString["status"] != null && Request.QueryString["status"] != "")
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "statusd", "<script type=\"text/javascript\">alert('Weekly Status has been Added');<" + "/" + "script>");
}
if (!IsPostBack)
{
double dblUsed = oResourceRequest.GetWorkflowUsed(intResourceWorkflow);
lblUpdated.Text = oResourceRequest.GetUpdated(intResourceParent);
if (dblAllocated == dblUsed)
{
if (boolComplete == false)
{
oFunction.ConfigureToolButton(btnComplete, "/images/tool_complete");
btnComplete.Attributes.Add("onclick", "return confirm('Are you sure you want to mark this as completed and remove it from your workload?');");
}
else
{
oFunction.ConfigureToolButton(btnComplete, "/images/tool_complete");
btnComplete.Attributes.Add("onclick", "alert('This task has already been marked COMPLETE. You can close this window.');return false;");
}
}
else
{
btnComplete.ImageUrl = "/images/tool_complete_dbl.gif";
btnComplete.Enabled = false;
}
if (oService.Get(intService, "sla") != "")
{
oFunction.ConfigureToolButton(btnSLA, "/images/tool_sla");
int intDays = oResourceRequest.GetSLA(intResourceParent);
if (intDays < 1)
{
btnSLA.Style["border"] = "solid 2px #FF0000";
}
else if (intDays < 3)
{
btnSLA.Style["border"] = "solid 2px #FF9999";
}
btnSLA.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST_SLA','?rrid=" + intResourceParent.ToString() + "');");
}
else
{
btnSLA.ImageUrl = "/images/tool_sla_dbl.gif";
btnSLA.Enabled = false;
}
oFunction.ConfigureToolButton(btnEmail, "/images/tool_email");
btnEmail.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST_EMAIL','?rrid=" + intResourceWorkflow.ToString() + "&type=GENERIC');");
dblUsed = (dblUsed / dblAllocated) * 100;
strCheckboxes = oServiceDetail.LoadCheckboxes(intRequest, intItem, intNumber, intResourceWorkflow, intService);
if (oService.Get(intService, "tasks") != "1" || strCheckboxes == "")
{
if (oService.Get(intService, "no_slider") == "1")
{
panNoSlider.Visible = true;
btnComplete.ImageUrl = "/images/tool_complete.gif";
btnComplete.Enabled = true;
btnComplete.Attributes.Add("onclick", "return confirm('Are you sure you want to mark this as completed and remove it from your workload?');");
btnComplete.CommandArgument = "FAST";
}
else
{
panSlider.Visible = true;
sldHours._StartPercent = dblUsed.ToString();
sldHours._TotalHours = dblAllocated.ToString();
}
}
else
{
panCheckboxes.Visible = true;
}
intProject = oRequest.GetProjectNumber(intRequest);
hdnTab.Value = "D";
panWorkload.Visible = true;
LoadStatus(intResourceWorkflow);
LoadChange(intResourceWorkflow);
LoadInformation(intResourceWorkflow);
chkDescription.Checked = (Request.QueryString["doc"] != null);
lblDocuments.Text = oDocument.GetDocuments_Request(intRequest, 0, Request.PhysicalApplicationPath, 1, (Request.QueryString["doc"] != null));
// GetDocuments(string _physical, int _projectid, int _requestid, int _userid, int _security, bool _show_description, bool _mine)
//lblDocuments.Text = oDocument.GetDocuments(Request.PhysicalApplicationPath, 0, intRequest, 0, 1, (Request.QueryString["doc"] != null), false);
btnDenied.Attributes.Add("onclick", "return CloseWindow();");
oFunction.ConfigureToolButton(btnSave, "/images/tool_save");
oFunction.ConfigureToolButton(btnPrint, "/images/tool_print");
btnPrint.Attributes.Add("onclick", "return PrintWindow();");
oFunction.ConfigureToolButton(btnClose, "/images/tool_close");
btnClose.Attributes.Add("onclick", "return ExitWindow();");
btnSave.Attributes.Add("onclick", "return ValidateStatus('" + ddlStatus.ClientID + "','" + txtComments.ClientID + "');");
btnChange.Attributes.Add("onclick", "return ValidateText('" + txtNumber.ClientID + "','Please enter a change control number')" +
" && ValidateDate('" + txtDate.ClientID + "','Please enter a valid implementation date')" +
" && ValidateTime('" + txtTime.ClientID + "','Please enter a valid implementation time')" +
";");
imgDate.Attributes.Add("onclick", "return ShowCalendar('" + txtDate.ClientID + "');");
// 6/1/2009 - Load ReadOnly View
if (oResourceRequest.CanUpdate(intProfile, intResourceWorkflow, false) == false)
{
oFunction.ConfigureToolButtonRO(btnSave, btnComplete);
//panDenied.Visible = true;
}
}
}
else
{
panDenied.Visible = true;
}
}
private bool LoadInformation(int _request_workflow)
{
if (intProject > 0)
{
lblName.Text = oProject.Get(intProject, "name");
lblNumber.Text = oProject.Get(intProject, "number");
lblType.Text = "Project";
}
else
{
lblName.Text = oResourceRequest.GetWorkflow(_request_workflow, "name");
lblNumber.Text = "CVT" + intRequest.ToString();
lblType.Text = "Task";
}
bool boolDone = false;
DataSet ds = oOnDemandTasks.GetVMWareII(intRequest, intItem, intNumber);
if (ds.Tables[0].Rows.Count > 0)
{
Forecast oForecast = new Forecast(intProfile, dsn);
int intAnswer = Int32.Parse(ds.Tables[0].Rows[0]["answerid"].ToString());
if (oForecast.IsHARoom(intAnswer) == true)
{
DataSet dsServer = oServer.GetAnswer(intAnswer);
foreach (DataRow drServer in dsServer.Tables[0].Rows)
{
int intHA = Int32.Parse(drServer["id"].ToString());
DataSet dsHA = oServer.GetHA(intHA);
if (dsHA.Tables[0].Rows.Count > 0)
{
if (lblHA.Text != "")
{
lblHA.Text += "<br/>";
}
lblHA.Text += oServer.GetName(intHA, true) + " = " + oServer.GetName(Int32.Parse(dsHA.Tables[0].Rows[0]["serverid_ha"].ToString()), true);
panHA.Visible = true;
}
}
}
lblAnswer.Text = intAnswer.ToString();
btnView.Attributes.Add("onclick", "return OpenWindow('FORECAST_EQUIPMENT','?id=" + intAnswer.ToString() + "');");
btnBirth.Attributes.Add("onclick", "return OpenWindow('PDF_BIRTH','?id=" + intAnswer.ToString() + "');");
btnSC.Attributes.Add("onclick", "return OpenWindow('PDF_BIRTH','?id=" + intAnswer.ToString() + "');");
lblView.Text = oOnDemandTasks.GetBody(intAnswer, intImplementorDistributed, intImplementorMidrange);
int intModel = Int32.Parse(ds.Tables[0].Rows[0]["modelid"].ToString());
ModelsProperties oModelsProperties = new ModelsProperties(intProfile, dsn);
intModel = Int32.Parse(oModelsProperties.Get(intModel, "modelid"));
Models oModel = new Models(intProfile, dsn);
int intType = Int32.Parse(oModel.Get(intModel, "typeid"));
Types oType = new Types(intProfile, dsn);
string strExecute = oType.Get(intType, "forecast_execution_path");
if (strExecute != "")
{
btnExecute.Attributes.Add("onclick", "return OpenWindow('FORECAST_EXECUTE','" + strExecute + "?id=" + intAnswer.ToString() + "');");
}
chk1.Checked = (ds.Tables[0].Rows[0]["chk1"].ToString() == "1");
chk3.Checked = (ds.Tables[0].Rows[0]["chk3"].ToString() == "1");
chk4.Checked = (ds.Tables[0].Rows[0]["chk4"].ToString() == "1");
chk5.Checked = (ds.Tables[0].Rows[0]["chk5"].ToString() == "1");
chk6.Checked = (ds.Tables[0].Rows[0]["chk6"].ToString() == "1");
chk7.Checked = (ds.Tables[0].Rows[0]["chk7"].ToString() == "1");
chk8.Checked = (ds.Tables[0].Rows[0]["chk8"].ToString() == "1");
chk9.Checked = (ds.Tables[0].Rows[0]["chk9"].ToString() == "1");
chk10.Checked = (ds.Tables[0].Rows[0]["chk10"].ToString() == "1");
chk11.Checked = (ds.Tables[0].Rows[0]["chk11"].ToString() == "1");
int intNotifications = Int32.Parse(ds.Tables[0].Rows[0]["notifications"].ToString());
int intClass = Int32.Parse(oForecast.GetAnswer(intAnswer, "classid"));
if (oClass.Get(intClass, "prod") != "1")
{
chk9.Checked = true;
img9.ImageUrl = "/images/cancel.gif";
chk10.Checked = true;
img10.ImageUrl = "/images/cancel.gif";
chk11.Checked = true;
img11.ImageUrl = "/images/cancel.gif";
}
boolDone = (chk1.Checked && chk3.Checked && chk4.Checked && chk5.Checked && chk6.Checked && chk7.Checked && chk8.Checked && chk9.Checked && chk10.Checked && chk11.Checked);
img1.ImageUrl = "/images/green_arrow.gif";
if (chk1.Checked == true)
{
btnExecute.Enabled = false;
img1.ImageUrl = "/images/check.gif";
img3.ImageUrl = "/images/green_arrow.gif";
chk3.Enabled = true;
Servers oServer = new Servers(intProfile, dsn);
DataSet dsAnswer = oServer.GetAnswer(intAnswer);
foreach (DataRow drAnswer in dsAnswer.Tables[0].Rows)
{
if (lbl1.Text != "")
{
lbl1.Text += "<br/>";
}
int intServer = Int32.Parse(drAnswer["id"].ToString());
int intServerName = Int32.Parse(drAnswer["nameid"].ToString());
ServerName oServerName = new ServerName(0, dsn);
string strName = oServer.GetName(intServer, boolUsePNCNaming);
lbl1.Text += "Server Name: " + strName + "<br/>";
Zeus oZeus = new Zeus(intProfile, dsnZeus);
DataSet dsZeus = oZeus.GetBuildServer(intServer);
if (dsZeus.Tables[0].Rows.Count > 0)
{
lbl1.Text += "Serial Number: " + dsZeus.Tables[0].Rows[0]["serial"].ToString() + "<br/>";
lbl1.Text += "Asset Tag: " + dsZeus.Tables[0].Rows[0]["asset"].ToString() + "<br/>";
}
int intDomain = Int32.Parse(drAnswer["domainid"].ToString());
Domains oDomain = new Domains(intProfile, dsn);
boolMove = (oDomain.Get(intDomain, "move") == "1");
if (boolMove == true)
{
lbl1.Text += "DHCP Address: " + drAnswer["dhcp"].ToString() + "<br/>";
}
int intIPAddress = 0;
IPAddresses oIPAddresses = new IPAddresses(0, dsnIP, dsn);
lbl1.Text += "Assigned IP Address: " + oServer.GetIPs(intServer, 1, 0, 0, dsnIP, "", "") + "<br/>";
lbl1.Text += "Final IP Address: " + oServer.GetIPs(intServer, 0, 1, 0, dsnIP, "", "") + "<br/>";
Asset oAsset = new Asset(intProfile, dsnAsset);
VMWare oVMWare = new VMWare(intProfile, dsn);
int intAsset = 0;
if (drAnswer["assetid"].ToString() != "")
{
intAsset = Int32.Parse(drAnswer["assetid"].ToString());
}
if (intAsset > 0)
{
DataSet dsGuest = oVMWare.GetGuest(strName);
if (dsGuest.Tables[0].Rows.Count > 0)
{
int intHost = Int32.Parse(dsGuest.Tables[0].Rows[0]["hostid"].ToString());
int intCluster = Int32.Parse(oVMWare.GetHost(intHost, "clusterid"));
int intFolder = Int32.Parse(oVMWare.GetCluster(intCluster, "folderid"));
int intDataCenter = Int32.Parse(oVMWare.GetFolder(intFolder, "datacenterid"));
lbl1.Text += "DataCenter: " + oVMWare.GetDatacenter(intDataCenter, "name") + "<br/>";
lbl1.Text += "Host: " + oVMWare.GetHost(intHost, "name") + "<br/>";
int intDatastore = Int32.Parse(dsGuest.Tables[0].Rows[0]["datastoreid"].ToString());
lbl1.Text += "DataStore: " + oVMWare.GetDatastore(intDatastore, "name") + "<br/>";
int intPool = Int32.Parse(dsGuest.Tables[0].Rows[0]["poolid"].ToString());
//lbl1.Text += "Pool: " + oVMWare.GetPool(intPool, "name") + "<br/>";
int intVlan = Int32.Parse(dsGuest.Tables[0].Rows[0]["vlanid"].ToString());
lbl1.Text += "VLAN: " + oVMWare.GetVlan(intVlan, "name") + "<br/>";
}
}
Storage oStorage = new Storage(intProfile, dsn);
int intCluster2 = Int32.Parse(drAnswer["clusterid"].ToString());
int intCSMConfig2 = Int32.Parse(drAnswer["csmconfigid"].ToString());
int intNumber2 = Int32.Parse(drAnswer["number"].ToString());
DataSet dsLuns = oStorage.GetLuns(intAnswer, 0, intCluster2, intCSMConfig2, intNumber2);
StringBuilder sbStorage = new StringBuilder();
int intRow = 0;
bool boolOverride = (oForecast.GetAnswer(intAnswer, "storage_override") == "1");
foreach (DataRow drLun in dsLuns.Tables[0].Rows)
{
intRow++;
sbStorage.Append("<tr>");
sbStorage.Append("<td>");
sbStorage.Append(intRow.ToString());
sbStorage.Append("</td>");
string strLetter = drLun["letter"].ToString();
if (strLetter == "")
{
if (drLun["driveid"].ToString() == "-1000")
{
strLetter = "E";
}
else if (drLun["driveid"].ToString() == "-100")
{
strLetter = "F";
}
else if (drLun["driveid"].ToString() == "-10")
{
strLetter = "P";
}
else if (drLun["driveid"].ToString() == "-1")
{
strLetter = "Q";
}
}
if ((boolOverride == true && drLun["driveid"].ToString() == "0") || oForecast.IsOSMidrange(intAnswer) == true)
{
sbStorage.Append("<td>");
sbStorage.Append(drLun["path"].ToString());
sbStorage.Append("</td>");
}
else
{
sbStorage.Append("<td>");
sbStorage.Append(strLetter);
sbStorage.Append(":");
sbStorage.Append(drLun["path"].ToString());
sbStorage.Append("</td>");
}
sbStorage.Append("<td>");
sbStorage.Append(drLun["performance"].ToString());
sbStorage.Append("</td>");
sbStorage.Append("<td>");
sbStorage.Append(drLun["size"].ToString());
sbStorage.Append(" GB</td>");
sbStorage.Append("<td class=\"required\">");
sbStorage.Append(drLun["actual_size"].ToString() == "-1" ? "Pending" : drLun["actual_size"].ToString() + " GB");
sbStorage.Append("</td>");
sbStorage.Append("<td>");
sbStorage.Append(drLun["size_qa"].ToString());
sbStorage.Append(" GB</td>");
sbStorage.Append("<td class=\"required\">");
sbStorage.Append(drLun["actual_size_qa"].ToString() == "-1" ? "Pending" : drLun["actual_size_qa"].ToString() + " GB");
sbStorage.Append("</td>");
sbStorage.Append("<td>");
sbStorage.Append(drLun["size_test"].ToString());
sbStorage.Append(" GB</td>");
sbStorage.Append("<td class=\"required\">");
sbStorage.Append(drLun["actual_size_test"].ToString() == "-1" ? "Pending" : drLun["actual_size_test"].ToString() + " GB");
sbStorage.Append("</td>");
sbStorage.Append("<td>");
sbStorage.Append(drLun["replicated"].ToString() == "0" ? "No" : "Yes");
sbStorage.Append("</td>");
sbStorage.Append("<td class=\"required\">");
sbStorage.Append(drLun["actual_replicated"].ToString() == "-1" ? "Pending" : (drLun["actual_replicated"].ToString() == "0" ? "No" : "Yes"));
sbStorage.Append("</td>");
sbStorage.Append("<td>");
sbStorage.Append(drLun["high_availability"].ToString() == "0" ? "No" : "Yes (" + drLun["size"].ToString() + " GB)");
sbStorage.Append("</td>");
sbStorage.Append("<td class=\"required\">");
sbStorage.Append(drLun["actual_high_availability"].ToString() == "-1" ? "Pending" : (drLun["actual_high_availability"].ToString() == "0" ? "No" : "Yes (" + drLun["actual_size"].ToString() + " GB)"));
sbStorage.Append("</td>");
sbStorage.Append("</tr>");
DataSet dsPoints = oStorage.GetMountPoints(Int32.Parse(drLun["id"].ToString()));
int intPoint = 0;
foreach (DataRow drPoint in dsPoints.Tables[0].Rows)
{
intRow++;
intPoint++;
sbStorage.Append("<tr>");
sbStorage.Append("<td>");
sbStorage.Append(intRow.ToString());
sbStorage.Append("</td>");
if (oForecast.IsOSMidrange(intAnswer) == true)
{
sbStorage.Append("<td>");
sbStorage.Append(drPoint["path"].ToString());
sbStorage.Append("</td>");
}
else
{
sbStorage.Append("<td>");
sbStorage.Append(strLetter);
sbStorage.Append(":\\SH");
sbStorage.Append(drLun["driveid"].ToString());
sbStorage.Append("VOL");
sbStorage.Append(intPoint < 10 ? "0" : "");
sbStorage.Append(intPoint.ToString());
sbStorage.Append("</td>");
}
sbStorage.Append("<td>");
sbStorage.Append(drPoint["performance"].ToString());
sbStorage.Append("</td>");
sbStorage.Append("<td>");
sbStorage.Append(drPoint["size"].ToString());
sbStorage.Append(" GB</td>");
sbStorage.Append("<td class=\"required\">");
sbStorage.Append(drPoint["actual_size"].ToString() == "-1" ? "Pending" : drPoint["actual_size"].ToString() + " GB");
sbStorage.Append("</td>");
sbStorage.Append("<td>");
sbStorage.Append(drPoint["size_qa"].ToString());
sbStorage.Append(" GB</td>");
sbStorage.Append("<td class=\"required\">");
sbStorage.Append(drPoint["actual_size_qa"].ToString() == "-1" ? "Pending" : drPoint["actual_size_qa"].ToString() + " GB");
sbStorage.Append("</td>");
sbStorage.Append("<td>");
sbStorage.Append(drPoint["size_test"].ToString());
sbStorage.Append(" GB</td>");
sbStorage.Append("<td class=\"required\">");
sbStorage.Append(drPoint["actual_size_test"].ToString() == "-1" ? "Pending" : drPoint["actual_size_test"].ToString() + " GB");
sbStorage.Append("</td>");
sbStorage.Append("<td>");
sbStorage.Append(drPoint["replicated"].ToString() == "0" ? "No" : "Yes");
sbStorage.Append("</td>");
sbStorage.Append("<td class=\"required\">");
sbStorage.Append(drPoint["actual_replicated"].ToString() == "-1" ? "Pending" : (drPoint["actual_replicated"].ToString() == "0" ? "No" : "Yes"));
sbStorage.Append("</td>");
sbStorage.Append("<td>");
sbStorage.Append(drPoint["high_availability"].ToString() == "0" ? "No" : "Yes (" + drPoint["size"].ToString() + " GB)");
sbStorage.Append("</td>");
sbStorage.Append("<td class=\"required\">");
sbStorage.Append(drPoint["actual_high_availability"].ToString() == "-1" ? "Pending" : (drPoint["actual_high_availability"].ToString() == "0" ? "No" : "Yes (" + drPoint["actual_size"].ToString() + " GB)"));
sbStorage.Append("</td>");
sbStorage.Append("</tr>");
}
}
if (sbStorage.ToString() != "")
{
sbStorage.Insert(0, "<tr class=\"bold\"><td></td><td>Path</td><td>Performance</td><td>Requested<br/>Size in Prod</td><td>Actual<br/>Size in Prod</td><td>Requested<br/>Size in QA</td><td>Actual<br/>Size in QA</td><td>Requested<br/>Size in Test</td><td>Actual<br/>Size in Test</td><td>Requested<br/>Replication</td><td>Actual<br/>Replication</td><td>Requested<br/>High Availability</td><td>Actual<br/>High Availability</td></tr>");
sbStorage.Insert(0, "<table width=\"100%\" cellpadding=\"2\" cellspacing=\"1\" border=\"0\">");
sbStorage.Append("</table>");
}
lbl1.Text += sbStorage.ToString();
}
}
if (chk3.Checked == true)
{
img3.ImageUrl = "/images/check.gif";
img4.ImageUrl = "/images/green_arrow.gif";
chk4.Enabled = true;
}
if (chk4.Checked == true)
{
img4.ImageUrl = "/images/check.gif";
if (boolMove == true)
{
img5.ImageUrl = "/images/green_arrow.gif";
chk5.Enabled = true;
}
else
{
chk5.Checked = true;
img7.ImageUrl = "/images/green_arrow.gif";
chk7.Enabled = true;
}
}
if (chk5.Checked == true)
{
if (boolMove == true)
{
img5.ImageUrl = "/images/check.gif";
}
else
{
img5.ImageUrl = "/images/cancel.gif";
}
if (boolMove == true)
{
img6.ImageUrl = "/images/green_arrow.gif";
chk6.Enabled = true;
}
}
if (chk6.Checked == true)
{
if (boolMove == true)
{
img6.ImageUrl = "/images/check.gif";
}
else
{
img6.ImageUrl = "/images/cancel.gif";
}
if (boolMove == true)
{
img7.ImageUrl = "/images/green_arrow.gif";
chk7.Enabled = true;
}
}
if (chk7.Checked == true)
{
img7.ImageUrl = "/images/check.gif";
img8.ImageUrl = "/images/green_arrow.gif";
chk8.Enabled = true;
}
if (chk8.Checked == true)
{
img8.ImageUrl = "/images/check.gif";
img9.ImageUrl = "/images/green_arrow.gif";
chk9.Enabled = true;
}
if (chk9.Checked == true)
{
img9.ImageUrl = "/images/check.gif";
img10.ImageUrl = "/images/green_arrow.gif";
chk10.Enabled = true;
}
if (chk10.Checked == true)
{
img10.ImageUrl = "/images/check.gif";
img11.ImageUrl = "/images/green_arrow.gif";
chk11.Enabled = true;
}
if (chk11.Checked == true)
{
img11.ImageUrl = "/images/check.gif";
}
}
if (Request.QueryString["div"] != null)
{
switch (Request.QueryString["div"])
{
case "E":
boolExecution = true;
break;
}
}
if (boolDetails == false && boolExecution == false)
{
boolDetails = true;
}
return(boolDone);
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oResourceRequest = new ResourceRequest(intProfile, dsn);
if (Request.QueryString["save"] != null)
{
lblUpdate.Visible = true;
}
if (!IsPostBack)
{
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
int intId = Int32.Parse(Request.QueryString["id"]);
DataSet ds = oResourceRequest.GetChangeControl(intId);
if (ds.Tables[0].Rows.Count > 0)
{
int intResourceWorkflow = Int32.Parse(ds.Tables[0].Rows[0]["parent"].ToString());
int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow);
int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid"));
int intRequest = Int32.Parse(oResourceRequest.Get(intResourceParent, "requestid"));
Requests oRequest = new Requests(intProfile, dsn);
ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn);
Projects oProject = new Projects(intProfile, dsn);
Users oUser = new Users(intProfile, dsn);
int intProject = oRequest.GetProjectNumber(intRequest);
if (intProject > 0)
{
panProject.Visible = true;
lblName.Text = oProject.Get(intProject, "name");
lblNumber.Text = oProject.Get(intProject, "number");
}
else
{
panTask.Visible = true;
lblTName.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "name");
lblTNumber.Text = "CVT" + intRequest.ToString();
}
lblImplementor.Text = oUser.GetFullName(intUser);
string strComments = ds.Tables[0].Rows[0]["comments"].ToString().Trim();
if (intProfile == intUser)
{
txtChange.Visible = true;
txtDate.Visible = true;
txtTime.Visible = true;
btnSubmit.Visible = true;
btnDelete.Visible = true;
txtComments.Visible = true;
txtChange.Text = ds.Tables[0].Rows[0]["number"].ToString();
txtDate.Text = DateTime.Parse(ds.Tables[0].Rows[0]["implementation"].ToString()).ToShortDateString();
txtTime.Text = DateTime.Parse(ds.Tables[0].Rows[0]["implementation"].ToString()).ToShortTimeString();
txtComments.Text = strComments;
btnSubmit.Attributes.Add("onclick", "return ValidateText('" + txtChange.ClientID + "','Please enter a change control number')" +
" && ValidateDate('" + txtDate.ClientID + "','Please enter a valid implementation date')" +
" && ValidateTime('" + txtTime.ClientID + "','Please enter a valid implementation time')" +
";");
btnDelete.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this change control?');");
}
else
{
lblChange.Visible = true;
lblDate.Visible = true;
lblTime.Visible = true;
panComments.Visible = true;
lblChange.Text = ds.Tables[0].Rows[0]["number"].ToString();
lblDate.Text = DateTime.Parse(ds.Tables[0].Rows[0]["implementation"].ToString()).ToLongDateString();
lblTime.Text = DateTime.Parse(ds.Tables[0].Rows[0]["implementation"].ToString()).ToLongTimeString();
if (strComments == "")
{
strComments = "<i>No additional information</i>";
}
lblComments.Text = strComments;
}
btnToday.Text += DateTime.Parse(ds.Tables[0].Rows[0]["implementation"].ToString()).ToShortDateString();
}
}
}
}
protected void btnSave_Click(Object Sender, EventArgs e)
{
int intResourceWorkflow = Int32.Parse(lblResourceWorkflow.Text);
int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow);
int intOldUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid"));
int intNewUser = Int32.Parse(ddlUser.SelectedItem.Value);
int intOldItem = Int32.Parse(oResourceRequest.Get(intResourceParent, "itemid"));
int intNewItem = Int32.Parse(ddlActivity.SelectedItem.Value);
int intNumber = Int32.Parse(oResourceRequest.Get(intResourceParent, "number"));
int intService = Int32.Parse(oResourceRequest.Get(intResourceParent, "serviceid"));
int intApp = oRequestItem.GetItemApplication(intNewItem);
int intRequest = Int32.Parse(oResourceRequest.Get(intResourceParent, "requestid"));
int intProject = oRequest.GetProjectNumber(intRequest);
int intRequester = oRequest.GetUser(intRequest);
int intStatus = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "status"));
Functions oFunction = new Functions(intProfile, dsn, intEnvironment);
strEMailIdsBCC = oFunction.GetGetEmailAlertsEmailIds("EMAILGRP_REQUEST_ASSIGNMENT");
if (intOldUser != intNewUser)
{
string strSpacerRow = "<tr><td colspan=\"3\"><img src=\"" + oVariable.ImageURL() + "/images/spacer.gif\" border=\"0\" width=\"1\" height=\"7\" /></td></tr>";
string strDefault = oUser.GetApplicationUrl(intNewUser, intWorkload);
// Notify Old User
// NOTIFICATION
oFunction.SendEmail("Request Assignment", oUser.GetName(intOldUser), "", strEMailIdsBCC, "Request Assignment", "<p><b>The following request has been removed from your workload</b><p><p>" + oResourceRequest.GetWorkflowSummary(intResourceWorkflow, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p>", true, false);
// Notify New User
if (strDefault == "")
{
oFunction.SendEmail("Request Assignment", oUser.GetName(intNewUser), "", strEMailIdsBCC, "Request Assignment", "<p><b>The following request has been re-assigned to you by " + oUser.GetFullName(intProfile) + "</b><p><p>" + oResourceRequest.GetWorkflowSummary(intResourceWorkflow, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p>", true, false);
}
else
{
if (intProject > 0)
{
oFunction.SendEmail("Request Assignment", oUser.GetName(intNewUser), "", strEMailIdsBCC, "Request Assignment", "<p><b>The following request has been re-assigned to you by " + oUser.GetFullName(intProfile) + "</b><p><p>" + oResourceRequest.GetWorkflowSummary(intResourceWorkflow, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p><p><a href=\"" + oVariable.URL() + "/redirect.aspx?referrer=/" + strDefault + oPage.GetFullLink(intWorkload) + "?pid=" + intProject.ToString() + "\" target=\"_blank\">Click here to review your new assignment.</a></p>", true, false);
}
else
{
oFunction.SendEmail("Request Assignment", oUser.GetName(intNewUser), "", strEMailIdsBCC, "Request Assignment", "<p><b>The following request has been re-assigned to you by " + oUser.GetFullName(intProfile) + "</b><p><p>" + oResourceRequest.GetWorkflowSummary(intResourceWorkflow, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p><p><a href=\"" + oVariable.URL() + "/redirect.aspx?referrer=/frame/resource_request.aspx?rrid=" + intResourceWorkflow.ToString() + "\" target=\"_blank\">Click here to review your new assignment.</a></p>", true, false);
}
}
string strActivity = "<tr><td><b>Resource:</b></td><td> </td><td>" + oUser.GetFullName(intNewUser) + "</td></tr>";
strActivity += strSpacerRow;
strActivity += "<tr><td><b>Activity Type:</b></td><td> </td><td>" + oService.GetName(intService) + "</td></tr>";
strActivity = "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"" + oVariable.DefaultFontStyle() + "\">" + strActivity + "</table>";
string strDeliverable = oApplication.Get(intApp, "deliverables_doc");
if (strDeliverable.Trim() != "")
{
strDeliverable = "<p><a href=\"" + oVariable.URL() + strDeliverable + "\">Click here to view the service deliverables</a></p>";
}
// if (oService.Get(intService, "notify_client") != "0")
// oFunction.SendEmail("Request Assignment", oUser.GetName(intRequester), "", strBCC, "Request Assignment", "<p><b>A resource has been assigned to the following request...</b><p><p>" + oResourceRequest.GetWorkflowSummary(intResourceWorkflow, intEnvironment, dsnServiceEditor) + "</p><p>" + strActivity + "</p>" + strDeliverable, true, false);
}
oResourceRequest.UpdateWorkflow(intResourceWorkflow, Int32.Parse(txtDevices.Text), double.Parse(txtAllocated.Text), (chkOpen.Checked ? 2 : intStatus));
oResourceRequest.UpdateWorkflowAssigned(intResourceWorkflow, intNewUser);
oResourceRequest.UpdateItemAndService(intResourceParent, intNewItem, intService);
if (chkOpen.Checked == true && intProject > 0)
{
oProject.Update(intProject, 2);
}
Response.Redirect(Request.Path + "?rrid=" + intResourceWorkflow.ToString() + "&save=true");
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oProject = new Projects(intProfile, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oUser = new Users(intProfile, dsn);
oPage = new Pages(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oRequestItem = new RequestItems(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oService = new Services(intProfile, dsn);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oRequestField = new RequestFields(intProfile, dsn);
oApplication = new Applications(intProfile, dsn);
oServiceDetail = new ServiceDetails(intProfile, dsn);
oDelegate = new Delegates(intProfile, dsn);
oCustomized = new Customized(intProfile, dsn);
oVariable = new Variables(intEnvironment);
oClass = new Classes(intProfile, dsn);
oEnvironment = new Environments(intProfile, dsn);
oLocation = new Locations(intProfile, dsn);
if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "")
{
intApplication = Int32.Parse(Request.QueryString["applicationid"]);
}
if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "")
{
intPage = Int32.Parse(Request.QueryString["pageid"]);
}
if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "")
{
intApplication = Int32.Parse(Request.Cookies["application"].Value);
}
if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "")
{
// Start Workflow Change
lblResourceWorkflow.Text = Request.QueryString["rrid"];
int intResourceWorkflow = Int32.Parse(Request.QueryString["rrid"]);
int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow);
ds = oResourceRequest.Get(intResourceParent);
// End Workflow Change
intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
lblRequestedBy.Text = oUser.GetFullName(oRequest.GetUser(intRequest));
lblRequestedOn.Text = DateTime.Parse(oResourceRequest.Get(intResourceParent, "created")).ToString();
intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString());
intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString());
// Start Workflow Change
bool boolComplete = (oResourceRequest.GetWorkflow(intResourceWorkflow, "status") == "3");
int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid"));
txtCustom.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "name");
double dblAllocated = double.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated"));
// End Workflow Change
intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString());
lblService.Text = oService.Get(intService, "name");
int intApp = oRequestItem.GetItemApplication(intItem);
if (Request.QueryString["save"] != null && Request.QueryString["save"] != "")
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "saved", "<script type=\"text/javascript\">alert('Information Saved Successfully');<" + "/" + "script>");
}
if (Request.QueryString["status"] != null && Request.QueryString["status"] != "")
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "statusd", "<script type=\"text/javascript\">alert('Status Updates has been Added');<" + "/" + "script>");
}
if (!IsPostBack)
{
double dblUsed = oResourceRequest.GetWorkflowUsed(intResourceWorkflow);
lblUpdated.Text = oResourceRequest.GetUpdated(intResourceWorkflow);
if (dblAllocated == dblUsed)
{
if (boolComplete == false)
{
oFunction.ConfigureToolButton(btnComplete, "/images/tool_complete");
btnComplete.Attributes.Add("onclick", "return confirm('Are you sure you want to mark this as completed and remove it from your workload?');");
}
else
{
oFunction.ConfigureToolButton(btnComplete, "/images/tool_complete");
btnComplete.Attributes.Add("onclick", "alert('This task has already been marked COMPLETE. You can close this window.');return false;");
}
panComplete.Visible = true;
}
else
{
btnComplete.ImageUrl = "/images/tool_complete_dbl.gif";
btnComplete.Enabled = false;
}
dblUsed = (dblUsed / dblAllocated) * 100;
intProject = oRequest.GetProjectNumber(intRequest);
hdnTab.Value = "D";
panWorkload.Visible = true;
LoadStatus(intResourceWorkflow);
LoadInformation(intResourceWorkflow);
LoadDetails();
btnDenied.Attributes.Add("onclick", "return CloseWindow();");
oFunction.ConfigureToolButton(btnSave, "/images/tool_save");
oFunction.ConfigureToolButton(btnPrint, "/images/tool_print");
btnPrint.Attributes.Add("onclick", "return PrintWindow();");
oFunction.ConfigureToolButton(btnClose, "/images/tool_close");
btnClose.Attributes.Add("onclick", "return ExitWindow();");
btnSave.Attributes.Add("onclick", "return ValidateNumber0('" + txtAmount.ClientID + "','Please enter the total amount of storage')" +
" && ValidateStatus('" + ddlStatus.ClientID + "','" + txtComments.ClientID + "')" +
";");
// 6/1/2009 - Load ReadOnly View
if (oResourceRequest.CanUpdate(intProfile, intResourceWorkflow, false) == false)
{
oFunction.ConfigureToolButtonRO(btnSave, btnComplete);
//panDenied.Visible = true;
}
}
}
else
{
panDenied.Visible = true;
}
}
private void LoadInformation(int _request)
{
lblView.Text = oEnhancement.GetBody(intID, intEnvironment);
if (intProject > 0)
{
lblName.Text = oProject.Get(intProject, "name");
lblNumber.Text = oProject.Get(intProject, "number");
lblType.Text = "Project";
}
else
{
lblName.Text = oResourceRequest.GetWorkflow(_request, "name");
lblNumber.Text = "CVT" + intRequest.ToString();
lblType.Text = "Task";
}
int intMenuTab = 0;
if (Request.QueryString["menu_tab"] != null && Request.QueryString["menu_tab"] != "")
{
intMenuTab = Int32.Parse(Request.QueryString["menu_tab"]);
}
Tab oTab = new Tab(hdnTab.ClientID, intMenuTab, "divMenu1", true, false);
oTab.AddTab("Enhancement Details", "");
oTab.AddTab("Execution", "");
int intStep = 1;
DataSet dsSteps = oEnhancement.GetSteps(intID, 0, 0);
if (dsSteps.Tables[0].Rows.Count > 0)
{
intStep = Int32.Parse(dsSteps.Tables[0].Rows[0]["step"].ToString());
}
intStep = LoadStep(1, intStep, img1, null, tr1, tr1Done, lbl1, dsSteps);
intStep = LoadStep(2, intStep, img2, tr2Wait, tr2, tr2Done, lbl2, dsSteps);
intStep = LoadStep(3, intStep, img3, tr3Wait, tr3, tr3Done, lbl3, dsSteps);
intStep = LoadStep(4, intStep, img4, tr4Wait, tr4, tr4Done, lbl4, dsSteps);
intStep = LoadStep(5, intStep, img5, tr5Wait, tr5, tr5Done, lbl5, dsSteps);
intStep = LoadStep(6, intStep, img6, tr6Wait, tr6, tr6Done, lbl6, dsSteps);
DataSet dsDocuments = oEnhancement.GetDocuments(intID);
// Step # 1
switch (intStep)
{
case 1:
btnSave.Attributes.Add("onclick", "return (document.getElementById('" + chk1.ClientID + "').checked == true)" +
" || (document.getElementById('" + chk1.ClientID + "').checked == false" +
" && ValidateText('" + filFunctional.ClientID + "','Select a functional requirement document')" +
" && ValidateNumber0('" + txtDays.ClientID + "','Enter a valid number for the estimated date range')" +
" && ValidateRadioList('" + radEstimate.ClientID + "','Make a selection for your estimated release date')" +
") && ProcessControlButton() && LoadWait()" +
";");
break;
case 2:
rptApprovers.DataSource = oEnhancement.GetApprovalResults(intID, intStep);
rptApprovers.DataBind();
lblApprovers.Visible = (rptApprovers.Items.Count == 0);
btnApprovalGroup.Attributes.Add("onclick", "return OpenWindow('ENHANCEMENT_APPROVAL_GROUPS','?enhancementid=" + intID.ToString() + "&step=" + intStep.ToString() + "');");
break;
case 3:
if (dsDocuments.Tables[0].Rows.Count > 0)
{
lblEstimate.Text = dsDocuments.Tables[0].Rows[0]["release"].ToString();
}
;
radEstimateYes.Attributes.Add("onclick", "ShowHideDiv('" + divEstimate.ClientID + "','none');");
radEstimateNo.Attributes.Add("onclick", "ShowHideDiv('" + divEstimate.ClientID + "','inline');");
btnSave.Attributes.Add("onclick", "return ValidateRadioButtons('" + radEstimateYes.ClientID + "','" + radEstimateNo.ClientID + "','Select whether or not the estimated release date is OK')" +
" && (document.getElementById('" + radEstimateYes.ClientID + "').checked == true || (document.getElementById('" + radEstimateNo.ClientID + "').checked == true && ValidateRadioList('" + radRelease.ClientID + "','Make a selection for your estimated release date')))" +
" && ProcessControlButton() && LoadWait()" +
";");
break;
}
strMessages = oEnhancement.GetMessages(intID, false, "#E1FFE1");
oTab.AddTab("Message Thread (" + oEnhancement.GetMessages(intID).Tables[0].Rows.Count.ToString() + ")", "");
rptDocuments.DataSource = dsDocuments;
rptDocuments.DataBind();
lblDocuments.Visible = (rptDocuments.Items.Count == 0);
foreach (RepeaterItem ri in rptDocuments.Items)
{
LinkButton _delete = (LinkButton)ri.FindControl("btnDeleteDocument");
_delete.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this document?');");
}
oTab.AddTab("Functional Requirements Documentation (" + rptDocuments.Items.Count.ToString() + ")", "");
oTab.AddTab("Log (" + oEnhancement.LoadLog(intID, rptLog, lblLog) + ")", "");
oTab.AddTab("Release Notes", "");
strMenuTab1 = oTab.GetTabs();
}
protected void LoadSearch(int _search)
{
Search oSearch = new Search(intProfile, dsn);
RequestItems oRequestItem = new RequestItems(intProfile, dsn);
Services oService = new Services(intProfile, dsn);
Applications oApplication = new Applications(intProfile, dsn);
StatusLevels oStatusLevel = new StatusLevels();
Users oUser = new Users(intProfile, dsn);
Projects oProject = new Projects(intProfile, dsn);
ResourceRequest oResourceRequest = new ResourceRequest(intProfile, dsn);
ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn);
DataSet ds = oSearch.GetProject(_search);
int intApplication = 0;
if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "")
{
intApplication = Int32.Parse(Request.QueryString["applicationid"]);
}
if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "")
{
intApplication = Int32.Parse(Request.Cookies["application"].Value);
}
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["userid"].ToString() == intProfile.ToString())
{
string strType = ds.Tables[0].Rows[0]["type"].ToString();
string strClause = "cv_projects.deleted = 0 AND cv_projects.number NOT LIKE 'CV%' AND cv_projects.number NOT LIKE 'EPS%'";
string strOr1 = "";
string strOr2 = "";
string strSQL = "SELECT DISTINCT '?pid=' + CAST(cv_projects.projectid AS varchar(10)) + '&sid=" + _search.ToString() + "' AS query, cv_projects.name, cv_projects.number, cv_projects.status, cv_projects.modified FROM cv_projects INNER JOIN cv_requests LEFT OUTER JOIN cv_service_requests ON cv_service_requests.requestid = cv_requests.requestid AND cv_service_requests.deleted = 0 LEFT OUTER JOIN cv_project_requests ON cv_project_requests.requestid = cv_requests.requestid AND cv_project_requests.deleted = 0 INNER JOIN cv_resource_requests INNER JOIN cv_request_items INNER JOIN cv_applications ON cv_request_items.applicationid = cv_applications.applicationid AND cv_applications.deleted = 0 ON cv_request_items.itemid = cv_resource_requests.itemid AND cv_request_items.deleted = 0 INNER JOIN cv_users ON cv_resource_requests.userid = cv_users.userid AND cv_users.deleted = 0 AND cv_users.enabled = 1 ON cv_requests.requestid = cv_resource_requests.requestid AND cv_resource_requests.deleted = 0 ON cv_requests.projectid = cv_projects.projectid AND cv_requests.deleted = 0 WHERE ";
string strApplication = " AND cv_request_items.applicationid = " + intApplication.ToString();
switch (strType)
{
case "O":
strApplication = "";
string strOName = ds.Tables[0].Rows[0]["oname"].ToString().Trim();
string strONumber = ds.Tables[0].Rows[0]["onumber"].ToString().Trim();
if (strONumber != "")
{
strClause += " AND cv_projects.number LIKE '%" + strONumber + "%'";
lblResults.Text = "Project Number LIKE "" + strONumber + """;
}
else
{
strClause += " AND cv_projects.name LIKE '%" + strOName + "%'";
lblResults.Text = "Project Name LIKE "" + strOName + """;
}
string strOStatus = ds.Tables[0].Rows[0]["ostatus"].ToString();
if (strOStatus != "0")
{
strClause += " AND cv_projects.status = " + strOStatus;
if (lblResults.Text != "")
{
lblResults.Text += " AND ";
}
lblResults.Text += "Status = "" + oStatusLevel.Name(Int32.Parse(strOStatus)) + """;
}
string strOStart = ds.Tables[0].Rows[0]["ostart"].ToString();
if (strOStart != "")
{
strOStart = DateTime.Parse(strOStart).ToShortDateString();
strClause += " AND cv_projects.modified > " + strOStart;
if (lblResults.Text != "")
{
lblResults.Text += " AND ";
}
lblResults.Text += "Project Date > "" + strOStart + """;
}
string strOEnd = ds.Tables[0].Rows[0]["oend"].ToString();
if (strOEnd != "")
{
strOEnd = DateTime.Parse(strOEnd).ToShortDateString();
strClause += " AND cv_projects.modified < " + strOEnd;
if (lblResults.Text != "")
{
lblResults.Text += " AND ";
}
lblResults.Text += "Project Date < "" + strOEnd + """;
}
break;
case "P":
string strDepartment = ds.Tables[0].Rows[0]["department"].ToString();
if (strDepartment == "0")
{
strApplication = "";
lblResults.Text += "Department = "ALL"";
}
else
{
strApplication = " AND cv_request_items.applicationid = " + strDepartment;
lblResults.Text += "Department = "" + oApplication.GetName(Int32.Parse(strDepartment)) + """;
}
string strDStatus = ds.Tables[0].Rows[0]["dstatus"].ToString();
if (strDStatus != "0")
{
strClause += " AND cv_resource_requests.status = " + strDStatus;
if (lblResults.Text != "")
{
lblResults.Text += " AND ";
}
lblResults.Text += "Status = "" + oStatusLevel.Name(Int32.Parse(strDStatus)) + """;
}
string strDStart = ds.Tables[0].Rows[0]["dstart"].ToString();
if (strDStart != "")
{
strDStart = DateTime.Parse(strDStart).ToShortDateString();
strClause += " AND cv_requests.modified > " + strDStart;
if (lblResults.Text != "")
{
lblResults.Text += " AND ";
}
lblResults.Text += "Request Date > "" + strDStart + """;
}
string strDEnd = ds.Tables[0].Rows[0]["dend"].ToString();
if (strDEnd != "")
{
strDEnd = DateTime.Parse(strDEnd).ToShortDateString();
strClause += " AND cv_requests.modified < " + strDEnd;
if (lblResults.Text != "")
{
lblResults.Text += " AND ";
}
lblResults.Text += "Request Date < "" + strDEnd + """;
}
break;
case "T":
string strTechnician = ds.Tables[0].Rows[0]["technician"].ToString();
if (strTechnician != "0")
{
strClause += " AND cv_resource_requests.userid = " + strTechnician;
lblResults.Text += "Technician = "" + oUser.GetFullName(Int32.Parse(strTechnician)) + """;
}
string strTStatus = ds.Tables[0].Rows[0]["tstatus"].ToString();
if (strTStatus != "0")
{
strClause += " AND cv_resource_requests.status = " + strTStatus;
if (lblResults.Text != "")
{
lblResults.Text += " AND ";
}
lblResults.Text += "Status = "" + oStatusLevel.Name(Int32.Parse(strTStatus)) + """;
}
string strTStart = ds.Tables[0].Rows[0]["tstart"].ToString();
if (strTStart != "")
{
strTStart = DateTime.Parse(strTStart).ToShortDateString();
strClause += " AND cv_requests.modified > " + strTStart;
if (lblResults.Text != "")
{
lblResults.Text += " AND ";
}
lblResults.Text += "Request Date > "" + strTStart + """;
}
string strTEnd = ds.Tables[0].Rows[0]["tend"].ToString();
if (strTEnd != "")
{
strTEnd = DateTime.Parse(strTEnd).ToShortDateString();
strClause += " AND cv_requests.modified < " + strTEnd;
if (lblResults.Text != "")
{
lblResults.Text += " AND ";
}
lblResults.Text += "Request Date < "" + strTEnd + """;
}
break;
case "L":
string strLead = ds.Tables[0].Rows[0]["lead"].ToString();
if (strLead != "0")
{
int intLead = Int32.Parse(strLead);
strClause += " AND cv_users.manager = " + intLead.ToString();
lblResults.Text += "Team Lead = "" + oUser.GetFullName(intLead) + """;
}
string strLStatus = ds.Tables[0].Rows[0]["lstatus"].ToString();
if (strLStatus != "0")
{
strClause += " AND cv_resource_requests.status = " + strLStatus;
if (lblResults.Text != "")
{
lblResults.Text += " AND ";
}
lblResults.Text += "Status = "" + oStatusLevel.Name(Int32.Parse(strLStatus)) + """;
}
string strLStart = ds.Tables[0].Rows[0]["lstart"].ToString();
if (strLStart != "")
{
strLStart = DateTime.Parse(strLStart).ToShortDateString();
strClause += " AND cv_requests.modified > " + strLStart;
if (lblResults.Text != "")
{
lblResults.Text += " AND ";
}
lblResults.Text += "Request Date < "" + strLStart + """;
}
string strLEnd = ds.Tables[0].Rows[0]["lend"].ToString();
if (strLEnd != "")
{
strLEnd = DateTime.Parse(strLEnd).ToShortDateString();
strClause += " AND cv_requests.modified < " + strLEnd;
if (lblResults.Text != "")
{
lblResults.Text += " AND ";
}
lblResults.Text += "Request Date > "" + strLEnd + """;
}
break;
case "G":
string strItem = ds.Tables[0].Rows[0]["itemid"].ToString();
if (strItem != "0")
{
strClause += " AND cv_resource_requests.itemid = " + strItem;
lblResults.Text += "Activity Type = "" + oRequestItem.GetItemName(Int32.Parse(strItem)) + """;
}
string strGStatus = ds.Tables[0].Rows[0]["gstatus"].ToString();
if (strGStatus != "0")
{
strClause += " AND cv_resource_requests.status = " + strGStatus;
if (lblResults.Text != "")
{
lblResults.Text += " AND ";
}
lblResults.Text += "Status = "" + oStatusLevel.Name(Int32.Parse(strGStatus)) + """;
}
string strGStart = ds.Tables[0].Rows[0]["gstart"].ToString();
if (strGStart != "")
{
strGStart = DateTime.Parse(strGStart).ToShortDateString();
strClause += " AND cv_requests.modified > " + strGStart;
if (lblResults.Text != "")
{
lblResults.Text += " AND ";
}
lblResults.Text += "Request Date < "" + strGStart + """;
}
string strGEnd = ds.Tables[0].Rows[0]["gend"].ToString();
if (strGEnd != "")
{
strGEnd = DateTime.Parse(strGEnd).ToShortDateString();
strClause += " AND cv_requests.modified < " + strGEnd;
if (lblResults.Text != "")
{
lblResults.Text += " AND ";
}
lblResults.Text += "Request Date > "" + strGEnd + """;
}
break;
case "S":
break;
}
strClause = strClause + strApplication;
if (strOr1 != "" && strOr2 != "")
{
strClause = strClause + " AND " + strOr1 + " AND cv_project_requests.id IS NOT NULL OR " + strClause + " AND " + strOr1 + " AND cv_service_requests.id IS NOT NULL OR " + strClause + " AND " + strOr2 + " AND cv_project_requests.id IS NOT NULL OR " + strClause + " AND " + strOr2 + " AND cv_service_requests.id IS NOT NULL";
}
else
{
strClause = strClause + " AND cv_project_requests.id IS NOT NULL OR " + strClause + " AND cv_service_requests.id IS NOT NULL";
}
ds = SqlHelper.ExecuteDataset(dsn, CommandType.Text, strSQL + strClause);
DataView dv = ds.Tables[0].DefaultView;
if (Request.QueryString["sort"] != null)
{
dv.Sort = Request.QueryString["sort"];
}
rptView.DataSource = dv;
rptView.DataBind();
foreach (RepeaterItem ri in rptView.Items)
{
Label _progress = (Label)ri.FindControl("lblProgress");
Label _status = (Label)ri.FindControl("lblStatus");
_status.Text = oStatusLevel.HTML(Int32.Parse(_status.Text));
Label _updated = (Label)ri.FindControl("lblUpdated");
Label _number = (Label)ri.FindControl("lblNumber");
if (_number.Text == "")
{
_number.Text = "<i>TBD...</i>";
}
double dblUsed = 0.00;
double dblAllocated = 0.00;
if (_progress.Text.Contains("?pid=") == true)
{
int intProject = 0;
if (Request.QueryString["sid"] != null && Request.QueryString["sid"] != "")
{
string strProgress = _progress.Text.Substring(0, _progress.Text.IndexOf("&"));
intProject = Int32.Parse(strProgress.Substring(5));
}
else
{
intProject = Int32.Parse(_progress.Text.Substring(5));
}
_updated.Text = oProject.GetLastUpdated(intProject);
DataSet dsAll = oResourceRequest.GetWorkflowProject(intProject);
foreach (DataRow drAll in dsAll.Tables[0].Rows)
{
int intResourceWorkflow = Int32.Parse(drAll["id"].ToString());
dblAllocated += double.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated"));
dblUsed += oResourceRequest.GetWorkflowUsed(intResourceWorkflow);
}
}
else if (_progress.Text.Contains("?rid=") == true)
{
int intRequest = Int32.Parse(_progress.Text.Substring(5));
DataSet dsAll = oResourceRequest.GetWorkflowRequestAll(intRequest);
foreach (DataRow drAll in dsAll.Tables[0].Rows)
{
int intResourceWorkflow = Int32.Parse(drAll["id"].ToString());
dblAllocated += double.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated"));
dblUsed += oResourceRequest.GetWorkflowUsed(intResourceWorkflow);
}
}
double dblProgress = 0.00;
if (dblAllocated > 0.00)
{
dblProgress = (dblUsed / dblAllocated) * 100.00;
}
_progress.Text = oServiceRequest.GetStatusBar(dblProgress, "100", "6", true);
}
lblNone.Visible = (rptView.Items.Count == 0);
}
}
}
private void LoadInformation(int _request)
{
StringBuilder sb = new StringBuilder();
Reports oReport = new Reports(intProfile, dsn);
Variables oVariable = new Variables(intEnvironment);
ds = oReport.GetOrderReport(intRequest, intItem, intNumber);
sb.Append("<table width=\"100%\" cellpadding=\"2\" cellspacing=\"3\" border=\"0\">");
if (ds.Tables[0].Rows.Count > 0)
{
sb.Append("<tr><td valign=\"top\"><b>Title: </b></td>");
sb.Append("<td>");
sb.Append(ds.Tables[0].Rows[0]["title"]);
sb.Append("</td></tr>");
sb.Append("<tr><td valign=\"top\"><b>Data Source: </b></td>");
sb.Append("<td>");
sb.Append(ds.Tables[0].Rows[0]["data_source"]);
sb.Append("</td></tr>");
sb.Append("<tr><td valign=\"top\"><b>Chart Type: </b></td>");
sb.Append("<td>");
sb.Append(ds.Tables[0].Rows[0]["chart_type"]);
sb.Append("</td></tr>");
sb.Append("<tr><td valign=\"top\"><b>Report Upload: </b></td>");
if ((string)ds.Tables[0].Rows[0]["report_upload"] != DBNull.Value.ToString())
{
sb.Append("<td><a href=\"");
sb.Append(oVariable.URL());
sb.Append("/");
sb.Append(ds.Tables[0].Rows[0]["report_upload"]);
sb.Append("\" target=\"_blank\">Click here to view the document</a></td></tr>");
}
sb.Append("<tr><td valign=\"top\"><b>Instructions: </b></td>");
sb.Append("<td>");
sb.Append(ds.Tables[0].Rows[0]["instructions"]);
sb.Append("</td></tr>");
sb.Append("<tr><td valign=\"top\"><b>Data Exclusion: </b></td>");
sb.Append("<td>");
sb.Append(ds.Tables[0].Rows[0]["data_exclusion"]);
sb.Append("</td></tr>");
int intId = Int32.Parse(ds.Tables[0].Rows[0]["id"].ToString());
DataSet ds2 = oReport.GetOrderReportDataFields(intId);
DataSet ds3 = oReport.GetOrderReportCalculations(intId);
DataSet ds4 = oReport.GetOrderReportApplications(intId);
sb.Append("<tr><td valign=\"top\"><b>Data Fields:</b></td>");
sb.Append("<td colspan=\"2\"><table width=\"50%\" cellpadding=\"2\" cellspacing=\"0\">");
sb.Append("<tr bgcolor=\"#EEEEEE\"><td><b>Field Name</b></td><td><b>Field Type</b></td></tr>");
string strRep1 = "";
foreach (DataRow dr in ds2.Tables[0].Rows)
{
strRep1 += "<tr><td>" + dr["name"] + "</td><td>" + dr["type"] + "</td></tr>";
}
if (strRep1 == "")
{
sb.Append("<tr><td colspan=\"2\"><img src=\"/images/alert.gif\" border=\"0\" align=\"absmiddle\"> There are no items </td></tr></table></td></tr>");
}
else
{
sb.Append(strRep1);
sb.Append("</table></td></tr>");
}
sb.Append("<tr><td valign=\"top\"><b>Calculations:</b></td>");
sb.Append("<td colspan=\"2\"><table width=\"50%\" cellpadding=\"2\" cellspacing=\"0\">");
sb.Append("<tr bgcolor=\"#EEEEEE\"><td><b>Field Name</b></td><td><b>Formula</b></td></tr>");
string strRep2 = "";
foreach (DataRow dr in ds3.Tables[0].Rows)
{
strRep2 += "<tr><td>" + dr["name"] + "</td><td>" + dr["formula"] + "</td></tr>";
}
if (strRep2 == "")
{
sb.Append("<tr><td colspan=\"2\"><img src=\"/images/alert.gif\" border=\"0\" align=\"absmiddle\"> There are no items </td></tr></table></td></tr>");
}
else
{
sb.Append(strRep2);
sb.Append("</table></td></tr>");
}
sb.Append("<tr><td valign=\"top\"><b>Who can view this report?:</b></td><td><span>");
foreach (DataRow dr in ds4.Tables[0].Rows)
{
sb.Append(dr["appname"]);
sb.Append("; <br>");
}
sb.Append("</span></td></tr>");
}
sb.Append("</table>");
strView = sb.ToString();
if (intProject > 0)
{
lblName.Text = oProject.Get(intProject, "name");
lblNumber.Text = oProject.Get(intProject, "number");
lblType.Text = "Project";
}
else
{
lblName.Text = oResourceRequest.GetWorkflow(_request, "name");
lblNumber.Text = "CVT" + intRequest.ToString();
lblType.Text = "Task";
}
if (Request.QueryString["div"] != null)
{
switch (Request.QueryString["div"])
{
case "E":
boolExecution = true;
break;
case "C":
boolChange = true;
break;
case "X":
boolExtension = true;
break;
}
}
if (boolDetails == false && boolExecution == false && boolChange == false && boolExtension == false)
{
boolDetails = true;
}
}
protected void btnConfidenceUnlock_Click(Object Sender, EventArgs e)
{
Encryption oEncryption = new Encryption();
string strEMailIdsBCC = oFunction.GetGetEmailAlertsEmailIds("EMAILGRP_DESIGN_BUILDER");
string strDate = DateTime.Today.Month.ToString() + DateTime.Today.Day.ToString() + DateTime.Today.Year.ToString();
if (txtConfidenceUnlock.Text == oEncryption.Encrypt(lblConfidenceUnlock.Text + strDate, "UNLOCK_100"))
{
if (oForecast.GetAnswer(intID, "override") == "-1")
{
// Send Email to iARB stating that they do not have to approve the design
string[] strEmail;
char[] strSplit = { ';' };
strEmail = strIARB.Split(strSplit);
for (int ii = 0; ii < strEmail.Length; ii++)
{
if (strEmail[ii].Trim() != "")
{
string strAddress = strEmail[ii];
oFunction.SendEmail("Review Board Approval UNLOCKED", strAddress, "", strEMailIdsBCC, "Review Board Approval UNLOCKED", "<p><b>An overridden design has been unlocked and no longer requires your approval.</b><p><p>" + oForecast.GetAnswerBody(intID, intEnvironment, dsnAsset, dsnIP) + "</p>", true, false);
}
}
}
oForecast.AddAnswerUnlock(intID, intProfile, txtConfidenceReason.Text);
oForecast.UpdateAnswerConfidence(intID, intConfidenceUnlock);
int intForecast = Int32.Parse(oForecast.GetAnswer(intID, "forecastid"));
int intRequest = Int32.Parse(oForecast.Get(intForecast, "requestid"));
Requests oRequest = new Requests(0, dsn);
int intProject = oRequest.GetProjectNumber(intRequest);
OnDemandTasks oOnDemandTasks = new OnDemandTasks(0, dsn);
ResourceRequest oResourceRequest = new ResourceRequest(0, dsn);
Variables oVariable = new Variables(intEnvironment);
Projects oProject = new Projects(0, dsn);
DataSet ds = oOnDemandTasks.GetPending(intID);
foreach (DataRow dr in ds.Tables[0].Rows)
{
int intResourceWorkflow = Int32.Parse(dr["resourceid"].ToString());
int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow);
int intImplementor = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid"));
oResourceRequest.UpdateItemAndService(intResourceParent, -1, -1);
oResourceRequest.UpdateName(intResourceParent, "Provisioning Task [Unlocked]");
string strDefault = oUser.GetApplicationUrl(intImplementor, intViewPage);
string strSpacerRow = "<tr><td colspan=\"3\"><img src=\"" + oVariable.ImageURL() + "/images/spacer.gif\" border=\"0\" width=\"1\" height=\"7\" /></td></tr>";
string strCC = "";
Delegates oDelegate = new Delegates(0, dsn);
DataSet dsDelegates = oDelegate.Gets(intImplementor);
foreach (DataRow drDelegate in dsDelegates.Tables[0].Rows)
{
strCC += oUser.GetName(Int32.Parse(drDelegate["delegate"].ToString())) + ";";
}
if (strDefault == "")
{
oFunction.SendEmail("ClearView Provisioning Task Unlocked", oUser.GetName(intImplementor), strCC, strEMailIdsBCC, "ClearView Provisioning Task Unlocked", "<p><b>A provisioning request has been unlocked. This request no longer requires you to take action.</b><p><p>" + oProject.GetBody(intProject, intEnvironment, false) + "</p>", true, false);
}
else
{
oFunction.SendEmail("ClearView Provisioning Task Unlocked", oUser.GetName(intImplementor), strCC, strEMailIdsBCC, "ClearView Provisioning Task Unlocked", "<p><b>A provisioning request has been unlocked. This request no longer requires you to take action.</b><p><p>" + oProject.GetBody(intProject, intEnvironment, false) + "</p><p><a href=\"" + oVariable.URL() + "/redirect.aspx?referrer=/" + strDefault + oPage.GetFullLink(intViewPage) + "?pid=" + intProject.ToString() + "\" target=\"_blank\">Click here to review this project.</a></p>", true, false);
}
}
oOnDemandTasks.DeleteAll(intID);
Response.Redirect(Request.Path + "?id=" + intID.ToString());
}
else
{
Response.Redirect(Request.Path + "?id=" + intID.ToString() + "&unlock=true");
}
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oProject = new Projects(intProfile, dsn);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oOrganization = new Organizations(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oRequestItem = new RequestItems(intProfile, dsn);
oService = new Services(intProfile, dsn);
oPage = new Pages(intProfile, dsn);
oVariable = new Variables(intEnvironment);
oApplication = new Applications(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oUser = new Users(intProfile, dsn);
if (Request.QueryString["action"] != null && Request.QueryString["action"] != "")
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "saved", "<script type=\"text/javascript\">alert('Information Saved Successfully');<" + "/" + "script>");
}
if (!IsPostBack)
{
if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "")
{
lblResourceWorkflow.Text = Request.QueryString["rrid"];
int intResourceWorkflow = Int32.Parse(lblResourceWorkflow.Text);
int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow);
ds = oResourceRequest.Get(intResourceParent);
if (ds.Tables[0].Rows.Count > 0)
{
int intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString());
int intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString());
int intApp = oRequestItem.GetItemApplication(intItem);
int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid"));
int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
int intProject = oRequest.GetProjectNumber(intRequest);
bool boolManager = false;
if (intProject > 0)
{
panProject.Visible = true;
lblName.Text = oProject.Get(intProject, "name");
lblNumber.Text = oProject.Get(intProject, "number");
lblOrganization.Text = oOrganization.GetName(Int32.Parse(oProject.Get(intProject, "organization")));
}
else
{
panTask.Visible = true;
lblTaskName.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "name");
lblTaskNumber.Text = "CVT" + intRequest.ToString();
}
lblSubmitter.Text = oUser.GetFullName(oRequest.GetUser(intRequest));
lblStatement.Text = oRequest.Get(intRequest, "description");
if (oRequest.Get(intRequest, "start_date") != "")
{
lblStart.Text = DateTime.Parse(oRequest.Get(intRequest, "start_date")).ToShortDateString();
}
else
{
lblStart.Text = "N / A";
}
if (oRequest.Get(intRequest, "end_date") != "")
{
lblEnd.Text = DateTime.Parse(oRequest.Get(intRequest, "end_date")).ToShortDateString();
}
else
{
lblEnd.Text = "N / A";
}
double dblUsed = oResourceRequest.GetWorkflowUsed(intResourceWorkflow);
lblUsed.Text = dblUsed.ToString("F");
lblAllocated.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated");
txtAllocated.Text = lblAllocated.Text;
txtDevices.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "devices");
lblDevices.Text = txtDevices.Text;
if (ds.Tables[0].Rows[0]["solo"].ToString() == "0")
{
btnView.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intViewRequest.ToString() + "&rid=" + intRequest.ToString() + "');");
btnView.Text = "View Original Request Details";
}
else
{
btnView.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intViewResourceRequest.ToString() + "&rrid=" + intResourceParent.ToString() + "');");
if (oApplication.Get(intApp, "tpm") == "1")
{
btnView.Text = "View Original Request Details";
}
else
{
btnView.Text = "View Original Request Details";
}
}
string strStatus = ds.Tables[0].Rows[0]["status"].ToString();
int intAppManager = oApplication.GetManager(intApp);
LoadList(intAppManager, intApp);
LoadAvailable(intAppManager, intApp);
if (oUser.IsAdmin(intProfile) || oService.IsManager(intService, intProfile) || (oApplication.IsManager(intApp, intProfile) && oApplication.Get(intApp, "disable_manager") != "1") || (oUser.IsManager(intUser, intProfile, true) && oApplication.Get(intApp, "disable_manager") != "1"))
{
boolManager = true;
}
else if (intProfile == intUser)
{
panVirtual.Visible = true;
btnVirtual.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST','" + intResourceWorkflow.ToString() + "');");
btnVirtual.Text = "View This Request";
}
try
{
ddlActivity.SelectedValue = intItem.ToString();
lblActivity.Text = ddlActivity.SelectedItem.Text;
ddlUser.SelectedValue = intUser.ToString();
lblUser.Text = ddlUser.SelectedItem.Text;
}
catch { }
if (boolManager == true)
{
Master.Page.Title = "Resource Request #" + intResourceWorkflow.ToString() + " Management View";
panView.Visible = true;
panManager.Visible = true;
chkOpen.Enabled = (strStatus == "3" || strStatus == "-2" || strStatus == "5");
txtAllocated.Visible = true;
txtDevices.Visible = true;
ddlActivity.Visible = true;
ddlUser.Visible = true;
lnkAvailable.Visible = true;
panVirtual.Visible = true;
btnVirtual.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST','" + intResourceWorkflow.ToString() + "');");
btnVirtual.Text = "Virtual Login as " + oUser.Get(intUser, "fname") + " " + oUser.Get(intUser, "lname");
btnSave.Attributes.Add("onclick", "return ValidateNumber('" + txtAllocated.ClientID + "','Please enter a valid number for the allocated hours')" +
" && ValidateNumber('" + txtDevices.ClientID + "','Please enter a valid number for the device count')" +
" && ValidateDropDown('" + ddlActivity.ClientID + "','Please make a selection for the activity type')" +
" && ValidateDropDown('" + ddlUser.ClientID + "','Please make a selection for the assigned technician')" +
";");
}
else
{
Master.Page.Title = "Resource Request #" + intResourceWorkflow.ToString() + " Technician View";
panView.Visible = true;
lblAllocated.Visible = true;
lblDevices.Visible = true;
lblActivity.Visible = true;
lblUser.Visible = true;
}
}
else
{
panDenied.Visible = true;
}
}
else
{
panDenied.Visible = true;
}
lnkAvailable.Attributes.Add("onclick", "return ShowHideAvailable('" + divAvailable.ClientID + "');");
btnFinish.Attributes.Add("onclick", "return CloseWindow();");
btnClose.Attributes.Add("onclick", "return CloseWindow();");
btnDenied.Attributes.Add("onclick", "return CloseWindow();");
}
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oProject = new Projects(intProfile, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oUser = new Users(intProfile, dsn);
oPage = new Pages(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oRequestItem = new RequestItems(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oService = new Services(intProfile, dsn);
oRequestField = new RequestFields(intProfile, dsn);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oApplication = new Applications(intProfile, dsn);
oOnDemandTasks = new OnDemandTasks(intProfile, dsn);
oDelegate = new Delegates(intProfile, dsn);
oClass = new Classes(intProfile, dsn);
oServer = new Servers(0, dsn);
if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "")
{
intApplication = Int32.Parse(Request.QueryString["applicationid"]);
}
if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "")
{
intPage = Int32.Parse(Request.QueryString["pageid"]);
}
if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "")
{
intApplication = Int32.Parse(Request.Cookies["application"].Value);
}
if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "")
{
lblResourceWorkflow.Text = Request.QueryString["rrid"];
int intResourceWorkflow = Int32.Parse(Request.QueryString["rrid"]);
int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow);
DataSet ds = oResourceRequest.Get(intResourceParent);
intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString());
intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString());
// Workflow start
bool boolComplete = (oResourceRequest.GetWorkflow(intResourceWorkflow, "status") == "3");
int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid"));
txtCustom.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "name");
double dblAllocated = double.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated"));
// Workflow end
int intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString());
lblService.Text = oService.Get(intService, "name");
int intApp = oRequestItem.GetItemApplication(intItem);
double dblUsed = oResourceRequest.GetWorkflowUsed(intResourceWorkflow);
lblUpdated.Text = oResourceRequest.GetUpdated(intResourceParent);
dblUsed = (dblUsed / dblAllocated) * 100;
if (Request.QueryString["save"] != null && Request.QueryString["save"] != "")
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "saved", "<script type=\"text/javascript\">alert('Information Saved Successfully');<" + "/" + "script>");
}
if (Request.QueryString["status"] != null && Request.QueryString["status"] != "")
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "statusd", "<script type=\"text/javascript\">alert('Weekly Status has been Added');<" + "/" + "script>");
}
intProject = oRequest.GetProjectNumber(intRequest);
hdnTab.Value = "D";
panWorkload.Visible = true;
LoadStatus(intResourceWorkflow);
bool boolDone = LoadInformation(intResourceWorkflow);
if (boolDone == true)
{
if (boolComplete == false)
{
oFunction.ConfigureToolButton(btnComplete, "/images/tool_complete");
btnComplete.Attributes.Add("onclick", "return ValidateDropDown('" + ddlSuccess.ClientID + "','Please select a status') && confirm('Are you sure you want to mark this as completed and remove it from your workload?');");
}
else
{
oFunction.ConfigureToolButton(btnComplete, "/images/tool_complete");
btnComplete.Attributes.Add("onclick", "alert('This task has already been marked COMPLETE. You can close this window.');return false;");
}
imgSuccess.ImageUrl = "/images/green_arrow.gif";
btnSave.ImageUrl = "/images/tool_save.gif";
btnSave.Enabled = false;
}
else
{
btnComplete.ImageUrl = "/images/tool_complete_dbl.gif";
btnComplete.Enabled = false;
oFunction.ConfigureToolButton(btnSave, "/images/tool_save");
}
btnDenied.Attributes.Add("onclick", "return CloseWindow();");
oFunction.ConfigureToolButton(btnSave, "/images/tool_save");
oFunction.ConfigureToolButton(btnPrint, "/images/tool_print");
btnPrint.Attributes.Add("onclick", "return PrintWindow();");
oFunction.ConfigureToolButton(btnClose, "/images/tool_close");
btnClose.Attributes.Add("onclick", "return ExitWindow();");
btnSave.Attributes.Add("onclick", "return ValidateStatus('" + ddlStatus.ClientID + "','" + txtIssues.ClientID + "');");
// 6/1/2009 - Load ReadOnly View
if (oResourceRequest.CanUpdate(intProfile, intResourceWorkflow, false) == false)
{
oFunction.ConfigureToolButtonRO(btnSave, btnComplete);
//panDenied.Visible = true;
}
}
else
{
panDenied.Visible = true;
}
}
private void LoadRequest()
{
// Get Workflow Details
lblResourceWorkflow.Text = Request.QueryString["rrid"];
int intResourceWorkflow = Int32.Parse(Request.QueryString["rrid"]);
int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow);
int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid"));
bool boolComplete = (oResourceRequest.GetWorkflow(intResourceWorkflow, "status") == "3");
double dblAllocated = double.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated"));
bool boolJoined = (oResourceRequest.GetWorkflow(intResourceWorkflow, "joined") == "1");
DataSet ds = oResourceRequest.Get(intResourceParent);
//Project or Task Details
intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
intProject = oRequest.GetProjectNumber(intRequest);
if (intProject > 0)
{
lblName.Text = oProject.Get(intProject, "name");
lblNumber.Text = oProject.Get(intProject, "number");
lblType.Text = "Project";
}
else
{
lblName.Text = oResourceRequest.GetWorkflow(intRequest, "name");
lblNumber.Text = "CVT" + intRequest.ToString();
lblType.Text = "Task";
}
intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString());
intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString());
intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString());
int intApp = oRequestItem.GetItemApplication(intItem);
lblService.Text = oService.Get(intService, "name");
lblRequestedBy.Text = oUser.GetFullName(oRequest.GetUser(intRequest));
lblRequestedOn.Text = DateTime.Parse(oResourceRequest.Get(intResourceParent, "created")).ToString();
lblDescription.Text = oRequest.Get(intRequest, "description");
if (lblDescription.Text == "")
{
lblDescription.Text = "<i>No information</i>";
}
txtCustom.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "name");
lblUpdated.Text = oResourceRequest.GetUpdated(intResourceParent);
if (!IsPostBack)
{
double dblUsed = oResourceRequest.GetWorkflowUsed(intResourceWorkflow);
if (dblAllocated == dblUsed)
{
if (boolComplete == false)
{
btnComplete.Attributes.Add("onclick", "return confirm('Are you sure you want to mark this as completed and remove it from your workload?');");
}
else
{
btnComplete.Attributes.Add("onclick", "alert('This task has already been marked COMPLETE. You can close this window.');return false;");
}
}
else
{
btnComplete.ImageUrl = "/images/tool_complete_dbl.gif";
btnComplete.Enabled = false;
}
bool boolSLABreached = false;
if (oService.Get(intService, "sla") != "")
{
int intDays = oResourceRequest.GetSLA(intResourceParent);
if (intDays > -99999)
{
if (intDays < 1)
{
btnSLA.Style["border"] = "solid 2px #FF0000";
}
else if (intDays < 3)
{
btnSLA.Style["border"] = "solid 2px #FF9999";
}
boolSLABreached = (intDays < 0);
btnSLA.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST_SLA','?rrid=" + intResourceParent.ToString() + "');");
}
else
{
btnSLA.ImageUrl = "/images/tool_sla_dbl.gif";
btnSLA.Enabled = false;
}
}
else
{
btnSLA.ImageUrl = "/images/tool_sla_dbl.gif";
btnSLA.Enabled = false;
}
btnEmail.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST_EMAIL','?rrid=" + intResourceWorkflow.ToString() + "&type=GENERIC');");
dblUsed = (dblUsed / dblAllocated) * 100;
panWorkload.Visible = true;
bool boolRed = LoadStatus(intResourceWorkflow);
if (boolRed == false && boolSLABreached == true)
{
btnComplete.Attributes.Add("onclick", "alert('NOTE: Your Service Level Agreement (SLA) has been breached!\\n\\nYou must provide a RED STATUS update with an explanation of why your SLA was breached for this request.\\n\\nOnce a RED STATUS update has been provided, you will be able to complete this request.');return false;");
}
LoadInformation();
chkDescription.Checked = (Request.QueryString["doc"] != null);
//Change Control and Documents
//ucWMStatusUpdates.RRWorkflowId = intResourceWorkflow;
LoadChange(intResourceWorkflow);
lblDocuments.Text = oDocument.GetDocuments_Service(intRequest, intService, oVariable.DocumentsFolder(), 1, (Request.QueryString["doc"] != null));
// 6/1/2009 - Load ReadOnly View
if ((oResourceRequest.CanUpdate(intProfile, intResourceWorkflow, false) == false) || boolComplete == true)
{
oFunction.ConfigureToolButtonRO(btnSave, btnComplete);
}
btnReturn.Visible = false;
//btnComplete.Visible = false;
}
//div selection
if (Request.QueryString["div"] != null)
{
switch (Request.QueryString["div"])
{
case "E":
boolExecution = true;
break;
case "C":
boolChange = true;
break;
case "D":
boolDocuments = true;
break;
case "S":
boolStatusUpdates = true;
break;
}
}
if (boolDetails == false && boolExecution == false && boolStatusUpdates == false && boolChange == false && boolDocuments == false)
{
boolDetails = true;
}
}
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);
}
protected void Page_Load(object sender, EventArgs e)
{
Servers oServer = new Servers(0, dsn);
VMWare oVMWare = new VMWare(0, dsn);
Forecast oForecast = new Forecast(0, dsn);
Environments oEnvironment = new Environments(0, dsn);
OperatingSystems oOperatingSystem = new OperatingSystems(0, dsn);
Classes oClass = new Classes(0, dsn);
Requests oRequest = new Requests(0, dsn);
Projects oProject = new Projects(0, dsn);
ServerName oServerName = new ServerName(0, dsn);
Locations oLocations = new Locations(0, dsn);
ModelsProperties oModelsProperties = new ModelsProperties(0, dsn);
ServicePacks oServicePacks = new ServicePacks(0, dsn);
Users oUser = new Users(0, dsn);
Organizations oOrganization = new Organizations(0, dsn);
IPAddresses oIPAddresses = new IPAddresses(0, dsnIP, dsn);
ResourceRequest oResourceRequest = new ResourceRequest(0, dsn);
Domains oDomains = new Domains(0, dsn);
oVariables = new Variables(intEnvironment);
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
StringBuilder sbTable = new StringBuilder(strTable);
int intServer = Int32.Parse(Request.QueryString["id"]);
DataSet ds = oServer.Get(intServer);
if (ds.Tables[0].Rows.Count > 0)
{
int intAnswer = Int32.Parse(ds.Tables[0].Rows[0]["answerid"].ToString());
int intName = Int32.Parse(ds.Tables[0].Rows[0]["nameid"].ToString());
string strName = oServer.GetName(intServer, boolUsePNCNaming);
int intForecast = Int32.Parse(oForecast.GetAnswer(intAnswer, "forecastid"));
int intRequest = Int32.Parse(oForecast.Get(intForecast, "requestid"));
int intProject = oRequest.GetProjectNumber(intRequest);
int intClass = Int32.Parse(oForecast.GetAnswer(intAnswer, "classid"));
int intEnv = Int32.Parse(oForecast.GetAnswer(intAnswer, "environmentid"));
int intModel = Int32.Parse(ds.Tables[0].Rows[0]["modelid"].ToString());
string _save_location = oVariables.UploadsFolder() + "SC\\";
string strFileName = "SC_" + intServer.ToString() + "_" + oProject.Get(intProject, "number") + ".HTM";
if (Directory.Exists(_save_location) == false)
{
Directory.CreateDirectory(_save_location);
}
string strFile = _save_location + strFileName;
StreamWriter fp = File.CreateText(strFile);
string strDefault = "<table cellpadding=\"2\" cellspacing=\"2\" border=\"0\" class=\"default\">";
StringBuilder sbLeft1 = new StringBuilder();
string strLead = oProject.Get(intProject, "lead");
int intLead = 0;
if (strLead != "")
{
intLead = Int32.Parse(strLead);
}
sbLeft1.Append("<fieldset>");
sbLeft1.Append("<legend><b>Who is this for?</b></legend>");
sbLeft1.Append(strDefault);
sbLeft1.Append("<tr>");
sbLeft1.Append("<td>Client XID:</td>");
sbLeft1.Append("<td>");
sbLeft1.Append(GetBox(intLead > 0 ? oUser.GetName(intLead) : "***ERROR**", 200));
sbLeft1.Append("</td>");
sbLeft1.Append("</tr>");
sbLeft1.Append("<tr>");
sbLeft1.Append("<td>Client Name:</td>");
sbLeft1.Append("<td>");
sbLeft1.Append(GetBox(intLead > 0 ? oUser.GetFullName(intLead) : "***ERROR**", 200));
sbLeft1.Append("</td>");
sbLeft1.Append("</tr>");
sbLeft1.Append("<tr>");
sbLeft1.Append("<td>Client Phone No.:</td>");
sbLeft1.Append("<td>");
sbLeft1.Append(GetBox(intLead > 0 ? oUser.Get(intLead, "phone") : "***ERROR**", 200));
sbLeft1.Append("</td>");
sbLeft1.Append("</tr>");
sbLeft1.Append("<tr>");
sbLeft1.Append("<td>Client Department:</td>");
sbLeft1.Append("<td>");
sbLeft1.Append(GetBox("", 200));
sbLeft1.Append("</td>");
sbLeft1.Append("</tr>");
sbLeft1.Append("<tr>");
sbLeft1.Append("<td>Client Fax:</td>");
sbLeft1.Append("<td>");
sbLeft1.Append(GetBox("", 200));
sbLeft1.Append("</td>");
sbLeft1.Append("</tr>");
sbLeft1.Append("<tr>");
sbLeft1.Append("<td>Client Cost Center:</td>");
sbLeft1.Append("<td>");
sbLeft1.Append(GetBox("", 200));
sbLeft1.Append("</td>");
sbLeft1.Append("</tr>");
sbLeft1.Append("</table>");
sbLeft1.Append("</fieldset>");
StringBuilder sbRight1 = new StringBuilder();
string strIE = oProject.Get(intProject, "engineer");
int intIE = 0;
if (strIE != "")
{
intIE = Int32.Parse(strIE);
}
sbRight1.Append("<fieldset>");
sbRight1.Append("<legend><b>Requestor Information</b></legend>");
sbRight1.Append(strDefault);
sbRight1.Append("<tr>");
sbRight1.Append("<td>Requested By Name:</td>");
sbRight1.Append("<td>");
sbRight1.Append(GetBox(intIE > 0 ? oUser.GetFullName(intIE) : "***ERROR**", 200));
sbRight1.Append("</td>");
sbRight1.Append("</tr>");
sbRight1.Append("<tr>");
sbRight1.Append("<td>Requested By Phone No.:</td>");
sbRight1.Append("<td>");
sbRight1.Append(GetBox(intIE > 0 ? oUser.Get(intIE, "phone") : "***ERROR**", 200));
sbRight1.Append("</td>");
sbRight1.Append("</tr>");
sbRight1.Append("<tr>");
sbRight1.Append("<td>Requested By Email:</td>");
sbRight1.Append("<td>");
sbRight1.Append(GetBox(intIE > 0 ? oUser.GetEmail(oUser.GetName(intIE), intEnvironment) : "***ERROR**", 200));
sbRight1.Append("</td>");
sbRight1.Append("</tr>");
sbRight1.Append("</table>");
sbRight1.Append("</fieldset>");
sbRight1.Append("<fieldset>");
sbRight1.Append("<legend><b>Location Information:</b></legend>");
sbRight1.Append(strDefault);
sbRight1.Append("<tr>");
sbRight1.Append("<td>Location:</td>");
sbRight1.Append("<td>");
sbRight1.Append(GetBox("", 200));
sbRight1.Append("</td>");
sbRight1.Append("</tr>");
sbRight1.Append("<tr>");
sbRight1.Append("<td>Location Full Name:</td>");
sbRight1.Append("<td>");
sbRight1.Append(GetBox("", 200));
sbRight1.Append("</td>");
sbRight1.Append("</tr>");
sbRight1.Append("</table>");
sbRight1.Append("</fieldset>");
StringBuilder sbCenter1 = new StringBuilder();
sbCenter1.Append("<fieldset>");
sbCenter1.Append("<legend><b>Brief Desc:</b></legend>");
sbCenter1.Append(strDefault);
sbCenter1.Append("<tr>");
sbCenter1.Append("<td>");
sbCenter1.Append(GetBox(oForecast.GetAnswer(intAnswer, "name") + " (" + strName + ")", 600));
sbCenter1.Append("</td>");
sbCenter1.Append("</tr>");
sbCenter1.Append("</table>");
sbCenter1.Append("</fieldset>");
StringBuilder sbLeft2 = new StringBuilder();
sbLeft2.Append("<fieldset>");
sbLeft2.Append("<legend><b>Project Information:</b></legend>");
sbLeft2.Append(strDefault);
sbLeft2.Append("<tr>");
sbLeft2.Append("<td>Project ID:</td>");
sbLeft2.Append("<td>");
sbLeft2.Append(GetBox(oProject.Get(intProject, "number"), 200));
sbLeft2.Append("</td>");
sbLeft2.Append("<td>Project Manager XID:</td>");
sbLeft2.Append("<td>");
sbLeft2.Append(GetBox(intLead > 0 ? oUser.GetName(intLead) : "***ERROR**", 200));
sbLeft2.Append("</td>");
sbLeft2.Append("</tr>");
sbLeft2.Append("<tr>");
sbLeft2.Append("<td>Project Name:</td>");
sbLeft2.Append("<td>");
sbLeft2.Append(GetBox(oProject.Get(intProject, "name"), 200));
sbLeft2.Append("</td>");
sbLeft2.Append("<td>Project Manager Name:</td>");
sbLeft2.Append("<td>");
sbLeft2.Append(GetBox(intLead > 0 ? oUser.GetFullName(intLead) : "***ERROR**", 200));
sbLeft2.Append("</td>");
sbLeft2.Append("</tr>");
sbLeft2.Append("<tr>");
sbLeft2.Append("<td>Project Budgeted:</td>");
sbLeft2.Append("<td>");
sbLeft2.Append(GetBox(oProject.Get(intProject, "bd"), 200));
sbLeft2.Append("</td>");
sbLeft2.Append("<td>Project Manager Phone:</td>");
sbLeft2.Append("<td>");
sbLeft2.Append(GetBox(intLead > 0 ? oUser.Get(intLead, "phone") : "***ERROR**", 200));
sbLeft2.Append("</td>");
sbLeft2.Append("</tr>");
sbLeft2.Append("<tr>");
sbLeft2.Append("<td>Project Cost Ctr:</td>");
sbLeft2.Append("<td>");
sbLeft2.Append(GetBox("", 200));
sbLeft2.Append("</td>");
sbLeft2.Append("<td>Project Manager Email:</td>");
sbLeft2.Append("<td>");
sbLeft2.Append(GetBox(intLead > 0 ? oUser.GetEmail(oUser.GetName(intLead), intEnvironment) : "***ERROR**", 200));
sbLeft2.Append("</td>");
sbLeft2.Append("</tr>");
sbLeft2.Append("</table>");
sbLeft2.Append("</fieldset>");
OnDemandTasks oOnDemandTasks = new OnDemandTasks(0, dsn);
int intImplementor = 0;
DataSet dsTasks = oOnDemandTasks.GetPending(intAnswer);
if (dsTasks.Tables[0].Rows.Count > 0)
{
intImplementor = Int32.Parse(dsTasks.Tables[0].Rows[0]["resourceid"].ToString());
intImplementor = Int32.Parse(oResourceRequest.GetWorkflow(intImplementor, "userid"));
}
else
{
intImplementor = -999;
}
sbTable = new StringBuilder("<table cellpadding=\"2\" cellspacing=\"2\" border=\"0\" class=\"default\">");
sbTable.Append("<tr>");
sbTable.Append("<td colspan=\"2\"><b>NOTE:</b> ASSIGN THIS REQUEST TO: ");
sbTable.Append(intImplementor > 0 || intImplementor == -999 ? oUser.GetFullName(intImplementor) + " (" + oUser.GetName(intImplementor) + ")" : "***ERROR**");
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>");
sbTable.Append(sbLeft1.ToString());
sbTable.Append("</td>");
sbTable.Append("<td>");
sbTable.Append(sbRight1.ToString());
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td colspan=\"2\">");
sbTable.Append(sbCenter1.ToString());
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td colspan=\"2\">");
sbTable.Append(sbLeft2.ToString());
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td colspan=\"2\"><p> </p></td>");
sbTable.Append("</tr>");
bool boolVirtual = false;
if (boolVirtual == true)
{
sbTable.Append("<tr>");
sbTable.Append("<td colspan=\"2\" class=\"header\">REQUISITION VIRTUAL SERVER GUEST</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Requested Server Completion Date:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox(oForecast.GetAnswer(intAnswer, "implementation"), 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Server Hardware Specifications:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox("VIRTUAL SERVER GUEST VMWARE", 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Server Operating System:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox(oOperatingSystem.Get(Int32.Parse(ds.Tables[0].Rows[0]["osid"].ToString()), "name").ToUpper() + " (" + oServicePacks.Get(Int32.Parse(ds.Tables[0].Rows[0]["spid"].ToString()), "name").ToUpper() + ")", 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Environment:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox(oEnvironment.Get(Int32.Parse(oForecast.GetAnswer(intAnswer, "environmentid")), "name").ToUpper(), 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Destination Class:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox(oClass.Get(Int32.Parse(oForecast.GetAnswer(intAnswer, "classid")), "name").ToUpper(), 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr><td colspan=\"2\"><p> </p></td></tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Destination Domain:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox(oDomains.Get(Int32.Parse(ds.Tables[0].Rows[0]["domainid"].ToString()), "name").ToUpper(), 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Backup Method:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox("TSM", 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
string strHost = "***ERROR***";
DataSet dsGuest = oVMWare.GetGuest(strName);
if (dsGuest.Tables[0].Rows.Count > 0)
{
strHost = oVMWare.GetHost(Int32.Parse(dsGuest.Tables[0].Rows[0]["hostid"].ToString()), "name").ToUpper();
}
sbTable.Append("<tr>");
sbTable.Append("<td>Host Server Name:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox(strHost, 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr><td colspan=\"2\"><p> </p></td></tr>");
sbTable.Append("<tr>");
sbTable.Append("<td bgcolor=\"#CCCCCC\" style=\"border:2px outset #FFFFFF\">Network Protocols</td>");
sbTable.Append("<td bgcolor=\"#CCCCCC\" style=\"border:2px outset #FFFFFF\">Server Software - click in box below to add</td>");
sbTable.Append("</tr>");
bool boolSQL = false;
bool boolIIS = false;
DataSet dsComp = oServerName.GetComponentDetailSelected(intServer, 1);
foreach (DataRow drComp in dsComp.Tables[0].Rows)
{
if (drComp["code"].ToString() == "IIS")
{
boolIIS = true;
}
if (drComp["code"].ToString() == "SQL")
{
boolSQL = true;
}
}
sbTable.Append("<tr>");
sbTable.Append("<td>");
sbTable.Append(GetBox("TCP/IP", 250));
sbTable.Append("</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox((boolSQL ? "SQL" : ""), 350));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>");
sbTable.Append(GetBox("", 250));
sbTable.Append("</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox((boolIIS ? "IIS" : ""), 350));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr><td colspan=\"2\"><p> </p></td></tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Attached to SAN?:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox("NO", 150));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Server is Clustered:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox("NO", 150));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Server Load Balanced:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox("NO", 150));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Maximum Allowable Downtime:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox("Not Applicable", 150) + "</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td colspan=\"2\"><input type=\"checkbox\" class=\"default\"/> Hardware Refresh</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr><td colspan=\"2\"><p> </p></td></tr>");
sbTable.Append("<tr>");
sbTable.Append("<td colspan=\"2\">Intended Use Description:</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td colspan=\"2\">");
sbTable.Append(GetBox("", 500));
sbTable.Append("</td>");
sbTable.Append("</tr>");
}
else
{
sbTable.Append("<tr>");
sbTable.Append("<td colspan=\"2\" class=\"header\">REQUISITION SERVER</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Requested Server Completion Date:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox(oForecast.GetAnswer(intAnswer, "implementation"), 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Server Hardware Specifications:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox(oModelsProperties.Get(intModel, "name"), 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td colspan=\"2\"><input type=\"checkbox\" class=\"default\" checked/> User re-deployable hardware if applicable</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>PO:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox("", 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Server Operating System:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox(oOperatingSystem.Get(Int32.Parse(ds.Tables[0].Rows[0]["osid"].ToString()), "name").ToUpper() + " (" + oServicePacks.Get(Int32.Parse(ds.Tables[0].Rows[0]["spid"].ToString()), "name").ToUpper() + ")", 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Environment:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox(oEnvironment.Get(Int32.Parse(oForecast.GetAnswer(intAnswer, "environmentid")), "name").ToUpper(), 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Destination Class:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox(oClass.Get(Int32.Parse(oForecast.GetAnswer(intAnswer, "classid")), "name").ToUpper(), 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr><td colspan=\"2\"><p> </p></td></tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Destination Domain:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox(oDomains.Get(Int32.Parse(ds.Tables[0].Rows[0]["domainid"].ToString()), "name").ToUpper(), 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Server Location:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox(oLocations.GetFull(Int32.Parse(oForecast.GetAnswer(intAnswer, "addressid"))).ToUpper(), 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Backup Method:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox("TSM", 300));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr><td colspan=\"2\"><p> </p></td></tr>");
sbTable.Append("<tr>");
sbTable.Append("<td bgcolor=\"#CCCCCC\" style=\"border:2px outset #FFFFFF\">Network Protocols</td>");
sbTable.Append("<td bgcolor=\"#CCCCCC\" style=\"border:2px outset #FFFFFF\">Server Software - click in box below to add</td>");
sbTable.Append("</tr>");
bool boolSQL = false;
bool boolIIS = false;
DataSet dsComp = oServerName.GetComponentDetailSelected(intServer, 1);
foreach (DataRow drComp in dsComp.Tables[0].Rows)
{
if (drComp["code"].ToString() == "IIS")
{
boolIIS = true;
}
if (drComp["code"].ToString() == "SQL")
{
boolSQL = true;
}
}
sbTable.Append("<tr>");
sbTable.Append("<td>");
sbTable.Append(GetBox("TCP/IP", 250));
sbTable.Append("</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox((boolSQL ? "SQL" : ""), 350));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>");
sbTable.Append(GetBox("", 250));
sbTable.Append("</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox((boolIIS ? "IIS" : ""), 350));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr><td colspan=\"2\"><p> </p></td></tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Attached to SAN?:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox("NO", 150));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Server is Clustered:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox("NO", 150));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Server Load Balanced:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox("NO", 150));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td>Maximum Allowable Downtime:</td>");
sbTable.Append("<td>");
sbTable.Append(GetBox("Not Applicable", 150));
sbTable.Append("</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td colspan=\"2\"><input type=\"checkbox\" class=\"default\"/> Hardware Refresh</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr><td colspan=\"2\"><p> </p></td></tr>");
sbTable.Append("<tr>");
sbTable.Append("<td colspan=\"2\">Intended Use Description:</td>");
sbTable.Append("</tr>");
sbTable.Append("<tr>");
sbTable.Append("<td colspan=\"2\">");
sbTable.Append(GetBox("", 500));
sbTable.Append("</td>");
sbTable.Append("</tr>");
}
sbTable.Append("</table>");
fp.WriteLine("<html>");
fp.WriteLine("<head>");
fp.WriteLine("<title>ClearView | Service Center Request Form</title>");
fp.WriteLine("<style type=\"text/css\">");
fp.WriteLine(".default {font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 10px;}");
fp.WriteLine(".header {font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 16px;font-style: italic;font-weight: bold;}");
fp.WriteLine("</style>");
fp.WriteLine("<body leftmargin=\"0\" topmargin=\"0\">");
fp.WriteLine(sbTable.ToString());
fp.WriteLine("</body>");
fp.WriteLine("</html>");
fp.Close();
}
strTable = sbTable.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oUser = new Users(intProfile, dsn);
oPage = new Pages(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oRequestItem = new RequestItems(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oApplication = new Applications(intProfile, dsn);
oAccountRequest = new AccountRequest(intProfile, dsn);
oDelegate = new Delegates(intProfile, dsn);
oService = new Services(intProfile, dsn);
if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "")
{
intApplication = Int32.Parse(Request.QueryString["applicationid"]);
}
if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "")
{
intPage = Int32.Parse(Request.QueryString["pageid"]);
}
if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "")
{
intApplication = Int32.Parse(Request.Cookies["application"].Value);
}
string strAttributes = "";
bool boolIncomplete = false;
if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "")
{
intResourceWorkflow = Int32.Parse(Request.QueryString["rrid"]);
int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow);
DataSet ds = oResourceRequest.Get(intResourceParent);
if (ds.Tables[0].Rows.Count > 0)
{
intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString());
intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString());
// Workflow start
bool boolComplete = (oResourceRequest.GetWorkflow(intResourceWorkflow, "status") == "3");
int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid"));
double dblAllocated = double.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated"));
// Workflow end
intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString());
int intApp = oRequestItem.GetItemApplication(intItem);
if (Request.QueryString["save"] != null && Request.QueryString["save"] != "")
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "saved", "<script type=\"text/javascript\">alert('Information Saved Successfully');<" + "/" + "script>");
}
if (oService.Get(intService, "sla") != "")
{
oFunction.ConfigureToolButton(btnSLA, "/images/tool_sla");
int intDays = oResourceRequest.GetSLA(intResourceParent);
if (intDays < 1)
{
btnSLA.Style["border"] = "solid 2px #FF0000";
}
else if (intDays < 3)
{
btnSLA.Style["border"] = "solid 2px #FF9999";
}
btnSLA.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST_SLA','?rrid=" + intResourceParent.ToString() + "');");
}
else
{
btnSLA.ImageUrl = "/images/tool_sla_dbl.gif";
btnSLA.Enabled = false;
}
if (!IsPostBack)
{
if (intResourceWorkflow > 0)
{
ds = oRequest.Get(intRequest);
if (ds.Tables[0].Rows.Count > 0)
{
ds = oAccountRequest.GetMaintenance(intRequest, intItem, intNumber);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["completed"].ToString() == "")
{
boolIncomplete = true;
}
else
{
lblComplete.Text = ds.Tables[0].Rows[0]["completed"].ToString();
panComplete.Visible = true;
}
lblRequestBy.Text = oUser.GetFullName(oRequest.GetUser(intRequest));
lblRequestOn.Text = DateTime.Parse(oRequest.Get(intRequest, "created")).ToLongDateString();
int intDomain = Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString());
Domains oDomain = new Domains(intProfile, dsn);
intDomain = Int32.Parse(oDomain.Get(intDomain, "environment"));
AD oAD = new AD(intProfile, dsn, intDomain);
DataSet dsParameters = oAccountRequest.GetMaintenanceParameters(intRequest, intItem, intNumber);
switch (ds.Tables[0].Rows[0]["maintenance"].ToString())
{
case "DISABLE":
lblType.Text = "Account Disable";
strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>";
strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>";
break;
case "UNLOCK":
lblType.Text = "Account Unlock";
strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>";
strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>";
break;
case "ENABLE":
lblType.Text = "Account Enable";
strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>";
strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>";
break;
case "EMAIL":
lblType.Text = "Email Enable an Account";
strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>";
strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>";
break;
case "MOVE":
lblType.Text = "Account Move";
strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>";
strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>";
strDetails += "<tr><td><b>New Location:</b></td><td>" + dsParameters.Tables[0].Rows[0]["value"].ToString() + "</td>";
break;
case "PASSWORD":
lblType.Text = "Account Password Change";
strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>";
strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>";
break;
case "COPY":
lblType.Text = "Account Copy";
panPassword.Visible = true;
strAttributes += "ValidateText('" + txtPassword.ClientID + "','Please enter a password') && ";
strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>";
strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>";
panID.Visible = true;
txtID.Text = dsParameters.Tables[0].Rows[0]["value"].ToString();
panFirst.Visible = true;
txtFirst.Text = dsParameters.Tables[0].Rows[1]["value"].ToString();
panLast.Visible = true;
txtLast.Text = dsParameters.Tables[0].Rows[2]["value"].ToString();
panGroups.Visible = true;
string[] strGroups;
char[] strSplit = { ';' };
strGroups = dsParameters.Tables[0].Rows[3]["value"].ToString().Split(strSplit);
for (int ii = 0; ii < strGroups.Length; ii++)
{
if (strGroups[ii].Trim() != "")
{
ListItem oList = new ListItem(strGroups[ii].Trim());
chkGroups.Items.Add(oList);
oList.Selected = true;
}
}
break;
case "DELETE":
lblType.Text = "Account Deletion";
strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>";
strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>";
break;
case "RENAME":
lblType.Text = "Account Rename";
strDetails += "<tr><td><b>Account:</b></td><td>" + ds.Tables[0].Rows[0]["username"].ToString() + " (" + oAD.GetUserFullName(ds.Tables[0].Rows[0]["username"].ToString()) + ")</td>";
strDetails += "<tr><td><b>Domain:</b></td><td>" + oDomain.Get(Int32.Parse(ds.Tables[0].Rows[0]["domain"].ToString()), "name") + "</td>";
panID.Visible = true;
txtID.Text = dsParameters.Tables[0].Rows[0]["value"].ToString();
panFirst.Visible = true;
txtFirst.Text = dsParameters.Tables[0].Rows[1]["value"].ToString();
panLast.Visible = true;
txtLast.Text = dsParameters.Tables[0].Rows[2]["value"].ToString();
break;
default:
lblType.Text = "Unavailable";
strDetails += "<tr><td colspan=\"2\"><b>Invalid Maintenance Code!</b></td>";
break;
}
panWorkload.Visible = true;
}
else
{
panDenied.Visible = true;
}
}
else
{
panDenied.Visible = true;
}
}
else
{
panDenied.Visible = true;
}
btnDenied.Attributes.Add("onclick", "return CloseWindow();");
oFunction.ConfigureToolButton(btnApprove, "/images/tool_approve");
oFunction.ConfigureToolButton(btnDeny, "/images/tool_deny");
if (boolIncomplete == true)
{
btnApprove.Attributes.Add("onclick", "return " + strAttributes + "confirm('Are you sure you want to APPROVE this request?');");
btnDeny.Attributes.Add("onclick", "return ValidateText('" + txtComments.ClientID + "','Please enter a reason') && confirm('Are you sure you want to DENY this request?');");
}
else
{
btnApprove.Attributes.Add("onclick", "alert('This request has already been completed.\\n\\nIf this request continues to appear in your work queue, please contact a ClearView administrator.');return false;");
btnDeny.Attributes.Add("onclick", "alert('This request has already been completed.\\n\\nIf this request continues to appear in your work queue, please contact a ClearView administrator.');return false;");
}
oFunction.ConfigureToolButton(btnPrint, "/images/tool_print");
btnPrint.Attributes.Add("onclick", "return PrintWindow();");
oFunction.ConfigureToolButton(btnClose, "/images/tool_close");
btnClose.Attributes.Add("onclick", "return ExitWindow();");
// 6/1/2009 - Load ReadOnly View
if (oResourceRequest.CanUpdate(intProfile, intResourceWorkflow, false) == false)
{
oFunction.ConfigureToolButtonRO(btnApprove, btnDeny);
//panDenied.Visible = true;
}
}
}
else
{
panDenied.Visible = true;
}
}
else
{
panDenied.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oForecast = new Forecast(intProfile, dsn);
oModelsProperties = new ModelsProperties(intProfile, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
Pages oPage = new Pages(intProfile, dsn);
if (Request.QueryString["done"] != null && Request.QueryString["done"] != "")
{
oForecast.UpdateAnswerSetComplete(Int32.Parse(Request.QueryString["done"]));
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "saved", "<script type=\"text/javascript\">alert('Design Marked Completed Successfully\\n\\nPlease wait while the page reloads....');window.navigate('" + Request.Path + "?model=" + Request.QueryString["model"] + "&filters=" + Request.QueryString["filters"] + "');<" + "/" + "script>");
}
else if (Request.QueryString["model"] != null && Request.QueryString["model"] != "" && Request.QueryString["filters"] != null)
{
string strFilter = oFunction.decryptQueryString(Request.QueryString["filters"]);
intModel = Int32.Parse(Request.QueryString["model"]);
int intType = oModelsProperties.GetType(intModel);
Types oType = new Types(intProfile, dsn);
int intPlatform = oType.GetPlatform(intType);
lblModel.Text = oModelsProperties.Get(intModel, "name");
bool boolOther = false;
DataSet dsDemand = oForecast.GetAnswersModel(intPlatform);
DataTable dtDemand = dsDemand.Tables[0];
DataRow[] drModels = dtDemand.Select("model = " + intModel.ToString() + strFilter);
ResourceRequest oResourceRequest = new ResourceRequest(0, dsn);
Users oUser = new Users(0, dsn);
StringBuilder sb = new StringBuilder(strResults);
OnDemandTasks oOnDemandTasks = new OnDemandTasks(0, dsn);
foreach (DataRow dr in drModels)
{
int intProject = Int32.Parse(dr["projectid"].ToString());
int intAnswer = Int32.Parse(dr["id"].ToString());
int intImplementor = 0;
DataSet dsTasks = oOnDemandTasks.GetPending(intAnswer);
if (dsTasks.Tables[0].Rows.Count > 0)
{
intImplementor = Int32.Parse(dsTasks.Tables[0].Rows[0]["resourceid"].ToString());
intImplementor = Int32.Parse(oResourceRequest.GetWorkflow(intImplementor, "userid"));
}
else
{
intImplementor = -999;
}
string strXID = "";
if (intImplementor > 0 || intImplementor == -999)
{
strXID = oUser.GetFullName(intImplementor);
}
boolOther = !boolOther;
sb.Append("<tr");
sb.Append(boolOther ? " bgcolor=\"F6F6F6\"" : "");
sb.Append("><td><a onclick=\"return confirm('Are you sure you want to mark this design as being completed?');\" title=\"Mark as Complete\" href=\"");
sb.Append(Request.Path);
sb.Append("?model=");
sb.Append(intModel.ToString());
sb.Append("&filters=");
sb.Append(Request.QueryString["filters"]);
sb.Append("&done=");
sb.Append(dr["id"].ToString());
sb.Append("\"><img src=\"/images/check.gif\" border=\"0\" align=\"absmiddle\"/></a></td><td>");
sb.Append(dr["id"].ToString());
sb.Append("</td><td><a href=\"");
sb.Append(oPage.GetFullLink(intDesignBuilder));
sb.Append("?id=");
sb.Append(dr["forecastid"].ToString());
sb.Append("&highlight=");
sb.Append(dr["id"].ToString());
sb.Append("\" target=\"_blank\">");
sb.Append(dr["project_name"].ToString());
sb.Append("</a></td><td>");
sb.Append(dr["project_number"].ToString());
sb.Append("</td><td>");
sb.Append(dr["confidence"].ToString());
sb.Append("</td><td>");
sb.Append(dr["implementation"].ToString());
sb.Append("</td><td>");
sb.Append(dr["class"].ToString());
sb.Append("</td><td>");
sb.Append(dr["environment"].ToString());
sb.Append("</td><td>");
sb.Append(dr["location"].ToString());
sb.Append("</td><td>");
sb.Append(strXID);
sb.Append("</td><td align=\"right\">");
sb.Append(dr["quantity"].ToString());
sb.Append("</td><td align=\"right\">");
sb.Append(dr["recovery_number"].ToString());
sb.Append("</td></tr>");
}
strResults = sb.ToString();
}
}
