private void Zip_lb_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
string s = (sender as ListBox).SelectedItem as string;
if (s != null)
{
ObservableCollection <string> tmp = mydb.SQLSELECTExec("SELECT population,avg_income,under18years,18_to_24years,25_to_44years, 45_to_64years, 65_and_over, median_age FROM censusdata WHERE zipcode = '"
+ s + "';");
population_tb.Text = tmp[0];
aver_inc_tb.Text = tmp[1];
age_under_18_tb.Text = tmp[2];
age_18_to_24_tb.Text = tmp[3];
age_25_to_44_tb.Text = tmp[4];
age_45_to_64_tb.Text = tmp[5];
age_65_and_older_tb.Text = tmp[6];
medi_age_tb.Text = tmp[7];
}
}
// *** IMPORTANT !! ***
//It is super werid that combo box selection is string, and by default the SelectedItem is "__blank__", which may cause the unexpected error
// *** Very Important !!!!!!! ***
public MainWindow()
{
InitializeComponent();
mydb = new MySql_Connection();
State_cb.ItemsSource = mydb.SQLSELECTExec("SELECT DISTINCT state FROM censusdata ORDER BY state; ", "state");
State_cb.SelectionChanged += State_cb_SelectionChanged;
city_lb.SelectionChanged += City_lb_SelectionChanged;
zip_lb.SelectionChanged += Zip_lb_SelectionChanged;
}
// *** IMPORTANT !! ***
//It is super weird that combo box selection is string, and by default the SelectedItem is "__blank__", which may cause the unexpected error
// *** Very Important !!!!!!! ***
public MainWindow()
{
InitializeComponent();
List <string> val = new List <string>();
val.Add("21plus");
val.Add("allages");
cons.Add("Ages_Allowed", val);
val = new List <string>();
val.Add("none");
val.Add("full_bar");
val.Add("beer_and_wine");
cons.Add("Alcohol", val);
val = new List <string>();
val.Add("casual");
val.Add("dressy");
val.Add("formal");
cons.Add("Attire", val);
val = new List <string>();
val.Add("yes_free");
val.Add("no");
val.Add("yes_corkage");
cons.Add("BYOBCorkage", val);
val = new List <string>();
val.Add("average");
val.Add("loud");
val.Add("very_loud");
val.Add("quiet");
cons.Add("Noise_Level", val);
val = new List <string>();
val.Add("no");
val.Add("free");
val.Add("paid");
cons.Add("Wi_Fi", val);
tabControl.SelectedIndex = 1;
/**** Sync btw tab0 and tab1 ****/
//tb2Categories.ItemsSource = Categories.Items;
//tb2State_cb.ItemsSource = State_cb.Items;
/* ************ tab0 *********************** */
mydb = new MySql_Connection();
State_cb.ItemsSource = mydb.SQLSELECTExec("SELECT DISTINCT state FROM censusdata ORDER BY state; ", "state");
State_cb.SelectionChanged += State_cb_SelectionChanged;
State_cb.SelectionChanged += enableUpdate;
city_lb.SelectionChanged += City_lb_SelectionChanged;
zip_lb.SelectionChanged += Zip_lb_SelectionChanged;
mydb2 = new MySql_ConnectionTwo();
//Categories.ItemsSource = onTest();
Categories.ItemsSource = mydb2.SQLSELECTExec("select distinct category from category order by category;");
Categories.SelectionChanged += onSelectedCat;
Categories.SelectionChanged += enableUpdate;
// Categories.SelectedItemChanged += onModifySel;
//Selected_Categories.DataContextChanged +=(s,e)=> { MessageBox.Show("S"); };
Selected_Categories.SelectionChanged += (sender, e) => { Selected_Categories.Items.Remove(Selected_Categories.SelectedItem); };
Selected_Categories.SelectionChanged += enableUpdate;
/**********************************************************************/
/******************** tab 1 ********************/
tb2State_cb.ItemsSource = mydb2.SQLSELECTExec("SELECT DISTINCT state FROM business ORDER BY state;", "state");
tb2Categories.ItemsSource = Categories.Items;
tb2State_cb.SelectionChanged += tb2State_cb_SelectionChanged;
tb2city_lb.SelectionChanged += tb2City_lb_SelectionChanged;
tb2Categories.SelectionChanged += tb2onSelectedCat;
tb2Categories.SelectionChanged += enableSearch;
tb2Categories.SelectionChanged += getAttrs;
tb2Selected_Categories.SelectionChanged += (sender, e) => { tb2Selected_Categories.Items.Remove(tb2Selected_Categories.SelectedItem); };
tb2Selected_Categories.SelectionChanged += enableSearch;
tb2Selected_Categories.SelectionChanged += getAttrs;
tb2Selected_Categories.SelectionChanged += AttrSetVals;
NoState.Checked += NoState_Checked;
NoState.Unchecked += NoState_Checked;
//tb2State_cb.IsEnabled = false;
//tb2city_lb.IsEnabled = false;
//tb2zip_lb.IsEnabled = false;
/************************************************************************/
for (int i = 0; i < 6; i++)
{
MinRat.Items.Add(i);
MaxRat.Items.Add(i);
}
for (int i = 0; i <= Int32.Parse(mydb2.SQLSELECTExec("select max(review_count) from business;")[0]); i++)
{
MinRev.Items.Add(i);
MaxRev.Items.Add(i);
}
val = new List <string>();
for (int i = 0; i <= Int32.Parse(mydb2.SQLSELECTExec("select max(val) from attributes where attr='price_range';")[0]); i++)
{
val.Add(i.ToString());
}
cons.Add("Price_Range", val);
//US states translate btw full and abbr.
using (TextFieldParser data = new TextFieldParser("../../usstate.txt"))
{
data.TextFieldType = FieldType.Delimited;
data.SetDelimiters(" ");
while (!data.EndOfData)
{
var array = data.ReadFields();
string abbreviation = array[0];
string state_name = null;
if (array.Length > 2)
{
for (int i = 1; i < array.Length; i++)
{
if (i != array.Length - 1)
{
state_name += array[i] + " ";
}
else
{
state_name += array[i];
}
}
}
else
{
state_name = array[1];
}
all_state.Add(state_name, abbreviation);
all_state.Add(abbreviation, abbreviation);
}
//data.Dispose();
}
}