//Função que renderiza os gráficos de pizza de acordo com as informações vindas do banco de dados
protected internal void renderIncomeChart(System.Windows.Forms.DataVisualization.Charting.Chart chart, string query, DataRow accountDataRow)
{
chart.Palette = System.Windows.Forms.DataVisualization.Charting.ChartColorPalette.None;
chart.PaletteCustomColors = Globals.myPalette;
DataTable dataTable = Database.query(query);
if (dataTable.Rows.Count > 0)
{
chart.Show();
foreach (DataRow dataRow in dataTable.Rows)
{
string category = accountDataRow.ItemArray[1].ToString().Trim();
if ((!string.IsNullOrEmpty(dataRow.ItemArray[0].ToString().Trim())) && ((Convert.ToInt32(dataRow.ItemArray[0])) != 0))
{
string graph = dataRow.ItemArray[0].ToString().Trim();
string sum = String.Format("{0:C}", dataRow.ItemArray[0]);
string label = category + "\n" + sum;
chart.Series[0].Points.AddXY(label, graph);
}
}
}
else
{
chart.Hide();
}
}
