public IList <T> GetAllLazyLoading(Func <T, object> aOrderFunc, OrderFunctionType aOrderFunctionType, params Expression <Func <T, object> >[] aNavigationProperties)
{
try
{
List <T> _List;
IQueryable <T> _DbQuery = fContext.Set <T>();
foreach (Expression <Func <T, object> > _NavigationProperty in aNavigationProperties)
{
_DbQuery = _DbQuery.Include(_NavigationProperty);
}
_List = aOrderFunctionType == OrderFunctionType.Descending ? _DbQuery.AsNoTracking().OrderByDescending(aOrderFunc).ToList() : _DbQuery.AsNoTracking().OrderBy(aOrderFunc).ToList();
if (fDisposeContextOnEveryAction)
{
fContext.Dispose();
}
return(_List);
}
catch (Exception _Exception)
{
MethodBase _MetodInfo = MethodInfo.GetCurrentMethod();
throw HandleException(_Exception, _MetodInfo);
}
}
public IList <TU> GetListWithSelectLazyLoading <TU>(Func <T, bool> aWhere, int aPage, int aCount, out int aPageCount, Func <T, object> aOrderFunc, Func <T, TU> aSelectFunc,
OrderFunctionType aOrderFunctionType, params Expression <Func <T, object> >[] aNavigationProperties)
{
try
{
List <TU> _List;
IQueryable <T> _DbQuery = fContext.Set <T>();
foreach (Expression <Func <T, object> > _NavigationProperty in aNavigationProperties)
{
_DbQuery = _DbQuery.Include(_NavigationProperty);
}
aPage -= 1;
var _AllItemsCount = _DbQuery.Count(aWhere);
if (_AllItemsCount % aCount == 0)
{
aPageCount = _AllItemsCount / aCount;
}
else
{
aPageCount = _AllItemsCount / aCount + 1;
}
_List = aOrderFunctionType == OrderFunctionType.Descending ? _DbQuery.AsNoTracking().Where(aWhere).OrderByDescending(aOrderFunc).Skip(aPage * aCount).Take(aCount).Select(aSelectFunc).ToList() : _DbQuery.AsNoTracking().Where(aWhere).OrderBy(aOrderFunc).Skip(aPage * aCount).Take(aCount).Select(aSelectFunc).ToList();
if (fDisposeContextOnEveryAction)
{
fContext.Dispose();
}
return(_List);
}
catch (Exception _Exception)
{
MethodBase _MetodInfo = MethodInfo.GetCurrentMethod();
throw HandleException(_Exception, _MetodInfo);
}
}
public IList <TU> GetAllWithSelect <TU>(int aPage, int aCount, out int aPageCount, Func <T, object> aOrderFunc, Func <T, TU> aSelectFunc,
OrderFunctionType aOrderFunctionType)
{
throw new NotImplementedException();
}
public IList <TU> GetAllWithSelect <TU>(Func <T, object> aOrderFunc, Func <T, TU> aSelectFunc, OrderFunctionType aOrderFunctionType) where TU : class
{
throw new NotImplementedException();
}
public IList <T> GetAll(Func <T, object> aOrderFunc, OrderFunctionType aOrderFunctionType)
{
throw new NotImplementedException();
}
public IList <T> GetList(Func <T, bool> aWhere, int aPage, int aCount, out int aPageCount, Func <T, object> aOrderFunc,
OrderFunctionType aOrderFunctionType)
{
throw new NotImplementedException();
}
public IList <TU> GetListWithSelect <TU>(Func <T, bool> aWhere, Func <T, object> aOrderFunc, Func <T, TU> aSelectFunc, OrderFunctionType aOrderFunctionType) where TU : class
{
try
{
List <TU> _List;
fContext.Configuration.LazyLoadingEnabled = false;
IQueryable <T> _DbQuery = fContext.Set <T>();
_List = aOrderFunctionType == OrderFunctionType.Descending ? _DbQuery.AsNoTracking().OrderByDescending(aOrderFunc).Select(aSelectFunc).ToList() : _DbQuery.AsNoTracking().OrderBy(aOrderFunc).Select(aSelectFunc).ToList();
if (fDisposeContextOnEveryAction)
{
fContext.Dispose();
}
return(_List);
}
catch (Exception _Exception)
{
MethodBase _MetodInfo = MethodInfo.GetCurrentMethod();
throw HandleException(_Exception, _MetodInfo);
}
}
