Advertisement
Guest User

Untitled

a guest
Mar 24th, 2017
295
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.25 KB | None | 0 0
  1. [HttpPost]
  2. public async Task<IActionResult> Post()
  3. {
  4. using (var sr = new StreamReader(Request.Body))
  5. {
  6. var body = sr.ReadToEnd();
  7. var json = JObject.Parse(body);
  8.  
  9. if (_storedProcedures.InputDataStoredProc != null)
  10. {
  11. var inputParameters = _storedProcedures.InputDataStoredProc.ToSqlParameters(json.ToString());
  12. await _context.ExecuteNonQueryAsync(_storedProcedures.InputDataStoredProc.Name, inputParameters);
  13. }
  14.  
  15. if (_storedProcedures.OutputDataStoredProc != null)
  16. {
  17. var outputParameters = _storedProcedures.OutputDataStoredProc.ToSqlParameters(json.ToString());
  18. var result =
  19. await _context.ExecuteScalarAsync(_storedProcedures.OutputDataStoredProc.Name, outputParameters);
  20.  
  21. IActionResult response = result != null
  22. ? new JsonResult(JObject.Parse(result.ToString()))
  23. : (IActionResult)new EmptyResult();
  24. return response;
  25. }
  26.  
  27. return new EmptyResult();
  28. }
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement