public ServOtch() { InitializeComponent(); GetTAble get = new GetTAble(); grid.DataContext = get; DatFirst.SelectedDate = DateTime.Parse("10.09.2020"); DatLast.SelectedDate = DateTime.Parse("25.09.2020"); }
private void Button_Click_2(object sender, RoutedEventArgs e) { grid.Items.Clear(); chart.Series.Clear(); chart.ChartAreas.Clear(); using (ModelBD md = new ModelBD()) { var dat = md.Rendering.ToList(); var SServ = from r in md.Rendering join ls in md.LabServices on r.IdService equals ls.ID select new { r.Period, ls.Name }; var CountPat = from r in md.Rendering join o in md.Orderr on r.IdService equals o.IDService select new { r.Period }; var dat_1 = from r in md.Rendering select new { datt = r.Period }; int count = 0; int count_2 = 0; int countPat = 0; int countServ = 0; foreach (var item in dat_1.Distinct()) { if (DateTime.Parse(item.datt).Day >= DatFirst.SelectedDate.Value.Day && DateTime.Parse(item.datt).Day <= DatLast.SelectedDate.Value.Day) { foreach (var item1 in CountPat) { DateTime date = DateTime.Parse(item1.Period); if (date.Day.Equals(DateTime.Parse(item.datt).Day)) { count++; } } foreach (var item1 in SServ) { DateTime date = DateTime.Parse(item1.Period); if (date.Day.Equals(DateTime.Parse(item.datt).Day)) { count_2++; } } GetTAble get = new GetTAble { Kserv = count_2, Sserv = count_2, Kpat = count, DayAndMonth = "Day: " + DateTime.Parse(item.datt).Day + $" - Month: {DateTime.Parse(item.datt).Month}" }; grid.Items.Add(get); countPat += count; countServ += count_2; count = 0; count_2 = 0; } } KPat.Text = countPat.ToString(); KServ.Text = countServ.ToString(); KSserv.Text = countServ.ToString(); int con = int.Parse(KServ.Text) + int.Parse(KSserv.Text) + int.Parse(KPat.Text); string[] str = new string[3] { "Кол-во оказанных услуг", "Кол-во пациентов", "Перечень оказанных услуг" }; chart.ChartAreas.Add(new ChartArea("Default")); GenerateGraph(str[1], dat_1, CountPat, count); GenerateGraph(str[0], dat_1, SServ, count); GenerateGraph(str[2], dat_1, SServ, count); } }