public CalendarModel(DateTime startDateP, TennisUserModel tennisUserP, SportsLinkDB dbP)
: base(tennisUserP)
{
this.UserStartDate = IndexModel.GetLocalDate(startDateP.ToUniversalTime(), tennisUserP.TimeZoneOffset);
this.UserStartDate = this.UserStartDate.AddDays(-(int)this.UserStartDate.DayOfWeek);
this.StartDate = IndexModel.GetUtcDate(this.UserStartDate, tennisUserP.TimeZoneOffset);
this.EndDate = this.StartDate.AddDays(7);
if (null == CachedQuery)
{
var offers = ModelUtils.GetOffersFunc();
Expression <Func <SportsLinkDB, TennisUserModel, DateTime, DateTime, IQueryable <OfferModel> > > results =
(SportsLinkDB db, TennisUserModel tennisUser, DateTime startDate, DateTime endDate) =>
offers.Invoke(db, tennisUser)
.Where(o => o.RequestUser.FacebookId != tennisUser.FacebookId)
.Where(o => o.SpecificOpponent == null || o.SpecificOpponent.FacebookId == tennisUser.FacebookId || o.RequestUser.FacebookId == tennisUser.FacebookId)
.Where(o => o.ConfirmedUser == null || o.ConfirmedUser.FacebookId == tennisUser.FacebookId || o.RequestUser.FacebookId == tennisUser.FacebookId)
.Where(o => o.MatchDateUtc >= startDate)
.Where(o => o.MatchDateUtc < endDate)
.Where(o => o.MatchDateUtc >= DateTime.UtcNow || null != o.ConfirmedUser)
.OrderBy(o => o.MatchDateUtc);
CachedQuery = CompiledQuery.Compile <SportsLinkDB, TennisUserModel, DateTime, DateTime, IQueryable <OfferModel> >
(
results.Expand()
);
}
this.Offers = CachedQuery(dbP, tennisUserP, this.StartDate, this.EndDate);
}
