public IActionResult SearchQueryExcel([FromBody] SearchParameters parameters)
{
SearchControllerLogic scl = new SearchControllerLogic(_queryRepository);
QueryAndQueryParamsViewModel svm = scl.GetQueryResult(parameters);
MemoryStream ms = _queryRequestRepository.GetSqlRequestToExcelFile(svm);
return(new FileStreamResult(ms, new MediaTypeHeaderValue("application/octet-stream")));
}
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));
}
