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