public static void Save(SqlConnection sqlConnection, SqlTransaction sqlTransaction, TitleAssociation titleAssociation) { SqlConnection connection = sqlConnection; SqlTransaction transaction = sqlTransaction; if (connection == null) { connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL")); } bool isTransactionCoordinator = CustomSqlHelper.IsTransactionCoordinator(transaction); try { transaction = CustomSqlHelper.BeginTransaction(connection, transaction, isTransactionCoordinator); CustomDataAccessStatus<TitleAssociation> updatedTitleAssociation = new TitleAssociationDAL().TitleAssociationManageAuto(connection, transaction, titleAssociation); if (titleAssociation.TitleAssociationIdentifiers.Count > 0) { TitleAssociation_TitleIdentifierDAL titleAssociationTitleIdentifierDAL = new TitleAssociation_TitleIdentifierDAL(); foreach (TitleAssociation_TitleIdentifier titleAssociationTitleIdentifier in titleAssociation.TitleAssociationIdentifiers) { if (titleAssociationTitleIdentifier.TitleAssociationID == 0) titleAssociationTitleIdentifier.TitleAssociationID = updatedTitleAssociation.ReturnObject.TitleAssociationID; titleAssociationTitleIdentifierDAL.TitleAssociation_TitleIdentifierManageAuto(connection, transaction, titleAssociationTitleIdentifier); } } CustomSqlHelper.CommitTransaction(transaction, isTransactionCoordinator); } catch (Exception ex) { CustomSqlHelper.RollbackTransaction(transaction, isTransactionCoordinator); throw new Exception("Exception in Save", ex); } finally { CustomSqlHelper.CloseConnection(connection, isTransactionCoordinator); } }
private void addTitleAssociation(int titleID) { Title title = (Title)Session["Title" + titleID.ToString()]; TitleAssociation ta = new TitleAssociation(); ta.TitleID = title.TitleID; ta.Active = true; ta.IsNew = true; title.TitleAssociations.Add(ta); }
/// <summary> /// Update values in TitleAssociation. Returns an object of type TitleAssociation. /// </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 TitleAssociation.</param> /// <returns>Object of type TitleAssociation.</returns> public TitleAssociation TitleAssociationUpdateAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, TitleAssociation value) { return TitleAssociationUpdateAuto(sqlConnection, sqlTransaction, connectionKeyName, value.TitleAssociationID, value.TitleID, value.TitleAssociationTypeID, value.Title, value.Section, value.Volume, value.Heading, value.Publication, value.Relationship, value.Active, value.AssociatedTitleID); }
/// <summary> /// Update values in TitleAssociation. Returns an object of type TitleAssociation. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="value">Object of type TitleAssociation.</param> /// <returns>Object of type TitleAssociation.</returns> public TitleAssociation TitleAssociationUpdateAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, TitleAssociation value) { return TitleAssociationUpdateAuto(sqlConnection, sqlTransaction, "BHL", value ); }
/// <summary> /// Manage TitleAssociation object. /// If the object is of type CustomObjectBase, /// then either insert values into, delete values from, or update values in TitleAssociation. /// </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 TitleAssociation.</param> /// <returns>Object of type CustomDataAccessStatus<TitleAssociation>.</returns> public CustomDataAccessStatus<TitleAssociation> TitleAssociationManageAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, TitleAssociation value) { if (value.IsNew && !value.IsDeleted) { TitleAssociation returnValue = TitleAssociationInsertAuto(sqlConnection, sqlTransaction, connectionKeyName, value.TitleID, value.TitleAssociationTypeID, value.Title, value.Section, value.Volume, value.Heading, value.Publication, value.Relationship, value.Active, value.AssociatedTitleID); return new CustomDataAccessStatus<TitleAssociation>( CustomDataAccessContext.Insert, true, returnValue); } else if (!value.IsNew && value.IsDeleted) { if (TitleAssociationDeleteAuto(sqlConnection, sqlTransaction, connectionKeyName, value.TitleAssociationID)) { return new CustomDataAccessStatus<TitleAssociation>( CustomDataAccessContext.Delete, true, value); } else { return new CustomDataAccessStatus<TitleAssociation>( CustomDataAccessContext.Delete, false, value); } } else if (value.IsDirty && !value.IsDeleted) { TitleAssociation returnValue = TitleAssociationUpdateAuto(sqlConnection, sqlTransaction, connectionKeyName, value.TitleAssociationID, value.TitleID, value.TitleAssociationTypeID, value.Title, value.Section, value.Volume, value.Heading, value.Publication, value.Relationship, value.Active, value.AssociatedTitleID); return new CustomDataAccessStatus<TitleAssociation>( CustomDataAccessContext.Update, true, returnValue); } else { return new CustomDataAccessStatus<TitleAssociation>( CustomDataAccessContext.NA, false, value); } }
/// <summary> /// Manage TitleAssociation object. /// If the object is of type CustomObjectBase, /// then either insert values into, delete values from, or update values in TitleAssociation. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="value">Object of type TitleAssociation.</param> /// <returns>Object of type CustomDataAccessStatus<TitleAssociation>.</returns> public CustomDataAccessStatus<TitleAssociation> TitleAssociationManageAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, TitleAssociation value) { return TitleAssociationManageAuto( sqlConnection, sqlTransaction, "BHL", value ); }
public void TitleAssociationSave(TitleAssociation titleAssociation) { TitleAssociationDAL.Save(null, null, titleAssociation); }