public override DataSet List(Filter f, out int RecordCount) { DataSet ds = new DataSet(); try { FiltroCiudad filtro = (FiltroCiudad)f; List<IDbDataParameter> paramList = new List<IDbDataParameter>(); DBRepository repository = DBRepository.GetDbRepository(); paramList.Add(repository.DbFactory.getDataParameter("P_ID", DbType.Int32, filtro.ID)); paramList.Add(repository.DbFactory.getDataParameter("P_IDPAIS", DbType.Int32, filtro.IDPais)); paramList.Add(repository.DbFactory.getDataParameter("P_IDPROVINCIA", DbType.Int32, filtro.IDProvinca)); bool result = repository.ExecuteListProcedure(CONST_LIST_PROCEDURE_NAME, paramList, f, ds, out RecordCount); } catch (Exception ex) { throw ex; } return ds; }
public DataSet ListUbicaciones(Filter f, out int RecordCount) { DataSet ds = new DataSet(); try { List<IDbDataParameter> paramList = new List<IDbDataParameter>(); DBRepository repository = DBRepository.GetDbRepository(); bool result = repository.ExecuteListProcedure(CONST_LIST_UBICACIONES_NAME, paramList, f, ds, out RecordCount); } catch (Exception ex) { throw ex; } return ds; }
public override DataSet List(Filter f, out int RecordCount) { DataSet resultSet = new DataSet(); try { FiltroProblema filtro = (FiltroProblema)f; DBRepository repository = DBRepository.GetDbRepository(); List<IDbDataParameter> paramList = new List<IDbDataParameter>(); paramList.Add(repository.DbFactory.getDataParameter("P_ID", DbType.Int32, filtro.ID)); repository.ExecuteListProcedure(CONST_LIST_PROCEDURE_NAME, paramList, f, resultSet, out RecordCount); } catch (Exception ex) { throw ex; } return resultSet; }
public override DataSet List(Filter f, out int RecordCount) { DataSet ds = new DataSet(); try { FiltroPrestador filtro = (FiltroPrestador)f; DBRepository repository = DBRepository.GetDbRepository(); List<IDbDataParameter> paramlist = new List<IDbDataParameter>(); paramlist.Add(repository.DbFactory.getDataParameter("P_ID_PRESTADOR", DbType.Int32, filtro.ID)); paramlist.Add(repository.DbFactory.getDataParameter("P_NOMBRE", DbType.String, filtro.Nombre)); paramlist.Add(repository.DbFactory.getDataParameter("P_DESCRIPCION", DbType.String, filtro.Descripcion)); paramlist.Add(repository.DbFactory.getDataParameter("P_ESTADO", DbType.Int32, filtro.ESTADO)); paramlist.Add(repository.DbFactory.getDataParameter("P_ID_PAIS", DbType.Int32, filtro.IdPais)); paramlist.Add(repository.DbFactory.getDataParameter("P_ID_PROVINCA", DbType.Int32, filtro.IdProvincia)); paramlist.Add(repository.DbFactory.getDataParameter("P_ID_CIUDAD", DbType.Int32, filtro.IdCiudad)); paramlist.Add(repository.DbFactory.getDataParameter("P_LOCALIDAD_NOMBRE", DbType.String, filtro.Localidad)); paramlist.Add(repository.DbFactory.getDataParameter("P_SEARCH", DbType.String, filtro.Search)); repository.ExecuteListProcedure(CONST_LIST_PROCEDURE_NAME, paramlist, f, ds, out RecordCount); } catch(Exception ex) { throw ex; } return ds; }
public System.Data.DataSet List(Filter f) { int RecordCount; return List(f, out RecordCount); }
public abstract DataSet List(Filter f, out int RecordCount);
public override System.Data.DataSet List(Filter f, out int RecordCount) { DataSet ds = new DataSet(); try { FiltroOperador filtro = (FiltroOperador)f; List<IDbDataParameter> paramList = new List<IDbDataParameter>(); DBRepository repository = DBRepository.GetDbRepository(); paramList.Add(repository.DbFactory.getDataParameter("P_ID", DbType.Int32, filtro.ID)); paramList.Add(repository.DbFactory.getDataParameter("P_USUARIO", DbType.String, filtro.Usuario)); paramList.Add(repository.DbFactory.getDataParameter("P_NOMBRE", DbType.String, filtro.Nombre)); paramList.Add(repository.DbFactory.getDataParameter("P_CLAVE", DbType.String, filtro.Clave)); paramList.Add(repository.DbFactory.getDataParameter("P_APELLIDO", DbType.String, filtro.Apellido)); paramList.Add(repository.DbFactory.getDataParameter("P_SEARCH", DbType.String, filtro.Search)); paramList.Add(repository.DbFactory.getDataParameter("P_ACTIVO", DbType.Int32, filtro.Estado)); bool result = repository.ExecuteListProcedure(CONST_LIST_PROCEDURE_NAME, paramList, f, ds, out RecordCount); } catch (Exception ex) { throw ex; } return ds; }
public override DataSet List(Filter f, out int RecordCount) { DataSet resultSet = new DataSet(); try { FiltroTicket filtro = (FiltroTicket)f; DBRepository repository = DBRepository.GetDbRepository(); List<IDbDataParameter> paramList = new List<IDbDataParameter>(); paramList.Add(repository.DbFactory.getDataParameter("P_ID", DbType.Int32, filtro.ID)); paramList.Add(repository.DbFactory.getDataParameter("P_IDOPERADOR", DbType.Int32, filtro.IDOperador)); paramList.Add(repository.DbFactory.getDataParameter("P_IDAFILIADO", DbType.Int32, filtro.IDAfiliado)); paramList.Add(repository.DbFactory.getDataParameter("P_CIUDAD_ORIGEN", DbType.Int32, filtro.IDCiudadOrigen)); paramList.Add(repository.DbFactory.getDataParameter("P_CIUDAD_DESTINO", DbType.Int32, filtro.IDCiudadDestino)); //paramList.Add(repository.DbFactory.getDataParameter("P_IDPRESTADOR", DbType.Int32, filtro.IDPrestador)); paramList.Add(repository.DbFactory.getDataParameter("P_SEARCH", DbType.String, filtro.Search)); repository.ExecuteListProcedure(CONST_LIST_PROCEDURE_NAME, paramList, f, resultSet, out RecordCount); } catch (Exception ex) { throw ex; } return resultSet; }
public System.Data.DataSet ListHuerfanos(Filter f, out int RecordCount) { DataSet ds = new DataSet(); try { FiltroAfiliado filtro = (FiltroAfiliado)f; List<IDbDataParameter> paramList = new List<IDbDataParameter>(); DBRepository repository = DBRepository.GetDbRepository(); paramList.Add(repository.DbFactory.getDataParameter("P_ID", DbType.Int32, filtro.ID)); paramList.Add(repository.DbFactory.getDataParameter("P_APELLIDO", DbType.String, filtro.Apellido)); paramList.Add(repository.DbFactory.getDataParameter("P_NOMBRE", DbType.String, filtro.Nombre)); paramList.Add(repository.DbFactory.getDataParameter("P_POLIZA", DbType.String, filtro.Poliza)); paramList.Add(repository.DbFactory.getDataParameter("P_IDDOCUMENTO", DbType.String, filtro.Documento)); paramList.Add(repository.DbFactory.getDataParameter("P_PATENTE", DbType.String, filtro.Patente)); paramList.Add(repository.DbFactory.getDataParameter("P_ID_EMPRESA", DbType.Int32, filtro.IDEmpresa)); paramList.Add(repository.DbFactory.getDataParameter("P_SEARCH", DbType.String, filtro.Search)); bool result = repository.ExecuteListProcedure(CONST_LIST_HUERFANOS_NAME, paramList, f, ds, out RecordCount); } catch (Exception ex) { throw ex; } return ds; }
public virtual bool ExecuteListProcedure(string ProcedureName, List<IDbDataParameter> parameters, Filter f, DataSet dsResult, out int RecordCount) { bool result = false; RecordCount = 0; try { this.AddFilterToCommand(parameters, f); this.ExecuteProcedure(ProcedureName, parameters, dsResult); if (f.IsPaged) { if ((dsResult.Tables.Count > 0) && (dsResult.Tables[0].Rows.Count>0)){ RecordCount = Int32.Parse(dsResult.Tables[0].Rows[0][COLUMN_TOTAL_ROW_NAME].ToString()); } } } catch (Exception ex) { throw ex; } return result; }
public virtual bool ExecuteListProcedure(string ProcedureName, List<IDbDataParameter> parameters, Filter f, DataSet dsResult) { int Rowcount; return ExecuteListProcedure(ProcedureName, parameters, f, dsResult, out Rowcount); }
public void AddFilterToCommand(List<IDbDataParameter> parameters, Filter filter) { // Get parameters. IDbDataParameter paramStartRow = this.DbFactory.getDataParameter(P_PAGE_START_PARAM, DbType.Int32, filter.StartRow); IDbDataParameter paramRowQtty = this.DbFactory.getDataParameter(P_PAGE_SIZE_PARAM, DbType.Int32, filter.PageSize); IDbDataParameter paramCouterFiltred = this.DbFactory.getDataParameter(P_IS_PAGED_PARAM, DbType.Int32, filter.IsPaged?PAGED_TRUE:PAGED_FALSE); IDbDataParameter paramOrderby = this.DbFactory.getDataParameter(P_ORDER_BY_PARAM, DbType.String, filter.OrderBY); parameters.Add(paramStartRow); parameters.Add(paramRowQtty); parameters.Add(paramCouterFiltred); parameters.Add(paramOrderby); }
public override DataSet List(Filter f, out int RecordCount) { throw new System.NotImplementedException(); }
public override DataSet List(Filter f, out int RecordCount) { DataSet ds = new DataSet(); try { FiltroOberservaciones filtro = (FiltroOberservaciones)f; List<IDbDataParameter> paramList = new List<IDbDataParameter>(); DBRepository repository = DBRepository.GetDbRepository(); paramList.Add(repository.DbFactory.getDataParameter("P_ID", DbType.Int32, filtro.ID)); paramList.Add(repository.DbFactory.getDataParameter("P_IDOPERADOR", DbType.Int32, filtro.IDOperador)); paramList.Add(repository.DbFactory.getDataParameter("P_IDTICKET", DbType.Int32, filtro.IDTicket)); bool result = repository.ExecuteListProcedure(CONST_LIST_PROCEDURE_NAME, paramList, f, ds, out RecordCount); } catch (Exception ex) { throw ex; } return ds; }