private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
DataTable dt;
switch (cboReportType.SelectedValue)
{
case ReportTypes.CustomerCredit:
#region Customer Credit
Customer clsCustomer = new Customer();
dt = clsCustomer.CustomersDataTable(cboContactName.SelectedItem.Text);
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.CustomerDetails.NewRow();
foreach (DataColumn dc in rptds.CustomerDetails.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.CustomerDetails.Rows.Add(drNew);
}
SalesTransactions clsSalesTransactions = new SalesTransactions(clsCustomer.Connection, clsCustomer.Transaction);
dt = clsSalesTransactions.ListForPaymentDataTable(Convert.ToInt64(cboContactName.SelectedItem.Value));
clsCustomer.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.CustomerCredit.NewRow();
foreach (DataColumn dc in rptds.CustomerCredit.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.CustomerCredit.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.CustomerCreditListWCredit:
#region Customers List With Credit
Contacts clsContact = new Contacts();
dt = clsContact.CustomerAdvanceSearch(null, cboContactName.SelectedItem.Text, cboCustomerGroup.SelectedItem.Value, true, "ContactID", SortOption.Ascending);
clsContact.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Contacts.NewRow();
foreach (DataColumn dc in rptds.Contacts.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Contacts.Rows.Add(drNew);
}
break;
#endregion
}
Report.SetDataSource(rptds);
SetParameters(Report);
}