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