public override Specification <Mapping> GetSpecification() { var spec = new Specification <Mapping>(); if (!Ids.IsEmpty()) { int[] ids = ArrayHelpers.StringToIntArray(Ids); if (ids != null && ids.Length > 0) { spec.And(c => ids.Contains(c.Id)); } } if (!ProductIds.IsEmpty()) { int[] ids = ArrayHelpers.StringToIntArray(ProductIds); if (ids != null && ids.Length > 0) { spec.And(c => ids.Contains(c.ProductId)); } } if (StoreId.HasValue) { spec.And(m => m.StoreId.Equals(StoreId.Value)); } if (!Sku.IsEmpty()) { spec.And(m => m.Product.Sku.StartsWith(Sku)); } if (!StoreSku.IsEmpty()) { spec.And(m => m.StoreSku.StartsWith(StoreSku)); } return(spec); }
public override Specification <Product> GetSpecification() { var spec = new Specification <Product>(); if (!Ids.IsEmpty()) { int[] ids = ArrayHelpers.StringToIntArray(Ids); if (ids != null && ids.Length > 0) { spec.And(c => ids.Contains(c.Id)); } } if (VendorId.HasValue) { spec.And(c => c.VendorId == VendorId.Value); } if (!Sku.IsEmpty()) { spec.And(c => c.Sku.StartsWith(Sku)); } if (!Name.IsEmpty()) { spec.And(c => c.Name.StartsWith(Name)); } if (!WarehouseLocation.IsEmpty()) { spec.And(c => c.WarehouseLocation.StartsWith(WarehouseLocation) || c.BulkWarehouseLocation.StartsWith(WarehouseLocation)); } if (!ShowAll) { spec.And(c => !c.Discontinued || c.Inventory.StockQuantity > 0); } return(spec); }
public override Specification <ReportGroupItem> GetSpecification() { var spec = new Specification <ReportGroupItem>(); if (!Ids.IsEmpty()) { int[] ids = ArrayHelpers.StringToIntArray(Ids); if (ids != null && ids.Length > 0) { spec.And(c => ids.Contains(c.Id)); } } if (ReportGroupId.HasValue) { spec.And(i => i.ReportGroupId == ReportGroupId.Value); } if (!Sku.IsEmpty()) { spec.And(i => i.Product.Sku.StartsWith(Sku)); } if (!Name.IsEmpty()) { spec.And(i => i.Product.Name.Contains(Name)); } return(spec); }
public override Specification <Adjustment> GetSpecification() { var spec = new Specification <Adjustment>(); if (!Ids.IsEmpty()) { int[] ids = ArrayHelpers.StringToIntArray(Ids); if (ids != null && ids.Length > 0) { spec.And(c => ids.Contains(c.Id)); } } if (!ProductIds.IsEmpty()) { int[] ids = ArrayHelpers.StringToIntArray(ProductIds); if (ids != null && ids.Length > 0) { spec.And(c => ids.Contains(c.ProductId)); } } if (AdjustmentTypeId.HasValue) { spec.And(a => a.AdjustmentTypeId == AdjustmentTypeId.Value); } if (StoreId.HasValue) { spec.And(a => a.StoreId == StoreId.Value); } if (!Sku.IsEmpty()) { spec.And(r => r.Product.Sku.StartsWith(Sku)); } if (!ReferenceNumber.IsEmpty()) { spec.And(r => r.ReferenceNumber.StartsWith(ReferenceNumber)); } return(spec); }
public override Specification <Reservation> GetSpecification() { var spec = new Specification <Reservation>(); if (!Ids.IsEmpty()) { int[] ids = ArrayHelpers.StringToIntArray(Ids); if (ids != null && ids.Length > 0) { spec.And(c => ids.Contains(c.Id)); } } if (!ProductIds.IsEmpty()) { int[] ids = ArrayHelpers.StringToIntArray(ProductIds); if (ids != null && ids.Length > 0) { spec.And(c => ids.Contains(c.ProductId)); } } if (!OrderNumber.IsEmpty()) { spec.And(r => r.OrderNumber == OrderNumber); } if (!Sku.IsEmpty()) { spec.And(r => r.Product.Sku.StartsWith(Sku)); } if (!ShowAll) { spec.And(r => r.Quantity > 0); } return(spec); }