public IEnumerable <RentalItem> All(RentalItemIncludes includes)
{
var query = Context.Set <RentalItem>().AsQueryable(); //It needs to be a queryable to be able to build the expression
query = AddIncludes(query, includes);
return(query.AsEnumerable());
}
public IList <RentalItem> All(RentalItemIncludes includes)
{
using (var unitOfWork = new UnitOfWork())
{
return(unitOfWork.RentalItems.All(includes).ToList());
}
}
public RentalItem Get(int id, RentalItemIncludes includes)
{
using (var unitOfWork = new UnitOfWork())
{
return(unitOfWork.RentalItems.Get(id, includes));
}
}
public RentalItem Get(int id, RentalItemIncludes includes)
{
var query = Context.Set <RentalItem>().AsQueryable(); //It needs to be a queryable to be able to build the expression
query = AddIncludes(query, includes);
query = query.Where(i => i.Id == id); //Add the where clause
return(query.FirstOrDefault());
}
public IList <RentalItem> GetRentedRentalItems(int userId, RentalItemIncludes includes)
{
using (var unitOfWork = new UnitOfWork())
{
return(unitOfWork.RentalItems.Find(ri => ri.Status == RentalItemStatus.Normal &&
ri.RentalOrderLines.Any(rol => !rol.ReturnedAt.HasValue && rol.RentalOrder.UserId == userId), includes).ToList());
}
}
public IList <RentalItem> GetAvailableRentalItems(RentalItemIncludes includes)
{
using (var unitOfWork = new UnitOfWork())
{
return(unitOfWork.RentalItems.Find(ri => ri.Status == RentalItemStatus.Normal &&
ri.RentalOrderLines.All(rol => rol.ReturnedAt.HasValue), includes).ToList());
}
}
private IQueryable <RentalItem> AddIncludes(IQueryable <RentalItem> query, RentalItemIncludes includes)
{
if (includes == null)
{
return(query);
}
if (includes.Item)
{
query = query.Include(i => i.Item);
}
return(query);
}
public IList <RentalItem> All(RentalItemIncludes includes)
{
try
{
using (var unitOfWork = unitOfWorkFactory.CreateInstance())
{
return(unitOfWork.RentalItems.All(includes).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public RentalItem Get(int id, RentalItemIncludes includes)
{
try
{
using (var unitOfWork = unitOfWorkFactory.CreateInstance())
{
return(unitOfWork.RentalItems.Get(id, includes));
}
}
catch (Exception ex)
{
throw ex;
}
}
public IList <RentalItem> GetRentedRentalItems(int userId, RentalItemIncludes includes)
{
try
{
using (var unitOfWork = unitOfWorkFactory.CreateInstance())
{
return(unitOfWork.RentalItems.Find(ri => ri.Status == RentalItemStatus.Rented &&
ri.RentalOrderLines.Any(rol => !rol.ReturnedAt.HasValue && rol.RentalOrder.UserId == userId), includes).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public IList <RentalItem> GetAvailableRentalItems(RentalItemIncludes includes)
{
try
{
using (var unitOfWork = unitOfWorkFactory.CreateInstance())
{
return(unitOfWork.RentalItems.Find(ri => ri.Status == RentalItemStatus.Normal &&
ri.RentalOrderLines.All(rol => rol.ReturnedAt.HasValue), includes).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <RentalItem> Find(Expression <Func <RentalItem, bool> > predicate, RentalItemIncludes includes)
{
var query = Context.Set <RentalItem>().AsQueryable(); //It needs to be a queryable to be able to build the expression
query = AddIncludes(query, includes);
return(query.Where(predicate).AsEnumerable()); //Add the where clause and return IEnumerable<RentalItem>
}
