public List<Module> Find(int skip = 0, int? take = null, List<SortingInfo> sortings = null, FilterInfo filters = null, string filterLogic = null) { IQueryable<Module> modules = context.Modules; if (filters != null && (filters.Filters != null && filters.Filters.Count > 0)) { filters.FormatFieldToUnderscore(); GridHelper.ProcessFilters<Business.Entities.Module>(filters, ref modules); } if (sortings != null && sortings.Count > 0) { foreach (var s in sortings) { string sortOn = this.MapSort(s.SortOn); modules = modules.OrderBy(sortOn + " " + s.SortOrder); } } else { modules = modules.OrderBy("ModuleName asc"); } var takeModules = modules; if (take != null) { takeModules = modules.Skip(skip).Take((int)take); } List<Module> moduleList = takeModules.ToList(); return moduleList; }
public List<Crew_Whitelist> FindAll(int? skip = null, int? take = null, List<SortingInfo> sortings = null, FilterInfo filters = null) { IQueryable<Crew_Whitelist> list = context.Crew_Whitelist; if (filters != null && (filters.Filters != null && filters.Filters.Count > 0)) { filters.FormatFieldToUnderscore(); GridHelper.ProcessFilters<Crew_Whitelist>(filters, ref list); } if (sortings != null && sortings.Count > 0) { foreach (var s in sortings) { s.FormatSortOnToUnderscore(); list = list.OrderBy<Crew_Whitelist>(s.SortOn + " " + s.SortOrder); } } else { list = list.OrderBy<Crew_Whitelist>("id desc"); //default, wajib ada atau EF error } //take & skip var takeList = list; if (skip != null) { takeList = takeList.Skip(skip.Value); } if (take != null) { takeList = takeList.Take(take.Value); } //return result //var sql = takeList.ToString(); List<Crew_Whitelist> result = takeList.ToList(); return result; }
/// <summary> /// </summary> /// <param name="skip"></param> /// <param name="take"></param> /// <param name="sortings"></param> /// <param name="filters"></param> /// <returns></returns> public List<log> Find(int? skip = null, int? take = null, List<SortingInfo> sortings = null, FilterInfo filters = null) { IQueryable<log> list = context.logs; if (filters != null && ((filters.Filters != null && filters.Filters.Count > 0) || (filters.Operator != null && filters.Operator != ""))) { filters.FormatFieldToUnderscore(); GridHelper.ProcessFilters<log>(filters, ref list); } if (sortings != null && sortings.Count > 0) { GridHelper.ProcessSorts<log>(sortings, ref list); } else { list = list.OrderByDescending(m => m.id); //default, wajib ada atau EF error } //filter //list = list.Where(i => i.show == 1); //take & skip var takeList = list; if (skip != null) { takeList = takeList.Skip(skip.Value); } if (take != null) { takeList = takeList.Take(take.Value); } //return result List<log> result = takeList.ToList(); return result; }
private IQueryable<currency> IQCurrency(List<SortingInfo> sortings = null, FilterInfo filters = null) { //kamus IQueryable<currency> list = context.currency; string sort = ""; List<string> sortArr = new List<string>(); //algoritma if (filters != null) { filters.FormatFieldToUnderscore(); GridHelper.ProcessFilters<currency>(filters, ref list); } if (sortings != null && sortings.Count > 0) { foreach (var s in sortings) { s.FormatSortOnToUnderscore(); sortArr.Add(s.SortOn + " " + s.SortOrder); } sort = string.Join(",", sortArr); list = list.OrderBy<currency>(sort); } else { list = list.OrderByDescending(m => m.id); //default, wajib ada atau EF error } list = list.Where(i => i.is_delete == false); return list; }