public static FormularioModel GetFormularioXSeleccion(MotivoModel motivo, NegocioModel negocio) { Query supQuery = new Query(); CompositeTest where = new CompositeTest(); where.SetOperator(CompositeTest.AND); where.Add(new AttributeTest("idMotivo", motivo.IdMotivo, AttributeTest.EQUAL)); where.Add(new AttributeTest("idNegocio", negocio.IdNegocio, AttributeTest.EQUAL)); supQuery.Where(where); GenericList <SeleccionFormulario> seleccionFormulario = SeleccionFormulario.FindWithQuery(supQuery); if (seleccionFormulario.Size() > 0) { return(FormularioModel.Create(seleccionFormulario[0].Formulario)); } else { return(null); } }
public static DireccionEntregaModelCollection BuscarClientes(String cuit, String razonSocial, String apies) { Query supQuery = new Query(); AttributeTest testCUIT = new AttributeTest(); testCUIT.Attribute = "CUIT"; testCUIT.Operator = AttributeTest.LIKE; testCUIT.Value = "%" + cuit + "%"; AttributeTest testRazonSocial = new AttributeTest(); testRazonSocial.Attribute = "razonSocial"; testRazonSocial.Operator = AttributeTest.LIKE; testRazonSocial.Value = "%" + razonSocial + "%"; AttributeTest testAPIES = new AttributeTest(); testRazonSocial.Attribute = "APIES"; testRazonSocial.Operator = AttributeTest.LIKE; testRazonSocial.Value = "%" + apies + "%"; //AttributeTest testCuentaLP2 = new AttributeTest(); //testCuentaLP2.setAttribute("cuentaLP2"); //testCuentaLP2.setOperator(AttributeTest.EQUAL); //testCuentaLP2.setValue(nroCuenta); //AttributeTest testCuentaQP1 = new AttributeTest(); //testCuentaQP1.setAttribute("cuentaQP1"); //testCuentaQP1.setOperator(AttributeTest.EQUAL); //testCuentaQP1.setValue(nroCuenta); //AttributeTest testCuentaSGC = new AttributeTest(); //testCuentaSGC.setAttribute("cuentaSGC"); //testCuentaSGC.setOperator(AttributeTest.EQUAL); //testCuentaSGC.setValue(nroCuenta); //AttributeTest testDummy = new AttributeTest(); //testDummy.setAttribute("CUIT"); //testDummy.setOperator(AttributeTest.NOT_EQUAL); //testDummy.setValue(""); CompositeTest where = new CompositeTest(); where.Operator = CompositeTest.AND; if (cuit.Trim().Length != 0) { where.Add(testCUIT); } if (razonSocial.Trim().Length != 0) { where.Add(testRazonSocial); } if (apies.Trim().Length > 0) { where.Add(testAPIES); } //if (nroCuenta != null && nroCuenta.length() > 0 && tipoCuenta != null && tipoCuenta.length() > 0) //{ // if (tipoCuenta.equals("LP2")) // where.add(testCuentaLP2); // if (tipoCuenta.equals("QP1")) // where.add(testCuentaQP1); // if (tipoCuenta.equals("SGC")) // where.add(testCuentaSGC); //} if (where.Operands.Count > 0) { supQuery.Where(where); } //SortCriteria sort = new SortCriteria(); //sort.add("CUIT", SortOrderType.ASCENDING); //sort.add("razonSocial", SortOrderType.ASCENDING); //supQuery.setSortCriteria(sort); GenericList <DireccionEntrega> result = DireccionEntrega.FindWithQuery(supQuery); return(new DireccionEntregaModelCollection(result)); }
public static void Main(string[] args) { int option = 1; int i_option = 1; int ii_option = 1; // YO AMO A MI ESPOSA :) LE VOY A COMPRAR MUCHOS REGALOS :) while (option != 0) { ConsoleUtility.WriteLine("Choose an option based in the next menu"); ConsoleUtility.WriteLine("1.-Algorithm"); ConsoleUtility.WriteLine("2.-DataStructures"); ConsoleUtility.WriteLine("3.-Design Patterns"); ConsoleUtility.WriteLine("4.-Language DotNet"); option = Convert.ToInt32(Console.ReadLine()); switch (option) { case 1: ConsoleUtility.WriteLine("Algorithm"); ConsoleUtility.WriteLine("1.-Linear Table"); ConsoleUtility.WriteLine("2.-Linear Table Append"); ConsoleUtility.WriteLine("3.-Linear Table Delete"); ConsoleUtility.WriteLine("4.-Linear Table Insert"); ConsoleUtility.WriteLine("5.-Linear Table Search"); ConsoleUtility.WriteLine("6.-Factorial"); ConsoleUtility.WriteLine("7.-Bubble Sort"); ConsoleUtility.WriteLine("8.-Heap Sort"); ConsoleUtility.WriteLine("9.-Insert Sorting"); ConsoleUtility.WriteLine("10.-Merge Sort"); ConsoleUtility.WriteLine("11.-Quick Sort"); ConsoleUtility.WriteLine("12.-Select Sort"); ConsoleUtility.WriteLine("13.-Binary Search"); ConsoleUtility.WriteLine("14.-Fibonnacci"); ConsoleUtility.WriteLine("15.-Fibonacci with Memoization"); i_option = Convert.ToInt32(Console.ReadLine()); switch (i_option) { case 1: ConsoleUtility.WriteLine("Running example of Linear Table"); LinearTable linearTable = new LinearTable(); linearTable.Run(); break; case 2: ConsoleUtility.WriteLine("Running example of Linear Table Append"); LinearTableAppend linearTableAppend = new LinearTableAppend(); linearTableAppend.Run(); break; case 3: ConsoleUtility.WriteLine("Running example of Linear Table Delete"); LinearTableDelete linearTableDelete = new LinearTableDelete(); linearTableDelete.Run(); break; case 4: ConsoleUtility.WriteLine("Running example of Linear Table Insert"); LinearTableInsert linearTableInsert = new LinearTableInsert(); linearTableInsert.Run(); break; case 5: ConsoleUtility.WriteLine("Running example of Linear Table Search"); LinearTableSearch linearTableSearch = new LinearTableSearch(); linearTableSearch.Run(); break; case 6: ConsoleUtility.WriteLine("Running example of Factorial"); Factorial factorial = new Factorial(); factorial.Run(); break; case 7: ConsoleUtility.WriteLine("Running example of Bubble Sort"); BubbleSort bubbleSort = new BubbleSort(); bubbleSort.Run(); break; case 8: ConsoleUtility.WriteLine("Running example of HeapSort"); HeapSort heapSort = new HeapSort(); heapSort.Run(); break; case 9: ConsoleUtility.WriteLine("Running example of InsertSorting"); InsertSorting insertSorting = new InsertSorting(); insertSorting.Run(); break; case 10: ConsoleUtility.WriteLine("Running example of Merge Sort"); MergeSort mergeSort = new MergeSort(); mergeSort.Run(); break; case 11: ConsoleUtility.WriteLine("Running example pf Quick Sort"); QuickSort quickSort = new QuickSort(); quickSort.Run(); break; case 12: ConsoleUtility.WriteLine("Running example of Select Sort"); SelectSort selectSort = new SelectSort(); selectSort.Run(); break; case 13: ConsoleUtility.WriteLine("Running example of Binary Search"); BinarySearch binarySearch = new BinarySearch(); binarySearch.Run(); break; case 14: ConsoleUtility.WriteLine("Running example of Fibonnacci"); Fibonnacci fibonnacci = new Fibonnacci(); fibonnacci.Run(); break; case 15: ConsoleUtility.WriteLine("Running example of Fibonnaci with Memoization"); FibonacciMemoization fibonacciMemoization = new FibonacciMemoization(); fibonacciMemoization.Run(); break; default: break; } break; case 2: ConsoleUtility.WriteLine("Data Structures"); ConsoleUtility.WriteLine("1.-Binary Search Tree"); ConsoleUtility.WriteLine("2.-Binary Tree"); ConsoleUtility.WriteLine("3.-Doubly Linked List"); ConsoleUtility.WriteLine("4.-Double Linked List"); ConsoleUtility.WriteLine("5.-Hash Table"); ConsoleUtility.WriteLine("6.-Linked List"); ConsoleUtility.WriteLine("7.-One Way Circular List"); ConsoleUtility.WriteLine("8.-Queue"); ConsoleUtility.WriteLine("9.-Stack"); ConsoleUtility.WriteLine("10.-Two Way Circular List"); ConsoleUtility.WriteLine("11.-Unidirectional Linked List"); i_option = Convert.ToInt32(Console.ReadLine()); ConsoleUtility.WriteLine($"you choose option {i_option}"); switch (i_option) { case 1: ConsoleUtility.WriteLine("Running example of Binary Search Tree"); BinarySearchTree binarySearchTree = new BinarySearchTree(); binarySearchTree.Run(); break; case 2: ConsoleUtility.WriteLine("Running example of Binary Tree"); BinaryTree binaryTree = new BinaryTree(); binaryTree.Run(); break; case 3: ConsoleUtility.WriteLine("Running example of DoublyLinkedList"); DoublyLinkedList doublyLinkedList = new DoublyLinkedList(); doublyLinkedList.Run(); break; case 4: ConsoleUtility.WriteLine("Running example of DoubleLinkedList"); DoubleLinkedList doubleLinkedList = new DoubleLinkedList(); doubleLinkedList.Run(); break; case 5: ConsoleUtility.WriteLine("Running example of HashTable"); HashTable hashTable = new HashTable(); hashTable.Run(); break; case 6: ConsoleUtility.WriteLine("Running example of Linked List"); LinkedList <int> linkedList = new LinkedList <int>(); linkedList.Run(); break; case 7: ConsoleUtility.WriteLine("Running example of One Way Circular List"); OneWayCircularList circularList = new OneWayCircularList(); circularList.Run(); break; case 8: ConsoleUtility.WriteLine("Running example of Queue"); Queue queue = new Queue(); queue.Run(); break; case 9: ConsoleUtility.WriteLine("Running example of Stack"); Stack stack = new Stack(); stack.Run(); break; case 10: ConsoleUtility.WriteLine("Running example of Two Way Circular List"); TwoWayCircularList twoWay = new TwoWayCircularList(); twoWay.Run(); break; case 11: ConsoleUtility.WriteLine("Running example fo Unidirectional Linked List"); UnidirectionalLinkedList unidirectionalLinkedList = new UnidirectionalLinkedList(); unidirectionalLinkedList.Run(); break; default: break; } break; case 3: ConsoleUtility.WriteLine("Design Patterns"); ConsoleUtility.WriteLine("1.-Creational"); ConsoleUtility.WriteLine("2.-Structural"); ConsoleUtility.WriteLine("3.-Behavioral"); ConsoleUtility.WriteLine("4.-SOLID Principles"); i_option = Convert.ToInt32(Console.ReadLine()); ConsoleUtility.WriteLine($"you choose option {i_option}"); switch (i_option) { case 1: ConsoleUtility.WriteLine("Example of creational design patterns"); ConsoleUtility.WriteLine("1.-Singleton"); ConsoleUtility.WriteLine("2.-Factory"); ConsoleUtility.WriteLine("3.-Builder"); ConsoleUtility.WriteLine("4.-Prototype"); ConsoleUtility.WriteLine("5.-Fluent Interface"); ConsoleUtility.WriteLine("6.-Factory Method"); ConsoleUtility.WriteLine("7.-Abstract Factory"); ConsoleUtility.WriteLine("Select one option"); ii_option = Convert.ToInt32(Console.ReadLine()); switch (ii_option) { case 1: ConsoleUtility.WriteLine("Running example of singleton design pattern"); SingletonTest singletonTest = new SingletonTest(); singletonTest.Run(); break; case 2: ConsoleUtility.WriteLine("Runnig example of Factory design pattern"); FactoryTest factoryTest = new FactoryTest(); factoryTest.Run(); break; case 3: ConsoleUtility.WriteLine("Running example fo Builder Desiogn Pattern"); BuilderTest builderTest = new BuilderTest(); builderTest.Run(); break; case 4: ConsoleUtility.WriteLine("Running example of Prototype Design Pattern"); PrototypeTest prototype = new PrototypeTest(); prototype.Run(); break; case 5: ConsoleUtility.WriteLine("Running example of Fluent Interface Design Patter"); FluentInterface fluent = new FluentInterface(); fluent.Run(); break; case 6: ConsoleUtility.WriteLine("Running example of Factory Method Design Pattern"); FactoryMethodTest factory = new FactoryMethodTest(); factory.Run(); break; case 7: ConsoleUtility.WriteLine("Running example of Abstract Factory"); AbstractFactoryTest abstractFactory = new AbstractFactoryTest(); abstractFactory.Run(); break; default: break; } break; case 2: ConsoleUtility.WriteLine("Example of Structural Design Pattern"); ConsoleUtility.WriteLine("1.-Adapter"); ConsoleUtility.WriteLine("2.-Facade"); ConsoleUtility.WriteLine("3.-Decorator"); ConsoleUtility.WriteLine("4.-Composite"); ConsoleUtility.WriteLine("5.-Proxy"); ConsoleUtility.WriteLine("6.-Flyweight"); ConsoleUtility.WriteLine("7.-Bridge"); ii_option = Convert.ToInt32(Console.ReadLine()); switch (ii_option) { case 1: ConsoleUtility.WriteLine("Running example of Adapter"); AdapterTest adapter = new AdapterTest(); adapter.Run(); break; case 2: ConsoleUtility.WriteLine("Running example of Facade"); FacadeTest facade = new FacadeTest(); facade.Run(); break; case 3: ConsoleUtility.WriteLine("Running example of Decorator"); DecoratorTest decorator = new DecoratorTest(); decorator.Run(); break; case 4: ConsoleUtility.WriteLine("Running example of Composite"); CompositeTest composite = new CompositeTest(); composite.Run(); break; case 5: ConsoleUtility.WriteLine("Running example of Proxy"); ProxyTest proxy = new ProxyTest(); proxy.Run(); break; case 6: ConsoleUtility.WriteLine("Running example of Flyweight"); FlyweightTest flyweight = new FlyweightTest(); flyweight.Run(); break; case 7: ConsoleUtility.WriteLine("Running example of Bridge"); BridgeTest bridge = new BridgeTest(); bridge.Run(); break; default: break; } break; case 3: ConsoleUtility.WriteLine("Example of Behavioral Design Pattern"); ConsoleUtility.WriteLine("1.-Chain of Responsability"); ConsoleUtility.WriteLine("2.-Command"); ConsoleUtility.WriteLine("3.-Observer"); ConsoleUtility.WriteLine("4.-Iterator"); ConsoleUtility.WriteLine("5.-State"); ConsoleUtility.WriteLine("6.-Template Method"); ConsoleUtility.WriteLine("7.-Visitor"); ConsoleUtility.WriteLine("8.-Strategy"); ConsoleUtility.WriteLine("9.-Mediator"); ConsoleUtility.WriteLine("10.-Memento"); ConsoleUtility.WriteLine("11.-Interpreter"); ii_option = Convert.ToInt32(Console.ReadLine()); switch (ii_option) { case 1: ConsoleUtility.WriteLine("Running example of Change Of Responsability"); ChainOfResponsability chain = new ChainOfResponsability(); chain.Run(); break; case 2: ConsoleUtility.WriteLine("Running example of Command"); CommandTest command = new CommandTest(); command.Run(); break; case 3: ConsoleUtility.WriteLine("Running example of Observer"); ObserverTest observer = new ObserverTest(); observer.Run(); break; case 4: ConsoleUtility.WriteLine("Running example of Iterator"); IteratorTest iterator = new IteratorTest(); iterator.Run(); break; case 5: ConsoleUtility.WriteLine("Running example of State"); StateTest state = new StateTest(); state.Run(); break; case 6: ConsoleUtility.WriteLine("Running example of Template Method"); TemplateMehodTest templateMehod = new TemplateMehodTest(); templateMehod.Run(); break; case 7: ConsoleUtility.WriteLine("Running example of Visitor"); VisitorTest visitor = new VisitorTest(); visitor.Run(); break; case 8: ConsoleUtility.WriteLine("Running example of stratgegy"); StrategyTest strategy = new StrategyTest(); strategy.Run(); break; case 9: ConsoleUtility.WriteLine("Running example of Mediator"); MediatorTest mediator = new MediatorTest(); mediator.Run(); break; case 10: ConsoleUtility.WriteLine("Running example of Memento"); MementoTest memento = new MementoTest(); memento.Run(); break; case 11: ConsoleUtility.WriteLine("Running example of Interpreter"); InterpreterTest interpreter = new InterpreterTest(); interpreter.Run(); break; default: break; } break; case 4: ConsoleUtility.WriteLine("Example of SOLID Principles"); ConsoleUtility.WriteLine("1.-Single Responsibility Principle"); ConsoleUtility.WriteLine("2.-Open-Closed Principle"); ConsoleUtility.WriteLine("3.-Liskov Substitution Principle"); ConsoleUtility.WriteLine("4.-Interface Segregation Principle"); ConsoleUtility.WriteLine("5.-Dependency Inversion Principle"); ii_option = Convert.ToInt32(Console.ReadLine()); switch (ii_option) { case 1: ConsoleUtility.WriteLine("Running example of Single Responsibility"); Invoice invoice = new Invoice(); invoice.Run(); break; case 2: ConsoleUtility.WriteLine("Running example of Open-Closed Principle"); InvoiceOCP invoiceOCP = new InvoiceOCP(); invoiceOCP.Run(); break; case 3: ConsoleUtility.WriteLine("Running example of Liskov Principle"); RunFruit run = new RunFruit(); run.Run(); break; case 4: ConsoleUtility.WriteLine("Running example of Interface Segregation Principle"); Printer printer = new Printer(); printer.Run(); break; case 5: ConsoleUtility.WriteLine("Running example of Dependency Inversion Principle"); RunDIP runDIP = new RunDIP(); runDIP.Run(); break; } break; default: break; } break; case 4: ConsoleUtility.WriteLine("Language DotNet"); ConsoleUtility.WriteLine("1.-Abstract"); ConsoleUtility.WriteLine("2.-Action"); ConsoleUtility.WriteLine("3.-AsyncAwait"); ConsoleUtility.WriteLine("4.-Delegate"); ConsoleUtility.WriteLine("5.-Extensions"); ConsoleUtility.WriteLine("6.-Func"); ConsoleUtility.WriteLine("7.-Generics"); ConsoleUtility.WriteLine("8.-Predicate"); ConsoleUtility.WriteLine("9.-Lock"); ConsoleUtility.WriteLine("10.-Reflection"); ConsoleUtility.WriteLine("11.-IOC Implementation"); ConsoleUtility.WriteLine("12.-Task"); ConsoleUtility.WriteLine("13.-Out Variable"); ConsoleUtility.WriteLine("14.-Pattern Matching"); ConsoleUtility.WriteLine("15.-Digit Separator"); ConsoleUtility.WriteLine("16.-Tuples"); ConsoleUtility.WriteLine("17.-Ref locals and ref return"); ConsoleUtility.WriteLine("18.-AsynReturn"); i_option = Convert.ToInt32(Console.ReadLine()); switch (i_option) { case 1: ConsoleUtility.WriteLine("Running example of Abstract Class"); Square square = new Square(); square.Run(); break; case 2: ConsoleUtility.WriteLine("Running example of Action"); LanguageDotNet.Action action = new LanguageDotNet.Action(); action.Run(); break; case 3: ConsoleUtility.WriteLine("Running example of AsyncAwait"); AsyncAwait asyncAwait = new AsyncAwait(); asyncAwait.Run(); break; case 4: ConsoleUtility.WriteLine("Running example of Delegate"); Number number = new Number(); number.Run(); break; case 5: ConsoleUtility.WriteLine("Running example of Extensions"); IntExtensions intExtensions = new IntExtensions(); intExtensions.Run(); break; case 6: ConsoleUtility.WriteLine("Running example of Func"); Func func = new Func(); func.Run(); break; case 7: ConsoleUtility.WriteLine("Running example of Generics"); Generic generic = new Generic(); generic.Run(); break; case 8: ConsoleUtility.WriteLine("Running example of Predicate"); Predicate predicate = new Predicate(); predicate.Run(); break; case 9: ConsoleUtility.WriteLine("Running example of Lock"); LockTest lockTest = new LockTest(); lockTest.runTest(); break; case 10: ConsoleUtility.WriteLine("Running example of Reflection"); Customer customer = new Customer(); customer.Run(); break; case 11: ConsoleUtility.WriteLine("Running example of IOC Implementation"); IOCImplementation.Run(); break; case 12: ConsoleUtility.WriteLine("Running example of Tasks"); TaskReturnValue taskReturnValue = new TaskReturnValue(); taskReturnValue.Run(); break; case 13: ConsoleUtility.WriteLine("Running example of Out variable"); OutVariables outVariables = new OutVariables(); outVariables.Run(); break; case 14: ConsoleUtility.WriteLine("Running example of Pattern Matching"); PatternMatching patternMatching = new PatternMatching(); patternMatching.Run(); break; case 15: ConsoleUtility.WriteLine("Running example of Digit Separators"); DigitSeparator digitSeparator = new DigitSeparator(); digitSeparator.Run(); break; case 16: ConsoleUtility.WriteLine("Running example of Tuple"); Tuples tuples = new Tuples(); tuples.Run(); break; case 17: ConsoleUtility.WriteLine("Running example of Ref locals and ref returns"); RefLocalRefReturn refLocalRefReturn = new RefLocalRefReturn(); refLocalRefReturn.Run(); break; case 18: ConsoleUtility.WriteLine("Running example of AsyncReturn"); AsyncReturn asyncReturn = new AsyncReturn(); asyncReturn.Run(); break; default: break; } break; default: ConsoleUtility.WriteLine("Exit"); break; } } }
public static FormularioModel GetFormularioXSeleccion(MotivoModel motivo, NegocioModel negocio) { Query supQuery = new Query(); CompositeTest where = new CompositeTest(); where.SetOperator(CompositeTest.AND); where.Add(new AttributeTest("idMotivo", motivo.IdMotivo, AttributeTest.EQUAL)); where.Add(new AttributeTest("idNegocio", negocio.IdNegocio, AttributeTest.EQUAL)); supQuery.Where(where); GenericList<SeleccionFormulario> seleccionFormulario = SeleccionFormulario.FindWithQuery(supQuery); if (seleccionFormulario.Size() > 0) return FormularioModel.Create(seleccionFormulario[0].Formulario); else return null; }
public static DireccionEntregaModelCollection BuscarClientes(String cuit, String razonSocial, String apies) { Query supQuery = new Query(); AttributeTest testCUIT = new AttributeTest(); testCUIT.Attribute = "CUIT"; testCUIT.Operator = AttributeTest.LIKE; testCUIT.Value = "%" + cuit + "%" ; AttributeTest testRazonSocial = new AttributeTest(); testRazonSocial.Attribute = "razonSocial"; testRazonSocial.Operator = AttributeTest.LIKE; testRazonSocial.Value = "%" + razonSocial + "%"; AttributeTest testAPIES = new AttributeTest(); testRazonSocial.Attribute = "APIES"; testRazonSocial.Operator = AttributeTest.LIKE; testRazonSocial.Value = "%" + apies + "%"; //AttributeTest testCuentaLP2 = new AttributeTest(); //testCuentaLP2.setAttribute("cuentaLP2"); //testCuentaLP2.setOperator(AttributeTest.EQUAL); //testCuentaLP2.setValue(nroCuenta); //AttributeTest testCuentaQP1 = new AttributeTest(); //testCuentaQP1.setAttribute("cuentaQP1"); //testCuentaQP1.setOperator(AttributeTest.EQUAL); //testCuentaQP1.setValue(nroCuenta); //AttributeTest testCuentaSGC = new AttributeTest(); //testCuentaSGC.setAttribute("cuentaSGC"); //testCuentaSGC.setOperator(AttributeTest.EQUAL); //testCuentaSGC.setValue(nroCuenta); //AttributeTest testDummy = new AttributeTest(); //testDummy.setAttribute("CUIT"); //testDummy.setOperator(AttributeTest.NOT_EQUAL); //testDummy.setValue(""); CompositeTest where = new CompositeTest(); where.Operator = CompositeTest.AND; if (cuit.Trim().Length != 0) where.Add(testCUIT); if (razonSocial.Trim().Length != 0) where.Add(testRazonSocial); if (apies.Trim().Length > 0) where.Add(testAPIES); //if (nroCuenta != null && nroCuenta.length() > 0 && tipoCuenta != null && tipoCuenta.length() > 0) //{ // if (tipoCuenta.equals("LP2")) // where.add(testCuentaLP2); // if (tipoCuenta.equals("QP1")) // where.add(testCuentaQP1); // if (tipoCuenta.equals("SGC")) // where.add(testCuentaSGC); //} if(where.Operands.Count > 0) supQuery.Where(where); //SortCriteria sort = new SortCriteria(); //sort.add("CUIT", SortOrderType.ASCENDING); //sort.add("razonSocial", SortOrderType.ASCENDING); //supQuery.setSortCriteria(sort); GenericList<DireccionEntrega> result = DireccionEntrega.FindWithQuery(supQuery); return new DireccionEntregaModelCollection(result); }