public SimpleSelect GetCategorySelect(int?categoryId, bool?single)
{
return(_loader.LoadFromFile <List <CategoryEntity> >("category")
.Where(e => (!single.GetValueOrDefault() && e.Active) || e.CategoryId == categoryId)
.OrderBy(e => e.CategoryName)
.ToSimpleSelect(a => a.CategoryId, a => a.CategoryName));
}
public PagedResult <IQueryable <PreviewDetailDTO> > PreviewDetailPreview(
int?currentPage,
int?pageSize,
string name,
int?categoryId,
bool?active,
DateTime?startDate,
DateTime?endDate)
{
// 0. Load data / data source
List <PreviewDetailEntity> previewDetail = _loader.LoadFromFile <List <PreviewDetailEntity> >("preview-detail");
List <CategoryEntity> categories = _loader.LoadFromFile <List <CategoryEntity> >("category");
// 1. Project
var qry = (from pd in previewDetail
from cat in categories.Where(e => pd.CategoryIds != null && pd.CategoryIds.Contains(e.CategoryId)).DefaultIfEmpty()
group cat by pd
into grp
select new { previewDetail = grp.Key, categories = grp })
.AsQueryable(); //Not needed if using entity framework - want to ensure pattern works with IQueryable
// 2. Filter
if (!string.IsNullOrEmpty(name))
{
qry = qry.Where(e => e.previewDetail.Name != null && e.previewDetail.Name.IndexOf(name, StringComparison.OrdinalIgnoreCase) >= 0);
}
if (categoryId != null)
{
qry = qry.Where(e => e.categories.Where(w => w != null).Any(f => f.CategoryId == categoryId));
}
if (active != null)
{
qry = qry.Where(e => e.previewDetail.Active == active);
}
if (startDate != null)
{
qry = qry.Where(e => e.previewDetail.Date >= startDate);
}
if (endDate != null)
{
qry = qry.Where(e => e.previewDetail.Date <= endDate);
}
// 3. Select to DTO
IQueryable <PreviewDetailDTO> items = qry.Select(q => new PreviewDetailDTO
{
PreviewDetailId = q.previewDetail.PreviewDetailId,
Name = q.previewDetail.Name,
Active = q.previewDetail.Active,
Date = q.previewDetail.Date,
Categories = q.categories
.Where(w => w != null) //TODO: Figure out why grouping results in 1 null category instead of 0 categories
.Select(c => c.CategoryName)
.ToList(),
Codes = new List <string> {
"TODO 1", "todo 2"
}
});
// 4. Sort
items = items.OrderBy(o => o.Name);
// 5. Page
return(PagedResult <PreviewDetailDTO> .AutoPage(items, currentPage, pageSize));
}