/// <summary> /// Select values from 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="titleIdentifierID"></param> /// <returns>Object of type TitleIdentifier.</returns> public TitleIdentifier TitleIdentifierSelectAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, int titleIdentifierID) { SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings(connectionKeyName), sqlConnection); SqlTransaction transaction = sqlTransaction; using (SqlCommand command = CustomSqlHelper.CreateCommand("TitleIdentifierSelectAuto", connection, transaction, CustomSqlHelper.CreateInputParameter("TitleIdentifierID", SqlDbType.Int, null, false, titleIdentifierID))) { using (CustomSqlHelper <TitleIdentifier> helper = new CustomSqlHelper <TitleIdentifier>()) { CustomGenericList <TitleIdentifier> list = helper.ExecuteReader(command); if (list.Count > 0) { TitleIdentifier o = list[0]; list = null; return(o); } else { return(null); } } } }
/// <summary> /// Manage TitleIdentifier object. /// If the object is of type CustomObjectBase, /// then either insert values into, delete values from, or update values in TitleIdentifier. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="value">Object of type TitleIdentifier.</param> /// <returns>Object of type CustomDataAccessStatus<TitleIdentifier>.</returns> public CustomDataAccessStatus <TitleIdentifier> TitleIdentifierManageAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, TitleIdentifier value) { return(TitleIdentifierManageAuto(sqlConnection, sqlTransaction, "BHL", value)); }
/// <summary> /// Update values in TitleIdentifier. Returns an object of type TitleIdentifier. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="value">Object of type TitleIdentifier.</param> /// <returns>Object of type TitleIdentifier.</returns> public TitleIdentifier TitleIdentifierUpdateAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, TitleIdentifier value) { return(TitleIdentifierUpdateAuto(sqlConnection, sqlTransaction, "BHL", value)); }
/// <summary> /// Update values in TitleIdentifier. Returns an object of type 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="titleIdentifierID"></param> /// <param name="identifierName"></param> /// <param name="marcDataFieldTag"></param> /// <param name="marcSubFieldCode"></param> /// <returns>Object of type TitleIdentifier.</returns> public TitleIdentifier TitleIdentifierUpdateAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, int titleIdentifierID, string identifierName, string marcDataFieldTag, string marcSubFieldCode) { SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings(connectionKeyName), sqlConnection); SqlTransaction transaction = sqlTransaction; using (SqlCommand command = CustomSqlHelper.CreateCommand("TitleIdentifierUpdateAuto", connection, transaction, CustomSqlHelper.CreateInputParameter("TitleIdentifierID", SqlDbType.Int, null, false, titleIdentifierID), CustomSqlHelper.CreateInputParameter("IdentifierName", SqlDbType.NVarChar, 40, false, identifierName), CustomSqlHelper.CreateInputParameter("MarcDataFieldTag", SqlDbType.NVarChar, 50, false, marcDataFieldTag), CustomSqlHelper.CreateInputParameter("MarcSubFieldCode", SqlDbType.NVarChar, 50, false, marcSubFieldCode), CustomSqlHelper.CreateReturnValueParameter("ReturnCode", SqlDbType.Int, null, false))) { using (CustomSqlHelper <TitleIdentifier> helper = new CustomSqlHelper <TitleIdentifier>()) { CustomGenericList <TitleIdentifier> list = helper.ExecuteReader(command); if (list.Count > 0) { TitleIdentifier o = list[0]; list = null; return(o); } else { return(null); } } } }
/// <summary> /// Insert values into TitleIdentifier. Returns an object of type 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 TitleIdentifier.</param> /// <returns>Object of type TitleIdentifier.</returns> public TitleIdentifier TitleIdentifierInsertAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, TitleIdentifier value) { return(TitleIdentifierInsertAuto(sqlConnection, sqlTransaction, connectionKeyName, value.IdentifierName, value.MarcDataFieldTag, value.MarcSubFieldCode)); }
/// <summary> /// Manage TitleIdentifier object. /// If the object is of type CustomObjectBase, /// then either insert values into, delete values from, or update values in 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 TitleIdentifier.</param> /// <returns>Object of type CustomDataAccessStatus<TitleIdentifier>.</returns> public CustomDataAccessStatus <TitleIdentifier> TitleIdentifierManageAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, TitleIdentifier value) { if (value.IsNew && !value.IsDeleted) { TitleIdentifier returnValue = TitleIdentifierInsertAuto(sqlConnection, sqlTransaction, connectionKeyName, value.IdentifierName, value.MarcDataFieldTag, value.MarcSubFieldCode); return(new CustomDataAccessStatus <TitleIdentifier>( CustomDataAccessContext.Insert, true, returnValue)); } else if (!value.IsNew && value.IsDeleted) { if (TitleIdentifierDeleteAuto(sqlConnection, sqlTransaction, connectionKeyName, value.TitleIdentifierID)) { return(new CustomDataAccessStatus <TitleIdentifier>( CustomDataAccessContext.Delete, true, value)); } else { return(new CustomDataAccessStatus <TitleIdentifier>( CustomDataAccessContext.Delete, false, value)); } } else if (value.IsDirty && !value.IsDeleted) { TitleIdentifier returnValue = TitleIdentifierUpdateAuto(sqlConnection, sqlTransaction, connectionKeyName, value.TitleIdentifierID, value.IdentifierName, value.MarcDataFieldTag, value.MarcSubFieldCode); return(new CustomDataAccessStatus <TitleIdentifier>( CustomDataAccessContext.Update, true, returnValue)); } else { return(new CustomDataAccessStatus <TitleIdentifier>( CustomDataAccessContext.NA, false, value)); } }