private void loadRevenueByYear()
        {
            BUS_Revenue        bus          = new BUS_Revenue();
            List <DTO_Revenue> revenueslist = bus.loadRevenueByYear(txtYearSearch.Text + "-01-01 00:00:00.999", txtYearSearch.Text + "-12-31 23:59:59.999");

            chartRevenue.Series["Revenue"].Points.Clear();
            for (int i = 0; i < revenueslist.Count; i++)
            {
                chartRevenue.Series["Revenue"].Points.AddXY(revenueslist[i].month, revenueslist[i].totalRevenue);
                chartRevenue.Series["Revenue"].Points[i].Label = revenueslist[i].totalRevenue.ToString();
            }
        }
        private void loadTop5Revenue()
        {
            BUS_Revenue bus       = new BUS_Revenue();
            string      datebegin = DateFrom.Value.ToString("yyyy-MM-dd 00:00:00.999");
            string      dateend   = DateTo.Value.ToString("yyyy-MM-dd 23:59:59.999");

            dt = bus.loadTop5Revenue(datebegin, dateend);
            dgvTotalOrder.DataSource = dt;

            List <DTO_Revenue> listRevenue = bus.toList(dt);

            chartTop.Series["Top"].Points.Clear();
            for (int i = 0; i < listRevenue.Count; i++)
            {
                chartTop.Series["Top"].Points.AddXY(listRevenue[i].nameProduct, listRevenue[i].totalRevenue);
                chartTop.Series["Top"].IsValueShownAsLabel = false;
                chartTop.Series["Top"]["PieLabelStyle"]    = "Disabled";
                chartTop.Series["Top"].Points[i].Label     = listRevenue[i].nameProduct + "(#PERCENT)";
            }
        }