public static async Task <IEnumerable <SmsQueue> > GetMailInQueueAsync(string database) { using (var db = DbProvider.GetDatabase(database)) { var sql = new Sql("SELECT * FROM config.sms_queue"); sql.Where("is_test=@0", false); sql.Append("AND delivered=@0", false); sql.Append("AND canceled=@0", false); sql.Append("AND send_on<=" + FrapidDbServer.GetDbTimestampFunction(database)); return(await db.SelectAsync <SmsQueue>(sql).ConfigureAwait(false)); } }
public static async Task SetSuccessAsync(string database, long queueId) { var sql = new Sql("UPDATE config.sms_queue SET"); sql.Append("delivered=@0, ", true); sql.Append("delivered_on=" + FrapidDbServer.GetDbTimestampFunction(database)); sql.Where("queue_id=@0", queueId); using (var db = DbProvider.GetDatabase(database)) { await db.NonQueryAsync(sql).ConfigureAwait(false); } }
public static async Task UpdateActivityAsync(string tenant, int userId, string ip, string browser) { using (var db = DbProvider.GetDatabase(tenant)) { var sql = new Sql("UPDATE account.users SET "); sql.Append("last_seen_on = " + FrapidDbServer.GetDbTimestampFunction(tenant)); sql.Append(","); sql.Append("last_ip = @0", ip); sql.Append(","); sql.Append("last_browser = @0", browser); sql.Where("user_id=@0", userId); await db.ExecuteAsync(sql).ConfigureAwait(false); } }