/// <summary>
/// Select values from IndicatedPage by primary key(s).
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="pageID">Unique identifier for each Page record.</param>
/// <param name="sequence">A number to separately identify various series of Indicated Pages.</param>
/// <returns>Object of type IndicatedPage.</returns>
public IndicatedPage IndicatedPageSelectAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
int pageID,
short sequence)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection);
SqlTransaction transaction = sqlTransaction;
using (SqlCommand command = CustomSqlHelper.CreateCommand("IndicatedPageSelectAuto", connection, transaction,
CustomSqlHelper.CreateInputParameter("PageID", SqlDbType.Int, null, false, pageID),
CustomSqlHelper.CreateInputParameter("Sequence", SqlDbType.SmallInt, null, false, sequence)))
{
using (CustomSqlHelper <IndicatedPage> helper = new CustomSqlHelper <IndicatedPage>())
{
CustomGenericList <IndicatedPage> list = helper.ExecuteReader(command);
if (list.Count > 0)
{
IndicatedPage o = list[0];
list = null;
return(o);
}
else
{
return(null);
}
}
}
}
/// <summary>
/// Update values in IndicatedPage. Returns an object of type IndicatedPage.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type IndicatedPage.</param>
/// <returns>Object of type IndicatedPage.</returns>
public IndicatedPage IndicatedPageUpdateAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
IndicatedPage value)
{
return(IndicatedPageUpdateAuto(sqlConnection, sqlTransaction,
value.PageID,
value.Sequence,
value.PagePrefix,
value.PageNumber,
value.Implied,
value.LastModifiedUserID));
}
/// <summary>
/// Insert values into IndicatedPage.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="pageID">Unique identifier for each Page record.</param>
/// <param name="sequence">A number to separately identify various series of Indicated Pages.</param>
/// <param name="pagePrefix">Prefix portion of Indicated Page.</param>
/// <param name="pageNumber">Page Number portion of Indicated Page.</param>
/// <param name="implied"></param>
/// <param name="creationUserID"></param>
/// <param name="lastModifiedUserID"></param>
/// <returns>Object of type IndicatedPage.</returns>
public IndicatedPage IndicatedPageInsertAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
int pageID,
short sequence,
string pagePrefix,
string pageNumber,
bool implied,
int?creationUserID,
int?lastModifiedUserID)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection);
SqlTransaction transaction = sqlTransaction;
using (SqlCommand command = CustomSqlHelper.CreateCommand("IndicatedPageInsertAuto", connection, transaction,
CustomSqlHelper.CreateInputParameter("PageID", SqlDbType.Int, null, false, pageID),
CustomSqlHelper.CreateInputParameter("Sequence", SqlDbType.SmallInt, null, false, sequence),
CustomSqlHelper.CreateInputParameter("PagePrefix", SqlDbType.NVarChar, 20, true, pagePrefix),
CustomSqlHelper.CreateInputParameter("PageNumber", SqlDbType.NVarChar, 20, true, pageNumber),
CustomSqlHelper.CreateInputParameter("Implied", SqlDbType.Bit, null, false, implied),
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 <IndicatedPage> helper = new CustomSqlHelper <IndicatedPage>())
{
CustomGenericList <IndicatedPage> list = helper.ExecuteReader(command);
if (list.Count > 0)
{
IndicatedPage o = list[0];
list = null;
return(o);
}
else
{
return(null);
}
}
}
}
/// <summary>
/// Manage IndicatedPage object.
/// If the object is of type CustomObjectBase,
/// then either insert values into, delete values from, or update values in IndicatedPage.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type IndicatedPage.</param>
/// <returns>Object of type CustomDataAccessStatus<IndicatedPage>.</returns>
public CustomDataAccessStatus <IndicatedPage> IndicatedPageManageAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
IndicatedPage value, int userId)
{
if (value.IsNew && !value.IsDeleted)
{
value.CreationUserID = userId;
value.LastModifiedUserID = userId;
IndicatedPage returnValue = IndicatedPageInsertAuto(sqlConnection, sqlTransaction,
value.PageID,
value.Sequence,
value.PagePrefix,
value.PageNumber,
value.Implied,
value.CreationUserID,
value.LastModifiedUserID);
return(new CustomDataAccessStatus <IndicatedPage>(
CustomDataAccessContext.Insert,
true, returnValue));
}
else if (!value.IsNew && value.IsDeleted)
{
if (IndicatedPageDeleteAuto(sqlConnection, sqlTransaction,
value.PageID,
value.Sequence))
{
return(new CustomDataAccessStatus <IndicatedPage>(
CustomDataAccessContext.Delete,
true, value));
}
else
{
return(new CustomDataAccessStatus <IndicatedPage>(
CustomDataAccessContext.Delete,
false, value));
}
}
else if (value.IsDirty && !value.IsDeleted)
{
value.LastModifiedUserID = userId;
IndicatedPage returnValue = IndicatedPageUpdateAuto(sqlConnection, sqlTransaction,
value.PageID,
value.Sequence,
value.PagePrefix,
value.PageNumber,
value.Implied,
value.LastModifiedUserID);
return(new CustomDataAccessStatus <IndicatedPage>(
CustomDataAccessContext.Update,
true, returnValue));
}
else
{
return(new CustomDataAccessStatus <IndicatedPage>(
CustomDataAccessContext.NA,
false, value));
}
}
/// <summary>
/// Update values in IndicatedPage. Returns an object of type IndicatedPage.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type IndicatedPage.</param>
/// <returns>Object of type IndicatedPage.</returns>
public IndicatedPage IndicatedPageUpdateAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
IndicatedPage value)
{
return IndicatedPageUpdateAuto(sqlConnection, sqlTransaction,
value.PageID,
value.Sequence,
value.PagePrefix,
value.PageNumber,
value.Implied,
value.LastModifiedUserID);
}
/// <summary>
/// Manage IndicatedPage object.
/// If the object is of type CustomObjectBase,
/// then either insert values into, delete values from, or update values in IndicatedPage.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type IndicatedPage.</param>
/// <returns>Object of type CustomDataAccessStatus<IndicatedPage>.</returns>
public CustomDataAccessStatus<IndicatedPage> IndicatedPageManageAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
IndicatedPage value , int userId)
{
if (value.IsNew && !value.IsDeleted)
{
value.CreationUserID = userId;
value.LastModifiedUserID = userId;
IndicatedPage returnValue = IndicatedPageInsertAuto(sqlConnection, sqlTransaction,
value.PageID,
value.Sequence,
value.PagePrefix,
value.PageNumber,
value.Implied,
value.CreationUserID,
value.LastModifiedUserID);
return new CustomDataAccessStatus<IndicatedPage>(
CustomDataAccessContext.Insert,
true, returnValue);
}
else if (!value.IsNew && value.IsDeleted)
{
if (IndicatedPageDeleteAuto(sqlConnection, sqlTransaction,
value.PageID,
value.Sequence))
{
return new CustomDataAccessStatus<IndicatedPage>(
CustomDataAccessContext.Delete,
true, value);
}
else
{
return new CustomDataAccessStatus<IndicatedPage>(
CustomDataAccessContext.Delete,
false, value);
}
}
else if (value.IsDirty && !value.IsDeleted)
{
value.LastModifiedUserID = userId;
IndicatedPage returnValue = IndicatedPageUpdateAuto(sqlConnection, sqlTransaction,
value.PageID,
value.Sequence,
value.PagePrefix,
value.PageNumber,
value.Implied,
value.LastModifiedUserID);
return new CustomDataAccessStatus<IndicatedPage>(
CustomDataAccessContext.Update,
true, returnValue);
}
else
{
return new CustomDataAccessStatus<IndicatedPage>(
CustomDataAccessContext.NA,
false, value);
}
}
