private void btnGenerateReport_Click(object sender, EventArgs e)
{
try
{
List <string> selectedMonth = (List <string>)lstMonth.SelectedItems.Cast <String>().ToList();
int selectedYear = Convert.ToInt32(cmbYear.SelectedItem.ToString());
int BU = 0;
var AccountList = new List <Account>();
BU = Convert.ToInt32(lstBUAcc.SelectedValue);
AccountMonthRevenue accMonthRevenue = new AccountMonthRevenue();
DataSet ds;
if (cmbReportType.SelectedItem.ToString() == "Revenue Report")
{
ds = accMonthRevenue.AccountRevenueReportBasedOnBU(BU, selectedYear, selectedMonth);
}
else
{
ds = accMonthRevenue.AccountMarginReportBasedOnBU(BU, selectedYear, selectedMonth);
}
dgvReportView.AutoGenerateColumns = true;
dgvReportView.DataSource = ds.Tables[0];
dgvReportView.AutoResizeColumns();
dgvReportView.Show();
}
catch (Exception ex)
{
MessageBox.Show("An error occured while generating the report.\nPlease try again in sometime.");
}
}
