public Limit ( DatabaseType type, int limit, int offset, string orderBy ) : |
||
type | DatabaseType | |
limit | int | |
offset | int | |
orderBy | string | |
return |
public static async Task<DTO.Configuration> GetDefaultConfigurationAsync(string tenant) { using (var db = DbProvider.Get(FrapidDbServer.GetConnectionString(tenant), tenant).GetDatabase()) { var sql = new Sql("SELECT * FROM website.configurations"); sql.Where("is_default=@0", true); sql.Limit(db.DatabaseType, 1, 0, "configuration_id"); var awaiter = await db.SelectAsync<DTO.Configuration>(sql).ConfigureAwait(false); return awaiter.FirstOrDefault(); } }
public static async Task<User> GetAsync(string tenant, string email) { using (var db = DbProvider.Get(FrapidDbServer.GetConnectionString(tenant), tenant).GetDatabase()) { var sql = new Sql("SELECT * FROM account.users"); sql.Where("email=@0", email); sql.Limit(db.DatabaseType, 1, 0, "user_id"); var awaiter = await db.SelectAsync<User>(sql).ConfigureAwait(false); return awaiter.FirstOrDefault(); } }
public static async Task<IEnumerable<PublishedContentView>> GetBlogContentsAsync(string tenant, string categoryAlias, int limit, int offset) { using (var db = DbProvider.Get(FrapidDbServer.GetConnectionString(tenant), tenant).GetDatabase()) { var sql = new Sql("SELECT * FROM website.published_content_view"); sql.Where("LOWER(category_alias)=@0", categoryAlias); sql.And("is_blog=@0", true); sql.Limit(db.DatabaseType, limit, offset, "publish_on"); return await db.SelectAsync<PublishedContentView>(sql).ConfigureAwait(false); } }
public static async Task<SmtpConfig> GetConfigAsync(string tenant) { using(var db = DbProvider.GetDatabase(tenant)) { var sql = new Sql("SELECT * FROM config.smtp_configs"); sql.Where("enabled=@0", true); sql.And("is_default=@0", true); sql.Limit(db.DatabaseType, 1, 0, "smtp_config_id"); var awaiter = await db.SelectAsync<SmtpConfig>(sql).ConfigureAwait(false); return awaiter.FirstOrDefault(); } }
public static async Task<PublishedContentView> GetDefaultAsync(string tenant) { using (var db = DbProvider.Get(FrapidDbServer.GetConnectionString(tenant), tenant).GetDatabase()) { var sql = new Sql("SELECT * FROM website.published_content_view"); sql.Where("is_homepage=@0", true); sql.Limit(db.DatabaseType, 1, 0, "publish_on"); var awaiter = await db.SelectAsync<PublishedContentView>(sql).ConfigureAwait(false); return awaiter.FirstOrDefault(); } }