private void LoadCultures()
{
List <CultureItem> list = new List <CultureItem>();
foreach (CultureInfo ci in CultureInfo.GetCultures(CultureTypes.AllCultures))
{
if (Regex.IsMatch(ci.IetfLanguageTag, @"^[a-z]{2}(-[A-Z]{2})?$"))
{
if (string.IsNullOrWhiteSpace(CodeText.Text) ||
ci.IetfLanguageTag.ToLowerInvariant().Contains(CodeText.Text.ToLowerInvariant()))
{
list.Add(new CultureItem(ci));
}
}
}
list.Sort();
string selectedCode = null;
if (CulturesList.SelectedItem is CultureItem)
{
selectedCode = ((CultureItem)CulturesList.SelectedItem).CultureInfo.IetfLanguageTag;
}
updating = true;
CulturesList.Items.Clear();
foreach (CultureItem ci in list)
{
CulturesList.Items.Add(ci);
if (ci.CultureInfo.IetfLanguageTag == selectedCode)
{
CulturesList.SelectedItem = ci;
}
}
if (CulturesList.SelectedIndex >= 0)
{
CulturesList.ScrollIntoView(CulturesList.SelectedItem);
}
updating = false;
}
private void CodeText_TextChanged(object sender, TextChangedEventArgs e)
{
if (updating)
{
return;
}
LoadCultures();
CultureItem selci = CulturesList.Items.OfType <CultureItem>()
.FirstOrDefault(ci => ci.CultureInfo.IetfLanguageTag.Equals(CodeText.Text, StringComparison.InvariantCultureIgnoreCase));
AddButton.IsEnabled = selci != null;
if (selci != null)
{
CulturesList.SelectedItem = selci;
CulturesList.ScrollIntoView(selci);
UpdateSystemKeysCheckBox(selci.CultureInfo.Name);
}
else
{
UpdateSystemKeysCheckBox(null);
}
}
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;
}
}
}
