public override async Task <IPagedResults <TModel> > ToList()
{
var builder = new LabelQueryBuilder <TModel>(this);
var populateSql = builder.BuildSqlPopulate();
var countSql = builder.BuildSqlCount();
var keywords = Params.Keywords.Value ?? string.Empty;
return(await _store.SelectAsync(new[]
{
new DbParam("PageIndex", DbType.Int32, PageIndex),
new DbParam("PageSize", DbType.Int32, PageSize),
new DbParam("SqlPopulate", DbType.String, populateSql),
new DbParam("SqlCount", DbType.String, countSql),
new DbParam("Keywords", DbType.String, keywords)
}));
}
public override async Task <IPagedResults <UserReputation> > ToList()
{
var builder = new UserReputationsQueryBuilder(this);
var populateSql = builder.BuildSqlPopulate();
var countSql = builder.BuildSqlCount();
var keywords = Params?.Keywords?.Value ?? string.Empty;
return(await _store.SelectAsync(new IDbDataParameter[]
{
new DbParam("PageIndex", DbType.Int32, PageIndex),
new DbParam("PageSize", DbType.Int32, PageSize),
new DbParam("SqlPopulate", DbType.String, populateSql),
new DbParam("SqlCount", DbType.String, countSql),
new DbParam("Keywords", DbType.String, keywords)
}));
}
public override async Task <IPagedResults <CategoryData> > ToList()
{
var builder = new CategoryDataQueryBuilder(this);
var populateSql = builder.BuildSqlPopulate();
var countSql = builder.BuildSqlCount();
var key = Params.Key.Value ?? string.Empty;
return(await _store.SelectAsync(new IDbDataParameter[]
{
new DbParam("PageIndex", DbType.Int32, PageIndex),
new DbParam("PageSize", DbType.Int32, PageSize),
new DbParam("SqlPopulate", DbType.String, populateSql),
new DbParam("SqlCount", DbType.String, countSql),
new DbParam("Key", DbType.String, 255, key)
}));
}
public override async Task <IPagedResults <EntityUser> > ToList()
{
var builder = new EntityUserQueryBuilder(this);
var populateSql = builder.BuildSqlPopulate();
var countSql = builder.BuildSqlCount();
var username = Params?.Username.Value ?? string.Empty;
return(await _store.SelectAsync(new[]
{
new DbParam("PageIndex", DbType.Int32, PageIndex),
new DbParam("PageSize", DbType.Int32, PageSize),
new DbParam("SqlPopulate", DbType.String, populateSql),
new DbParam("SqlCount", DbType.String, countSql),
new DbParam("Keywords", DbType.String, username)
}));
}
public override async Task <IPagedResults <TModel> > ToList()
{
Builder = new SimpleEntityQueryBuilder <TModel>(this);
var populateSql = Builder.BuildSqlPopulate();
var countSql = Builder.BuildSqlCount();
var keywords = Params?.Keywords.Value.ToEmptyIfNull() ?? string.Empty;
return(await _store.SelectAsync(new IDbDataParameter[]
{
new DbParam("PageIndex", DbType.Int32, PageIndex),
new DbParam("PageSize", DbType.Int32, PageSize),
new DbParam("SqlPopulate", DbType.String, populateSql),
new DbParam("SqlCount", DbType.String, countSql),
new DbParam("Keywords", DbType.String, keywords)
}));
}
public override async Task <IPagedResults <Models.Follow> > ToList()
{
var builder = new FollowQueryBuilder(this);
var populateSql = builder.BuildSqlPopulate();
var countSql = builder.BuildSqlCount();
var name = Params.Name.Value ?? string.Empty;
return(await _store.SelectAsync(
new IDbDataParameter[]
{
new DbParam("PageIndex", DbType.Int32, PageIndex),
new DbParam("PageSize", DbType.Int32, PageSize),
new DbParam("SqlPopulate", DbType.String, populateSql),
new DbParam("SqlCount", DbType.String, countSql),
new DbParam("Name", DbType.String, name)
}));
}
public override async Task <IPagedResults <UserLogin> > ToList()
{
var builder = new UserLoginQueryBuilder(this);
var populateSql = builder.BuildSqlPopulate();
var countSql = builder.BuildSqlCount();
var loginProvider = Params.LoginProvider.Value ?? string.Empty;
var providerKey = Params.ProviderKey.Value ?? string.Empty;
return(await _store.SelectAsync(new IDbDataParameter[]
{
new DbParam("PageIndex", DbType.Int32, PageIndex),
new DbParam("PageSize", DbType.Int32, PageSize),
new DbParam("SqlPopulate", DbType.String, populateSql),
new DbParam("SqlCount", DbType.String, countSql),
new DbParam("LoginProvider", DbType.String, loginProvider),
new DbParam("ProviderKey", DbType.String, providerKey)
}));
}
public override async Task <IPagedResults <EntityLabel> > ToList()
{
var builder = new EntityLabelQueryBuilder(this);
var populateSql = builder.BuildSqlPopulate();
var countSql = builder.BuildSqlCount();
var labelId = Params.LabelId.Value;
var entityId = Params.EntityId.Value;
return(await _store.SelectAsync(new[]
{
new DbParam("PageIndex", DbType.Int32, PageIndex),
new DbParam("PageSize", DbType.Int32, PageSize),
new DbParam("SqlPopulate", DbType.String, populateSql),
new DbParam("SqlCount", DbType.String, countSql),
new DbParam("LabelId", DbType.Int32, labelId),
new DbParam("EntityId", DbType.Int32, entityId)
}));
}
public override async Task <IPagedResults <ShellFeature> > ToList()
{
var builder = new ShellFeatureQueryBuilder(this);
var populateSql = builder.BuildSqlPopulate();
var countSql = builder.BuildSqlCount();
var id = Params?.Id.Value;
var moduleId = Params?.ModuleId?.Value ?? string.Empty;
return(await _store.SelectAsync(new IDbDataParameter[]
{
new DbParam("PageIndex", DbType.Int32, PageIndex),
new DbParam("PageSize", DbType.Int32, PageSize),
new DbParam("SqlPopulate", DbType.String, populateSql),
new DbParam("SqlCount", DbType.String, countSql),
new DbParam("Id", DbType.Int32, id),
new DbParam("ModuleId", DbType.String, 255, moduleId)
}));
}
public override async Task <IPagedResults <Models.Attachment> > ToList()
{
var builder = new AttachmentQueryBuilder(this);
var populateSql = builder.BuildSqlPopulate();
var countSql = builder.BuildSqlCount();
var contentGuid = Params.ContentGuid.Value ?? string.Empty;
var contentCheckSum = Params.ContentCheckSum.Value ?? string.Empty;
var keywords = Params.Keywords.Value ?? string.Empty;
return(await _store.SelectAsync(new IDbDataParameter[]
{
new DbParam("PageIndex", DbType.Int32, PageIndex),
new DbParam("PageSize", DbType.Int32, PageSize),
new DbParam("SqlPopulate", DbType.String, populateSql),
new DbParam("SqlCount", DbType.String, countSql),
new DbParam("ContentGuid", DbType.String, 32, contentGuid),
new DbParam("ContentCheckSum", DbType.String, 32, contentCheckSum),
new DbParam("Keywords", DbType.String, keywords)
}));
}
public override async Task <IPagedResults <EntityMetric> > ToList()
{
var builder = new EntityMetricQueryBuilder(this);
var populateSql = builder.BuildSqlPopulate();
var countSql = builder.BuildSqlCount();
var ipV4Address = Params.IpV4Address.Value ?? string.Empty;
var iopV6Address = Params.IpV6Address.Value ?? string.Empty;
var userAgent = Params.UserAgent.Value ?? string.Empty;
return(await _store.SelectAsync(new[]
{
new DbParam("PageIndex", DbType.Int32, PageIndex),
new DbParam("PageSize", DbType.Int32, PageSize),
new DbParam("SqlPopulate", DbType.String, populateSql),
new DbParam("SqlCount", DbType.String, countSql),
new DbParam("IpV4Address", DbType.String, ipV4Address),
new DbParam("IopV6Address", DbType.String, iopV6Address),
new DbParam("UserAgent", DbType.String, userAgent)
}));
}
public override async Task <IPagedResults <Models.SignUp> > ToList()
{
var builder = new SignUpQueryBuilder(this);
var populateSql = builder.BuildSqlPopulate();
var countSql = builder.BuildSqlCount();
var email = Params.Email.Value ?? string.Empty;
var companyName = Params.CompanyName.Value ?? string.Empty;
var companyNameAlias = Params.CompanyNameAlias.Value ?? string.Empty;
return(await _store.SelectAsync(new[]
{
new DbParam("PageIndex", DbType.Int32, PageIndex),
new DbParam("PageSize", DbType.Int32, PageSize),
new DbParam("SqlPopulate", DbType.String, populateSql),
new DbParam("SqlCount", DbType.String, countSql),
new DbParam("Email", DbType.String, email),
new DbParam("CompanyName", DbType.String, companyName),
new DbParam("CompanyNameAlias", DbType.String, companyNameAlias)
}));
}
