private void BindData()
{
int catid = 0;
if (Request.QueryString["cid"] != null)
{
try
{
catid = Convert.ToInt32(Request.QueryString["cid"].ToString());
}
catch (Exception ex)
{
catid = 0;
}
}
int subcatid = 0;
if (Request.QueryString["scid"] != null)
{
try
{
subcatid = Convert.ToInt32(Request.QueryString["scid"].ToString());
}
catch (Exception ex)
{
subcatid = 0;
}
}
string searchfor = "";
if (Request.QueryString["f"] != null)
{
try
{
searchfor = Request.QueryString["f"].ToString();
}
catch (Exception ex)
{
searchfor = "";
}
}
PagedDataSource dt = new PagedDataSource();
Companies objData = new Companies();
if (!string.IsNullOrEmpty(searchfor) && searchfor == "sh")
objData.SearchCompaniesForShipping(subcatid);
else if (!string.IsNullOrEmpty(searchfor) && searchfor == "off")
{
objData.SearchCompaniesForOffers(catid, subcatid);
}
else
{
objData.SearchCompanies("", 0, catid, subcatid);
}
Categories cat = new Categories();
cat.LoadByPrimaryKey(catid);
SubCategories subcat = new SubCategories();
subcat.LoadByPrimaryKey(subcatid);
dt.DataSource = objData.DefaultView;
dt.AllowPaging = true;
dt.PageSize = 10;
dt.CurrentPageIndex = PageIndex;
if (objData.RowCount > 0 && dt != null)
{
if(cat.RowCount > 0 )
uiLabelTitle.Text = " - " + cat.EnName;
if (subcat.RowCount > 0)
uiLabelTitle.Text += " -> " + subcat.EnName;
uiRepeaterResults.DataSource = dt;
uiRepeaterResults.DataBind();
uiLinkButtonPrev.Enabled = !dt.IsFirstPage;
uiLinkButtonNext.Enabled = !dt.IsLastPage;
uiLabelPages.Text = "Page " + (PageIndex + 1).ToString() + " of " + dt.PageCount.ToString() + " Pages";
uiPanelNoResults.Visible = false;
uiPanelResults.Visible = true;
}
else
{
uiPanelNoResults.Visible = true;
uiPanelResults.Visible = false;
}
}
