protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                this.UsageChartDataBinding();

                LoadCompany();
            }

            List <UsageItem> us = new List <UsageItem>();

            DataView dv = (DataView)SqlDataSource4.Select(System.Web.UI.DataSourceSelectArguments.Empty);

            if (dv != null)
            {
                foreach (DataRowView dr in dv)
                {
                    UsageItem v = new UsageItem();


                    v.BillDt       = dr["BillDt"].ToString();
                    v.UsageSummary = (double)dr["UsageSummary"];

                    us.Add(v);
                }

                RadChart1.DataSource                      = us;
                RadChart1.Series[0].DataYColumn           = "UsageSummary";
                RadChart1.PlotArea.XAxis.DataLabelsColumn = "BillDt";

                RadChart1.DataBind();
            }
        }
예제 #2
0
        protected void btnApply_Click(object sender, EventArgs e)
        {
            if (cboCompany.SelectedItem.Value != string.Empty &&
                cboCycle.SelectedItem.Value != string.Empty &&
                !string.IsNullOrEmpty(txtAcctNum.Text) &&
                !string.IsNullOrWhiteSpace(txtAcctNum.Text))
            {
                //use viewUsageSummarybyAccount view
                List<UsageItem> us = new List<UsageItem>();

                DataView dv = (DataView)SqlDataSource3.Select(System.Web.UI.DataSourceSelectArguments.Empty);

                if (dv != null)
                {
                    foreach (DataRowView dr in dv)
                    {
                        UsageItem v = new UsageItem();

                        v.BillDt = dr["BillDt"].ToString();
                        v.UsageSummary = (double)dr["UsageSummary"];

                        us.Add(v);
                    }

                    RadChart1.DataSource = us;
                    RadChart1.Series[0].DataYColumn = "UsageSummary";
                    RadChart1.PlotArea.XAxis.DataLabelsColumn = "BillDt";

                    RadChart1.DataBind();
                }

            }
            else
            {
                if (cboCompany.SelectedItem.Value != string.Empty &&
                cboCycle.SelectedItem.Value != string.Empty)
                {
                    //use viewUsageSummaryByCycle view
                    List<UsageItem> us = new List<UsageItem>();

                    DataView dv = (DataView)SqlDataSource2.Select(System.Web.UI.DataSourceSelectArguments.Empty);

                    if (dv != null)
                    {
                        foreach (DataRowView dr in dv)
                        {
                            UsageItem v = new UsageItem();

                            v.BillDt = dr["BillDt"].ToString();
                            v.UsageSummary = (double)dr["UsageSummary"];

                            us.Add(v);
                        }

                        RadChart1.DataSource = us;
                        RadChart1.Series[0].DataYColumn = "UsageSummary";
                        RadChart1.PlotArea.XAxis.DataLabelsColumn = "BillDt";

                        RadChart1.DataBind();
                    }
                }
                else
                {
                    if (cboCompany.SelectedItem.Value != string.Empty)
                    {
                        List<UsageItem> us = new List<UsageItem>();

                        DataView dv = (DataView)SqlDataSource1.Select(System.Web.UI.DataSourceSelectArguments.Empty);

                        if (dv != null)
                        {
                            foreach (DataRowView dr in dv)
                            {
                                UsageItem v = new UsageItem();

                                v.BillDt = dr["BillDt"].ToString();
                                v.UsageSummary = (double)dr["UsageSummary"];

                                us.Add(v);
                            }

                            RadChart1.DataSource = us;
                            RadChart1.Series[0].DataYColumn = "UsageSummary";
                            RadChart1.PlotArea.XAxis.DataLabelsColumn = "BillDt";

                            RadChart1.DataBind();
                        }
                    }
                    else
                    {
                        //use all data
                        List<UsageItem> us = new List<UsageItem>();

                        DataView dv = (DataView)SqlDataSource4.Select(System.Web.UI.DataSourceSelectArguments.Empty);

                        if (dv != null)
                        {
                            foreach (DataRowView dr in dv)
                            {
                                UsageItem v = new UsageItem();

                                v.BillDt = dr["BillDt"].ToString();
                                v.UsageSummary = (double)dr["UsageSummary"];

                                us.Add(v);
                            }

                            RadChart1.DataSource = us;
                            RadChart1.Series[0].DataYColumn = "UsageSummary";
                            RadChart1.PlotArea.XAxis.DataLabelsColumn = "BillDt";

                            RadChart1.DataBind();
                        }
                    }
                }
            }
        }
        protected void btnApply_Click(object sender, EventArgs e)
        {
            if (cboCompany.SelectedItem.Value != string.Empty &&
                cboCycle.SelectedItem.Value != string.Empty &&
                !string.IsNullOrEmpty(txtAcctNum.Text) &&
                !string.IsNullOrWhiteSpace(txtAcctNum.Text))
            {
                //use viewUsageSummarybyAccount view
                List <UsageItem> us = new List <UsageItem>();

                DataView dv = (DataView)SqlDataSource3.Select(System.Web.UI.DataSourceSelectArguments.Empty);

                if (dv != null)
                {
                    foreach (DataRowView dr in dv)
                    {
                        UsageItem v = new UsageItem();


                        v.BillDt       = dr["BillDt"].ToString();
                        v.UsageSummary = (double)dr["UsageSummary"];

                        us.Add(v);
                    }

                    RadChart1.DataSource                      = us;
                    RadChart1.Series[0].DataYColumn           = "UsageSummary";
                    RadChart1.PlotArea.XAxis.DataLabelsColumn = "BillDt";

                    RadChart1.DataBind();
                }
            }
            else
            {
                if (cboCompany.SelectedItem.Value != string.Empty &&
                    cboCycle.SelectedItem.Value != string.Empty)
                {
                    //use viewUsageSummaryByCycle view
                    List <UsageItem> us = new List <UsageItem>();

                    DataView dv = (DataView)SqlDataSource2.Select(System.Web.UI.DataSourceSelectArguments.Empty);

                    if (dv != null)
                    {
                        foreach (DataRowView dr in dv)
                        {
                            UsageItem v = new UsageItem();


                            v.BillDt       = dr["BillDt"].ToString();
                            v.UsageSummary = (double)dr["UsageSummary"];

                            us.Add(v);
                        }

                        RadChart1.DataSource                      = us;
                        RadChart1.Series[0].DataYColumn           = "UsageSummary";
                        RadChart1.PlotArea.XAxis.DataLabelsColumn = "BillDt";

                        RadChart1.DataBind();
                    }
                }
                else
                {
                    if (cboCompany.SelectedItem.Value != string.Empty)
                    {
                        List <UsageItem> us = new List <UsageItem>();

                        DataView dv = (DataView)SqlDataSource1.Select(System.Web.UI.DataSourceSelectArguments.Empty);

                        if (dv != null)
                        {
                            foreach (DataRowView dr in dv)
                            {
                                UsageItem v = new UsageItem();


                                v.BillDt       = dr["BillDt"].ToString();
                                v.UsageSummary = (double)dr["UsageSummary"];

                                us.Add(v);
                            }

                            RadChart1.DataSource                      = us;
                            RadChart1.Series[0].DataYColumn           = "UsageSummary";
                            RadChart1.PlotArea.XAxis.DataLabelsColumn = "BillDt";

                            RadChart1.DataBind();
                        }
                    }
                    else
                    {
                        //use all data
                        List <UsageItem> us = new List <UsageItem>();

                        DataView dv = (DataView)SqlDataSource4.Select(System.Web.UI.DataSourceSelectArguments.Empty);

                        if (dv != null)
                        {
                            foreach (DataRowView dr in dv)
                            {
                                UsageItem v = new UsageItem();


                                v.BillDt       = dr["BillDt"].ToString();
                                v.UsageSummary = (double)dr["UsageSummary"];

                                us.Add(v);
                            }

                            RadChart1.DataSource                      = us;
                            RadChart1.Series[0].DataYColumn           = "UsageSummary";
                            RadChart1.PlotArea.XAxis.DataLabelsColumn = "BillDt";

                            RadChart1.DataBind();
                        }
                    }
                }
            }
        }
예제 #4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                this.UsageChartDataBinding();

                LoadCompany();
            }

            List<UsageItem> us = new List<UsageItem>();

            DataView dv = (DataView)SqlDataSource4.Select(System.Web.UI.DataSourceSelectArguments.Empty);

            if (dv != null)
            {
                foreach (DataRowView dr in dv)
                {
                    UsageItem v = new UsageItem();

                    v.BillDt = dr["BillDt"].ToString();
                    v.UsageSummary = (double)dr["UsageSummary"];

                    us.Add(v);
                }

                RadChart1.DataSource = us;
                RadChart1.Series[0].DataYColumn = "UsageSummary";
                RadChart1.PlotArea.XAxis.DataLabelsColumn = "BillDt";

                RadChart1.DataBind();
            }
        }