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> }