public List <SkillSet> GetAllSkills() { var skillSetList = new List <SkillSet>(); var skillList = _commonDBContext.Query <Skill>().ToList(); foreach (var skill in skillList) { skillSetList.Add(_commonMapper.MapSkillToSkillSet(skill)); } SkillSetSortByName skillSetSortByName = new SkillSetSortByName(); skillSetList.Sort(skillSetSortByName); return(skillSetList); }
public IEnumerable <SkillSet> GetSkillSetListByName(string name) { List <SkillSet> skillSetList = new List <SkillSet>(); if (name != null) { string _name = name.Trim().ToLower(); var skillList = _commonDBContext.Query <Skill>().Where(skill => skill.Name.ToLower().Contains(_name) || skill.Parent.Name.ToLower().Contains(_name)).ToList(); foreach (var skill in skillList) { skillSetList.Add(_commonMapper.MapSkillToSkillSet(skill)); } } SkillSetSortByName skillSetSortByName = new SkillSetSortByName(); skillSetList.Sort(skillSetSortByName); return(skillSetList); }