private TransactionDto MapFromDataObjectToDto(TransactionDataObject item)
{
return(new TransactionDto
{
Summary = item.Summary,
TransactionDate = item.TransactionDate,
TransactionId = item.TransactionId,
Value = item.Value
});
}
public TransactionDataObject CreateTransaction(TransactionDataObject item)
{
string sql = "INSERT INTO dbo.Transactions ([Value], TransactionDate, Summary) Values (@Value, @TransactionDate, @Summary); " +
"SELECT CAST(SCOPE_IDENTITY() as BIGINT)";
long rowId;
using (var connection = new SqlConnection(_connectionString))
{
rowId = connection.Query<long>(sql,
new
{
item.Value,
item.TransactionDate,
item.Summary
}).Single();
}
return GetTransaction(rowId);
}
public TransactionDataObject UpdateTransaction(TransactionDataObject item)
{
string sql =
"UPDATE dbo.Transactions " +
"SET [Value] = @Value, TransactionDate = @TransactionDate, Summary = @Summary " +
"WHERE TransactionId = @TransactionId";
int rowsAffected = 0;
using (var connection = new SqlConnection(_connectionString))
{
rowsAffected = connection.Execute(sql,
new
{
item.TransactionId,
item.Value,
item.TransactionDate,
item.Summary
});
}
return GetTransaction(item.TransactionId);
}
