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