public RentalRepository(PropertyRentalContext context)
{
this.context = context;
}
private async Task <IQueryable <Tenant> > FilteredRequired(IQueryable <Tenant> query, TenantQuery queryObject, PropertyRentalContext context)
{
if (queryObject.Available.HasValue && queryObject.Available == true)
{
var unavailableTenants = new List <int>();
var rentals = await context.Rentals.Include(rental => rental.Tenant).ToListAsync();
foreach (var rental in rentals)
{
unavailableTenants.Add(rental.Tenant.Id);
}
query = query.Where(tenant => !unavailableTenants.Any(unavailableTenantId => unavailableTenantId == tenant.Id));
}
return(query);
}
public StatesController(PropertyRentalContext context, IMapper mapper)
{
this.context = context;
this.mapper = mapper;
}
private IQueryable <Suburb> FilteredRequired(IQueryable <Suburb> query, SuburbQuery queryObject, PropertyRentalContext context)
{
if (!String.IsNullOrWhiteSpace(queryObject.Postcode))
{
query = query.Where(suburb => suburb.Postcode == queryObject.Postcode);
}
if (queryObject.StateId.HasValue)
{
query = query.Where(suburb => suburb.StateId == queryObject.StateId);
}
return(query);
}
