public async Task OnResourceExecutionAsync(ResourceExecutingContext context, ResourceExecutionDelegate next)
{
var httpContext = context.HttpContext;
var request = httpContext.Request;
var user = httpContext.User;
//Serialize Routes
var jsonRoutes = JsonConvert.SerializeObject(context.RouteData.Values);
//Serialize Headers
var headerDictionary = _jsonAutoService.GetHeadersDictionary(request.Headers, user);
var jsonHeaders = JsonConvert.SerializeObject(headerDictionary);
//Get connection string
var sqlConnection = _options.ConnectionString;
//Handle request
using (var reader = new StreamReader(request.Body))
{
var body = await reader.ReadToEndAsync();
switch (request.Method)
{
case nameof(SupportedMethods.GET):
var getResponse = await _jsonAutoService.SqlGetAsync(sqlConnection, jsonHeaders, procName, jsonRoutes);
context.Result = _jsonAutoService.JsonGetContentResult(getResponse.ToString());
break;
case nameof(SupportedMethods.PUT):
var putResponse = await _jsonAutoService.SqlPutAsync(sqlConnection, jsonHeaders, procName, jsonRoutes, body);
context.Result = _jsonAutoService.JsonPutContentResult(putResponse, _options.Mode, _options.ErrorThreshold);
break;
case nameof(SupportedMethods.POST):
var postResponse = await _jsonAutoService.SqlPostAsync(sqlConnection, jsonHeaders, procName, jsonRoutes, body);
context.Result = _jsonAutoService.JsonPostContentResult(postResponse, _options.Mode, _options.ErrorThreshold);
break;
case nameof(SupportedMethods.DELETE):
var deleteResponse = await _jsonAutoService.SqlDeleteAsync(sqlConnection, jsonHeaders, procName, jsonRoutes);
context.Result = _jsonAutoService.JsonDeleteContentResult(deleteResponse, _options.Mode, _options.ErrorThreshold);
break;
case nameof(SupportedMethods.HEAD):
var headResponse = await _jsonAutoService.SqlHeadAsync(sqlConnection, jsonHeaders, procName, jsonRoutes);
context.Result = _jsonAutoService.JsonHeadContentResult((bool)headResponse);
break;
default:
context.Result = _jsonAutoService.JsonDefaultContentResult();
break;
}
}
}
public async Task OnResourceExecutionAsync(ResourceExecutingContext context, ResourceExecutionDelegate next)
{
_logger.LogInformation("Entered OnResourceExecutionAsync() method of JsonResourceContextHandler");
var httpContext = context.HttpContext;
var request = httpContext.Request;
var user = httpContext.User;
//Serialize Routes
var jsonRoutes = JsonConvert.SerializeObject(context.RouteData.Values);
//Serialize Headers
var headerDictionary = _jsonAutoService.GetHeadersDictionary(request.Headers, user);
var jsonHeaders = JsonConvert.SerializeObject(headerDictionary);
//Get connection string
var sqlConnection = _options.ConnectionString;
//var sqlConnection = httpContext.Items[_options.ConnectionStringName].ToString();
// debug
var stopWatch = new Stopwatch();
//Handle request
using (var reader = new StreamReader(request.Body))
{
var body = await reader.ReadToEndAsync();
switch (request.Method)
{
case nameof(SupportedMethods.GET):
_logger.LogInformation($"Executing GET request for {procName} in db {sqlConnection}");
stopWatch.Start();
httpContext.Items[nameof(GetResult)] = new GetResult(await _jsonAutoService.SqlGetAsync(sqlConnection, jsonHeaders, procName, jsonRoutes));
stopWatch.Stop();
var ts1 = stopWatch.Elapsed;
var elapsedTime1 = String.Format("{0:00}:{1:00}:{2:00}.{3:00}",
ts1.Hours, ts1.Minutes, ts1.Seconds,
ts1.Milliseconds / 10);
_logger.LogInformation($"Result retrieved in {elapsedTime1}");
stopWatch.Reset();
break;
case nameof(SupportedMethods.PUT):
_logger.LogInformation($"Executing PUT request for {procName} in db {sqlConnection}");
stopWatch.Start();
httpContext.Items[nameof(PutResult)] = await _jsonAutoService.SqlPutAsync(sqlConnection, jsonHeaders, procName, jsonRoutes, body);
stopWatch.Stop();
var ts2 = stopWatch.Elapsed;
var elapsedTime2 = String.Format("{0:00}:{1:00}:{2:00}.{3:00}",
ts2.Hours, ts2.Minutes, ts2.Seconds,
ts2.Milliseconds / 10);
_logger.LogInformation($"Result retrieved in {elapsedTime2}");
stopWatch.Reset();
break;
case nameof(SupportedMethods.POST):
_logger.LogInformation($"Executing POST request for {procName} in db {sqlConnection}");
stopWatch.Start();
httpContext.Items[nameof(PostResult)] = await _jsonAutoService.SqlPostAsync(sqlConnection, jsonHeaders, procName, jsonRoutes, body);
stopWatch.Stop();
var ts3 = stopWatch.Elapsed;
var elapsedTime3 = String.Format("{0:00}:{1:00}:{2:00}.{3:00}",
ts3.Hours, ts3.Minutes, ts3.Seconds,
ts3.Milliseconds / 10);
_logger.LogInformation($"Result retrieved in {elapsedTime3}");
stopWatch.Reset();
break;
case nameof(SupportedMethods.DELETE):
_logger.LogInformation($"Executing DELETE request for {procName} in db {sqlConnection}");
stopWatch.Start();
httpContext.Items[nameof(DeleteResult)] = await _jsonAutoService.SqlDeleteAsync(sqlConnection, jsonHeaders, procName, jsonRoutes);
stopWatch.Stop();
var ts4 = stopWatch.Elapsed;
var elapsedTime4 = String.Format("{0:00}:{1:00}:{2:00}.{3:00}",
ts4.Hours, ts4.Minutes, ts4.Seconds,
ts4.Milliseconds / 10);
_logger.LogInformation($"Result retrieved in {elapsedTime4}");
stopWatch.Reset();
break;
case nameof(SupportedMethods.HEAD):
_logger.LogInformation($"Executing HEAD request for {procName} in db {sqlConnection}");
stopWatch.Start();
httpContext.Items[nameof(HeadResult)] = new HeadResult(await _jsonAutoService.SqlHeadAsync(sqlConnection, jsonHeaders, procName, jsonRoutes));
stopWatch.Stop();
var ts5 = stopWatch.Elapsed;
var elapsedTime5 = String.Format("{0:00}:{1:00}:{2:00}.{3:00}",
ts5.Hours, ts5.Minutes, ts5.Seconds,
ts5.Milliseconds / 10);
_logger.LogInformation($"Result retrieved in {elapsedTime5}");
stopWatch.Reset();
break;
default:
context.Result = _jsonAutoService.JsonDefaultContentResult();
break;
}
await next();
}
}