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 static List <Ticket> List(FiltroTicket f, out int RecordCount)
{
List <Ticket> resultList = new List <Ticket>();
try
{
TicketDS dataservice = new TicketDS();
DataSet ds = dataservice.List(f, out RecordCount);
if (ds.Tables.Count > 0)
{
foreach (DataRow r in ds.Tables[0].Rows)
{
Ticket t = new Ticket();
ORM(t, r);
resultList.Add(t);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(resultList);
}
public void CargarListadoID(FiltroTicket filtro, int pageNumber)
{
int idSearch;
List <Entities.InterAsisst.Ticket> listaAfiliados = new List <Ticket>();
int totalRegistros = 0;
if (Int32.TryParse(filtro.Search, out idSearch))
{
Ticket t = Ticket.GetById(idSearch);
if (t != null)
{
listaAfiliados.Add(t);
totalRegistros = 1;
}
}
this.ShowList(totalRegistros > 0);
this.lbltxtCantidadRegistros.Text = totalRegistros.ToString();
this.dtgTickets.CurrentPageIndex = pageNumber - 1;
this.dtgTickets.VirtualItemCount = totalRegistros;
this.dtgTickets.DataSource = listaAfiliados;
this.dtgTickets.DataBind();
}
public void CargarListado(FiltroTicket filtro, int pageNumber)
{
int totalRegistros;
filtro.PageSize = PAGE_SIZE;
filtro.IsPaged = true;
filtro.StartRow = ((pageNumber - 1) * PAGE_SIZE) + 1;
filtro.OrderBY = " order by fecha desc";
List <Entities.InterAsisst.Ticket> listaAfiliados = Entities.InterAsisst.Ticket.List((FiltroTicket)filtro, out totalRegistros);
this.Filtro.FiltredRowsQtty = totalRegistros;
this.ShowList(totalRegistros > 0);
this.lbltxtCantidadRegistros.Text = totalRegistros.ToString();
this.dtgTickets.CurrentPageIndex = pageNumber - 1;
this.dtgTickets.VirtualItemCount = totalRegistros;
this.dtgTickets.DataSource = listaAfiliados;
this.dtgTickets.DataBind();
}
public static List <Ticket> List(FiltroTicket f)
{
int r;
return(List(f, out r));
}
