public List <CVShortcut_ViewModel> SearchCVShortcut(Search_ViewModel search)
{
if (search.key == "")
{
return(GetTop10CVNewest());
}
// Select laborer id
var e = (from a in db.Skills
join b in db.Laborer_Skills on a.IDSkill equals b.IDSkill
join c in db.CVs on b.IDLaborer equals c.LaborerId
join d in db.LaborerandAdmins on c.LaborerId equals d.IDLaborer
where a.skillName.ToLower().Contains(search.key.ToLower()) ||
c.Languages.ToLower().Contains(search.key.ToLower()) ||
c.Major.ToLower().Contains(search.key.ToLower()) ||
c.DetailInformation.ToLower().Contains(search.key.ToLower()) ||
c.ShortDescription.ToLower().Contains(search.key.ToLower()) ||
d.laborerName.ToLower().Contains(search.key.ToLower())
select new CVShortcut_ViewModel
{
IDLaborer = d.IDLaborer,
Name = d.laborerName,
Avatar = d.avatar,
Description = c.ShortDescription
}).Distinct <CVShortcut_ViewModel>();
// Select information of laborer
List <CVShortcut_ViewModel> result = e.ToList <CVShortcut_ViewModel>();
foreach (CVShortcut_ViewModel o in result)
{
o.arrSkills = GetList(o.IDLaborer);
}
return(result);
}
public Search_Update_Command(Search_ViewModel search_ViewModel)
{
this.search_ViewModel = search_ViewModel;
}
public List <Skill> FindoutSkills(Search_ViewModel key)
{
return(db.Skills.Where(s => s.skillName.ToLower().Contains(key.key.ToLower())).ToList());
}
//Constructors
public SearchDeliverMan_UserCntrl(LogIn_AdministratorViewModel logIn_AdministratorViewModel)
{
searchMV = new Search_ViewModel(this, logIn_AdministratorViewModel);
this.DataContext = searchMV;
InitializeComponent();
}
