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