protected void FillForm() { try { if (!CheckIsValidStartEndDates()) { return; } DataTable tblStats = OrganisationDB.GetStats(GetFromDate(), GetToDate(), UserView.GetInstance().IsClinicView ? 5 : 6, chkIncDeleted.Checked); lstOrgStats.DataSource = tblStats; lstOrgStats.DataBind(); // get from footer Label lblSum_TotalBookings = (Label)lstOrgStats.Controls[lstOrgStats.Controls.Count - 1].Controls[0].FindControl("lblSum_TotalBookings"); Label lblSum_AvgConsultTime = (Label)lstOrgStats.Controls[lstOrgStats.Controls.Count - 1].Controls[0].FindControl("lblSum_AvgConsultTime"); Label lblSum_Bookings = (Label)lstOrgStats.Controls[lstOrgStats.Controls.Count - 1].Controls[0].FindControl("lblSum_Bookings"); Label lblSum_Patients = (Label)lstOrgStats.Controls[lstOrgStats.Controls.Count - 1].Controls[0].FindControl("lblSum_Patients"); lblSum_TotalBookings.Text = String.Format("{0:n0}", tblStats.Compute("Sum(total_bookings)", "")); decimal total = 0; int count = 0; for (int i = 0; i < tblStats.Rows.Count; i++) { if (tblStats.Rows[i]["avg_minutes"] == DBNull.Value) { continue; } total += Convert.ToDecimal(tblStats.Rows[i]["avg_minutes"]); count++; } if (count > 0) { lblSum_AvgConsultTime.Text = String.Format("{0:n0}", total / count); } lblSum_Bookings.Text = String.Format("{0:n0}", tblStats.Compute("Sum(n_bookings)", "")); lblSum_Patients.Text = String.Format("{0:n0}", tblStats.Compute("Sum(n_patients)", "")); } catch (CustomMessageException cmEx) { HideTableAndSetErrorMessage(cmEx.Message); } catch (Exception ex) { HideTableAndSetErrorMessage(Utilities.IsDev() ? ex.ToString() : string.Empty); } }
protected void FillForm() { try { if (!CheckIsValidStartEndDates()) { return; } SeriesChartType chartType = SeriesChartType.StackedBar; if (ddlChartType.SelectedValue == "Pie") { chartType = SeriesChartType.Pie; } if (ddlChartType.SelectedValue == "Doughnut") { chartType = SeriesChartType.Doughnut; } if (ddlChartType.SelectedValue == "StackedBar") { chartType = SeriesChartType.StackedBar; } if (ddlChartType.SelectedValue == "Area") { chartType = SeriesChartType.Area; } if (ddlChartType.SelectedValue == "BoxPlot") { chartType = SeriesChartType.BoxPlot; } if (ddlChartType.SelectedValue == "Column") { chartType = SeriesChartType.Column; } if (ddlChartType.SelectedValue == "Line") { chartType = SeriesChartType.Line; } if (ddlChartType.SelectedValue == "Point") { chartType = SeriesChartType.Point; } if (ddlChartType.SelectedValue == "Range") { chartType = SeriesChartType.Range; } if (ddlChartType.SelectedValue == "RangeBar") { chartType = SeriesChartType.RangeBar; } if (ddlChartType.SelectedValue == "RangeColumn") { chartType = SeriesChartType.RangeColumn; } chartOrgStats.Series["Series1"].ChartType = chartType; DataTable tblStats = OrganisationDB.GetStats(GetFromDate(), GetToDate(), UserView.GetInstance().IsClinicView ? 5 : 6, chkIncDeleted.Checked); int maxToShow = 350; if (tblStats.Rows.Count > maxToShow) { for (int i = tblStats.Rows.Count - 1; i >= maxToShow; i--) { tblStats.Rows.RemoveAt(i); } } DataView dv = tblStats.DefaultView; string field = string.Empty; if (ddlType.SelectedValue == "New Bookings Added By") { field = "n_bookings"; } if (ddlType.SelectedValue == "New Patients") { field = "n_patients"; } if (ddlType.SelectedValue == "Total Bookings") { field = "total_bookings"; } dv.Sort = field; chartOrgStats.Titles[0].Text = ddlType.SelectedValue; chartOrgStats.Series["Series1"].Points.DataBindXY(dv, "name", dv, field); lblChartHeading.Text = ddlType.SelectedValue; if (chartType == SeriesChartType.StackedBar) { chartOrgStats.Height = new Unit((tblStats.Rows.Count * 30), UnitType.Pixel); } chartOrgStats.ChartAreas["ChartArea1"].AxisX.MinorTickMark.Enabled = false; chartOrgStats.ChartAreas["ChartArea1"].AxisX.Interval = 1; chartOrgStats.ChartAreas["ChartArea1"].AxisX.IsLabelAutoFit = true; //chartOrgStats.ChartAreas["ChartArea1").AxisX.LabelStyle.IsStaggered = True //chartOrgStats.ChartAreas["ChartArea1"].AxisX.LabelAutoFitStyle = System.Web.UI.DataVisualization.Charting.LabelAutoFitStyles.DecreaseFont; chartOrgStats.ChartAreas["ChartArea1"].AxisY.Enabled = System.Web.UI.DataVisualization.Charting.AxisEnabled.False; if (chartType == SeriesChartType.Pie || chartType == SeriesChartType.Doughnut) { chartOrgStats.Legends.Add("Legend1"); chartOrgStats.Legends["Legend1"].Enabled = true; chartOrgStats.Legends["Legend1"].Docking = System.Web.UI.DataVisualization.Charting.Docking.Right; chartOrgStats.Legends["Legend1"].LegendItemOrder = System.Web.UI.DataVisualization.Charting.LegendItemOrder.SameAsSeriesOrder; chartOrgStats.Legends["Legend1"].Font = new Font("Trebuchet MS", 10); // Add Color column LegendCellColumn firstColumn = new LegendCellColumn(); firstColumn.ColumnType = LegendCellColumnType.SeriesSymbol; chartOrgStats.Legends["Legend1"].CellColumns.Add(firstColumn); // Add name cell column LegendCellColumn textColumn = new LegendCellColumn(); textColumn.Alignment = System.Drawing.ContentAlignment.MiddleLeft; textColumn.Text = "#LEGENDTEXT"; textColumn.Name = "nameColumn"; chartOrgStats.Legends["Legend1"].CellColumns.Add(textColumn); // Add value cell column LegendCellColumn valColumn = new LegendCellColumn(); valColumn.Text = "#VAL"; valColumn.Name = "totalColumn"; chartOrgStats.Legends["Legend1"].CellColumns.Add(valColumn); // Add percent cell column LegendCellColumn percentColumn = new LegendCellColumn(); percentColumn.Text = "#PERCENT"; percentColumn.Name = "percentColumn"; chartOrgStats.Legends["Legend1"].CellColumns.Add(percentColumn); } } catch (CustomMessageException cmEx) { HideTableAndSetErrorMessage(cmEx.Message); } catch (Exception ex) { HideTableAndSetErrorMessage(ex.ToString()); } }