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