public async Task <int> InsertMessage(FoundMessage message)
{
try
{
message.TimePosted = message.TimePosted.ToUniversalTime();
await _connection.OpenAsync();
using (var transaction = await _connection.BeginTransactionAsync())
{
var inserted = await _commentsRepo.InsertRedditMessage(message, _connection);
if (inserted != -1)
{
try
{
await _commentsRepo.InsertRedditTickerMessage(message, inserted, _connection);
await transaction.CommitAsync();
return(inserted);
}
catch (Exception ex)
{
await transaction.RollbackAsync();
throw ex;
}
}
else
{
return(-1);
}
}
}
finally
{
await _connection.CloseAsync();
}
}
