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