public QueryResult Handle(ListarUbigeoParameters parameters)
{
using (var connection = (SqlConnection)ConnectionFactory.CreateFromUserSession())
{
var parametros = new DynamicParameters();
var resultado = new ListarUbigeoResult
{
Hits = connection.Query <ListarUbigeoDto>
(
"pago.pa_listarubigeo",
parametros,
commandType: CommandType.StoredProcedure
),
};
return(resultado);
}
}
public QueryResult Handle(ListarUbigeoParameters parameters)
{
using (var connection = (SqlConnection)ConnectionFactory.CreateFromUserSession())
{
var parametros = new DynamicParameters();
parametros.Add("criterio", dbType: DbType.String, direction: ParameterDirection.Input, value: parameters.criterio);
var resultado = new ListarUbigeoResult
{
Hits = connection.Query <ListarUbigeoDto>
(
"mantenimiento.pa_listarubigeo",
parametros,
commandType: CommandType.StoredProcedure
),
};
return(resultado);
}
}
