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