public static IList <TEntity> GetAllActiveSorted <TEntity>(this IPagingDbContextRepository <TEntity> repository, int?optionalId = null)
where TEntity : BaseEntityWithIntKey, IIsActive, INamedEntity, new()
{
using (var tran = repository.GetTransaction())
{
IQueryable <TEntity> query = tran.Set <TEntity>();
if (optionalId.HasValue)
{
query = query.Where(x => x.IsActive || x.Id == optionalId.Value);
}
else
{
query = query.Where(x => x.IsActive);
}
query = query.OrderBy(x => x.Name);
var results = query.ToList();
tran.CommitIfOwner();
return(results);
}
}
public static IList <TEntity> GetAllSorted <TEntity>(this IPagingDbContextRepository <TEntity> repository)
where TEntity : class, INamedEntity
{
using (var tran = repository.GetTransaction())
{
var results = tran.Set <TEntity>()
.OrderBy(x => x.Name)
.ToList();
tran.CommitIfOwner();
return(results);
}
}
public static IList <TEntity> GetAllActive <TEntity>(this IPagingDbContextRepository <TEntity> repository)
where TEntity : class, IIsActive
{
using (var tran = repository.GetTransaction())
{
IQueryable <TEntity> query = tran.Set <TEntity>()
.Where(x => x.IsActive);
var results = query.ToList();
tran.CommitIfOwner();
return(results);
}
}
public static bool DoesEntityExistById <TEntity>(this IPagingDbContextRepository <TEntity> repository, object id)
where TEntity : class
{
using (var tran = repository.GetTransaction())
{
var entity = tran.Set <TEntity>().Find(id);
var exists = entity != null;
if (exists)
{
var entry = tran.Context.Entry(entity);
if (entry.State == EntityState.Unchanged)
{
entry.State = EntityState.Detached;
}
}
tran.CommitIfOwner();
return(exists);
}
}
