/// <summary>
/// Select values from MarcControl 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="marcControlID"></param>
/// <returns>Object of type MarcControl.</returns>
public MarcControl MarcControlSelectAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
string connectionKeyName,
int marcControlID)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings(connectionKeyName), sqlConnection);
SqlTransaction transaction = sqlTransaction;
using (SqlCommand command = CustomSqlHelper.CreateCommand("MarcControlSelectAuto", connection, transaction,
CustomSqlHelper.CreateInputParameter("MarcControlID", SqlDbType.Int, null, false, marcControlID)))
{
using (CustomSqlHelper <MarcControl> helper = new CustomSqlHelper <MarcControl>())
{
CustomGenericList <MarcControl> list = helper.ExecuteReader(command);
if (list.Count > 0)
{
MarcControl o = list[0];
list = null;
return(o);
}
else
{
return(null);
}
}
}
}
/// <summary>
/// Manage MarcControl object.
/// If the object is of type CustomObjectBase,
/// then either insert values into, delete values from, or update values in MarcControl.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type MarcControl.</param>
/// <returns>Object of type CustomDataAccessStatus<MarcControl>.</returns>
public CustomDataAccessStatus <MarcControl> MarcControlManageAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
MarcControl value)
{
return(MarcControlManageAuto(sqlConnection, sqlTransaction, "BHL", value));
}
/// <summary>
/// Update values in MarcControl. Returns an object of type MarcControl.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type MarcControl.</param>
/// <returns>Object of type MarcControl.</returns>
public MarcControl MarcControlUpdateAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
MarcControl value)
{
return(MarcControlUpdateAuto(sqlConnection, sqlTransaction, "BHL", value));
}
/// <summary>
/// Update values in MarcControl. Returns an object of type MarcControl.
/// </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="marcControlID"></param>
/// <param name="marcID"></param>
/// <param name="tag"></param>
/// <param name="value"></param>
/// <returns>Object of type MarcControl.</returns>
public MarcControl MarcControlUpdateAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
string connectionKeyName,
int marcControlID,
int marcID,
string tag,
string value)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings(connectionKeyName), sqlConnection);
SqlTransaction transaction = sqlTransaction;
using (SqlCommand command = CustomSqlHelper.CreateCommand("MarcControlUpdateAuto", connection, transaction,
CustomSqlHelper.CreateInputParameter("MarcControlID", SqlDbType.Int, null, false, marcControlID),
CustomSqlHelper.CreateInputParameter("MarcID", SqlDbType.Int, null, false, marcID),
CustomSqlHelper.CreateInputParameter("Tag", SqlDbType.NChar, 3, false, tag),
CustomSqlHelper.CreateInputParameter("Value", SqlDbType.NVarChar, 200, false, value),
CustomSqlHelper.CreateReturnValueParameter("ReturnCode", SqlDbType.Int, null, false)))
{
using (CustomSqlHelper <MarcControl> helper = new CustomSqlHelper <MarcControl>())
{
CustomGenericList <MarcControl> list = helper.ExecuteReader(command);
if (list.Count > 0)
{
MarcControl o = list[0];
list = null;
return(o);
}
else
{
return(null);
}
}
}
}
/// <summary>
/// Insert values into MarcControl. Returns an object of type MarcControl.
/// </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 MarcControl.</param>
/// <returns>Object of type MarcControl.</returns>
public MarcControl MarcControlInsertAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
string connectionKeyName,
MarcControl value)
{
return(MarcControlInsertAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.MarcID,
value.Tag,
value.Value));
}
/// <summary>
/// Manage MarcControl object.
/// If the object is of type CustomObjectBase,
/// then either insert values into, delete values from, or update values in MarcControl.
/// </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 MarcControl.</param>
/// <returns>Object of type CustomDataAccessStatus<MarcControl>.</returns>
public CustomDataAccessStatus <MarcControl> MarcControlManageAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
string connectionKeyName,
MarcControl value)
{
if (value.IsNew && !value.IsDeleted)
{
MarcControl returnValue = MarcControlInsertAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.MarcID,
value.Tag,
value.Value);
return(new CustomDataAccessStatus <MarcControl>(
CustomDataAccessContext.Insert,
true, returnValue));
}
else if (!value.IsNew && value.IsDeleted)
{
if (MarcControlDeleteAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.MarcControlID))
{
return(new CustomDataAccessStatus <MarcControl>(
CustomDataAccessContext.Delete,
true, value));
}
else
{
return(new CustomDataAccessStatus <MarcControl>(
CustomDataAccessContext.Delete,
false, value));
}
}
else if (value.IsDirty && !value.IsDeleted)
{
MarcControl returnValue = MarcControlUpdateAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.MarcControlID,
value.MarcID,
value.Tag,
value.Value);
return(new CustomDataAccessStatus <MarcControl>(
CustomDataAccessContext.Update,
true, returnValue));
}
else
{
return(new CustomDataAccessStatus <MarcControl>(
CustomDataAccessContext.NA,
false, value));
}
}
/// <summary>
/// Update values in MarcControl. Returns an object of type MarcControl.
/// </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 MarcControl.</param>
/// <returns>Object of type MarcControl.</returns>
public MarcControl MarcControlUpdateAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
string connectionKeyName,
MarcControl value)
{
return MarcControlUpdateAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.MarcControlID,
value.MarcID,
value.Tag,
value.Value);
}
/// <summary>
/// Update values in MarcControl. Returns an object of type MarcControl.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type MarcControl.</param>
/// <returns>Object of type MarcControl.</returns>
public MarcControl MarcControlUpdateAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
MarcControl value)
{
return MarcControlUpdateAuto(sqlConnection, sqlTransaction, "BHL", value );
}
/// <summary>
/// Manage MarcControl object.
/// If the object is of type CustomObjectBase,
/// then either insert values into, delete values from, or update values in MarcControl.
/// </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 MarcControl.</param>
/// <returns>Object of type CustomDataAccessStatus<MarcControl>.</returns>
public CustomDataAccessStatus<MarcControl> MarcControlManageAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
string connectionKeyName,
MarcControl value)
{
if (value.IsNew && !value.IsDeleted)
{
MarcControl returnValue = MarcControlInsertAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.MarcID,
value.Tag,
value.Value);
return new CustomDataAccessStatus<MarcControl>(
CustomDataAccessContext.Insert,
true, returnValue);
}
else if (!value.IsNew && value.IsDeleted)
{
if (MarcControlDeleteAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.MarcControlID))
{
return new CustomDataAccessStatus<MarcControl>(
CustomDataAccessContext.Delete,
true, value);
}
else
{
return new CustomDataAccessStatus<MarcControl>(
CustomDataAccessContext.Delete,
false, value);
}
}
else if (value.IsDirty && !value.IsDeleted)
{
MarcControl returnValue = MarcControlUpdateAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.MarcControlID,
value.MarcID,
value.Tag,
value.Value);
return new CustomDataAccessStatus<MarcControl>(
CustomDataAccessContext.Update,
true, returnValue);
}
else
{
return new CustomDataAccessStatus<MarcControl>(
CustomDataAccessContext.NA,
false, value);
}
}
/// <summary>
/// Manage MarcControl object.
/// If the object is of type CustomObjectBase,
/// then either insert values into, delete values from, or update values in MarcControl.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type MarcControl.</param>
/// <returns>Object of type CustomDataAccessStatus<MarcControl>.</returns>
public CustomDataAccessStatus<MarcControl> MarcControlManageAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
MarcControl value)
{
return MarcControlManageAuto( sqlConnection, sqlTransaction, "BHL", value );
}