public virtual async Task <IEntityViewModel <TViewModel> > ListViewModel <TViewModel>([FromService] IDatabaseContext database, [FromService] IAuthenticationProvider authenticationProvider, [FromOptions] EntityDomainAuthorizeOption authorizeOption, [FromOptions(true)] EntityQuerySelectOption <T, TViewModel> selectOption)
{
var auth = authenticationProvider.GetAuthentication();
if (authorizeOption == null)
{
authorizeOption = EntityDomainAuthorizeOption.View;
}
authorizeOption.Validate(Metadata, auth);
var context = database.GetContext <T>();
var queryable = context.Query();
var e = new EntityQueryEventArgs <T>(queryable);
await RaiseAsyncEvent(EntityQueryEvent, e);
queryable = e.Queryable;
var convertQueryable = selectOption.Select(queryable);
EntityViewModel <TViewModel> model = new EntityViewModel <TViewModel>(convertQueryable);
EntityPagerOption pagerOption = Context.DomainContext.Options.GetOption <EntityPagerOption>();
if (pagerOption != null)
{
model.CurrentSize = pagerOption.CurrentSize;
model.CurrentPage = pagerOption.CurrentPage;
model.PageSizeOption = pagerOption.PageSizeOption;
}
await model.UpdateTotalPageAsync();
await model.UpdateItemsAsync();
return(model);
}
public virtual async Task <IEntityViewModel <T> > List([FromService] IDatabaseContext database, [FromService] IAuthenticationProvider authenticationProvider, [FromOptions] EntityDomainAuthorizeOption authorizeOption)
{
var auth = authenticationProvider.GetAuthentication();
if (authorizeOption == null)
{
authorizeOption = EntityDomainAuthorizeOption.View;
}
authorizeOption.Validate(Metadata, auth);
var context = database.GetContext <T>();
var queryable = context.Query();
foreach (var propertyMetadata in Metadata.Properties.Where(t => t.CustomType == "Entity"))
{
queryable = context.Include(queryable, propertyMetadata.ClrName);
}
queryable = context.Order(queryable);
if (EntityQuery != null)
{
var e = new EntityQueryEventArgs <T>(queryable);
await EntityQuery(Context, e);
queryable = e.Queryable;
}
EntityViewModel <T> model = new EntityViewModel <T>(queryable);
model.Properties = authorizeOption.GetProperties(Metadata, auth);
model.Items = await context.ToArrayAsync(queryable);
return(model);
}
public virtual async Task <IEntityViewModel <T> > List([FromService] IDatabaseContext database, [FromService] IAuthenticationProvider authenticationProvider, [FromOptions] EntityDomainAuthorizeOption authorizeOption)
{
var auth = authenticationProvider.GetAuthentication();
if (authorizeOption == null)
{
authorizeOption = EntityDomainAuthorizeOption.View;
}
authorizeOption.Validate(Metadata, auth);
var context = database.GetContext <T>();
var queryable = context.Query();
foreach (var propertyMetadata in Metadata.Properties.Where(t => t.CustomType == "Entity"))
{
queryable = context.Include(queryable, propertyMetadata.ClrName);
}
var e = new EntityQueryEventArgs <T>(queryable);
await RaiseAsyncEvent(EntityQueryEvent, e);
queryable = e.Queryable;
if (!e.IsOrdered)
{
queryable = context.Order(queryable);
}
EntityViewModel <T> model = new EntityViewModel <T>(queryable);
model.Properties = authorizeOption.GetProperties(Metadata, auth);
EntityPagerOption pagerOption = Context.DomainContext.Options.GetOption <EntityPagerOption>();
if (pagerOption != null)
{
model.CurrentSize = pagerOption.CurrentSize;
model.CurrentPage = pagerOption.CurrentPage;
model.PageSizeOption = pagerOption.PageSizeOption;
}
await model.UpdateTotalPageAsync();
await model.UpdateItemsAsync();
return(model);
}
private Task Service_EntityQuery(IDomainExecutionContext context, EntityQueryEventArgs <T> e)
{
List <EntitySearchItem> searchItems = new List <EntitySearchItem>();
var valueProvider = context.DomainContext.GetRequiredService <IValueProvider>();
if (!valueProvider.GetValue <bool>("Search"))
{
return(Task.CompletedTask);
}
IQueryable <T> queryable = e.Queryable;
var keys = valueProvider.Keys.Where(t => t.StartsWith("Search.", StringComparison.OrdinalIgnoreCase)).Select(t => t.Substring(7).Split('.')).GroupBy(t => t[0], t => t.Length == 1 ? "" : "." + t[1]).ToArray();
for (int i = 0; i < keys.Length; i++)
{
string propertyName = keys[i].Key;
IPropertyMetadata property = Service.Metadata.SearchProperties.FirstOrDefault(t => t.ClrName.Equals(propertyName, StringComparison.OrdinalIgnoreCase));
if (property == null)
{
continue;
}
EntitySearchItem searchItem = new EntitySearchItem();
string[] options = keys[i].ToArray();
switch (property.Type)
{
case CustomDataType.Date:
case CustomDataType.DateTime:
for (int a = 0; a < options.Length; a++)
{
if (options[a].Equals(".Start", StringComparison.OrdinalIgnoreCase))
{
DateTime start;
if (!DateTime.TryParse(valueProvider.GetValue <string>("Search." + keys[i].Key + options[a]), out start))
{
continue;
}
searchItem.MorethanDate = start;
ParameterExpression parameter = Expression.Parameter(Service.Metadata.Type);
queryable = queryable.Where <T>(Expression.Lambda <Func <T, bool> >(Expression.GreaterThanOrEqual(Expression.Property(parameter, property.ClrName), Expression.Constant(start)), parameter));
}
else if (options[a].Equals(".End", StringComparison.OrdinalIgnoreCase))
{
DateTime end;
if (!DateTime.TryParse(valueProvider.GetValue <string>("Search." + keys[i].Key + options[a]), out end))
{
continue;
}
if (property.Type == CustomDataType.Date)
{
end = end.AddDays(1);
}
searchItem.LessthanDate = end;
ParameterExpression parameter = Expression.Parameter(Service.Metadata.Type);
queryable = queryable.Where <T>(Expression.Lambda <Func <T, bool> >(Expression.LessThanOrEqual(Expression.Property(parameter, property.ClrName), Expression.Constant(end)), parameter));
}
}
break;
case CustomDataType.Boolean:
case CustomDataType.Gender:
if (options[0] == "")
{
bool result;
if (!bool.TryParse(valueProvider.GetValue <string>("Search." + keys[i].Key), out result))
{
continue;
}
searchItem.Equal = result;
ParameterExpression parameter = Expression.Parameter(Service.Metadata.Type);
queryable = queryable.Where <T>(Expression.Lambda <Func <T, bool> >(Expression.Equal(Expression.Property(parameter, property.ClrName), Expression.Constant(result)), parameter));
}
break;
case CustomDataType.Currency:
case CustomDataType.Integer:
case CustomDataType.Number:
for (int a = 0; a < options.Length; a++)
{
if (options[a].Equals(".Start", StringComparison.OrdinalIgnoreCase))
{
object start;
try
{
start = TypeDescriptor.GetConverter(property.ClrType).ConvertFromString(valueProvider.GetValue <string>("Search." + keys[i].Key + options[a]));
}
catch
{
continue;
}
searchItem.Morethan = double.Parse(start.ToString());
ParameterExpression parameter = Expression.Parameter(Service.Metadata.Type);
queryable = queryable.Where <T>(Expression.Lambda <Func <T, bool> >(Expression.GreaterThanOrEqual(Expression.Property(parameter, property.ClrName), Expression.Constant(start)), parameter));
}
else if (options[a].Equals(".End", StringComparison.OrdinalIgnoreCase))
{
object end;
try
{
end = TypeDescriptor.GetConverter(property.ClrType).ConvertFromString(valueProvider.GetValue <string>("Search." + keys[i].Key + options[a]));
}
catch
{
continue;
}
searchItem.Lessthan = double.Parse(end.ToString());
ParameterExpression parameter = Expression.Parameter(Service.Metadata.Type);
queryable = queryable.Where <T>(Expression.Lambda <Func <T, bool> >(Expression.LessThanOrEqual(Expression.Property(parameter, property.ClrName), Expression.Constant(end)), parameter));
}
}
break;
case CustomDataType.Other:
if (property.CustomType == "Enum")
{
object result;
try
{
result = Enum.Parse(property.ClrType, valueProvider.GetValue <string>("Search." + keys[i].Key));
}
catch
{
continue;
}
searchItem.Enum = new EnumConverter(property.ClrType).ConvertToString(result);
ParameterExpression parameter = Expression.Parameter(Service.Metadata.Type);
queryable = queryable.Where <T>(Expression.Lambda <Func <T, bool> >(Expression.Equal(Expression.Property(parameter, property.ClrName), Expression.Constant(result)), parameter));
}
else if (property.CustomType == "Entity")
{
searchItem.Contains = valueProvider.GetValue <string>("Search." + keys[i].Key);
if (searchItem.Contains == null)
{
continue;
}
var isId = valueProvider.GetValue <bool?>("Search." + keys[i].Key + ".Id");
ParameterExpression parameter = Expression.Parameter(Service.Metadata.Type);
if (isId.HasValue && isId.Value)
{
var keyProperty = EntityDescriptor.GetMetadata(property.ClrType).KeyProperty;
var id = keyProperty.Converter.ConvertFrom(searchItem.Contains);
Expression expression = Expression.Property(Expression.Property(parameter, property.ClrName), keyProperty.ClrName);
expression = Expression.Equal(expression, Expression.Constant(id));
queryable = queryable.Where <T>(Expression.Lambda <Func <T, bool> >(expression, parameter));
}
else
{
Expression expression = Expression.Property(Expression.Property(parameter, property.ClrName), EntityDescriptor.GetMetadata(property.ClrType).DisplayProperty.ClrName);
expression = Expression.Call(expression, typeof(string).GetMethod("Contains", new Type[] { typeof(string) }), Expression.Constant(searchItem.Contains));
queryable = queryable.Where <T>(Expression.Lambda <Func <T, bool> >(expression, parameter));
}
}
else if (property.ClrType == typeof(string))
{
searchItem.Contains = valueProvider.GetValue <string>("Search." + keys[i].Key);
if (searchItem.Contains == null)
{
continue;
}
ParameterExpression parameter = Expression.Parameter(Service.Metadata.Type);
Expression expression = Expression.Property(parameter, property.ClrName);
expression = Expression.Call(expression, typeof(string).GetMethod("Contains", new Type[] { typeof(string) }), Expression.Constant(searchItem.Contains));
queryable = queryable.Where <T>(Expression.Lambda <Func <T, bool> >(expression, parameter));
}
break;
default:
if (property.ClrType == typeof(string))
{
searchItem.Contains = valueProvider.GetValue <string>("Search." + keys[i].Key);
if (searchItem.Contains == null)
{
continue;
}
ParameterExpression parameter = Expression.Parameter(Service.Metadata.Type);
Expression expression = Expression.Property(parameter, property.ClrName);
expression = Expression.Call(expression, typeof(string).GetMethod("Contains", new Type[] { typeof(string) }), Expression.Constant(searchItem.Contains));
queryable = queryable.Where <T>(Expression.Lambda <Func <T, bool> >(expression, parameter));
}
break;
}
if (searchItem.Contains != null || searchItem.Enum != null || searchItem.Equal.HasValue || searchItem.Lessthan.HasValue || searchItem.LessthanDate.HasValue || searchItem.Morethan.HasValue || searchItem.MorethanDate.HasValue)
{
searchItem.Name = property.Name;
}
if (searchItem.Name != null)
{
searchItems.Add(searchItem);
}
e.Queryable = queryable;
}
context.DomainContext.DataBag.SearchItem = searchItems.ToArray();
return(Task.CompletedTask);
}
