Exemple #1
0
        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);
        }