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