private bool disposedValue = false; // To detect redundant calls
protected virtual void Dispose(bool disposing)
{
if (!disposedValue)
{
if (disposing)
{
SQLCmd_AddBotComment.Dispose();
SQLCmd_AddCheckedComment.Dispose();
SQLCmd_DoesBotCommentExist.Dispose();
SQLCmd_GetBotComment.Dispose();
SQLCmd_HasCommentBeenChecked.Dispose();
SQLCmd_HasPostBeenChecked.Dispose();
SQLCmd_AddCheckedPost.Dispose();
SQLCmd_UpdateBotComment.Dispose();
dbConnection.Dispose();
// TODO: dispose managed state (managed objects).
}
// TODO: free unmanaged resources (unmanaged objects) and override a finalizer below.
// TODO: set large fields to null.
disposedValue = true;
}
}
public void UpdateBotComment(string postID, string commentID)
{
SQLCmd_UpdateBotComment.Parameters["@postID"].Value = postID;
SQLCmd_UpdateBotComment.Parameters["@botReplyID"].Value = commentID;
SQLCmd_UpdateBotComment.ExecuteNonQuery();
}