public IEnumerable <VolumeQualificationReadModel> GetVolumeQualifications()
{
using (var connection = _connectionFactory.CreateOpenConnection())
{
return(connection.Query <VolumeQualificationReadModel>(
"VolumeQualifications_GetAll",
commandType: CommandType.StoredProcedure).ToList());
}
}
public IEnumerable <IncentiveReadModel> GetAllIncentives()
{
using (var connection = _connectionFactory.CreateOpenConnection())
{
return(connection.Query <IncentiveReadModel>(
"Incentive_GetAll",
commandType: CommandType.StoredProcedure
).ToList());
}
}
public IEnumerable <CommissionTierReadModel> GetTiers()
{
using (var connection = _connectionFactory.CreateOpenConnection())
{
return(connection.Query <CommissionTierReadModel>(
"CommissionTier_GetAll",
commandType: CommandType.StoredProcedure).ToList());
}
}