public StatusCountBO GetApprPending(int UserID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_PROJ_SHA_MY_PEND"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("ASSIGNTOID_", UserID); cmd.Parameters.Add("SP_RECORDSET", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); StatusCountBO StatusCountBO = null; StatusCountBO = new StatusCountBO(); while (dr.Read()) { // ID,CLARIFYREQUEST,CLARIFYRESPONSE,CLARIFYSTATUS,CREATEDBY,CREATEDDATE,UPDATEDBY,UPDATEDDATE,ISDELETED,TRACKERHEADERID,HHID, // PAPNAME,REQ.USERNAME AS REQUESTER,RES.USERNAME AS RESPONDENT if (!dr.IsDBNull(dr.GetOrdinal("COUNTS"))) { StatusCountBO.PendingApprovals = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("COUNTS"))); } } dr.Close(); return(StatusCountBO); }
protected void Page_Load(object sender, EventArgs e) { if (Session["userName"] != null) { userNameLabel.Text = "Welcome " + Session["userName"].ToString(); StatusCountBLL StatusCountBLL = new StatusCountBLL(); StatusCountBO StatusCountBOA = new StatusCountBO(); StatusCountBOA = StatusCountBLL.GetApprPending(Convert.ToInt32(Session["USER_ID"])); StatusCountBLL StatusCountBLLC = new StatusCountBLL(); StatusCountBO StatusCountBOC = new StatusCountBO(); StatusCountBOC = StatusCountBLLC.GetClarifyPending(Convert.ToInt32(Session["USER_ID"])); int totalPending = StatusCountBOA.PendingApprovals + StatusCountBOC.PendingClarify; NavigationMenu.Items[7].Text = "<span style='color: Orange; font-weight: bold;'> Tasks" + " " + "(" + totalPending + ")" + " </span>"; UserBLL UserBLL = new UserBLL(); UserBO UserBO = new UserBO(); UserBO = UserBLL.GetUserById(Convert.ToInt32(Session["USER_ID"])); string userName = UserBO.UserName; bool sysAccount = userName.Contains("wis."); if (sysAccount == true) { NavigationMenu.Items[7].ChildItems.Remove(NavigationMenu.Items[7].ChildItems[1]); NavigationMenu.Items[7].ChildItems.Remove(NavigationMenu.Items[7].ChildItems[1]); NavigationMenu.Items[7].ChildItems.Remove(NavigationMenu.Items[7].ChildItems[1]); //NavigationMenu.Items[7].ChildItems.Remove(NavigationMenu.Items[7].ChildItems[1]); NavigationMenu.Items[7].ChildItems[0].Text = "Approvals" + " " + "(" + StatusCountBOA.PendingApprovals + ")" + " "; } else { NavigationMenu.Items[7].ChildItems.Remove(NavigationMenu.Items[7].ChildItems[0]); NavigationMenu.Items[7].ChildItems.Remove(NavigationMenu.Items[7].ChildItems[2]); NavigationMenu.Items[7].ChildItems.Remove(NavigationMenu.Items[7].ChildItems[2]); NavigationMenu.Items[7].ChildItems[0].Text = "Approvals"; NavigationMenu.Items[7].ChildItems[0].Text = "Approvals" + " " + "(" + StatusCountBOA.PendingApprovals + ")" + " "; NavigationMenu.Items[7].ChildItems[1].Text = "Clarifications" + " " + "(" + StatusCountBOC.PendingClarify + ")" + " "; int UserID = Convert.ToInt32(Session["USER_ID"]); string OpenResponse = string.Format("javascript:OpenResponse({0});", UserID, "Readonly"); NavigationMenu.Items[7].ChildItems[1].NavigateUrl = OpenResponse; } } else { Response.Redirect("~/Login.aspx"); } CheckPrivilege(); /* * System.Web.HttpBrowserCapabilities browser = Request.Browser; * //A link tag to external CSS file * HtmlLink linkCss = new HtmlLink(); * if (browser.Browser == "IE" || browser.Browser == "Firefox" || browser.Browser == "Google Chorme") * { * //Defining attributes and values of the link tag * linkCss.Attributes.Add("href", "Styles/MenuCSSForIE.css"); * } * if (browser.Browser == "Safari" || browser.Browser == "Chrome" ) * { * //Defining attributes and values of the link tag * linkCss.Attributes.Add("href", "Styles/Site.css"); * } * linkCss.Attributes.Add("type", "text/css"); * linkCss.Attributes.Add("rel", "Stylesheet"); * //Add HtmlLink instance to the header of the current page * Page.Header.Controls.Add(linkCss); */ }