/// <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));
}
}
