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);
}
