public IHttpActionResult PostLinkedQueryResult(LinkedQueryResult results)
{
if (results == null)
{
return(this.BadRequest("The results parameter cannot be null"));
}
try
{
Log.Debug("{class} {method} {event}", "WorkbookController", "PostLinkedQueryResult", "Start");
using (var xl = new ExcelHelper(Globals.ThisAddIn.Application))
{
var sht = xl.GetTargetWorksheet(results.TargetSheet);
xl.DaxQueryTable(sht, results.DaxQuery, results.ConnectionString);
}
Log.Debug("{class} {method} {event}", "WorkbookController", "PostLinkedQueryResult", "End");
return(Ok());
}
#pragma warning disable CA1031 // Do not catch general exception types
catch (Exception ex)
#pragma warning restore CA1031 // Do not catch general exception types
{
Log.Error("{class} {method} {message} {stacktrace}", "WorkbookController", "PostLinkedQueryResult", ex.Message, ex.StackTrace);
return(BadRequest(ex.Message));
}
}
public IHttpActionResult PostLinkedQueryResult(LinkedQueryResult results)
{
try
{
Log.Debug("{class} {method} {event}", "WorkbookController", "PostLinkedQueryResult", "Start");
var xl = new ExcelHelper(Globals.ThisAddIn.Application);
var sht = xl.GetTargetWorksheet(results.TargetSheet);
xl.DaxQueryTable(sht, results.DaxQuery, results.ConnectionString);
Log.Debug("{class} {method} {event}", "WorkbookController", "PostLinkedQueryResult", "End");
return(Ok());
}
catch (Exception ex)
{
Log.Error("{class} {method} {message} {stacktrace}", "WorkbookController", "PostLinkedQueryResult", ex.Message, ex.StackTrace);
return(BadRequest(ex.Message));
}
}
