Beispiel #1
0
        // 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";
        }
Beispiel #2
0
        // Function to populate the checkins chart
        public void CheckinChart(string bid)
        {
            SingletonDB DB    = SingletonDB.GetInstance;
            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";
        }