public ICollection <T> Get(Expression <Func <T, bool> > filter = null, DataPagingOptions pagingOptions = null)
{
IQueryable <T> queryable = _dbContext.Set <T>();
if (filter != null)
{
queryable = queryable.Where(filter);
}
if (pagingOptions?.PageSize > 0 && pagingOptions.PageNumber.GetValueOrDefault() > 0)
{
queryable = queryable
.Skip(pagingOptions.PageNumber.GetValueOrDefault() * pagingOptions.PageSize.GetValueOrDefault())
.Take(pagingOptions.PageSize.GetValueOrDefault());
}
return(queryable.ToList());
}
public SumResultModel <ProductListDto> GetProductList(Expression <Func <Products, bool> > filter = null, DataPagingOptions dataPagingOptions = null)
{
SumResultModel <ProductListDto> result = new SumResultModel <ProductListDto>();
var list = _repository.Get(filter, dataPagingOptions).Select(c => new ProductListDto
{
ProductId = c.ProductId,
CategoryName = c.CategoryId != null ? _baseCrudCategoryRepository.GetById((int)c.CategoryId).CategoryName : string.Empty,
ProductName = c.ProductName,
QuantityPerUnit = c.QuantityPerUnit,
SupplierName = c.SupplierId != null ? _baseCrudSupplierRepository.GetById((int)c.SupplierId).CompanyName : string.Empty,
UnitPrice = c.UnitPrice,
UnitsInStock = c.UnitsInStock
}).ToList();
result.Data = list;
result.Success = true;
result.StatusCode = 200;
result.TotalRecordCount = _repository.GetTotalRecordCount();
return(result);
}
public ICollection <T> Get(Expression <Func <T, bool> > filter = null, DataPagingOptions pagingOptions = null)
{
return(_repository.Get(filter, pagingOptions));
}
