SIAQ.DataAccess.Object.DACalificacion.SelectCalificacion C# (CSharp) Method

        public DataSet SelectCalificacion(ENTCalificacion ENTCalificacion, string ConnectionString)
        {
            DataSet ResultData = new DataSet();
            SqlConnection Connection = new SqlConnection(ConnectionString);
            SqlCommand Command;
            SqlParameter Parameter;
            SqlDataAdapter DataAdapter;

            try
            {
                Command = new SqlCommand("sptblCalificacion_Sel", Connection);
                Command.CommandType = CommandType.StoredProcedure;

                Parameter = new SqlParameter("CalificacionId", SqlDbType.Int);
                Parameter.Value = ENTCalificacion.CalificacionId;
                Command.Parameters.Add(Parameter);

                Parameter = new SqlParameter("Nombre", SqlDbType.VarChar);
                Parameter.Value = ENTCalificacion.Nombre;
                Command.Parameters.Add(Parameter);

                DataAdapter = new SqlDataAdapter(Command);

                Connection.Open();
                DataAdapter.Fill(ResultData);
                Connection.Close();

                return ResultData;

            }
            catch (SqlException Exception)
            {
                _ErrorId = Exception.Number;
                _ErrorDescription = Exception.Message;

                if (Connection.State == ConnectionState.Open)
                    Connection.Close();

                return ResultData;
            }
        }

        public DataSet SelectCalificacion()
        {
            string ConnectionString = string.Empty;
            DACalificacion DACalificacion = new DACalificacion();

            ConnectionString = sConnectionApplication;
            _ENTCalificacion.ResultData = DACalificacion.SelectCalificacion(_ENTCalificacion, ConnectionString);

            _ErrorId = DACalificacion.ErrorId;
            _ErrorDescription = DACalificacion.ErrorDescription;

            return _ENTCalificacion.ResultData;
        }