/// <summary>
/// Builds the property expression.
/// </summary>
/// <param name="request">The property request.</param>
/// <returns>System.Linq.Expressions.Expression<System.Func<RealState.Domain.Entities.Property, System.Boolean>>.</returns>
public Expression <Func <Property, bool> > BuildPropertyExpression(PropertyRequestDto request)
{
if (string.IsNullOrEmpty(request.Name) && string.IsNullOrEmpty(request.CodeInternal) && request.Year == decimal.Zero)
{
return(PredicateBuilderExtension.True <Property>());
}
var predicate = PredicateBuilderExtension.False <Property>();
if (!string.IsNullOrEmpty(request.Name))
{
predicate = predicate.Or(p => p.Name.Contains(request.Name));
}
if (!string.IsNullOrEmpty(request.CodeInternal))
{
predicate = predicate.Or(p => p.CodeInternal.Equals(request.CodeInternal));
}
if (request.Year > decimal.Zero)
{
predicate = predicate.Or(p => p.Year == request.Year);
}
return(predicate);
}
public OperationResponse <PageResult <BasicProductAliasPageQueryCommandOutputDTO> > PageQuery(PageQuery <BasicProductAliasPageQueryCommandInputDTO> input)
{
var result = new OperationResponse <PageResult <BasicProductAliasPageQueryCommandOutputDTO> >();
try
{
// predicate construction
var predicate = PredicateBuilderExtension.True <BasicProductAlias>();
if (input.CustomFilter != null)
{
var filter = input.CustomFilter;
if (!string.IsNullOrWhiteSpace(filter.Term))
{
predicate = predicate.And(o => o.Name.Contains(filter.Term, StringComparison.InvariantCultureIgnoreCase));
}
}
var dbLocator = this.AmbientDbContextLocator.Get <RiverdaleDBContext>();
{
var query = dbLocator.Set <BasicProductAlias>().AsQueryable();
var advancedSorting = new List <SortItem <BasicProductAlias> >();
Expression <Func <BasicProductAlias, object> > expression;
if (input.Sort.ContainsKey("productName"))
{
expression = o => o.Product.Name;
advancedSorting.Add(new SortItem <BasicProductAlias> {
PropertyName = "productName", SortExpression = expression, SortOrder = "desc"
});
}
var sorting = new SortingDTO <BasicProductAlias>(input.Sort, advancedSorting);
result.Bag = query.ProcessPagingSort <BasicProductAlias, BasicProductAliasPageQueryCommandOutputDTO>(predicate, input, sorting, o => new BasicProductAliasPageQueryCommandOutputDTO
{
Id = o.Id,
Name = o.Name,
ProductId = o.ProductId,
ProductName = o.Product.Name,
ProductCategorySizeId = o.ProductCategorySizeId,
ProductCategorySize = o.ProductCategorySize.Size,
ColorTypeId = o.ColorTypeId,
ColorTypeName = o.ColorType.Name,
CreatedAt = o.CreatedAt
});
}
}
catch (Exception ex)
{
result.AddException($"Error getting Basic Product Alias page query", ex);
}
return(result);
}
public OperationResponse <PageResult <CustomerFreightoutPageQueryCommandOutputDTO> > PageQuery(PageQuery <CustomerFreightoutPageQueryCommandInputDTO> input)
{
var result = new OperationResponse <PageResult <CustomerFreightoutPageQueryCommandOutputDTO> >();
try
{
// predicate construction
var predicate = PredicateBuilderExtension.True <CustomerFreightout>();
if (input.CustomFilter != null)
{
var filter = input.CustomFilter;
if (!string.IsNullOrWhiteSpace(filter.Term))
{
predicate = predicate.And(o => o.Customer.Name.Contains(filter.Term, StringComparison.InvariantCultureIgnoreCase));
}
}
var dbLocator = this.AmbientDbContextLocator.Get <RiverdaleDBContext>();
{
var query = dbLocator.Set <CustomerFreightout>().AsQueryable();
var advancedSorting = new List <SortItem <CustomerFreightout> >();
Expression <Func <CustomerFreightout, object> > expression;
if (input.Sort.ContainsKey("customerName"))
{
expression = o => o.Customer.Name;
advancedSorting.Add(new SortItem <CustomerFreightout> {
PropertyName = "customerName", SortExpression = expression, SortOrder = "desc"
});
}
var sorting = new SortingDTO <CustomerFreightout>(input.Sort, advancedSorting);
result.Bag = query.ProcessPagingSort <CustomerFreightout, CustomerFreightoutPageQueryCommandOutputDTO>(predicate, input, sorting, o => new CustomerFreightoutPageQueryCommandOutputDTO
{
Id = o.Id,
CustomerName = o.Customer.Name,
Cost = o.Cost,
CustomerFreightoutRateTypeId = o.CustomerFreightoutRateTypeId,
CustomerId = o.CustomerId,
DateFrom = o.DateFrom,
DateTo = o.DateTo,
SecondLeg = o.SecondLeg,
SurchargeHourly = o.SurchargeHourly,
SurchargeYearly = o.SurchargeYearly,
WProtect = o.WProtect,
});
}
}
catch (Exception ex)
{
result.AddException($"Error getting customer freightout page query", ex);
}
return(result);
}
public OperationResponse <PageResult <ProductPageQueryCommandOutputDTO> > PageQuery(PageQuery <ProductPageQueryCommandInputDTO> input)
{
var result = new OperationResponse <PageResult <ProductPageQueryCommandOutputDTO> >();
try
{
// predicate construction
var predicate = PredicateBuilderExtension.True <AbstractProduct>();
if (input.CustomFilter != null)
{
var filter = input.CustomFilter;
if (!string.IsNullOrWhiteSpace(filter.Term))
{
predicate = predicate.And(o => o.Name.Contains(filter.Term, StringComparison.InvariantCultureIgnoreCase));
}
}
var dbLocator = this.AmbientDbContextLocator.Get <RiverdaleDBContext>();
{
var query = dbLocator.Set <AbstractProduct>().AsQueryable();
var advancedSorting = new List <SortItem <AbstractProduct> >();
Expression <Func <AbstractProduct, object> > expression;
if (input.Sort.ContainsKey("productType"))
{
expression = o => o.ProductType.Name;
advancedSorting.Add(new SortItem <AbstractProduct> {
PropertyName = "productType", SortExpression = expression, SortOrder = "desc"
});
}
var sorting = new SortingDTO <AbstractProduct>(input.Sort, advancedSorting);
result.Bag = query.ProcessPagingSort <AbstractProduct, ProductPageQueryCommandOutputDTO>(predicate, input, sorting, o => new ProductPageQueryCommandOutputDTO
{
Id = o.Id,
Name = o.Name,
FlowerProductCategoryName = o.ProductTypeId == "FLW" && ((FlowerProduct)o).ProductCategory != null ? ((FlowerProduct)o).ProductCategory.Name : null,
CreatedAt = o.CreatedAt,
MainPicture = o.ProductMedias.Select(m => new FileItemRefOutputDTO
{
Id = m.Id,
FullUrl = m.FileRepository.FullFilePath
}).FirstOrDefault()
});
}
}
catch (Exception ex)
{
result.AddException($"Error getting customer page query", ex);
}
return(result);
}
public OperationResponse <PageResult <SaleOpportunityPageQueryCommandOutputDTO> > PageQuery(PageQuery <SaleOpportunityPageQueryCommandInputDTO> input)
{
var result = new OperationResponse <PageResult <SaleOpportunityPageQueryCommandOutputDTO> >();
try
{
// predicate construction
var predicate = PredicateBuilderExtension.True <SaleOpportunity>();
if (input.CustomFilter != null)
{
var filter = input.CustomFilter;
if (!string.IsNullOrWhiteSpace(filter.Term))
{
predicate = predicate.And(o => o.Name.Contains(filter.Term, StringComparison.InvariantCultureIgnoreCase));
}
}
var dbLocator = this.AmbientDbContextLocator.Get <RiverdaleDBContext>();
{
var query = dbLocator.Set <SaleOpportunity>().AsQueryable();
var advancedSorting = new List <SortItem <SaleOpportunity> >();
Expression <Func <SaleOpportunity, object> > expression = null;
if (input.Sort.ContainsKey("SaleSeasonType"))
{
expression = o => o.SaleOpportunityTargetPrices.FirstOrDefault().SaleSeasonType.Name;
advancedSorting.Add(new SortItem <SaleOpportunity> {
PropertyName = "SaleOpportunityType", SortExpression = expression, SortOrder = "desc"
});
}
var sorting = new SortingDTO <SaleOpportunity>(input.Sort, advancedSorting);
result.Bag = query.ProcessPagingSort <SaleOpportunity, SaleOpportunityPageQueryCommandOutputDTO>(predicate, input, sorting, o => new SaleOpportunityPageQueryCommandOutputDTO
{
Id = o.Id,
Name = o.Name,
//SaleSeasonTypeId = o.SaleSeasonTypeId,
//SaleSeasonTypeName = o.SaleSeasonType.Name,
CustomerId = o.CustomerId,
CustomerName = o.Customer.Name,
//TargetPrice = o.TargetPrice,
CreatedAt = o.CreatedAt,
});
}
}
catch (Exception ex)
{
result.AddException($"Error getting sale opportunity page query", ex);
}
return(result);
}
public void AndPredicateTest()
{
// Arrange
var predicate = PredicateBuilderExtension.True <Person>();
predicate = predicate.And(x => x.Name.StartsWith("A"));
// Act
var queryResult = Persons.AsQueryable().Where(predicate).ToList();
// Assert
Assert.IsTrue(queryResult.Count == 3);
}
public OperationResponse <PageResult <AppUserPageQueryCommandOutputDTO> > PageQuery(PageQuery <AppUserPageQueryCommandInputDTO> input)
{
var result = new OperationResponse <PageResult <AppUserPageQueryCommandOutputDTO> >();
try
{
// predicate construction
var predicate = PredicateBuilderExtension.True <AppUser>();
if (input.CustomFilter != null)
{
var filter = input.CustomFilter;
if (!string.IsNullOrWhiteSpace(filter.Term))
{
predicate = predicate.And(o => o.UserName.Contains(filter.Term, StringComparison.InvariantCultureIgnoreCase) || o.Email.Contains(filter.Term, StringComparison.InvariantCultureIgnoreCase));
}
}
var dbLocator = this.AmbientDbContextLocator.Get <RiverdaleDBContext>();
{
var query = dbLocator.Set <AppUser>().AsQueryable();
var advancedSorting = new List <SortItem <AppUser> >();
//Expression<Func<AppUser, object>> expression;
//if (input.Sort.ContainsKey("email"))
//{
// expression = o => o.AppUserThirdPartyAppSettings.Where(third => third.ThirdPartyAppTypeId == ThirdPartyAppTypeEnum.BusinessERP).SingleOrDefault().ThirdPartyAppUserId;
// advancedSorting.Add(new SortItem<AppUser> { PropertyName = "erpId", SortExpression = expression, SortOrder = "desc" });
//}
var sorting = new SortingDTO <AppUser>(input.Sort, advancedSorting);
result.Bag = query.ProcessPagingSort <AppUser, AppUserPageQueryCommandOutputDTO>(predicate, input, sorting, o => new AppUserPageQueryCommandOutputDTO
{
Id = o.Id,
UserName = o.UserName,
Email = o.Email,
FirstName = o.FirstName,
LastName = o.LastName
});
return(result);
}
}
catch (Exception ex)
{
result.AddException($"Error getting users", ex);
}
return(result);
}
public OperationResponse <PageResult <CustomerPageQueryCommandOutputDTO> > PageQuery(PageQuery <CustomerPageQueryCommandInputDTO> input)
{
var result = new OperationResponse <PageResult <CustomerPageQueryCommandOutputDTO> >();
try
{
// predicate construction
var predicate = PredicateBuilderExtension.True <Customer>();
if (input.CustomFilter != null)
{
var filter = input.CustomFilter;
if (!string.IsNullOrWhiteSpace(filter.Term))
{
predicate = predicate.And(o => o.Name.Contains(filter.Term, StringComparison.InvariantCultureIgnoreCase));
}
}
var dbLocator = this.AmbientDbContextLocator.Get <RiverdaleDBContext>();
{
var query = dbLocator.Set <Customer>().AsQueryable();
var advancedSorting = new List <SortItem <Customer> >();
Expression <Func <Customer, object> > expression;
if (input.Sort.ContainsKey("erpId"))
{
expression = o => o.CustomerThirdPartyAppSettings.Where(third => third.ThirdPartyAppTypeId == ThirdPartyAppTypeEnum.BusinessERP).SingleOrDefault().ThirdPartyCustomerId;
advancedSorting.Add(new SortItem <Customer> {
PropertyName = "erpId", SortExpression = expression, SortOrder = "desc"
});
}
var sorting = new SortingDTO <Customer>(input.Sort, advancedSorting);
result.Bag = query.ProcessPagingSort <Customer, CustomerPageQueryCommandOutputDTO>(predicate, input, sorting, o => new CustomerPageQueryCommandOutputDTO
{
Id = o.Id,
Name = o.Name,
ERPId = o.CustomerThirdPartyAppSettings.Where(third => third.ThirdPartyAppTypeId == DomainModel._Commons.Enums.ThirdPartyAppTypeEnum.BusinessERP).Select(thid => thid.ThirdPartyCustomerId).FirstOrDefault(),
SalesforceId = o.CustomerThirdPartyAppSettings.Where(third => third.ThirdPartyAppTypeId == DomainModel._Commons.Enums.ThirdPartyAppTypeEnum.Salesforce).Select(thid => thid.ThirdPartyCustomerId).FirstOrDefault(),
CreatedAt = o.CreatedAt
});
}
}
catch (Exception ex)
{
result.AddException($"Error getting customer page query", ex);
}
return(result);
}
public OperationResponse <PageResult <ProductBridgePageQueryCommandOutputDTO> > PageQuery(PageQuery <ProductBridgePageQueryCommandInputDTO> input)
{
var result = new OperationResponse <PageResult <ProductBridgePageQueryCommandOutputDTO> >();
try
{
// predicate construction
var predicate = PredicateBuilderExtension.True <CompositionProductBridge>();
if (input.CustomFilter != null)
{
var filter = input.CustomFilter;
if (!string.IsNullOrWhiteSpace(filter.Term))
{
predicate = predicate.And(o => o.CompositionProduct.Name.Contains(filter.Term, StringComparison.InvariantCultureIgnoreCase));
}
}
var dbLocator = this.AmbientDbContextLocator.Get <RiverdaleDBContext>();
{
var query = dbLocator.Set <CompositionProductBridge>().AsQueryable();
var advancedSorting = new List <SortItem <CompositionProductBridge> >();
Expression <Func <AbstractProduct, object> > expression;
if (input.Sort.ContainsKey("productType"))
{
expression = o => o.ProductType.Name;
advancedSorting.Add(new SortItem <CompositionProductBridge> {
PropertyName = "productType", SortExpression = expression, SortOrder = "desc"
});
}
var sorting = new SortingDTO <CompositionProductBridge>(input.Sort, advancedSorting);
result.Bag = query.ProcessPagingSort <CompositionProductBridge, ProductBridgePageQueryCommandOutputDTO>(predicate, input, sorting, o => new ProductBridgePageQueryCommandOutputDTO
{
Id = o.Id,
ProductId = o.CompositionProductId,
RelatedProductId = o.CompositionItemId,
Stems = o.CompositionItemAmount
});
}
}
catch (Exception ex)
{
result.AddException($"Error getting Product Bridge page query", ex);
}
return(result);
}
public OperationResponse <PageResult <ProductPageQueryCommandOutput> > PageQuery(PageQuery <ProductPageQueryCommandInput> input)
{
var result = new OperationResponse <PageResult <ProductPageQueryCommandOutput> >();
try
{
// predicate construction
var predicate = PredicateBuilderExtension.True <Product>();
if (input.CustomFilter != null)
{
var filter = input.CustomFilter;
if (!string.IsNullOrWhiteSpace(filter.Term))
{
predicate = predicate.And(o => o.ReferenceDescription.Contains(filter.Term, StringComparison.InvariantCultureIgnoreCase));
}
}
var dbLocator = this.AmbientDbContextLocator.Get <FunzaDBContext>();
{
var query = dbLocator.Set <Product>().AsQueryable();
var advancedSorting = new List <SortItem <Product> >();
Expression <Func <Product, object> > expression = null;
//if (input.Sort.ContainsKey("erpId"))
//{
// expression = o => o.CustomerThirdPartyAppSettings.Where(third => third.ThirdPartyAppTypeId == ThirdPartyAppTypeEnum.BusinessERP).SingleOrDefault().ThirdPartyCustomerId;
// advancedSorting.Add(new SortItem<Product> { PropertyName = "erpId", SortExpression = expression, SortOrder = "desc" });
//}
var sorting = new SortingDTO <Product>(input.Sort, advancedSorting);
result.Bag = query.ProcessPagingSort <Product, ProductPageQueryCommandOutput>(predicate, input, sorting, o => new ProductPageQueryCommandOutput
{
Id = o.Id,
Name = o.ReferenceDescription,
CreatedAt = o.CreatedAt
});
}
}
catch (Exception ex)
{
result.AddException($"Error getting customer page query", ex);
}
return(result);
}
public OperationResponse <PageResult <ProductColorTypePageQueryCommandOutputDTO> > PageQuery(PageQuery <ProductColorTypePageQueryCommandInputDTO> input)
{
var result = new OperationResponse <PageResult <ProductColorTypePageQueryCommandOutputDTO> >();
try
{
// predicate construction
var predicate = PredicateBuilderExtension.True <ProductColorType>();
if (input.CustomFilter != null)
{
var filter = input.CustomFilter;
if (!string.IsNullOrWhiteSpace(filter.Term))
{
predicate = predicate.And(o => o.Name.Contains(filter.Term, StringComparison.InvariantCultureIgnoreCase));
}
}
var dbLocator = this.AmbientDbContextLocator.Get <RiverdaleDBContext>();
{
var query = dbLocator.Set <ProductColorType>().AsQueryable();
var advancedSorting = new List <SortItem <ProductColorType> >();
//var advancedSorting = new List<Expression<Func<ProductColorType, object>>>();
//Expression<Func<ProductColorType, object>> expression;
var sorting = new SortingDTO <ProductColorType>(input.Sort, advancedSorting);
result.Bag = query.ProcessPagingSort <ProductColorType, ProductColorTypePageQueryCommandOutputDTO>(predicate, input, sorting, o => new ProductColorTypePageQueryCommandOutputDTO
{
Id = o.Id,
Name = o.Name,
HexCode = o.HexCode,
IsBasicColor = o.IsBasicColor,
});
}
}
catch (Exception ex)
{
result.AddException($"Error getting customer freightout page query", ex);
}
return(result);
}