RoutineParamBase.cs

Go to the documentation of this file.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace RoutineAnalyzer
{
    public enum ParameterTypes
    {
        IntByValue,
        IntByReference,
        StringByValue,
        StringByReference
    };

    public abstract class RoutineParamBase
    {
        #region Static Methods

        static ParameterTypes ConvertParameterType(string paramType, bool isIn)
        {
            paramType = paramType.ToUpper();
            if (isIn)
            {
                if (paramType.Contains("VARCHAR"))
                    return ParameterTypes.StringByValue;
                else
                    return ParameterTypes.IntByValue;
            }
            else
            {
                if (paramType.Contains("VARCHAR"))
                    return ParameterTypes.StringByReference;
                else
                    return ParameterTypes.IntByReference;
            }
        }

        #endregion

        #region Fields

        protected string _name;
        protected string _sql;
        protected int _index;
        protected bool _isInParam;
        protected ParameterTypes _type;

        public string Name
        {
            get
            {
                return _name;
            }
        }
        #endregion

        #region Methods

        public RoutineParamBase(string sql, int index)
        {
            _index = index;

            Parse(sql);
        }

        void Parse(string sql)
        {
            //save the original SQL
            _sql = sql;

            //break up the parameters by their spaces
            //NOTE: This is a very brittle way of parsing and depends on consistent SQL coding style in the database
            string[] parts = sql.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);

            string direction;
            string name;
            string type;

            //We assuming the delcaration takes the form: DIRECTION NAME TYPE
            //if they didn't use an explicit IN declaration, then it is assumed to be one
            if (parts.Length == 2)
            {
                direction = "IN";
                name = parts[0];
                type = parts[1];
            }
            else
            {
                direction = parts[0].ToUpper();
                name = parts[1];
                type = parts[2];
            }

            //if the direction is IN, then it's an in paramter (otherwise it is an OUT)
            _isInParam = direction.ToUpper() == "IN";
            _type = ConvertParameterType(type, _isInParam);
            _name = name;
        }

        public virtual string GetParameter()
        {
            //if it is just an input param, then we use a quotation mark as the param maker
            if (_isInParam)
                return "?";

            //if it is an output parameter, then we create a variable name based on the index
            return string.Format("@param{0}", _index);
        }

        public abstract string GetDeclaration();

        public abstract string GetPreExecuteCode();

        public abstract string GetPostExecuteCode();

        #endregion
    }
}