private void loadLineChart()
{
LineChart1.ChartTitle = "Number of Umaapaw na Flush sa Isang Taon";
LineChartSeries sample = new LineChartSeries();
decimal[] set1 = {
new decimal(5),
new decimal(10),
new decimal(15),
new decimal(20),
new decimal(25),
new decimal(30),
};
sample.Data = set1;
sample.Name = "Amiel";
sample.LineColor = "#000000";
LineChart1.Series.Add(sample);
LineChart1.DataBind();
}
private void BindChart()
{
// line chart is very slow to render when there are lots of data points
// bar chart is much faster
zgSales.Visible = false;
lcSales.Visible = true;
if (salesByMonthData == null) { salesByMonthData = CommerceReport.GetSalesByYearMonthByModule(moduleGuid); }
StringBuilder categories = new StringBuilder();
string comma = string.Empty;
List<decimal> revenue = new List<decimal>();
// original data is sorted descending on Y, M resorting here
DataRow[] result = salesByMonthData.Select(string.Empty, "Y ASC, M ASC");
int spaceInterval = 0;
int totalItems = result.Length;
int itemsAdded = 0;
if (totalItems > 12)
{
spaceInterval = 4;
}
int nextItemToShow = 0;
foreach (DataRow row in result)
{
categories.Append(comma);
if (itemsAdded == nextItemToShow)
{
categories.Append(row["Y"].ToString());
categories.Append("-");
categories.Append(row["M"].ToString());
nextItemToShow = itemsAdded + spaceInterval;
}
comma = ",";
revenue.Add(Convert.ToDecimal(row["Sales"]));
itemsAdded += 1;
}
lcSales.ChartTitle = Resource.SalesByMonthChartLabel;
lcSales.CategoriesAxis = categories.ToString();
LineChartSeries series = new LineChartSeries();
series.Name = Resource.SalesByMonthChartSalesLabel;
series.Data = revenue.ToArray();
lcSales.Series.Add(series);
//bcSales.CategoriesAxis
//bcSales.Series.
}