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;
}
