Example #1
0
        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));
        }