public DropDownVortrag() { ListeAlle = TalkList.Get().ToList(); foreach (var item in ListeAlle) { ListeFilteredItems.Add(item); } InitializeComponent(); }
internal static void OverviewTalkCount(bool openReport) { Log.Info(nameof(OverviewTalkCount), ""); var tempFile = Path.GetTempFileName(); var excel = new FileInfo(tempFile); var vers = DataContainer.MeineVersammlung; var kreis = vers.Kreis; using (ExcelPackage package = new ExcelPackage()) { ExcelWorksheet sheet = package.Workbook.Worksheets.Add($"Vorträge"); sheet.Column(1).Width = 10; sheet.Column(2).Width = 50; sheet.Column(3).Width = 10; sheet.Column(5).Width = 15; sheet.Cells[1, 1].Value = "Anzahl der Ausarbeitungen der Vorträge"; sheet.Cells[2, 1, 2, 4].Style.Font.Bold = true; sheet.Cells[2, 1].Value = "Nr"; sheet.Cells[2, 2].Value = "Thema"; sheet.Cells[2, 3].Value = "Versammlung"; sheet.Cells[2, 4].Value = "Kreis"; sheet.Cells[2, 5].Value = "zuletzt gehört"; var row = 3; foreach (var v in TalkList.Get()) { sheet.Cells[row, 1].Value = v.Nummer; sheet.Cells[row, 2].Value = v.Thema; sheet.Cells[row, 3].Value = DataContainer.Redner.Where(x => x.Versammlung == vers && x.Vorträge.Select(y => y.Vortrag).Contains(v)).Count(); sheet.Cells[row, 4].Value = DataContainer.Redner.Where(x => x.Versammlung.Kreis == kreis && x.Vorträge.Select(y => y.Vortrag).Contains(v)).Count(); var wochen = DataContainer.MeinPlan.Where(x => x.Vortrag?.Vortrag?.Nummer == v.Nummer); if (wochen.Any()) { var zuletzt = wochen.Select(x => x.Kw).Max(); sheet.Cells[row, 5].Value = Core.Helper.CalculateWeek(zuletzt); } row++; } //create a range for the table ExcelRange range = sheet.Cells[2, 1, row - 1, 5]; ExcelTable tab = sheet.Tables.Add(range, "Table1"); tab.TableStyle = TableStyles.Medium2; range = sheet.Cells[2, 5, row - 1, 5]; range.Style.Numberformat.Format = "dd.mm.yyyy"; package.SaveAs(excel); } File.Save(tempFile, "Vortragsthemen.xlsx", openReport); }
public EreignisEintragenCommandDialogView() { CloseCommand = new DelegateCommand <ICloseable>(Schließen); SaveCommand = new DelegateCommand <ICloseable>(Save); Vortragsliste = new ObservableCollection <Talk>(TalkList.Get()); }