public async Task UpdatePost(Post post, bool deleted)
{
using (var rentedConnection = await ConnectionPool.RentConnectionAsync())
{
UpdateQuery.Connection = rentedConnection;
UpdateQuery.Parameters["@comment"].Value = post.Comment;
UpdateQuery.Parameters["@deleted"].Value = deleted ? 1 : 0;
UpdateQuery.Parameters["@media_filename"].Value = post.OriginalFilenameFull;
UpdateQuery.Parameters["@sticky"].Value = post.Sticky == true ? 1 : 0;
UpdateQuery.Parameters["@locked"].Value = post.Closed == true ? 1 : 0;
UpdateQuery.Parameters["@thread_no"].Value = post.ReplyPostNumber != 0 ? post.ReplyPostNumber : post.PostNumber;
UpdateQuery.Parameters["@subnum"].Value = 0;
await UpdateQuery.ExecuteNonQueryAsync();
}
}