public void ColumnChart(List <Classes.Checkins> checkinList)
{
Classes.Checkins GetSort = new Classes.Checkins();
checkinList = GetSort.SortDays(checkinList);
chartData = new List <KeyValuePair <string, int> >();
if (checkinList != null)
{
foreach (Classes.Checkins item in checkinList)
{
chartData.Add(new KeyValuePair <string, int>(item.checkin_day, item.checkin_count));
}
}
newChart.DataContext = chartData;
}
public List <Classes.Checkins> GetBusinessCheckinDays(Classes.Business business)
{
query = new Dictionary <string, List <string> >();
query.Add(sq.SQL_PROJECT, new List <string>()
{
sq.SQL_SELECTDIST, c.CHK_day
});
query.Add(sq.SQL_FROM, new List <string>()
{
sq.SQL_FROM, c.CHK_table
});
query.Add(sq.SQL_WHERE, new List <string>()
{
c.B_id
});
query.Add(sq.SQL_COND, new List <string>()
{
business.business_id
});
query.Add(sq.SQL_ORDER, new List <string>()
{
sq.SQL_ORDER, ";", c.CHK_day
});
List <Object[]> newObject = newQuery.SQLSelectQuery(query);
var checkinList = new List <Classes.Checkins>();
foreach (var item in newObject)
{
var newCheckin = new Classes.Checkins()
{
checkin_day = item[0].ToString()
};
checkinList.Add(newCheckin);
}
return(checkinList);
}
