protected void GridViewTopics_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
Forum forum = ForumFromQueryString();
GridViewTopics.PageIndex = e.NewPageIndex;
GridViewTopics.DataSource = forum.Topics.OrderByDescending(topic => topic.IsPinned).ThenByDescending(topic => topic.LaatstePost.CreatedDate).ToList();
GridViewTopics.DataBind();
}
protected void ImageButtonTopicsAdd_Click(object sender, ImageClickEventArgs e)
{
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString);
SqlCommand sqlCmd = new SqlCommand("sp_supportTopicAdd", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@UserType", SqlDbType.Int).Value = Convert.ToInt32(DropDownListTopicsUserType.SelectedValue);
sqlCmd.Parameters.Add("@Sort", SqlDbType.Int).Value = Convert.ToInt32(TextBoxTopicsSort.Text);
sqlCmd.Parameters.Add("@Topic", SqlDbType.NVarChar).Value = TextBoxTopicsTopic.Text;
sqlCmd.Parameters.Add("@Descriptions", SqlDbType.NVarChar).Value = TextBoxTopicsDescriptions.Text;
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
GridViewTopics.DataBind();
sqlCmd.Dispose();
sqlConn.Dispose();
LabelAddTopicMessage.Visible = true;
LabelAddTopicMessage.Text = "عنوان با مشخصات وارد شده اضافه گردید.";
LabelAddTopicMessage.CssClass = "SuccessMessage";
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
Forum forum = ForumFromQueryString();
(Master as Layout).GenerateBreadCrumb(forum);
Page.Title = forum.Name;
LiteralForumNaam.Text = forum.Name;
LiteralForumBeschrijving.Text = forum.Description != null ? forum.Description : forum.Name;
PanelSubforums.Visible = forum.Children.Count > 0;
PanelTopicList.Visible = !forum.IsCategory;
if (PanelSubforums.Visible)
{
ListViewSubforums.DataSource = forum.Children;
ListViewSubforums.DataBind();
}
if (PanelTopicList.Visible)
{
string moderators = string.Join(", ", forum.ForumModerators.Select(fm => fm.Member.Name));
LabelForumModerators.Text = (moderators.Length > 0) ? moderators : "Administrators";
HyperLinkNewTopic.NavigateUrl = "NewTopic.aspx?forumId=" + forum.Id;
GridViewTopics.AutoGenerateColumns = false;
GridViewTopics.ShowHeader = false;
GridViewTopics.AllowPaging = true;
GridViewTopics.PagerSettings.Mode = PagerButtons.NumericFirstLast;
GridViewTopics.DataSource = forum.Topics.OrderByDescending(topic => topic.IsPinned).ThenByDescending(topic => topic.LaatstePost.CreatedDate).ToList();
GridViewTopics.DataBind();
Member member = Session["member"] as Member;
if (member == null)
{
HyperLinkNewTopic.Enabled = false;
HyperLinkNewTopic.Attributes.Add("disabled", "disabled");
HyperLinkNewTopic.ToolTip = "Only registered members can start new topics.";
}
else
{
if (member.IsForumModerator(forum))
{
ListItem[] listItems =
{
new ListItem("Pin"),
new ListItem("Unpin"),
new ListItem("Lock"),
new ListItem("Unlock"),
new ListItem("Delete")
};
DropDownListTopicAction.Items.AddRange(listItems);
PanelTopicOptions.Visible = true;
}
}
}
}
