public AddProfessionalCompetenceViewModel GetProfessionalCompetence(int competenceId)
 {
     AddProfessionalCompetenceViewModel model = new AddProfessionalCompetenceViewModel();
     var competence = _context.students_proffessional_competences.FirstOrDefault(x => x.id == competenceId);
     model.Id = competence.id;
     model.Name = competence.proffessional_competence.name;
     model.ProfileId = competence.id_student_profiles.Value;
     model.Skills = competence.proffessional_competence.skills.Select(x => x.name).ToList();
     model.Knowlege = competence.proffessional_competence.knowlege.Select(x => x.name).ToList();
     model.Abilities = competence.proffessional_competence.abilities.Select(x => x.name).ToList();
     return model;
 }
        public void AddProfessionalCompetence(AddProfessionalCompetenceViewModel model)
        {
            var profile = _context.student_profiles.FirstOrDefault(x => x.id == model.ProfileId);
            var professionalCompetence = new proffessional_competences
            {
                name = model.Name
            };
            professionalCompetence.abilities = new List<ability>();
            foreach (var ability in model.Abilities)
            {
                professionalCompetence.abilities.Add(new Entities.ability
                {
                    name = ability
                });
            }
            professionalCompetence.skills = new List<skill>();
            foreach (var skill in model.Skills)
            {
                professionalCompetence.skills.Add(new Entities.skill
                {
                    name = skill
                });
            }
            professionalCompetence.knowlege = new List<knowlege>();
            foreach (var knowlege in model.Knowlege)
            {
                professionalCompetence.knowlege.Add(new Entities.knowlege
                {
                    name = knowlege
                });
            }

            profile.students_proffessional_competences.Add(new students_proffessional_competences
            {
                id_student_profiles = model.ProfileId,
                proffessional_competence = professionalCompetence
            });
            _context.SaveChanges();
        }