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