protected void Page_Load(object sender, EventArgs e)
{
Response.Cookies["loginreferrer"].Value = "/admin/asset/asset_category_burnin_and_deployment_steps.aspx";
Response.Cookies["loginreferrer"].Expires = DateTime.Now.AddDays(30);
if (Request.Cookies["adminid"] != null && Request.Cookies["adminid"].Value != "")
{
intProfile = Int32.Parse(Request.Cookies["adminid"].Value);
}
else
{
Response.Redirect("/admin/login.aspx");
}
oAssetCategory = new AssetCategory(intProfile, dsn);
oAssetCategoryDeploymentConfig = new AssetCategoryDeploymentConfig(intProfile, dsn);
oService = new Services(intProfile, dsn);
oStatusLevels = new StatusLevels(intProfile, dsn);
if (!IsPostBack)
{
LoadList();
if (Request.QueryString["AssetCategoryId"] != null && Request.QueryString["AssetCategoryId"] != "")
{
ddlAssetCategory.SelectedValue = Request.QueryString["AssetCategoryId"].ToString();
}
btnUpdate.Attributes.Add("onclick", "return ValidateDropDown('" + ddlAssetCategory.ClientID + "','Please select asset category')" +
" && confirm('Are you sure you want to update deployments steps ?')" +
";");
btnService.Attributes.Add("onclick", "return OpenWindow('SERVICEBROWSER','" + hdnServiceId.ClientID + "','&control=" + hdnServiceId.ClientID + "&controltext=" + txtService.ClientID + "',false,400,600);");
btnAddService.Attributes.Add("onclick", "return ValidateHidden0('" + hdnServiceId.ClientID + "','" + btnService.ClientID + "','Please select service');");
PopulateConfigurations();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Visible)
{
if (Request.Cookies["profileid"] != null && Request.Cookies["profileid"].Value != "")
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
}
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);
}
oDataPoint = new DataPoint(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oService = new Services(intProfile, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oStatusLevel = new StatusLevels();
oProject = new Projects(intProfile, dsn);
oLog = new Log(intProfile, dsn);
int intProjectID = 0;
if (intProjectId != null)
{
Int32.TryParse(intProjectId.ToString(), out intProjectID);
}
oLog.AddEvent("PROJECT_SEARCH", "", oProject.Get(intProjectID, "number") + ": ServiceProgression started at " + DateTime.Now.ToString(), LoggingType.Debug);
LoadServiceProgression();
oLog.AddEvent("PROJECT_SEARCH", "", oProject.Get(intProjectID, "number") + ": ServiceProgression finished at " + DateTime.Now.ToString(), LoggingType.Debug);
}
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oPage = new Pages(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oCustomized = new Customized(intProfile, dsn);
oVariable = new Variables(intEnvironment);
oStatusLevel = new StatusLevels(intProfile, dsn);
if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "")
{
intPage = Int32.Parse(Request.QueryString["pageid"]);
}
strRedirect = oPage.GetFullLinkRelated(intPage);
lblTitle.Text = oPage.Get(intPage, "title");
lblPage.Text = "1";
lblSort.Text = "";
if (Request.QueryString["page"] != null && Request.QueryString["page"] != "")
{
lblPage.Text = Request.QueryString["page"];
}
if (Request.QueryString["sort"] != null && Request.QueryString["sort"] != "")
{
lblSort.Text = Request.QueryString["sort"];
}
lblTopPaging.Text = "";
LoadDefaultValues();
LoadPaging(Int32.Parse(lblPage.Text), lblSort.Text);
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oPage = new Pages(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oPlatform = new Platforms(intProfile, dsn);
oStatusLevel = new StatusLevels(intProfile, dsn);
oAssetOrder = new AssetOrder(intProfile, dsn, dsnAsset, intEnvironment);
oLocation = new Locations(intProfile, dsn);
oClass = new Classes(intProfile, dsn);
oModel = new Models(intProfile, dsn);
oModelsProperties = new ModelsProperties(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oService = new Services(intProfile, dsn);
oServiceRequest = new ServiceRequests(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["id"] != null && Request.QueryString["id"] != "")
{
intPlatform = Int32.Parse(Request.QueryString["id"]);
}
intPlatform = 1;
if (intPlatform != 0)
{
pnlAllow.Visible = true;
if (!IsPostBack)
{
LoadDefaultValues(intPlatform);
btnApplyFilter.Attributes.Add("onclick", "return ValidateDate('" + txtStartDate.ClientID + "','Please enter start date')" +
" && ValidateDate('" + txtEndDate.ClientID + "','Please enter end date')" +
";");
}
else
{
Page.ClientScript.RegisterStartupScript(typeof(Page), "loadCurrentTab", "<script type=\"text/javascript\">window.top.LoadCurrentTab();<" + "/" + "script>");
}
}
else
{
pnlDenied.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oRequest = new Requests(intProfile, dsn);
oService = new Services(intProfile, dsn);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oEnhancement = new Enhancements(intProfile, dsn);
oPage = new Pages(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oStatusLevel = new StatusLevels();
oUser = new Users(intProfile, dsn);
oCustomized = new Customized(intProfile, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oVariable = new Variables(intEnvironment);
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["id"] != null && Request.QueryString["id"] != "")
{
intID = Int32.Parse(Request.QueryString["id"]);
}
if (Request.QueryString["old"] != null && Request.QueryString["old"] != "")
{
intIDold = Int32.Parse(Request.QueryString["old"]);
}
if (!IsPostBack)
{
LoadLists();
}
int intMenuTab = 0;
if (Request.QueryString["menu_tab"] != null && Request.QueryString["menu_tab"] != "")
{
intMenuTab = Int32.Parse(Request.QueryString["menu_tab"]);
}
Tab oTab = new Tab("", intMenuTab, "divMenu1", true, false);
oTab.AddTab("Enhancement Details", "");
if (intID > 0)
{
panEnhancement.Visible = true;
DataSet ds = oEnhancement.Get(intID);
if (ds.Tables[0].Rows.Count > 0)
{
panNew.Visible = true;
trStatus.Visible = true;
lblTitle.Text = "Edit Enhancement";
DataSet dsMessages = oEnhancement.GetMessages(intID);
if (!IsPostBack)
{
txtTitle.Text = ds.Tables[0].Rows[0]["title"].ToString();
txtDescription.Text = ds.Tables[0].Rows[0]["description"].ToString();
ddlUsers.SelectedValue = ds.Tables[0].Rows[0]["users"].ToString();
txtURL.Text = ds.Tables[0].Rows[0]["url"].ToString();
if (ds.Tables[0].Rows[0]["url"].ToString() != "")
{
hypURL.Visible = true;
hypURL.NavigateUrl = ds.Tables[0].Rows[0]["url"].ToString();
}
if (ds.Tables[0].Rows[0]["screenshot"].ToString() != "")
{
panUploaded.Visible = true;
hypUpload.NavigateUrl = ds.Tables[0].Rows[0]["screenshot"].ToString();
}
else
{
panUpload.Visible = true;
hypUpload.Visible = false;
}
radRelease1.SelectedValue = ds.Tables[0].Rows[0]["release1"].ToString();
radRelease2.SelectedValue = ds.Tables[0].Rows[0]["release2"].ToString();
int intStatus = Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString());
lblStatus.Text = oEnhancement.Status(intID);
int intRR = Int32.Parse(ds.Tables[0].Rows[0]["rrid"].ToString());
//foreach (DataRow drStep in dsSteps.Tables[0].Rows)
//{
// if (drStep["requires_approval"].ToString() == "1" && drStep["approved"].ToString() == "")
// boolApproved = false;
// if (drStep["step"].ToString() == "1")
// boolFunctionalReq = true;
//}
if (intStatus != (int)EnhancementStatus.Cancelled && intStatus != (int)EnhancementStatus.Completed && intStatus != (int)EnhancementStatus.Denied && intStatus != (int)EnhancementStatus.Duplicate)
{
trSave1.Visible = true;
trSave2.Visible = true;
btnCancel.Visible = true;
btnUpdate.Visible = true;
btnCancel.CommandArgument = intRR.ToString();
if (intStatus == (int)EnhancementStatus.UnderReview)
{
// Request is active but not yet assigned, so nobody is working on it yet.
}
else
{
btnUpdate.Enabled = false;
trLocked.Visible = true;
btnDeleteAttachment.Enabled = false;
oTab.AddTab("Functional Requirements", "");
DataSet dsSteps = oEnhancement.GetSteps(intID, 1, 0);
if (dsSteps.Tables[0].Rows.Count == 1 && dsSteps.Tables[0].Rows[0]["completed"].ToString() != "")
{
DataSet dsDocuments = oEnhancement.GetDocuments(intID);
hypFunctionalRequirements.NavigateUrl = dsDocuments.Tables[0].Rows[0]["path"].ToString();
lblDays.Text = dsDocuments.Tables[0].Rows[0]["days"].ToString();
lblRelease.Text = DateTime.Parse(dsDocuments.Tables[0].Rows[0]["release"].ToString()).ToShortDateString();
if (dsSteps.Tables[0].Rows[0]["approved"].ToString() == "" && dsSteps.Tables[0].Rows[0]["rejected"].ToString() == "")
{
trFunctionalRequirementsDocument.Visible = true;
btnFunctionalApproving.Enabled = true;
btnFunctionalRejecting.Enabled = true;
btnFunctionalRejecting.Attributes.Add("onclick", "ShowHideDiv('" + trFunctionalReject.ClientID + "','inline');ShowHideDiv('" + trFunctionalButtons.ClientID + "','none');return false;");
btnFunctionalCancelReject.Attributes.Add("onclick", "ShowHideDiv('" + trFunctionalReject.ClientID + "','none');ShowHideDiv('" + trFunctionalButtons.ClientID + "','inline');return false;");
btnFunctionalApproving.Attributes.Add("onclick", "ShowHideDiv('" + trFunctionalApprove.ClientID + "','inline');ShowHideDiv('" + trFunctionalButtons.ClientID + "','none');return false;");
btnFunctionalCancelApprove.Attributes.Add("onclick", "ShowHideDiv('" + trFunctionalApprove.ClientID + "','none');ShowHideDiv('" + trFunctionalButtons.ClientID + "','inline');return false;");
btnFunctionalReject.Attributes.Add("onclick", "return ValidateText('" + txtFunctionalReject.ClientID + "','Specify why you are rejecting the functional requirements') && confirm('Rejecting the functional requirements document will cause delays in this enhancement being released.\\n\\nAre you sure you want to reject the functional requirements document?') && ProcessButton(this) && LoadWait();");
btnFunctionalApprove.Attributes.Add("onclick", "return ValidateCheck('" + chkApprove.ClientID + "','You must accept the acknowledgement to approve the functional requirements') && ProcessButton(this) && LoadWait();");
}
else
{
trFunctionalButtons.Visible = false;
trFunctionalStatus.Visible = true;
if (dsSteps.Tables[0].Rows[0]["approved"].ToString() != "")
{
imgFunctionalStatus.ImageUrl = "/images/bigCheckBox.gif";
lblFunctionalStatus.Text = "Approved on " + dsSteps.Tables[0].Rows[0]["approved"].ToString();
}
if (dsSteps.Tables[0].Rows[0]["rejected"].ToString() != "")
{
imgFunctionalStatus.ImageUrl = "/images/bigError2.gif";
lblFunctionalStatus.Text = "Rejected on " + dsSteps.Tables[0].Rows[0]["rejected"].ToString();
}
}
}
oTab.AddTab("Message Thread (" + dsMessages.Tables[0].Rows.Count.ToString() + ")", "");
oTab.AddTab("Log (" + oEnhancement.LoadLog(intID, rptLog, lblLog) + ")", "");
}
btnMessageReplyImage.Attributes.Add("onclick", "ShowHideDiv2('" + divMessageReply.ClientID + "');return false;");
}
else
{
btnDeleteAttachment.Visible = false;
btnMessageReplyImage.Attributes.Add("onclick", "alert('You can only post a message to an ACTIVE thread.\\n\\nSince this thread is no longer active, additional posts have been disabled');return false;");
btnMessageReply.Enabled = false;
if (ds.Tables[0].Rows[0]["reason"].ToString() != "")
{
trComments.Visible = true;
lblComments.Text = ds.Tables[0].Rows[0]["reason"].ToString();
}
}
lblRequestBy.Text = oUser.GetFullName(intProfile);
lblRequestOn.Text = DateTime.Parse(ds.Tables[0].Rows[0]["created"].ToString()).ToString();
}
strMessages = oEnhancement.GetMessages(intID, false, "#E1FFE1");
}
}
else if (intIDold > 0)
{
// OLD ENHANCEMENT (Read Only)
panEnhancement.Visible = true;
DataSet ds = oCustomized.GetEnhancementByID(intIDold);
if (ds.Tables[0].Rows.Count > 0)
{
panOld.Visible = true;
lblTitle.Text = "Edit Enhancement";
lblOldTitle.Text = ds.Tables[0].Rows[0]["title"].ToString();
lblOldDescription.Text = ds.Tables[0].Rows[0]["description"].ToString();
lblOldModule.Text = oPage.Get(Int32.Parse(ds.Tables[0].Rows[0]["pageid"].ToString()), "title");
lblOldNumUsers.Text = ds.Tables[0].Rows[0]["num_users"].ToString();
if (ds.Tables[0].Rows[0]["url"].ToString() != "")
{
hypOldURL.NavigateUrl = ds.Tables[0].Rows[0]["url"].ToString();
}
else
{
hypOldURL.Visible = false;
}
if (ds.Tables[0].Rows[0]["path"].ToString() != "")
{
hypOldAttach.NavigateUrl = ds.Tables[0].Rows[0]["path"].ToString();
}
else
{
hypOldAttach.Visible = false;
}
lblOldStart.Text = DateTime.Parse(ds.Tables[0].Rows[0]["startdate"].ToString()).ToShortDateString();
lblOldEnd.Text = DateTime.Parse(ds.Tables[0].Rows[0]["enddate"].ToString()).ToShortDateString();
lblOldStatus.Text = oStatusLevel.HTMLSupport(Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString()));
int intRelease = 0;
if (Int32.TryParse(ds.Tables[0].Rows[0]["release"].ToString(), out intRelease) == true && intRelease > 0)
{
lblOldRelease.Text = DateTime.Parse(oEnhancement.GetVersion(intRelease, "release")).ToLongDateString();
}
else
{
lblOldRelease.Text = "To Be Determined";
}
lblOldRequestedBy.Text = oUser.GetFullName(intProfile);
lblOldRequestedOn.Text = DateTime.Parse(ds.Tables[0].Rows[0]["created"].ToString()).ToString();
intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
oCustomized.UpdateEnhancementNew(intRequest, 0);
panMessage.Visible = (oCustomized.GetMessages(intRequest, 0).Tables[0].Rows.Count > 0);
strMessages = oCustomized.GetMessages(intRequest, false, "#E1FFE1");
if (ds.Tables[0].Rows[0]["status"].ToString() == "2" || ds.Tables[0].Rows[0]["status"].ToString() == "7")
{
btnMessage.Attributes.Add("onclick", "ShowHideDiv2('" + divMessage.ClientID + "');return false;");
}
else
{
btnMessage.Attributes.Add("onclick", "alert('You can only post a message to an ACTIVE thread.\\n\\nSince this thread is no longer active, additional posts have been disabled');return false;");
}
}
}
else
{
//panNoEnhancement.Visible = true;
panEnhancement.Visible = true;
hypCommunity.NavigateUrl = oVariable.Community();
panUpload.Visible = true;
lblRequestBy.Text = oUser.GetFullName(intProfile);
lblRequestOn.Text = DateTime.Now.ToString();
lblTitle.Text = oPage.Get(intPage, "title");
btnSave.Visible = true;
trSave1.Visible = true;
trSave2.Visible = true;
panNew.Visible = true;
}
strMenuTab1 = oTab.GetTabs();
btnSave.Attributes.Add("onclick", "return ValidateText('" + txtTitle.ClientID + "','Please enter a title')" +
" && ValidateText('" + txtDescription.ClientID + "','Please enter a description')" +
" && ValidateDropDown('" + ddlUsers.ClientID + "','Please make a selection for the number of users benefited')" +
" && ValidateRadioList('" + radRelease1.ClientID + "','Please make a selection for your preferred release date')" +
" && ValidateRadioList('" + radRelease2.ClientID + "','Please make a selection for your alternative release date')" +
" && ProcessButton(this) && LoadWait()" +
";");
btnUpdate.Attributes.Add("onclick", "return ValidateText('" + txtTitle.ClientID + "','Please enter a title')" +
" && ValidateText('" + txtDescription.ClientID + "','Please enter a description')" +
" && ValidateDropDown('" + ddlUsers.ClientID + "','Please make a selection for the number of users benefited')" +
" && ValidateRadioList('" + radRelease1.ClientID + "','Please make a selection for your preferred release date')" +
" && ValidateRadioList('" + radRelease2.ClientID + "','Please make a selection for your alternative release date')" +
" && ProcessButton(this) && LoadWait()" +
";");
btnCancel.Attributes.Add("onclick", "return confirm('WARNING: Any changes related to this enhancement and the ClearView system will be removed.\\n\\nAre you sure you want to cancel this enhancement?') && ProcessButton(this) && LoadWait();");
btnResponse.Attributes.Add("onclick", "return ValidateText('" + txtResponse.ClientID + "','Please enter a response') && ProcessButton(this) && LoadWait();;");
btnMessageReply.Attributes.Add("onclick", "return ValidateText('" + txtMessageReply.ClientID + "','Please enter a response') && ProcessButton(this) && LoadWait();;");
btnDeleteAttachment.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this file?') && ProcessButton(this) && LoadWait();;");
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
Master.Page.Title = "DataPoint | Service Search";
if (Request.Cookies["profileid"] != null && Request.Cookies["profileid"].Value != "")
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
}
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);
}
oDataPoint = new DataPoint(intProfile, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oUser = new Users(intProfile, dsn);
oModel = new Models(intProfile, dsn);
oApplications = new Applications(intProfile, dsn);
oService = new Services(intProfile, dsn);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oVariable = new Variables(intEnvironment);
oPage = new Pages(intProfile, dsn);
oStatusLevel = new StatusLevels();
oConfidence = new Confidence(intProfile, dsn);
Response.Cookies["storage"].Value = "0";
Response.Cookies["applications"].Value = "0";
if (oUser.IsAdmin(intProfile) == true || (oDataPoint.GetPagePermission(intApplication, "SERVICE") == true || intDataPointAvailableService == 1))
{
if (Request.QueryString["advanced"] != null && Request.QueryString["advanced"].ToString() == "true")
{
boolAdvSearch = true;
}
if (!IsPostBack)
{
if (Request.QueryString["search"] != null && Request.QueryString["search"].ToString() == "request")
{
ddlSearchType.ClearSelection();
ddlSearchType.Items.FindByValue("request").Selected = true;
}
else if (Request.QueryString["search"] != null && Request.QueryString["search"].ToString() == "design")
{
ddlSearchType.ClearSelection();
ddlSearchType.Items.FindByValue("design").Selected = true;
}
LoadList();
}
//Set controls and add attributes
setControls();
AddControlAttributes();
}
else
{
pnlDenied.Visible = 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);
oDocument = new Documents(intProfile, dsn);
oStatusLevel = new StatusLevels(intProfile, dsn);
oAssetOrder = new AssetOrder(intProfile, dsn, dsnAsset, intEnvironment);
oAsset = new Asset(0, dsnAsset, dsn);
oVariable = new Variables(intEnvironment);
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"] != "")
{
LoadAssetTable();
//Load Attributes
if (!IsPostBack)
{
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 Added Successfully');<" + "/" + "script>");
}
oFunction.ConfigureToolButton(btnEmail, "/images/tool_email");
oFunction.ConfigureToolButton(btnPrint, "/images/tool_print");
oFunction.ConfigureToolButton(btnClose, "/images/tool_close");
oFunction.ConfigureToolButton(btnSave, "/images/tool_save");
oFunction.ConfigureToolButton(btnComplete, "/images/tool_complete");
oFunction.ConfigureToolButton(btnSLA, "/images/tool_sla");
btnDenied.Attributes.Add("onclick", "return CloseWindow();");
btnPrint.Attributes.Add("onclick", "return PrintWindow();");
btnClose.Attributes.Add("onclick", "return ExitWindow();");
//btnSave.Attributes.Add("onclick", "return ValidateStatus('" + ddlStatus.ClientID + "','" + txtComments.ClientID + "')" +
// ";");
btnStatus.Attributes.Add("onclick", "return ValidateStatus('" + ddlStatus.ClientID + "','" + txtComments.ClientID + "')" +
";");
imgDate.Attributes.Add("onclick", "return ShowCalendar('" + txtDate.ClientID + "');");
}
LoadRequest();
}
else
{
panDenied.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
Projects oProject = new Projects(intProfile, dsn);
Organizations oOrganization = new Organizations(intProfile, dsn);
Segment oSegment = new Segment(intProfile, dsn);
Users oUser = new Users(intProfile, dsn);
StatusLevels oStatusLevel = new StatusLevels();
StringBuilder sb = new StringBuilder(strBody);
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
int intProject = Int32.Parse(Request.QueryString["id"]);
DataSet ds = oProject.Get(intProject);
if (ds.Tables[0].Rows.Count > 0)
{
sb.Append("<tr><td nowrap><b>Project Name:</b></td><td>");
sb.Append(ds.Tables[0].Rows[0]["name"].ToString());
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap><b>Project Number:</b></td><td>");
sb.Append(ds.Tables[0].Rows[0]["number"].ToString());
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap><b>Initiative Type:</b></td><td>");
sb.Append(ds.Tables[0].Rows[0]["bd"].ToString());
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap><b>Organization:</b></td><td>");
sb.Append(oOrganization.GetName(Int32.Parse(ds.Tables[0].Rows[0]["organization"].ToString())));
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap><b>Segment:</b></td><td>");
sb.Append(oSegment.GetName(Int32.Parse(ds.Tables[0].Rows[0]["segmentid"].ToString())));
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap><b>Project Lead:</b></td><td>");
sb.Append(oUser.GetFullName(Int32.Parse(ds.Tables[0].Rows[0]["lead"].ToString())));
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap><b>Executive Sponsor:</b></td><td>");
sb.Append(oUser.GetFullName(Int32.Parse(ds.Tables[0].Rows[0]["executive"].ToString())));
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap><b>Working Sponsor:</b></td><td>");
sb.Append(oUser.GetFullName(Int32.Parse(ds.Tables[0].Rows[0]["working"].ToString())));
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap><b>Integration Engineer:</b></td><td>");
sb.Append(oUser.GetFullName(Int32.Parse(ds.Tables[0].Rows[0]["engineer"].ToString())));
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap><b>Technical Lead:</b></td><td>");
sb.Append(oUser.GetFullName(Int32.Parse(ds.Tables[0].Rows[0]["technical"].ToString())));
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap><b>Status:</b></td><td>");
sb.Append(oStatusLevel.HTML(Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString())));
sb.Append("</td></tr>");
}
}
if (sb.ToString() != "")
{
sb.Insert(0, "<table border=\"0\" cellpadding=\"4\" cellspacing=\"3\">");
sb.Append("</table>");
}
strBody = sb.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oProjectRequest = new ProjectRequest(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oProjectNumber = new ProjectNumber(intProfile, dsn);
oPage = new Pages(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oRequestItem = new RequestItems(intProfile, dsn);
oApplication = new Applications(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oVariable = new Variables(intEnvironment);
oService = new Services(intProfile, dsn);
oDelegate = new Delegates(intProfile, dsn);
oStatusLevel = new StatusLevels();
oServiceDetail = new ServiceDetails(intProfile, dsn);
oLog = new Log(intProfile, dsn);
if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "")
{
intPage = Int32.Parse(Request.QueryString["pageid"]);
}
if (Request.QueryString["action"] != null && Request.QueryString["action"] != "")
{
panFinish.Visible = true;
}
else
{
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 (!IsPostBack)
{
if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "")
{
lblResourceParent.Text = Request.QueryString["rrid"];
int intResourceParent = Int32.Parse(lblResourceParent.Text);
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 intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
int intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString());
int intProject = Int32.Parse(oRequest.Get(intRequest, "projectid"));
int intApp = oRequestItem.GetItemApplication(intItem);
int intForecast = 0;
Forecast oForecast = new Forecast(intProfile, dsn);
DataSet dsForecast = oForecast.GetProject(intProject);
if (dsForecast.Tables[0].Rows.Count > 0)
{
intForecast = Int32.Parse(dsForecast.Tables[0].Rows[0]["id"].ToString());
}
if (intForecast > 0)
{
btnView.Attributes.Add("oncontextmenu", "return OpenWindow('NEW_WINDOW','" + oPage.GetFullLink(intDesignBuilder) + "?id=" + intForecast.ToString() + "');");
}
else
{
btnView.Attributes.Add("oncontextmenu", "alert('There is no design for this project');return false;");
}
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 = "Click here to view the project details";
lblType.Text = "Project Request";
}
else
{
btnView.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intViewResourceRequest.ToString() + "&rrid=" + intResourceParent.ToString() + "');");
if (oApplication.Get(intApp, "tpm") == "1")
{
btnView.Text = "Click here to view the project details";
}
else
{
btnView.Text = "Click here to view this request";
}
lblType.Text = "Service Request";
}
btnAssignments.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intSearchPage.ToString() + "&pid=" + intProject + "&aid=" + intApp.ToString() + "&sort=userid');");
lblItem.Text = intItem.ToString();
lblService.Text = oService.GetName(intService);
lblServiceID.Text = intService.ToString();
if (oApplication.Get(intApp, "request_items") == "1")
{
lblGroup.Text = oApplication.GetName(intApp) + " | " + oRequestItem.GetItemName(intItem);
}
else
{
lblGroup.Text = oApplication.GetName(intApp);
}
int intUser = Int32.Parse(oRequest.Get(intRequest, "userid"));
int intAppManager = oApplication.GetManager(intApp);
if (ds.Tables[0].Rows[0]["accepted"].ToString() == "-1" && oApplication.Get(intApp, "tpm") == "1")
{
if (intUser == intProfile || oDelegate.Get(intUser, intProfile) > 0)
{
panRequest.Visible = true;
panAssignSingle.Visible = true;
txtHours.Text = double.Parse(ds.Tables[0].Rows[0]["allocated"].ToString()).ToString("F");
lblHoursOverall.Text = double.Parse(ds.Tables[0].Rows[0]["allocated"].ToString()).ToString("F");
txtQuantityOverall.Text = ds.Tables[0].Rows[0]["devices"].ToString();
txtQuantityOverall.Enabled = false;
txtQuantity.Text = txtQuantityOverall.Text;
txtQuantity.Enabled = false;
lblHours.Visible = true;
lblHours.Text = txtHours.Text;
lblStatus.Text = oStatusLevel.HTML(Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString()));
txtQuantity.Text = ds.Tables[0].Rows[0]["devices"].ToString();
btnAssign.Enabled = (txtQuantity.Text != "0");
lblAssignBy.Text = oUser.GetFullName(intProfile);
strSummary = oResourceRequest.GetBodyOverallFix(intResourceParent, 0, intEnvironment, false);
}
else
{
Response.Write("no rights");
panDenied.Visible = true;
}
btnSubmit.Attributes.Add("onclick", "return ValidateNumber0('" + txtHours.ClientID + "','Please enter a valid number for the hours allocated') && ValidateHidden('" + hdnManager.ClientID + "','" + txtManager.ClientID + "','Please enter a valid LAN ID') && ProcessButton(this);");
}
else
{
if (oUser.IsAdmin(intProfile) || oService.IsManager(intService, intProfile) || (oApplication.IsManager(intApp, intProfile) && oApplication.Get(intApp, "disable_manager") != "1"))
{
panRequest.Visible = true;
panAssignMultiple.Visible = true;
btnSubmit.Enabled = (ds.Tables[0].Rows[0]["assigned"].ToString() == "");
if (ds.Tables[0].Rows[0]["status"].ToString() == "5")
{
radHold.Checked = true;
divChoice.Style["display"] = "inline";
divHold.Style["display"] = "inline";
txtHold.Text = ds.Tables[0].Rows[0]["reason"].ToString();
}
else
{
divChoice.Style["display"] = (ds.Tables[0].Rows[0]["accepted"].ToString() == "0" ? "inline" : "none");
if (Request.QueryString["assign"] != null)
{
divAccept.Style["display"] = "inline";
radAccept.Checked = true;
}
else
{
divAccept.Style["display"] = (ds.Tables[0].Rows[0]["accepted"].ToString() == "1" ? "inline" : "none");
}
}
panDelete.Visible = (intItem == intImplementorDistributed || intItem == intImplementorMidrange);
btnDelete.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this request');");
txtHours.Text = double.Parse(ds.Tables[0].Rows[0]["allocated"].ToString()).ToString("F");
lblHoursOverall.Text = double.Parse(ds.Tables[0].Rows[0]["allocated"].ToString()).ToString("F");
txtQuantityOverall.Text = ds.Tables[0].Rows[0]["devices"].ToString();
if (oApplication.Get(intApp, "tpm") == "1")
{
lblHours.Visible = true;
lblHours.Text = txtHours.Text;
txtQuantityOverall.Enabled = false;
txtQuantity.Enabled = false;
btnAssign.Attributes.Add("onclick", "return ValidateDropDown('" + ddlUser.ClientID + "','Please select a technician')" +
" && ProcessButton(this)" +
";");
}
else if (oServiceDetail.Gets(intService, 1).Tables[0].Rows.Count > 0)
{
lblHours.Visible = true;
lblHours.Text = "TBD ";
btnWhy.Visible = true;
btnAssign.Attributes.Add("onclick", "return ValidateDropDown('" + ddlUser.ClientID + "','Please select a technician')" +
" && ValidateNumber0('" + txtQuantity.ClientID + "','Please enter the quantity')" +
" && ProcessButton(this)" +
";");
}
else if (oService.Get(intService, "disable_hours") == "1")
{
lblHours.Visible = true;
lblHours.Text = txtHours.Text;
btnAssign.Attributes.Add("onclick", "return ValidateDropDown('" + ddlUser.ClientID + "','Please select a technician')" +
" && ValidateNumber0('" + txtQuantity.ClientID + "','Please enter the quantity')" +
" && ProcessButton(this)" +
";");
}
else
{
txtHours.Visible = true;
btnAssign.Attributes.Add("onclick", "return ValidateDropDown('" + ddlUser.ClientID + "','Please select a technician')" +
" && ValidateNumber0('" + txtQuantity.ClientID + "','Please enter the quantity')" +
" && ValidateNumber0('" + txtHours.ClientID + "','Please enter the hours')" +
" && ProcessButton(this)" +
";");
}
btnUpdate.Attributes.Add("onclick", "return ValidateNumber0('" + txtQuantityOverall.ClientID + "') && ProcessButton(this);");
DataSet dsAssigned = oResourceRequest.GetWorkflowsAssign(intResourceParent);
int intQuantity = Int32.Parse(ds.Tables[0].Rows[0]["devices"].ToString());
foreach (DataRow drAssigned in dsAssigned.Tables[0].Rows)
{
intQuantity = intQuantity - Int32.Parse(drAssigned["devices"].ToString());
}
txtQuantity.Text = intQuantity.ToString();
btnAssign.Enabled = (txtQuantity.Text != "0");
lblStatus.Text = oStatusLevel.HTML(Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString()));
lblAssigned.Visible = !(btnSubmit.Enabled);
string strAssign = "";
DataSet dsManager = oService.GetUser(intService, 1);
foreach (DataRow drManager in dsManager.Tables[0].Rows)
{
if (strAssign != "")
{
strAssign += ", ";
}
strAssign += oUser.GetFullName(Int32.Parse(drManager["userid"].ToString()));
}
lblAssignBy.Text = strAssign;
DataSet dsReports = oUser.GetManagerReports(intAppManager, intRequest, intService, intNumber);
DataTable dtReports = dsReports.Tables[0].Copy();
dtReports.Clear();
DataSet dsAssignment = oService.GetUser(intService, -100);
foreach (DataRow drAssignment in dsAssignment.Tables[0].Rows)
{
int intAssignment = Int32.Parse(drAssignment["userid"].ToString());
DataSet dsAssignees = oUser.GetManagerReports(intAssignment, intRequest, intService, intNumber);
foreach (DataRow drAssignee in dsAssignees.Tables[0].Rows)
{
dtReports.ImportRow(drAssignee);
}
}
if (dtReports.Rows.Count > 0)
{
// Use custom assignment list
// First, remove duplicates
Hashtable hTable = new Hashtable();
ArrayList duplicateList = new ArrayList();
foreach (DataRow drow in dtReports.Rows)
{
if (hTable.Contains(drow["userid"]))
{
duplicateList.Add(drow);
}
else
{
hTable.Add(drow["userid"], string.Empty);
}
}
foreach (DataRow dRow in duplicateList)
{
dtReports.Rows.Remove(dRow);
}
// Next, sort by username
dtReports.DefaultView.Sort = "username";
// Now add to dataset
dsReports = new DataSet();
dsReports.Tables.Add(dtReports.DefaultView.ToTable());
}
LoadList(dsReports, intApp);
LoadAvailable(dsReports, intApp);
rptAssign.DataSource = dsAssigned;
rptAssign.DataBind();
foreach (RepeaterItem ri in rptAssign.Items)
{
((LinkButton)ri.FindControl("btnDeleteAssign")).Attributes.Add("onclick", "return confirm('Are you sure you want to delete this assignment?');");
}
lblAssign.Visible = (rptAssign.Items.Count == 0);
strSummary = oResourceRequest.GetBodyOverallFix(intResourceParent, 0, intEnvironment, false);
btnSubmit.Attributes.Add("onclick", "return ValidateChoice('" + divChoice.ClientID + "','" + radAccept.ClientID + "','" + radReject.ClientID + "','" + radHold.ClientID + "'," + dsAssigned.Tables[0].Rows.Count.ToString() + ") && ProcessButton(this);");
}
else
{
Response.Write("no delegate");
panDenied.Visible = true;
}
}
}
else
{
panDenied.Visible = true;
}
}
else
{
panDenied.Visible = true;
}
}
}
btnClose.Attributes.Add("onclick", "return CloseWindow();");
lnkAvailable.Attributes.Add("onclick", "return ShowHideAvailable('" + divAvailable.ClientID + "');");
radAccept.Attributes.Add("onclick", "ShowHideDiv('" + divAccept.ClientID + "','inline');ShowHideDiv('" + divReject.ClientID + "','none');ShowHideDiv('" + divHold.ClientID + "','none');");
radReject.Attributes.Add("onclick", "ShowHideDiv('" + divReject.ClientID + "','inline');ShowHideDiv('" + divAccept.ClientID + "','none');ShowHideDiv('" + divHold.ClientID + "','none');");
radHold.Attributes.Add("onclick", "ShowHideDiv('" + divHold.ClientID + "','inline');ShowHideDiv('" + divAccept.ClientID + "','none');ShowHideDiv('" + divReject.ClientID + "','none');");
txtManager.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'300','195','" + divManager.ClientID + "','" + lstManager.ClientID + "','" + hdnManager.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstManager.Attributes.Add("ondblclick", "AJAXClickRow();");
btnWhy.Attributes.Add("onclick", "return ShowHideAvailable('" + divWhy.ClientID + "');");
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oPage = new Pages(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oProject = new Projects(intProfile, dsn);
oOrganization = new Organizations(intProfile, dsn);
oSegment = new Segment(intProfile, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oVariable = new Variables(intEnvironment);
//oProjectPending = new ProjectsPending(intProfile, dsn, intEnvironment);
//oRequest = new Requests(intProfile, dsn);
oStatusLevel = new StatusLevels();
oForecast = new Forecast(intProfile, dsn);
//oModel = new Models(intProfile, dsn);
//oType = new Types(intProfile, dsn);
//oModelsProperties = new ModelsProperties(intProfile, dsn);
//oPlatform = new Platforms(intProfile, dsn);
//oConfidence = new Confidence(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);
}
lblTitle.Text = oPage.Get(intPage, "title");
if (Request.QueryString["project"] != null && Request.QueryString["project"] != "")
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "projectsaved", "<script type=\"text/javascript\">alert('Project Information Saved');<" + "/" + "script>");
}
if (!IsPostBack)
{
if (Request.QueryString["name"] != null)
{
string strQuery = oFunction.decryptQueryString(Request.QueryString["name"]);
txtNameSearch.Text = strQuery;
CheckResults(strQuery, "", 0, 0);
}
else if (Request.QueryString["number"] != null)
{
string strQuery = oFunction.decryptQueryString(Request.QueryString["number"]);
txtNumberSearch.Text = strQuery;
CheckResults("", strQuery, 0, 0);
}
else if (Request.QueryString["lead"] != null)
{
int intQuery = Int32.Parse(oFunction.decryptQueryString(Request.QueryString["lead"]));
txtManagerSearch.Text = oUser.GetFullName(intQuery) + " (" + oUser.GetName(intQuery) + ")";
hdnManagerSearch.Value = intQuery.ToString();
CheckResults("", "", intQuery, 0);
}
else if (Request.QueryString["engineer"] != null)
{
int intQuery = Int32.Parse(oFunction.decryptQueryString(Request.QueryString["engineer"]));
txtEngineerSearch.Text = oUser.GetFullName(intQuery) + " (" + oUser.GetName(intQuery) + ")";
hdnEngineerSearch.Value = intQuery.ToString();
CheckResults("", "", 0, intQuery);
}
else if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
LoadLists();
LoadProject(Int32.Parse(oFunction.decryptQueryString(Request.QueryString["id"])));
}
else
{
panNone.Visible = true;
}
txtWorking.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'250','195','" + divWorking.ClientID + "','" + lstWorking.ClientID + "','" + hdnWorking.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstWorking.Attributes.Add("ondblclick", "AJAXClickRow();");
txtExecutive.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'250','195','" + divExecutive.ClientID + "','" + lstExecutive.ClientID + "','" + hdnExecutive.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstExecutive.Attributes.Add("ondblclick", "AJAXClickRow();");
txtManager.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'250','195','" + divManager.ClientID + "','" + lstManager.ClientID + "','" + hdnManager.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstManager.Attributes.Add("ondblclick", "AJAXClickRow();");
txtEngineer.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'250','195','" + divEngineer.ClientID + "','" + lstEngineer.ClientID + "','" + hdnEngineer.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstEngineer.Attributes.Add("ondblclick", "AJAXClickRow();");
txtLead.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'250','195','" + divLead.ClientID + "','" + lstLead.ClientID + "','" + hdnLead.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstLead.Attributes.Add("ondblclick", "AJAXClickRow();");
txtManagerSearch.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'250','195','" + divManagerSearch.ClientID + "','" + lstManagerSearch.ClientID + "','" + hdnManagerSearch.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstManagerSearch.Attributes.Add("ondblclick", "AJAXClickRow();");
txtEngineerSearch.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'250','195','" + divEngineerSearch.ClientID + "','" + lstEngineerSearch.ClientID + "','" + hdnEngineerSearch.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstEngineerSearch.Attributes.Add("ondblclick", "AJAXClickRow();");
ddlPortfolio.Attributes.Add("onchange", "PopulateSegments('" + ddlPortfolio.ClientID + "','" + ddlSegment.ClientID + "');");
ddlSegment.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlSegment.ClientID + "','" + hdnSegment.ClientID + "');");
}
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
if (Request.Cookies["profileid"] != null && Request.Cookies["profileid"].Value != "")
{
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);
oServiceDetail = new ServiceDetails(intProfile, dsn);
oStatusLevel = new StatusLevels(intProfile, dsn);
oLog = new Log(intProfile, dsn);
if (Request.QueryString["save"] != null)
{
panSave.Visible = true;
}
if (Request.QueryString["close"] != null)
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">window.close();<" + "/" + "script>");
}
if (!IsPostBack)
{
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
lblResourceWorkflow.Text = Request.QueryString["id"];
int intResourceWorkflow = Int32.Parse(lblResourceWorkflow.Text);
int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow);
string strHeader = intResourceWorkflow.ToString();
lblHeader.Text = """ + strHeader + """;
Master.Page.Title = "DataPoint | Resource (" + strHeader + ") Administration";
lblHeaderSub.Text = "Provides administration of a resource request...";
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 intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString());
int intProject = oRequest.GetProjectNumber(intRequest);
if (oService.Get(intService, "disable_hours") != "1")
{
txtAllocated.Enabled = false;
txtAllocated.ToolTip = intService.ToString();
panDynamic.Visible = true;
}
bool boolManager = false;
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;
string strStatus = ds.Tables[0].Rows[0]["status"].ToString();
ddlStatus.DataValueField = "StatusValue";
ddlStatus.DataTextField = "StatusDescription";
ddlStatus.DataSource = oStatusLevel.GetStatusList("RRWFSTATUS");
ddlStatus.DataBind();
ddlStatus.SelectedValue = strStatus;
int intAppManager = oApplication.GetManager(intApp);
LoadList(intAppManager, intApp);
LoadAvailable(intAppManager, intApp, intRequest, intService, intNumber);
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;
}
try
{
ddlActivity.SelectedValue = intItem.ToString();
lblActivity.Text = ddlActivity.SelectedItem.Text;
hdnUser.Value = intUser.ToString();
txtUser.Text = oUser.GetFullName(intUser) + " (" + oUser.GetName(intUser) + ")";
lblUser.Text = txtUser.Text;
}
catch { }
if (boolManager == true)
{
Master.Page.Title = "Resource Request #" + intResourceWorkflow.ToString() + " Management View";
panView.Visible = true;
panManager.Visible = true;
txtAllocated.Visible = true;
txtDevices.Visible = true;
ddlActivity.Visible = true;
panUser.Visible = true;
ddlStatus.Enabled = true;
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')" +
" && ValidateHidden0('" + hdnUser.ClientID + "','" + txtUser.ClientID + "','Please select an assigned technician')" +
" && ProcessControlButton()" +
";");
btnSaveClose.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')" +
" && ValidateHidden0('" + hdnUser.ClientID + "','" + txtUser.ClientID + "','Please select an assigned technician')" +
" && ProcessControlButton()" +
";");
}
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;
}
txtUser.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'300','195','" + divUser.ClientID + "','" + lstUser.ClientID + "','" + hdnUser.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstUser.Attributes.Add("ondblclick", "AJAXClickRow();");
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)
{
AuthenticateUser();
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
StringBuilder sb = new StringBuilder(strQuestions);
oForecast = new Forecast(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oProject = new Projects(intProfile, dsn);
oProjectPending = new ProjectsPending(intProfile, dsn, intEnvironment);
oRequest = new Requests(intProfile, dsn);
oOrganization = new Organizations(intProfile, dsn);
oStatusLevel = new StatusLevels();
oPlatform = new Platforms(intProfile, dsn);
oModel = new Models(intProfile, dsn);
oModelsProperties = new ModelsProperties(intProfile, dsn);
int intForecast = Int32.Parse(Request.QueryString["id"]);
if (!IsPostBack)
{
Document doc = new Document();
iTextSharp.text.Table oTable = new iTextSharp.text.Table(2);
oTable.BorderWidth = 0;
oTable.BorderColor = new iTextSharp.text.Color(255, 255, 255);
oTable.Padding = 2;
oTable.Width = 100;
iTextSharp.text.Font oFontHeader = new iTextSharp.text.Font(iTextSharp.text.Font.HELVETICA, 10, 1);
iTextSharp.text.Font oFontBold = new iTextSharp.text.Font(iTextSharp.text.Font.HELVETICA, 8, 1);
iTextSharp.text.Font oFont = new iTextSharp.text.Font(iTextSharp.text.Font.HELVETICA, 8, 0);
if (Request.QueryString["export"] != null)
{
PdfWriter.GetInstance(doc, Response.OutputStream);
string strHeader = "ClearView Design Summary";
HeaderFooter header = new HeaderFooter(new Phrase(strHeader, new iTextSharp.text.Font(iTextSharp.text.Font.HELVETICA, 6)), false);
header.Border = iTextSharp.text.Rectangle.NO_BORDER;
header.Alignment = 2;
doc.Header = header;
string strFooter = DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToLongTimeString();
HeaderFooter footer = new HeaderFooter(new Phrase(strFooter, new iTextSharp.text.Font(iTextSharp.text.Font.HELVETICA, 6)), false);
footer.Border = iTextSharp.text.Rectangle.NO_BORDER;
footer.Alignment = 2;
doc.Footer = footer;
doc.Open();
//iTextSharp.text.Image gif = iTextSharp.text.Image.GetInstance(Request.MapPath("~/images/nc_logo.gif"));
//gif.Alignment = iTextSharp.text.Image.RIGHT_ALIGN;
//gif.ScalePercent(50f); // change it's size
//doc.Add(gif);
Cell cell = new Cell(new Phrase("General Information", oFontHeader));
cell.Colspan = 2;
cell.BackgroundColor = new iTextSharp.text.Color(204, 204, 204);
oTable.AddCell(cell);
}
DataSet ds = oForecast.Get(intForecast);
int intRequest = 0;
sb.Append("<table width=\"100%\" cellpadding=\"4\" cellspacing=\"3\" border=\"0\">");
sb.Append("<tr><td colspan=\"2\" class=\"header\">General Information</td></tr>");
if (ds.Tables[0].Rows.Count > 0)
{
oTable.AddCell(new Cell(new Phrase("Requestor:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(oUser.GetFullName(Int32.Parse(ds.Tables[0].Rows[0]["userid"].ToString())), oFont)));
sb.Append("<tr><td nowrap>Requestor:</td><td width=\"100%\">");
sb.Append(oUser.GetFullName(Int32.Parse(ds.Tables[0].Rows[0]["userid"].ToString())));
sb.Append("</td></tr>");
oTable.AddCell(new Cell(new Phrase("Submission Date:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(DateTime.Parse(ds.Tables[0].Rows[0]["created"].ToString()).ToLongDateString(), oFont)));
sb.Append("<tr><td nowrap>Submission Date:</td><td width=\"100%\">");
sb.Append(DateTime.Parse(ds.Tables[0].Rows[0]["created"].ToString()).ToLongDateString());
sb.Append("</td></tr>");
intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
}
int intManager = 0;
int intEngineer = 0;
int intLead = 0;
int intProject = oRequest.GetProjectNumber(intRequest);
if (intProject > 0)
{
DataSet dsProject = oProject.Get(intProject);
if (dsProject.Tables[0].Rows.Count > 0)
{
oTable.AddCell(new Cell(new Phrase("Project Name:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(dsProject.Tables[0].Rows[0]["name"].ToString(), oFont)));
oTable.AddCell(new Cell(new Phrase("Initiative Type:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(dsProject.Tables[0].Rows[0]["bd"].ToString(), oFont)));
oTable.AddCell(new Cell(new Phrase("Organization:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(oOrganization.GetName(Int32.Parse(dsProject.Tables[0].Rows[0]["organization"].ToString())), oFont)));
oTable.AddCell(new Cell(new Phrase("Project Number:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(dsProject.Tables[0].Rows[0]["number"].ToString(), oFont)));
oTable.AddCell(new Cell(new Phrase("Project Status:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(oStatusLevel.Name(Int32.Parse(dsProject.Tables[0].Rows[0]["status"].ToString())), oFont)));
sb.Append("<tr><td nowrap>Project Name:</td><td width=\"100%\">");
sb.Append(dsProject.Tables[0].Rows[0]["name"].ToString());
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap>Initiative Type:</td><td width=\"100%\">");
sb.Append(dsProject.Tables[0].Rows[0]["bd"].ToString());
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap>Organization:</td><td width=\"100%\">");
sb.Append(oOrganization.GetName(Int32.Parse(dsProject.Tables[0].Rows[0]["organization"].ToString())));
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap>Project Number:</td><td width=\"100%\">");
sb.Append(dsProject.Tables[0].Rows[0]["number"].ToString());
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap>Project Status:</td><td width=\"100%\">");
sb.Append(oStatusLevel.HTML(Int32.Parse(dsProject.Tables[0].Rows[0]["status"].ToString())));
sb.Append("</td></tr>");
intManager = Int32.Parse(dsProject.Tables[0].Rows[0]["lead"].ToString());
intEngineer = Int32.Parse(dsProject.Tables[0].Rows[0]["engineer"].ToString());
intLead = Int32.Parse(dsProject.Tables[0].Rows[0]["technical"].ToString());
}
}
else
{
DataSet dsPending = oProjectPending.GetRequest(intRequest);
if (dsPending.Tables[0].Rows.Count > 0)
{
oTable.AddCell(new Cell(new Phrase("Project Name:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(dsPending.Tables[0].Rows[0]["name"].ToString(), oFont)));
oTable.AddCell(new Cell(new Phrase("Initiative Type:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(dsPending.Tables[0].Rows[0]["bd"].ToString(), oFont)));
oTable.AddCell(new Cell(new Phrase("Organization:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(oOrganization.GetName(Int32.Parse(dsPending.Tables[0].Rows[0]["organization"].ToString())), oFont)));
oTable.AddCell(new Cell(new Phrase("Project Number:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(dsPending.Tables[0].Rows[0]["number"].ToString(), oFont)));
oTable.AddCell(new Cell(new Phrase("Project Status:", oFontBold)));
oTable.AddCell(new Cell(new Phrase("PENDING", oFont)));
sb.Append("<tr><td nowrap>Project Name:</td><td width=\"100%\">");
sb.Append(dsPending.Tables[0].Rows[0]["name"].ToString());
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap>Initiative Type:</td><td width=\"100%\">");
sb.Append(dsPending.Tables[0].Rows[0]["bd"].ToString());
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap>Organization:</td><td width=\"100%\">");
sb.Append(oOrganization.GetName(Int32.Parse(dsPending.Tables[0].Rows[0]["organization"].ToString())));
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap>Project Number:</td><td width=\"100%\">");
sb.Append(dsPending.Tables[0].Rows[0]["number"].ToString());
sb.Append("</td></tr>");
sb.Append("<tr><td nowrap>Project Status:</td><td width=\"100%\" class=\"pending\">PENDING</td></tr>");
intManager = Int32.Parse(dsPending.Tables[0].Rows[0]["lead"].ToString());
intEngineer = Int32.Parse(dsPending.Tables[0].Rows[0]["engineer"].ToString());
intLead = Int32.Parse(dsPending.Tables[0].Rows[0]["technical"].ToString());
}
}
if (intManager > 0)
{
sb.Append("<tr><td nowrap>Project Manager:</td><td width=\"100%\">");
sb.Append(oUser.GetFullName(intManager));
sb.Append("</td></tr>");
}
else
{
sb.Append("<tr><td nowrap>Project Manager:</td><td width=\"100%\"></td></tr>");
}
if (intEngineer > 0)
{
sb.Append("<tr><td nowrap>Integration Engineer:</td><td width=\"100%\">");
sb.Append(oUser.GetFullName(intEngineer));
sb.Append("</td></tr>");
}
else
{
sb.Append("<tr><td nowrap>Integration Engineer:</td><td width=\"100%\"></td></tr>");
}
if (intLead > 0)
{
sb.Append("<tr><td nowrap>Technical Lead:</td><td width=\"100%\">");
sb.Append(oUser.GetFullName(intLead));
sb.Append("</td></tr>");
}
else
{
sb.Append("<tr><td nowrap>Technical Lead:</td><td width=\"100%\"></td></tr>");
}
oTable.AddCell(new Cell(new Phrase("Project Manager:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(oUser.GetFullName(intManager), oFont)));
oTable.AddCell(new Cell(new Phrase("Integration Engineer:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(oUser.GetFullName(intEngineer), oFont)));
oTable.AddCell(new Cell(new Phrase("Technical Lead:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(oUser.GetFullName(intLead), oFont)));
oTable.AddCell(new Cell(new Phrase(" ", oFontBold)));
oTable.AddCell(new Cell(new Phrase(" ", oFont)));
Cell cell2 = new Cell(new Phrase("Line Items", oFontHeader));
cell2.Colspan = 2;
cell2.BackgroundColor = new iTextSharp.text.Color(204, 204, 204);
oTable.AddCell(cell2);
sb.Append("<tr><td colspan=\"2\"><hr size=\"1\" noshade /></td></tr>");
sb.Append("<tr><td colspan=\"2\" class=\"header\">Line Items</td></tr>");
sb.Append("<tr><td colspan=\"2\">");
ds = oForecast.GetAnswers(intForecast);
bool boolChange = false;
foreach (DataRow dr in ds.Tables[0].Rows)
{
int intID = Int32.Parse(dr["id"].ToString());
int intPlatform = Int32.Parse(dr["platformid"].ToString());
int intClass = Int32.Parse(dr["classid"].ToString());
int intEnvir = Int32.Parse(dr["environmentid"].ToString());
double dblQuantity = double.Parse(dr["quantity"].ToString()) + double.Parse(dr["recovery_number"].ToString());
int intModel = 0;
int intServerModel = oForecast.GetModelAsset(intID);
if (intServerModel == 0)
{
intServerModel = oForecast.GetModel(intID);
}
if (intServerModel == 0)
{
// Get the model selected in the equipment dropdown (if not server)
intModel = Int32.Parse(dr["modelid"].ToString());
}
double dblAmp = 0.00;
double dblReplicate = 0.00;
string strModel = "";
if (intServerModel > 0)
{
dblAmp = (double.Parse(oModelsProperties.Get(intServerModel, "amp")) * dblQuantity);
double.TryParse(oModelsProperties.Get(intServerModel, "replicate_times"), out dblReplicate);
if (intModel == 0)
{
intModel = Int32.Parse(oModelsProperties.Get(intServerModel, "modelid"));
}
strModel = oModelsProperties.Get(intServerModel, "name");
}
else if (intModel > 0)
{
strModel = oModel.Get(intModel, "name");
}
else
{
DataSet dsVendor = oForecast.GetAnswer(intID);
if (dsVendor.Tables[0].Rows.Count > 0 && dsVendor.Tables[0].Rows[0]["modelname"].ToString() != "")
{
dblAmp = (double.Parse(dsVendor.Tables[0].Rows[0]["amp"].ToString()) * dblQuantity);
strModel = dsVendor.Tables[0].Rows[0]["modelname"].ToString();
}
}
if (intModel == 0)
{
strModel = "Solution Unavailable";
}
// STORAGE
DataSet dsStorage = oForecast.GetStorage(intID);
double dblStorage = 0.00;
if (dsStorage.Tables[0].Rows.Count > 0)
{
double dblHigh = double.Parse(dsStorage.Tables[0].Rows[0]["high_total"].ToString()) + double.Parse(dsStorage.Tables[0].Rows[0]["high_qa"].ToString()) + double.Parse(dsStorage.Tables[0].Rows[0]["high_test"].ToString()) + (double.Parse(dsStorage.Tables[0].Rows[0]["high_replicated"].ToString()) * dblReplicate) + double.Parse(dsStorage.Tables[0].Rows[0]["high_ha"].ToString());
double dblStandard = double.Parse(dsStorage.Tables[0].Rows[0]["standard_total"].ToString()) + double.Parse(dsStorage.Tables[0].Rows[0]["standard_qa"].ToString()) + double.Parse(dsStorage.Tables[0].Rows[0]["standard_test"].ToString()) + (double.Parse(dsStorage.Tables[0].Rows[0]["standard_replicated"].ToString()) * dblReplicate) + double.Parse(dsStorage.Tables[0].Rows[0]["standard_ha"].ToString());
double dblLow = double.Parse(dsStorage.Tables[0].Rows[0]["low_total"].ToString()) + double.Parse(dsStorage.Tables[0].Rows[0]["low_qa"].ToString()) + double.Parse(dsStorage.Tables[0].Rows[0]["low_test"].ToString()) + (double.Parse(dsStorage.Tables[0].Rows[0]["low_replicated"].ToString()) * dblReplicate) + double.Parse(dsStorage.Tables[0].Rows[0]["low_ha"].ToString());
dblStorage = dblHigh + dblStandard + dblLow;
}
sb.Append("<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"background-color:");
sb.Append(boolChange ? "#FFFFFF" : "#F6F6F6");
sb.Append("\">");
sb.Append("<tr><td>");
sb.Append("<table width=\"100%\" cellpadding=\"5\" cellspacing=\"2\" border=\"0\">");
sb.Append("<tr><td valign=\"top\" nowrap>Nickname:</td><td>");
sb.Append(dr["name"].ToString());
sb.Append("</td></tr>");
sb.Append("<tr><td valign=\"top\" nowrap>Platform:</td><td>");
sb.Append(oPlatform.GetName(intPlatform));
sb.Append("</td></tr>");
oTable.AddCell(new Cell(new Phrase("Nickname:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(dr["name"].ToString(), oFont)));
oTable.AddCell(new Cell(new Phrase("Platform:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(oPlatform.GetName(intPlatform), oFont)));
oTable.AddCell(new Cell(new Phrase("Model:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(strModel, oFont)));
oTable.AddCell(new Cell(new Phrase("Commitment Date:", oFontBold)));
oTable.AddCell(new Cell(new Phrase((dr["implementation"].ToString() == "" ? "" : DateTime.Parse(dr["implementation"].ToString()).ToShortDateString()), oFont)));
oTable.AddCell(new Cell(new Phrase("Quantity:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(dblQuantity.ToString(), oFont)));
string strPDF = oModel.Get(intModel, "pdf");
sb.Append("<tr><td valign=\"top\" nowrap>Model:</td><td width=\"100%\">");
sb.Append(strPDF == "" ? strModel : "<a href=\"javascript:void(0);\" onclick=\"OpenNewWindowMAX('" + strPDF.Replace("\\", "\\\\") + "');\">" + strModel + "</a>");
sb.Append("</td></tr>");
sb.Append("<tr><td valign=\"top\" nowrap>Commitment Date:</td><td width=\"100%\">");
sb.Append(dr["implementation"].ToString() == "" ? "" : DateTime.Parse(dr["implementation"].ToString()).ToShortDateString());
sb.Append("</td></tr>");
sb.Append("<tr><td valign=\"top\" nowrap>Quantity:</td><td width=\"100%\"><a href=\"javascript:void(0);\" onclick=\"OpenNewWindow('/frame/forecast/forecast_print_quantity.aspx?id=");
sb.Append(intID.ToString());
sb.Append("',275,200);\">");
sb.Append(dblQuantity.ToString());
sb.Append("</a></td></tr>");
double dblA = 0.00;
DataSet dsA = oForecast.GetAcquisitions(intModel, 1);
foreach (DataRow drA in dsA.Tables[0].Rows)
{
dblA += double.Parse(drA["cost"].ToString());
}
sb.Append("<tr><td valign=\"top\" nowrap>Acquisition Costs:</td><td width=\"100%\"><a href=\"javascript:void(0);\" onclick=\"OpenNewWindow('/frame/forecast/forecast_print_acquisition.aspx?id=");
sb.Append(intID.ToString());
sb.Append("',400,300);\">$");
sb.Append(dblA.ToString("N"));
sb.Append("</a></td></tr>");
oTable.AddCell(new Cell(new Phrase("Acquisition Costs:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(dblA.ToString("N"), oFont)));
double dblO = 0.00;
DataSet dsO = oForecast.GetOperations(intModel, 1);
foreach (DataRow drO in dsO.Tables[0].Rows)
{
dblO += double.Parse(drO["cost"].ToString());
}
oTable.AddCell(new Cell(new Phrase("Operational Costs:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(dblO.ToString("N"), oFont)));
oTable.AddCell(new Cell(new Phrase("Storage:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(dblStorage.ToString("N") + " GB", oFont)));
oTable.AddCell(new Cell(new Phrase("AMPs:", oFontBold)));
oTable.AddCell(new Cell(new Phrase(dblAmp.ToString("N") + " AMPs", oFont)));
sb.Append("<tr><td valign=\"top\" nowrap>Operational Costs:</td><td width=\"100%\"><a href=\"javascript:void(0);\" onclick=\"OpenNewWindow('/frame/forecast/forecast_print_operational.aspx?id=");
sb.Append(intID.ToString());
sb.Append("',400,300);\">$");
sb.Append(dblO.ToString("N"));
sb.Append("</a></td></tr>");
sb.Append("<tr><td valign=\"top\" nowrap>Storage:</td><td width=\"100%\"><a href=\"javascript:void(0);\" onclick=\"OpenNewWindow('/frame/forecast/forecast_print_storage.aspx?id=");
sb.Append(intID.ToString());
sb.Append("',650,200);\">");
sb.Append(dblStorage.ToString("N"));
sb.Append(" GB</a></td></tr>");
sb.Append("<tr><td valign=\"top\" nowrap>AMPs:</td><td width=\"100%\">");
sb.Append(dblAmp.ToString("N"));
sb.Append("</td></tr>");
if (Request.QueryString["checked"] != null)
{
sb.Append("<tr><td valign=\"top\" colspan=\"2\"><b>Questions & Responses</b></td></tr>");
DataSet dsQuestions = oForecast.GetQuestionPlatform(intPlatform, intClass, intEnvir);
foreach (DataRow drQuestion in dsQuestions.Tables[0].Rows)
{
string strResponse = "";
string strResponsePDF = "";
int intQuestion = Int32.Parse(drQuestion["id"].ToString());
DataSet dsAnswers = oForecast.GetAnswerPlatform(intID, intQuestion);
foreach (DataRow drAnswer in dsAnswers.Tables[0].Rows)
{
strResponse += "<tr><td valign=\"top\"></td><td> " + oForecast.GetResponse(Int32.Parse(drAnswer["responseid"].ToString()), "response") + "</td></tr>";
if (strResponsePDF != "")
{
strResponsePDF += ", ";
}
strResponsePDF += oForecast.GetResponse(Int32.Parse(drAnswer["responseid"].ToString()), "response");
}
if (strResponse != "")
{
sb.Append("<tr><td valign=\"top\" colspan=\"2\"><table cellpadding=\"1\" cellspacing=\"1\" border=\"0\">");
sb.Append("<tr><td valign=\"top\"><img src=\"/images/help.gif\" align=\"absmiddle\" border=\"0\"/></td><td>");
sb.Append(drQuestion["question"].ToString());
sb.Append("</td></tr>");
Cell oCellQ = new Cell(new Phrase(drQuestion["question"].ToString(), oFontBold));
oCellQ.Colspan = 2;
oTable.AddCell(oCellQ);
Cell oCellA = new Cell(new Phrase(strResponsePDF, oFont));
oCellA.Colspan = 2;
oTable.AddCell(oCellA);
sb.Append(strResponse);
sb.Append("</table></td></tr>");
}
}
}
sb.Append("</table></td></tr>");
Cell oCellD = new Cell(new Phrase("", oFont));
oCellD.Colspan = 2;
oCellD.BackgroundColor = new iTextSharp.text.Color(100, 100, 100);
oTable.AddCell(oCellD);
sb.Append("<tr height=\"1\"><td colspan=\"2\" style=\"border-bottom:dashed 1px #CCCCCC\"><img src=\"/images/spacer.gif\" border=\"0\" width=\"1\" height=\"1\" /></td></tr>");
sb.Append("</table>");
boolChange = !boolChange;
}
sb.Append("</td></tr>");
chkQuestions.Checked = (Request.QueryString["checked"] != null);
chkQuestions.Attributes.Add("onclick", "WaitDDL('" + divWait.ClientID + "');");
if (Request.QueryString["export"] != null)
{
doc.Add(oTable);
doc.Close();
Response.ContentType = "application/pdf";
Response.AddHeader("Content-Disposition", "attachment; filename=export.pdf");
Response.End();
Response.Flush();
}
}
strQuestions = sb.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oProjectRequest = new ProjectRequest(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oRequestItem = new RequestItems(intProfile, dsn);
oProject = new Projects(intProfile, dsn);
oPage = new Pages(intProfile, dsn);
oVariable = new Variables(intEnvironment);
oApplication = new Applications(intProfile, dsn);
oProjectNumber = new ProjectNumber(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oRequestField = new RequestFields(intProfile, dsn);
oDocument = new Documents(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oStatus = new StatusLevels();
oService = new Services(intProfile, dsn);
oDelegate = new Delegates(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["pid"] != null && Request.QueryString["pid"] != "")
{
int intProject = Int32.Parse(Request.QueryString["pid"]);
lblProject.Text = intProject.ToString();
ds = oProject.GetCoordinator(intProject, 0);
int intCoordinator = 0;
int intRequest = 0;
int intResource = 0;
bool boolCoordinator = false;
bool boolTPM = false;
foreach (DataRow dr in ds.Tables[0].Rows)
{
if ((Int32.Parse(dr["userid"].ToString()) == intProfile || oDelegate.Get(Int32.Parse(dr["userid"].ToString()), intProfile) > 0) && (Request.QueryString["search"] == null))
{
if (dr["tpm"].ToString() == "1")
{
boolTPM = true;
}
else
{
boolCoordinator = true;
}
}
}
if (ds.Tables[0].Rows.Count > 0)
{
//panProject.Visible = true;
intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
intResource = Int32.Parse(ds.Tables[0].Rows[0]["id"].ToString());
intCoordinator = Int32.Parse(ds.Tables[0].Rows[0]["userid"].ToString());
lblCoordinator.Text = oUser.GetFullName(intCoordinator);
lblPhone.Text = (oUser.Get(intCoordinator, "phone") == "" ? "N / A" : oUser.Get(intCoordinator, "phone"));
string strEmail = oUser.GetEmail(oUser.GetName(intCoordinator), intEnvironment);
lblEmail.Text = (strEmail == "" ? "N / A" : "<a href=\"mailto:" + strEmail + "\" target=\"_blank\">" + strEmail + "</a>");
string strPager = oUser.Get(intCoordinator, "pager");
lblMobileDevice.Text = (strPager == "" || strPager == "0" ? "N / A" : strPager);
string strAt = oUser.Get(intCoordinator, "atid");
if (strAt != "0" && strAt != "")
{
Users_At oUserAt = new Users_At(intProfile, dsn);
strPager += "@" + oUserAt.GetName(Int32.Parse(strAt));
lblMobileEmail.Text = "<a href=\"mailto:" + strPager + "\" target=\"_blank\">" + strPager + "</a>";
}
else
{
lblMobileEmail.Text = "N / A";
}
}
lblRequest.Text = intRequest.ToString();
if (Request.QueryString["comm"] != null && Request.QueryString["comm"] != "")
{
trCommunication.Visible = true;
}
if (boolTPM == true)
{
// if (CheckConfigured(intProject, intRequest, intResource) == true)
// {
panControl.Visible = true;
Control oControl = (Control)LoadControl(strTPMWM);
phControl.Controls.Add(oControl);
LoadProject(intProject);
// }
// else
// panConfigure.Visible = true;
}
else if (boolCoordinator == true)
{
panControl.Visible = true;
Control oControl = (Control)LoadControl(strPCWM);
phControl.Controls.Add(oControl);
LoadProject(intProject);
}
else if (oApplication.GetName(intApplication).Contains("IDC") == true || oApplication.GetName(intApplication).Contains("Integration Engineer") == true)
{
panControl.Visible = true;
Control oControl = (Control)LoadControl("/controls/wm/wm_ie.ascx");
phControl.Controls.Add(oControl);
LoadProject(intProject);
}
else
{
panWorkload.Visible = true;
ds = oResourceRequest.GetWorkflowProjectAll(intProject);
if (ds.Tables[0].Rows.Count > 0)
{
ds = oProjectRequest.GetProject(intProject);
if (ds.Tables[0].Rows.Count > 0)
{
btnViewPR.Text = "View Original Project Request";
btnViewPR.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intViewRequest.ToString() + "&rid=" + intRequest.ToString() + "');");
}
else
{
//if (intResource > 0)
//{
// btnViewPR.Text = "View Original Request Details";
// btnViewPR.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intViewResourceRequest.ToString() + "&rrid=" + intResource.ToString() + "');");
//}
//else
btnViewPR.Visible = false;
}
// Documents
btnDocuments.Attributes.Add("onclick", "return OpenWindow('DOCUMENTS_SECURE','?pid=" + intProject.ToString() + "');");
chkMyDescription.Checked = (Request.QueryString["mydoc"] != null);
lblMyDocuments.Text = oDocument.GetDocuments_Mine(intProject, intProfile, oVariable.DocumentsFolder(), -1, (Request.QueryString["mydoc"] != null));
// GetDocuments(string _physical, int _projectid, int _requestid, int _userid, int _security, bool _show_description, bool _mine)
//lblMyDocuments.Text = oDocument.GetDocuments(Request.PhysicalApplicationPath, intProject, 0, intProfile, -1, (Request.QueryString["mydoc"] != null), true);
chkDescription.Checked = (Request.QueryString["doc"] != null);
lblDocuments.Text = oDocument.GetDocuments_Project(intProject, intProfile, oVariable.DocumentsFolder(), 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, intProject, 0, intProfile, 1, (Request.QueryString["doc"] != null), false);
/*
* ds = oResourceRequest.GetWorkflowProject(intProject);
* int intOldUser = 0;
* foreach (DataRow dr in ds.Tables[0].Rows)
* {
* if (intOldUser == Int32.Parse(dr["userid"].ToString()))
* dr.Delete();
* else
* intOldUser = Int32.Parse(dr["userid"].ToString());
* }
* ddlResource.DataValueField = "userid";
* ddlResource.DataTextField = "userid";
* ddlResource.DataSource = ds;
* ddlResource.DataBind();
* foreach (ListItem oItem in ddlResource.Items)
* oItem.Text = oUser.GetFullName(Int32.Parse(oItem.Value));
* ddlResource.Items.Insert(0, new ListItem("-- SELECT --", "0"));
* // Load Involvement
* DataSet dsInvolvement = oResourceRequest.GetWorkflowProject(intProject);
* int intOldItem = 0;
* intOldUser = 0;
* foreach (DataRow dr in dsInvolvement.Tables[0].Rows)
* {
* if (intImplementorDistributed == Int32.Parse(dr["itemid"].ToString()))
* dr.Delete();
* else if (intImplementorMidrange == Int32.Parse(dr["itemid"].ToString()))
* dr.Delete();
* else if (intOldItem == Int32.Parse(dr["itemid"].ToString()) && intOldUser == Int32.Parse(dr["userid"].ToString()))
* dr.Delete();
* else
* {
* intOldItem = Int32.Parse(dr["itemid"].ToString());
* intOldUser = Int32.Parse(dr["userid"].ToString());
* }
* }
* rptInvolvement.DataSource = dsInvolvement;
* rptInvolvement.DataBind();
* lblNoInvolvement.Visible = (rptInvolvement.Items.Count == 0);
* foreach (RepeaterItem ri in rptInvolvement.Items)
* {
* Label _id = (Label)ri.FindControl("lblId");
* Label _user = (Label)ri.FindControl("lblUser");
* Label _status = (Label)ri.FindControl("lblStatus");
* int intStatus = Int32.Parse(_status.Text);
* int intUser = Int32.Parse(_user.Text);
* _user.Text = oUser.GetFullName(intUser);
* Label _item = (Label)ri.FindControl("lblItem");
* int intItem = Int32.Parse(_item.Text);
* Label _allocated = (Label)ri.FindControl("lblAllocated");
* Label _used = (Label)ri.FindControl("lblUsed");
* double dblAllocated = oResourceRequest.GetAllocated(intProject, intUser, intItem);
* double dblUsed = oResourceRequest.GetUsed(intProject, intUser, intItem);
* Label _percent = (Label)ri.FindControl("lblPercent");
* _allocated.Text = dblAllocated.ToString();
* _used.Text = dblUsed.ToString();
* if (dblAllocated > 0)
* {
* dblUsed = dblUsed / dblAllocated;
* _percent.Text = dblUsed.ToString("P");
* }
* else
* _percent.Text = dblAllocated.ToString("P");
* if (intItem == 0)
* _item.Text = "Project Coordinator";
* else
* {
* if (intItem == -1)
* _item.Text = "Design Implementor";
* else
* {
* int intApp = oRequestItem.GetItemApplication(intItem);
* _item.Text = oApplication.GetName(intApp);
* }
* }
* _status.Text = oStatus.Name(intStatus);
* }
*/
// MY Involvement
DataSet dsMine = oResourceRequest.GetWorkflowProject(intProject);
//Check if new request
DataColumn oColumn;
oColumn = new DataColumn();
oColumn.DataType = System.Type.GetType("System.String");
oColumn.ColumnName = "new";
dsMine.Tables[0].Columns.Add(oColumn);
foreach (DataRow dr in dsMine.Tables[0].Rows)
{
if (intImplementorDistributed == Int32.Parse(dr["itemid"].ToString()))
{
dr.Delete();
}
else if (intImplementorMidrange == Int32.Parse(dr["itemid"].ToString()))
{
dr.Delete();
}
else if (DateTime.Parse(dr["created"].ToString()) <= DateTime.Parse(dr["modified"].ToString()))
{
dr["new"] = "1";
}
//else if (intProfile != Int32.Parse(dr["userid"].ToString()) && oDelegate.Get(Int32.Parse(dr["userid"].ToString()), intProfile) <= 0)
// dr.Delete();
}
Functions oFunction = new Functions(0, dsn, intEnvironment);
rptMine.DataSource = dsMine;
rptMine.DataBind();
lblNoMine.Visible = (rptMine.Items.Count == 0);
foreach (RepeaterItem ri in rptMine.Items)
{
Label _id = (Label)ri.FindControl("lblId");
Label _user = (Label)ri.FindControl("lblUser");
Label _status = (Label)ri.FindControl("lblStatus");
Label _color = (Label)ri.FindControl("lblColor");
Label _service = (Label)ri.FindControl("lblServiceId");
int _serviceid = Int32.Parse(_service.Text);
Label _name = (Label)ri.FindControl("lblName");
Image imgDelegate = (Image)ri.FindControl("imgDelegate");
int intStatus = Int32.Parse(_status.Text);
int intUser = Int32.Parse(_user.Text);
if ((intStatus < 1 || intStatus > 2) && intStatus != 5)
{
ri.Visible = false;
}
else if (intUser != intProfile)
{
if (oDelegate.Get(intUser, intProfile) <= 0)
{
ri.Visible = false;
}
else
{
imgDelegate.Visible = true;
}
}
if (ri.Visible == true)
{
string strColor = _color.Text;
int intGreen = 0;
Int32.TryParse(strColor.Substring(0, strColor.IndexOf("_")), out intGreen);
strColor = strColor.Substring(strColor.IndexOf("_") + 1);
int intYellow = 0;
Int32.TryParse(strColor.Substring(0, strColor.IndexOf("_")), out intYellow);
strColor = strColor.Substring(strColor.IndexOf("_") + 1);
int intRed = 0;
Int32.TryParse(strColor, out intRed);
strColor = "<table cellpadding=\"0\" cellspacing=\"2\" border=\"0\">";
if (intRed > 0)
{
strColor += "<tr><td>" + oFunction.GetBox("FF0000", 15, 8) + "</td>" + (intRed > 1 ? "<td> (" + intRed.ToString() + ")</td>" : "") + "</tr>";
}
if (intYellow > 0)
{
strColor += "<tr><td>" + oFunction.GetBox("FFFF00", 15, 8) + "</td>" + (intYellow > 1 ? "<td> (" + intYellow.ToString() + ")</td>" : "") + "</tr>";
}
if (intGreen > 0)
{
strColor += "<tr><td>" + oFunction.GetBox("00FF00", 15, 8) + "</td>" + (intGreen > 1 ? "<td> (" + intGreen.ToString() + ")</td>" : "") + "</tr>";
}
strColor += "</table>";
_color.Text = strColor;
if (_name.Text == "")
{
_name.Text = oService.GetName(_serviceid);
}
Label _item = (Label)ri.FindControl("lblItem");
Label _allocated = (Label)ri.FindControl("lblAllocated");
double dblAllocated = double.Parse(_allocated.Text);
Label _used = (Label)ri.FindControl("lblUsed");
double dblUsed = oResourceRequest.GetWorkflowUsed(Int32.Parse(_id.Text));
Label _percent = (Label)ri.FindControl("lblPercent");
int intItem2 = Int32.Parse(_item.Text);
if (intItem2 == 0)
{
_item.Text = "Project Coordinator";
}
else
{
if (intItem2 == -1)
{
_item.Text = "Pending Execution";
}
else
{
int intApp = oRequestItem.GetItemApplication(intItem2);
_item.Text = oApplication.GetName(intApp);
}
}
_allocated.Text = dblAllocated.ToString();
_used.Text = dblUsed.ToString();
if (dblAllocated > 0)
{
dblUsed = dblUsed / dblAllocated;
_percent.Text = dblUsed.ToString("P");
}
else
{
_percent.Text = dblAllocated.ToString("P");
}
_status.Text = oStatus.Name(intStatus);
}
}
}
else
{
panDenied.Visible = true;
lblTitle.Text = "Zero Dataset ";
}
LoadProject(intProject);
}
}
else
{
panDenied.Visible = true;
lblTitle.Text = "Invalid Querystring ";
}
btnDenied.Attributes.Add("onclick", "return CloseWindow();");
btnConfigure.Attributes.Add("onclick", "return ValidateText('" + txtNumber.ClientID + "','Please enter the project number');");
}
protected void Page_Load(object sender, EventArgs e)
{
Master.Page.Title = "DataPoint | Project Search";
if (Request.Cookies["profileid"] != null && Request.Cookies["profileid"].Value != "")
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
}
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);
}
oDataPoint = new DataPoint(intProfile, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oUser = new Users(intProfile, dsn);
oModel = new Models(intProfile, dsn);
oApplications = new Applications(intProfile, dsn);
oVariable = new Variables(intEnvironment);
oPage = new Pages(intProfile, dsn);
oOrganizations = new Organizations(intProfile, dsn);
oStatusLevel = new StatusLevels();
if (oUser.IsAdmin(intProfile) == true || (oDataPoint.GetPagePermission(intApplication, "PROJECT") == true || intDataPointAvailableProject == 1))
{
pnlAllow.Visible = true;
if (Request.QueryString["advanced"] == null)
{
pnlBasicSearch.Visible = true;
pnlAdvancedSearch.Visible = false;
lnkbtnAdvancedSearch.Visible = true;
lnkbtnBasicSearch.Visible = false;
btnAdvancedSearch.Visible = false;
btnBasicSearch.Visible = true;
}
else
{
boolAdvSearch = true;
pnlBasicSearch.Visible = true;
pnlAdvancedSearch.Visible = true;
lnkbtnAdvancedSearch.Visible = false;
lnkbtnBasicSearch.Visible = true;
btnAdvancedSearch.Visible = true;
btnBasicSearch.Visible = false;
}
if (!IsPostBack)
{
LoadList();
}
AddControlAttributes();
}
else
{
pnlDenied.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
if (Request.Cookies["profileid"] != null && Request.Cookies["profileid"].Value != "")
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
}
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);
}
oDataPoint = new DataPoint(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oServer = new Servers(intProfile, dsn);
oAsset = new Asset(intProfile, dsnAsset);
oForecast = new Forecast(intProfile, dsn);
oPlatform = new Platforms(intProfile, dsn);
oType = new Types(intProfile, dsn);
oModel = new Models(intProfile, dsn);
oModelsProperties = new ModelsProperties(intProfile, dsn);
oIPAddresses = new IPAddresses(intProfile, dsnIP, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oOperatingSystem = new OperatingSystems(intProfile, dsn);
oServicePack = new ServicePacks(intProfile, dsn);
oClass = new Classes(intProfile, dsn);
oEnvironment = new Environments(intProfile, dsn);
oResiliency = new Resiliency(intProfile, dsn);
//oLocation = new Locations(intProfile, dsn);
//oRoom = new Rooms(intProfile, dsn);
//oRack = new Racks(intProfile, dsn);
oStatusList = new StatusLevels(intProfile, dsn);
if (oUser.IsAdmin(intProfile) == true || (oDataPoint.GetPagePermission(intApplication, "ASSET") == true || intDataPointAvailableAsset == 1))
{
panAllow.Visible = true;
if (Request.QueryString["save"] != null)
{
panSave.Visible = true;
}
if (Request.QueryString["error"] != null)
{
panError.Visible = true;
lblError.Text = "Name Already Exists";
}
if (Request.QueryString["close"] != null)
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">window.close();<" + "/" + "script>");
}
else if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
string strID = oFunction.decryptQueryString(Request.QueryString["id"]);
DataSet ds = oDataPoint.GetAsset(Int32.Parse(strID));
if (ds.Tables[0].Rows.Count == 1)
{
// Load General Information
intAsset = Int32.Parse(ds.Tables[0].Rows[0]["id"].ToString());
lblAssetID.Text = "#" + intAsset.ToString();
string strSerial = ds.Tables[0].Rows[0]["serial"].ToString();
string strAsset = ds.Tables[0].Rows[0]["asset"].ToString();
string strHeader = (strSerial.Length > 15 ? strSerial.Substring(0, 15) + "..." : strSerial);
lblHeader.Text = """ + strHeader.ToUpper() + """;
Master.Page.Title = "DataPoint | Enclosure Deploy (" + strHeader + ")";
lblHeaderSub.Text = "Complete the following information to deploy an enclosure...";
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("Asset Information", "");
oTab.AddTab("Location Information", "");
oTab.AddTab("Virtual Connect IPs", "");
oTab.AddTab("Resource Dependencies", "");
oTab.AddTab("Provisioning History", "");
strMenuTab1 = oTab.GetTabs();
if (oUser.IsAdmin(intProfile) == true || oDataPoint.GetFieldPermission(intProfile, "SERVER_ADMIN") == true)
{
panOldLocationInfo.Visible = true;
}
if (!IsPostBack)
{
LoadList();
// Asset Information
oDataPoint.LoadTextBox(txtPlatformSerial, intProfile, null, "", lblPlatformSerial, fldPlatformSerial, "ENCLOSURE_SERIAL", strSerial, "", false, true);
oDataPoint.LoadTextBox(txtPlatformAsset, intProfile, null, "", lblPlatformAsset, fldPlatformAsset, "ENCLOSURE_ASSET", strAsset, "", false, true);
int intAssetAttribute = Int32.Parse(oAsset.Get(intAsset, "asset_attribute"));
oDataPoint.LoadDropDown(ddlAssetAttribute, intProfile, null, "", lblAssetAttribute, fldAssetAttribute, "ASSET_ATTRIBUTE", "Name", "AttributeId", oAsset.getAssetAttributes(null, "", 1), intAssetAttribute, true, false, false);
oDataPoint.LoadTextBox(txtAssetAttributeComment, intProfile, null, "", lblAssetAttributeComment, fldAssetAttributeComment, "ASSET_ATTRIBUTE_COMMENT", oAsset.getAssetAttributesComments(intAsset), "", false, true);
ddlAssetAttribute.Attributes.Add("onclick", "return SetControlsForAssetAttributes()");
ddlPlatform.Attributes.Add("onchange", "PopulatePlatformTypes('" + ddlPlatform.ClientID + "','" + ddlPlatformType.ClientID + "','" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformType.Attributes.Add("onchange", "PopulatePlatformModels('" + ddlPlatformType.ClientID + "','" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformModel.Attributes.Add("onchange", "PopulatePlatformModelProperties('" + ddlPlatformModel.ClientID + "','" + ddlPlatformModelProperty.ClientID + "');ResetDropDownHidden('" + hdnModel.ClientID + "');");
ddlPlatformModelProperty.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlPlatformModelProperty.ClientID + "','" + hdnModel.ClientID + "');");
int intModel = Int32.Parse(oAsset.Get(intAsset, "modelid"));
int intParent = Int32.Parse(oModelsProperties.Get(intModel, "modelid"));
if (oDataPoint.GetDeployModel(intProfile, intParent) == false && oUser.IsAdmin(intProfile) == false)
{
panAllow.Visible = false;
panDenied.Visible = true;
}
hdnModel.Value = intModel.ToString();
int intModelParent = Int32.Parse(oModelsProperties.Get(intModel, "modelid"));
int intType = oModel.GetType(intModelParent);
int intPlatform = oType.GetPlatform(intType);
oDataPoint.LoadDropDown(ddlPlatform, intProfile, null, "", lblPlatform, fldPlatform, "ENCLOSURE_PLATFORM", "name", "platformid", oPlatform.Gets(1), intPlatform, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformType, intProfile, null, "", lblPlatformType, fldPlatformType, "ENCLOSURE_TYPE", "name", "id", oType.Gets(intPlatform, 1), intType, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformModel, intProfile, null, "", lblPlatformModel, fldPlatformModel, "ENCLOSURE_MODEL", "name", "id", oModel.Gets(intType, 1), intModelParent, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformModelProperty, intProfile, null, "", lblPlatformModelProperty, fldPlatformModelProperty, "ENCLOSURE_MODEL_PROP", "name", "id", oModelsProperties.GetModels(0, intModelParent, 1), intModel, false, false, true);
// Get Asset
DataSet dsAsset = oAsset.GetEnclosure(intAsset);
if (dsAsset.Tables[0].Rows.Count > 0)
{
Response.Redirect("/datapoint/asset/enclosure.aspx?t=serial&q=" + oFunction.encryptQueryString(strSerial) + "&id=" + oFunction.encryptQueryString(intAsset.ToString()) + "&r=0");
}
txtName.Text = oAsset.GetStatus(intAsset, "name");
oDataPoint.LoadTextBox(txtName, intProfile, null, "", lblName, fldName, "ENCLOSURE_NAME", "", "", false, true);
oDataPoint.LoadDropDown(ddlPlatformClass, intProfile, null, "", lblPlatformClass, fldPlatformClass, "ENCLOSURE_CLASS", "name", "id", oClass.Gets(1), 0, false, false, true);
oDataPoint.LoadDropDown(ddlPlatformEnvironment, intProfile, null, "", lblPlatformEnvironment, fldPlatformEnvironment, "ENCLOSURE_ENVIRONMENT", "name", "id", oClass.GetEnvironment(0, 0), 0, false, false, true);
oDataPoint.LoadTextBox(txtPlatformVLAN, intProfile, null, "", lblPlatformVLAN, fldPlatformVLAN, "ENCLOSURE_VLAN", "", "", false, true);
oDataPoint.LoadTextBox(txtPlatformOA, intProfile, null, "", lblPlatformOA, fldPlatformOA, "ENCLOSURE_OA", "", "", false, true);
oDataPoint.LoadDropDown(ddlPlatformResiliency, intProfile, null, "", lblPlatformResiliency, fldPlatformResiliency, "ENCLOSURE_RESILIENCY", "name", "id", oResiliency.Gets(1), 0, false, false, true);
if (dsAsset.Tables[0].Rows.Count > 0)
{
lblOldlocation.Text = dsAsset.Tables[0].Rows[0]["OldLocation"].ToString();
lblOldRoom.Text = dsAsset.Tables[0].Rows[0]["OldRoom"].ToString();
lblOldRack.Text = dsAsset.Tables[0].Rows[0]["OldRack"].ToString();
txtLocation.Text = dsAsset.Tables[0].Rows[0]["Location"].ToString();
txtRoom.Text = dsAsset.Tables[0].Rows[0]["Room"].ToString();
txtZone.Text = dsAsset.Tables[0].Rows[0]["Zone"].ToString();
txtRack.Text = dsAsset.Tables[0].Rows[0]["Rack"].ToString();
txtRackPosition.Text = dsAsset.Tables[0].Rows[0]["Rackposition"].ToString();
oDataPoint.LoadTextBox(txtRackPosition, intProfile, null, "", lblRackPositionValue, fldLocation, "CHANGE_LOCATION", dsAsset.Tables[0].Rows[0]["rackposition"].ToString(), "", false, true);
hdnRackId.Value = dsAsset.Tables[0].Rows[0]["NewRackId"].ToString();
}
oDataPoint.LoadButton(btnSelectLocation, intProfile, fldLocation, "CHANGE_LOCATION",
"return LoadLocationRoomRack('" + "rack" + "','" + hdnRackId.ClientID + "', '" + txtLocation.ClientID + "','" + txtRoom.ClientID + "','" + txtZone.ClientID + "','" + txtRack.ClientID + "');");
ddlPlatformStatus.SelectedValue = oAsset.GetStatus(intAsset, "status");
// Resource Dependencies
AssetOrder oAssetOrder = new AssetOrder(0, dsn, dsnAsset, intEnvironment);
Services oService = new Services(0, dsn);
ServiceRequests oServiceRequest = new ServiceRequests(0, dsn);
rptServiceRequests.DataSource = oAssetOrder.GetByAsset(intAsset, false);
rptServiceRequests.DataBind();
trServiceRequests.Visible = (rptServiceRequests.Items.Count == 0);
foreach (RepeaterItem ri in rptServiceRequests.Items)
{
Label lblServiceID = (Label)ri.FindControl("lblServiceID");
int intService = Int32.Parse(lblServiceID.Text);
Label lblDetails = (Label)ri.FindControl("lblDetails");
Label lblProgress = (Label)ri.FindControl("lblProgress");
if (lblProgress.Text == "")
{
lblProgress.Text = "<i>Unavailable</i>";
}
else
{
int intResource = Int32.Parse(lblProgress.Text);
double dblAllocated = 0.00;
double dblUsed = 0.00;
int intStatus = 0;
bool boolAssigned = false;
DataSet dsResource = oDataPoint.GetServiceRequestResource(intResource);
if (dsResource.Tables[0].Rows.Count > 0)
{
Int32.TryParse(dsResource.Tables[0].Rows[0]["status"].ToString(), out intStatus);
}
foreach (DataRow drResource in dsResource.Tables[1].Rows)
{
boolAssigned = true;
dblAllocated += double.Parse(drResource["allocated"].ToString());
dblUsed += double.Parse(drResource["used"].ToString());
intStatus = Int32.Parse(drResource["status"].ToString());
}
if (intStatus == (int)ResourceRequestStatus.Closed)
{
lblProgress.Text = oServiceRequest.GetStatusBar(100.00, "100", "12", true);
}
else if (intStatus == (int)ResourceRequestStatus.Cancelled)
{
lblProgress.Text = "Cancelled";
}
else if (boolAssigned == false)
{
string strManager = "";
DataSet dsManager = oService.GetUser(intService, 1); // Managers
foreach (DataRow drManager in dsManager.Tables[0].Rows)
{
if (strManager != "")
{
strManager += "\\n";
}
int intManager = Int32.Parse(drManager["userid"].ToString());
strManager += " - " + oUser.GetFullName(intManager) + " [" + oUser.GetName(intManager) + "]";
}
lblProgress.Text = "<a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"alert('This request is pending assignment by the following...\\n\\n" + strManager + "');\">Pending Assignment</a>";
}
else if (dblAllocated > 0.00)
{
lblProgress.Text = oServiceRequest.GetStatusBar((dblUsed / dblAllocated) * 100.00, "100", "12", true);
}
else
{
lblProgress.Text = "<i>N / A</i>";
}
lblDetails.Text = "<a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"OpenNewWindowMenu('/datapoint/service/resource.aspx?id=" + oFunction.encryptQueryString(intResource.ToString()) + "', '800', '600');\">" + lblDetails.Text + "</a>";
}
}
// Provioning History
rptHistory.DataSource = oAsset.GetProvisioningHistory(intAsset);
rptHistory.DataBind();
lblHistory.Visible = (rptHistory.Items.Count == 0);
// Virtual Connects
rptVirtualConnect.DataSource = oAsset.GetEnclosureVCs(intAsset, 1);
rptVirtualConnect.DataBind();
lblVirtualConnect.Visible = (rptVirtualConnect.Items.Count == 0);
btnVCs.Attributes.Add("onclick", "return OpenWindow('ASSET_DEPLOY_VCs','" + intAsset.ToString() + "');");
}
}
else
{
if (Request.QueryString["t"] != null && Request.QueryString["q"] != null)
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx?t=" + Request.QueryString["t"] + "&q=" + Request.QueryString["q"] + "&r=0");
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx");
}
}
}
else
{
Response.Redirect("/datapoint/asset/datapoint_asset_search.aspx");
}
btnClose.Attributes.Add("onclick", "window.close();return false;");
btnPrint.Attributes.Add("onclick", "window.print();return false;");
btnDeploy.Attributes.Add("onclick", oDataPoint.LoadValidation());
ddlPlatformClass.Attributes.Add("onchange", "PopulateEnvironments('" + ddlPlatformClass.ClientID + "','" + ddlPlatformEnvironment.ClientID + "',0);");
ddlPlatformEnvironment.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlPlatformEnvironment.ClientID + "','" + hdnEnvironment.ClientID + "');");
//ddlLocationState.Attributes.Add("onchange", "LoadLocationCity('" + ddlLocationCity.ClientID + "');LoadLocationAddress('" + ddlLocationAddress.ClientID + "');PopulateCitys('" + ddlLocationState.ClientID + "','" + ddlLocationCity.ClientID + "');ResetDropDownHidden('" + hdnAddress.ClientID + "');");
//ddlLocationCity.Attributes.Add("onchange", "LoadLocationAddress('" + ddlLocationAddress.ClientID + "');PopulateAddresss('" + ddlLocationCity.ClientID + "','" + ddlLocationAddress.ClientID + "');ResetDropDownHidden('" + hdnAddress.ClientID + "');");
//ddlLocationAddress.Attributes.Add("onchange", "UpdateDropDownHidden('" + ddlLocationAddress.ClientID + "','" + hdnAddress.ClientID + "');");
}
else
{
panDenied.Visible = true;
}
}
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);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oPage = new Pages(intProfile, dsn);
oOrganization = new Organizations(intProfile, dsn);
oSegment = new Segment(intProfile, dsn);
oApplication = new Applications(intProfile, dsn);
oRequestItem = new RequestItems(intProfile, dsn);
oService = new Services(intProfile, dsn);
oSearch = new Search(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oProject = new Projects(intProfile, dsn);
oStatusLevel = new StatusLevels();
oProjectRequest = new ProjectRequest(intProfile, dsn);
oDocument = new Documents(intProfile, dsn);
oStatus = new StatusLevels();
oApprove = new ProjectRequest_Approval(intProfile, dsn, intEnvironment);
oCustomized = new Customized(intProfile, dsn);
oVariable = new Variables(intEnvironment);
oFunction = new Functions(intProfile, dsn, intEnvironment);
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);
}
bool boolUserSearch = false;
if (Request.QueryString["pid"] != null && Request.QueryString["pid"] != "")
{
int intProject = Int32.Parse(Request.QueryString["pid"]);
strProjectName = oProject.GetName(intProject);
lblProjectName.Text = """ + strProjectName + """;
// INVOLVEMENT
DataSet dsInvolvement = oResourceRequest.GetWorkflowProject(intProject);
int intOldUser = 0;
foreach (DataRow dr in dsInvolvement.Tables[0].Rows)
{
if (intOldUser == Int32.Parse(dr["userid"].ToString()))
{
dr.Delete();
}
else
{
intOldUser = Int32.Parse(dr["userid"].ToString());
}
}
dsInvolvement = oResourceRequest.GetWorkflowProject(intProject);
int intOldItem = 0;
intOldUser = 0;
foreach (DataRow dr in dsInvolvement.Tables[0].Rows)
{
if (intOldItem == Int32.Parse(dr["itemid"].ToString()) && intOldUser == Int32.Parse(dr["userid"].ToString()))
{
dr.Delete();
}
else
{
intOldItem = Int32.Parse(dr["itemid"].ToString());
intOldUser = Int32.Parse(dr["userid"].ToString());
}
}
rptInvolvement.DataSource = dsInvolvement;
rptInvolvement.DataBind();
lblNoInvolvement.Visible = (rptInvolvement.Items.Count == 0);
foreach (RepeaterItem ri in rptInvolvement.Items)
{
Label _id = (Label)ri.FindControl("lblId");
Label _user = (Label)ri.FindControl("lblUser");
Label _status = (Label)ri.FindControl("lblStatus");
Label _image = (Label)ri.FindControl("lblImage");
int intStatus = Int32.Parse(_status.Text);
int intUser = Int32.Parse(_user.Text);
_user.Text = oUser.GetFullName(intUser);
Label _item = (Label)ri.FindControl("lblItem");
int intItem2 = Int32.Parse(_item.Text);
Label _allocated = (Label)ri.FindControl("lblAllocated");
Label _used = (Label)ri.FindControl("lblUsed");
double dblAllocated = oResourceRequest.GetAllocated(intProject, intUser, intItem2);
double dblUsed = oResourceRequest.GetUsed(intProject, intUser, intItem2);
Label _percent = (Label)ri.FindControl("lblPercent");
_allocated.Text = dblAllocated.ToString();
_used.Text = dblUsed.ToString();
if (dblAllocated > 0)
{
dblUsed = dblUsed / dblAllocated;
_percent.Text = dblUsed.ToString("P");
}
else
{
_percent.Text = dblAllocated.ToString("P");
}
bool boolTPMDone = false;
if (intItem2 == 0)
{
_item.Text = "Project Coordinator";
}
else if (intItem2 == -1)
{
_item.Text = "Design Implementation (Pending Execution)";
}
else
{
int intApp = oRequestItem.GetItemApplication(intItem2);
_item.Text = oApplication.GetName(intApp);
}
_status.Text = oStatus.Name(intStatus);
if (boolTPMDone == true)
{
_status.Text = "Closed";
}
}
}
}
private string GetSummary(int _requestid, int _serviceid, int _number)
{
Users oUser = new Users(intProfile, dsn);
ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn);
RequestItems oRequestItem = new RequestItems(intProfile, dsn);
Applications oApplication = new Applications(intProfile, dsn);
StatusLevels oStatus = new StatusLevels();
StringBuilder sbSummary = new StringBuilder();
DataSet ds = oResourceRequest.GetRequestService(_requestid, _serviceid, _number);
int intCount = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
intCount++;
int intResource = Int32.Parse(dr["id"].ToString());
int intItem = Int32.Parse(dr["itemid"].ToString());
int intNumber = Int32.Parse(dr["number"].ToString());
int intStatus = Int32.Parse(dr["status"].ToString());
double dblAllocated = double.Parse(dr["allocated"].ToString());
double dblProgress = 0.00;
if (intStatus == 3)
{
dblProgress = 100.00;
}
else
{
double dblUsed = oResourceRequest.GetWorkflowUsed(intResource);
if (dblAllocated > 0.00)
{
dblProgress = (dblUsed / dblAllocated) * 100.00;
}
}
string strReason = "Unavailable";
int intApproval = 0;
DataSet dsReason = oResourceRequest.GetApproval(_requestid, intItem, intNumber);
if (dsReason.Tables[0].Rows.Count > 0)
{
strReason = dsReason.Tables[0].Rows[0]["reason"].ToString().Trim();
if (strReason == "")
{
strReason = "<i>No additional information...</i>";
}
intApproval = Int32.Parse(dsReason.Tables[0].Rows[0]["approval"].ToString());
}
string strStatus = oStatus.Name(intApproval);
bool boolResult = (intApproval == 1);
sbSummary.Append("<tr>");
sbSummary.Append("<td width=\"1\"><img src=\"/images/resource_people.gif\" border=\"0\" align=\"absmiddle\"></td>");
int intUser = Int32.Parse(dr["userid"].ToString());
sbSummary.Append("<td>");
sbSummary.Append(intUser > 0 ? oUser.GetFullName(intUser) : "Pending Assignment");
sbSummary.Append("</td>");
sbSummary.Append("<td>");
sbSummary.Append(oApplication.GetName(oRequestItem.GetItemApplication(Int32.Parse(dr["itemid"].ToString()))));
sbSummary.Append("</td>");
sbSummary.Append("<td nowrap align=\"center\">");
sbSummary.Append(intUser > 0 ? strStatus : "---");
sbSummary.Append("</td>");
sbSummary.Append("<td nowrap width=\"100\">");
sbSummary.Append(intUser > 0 ? oServiceRequest.GetStatusBar(dblProgress, "100", "14", true) : "---");
sbSummary.Append("</td>");
sbSummary.Append("<td width=\"1\" nowrap><a href=\"javascript:void(0);\" onclick=\"ShowHide('div");
sbSummary.Append(intCount.ToString());
sbSummary.Append("_1');\">[Details]</a>");
sbSummary.Append(boolResult ? " <a href=\"javascript:void(0);\" onclick=\"ShowHide('div" + intCount.ToString() + "_2');\">[Result]</a>" : "");
sbSummary.Append("</td>");
sbSummary.Append("</tr>");
sbSummary.Append("<tr>");
sbSummary.Append("<td colspan=\"6\">");
sbSummary.Append("<div id=\"div");
sbSummary.Append(intCount.ToString());
sbSummary.Append("_1\" style=\"display:none\">");
sbSummary.Append(strReason);
sbSummary.Append("</div>");
if (boolResult == true)
{
string strResult = "";
DataSet dsResult = oRequest.GetResult(_requestid, intItem, intNumber);
foreach (DataRow drResult in dsResult.Tables[0].Rows)
{
strResult += drResult["result"].ToString();
}
sbSummary.Append("<div id=\"div");
sbSummary.Append(intCount.ToString());
sbSummary.Append("_2\" style=\"display:none\">");
sbSummary.Append(strResult);
sbSummary.Append("</div>");
}
sbSummary.Append("</td>");
sbSummary.Append("</tr>");
}
sbSummary.Insert(0, "<table width=\"100%\" cellpadding=\"3\" cellspacing=\"2\" border=\"0\"><tr><td></td><td><b><u>Technician:</u></b></td><td><b><u>Department:</u></b></td><td align=\"center\"><b><u>Status:</u></b></td><td><b><u>Progress:</u></b></td><td></td></tr>");
sbSummary.Append("</table>");
return(sbSummary.ToString());
}
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);
oStatusLevel = new StatusLevels(intProfile, dsn);
oAssetOrder = new AssetOrder(intProfile, dsn, dsnAsset, intEnvironment);
oVariable = new Variables(intEnvironment);
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"] != "")
{
//Load Attributes
if (!IsPostBack)
{
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 Added Successfully');<" + "/" + "script>");
}
LoadLists();
oFunction.ConfigureToolButton(btnEmail, "/images/tool_email");
oFunction.ConfigureToolButton(btnPrint, "/images/tool_print");
oFunction.ConfigureToolButton(btnClose, "/images/tool_close");
oFunction.ConfigureToolButton(btnSave, "/images/tool_save");
oFunction.ConfigureToolButton(btnComplete, "/images/tool_complete");
oFunction.ConfigureToolButton(btnSLA, "/images/tool_sla");
btnDenied.Attributes.Add("onclick", "return CloseWindow();");
btnPrint.Attributes.Add("onclick", "return PrintWindow();");
btnClose.Attributes.Add("onclick", "return ExitWindow();");
btnSave.Attributes.Add("onclick", "return ValidateText('" + txtNickName.ClientID + "','Please enter the nick name')" +
" && ValidateNumber('" + txtApprovedQuantity.ClientID + "','Please enter the quantity.')" +
//" && ValidateNumber('" + txtProcureQuantity.ClientID + "','Please enter the quantity.')" +
//" && ValidateNumber('" + txtReDeployQuantity.ClientID + "','Please enter the re-deploy quantity.')" +
//" && ValidateNumber('" + txtReturnedQuantity.ClientID + "','Please enter the returned quantity.')" +
" && ValidateDropDown('" + ddlPurchaseOrderStatus.ClientID + "','Please select the purchase order status')" +
" && ValidatePurchaseOrderStatus()" +
";");
//" && ValidateStatus('" + ddlStatus.ClientID + "','" + txtComments.ClientID + "')" +
btnStatus.Attributes.Add("onclick", "return ValidateStatus('" + ddlStatus.ClientID + "','" + txtComments.ClientID + "')" +
";");
imgBtnPurchaseOrderDate.Attributes.Add("onclick", "return ShowCalendar('" + txtPurchaseOrderDate.ClientID + "');");
imgApprovedOn.Attributes.Add("onclick", "return ShowCalendar('" + txtApprovedOn.ClientID + "');");
imgQuoteDate.Attributes.Add("onclick", "return ShowCalendar('" + txtQuoteDate.ClientID + "','" + txtWarrantyDate.ClientID + "',1095);");
imgBtnVendorOrderDate.Attributes.Add("onclick", "return ShowCalendar('" + txtVendorOrderDate.ClientID + "');");
txtAttentionTo.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'250','195','" + divAttentionTo.ClientID + "','" + lstAttentionTo.ClientID + "','" + hdnAttentionTo.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstAttentionTo.Attributes.Add("ondblclick", "AJAXClickRow();");
txtProjectManager.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'250','195','" + divProjectManager.ClientID + "','" + lstProjectManager.ClientID + "','" + hdnProjectManager.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstProjectManager.Attributes.Add("ondblclick", "AJAXClickRow();");
imgDate.Attributes.Add("onclick", "return ShowCalendar('" + txtDate.ClientID + "');");
}
LoadRequest();
}
else
{
panDenied.Visible = 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);
oStatusLevel = new StatusLevels();
oEnhancement = new Enhancements(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();
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"));
// End Workflow Change
intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString());
lblService.Text = oService.Get(intService, "name");
int intApp = oRequestItem.GetItemApplication(intItem);
strMessages = oCustomized.GetMessages(intRequest, false, "#E1FFE1");
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?') && ProcessControlButton();");
}
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;
}
dblUsed = (dblUsed / dblAllocated) * 100;
sldHours._StartPercent = dblUsed.ToString();
sldHours._TotalHours = dblAllocated.ToString();
intProject = oRequest.GetProjectNumber(intRequest);
hdnTab.Value = "D";
panWorkload.Visible = true;
LoadLists();
LoadStatus(intResourceWorkflow);
LoadInformation(intResourceWorkflow);
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 ProcessControlButton();");
btnMessage.Attributes.Add("onclick", "ShowHideDiv2('" + divMessage.ClientID + "');return false;");
// 6/1/2009 - Load ReadOnly View
if (oResourceRequest.CanUpdate(intProfile, intResourceWorkflow, false) == false)
{
oFunction.ConfigureToolButtonRO(btnSave, btnComplete);
//panDenied.Visible = true;
}
}
}
else
{
panDenied.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oRequest = new Requests(intProfile, dsn);
oService = new Services(intProfile, dsn);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oCustomized = new Customized(intProfile, dsn);
oPage = new Pages(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oStatusLevel = new StatusLevels();
oUser = new Users(intProfile, dsn);
oApplication = new Applications(intProfile, dsn);
oEnhancement = new Enhancements(intProfile, dsn);
oVariables = new Variables(intEnvironment);
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["id"] != null && Request.QueryString["id"] != "")
{
intId = Int32.Parse(Request.QueryString["id"]);
}
if (Request.QueryString["old"] != null && Request.QueryString["old"] != "")
{
intId = Int32.Parse(Request.QueryString["old"]);
}
if (!IsPostBack)
{
drpModules.DataValueField = "pageid";
drpModules.DataTextField = "menutitle";
drpModules.DataSource = oPage.Gets(intApplication, intProfile, 0, 1, 1);
drpModules.DataBind();
drpModules.Items.Insert(0, new ListItem("-- SELECT --", "0"));
}
if (intId > 0)
{
panEnhancement.Visible = true;
DataSet ds = oCustomized.GetEnhancementByID(intId);
if (ds.Tables[0].Rows.Count > 0)
{
panStatus.Visible = true;
lblTitle.Text = "Edit Enhancement";
txtTitle.Text = ds.Tables[0].Rows[0]["title"].ToString();
txtDescription.Text = ds.Tables[0].Rows[0]["description"].ToString();
drpModules.SelectedValue = ds.Tables[0].Rows[0]["pageid"].ToString();
txtNumUsers.Text = ds.Tables[0].Rows[0]["num_users"].ToString();
txtURL.Text = ds.Tables[0].Rows[0]["url"].ToString();
if (ds.Tables[0].Rows[0]["path"].ToString() != "")
{
panUploaded.Visible = true;
hypUpload.NavigateUrl = ds.Tables[0].Rows[0]["path"].ToString();
}
else
{
panUpload.Visible = true;
}
txtStartDate.Text = DateTime.Parse(ds.Tables[0].Rows[0]["startdate"].ToString()).ToShortDateString();
txtEndDate.Text = DateTime.Parse(ds.Tables[0].Rows[0]["enddate"].ToString()).ToShortDateString();
lblStatus.Text = oStatusLevel.HTMLSupport(Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString()));
lblStatus.Attributes.Add("oncontextmenu", "alert('CVT" + intRequest.ToString() + "');");
if (ds.Tables[0].Rows[0]["status"].ToString() == "0")
{
btnUpdate.Visible = true;
panActive.Visible = true;
}
int intRelease = 0;
if (Int32.TryParse(ds.Tables[0].Rows[0]["release"].ToString(), out intRelease) == true && intRelease > 0)
{
lblRelease.Text = DateTime.Parse(oEnhancement.GetVersion(intRelease, "release")).ToLongDateString();
}
else
{
lblRelease.Text = "To Be Determined";
}
lblRequestBy.Text = oUser.GetFullName(intProfile);
lblRequestOn.Text = DateTime.Parse(ds.Tables[0].Rows[0]["created"].ToString()).ToString();
intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
oCustomized.UpdateEnhancementNew(intRequest, 0);
panMessage.Visible = (oCustomized.GetMessages(intRequest, 0).Tables[0].Rows.Count > 0);
strMessages = oCustomized.GetMessages(intRequest, false, "#E1FFE1");
if (ds.Tables[0].Rows[0]["status"].ToString() == "2" || ds.Tables[0].Rows[0]["status"].ToString() == "7")
{
btnMessage.Attributes.Add("onclick", "ShowHideDiv2('" + divMessage.ClientID + "');return false;");
}
else
{
btnMessage.Attributes.Add("onclick", "alert('You can only post a message to an ACTIVE thread.\\n\\nSince this thread is no longer active, additional posts have been disabled');return false;");
}
}
}
else
{
panNoEnhancement.Visible = true;
//panEnhancement.Visible = true;
//hypCommunity.NavigateUrl = oVariables.Community();
panUpload.Visible = true;
lblRequestBy.Text = oUser.GetFullName(intProfile);
lblRequestOn.Text = DateTime.Now.ToString();
lblTitle.Text = oPage.Get(intPage, "title");
txtNumUsers.Text = "0";
btnSave.Visible = true;
panActive.Visible = true;
}
btnSave.Attributes.Add("onclick", "return ValidateText('" + txtTitle.ClientID + "','Please enter a title')" +
" && ValidateText('" + txtDescription.ClientID + "','Please enter a description')" +
" && ValidateNumber('" + txtNumUsers.ClientID + "','Please enter a valid number for the number of users')" +
";");
btnUpdate.Attributes.Add("onclick", "return ValidateText('" + txtTitle.ClientID + "','Please enter a title')" +
" && ValidateText('" + txtDescription.ClientID + "','Please enter a description')" +
" && ValidateNumber('" + txtNumUsers.ClientID + "','Please enter a valid number for the number of users')" +
";");
btnResponse.Attributes.Add("onclick", "return ValidateText('" + txtResponse.ClientID + "','Please enter a response');");
btnDeleteAttachment.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this file?');");
imgStartDate.Attributes.Add("onclick", "return ShowCalendar('" + txtStartDate.ClientID + "');");
imgEndDate.Attributes.Add("onclick", "return ShowCalendar('" + txtEndDate.ClientID + "');");
}
private void LoopRepeater(string _sort, int _start)
{
DataSet ds = oForecast.Gets();
double dblCount1 = 0;
DataColumn dc1 = new DataColumn("implementation", System.Type.GetType("System.DateTime"));
ds.Tables[0].Columns.Add(dc1);
DataColumn dc2 = new DataColumn("quantity", System.Type.GetType("System.Int32"));
ds.Tables[0].Columns.Add(dc2);
DataColumn dc3 = new DataColumn("amp", System.Type.GetType("System.Double"));
ds.Tables[0].Columns.Add(dc3);
foreach (DataRow dr in ds.Tables[0].Rows)
{
int intForecast = Int32.Parse(dr["id"].ToString());
DataSet dsAnswers = oForecast.GetAnswers(intForecast);
DateTime _date = DateTime.MaxValue;
foreach (DataRow drAnswer in dsAnswers.Tables[0].Rows)
{
//bool boolOverride = (dr["override"].ToString() == "1");
if (drAnswer["implementation"].ToString() != "")
{
DateTime _commitment = DateTime.Parse(drAnswer["implementation"].ToString());
if (_commitment < _date)
{
_date = _commitment;
}
}
double dblQuantity = double.Parse(drAnswer["quantity"].ToString()) + double.Parse(drAnswer["recovery_number"].ToString());
dblCount1 += dblQuantity;
}
//dblCount2 += dblCount1;
dr["implementation"] = _date.ToShortDateString();
dr["quantity"] = dblCount1.ToString();
dblCount1 = 0.00;
}
if (_start > ds.Tables[0].Rows.Count)
{
_start = 0;
}
intRecordStart = _start + 1;
DataView dv = ds.Tables[0].DefaultView;
if (Request.QueryString["sort"] != null)
{
dv.Sort = Request.QueryString["sort"];
}
dv.RowFilter = LoadFilter();
LoadLists(dv);
int intCount = _start + intRecords;
if (dv.Count < intCount)
{
intCount = dv.Count;
}
int ii = 0;
lblRecords.Text = "Models " + intRecordStart.ToString() + " - " + intCount.ToString() + " of " + dv.Count.ToString();
for (ii = 0; ii < _start && ii < intCount; ii++)
{
dv[0].Delete();
}
int intTotalCount = (dv.Count - intRecords);
for (ii = 0; ii < intTotalCount; ii++)
{
dv[intRecords].Delete();
}
rptView.DataSource = dv;
rptView.DataBind();
Projects oProject = new Projects(intProfile, dsn);
Requests oRequest = new Requests(intProfile, dsn);
ProjectsPending oProjectPending = new ProjectsPending(intProfile, dsn, intEnvironment);
Users oUser = new Users(intProfile, dsn);
StatusLevels oStatusLevel = new StatusLevels();
//foreach (RepeaterItem ri in rptView.Items)
//{
// Label lblProject = (Label)ri.FindControl("lblProject");
// int intProject = Int32.Parse(lblProject.Text);
// Label lblRequest = (Label)ri.FindControl("lblRequest");
// int intRequest = Int32.Parse(lblRequest.Text);
// if (intProject > 0)
// {
// ds = oForecast.GetProject(intProject);
// }
// else
// {
// ds = oForecast.GetRequest(intRequest);
// }
// double dblAmp = 0.00;
// if (ds.Tables[0].Rows.Count > 0)
// {
// Label lblCount = (Label)ri.FindControl("lblCount");
// Label lblDate = (Label)ri.FindControl("lblDate");
// int intForecast = Int32.Parse(ds.Tables[0].Rows[0]["id"].ToString());
// Platforms oPlatform = new Platforms(intProfile, dsn);
// ModelsProperties oModelsProperties = new ModelsProperties(intProfile, dsn);
// ds = oForecast.GetAnswers(intForecast);
// DateTime _date = DateTime.MaxValue;
// foreach (DataRow dr in ds.Tables[0].Rows)
// {
// //bool boolOverride = (dr["override"].ToString() == "1");
// if (dr["implementation"].ToString() != "")
// {
// DateTime _commitment = DateTime.Parse(dr["implementation"].ToString());
// if (_commitment < _date)
// _date = _commitment;
// }
// // // Get AMP
// // int intModel = 0;
// // int intServerModel = oForecast.GetModel(Int32.Parse(dr["id"].ToString()));
// // if (intServerModel == 0)
// // {
// // // Get the model selected in the equipment dropdown (if not server)
// // intModel = Int32.Parse(dr["modelid"].ToString());
// // if (boolOverride == true && intModel > 0)
// // {
// // intServerModel = intModel;
// // intModel = Int32.Parse(oModelsProperties.Get(intModel, "modelid"));
// // }
// // }
// // if (intServerModel > 0)
// // dblAmp += (double.Parse(oModelsProperties.Get(intServerModel, "amp")) * dblQuantity);
// // else if (intModel > 0)
// // {
// // if (oModelsProperties.Get(intModel).Tables[0].Rows.Count > 0)
// // {
// // double dblAmpTemp = (double.Parse(oModelsProperties.Get(intModel, "amp")) * dblQuantity);
// // dblAmp += dblAmpTemp;
// // }
// // }
// // else
// // {
// // DataSet dsVendor = oForecast.GetAnswer(Int32.Parse(dr["id"].ToString()));
// // if (dsVendor.Tables[0].Rows.Count > 0 && dsVendor.Tables[0].Rows[0]["modelname"].ToString() != "")
// // dblAmp += (double.Parse(dsVendor.Tables[0].Rows[0]["amp"].ToString()) * dblQuantity);
// // }
// }
// lblDate.Text = (_date == DateTime.MaxValue ? "---" : _date.ToShortDateString());
// lblCount.Text = dblCount2.ToString();
// }
// Label lblAmp = (Label)ri.FindControl("lblAmp");
// lblAmp.Text = dblAmp.ToString("F");
//}
lblNone.Visible = (rptView.Items.Count == 0);
_start++;
}
private void LoopRepeater(string _sort, int _start)
{
//DataSet ds = oForecast.Gets();
DataSet ds = oDesign.Gets();
double dblCount1 = 0;
DataColumn dc1 = new DataColumn("implementation", System.Type.GetType("System.String"));
ds.Tables[0].Columns.Add(dc1);
DataColumn dc2 = new DataColumn("quantity", System.Type.GetType("System.Int32"));
ds.Tables[0].Columns.Add(dc2);
DataColumn dc3 = new DataColumn("amp", System.Type.GetType("System.Double"));
ds.Tables[0].Columns.Add(dc3);
foreach (DataRow dr in ds.Tables[0].Rows)
{
int intForecast = Int32.Parse(dr["id"].ToString());
//DataSet dsAnswers = oForecast.GetAnswers(intForecast);
DataSet dsAnswers = oDesign.Gets(intForecast);
DateTime _date = DateTime.MaxValue;
foreach (DataRow drAnswer in dsAnswers.Tables[0].Rows)
{
//bool boolOverride = (dr["override"].ToString() == "1");
if (drAnswer["commitment"].ToString() != "")
{
DateTime _commitment = DateTime.Parse(drAnswer["commitment"].ToString());
if (_commitment < _date)
{
_date = _commitment;
}
}
double dblQuantity = 0.00;
double.TryParse(drAnswer["quantity"].ToString(), out dblQuantity);
int intClass = 0;
if (Int32.TryParse(drAnswer["classid"].ToString(), out intClass) == true && oClass.IsProd(intClass))
{
double dblRecovery = 0.00;
double.TryParse(drAnswer["quantity"].ToString(), out dblRecovery);
dblQuantity += dblRecovery;
}
dblCount1 += dblQuantity;
}
//dblCount2 += dblCount1;
if (_date == DateTime.MaxValue)
{
dr["implementation"] = "N / A";
}
else
{
dr["implementation"] = _date.ToShortDateString();
}
dr["quantity"] = dblCount1.ToString();
dblCount1 = 0.00;
}
if (_start > ds.Tables[0].Rows.Count)
{
_start = 0;
}
intRecordStart = _start + 1;
DataView dv = ds.Tables[0].DefaultView;
if (Request.QueryString["sort"] != null)
{
dv.Sort = Request.QueryString["sort"];
}
dv.RowFilter = LoadFilter();
LoadLists(dv);
int intCount = _start + intRecords;
if (dv.Count < intCount)
{
intCount = dv.Count;
}
int ii = 0;
lblRecords.Text = "Models " + intRecordStart.ToString() + " - " + intCount.ToString() + " of " + dv.Count.ToString();
for (ii = 0; ii < _start && ii < intCount; ii++)
{
dv[0].Delete();
}
int intTotalCount = (dv.Count - intRecords);
for (ii = 0; ii < intTotalCount; ii++)
{
dv[intRecords].Delete();
}
rptView.DataSource = dv;
rptView.DataBind();
Projects oProject = new Projects(intProfile, dsn);
Requests oRequest = new Requests(intProfile, dsn);
ProjectsPending oProjectPending = new ProjectsPending(intProfile, dsn, intEnvironment);
Users oUser = new Users(intProfile, dsn);
StatusLevels oStatusLevel = new StatusLevels();
lblNone.Visible = (rptView.Items.Count == 0);
_start++;
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
if (Request.Cookies["profileid"] != null && Request.Cookies["profileid"].Value != "")
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
}
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);
}
oDataPoint = new DataPoint(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oService = new Services(intProfile, dsn);
oServiceDetail = new ServiceDetails(intProfile, dsn);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oApplication = new Applications(intProfile, dsn);
oRequestItem = new RequestItems(intProfile, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
oStatusLevel = new StatusLevels();
oProjectNumber = new ProjectNumber(intProfile, dsn);
oPage = new Pages(intProfile, dsn);
oLog = new Log(intProfile, dsn);
if (oUser.IsAdmin(intProfile) == true || (oDataPoint.GetPagePermission(intApplication, "SERVICE") == true || intDataPointAvailableService == 1))
{
panAllow.Visible = true;
if (Request.QueryString["save"] != null)
{
panSave.Visible = true;
}
if (Request.QueryString["clear"] != null)
{
panClear.Visible = true;
}
if (Request.QueryString["error"] != null)
{
panError.Visible = true;
}
if (Request.QueryString["close"] != null)
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">window.close();<" + "/" + "script>");
}
else if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
string strID = oFunction.decryptQueryString(Request.QueryString["id"]);
intResource = Int32.Parse(strID);
DataSet ds = oDataPoint.GetServiceRequestResource(intResource);
if (ds.Tables[0].Rows.Count == 1)
{
// Load General Information
//string strHeader = intResource.ToString();
string strHeader = ds.Tables[0].Rows[0]["requestid"].ToString()
+ "-" + (ds.Tables[0].Rows[0]["ServiceId"] != DBNull.Value?ds.Tables[0].Rows[0]["ServiceId"].ToString():"0")
+ "-" + (ds.Tables[0].Rows[0]["number"] != DBNull.Value ? ds.Tables[0].Rows[0]["number"].ToString() : "0");
lblRequestID.Text = strHeader;
lblRequestID.ToolTip = "Resource Request :" + intResource.ToString();
lblHeader.Text = """ + strHeader + """;
Master.Page.Title = "DataPoint | Request (" + strHeader + ")";
lblHeaderSub.Text = "Provides all the information about a resource request...";
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("Submitted Information", "");
oTab.AddTab("Workflow / History", "");
oTab.AddTab("Resource(s) Involvement", "");
if (oUser.IsAdmin(intProfile) == true)
{
trAdmin.Visible = true;
Variables oVariable = new Variables(intEnvironment);
txtUser.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'300','195','" + divUser.ClientID + "','" + lstUser.ClientID + "','" + hdnUser.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstUser.Attributes.Add("ondblclick", "AJAXClickRow();");
oTab.AddTab("Resource Detail", "");
divDetail.Visible = true;
}
if (!IsPostBack)
{
strOriginal = oResourceRequest.GetSummary(intResource, 0, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP);
bool boolDeleted = (ds.Tables[0].Rows[0]["deleted"].ToString() != "0");
panDeleted.Visible = boolDeleted;
int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
int intRequestor = oRequest.GetUser(intRequest);
strRequestor = "<a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"OpenWindow('PROFILE','?userid=" + intRequestor.ToString() + "');\">" + oUser.GetFullName(intRequestor) + " [" + oUser.GetName(intRequestor) + "]</a>";
int intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString());
int intApp = oRequestItem.GetItemApplication(intItem);
int intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString());
int intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString());
// General Information
oDataPoint.LoadTextBox(txtRequest, intProfile, null, "/datapoint/service/request.aspx?t=id&q=" + oFunction.encryptQueryString("CVT" + intRequest.ToString()) + "&id=" + oFunction.encryptQueryString(intRequest.ToString()), lblRequest, fldRequest, "RESOURCE_REQUEST", "CVT" + ds.Tables[0].Rows[0]["requestid"].ToString(), "", true, false);
oDataPoint.LoadTextBox(txtCreated, intProfile, null, "", lblCreated, fldCreated, "RESOURCE_CREATED", ds.Tables[0].Rows[0]["created"].ToString(), "", true, false);
oDataPoint.LoadTextBox(txtDepartment, intProfile, null, "", lblDepartment, fldDepartment, "RESOURCE_DEPARTMENT", ds.Tables[0].Rows[0]["department"].ToString(), "", true, false);
oDataPoint.LoadTextBox(txtService, intProfile, null, "", lblService, fldService, "RESOURCE_SERVICE", oService.GetName(intService), "", true, false);
string strOwner = "";
DataSet dsOwner = oService.GetUser(intService, -1); // Service Owners
foreach (DataRow drOwner in dsOwner.Tables[0].Rows)
{
if (strOwner != "")
{
strOwner += ", ";
}
int intOwner = Int32.Parse(drOwner["userid"].ToString());
strOwner += "<span class=\"required\">*</span> <a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"OpenWindow('PROFILE','?userid=" + intOwner.ToString() + "');\">" + oUser.GetFullName(intOwner) + " [" + oUser.GetName(intOwner) + "]</a>";
}
//strOwner = "<b>" + strOwner + "</b>";
DataSet dsManager = oService.GetUser(intService, 1); // Managers
foreach (DataRow drManager in dsManager.Tables[0].Rows)
{
if (strOwner != "")
{
strOwner += ", ";
}
int intManager = Int32.Parse(drManager["userid"].ToString());
strOwner += "<a href=\"javascript:void(0);\" class=\"lookup\" onclick=\"OpenWindow('PROFILE','?userid=" + intManager.ToString() + "');\">" + oUser.GetFullName(intManager) + " [" + oUser.GetName(intManager) + "]</a>";
}
oDataPoint.LoadTextBox(txtOwner, intProfile, null, "", lblOwner, fldOwner, "RESOURCE_OWNER", strOwner, "", true, false);
oDataPoint.LoadTextBox(txtName, intProfile, null, "", lblName, fldName, "RESOURCE_NAME", ds.Tables[0].Rows[0]["name"].ToString(), "", false, true);
oDataPoint.LoadTextBox(txtDevices, intProfile, null, "", lblDevices, fldDevices, "RESOURCE_DEVICES", ds.Tables[0].Rows[0]["devices"].ToString(), "", false, true);
oDataPoint.LoadTextBox(txtAllocated, intProfile, null, "", lblAllocated, fldAllocated, "RESOURCE_ALLOCATED", ds.Tables[0].Rows[0]["allocated"].ToString(), "", false, true);
if (txtDevices.Visible == true && oService.Get(intService, "disable_hours") != "1")
{
txtAllocated.Enabled = false;
txtAllocated.ToolTip = intService.ToString();
panDynamic.Visible = true;
}
int intAccepted = Int32.Parse(ds.Tables[0].Rows[0]["accepted"].ToString());
oDataPoint.LoadDropDown(ddlAccepted, intProfile, null, "", lblAccepted, fldAccepted, "REQUEST_ACCEPTED", "name", "id", SqlHelper.ExecuteDataset(dsn, CommandType.Text, "SELECT -1 AS id, 'No' AS name UNION ALL SELECT 0 AS id, 'Pending' AS name UNION ALL SELECT 1 AS id, 'Yes' AS name"), intAccepted, false, false, true);
oDataPoint.LoadDropDown(ddlStatus, intProfile, null, "", lblStatus, fldStatus, "REQUEST_STATUS", "name", "id", SqlHelper.ExecuteDataset(dsn, CommandType.Text, oStatusLevel.List()), Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString()), false, false, true);
oDataPoint.LoadTextBox(txtReason, intProfile, null, "", lblReason, fldReason, "RESOURCE_REASON", ds.Tables[0].Rows[0]["reason"].ToString(), "", false, false);
int intAssigned = Int32.Parse(ds.Tables[0].Rows[0]["assignedby"].ToString());
oDataPoint.LoadDropDownAJAX(txtAssignedBy, hdnAssignedBy, divAssignedBy, lstAssignedBy, intEnvironment, intProfile, null, "", lblAssignedBy, fldAssignedBy, "RESOURCE_ASSIGNED", intAssigned, (intAssigned > 0 ? oUser.GetFullName(intAssigned) + " (" + oUser.GetName(intAssigned) + ")" : ""), "/frame/users.aspx", "", false, false);
oDataPoint.LoadTextBox(txtAssignedOn, intProfile, null, "", lblAssignedOn, fldAssignedOn, "RESOURCE_ASSIGNED", ds.Tables[0].Rows[0]["assigned"].ToString(), "", true, false);
btnAssign.Visible = oUser.IsAdmin(intProfile);
btnAssign.Enabled = (intAssigned > 0);
ucWorkflow.RequestID = intRequest;
ucWorkflow.ServiceID = intService;
ucWorkflow.Number = intNumber;
ucResourceInvolvement.ResourceRequestId = intResource;
//if (ds.Tables[1].Rows.Count > 0)
//{
// // Resource Assignment(s)
// if (ds.Tables[2].Rows.Count > 0)
// ds.Relations.Add("relationship", ds.Tables[1].Columns["id"], ds.Tables[2].Columns["id"]);
// rptAssignments.DataSource = ds.Tables[1];
// rptAssignments.DataBind();
// foreach (RepeaterItem ri in rptAssignments.Items)
// {
// Label lblStatusR = (Label)ri.FindControl("lblStatusR");
// int intStatus = Int32.Parse(lblStatusR.Text);
// lblStatusR.Text = oStatusLevel.HTML(intStatus);
// Label lblProgress = (Label)ri.FindControl("lblProgress");
// double dblProgress = double.Parse(lblProgress.Text);
// if (intStatus == 3)
// dblProgress = 100.00;
// if (intStatus < 1 || intStatus > 2)
// lblProgress.Text = "---";
// else
// {
// try
// {
// lblProgress.Text = oServiceRequest.GetStatusBar(dblProgress, "100", "12", true);
// }
// catch
// {
// lblProgress.Text = oServiceRequest.GetStatusBar(0.00, "100", "12", true);
// }
// }
// Panel panDelete = (Panel)ri.FindControl("panDelete");
// if (panDelete.ToolTip == "1")
// panDelete.Visible = true;
// else
// {
// Panel panEdit = (Panel)ri.FindControl("panEdit");
// panEdit.Visible = true;
// Button btnLogin = (Button)ri.FindControl("btnLogin");
// btnLogin.Attributes.Add("onclick", "return OpenNewWindowMenu('/frame/resource_request.aspx?rrid=" + btnLogin.CommandArgument + "', '800', '600');");
// Button btnEdit = (Button)ri.FindControl("btnEdit");
// if (oUser.IsAdmin(intProfile) || oService.IsManager(intService, intProfile))
// btnEdit.Attributes.Add("onclick", "return OpenNewWindowMenu('/datapoint/service/manager.aspx?id=" + btnEdit.CommandArgument + "', '800', '600');");
// else
// btnEdit.Enabled = false;
// LinkButton btnMore = (LinkButton)ri.FindControl("btnMore");
// btnMore.Attributes.Add("onclick", "ShowHideDiv2('div_" + btnMore.CommandArgument + "');return false;");
// if (ds.Tables[2].Rows.Count > 0)
// btnMore.Visible = true;
// }
// }
//}
//lblAssignments.Visible = (rptAssignments.Items.Count == 0);
// This should be the last tab to load
DataSet dsResults = oRequest.GetResult(intRequest, intItem, intNumber);
if (dsResults.Tables[0].Rows.Count > 0)
{
// Request Results
oTab.AddTab("Request Results", "");
divResults.Visible = true;
rptResults.DataSource = dsResults;
rptResults.DataBind();
}
lblResults.Visible = (rptResults.Items.Count == 0);
strMenuTab1 = oTab.GetTabs();
}
}
else
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">window.close();<" + "/" + "script>");
}
}
else
{
Response.Redirect("/datapoint/service/datapoint_service_search.aspx");
}
btnAssign.Attributes.Add("onclick", "return confirm('Are you sure you want to put this request back in queue for assignment?');");
btnClose.Attributes.Add("onclick", "window.close();return false;");
btnPrint.Attributes.Add("onclick", "window.print();return false;");
btnSave.Attributes.Add("onclick", oDataPoint.LoadValidation());
btnSaveClose.Attributes.Add("onclick", oDataPoint.LoadValidation());
}
else
{
panDenied.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oProjectRequest = new ProjectRequest(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oProjectNumber = new ProjectNumber(intProfile, dsn);
oPage = new Pages(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oRequestItem = new RequestItems(intProfile, dsn);
oApplication = new Applications(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oVariable = new Variables(intEnvironment);
oService = new Services(intProfile, dsn);
oDelegate = new Delegates(intProfile, dsn);
oStatusLevel = new StatusLevels();
oEnhancement = new Enhancements(intProfile, dsn);
oLog = new Log(intProfile, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "")
{
intPage = Int32.Parse(Request.QueryString["pageid"]);
}
if (Request.QueryString["action"] != null && Request.QueryString["action"] != "")
{
panFinish.Visible = true;
}
else
{
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 (!IsPostBack)
{
if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "")
{
lblResourceParent.Text = Request.QueryString["rrid"];
int intResourceParent = Int32.Parse(lblResourceParent.Text);
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 intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString());
int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
Forecast oForecast = new Forecast(intProfile, dsn);
if (intService == intStorageService)
{
try
{
OnDemandTasks oOnDemandTask = new OnDemandTasks(0, dsn);
Locations oLocation = new Locations(0, dsn);
DataSet dsDesign = oOnDemandTask.GetServerStorage(intRequest, intItem, intNumber);
if (dsDesign.Tables[0].Rows.Count == 1)
{
int intAnswer = Int32.Parse(dsDesign.Tables[0].Rows[0]["answerid"].ToString());
int intAddress = Int32.Parse(oForecast.GetAnswer(intAnswer, "addressid"));
lblLocation.Text = oLocation.GetFull(intAddress);
panLocation.Visible = true;
}
}
catch { }
}
int intProject = Int32.Parse(oRequest.Get(intRequest, "projectid"));
int intApp = oRequestItem.GetItemApplication(intItem);
int intForecast = 0;
DataSet dsForecast = oForecast.GetProject(intProject);
if (dsForecast.Tables[0].Rows.Count > 0)
{
intForecast = Int32.Parse(dsForecast.Tables[0].Rows[0]["id"].ToString());
}
if (intForecast > 0)
{
btnView.Attributes.Add("oncontextmenu", "return OpenWindow('NEW_WINDOW','" + oPage.GetFullLink(intDesignBuilder) + "?id=" + intForecast.ToString() + "');");
}
else
{
btnView.Attributes.Add("oncontextmenu", "alert('There is no design for this project');return false;");
}
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 = "Click here to view the project details";
lblType.Text = "Project Request";
}
else
{
btnView.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intViewResourceRequest.ToString() + "&rrid=" + intResourceParent.ToString() + "');");
if (oApplication.Get(intApp, "tpm") == "1")
{
btnView.Text = "Click here to view the project details";
}
else
{
btnView.Text = "Click here to view this request";
}
lblType.Text = "Service Request";
}
btnAssignments.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intSearchPage.ToString() + "&pid=" + intProject + "&aid=" + intApp.ToString() + "&sort=userid');");
//btnAssignments.Attributes.Add("onclick", "return OpenNewWindowMenu('/datapoint/projects/datapoint_projects.aspx?id=" + oFunction.encryptQueryString(intProject.ToString()) + "', '800', '600');");
lblItem.Text = intItem.ToString();
lblService.Text = oService.GetName(intService);
if (oApplication.Get(intApp, "request_items") == "1")
{
lblGroup.Text = oApplication.GetName(intApp) + " | " + oRequestItem.GetItemName(intItem);
}
else
{
lblGroup.Text = oApplication.GetName(intApp);
}
int intUser = Int32.Parse(oRequest.Get(intRequest, "userid"));
int intAppManager = oApplication.GetManager(intApp);
if (ds.Tables[0].Rows[0]["accepted"].ToString() == "-1" && oApplication.Get(intApp, "tpm") == "1")
{
if (intUser == intProfile || oDelegate.Get(intUser, intProfile) > 0)
{
panRequest.Visible = true;
panAssignSingle.Visible = true;
txtHours.Text = double.Parse(ds.Tables[0].Rows[0]["allocated"].ToString()).ToString("F");
panHours.Visible = !(oApplication.Get(intApp, "tpm") == "1");
txtHours.Enabled = (oService.Get(intService, "disable_hours") == "1" ? false : true);
lblQuantity.Text = ds.Tables[0].Rows[0]["devices"].ToString();
lblStatus.Text = oStatusLevel.HTML(Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString()));
panQuantity.Visible = (lblQuantity.Text != "0");
txtQuantity.Text = lblQuantity.Text;
txtQuantity.Enabled = (txtQuantity.Text != "0");
txtQuantity.Enabled = false;
lblAssign.Text = oUser.GetFullName(intProfile);
strSummary = oResourceRequest.GetBodyOverallFix(intResourceParent, 0, intEnvironment, false);
}
else
{
Response.Write("no rights");
panDenied.Visible = true;
}
btnSubmit.Attributes.Add("onclick", "return ValidateNumber0('" + txtHours.ClientID + "','Please enter a valid number for the hours allocated') && ValidateHidden('" + hdnManager.ClientID + "','" + txtManager.ClientID + "','Please enter a valid LAN ID') && ProcessButton(this);");
}
else
{
string strValidate = "";
if (oUser.IsAdmin(intProfile) || oService.IsManager(intService, intProfile) || (oApplication.IsManager(intApp, intProfile) && oApplication.Get(intApp, "disable_manager") != "1"))
{
panRequest.Visible = true;
panAssignMultiple.Visible = true;
btnSubmit.Enabled = (ds.Tables[0].Rows[0]["assigned"].ToString() == "");
if (ds.Tables[0].Rows[0]["status"].ToString() == "5")
{
radHold.Checked = true;
divChoice.Style["display"] = "inline";
divHold.Style["display"] = "inline";
txtHold.Text = ds.Tables[0].Rows[0]["reason"].ToString();
}
else
{
divChoice.Style["display"] = (ds.Tables[0].Rows[0]["accepted"].ToString() == "0" ? "inline" : "none");
divAccept.Style["display"] = (ds.Tables[0].Rows[0]["accepted"].ToString() == "1" ? "inline" : "none");
}
int intEnhancementService = 0;
Int32.TryParse(ConfigurationManager.AppSettings["HELP_ENHANCEMENT_SERVICEID"], out intEnhancementService);
if (intService == intEnhancementService)
{
panEnhancement.Visible = true;
ddlModule.DataTextField = "name";
ddlModule.DataValueField = "id";
ddlModule.DataSource = oEnhancement.GetModules(1);
ddlModule.DataBind();
ddlModule.Items.Insert(0, new ListItem("-- SELECT --", "0"));
strValidate += "ValidateDropDown('" + ddlModule.ClientID + "','Select a classification') && ";
radEnhancementShort.Checked = true;
radEnhancementReject.Attributes.Add("onclick", "ShowHideDiv('" + trEnhancementReject.ClientID + "','inline');ShowHideDiv('" + trEnhancementClassification.ClientID + "','none');ShowHideDiv('" + divAccept.ClientID + "','none');");
radEnhancementDuplicate.Attributes.Add("onclick", "ShowHideDiv('" + trEnhancementReject.ClientID + "','inline');ShowHideDiv('" + trEnhancementClassification.ClientID + "','none');ShowHideDiv('" + divAccept.ClientID + "','none');");
radEnhancementShort.Attributes.Add("onclick", "ShowHideDiv('" + trEnhancementReject.ClientID + "','none');ShowHideDiv('" + trEnhancementClassification.ClientID + "','inline');ShowHideDiv('" + divAccept.ClientID + "','inline');");
radEnhancementLong.Attributes.Add("onclick", "ShowHideDiv('" + trEnhancementReject.ClientID + "','inline');ShowHideDiv('" + trEnhancementClassification.ClientID + "','inline');ShowHideDiv('" + divAccept.ClientID + "','inline');");
}
panDelete.Visible = (intItem == intImplementorDistributed || intItem == intImplementorMidrange);
btnDelete.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this request');");
txtHours.Text = double.Parse(ds.Tables[0].Rows[0]["allocated"].ToString()).ToString("F");
panHours.Visible = !(oApplication.Get(intApp, "tpm") == "1");
txtHours.Enabled = (oService.Get(intService, "disable_hours") == "1" ? false : true);
lblQuantity.Text = ds.Tables[0].Rows[0]["devices"].ToString();
panQuantity.Visible = (lblQuantity.Text != "0");
txtQuantity.Text = lblQuantity.Text;
txtQuantity.Enabled = (txtQuantity.Text != "0");
txtQuantity.Enabled = false;
lblStatus.Text = oStatusLevel.HTML(Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString()));
trAssigned.Visible = !(btnSubmit.Enabled);
string strAssign = "";
DataSet dsManager = oService.GetUser(intService, 1);
foreach (DataRow drManager in dsManager.Tables[0].Rows)
{
if (strAssign != "")
{
strAssign += ", ";
}
strAssign += oUser.GetFullName(Int32.Parse(drManager["userid"].ToString()));
}
lblAssign.Text = strAssign;
DataSet dsReports = oUser.GetManagerReports(intAppManager, intRequest, intService, intNumber);
DataTable dtReports = dsReports.Tables[0].Copy();
dtReports.Clear();
DataSet dsAssignment = oService.GetUser(intService, -100);
foreach (DataRow drAssignment in dsAssignment.Tables[0].Rows)
{
int intAssignment = Int32.Parse(drAssignment["userid"].ToString());
DataSet dsAssignees = oUser.GetManagerReports(intAssignment, intRequest, intService, intNumber);
foreach (DataRow drAssignee in dsAssignees.Tables[0].Rows)
{
dtReports.ImportRow(drAssignee);
}
}
if (dtReports.Rows.Count > 0)
{
// Use custom assignment list
// First, remove duplicates
Hashtable hTable = new Hashtable();
ArrayList duplicateList = new ArrayList();
foreach (DataRow drow in dtReports.Rows)
{
if (hTable.Contains(drow["userid"]))
{
duplicateList.Add(drow);
}
else
{
hTable.Add(drow["userid"], string.Empty);
}
}
foreach (DataRow dRow in duplicateList)
{
dtReports.Rows.Remove(dRow);
}
// Next, sort by username
dtReports.DefaultView.Sort = "username";
// Now add to dataset
dsReports = new DataSet();
dsReports.Tables.Add(dtReports.DefaultView.ToTable());
}
LoadList(dsReports, intApp);
LoadAvailable(dsReports, intApp);
strSummary = oResourceRequest.GetBodyOverallFix(intResourceParent, 0, intEnvironment, false);
}
else
{
Response.Write("no delegate");
panDenied.Visible = true;
}
btnSubmit.Attributes.Add("onclick", "return " + strValidate + "ValidateChoice('" + divChoice.ClientID + "','" + radAccept.ClientID + "','" + radReject.ClientID + "','" + radHold.ClientID + "','" + ddlUser.ClientID + "','" + txtHours.ClientID + "') && ProcessButton(this);");
}
}
else
{
panDenied.Visible = true;
}
}
else
{
panDenied.Visible = true;
}
}
}
btnClose.Attributes.Add("onclick", "return CloseWindow();");
lnkAvailable.Attributes.Add("onclick", "return ShowHideAvailable('" + divAvailable.ClientID + "');");
radAccept.Attributes.Add("onclick", "ShowHideDiv('" + divAccept.ClientID + "','inline');ShowHideDiv('" + divReject.ClientID + "','none');ShowHideDiv('" + divHold.ClientID + "','none');");
radReject.Attributes.Add("onclick", "ShowHideDiv('" + divReject.ClientID + "','inline');ShowHideDiv('" + divAccept.ClientID + "','none');ShowHideDiv('" + divHold.ClientID + "','none');");
radHold.Attributes.Add("onclick", "ShowHideDiv('" + divHold.ClientID + "','inline');ShowHideDiv('" + divAccept.ClientID + "','none');ShowHideDiv('" + divReject.ClientID + "','none');");
txtManager.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'300','195','" + divManager.ClientID + "','" + lstManager.ClientID + "','" + hdnManager.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstManager.Attributes.Add("ondblclick", "AJAXClickRow();");
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oRequest = new Requests(intProfile, dsn);
oService = new Services(intProfile, dsn);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oCustomized = new Customized(intProfile, dsn);
oPage = new Pages(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oStatusLevel = new StatusLevels();
oUser = new Users(intProfile, dsn);
oApplication = new Applications(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["id"] != null && Request.QueryString["id"] != "")
{
intId = Int32.Parse(Request.QueryString["id"]);
}
if (!IsPostBack)
{
drpModules.DataValueField = "pageid";
drpModules.DataTextField = "menutitle";
drpModules.DataSource = oPage.Gets(intApplication, intProfile, 0, 1, 1);
drpModules.DataBind();
drpModules.Items.Add(new ListItem("New Module", "-10"));
drpModules.Items.Insert(0, new ListItem("-- SELECT --", "0"));
}
if (intId > 0)
{
panIncident.Visible = true;
DataSet ds = oCustomized.GetIssueByID(intId);
if (ds.Tables[0].Rows.Count > 0)
{
radNo.Checked = true;
radYes.Enabled = false;
radNo.Enabled = false;
divNo.Style["display"] = "inline";
panStatus.Visible = true;
lblTitle.Text = "Edit Issue";
txtTitle.Text = ds.Tables[0].Rows[0]["title"].ToString();
txtDescription.Text = ds.Tables[0].Rows[0]["description"].ToString();
drpModules.SelectedValue = ds.Tables[0].Rows[0]["pageid"].ToString();
txtNumUsers.Text = ds.Tables[0].Rows[0]["num_users"].ToString();
txtURL.Text = ds.Tables[0].Rows[0]["url"].ToString();
if (ds.Tables[0].Rows[0]["path"].ToString() != "")
{
panUploaded.Visible = true;
hypUpload.NavigateUrl = ds.Tables[0].Rows[0]["path"].ToString();
}
else
{
panUpload.Visible = true;
}
lblStatus.Text = oStatusLevel.HTMLSupport(Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString()));
lblStatus.Attributes.Add("oncontextmenu", "alert('CVT" + intRequest.ToString() + "');");
if (ds.Tables[0].Rows[0]["status"].ToString() == "0")
{
btnUpdate.Visible = true;
panActive.Visible = true;
}
lblRequestBy.Text = oUser.GetFullName(intProfile);
lblRequestOn.Text = DateTime.Parse(ds.Tables[0].Rows[0]["created"].ToString()).ToString();
intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
oCustomized.UpdateIssueNew(intRequest, 0);
panMessage.Visible = (oCustomized.GetMessages(intRequest, 0).Tables[0].Rows.Count > 0);
strMessages = oCustomized.GetMessages(intRequest, false, "#E1FFE1");
if (ds.Tables[0].Rows[0]["status"].ToString() == "2" || ds.Tables[0].Rows[0]["status"].ToString() == "7")
{
btnMessage.Attributes.Add("onclick", "ShowHideDiv2('" + divMessage.ClientID + "');return false;");
}
else
{
btnMessage.Attributes.Add("onclick", "alert('You can only post a message to an ACTIVE thread.\\n\\nSince this thread is no longer active, additional posts have been disabled');return false;");
}
}
}
else
{
panNoIncident.Visible = true;
panUpload.Visible = true;
lblRequestBy.Text = oUser.GetFullName(intProfile);
lblRequestOn.Text = DateTime.Now.ToString();
lblTitle.Text = oPage.Get(intPage, "title");
txtNumUsers.Text = "0";
btnSave.Visible = true;
panActive.Visible = true;
}
radYes.Attributes.Add("onclick", "ShowHideDiv('" + divYes.ClientID + "','inline');ShowHideDiv('" + divNo.ClientID + "','none');");
radNo.Attributes.Add("onclick", "ShowHideDiv('" + divNo.ClientID + "','inline');ShowHideDiv('" + divYes.ClientID + "','none');");
btnSave.Attributes.Add("onclick", "return ValidateText('" + txtTitle.ClientID + "','Please enter a title')" +
" && ValidateText('" + txtDescription.ClientID + "','Please enter a description')" +
" && ValidateNumber('" + txtNumUsers.ClientID + "','Please enter a valid number for the number of users')" +
";");
btnUpdate.Attributes.Add("onclick", "return ValidateText('" + txtTitle.ClientID + "','Please enter a title')" +
" && ValidateText('" + txtDescription.ClientID + "','Please enter a description')" +
" && ValidateNumber('" + txtNumUsers.ClientID + "','Please enter a valid number for the number of users')" +
";");
btnResponse.Attributes.Add("onclick", "return ValidateText('" + txtResponse.ClientID + "','Please enter a response');");
btnDeleteAttachment.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this file?');");
}
