public async Task <IList <Comment> > GetTransactionComments(ESRTransaction transaction)
{
string cmd = $@"SELECT CreatedBy, CreatedOn, CommentText, TransactionID, BatchID FROM Comments WHERE TransactionID = '{transaction.ID}' ORDER BY CreatedOn ASC;";
return(await GetComments(cmd));
}
