private void SetViewToPreviousPage() { bool onPreviousPage = !string.IsNullOrEmpty(Request.QueryString["Previous"]); if (onPreviousPage) { oHeader.InnerText = "Past Events"; } else { using (var context = new WLMembership.Model.WoodlandLifeEntities()) { var query = from ev in context.Events where ev.Date.Value < DateTime.Today select ev; bool previousListExists = query.Count() > 0; if (previousListExists) { oMessagePrevious.Visible = true; } } } }
protected void Page_Load(object sender, EventArgs e) { using (var context = new WLMembership.Model.WoodlandLifeEntities()) { System.Linq.IOrderedQueryable <WLMembership.Model.Event> query; if (DisplayPreviousEvents) { query = from ev in context.Events where ev.Date.Value < DateTime.Today orderby ev.Date descending select ev; } else { query = from ev in context.Events where ev.Date.Value >= DateTime.Today orderby ev.Date select ev; } StringBuilder html = new StringBuilder(); foreach (var ev in query) { html.AppendFormat( layout, FormatDate(ev.Date.Value), ev.Title, ev.Content ); } oHtml.Text = html.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { using (var context = new WLMembership.Model.WoodlandLifeEntities()) { System.Linq.IOrderedQueryable<WLMembership.Model.Event> query; if (DisplayPreviousEvents) { query = from ev in context.Events where ev.Date.Value < DateTime.Today orderby ev.Date descending select ev; } else { query = from ev in context.Events where ev.Date.Value >= DateTime.Today orderby ev.Date select ev; } StringBuilder html = new StringBuilder(); foreach (var ev in query) { html.AppendFormat( layout, FormatDate(ev.Date.Value), ev.Title, ev.Content ); } oHtml.Text = html.ToString(); } }