public IActionResult GetProcedureParameters(string ProcedureName) { var response = new OperationResponse <List <ProcedureParameter> >(); try { if (codeGeneratorService.SpExists(ProcedureName)) { response.Data = codeGeneratorService.GetSpParameters(ProcedureName); } else { response.Data = null; response.State = ResponseState.Error; response.Messages.Add("Sorry the procedure does not exist"); } } catch (Exception exception) { response.State = ResponseState.Error; response.Messages.Add(exception.Message); _logger.LogError(exception, "Error Getting Procedure Params"); } return(Json(response)); }