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()); }