public PageOfResults<Gig> Get(BandName band, PagingParams paging) { var result = gigSummary.BandDiaries().Where(x => x.BandName.Value.Tidy() == band.Value.Tidy()).FirstOrDefault().Gigs; return new PageOfResults<Gig> { CurrentPageNumber = paging.PageNumber, NumberOfPages = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(result.Count()) / Convert.ToDouble(paging.PageSize))), TotalNumberOfRecords = result.Count(), Results = result.Skip(((paging.PageNumber - 1) * paging.PageSize)).Take(paging.PageSize).ToList() }; }
public PageOfResults<BandUrls> GetBandUrls(PagingParams paging) { var pageOf = session.Advanced.LuceneQuery<BandUrls>("BandUrls").Skip(((paging.PageNumber - 1) * paging.PageSize)) .Take(paging.PageSize); return new PageOfResults<BandUrls> { CurrentPageNumber = paging.PageNumber, NumberOfPages = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(pageOf.QueryResult.TotalResults) / Convert.ToDouble(paging.PageSize))), TotalNumberOfRecords = pageOf.QueryResult.TotalResults, Results = pageOf.ToList() }; }
public PageOfResults<BandName> GetBands(PagingParams paging, params string[] alphaPick) { var result = BandNames(); var pageOf = result.Skip(((paging.PageNumber - 1) * paging.PageSize)) .Take(paging.PageSize); return new PageOfResults<BandName> { CurrentPageNumber = paging.PageNumber, NumberOfPages = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(result.Count()) / Convert.ToDouble(paging.PageSize))), TotalNumberOfRecords = result.Count(), Results = pageOf.ToList() }; }
public PageOfResults<StolenGear> Get(PagingParams paging) { var result = session.Advanced.LuceneQuery<StolenGear>() .Skip(((paging.PageNumber - 1) * paging.PageSize)) .Take(paging.PageSize); return new PageOfResults<StolenGear> { CurrentPageNumber = paging.PageNumber, NumberOfPages = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(result.QueryResult.TotalResults) / Convert.ToDouble(paging.PageSize))), TotalNumberOfRecords = result.QueryResult.TotalResults, Results = result.ToList() }; }
public PageOfResults<RepeatingGig> GetRepeating(PagingParams paging) { var result = session.Advanced.LuceneQuery<RepeatingGig>() .AddOrder("SequenceStartFrom", paging.SortOrder == "desc") .Skip(((paging.PageNumber - 1) * paging.PageSize)) .Take(paging.PageSize); return new PageOfResults<RepeatingGig> { CurrentPageNumber = paging.PageNumber, NumberOfPages = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(result.QueryResult.TotalResults) / Convert.ToDouble(paging.PageSize))), TotalNumberOfRecords = result.QueryResult.TotalResults, Results = result.ToList() }; }
public PageOfResults<VenueDiary> Get(PagingParams paging) { var venues = files.GetDirectory(HostingEnvironment.MapPath("~/Content/Export/Venues/")).Files(); var filtered = venues.OrderBy(x => x.NameWithoutExtension).Select(x => x.NameWithoutExtension) .Skip(((paging.PageNumber - 1) * paging.PageSize)) .Take(paging.PageSize); return new PageOfResults<VenueDiary> { CurrentPageNumber = paging.PageNumber, NumberOfPages = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(venues.Count()) / Convert.ToDouble(paging.PageSize))), TotalNumberOfRecords = venues.Count(), Results = filtered.Select(x => Get(new VenueName { Value = x })).ToList() }; }
public PageOfResults<VenueDiary> Get(PagingParams paging) { var gigs = gigSummary.AllGigs(); var result = session.Advanced.LuceneQuery<Venues.ReduceResult>("Venues") .OrderBy("Venue") .Skip(((paging.PageNumber - 1) * paging.PageSize)) .Take(paging.PageSize); return new PageOfResults<VenueDiary> { CurrentPageNumber = paging.PageNumber, NumberOfPages = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(result.QueryResult.TotalResults) / Convert.ToDouble(paging.PageSize))), TotalNumberOfRecords = result.QueryResult.TotalResults, Results = result.Select(x => new VenueDiary { Venue = x.Venue, Gigs = gigs.Where(y => y.Venue == x.Venue).ToList() }).ToList() }; }
public PageOfResults<BandName> GetBands(PagingParams paging, params string[] alphaPick) { var bands = BandNames(); var filter = alphaPick.Any() ? bands.Where(x => x.Value.StartsWith(alphaPick[0], true, CultureInfo.CurrentCulture)) : bands; var result = filter.OrderBy(x => x.Value) .Skip(((paging.PageNumber - 1) * paging.PageSize)) .Take(paging.PageSize); return new PageOfResults<BandName> { CurrentPageNumber = paging.PageNumber, NumberOfPages = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(filter.Count()) / Convert.ToDouble(paging.PageSize))), TotalNumberOfRecords = filter.Count(), Results = result }; }
public PageOfResults<StolenGear> Get(PagingParams paging) { var stolenGearFiles = files.GetDirectory(HostingEnvironment.MapPath("~/Content/Export/StolenGear/")).Files(); var filtered = stolenGearFiles .Select(file => cache.ReadOut<StolenGear>("StolenGear/" + file.Name)) .Where(s => !s.Archived) .OrderBy(s => s.Edited).ToList() .Skip(((paging.PageNumber - 1) * paging.PageSize)) .Take(paging.PageSize); return new PageOfResults<StolenGear> { CurrentPageNumber = paging.PageNumber, NumberOfPages = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(stolenGearFiles.Count()) / Convert.ToDouble(paging.PageSize))), TotalNumberOfRecords = stolenGearFiles.Count(), Results = filtered.ToList() }; }
public PageOfResults<VenueDiaryPlusMetaData> DiaryPlusMetadata(PagingParams paging) { var diaries = Get(paging); var metadata = venueSummary.Metadata(); var result = diaries.Results.Select(diary => new VenueDiaryPlusMetaData { Diary = diary, Metadata = metadata .Where(x => x.VenueName == diary.Venue) .FirstOrDefault() ?? new VenueMetadata { VenueName = diary.Venue } }).ToList(); return new PageOfResults<VenueDiaryPlusMetaData> { CurrentPageNumber = paging.PageNumber, NumberOfPages = diaries.NumberOfPages, TotalNumberOfRecords = diaries.TotalNumberOfRecords, Results = result }; }
public PageOfResults<BandUrls> GetBandUrls(PagingParams paging) { throw new NotImplementedException(); }
public PageOfResults<VenueDiaryPlusMetaData> DiaryPlusMetadata(PagingParams paging) { throw new NotImplementedException(); }
public PageOfResults<Gig> Get(BandName band, PagingParams paging) { throw new NotImplementedException(); }