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);
*/
}
