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; } }