public async Task <IActionResult> Create(EducationalViewModel model) { if (ModelState.IsValid) { TableEducational educational = new TableEducational { EducationType = model.EducationType.ToString(), QualificationEducation = model.QualificationEducation.ToString(), StartDate = model.StartDate, EndDate = model.EndDate, EducationalInstitutionsId = model.EducationalInstitutionsId, tableSpecialtySpecialtyId = model.tableSpecialtySpecialtyId, QualificationId = model.QualificationId, WorkerEmployeeRegistrationId = model.EmployeeRegistrationLogId }; _context.TableEducational.Add(educational); await _context.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(model)); }
public async Task <IActionResult> Create() { int TableOrganizations = _context.TableOrganizations.Include(i => i.users).FirstOrDefault (i => User.Identity.Name == i.users.UserName).TableOrganizationsId; var Worker = 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 Qualification = await _context.TableQualification .OrderBy(i => i.Qualification) .ToListAsync(); var Educational = await _context.EducationalInstitutions .OrderBy(i => i.NameEducationalInstitutions) .ToListAsync(); var Specialties = await _context.tableSpecialties .OrderBy(i => i.Specialty) .ToListAsync(); EducationalViewModel model = new EducationalViewModel { workers = Worker, educationals = Educational, tableSpecialties = Specialties, qualifications = Qualification }; return(View(model)); }