private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
System.Data.DataTable dt;
DateTime StartTransactionDate = DateTime.MinValue;
try
{ StartTransactionDate = Convert.ToDateTime(txtStartTransactionDate.Text); }
catch { }
DateTime EndTransactionDate = DateTime.MinValue;
try
{ EndTransactionDate = Convert.ToDateTime(txtEndTransactionDate.Text); }
catch { }
ContactReward clsContactReward;
switch (cboReportType.SelectedValue)
{
case ReportTypes.RewardsHistory:
#region RewardsHistory
clsContactReward = new ContactReward();
dt = clsContactReward.RewardsMovement(StartTransactionDate, EndTransactionDate, long.Parse(cboContactName.SelectedItem.Value));
clsContactReward.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.RewardsMovement.NewRow();
foreach (DataColumn dc in rptds.RewardsMovement.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.RewardsMovement.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.RewardsSummary:
#region RewardsSummary
clsContactReward = new ContactReward();
dt = clsContactReward.RewardsSummary(StartTransactionDate, EndTransactionDate, long.Parse(cboContactName.SelectedItem.Value));
clsContactReward.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Rewards.NewRow();
foreach (DataColumn dc in rptds.Rewards.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Rewards.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.RewardsSummaryStatistics:
#region RewardsSummaryStatistics
clsContactReward = new ContactReward();
dt = clsContactReward.SummarizedStatistics();
clsContactReward.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.RewardsSummary.NewRow();
foreach (DataColumn dc in rptds.RewardsSummary.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.RewardsSummary.Rows.Add(drNew);
}
break;
#endregion
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
