private void LoadMembers() { ContactReward clsContactReward = new ContactReward(); DataTable dtActiveStatisticsReport = clsContactReward.ActiveStatisticsReport(DateTime.Now.AddMonths(-1), DateTime.Now); clsContactReward.CommitAndDispose(); if (dtActiveStatisticsReport.Rows.Count == 0) { Chart1.Visible = false; } else { Chart1.Visible = true; Chart1.DataSource = dtActiveStatisticsReport.DefaultView; Chart1.Series["Series1"].XValueMember = "RewardAwardDate"; Chart1.Series["Series1"].YValueMembers = "TotalNoOfActiveRewards"; Chart1.Series["Series2"].XValueMember = "RewardAwardDate"; Chart1.Series["Series2"].YValueMembers = "NoOfActiveRewards"; Chart1.Series["Series3"].XValueMember = "RewardAwardDate"; Chart1.Series["Series3"].YValueMembers = "TotalNoOfInActiveRewards"; Chart1.Series["Series4"].XValueMember = "RewardAwardDate"; Chart1.Series["Series4"].YValueMembers = "NoOfInActiveRewards"; Chart1.ChartAreas["ChartArea1"].AxisX.MajorGrid.LineWidth = 0; Chart1.ChartAreas["ChartArea1"].AxisY.MajorGrid.LineWidth = 0; Chart1.Series["Series1"].LegendText = "Total No. Of ActiveRewards"; Chart1.Series["Series2"].LegendText = "No. Of New ActiveRewards"; Chart1.Series["Series3"].LegendText = "Total No. Of InActiveRewards"; Chart1.Series["Series4"].LegendText = "No. Of InActiveRewards"; Chart1.DataBind(); } }
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); }