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;
}
