public PageAdmin() { InitializeComponent(); //ngay thang nam fromDatePicker.Date = new DateTime(2021, 1, 1).Date; toDatePicker.Date = new DateTime(2021, 12, 31).Date; data = new List <Tuple <int, decimal> >(); data = QueryForSQLServer.GetTotalByMonth(2021); var dataSeller = QueryForSQLServer.GetListBestSellerPurchases(); //string []Labels = new []{ "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul","Aug","Sep","Oct","Nov","Dec" }; ////LineChartViewX.DataContext = Labels; //PieChartView.Series = new SeriesCollection(); //foreach (var item in data) //{ // if (item.Item2 != 0) // PieChartView.Series.Add( // new PieSeries() // { // Values = new ChartValues<decimal> { item.Item2 }, // Title = item.Item1.ToString(), // DataLabels = true, // } // ) ; //} //PieChartView.LegendLocation = LegendLocation.Bottom; //PieChartView.DataContext = this; var productdt = QueryForSQLServer.GetProductFromDBTwo(); DataGridProduct.ItemsSource = productdt; //PieChartView.Series = new SeriesCollection(); foreach (var item in dataSeller) { ColumChartView.Series.Add( new ColumnSeries() { Values = new ChartValues <decimal> { item.Item2 }, Title = item.Item1.ToString(), DataLabels = true, } ); } ColumChartView.LegendLocation = LegendLocation.Bottom; ColumChartView.DataContext = this; //var linedata = new List<decimal>(); //foreach(var item in data) //{ // linedata.Add(item.Item2); //} //LineChartView.Series.Add( // new LineSeries() // { // Values = new ChartValues<decimal> { linedata[0] }, // Title = "Doanh thu theo năm", // LineSmoothness = 0, //0: straight lines, 1: really smooth lines // DataLabels = true, // } //); //for (int i = 1; i < linedata.Count(); i++) //{ // LineChartView.Series[0].Values.Add(linedata[i]); //} //LineChartView.LegendLocation = LegendLocation.Bottom; //LineChartView.AxisX.Add( // new Axis // { // MinValue = 0, // Labels = Labels // } // ); //LineChartView.AxisY.Add( // new Axis // { // MinValue = 0, // } // ); //LineChartView.DataContext = this; }