/// <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>
/// Get the title association from the Title stored in the Session object
/// </summary>
/// <param name="titleAssociationId"></param>
/// <returns></returns>
private TitleAssociation FindTitleAssociation(int titleAssociationId)
{
TitleAssociation titleAssociation = null;
Title title = (Title)Session["Title" + hidTitleID.Value];
if (title != null)
{
foreach (TitleAssociation ta in title.TitleAssociations)
{
if (ta.IsDeleted)
{
continue;
}
if (titleAssociationId == 0 && ta.TitleAssociationID == 0)
{
titleAssociation = ta;
break;
}
else if (titleAssociationId > 0 && ta.TitleAssociationID == titleAssociationId)
{
titleAssociation = ta;
break;
}
}
}
return(titleAssociation);
}
/// <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));
}
protected void identifiersList_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = identifiersList.Rows[e.RowIndex];
if (row != null)
{
DropDownList ddlIdentifierName = row.FindControl("ddlIdentifierName") as DropDownList;
TextBox txtIdentifierValue = row.FindControl("txtIdentifierValue") as TextBox;
if (ddlIdentifierName != null && txtIdentifierValue != null)
{
//int titleAssociationId = (int)Session["TitleAssociation"];
int titleAssociationId = Convert.ToInt32(hidTitleAssociationID.Value);
TitleAssociation association = this.FindTitleAssociation(titleAssociationId);
TitleAssociation_TitleIdentifier taTitleIdentifier = FindTitleAssociation_TitleIdentifier(
association.TitleAssociationIdentifiers,
(int)identifiersList.DataKeys[e.RowIndex].Values[0],
(int)identifiersList.DataKeys[e.RowIndex].Values[1],
identifiersList.DataKeys[e.RowIndex].Values[2].ToString());
int titleIdentifierId = int.Parse(ddlIdentifierName.SelectedValue);
String identifierValue = txtIdentifierValue.Text;
taTitleIdentifier.TitleAssociationID = association.TitleAssociationID;
taTitleIdentifier.TitleIdentifierID = titleIdentifierId;
taTitleIdentifier.IdentifierName = ddlIdentifierName.SelectedItem.Text;
taTitleIdentifier.IdentifierValue = identifierValue;
}
}
identifiersList.EditIndex = -1;
bindTitleIdentifierData();
}
/// <summary>
/// Select values from TitleAssociation 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="titleAssociationID"></param>
/// <returns>Object of type TitleAssociation.</returns>
public TitleAssociation TitleAssociationSelectAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
string connectionKeyName,
int titleAssociationID)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings(connectionKeyName), sqlConnection);
SqlTransaction transaction = sqlTransaction;
using (SqlCommand command = CustomSqlHelper.CreateCommand("TitleAssociationSelectAuto", connection, transaction,
CustomSqlHelper.CreateInputParameter("TitleAssociationID", SqlDbType.Int, null, false, titleAssociationID)))
{
using (CustomSqlHelper <TitleAssociation> helper = new CustomSqlHelper <TitleAssociation>())
{
CustomGenericList <TitleAssociation> list = helper.ExecuteReader(command);
if (list.Count > 0)
{
TitleAssociation o = list[0];
list = null;
return(o);
}
else
{
return(null);
}
}
}
}
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);
}
protected void addTitleIdentifierButton_Click(object sender, EventArgs e)
{
//int titleAssociationId = (int)Session["TitleAssociation"];
int titleAssociationId = Convert.ToInt32(hidTitleAssociationID.Value);
TitleAssociation association = this.FindTitleAssociation(titleAssociationId);
TitleAssociation_TitleIdentifier ti = new TitleAssociation_TitleIdentifier();
ti.TitleAssociationID = association.TitleAssociationID;
association.TitleAssociationIdentifiers.Add(ti);
identifiersList.EditIndex = identifiersList.Rows.Count;
bindTitleIdentifierData();
}
/// <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="titleAssociationID"></param>
/// <param name="titleID"></param>
/// <param name="titleAssociationTypeID"></param>
/// <param name="title"></param>
/// <param name="section"></param>
/// <param name="volume"></param>
/// <param name="heading"></param>
/// <param name="publication"></param>
/// <param name="relationship"></param>
/// <param name="active"></param>
/// <param name="associatedTitleID"></param>
/// <returns>Object of type TitleAssociation.</returns>
public TitleAssociation TitleAssociationUpdateAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
string connectionKeyName,
int titleAssociationID,
int titleID,
int titleAssociationTypeID,
string title,
string section,
string volume,
string heading,
string publication,
string relationship,
bool active,
int?associatedTitleID)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings(connectionKeyName), sqlConnection);
SqlTransaction transaction = sqlTransaction;
using (SqlCommand command = CustomSqlHelper.CreateCommand("TitleAssociationUpdateAuto", connection, transaction,
CustomSqlHelper.CreateInputParameter("TitleAssociationID", SqlDbType.Int, null, false, titleAssociationID),
CustomSqlHelper.CreateInputParameter("TitleID", SqlDbType.Int, null, false, titleID),
CustomSqlHelper.CreateInputParameter("TitleAssociationTypeID", SqlDbType.Int, null, false, titleAssociationTypeID),
CustomSqlHelper.CreateInputParameter("Title", SqlDbType.NVarChar, 500, false, title),
CustomSqlHelper.CreateInputParameter("Section", SqlDbType.NVarChar, 500, false, section),
CustomSqlHelper.CreateInputParameter("Volume", SqlDbType.NVarChar, 500, false, volume),
CustomSqlHelper.CreateInputParameter("Heading", SqlDbType.NVarChar, 500, false, heading),
CustomSqlHelper.CreateInputParameter("Publication", SqlDbType.NVarChar, 500, false, publication),
CustomSqlHelper.CreateInputParameter("Relationship", SqlDbType.NVarChar, 500, false, relationship),
CustomSqlHelper.CreateInputParameter("Active", SqlDbType.Bit, null, false, active),
CustomSqlHelper.CreateInputParameter("AssociatedTitleID", SqlDbType.Int, null, true, associatedTitleID),
CustomSqlHelper.CreateReturnValueParameter("ReturnCode", SqlDbType.Int, null, false)))
{
using (CustomSqlHelper <TitleAssociation> helper = new CustomSqlHelper <TitleAssociation>())
{
CustomGenericList <TitleAssociation> list = helper.ExecuteReader(command);
if (list.Count > 0)
{
TitleAssociation o = list[0];
list = null;
return(o);
}
else
{
return(null);
}
}
}
}
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);
}
}
public TitleAssociation TitleAssociationSelectExtended(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
int titleAssociationID)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(
CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection);
SqlTransaction transaction = sqlTransaction;
TitleAssociation titleAssociation = this.TitleAssociationSelectAuto(connection, transaction, titleAssociationID);
if (titleAssociation != null)
{
titleAssociation.TitleAssociationIdentifiers = new TitleAssociation_TitleIdentifierDAL().TitleAssociation_TitleIdentifierSelectByTitleAssociationID(connection, transaction, titleAssociation.TitleAssociationID);
}
return(titleAssociation);
}
/// <summary>
/// Insert values into 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 TitleAssociationInsertAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
string connectionKeyName,
TitleAssociation value)
{
return(TitleAssociationInsertAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.TitleID,
value.TitleAssociationTypeID,
value.Title,
value.Section,
value.Volume,
value.Heading,
value.Publication,
value.Relationship,
value.Active,
value.AssociatedTitleID));
}
private void bindTitleIdentifierData()
{
//int titleAssociationId = (int)Session["TitleAssociation"];
int titleAssociationId = Convert.ToInt32(hidTitleAssociationID.Value);
TitleAssociation association = this.FindTitleAssociation(titleAssociationId);
// filter out deleted items
CustomGenericList <TitleAssociation_TitleIdentifier> titleIdentifiers = new CustomGenericList <TitleAssociation_TitleIdentifier>();
foreach (TitleAssociation_TitleIdentifier ti in association.TitleAssociationIdentifiers)
{
if (ti.IsDeleted == false)
{
titleIdentifiers.Add(ti);
}
}
identifiersList.DataSource = titleIdentifiers;
identifiersList.DataBind();
}
protected void identifiersList_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("RemoveButton"))
{
int rowNum = int.Parse(e.CommandArgument.ToString());
//int titleAssociationId = (int)Session["TitleAssociation"];
int titleAssociationId = Convert.ToInt32(hidTitleAssociationID.Value);
TitleAssociation association = this.FindTitleAssociation(titleAssociationId);
TitleAssociation_TitleIdentifier taTitleIdentifier = FindTitleAssociation_TitleIdentifier(
association.TitleAssociationIdentifiers,
(int)identifiersList.DataKeys[rowNum].Values[0],
(int)identifiersList.DataKeys[rowNum].Values[1],
identifiersList.DataKeys[rowNum].Values[2].ToString());
taTitleIdentifier.IsDeleted = true;
identifiersList.EditIndex = -1;
bindTitleIdentifierData();
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
//int titleAssociationId = (int)Session["TitleAssociation"];
int titleAssociationId = Convert.ToInt32(hidTitleAssociationID.Value);
if (validate())
{
TitleAssociation association = this.FindTitleAssociation(titleAssociationId);
// Gather up data on form
association.TitleAssociationTypeID = Convert.ToInt32(ddlType.SelectedValue);
association.TitleAssociationName = ddlType.SelectedItem.Text;
association.Title = titleTextBox.Text.Trim();
association.Section = sectionTextBox.Text.Trim();
association.Volume = volumeTextBox.Text.Trim();
association.Heading = headingTextBox.Text.Trim();
association.Publication = publicationTextBox.Text.Trim();
association.Relationship = relationshipTextBox.Text.Trim();
if (hidAssociatedTitleID.Value.Trim() == String.Empty)
{
association.AssociatedTitleID = null;
}
else
{
association.AssociatedTitleID = Convert.ToInt32(hidAssociatedTitleID.Value);
}
association.Active = activeCheckBox.Checked;
association.IsNew = (association.TitleAssociationID == 0);
// Forces deletes to happen first
association.TitleAssociationIdentifiers.Sort(SortOrder.Descending, "IsDeleted");
}
else
{
return;
}
ClientScript.RegisterClientScriptBlock(this.GetType(), "scptDone", "<script language='javascript'>parent.updateAssociations();</script>");
}
private void fillUI(int id, int titleID)
{
//Session["TitleAssociation"] = id;
hidTitleID.Value = titleID.ToString();
hidTitleAssociationID.Value = id.ToString();
TitleAssociation association = this.FindTitleAssociation(id);
if (association != null)
{
if (association.TitleAssociationTypeID != 0)
{
ddlType.SelectedValue = ddlType.Items.FindByValue(association.TitleAssociationTypeID.ToString()).Value;
}
else
{
ddlType.SelectedIndex = 0;
}
titleTextBox.Text = association.Title;
sectionTextBox.Text = association.Section;
volumeTextBox.Text = association.Volume;
headingTextBox.Text = association.Heading;
publicationTextBox.Text = association.Publication;
relationshipTextBox.Text = association.Relationship;
activeCheckBox.Checked = association.Active;
if (association.AssociatedTitleID != null)
{
Title title = new BHLProvider().TitleSelectAuto((int)association.AssociatedTitleID);
litAssociatedTitle.Text = association.AssociatedTitleID.ToString() + ": " + title.ShortTitle;
hidAssociatedTitleID.Value = association.AssociatedTitleID.ToString();
}
this.bindTitleIdentifierData();
}
}
/// <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));
}
}
public void TitleAssociationSave(TitleAssociation titleAssociation)
{
TitleAssociationDAL.Save(null, null, titleAssociation);
}
