public int GetByFilterWithFullReferencesCount(string RUT, string NOMBRE, int? ID_REGION, int? ID_COMUNA, int? ID_TIPO_PRESTACION, int? ID_CONVENIO) { Init(); try { using (LQCEEntities context = new LQCEEntities()) { RepositorioCLIENTE repositorio = new RepositorioCLIENTE(context); return (from f in repositorio.GetByFilterWithFullReferences(RUT, NOMBRE, ID_REGION, ID_COMUNA, ID_TIPO_PRESTACION, ID_CONVENIO) select f).Count(); } } catch (Exception ex) { ISException.RegisterExcepcion(ex); Error = ex.Message; throw ex; } }
public List<CLIENTE> GetByFilterWithFullReferences(string RUT, string NOMBRE, int? ID_REGION, int? ID_COMUNA, int? ID_TIPO_PRESTACION, int? ID_CONVENIO, int PageIndex, int PageSize) { Init(); try { using (LQCEEntities context = new LQCEEntities()) { RepositorioCLIENTE repositorio = new RepositorioCLIENTE(context); return (from f in repositorio.GetByFilterWithFullReferences(RUT, NOMBRE, ID_REGION, ID_COMUNA, ID_TIPO_PRESTACION, ID_CONVENIO) .OrderBy(f => f.NOMBRE) .Skip((PageIndex - 1) * PageSize).Take(PageSize) select f).ToList(); } } catch (Exception ex) { ISException.RegisterExcepcion(ex); Error = ex.Message; throw ex; } }