public QueryResult Execute(ListarProveedorParameter parameters) { using (var conn = new ConnectionFactory(_config).GetOpenConnection()) { var parametros = new DynamicParameters(); parametros.Add("Criterio", dbType: DbType.String, direction: ParameterDirection.Input, value: parameters.Criterio); var result = new ListarProveedorResult(); result.Hits = conn.Query <ListarProveedorDto>("Mantenimiento.pa_buscarproveedor" , parametros , commandType: CommandType.StoredProcedure); return(result); } }
public QueryResult Handle(ListarProveedorParameters parameters) { using (var connection = (SqlConnection)ConnectionFactory.CreateFromUserSession()) { var parametros = new DynamicParameters(); parametros.Add("criterio", dbType: DbType.String, direction: ParameterDirection.Input, value: parameters.criterio); parametros.Add("activo", dbType: DbType.String, direction: ParameterDirection.Input, value: parameters.activo); var resultado = new ListarProveedorResult { Hits = connection.Query <ListarProveedorDto> ( "pago.pa_listarproveedor", parametros, commandType: CommandType.StoredProcedure ), }; return(resultado); } }