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; }
void FillByDate(DateTimeOffset?fromDate, DateTimeOffset?toDate) { data = new List <Tuple <int, decimal> >(); data = QueryForSQLServer.GetTotalByMonth(2021); var list = data.ToList(); if (fromDate != null && toDate != null) { data = new List <Tuple <int, decimal> >(); for (int i = 0; i < list.Count(); i++) { var Created_At = list[i].Item1.ToString(); var dateMonth = int.Parse(Created_At); var fromDateMonth = int.Parse(fromDate?.ToString("MM")); var toDateMonth = int.Parse(toDate?.ToString("MM")); if (fromDateMonth <= dateMonth && dateMonth <= toDateMonth) { data.Add(list[i]); } } PieChartView.Series = new SeriesCollection(); var enum2 = from num in data orderby num.Item2 descending select num; foreach (var item in enum2) { 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; LineChartView.Series = new SeriesCollection(); var linedata = new List <decimal>(); string[] Labels = new[] { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }; var fromDateMonth2 = int.Parse(fromDate?.ToString("MM")); switch (fromDateMonth2) { case 1: Labels = new[] { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }; break; case 2: Labels = new[] { "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }; break; case 3: Labels = new[] { "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }; break; case 4: Labels = new[] { "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }; break; case 5: Labels = new[] { "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }; break; case 6: Labels = new[] { "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }; break; case 7: Labels = new[] { "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }; break; case 8: Labels = new[] { "Aug", "Sep", "Oct", "Nov", "Dec" }; break; case 9: Labels = new[] { "Sep", "Oct", "Nov", "Dec" }; break; case 10: Labels = new[] { "Oct", "Nov", "Dec" }; break; case 11: Labels = new[] { "Nov", "Dec" }; break; case 12: Labels = new[] { "Dec" }; break; default: break; } 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 = 1, //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.Clear(); LineChartView.AxisY.Clear(); LineChartView.AxisX.Add( new Axis { MinValue = 0, Labels = Labels, } ); LineChartView.AxisY.Add( new Axis { MinValue = 0, } ); LineChartView.DataContext = this; } }