protected void BindData()
{
// Filter by x number of flags
int count;
Int32.TryParse(tbMinFlags.Text, out count);
StringBuilder sb = new StringBuilder();
List <WebpageInfo> subpages = BayshoreSolutions.WebModules.Webpage.GetWebpages(this.PageNavigationId);
foreach (WebpageInfo list in subpages)
{
foreach (WebModuleInfo module in list.Modules)
{
if (sb.Length == 0)
{
sb.Append(module.Id);
}
else
{
sb.Append("," + module.Id);
}
// Maximum length of idList for stored proc is 8000
if (sb.Length > 7990)
{
break;
}
}
}
CommentsListRepeater.DataSource = SPs.MasterDetailGetCommentFlags(sb.ToString(), count, Convert.ToInt32(rblSortOrder.SelectedValue)).GetDataSet();
CommentsListRepeater.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
HtmlLink cssLink = new HtmlLink();
cssLink.Href = "~/WebModules/MasterDetail/public/css/MasterDetail.css";
cssLink.Attributes["rel"] = "stylesheet";
cssLink.Attributes["type"] = "text/css";
this.Page.Header.Controls.AddAt(1, cssLink);
// AntiSpam session var
Session.Add("AntiSpamVar", "0");
if (!IsPostBack)
{
WebpageInfo page = this.WebModuleInfo.Webpage;
MasterDetailItem item = MasterDetailItem.GetSafeResource(this.ModuleId);
MasterDetailSetting itemList = item.GetContentList();
CurrentModuleId = item.ModuleId;
if (itemList != null)
{
lblPostDate.Visible = itemList.IsPostDateVisible;
CommentsPanel.Visible = itemList.AllowComments;
if (itemList.AllowComments)
{
Query q = MasterDetailComment.Query().WHERE(MasterDetailComment.Columns.ModuleId, CurrentModuleId);
litCommentsLink.Text = " | <a href='#Comments'>" + q.GetCount(MasterDetailComment.Columns.Id) + " Comment(s)</a>";
}
if (Page.User.Identity.IsAuthenticated || !itemList.RequireAuthentication)
{
submitCommentsDiv.Visible = true;
lblLoginMsg.Visible = false;
}
else
{
submitCommentsDiv.Visible = false;
lblLoginMsg.Visible = true;
}
}
if (lblPostDate.Visible)
{
if (page.PostDate.HasValue)
{
lblPostDate.Text = page.PostDate.Value.ToLongDateString();
}
}
if (string.IsNullOrEmpty(item.ImagePath))
{
img.Visible = false;
}
else
{
img.ImageUrl = ResolveUrl(item.ImagePath);
}
litTitle.Text = page.Text;
litBody.Text = item.LongDescription;
hypBack.NavigateUrl = this.WebModuleInfo.Webpage.Parent.Path;
CommentsListRepeater.DataSource = new MasterDetailCommentCollection()
.Where(MasterDetailComment.Columns.ModuleId, CurrentModuleId)
.OrderByDesc(MasterDetailComment.Columns.CreatedOn)
.Load();
CommentsListRepeater.DataBind();
}
}
