public async Task <IEnumerable <Model.TransactionCode> > Select(
TransactionCodeOptions options)
{
var param = new DynamicParameters();
param.Add("@ID", options.ID);
param.Add("@Code", StringUtils.NullIfEmptyOrNull(options.Code));
param.Add("@GLEntry", StringUtils.NullIfEmptyOrNull(options.GLEntry));
param.Add("@Description", StringUtils.NullIfEmptyOrNull(options.Text));
var mapper = new TransactionCodeMapper();
return((await SqlMapper.QueryAsync(_unitOfWork.Connection,
"GetFinanceTransactionCode",
new[]
{
typeof(TransactionCode),
typeof(Price)
},
obj =>
{
return mapper.Map(
obj[0] as TransactionCode,
price: obj[1] as Price);
},
param,
splitOn: "ID,PriceID",
commandType: CommandType.StoredProcedure,
transaction: _unitOfWork.Transaction)).Distinct());
}
public async Task <TransactionCode> GetTransactionCodeByID(long id)
{
var param = new DynamicParameters();
param.Add("@ID", id);
var transactionCodeMapper = new TransactionCodeMapper();
return((await SqlMapper.QueryAsync(_unitOfWork.Connection,
"GetFinanceTransactionCodeByID",
new[]
{
typeof(TransactionCode),
typeof(Condition),
typeof(Log),
typeof(Price)
},
obj =>
{
return transactionCodeMapper.Map(
obj[0] as TransactionCode,
obj[1] as Condition,
obj[2] as Log,
obj[3] as Price);
},
param,
splitOn: "ID,ConditionID,LogID,PriceID",
commandType: CommandType.StoredProcedure,
transaction: _unitOfWork.Transaction)).FirstOrDefault());
}
public async Task <TransactionCode> GetTransactionCodeByCode(string code, DateTimeOffset?refDate)
{
var param = new DynamicParameters();
param.Add("@Code", code);
param.Add("@RefDate", refDate);
var mapper = new TransactionCodeMapper();
return((await SqlMapper.QueryAsync(_unitOfWork.Connection,
"GetTransactionCodeByCode",
new[]
{
typeof(TransactionCode),
typeof(Price),
typeof(Condition)
},
obj =>
{
var trxCode = obj[0] as TransactionCode;
var price = obj[1] as Price;
var condition = obj[2] as Condition;
return mapper.Map(trxCode, condition: condition, price: price);
},
param,
splitOn: "ID,PriceID,ConditionID",
commandType: CommandType.StoredProcedure,
transaction: _unitOfWork.Transaction)).FirstOrDefault());
}
