// *******************************************************************************************************************************
#region - GetItems -
public Task <PagedList <ProductItemDTO> > GetItemsAsync(GetProductItemsQuery query)
{
var where = new StringBuilder();
where.AppendFormat($" AND ASIN = '{query.ASIN}'");
if (query.Keyword.IsPresent())
{
where.AppendFormat(" AND (SKU LIKE '%{0}%' OR Alias LIKE '%{0}%')", query.Keyword);
}
string orderBy = "SKU";
switch (query.OrderBy.GetValueOrDefault())
{
case 0:
orderBy = "SKU";
break;
case 1:
orderBy = "Alias";
break;
}
orderBy += " " + query.SortDirection;
return(base.GetPagedListAsync <ProductItemDTO>(query.PageSize, query.PageIndex, "ProductItem", "*", where.ToString(), orderBy));
}
public async Task <DataTables <ProductItemDTO> > GetItemsAsync(DataTableModel model, string asin)
{
var query = new GetProductItemsQuery
{
PageSize = model.PageSize,
PageIndex = model.PageIndex,
OrderBy = model.OrderBy,
Draw = model.Draw,
Keyword = model.Keyword,
ASIN = asin,
SortDirection = model.SortDirection,
};
query.SetContext(User.Identity);
var plist = await ProductItemDF.GetItemsAsync(query).ConfigureAwait(false);
return(new DataTables <ProductItemDTO>(query.Draw, plist));
}
public async Task <PagedList <ProductItemDTO> > GetItemsAsync(GetProductItemsQuery query)
{
var rs = await ProductItemDAL.GetItemsAsync(query).ConfigureAwait(false);
return(rs);
}
