/// <summary>
/// Gets all.
/// </summary>
/// <param name="page">The page.</param>
/// <param name="pageSize">Size of the page.</param>
/// <param name="includeDeleted">The include deleted.</param>
/// <param name="totalCount">The total count.</param>
/// <returns></returns>
public IEnumerable <TI> GetAll(int?page, int?pageSize, bool?includeDeleted, out long totalCount)
{
using (var pc = PersistenceHelper.CreatePersistenceContext())
{
var resultSet = BaseObject <T> .Queryable;
if (!page.HasValue)
{
page = 0;
}
if (!pageSize.HasValue)
{
pageSize = 10;
}
if (includeDeleted.HasValue && !includeDeleted.Value)
{
resultSet = resultSet.Where(o => !o.IsDeleted);
}
totalCount = resultSet.Count();
if (page.Value >= 0 && pageSize.Value >= 0)
{
return((IEnumerable <TI>)resultSet.Skip(page.Value * pageSize.Value).Take(pageSize.Value));
}
else
{
return((IEnumerable <TI>)resultSet);
}
}
}
/// <summary>
/// Gets the by id.
/// </summary>
/// <param name="id">The id.</param>
/// <returns></returns>
public TI GetById(long id)
{
using (var pc = PersistenceHelper.CreatePersistenceContext())
{
return((TI)((IBaseObject)BaseObject <T> .FindById(id)));
}
}
/// <summary>
/// Creates the specified base object interface.
/// </summary>
/// <param name="baseObjectInterface">The base object interface.</param>
/// <returns></returns>
public TI CreateOrUpdate(TI baseObjectInterface)
{
BaseObject <T> savedObject = null;
using (var pc = PersistenceHelper.CreatePersistenceContext())
{
T baseObject = AutoMapper.Mapper.Map <TI, T>(baseObjectInterface);
savedObject = baseObject.Merge();
}
return((TI)((IBaseObject)savedObject));
}
/// <summary>
/// Deletes the physically.
/// </summary>
/// <param name="baseObjectInterface">The base object interface.</param>
/// <returns></returns>
public TI DeletePhysically(TI baseObjectInterface)
{
BaseObject <T> savedObject = null;
using (var pc = PersistenceHelper.CreatePersistenceContext())
{
savedObject = BaseObject <T> .FindById(baseObjectInterface.Id);
savedObject.Delete();
}
return((TI)((IBaseObject)savedObject));
}
public IEnumerable <TI> GetAll(int?page, int?pageSize, bool?includeDeleted, IDictionary <Func <IBaseObject, IComparable>, SortOrder> sortProperties, out long totalCount)
{
totalCount = 0;
using (var pc = PersistenceHelper.CreatePersistenceContext())
{
IQueryable <T> resultSet = BaseObject <T> .Queryable;
if (!page.HasValue)
{
page = 0;
}
if (!pageSize.HasValue)
{
pageSize = 10;
}
if (includeDeleted.HasValue && !includeDeleted.Value)
{
resultSet = resultSet.Where(o => !o.IsDeleted);
}
if (sortProperties.Any())
{
IOrderedQueryable <T> sortedResultSet = null;
KeyValuePair <Func <IBaseObject, IComparable>, SortOrder> firstCriteria = sortProperties.FirstOrDefault();
if (firstCriteria.Key != null)
{
if (firstCriteria.Value == SortOrder.Ascending)
{
sortedResultSet = resultSet.OrderBy(element => firstCriteria.Key(element));
}
else if (firstCriteria.Value == SortOrder.Descending)
{
sortedResultSet = resultSet.OrderByDescending(element => firstCriteria.Key(element));
}
if (sortedResultSet != null && sortProperties.Count > 1)
{
for (int i = 1; i < sortProperties.Count; i++)
{
var sortProperty = sortProperties.ElementAt(i);
if (sortProperty.Value == SortOrder.Ascending)
{
sortedResultSet = sortedResultSet.ThenBy(element => sortProperty.Key(element));
}
else if (sortProperty.Value == SortOrder.Descending)
{
sortedResultSet = sortedResultSet.ThenByDescending(element => sortProperty.Key(element));
}
}
}
resultSet = sortedResultSet;
}
}
if (resultSet != null)
{
totalCount = resultSet.Count();
return((IEnumerable <TI>)resultSet.Skip(page.Value * pageSize.Value).Take(pageSize.Value));
}
return(null);
}
}