protected void Page_Load(object sender, EventArgs e) { AuthenticateUser(); intProfile = Int32.Parse(Request.Cookies["profileid"].Value); oPage = new Pages(intProfile, dsn); oUser = new Users(intProfile, dsn); oTPM = new TPM(intProfile, dsn, intEnvironment); oCustomized = new Customized(intProfile, dsn); oCost = new Costs(intProfile, dsn); oVariable = new Variables(intEnvironment); if (Request.QueryString["status"] != "" && Request.QueryString["status"] != null) { strStatus = Request.QueryString["status"]; } if (Request.QueryString["id"] != "" && Request.QueryString["id"] != null) { intId = Int32.Parse(Request.QueryString["id"]); } if (Request.QueryString["work"] != "" && Request.QueryString["work"] != null) { intWorking = Int32.Parse(Request.QueryString["work"]); } if (Request.QueryString["exec"] != "" && Request.QueryString["exec"] != null) { intExecutive = Int32.Parse(Request.QueryString["exec"]); } if (!IsPostBack) { ds = oTPM.GetPCR(intId); int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString()); int intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString()); int intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString()); int intParent = Int32.Parse(ds.Tables[0].Rows[0]["id"].ToString()); strPath = ds.Tables[0].Rows[0]["path"].ToString(); dsResource = oCustomized.GetTPM(intRequest, intItem, intNumber); string strCosts = dsResource.Tables[0].Rows.Count > 0 ? dsResource.Tables[0].Rows[0]["costs"].ToString() : "No Cost Center(s)"; string[] strCost; char[] strSplit = { '&' }; strCost = strCosts.Split(strSplit); string strText = strCosts == "" ? "None" : ""; foreach (string str in strCost) { if (str != "") { strText += oCost.GetName(Int32.Parse(str)) + ";"; } } chkScope.Checked = ds.Tables[0].Rows[0]["scope"].ToString() == "1" ? true : false; chkSchedule.Checked = ds.Tables[0].Rows[0]["s"].ToString() == "1" ? true : false; chkFinancial.Checked = ds.Tables[0].Rows[0]["f"].ToString() == "1" ? true : false; divScope.Style["display"] = chkScope.Checked ? "inline" : "none"; divSchedule.Style["display"] = chkSchedule.Checked ? "inline" : "none"; divFinancial.Style["display"] = chkFinancial.Checked ? "inline" : "none"; txtPCRScheduleDS.Text = ds.Tables[0].Rows[0]["sds"].ToString() != "" ? DateTime.Parse(ds.Tables[0].Rows[0]["sds"].ToString()).ToShortDateString() : ""; txtPCRScheduleDE.Text = ds.Tables[0].Rows[0]["sde"].ToString() != "" ? DateTime.Parse(ds.Tables[0].Rows[0]["sde"].ToString()).ToShortDateString() : ""; txtPCRSchedulePS.Text = ds.Tables[0].Rows[0]["sps"].ToString() != "" ? DateTime.Parse(ds.Tables[0].Rows[0]["sps"].ToString()).ToShortDateString() : ""; txtPCRSchedulePE.Text = ds.Tables[0].Rows[0]["spe"].ToString() != "" ? DateTime.Parse(ds.Tables[0].Rows[0]["spe"].ToString()).ToShortDateString() : ""; txtPCRScheduleES.Text = ds.Tables[0].Rows[0]["ses"].ToString() != "" ? DateTime.Parse(ds.Tables[0].Rows[0]["ses"].ToString()).ToShortDateString() : ""; txtPCRScheduleEE.Text = ds.Tables[0].Rows[0]["see"].ToString() != "" ? DateTime.Parse(ds.Tables[0].Rows[0]["see"].ToString()).ToShortDateString() : ""; txtPCRScheduleCS.Text = ds.Tables[0].Rows[0]["scs"].ToString() != "" ? DateTime.Parse(ds.Tables[0].Rows[0]["scs"].ToString()).ToShortDateString() : ""; txtPCRScheduleCE.Text = ds.Tables[0].Rows[0]["sce"].ToString() != "" ? DateTime.Parse(ds.Tables[0].Rows[0]["sce"].ToString()).ToShortDateString() : ""; chkPCRScheduleD.Checked = txtPCRScheduleDS.Text != "" || txtPCRScheduleDE.Text != ""; chkPCRScheduleP.Checked = txtPCRSchedulePS.Text != "" || txtPCRSchedulePE.Text != ""; chkPCRScheduleE.Checked = txtPCRScheduleES.Text != "" || txtPCRScheduleEE.Text != ""; chkPCRScheduleC.Checked = txtPCRScheduleCS.Text != "" || txtPCRScheduleCE.Text != ""; if (dsResource.Tables[0].Rows[0]["appsd"] == DBNull.Value || dsResource.Tables[0].Rows[0]["apped"] == DBNull.Value) { chkPCRScheduleD.Enabled = false; lblPCRScheduleD.Text = "N / A"; } else { lblPCRScheduleD.Text = GetDate(dsResource.Tables[0].Rows[0]["appsd"].ToString()) + " - " + GetDate(dsResource.Tables[0].Rows[0]["apped"].ToString()); } if (dsResource.Tables[0].Rows[0]["appsp"] == DBNull.Value || dsResource.Tables[0].Rows[0]["appep"] == DBNull.Value) { chkPCRScheduleP.Enabled = false; lblPCRScheduleP.Text = "N / A"; } else { lblPCRScheduleP.Text = GetDate(dsResource.Tables[0].Rows[0]["appsp"].ToString()) + " - " + GetDate(dsResource.Tables[0].Rows[0]["appep"].ToString()); } if (dsResource.Tables[0].Rows[0]["appse"] == DBNull.Value || dsResource.Tables[0].Rows[0]["appee"] == DBNull.Value) { chkPCRScheduleE.Enabled = false; lblPCRScheduleE.Text = "N / A"; } else { lblPCRScheduleE.Text = GetDate(dsResource.Tables[0].Rows[0]["appse"].ToString()) + " - " + GetDate(dsResource.Tables[0].Rows[0]["appee"].ToString()); } if (dsResource.Tables[0].Rows[0]["appsc"] == DBNull.Value || dsResource.Tables[0].Rows[0]["appec"] == DBNull.Value) { chkPCRScheduleC.Enabled = false; lblPCRScheduleC.Text = "N / A"; } else { lblPCRScheduleC.Text = GetDate(dsResource.Tables[0].Rows[0]["appsc"].ToString()) + " - " + GetDate(dsResource.Tables[0].Rows[0]["appec"].ToString()); } double dblAppDI = GetFloat(dsResource.Tables[0].Rows[0]["appid"].ToString()); double dblAppDE = GetFloat(dsResource.Tables[0].Rows[0]["appexd"].ToString()); double dblAppDH = GetFloat(dsResource.Tables[0].Rows[0]["apphd"].ToString()); double dblAppD = dblAppDI + dblAppDE + dblAppDH; lblPCRFinancialD.Text = "$" + dblAppD.ToString("N"); double dblAppPI = GetFloat(dsResource.Tables[0].Rows[0]["appip"].ToString()); double dblAppPE = GetFloat(dsResource.Tables[0].Rows[0]["appexp"].ToString()); double dblAppPH = GetFloat(dsResource.Tables[0].Rows[0]["apphp"].ToString()); double dblAppP = dblAppPI + dblAppPE + dblAppPH; lblPCRFinancialP.Text = "$" + dblAppP.ToString("N"); double dblAppEI = GetFloat(dsResource.Tables[0].Rows[0]["appie"].ToString()); double dblAppEE = GetFloat(dsResource.Tables[0].Rows[0]["appexe"].ToString()); double dblAppEH = GetFloat(dsResource.Tables[0].Rows[0]["apphe"].ToString()); double dblAppE = dblAppEI + dblAppEE + dblAppEH; lblPCRFinancialE.Text = "$" + dblAppE.ToString("N"); double dblAppCI = GetFloat(dsResource.Tables[0].Rows[0]["appic"].ToString()); double dblAppCE = GetFloat(dsResource.Tables[0].Rows[0]["appexc"].ToString()); double dblAppCH = GetFloat(dsResource.Tables[0].Rows[0]["apphc"].ToString()); double dblAppC = dblAppCI + dblAppCE + dblAppCH; lblPCRFinancialC.Text = "$" + dblAppC.ToString("N"); txtPCRFinancialD.Text = ds.Tables[0].Rows[0]["fd"].ToString(); txtPCRFinancialP.Text = ds.Tables[0].Rows[0]["fp"].ToString(); txtPCRFinancialE.Text = ds.Tables[0].Rows[0]["fe"].ToString(); txtPCRFinancialC.Text = ds.Tables[0].Rows[0]["fc"].ToString(); chkPCRFinancialD.Checked = txtPCRFinancialD.Text != "0"; chkPCRFinancialP.Checked = txtPCRFinancialP.Text != "0"; chkPCRFinancialE.Checked = txtPCRFinancialE.Text != "0"; chkPCRFinancialC.Checked = txtPCRFinancialC.Text != "0"; chkReason.Checked = ds.Tables[0].Rows[0]["reasons"].ToString() != ""; divReason.Style["display"] = chkReason.Checked ? "inline" : "none"; string[] strReasons = ds.Tables[0].Rows[0]["reasons"].ToString().Split(';'); foreach (string str in strReasons) { for (int ii = 0; ii < chkPCRReason.Items.Count; ii++) { if (chkPCRReason.Items[ii].Value == str) { chkPCRReason.Items[ii].Selected = true; break; } } } txtScopeComments.Text = ds.Tables[0].Rows[0]["scopecomments"].ToString(); txtScheduleComments.Text = ds.Tables[0].Rows[0]["schcomments"].ToString(); txtFinancialComments.Text = ds.Tables[0].Rows[0]["fincomments"].ToString(); int intStatus = Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString()); if (intStatus == 1) { strStatus = "Approved"; } else if (intStatus == -1) { strStatus = "Denied"; } hdnStatus.Value = strStatus.ToUpper(); } chkScope.Attributes.Add("onclick", "ShowHideDivCheck('" + divScope.ClientID + "',this);"); chkSchedule.Attributes.Add("onclick", "ShowHideDivCheck('" + divSchedule.ClientID + "',this);"); chkFinancial.Attributes.Add("onclick", "ShowHideDivCheck('" + divFinancial.ClientID + "',this);"); chkReason.Attributes.Add("onclick", "ShowHideDivCheck('" + divReason.ClientID + "',this);"); btnUpdate.Attributes.Add("onclick", "return ValidateStatus('" + hdnStatus.Value + "') && ValidatePCR('" + chkScope.ClientID + "'" + ",'" + chkSchedule.ClientID + "'" + ",'" + chkPCRScheduleD.ClientID + "'" + ",'" + txtPCRScheduleDS.ClientID + "'" + ",'" + txtPCRScheduleDE.ClientID + "'" + ",'" + chkPCRScheduleP.ClientID + "'" + ",'" + txtPCRSchedulePS.ClientID + "'" + ",'" + txtPCRSchedulePE.ClientID + "'" + ",'" + chkPCRScheduleE.ClientID + "'" + ",'" + txtPCRScheduleES.ClientID + "'" + ",'" + txtPCRScheduleEE.ClientID + "'" + ",'" + chkPCRScheduleC.ClientID + "'" + ",'" + txtPCRScheduleCS.ClientID + "'" + ",'" + txtPCRScheduleCE.ClientID + "'" + ",'" + chkFinancial.ClientID + "'" + ",'" + chkPCRFinancialD.ClientID + "'" + ",'" + txtPCRFinancialD.ClientID + "'" + ",'" + chkPCRFinancialP.ClientID + "'" + ",'" + txtPCRFinancialP.ClientID + "'" + ",'" + chkPCRFinancialE.ClientID + "'" + ",'" + txtPCRFinancialE.ClientID + "'" + ",'" + chkPCRFinancialC.ClientID + "'" + ",'" + txtPCRFinancialC.ClientID + "'" + ");"); imgPCRScheduleCE.Attributes.Add("onclick", "return OpenCalendar('" + txtPCRScheduleCE.ClientID + "');"); imgPCRScheduleCS.Attributes.Add("onclick", "return OpenCalendar('" + txtPCRScheduleCS.ClientID + "');"); imgPCRScheduleDE.Attributes.Add("onclick", "return OpenCalendar('" + txtPCRScheduleDE.ClientID + "');"); imgPCRScheduleDS.Attributes.Add("onclick", "return OpenCalendar('" + txtPCRScheduleDS.ClientID + "');"); imgPCRScheduleEE.Attributes.Add("onclick", "return OpenCalendar('" + txtPCRScheduleEE.ClientID + "');"); imgPCRScheduleES.Attributes.Add("onclick", "return OpenCalendar('" + txtPCRScheduleES.ClientID + "');"); imgPCRSchedulePE.Attributes.Add("onclick", "return OpenCalendar('" + txtPCRSchedulePE.ClientID + "');"); imgPCRSchedulePS.Attributes.Add("onclick", "return OpenCalendar('" + txtPCRSchedulePS.ClientID + "');"); imgPCRFinancialC.Attributes.Add("onclick", "return OpenCalculator('" + txtPCRFinancialC.ClientID + "');"); imgPCRFinancialD.Attributes.Add("onclick", "return OpenCalculator('" + txtPCRFinancialD.ClientID + "');"); imgPCRFinancialE.Attributes.Add("onclick", "return OpenCalculator('" + txtPCRFinancialE.ClientID + "');"); imgPCRFinancialP.Attributes.Add("onclick", "return OpenCalculator('" + txtPCRFinancialP.ClientID + "');"); }