public void ChartPie() { List <string> chk_kategorie = new List <string>(); List <DateTime> chk_daty = new List <DateTime>(); List <string> chk_uzytkownicy = new List <string>(); GetCheckedNodes(tW_kategorie.Nodes, chk_kategorie); GetDates(tW_daty.Nodes, chk_daty); GetChecked_uzytkownicy(tW_users.Nodes, chk_uzytkownicy); chart1.Series["s2"].Points.Clear(); foreach (var kat in chk_kategorie) { List <string> list = new List <string>(); list.Add(kat); var operation = DBaccess.GetOperationWithCategory(chk_daty, list, chk_uzytkownicy.Select(s => int.Parse(s)).ToList()); if (operation.FirstOrDefault() != null) { var suma = operation.Sum(x => x.Kwota); chart1.Series["s2"].Points.AddXY(kat, suma); } } }
public void LineChart() { List <string> chk_kategorie = new List <string>(); List <DateTime> chk_daty = new List <DateTime>(); List <string> chk_uzytkownicy = new List <string>(); GetCheckedNodes(tW_kategorie.Nodes, chk_kategorie); GetDates(tW_daty.Nodes, chk_daty); GetChecked_uzytkownicy(tW_users.Nodes, chk_uzytkownicy); chart2.Series["Wydatki"].Points.Clear(); chart2.Series[0].XValueType = ChartValueType.DateTime; var ListOfDataExpense = DBaccess.GetOperationWithCategory(chk_daty, chk_kategorie, chk_uzytkownicy.Select(s => int.Parse(s)).ToList()) .Select(x => new { date = x.Data, price = x.Typ.Equals("wydatek") ? x.Kwota : 0 }); var ListOfDataIncome = DBaccess.GetOperationWithCategory(chk_daty, chk_kategorie, chk_uzytkownicy.Select(s => int.Parse(s)).ToList()) .Select(x => new { date = x.Data, price = x.Typ.Equals("przychod") ? x.Kwota : 0 }); chart2.Series[0].Points.DataBind(ListOfDataExpense, "date", "price", ""); chart2.Series[0].XValueType = ChartValueType.DateTime; chart2.Series[1].Points.DataBind(ListOfDataIncome, "date", "price", ""); chart2.Series[1].XValueType = ChartValueType.DateTime; chart2.Series[0].Color = Color.Red; chart2.Series[0].BorderWidth = 5; chart2.Series[1].Color = Color.Green; chart2.Series[1].BorderWidth = 5; chart2.Series[0].IsValueShownAsLabel = true; chart2.Series[0].Font = new Font(Font.SystemFontName, 15, FontStyle.Regular); chart2.Series[0].MarkerSize = 7; chart2.Series[0].MarkerColor = Color.DarkRed; chart2.Series[0].MarkerBorderColor = Color.Black; chart2.Series[0].MarkerStyle = MarkerStyle.Circle; chart2.Series[1].IsValueShownAsLabel = true; chart2.Series[1].Font = new Font(Font.SystemFontName, 15, FontStyle.Regular); chart2.Series[1].MarkerSize = 7; chart2.Series[1].MarkerColor = Color.DarkGreen; chart2.Series[1].MarkerBorderColor = Color.Black; chart2.Series[1].MarkerStyle = MarkerStyle.Circle; }
public void ColumnChart() { List <string> chk_kategorie = new List <string>(); List <DateTime> chk_daty = new List <DateTime>(); List <string> chk_uzytkownicy = new List <string>(); GetCheckedNodes(tW_kategorie.Nodes, chk_kategorie); GetDates(tW_daty.Nodes, chk_daty); GetChecked_uzytkownicy(tW_users.Nodes, chk_uzytkownicy); chart3.Series["s1"].Points.Clear(); var operation = DBaccess.GetOperationWithCategory(chk_daty, chk_kategorie, chk_uzytkownicy.Select(s => int.Parse(s)).ToList()); var sumaPrzychody = operation.Where(x => x.Typ.Equals("przychod")).Sum(x => x.Kwota); var sumaWydatki = operation.Where(x => x.Typ.Equals("wydatek")).Sum(x => x.Kwota); chart3.Series["s1"].Points.AddXY("Wydatki - " + sumaWydatki, sumaWydatki); chart3.Series["s1"].Points.AddXY("Przychody - " + sumaPrzychody, sumaPrzychody); chart3.Series[0].Points[0].Color = Color.Red; chart3.Series[0].Points[1].Color = Color.Green; }