public IActionResult SearchQuery([FromBody] SearchParameters parameters)
{
SearchControllerLogic scl = new SearchControllerLogic(_queryRepository);
QueryAndQueryParamsViewModel svm = scl.GetQueryResult(parameters);
DataTable sqlResults = _queryRequestRepository.GetSqlRequestToPage(svm);
SqlResultViewModel resultViewModel = SearchControllerLogic.GetResultViewModel(sqlResults);
return(Ok(resultViewModel));
}
//Converts the DataTable into readable variables and adds it to the "SqlResultViewModel"
internal static SqlResultViewModel GetResultViewModel(DataTable sqlResults)
{
SqlResultViewModel resultViewModel = new SqlResultViewModel();
resultViewModel.ColumnNames = GetColumnNamesFromDataTable(sqlResults);
resultViewModel.RowValues = GetListRowResultFromDataTable(sqlResults);
if (resultViewModel.RowValues.Count == 0)
{
resultViewModel.Message = "Det fanns inga matchande resultat!";
}
else
{
resultViewModel.Message = "Nerladdning slutförd!";
}
return(resultViewModel);
}
