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());
}
