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