private static IQueryable <JGN_Attr_Templates> processOptionalConditions(IQueryable <JGN_Attr_Templates> collectionQuery, AttrTemplateEntity query) { if (query.order != "") { collectionQuery = (IQueryable <JGN_Attr_Templates>)collectionQuery.Sort(query.order); } // skip logic if (query.pagenumber > 1) { collectionQuery = collectionQuery.Skip(query.pagesize * (query.pagenumber - 1)); } // take logic if (!query.loadall) { collectionQuery = collectionQuery.Take(query.pagesize); } return(collectionQuery); }
public static Task <List <JGN_Attr_Templates> > LoadItems(ApplicationDbContext context, AttrTemplateEntity entity) { var collectionQuery = context.JGN_Attr_Templates.Where(returnWhereClause(entity)); collectionQuery = processOptionalConditions(collectionQuery, entity); return(LoadCompleteList(collectionQuery)); }
public static int Count(ApplicationDbContext context, AttrTemplateEntity entity) { return(context.JGN_Attr_Templates.Where(returnWhereClause(entity)).Count()); }
private static System.Linq.Expressions.Expression <Func <JGN_Attr_Templates, bool> > returnWhereClause(AttrTemplateEntity entity) { var where_clause = PredicateBuilder.New <JGN_Attr_Templates>(true); where_clause = where_clause.And(p => p.attr_type == (byte)entity.attr_type); if (entity.excludedid > 0) { where_clause = where_clause.And(p => p.id != entity.excludedid); } if (entity.id > 0) { where_clause = where_clause.And(p => p.id == entity.id); } if (entity.nofilter) { if (entity.term != "") { where_clause = where_clause.And(p => p.title.Contains(entity.term)); } } return(where_clause); }