public void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { NotifyBounces(sender, e); accountName.Text = string.Format("Hello, {0}!", Renderer.Render(SessionManager.Account.Name)); accountImage.Src = string.Format("AccountPictureThumbnail.aspx?id={0}", SessionManager.Account.PictureId); groupsView.AccountId = SessionManager.AccountId; friendsView.AccountId = SessionManager.AccountId; broadcastView.AccountId = SessionManager.AccountId; TransitAccountNumbers numbers = SessionManager.GetInstance <TransitAccountNumbers, int>( SessionManager.AccountId, SessionManager.AccountService.GetAccountNumbersByAccountId); accountFirstDegree.Visible = (numbers.FirstDegreeCount > 0); accountFirstDegree.Text = string.Format("{0} friend{1} in your personal network", numbers.FirstDegreeCount, numbers.FirstDegreeCount != 1 ? "s" : string.Empty); accountSecondDegree.Visible = (numbers.SecondDegreeCount > 0); accountSecondDegree.Text = string.Format("{0} friend{1} in your extended network", numbers.SecondDegreeCount, numbers.SecondDegreeCount != 1 ? "s" : string.Empty); accountAllDegrees.Text = string.Format("{0} {1} to make new friends with", numbers.NewCount > 0 ? numbers.NewCount.ToString() : "no", numbers.NewCount != 1 ? "people" : "person"); accountDiscussionThreads.Visible = (numbers.PostsCount > 0); accountDiscussionThreads.Text = string.Format("{0} discussion post{1}", numbers.PostsCount, numbers.PostsCount != 1 ? "s" : string.Empty); } }
public TransitAccountNumbers GetAccountNumbersByAccountId(string ticket, int id) { using (SnCore.Data.Hibernate.Session.OpenConnection()) { TransitAccountNumbers t_result = new TransitAccountNumbers(); ISession session = SnCore.Data.Hibernate.Session.Current; ManagedSecurityContext sec = new ManagedSecurityContext(session, ticket); ManagedAccount acct = new ManagedAccount(session, id); // second degree count t_result.SecondDegreeCount = acct.GetNDegreeCount(sec, 2); // first degree count t_result.FirstDegreeCount = session.CreateQuery( string.Format("SELECT COUNT(*) FROM AccountFriend AccountFriend" + " WHERE (AccountFriend.Account.Id = {0} OR AccountFriend.Keen.Id = {0})", id)).UniqueResult<int>(); // all accounts count t_result.AllCount = session.CreateQuery( "SELECT COUNT(*) FROM Account Account").UniqueResult<int>(); // discussion posts count DiscussionQueryOptions qopt = new DiscussionQueryOptions(); qopt.AccountId = id; t_result.PostsCount = session.CreateQuery( string.Format("SELECT COUNT(*) FROM DiscussionPost DiscussionPost {0}", qopt.CountQuery)).UniqueResult<int>(); return t_result; } }