/// <summary>
/// @param P_Date
/// </summary>
/// <param name="P_Date">date</param>
/// <param name="P_ID">id</param>
/// <param name="P_Number">Number</param>
/// <param name="P_Msg">msg</param>
public void AddLog(DateTime P_Date, int P_ID, Decimal P_Number, String msg)
{
MPInstanceLog logEntry = new MPInstanceLog(GetAD_PInstance_ID(), _log.Count + 1,
P_Date, P_ID, P_Number, msg);
_log.Add(logEntry);
// save it to DB ?
// log.save();
}
/// <summary>
/// Get Logs
/// </summary>
/// <returns>array of logs</returns>
public MPInstanceLog[] GetLog()
{
// load it from DB
_log.Clear();
String sql = "SELECT * FROM AD_PInstance_Log WHERE AD_PInstance_ID=" + GetAD_PInstance_ID() + " ORDER BY Log_ID";
DataTable dt = null;
IDataReader idr = null;
try
{
idr = DataBase.DB.ExecuteReader(sql, null, null);
dt = new DataTable();
dt.Load(idr);
idr.Close();
foreach (DataRow dr in dt.Rows)
{
_log.Add(new MPInstanceLog(dr));
}
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
log.Log(Level.SEVERE, sql, e);
}
finally
{
if (idr != null)
{
idr.Close();
}
dt = null;
}
MPInstanceLog[] retValue = new MPInstanceLog[_log.Count];
retValue = _log.ToArray();
return(retValue);
}
