protected override Expression <Func <Purchase, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.OrderNumber.ToLower().Contains(Keyword) || x.ShipmentTrackingNo.ToLower().Contains(Keyword); } if (ParentId.IdIsOk()) { ExpressionObj = ExpressionObj.And(x => x.SupplierId == ParentId); } if (SupplierId.IdIsOk() && SupplierId != new Guid().ToString()) { ExpressionObj = ExpressionObj.And(x => x.SupplierId == SupplierId); } if (WarehouseId.IdIsOk() && WarehouseId != new Guid().ToString()) { this.ExpressionObj = this.ExpressionObj.And(x => x.WarehouseId == WarehouseId); } ExpressionObj = ExpressionObj.And(x => x.ShopId == ShopId); ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <StockTransferDetail, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Remarks.ToLower().Contains(Keyword); } if (!string.IsNullOrWhiteSpace(ParentId)) { ExpressionObj = ExpressionObj.And(x => x.StockTransferId == ParentId); } if (ProductDetailId.IdIsOk()) { ExpressionObj = ExpressionObj.And(x => x.ProductDetailId == ProductDetailId); } if (SourceWarehouseId.IdIsOk()) { ExpressionObj = ExpressionObj.And(x => x.SourceWarehouseId == SourceWarehouseId); } if (DestinationWarehouseId.IdIsOk()) { ExpressionObj = ExpressionObj.And(x => x.DestinationWarehouseId == DestinationWarehouseId); } ExpressionObj = ExpressionObj.And(x => x.ShopId == ShopId); ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <PurchaseDetail, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Remarks.ToLower().Contains(Keyword); } if (!string.IsNullOrWhiteSpace(ParentId)) { ExpressionObj = ExpressionObj.And(x => x.PurchaseId == ParentId); } if (!string.IsNullOrWhiteSpace(ProductDetailId)) { ExpressionObj = ExpressionObj.And(x => x.ProductDetailId == ProductDetailId); } if (WarehouseId.IdIsOk()) { this.ExpressionObj = this.ExpressionObj.And(x => x.WarehouseId == WarehouseId); } ExpressionObj = ExpressionObj.And(x => x.ShopId == ShopId); ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
public override Expression <Func <Teacher, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Name.ToLower().Contains(Keyword.ToLower()) || x.Phone.ToLower().Contains(Keyword.ToLower()) || x.Address.ToLower().Contains(Keyword.ToLower()) || x.Email.ToLower().Contains(Keyword.ToLower()); } if (!string.IsNullOrWhiteSpace(Name)) { this.ExpressionObj = ExpressionObj.And(x => Name.ToLower().Contains(Name.ToLower())); } if (!string.IsNullOrWhiteSpace(Phone)) { this.ExpressionObj = ExpressionObj.And(x => Phone.ToLower().Contains(Phone.ToLower())); } if (!string.IsNullOrWhiteSpace(Email)) { this.ExpressionObj = ExpressionObj.And(x => Email.ToLower().Contains(Email.ToLower())); } if (!string.IsNullOrWhiteSpace(Address)) { this.ExpressionObj = ExpressionObj.And(x => Address.ToLower().Contains(Address.ToLower())); } return(ExpressionObj); }
protected override Expression <Func <ProductDetail, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.ProductCategory.Name.ToLower().Contains(Keyword) || x.Name.ToLower().Contains(Keyword) || x.BarCode.ToLower().Contains(Keyword) || x.ProductCode.ToLower().Contains(Keyword); } if (IsProductActive) { ExpressionObj = ExpressionObj.And(x => x.IsActive == IsProductActive); } if (IsFinishedProduct) { ExpressionObj = ExpressionObj.And(x => x.IsRawProduct == false); } if (ParentId.IdIsOk()) { ExpressionObj = ExpressionObj.And(x => x.ProductCategoryId == ParentId); } if (OnHand > 0) { ExpressionObj = ExpressionObj.And(x => x.OnHand <= OnHand); } ExpressionObj = ExpressionObj.And(x => x.ShopId == ShopId); ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <EmployeeInfo, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Name.ToLower().Contains(Keyword) || x.Phone.ToLower().Contains(Keyword) || x.Email.ToLower().Contains(Keyword); } if (RoleId.IdIsOk()) { this.ExpressionObj = this.ExpressionObj.And(x => x.RoleId == RoleId); } if (WarehouseId.IdIsOk()) { this.ExpressionObj = this.ExpressionObj.And(x => x.WarehouseId == WarehouseId); } if (IsEmployeeActive) { this.ExpressionObj = this.ExpressionObj.And(x => x.IsActive == IsEmployeeActive); } ExpressionObj = ExpressionObj.And(x => x.ShopId == ShopId); ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <SaleDetail, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(ParentId)) { ExpressionObj = ExpressionObj.And(x => x.SaleId == ParentId); } if (!string.IsNullOrWhiteSpace(ProductDetailId)) { ExpressionObj = ExpressionObj.And(x => x.ProductDetailId == ProductDetailId); } if (WarehouseId.IdIsOk()) { this.ExpressionObj = this.ExpressionObj.And(x => x.WarehouseId == WarehouseId); } //if (string.IsNullOrWhiteSpace(OrderState)) //{ // OrderState state = (OrderState)Enum.Parse(typeof(OrderState), OrderState); // ExpressionObj = this.ExpressionObj.And(x => x.Sale.OrderState ==) //} ExpressionObj = ExpressionObj.And(x => x.ShopId == ShopId); ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <Teacher, bool> > GetExpression() { if (Keyword != null && MinCredit != null && MaxCredit != null) { ExpressionObj = x => (x.TotalCredit > Convert.ToDouble(MinCredit) && x.TotalCredit < Convert.ToDouble(MaxCredit)) || (x.Name.Contains(Keyword) || x.Phone.Contains(Keyword) || x.Courses.Contains(Keyword)); } if (MinCredit != null && MaxCredit != null) { ExpressionObj = x => x.TotalCredit > Convert.ToDouble(MinCredit) && x.TotalCredit < Convert.ToDouble(MaxCredit); } if (Keyword != null) { ExpressionObj = x => x.Name.Contains(Keyword) || x.Phone.Contains(Keyword) || x.Courses.Contains(Keyword); } if (MinCredit != null) { ExpressionObj = x => x.TotalCredit > Convert.ToDouble(MinCredit); } if (MaxCredit != null) { ExpressionObj = x => x.TotalCredit < Convert.ToDouble(MaxCredit); } ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <Transaction, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.OrderNumber.ToLower().Contains(Keyword) || x.TransactionNumber.ToLower().Contains(Keyword) || x.AccountHeadName.ToString().ToLower().Contains(Keyword); } if (!string.IsNullOrWhiteSpace(AccountHeadId)) { ExpressionObj = ExpressionObj.And(x => x.AccountHeadId == AccountHeadId); } if (!string.IsNullOrWhiteSpace(WalletId)) { this.ExpressionObj = this.ExpressionObj.And(x => x.WalletId == WalletId); } if (!string.IsNullOrWhiteSpace(ParentId)) { ExpressionObj = ExpressionObj.And(x => x.ParentId == ParentId); } if (!string.IsNullOrWhiteSpace(TransactionMediumName)) { ExpressionObj = ExpressionObj.And(x => x.TransactionMediumName == TransactionMediumName); } ExpressionObj = ExpressionObj.And(x => x.ShopId == ShopId); ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <Course, bool> > GetExpression() { Keyword = Keyword.ToLower(); ExpressionObj = x => x.Name.Contains(Keyword) || x.Topic.Contains(Keyword); ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <Student, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Name.ToLower().Contains(Keyword) || x.Phone.ToLower().Contains(Keyword); } ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <Department, bool> > GetExpression() { // by which property we want to query on this table? if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Name.ToLower().Contains(Keyword); } ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <Customer, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Name.ToLower().Contains(Keyword) || x.HouseNo.ToLower().Contains(Keyword) || x.RoadNo.ToLower().Contains(Keyword) || x.Area.ToLower().Contains(Keyword) || x.Thana.ToLower().Contains(Keyword) || x.District.ToLower().Contains(Keyword) || x.Country.ToLower().Contains(Keyword) || x.Phone.ToLower().Contains(Keyword) || x.Email.ToLower().Contains(Keyword); } ExpressionObj = ExpressionObj .And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <Sms, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Text.ToLower().Contains(Keyword); } ExpressionObj = ExpressionObj.And(x => x.ShopId == ShopId); ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <Installment, bool> > GetExpression() { //if (!string.IsNullOrWhiteSpace(Keyword)) //{ // ExpressionObj = x => x.Sale.OrderNumber.ToLower().Contains(Keyword) || x.Sale.OrderReferenceNumber.ToLower().Contains(Keyword) || x.Sale.CustomerPhone.ToLower().Contains(Keyword) || x.Sale.CustomerName.ToLower().Contains(Keyword); //} ExpressionObj = ExpressionObj.And(x => x.ShopId == ShopId); ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <InstallmentDetail, bool> > GetExpression() { if (ScheduledDate != new DateTime()) { this.ExpressionObj = this.ExpressionObj.And(x => x.ScheduledDate.Date == ScheduledDate.Date); } ExpressionObj = ExpressionObj.And(x => x.ShopId == ShopId); ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <Customer, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Name.ToLower().Contains(Keyword) || x.MembarshipCardNo.ToLower().Contains(Keyword) || x.Phone.ToLower().Contains(Keyword) || x.Address.ToLower().Contains(Keyword); } if (!string.IsNullOrWhiteSpace(Id)) { ExpressionObj.And(x => x.Id == Id); } return(ExpressionObj); }
protected override Expression <Func <Partner, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.PartnerShopId.ToLower().Contains(Keyword) || x.ShopId.ToLower().Contains(Keyword); } if (!string.IsNullOrWhiteSpace(Id)) { ExpressionObj = ExpressionObj.And(x => x.Id == Id); } return(ExpressionObj); }
protected override Expression <Func <PurchaseDetail, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Product.Name.ToLower().Contains(Keyword) || x.Product.BarCode.ToLower().Contains(Keyword); } if (!string.IsNullOrWhiteSpace(ParentId)) { ExpressionObj = ExpressionObj.And(x => x.PurchaseId == ParentId); } return(ExpressionObj); }
protected override Expression <Func <Content, bool> > GetExpression() { if (!IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Name.ToLower().Contains(Keyword); } if (!IsNullOrWhiteSpace(LevelId) && LevelId != new Guid().ToString()) { ExpressionObj = ExpressionObj.And(x => x.LevelId == LevelId); } return(ExpressionObj); }
protected override Expression <Func <Course, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Name.Contains(Keyword) || x.Description.Contains(Keyword); } if (Fee > 0) { ExpressionObj = ExpressionObj.And(x => x.Fee <= Fee); } return(ExpressionObj); }
protected override Expression <Func <Warehouse, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Name.ToLower().Contains(Keyword) || x.Area.ToString().ToLower().Contains(Keyword); } ExpressionObj = ExpressionObj.And(x => x.ShopId == ShopId); ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <CollectionDetail, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Fee.Name.ToLower().Contains(Keyword); } if (!string.IsNullOrWhiteSpace(ParentId)) { ExpressionObj = ExpressionObj.And(x => x.CollectionId == ParentId); } return(ExpressionObj); }
protected override Expression <Func <Student, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Name.ToLower().Contains(Keyword) || x.Department.Name.ToLower().Contains(Keyword) || x.Phone.ToLower().Contains(Keyword) || x.Address.ToLower().Contains(Keyword); } if (!string.IsNullOrWhiteSpace(Id)) { ExpressionObj.And(x => x.Id == Id); } return(ExpressionObj); }
protected override Expression <Func <Option, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Name.Contains(Keyword); } if (ShowOnlyRightAnswers) { ExpressionObj.And(x => x.IsAnswer); } return(ExpressionObj); }
protected override Expression <Func <Supplier, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Name.ToLower().Contains(Keyword) || x.StreetAddress.ToLower().Contains(Keyword) || x.Phone.ToLower().Contains(Keyword) || x.ContactPersonName.ToLower().Contains(Keyword); } ExpressionObj = ExpressionObj.And(x => x.ShopId == ShopId); ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <Product, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Name.ToLower().Contains(Keyword) || x.BarCode.ToLower().Contains(Keyword); } if (MaxQuantity > 0) { ExpressionObj = ExpressionObj.And(x => x.OnHand < MaxQuantity); } return(ExpressionObj); }
public override Expression <Func <Subscription, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Package.ToString().Contains(Keyword) || x.Edition.Name.Contains(Keyword); } if (!string.IsNullOrWhiteSpace(TenantId)) { ExpressionObj = ExpressionObj.And(x => x.TenantId == TenantId); } return(ExpressionObj); }
protected override Expression <Func <DealerProduct, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.ProductDetailId.Contains(Keyword) || x.DealerId.Contains(Keyword); } ExpressionObj = ExpressionObj.And(x => x.ShopId == ShopId); ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }
protected override Expression <Func <ProductGroup, bool> > GetExpression() { if (!string.IsNullOrWhiteSpace(Keyword)) { ExpressionObj = x => x.Name.ToLower().Contains(Keyword); } if (IsProductGroupActive) { ExpressionObj = ExpressionObj.And(x => x.IsActive == IsProductGroupActive); } ExpressionObj = ExpressionObj.And(x => x.ShopId == ShopId); ExpressionObj = ExpressionObj.And(GenerateBaseEntityExpression()); return(ExpressionObj); }