protected void populateLstBoxBusinessUnitName(int code, string str) { Database dbObj = new Database(HyperCatalog.Business.ApplicationSettings.Components["Datawarehouse_DB"].ConnectionString); if (str.Equals("First")) { BusinessList.DataSource = dbObj.RunSPReturnDataSet("dbo._GetAllBusinessNames", new SqlParameter[] { new SqlParameter("@Code", code) }); BusinessList.DataValueField = "Code"; BusinessList.DataTextField = "BizName"; BusinessList.DataBind(); BusinessList.Items.Insert(0, "All"); BusinessList.SelectedIndex = 0; BusinessList.Visible = true; } if (str.Equals("Second")) { BusinessList1.DataSource = dbObj.RunSPReturnDataSet("dbo._GetAllBusinessNames", new SqlParameter[] { new SqlParameter("@Code", code) }); BusinessList1.DataValueField = "Code"; BusinessList1.DataTextField = "BizName"; BusinessList1.DataBind(); BusinessList1.Items.Insert(0, "All"); BusinessList1.SelectedIndex = 0; BusinessList1.Visible = true; } }
protected void SearchResID_Click(object sender, EventArgs e) { string city = SelectState.SelectedItem.Value; string searchbar = SearchBox.Text; if (searchbar != "" && city != "0") { BusinessList.DataSource = fdp.getBusinessList(city, searchbar); BusinessList.DataBind(); } else if (searchbar == "" && city != "0") { BusinessList.DataSource = fdp.getBusinessList(city); BusinessList.DataBind(); } else if (city == "0" && searchbar != "") { BusinessList.DataSource = fdp.getBusinessListbycity(searchbar); BusinessList.DataBind(); } if (Panel2.Visible == false) { Panel2.Visible = true; } }
protected void Buttons_Click(object sender, EventArgs e) { string city = SelectState.SelectedItem.Value; string searchbar = SearchBox.Text; LinkButton Button1 = (LinkButton)sender; BusinessList.DataSource = fdp.getBusinessListbyCategory(searchbar, city, Button1.CommandArgument.ToString()); BusinessList.DataBind(); catid = Button1.CommandArgument.ToString(); if (Panel2.Visible == false) { Panel2.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { Database dbObj = new Database(HyperCatalog.Business.ApplicationSettings.Components["Datawarehouse_DB"].ConnectionString); if (!Page.IsPostBack) { DataSet ds1 = new DataSet(); this.code = 0; OrgName.Checked = true; populateLstBoxBusinessUnitName(code); ds1 = dbObj.RunSPReturnDataSet("dbo._GetAllBusinessNamesByAccessories", new SqlParameter[] { new SqlParameter("@Code", code) }); BUType.Text = "OrgName"; BUType.Visible = true; BusinessList.DataSource = ds1; if (this.code == 3) { BusinessList.DataValueField = "Code"; BusinessList.DataTextField = "Code"; } else { BusinessList.DataValueField = "Code"; BusinessList.DataTextField = "BizName"; } BusinessList.DataBind(); BusinessList.Items.Insert(0, "All"); BusinessList.SelectedIndex = 0; BusinessList.Visible = true; DataSet ds2 = new DataSet(); ds2 = dbObj.RunSPReturnDataSet("_GetRegion"); if (dbObj.LastError == string.Empty || ds2.Tables[0].Rows.Count > 0) { ddlGeography.DataSource = ds2.Tables[0].DefaultView; ddlGeography.DataTextField = "RegionName"; ddlGeography.DataValueField = "ShortCode"; ddlGeography.DataBind(); ddlGeography.Visible = true; } dbObj.CloseConnection(); dbObj.Dispose(); } }
protected void Page_Load(object sender, EventArgs e) { Database dbObj = new Database(HyperCatalog.Business.ApplicationSettings.Components["Datawarehouse_DB"].ConnectionString); //DataSet ds = new DataSet(); if (!Page.IsPostBack) { DataSet ds = new DataSet(); ds = dbObj.RunSPReturnDataSet("_getLinks"); if (dbObj.LastError == string.Empty || ds.Tables[0].Rows.Count > 0) { Linksdropdown.DataSource = ds.Tables[0].DefaultView; Linksdropdown.DataTextField = "LinkTypeName"; Linksdropdown.DataValueField = "LinkTypeId"; Linksdropdown.DataBind(); Linksdropdown.Visible = true; } DataSet ds1 = new DataSet(); this.code = 0; this.code1 = 0; ds1 = dbObj.RunSPReturnDataSet("dbo._GetAllBusinessNames", new SqlParameter[] { new SqlParameter("@Code", code) }); BUType.Text = "OrgName"; BUType.Visible = true; BusinessList.DataSource = ds1; BusinessList.DataValueField = "Code"; BusinessList.DataTextField = "BizName"; BusinessList.DataBind(); BusinessList.Items.Insert(0, "All"); BusinessList.SelectedIndex = 0; BusinessList.Visible = true; BUType1.Text = "OrgName"; BUType1.Visible = true; BusinessList1.DataSource = ds1; BusinessList1.DataValueField = "Code"; BusinessList1.DataTextField = "BizName"; BusinessList1.DataBind(); BusinessList1.Items.Insert(0, "All"); BusinessList1.SelectedIndex = 0; BusinessList1.Visible = true; DataSet ds2 = new DataSet(); ds2 = dbObj.RunSPReturnDataSet("_GetRegion"); if (dbObj.LastError == string.Empty || ds2.Tables[0].Rows.Count > 0) { CulturesList.DataSource = ds2.Tables[0].DefaultView; CulturesList.DataTextField = "RegionName"; CulturesList.DataValueField = "ShortCode"; CulturesList.DataBind(); CulturesList.Items.Insert(0, "All"); CulturesList.SelectedIndex = 0; CulturesList.Visible = true; CulturesList1.DataSource = ds2.Tables[0].DefaultView; CulturesList1.DataTextField = "RegionName"; CulturesList1.DataValueField = "ShortCode"; CulturesList1.DataBind(); CulturesList1.Items.Insert(0, "All"); CulturesList1.SelectedIndex = 0; CulturesList1.Visible = true; } } }