public ActionResult EditCPR(int id) { var query = (from mcpr in _context.MemberCpr where mcpr.MemberCprid == id select mcpr).FirstOrDefault(); //Explicit loading because EF Core isn't lazy _context.MemberCpr.Include(x => x.Member).Load(); _context.MemberCpr.Include(x => x.Cpr).Load(); //converting from data models to the view model (dto), the conversions happen in the view model / dto's constructor Models.Training.CPRSummaryItem model = new Models.Training.CPRSummaryItem(query); return(View(model)); }
public ActionResult DeleteCPR(Models.Training.CPRSummaryItem viewModel) { try { var del = new Models.DB.MemberCpr { MemberCprid = viewModel.ID }; _context.MemberCpr.Attach(del); _context.Remove(del); _context.SaveChanges(); return(RedirectToAction(nameof(CPRList))); } catch (Exception exc) { throw exc; } }
public ActionResult EditCPR(Models.Training.CPRSummaryItem viewModel) { // only updating the issued and expiration try { var query = (from mcpr in _context.MemberCpr where mcpr.MemberCprid == viewModel.ID select mcpr).FirstOrDefault(); query.Issued = viewModel.Issued; query.Expiration = viewModel.Expiration; _context.SaveChanges(); return(RedirectToAction(nameof(CPRList))); } catch (Exception exc) { throw exc; } }