/// <summary>
/// Select values from TitleLanguage 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="titleLanguageID"></param>
/// <returns>Object of type TitleLanguage.</returns>
public TitleLanguage TitleLanguageSelectAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
string connectionKeyName,
int titleLanguageID)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings(connectionKeyName), sqlConnection);
SqlTransaction transaction = sqlTransaction;
using (SqlCommand command = CustomSqlHelper.CreateCommand("TitleLanguageSelectAuto", connection, transaction,
CustomSqlHelper.CreateInputParameter("TitleLanguageID", SqlDbType.Int, null, false, titleLanguageID)))
{
using (CustomSqlHelper <TitleLanguage> helper = new CustomSqlHelper <TitleLanguage>())
{
CustomGenericList <TitleLanguage> list = helper.ExecuteReader(command);
if (list.Count > 0)
{
TitleLanguage o = list[0];
list = null;
return(o);
}
else
{
return(null);
}
}
}
}
/// <summary>
/// Manage TitleLanguage object.
/// If the object is of type CustomObjectBase,
/// then either insert values into, delete values from, or update values in TitleLanguage.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type TitleLanguage.</param>
/// <returns>Object of type CustomDataAccessStatus<TitleLanguage>.</returns>
public CustomDataAccessStatus <TitleLanguage> TitleLanguageManageAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
TitleLanguage value)
{
return(TitleLanguageManageAuto(sqlConnection, sqlTransaction, "BHL", value));
}
/// <summary>
/// Update values in TitleLanguage. Returns an object of type TitleLanguage.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type TitleLanguage.</param>
/// <returns>Object of type TitleLanguage.</returns>
public TitleLanguage TitleLanguageUpdateAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
TitleLanguage value)
{
return(TitleLanguageUpdateAuto(sqlConnection, sqlTransaction, "BHL", value));
}
/// <summary>
/// Insert values into TitleLanguage. Returns an object of type TitleLanguage.
/// </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 TitleLanguage.</param>
/// <returns>Object of type TitleLanguage.</returns>
public TitleLanguage TitleLanguageInsertAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
string connectionKeyName,
TitleLanguage value)
{
return(TitleLanguageInsertAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.TitleID,
value.LanguageCode));
}
public NacpDescription(BinaryReader reader, int index)
{
Language = (TitleLanguage)index;
long start = reader.BaseStream.Position;
Title = reader.ReadUtf8Z();
reader.BaseStream.Position = start + 0x200;
Developer = reader.ReadUtf8Z();
reader.BaseStream.Position = start + 0x300;
}
/// <summary>
/// Manage TitleLanguage object.
/// If the object is of type CustomObjectBase,
/// then either insert values into, delete values from, or update values in TitleLanguage.
/// </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 TitleLanguage.</param>
/// <returns>Object of type CustomDataAccessStatus<TitleLanguage>.</returns>
public CustomDataAccessStatus <TitleLanguage> TitleLanguageManageAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
string connectionKeyName,
TitleLanguage value)
{
if (value.IsNew && !value.IsDeleted)
{
TitleLanguage returnValue = TitleLanguageInsertAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.TitleID,
value.LanguageCode);
return(new CustomDataAccessStatus <TitleLanguage>(
CustomDataAccessContext.Insert,
true, returnValue));
}
else if (!value.IsNew && value.IsDeleted)
{
if (TitleLanguageDeleteAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.TitleLanguageID))
{
return(new CustomDataAccessStatus <TitleLanguage>(
CustomDataAccessContext.Delete,
true, value));
}
else
{
return(new CustomDataAccessStatus <TitleLanguage>(
CustomDataAccessContext.Delete,
false, value));
}
}
else if (value.IsDirty && !value.IsDeleted)
{
TitleLanguage returnValue = TitleLanguageUpdateAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.TitleLanguageID,
value.TitleID,
value.LanguageCode);
return(new CustomDataAccessStatus <TitleLanguage>(
CustomDataAccessContext.Update,
true, returnValue));
}
else
{
return(new CustomDataAccessStatus <TitleLanguage>(
CustomDataAccessContext.NA,
false, value));
}
}