public void LoadData(Guid siteid, bool activeOnly)
{
this.SiteID = siteid;
DateTime dtStart = this.MonthSelected.AddDays(1 - this.MonthSelected.Day);
DateTime dtEnd = dtStart.AddMonths(1);
this.MonthSelected = dtStart;
this.MonthNext = this.MonthSelected.AddMonths(1);
this.MonthPrior = this.MonthSelected.AddMonths(-1);
using (dbCalendarDataContext db = dbCalendarDataContext.GetDataContext()) {
var lst = (from c in db.tblCalendars
where c.EventDate >= dtStart &&
c.EventDate < dtEnd &&
c.SiteID == siteid &&
((c.IsActive ?? false == true) || !activeOnly)
orderby c.EventDate
select c).ToList();
List <DateTime> dates = (from dd in lst
select Convert.ToDateTime(dd.EventDate).Date).Distinct().ToList();
this.SelectedDates = dates;
this.MonthDates = lst;
}
}
public DateModel(DateTime date, Guid siteId)
: this()
{
this.SelectedDate = date;
using (dbCalendarDataContext db = dbCalendarDataContext.GetDataContext()) {
this.Dates = (from c in db.tblCalendars
where c.EventDate == this.SelectedDate &&
c.IsActive == true &&
c.SiteID == siteId
orderby c.EventDate
select c).ToList();
}
}