public abstract OracleDataReader ExecuteDataReaderRefCur(string procname, ProcParam procParam, int indexRefCur);
public abstract object ExecuteScalar(ProcParam procParam);
public abstract OracleDataReader ExecuteDataReader(ProcParam procParam);
public abstract int ExecuteNonQuery(ProcParam procParam, List <ProcParam> procList, int keyHeader, int keyDetail);
public abstract int ExecuteNonQuery(ProcParam procParam, List <ProcParam> procList);
public abstract DataTable GetDataTable(ProcParam procParam, string tableName);
public abstract int ExecuteNonQuery(ProcParam procParam);
public abstract int ExecuteNonQuery(ProcParam paramHdr, ProcParam paramDtl1, int arrBindCount1, ProcParam paramDtl2, int arrBindCount2, ProcParam paramDtl3, int arrBindCount3, ProcParam paramDtl4, int arrBindCount4);
public abstract DataTable GetDataTable(ProcParam procParam);
public abstract int ExecuteNonQuery(ProcParam paramHdr, ProcParam paramDtl, int arrBindCount);
public abstract int ExecuteNonQuery(ProcParam paramDtl1, int arrBindCount1, ProcParam paramDtl2, int arrBindCount2);
//Just one to one! public abstract int ExecuteNonQuery(ProcParam paramHdr, int arrBindCountHdr, ProcParam paramDtl, int arrBindCountDtl, int keyHeader, int keyDetail);
//Improve Performance public abstract int ExecuteNonQuery(ProcParam procParam, int arrBindCount);
public abstract DataTable GetDataTable(ProcParam procParam, string tableName, long fetchsize);
public abstract DataTable GetDataTable(ProcParam procParam, long fetchsize);
public override int ExecuteNonQuery(ProcParam procParam, List <ProcParam> procList)
{
Stopwatch _stopwatch = null;
OracleCommand cmd = null;
int ret = 0;
try
{
this.executionStartTime = DateTime.Now;
_stopwatch = new Stopwatch();
base.BeginTransaction();
cmd = base._getCommand(procParam);
if (cmd != null)
{
_stopwatch.Start();
ret = cmd.ExecuteNonQuery();
_stopwatch.Stop();
if (procParam.IndexToCheck != -1)
{
string resultMessage = procParam.ReturnValue(procParam.IndexToCheck).ToString();
if (!procParam.MessageToCheck.Equals(resultMessage))
{
throw new Exception(resultMessage);
}
}
if (procList != null)
{
string resultMessage = string.Empty;
OracleCommand commandDetail;
foreach (ProcParam paramDetail in procList)
{
commandDetail = base._getCommand(paramDetail);
_stopwatch.Reset();
_stopwatch.Start();
ret = commandDetail.ExecuteNonQuery();
_stopwatch.Stop();
if (paramDetail.IndexToCheck != -1)
{
resultMessage = paramDetail.ReturnValue(paramDetail.IndexToCheck).ToString();
if (!paramDetail.MessageToCheck.Equals(resultMessage))
{
//Problem case
throw new Exception(resultMessage);
}
}
}
}
}
else
{
throw new MSDataLayerException("Command cannot be created since connection is not initialized.");
}
this.lastException = null;
base.CommitTransaction();
this.executionStopTime = DateTime.Now;
}
catch (MSDataLayerException tEx)
{
base.RollbackTransaction();
throw tEx;
}
catch (Exception ex)
{
base.RollbackTransaction();
ret = ODPDataAccess.ERROR_RESULT; this.lastException = ex;
}
finally
{
base.ExecuteTime = this.executionStopTime - this.executionStartTime;
_stopwatch = null;
cmd.Dispose();
cmd = null;
}
return(ret);
}
