public IEnumerable <Contact> GetAllPaging(ContactsParameters contactsParameters) { string query = "SELECT [Id],[FirstName],[LastName],[Company],[Email],[PhoneNumber] FROM [dbo].[Contacts] "; using (var multipleResults = this.db.QueryMultiple(query)) { var contacts = multipleResults.Read <Contact>().ToList(); return(contacts.OrderBy(x => x.Id) .Skip((contactsParameters.PageNumber - 1) * contactsParameters.PageSize) .Take(contactsParameters.PageSize) .ToList()); } }
public void Test_GetContactsList_OK() { #region Arrange ContactRepository _repository = new ContactRepository(); ContactManager _manager = new ContactManager(_repository); ContactsController controller = new ContactsController(_manager); ContactsParameters parameters = new ContactsParameters(); parameters.PageNumber = 2; parameters.PageSize = 15; #endregion #region Act var result = controller.GetContacts(parameters); #endregion #region Assert Assert.True(result.Value != null); #endregion }