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