public IList <Model.Advertisment> LoadTodayAdversitments(AdvertismentState advertismentState, string sectionCode)
{
return(LoadAdversitments(
advertismentState,
Utils.GetUkranianDateTimeNow().Date,
Utils.GetUkranianDateTimeNow().Date.AddDays(1),
sectionCode));
}
private IQueryable <Advertisment> LoadAdvertismentsByDate(AdvertismentState advertismentState, DateTime dateTimeFrom, DateTime dateTimeTo)
{
IQueryable <Advertisment> searchResults = from adv in context.Advertisments
where
!adv.isSpecial &&
adv.modifyDate >= dateTimeFrom.Date &&
adv.modifyDate < dateTimeTo.Date &&
!adv.not_realestate
select adv;
return(searchResults);
}
public IList <Model.Advertisment> LoadAdversitments(AdvertismentState advertismentState, DateTime dateTimeFrom, DateTime dateTimeTo, string sectionCode)
{
IQueryable <Advertisment> advertisments = LoadAdvertismentsByDate(advertismentState, dateTimeFrom, dateTimeTo);
int advertismentsCount = 0;
if (advertisments != null)
{
advertisments = advertisments.Where(adv => adv.AdvertismentSection.code == sectionCode);
advertismentsCount = advertisments.Count();
switch (advertismentState)
{
case AdvertismentState.JustParsed:
advertisments = advertisments.Where(
adv => adv.subpurchaseAdvertisment && adv.SubPurchase == null
);
break;
case AdvertismentState.NotSubpurchase:
advertisments = advertisments.Where(
adv => !adv.subpurchaseAdvertisment
);
break;
case AdvertismentState.Subpurchase:
advertisments = advertisments.Where(
adv => adv.subpurchaseAdvertisment && adv.SubPurchase != null
);
break;
}
}
advertisments = advertisments.Where(a => a.AdvertismentPhones.Any());
return(advertisments.ToList());
}
