public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } AdvisingAssignment = await _context.AdvisingAssignments.FindAsync(id); if (AdvisingAssignment != null) { _context.AdvisingAssignments.Remove(AdvisingAssignment); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } // make an empty list List <SectionDropdownItem> dropdownItems = new List <SectionDropdownItem>(); // get all sections from the db List <DiplomaProgramYearSection> dpysList = _context .DiplomaProgramYearSections .Include(dpys => dpys.AcademicYear) .Include(dpys => dpys.DiplomaProgramYear) .ThenInclude(dpy => dpy.DiplomaProgram) .OrderByDescending(dpys => dpys.AcademicYear.Title) .ThenBy(dpys => dpys.DiplomaProgramYear.DiplomaProgram.Title) .ThenBy(dpys => dpys.DiplomaProgramYear.Title) .ThenBy(dpys => dpys.Title) .ToList(); foreach (var section in dpysList) { // create a new dropdown item // add it to dropdown list dropdownItems.Add(new SectionDropdownItem { Id = section.Id, DisplayName = $"{section.AcademicYear.Title} - {section.DiplomaProgramYear.DiplomaProgram.Title} - {section.DiplomaProgramYear.Title} - {section.Title}" }); } AdvisingAssignment = await _context.AdvisingAssignments .Include(a => a.DiplomaProgramYearSection) .Include(a => a.Instructor).FirstOrDefaultAsync(m => m.Id == id); if (AdvisingAssignment == null) { return(NotFound()); } ViewData["DiplomaProgramYearSectionId"] = new SelectList(dropdownItems, "Id", "DisplayName"); ViewData["InstructorId"] = new SelectList(_context.Instructors , "Id" , "FullName"); return(Page()); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } AdvisingAssignment = await _context.AdvisingAssignments .Include(a => a.DiplomaProgramYearSection) .Include(a => a.Instructor).FirstOrDefaultAsync(m => m.Id == id); if (AdvisingAssignment == null) { return(NotFound()); } return(Page()); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } AdvisingAssignment = await _context.AdvisingAssignments .Include(a => a.DiplomaProgramYearSection) .ThenInclude(d => d.DiplomaProgramYear) .ThenInclude(d => d.DiplomaProgram) .Include(a => a.Instructor).FirstOrDefaultAsync(m => m.Id == id); if (AdvisingAssignment == null) { return(NotFound()); } var LongText = _context.DiplomaProgramYearSections .Select(d => new { Id = d.Id, fulltext = d.DiplomaProgramYear.DiplomaProgram.Title + " - " + d.DiplomaProgramYear.Title + " - " + d.Title }); ViewData["DiplomaProgramYearSectionId"] = new SelectList(LongText, "Id", "fulltext"); // Select all records from the database and store in a variable // Create a new objects the array and concatenate the first and last names together var fullname = _context.Instructors.Select(i => new{ Id = i.Id, fullname = i.FirstName + " " + i.LastName }); ViewData["InstructorId"] = new SelectList(fullname, "Id", "fullname"); // Pass the fullNames variable into the ViewData //ViewData['InstructorId'] = new SelectList(fullNames, "Id", "fullNames"); return(Page()); }