/// <summary>
 /// Update values in Title_TitleType. Returns an object of type Title_TitleType.
 /// </summary>
 /// <param name="sqlConnection">Sql connection or null.</param>
 /// <param name="sqlTransaction">Sql transaction or null.</param>
 /// <param name="value">Object of type Title_TitleType.</param>
 /// <returns>Object of type Title_TitleType.</returns>
 public Title_TitleType Title_TitleTypeUpdateAuto(
     SqlConnection sqlConnection,
     SqlTransaction sqlTransaction,
     Title_TitleType value)
 {
     return Title_TitleTypeUpdateAuto(sqlConnection, sqlTransaction,
         value.Title_TitleTypeID,
         value.TitleID,
         value.TitleTypeID);
 }
        /// <summary>
        /// Manage Title_TitleType object.
        /// If the object is of type CustomObjectBase, 
        /// then either insert values into, delete values from, or update values in Title_TitleType.
        /// </summary>
        /// <param name="sqlConnection">Sql connection or null.</param>
        /// <param name="sqlTransaction">Sql transaction or null.</param>
        /// <param name="value">Object of type Title_TitleType.</param>
        /// <returns>Object of type CustomDataAccessStatus<Title_TitleType>.</returns>
        public CustomDataAccessStatus<Title_TitleType> Title_TitleTypeManageAuto(
            SqlConnection sqlConnection,
            SqlTransaction sqlTransaction,
            Title_TitleType value)
        {
            if (value.IsNew && !value.IsDeleted)
            {

                Title_TitleType returnValue = Title_TitleTypeInsertAuto(sqlConnection, sqlTransaction,
                    value.TitleID,
                        value.TitleTypeID);

                return new CustomDataAccessStatus<Title_TitleType>(
                    CustomDataAccessContext.Insert,
                    true, returnValue);
            }
            else if (!value.IsNew && value.IsDeleted)
            {
                if (Title_TitleTypeDeleteAuto(sqlConnection, sqlTransaction,
                    value.Title_TitleTypeID))
                {
                return new CustomDataAccessStatus<Title_TitleType>(
                    CustomDataAccessContext.Delete,
                    true, value);
                }
                else
                {
                return new CustomDataAccessStatus<Title_TitleType>(
                    CustomDataAccessContext.Delete,
                    false, value);
                }
            }
            else if (value.IsDirty && !value.IsDeleted)
            {

                Title_TitleType returnValue = Title_TitleTypeUpdateAuto(sqlConnection, sqlTransaction,
                    value.Title_TitleTypeID,
                        value.TitleID,
                        value.TitleTypeID);

                return new CustomDataAccessStatus<Title_TitleType>(
                    CustomDataAccessContext.Update,
                    true, returnValue);
            }
            else
            {
                return new CustomDataAccessStatus<Title_TitleType>(
                    CustomDataAccessContext.NA,
                    false, value);
            }
        }