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());
}