protected void SetCalendar()
{
using (dbCalendarDataContext db = dbCalendarDataContext.GetDataContext()) {
var lst = (from c in db.tblCalendars
where c.EventDate == theEventDate &&
c.IsActive == true &&
c.SiteID == this.SiteID
orderby c.EventDate
select c).ToList();
rEvents.DataSource = lst;
rEvents.DataBind();
}
}
protected void SetCalendar()
{
DateTime dtStart = DateTime.Now.Date.AddDays(this.DaysInPast);
DateTime dtEnd = DateTime.Now.Date.AddDays(this.DaysInFuture);
using (dbCalendarDataContext db = dbCalendarDataContext.GetDataContext()) {
var lst = (from c in db.tblCalendars
where c.EventDate >= dtStart &&
c.EventDate < dtEnd &&
c.IsActive == true &&
c.SiteID == this.SiteID
orderby c.EventDate
select c).ToList();
dgEvents.DataSource = lst;
dgEvents.DataBind();
}
}
protected void SetCalendar()
{
DateTime dtStart = Calendar1.CalendarDate.AddDays(1 - Calendar1.CalendarDate.Day);
DateTime dtEnd = dtStart.AddMonths(1);
using (dbCalendarDataContext db = dbCalendarDataContext.GetDataContext()) {
var lst = (from c in db.tblCalendars
where c.EventDate >= dtStart &&
c.EventDate < dtEnd &&
c.IsActive == true &&
c.SiteID == this.SiteID
orderby c.EventDate
select c).ToList();
List <DateTime> dates = (from dd in lst
select Convert.ToDateTime(dd.EventDate).Date).Distinct().ToList();
Calendar1.HilightDateList = dates;
dgEvents.DataSource = lst;
dgEvents.DataBind();
}
}