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
}
