// AddStates() runs a query in the database that returns a table
// of all distinct states. It then populates the combobox
// with the result
public void AddStates()
{
string query = "SELECT DISTINCT state FROM yelp_business ORDER BY STATE;";
var data = database.RunQuery(query);
PopulateComboBox(data, stateComboBox);
}
// Function to populate the checkins chart
public void CheckinChart(string bid)
{
string query = String.Format("Select Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday from yelp_checkins where bid = '{0}'", bid);
var data = DB.RunQuery(query);
List <KeyValuePair <string, int> > myChartData = new List <KeyValuePair <string, int> >();
foreach (var kvp in data)
{
int checkinsPerDay = 0;
foreach (var num in data[kvp.Key][0])
{
checkinsPerDay += num;
}
myChartData.Add(new KeyValuePair <string, int>(kvp.Key, checkinsPerDay));
}
myChart.DataContext = myChartData;
myColumns.Title = "# of Checkins";
}
// Function to populate the zipcode chart
public void ZipChart(string city)
{
SingletonDB DB = SingletonDB.GetInstance;
string query = String.Format("select zipcode, count(bid) as NumBusinesses" +
" from yelp_business where city = '{0}' " +
"group by zipcode order by zipcode", city);
var data = DB.RunQuery(query);
List <KeyValuePair <string, int> > myChartData = new List <KeyValuePair <string, int> >();
for (int i = 0; i < data["zipcode"].Count; i++)
{
myChartData.Add(new KeyValuePair <string, int>(data["zipcode"][i].ToString(), Convert.ToInt32(data["numbusinesses"][i].ToString())));
}
myChart.DataContext = myChartData;
myColumns.Title = "# of businesses per Zipcode";
}
