/// <exception cref="ConfigurationErrorsException">A configuration file could not be loaded.</exception>
/// <exception cref="ArgumentNullException"><paramref>
/// <name>key</name>
/// </paramref>
/// is null. </exception>
/// <exception cref="NotSupportedException">The property is set and the <see cref="T:System.Collections.Hashtable" />
/// is read-only.-or- The property is set, <paramref>
/// <name>key</name>
/// </paramref>
/// does not exist in the collection, and the
/// <see cref="T:System.Collections.Hashtable" /> has a fixed size. </exception>
public static void BulkUpdateTariffNumbers(string[] tariffNumbers, string[] contractNumbers)
{
var procName = ConfigUtil.GetStoredProcedureName("TRC_GSD2_BULKUPDATE");
var oracleParams = new OracleParameter[2];
oracleParams[0] = new OracleParameter("i_ctr_no", OracleDbType.Varchar2, ParameterDirection.Input)
{
Value = contractNumbers
};
oracleParams[1] = new OracleParameter("i_tariff_no", OracleDbType.Varchar2, ParameterDirection.Input)
{
Value = tariffNumbers
};
OracleUtil.ExecuteOracleBatchAction(procName, oracleParams, CommandType.StoredProcedure, tariffNumbers.Length);
}
/// <exception cref="ConfigurationErrorsException">A configuration file could not be loaded.</exception>
/// <exception cref="ArgumentNullException"><paramref>
/// <name>key</name>
/// </paramref>
/// is null. </exception>
/// <exception cref="NotSupportedException">The property is set and the <see cref="T:System.Collections.Hashtable" />
/// is read-only.-or- The property is set, <paramref>
/// <name>key</name>
/// </paramref>
/// does not exist in the collection, and the
/// <see cref="T:System.Collections.Hashtable" /> has a fixed size. </exception>
public static void BulkInsertGSD2TariffData(string[] tariffNumbers, string[] contractNumbers, string[] fileNames)
{
var procName = ConfigUtil.GetStoredProcedureName("TRC_GSD2_BULKINSERT");
var oracleParams = new OracleParameter[3];
oracleParams[0] = new OracleParameter("i_tariff_no", OracleDbType.Varchar2, ParameterDirection.Input)
{
Value = tariffNumbers
};
oracleParams[1] = new OracleParameter("i_ctr_no", OracleDbType.Varchar2, ParameterDirection.Input)
{
Value = contractNumbers
};
oracleParams[2] = new OracleParameter("i_file_name", OracleDbType.Varchar2, ParameterDirection.Input)
{
Value = fileNames
};
OracleUtil.ExecuteOracleBatchAction(procName, oracleParams, CommandType.StoredProcedure, tariffNumbers.Length);
}