public async Task ReportBadCaptionsAsync(string clip)
{
var targetClip = this.clipProvider.Get(clip);
if (targetClip == null)
{
return;
}
using (var db = sqlConnectionProvider.Get())
{
await db.OpenAsync();
var cmd = db.CreateCommand();
cmd.CommandText = "INSERT INTO [BadCaptions] (Id, ClipName, Reported) VALUES (@Id, @ClipName, @Reported)";
AddParameter(cmd, "Id", Guid.NewGuid());
AddParameter(cmd, "ClipName", clip);
AddParameter(cmd, "Reported", DateTime.UtcNow);
await cmd.ExecuteNonQueryAsync();
db.Close();
}
}
