protected override IQueryable <TAggregateRoot> DoGetAll(SortGroup sortGroup = null,
FilterCondition filterCondition = null,
Expression <Func <TAggregateRoot, dynamic> >[] eagerLoadingProperties = null)
{
IQueryable <TAggregateRoot> query = EFContext.Context.Set <TAggregateRoot>();
if (eagerLoadingProperties != null)
{
for (var i = 1; i < eagerLoadingProperties.Length; i++)
{
var eagerLoadingProperty = eagerLoadingProperties[i];
var eagerLoadingPath = GetEagerLoadingPath(eagerLoadingProperty);
query = query.Include(eagerLoadingPath);
}
}
if (filterCondition != null)
{
query = query.Filter(filterCondition);
}
if (sortGroup != null)
{
query = query.Sort(sortGroup);
}
return(query);
}
void AddSortEntry(TrueShadow shadow)
{
var entry = new SortEntry(shadow);
var group = new SortGroup(entry);
var oldIndex = sortGroups.IndexOf(group);
if (oldIndex > -1)
{
sortGroups[oldIndex].Add(entry);
}
else
{
sortGroups.Add(group);
}
}
public static IQueryable Sort(this IQueryable source, SortGroup sortGroup)
{
var parameters = new[] { Expression.Parameter(source.ElementType, "e") };
var orderings = sortGroup.ToDynamicOrderings(source.ElementType, parameters);
var queryExpr = source.Expression;
var methodAsc = "OrderBy";
var methodDesc = "OrderByDescending";
foreach (var ordering in orderings)
{
queryExpr = Expression.Call(typeof(Queryable),
ordering.SortOrder == SortOrder.Ascending ? methodAsc : methodDesc,
new[] { source.ElementType, ordering.Selector.Type },
queryExpr, Expression.Quote(Expression.Lambda(ordering.Selector, parameters)));
methodAsc = "ThenBy";
methodDesc = "ThenByDescending";
}
return(source.Provider.CreateQuery(queryExpr));
}
public async Task <IEnumerable <CategoryDto> > GetCategories(SortGroup sortGroup, FilterCondition filters)
{
var entities = _categoryRepository.GetAll(sortGroup, filters);
return(entities.To <List <CategoryDto> >());
}
public static IQueryable <T> Sort <T>(this IQueryable <T> source, SortGroup sortGroup)
{
return((IQueryable <T>)Sort((IQueryable)source, sortGroup));
}
void EditLabel(int check)
{
if (check == 0)
{
label1.Hide();
label2.Hide();
label3.Hide();
label4.Hide();
label5.Hide();
textBox2.Hide();
textBox3.Hide();
textBox4.Hide();
textBox5.Hide();
textBox6.Hide();
button6.Hide();
DeleteBtn.Hide();
SearchBtn.Hide();
SortName.Hide();
SortGroup.Hide();
SortPoint.Hide();
}
if (check == 1)
{
label1.Show();
label2.Show();
label3.Show();
label4.Show();
label5.Show();
textBox2.Show();
textBox3.Show();
textBox4.Show();
textBox5.Show();
textBox6.Show();
button6.Show();
DeleteBtn.Hide();
SortName.Hide();
SortGroup.Hide();
SortPoint.Hide();
}
if (check == 2)
{
DeleteBtn.Show();
label1.Show();
label2.Hide();
label3.Hide();
label4.Hide();
label5.Hide();
textBox2.Show();
textBox3.Hide();
textBox4.Hide();
textBox5.Hide();
textBox6.Hide();
button6.Hide();
SearchBtn.Hide();
SortName.Hide();
SortGroup.Hide();
SortPoint.Hide();
}
if (check == 3)
{
SearchBtn.Show();
label1.Show();
label2.Hide();
label3.Hide();
label4.Hide();
label5.Hide();
textBox2.Show();
textBox3.Hide();
textBox4.Hide();
textBox5.Hide();
textBox6.Hide();
button6.Hide();
DeleteBtn.Hide();
SortName.Hide();
SortGroup.Hide();
SortPoint.Hide();
}
if (check == 4)
{
SearchBtn.Hide();
label1.Hide();
label2.Hide();
label3.Hide();
label4.Hide();
label5.Hide();
textBox2.Hide();
textBox3.Hide();
textBox4.Hide();
textBox5.Hide();
textBox6.Hide();
button6.Hide();
DeleteBtn.Hide();
SortName.Show();
SortGroup.Show();
SortPoint.Show();
}
}
public IQueryable <TAggregateRoot> GetAll(SortGroup sortGroup = null, FilterCondition filterCondition = null, Expression <Func <TAggregateRoot, dynamic> >[] eagerLoadingProperties = null)
{
return(DoGetAll(sortGroup, filterCondition, eagerLoadingProperties));
}
protected abstract IQueryable <TAggregateRoot> DoGetAll(SortGroup sortGroup = null, FilterCondition filterCondition = null, Expression <Func <TAggregateRoot, dynamic> >[] eagerLoadingProperties = null);
