Example #1
0
        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);
        }
Example #2
0
        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);
        }
Example #3
0
        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);
        }
Example #4
0
        public JsonResult Address(PagingQueryDto input)
        {
            var data = _address.GetAll(input);

            return(Json(data));
        }