public async Task <IActionResult> Create(AdvancedTrainingViewModel model) { try { if (ModelState.IsValid) { AdvancedTraining advanced = new AdvancedTraining { EducationalInstitutionsId = model.educationalsId, EmployeeRegistrationLogId = model.employeesId, Start = model.Start, End = model.End, }; _context.advancedTrainings.Add(advanced); await _context.SaveChangesAsync(); return(RedirectToAction("Index")); } else { int TableOrganizations = _context.TableOrganizations.Include(i => i.users).FirstOrDefault (i => User.Identity.Name == i.users.UserName).TableOrganizationsId; var employees = await _context.employeeRegistrationLogs .Include(i => i.Worker) .Include(i => i.Organizations) .ThenInclude(i => i.users) .Where(i => i.TableOrganizationsId == TableOrganizations).ToListAsync(); var educationals = await _context.EducationalInstitutions.ToListAsync(); AdvancedTrainingViewModel modelResult = new AdvancedTrainingViewModel { employees = employees, educationals = educationals }; return(View(modelResult)); } } catch { return(RedirectToAction("Create")); } }
public async Task <IActionResult> Create() { int TableOrganizations = _context.TableOrganizations.Include(i => i.users).FirstOrDefault (i => User.Identity.Name == i.users.UserName).TableOrganizationsId; var employees = await _context.employeeRegistrationLogs .Include(i => i.Worker) .Include(i => i.Organizations) .ThenInclude(i => i.users) .OrderBy(i => i.Worker.Surname) .Where(i => i.TableOrganizationsId == TableOrganizations).ToListAsync(); var educationals = await _context.EducationalInstitutions .OrderBy(i => i.NameEducationalInstitutions) .ToListAsync(); AdvancedTrainingViewModel model = new AdvancedTrainingViewModel { employees = employees, educationals = educationals }; return(View(model)); }