public void bindInboxMessages() { if (Session["username"] != null && Session["operator_id"] != null && Session["category"] != null) { username = Convert.ToString(Session["username"]); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); } cls_BLL_messenger ob = new cls_BLL_messenger(); DataTable dt = new DataTable(); dt = ob.fillinbox(username, ViewState["cityid"].ToString().TrimStart(',').TrimEnd(','), ViewState["UserLevel"].ToString(), ViewState["state"].ToString(), "", ""); if (dt == null) { Response.Redirect("~/ErrorPage.aspx"); return; } int Countmsg = 0; if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { String Readby = Session["username"].ToString() + ","; if (dr["readby"].ToString().Contains(Readby)) { } else { Countmsg++; } } } else { } dt.Dispose(); lblinboxcount.Text = Countmsg.ToString(); }
protected void Page_Load(object sender, EventArgs e) { incrementDate(); String sid = Session.SessionID; Master.PageHeading = "Home"; if (Session["username"] != null && Session["RPAuthToken"] != null && Request.Cookies["AuthToken"] != null) { if (!Session["RPAuthToken"].ToString().Equals(Request.Cookies["AuthToken"].Value)) { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } else { username = Convert.ToString(Session["username"]); Session["RightsKey"] = "Y"; hdnlco.Value = username; } } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } if (!IsPostBack) { Session["pagenos"] = "1"; cls_BLL_messenger obj = new cls_BLL_messenger(); String City = ""; String UserLevel = ""; String state = ""; string cityuser = ""; obj.GetCity(Session["username"].ToString(), out City, out state, out UserLevel, out cityuser); ViewState["cityid"] = City; ViewState["UserLevel"] = UserLevel; ViewState["state"] = state; ViewState["cityuser"] = cityuser; bindInboxMessages(); } }