public void FilterCompanies()
{
Companies comp = new Companies();
comp.SearchCompanies(uiTextBoxSearch.Text,0,Convert.ToInt32(uiDropDownListCategoryFilter.SelectedValue), Convert.ToInt32(uiDropDownListSubCategoryFilter.SelectedValue));
uiGridViewCompanies.DataSource = comp.DefaultView;
uiGridViewCompanies.DataBind();
}
private void LoadCompanies(int catid, int subcatid)
{
PagedDataSource dt = new PagedDataSource();
Companies objData = new Companies();
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.ArName;
if (subcat.RowCount > 0)
uiLabelTitle.Text += " -> " + subcat.ArName;
uiRepeaterResults.DataSource = dt;
uiRepeaterResults.DataBind();
uiLinkButtonPrev.Enabled = !dt.IsFirstPage;
uiLinkButtonNext.Enabled = !dt.IsLastPage;
uiLabelPages.Text = "صفحة " + (PageIndex + 1).ToString() + " من " + dt.PageCount.ToString() + " صفحات";
uiPanelNoResults.Visible = false;
uiPanelResults.Visible = true;
uiPanelCategories.Visible = false;
}
else
{
uiPanelNoResults.Visible = true;
uiPanelResults.Visible = false;
uiPanelCategories.Visible = false;
}
}
private void LoadDDLs()
{
Companies comp = new Companies();
comp.SearchCompanies("", 0, 1, 1);
uiDropDownListCompanies.DataSource = comp.DefaultView;
uiDropDownListCompanies.DataTextField = "ArName";
uiDropDownListCompanies.DataValueField = "CompanyID";
uiDropDownListCompanies.DataBind();
Companies comp1 = new Companies();
comp1.SearchCompanies("", 0, 1, 1);
uiDropDownListCompanyUpload.DataSource = comp1.DefaultView;
uiDropDownListCompanyUpload.DataTextField = "ArName";
uiDropDownListCompanyUpload.DataValueField = "CompanyID";
uiDropDownListCompanyUpload.DataBind();
AirPorts city = new AirPorts();
city.LoadAll();
uiDropDownListFromCity.DataSource = city.DefaultView;
uiDropDownListToCity.DataSource = city.DefaultView;
uiDropDownListFromCity.DataTextField = "EnName";
uiDropDownListToCity.DataTextField = "EnName";
uiDropDownListFromCity.DataValueField = "AirPortID";
uiDropDownListToCity.DataValueField = "AirPortID";
uiDropDownListFromCity.DataBind();
uiDropDownListToCity.DataBind();
}
private void BindData()
{
PagedDataSource dt = new PagedDataSource();
Companies objData = new Companies();
int cityid = 0;
int catid = 0;
int scatid = 0;
int fromport = 0;
int toport = 0;
bool IsAir = false;
bool IsShipping = false;
string filter = "";
if (Request.QueryString["q"] != null)
{
if (!string.IsNullOrEmpty(Request.QueryString["q"].ToString()))
{
filter = Request.QueryString["q"].ToString();
}
}
if (Request.QueryString["cat"] != null)
{
if (!string.IsNullOrEmpty(Request.QueryString["cat"].ToString()))
{
try
{
catid = Convert.ToInt32(Request.QueryString["cat"].ToString());
}
catch (Exception ex)
{
catid = 0;
}
}
}
if (Request.QueryString["scat"] != null)
{
if (!string.IsNullOrEmpty(Request.QueryString["scat"].ToString()))
{
try
{
scatid = Convert.ToInt32(Request.QueryString["scat"].ToString());
}
catch (Exception ex)
{
scatid = 0;
}
}
}
if (Request.QueryString["cid"] != null)
{
if (!string.IsNullOrEmpty(Request.QueryString["cid"].ToString()))
{
try
{
cityid = Convert.ToInt32(Request.QueryString["cid"].ToString());
}
catch (Exception ex)
{
cityid = 0;
}
}
}
if (Request.QueryString["fcid"] != null)
{
if (!string.IsNullOrEmpty(Request.QueryString["fcid"].ToString()))
{
try
{
fromport = Convert.ToInt32(Request.QueryString["fcid"].ToString());
}
catch (Exception ex)
{
fromport = 0;
}
}
}
if (Request.QueryString["tcid"] != null)
{
if (!string.IsNullOrEmpty(Request.QueryString["tcid"].ToString()))
{
try
{
toport = Convert.ToInt32(Request.QueryString["tcid"].ToString());
}
catch (Exception ex)
{
toport = 0;
}
}
}
if (Request.QueryString["al"] != null)
{
if (!string.IsNullOrEmpty(Request.QueryString["al"].ToString()))
{
try
{
IsAir = Convert.ToBoolean(Request.QueryString["al"].ToString());
}
catch (Exception ex)
{
IsAir = false;
}
}
}
if (Request.QueryString["sl"] != null)
{
if (!string.IsNullOrEmpty(Request.QueryString["sl"].ToString()))
{
try
{
IsShipping = Convert.ToBoolean(Request.QueryString["sl"].ToString());
}
catch (Exception ex)
{
IsShipping = false;
}
}
}
if (!IsAir && !IsShipping)
{
objData.SearchCompanies(filter, cityid, catid, scatid);
}
else if (IsAir)
{
objData.SearchCompaniesForAirLines(fromport, toport);
}
else if (IsShipping)
{
objData.SearchCompaniesForSeaLines(fromport, toport);
}
dt.DataSource = objData.DefaultView;
dt.AllowPaging = true;
dt.PageSize = 10;
dt.CurrentPageIndex = PageIndex;
if (objData.RowCount > 0 && dt != null)
{
uiPanelResults.Visible = true;
uiPanelNoResults.Visible = false;
uiRepeaterResults.DataSource = dt;
uiRepeaterResults.DataBind();
uiLinkButtonPrev.Enabled = !dt.IsFirstPage;
uiLinkButtonNext.Enabled = !dt.IsLastPage;
uiLabelPages.Text = "Page " + (PageIndex + 1).ToString() + " of " + dt.PageCount.ToString() + " Pages";
}
else
{
uiPanelResults.Visible = false;
uiPanelNoResults.Visible = true;
}
}
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;
}
}
