private ChartJumlahObat GetChartJumlahObat(string sp)
{
ChartJumlahObat chartJumlahObat = new ChartJumlahObat();
SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConString"]);
connection.Open();
SqlCommand cmd = new SqlCommand(sp, connection);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader RDR = cmd.ExecuteReader();
while (RDR.Read())
{
chartJumlahObat.jumlah.Add(Convert.ToInt32(RDR["jumlah"]));
chartJumlahObat.bulan.Add(RDR["bulan"].ToString());
}
connection.Close();
return(chartJumlahObat);
}
private void refreshGrafikJumlahObat()
{
ChartJumlahObat chartPenjualan = GetChartJumlahObat("sp_chartPenjualan");
ChartJumlahObat chartPembelian = GetChartJumlahObat("sp_chartPembelian");
CartesianChart ch = new CartesianChart();
ch.Foreground = new SolidColorBrush(Colors.Black);
ch.Series = new SeriesCollection
{
new ColumnSeries
{
Title = "Penjualan",
Values = new ChartValues <int>(chartPenjualan.jumlah)
},
new ColumnSeries
{
Title = "Pembelian",
Values = new ChartValues <int>(chartPembelian.jumlah)
}
};
ch.AxisX.Add(new Axis
{
Title = "Bulan",
Labels = chartPenjualan.bulan,
Separator = new Separator
{
Step = 1
}
});
ch.AxisY.Add(new Axis
{
Title = "Jumlah Obat",
});
jumlahObatChart.Children.Add(ch);
}
