/// <summary> /// Select values from Title_TitleType by primary key(s). /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="title_TitleTypeID"></param> /// <returns>Object of type Title_TitleType.</returns> public Title_TitleType Title_TitleTypeSelectAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, int title_TitleTypeID) { SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection); SqlTransaction transaction = sqlTransaction; using (SqlCommand command = CustomSqlHelper.CreateCommand("Title_TitleTypeSelectAuto", connection, transaction, CustomSqlHelper.CreateInputParameter("Title_TitleTypeID", SqlDbType.Int, null, false, title_TitleTypeID))) { using (CustomSqlHelper <Title_TitleType> helper = new CustomSqlHelper <Title_TitleType>()) { CustomGenericList <Title_TitleType> list = helper.ExecuteReader(command); if (list.Count > 0) { Title_TitleType o = list[0]; list = null; return(o); } else { return(null); } } } }
/// <summary> /// Insert values into 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_TitleTypeInsertAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, Title_TitleType value) { return(Title_TitleTypeInsertAuto(sqlConnection, sqlTransaction, 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)); } }