/// <summary>
        /// Creates a new PerformanceStandard record
        /// </summary>
        public static int Create(PerformanceStandardDO DO)
        {
            SqlParameter _PerformanceStandardTypeID = new SqlParameter("PerformanceStandardTypeID", SqlDbType.Int);
            SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
            SqlParameter _Section = new SqlParameter("Section", SqlDbType.VarChar);
            SqlParameter _SubSection = new SqlParameter("SubSection", SqlDbType.VarChar);
            SqlParameter _TOCID = new SqlParameter("TOCID", SqlDbType.Int);
            SqlParameter _AgreeToComply = new SqlParameter("AgreeToComply", SqlDbType.Bit);
            SqlParameter _OperatorComments = new SqlParameter("OperatorComments", SqlDbType.VarChar);

            _PerformanceStandardTypeID.Value = DO.PerformanceStandardTypeID;
            _PermitKey.Value = DO.PermitKey;
            _Section.Value = DO.Section;
            _SubSection.Value = DO.SubSection;
            _TOCID.Value = DO.TOCID;
            _AgreeToComply.Value = DO.AgreeToComply;
            _OperatorComments.Value = DO.OperatorComments;

            SqlParameter[] _params = new SqlParameter[] {
                _PerformanceStandardTypeID,
                _PermitKey,
                _Section,
                _SubSection,
                _TOCID,
                _AgreeToComply,
                _OperatorComments
            };

            return DataCommon.ExecuteScalar("[dbo].[PerformanceStandard_Insert]", _params, "dbo");
        }
        /// <summary>
        /// Deletes a PerformanceStandard record
        /// </summary>
        public static int Delete(PerformanceStandardDO DO)
        {
            SqlParameter _PerformanceStandardID = new SqlParameter("PerformanceStandardID", SqlDbType.Int);

            _PerformanceStandardID.Value = DO.PerformanceStandardID;

            SqlParameter[] _params = new SqlParameter[] {
                _PerformanceStandardID
            };

            return DataCommon.ExecuteScalar("[dbo].[PerformanceStandard_Delete]", _params, "dbo");
        }
        /// <summary>
        /// Gets all PerformanceStandard records
        /// </summary>
        public static PerformanceStandardDO[] GetAll()
        {
            SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[PerformanceStandard_GetAll]", new SqlParameter[] { }, "dbo");

            List<PerformanceStandardDO> objs = new List<PerformanceStandardDO>();

            while(sr.Read()){

                PerformanceStandardDO obj = new PerformanceStandardDO();

                obj.PerformanceStandardID = sr.GetInt32(sr.GetOrdinal("PerformanceStandardID"));
                obj.PerformanceStandardTypeID = sr.GetInt32(sr.GetOrdinal("PerformanceStandardTypeID"));
                obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
                obj.Section = sr.GetString(sr.GetOrdinal("Section"));
                obj.SubSection = sr.GetString(sr.GetOrdinal("SubSection"));
                obj.TOCID = sr.GetInt32(sr.GetOrdinal("TOCID"));
                obj.AgreeToComply = sr.GetBoolean(sr.GetOrdinal("AgreeToComply"));
                if (sr.IsDBNull(sr.GetOrdinal("OperatorComments"))) { obj.OperatorComments = null; } else { obj.OperatorComments = sr.GetString(sr.GetOrdinal("OperatorComments")); }

                objs.Add(obj);
            }

            return objs.ToArray();
        }