public async Task <IActionResult> Search(ListPersoonViewModel viewModel)
{
if (!string.IsNullOrEmpty(viewModel.ZoekPersoon))
{
viewModel.Persoon = await _context.Personen.Include(p => p.CustomUser)
.Where(x => x.Voornaam.Contains(viewModel.ZoekPersoon)).ToListAsync();
}
else
{
viewModel.Persoon = await _context.Personen.Include(p => p.CustomUser).ToListAsync();
}
foreach (var persoon in viewModel.Persoon)
{
persoon.ActieveDrankkaart = await _context.Drankkaarten.FirstOrDefaultAsync(x => x.PersoonID == persoon.Persoon_ID && x.IsBetaald == false);
if (persoon.IsAdmin == true)
{
persoon.RolDuiding = "Administrator";
}
else
{
persoon.RolDuiding = "Speler";
}
}
return(View("Index", viewModel));
}
public ActionResult DrankkaartIsBetaald(ListPersoonViewModel viewModel, int PersoonID)
{
viewModel.ActDrankkaart = _context.Drankkaarten.FirstOrDefault(x => x.PersoonID == PersoonID && x.IsBetaald == false);
viewModel.ActDrankkaart.IsBetaald = true;
_context.Update(viewModel.ActDrankkaart);
_context.SaveChangesAsync();
return(View("Index", viewModel));
}
public async Task KlantenOverzichtDownload()
{
ListPersoonViewModel viewModel = new ListPersoonViewModel();
viewModel.Persoon = await _context.Personen.Include(x => x.CustomUser).ToListAsync();
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
ExcelPackage Ep = new ExcelPackage();
ExcelWorksheet Sheet = Ep.Workbook.Worksheets.Add("ExcelKlanten");
Sheet.Cells["A1"].Value = "Voornaam";
Sheet.Cells["B1"].Value = "Achternaam";
Sheet.Cells["C1"].Value = "Username";
Sheet.Cells["D1"].Value = "IsAdmin";
Sheet.Cells["E1"].Value = "EmailAdres";
Sheet.Cells["F1"].Value = "GeboorteDatum";
Sheet.Cells["G1"].Value = "Aangemaakte Datum";
int row = 2;
foreach (var item in viewModel.Persoon)
{
Sheet.Cells[string.Format("A{0}", row)].Value = item.Voornaam;
Sheet.Cells[string.Format("B{0}", row)].Value = item.Achternaam;
Sheet.Cells[string.Format("C{0}", row)].Value = item.Username;
Sheet.Cells[string.Format("D{0}", row)].Value = item.IsAdmin;
Sheet.Cells[string.Format("E{0}", row)].Value = item.Email;
Sheet.Cells[string.Format("F{0}", row)].Value = item.Geboortedatum;
Sheet.Cells[string.Format("F{0}", row)].Style.Numberformat.Format = "yyyy-mm-dd";
Sheet.Cells[string.Format("G{0}", row)].Value = item.AangemaaktDatum;
Sheet.Cells[string.Format("G{0}", row)].Style.Numberformat.Format = "yyyy-mm-dd";
row++;
}
Sheet.Cells["A:AZ"].AutoFitColumns();
Response.Clear();
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.Headers.Add("content-disposition", "attachment: filename=" + "Report.xlsx");
await Response.Body.WriteAsync(Ep.GetAsByteArray());
Response.StatusCode = StatusCodes.Status200OK;
}
// GET: Persoon
public async Task <IActionResult> Index()
{
ListPersoonViewModel viewModel = new ListPersoonViewModel();
viewModel.Persoon = await _context.Personen.Include(p => p.CustomUser).Include(x => x.Drankkaarten).ToListAsync();
foreach (var persoon in viewModel.Persoon)
{
persoon.ActieveDrankkaart = await _context.Drankkaarten.FirstOrDefaultAsync(x => x.PersoonID == persoon.Persoon_ID && x.IsBetaald == false);
if (persoon.IsAdmin == true)
{
persoon.RolDuiding = "Administrator";
}
else
{
persoon.RolDuiding = "Speler";
}
}
return(View(viewModel));
}
