public IHttpActionResult ExecuteReader([FromBody] string command)
{
_logger.Debug(string.Format("Begin. Command: [{0}]", command));
if (string.IsNullOrWhiteSpace(command))
{
_logger.Error("Command is empty");
return(BadRequest());
}
List <List <Dictionary <string, object> > > data = new List <List <Dictionary <string, object> > >();
using (var executor = new NdSqlExecutor())
{
_logger.Debug(string.Format("Executing reader with command [{0}]", command));
data = executor.Reader(command);
_logger.Debug("Reader executed successfully");
}
_logger.Debug("Command executed successfully");
return(Ok(data));
}
public IHttpActionResult ExecuteNonQuery(IEnumerable <string> commands)
{
_logger.Debug(string.Format("Begin. Commands: [{0}]", string.Join(", ", commands)));
if (commands.Any())
{
int rowsAffected = 0;
using (var executor = new NdSqlExecutor())
{
foreach (var command in commands)
{
_logger.Debug(string.Format("Executing command [{0}]", command));
if (string.IsNullOrWhiteSpace(command))
{
_logger.Error("Command is empty. Skipping it.");
continue;
}
try
{
var tmp = executor.NonQuery(command);
rowsAffected += tmp;
_logger.Debug(string.Format("Command executed successfully. Rows affected [{0}]", tmp));
}
catch (Exception ex)
{
_logger.Error(string.Format("Error executing command. Command: [{0}]", command), ex);
return(InternalServerError(ex));
}
}
}
_logger.Debug(string.Format("All commands executed successfully. Rows affected [{0}]", rowsAffected));
return(Ok(rowsAffected));
}
_logger.Error("Command set is empty");
return(BadRequest());
}
