private void cargarProductoLista()
{
try
{
string ordenar = "order by p.[nombre] asc";
List <Producto> _cache = new List <Producto>();
string armadoDeQuery = "@familiaId in(" + familiaIdHiddenField.Value + ")";
string query = consultaSql(armadoDeQuery).SqlQuery();
_totalRows = ProductoBLL.SearchProductoPaginacion(ref _cache, query, Pager1.PageSize, Pager1.CurrentRow, ordenar);
familiaForIdRepeater.DataSource = _cache;
familiaForIdRepeater.DataBind();
Pager1.TotalRows = _totalRows;
if (_cache.Count == 0)
{
noResult.Visible = true;
Pager1.Visible = false;
PagesButtons.Visible = true;
return;
}
noResult.Visible = false;
Pager1.Visible = true;
Pager1.BuildPagination();
}
catch (Exception ex)
{
log.Error("error al cargar la lista de articulos", ex);
throw ex;
//return;
}
}
private void cargarImagenesRepeateLista()
{
string ordenar = "";
//TIPO DE ORDEN
ordenar = "order by i.[titulo] asc";
try
{
Searcher searcher = new Searcher(new BusquedaImagen());
searcher.Query = SearchQueryHiddenField.Value;
List <Imagen> _cache = new List <Imagen>();
try
{
_totalRows = ImagenBLL.SearchFiles(ref _cache, searcher.SqlQuery(), Pager1.PageSize, Pager1.CurrentRow, ordenar);
}
catch (Exception ex)
{
log.Error("Error serching product:", ex);
throw ex;
//return;
}
ImagenesRepeater.DataSource = _cache;
ImagenesRepeater.DataBind();
Pager1.TotalRows = _totalRows;
if (_cache.Count == 0)
{
Pager1.Visible = false;
PagesButtons.Visible = true;
return;
}
Pager1.Visible = true;
Pager1.BuildPagination();
}
catch (Exception ex)
{
log.Error("error al cargar la lista de articulos", ex);
return;
}
}
