private IQueryable <rent_package> IQRentPackage(List <SortingInfo> sortings = null, FilterInfo filters = null)
{
IQueryable <rent_package> list = context.rent_package;
if (filters != null && (filters.Filters != null && filters.Filters.Count > 0))
{
filters.FormatFieldToUnderscore();
GridHelper.ProcessFilters <rent_package>(filters, ref list);
}
if (sortings != null && sortings.Count > 0)
{
foreach (var s in sortings)
{
s.FormatSortOnToUnderscore();
list = list.OrderBy <rent_package>(s.SortOn + " " + s.SortOrder);
}
}
else
{
list = list.OrderBy <rent_package>("id desc"); //default, wajib ada atau EF error
}
return(list);
}
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 <log> Find(int skip = 0, int?take = null, List <SortingInfo> sortings = null, FilterInfo filters = null)
{
IQueryable <log> atributes = context.log;
if (filters != null && (filters.Filters != null && filters.Filters.Count > 0))
{
filters.FormatFieldToUnderscore();
GridHelper.ProcessFilters <log>(filters, ref atributes);
}
if (sortings != null && sortings.Count > 0)
{
foreach (var s in sortings)
{
string sortOn = this.MapSort(s.SortOn);
atributes = atributes.OrderBy(sortOn + " " + s.SortOrder);
}
}
else
{
atributes = atributes.OrderBy("id desc");
}
var takeActions = atributes;
if (take != null)
{
takeActions = atributes.Skip(skip).Take((int)take);
}
List <log> actionList = takeActions.ToList();
return(actionList);
}
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);
}
public List <Business.Entities.Action> Find(int skip = 0, int?take = null, List <SortingInfo> sortings = null, FilterInfo filters = null, string filterLogic = null)
{
IQueryable <Business.Entities.Action> actions = context.Actions;
if (filters != null && (filters.Filters != null && filters.Filters.Count > 0))
{
filters.FormatFieldToUnderscore();
GridHelper.ProcessFilters <Business.Entities.Action>(filters, ref actions);
}
if (sortings != null && sortings.Count > 0)
{
foreach (var s in sortings)
{
s.FormatSortOnToUnderscore();
actions = actions.OrderBy <Business.Entities.Action>(s.SortOn + " " + s.SortOrder);
}
}
else
{
actions = actions.OrderBy("id desc");
}
var takeActions = actions;
if (take != null)
{
takeActions = actions.Skip(skip).Take((int)take);
}
List <Business.Entities.Action> actionList = takeActions.ToList();
return(actionList);
}
private IQueryable <api_rent> IQApiRent(List <SortingInfo> sortings = null, FilterInfo filters = null)
{
//kamus
IQueryable <api_rent> list = context.api_rent;
string dateParam = null;
FilterInfo copyFilters = null;
//algoritma
if (filters != null)
{
copyFilters = filters.Clone();
}
if (copyFilters != null && (copyFilters.Field != null || copyFilters.Filters != null))
{
copyFilters.FormatFieldToUnderscore();
GridHelper.ProcessFilters <api_rent>(copyFilters, ref list);
}
if (sortings != null && sortings.Count > 0)
{
foreach (var s in sortings)
{
s.FormatSortOnToUnderscore();
list = list.OrderBy <api_rent>(s.SortOn + " " + s.SortOrder);
}
}
else
{
list = list.OrderBy <api_rent>("id desc"); //default, wajib ada atau EF error
}
return(list);
}
private IQueryable <rent_position> IQRentPos(List <SortingInfo> sortings = null, FilterInfo filters = null)
{
//kamus
IQueryable <rent_position> list = context.rent_position;
string dateParam = null;
FilterInfo copyFilters = null;
//algoritma
if (filters != null)
{
copyFilters = filters.Clone();
}
if (copyFilters != null)
{
copyFilters.FormatFieldToUnderscore();
dateParam = copyFilters.RemoveFilterField("filter_date");
GridHelper.ProcessFilters <rent_position>(copyFilters, ref list);
}
//menangani date filter
if (dateParam != null)
{
DateTime dt = DateTime.Parse(dateParam);
dt = DateTime.SpecifyKind(dt, DateTimeKind.Utc);
DateTimeOffset dto = dt;
int diffHours = TimeZoneInfo.Local.BaseUtcOffset.Hours;
int minutes = diffHours * 60;
//list = list.Where(m =>
// dto >= DbFunctions.TruncateTime(DbFunctions.AddMinutes(m.start_rent, minutes)) &&
// DbFunctions.TruncateTime(DbFunctions.AddMinutes(m.finish_rent, minutes)) >= dto);
}
if (sortings != null && sortings.Count > 0)
{
foreach (var s in sortings)
{
s.FormatSortOnToUnderscore();
list = list.OrderBy <rent_position>(s.SortOn + " " + s.SortOrder);
}
}
else
{
list = list.OrderBy <rent_position>("id desc"); //default, wajib ada atau EF error
}
return(list);
}
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 <car> IQCar(List <SortingInfo> sortings = null, FilterInfo filters = null)
{
//kamus
IQueryable <car> list = context.cars;
FilterInfo copyFilters = null;
string sort = "";
List <string> sortArr = new List <string>();
//algoritma
if (filters != null)
{
copyFilters = filters.Clone();
}
if (copyFilters != null && (copyFilters.Field != null || copyFilters.Filters != null))
{
copyFilters.FormatFieldToUnderscore();
GridHelper.ProcessFilters <car>(copyFilters, 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 <car>(sort);
}
else
{
list = list.OrderBy <car>("id desc"); //default, wajib ada atau EF error
}
return(list);
}
/// <summary>
/// ada kemungkinan penanganan datetime with offset disamakan dengan fungsi find all yang 1 lagi
/// filter khusus
/// filter_date: mengambil data rent dengan start <= filter_date <= end
/// without_invoice: mengambil data rent yang belum memiliki invoice
/// include_id: mengambil data rent dengan id = ...
/// </summary>
/// <param name="sortings"></param>
/// <param name="filters"></param>
/// <returns></returns>
private IQueryable <rent> IQRent(List <SortingInfo> sortings = null, FilterInfo filters = null)
{
//kamus
IQueryable <rent> list = context.rents;
string dateParam = null;
string withoutInvoiceParam = null;
string withoutExpenseParam = null;
string idParam = null;
FilterInfo copyFilters = null;
//algoritma
if (filters != null)
{
copyFilters = filters.Clone();
}
if (copyFilters != null && (copyFilters.Field != null || copyFilters.Filters != null))
{
copyFilters.FormatFieldToUnderscore();
dateParam = copyFilters.RemoveFilterField("filter_date");
withoutInvoiceParam = copyFilters.RemoveFilterField("without_invoice");
withoutExpenseParam = copyFilters.RemoveFilterField("without_expense");
idParam = copyFilters.RemoveFilterField("include_id");
GridHelper.ProcessFilters <rent>(copyFilters, ref list);
}
//menangani date filter
if (dateParam != null)
{
DateTime dt = DateTime.Parse(dateParam);
dt = DateTime.SpecifyKind(dt, DateTimeKind.Utc);
DateTimeOffset dto = dt;
int diffHours = TimeZoneInfo.Local.BaseUtcOffset.Hours;
int minutes = diffHours * 60;
list = list.Where(m =>
dto >= DbFunctions.TruncateTime(DbFunctions.AddMinutes(m.start_rent, minutes)) &&
DbFunctions.TruncateTime(DbFunctions.AddMinutes(m.finish_rent, minutes)) >= dto);
}
//menangani without invoice
if (withoutInvoiceParam != null)
{
if (idParam == null)
{
list = list.Where(m => m.invoices.Count() == 0);
}
else
{
list = list.Where(m => m.id == new Guid(idParam) || m.invoices.Count() == 0);
}
}
//menangani without expense
if (withoutExpenseParam != null)
{
if (idParam == null)
{
list = list.Where(m => m.expenses.Count() == 0);
}
else
{
list = list.Where(m => m.id == new Guid(idParam) || m.expenses.Count() == 0);
}
}
if (sortings != null && sortings.Count > 0)
{
foreach (var s in sortings)
{
s.FormatSortOnToUnderscore();
list = list.OrderBy <rent>(s.SortOn + " " + s.SortOrder);
}
}
else
{
list = list.OrderBy <rent>("id desc"); //default, wajib ada atau EF error
}
return(list);
}
