public IActionResult Index( int?pageNumber, int?pageSize, string sortCol, string sortDir, string searchTerms) { _logger.LogInformation("In the Index of the controller!"); return(ExecuteExceptionsHandledActionResult(() => { OperationResult result = _customerEntityBusiness.ListItems( pageNumber, pageSize, sortCol ?? "CustomerId", sortDir, searchTerms); ViewBag.offset = result.ObjectsDictionary["offset"]; ViewBag.pageIndex = result.ObjectsDictionary["pageIndex"]; ViewBag.sizeOfPage = result.ObjectsDictionary["sizeOfPage"]; ViewBag.offsetUpperBound = result.ObjectsDictionary["offsetUpperBound"]; ViewBag.totalRecords = result.ObjectsDictionary["totalNumberOfRecords"]; ViewBag.totalNumberOfPages = result.ObjectsDictionary["totalNumberOfPages"]; ViewBag.searchTerms = result.ObjectsDictionary["searchTerms"]; ViewBag.sortCol = result.ObjectsDictionary["sortCol"]; ViewBag.sortDir = result.ObjectsDictionary["sortDir"]; var model = new CustomerListingViewModel { CustomersList = result.ObjectsDictionary["list"] as IEnumerable <Customer> }; return View(model); })); }
public IActionResult Artists( int?pageNumber, int?pageSize, string sortCol, string sortDir, string searchTerms) { return(ExecuteExceptionsHandledActionResult(() => { OperationResult result = _artistEntityBusiness.ListItems( pageNumber, pageSize, sortCol, sortDir, searchTerms); ViewBag.offset = result.ObjectsDictionary["offset"]; ViewBag.pageIndex = result.ObjectsDictionary["pageIndex"]; ViewBag.sizeOfPage = result.ObjectsDictionary["sizeOfPage"]; ViewBag.offsetUpperBound = result.ObjectsDictionary["offsetUpperBound"]; ViewBag.totalRecords = result.ObjectsDictionary["totalNumberOfRecords"]; ViewBag.totalNumberOfPages = result.ObjectsDictionary["totalNumberOfPages"]; ViewBag.searchTerms = result.ObjectsDictionary["searchTerms"]; ViewBag.sortCol = result.ObjectsDictionary["sortCol"]; ViewBag.sortDir = result.ObjectsDictionary["sortDir"]; var model = new ArtistViewModel { ArtistsList = result.ObjectsDictionary["list"] as IEnumerable <Artist> }; return View(model); })); }
public IActionResult List( int?pageNumber, int?pageSize, string sortCol, string sortDir, string searchTerms) { return(ExecuteExceptionsHandledActionResult(() => { OperationResult result = _customerBusiness.ListItems( pageNumber, pageSize, sortCol ?? "CustomerId", sortDir, searchTerms); var paginationData = new PaginationData { OffsetFromZero = (int)result.ObjectsDictionary["offset"], PageNumber = (int)result.ObjectsDictionary["pageIndex"], PageSize = (int)result.ObjectsDictionary["sizeOfPage"], OffsetUpperBound = (int)result.ObjectsDictionary["offsetUpperBound"], TotalNumberOfRecords = (int)result.ObjectsDictionary["totalNumberOfRecords"], TotalNumberOfPages = (int)result.ObjectsDictionary["totalNumberOfPages"], SearchTermsCommaSeparated = result.ObjectsDictionary["searchTerms"].ToString(), SortColumn = result.ObjectsDictionary["sortCol"].ToString(), SortDirection = result.ObjectsDictionary["sortDir"].ToString() }; var list = result.ObjectsDictionary["list"] as IEnumerable <Customer>; var toReturn = Json(new { list, paginationData }); return toReturn; })); }
public IActionResult GetAll( int?pageNumber, int?pageSize, string sortCol, string sortDir, string searchTerms) { OperationResult result = _artistEntityBusiness.ListItems( pageNumber, pageSize, sortCol, sortDir, searchTerms); var paginationData = new PaginationData { OffsetFromZero = (int)result.ObjectsDictionary["offset"], PageNumber = (int)result.ObjectsDictionary["pageIndex"], PageSize = (int)result.ObjectsDictionary["sizeOfPage"], OffsetUpperBound = (int)result.ObjectsDictionary["offsetUpperBound"], TotalNumberOfRecords = (int)result.ObjectsDictionary["totalNumberOfRecords"], TotalNumberOfPages = (int)result.ObjectsDictionary["totalNumberOfPages"], SearchTermsCommaSeparated = result.ObjectsDictionary["searchTerms"].ToString(), SortColumn = result.ObjectsDictionary["sortCol"].ToString(), SortDirection = result.ObjectsDictionary["sortDir"].ToString() }; var list = result.ObjectsDictionary["list"] as IEnumerable <Artist>; var toReturn = Json(new { list, paginationData }); return(toReturn); }
public void ReturnEntitiesWhenPresentInDatabase() { IEntityBusiness <Customer> cutomerBusiness = ServiceProvider.GetService <IEntityBusiness <Customer> >(); int? pageSize = 10; string sortCol = "CustomerID"; string sortDir = "ASC"; string searchTerms = string.Empty; int? pageNumber = 1; OperationResult result = cutomerBusiness.ListItems( pageNumber, pageSize, sortCol, sortDir, searchTerms); Assert.True(result.Success); IEnumerable <Customer> list = result.ObjectsDictionary["list"] as IEnumerable <Customer>; Assert.True(list.Count() == pageSize); }