/// <summary> /// Select values from Title_TitleIdentifier by primary key(s). /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="connectionKeyName">Connection key name located in config file.</param> /// <param name="title_TitleIdentifierID"></param> /// <returns>Object of type Title_TitleIdentifier.</returns> public Title_TitleIdentifier Title_TitleIdentifierSelectAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, int title_TitleIdentifierID) { SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings(connectionKeyName), sqlConnection); SqlTransaction transaction = sqlTransaction; using (SqlCommand command = CustomSqlHelper.CreateCommand("Title_TitleIdentifierSelectAuto", connection, transaction, CustomSqlHelper.CreateInputParameter("Title_TitleIdentifierID", SqlDbType.Int, null, false, title_TitleIdentifierID))) { using (CustomSqlHelper <Title_TitleIdentifier> helper = new CustomSqlHelper <Title_TitleIdentifier>()) { CustomGenericList <Title_TitleIdentifier> list = helper.ExecuteReader(command); if (list.Count > 0) { Title_TitleIdentifier o = list[0]; list = null; return(o); } else { return(null); } } } }
/// <summary> /// Update values in Title_TitleIdentifier. Returns an object of type Title_TitleIdentifier. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="value">Object of type Title_TitleIdentifier.</param> /// <returns>Object of type Title_TitleIdentifier.</returns> public Title_TitleIdentifier Title_TitleIdentifierUpdateAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, Title_TitleIdentifier value) { return(Title_TitleIdentifierUpdateAuto(sqlConnection, sqlTransaction, "BHL", value)); }
/// <summary> /// Manage Title_TitleIdentifier object. /// If the object is of type CustomObjectBase, /// then either insert values into, delete values from, or update values in Title_TitleIdentifier. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="value">Object of type Title_TitleIdentifier.</param> /// <returns>Object of type CustomDataAccessStatus<Title_TitleIdentifier>.</returns> public CustomDataAccessStatus <Title_TitleIdentifier> Title_TitleIdentifierManageAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, Title_TitleIdentifier value) { return(Title_TitleIdentifierManageAuto(sqlConnection, sqlTransaction, "BHL", value)); }
/// <summary> /// Insert values into Title_TitleIdentifier. Returns an object of type Title_TitleIdentifier. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="connectionKeyName">Connection key name located in config file.</param> /// <param name="value">Object of type Title_TitleIdentifier.</param> /// <returns>Object of type Title_TitleIdentifier.</returns> public Title_TitleIdentifier Title_TitleIdentifierInsertAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, Title_TitleIdentifier value) { return(Title_TitleIdentifierInsertAuto(sqlConnection, sqlTransaction, connectionKeyName, value.TitleID, value.TitleIdentifierID, value.IdentifierValue)); }
/// <summary> /// Manage Title_TitleIdentifier object. /// If the object is of type CustomObjectBase, /// then either insert values into, delete values from, or update values in Title_TitleIdentifier. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="connectionKeyName">Connection key name located in config file.</param> /// <param name="value">Object of type Title_TitleIdentifier.</param> /// <returns>Object of type CustomDataAccessStatus<Title_TitleIdentifier>.</returns> public CustomDataAccessStatus <Title_TitleIdentifier> Title_TitleIdentifierManageAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, Title_TitleIdentifier value) { if (value.IsNew && !value.IsDeleted) { Title_TitleIdentifier returnValue = Title_TitleIdentifierInsertAuto(sqlConnection, sqlTransaction, connectionKeyName, value.TitleID, value.TitleIdentifierID, value.IdentifierValue); return(new CustomDataAccessStatus <Title_TitleIdentifier>( CustomDataAccessContext.Insert, true, returnValue)); } else if (!value.IsNew && value.IsDeleted) { if (Title_TitleIdentifierDeleteAuto(sqlConnection, sqlTransaction, connectionKeyName, value.Title_TitleIdentifierID)) { return(new CustomDataAccessStatus <Title_TitleIdentifier>( CustomDataAccessContext.Delete, true, value)); } else { return(new CustomDataAccessStatus <Title_TitleIdentifier>( CustomDataAccessContext.Delete, false, value)); } } else if (value.IsDirty && !value.IsDeleted) { Title_TitleIdentifier returnValue = Title_TitleIdentifierUpdateAuto(sqlConnection, sqlTransaction, connectionKeyName, value.Title_TitleIdentifierID, value.TitleID, value.TitleIdentifierID, value.IdentifierValue); return(new CustomDataAccessStatus <Title_TitleIdentifier>( CustomDataAccessContext.Update, true, returnValue)); } else { return(new CustomDataAccessStatus <Title_TitleIdentifier>( CustomDataAccessContext.NA, false, value)); } }