/// <summary> /// Gets the number of new friend requests for a Member /// </summary> /// <param name="MemberID">The MemberID of the Member</param> /// <returns>Returns a FriendStat object with number of requests populated</returns> public static FriendStats GetNumberOfNewFriendRequests(int MemberID) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("HG_GetNumberOfNewFriendRequests"); db.AddInParameter(dbCommand, "MemberID", DbType.Int32, MemberID); FriendStats stats = new FriendStats(); //execute the stored procedure using (IDataReader dr = db.ExecuteReader(dbCommand)) { if (dr.Read()) { stats.WebFriendRequest = (int)dr[0]; stats.ProximityTags = (int)dr[1]; stats.AllRequests = (int)dr[2]; } dr.Close(); } // Create the object array from the datareader return(stats); }
protected void Page_Load(object sender, EventArgs e) { AjaxPro.Utility.RegisterTypeForAjax(typeof(FriendPage)); //string strListerType = Request.Params["t"]; string strListerType = "px"; string strSearchkeywords = Request.Params["s"]; string strPager = Request.Params["p"]; // determine if a page reqest has been requested otherwise default to page 1 int PageTo = 1; Int32.TryParse(strPager, out PageTo); PageTo = (PageTo == 0) ? 1 : PageTo; MemberOrderBy OrderBY = SetCurrentTab(); if (strListerType != null) { if (strListerType == "blocked") { List<Member> blocked = Member.GetAllBlockedFriendsByMemberIDForPageLister(member.MemberID); NumberOfFriends = blocked.Count.ToString(); TabContents tabContents = GenerateBlockedLister(blocked, 1, PageTo, true, OrderBY); DefaultHTMLLister = tabContents.HTML; ShowStats = false; PageHeaderTitle = "<h2>Blocked Friends</h2>"; } else if (strListerType == "search") { ShowStats = false; PageHeaderTitle = "<h2>Search</h2>"; } else if (strListerType == "px") { ShowStats = false; PageHeaderTitle = "<h2>Proximity Tags</h2>"; List<Member> friends = GetProximityTag(member.MemberID); TabContents tabContents = GenerateProximityLister(friends, 1, PageTo, true, OrderBY); DefaultHTMLLister = tabContents.HTML; DefaultHTMLPager = string.Empty; } } else if (strSearchkeywords != null) { //Search(strSearchkeywords, 1); //ShowStats = false; //List<Member> friends = member.friend } else { List<Member> friends = Member.GetAllFriendsByMemberIDForPageLister(member.MemberID); NumberOfFriends = friends.Count.ToString(); TabContents tabContents = GenerateLister(friends, TabType, PageTo, true, OrderBY); DefaultHTMLLister = tabContents.HTML; ShowStats = true; PageHeaderTitle = "<h2>My Friends</h2>"; } friendStats = FriendRequest.GetNumberOfNewFriendRequests(member.MemberID); if (friendStats.AllRequests == 0) { ShowStats = false; } if (!IsPostBack) { //drpCopuntries.Items.Insert(0, new ListItem("All Countries", "-1")); //register the return key default submit button //txtSearch.Attributes.Add("onKeyPress", "javascript:if (event.keyCode == 13) __doPostBack('" + btnSearch.UniqueID + "','')"); } }
/// <summary> /// Gets the number of new friend requests for a Member /// </summary> /// <param name="MemberID">The MemberID of the Member</param> /// <returns>Returns a FriendStat object with number of requests populated</returns> public static FriendStats GetNumberOfNewFriendRequests(int MemberID) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("HG_GetNumberOfNewFriendRequests"); db.AddInParameter(dbCommand, "MemberID", DbType.Int32, MemberID); FriendStats stats = new FriendStats(); //execute the stored procedure using (IDataReader dr = db.ExecuteReader(dbCommand)) { if (dr.Read()) { stats.WebFriendRequest = (int)dr[0]; stats.ProximityTags = (int)dr[1]; stats.AllRequests = (int)dr[2]; } dr.Close(); } // Create the object array from the datareader return stats; }