public ModelCollection <ProductEntityBase> ListProducts(int categoryId, ProductFlagTypes flags, ProductOrder order)
{
/*
* Select<DataModel.VProduct> select = _modelDataService.DataProvider.NewSelect();
* select
* .Where(x => x.CategoryId, categoryId)
* .And(x => x.ProductFlags, flags);
*
* select
* .Join("INNER JOIN dbo.TEntityCategory C ON C.EntityGuid = P.EntityGuid");
*
* if (order == ProductOrder.CostAsc)
* {
* select.OrderBy(x => x.Net);
* }
* else if (order == ProductOrder.CostDesc)
* {
* select.OrderBy(x => x.Net, false);
* }
* else if (order == ProductOrder.TitleAsc)
* {
* select.OrderBy(x => x.Title);
* }
*
* DataPage<dynamic> dataPage = _modelDataService.DataProvider.QueryPage<dynamic>(select, connection => select.WithLicenseId(connection, DataContext.LicenseSettings));
* return new ModelCollection<ProductEntityBase>(ObjectMapper.MapAll<ProductEntityBase>(dataPage.Data), dataPage.Count);
*/
return(ListProductsInternal("dbo.SPListProductsByCategory", new { categoryId, productFlags = (byte)flags, order = (byte)order }));
}
public ProductFlagTypes SetFlag(ProductFlagTypes flag, bool on = true)
{
ProductFlagTypes flags = ProductFlags;
// toggle flag
if (on)
{
flags |= flag;
}
else
{
flags &= flag;
}
// now set the main property back after the changes
ProductFlags = flags;
// return result
return(flags);
}
public ModelCollection <ProductEntityBase> ListProducts(ProductFlagTypes flags = ProductFlagTypes.Active)
{
return(_productDataProvider.ListProducts(flags));
}
public ModelCollection <ProductEntityBase> ListProducts(int categoryId, ProductFlagTypes flags, ProductOrder order = ProductOrder.CostDesc)
{
return(_productDataProvider.ListProducts(categoryId, flags, order));
}
public ModelCollection <ProductEntityBase> ListProducts(ProductFlagTypes flags)
{
return(ListProductsInternal("dbo.SPListProducts", new { productFlags = (short)flags }));
}
