/// <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); }