public ViewResult Index(string SortOrder, string CurrentFilter, string SearchQuery, int?CurrentPage)
{
//Handle Paging
int pageSize = 20;
int pageNumber = (CurrentPage ?? 1);
//Handle Sorting by Column
if (string.IsNullOrEmpty(SortOrder))
{
SortOrder = "";
}
ViewBag.CurrentSort = SortOrder;
ViewBag.NameSortParm = (SortOrder == "legal_name") ? "legal_name_desc" : "legal_name";
ViewBag.DBASortParm = (SortOrder == "doing_business_as_name") ? "doing_business_as_name_desc" : "doing_business_as_name";
ViewBag.ZipSortParm = (SortOrder == "zip_code") ? "zip_code_desc" : "zip_code";
ViewBag.IssuedSortParm = (SortOrder == "date_issued") ? "date_issued_desc" : "date_issued";
bool sortAsc = (!SortOrder.Contains("_desc")) ? true : false;
//Handle Filtering
if (!string.IsNullOrEmpty(SearchQuery))
{
CurrentPage = 1;
}
else
{
SearchQuery = CurrentFilter;
}
ViewBag.CurrentFilter = SearchQuery;
if (!string.IsNullOrEmpty(SearchQuery))
{
SearchQuery = SearchQuery.ToUpper().Trim();
}
//Call out to OpenData API
var bigData = SODAHelper.GetBusinessLocations(SearchQuery, pageNumber, pageSize, SortOrder.Replace("_desc", ""), sortAsc);
return(View(bigData));
}
public ViewResult Index(string SortOrder, string CurrentFilter, string SearchQuery, int?CurrentPage)
{
// Paging
int pageSize = 20;
int pageNumber = (CurrentPage ?? 1);
// Sort by column
if (string.IsNullOrEmpty(SortOrder))
{
SortOrder = "";
}
ViewBag.CurrentSort = SortOrder;
ViewBag.NameSortParm = (SortOrder == "company_name") ? "company_name_desc" : "company_name";
ViewBag.DBASortParm = (SortOrder == "sub_subindustry") ? "sub_subindustry_desc" : "sub_subindustry";
ViewBag.ZipSortParm = (SortOrder == "phone") ? "phone_desc" : "phone";
ViewBag.IssuedSortParm = (SortOrder == "location_1") ? "location_1_desc" : "location_1";
bool sortAsc = (!SortOrder.Contains("_desc")) ? true : false;
// Filtering
if (!string.IsNullOrEmpty(SearchQuery))
{
CurrentPage = 1;
}
else
{
SearchQuery = CurrentFilter;
}
ViewBag.CurrentFilter = SearchQuery;
if (!string.IsNullOrEmpty(SearchQuery))
{
SearchQuery = SearchQuery.ToUpper().Trim();
}
var bigData = SODAHelper.GetBusinessLocations(SearchQuery, pageNumber, pageSize, SortOrder.Replace("_desc", ""), sortAsc);
return(View(bigData));
}