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