public Select2PagedModel GetSelect2IndustryCodes(int pageSize, int page, string term)
{
var result = new Select2PagedModel();
var industryCodes = _db.Industries
.Where(x => string.IsNullOrEmpty(term) || x.Name.Contains(term))
.Select(x => new Select2Model
{
id = x.Id.ToString(),
text = x.Name.ToString()
})
.OrderBy(x => x.id)
.ToPagedList(page, pageSize);
result.TotalCount = industryCodes.TotalItemCount;
result.Items = industryCodes.ToList();
return(result);
}
public Select2PagedModel GetSelect2(int pageSize, int page, string term)
{
var result = new Select2PagedModel();
var items = (from p in _db.Companies
where term == null || term == "" || p.Name.ToLower().Contains(term.ToLower())
orderby p.Id
select new Select2Model
{
id = p.Id.ToString(),
text = p.Name
}).ToPagedList(page, pageSize);
result.TotalCount = items.TotalItemCount;
result.Items = items.ToList();
return(result);
}
