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