public IQueryable <Badge> Execute(IQueryableProvider queryableProvider) { var baseQuery = queryableProvider.Query <Badge>(); if (IncludeApp) { baseQuery = baseQuery.Include(i => i.App); } if (IncludeStage) { baseQuery = baseQuery.Include(i => i.Stage); } if (_id.HasValue) { baseQuery = baseQuery.Where(w => w.Id == _id); } if (_appId.HasValue) { baseQuery = baseQuery.Where(w => w.AppId == _appId && w.StageId == _stageId); } return(baseQuery.AsQueryable()); }
public IQueryable <Stage> Execute(IQueryableProvider queryableProvider) { var baseQuery = queryableProvider .Query <Stage>() .Where(w => w.OrganisationId == _orgId) .OrderBy(o => o.OrderBy); //defined sort order return(baseQuery.AsQueryable()); }
public IQueryable <App> Execute(IQueryableProvider queryableProvider) { var baseQuery = queryableProvider .Query <App>() .Where(w => w.OrganisationId == _orgId) .OrderBy(o => o.Name); return(baseQuery.AsQueryable()); }
public IQueryable <OrganisationKey> Execute(IQueryableProvider queryableProvider) { var baseQuery = queryableProvider.Query <OrganisationKey>() .Where(w => w.Id == _id); if (_includeOrganisation) { baseQuery = baseQuery.Include(i => i.Organisation); } return(baseQuery.AsQueryable()); }
public IQueryable <App> Execute(IQueryableProvider queryableProvider) { var baseQuery = queryableProvider.Query <App>(); if (_id.HasValue) { baseQuery = baseQuery.Where(w => w.Id == _id); } if (!string.IsNullOrWhiteSpace(_name)) { baseQuery = baseQuery.Where(w => w.OrganisationId == _orgId && w.Name == _name); } return(baseQuery.AsQueryable()); }
public IQueryable <Member> Execute(IQueryableProvider queryableProvider) { //validate query data if (!_organisationId.HasValue && string.IsNullOrWhiteSpace(_email)) { throw new ThisAppException(StatusCodes.Status417ExpectationFailed, Messages.Err417MissingObjectData("Member information")); } var baseQuery = queryableProvider.Query <Member>() .Where(w => w.OrganisationId == _organisationId); if (!string.IsNullOrWhiteSpace(_email)) { baseQuery = baseQuery.Where(w => w.Email == _email); } return(baseQuery.AsQueryable()); }
public IQueryable <Organisation> Execute(IQueryableProvider queryableProvider) { DoValidations(); var baseQuery = queryableProvider.Query <Organisation>(); if (_id.HasValue) { baseQuery = baseQuery.Where(w => w.Id == _id); } if (!string.IsNullOrWhiteSpace(_name) & !string.IsNullOrWhiteSpace(_masterEmail)) { baseQuery = baseQuery.Where(w => w.Name == _name && w.MasterEmail == _masterEmail); } return(baseQuery.AsQueryable()); }
public IQueryable <Member> Execute(IQueryableProvider queryableProvider) { if (!_id.HasValue && !_orgId.HasValue) { throw new ThisAppException(StatusCodes.Status412PreconditionFailed, Messages.Err417MissingObjectData("")); } var baseQuery = queryableProvider.Query <Member>(); if (_id.HasValue) { baseQuery = baseQuery.Where(w => w.Id == _id.Value); } if (_orgId.HasValue) { baseQuery = baseQuery.Where(w => w.OrganisationId == _orgId.Value && w.Email == _email); } return(baseQuery.AsQueryable()); }
public IQueryable <OrganisationKey> Execute(IQueryableProvider queryableProvider) { //validate query data if (!_organisationId.HasValue && _data == null) { throw new ThisAppException(StatusCodes.Status417ExpectationFailed, Messages.Err417MissingObjectData("Private Key information")); } var baseQuery = queryableProvider.Query <OrganisationKey>() .Where(w => w.OrganisationId == _organisationId); if (_data != null) { baseQuery = baseQuery.Where ( w => w.Description == _data.Description && w.ExpiryDate == _data.ExpiryDate && w.PrivateKey == _data.PrivateKey ); } return(baseQuery.AsQueryable()); }