protected void LoadItems()
{
if (!HasEditPermission)
{
gvCatagoriesYad2.Columns[gvCatagoriesYad2.Columns.Count - 1].Visible = false;
}
Query qry = new Query(core.DAL.CategoryYad2.TableSchema);
qry.OrderBy(core.DAL.CategoryYad2.Columns.CategoryYad2Name, dg.Sql.SortDirection.ASC);
CategoryYad2Collection items = CategoryYad2Collection.FetchByQuery(qry);
if (items == null || items.Count == 0)
{
phHasNoItems.Visible = true;
//if no records, create collection with dummy record for gv data source only so that footer row will still be displayed, but will not be saved in cache
items = new CategoryYad2Collection();
items.Add(new CategoryYad2());
lblTotal.Text = "0";
}
else
{
phHasNoItems.Visible = false;
lblTotal.Text = items.Count.ToString();
}
gvCatagoriesYad2.DataSource = items;
gvCatagoriesYad2.DataBind();
//if first row is just a dummy - hide it
if (phHasNoItems.Visible)
{
gvCatagoriesYad2.Rows[0].Visible = false;
}
}
