Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [HttpPost]
- public async Task<IActionResult> Post()
- {
- using (var sr = new StreamReader(Request.Body))
- {
- var body = sr.ReadToEnd();
- var json = JObject.Parse(body);
- if (_storedProcedures.InputDataStoredProc != null)
- {
- var inputParameters = _storedProcedures.InputDataStoredProc.ToSqlParameters(json.ToString());
- await _context.ExecuteNonQueryAsync(_storedProcedures.InputDataStoredProc.Name, inputParameters);
- }
- if (_storedProcedures.OutputDataStoredProc != null)
- {
- var outputParameters = _storedProcedures.OutputDataStoredProc.ToSqlParameters(json.ToString());
- var result =
- await _context.ExecuteScalarAsync(_storedProcedures.OutputDataStoredProc.Name, outputParameters);
- IActionResult response = result != null
- ? new JsonResult(JObject.Parse(result.ToString()))
- : (IActionResult)new EmptyResult();
- return response;
- }
- return new EmptyResult();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement