/// <summary>
/// Select values from Title_Creator by primary key(s).
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="title_CreatorID"></param>
/// <returns>Object of type Title_Creator.</returns>
public Title_Creator Title_CreatorSelectAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
int title_CreatorID)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection);
SqlTransaction transaction = sqlTransaction;
using (SqlCommand command = CustomSqlHelper.CreateCommand("Title_CreatorSelectAuto", connection, transaction,
CustomSqlHelper.CreateInputParameter("Title_CreatorID", SqlDbType.Int, null, false, title_CreatorID)))
{
using (CustomSqlHelper <Title_Creator> helper = new CustomSqlHelper <Title_Creator>())
{
CustomGenericList <Title_Creator> list = helper.ExecuteReader(command);
if (list.Count > 0)
{
Title_Creator o = list[0];
list = null;
return(o);
}
else
{
return(null);
}
}
}
}
/// <summary>
/// Manage Title_Creator object.
/// If the object is of type CustomObjectBase,
/// then either insert values into, delete values from, or update values in Title_Creator.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type Title_Creator.</param>
/// <returns>Object of type CustomDataAccessStatus<Title_Creator>.</returns>
public CustomDataAccessStatus <Title_Creator> Title_CreatorManageAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
Title_Creator value, int userId)
{
if (value.IsNew && !value.IsDeleted)
{
value.CreationUserID = userId;
value.LastModifiedUserID = userId;
Title_Creator returnValue = Title_CreatorInsertAuto(sqlConnection, sqlTransaction,
value.TitleID,
value.CreatorID,
value.CreatorRoleTypeID,
value.CreationUserID,
value.LastModifiedUserID);
return(new CustomDataAccessStatus <Title_Creator>(
CustomDataAccessContext.Insert,
true, returnValue));
}
else if (!value.IsNew && value.IsDeleted)
{
if (Title_CreatorDeleteAuto(sqlConnection, sqlTransaction,
value.Title_CreatorID))
{
return(new CustomDataAccessStatus <Title_Creator>(
CustomDataAccessContext.Delete,
true, value));
}
else
{
return(new CustomDataAccessStatus <Title_Creator>(
CustomDataAccessContext.Delete,
false, value));
}
}
else if (value.IsDirty && !value.IsDeleted)
{
value.LastModifiedUserID = userId;
Title_Creator returnValue = Title_CreatorUpdateAuto(sqlConnection, sqlTransaction,
value.Title_CreatorID,
value.TitleID,
value.CreatorID,
value.CreatorRoleTypeID,
value.LastModifiedUserID);
return(new CustomDataAccessStatus <Title_Creator>(
CustomDataAccessContext.Update,
true, returnValue));
}
else
{
return(new CustomDataAccessStatus <Title_Creator>(
CustomDataAccessContext.NA,
false, value));
}
}
/// <summary>
/// Update values in Title_Creator. Returns an object of type Title_Creator.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type Title_Creator.</param>
/// <returns>Object of type Title_Creator.</returns>
public Title_Creator Title_CreatorUpdateAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
Title_Creator value)
{
return(Title_CreatorUpdateAuto(sqlConnection, sqlTransaction,
value.Title_CreatorID,
value.TitleID,
value.CreatorID,
value.CreatorRoleTypeID,
value.LastModifiedUserID));
}
private bool titleCreatorExists( CustomGenericList<Title_Creator> titleCreators,
Title_Creator titleCreatorToCheckFor)
{
foreach ( Title_Creator tc in titleCreators )
{
if ( ( tc.TitleID == titleCreatorToCheckFor.TitleID ) &&
( tc.CreatorID == titleCreatorToCheckFor.CreatorID ) &&
( tc.CreatorRoleTypeID == titleCreatorToCheckFor.CreatorRoleTypeID ) )
{
return true;
}
}
return false;
}
private bool titleCreatorExists(CustomGenericList <Title_Creator> titleCreators,
Title_Creator titleCreatorToCheckFor)
{
foreach (Title_Creator tc in titleCreators)
{
if ((tc.TitleID == titleCreatorToCheckFor.TitleID) &&
(tc.CreatorID == titleCreatorToCheckFor.CreatorID) &&
(tc.CreatorRoleTypeID == titleCreatorToCheckFor.CreatorRoleTypeID))
{
return(true);
}
}
return(false);
}
/// <summary>
/// Insert values into Title_Creator.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="titleID">Unique identifier for each Title record.</param>
/// <param name="creatorID">Unique identifier for each Creator record.</param>
/// <param name="creatorRoleTypeID">Unique identifier for each Creator Role Type.</param>
/// <param name="creationUserID"></param>
/// <param name="lastModifiedUserID"></param>
/// <returns>Object of type Title_Creator.</returns>
public Title_Creator Title_CreatorInsertAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
int titleID,
int creatorID,
int creatorRoleTypeID,
int?creationUserID,
int?lastModifiedUserID)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection);
SqlTransaction transaction = sqlTransaction;
using (SqlCommand command = CustomSqlHelper.CreateCommand("Title_CreatorInsertAuto", connection, transaction,
CustomSqlHelper.CreateOutputParameter("Title_CreatorID", SqlDbType.Int, null, false),
CustomSqlHelper.CreateInputParameter("TitleID", SqlDbType.Int, null, false, titleID),
CustomSqlHelper.CreateInputParameter("CreatorID", SqlDbType.Int, null, false, creatorID),
CustomSqlHelper.CreateInputParameter("CreatorRoleTypeID", SqlDbType.Int, null, false, creatorRoleTypeID),
CustomSqlHelper.CreateInputParameter("CreationUserID", SqlDbType.Int, null, true, creationUserID),
CustomSqlHelper.CreateInputParameter("LastModifiedUserID", SqlDbType.Int, null, true, lastModifiedUserID),
CustomSqlHelper.CreateReturnValueParameter("ReturnCode", SqlDbType.Int, null, false)))
{
using (CustomSqlHelper <Title_Creator> helper = new CustomSqlHelper <Title_Creator>())
{
CustomGenericList <Title_Creator> list = helper.ExecuteReader(command);
if (list.Count > 0)
{
Title_Creator o = list[0];
list = null;
return(o);
}
else
{
return(null);
}
}
}
}
/// <summary>
/// Update values in Title_Creator. Returns an object of type Title_Creator.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type Title_Creator.</param>
/// <returns>Object of type Title_Creator.</returns>
public Title_Creator Title_CreatorUpdateAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
Title_Creator value)
{
return Title_CreatorUpdateAuto(sqlConnection, sqlTransaction,
value.Title_CreatorID,
value.TitleID,
value.CreatorID,
value.CreatorRoleTypeID,
value.LastModifiedUserID);
}
/// <summary>
/// Manage Title_Creator object.
/// If the object is of type CustomObjectBase,
/// then either insert values into, delete values from, or update values in Title_Creator.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type Title_Creator.</param>
/// <returns>Object of type CustomDataAccessStatus<Title_Creator>.</returns>
public CustomDataAccessStatus<Title_Creator> Title_CreatorManageAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
Title_Creator value , int userId)
{
if (value.IsNew && !value.IsDeleted)
{
value.CreationUserID = userId;
value.LastModifiedUserID = userId;
Title_Creator returnValue = Title_CreatorInsertAuto(sqlConnection, sqlTransaction,
value.TitleID,
value.CreatorID,
value.CreatorRoleTypeID,
value.CreationUserID,
value.LastModifiedUserID);
return new CustomDataAccessStatus<Title_Creator>(
CustomDataAccessContext.Insert,
true, returnValue);
}
else if (!value.IsNew && value.IsDeleted)
{
if (Title_CreatorDeleteAuto(sqlConnection, sqlTransaction,
value.Title_CreatorID))
{
return new CustomDataAccessStatus<Title_Creator>(
CustomDataAccessContext.Delete,
true, value);
}
else
{
return new CustomDataAccessStatus<Title_Creator>(
CustomDataAccessContext.Delete,
false, value);
}
}
else if (value.IsDirty && !value.IsDeleted)
{
value.LastModifiedUserID = userId;
Title_Creator returnValue = Title_CreatorUpdateAuto(sqlConnection, sqlTransaction,
value.Title_CreatorID,
value.TitleID,
value.CreatorID,
value.CreatorRoleTypeID,
value.LastModifiedUserID);
return new CustomDataAccessStatus<Title_Creator>(
CustomDataAccessContext.Update,
true, returnValue);
}
else
{
return new CustomDataAccessStatus<Title_Creator>(
CustomDataAccessContext.NA,
false, value);
}
}