public List <Address> GetAllList(PagingQueryDto input) { var query = _addressRepo.GetAll(); if (!string.IsNullOrWhiteSpace(input.City)) { query = query.Where(q => q.City == input.City); } //var filteredResultsCount = query.Count(); //var totalResultsCount = query.Count(); //var result = new DtResult<Address> //{ // Draw = input.Draw, // RecordsTotal = totalResultsCount, // RecordsFiltered = filteredResultsCount, // Data = query // .Skip(input.Start) // .Take(input.Length) // .ToList() //}; var result = query.ToList(); return(result); }
public DtResult <Address> GetAll(PagingQueryDto input) { var query = _addressRepo.GetAll(); if (!string.IsNullOrWhiteSpace(input.City)) { query = query.Where(q => q.City == input.City); } var filteredResultsCount = query.Count(); var totalResultsCount = query.Count(); var result = new DtResult <Address> { Draw = input.Draw, RecordsTotal = totalResultsCount, RecordsFiltered = filteredResultsCount, Data = query .Skip(input.Start) .Take(input.Length) .ToList() }; return(result); }
public void GetAllList_ShouldNot_BeNull() { //Mock<IRepositoryBase<Address>> _addressRepo; ////IRepositoryBase<Address> _addressRepo; //IAddressService _address; //_addressRepo = new Mock<IRepositoryBase<Address>>(); //_address = new AddressService(_addressRepo.Object); //var fakedata = new List<Address> //{ // new Address // { // City ="Toronto" // } //}.AsQueryable(); //_addressRepo.Setup(p => p.GetAll()).Returns(fakedata); // arrange var fakedata = WebHostTest.ctx.Address.AsQueryable(); WebHostTest._addressRepo.Setup(p => p.GetAll()).Returns(fakedata); //Bothell //Toronto var input = new PagingQueryDto { City = "Bothell", //Draw = 1, //Length = 10, //Start = 0 }; //act var data = _address.GetAllList(input); var actual = data.Count; var expected = 4; // assert Assert.AreEqual(expected, actual); }
public JsonResult Address(PagingQueryDto input) { var data = _address.GetAll(input); return(Json(data)); }