public void GetAnalyticsByMonth(DataGridView dataGridView, Chart chartColumn)
{
var transaction = _analyticsService.GetAnalyticsByMonth();
var credit = transaction.Select(x => x.Credit).ToList();
var debit = transaction.Select(x => - x.Debit).ToList();
var balance = transaction.Select(x => x.Balance).ToList();
var month = transaction.Select(x => x.Date.ToString("MMM")).ToList();
chartColumn.Series[0].Points.DataBindXY(month, credit);
chartColumn.Series[1].Points.DataBindXY(month, debit);
chartColumn.Series[2].Points.DataBindXY(month, balance);
dataGridView.DataSource = transaction;
}
