/// <summary> /// Delete values from PageType by primary key(s). /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="pageTypeID">Unique identifier for each Page Type record.</param> /// <returns>true if successful otherwise false.</returns> public bool PageTypeDeleteAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, int pageTypeID) { SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection); SqlTransaction transaction = sqlTransaction; using (SqlCommand command = CustomSqlHelper.CreateCommand("PageTypeDeleteAuto", connection, transaction, CustomSqlHelper.CreateInputParameter("PageTypeID", SqlDbType.Int, null, false, pageTypeID), CustomSqlHelper.CreateReturnValueParameter("ReturnCode", SqlDbType.Int, null, false))) { int returnCode = CustomSqlHelper.ExecuteNonQuery(command, "ReturnCode"); if (transaction == null) { CustomSqlHelper.CloseConnection(connection); } if (returnCode == 0) { return(true); } else { return(false); } } }
public bool IndicatedPageDeleteAllForPage(SqlConnection sqlConnection, SqlTransaction sqlTransaction, int pageID) { SqlConnection connection = CustomSqlHelper.CreateConnection( CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection); SqlTransaction transaction = sqlTransaction; try { using (SqlCommand command = CustomSqlHelper.CreateCommand("IndicatedPageDeleteAllForPage", connection, sqlTransaction, CustomSqlHelper.CreateInputParameter("PageID", SqlDbType.Int, null, false, pageID), CustomSqlHelper.CreateReturnValueParameter("ReturnCode", SqlDbType.Int, null, false))) { int returnCode = CustomSqlHelper.ExecuteNonQuery(command, "ReturnCode"); if (transaction == null) { CustomSqlHelper.CloseConnection(connection); } if (returnCode == 0) { return(true); } else { return(false); } } } catch (Exception ex) { throw new Exception("Exception in IndicatedPageDeleteAllForPage", ex); } }
public bool IndicatedPageInsertNext(SqlConnection sqlConnection, SqlTransaction sqlTransaction, int pageID, string pagePrefix, string pageNumber, bool implied, int userId) { SqlConnection connection = CustomSqlHelper.CreateConnection( CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection); SqlTransaction transaction = sqlTransaction; using (SqlCommand command = CustomSqlHelper.CreateCommand("IndicatedPageInsertNext", connection, transaction, CustomSqlHelper.CreateInputParameter("PageID", SqlDbType.Int, null, false, pageID), 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, false, userId), CustomSqlHelper.CreateInputParameter("LastModifiedUserID", SqlDbType.Int, null, false, userId), CustomSqlHelper.CreateReturnValueParameter("ReturnCode", SqlDbType.Int, null, false))) { int returnCode = CustomSqlHelper.ExecuteNonQuery(command, "ReturnCode"); if (transaction == null) { CustomSqlHelper.CloseConnection(connection); } if (returnCode == 0) { return(true); } else { return(false); } } }
/// <summary> /// Delete values from Title_TitleIdentifier 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="title_TitleIdentifierID"></param> /// <returns>true if successful otherwise false.</returns> public bool Title_TitleIdentifierDeleteAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, int title_TitleIdentifierID) { SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings(connectionKeyName), sqlConnection); SqlTransaction transaction = sqlTransaction; using (SqlCommand command = CustomSqlHelper.CreateCommand("Title_TitleIdentifierDeleteAuto", connection, transaction, CustomSqlHelper.CreateInputParameter("Title_TitleIdentifierID", SqlDbType.Int, null, false, title_TitleIdentifierID), CustomSqlHelper.CreateReturnValueParameter("ReturnCode", SqlDbType.Int, null, false))) { int returnCode = CustomSqlHelper.ExecuteNonQuery(command, "ReturnCode"); if (transaction == null) { CustomSqlHelper.CloseConnection(connection); } if (returnCode == 0) { return(true); } else { return(false); } } }
public void MarcUpdateStatusError( SqlConnection sqlConnection, SqlTransaction sqlTransaction, int marcID) { SqlConnection connection = CustomSqlHelper.CreateConnection( CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection); SqlTransaction transaction = sqlTransaction; using (SqlCommand command = CustomSqlHelper.CreateCommand("MarcUpdateStatusError", connection, transaction, CustomSqlHelper.CreateInputParameter("MarcID", SqlDbType.Int, null, false, marcID))) { CustomSqlHelper.ExecuteNonQuery(command); } }
/// <summary> /// Delete values from MonthlyStats 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="year"></param> /// <param name="month"></param> /// <param name="institutionName"></param> /// <param name="statType"></param> /// <returns>true if successful otherwise false.</returns> public bool MonthlyStatsDeleteAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, int year, int month, string institutionName, string statType) { SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings(connectionKeyName), sqlConnection); SqlTransaction transaction = sqlTransaction; using (SqlCommand command = CustomSqlHelper.CreateCommand("MonthlyStatsDeleteAuto", connection, transaction, CustomSqlHelper.CreateInputParameter("Year", SqlDbType.Int, null, false, year), CustomSqlHelper.CreateInputParameter("Month", SqlDbType.Int, null, false, month), CustomSqlHelper.CreateInputParameter("InstitutionName", SqlDbType.NVarChar, 255, false, institutionName), CustomSqlHelper.CreateInputParameter("StatType", SqlDbType.NVarChar, 100, false, statType), CustomSqlHelper.CreateReturnValueParameter("ReturnCode", SqlDbType.Int, null, false))) { int returnCode = CustomSqlHelper.ExecuteNonQuery(command, "ReturnCode"); if (transaction == null) { CustomSqlHelper.CloseConnection(connection); } if (returnCode == 0) { return(true); } else { return(false); } } }