/// <summary>
/// Function to call from CashFlow
/// </summary>
public void CashflowCommonGridFill()
{
decimal decBalanceTotal = 0;
try
{
AccountGroupBll bllAccountGroup = new AccountGroupBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllAccountGroup.CashflowAccountGroupWiseReportViewAll(decAccountGroupId, Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text));
dgvAccountGroupWiseReport.DataSource = ListObj[0];
if (ListObj[0].Rows.Count > 0)
{
for (int i = 0; i < dgvAccountGroupWiseReport.RowCount; i++)
{
decBalanceTotal += Convert.ToDecimal(dgvAccountGroupWiseReport.Rows[i].Cells["balance1"].Value.ToString());
}
}
if (decBalanceTotal < 0)
{
decBalanceTotal = -1 * decBalanceTotal;
lblBalanceTotal.Text = decBalanceTotal.ToString() + "Cr";
}
else
{
lblBalanceTotal.Text = decBalanceTotal.ToString() + "Dr";
}
}
catch (Exception ex)
{
MessageBox.Show("AGWREP09:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}