public void Page_PageTypeSave(int[] pageIDs, int pageTypeID, int userID) { TransactionController transactionController = new TransactionController(); try { transactionController.BeginTransaction(); int index = 0; Page_PageType ppt = new Page_PageType(); ppt.PageTypeID = pageTypeID; ppt.Verified = true; for (index = 0; index < pageIDs.Length; index++) { ppt.PageID = pageIDs[index]; this.Page_PageTypeSave(ppt, userID, transactionController); } transactionController.CommitTransaction(); } catch { transactionController.RollbackTransaction(); } finally { transactionController.Dispose(); } }
/// <summary> /// Select values from Page_PageType 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="pageTypeID">Unique identifier for each Page Type record.</param> /// <returns>Object of type Page_PageType.</returns> public Page_PageType Page_PageTypeSelectAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, int pageID, int pageTypeID) { SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection); SqlTransaction transaction = sqlTransaction; using (SqlCommand command = CustomSqlHelper.CreateCommand("Page_PageTypeSelectAuto", connection, transaction, CustomSqlHelper.CreateInputParameter("PageID", SqlDbType.Int, null, false, pageID), CustomSqlHelper.CreateInputParameter("PageTypeID", SqlDbType.Int, null, false, pageTypeID))) { using (CustomSqlHelper <Page_PageType> helper = new CustomSqlHelper <Page_PageType>()) { CustomGenericList <Page_PageType> list = helper.ExecuteReader(command); if (list.Count > 0) { Page_PageType o = list[0]; list = null; return(o); } else { return(null); } } } }
/// <summary> /// Update values in Page_PageType. Returns an object of type Page_PageType. /// </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="pageTypeID">Unique identifier for each Page Type record.</param> /// <param name="verified"></param> /// <param name="lastModifiedUserID"></param> /// <returns>Object of type Page_PageType.</returns> public Page_PageType Page_PageTypeUpdateAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, int pageID, int pageTypeID, bool verified, int?lastModifiedUserID) { SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection); SqlTransaction transaction = sqlTransaction; using (SqlCommand command = CustomSqlHelper.CreateCommand("Page_PageTypeUpdateAuto", connection, transaction, CustomSqlHelper.CreateInputParameter("PageID", SqlDbType.Int, null, false, pageID), CustomSqlHelper.CreateInputParameter("PageTypeID", SqlDbType.Int, null, false, pageTypeID), CustomSqlHelper.CreateInputParameter("Verified", SqlDbType.Bit, null, false, verified), CustomSqlHelper.CreateInputParameter("LastModifiedUserID", SqlDbType.Int, null, true, lastModifiedUserID), CustomSqlHelper.CreateReturnValueParameter("ReturnCode", SqlDbType.Int, null, false))) { using (CustomSqlHelper <Page_PageType> helper = new CustomSqlHelper <Page_PageType>()) { CustomGenericList <Page_PageType> list = helper.ExecuteReader(command); if (list.Count > 0) { Page_PageType o = list[0]; list = null; return(o); } else { return(null); } } } }
public void Page_PageTypeSave( int[] pageIDs, int pageTypeID, int userID ) { TransactionController transactionController = new TransactionController(); try { transactionController.BeginTransaction(); int index = 0; Page_PageType ppt = new Page_PageType(); ppt.PageTypeID = pageTypeID; ppt.Verified = true; for ( index = 0; index < pageIDs.Length; index++ ) { ppt.PageID = pageIDs[ index ]; this.Page_PageTypeSave( ppt, userID, transactionController ); } transactionController.CommitTransaction(); } catch { transactionController.RollbackTransaction(); } finally { transactionController.Dispose(); } }
/// <summary> /// Manage Page_PageType object. /// If the object is of type CustomObjectBase, /// then either insert values into, delete values from, or update values in Page_PageType. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="value">Object of type Page_PageType.</param> /// <returns>Object of type CustomDataAccessStatus<Page_PageType>.</returns> public CustomDataAccessStatus <Page_PageType> Page_PageTypeManageAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, Page_PageType value, int userId) { if (value.IsNew && !value.IsDeleted) { value.CreationUserID = userId; value.LastModifiedUserID = userId; Page_PageType returnValue = Page_PageTypeInsertAuto(sqlConnection, sqlTransaction, value.PageID, value.PageTypeID, value.Verified, value.CreationUserID, value.LastModifiedUserID); return(new CustomDataAccessStatus <Page_PageType>( CustomDataAccessContext.Insert, true, returnValue)); } else if (!value.IsNew && value.IsDeleted) { if (Page_PageTypeDeleteAuto(sqlConnection, sqlTransaction, value.PageID, value.PageTypeID)) { return(new CustomDataAccessStatus <Page_PageType>( CustomDataAccessContext.Delete, true, value)); } else { return(new CustomDataAccessStatus <Page_PageType>( CustomDataAccessContext.Delete, false, value)); } } else if (value.IsDirty && !value.IsDeleted) { value.LastModifiedUserID = userId; Page_PageType returnValue = Page_PageTypeUpdateAuto(sqlConnection, sqlTransaction, value.PageID, value.PageTypeID, value.Verified, value.LastModifiedUserID); return(new CustomDataAccessStatus <Page_PageType>( CustomDataAccessContext.Update, true, returnValue)); } else { return(new CustomDataAccessStatus <Page_PageType>( CustomDataAccessContext.NA, false, value)); } }
/// <summary> /// Update values in Page_PageType. Returns an object of type Page_PageType. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="value">Object of type Page_PageType.</param> /// <returns>Object of type Page_PageType.</returns> public Page_PageType Page_PageTypeUpdateAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, Page_PageType value) { return(Page_PageTypeUpdateAuto(sqlConnection, sqlTransaction, value.PageID, value.PageTypeID, value.Verified, value.LastModifiedUserID)); }
public void Page_PageTypeSave(SqlConnection sqlConnection, SqlTransaction sqlTransaction, Page_PageType value, int userId) { Page_PageType ppt = this.Page_PageTypeSelectAuto( sqlConnection, sqlTransaction, value.PageID, value.PageTypeID ); if ( ppt != null ) { ppt.Verified = true; ppt.LastModifiedUserID = userId; this.Page_PageTypeUpdateAuto( sqlConnection, sqlTransaction, ppt ); } else { value.LastModifiedUserID = userId; value.CreationUserID = userId; this.Page_PageTypeInsertAuto( sqlConnection, sqlTransaction, value ); } }
public void Page_PageTypeSave(SqlConnection sqlConnection, SqlTransaction sqlTransaction, Page_PageType value, int userId) { Page_PageType ppt = this.Page_PageTypeSelectAuto(sqlConnection, sqlTransaction, value.PageID, value.PageTypeID); if (ppt != null) { ppt.Verified = true; ppt.LastModifiedUserID = userId; this.Page_PageTypeUpdateAuto(sqlConnection, sqlTransaction, ppt); } else { value.LastModifiedUserID = userId; value.CreationUserID = userId; this.Page_PageTypeInsertAuto(sqlConnection, sqlTransaction, value); } }
private void Page_PageTypeSave(Page_PageType value, int userID, TransactionController transactionController) { GetPage_PageTypeDalInstance().Page_PageTypeSave(transactionController.Connection, transactionController.Transaction, value, userID); PageSetPaginationInfo(value.PageID, userID, transactionController); }
private void Page_PageTypeSave( Page_PageType value, int userID, TransactionController transactionController ) { GetPage_PageTypeDalInstance().Page_PageTypeSave( transactionController.Connection, transactionController.Transaction, value, userID ); PageSetPaginationInfo( value.PageID, userID, transactionController ); }
/// <summary> /// Update values in Page_PageType. Returns an object of type Page_PageType. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="value">Object of type Page_PageType.</param> /// <returns>Object of type Page_PageType.</returns> public Page_PageType Page_PageTypeUpdateAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, Page_PageType value) { return Page_PageTypeUpdateAuto(sqlConnection, sqlTransaction, value.PageID, value.PageTypeID, value.Verified, value.LastModifiedUserID); }
/// <summary> /// Manage Page_PageType object. /// If the object is of type CustomObjectBase, /// then either insert values into, delete values from, or update values in Page_PageType. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="value">Object of type Page_PageType.</param> /// <returns>Object of type CustomDataAccessStatus<Page_PageType>.</returns> public CustomDataAccessStatus<Page_PageType> Page_PageTypeManageAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, Page_PageType value , int userId) { if (value.IsNew && !value.IsDeleted) { value.CreationUserID = userId; value.LastModifiedUserID = userId; Page_PageType returnValue = Page_PageTypeInsertAuto(sqlConnection, sqlTransaction, value.PageID, value.PageTypeID, value.Verified, value.CreationUserID, value.LastModifiedUserID); return new CustomDataAccessStatus<Page_PageType>( CustomDataAccessContext.Insert, true, returnValue); } else if (!value.IsNew && value.IsDeleted) { if (Page_PageTypeDeleteAuto(sqlConnection, sqlTransaction, value.PageID, value.PageTypeID)) { return new CustomDataAccessStatus<Page_PageType>( CustomDataAccessContext.Delete, true, value); } else { return new CustomDataAccessStatus<Page_PageType>( CustomDataAccessContext.Delete, false, value); } } else if (value.IsDirty && !value.IsDeleted) { value.LastModifiedUserID = userId; Page_PageType returnValue = Page_PageTypeUpdateAuto(sqlConnection, sqlTransaction, value.PageID, value.PageTypeID, value.Verified, value.LastModifiedUserID); return new CustomDataAccessStatus<Page_PageType>( CustomDataAccessContext.Update, true, returnValue); } else { return new CustomDataAccessStatus<Page_PageType>( CustomDataAccessContext.NA, false, value); } }