protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["adminid"] != null && Request.Cookies["adminid"].Value != "") { intProfile = Int32.Parse(Request.Cookies["adminid"].Value); } else { Reload(); } oApplication = new Applications(intProfile, dsn); oPage = new Pages(intProfile, dsn); oAppPage = new AppPages(intProfile, dsn); btnClose.Attributes.Add("onclick", "return HidePanel();"); if (!IsPostBack) { int intApplication = 0; if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "") { lblApplication.Text = Request.QueryString["applicationid"]; intApplication = Int32.Parse(Request.QueryString["applicationid"]); } LoadPages(null, 0, intApplication); if (intApplication > 0) { lblName.Text = oApplication.GetName(intApplication); } else { lblName.Text = "GLOBAL ADD"; } } }
protected void Page_Load(object sender, EventArgs e) { Response.Cookies["loginreferrer"].Value = "/admin/services_pending.aspx"; Response.Cookies["loginreferrer"].Expires = DateTime.Now.AddDays(30); if (Request.Cookies["adminid"] != null && Request.Cookies["adminid"].Value != "") { intProfile = Int32.Parse(Request.Cookies["adminid"].Value); } else { Response.Redirect("/admin/login.aspx"); } oService = new Services(intProfile, dsn); oServiceEditor = new ServiceEditor(intProfile, dsn); oRequestItem = new RequestItems(intProfile, dsn); oApplication = new Applications(intProfile, dsn); oUser = new Users(intProfile, dsn); if (Request.QueryString["id"] != null && Request.QueryString["id"] != "") { intService = Int32.Parse(Request.QueryString["id"]); panView.Visible = true; if (!IsPostBack) { LoadServices(0); lblName.Text = oService.GetName(intService); int intItem = oService.GetItemId(intService); lblItem.Text = oRequestItem.GetItemName(intItem); lblApplication.Text = oApplication.GetName(oRequestItem.GetItemApplication(intItem)); DataSet ds = oService.GetUser(intService, -1); if (ds.Tables[0].Rows.Count > 0) { lblUser.Text = oUser.GetFullName(Int32.Parse(ds.Tables[0].Rows[0]["userid"].ToString())); } } } else { panAll.Visible = true; rptView.DataSource = oService.GetPending(); rptView.DataBind(); } btnSave.Attributes.Add("onclick", "return confirm('Are you sure you want to save this service?');"); btnDelete.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this service?');"); }
private void LoadProperties() { ds = oPermission.Get(Int32.Parse(hdnId.Value)); if (ds.Tables[0].Rows.Count > 0) { int intApplication = Int32.Parse(ds.Tables[0].Rows[0]["applicationid"].ToString()); hdnApplication.Value = intApplication.ToString(); if (intApplication == 0) { lblApplication.Text = "No Application"; } else { lblApplication.Text = oApplication.GetName(intApplication); } ddlGroup.SelectedValue = ds.Tables[0].Rows[0]["groupid"].ToString(); ddlPermission.SelectedValue = ds.Tables[0].Rows[0]["permission"].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["adminid"] != null && Request.Cookies["adminid"].Value != "") { intProfile = Int32.Parse(Request.Cookies["adminid"].Value); } else { Reload(); } oPermission = new Permissions(intProfile, dsn); oApplication = new Applications(intProfile, dsn); oGroup = new Groups(intProfile, dsn); if (Request.QueryString["id"] != null && Request.QueryString["id"] != "") { if (!IsPostBack) { hdnApplication.Value = "0"; lblApplication.Text = "No Category"; hdnId.Value = Request.QueryString["id"]; LoadLists(); if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "") { hdnApplication.Value = Request.QueryString["applicationid"]; int intApplication = Int32.Parse(hdnApplication.Value); lblApplication.Text = oApplication.GetName(intApplication); } if (hdnId.Value == "0") { btnDelete.Visible = false; } else { btnSave.Text = "Update"; LoadProperties(); btnDelete.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this permission?');"); } btnClose.Attributes.Add("onclick", "return HidePanel();"); } } }
protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["adminid"] != null && Request.Cookies["adminid"].Value != "") { intProfile = Int32.Parse(Request.Cookies["adminid"].Value); } else { Reload(); } oVariable = new Variables(intEnvironment); oCustomized = new Customized(intProfile, dsn); oService = new Services(intProfile, dsn); oApplication = new Applications(intProfile, dsn); oUser = new Users(intProfile, dsn); Int32.TryParse(Request.QueryString["applicationid"], out intApplication); if (intApplication > 0) { litApplication.Text = oApplication.GetName(intApplication); } if (Request.QueryString["id"] != null && Request.QueryString["id"] != "") { lblId.Text = Request.QueryString["id"]; } string strControl = ""; string strControlText = ""; if (Request.QueryString["control"] != null) { strControl = Request.QueryString["control"]; } if (Request.QueryString["controltext"] != null) { strControlText = Request.QueryString["controltext"]; } btnNone.Attributes.Add("onclick", "return Reset(0,'" + hdnId.ClientID + "','No Document','" + txtName.ClientID + "');"); btnSave.Attributes.Add("onclick", "return Update('" + hdnId.ClientID + "','" + strControl + "','" + txtName.ClientID + "','" + strControlText + "');"); btnClose.Attributes.Add("onclick", "return HidePanel();"); LoadTree(); }
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); 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); 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"; } } } }
protected void LoadSearch(int _search) { Search oSearch = new Search(intProfile, dsn); RequestItems oRequestItem = new RequestItems(intProfile, dsn); Services oService = new Services(intProfile, dsn); Applications oApplication = new Applications(intProfile, dsn); StatusLevels oStatusLevel = new StatusLevels(); Users oUser = new Users(intProfile, dsn); Projects oProject = new Projects(intProfile, dsn); ResourceRequest oResourceRequest = new ResourceRequest(intProfile, dsn); ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn); DataSet ds = oSearch.GetProject(_search); int intApplication = 0; if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "") { intApplication = Int32.Parse(Request.QueryString["applicationid"]); } if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "") { intApplication = Int32.Parse(Request.Cookies["application"].Value); } if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["userid"].ToString() == intProfile.ToString()) { string strType = ds.Tables[0].Rows[0]["type"].ToString(); string strClause = "cv_projects.deleted = 0 AND cv_projects.number NOT LIKE 'CV%' AND cv_projects.number NOT LIKE 'EPS%'"; string strOr1 = ""; string strOr2 = ""; string strSQL = "SELECT DISTINCT '?pid=' + CAST(cv_projects.projectid AS varchar(10)) + '&sid=" + _search.ToString() + "' AS query, cv_projects.name, cv_projects.number, cv_projects.status, cv_projects.modified FROM cv_projects INNER JOIN cv_requests LEFT OUTER JOIN cv_service_requests ON cv_service_requests.requestid = cv_requests.requestid AND cv_service_requests.deleted = 0 LEFT OUTER JOIN cv_project_requests ON cv_project_requests.requestid = cv_requests.requestid AND cv_project_requests.deleted = 0 INNER JOIN cv_resource_requests INNER JOIN cv_request_items INNER JOIN cv_applications ON cv_request_items.applicationid = cv_applications.applicationid AND cv_applications.deleted = 0 ON cv_request_items.itemid = cv_resource_requests.itemid AND cv_request_items.deleted = 0 INNER JOIN cv_users ON cv_resource_requests.userid = cv_users.userid AND cv_users.deleted = 0 AND cv_users.enabled = 1 ON cv_requests.requestid = cv_resource_requests.requestid AND cv_resource_requests.deleted = 0 ON cv_requests.projectid = cv_projects.projectid AND cv_requests.deleted = 0 WHERE "; string strApplication = " AND cv_request_items.applicationid = " + intApplication.ToString(); switch (strType) { case "O": strApplication = ""; string strOName = ds.Tables[0].Rows[0]["oname"].ToString().Trim(); string strONumber = ds.Tables[0].Rows[0]["onumber"].ToString().Trim(); if (strONumber != "") { strClause += " AND cv_projects.number LIKE '%" + strONumber + "%'"; lblResults.Text = "Project Number LIKE "" + strONumber + """; } else { strClause += " AND cv_projects.name LIKE '%" + strOName + "%'"; lblResults.Text = "Project Name LIKE "" + strOName + """; } string strOStatus = ds.Tables[0].Rows[0]["ostatus"].ToString(); if (strOStatus != "0") { strClause += " AND cv_projects.status = " + strOStatus; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Status = "" + oStatusLevel.Name(Int32.Parse(strOStatus)) + """; } string strOStart = ds.Tables[0].Rows[0]["ostart"].ToString(); if (strOStart != "") { strOStart = DateTime.Parse(strOStart).ToShortDateString(); strClause += " AND cv_projects.modified > " + strOStart; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Project Date > "" + strOStart + """; } string strOEnd = ds.Tables[0].Rows[0]["oend"].ToString(); if (strOEnd != "") { strOEnd = DateTime.Parse(strOEnd).ToShortDateString(); strClause += " AND cv_projects.modified < " + strOEnd; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Project Date < "" + strOEnd + """; } break; case "P": string strDepartment = ds.Tables[0].Rows[0]["department"].ToString(); if (strDepartment == "0") { strApplication = ""; lblResults.Text += "Department = "ALL""; } else { strApplication = " AND cv_request_items.applicationid = " + strDepartment; lblResults.Text += "Department = "" + oApplication.GetName(Int32.Parse(strDepartment)) + """; } string strDStatus = ds.Tables[0].Rows[0]["dstatus"].ToString(); if (strDStatus != "0") { strClause += " AND cv_resource_requests.status = " + strDStatus; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Status = "" + oStatusLevel.Name(Int32.Parse(strDStatus)) + """; } string strDStart = ds.Tables[0].Rows[0]["dstart"].ToString(); if (strDStart != "") { strDStart = DateTime.Parse(strDStart).ToShortDateString(); strClause += " AND cv_requests.modified > " + strDStart; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Request Date > "" + strDStart + """; } string strDEnd = ds.Tables[0].Rows[0]["dend"].ToString(); if (strDEnd != "") { strDEnd = DateTime.Parse(strDEnd).ToShortDateString(); strClause += " AND cv_requests.modified < " + strDEnd; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Request Date < "" + strDEnd + """; } break; case "T": string strTechnician = ds.Tables[0].Rows[0]["technician"].ToString(); if (strTechnician != "0") { strClause += " AND cv_resource_requests.userid = " + strTechnician; lblResults.Text += "Technician = "" + oUser.GetFullName(Int32.Parse(strTechnician)) + """; } string strTStatus = ds.Tables[0].Rows[0]["tstatus"].ToString(); if (strTStatus != "0") { strClause += " AND cv_resource_requests.status = " + strTStatus; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Status = "" + oStatusLevel.Name(Int32.Parse(strTStatus)) + """; } string strTStart = ds.Tables[0].Rows[0]["tstart"].ToString(); if (strTStart != "") { strTStart = DateTime.Parse(strTStart).ToShortDateString(); strClause += " AND cv_requests.modified > " + strTStart; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Request Date > "" + strTStart + """; } string strTEnd = ds.Tables[0].Rows[0]["tend"].ToString(); if (strTEnd != "") { strTEnd = DateTime.Parse(strTEnd).ToShortDateString(); strClause += " AND cv_requests.modified < " + strTEnd; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Request Date < "" + strTEnd + """; } break; case "L": string strLead = ds.Tables[0].Rows[0]["lead"].ToString(); if (strLead != "0") { int intLead = Int32.Parse(strLead); strClause += " AND cv_users.manager = " + intLead.ToString(); lblResults.Text += "Team Lead = "" + oUser.GetFullName(intLead) + """; } string strLStatus = ds.Tables[0].Rows[0]["lstatus"].ToString(); if (strLStatus != "0") { strClause += " AND cv_resource_requests.status = " + strLStatus; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Status = "" + oStatusLevel.Name(Int32.Parse(strLStatus)) + """; } string strLStart = ds.Tables[0].Rows[0]["lstart"].ToString(); if (strLStart != "") { strLStart = DateTime.Parse(strLStart).ToShortDateString(); strClause += " AND cv_requests.modified > " + strLStart; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Request Date < "" + strLStart + """; } string strLEnd = ds.Tables[0].Rows[0]["lend"].ToString(); if (strLEnd != "") { strLEnd = DateTime.Parse(strLEnd).ToShortDateString(); strClause += " AND cv_requests.modified < " + strLEnd; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Request Date > "" + strLEnd + """; } break; case "G": string strItem = ds.Tables[0].Rows[0]["itemid"].ToString(); if (strItem != "0") { strClause += " AND cv_resource_requests.itemid = " + strItem; lblResults.Text += "Activity Type = "" + oRequestItem.GetItemName(Int32.Parse(strItem)) + """; } string strGStatus = ds.Tables[0].Rows[0]["gstatus"].ToString(); if (strGStatus != "0") { strClause += " AND cv_resource_requests.status = " + strGStatus; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Status = "" + oStatusLevel.Name(Int32.Parse(strGStatus)) + """; } string strGStart = ds.Tables[0].Rows[0]["gstart"].ToString(); if (strGStart != "") { strGStart = DateTime.Parse(strGStart).ToShortDateString(); strClause += " AND cv_requests.modified > " + strGStart; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Request Date < "" + strGStart + """; } string strGEnd = ds.Tables[0].Rows[0]["gend"].ToString(); if (strGEnd != "") { strGEnd = DateTime.Parse(strGEnd).ToShortDateString(); strClause += " AND cv_requests.modified < " + strGEnd; if (lblResults.Text != "") { lblResults.Text += " AND "; } lblResults.Text += "Request Date > "" + strGEnd + """; } break; case "S": break; } strClause = strClause + strApplication; if (strOr1 != "" && strOr2 != "") { strClause = strClause + " AND " + strOr1 + " AND cv_project_requests.id IS NOT NULL OR " + strClause + " AND " + strOr1 + " AND cv_service_requests.id IS NOT NULL OR " + strClause + " AND " + strOr2 + " AND cv_project_requests.id IS NOT NULL OR " + strClause + " AND " + strOr2 + " AND cv_service_requests.id IS NOT NULL"; } else { strClause = strClause + " AND cv_project_requests.id IS NOT NULL OR " + strClause + " AND cv_service_requests.id IS NOT NULL"; } ds = SqlHelper.ExecuteDataset(dsn, CommandType.Text, strSQL + strClause); DataView dv = ds.Tables[0].DefaultView; if (Request.QueryString["sort"] != null) { dv.Sort = Request.QueryString["sort"]; } rptView.DataSource = dv; rptView.DataBind(); foreach (RepeaterItem ri in rptView.Items) { Label _progress = (Label)ri.FindControl("lblProgress"); Label _status = (Label)ri.FindControl("lblStatus"); _status.Text = oStatusLevel.HTML(Int32.Parse(_status.Text)); Label _updated = (Label)ri.FindControl("lblUpdated"); Label _number = (Label)ri.FindControl("lblNumber"); if (_number.Text == "") { _number.Text = "<i>TBD...</i>"; } double dblUsed = 0.00; double dblAllocated = 0.00; if (_progress.Text.Contains("?pid=") == true) { int intProject = 0; if (Request.QueryString["sid"] != null && Request.QueryString["sid"] != "") { string strProgress = _progress.Text.Substring(0, _progress.Text.IndexOf("&")); intProject = Int32.Parse(strProgress.Substring(5)); } else { intProject = Int32.Parse(_progress.Text.Substring(5)); } _updated.Text = oProject.GetLastUpdated(intProject); DataSet dsAll = oResourceRequest.GetWorkflowProject(intProject); foreach (DataRow drAll in dsAll.Tables[0].Rows) { int intResourceWorkflow = Int32.Parse(drAll["id"].ToString()); dblAllocated += double.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated")); dblUsed += oResourceRequest.GetWorkflowUsed(intResourceWorkflow); } } else if (_progress.Text.Contains("?rid=") == true) { int intRequest = Int32.Parse(_progress.Text.Substring(5)); DataSet dsAll = oResourceRequest.GetWorkflowRequestAll(intRequest); foreach (DataRow drAll in dsAll.Tables[0].Rows) { int intResourceWorkflow = Int32.Parse(drAll["id"].ToString()); dblAllocated += double.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated")); dblUsed += oResourceRequest.GetWorkflowUsed(intResourceWorkflow); } } double dblProgress = 0.00; if (dblAllocated > 0.00) { dblProgress = (dblUsed / dblAllocated) * 100.00; } _progress.Text = oServiceRequest.GetStatusBar(dblProgress, "100", "6", true); } lblNone.Visible = (rptView.Items.Count == 0); } } }
private void LoadApplications(int _parent) { DataSet ds = oApplication.Gets(_parent, 1); foreach (DataRow dr in ds.Tables[0].Rows) { TreeNode oNode = new TreeNode(); oNode.Text = dr["name"].ToString(); oNode.ToolTip = dr["name"].ToString(); oNode.ImageUrl = "/images/folder.gif"; oNode.SelectAction = TreeNodeSelectAction.Expand; oTreeview.Nodes.Add(oNode); LoadApplications(Int32.Parse(dr["applicationid"].ToString())); LoadItems(Int32.Parse(dr["applicationid"].ToString()), oNode); TreeNode oNew = new TreeNode(); oNew.Text = " Add Item"; oNew.ToolTip = "Add Item"; oNew.ImageUrl = "/images/green_right.gif"; oNew.NavigateUrl = "javascript:Add('" + dr["applicationid"].ToString() + "','" + oApplication.GetName(Int32.Parse(dr["applicationid"].ToString())) + "');"; oNode.ChildNodes.Add(oNew); } oTreeview.ExpandDepth = 1; oTreeview.Attributes.Add("oncontextmenu", "return false;"); }
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); 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()); double dblAllocated = double.Parse(dr["allocated"].ToString()); double dblUsed = oResourceRequest.GetWorkflowUsed(intResource); DataSet dsStatus = oResourceRequest.GetStatuss(intResource); string strStatus = ""; StringBuilder sbStatuses = new StringBuilder(); bool boolChange = false; foreach (DataRow drStatus in dsStatus.Tables[0].Rows) { double dblStatus = double.Parse(drStatus["status"].ToString()); strStatus = oResourceRequest.GetStatus(dblStatus, 30, 15); if (boolChange == true) { sbStatuses.Append("<tr>"); } else { sbStatuses.Append("<tr bgcolor=\"#F6F6F6\">"); } sbStatuses.Append("<td nowrap valign=\"top\" align=\"center\">"); sbStatuses.Append(oResourceRequest.GetStatus(dblStatus, 30, 10)); sbStatuses.Append("</td>"); sbStatuses.Append("<td nowrap valign=\"top\" align=\"center\">"); sbStatuses.Append(DateTime.Parse(drStatus["modified"].ToString()).ToShortDateString()); sbStatuses.Append("</td>"); sbStatuses.Append("<td width=\"100%\" valign=\"top\">"); sbStatuses.Append(drStatus["comments"].ToString()); sbStatuses.Append("</td>"); sbStatuses.Append("</tr>"); boolChange = !boolChange; } if (sbStatuses.ToString() != "") { sbStatuses.Insert(0, "<table width=\"100%\" cellpadding=\"3\" cellspacing=\"0\" border=\"0\" style=\"border:solid 1px #CCCCCC\"><tr bgcolor=\"#EEEEEE\"><td> </td><td><b><u>Date:</u></b></td><td><b><u>Comments:</u></b></td></tr>"); sbStatuses.Append("</table>"); } double dblProgress = 0.00; if (dblAllocated > 0.00) { dblProgress = (dblUsed / dblAllocated) * 100.00; } sbSummary.Append("<tr>"); sbSummary.Append("<td><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("');\">[Details]</a></td>"); sbSummary.Append("</tr>"); sbSummary.Append("<tr>"); sbSummary.Append("<td colspan=\"6\">"); sbSummary.Append("<div id=\"div"); sbSummary.Append(intCount.ToString()); sbSummary.Append("\" style=\"display:none\">"); sbSummary.Append(sbStatuses.ToString()); 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()); }
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); 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) { intProfile = Int32.Parse(Request.Cookies["profileid"].Value); oPage = new Pages(intProfile, dsn); oUser = new Users(intProfile, dsn); oCustomized = new Customized(intProfile, dsn); oVariable = new Variables(intEnvironment); oApplication = new Applications(intProfile, dsn); oFunction = new Functions(0, dsn, intEnvironment); string strNavigation = ""; 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); } //Menus 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); Tab oTab = new Tab(hdnType.ClientID, intMenuTab, "divMenu1", true, false); oTab.AddTab(""" + oApplication.GetName(intApplication) + "" Documents", ""); oTab.AddTab("Documents Shared by Other Departments", ""); strMenuTab1 = oTab.GetTabs(); //End Menus lblTitle.Text = oPage.Get(intPage, "title"); strRedirect = oPage.GetFullLink(intPage); if (lblCurrent.Text == "") { lblCurrent.Text = oVariable.DocumentsFolder() + "department\\" + intApplication.ToString(); if (!Directory.Exists(lblCurrent.Text)) { DirectoryInfo drinfo = new DirectoryInfo(lblCurrent.Text); drinfo.Create(); drinfo.LastAccessTime = DateTime.Now; drinfo.LastWriteTime = DateTime.Now; } } strHome = lblCurrent.Text; strDirectory = strHome; if (strFolder == string.Empty) { strFolder = "\\"; } if (!Page.IsPostBack) { if (Request.QueryString["folder"] != null && Request.QueryString["folder"] != "") { string strFolderTemp = Request.QueryString["folder"]; if (!strFolderTemp.StartsWith("\\")) { strFolderTemp = "\\" + strFolderTemp; } if (Directory.Exists(strHome + strFolderTemp) == true) { strFolder = strFolderTemp; strDirectory = strHome + strFolderTemp; } } dir_info = new DirectoryInfo(strDirectory); if (dir_info.Parent.Parent.Name != "documents") { string strNav = strFolder; while (strNav != "") { strNavigation = " / <a class=\"breadcrumb\" href=\"" + strRedirect + "?folder=" + Server.UrlEncode(strNav) + "\">" + strNav.Substring(strNav.LastIndexOf("\\") + 1) + "</a>" + strNavigation; strNav = strNav.Substring(0, strNav.LastIndexOf("\\")); } strRedirect = oPage.GetFullLink(intPage) + "?folder=" + strFolder.Substring(0, strFolder.LastIndexOf("\\")); strFolder = "<a href=\"" + strRedirect + "\">" + strFolder.Substring(0, strFolder.LastIndexOf("\\")) + "</a>" + strFolder.Substring(strFolder.LastIndexOf("\\")); } DataSet ds = oCustomized.GetDocumentRepositoryApplication(intApplication, strDirectory); DataView dv = ds.Tables[0].DefaultView; if (Request.QueryString["sort"] != null && Request.QueryString["sort"] != "") { if (Request.QueryString["sort"].ToLower().Contains("desc")) { dv.Sort = "type desc," + Request.QueryString["sort"]; } else { dv.Sort = "type," + Request.QueryString["sort"]; } } else { dv.Sort = "type desc"; } rptDocs.DataSource = dv; rptDocs.DataBind(); lblNoDocs.Visible = rptDocs.Items.Count == 0; DataSet dsOthers = oCustomized.GetDocumentRepositorySharesByApplication(intApplication); dsOthers.Relations.Add("relationship", dsOthers.Tables[0].Columns["applicationid"], dsOthers.Tables[1].Columns["applicationid"], false); DataView dvOthers = dsOthers.Tables[0].DefaultView; rptOthers.DataSource = dvOthers; rptOthers.DataBind(); lblNoShares.Visible = rptOthers.Items.Count == 0; foreach (RepeaterItem ri in rptDocs.Items) { LinkButton btnName = (LinkButton)ri.FindControl("btnName"); Label lblType = (Label)ri.FindControl("lblType"); Label lblDeleted = (Label)ri.FindControl("lblDeleted"); Label lblId = (Label)ri.FindControl("lblId"); Label lblSize = (Label)ri.FindControl("lblSize"); ImageButton imgDelete = (ImageButton)ri.FindControl("imgDelete"); ImageButton imgRename = (ImageButton)ri.FindControl("imgRename"); ImageButton imgShare = (ImageButton)ri.FindControl("imgShare"); imgRename.Attributes.Add("onclick", "return OpenWindow('DOCUMENT_REPOSITORY_RENAME','?id=" + lblId.Text + "');"); imgShare.Attributes.Add("onclick", "return OpenWindow('DOCUMENT_REPOSITORY_SHARE','?id=" + imgShare.CommandArgument + "');"); imgDelete.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this " + (lblType.Text.ToLower() != "folder" ? "File" : lblType.Text) + " ?');"); if (!FileExists(btnName.CommandArgument, lblType.Text)) { btnName.Text = btnName.Text + " (Not Found)"; btnName.Enabled = false; imgRename.Visible = false; imgShare.Visible = false; } else { if (lblType.Text.ToLower() != "folder") { btnName.Text = "<a href=\"" + oVariable.URL() + "/frame/document_repository_permissions.aspx?docid=" + oFunction.encryptQueryString(lblId.Text) + "\" target=\"_blank\">" + btnName.Text + "</a>"; //btnName.Text = "<a href=\"" + btnName.CommandArgument + "\" target=\"_blank\">" + btnName.Text + "</a>"; int intSize = Int32.Parse(lblSize.Text); decimal decSize = intSize / 1024; if (decSize > 1024) { lblSize.Text = (Decimal.Round((decSize / 1024), 1)).ToString() + " MB"; } else { lblSize.Text = (Decimal.Round(decSize, 0)).ToString() + " KB"; } } else { imgShare.Visible = false; } } } foreach (RepeaterItem riOther in rptOthers.Items) { Repeater rptShared = (Repeater)riOther.FindControl("rptShared"); foreach (RepeaterItem ri in rptShared.Items) { LinkButton btnName = (LinkButton)ri.FindControl("btnName"); Label lblType = (Label)ri.FindControl("lblType"); Label lblId = (Label)ri.FindControl("lblId"); Label lblOwnerId = (Label)ri.FindControl("lblOwnerId"); Label lblDeleted = (Label)ri.FindControl("lblDeleted"); Label lblSize = (Label)ri.FindControl("lblSize"); if (!FileExists(btnName.CommandArgument, lblType.Text)) { btnName.Text = btnName.Text + " (Not Found)"; btnName.Enabled = false; } else { if (lblType.Text.ToLower() != "folder") { btnName.Text = "<a href=\"" + oVariable.URL() + "/frame/document_repository_permissions.aspx?docid=" + oFunction.encryptQueryString(lblId.Text) + "\" target=\"_blank\">" + btnName.Text + "</a>"; int intSize = Int32.Parse(lblSize.Text); decimal decSize = intSize / 1024; if (decSize > 1024) { lblSize.Text = (Decimal.Round((decSize / 1024), 1)).ToString() + " MB"; } else { lblSize.Text = (Decimal.Round(decSize, 0)).ToString() + " KB"; } } } } } lblTitle.Text = oPage.Get(intPage, "title"); lblFolder.Text = strFolder != "" ? "<a class=\"breadcrumb\" href=\"" + oPage.GetFullLink(intPage) + "\">Home</a>" + strNavigation : "<a class=\"breadcrumb\" href=\"" + oPage.GetFullLink(intPage) + "\">Home</a>"; hdnDir.Value = dir_info.FullName; btnCreate.Attributes.Add("onclick", "return ValidateText('" + txtDirectory.ClientID + "','Please enter a name for the new directory') && ValidateDirName('" + txtDirectory.ClientID + "') && ProcessButton(this);"); btnUpload.Attributes.Add("onclick", "return ProcessButton(this);"); txtDirectory.Attributes.Add("onkeydown", "if(event.which || event.keyCode){if ((event.which == 13) || (event.keyCode == 13)) {document.getElementById('" + btnCreate.ClientID + "').click();return false;}} else {return true}; "); } }