//busca trabalhos por palavra chave
public List <Trabalho> GetTrabalho(string search, string sort, string sortdir, int skip, int pageSize, out int totalRecord)
{
using (BPL_ProjectContext db = new BPL_ProjectContext())
{
var v = (from a in db.Trabalhoes.Include(x => x.Professor)
where
a.Prof_Curso.ToUpper().Contains(search.ToUpper()) ||
a.Prof_Nome.ToUpper().Contains(search.ToUpper()) ||
a.Assunto.ToUpper().Contains(search.ToUpper()) ||
a.Problema.ToUpper().Contains(search.ToUpper()) ||
a.Professor.Nome.ToUpper().Contains(search.ToUpper()) ||
a.Status.ToUpper().Contains(search.ToUpper())
select a
);
totalRecord = v.Count();
return(v.ToList());
}
}
