public IEnumerable <Post> GetPosts(DateRangeAddress dateRangeAddress)
{
return(cache.GetItems <IEnumerable <Post>, Post>(
string.Format("GetPostsWithDrafts-StartDate:{0},EndDate:{1}", dateRangeAddress.StartDate, dateRangeAddress.EndDate),
() => pluginEngine.ProcessDisplayOfPosts(context, () => repository.GetPosts(dateRangeAddress).FillTags(tagService)),
p => p.GetDependencies()
));
}
public IEnumerable <ScheduleItem> GetScheduleItemsByTimeSlot(Event evnt, DateRangeAddress dateRangeAddress)
{
return
(cache.GetItems <IEnumerable <ScheduleItem>, ScheduleItem>(
string.Format("GetScheduleItems-Event:{0},Start:{1},End:{2}", evnt.Name, dateRangeAddress.StartDate.ToStringForFeed(), dateRangeAddress.EndDate.ToStringForFeed()),
() => repository.GetScheduleItemsByTimeSlot(evnt, dateRangeAddress).FillTags(tagService),
si => si.GetDependencies()
));
}
public IEnumerable <Post> GetPosts(DateRangeAddress dateRangeAddress)
{
return(projectPosts(
from b in context.oxite_Blogs_Blogs
join p in context.oxite_Blogs_Posts on b.BlogID equals p.BlogID
where b.SiteID == siteID && p.PublishedDate != null && p.PublishedDate >= dateRangeAddress.StartDate && p.PublishedDate < dateRangeAddress.EndDate && p.State == (byte)EntityState.Normal
orderby p.PublishedDate
select p
).ToArray());
}
public IEnumerable <ScheduleItem> GetScheduleItemsByTimeSlot(Event evnt, DateRangeAddress dateRangeAddress)
{
var query =
from si in context.oxite_Conferences_ScheduleItems
join e in context.oxite_Conferences_Events on si.EventID equals e.EventID
where e.EventID == evnt.ID && si.StartTime >= dateRangeAddress.StartDate && si.EndTime <= dateRangeAddress.EndDate
select si;
return(projectScheduleItems(query).ToArray());
}
public IQueryable <ScheduleItem> GetScheduleItemsByTimeSlotAndUser(EventAddress eventAddress, DateRangeAddress dateRangeAddress, Guid userID)
{
IQueryable <oxite_Conferences_ScheduleItem> query =
from si in context.oxite_Conferences_ScheduleItems
join e in context.oxite_Conferences_Events on si.EventID equals e.EventID
where string.Compare(e.EventName, eventAddress.EventName, true) == 0 && si.StartTime >= dateRangeAddress.StartDate && si.EndTime <= dateRangeAddress.EndDate
select si;
query = query.Where(
si => si.oxite_Conferences_ScheduleItemUserRelationships
.Any(siu => siu.UserID == userID)
);
return(projectScheduleItems(query));
}
public IEnumerable <ScheduleItem> GetScheduleItemsByTimeSlotAndUser(EventAddress address, DateRangeAddress rangeAddress, Guid userID)
{
// if this is cached, you'll see schedule items on your list that used to be on the list but aren't anymore
var result = repository.GetScheduleItemsByTimeSlotAndUser(address, rangeAddress, userID).FillTags(tagService);
SetScheduleItemUsers(result);
return(result);
}
public IEnumerable <ScheduleItem> GetScheduleItemsByTimeSlot(EventAddress eventAddress, DateRangeAddress dateRangeAddress)
{
var result =
cache.GetItems <IEnumerable <ScheduleItem>, ScheduleItem>(
string.Format("GetScheduleItems-Event:{0},Start:{1},End:{2}", eventAddress.EventName, dateRangeAddress.StartDate.ToStringForFeed(), dateRangeAddress.EndDate.ToStringForFeed()),
() => repository.GetScheduleItemsByTimeSlot(eventAddress, dateRangeAddress).FillTags(tagService).ToList(),
si => si.GetDependencies()
);
SetScheduleItemUsers(result);
return(result);
}
public IQueryable <ScheduleItem> GetScheduleItemsByTimeSlot(EventAddress eventAddress, DateRangeAddress dateRangeAddress)
{
var query =
from si in context.oxite_Conferences_ScheduleItems
join e in context.oxite_Conferences_Events on si.EventID equals e.EventID
where string.Compare(e.EventName, eventAddress.EventName, true) == 0 && si.StartTime >= dateRangeAddress.StartDate && si.EndTime <= dateRangeAddress.EndDate
select si;
return(projectScheduleItems(query));
}
public OxiteViewModelItems <ScheduleItem> ListByDateRangeAndUser(EventAddress eventAddress, DateRangeAddress dateRangeAddress)
{
Event evnt = eventService.GetEvent(eventAddress);
if (evnt == null)
{
return(null);
}
var userAuthenticated = userService.GetUser(currentUser.Name);
if (userAuthenticated == null)
{
return(null);
}
var userID = userAuthenticated.ID;
IEnumerable <ScheduleItem> scheduleItems = scheduleItemService.GetScheduleItemsByTimeSlotAndUser(eventAddress, dateRangeAddress, userID);
return(new OxiteViewModelItems <ScheduleItem>(scheduleItems)
{
Container = evnt
});
}
public OxiteViewModelItems <ScheduleItem> ListByDateRange(EventAddress eventAddress, DateRangeAddress dateRangeAddress)
{
Event evnt = eventService.GetEvent(eventAddress);
if (evnt == null)
{
return(null);
}
IEnumerable <ScheduleItem> scheduleItems = scheduleItemService.GetScheduleItemsByTimeSlot(eventAddress, dateRangeAddress);
return(new OxiteViewModelItems <ScheduleItem>(scheduleItems)
{
Container = evnt
});
}