public TransactionDto GetTransaction(int transactionId)
{
var query = string.Format("select id, account, description, currencyCode, amount from TransactionData where id = {0}", transactionId);
using (var conn = _connectionProvider.OpenConnection())
{
using (var cmd = new SqlCommand(query, conn))
{
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
return(new TransactionDto(
id: reader.GetInt32(0),
account: reader.GetString(1),
description: reader.GetString(2),
currencyCode: reader.GetString(3),
amount: reader.GetDecimal(4)
));
}
}
}
}
return(null);
}