public ActionResult AddPaternSearchVacancy()
        {
            var user = HttpContext.User.Identity.Name;

            var model = new AddPaternSearchVacancyViewModel()
            {
                UserName = user,
            };

            model.Cities = db.Cities.Select(c => new Microsoft.AspNetCore.Mvc.Rendering.SelectListItem()
            {
                Value = c.Id.ToString(),
                Text  = c.Name,
            }).ToList();
            model.FieldActivity = db.FieldActivities.Select(c => new Microsoft.AspNetCore.Mvc.Rendering.SelectListItem()
            {
                Value = c.Id.ToString(),
                Text  = c.Name,
            }).ToList();
            model.ExperienceOfWorks = db.ExperienceOfWorks.Select(c => new Microsoft.AspNetCore.Mvc.Rendering.SelectListItem()
            {
                Value = c.Id.ToString(),
                Text  = c.NameField,
            }).ToList();
            model.Employments = db.Employments.Select(c => new Microsoft.AspNetCore.Mvc.Rendering.SelectListItem()
            {
                Value = c.Id.ToString(),
                Text  = c.Name,
            }).ToList();
            return(View("/Arrea/Candidate/Views/Candidat/AddPaternSearchVacancy.cshtml", model));
        }
        public ActionResult AddPaternSearchVacancy(AddPaternSearchVacancyViewModel model)
        {
            var fieldAct   = db.FieldActivities.Include(f => f.Vacancies).FirstOrDefault(f => f.Id == model.FieldActivityId);
            var city       = db.Cities.Include(c => c.Vacancies).FirstOrDefault(c => c.Id == model.Id);
            var employment = db.Employments.Include(e => e.Vacancies).FirstOrDefault(e => e.Id == model.EmploymentId);
            var exOfWork   = db.ExperienceOfWorks.Include(e => e.Vacancies).FirstOrDefault(e => e.Id == model.ExperienceOfWorkId);

            var newPaternSearch = new PaternSearchVacancy()
            {
                Id               = Guid.NewGuid(),
                Request          = model.Request,
                Salary           = model.Salary,
                City             = city == null ? Guid.Empty : city.Id,
                Employment       = employment == null ? Guid.Empty : employment.Id,
                FieldActivity    = fieldAct == null ? Guid.Empty : fieldAct.Id,
                ExperienceOfWork = exOfWork == null ? Guid.Empty : exOfWork.Id,
            };

            db.PaternSearchVacancies.Add(newPaternSearch);
            db.SaveChanges();

            return(RedirectToAction(nameof(PaternSearchVacancy)));
        }