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