Index.aspx.cs

using System;
using System.Collections.Generic;
using System.Data.Linq;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Index : System.Web.UI.Page
{
	protected void Page_Load(object sender, EventArgs e)
	{
		if (IsPostBack)
			return;

		// ===== DEBUG DEBUG DEBUG =====
		//Session["member"] = GetMemberById(2);
		// =============================
        
		Page.Title = "Forum Index";

		ListViewCategories.DataSource = new BLForum().GetParentForums();
		ListViewCategories.DataBind();

		Layout masterPage = Master as Layout;
		masterPage.GenerateBreadCrumb(null);

		LiteralTotalPosts.Text = new BLPost().CountAll().ToString();

		BLMember blMember = new BLMember();
		LiteralTotalMembers.Text = blMember.CountAll().ToString();
		LiteralNewestMember.Text = blMember.GetNewestMember().Name;
	}

	protected Member GetMemberById(int id)
	{
		AspLinqDataContext dc = new AspLinqDataContext();
		return (from Member in dc.Members where Member.Id == id select Member).SingleOrDefault();
	}

	protected void ListViewCategories_ItemDataBound(object sender, ListViewItemEventArgs e)
	{
		ListView list = (ListView)e.Item.FindControl("ListViewForums");

		list.DataSource = ((Forum)e.Item.DataItem).Children;
		list.DataBind();
	}

	protected void ListViewForums_ItemDataBound(object sender, ListViewItemEventArgs e)
	{
		Forum forum = e.Item.DataItem as Forum;
		Panel panelSubforums = e.Item.FindControl("PanelSubforums") as Panel;

		panelSubforums.Visible = forum.Children.Count > 0;

		if (panelSubforums.Visible)
		{
			BulletedList listSubforums = e.Item.FindControl("BulletedListSubforums") as BulletedList;

			foreach (Forum child in forum.Children)
			{
				listSubforums.Items.Add(new ListItem(child.Name, "ViewForum.aspx?id=" + child.Id));
			}
		}

		if (forum.Topics.Count > 0)
		{
			BLForum blForum = new BLForum();

			Literal topicCount = (Literal)e.Item.FindControl("LiteralTopicCount");
			//topicCount.Text = forum.Topics.Count.ToString();
			topicCount.Text = blForum.CountAllTopics(forum).ToString();

			Literal postCount = (Literal)e.Item.FindControl("LiteralPostCount");
			//postCount.Text = (forum.Topics.Sum(topic => topic.Posts.Count)).ToString();
			postCount.Text = blForum.CountAllPosts(forum).ToString();

			HyperLink hyperLinkLastPost = (HyperLink)e.Item.FindControl("HyperLinkLastPost");
			Label labelLastPostInformation = (Label)e.Item.FindControl("LabelLastPostInformation");

			Topic lastTopic = forum.Topics.OrderByDescending(t => t.LaatstePost.CreatedDate).First();

			hyperLinkLastPost.Text = lastTopic.Title;
			hyperLinkLastPost.NavigateUrl = "~/ViewTopic.aspx?id=" + lastTopic.Id.ToString();
			labelLastPostInformation.Text = "By " + lastTopic.LaatstePost.Member.Name + ", " + lastTopic.LaatstePost.CreatedDate.ToShortDateString();
		}
	}
}