public CustomerSearchResultApiModel Search(string searchTerm, int pageSize, int pageNumber) { var model = new CustomerSearchResultApiModel(); var query = db.Customers.Where(c => c.Name.Contains(searchTerm) || c.Id.Contains(searchTerm)); model.ResultCount = query.Count(); model.PageCount = (model.ResultCount + pageSize - 1) / pageSize; var skipVal = (pageNumber - 1) * pageSize; model.Results = query.Skip(skipVal).Take(pageSize); return(model); }
public CustomerSearchResultApiModel Search(string searchTerm, int pageSize, int pageNumber, string deviceId) { var model = new CustomerSearchResultApiModel(); deviceExist = db.Devices.Where(d => d.Id == (deviceId)).ToList(); var ActiveDevice = deviceExist.Find(d => d.Id == deviceId && d.Status == 1); if (ActiveDevice != null) { var query = db.Customers.Where(c => c.Name.Contains(searchTerm) || c.Id.Contains(searchTerm)); model.ResultCount = query.Count(); model.PageCount = (model.ResultCount + pageSize - 1) / pageSize; var skipVal = (pageNumber - 1) * pageSize; model.Results = query.Skip(skipVal).Take(pageSize); return(model); } return(null); }